PHPJunkyard support forum

Posted: **Thu Apr 30, 2009 1:55 pm**

Script URL:
Version of script: 2.0
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution: date closed, closed, time stamp

Write your message below:

Just upgraded to to 2.0 from 0.94x everything is working great. Quick question though. When we close a ticket the mysql is not being updated with "date_closed" any ideas?

Posted: **Thu Apr 30, 2009 4:09 pm**

There isn't such a feature in Hesk (yet?), it will only update dates on new replies.

Posted: **Fri May 01, 2009 9:53 am**

Ah, that would explain it. Obviously was added to our previous installation by one of my ex colleagues.

Code: Select all

if ($status == '0') $sql = "UPDATE `hesk_tickets` SET `date_closed`='$date' WHERE `trackid`='$trackingID' LIMIT 1"; $result = hesk_dbQuery($sql) or hesk_error("$hesklang[cant_sql]: $sql</p><p>$hesklang[mysql_said]:<br>".mysql_error()."</p><p>$hesklang[contact_webmsater] $hesk_settings[webmaster_mail]");

This was in admin_change_status.php

PHPJunkyard support forum

Closing tickets - writing date closed to sql

Closing tickets - writing date closed to sql