No. Seriously. Like from 11k seconds down to 0.3 for a full-text search on
several thousand tickets.

This patch makes the open and closed ticket counts on the client portal
relative to the help topic search. It also hides the counts when doing text
searches so that an extra count query isn't necessary.

So, fields with only the 'required' flag set for users are shown for the
registration page.

This greatly improves the performance collecting user and organization
ticket statistics.

The previous code would erroneously include ticket counts from the user's
organization even if the user did not have access to them.

Use `if not exists` in the create statement for the %cdata table so that, in
some race conditions, a MySQL slave would not be crashed because of an
already-existing table.

The previous code resulted in rebuilding the %thread_entry table several
times during the upgrade process. For systems will several hundred or
thousand megabytes of content in their system, this could result in a very
slow or crashed system.

This patch avoids multiple rebuilds of the table by simply creating a new
one and copying the correct values into the new table. It also avoids
possible duplicates when changing collaborators to the new thread system
considering that collaborators were not properly removed with tickets in
previous versions.

The previous logic required the Ticket::PERM_ASSIGN permission in order to
open a ticket. This logic requires that perm only if attempting to assign
the ticket on open.

Conflicts:
	WHATSNEW.md
	bootstrap.php
	include/ajax.users.php
	include/cli/modules/package.php
	include/client/tickets.inc.php
	include/staff/tickets.inc.php

sla: Capture current sla before setting new one

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

bug: Zombie tickets

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

v1.10 bug fixes and enhancements

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

Redirect to recent queue / listing on transfer or assign

Department/Topic create now considers the possibility of preset id (primary key)
Default help topic routing to floating system's default department

Queue sort template

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

bug: Task print

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

SendAlert expects an array as options param.

bug: Not every form has action attr.

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

Utilize the same template for tickets and tasks queues

If enabled globally. Also, keep the columns consistent on search results.
Lastly, actually show _only_ unassigned tickets (not either unassiged to
staff or team)