Otherwise we might end up with a search term like '"some junk"*' which is
invalid.

Instead of using distinct alone, change to add the relevance of related
items when searching for tickets. In other words, when performing a full
text search for 'xyz', add the relevance of matched user, organization, and
thread objects.

This time, use full-text for user and ticket lookup boxes, and drop the
full-table scans from the ticket basic search page. Auto promote searches to
wildcard searches when searching with the user-supplied input yields no
results.

Also, apply requested state to the user and organization tickets search.

If the subject field is something crazy, such as an HTML field, ensure that
the layout of the ticket queue is preserved and properly truncated.
Furthermore, ensure that the HTML is properly rendered on the client and
staff ticket view pages.

The system would encode 'access -related' as 'access+-related' when changing
the sorting preference and would crash the query. This patch fixes the
search engine code to avoid a BOOLEAN MODE search when improper operators
are used in the query terms, and it fixes the sorting preference system to
properly decode the '+' to a space when rewriting the URL.

Adjusted all tables to use % instead of px.

Styled dashboard page.

Add ticket count to page bottom. Team-assigned tickets show up in "My
Tickets"

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

Redirect to recent queue / listing on transfer or assign

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)

- Adds mass assign, transfer to ticket queues
- Retire inline forms for ticket assignment and transfer

This reverts commit c4ace2d5.

Remove manual roll-up on tickets page since it's auto-added.

Fixup IE and firefox rendering issues

orm: Correctly label correlated query joins via sub-queries
orm: Fixup formatting of dates in queries
orm: Fixup mangling of parameter values with colons in sub-queries
misc: Fixup incorrect offset calculation in Misc::dbtime()
forms: search: Add ability to describe a field search
search: Fix crash searching by ticket due date
search: Fix wrong results if searching by a date field (unix epoch was not
    converted to MySQL date format)
search: Fix wrong results searching by date == or !=

* Fix crash visiting tasks page while ticket adv search
* Fix search on custom fields
* Add search on ticket source
* Move more advanced fields to drop-down