Time Zone Offset (for v1.3.0-thru-v1.3.9d ONLY)

**IMPORTANT NOTE:
This mod will not be updated further than Zen-Cart v1.3.9d

Please use the new replacement mod instead: Time Zone Fix.
**
The new mod is:
Much simpler and overwrites only 1 core file.
When working it fixes all known Time Zone problems

There is a new Support Thread for this new mod.

There is no need to update the existing Time Zone Offset mod if it is working fine for you.

When you should use the new Time Zone Fix mod:

• If updating to a new version of Zen-Cart.
• And for all new Zen-Cart installs.

Just updated the Time Zone Offset module for 1.3.0.1 ... and v1.3.5

Added two more places to update the date & time in admin, showing customer information.

Now corrects the customers last login and last modified.

Available here

Gilby
I'm updating for v1.3.5 but as I'm also running Super Orders and it can replace Orders.php I'm wondering if I need to patch that as well

lucidlee:

Gilby
I'm updating for v1.3.5 but as I'm also running Super Orders and it can replace Orders.php I'm wondering if I need to patch that as well

in the time zone contrib file admin/orders.php
around line 123 is what you may need to add to the super orders file

check if it uses the order.php in the catalog side as well.

Haven't used super orders myself so I don't know what it alters

I have ZenCart 1.3.0.2 installed. I want to install Time Zone Offset module for 1.3.0.1 which after comparing files I believe should work fine with ZenCart 1.3.0.2.

I am confused about the readme file where it states:
"Step 1. If you use a database table prefix other than zen_ you need to edit the included database_mod.sql file so that the zen_configuration table name accurately reflects the name in your database."

The database name I use is db_aso_zen and I use phpMyAdmin.

The table names inside the database have not been renamed or modified however I'm not sure if in the context of this readme file the name of the database is considered the prefix.

Here is the database_mod.sql code. Where do I insert the prefix?

