now() [SOLVED]

[Tom]

Where is this defined? It doesn't seem to be a php function and I want to change it so all the dates recorded are GMT.

I've already set the php default timezone to GMT in local.config.php, however this doesn't seem to affect now();

How can I change it?

Thanks

[Guest lorathon]

NOW() is a MySql function. You need to change it to UTC_TIMESTAMP()for GMT/Zulu/UTC

[Tom]

Oh right it's MySQL. Thanks, I've changed it to php date any way

[Guest lorathon]

NP

[Nabeel]

I have this on the list of things to convert into a setting

[Tom]

Oh ok thanks Nabeel!

I've probably missed a few instances of it anyway

[savagegrave]

Hi Guys,

Im trying to get the departure board on my site (www.imgvirtual.com) to show the "actual" dep time according to kacars or fsacars...

Changing the NOW() function in AcarsData.Class.php to UTC_TIMESTAMP() changed the lastupdated field in the acars table however not the deptime/arrtimes. These are still in EST and not UTC which i would like.

I can see the code uses a mix of FROM_UNIXTIME() and time() functions, even placing

date_default_timezone_set("UTC");

at the start of the function doesnt seem to change these fields....

any pointers?

[Tom]

Instead of 'NOW()' I've used:

'".date('Y-m-d H:i:s')."'

And then to set your time zone put the following in local.config.php (applies it to all scripts then):

date_default_timezone_set('Europe/London');

[Nabeel]

deptime and arrtime are from the ACARS app. I have no indication of what timezone they are in, so you'll have to see how they send it, and adjust for that

[savagegrave]

ty for your help guys, will have a play over the w/e and see what i can come up with lol