One of the things that annoyed me was that the email templates allow you to supply links to tickets when emailing users, but for staff, all you could do was link to /osticket/scp/index.php because the 'id' parameter for /scp/tickets.php takes the DB's row id for the ticket, not the ticket number. I modified the /scp/tickets.php to allow direct linking to tickets from staff emails.
NOTE: You need to modify the /scp/tickets.php, DO NOT modify the one in the base directory!
The only lines I changed in the attached file are lines 26-31. Everything else is untouched from the original.
To use this for your staff emails, open your email templates and go down to Staff New Ticket Alert. Here is the link that you would add to this template:
%url/scp/tickets.php?extid=%ticket
Now your staff can open tickets directly from email alerts! Hope this helps someone else.
[tickets.php.zip](https://forum.osticket.com/assets/files/migrated/c/8601f9c3debe62cf3bbb6a3c6662571.zip)