Also, add build version and path information for the PHAR files listed as
language packs.

Since two major versions will internationalization support will soon be
available, the language pack system will need a way to indicate which major
version of osTicket the phrases were compiled for. This patch adds a
`Phrases-Version` tag to the MANIFEST, which will be a copy of the
MAJOR_VERSION included in the messages.pot file created via `make-pot`.
Then, a `Build-Major-Version` tag is added to the MANIFEST which represents
the version of osTicket used to compile the language pack.

Ordinarily, both strings should be the same, and they should also both match
the MAJOR_VERSION of osTicket when the language packs are loaded on a
production system.

This also adds support for PHAR compression in the build process. Since
accessing a PHAR file in a request burns 1ms per megabyte of PHAR file,
reducing the PHAR file size by up to 77% means that much less time spent
loading PHAR files. This can be especially useful for a busy server with
support for several languages. But, ZLIB or BZIP2 support would be required
for all production servers.

Date Time Conversion Mojo

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

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>

Textarea input cleanup

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

This duplicates the custom logo code to allow for custom login backdrops. A
new page is added to the "Company" settings page which allows for management
of the uploaded custom backdrops.

Also, rename other apc_xxx functio to the new apcu_xxx equivalents available
since PHP 5.4.

Use APCu, if available, to cache the compiled model meta data.

Previously, the create method was used to create a new instance of an orm
model (which would later result in an INSERT when persisted); however, some
classes require or utilize varying parameters to their create() method,
which PHP7 considers an error. Methods in subclasses must be defined with a
calling signature compatible with the parent class.

This patch shifts the concept of model creation to the constructor. Now, the
constructor of ORM models is required to be compatible with that of
ModelBase class. Now that most models do not define a constructor, this is
much easier to control, and much more logical.

Also, remove an issue where assignments on a relationship field to an
instance of a super class of the foreign model would raise an error. This
was previously addressed by re-classing the instance in the
ModelInstanceManager::getOrBuild(); however that design would create
multiple instances of the same object in memory, which defeats one of the
primary design concepts of the ORM. This patch addresses the issue by
allowing super-classes of the declared foreign model in relationship
assignments.

This commit attempts to remove all coding standard warnings emitted by PHP
7.0.

Default to system default of staff doesn't have page limit set.

Credit: @antriver PR#2951

Strip tags on text input field to prevent potential XSS exploit.

Let textarea widgets parse and clean input based on configured text format.
Add cleanup routine to ThreadEntryBody
Clean response/note inputs

Conflicts:

	include/class.forms.php
	include/class.ticket.php