Mijn cron_day doet het niet, mijn cron_hour overigens wel dus het kan niet aan m`n host liggen.
Heeft iemand hier mischien een oplossing voor?
PHP
<?php /* ------------------------- */
if($cron_pass != "secretcronpassword")
exit;
mysql_query("TRUNCATE TABLE `backup-[users]`");
mysql_query("OPTIMIZE TABLE `backup-[users]`");
mysql_query("INSERT INTO `backup-[users]` SELECT * FROM `[users]`");
mysql_query("UPDATE `[users]` SET `bankleft`=3 WHERE (`attack`+`defence`)/2 > 10000");
mysql_query("UPDATE `[users]` SET `bankleft`=4 WHERE (`attack`+`defence`)/2 < 10000");
mysql_query("UPDATE `[users]` SET `bankleft`=5 WHERE (`attack`+`defence`)/2 < 5000");
mysql_query("UPDATE `[users]` SET `moordbescherming`=0 WHERE `activated`=1");
mysql_query("UPDATE `[users]` SET `bank`=`bank`*1.05,`clickstoday`=0");
mysql_query("UPDATE `[users]` SET `ocsdoen`=`ocsdoen`2 WHERE `activated`=1");
mysql_query("UPDATE `[users]` SET `bank`=`bank`+10 WHERE `trouw`=1");
mysql_query("UPDATE `[clans]` SET `bank`=`bank`*1.05,`bankleft`=10,`clickstoday`=0");
mysql_query("UPDATE `[users]` SET `moordg`=3");
mysql_query("UPDATE `[users]` SET `bankpogingen`='0'");
mysql_query("UPDATE `[stadowner]` SET `gevang`=3");
mysql_query("UPDATE `[stadowner]` SET `gevanguit`=3");
mysql_query("UPDATE `[users]` SET `nederwiet`=`nederwiet`+1 WHERE `nederwiet` < 20");
mysql_query("UPDATE `[users]` SET `xtc`=`xtc`+1 WHERE `xtc` < 20");
mysql_query("UPDATE `[users]` SET `lsd`=`lsd`+1 WHERE `lsd` < 20");
mysql_query("UPDATE `[users]` SET `speed`=`speed`+1 WHERE `speed` < 20");
mysql_query("UPDATE `[users]` SET `paddo`=`paddo`+1 WHERE `paddo` < 20");
mysql_query("UPDATE `[users]` SET `opium`=`opium`+1 WHERE `opium` < 20");
mysql_query("UPDATE `[users]` SET `rp`=`rp`+'10'");
mysql_query("UPDATE `[users]` SET `vip`=`vip`-1 WHERE `vip`> 0"):
mysql_query("UPDATE `[users]` SET `joint`=`joint`+2000 WHERE `plantage`=1");
mysql_query("UPDATE `[users]` SET `joint`=`joint`+4000 WHERE `plantage`=2");
mysql_query("UPDATE `[users]` SET `joint`=`joint`+6000 WHERE `plantage`=3");
mysql_query("UPDATE `[users]` SET `joint`=`joint`+8000 WHERE `plantage`=4");
mysql_query("UPDATE `[users]` SET `joint`=`joint`+10000 WHERE `plantage`=5");
mysql_query("UPDATE `[users]` SET `joint`=`joint`+12000 WHERE `plantage`=6");
mysql_query("DELETE FROM `[logs]` WHERE `area`='click'");
mysql_query("UPDATE `[users]` SET `energie`=`energie`-5'");
mysql_query("OPTIMIZE TABLE `[clans]`");
mysql_query("OPTIMIZE TABLE `[logs]`");
mysql_query("OPTIMIZE TABLE `[temp]`");
mysql_query("OPTIMIZE TABLE `[users]`");
/* ------------------------- */ ?>
Toon Meer
en in me config heb ik dit
PHP
if(floor($update['day']/86400) != floor(time()/86400)) {
$dbres = mysql_query("SELECT GET_LOCK('day_update',0)");
if(mysql_result($dbres,0) == 1) {
$cron_pass = "secretcronpassword";
mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='day'");
include("_cron_day.php");
mysql_query("SELECT RELEASE_LOCK('day_update')");
Iemand mischien een oplossing ?
Mvg,
Sander