This helps in long UTF-8 characters as the bytes were previously counted and
the width of the characters was assumed to correlate with the count of the
bytes in the text. This method allows the browser to calmly truncate the
text according to the available space in the page where the text is
rendered.

bug: Check to make sure $ost is initialized

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

Fix subject display when a ChoiceField is used

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

There was a slight issue when transitioning from a short answer field to a
drop-down field, and when the CDATA table is dropped and rebuilt.

forms: Fix interpretation of custom list data

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

Rollback to auto commit, except for sequence  iteration

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

Prior to osTicket v1.9.4, drop down lists only allowed for a single entry.
After upgrading to 1.9.4 the database data for drop downs changed to allow
for multiple entries. However, the old data format was not properly handled
by the SelectionField::to_php() method which handled interpreting and
upgrading the database data.

Keeping the transaction active for the entire request increases the
likelihood of a deadlock on Galera clusters.

search: Escape non-word chars for search queries

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

oops: Always strip embedded images unless

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

Default max file size

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

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.

Determine and set a reasonable max file size on install
Remove file extension restrictions - transition to mime types

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>