Page 1 of 9 123 ... LastLast
Results 1 to 10 of 83
  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
    Jan 2011
    Posts
    70
    Plugin Contributions
    0

    Default Re: Time Zone Fix Support Thread

    Hi, just wanted to add my thanks for this mod. An elegant solution and much appreciated.

  8. #8
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: Time Zone Fix Support Thread

    Yep, works like a charm. Thanks for your contribution!
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  9. #9
    Join Date
    Feb 2011
    Posts
    2
    Plugin Contributions
    0

    Default Re: Time Zone Fix Support Thread

    Is very good and easy. Many thanks

  10. #10
    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.

 

 
Page 1 of 9 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