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

**gilby** · 5 Jun 2006, 02:15 PM

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.

**gilby** · 21 Sep 2006, 04:05 AM

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

**lucidlee** · 26 Sep 2006, 02:48 AM

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

**gilby** · 26 Sep 2006, 06:53 AM

Originally Posted by 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

**ronlee67** · 29 Sep 2006, 08:11 PM

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?

Code:

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 -

**ronlee67** · 29 Sep 2006, 08:15 PM

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 -

**siege** · 19 Oct 2006, 07:59 AM

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.

**gilby** · 19 Oct 2006, 12:48 PM

Originally Posted by 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.

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.

**siege** · 20 Oct 2006, 03:39 AM

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.