Quite some time back, I wrote a mod to osTicket on the 1.6 release to add merge functionality and time tracking.  You can see the post here.  There were a few tweaks to bring it forward to the 1.9 platform which has now been release at 1.9.7, the latest vintage as of writing this.

If you’ve already upgraded to the 1.9 platform and made the original mods to your database, you can simply install the following files on your current release.  If you haven’t done the database tweaks yet, you need to run the following two lines on your database via mysql directly or via phpMyAdmin:

ALTER TABLE `ost_ticket_response` ADD `invdate` DATE NULL ,
ADD `invtime` DECIMAL ( 10, 2 ) NULL ,
ADD `invtype` ENUM( 'Meal', 'No Charge', 'Remote Access', 'Off-site', 'Site', 'Travel', 'Phone' ) NULL ;

ALTER TABLE `ost_ticket_note` ADD `invdate` DATE NULL ,
ADD `invtime` DECIMAL ( 10, 2 )  NULL ,
ADD `invtype` ENUM( 'Meal', 'No Charge', 'Remote Access', 'Off-site', 'Site', 'Travel', 'Phone' ) NULL ;

1.9.5.1 Download Mods

1.9.6 Download Mods

1.9.7 Download Mods

Verified by MonsterInsights