Forum Subject: Time Offset from the server time
Posted on: 12/06/02 02:44pm
By: Anonymous (Anonymous)
Hi there,
I tried to find a Time Offset variable eaither in language file or config so my site can show my local time to the visitors insted of the server time which is (-7) from my place.
I hope somebody can tell me how to do it..
Regards,
Ageel
Time Offset from the server time
Posted on: 12/07/02 01:14am
By: Dirk
Yes, this is a known shortcoming - Geeklog will always use the time zone of the server it's running on.
Maybe this Timezone hack[*1] works for you.
bye, Dirk
Time Offset from the server time
Posted on: 12/07/02 09:16am
By: isol8
Geeklog's Greatest Hits Vol.1
Order your copy today...featuring crowd favorites like:
1. "I Fought PHP, and PHP won."
2. "This path is your path, This path is my path"
3. "8675309: You have an error in your SQL syntax"
4. "Template Error: Halt in the Name of Love"
Time Offset from the server time
Posted on: 12/07/02 05:01pm
By: Anonymous (Anonymous)
hi,
thanx, it solved the display part,
but, the server still retrieve the recored of the database according to it's local time while the article I made are stored using my local time 
I think there must be something to add the time offset to SQL queries also.
any idea?
Ageel
I think there must be something to add the time offset to SQL queries also.
any idea?
AgeelRe:Time Offset from the server time
Posted on: 01/18/04 03:56am
By: xbrief
[QUOTE BY= Dirk]
Yes, this is a known shortcoming - Geeklog will always use the time zone of the server it's running on.
Maybe this Timezone hack[*1] works for you.
bye, Dirk[/QUOTE]
Clicking on the link brings me back to the Index page. I am interested in the Server Time Offset problem too.
Re:Time Offset from the server time
Posted on: 01/18/04 04:34am
By: Dirk
[QUOTE BY= xbrief] Clicking on the link brings me back to the Index page.[/QUOTE]
Looks like that link wasn't converted when we moved stories to the forums. A simple search for "timezone hack" brings up this thread[*2] (with horrible formatting), and a lot more ...
bye, Dirk
Looks like that link wasn't converted when we moved stories to the forums. A simple search for "timezone hack" brings up this thread[*2] (with horrible formatting), and a lot more ...
bye, Dirk
Re:Time Offset from the server time
Posted on: 01/18/04 05:14am
By: xbrief
[QUOTE BY= Dirk] [QUOTE BY= xbrief] Clicking on the link brings me back to the Index page.[/QUOTE]
Looks like that link wasn't converted when we moved stories to the forums. A simple search for "timezone hack" brings up this thread[*2] (with horrible formatting), and a lot more ...
bye, Dirk[/QUOTE]
The hack is good for time zones. But when I post an article, the time of posting that is given is the time zone of the server AS determined from my Time zone (Asia/Manila). I'd like to see a hack that would cure this.
Thanks.
Looks like that link wasn't converted when we moved stories to the forums. A simple search for "timezone hack" brings up this thread[*2] (with horrible formatting), and a lot more ...
bye, Dirk[/QUOTE]
The hack is good for time zones. But when I post an article, the time of posting that is given is the time zone of the server AS determined from my Time zone (Asia/Manila). I'd like to see a hack that would cure this.
Thanks.
Re:Time Offset from the server time
Posted on: 01/18/04 07:04am
By: geKow
I followed that thread and now all times in my geeklog are CET while the server is under EST
Re:Time Offset from the server time
Posted on: 01/18/04 07:08am
By: xbrief
[QUOTE BY= xbrief] [QUOTE BY= Dirk] [QUOTE BY= xbrief] Clicking on the link brings me back to the Index page.[/QUOTE]
Looks like that link wasn't converted when we moved stories to the forums. A simple search for "timezone hack" brings up this thread[*2] (with horrible formatting), and a lot more ...
bye, Dirk[/QUOTE]
The hack is good for time zones. But when I post an article, the time of posting that is given is the time zone of the server AS determined from my Time zone (Asia/Manila). I'd like to see a hack that would cure this.
Thanks.[/QUOTE]
All? Does that mean even your posted articles?
Looks like that link wasn't converted when we moved stories to the forums. A simple search for "timezone hack" brings up this thread[*2] (with horrible formatting), and a lot more ...
bye, Dirk[/QUOTE]
The hack is good for time zones. But when I post an article, the time of posting that is given is the time zone of the server AS determined from my Time zone (Asia/Manila). I'd like to see a hack that would cure this.
Thanks.[/QUOTE]
All? Does that mean even your posted articles?
Re:Time Offset from the server time
Posted on: 01/18/04 08:49am
By: geKow
[QUOTE BY= xbrief]
All? Does that mean even your posted articles?[/QUOTE]
Yes, postings, forum, downloads (filemgmt)
For some reasons I disabled the posting time, but I can check it in the postings list and yes, it's correct.
The imortant part for the postings was
[Quote BY= Anonymous: Joe]
On line 910, I changed the DB_save call a little. Instead of storing $date, I changed it to FROM_UNIXTIME($unixdate)
[/QUOTE]
(admin/story.php that is)
geKow
All? Does that mean even your posted articles?[/QUOTE]
Yes, postings, forum, downloads (filemgmt)
For some reasons I disabled the posting time, but I can check it in the postings list and yes, it's correct.
The imortant part for the postings was
[Quote BY= Anonymous: Joe]
On line 910, I changed the DB_save call a little. Instead of storing $date, I changed it to FROM_UNIXTIME($unixdate)
[/QUOTE]
(admin/story.php that is)
geKow
Re:Time Offset from the server time
Posted on: 01/18/04 10:33am
By: xbrief
[QUOTE BY= geKow] [QUOTE BY= xbrief]
All? Does that mean even your posted articles?[/QUOTE]
Yes, postings, forum, downloads (filemgmt)
For some reasons I disabled the posting time, but I can check it in the postings list and yes, it's correct.
The imortant part for the postings was
[Quote BY= Anonymous: Joe]
On line 910, I changed the DB_save call a little. Instead of storing $date, I changed it to FROM_UNIXTIME($unixdate)
[/QUOTE]
(admin/story.php that is)
geKow
[/QUOTE]
But that would be if your server is Unix right?
All? Does that mean even your posted articles?[/QUOTE]
Yes, postings, forum, downloads (filemgmt)
For some reasons I disabled the posting time, but I can check it in the postings list and yes, it's correct.
The imortant part for the postings was
[Quote BY= Anonymous: Joe]
On line 910, I changed the DB_save call a little. Instead of storing $date, I changed it to FROM_UNIXTIME($unixdate)
[/QUOTE]
(admin/story.php that is)
geKow
[/QUOTE]
But that would be if your server is Unix right?
Re:Time Offset from the server time
Posted on: 01/18/04 10:50am
By: xbrief
[QUOTE BY= xbrief] [QUOTE BY= geKow] [QUOTE BY= xbrief]
All? Does that mean even your posted articles?[/QUOTE]
Yes, postings, forum, downloads (filemgmt)
For some reasons I disabled the posting time, but I can check it in the postings list and yes, it's correct.
The imortant part for the postings was
[Quote BY= Anonymous: Joe]
On line 910, I changed the DB_save call a little. Instead of storing $date, I changed it to FROM_UNIXTIME($unixdate)
[/QUOTE]
(admin/story.php that is)
geKow
[/QUOTE]
But that would be if your server is Unix right?
[/QUOTE]
Ummm I tried it. It looks good. Thanks.
All? Does that mean even your posted articles?[/QUOTE]
Yes, postings, forum, downloads (filemgmt)
For some reasons I disabled the posting time, but I can check it in the postings list and yes, it's correct.
The imortant part for the postings was
[Quote BY= Anonymous: Joe]
On line 910, I changed the DB_save call a little. Instead of storing $date, I changed it to FROM_UNIXTIME($unixdate)
[/QUOTE]
(admin/story.php that is)
geKow
[/QUOTE]
But that would be if your server is Unix right?
[/QUOTE]
Ummm I tried it. It looks good. Thanks.
Re:Time Offset from the server time
Posted on: 01/18/04 11:22am
By: geKow
outch...
what have you done? maybe you should stop quoting for this thread
geKow
what have you done? maybe you should stop quoting for this thread
geKow