This means that drive-by mouse hovers, where the user likely did not intend
for the hover to actually popup the banner with the filename and download
button, do not trigger the popup. This patch changes the popup effect so
that it requires a 500ms hover before the popup is shown.

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.