Previously, if a SQL query did not return results for all rows, the results
that were returned would be added to the table in a new column(s) and those
(new) columns would be populated from top down. Therefore, the data would
not correcly line up with the row to which it pertains. Now, results are
matched back to the row to which they pertain, and rows are checked after
each query to ensure they all have the same number of columns.

Add Content-Type

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

Implement automatic client logins

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

Feature/nested help topics

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

Rename 'Knowledgebase' to FAQs and Categories to FAQ Categories

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

open_basedir restriction while adding staff

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

When reading data from /dev/urandom and friends on *nix systems with the
open_basedir setting enforced.

Fix team selection and cancel navigation for staff page

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

Remove forced password change on upgrade

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

This will help distinguish between the knowledgebase part which encompasses
FAQ's and canned responses, and the FAQ part which contains the articles
detailing frequently-asked-questions.

* Auto rehash MD5 based passwords

Remove short_open_tags dependency

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

Fix filters applied on web created tickets

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

Check access post-update

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

Force password to change when changing password

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

Fix staff and departments count on groups page

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

Fix Quoted Reply not removed

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