InnoDB tables for search indexing where possible

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

Especially on Galera clusters, search indexing with MyISAM tables will cause
unstable clusters and loss of data. For standalone clusters using MySQL 5.6
or MariaDB 10.0, the database default table storage engine can be used,
since either support fulltext indexing.

files: Cleanup orphaned files on autocron

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

forms: Fix validation errors for field `name` matches

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

For fields with `name`s which are the same as other fields on the new ticket
form (such as `time` used with the new ticket by staff form), ensure that
data from the fields outside the main ticket form ("Ticket Details") is not
mingled with fields inside the form.

Since this is only a problem for web requests, and specifically new ticket
by staff requests, this patch only applies the field name to data matching
for non-web requests.

draft: Allow clients to delete their draft

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

bug: Custom ticket statuses

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

Add order by method to ticket status list to return appropriate sort columns
Delegate __get method in CustomListHandler to the parent list

Conflicts:
	include/client/header.inc.php

Dashboard statistics should use 'period' as the date limiter

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

i18n: Add a few forgotten strings

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

i18n: Show ticket numbers bold when open

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

Fix crash submitting new ticket with validation errors

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

And fix an error message typo

Compare the database `state` field rather than the admin editable status
name.

The real bug was setting the source of the ticket form — not the fallback to
the form entry source.  Falling back breaks edits.

Also fix a crash when re-rendering the new ticket by staff page after a
validation error.

oops: Fix regression from e99d1364

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

Use the cdata field when searching and sorting the ticket listing on the
client side.

pjax: Upgrade to PJAX 1.8.2

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

Bug: attachments

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

Fix Additional XSS Vulnerability In "tpl.inc.php"

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

forms: oops: Properly validate forms for agents

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

users: Error message setting username to an email

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

forms: If an answer has no saved value, use the field

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

User Directory not sortable by Status

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

pjax: Fix placement of footer

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

oops: Fix bad merge for list properties as sub-fields

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

i18n: Fix several issues with right-to-left layout

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

oops: Properly format text thread bodies

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

Fixes https://github.com/osTicket/osTicket-1.8/issues/1277 and https://github.com/osTicket/osTicket-1.8/issues/1373

This patch fixes a small glitch where validation might be bypassed for
fields for agents. Previously there was a glitch where required fields would
have their validation errors ignored.

Since users can already log in via their email address, offer a friendly
error message when agents configure the user name to be an email address.

Footer should not be in #pjax_container, because the footer is not rendered
for non PJAX requests.