PHP to show arena and quest reset time

[Voldemmort]

Hello.

I'm currently using a script like this one to take from DB the Arena Reset Time and Daily and Weekly reset time to show on a PHP web.

The scripts looks like this.

   mysql_select_db($gdbchar);
       $gettime = mysql_query("SELECT NextArenaPointDistributionTime, NextDailyQuestResetTime, NextWeeklyQuestResetTime FROM saved_variables");
       $players = mysql_fetch_assoc($gettime)
?>

Arenas Distribution Date: <?php echo date('F j, Y - g:i a', $players['NextArenaPointDistributionTime']) ; ?>


Daily Quest Reset Time: <?php echo date('F j, Y - g:i a', $players['NextDailyQuestResetTime']) ; ?>


Weekly Quest Reset Time: <?php echo date('F j, Y - g:i a', $players['NextWeeklyQuestResetTime']) ; ?>

The result is that the script is showing the day of week that it is resetting, but the time isnt exact, it has difference of some minutes or even some hours of the time it is showing. For example the script say the Daily Quest will reset at 03 - 06 - 2010 - 2:00 AM, but it is resetting 03 - 06 - 2010 - 2:45 AM

Anyone know what is happening or what I have bad in my script?

[Voldemmort]

Bump.

Someone can help me please

[FunkyBit]

Just an idea...

Maybe your server time has an offset to real time?

You can tell your server to sync time with an NTP server in the web to avoid time shifts.

On linux login and type "date" to the console and see what time the machine thinks it is.

[Voldemmort]

TY for your answer =)

The only problem is.... That i use Windows , the time zone for it is setted to GMT -3

I have a function to show the actual time of the server, and the time it is showing is correct

[Mylifesuxito]

did you fix it? can you share or you already update it?

[Voldemmort]

No I have not fixed it yet

The function is as I posted in the first post, just need to add the configs and stuff like that.

[FeRkEl]

is the difference constant or variable? ( somtimes 45mins somtimes 2h ...)

[Voldemmort]

I'm not totally sure but I guess it is more or less a constant 4 hours difference.

[FeRkEl]

pls try the following Format parameter addition maybe it helps "O"

Zeitunterschied zur Greenwich time (GMT) in Stunden Beispiel: +0200