This script adds a single download script, 'file.php', which provides access
to files of all types to all users. It uses a HMAC signature system with an
expires time, which allows signed URLs to be sent to external users.

This also fixes an issue with the Http::cacheable() method, where the
last-modified and Etag headers were not properly compared, which resulted in
permanent cache misses by the client.

forms: Properly export choices lists

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

files: Avoid crash if `file info` extension missing

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

Disable auto-responses on staff created tickets

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

i18n: Clarify attachment settings labels

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

pdf: Fix invalid UTF-8 characters error message

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

Take into consideration the auto-response settings when sending out new
ticket by staff notice to the end user.

i18n: Add a few forgotten strings #2

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

thread: Fix regex for ticket # in email subject

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

forms: Drop custom data when removing a user

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

The ticket number regex was changed with the advent of custom ticket
numbers, and it matches the closing punctuation in [#12345], that is, the
closing bracket would be included in the ticket number sought in the
database. Therefore, it would never match the ticket number properly.

The new regex attempts to match punctuation and non-punctuation groups so
that punctuation in the middle of the ticket number is matched; however,
punctuation at the end is not. So #12345+DEPT will match properly and will
ignore any trailing whitespace and punctuation.

bug: Check to make sure $ost is initialized

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

Previously, this was not ported properly now that multiple selections are
supported in the choice field and derivatives.

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>