Include username when checking if a system email already exists. This
is important for emails that use aliases.

forms: Fix lag updating the CDATA table

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

Config  items cache

This fixes an issue where the CDATA table is updated with the OLD version of
an answer after it is updated. That is, after an answer is updated, the
CDATA table is also updated to reflect the change; however, the old content
of the answer value is used when updating the CDATA value.

Make config items caching class instance based.

forms: Fix attachment security merge conflict

Somehow the attachment security checks got duplicated and messed up. Perhaps
it was a bad merge?

orm: Properly quote objects in queries

Date Time Conversion Mojo

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

This fixes a regression in 4f8f236d, where
the parameters are sent in the SQL statement to the database. Objects which
are converted to a string must be propertly quoted when placed in the query.

ORM queries avoiding caching

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

Add year to php to Date Picker (js) translation table

Make sure due date time dropdown display matches the option value.

Stop doing double timezone offset

Simplified executor which uses the mysqli_query() function to process
queries. This method is faster on MySQL as it doesn't require the PREPARE
overhead, nor require two trips to the database per query. All parameters
are escaped and placed directly into the SQL statement.

This executor extends the traditional mysqli_fetch_xxx() methods by casting
non-null numeric field values to PHP numeric types.

This is required because using unbuffered MySQL queries means that no other
SQL queries can be run until the export is finished. Since the Staff model
will lazily query the config table, the queries need to be fetched in
advance.

This adds a new concept to the ORM iteration mechanisms and allows iterating
over very large queries without caching the records neither in the result
set nor in the model cache. It also implies using the mysqli_query() method
rather than the prepared statement model, as unbuffered queries with the
prepared statement system are much slower.

alerts: Do not include the manager with the members

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

i18n: Eliminate duplicate or incorrect texts

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

This pass also makes a stride at adding correct punctuation and making error
phrases consistent.

This is my attempt at removing similar texts from the translator work load.
It also makes an attempt at dropping some misspelled words and works toward
standardizing some phrases.

login: Introduce a more "professional" login backdrop

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

v1.10 rc2++ Bug Fixes

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

php: Support PHP 7, require at least 5.4

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

Bug: Show help topic specific thank-you page

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