Anybody successfully implemented a Date Offset contribution??

I searched and cannot seem to find anyone saying they have successfully implemented any Date Offset? I need to set my server to GMT+8 hours but have not been able to get this done. Really appreciate some help. Thank you.

Henry

bump for a good cause

henrygoh:

I searched and cannot seem to find anyone saying they have successfully implemented any Date Offset? I need to set my server to GMT+8 hours but have not been able to get this done. Really appreciate some help. Thank you.

Henry

Search fot TIME ZONE OFFSET
or
look in downloads->other modules->timeZoneOffset

This is for 1.3.0.1 if you have a previous version its available as well
This sets the time offset for the database stuff which is the most important.
You can set the admin server time by adding another file with a TZ variable for your time zone.

Hello Neville,

I actually emailed you yesterday hoping to get some instructions on implementing your contribution for Date Offset. I don't quite understand (I'm a total newbie and a non-programming guy) and was not able to get your contribution working. I really, really need to get this small cart of mine to work right since I only sell in Singapore.

Would be truly grateful for some hand-holding through this.

Henry

Sorry I'm Not Neville??? no email received by me!

Assuming you are using 1.3
download contrib, unpack on your computer
Copy & paste the contents of the sql patch to the box in the admin->tools->install sql patches area of the administration side of the site.
Run (send) the query.

Upload the files in the admin directory to the admin directory on your site.

Open admin->configuration->my store->time zone offset, put +8 in here

Thats it

gilby:

Sorry I'm Not Neville??? no email received by me!

Assuming you are using 1.3
download contrib, unpack on your computer
Copy & paste the contents of the sql patch to the box in the admin->tools->install sql patches area of the administration side of the site.
Run (send) the query.

Upload the files in the admin directory to the admin directory on your site.

Open admin->configuration->my store->time zone offset, put +8 in here

Thats it

Really sorry.. I'm getting names all mixed up.

Before I saw your reply, I had re-run the patch again but w/o sending the query. Seems to work in so far as Date Offset for reports and time stamp on purchase are concerned but my Admin panel clock remains unchanged. Is this to be expected? Is it harmful if I now re-run the whole process on the existing database? Will the mod cause errors if I do not work on an unmod database?

Thanks a zillion for coming back and writing a very clear and simple set of instructions. Really appreciate this.

Henry

henrygoh:

Before I saw your reply, I had re-run the patch again but w/o sending the query. Seems to work in so far as Date Offset for reports and time stamp on purchase are concerned but my Admin panel clock remains unchanged. Is this to be expected? Is it harmful if I now re-run the whole process on the existing database? Will the mod cause errors if I do not work on an unmod database?

Thanks a zillion for coming back and writing a very clear and simple set of instructions. Really appreciate this.

Henry
Running the patch again will bring up errors saying it can't insert the patch because it alredy exists. Ignore it It does no damage.

I prefer not to patch the admin panel but to use a simpler approach.
create a file time_offset.php and put the correct define in it for your time zone.
You may have to search to find the correct valid names for your time zone.

Heres the one I use in Oz

<?php 
//You can modify the TZ (Time Zone) by using one of the following offsets
//TZ=America/Los_Angeles
//TZ=America/Denver
//TZ=America/Chicago
//TZ=America/New_York

putenv ('TZ=Australia/Melbourne'); 
?>

upload to
admin/includes/extra_configures/

This doesn't work on all servers but try it out and see.

Thank you very much gilby!

This works very well and I now have the cart working correctly.

Very grateful for your help.

Henry

Thank you very very much. Everything is working nicely now.

I'm just wondering if I should update to 1.3.0.2 because I understand that all or most of my mods may be discarded....??? not sure what to do...

Henry

henrygoh:

Thank you very very much. Everything is working nicely now.

I'm just wondering if I should update to 1.3.0.2 because I understand that all or most of my mods may be discarded....??? not sure what to do...

Henry

I have already updated the time zone offset for 1.3.0.2
Just need to do some testing to make sure its working ok before I update my sig to point to it, and to update the downloads section.

Sigh "When will it ever be finished...." :D

Hi, there:

I just checked the download area, there are two versions of the Time Zone Offset module......for 1.3.0.1 and 1.3.0.2

I have not upgraded my Zencart to 1.3.0.X yet, still using 1.2.6d, so my question is which Time Zone Offset version should I use for my current version (not for current Zencart current version 1.3.0.2)??

Thank you very much!

By the way, except the above method, is there any other way to fix this problem without doing so much extra work? Like, build in module in the future??

ez2ask:

Hi, there:

I just checked the download area, there are two versions of the Time Zone Offset module......for 1.3.0.1 and 1.3.0.2

I have not upgraded my Zencart to 1.3.0.X yet, still using 1.2.6d, so my question is which Time Zone Offset version should I use for my current version (not for current Zencart current version 1.3.0.2)??

Thank you very much!

By the way, except the above method, is there any other way to fix this problem without doing so much extra work? Like, build in module in the future??

Try this from the archived contribs
http://www.zen-cart.com/archived_contributions/other/time_zone_offset.zip

gilby:

Heres the one I use in Oz

>  
> upload to
> admin/includes/extra_configures/
>  
> This doesn't work on all servers but try it out and see.
 
 
Thanks Gilby :laugh:  i have tried the mods and they just screw up my store. i'm using 1.3.7 and did the little patch and works great :D :D

sirryche:

Thanks Gilby :laugh: i have tried the mods and they just screw up my store. i'm using 1.3.7 and did the little patch and works great :D :D

This patch admin/includes/extra_configures/time_offset.php updates & sets the server time (php) so that your admin shows the correct time.

It doesn't correct the mysql database time. (Mysql has its own independant time)

So unless you install the mod all the database times will show the mysql times.
This is the main reason for the mod so that all store database purchase, update & other customer related timestamps will show the correct time & date for your timezone

gilby:

This patch admin/includes/extra_configures/time_offset.php updates & sets the server time (php) so that your admin shows the correct time.

It doesn't correct the mysql database time. (Mysql has its own independant time)

So unless you install the mod all the database times will show the mysql times.
This is the main reason for the mod so that all store database purchase, update & other customer related timestamps will show the correct time & date for your timezone

okdoky i got the time patch for 1.3.7 it is the first time i saw this version. for when i tried the older mod it crashed my database(or i did:D ) but i backed everything up installed newest mod and lo behold it WORKS!!!:lol: thanks for the information on it.