Users can visit more than one ticket via link

Reviewed-By: Peter Rotich <peter@osticket.com>

orm: Fix issues surrounding MySQL commands OoS

Reviewed-By: Peter Rotich <peter@osticket.com>

Several places in the code initialize a list of objects from the database
and only fetch one item. In certain instances (which seem almost like a race
condition), MySQL will feel like there are more records available in the
database and will complain with "Commands out of sync, you can't run the
command now".

This patch addresses the issue by utilizing the ::one() method of the
QuerySet where only one record is expected. The ::one() method is further
designed to fetch all one results (which satisfies the MySQL client library)
and return the first item.

topics: Properly sort help topics on faq manage

Reviewed-By: Peter Rotich <peter@osticket.com>

i18n: Format time drop down via config time format

Peter Rotich <peter@osticket.com>

Fix dialog boxes on backward pjax navigation

Reviewed-By: Peter Rotich <peter@osticket.com>

Fix various XSS vulnerabilities

Reviewed-By: Peter Rotich <peter@osticket.com>

Use the admin-configured time format for formatting the values in the time
dropdown as opposed to always using 24-hour time.

Previously, they were displayed in seemingly random order, did not honor
proper nesting, or declared sort order.

pjax:complete is only called after an AJAX page load. If a user navigates
forward or backward and the page loads from local cache, then pjax:complete
is not fired. pjax:end, however, is always fired.

In both the client and staff interfaces, where the URL and request
parameters were echo'd back without any escaping

Account Manager Auto-assignment

References:
http://www.osticket.com/forum/discussion/77593/1-9-1-auto-assignment-to-the-account-manager



Reviewed-By: Jared Hancock <jared@osticket.com>

Auto assign tickets to organization's account manager only if the flag is set and as
the last resort i.e topic or filters assignment takes precedence.

Display external images and original links on thanks

Reviewed-By: Peter Rotich <peter@osticket.com>

Allow guests to sign out

Reviewed-By: Peter Rotich <peter@osticket.com>

Retire %{ticket.client_link}

Reviewed-By: Peter Rotich <peter@osticket.com>

Affected users should upgrade the token to %{recipient.ticket_link}

Previously, once a client was authenticated to the system with an email
link, the user could utilize other email links to other tickets; however,
the same ticket page would be presented to the user regardless of which link
was utilized.

This patch allows the ticket in focus for the user to be changed after
visiting the client portal with a different ticket link.

Otherwise, a user's session cannot be voluntarily destroyed

Previously, external images were mucked up and links were routed through
l.php, which requires a client sign in. If a client were not signed in when
creating a ticket. The links would not work correctly.

Fixes #980

Retire canned response append checkbox on ticket reply.

Reviewed-By: Jared Hancock <jared@osticket.com>

Help Topics improved

Reviewed-By: Peter Rotich <peter@osticket.com>

Correctly generate ticket_link for message confirm

Reviewed-By: Peter Rotich <peter@osticket.com>

dept: Allow saving of various alert recipient opts

Reviewed-By: Peter Rotich <peter@osticket.com>

As previously implemented, only "Department and group members" could be set

forms: Ensure the issue summary will have data

Reviewed-By: Peter Rotich <peter@osticket.com>