Closing tickets - writing date closed to sql

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
nickday85
Posts: 9
Joined: Thu Apr 30, 2009 10:06 am

Closing tickets - writing date closed to sql

Post by nickday85 »

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?
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

There isn't such a feature in Hesk (yet?), it will only update dates on new replies.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
nickday85
Posts: 9
Joined: Thu Apr 30, 2009 10:06 am

Post by nickday85 »

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
Post Reply