Page 1 of 3 123 LastLast
Results 1 to 10 of 83

Hybrid View

  1. #1
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Time Zone Fix Support Thread

    This is the official support thread for this new mod.

    This mod is available for download here: Time Zone Fix

    This module allows you to set the Server PHP and MySql time zone to your local time zone in your Zen-Cart website, if you are in a situation where your store is in a different time zone from the server on which it is hosted. (For example, your store is based in Australia but is hosted on a server in the USA.)

    This module replaces the previous Time Zone Offset mod.
    Much simpler and overwrites only 1 core file.
    When working it fixes all known Time Zone problems.

  2. #2
    Join Date
    Sep 2005
    Location
    Waikato, New Zealand
    Posts
    1,539
    Plugin Contributions
    3

    Default Re: Time Zone Fix Support Thread

    Cheers Gilby

    Works perfectly for me

    Thanks
    Webzings Design
    Semi retired from Web Design

  3. #3
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by nigelt74 View Post
    Cheers Gilby

    Works perfectly for me

    Thanks
    Good to hear.
    And, Thanks for testing the beta version for me last year

  4. #4
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Time Zone Fix Support Thread

    Gilby,

    noticed this change from the beta and the new version

    Beta Version

    PHP Code:
            // begin mod to set mysql timezone (gilby)
            
    if (getenv('TZ')) {
              @
    mysql_query("SET time_zone = '" substr_replace(date("O"),":",-2,0) . "'"$this->link);
            }
            
    // end mod to set mysql timezone (gilby) 
    New Version

    PHP Code:
            // begin mod to set mysql timezone (gilby)
              
    @mysql_query("SET time_zone = '" substr_replace(date("O"),":",-2,0) . "'"$this->link);
            
    // end mod to set mysql timezone (gilby) 
    Will this make any difference to how things work.

  5. #5
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by clydejones View Post
    Gilby,

    noticed this change from the beta and the new version

    Beta Version

    PHP Code:
            // begin mod to set mysql timezone (gilby)
            
    if (getenv('TZ')) {
              @
    mysql_query("SET time_zone = '" substr_replace(date("O"),":",-2,0) . "'"$this->link);
            }
            
    // end mod to set mysql timezone (gilby) 
    New Version

    PHP Code:
            // begin mod to set mysql timezone (gilby)
              
    @mysql_query("SET time_zone = '" substr_replace(date("O"),":",-2,0) . "'"$this->link);
            
    // end mod to set mysql timezone (gilby) 
    Will this make any difference to how things work.
    No it won't
    The beta version just checked that you had indeed set the TZ variable, hopefully to your local time.

    Removing that test still sets the mysql time to be the same as the php time.

    I used the TZ variable as it is a backwardly supported way to set the php time.

    In future you may in php5.3 set the php time a different way.
    If you do then the mysql time will still be updated.

  6. #6
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by gilby View Post
    No it won't
    The beta version just checked that you had indeed set the TZ variable, hopefully to your local time.

    Removing that test still sets the mysql time to be the same as the php time.

    I used the TZ variable as it is a backwardly supported way to set the php time.

    In future you may in php5.3 set the php time a different way.
    If you do then the mysql time will still be updated.
    OK. Many thanks.

  7. #7
    Join Date
    Nov 2010
    Posts
    37
    Plugin Contributions
    0

    Default Re: Time Zone Fix Support Thread

    this is straight-forward excellent mod for the timezone fix.

  8. #8
    Join Date
    Apr 2010
    Posts
    133
    Plugin Contributions
    0

    Default Re: Time Zone Fix Support Thread

    Hello just a few clarifications...

    In my directions it says:

    Edit this mods YOUR_RENAMED_ADMIN/includes/extra_configures/time_offset.php

    But in my folder structure as above the only file in the extra_configures folder is time_zone_fix.php

    So I assume that this is a type error in the directions. I edited the time zone as stated and logged in to my store and sure enough the time is correct!

    Now it says:

    Copy this same edited file to the front end of your store
    includes/extra_configures/time_offset.php

    Well what exactly is the "front end" of my store? (Please excuse my ignorance.)

    Are you meaning the root directory of my store?

    Anyway I have been looking for a mod like this for some time and have been patiently waiting until this came along! Thank you!

  9. #9
    Join Date
    Sep 2005
    Location
    Waikato, New Zealand
    Posts
    1,539
    Plugin Contributions
    3

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by nohart View Post
    Hello just a few clarifications...

    In my directions it says:

    Edit this mods YOUR_RENAMED_ADMIN/includes/extra_configures/time_offset.php

    But in my folder structure as above the only file in the extra_configures folder is time_zone_fix.php

    So I assume that this is a type error in the directions. I edited the time zone as stated and logged in to my store and sure enough the time is correct!

    Now it says:

    Copy this same edited file to the front end of your store
    includes/extra_configures/time_offset.php

    Well what exactly is the "front end" of my store? (Please excuse my ignorance.)

    Are you meaning the root directory of my store?

    Anyway I have been looking for a mod like this for some time and have been patiently waiting until this came along! Thank you!
    yep the root of your store

    basically yourstore . com/includes/extra_configures/time_offset.php
    Webzings Design
    Semi retired from Web Design

  10. #10
    Join Date
    Mar 2011
    Posts
    76
    Plugin Contributions
    0

    Default Re: Time Zone Fix Support Thread

    does it work for daylight saving time?
    4 times per year (server and location)

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  2. Multiple Zone Rates Support Thread
    By totalsam in forum Addon Shipping Modules
    Replies: 54
    Last Post: 24 Feb 2015, 03:34 PM
  3. v150 Time Zone Fix
    By donscotti in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 4 Nov 2012, 07:09 PM
  4. 1064 Error after installing Time Zone Fix addon
    By HFProjekte in forum General Questions
    Replies: 3
    Last Post: 6 Aug 2011, 11:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR