Time Zone Offset Problem

[gilby]

Hey,

So how would you integrate this with ZC. I know the Time Zone Offset mod used MySQL functions to change the date, but there is apparently a better way to do it with php now pho has improved. Anyone got any ideas how to do this?

There is 2 parts
Setting the php time
and fixing the mysql time

This mod is designed to adjust the mysql database time

The php time can be set with the set TZ=(your country/city)

[badger64]

Hi all

I know this thread is abit old but my host is based in the states and I'm in the uk.

Put this code in the .htaccess in the root of your site.

SetEnv TZ Europe/London

Works for me. Hope it helps.

Rgds
Badger

[bear1728]

this mod is so useful, i wonder if i could also set the time of reviews to my local time just as what it does to create_account and customer_order ?

[bear1728]

i use zencart 1.38a, do i need to update time zone offset mod to the newest version published on may 2nd 2010 ?

[gilby]

this mod is so useful, i wonder if i could also set the time of reviews to my local time just as what it does to create_account and customer_order ?

The basic process is here
http://www.zen-cart.com/forum/showpo...&postcount=111

Just find the relevent files that apply to your situation to alter

[gilby]

i use zencart 1.38a, do i need to update time zone offset mod to the newest version published on may 2nd 2010 ?

No you don't
Use the files for 1.38a

[bear1728]

thanks
then what do i set the customer reviews time to my local time?

[bear1728]

i didn't notice your first response to my questions

i check that post then, i find totally 2 now() concerning reviews

/admin/reviews.php
Line #30 : last_modified = now() where reviews_id = '" . (int)$reviews_id . "'");

/includes/modules/pages/product_reviews_write/header_php.php
VALUES (roductsID, :customersID, :customersName, :rating, now(), " . $review_status . ")";

i should modify these 2 now() above? or any other files i need to modify?

[gilby]

i didn't notice your first response to my questions

i check that post then, i find totally 2 now() concerning reviews

/admin/reviews.php
Line #30 : last_modified = now() where reviews_id = '" . (int)$reviews_id . "'");

/includes/modules/pages/product_reviews_write/header_php.php
VALUES (roductsID, :customersID, :customersName, :rating, now(), " . $review_status . ")";

i should modify these 2 now() above? or any other files i need to modify?

I have never used reviews so have never had the need to alter these.
The 2 lines look right so try it and see if it works correctly for you

[bear1728]

i modified those 2 files, it works