Time Zone Offset (for v1.3.0-thru-v1.3.9d ONLY)

[rlexyd]

G'day Gilby, how's it going?

Thanks for your Time Zone Offset Mod, it's really helpfull :)

I have one question and was wondering if you can help me.

I have installed this mod on 1.3.9, everything works fine, the only problem is I replaced the includes/classes/order.php with your one, the only problem it's meant for 1.3.8.

I try to compare your file with the original to merge them, but winmerge is telling the whole files needs to be mergerd!!
I am getting a headache trying to figure it out

Can you please tell me what coding and on which line I need to add to my fresh 1.3.9 order.php file?

Hope you can help me out!

Best Regards,

[gilby]

The 1.39b update of this mod is now available for down load here
http://www.zen-cart.com/index.php?ma...roducts_id=145

As usual backup, backup, backup and test, test, test that it works for you before using on a live shop.

[gilby]

The 1.39b update of this mod works fine with zen-cart v1.3.9c
No update will be required for this mod.

http://www.zen-cart.com/index.php?ma...roducts_id=145

As usual backup, backup, backup and test, test, test that it works for you before using on a live shop.

[gilby]

The 1.39d update of this mod is now available for down load here
http://www.zen-cart.com/index.php?ma...roducts_id=145

As usual backup, backup, backup and test, test, test that it works for you before using on a live shop.

[totalsam]

Hey,

Having problems getting this to work entirely.

All seems fine except when I update an order it puts the server time in instead of my time

When purchases are made the time is updated correctly.

I am using super orders but it doesn't work if I update the status on standard orders either.

I presume there is something in the script for super_orders.php which I haven't added can someone confirm where all the super_orders edits need to go and I can check they are there?

(Or any other possible solutions would also make me happy )

Thanks
Sam

[gilby]

Hey,

Having problems getting this to work entirely.

All seems fine except when I update an order it puts the server time in instead of my time

When purchases are made the time is updated correctly.

I am using super orders but it doesn't work if I update the status on standard orders either.

I presume there is something in the script for super_orders.php which I haven't added can someone confirm where all the super_orders edits need to go and I can check they are there?

(Or any other possible solutions would also make me happy )

Thanks
Sam

See Post# 111

[totalsam]

Thanks!

The bit of code that needed changing from

now() 

to

date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR) 

was in admin/includes/functions/extra_functions/super_orders_functions.phpfor any one else that is looking for it!

[superprg]

I am having problems getting the right timestamp for the paypal orders
I already edited the file paypalwpp.php

Also,when I edit the ipn_main_handler.php
from following line

'date_added' => 'now()',

TO

date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR)

All I see in my order history in admin is this time - date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR)
Any clue on whats going on wrong? I separately ran the query in the php file and it seems to be returning the correct time

[superprg]

the debug file shows

[orders_id] => 786
[orders_status_id] => 2
[date_added] => date_add(now(), INTERVAL 10 HOUR)
[comments] => PayPal status: Completed @ 17:03:22 Aug 03, 2010 PDT
Trans ID:2V030092FA8415611
Amount: 0.97 AUD
[customer_notified] => 0

which means everything should be correct??

[gilby]

I am having problems getting the right timestamp for the paypal orders
I already edited the file paypalwpp.php

Also,when I edit the ipn_main_handler.php
from following line

'date_added' => 'now()',

TO

date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR)

All I see in my order history in admin is this time - date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR)
Any clue on whats going on wrong? I separately ran the query in the php file and it seems to be returning the correct time

Maybe try this instead for that line

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