Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
Advanced search

2505 Posts in 648 Topics- by 1314 Members - Latest Member: Saudi Arabia

eTicket CommunitySupportTips & Tricks (Moderators: jason, Hummdis)Topic: Change/Set time
« previous next »
Pages: [1]   Go Down
Print
Author Topic: Change/Set time  (Read 675 times)
0 Members and 1 Guest are viewing this topic.
ibstyln
New Member
*

Karma: +0/-0
Offline Offline

Posts: 7
« on: June 24, 2009, 03:02:46 AM »

When replying to tickets the time shown is not correct.   I've already set the time zone in preferences.   When a new ticket is created the time is correct.   When replying to the ticket the time is not correct.   The time is showing 7 hours earlier.   Where can I go to fix this?

Thanks
Logged
Hummdis
Moderator
Super Member
*****

Karma: +13/-0
Offline Offline

Posts: 558



WWW
« Reply #1 on: June 24, 2009, 06:19:01 AM »
I had this same problem.  I fixed it, but can't remember what changes I made.

I'm going to download the original files and compare then with what I've got so I can find where I made this change.

I usually add comment lines that explain the changes I'm making, but I didn't do it this time.  Of course. Smiley
« Last Edit: June 24, 2009, 06:24:15 AM by Hummdis » Logged
Don't PM me directly for help.  Post to the forums, that's what they are for after all.  PM's to me that request help will be ignored.

Hummdis Communications - Freelance Website Design & IT Consulting
Hummdis
Moderator
Super Member
*****

Karma: +13/-0
Offline Offline

Posts: 558



WWW
« Reply #2 on: June 24, 2009, 07:10:56 AM »
Okay, here are some changes....

1. inc/class.ticket.php -- Line 411: Add: ", timestamp)" to the list.  It should look like this:

Code:
$sql = "INSERT INTO " . $db_table['answers'] . " (ticket, message, rep, reference, timestamp) ";

2. inc/class.ticket.php -- Line 412: Add: ", UTC_TIMESTAMP()" in the "$sql.=" command.  It should look like this:

Code:
$sql.= "VALUES('$ticket', $sql_message, '$repid', '$refid', UTC_TIMESTAMP())";

Start there.  Let me know if that works or not.  If not, I'll keep digging for the fix I was able to achieve.
Logged
Don't PM me directly for help.  Post to the forums, that's what they are for after all.  PM's to me that request help will be ignored.

Hummdis Communications - Freelance Website Design & IT Consulting
eTicket Community
   
 Logged
Pages: [1]   Go Up
Print
eTicket CommunitySupportTips & Tricks (Moderators: jason, Hummdis)Topic: Change/Set time « previous next »
Jump to: