And provide a shell script to remove codebase files no longer used in
osTicket 1.7

Add a (temporary) key to %ticket_thread allowing quick lookups on the old_pk
column. Also, only fill the temporary table used for linking responses to
the migrated messages with messages.

Remove clobber between queue() method and queue instance property (which is
the queue list). Also properly limit the number of attachments queued for
migration as indicated by the initial call to the queueAttachments() method.
Lastly, fix an issue where the first $limit items of the database cannot be
found on or read from the disk. Recurse through the queueAttachments()
method until the entire database is scanned or $limit items are placed in
the queue.

This overcomes the eventual limit of and database to support queries of a
finite length. We now split the file contents into 100k chunks and append
the chunks to the database one chunk at a time.

Migrate the PHP session from disk to database live. To pull this off, the
session contents are written to database under the current session id. When
the `ostversion` column is dropped from the %config table, the system will
automatically switch to database-backed sessions in osTicket 1.7 mode.

This is sort-of hacked together by carefully calling a instance method of
the osTicketSession class statically, and modify the instance method to
support static invocation.

When the `ostversion` column is removed from the %config table, the system
will immediately switch to database-backed sessions. Because the
administrator upgrading the system originally logged in with a file-based
session, it must be migrated to the database before removing the column.

Remove LEFT JOIN to time zone table in order to support upgrading from 1.6* to 1.7 + Fix bug on getDepts

Symbolic link to the upgrade patch for 1.6ST-1.7 upgrade - makes it easy, for devs, to indetify major patches

Issue/stop dashboard freezes

Looks good.

Reviewed By: Peter 06/18/12

Looks good, thanks.

Looks good, thanks. Wonder where this broke?

Minor cleanups pending - parked for DPR5/RC1

Reviewed By: Peter 06/18/12

Looks good.

Reviewed By: Peter 06/18/12