Help Center Live Community

Support => Installation Help & Software Support => Topic started by: BrianP on April 02, 2009, 05:09:26 PM



Title: Chat transcript times
Post by: BrianP on April 02, 2009, 05:09:26 PM
anyone understand how the time stamps are put in the transcripts?  I have an transcript in the database:

mysql> select id, timestamp, FROM_UNIXTIME(timestamp) from hcl_transcripts where id = 40;
+----+------------+--------------------------+
| id | timestamp  | FROM_UNIXTIME(timestamp) |
+----+------------+--------------------------+
| 40 | 1238528629 | 2009-03-31 14:43:49      |
+----+------------+--------------------------+
1 row in set (0. 00 sec)

This time matches the time I actually did this chat test.   But if I look at the transcript list for my operator, it shows a different time:
16:09:37 Fri 16th January 2009 - XXXX. XXXX. XXXX

And if I look at the transcript itself, I see the wrong times:

Time:     19:43:49 Tue 31st March 2009

(19:43:19) Brian: randy hi there
(19:43:49) Brian: Pushed Page: hxxp: google. com

I am assuming I have a timezone issue.   I see in docs/CHANGE_LOG. txt

- Added timezone offsets

but I don't see anything about how to configure them.   Any ideas?  (Make is worse, I have 5 time zones I have to deal with based on my departments).

- brian



Title: Re: Chat transcript times
Post by: BrianP on April 02, 2009, 06:43:52 PM
Okay, I just found
        // Time offset from GMT
        $conf['offset'] = -5;

in config. php.

Any idea if there is an easy way to change it based on department?  Any chance that is part of v3?

- brian