Change/Set time

ibstyln

New Member

Karma: +0/-0
Offline

Offline

Posts: 7

Change/Set time

« 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: 601

In a world without fences, who needs Gates?

Re: Change/Set time

« 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.


« 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 Web Design - Freelance Website Design & IT Consulting

Hummdis

Moderator
Super Member

Karma: +13/-0
Offline

Offline

Posts: 601

In a world without fences, who needs Gates?

Re: Change/Set time

« 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 Web Design - Freelance Website Design & IT Consulting

eTicket Community


	Logged

Pages: [1] Go Up

eTicket Community > Support > Tips & Tricks (Moderators: jason, Hummdis) > Topic: Change/Set time

« previous next »

Related Topics
	Subject	Started by	Replies	Views	Last post
	time zone problem Web Site Discussion	amit	0	2123	July 06, 2009, 11:14:54 PM by amit
	Can't change mail-setting Installation Help & Software Support	jelle100	1	964	October 02, 2009, 05:31:19 PM by Hummdis
	Extra Functionality - Time spent on ticket Module Development	fiberwire	1	5484	November 13, 2009, 04:16:10 AM by Hummdis
	prevent status change on reply Tips & Tricks	splatt	1	1049	February 06, 2010, 01:21:34 PM by Hummdis
	Incorrect time shown in the web interface General Discussion	dnk	2	1358	April 12, 2010, 07:00:04 AM by Hummdis

	Author	Topic: Change/Set time (Read 1157 times)
0 Members and 1 Guest are viewing this topic.