INSERT INTO configuration 
   (configuration_id, configuration_title, configuration_key, 
   configuration_value, configuration_description, 
   configuration_group_id, sort_order, last_modified, 
   date_added, use_function, set_function) 
   VALUES ('', 'Time Zone Offset', 'TIME_ZONE_OFFSET', '0', 
   'The time zone difference between your store and the server. 
   Enter +h, 0 or -h where ''h'' is the number of hours. If your
   store time zone is ahead of the server time zone, 
   use +', 1, 7, NULL, '0001-01-01 00:00:00', NULL, NULL);

Any clarification on this would be greatly appreciated. - Ron -

OK, of course once I posted my question it seems that my comprehension skills immediately improved.

I think that I'm good to go without modifying the database_mod.sql file but would sure appreciate anyone confirming or correcting me on that assumption.

• Ron -

Hi Gilby

I'm just going through installing your time zone offset and I have come across an issue. I am in Adelaide +9.5GMT. Time zone offset appears to ignore fractions of an hour and rounds up to the next hour. I insert 14 or 14.5 and I get the same error message and of course it won't adjust the time by that extra half an hour.

Is this something that you are able to look at or let me know where to look at changing this. :lamo:

siege:

Hi Gilby

I'm just going through installing your time zone offset and I have come across an issue. I am in Adelaide +9.5GMT. Time zone offset appears to ignore fractions of an hour and rounds up to the next hour. I insert 14 or 14.5 and I get the same error message and of course it won't adjust the time by that extra half an hour.

Is this something that you are able to look at or let me know where to look at changing this. :lamo:

No the contrib was written to work with whole hours and you would need to do a bit of work to get this to work for half hours. It is possible but would take some time.

Besides crow eaters should get with the real world and fix that half hour problem. :D

Ok Gilby

Here's the deal - The Crow eaters have got with the program and made some changes

This module will now accept time adjustments in minutes.

Just insert the adjustment as 14.30 for an adjustment of 14 hours and 30 minutes.

So now for all of us that are in timezones that don't happen to be in round hours we can adjust our carts.

Hopefully others will find this useful.

Time Zone Offset
updated to zen v1.3.6
available here

wow i can't get this thing to work from my admin one thing i don't get is this

Step 1. If you use a database table prefix other than zen_ you need to edit the included database_mod.sql file so that the zen_configuration table name accurately reflects the name in your database.

i don't see zen_ in the file, and if you install this sql fle can you install over it with a new file just like regular files?

Time Zone Offset
updated to Zen-Cart v1.3.7
available here

Hello,

I have installed this successfully, however the one thing I am trying to get right is the time in the admin header.

In the readme file it says:

"========================================================
OPTIONAL FILES
admin/includes/extra_configures/time_offset.php
This file needs to be EDITED to point to your local timezone, but it may not work on all servers.
It updates the admin display to show your local time.
If it does work then you may want to use
admin/includes/header.php
This file compares the admin header time produced by the above time_offset.php file with the Time Zone Offset time and displays a warning if there is a difference. This is helpful when either local or the hosting server time zone move into or out of daylight saving time. It produces a visible warning of such changes.
========================================================"

I installed the admin/includes/extra_configures/time_offset.php file, however the time is set to Australia Melbourne.

I tried to change the line in the file from:

putenv ('TZ=Australia/Melbourne');

to :

putenv ('TZ=Australia/Perth');

however it did not bring the time 2 hours back to Perth time.

Is there something else that I can do to get the time in the admin header to show 2 hours less than it is ?

Thanks,
Anthony

xman888:

I installed the admin/includes/extra_configures/time_offset.php file, however the time is set to Australia Melbourne.

I tried to change the line in the file from:

putenv ('TZ=Australia/Melbourne');

to :

putenv ('TZ=Australia/Perth');

however it did not bring the time 2 hours back to Perth time.

Is there something else that I can do to get the time in the admin header to show 2 hours less than it is ?

Thanks,
Anthony

If the
putenv ('TZ=Australia/Melbourne');
setting works then
putenv ('TZ=Australia/Perth');
should work as well.
Just tried it on my computer and it works fine.

Try editing it locally on your computer, then upload to the website.
Refresh your computer with ctrl+F5

Hello,

Cheers for that.

I think that maybe I might have uploaded the file to the wrong location.

All is working spot in now.

Thanks
Anthony

I installed Time Zone Offset and it works great! Thanks, gilby!

One thing I noticed though is PayPal (both IPN and Express Checkout) date / time stamps are still wrong.

PayPal IPN uses server time, while PayPal Express Checkout is all over the map - I guess it uses the time zone from where the payment originates or something.

Can this be addressed by enhancing Time Zone Offset or is it a limitation of PayPal payment modules?

Thanks!

Dan G.

http://www.NotebookSolutions.ca

DanTheMan:

I installed Time Zone Offset and it works great! Thanks, gilby!

One thing I noticed though is PayPal (both IPN and Express Checkout) date / time stamps are still wrong.

PayPal IPN uses server time, while PayPal Express Checkout is all over the map - I guess it uses the time zone from where the payment originates or something.

Can this be addressed by enhancing Time Zone Offset or is it a limitation of PayPal payment modules?

Thanks!

Dan G.

http://www.NotebookSolutions.ca

Never used paypal so don't know!
But if its using "server time" then it could probably be fixed in the paypal module if it stores dates in the database.
Sounds like paypal express could be a bit more difficult.

Hi!
I am using zen v1.3.7 and dd/mm/yy date format. However, after installing time zone offset, I recognised that the date format in confirmation emails of orders has been changed into yy/mm/dd format. Can anybody help me to set dd/mm/yy date format in the confirmation email? Thank you so much in advance.

bogia:

Hi!
I am using zen v1.3.7 and dd/mm/yy date format. However, after installing time zone offset, I recognised that the date format in confirmation emails of orders has been changed into yy/mm/dd format. Can anybody help me to set dd/mm/yy date format in the confirmation email? Thank you so much in advance.

Time zone offset doesn't change the date format...
Have you changed the date formats in BOTH english.php files?

gilby:

Time zone offset doesn't change the date format...
Have you changed the date formats in BOTH english.php files?
Thanks for your answer gilby. Yes, I have changed the date format in both english.php. After I installed Time Zone Offset module, the date in my website and my admin page is still shown in dd/mm/yy format. I tried to make an order and saw that the date of order (purchased date)in confirmation email before Time Zone Offset is show in D/dd/mm/yy format like Saturday 24th Feruary 2007 while one after Time Zone Offset is shown in yy/mm/dd H/M/S like 2007-02-24 15:30:25. Can you tell me why this change has occured?