[SOLVED] Cron Issue

[Sinikka]

Hi I'm pretty new at this so sorry if I don't come across to clearly. I'm having a problem with a cron, instead of executing the cron every 15 minutes like it's supposed to it's setting the last run for each job like it already executed and bypassing it. Here's the query that's not working correctly.

 

$dailyCron = mysql_query("SELECT * FROM cron WHERE game = '$game' AND weekly_run = '0' AND monthly_run = '0' AND (last_run is null or last_run != now())");

while ($getDailyCron = mysql_fetch_array($dailyCron))

{

$explodeCronTime = explode(":", $getDailyCron[cron_time]);

$cronHour  = $explodeCronTime[0];

$cronMin   = $explodeCronTime[1];

if ($cronHour > 12) { $cronHour -= 12; } 





if (($cronHour < $hour2) or ( $cronHour == $hour2 AND $cronMin <= $minute))

{

	$cronName = $getDailyCron[cron_name];

	$run[$cronName] = 1;

	mysql_query("UPDATE cron SET last_run = now() WHERE game = '$game' AND id = '$getDailyCron[id]'");

	mysql_query("UPDATE cron SET total_runs = total_runs + 1 WHERE game = '$game' AND id = '$getDailyCron[id]'");

}

}

[Sinikka]

Bump

[Branden Wagner]

1. Can you give me an Example row of what the query would return?

2. What is the purpose of the script? and maybe i can come up with something a little different with the same general idea

 

[Sinikka]

The purpose of the script is to restock items in shops in an online game.  The script is supposed return the row where cron_time matches the current time and then execute the corresponding program.

[Sinikka]

bump