Change the config table from a column-based table to a key-value table
with namespacing. This allows several parts of osTicket to store their
respective configurations in the same table without requiring database
structure updates

'namespace' is reserved in PHP

Add log error param flag

Since the first department id cannot be assumed

Drop required usage of MyISAM tables, and drop fulltext indexes as they
are not used in the code currently anyway. Also, use a blob to store
session data so as not to waste space with UTF-8 encoding. Lastly, fix
session_id storage to use VARCHAR(255) which is required for versions
of MySQL < 5.0.3, and use ascii for the storage model for the
session_id as it will contain simple characters only.

The problem stems from assumed MySQL insert ids. In MySQL clusters, the id
numbers will not necessarily be consecutive. This patch causes the install
and upgrade patches to lookup the assumed values for the linked id numbers.

Add support for SSL certificates in the MySQL connection

'Hightly' should be Highly

Typo

Convert to desired charset when getting email parts.

 - get_path_info() - simply returns the PATH_INFO if available
 - get_var() - get var from an array - checks if index is set & can validate type.

Add tickets count to ticket's status filter dropdown.

Remove SLA when overdue flag is cleared AND est. duedate is in the past. Only managers can manually clear overdue tickets.

Make sure ticket api controller enforces attachments settings (don't trust data parsers).

Change /api/task/* -> /api/tasks/*

Fix minor spacing/formatting issues.

Don't show reply/response section on new ticket form if the staff can NOT post replies... also checked in Ticket::open().