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?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
<?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]`");
/* ------------------------- */ ?>
|
|
|
en in me config heb ik dit
1
2
3
4
5
6
7
|
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
Laatst gewijzigd door sander-301 op 2010-09-15 22:53:38
15-09-2010 22:52
Dit topic is 141 keer bekeken door 37 verschillende leden
Reacties op: "Cron_day"
1
