mel77 Posted June 23, 2006 Share Posted June 23, 2006 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted July 11, 2006 Share Posted July 11, 2006 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. Quote Link to comment Share on other sites More sharing options...
klarsen Posted July 12, 2006 Share Posted July 12, 2006 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2006 Share Posted July 13, 2006 yes those changes are basically for the sql queries. The particular contribution also shows how to adjust the time for the php statements. Quote Link to comment Share on other sites More sharing options...
mel77 Posted July 15, 2006 Author Share Posted July 15, 2006 enigma1, I made the changes you suggested but now I get a blank page when I click on "confirm order" during the checkout process?? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 15, 2006 Share Posted July 15, 2006 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.