Supertracker

[alexhigh]

1. In sql replace
NOW()
by
date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR)
2. Replace
$thirty_mins_ago = date('Y-m-d H:i:s', (time() - (30*60)));
by
$thirty_mins_ago = date('Y-m-d H:i:s', (time()+TIME_ZONE_OFFSET*60*60 - (30*60)));

Hi, this time offset 60*60 business confuses me a bit, could someone explain how I might go about adding 4 hours to the times reported so that its inline with UK time?

Any help with this would be appreciated