Time Zone Offset - Adjust to match your location

[mel77]

I found this contibution which I'm sure will be helpfull for many people.

 

It just needs someone to help with the code so that it also updates the order confirmation and order status update emails (code is located in checkout_process.php).

 

Is anyone able to help with this?

 

http://www.oscommerce.com/community/contri...earch,time+zone

[Guest]

in the catalog checkout_process.php change:

 

'date_purchased' => 'now()',

to

 

'date_purchased' => date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR),

 

 

and further down change

'date_added' => 'now()',

 

to

'date_added' => date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR),

just define the time difference.

[klarsen]

So, can this same change be made in other files also? Say some of the admin files? in the Helpdesk contribution? The Order Edit contribution? etc.?

 

Of course, I'm assuming that the original code is exactly like this, but I guess the principle can be used elsewhere?

 

 

 

in the catalog checkout_process.php change:

 

'date_purchased' => 'now()',

to

 

'date_purchased' => date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR),

and further down change

'date_added' => 'now()',

 

to

'date_added' => date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR),

just define the time difference.

[Guest]

yes those changes are basically for the sql queries. The particular contribution also shows how to adjust the time for the php statements.

[mel77]

enigma1, I made the changes you suggested but now I get a blank page when I click on "confirm order" during the checkout process??

[Guest]

yea I think I missed the quotes around it

 

'date_purchased' => 'date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR)',

 

and define the TIME_ZONE_OFFSET as the hour difference