Wrap the upgraded email template data in an HTML <div> element so that the
final content is valid HTML. This is useful for the mailer to identify the
message content as HTML

Conflicts:
	include/mysqli.php
	include/staff/faq-categories.inc.php
	setup/tips.html

Include category when searching the knowledge base 

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

Support non-standard port numbers for MySQLi

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

Include changes post 1.7.2

Conflicts:
	include/class.file.php
	main.inc.php

Mark tickets overdue which have no SLA

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

Make Crypto::random() more reliable on Windows

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

Handle parsing email if Reply-To header is missing

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

Reduce cost of deleting orphaned files

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

Support updating the source of the ticket

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

Emit a backtrace on db_error logs

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

add table prefix to places missing in the query

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

Die on redirect

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

Validate port during installation

Add help information about the non-standard port number to the popup tips in
the install screen.

Support MySQL 'localhost' connections using a non-standard port number.
Ordinarily, MySQL will ignore the port setting on *nix systems if the host
is specified as 'localhost'

Implements/Fixes #769

This patch makes openssl the preferred source of random data on Windows and
will only use mcrypt_create_iv on PHP 5.3.7 and newer.

Fixes #771

Fixes #772

Previous explain included a nested sub-select, which exponentially increased
the count of the rows to be examined. This patch eliminates one layer of
nesting on the sub-select and dramatically increases the performance finding
orphaned files.

Fixes #773

References:
http://www.osticket.com/forums/forum/osticket-1-7-latest-release/troubleshooting-and-problems-aa/9446-version-1-7-much-slower-than-1-6

Support incorrectly labeled us-ascii charsets

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

Index form_entry on (object_type, object_id)

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

Address various lint related bugs, typos, and hints

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

Including adding support to the TCL uninitialized variable reader to ignore
class-static variable access as well as detect inline functions and their
closure arguments.

Various issues from big feature merges

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

Some email clients (names omitted to protect the innocent) advertise the
encoding as us-ascii when iso-8859-1 was really implied. This patch allows
the two charsets to be interchangable.