Little Bit Of Cron Help

[HITMAN 17]

can someone help make it so donators brave goes up every 5mins and non donators go up every 10mins?

As I Aint To Good With Crons

[Isomerizer]

Re: Little Bit Of Cron Help

 

$SQL = "UPDATE `users` SET `brave` = `brave` + 5 WHERE `brave` < 100 AND `donatordays` < 1";
$SQL_2 = "UPDATE `users` SET `brave` = `brave` + 10 WHERE `brave` < 100 AND `donatordays` > 0";
mysql_query($SQL);
mysql_query($SQL_2);

 

This isn't based on the actual ticks, but it should do...

[gurpreet]

Re: Little Bit Of Cron Help

 

$SQL = "UPDATE `users` SET `brave` = `brave` + 5 WHERE `brave` < 100 AND `donatordays` < 1";
$SQL_2 = "UPDATE `users` SET `brave` = `brave` + 10 WHERE `brave` < 100 AND `donatordays` > 0";
mysql_query($SQL);
mysql_query($SQL_2);

 

This isn't based on the actual ticks, but it should do...

Wouldn't you increase the WHERE 'brave' < 100 for higher levels? I think level 49 and above have more than 100 brave...

$SQL = "UPDATE `users` SET `brave` = `brave` + 5 WHERE `brave` < 1000 AND `donatordays` < 1";

$SQL_2 = "UPDATE `users` SET `brave` = `brave` + 10 WHERE `brave` < 1000 AND `donatordays` > 0";

That should cover into the level 400's.

[Haunted Dawg]

Re: Little Bit Of Cron Help

OR..

 

$sql[1] = 'UPDATE `users` SET `brave` = `brave` + 5 WHERE `brave` < `maxbrave` AND `donatordays` < 1';
$sql[2] = 'UPDATE `users` SET `brave` = `brave` + 10 WHERE `brave` < `maxbrave` AND `donatordays` > 0';
mysql_query($sql[1]);
mysql_query($sql[2]);

[Lithium]

Re: Little Bit Of Cron Help

Seems no one READ the first post.

Basicly, to simplify, you will need to run in this examples, killah's query for non donators on a 5minutes cron (0/5 * * * *)

$sql[1] = 'UPDATE `users` SET `brave` = `brave` + 5 WHERE `brave` < `maxbrave` AND `donatordays` < 1';

mysql_query($sql[1]);

and donators query on a 10 minute cron (0/10 * * * *)

$sql[2] = 'UPDATE `users` SET `brave` = `brave` + 10 WHERE `brave` < `maxbrave` AND `donatordays` > 0';

mysql_query($sql[2]);

:)