cron

cri

Beste CP'ers

Na een eindje afwezig zijn heb ik een vraagje waar ik maar niet aan uit kan, het levert telkens fouten op mijn site door fout in cron:

PHP

$dbres                              = mysql_query("SELECT * FROM `cron`");
    while($x = mysql_fetch_object($dbres))
      $update[$x->name]         = $x->time;
    if(floor($update['hour']/3600) <= floor(time()/3600)) {
      $dbres                            = mysql_query("SELECT GET_LOCK('hour_update',0)");
      if(mysql_result($dbres,0) == 1) {
        $cron_pass                      = "secret";
        mysql_query("SELECT RELEASE_LOCK('hour_update')");
$datum1 = (date("Y-m-d H"));
$datum = time()+3600;
mysql_query("UPDATE `cron` SET `time`='$datum' WHERE `name`='hour'");
$drank1 = rand(250,350);
$drank2 = rand(250,350);
$drank3 = rand(250,350);
$drank4 = rand(250,350);
$drank5 = rand(250,350);
$drank6 = rand(250,350);
$nederwietrand1 = rand(600,1300);
$nederwietrand2 = rand(600,1300);
$nederwietrand3 = rand(600,1300);
$nederwietrand4 = rand(600,1300);
$nederwietrand5 = rand(600,1300);
$nederwietrand6 = rand(600,1300);
$paddorand1 = rand(1500,2200);
$paddorand2 = rand(1500,2200);
$paddorand3 = rand(1500,2200);
$paddorand4 = rand(1500,2200);
$paddorand5 = rand(1500,2200);
$paddorand6 = rand(1500,2200);
$xtcrand1 = rand(2500,3100);
$xtcrand2 = rand(2500,3100);
$xtcrand3 = rand(2500,3100);
$xtcrand4 = rand(2500,3100);
$xtcrand5 = rand(2500,3100);
$xtcrand6 = rand(2500,3100);
$lsdrand1 = rand(3400,4000);
$lsdrand2 = rand(3400,4000);
$lsdrand3 = rand(3400,4000);
$lsdrand4 = rand(3400,4000);
$lsdrand5 = rand(3400,4000);
$lsdrand6 = rand(3400,4000);
$speedrand1 = rand(4000,4600);
$speedrand2 = rand(4000,4600);
$speedrand3 = rand(4000,4600);
$speedrand4 = rand(4000,4600);
$speedrand5 = rand(4000,4600);
$speedrand6 = rand(4000,4600);
$opiumrand1 = rand(4500,5000);
$opiumrand2 = rand(4500,5000);
$opiumrand3 = rand(4500,5000);
$opiumrand4 = rand(4500,5000);
$opiumrand5 = rand(4500,5000);
$opiumrand6 = rand(4500,5000);
$pruimtabak1 = rand(600,1300);
$pruimtabak2 = rand(600,1300);
$pruimtabak3 = rand(600,1300);
$pruimtabak4 = rand(600,1300);
$pruimtabak5 = rand(600,1300);
$pruimtabak6 = rand(600,1300);
$vannelle1 = rand(1500,2200);
$vannelle2 = rand(1500,2200);
$vannelle3 = rand(1500,2200);
$vannelle4 = rand(1500,2200);
$vannelle5 = rand(1500,2200);
$vannelle6 = rand(1500,2200);
$drum1 = rand(2500,3100);
$drum2 = rand(2500,3100);
$drum3 = rand(2500,3100);
$drum4 = rand(2500,3100);
$drum5 = rand(2500,3100);
$drum6 = rand(2500,3100);
$lm1 = rand(3400,4000);
$lm2 = rand(3400,4000);
$lm3 = rand(3400,4000);
$lm4 = rand(3400,4000);
$lm5 = rand(3400,4000);
$lm6 = rand(3400,4000);
$kent1 = rand(4000,4600);
$kent2 = rand(4000,4600);
$kent3 = rand(4000,4600);
$kent4 = rand(4000,4600);
$kent5 = rand(4000,4600);
$kent6 = rand(4000,4600);
$panter1 = rand(4500,5000);
$panter2 = rand(4500,5000);
$panter3 = rand(4500,5000);
$panter4 = rand(4500,5000);
$panter5 = rand(4500,5000);
$panter6 = rand(4500,5000);
mysql_query("UPDATE `stad` SET `drankp`='$drank1' WHERE `stad`='1'");
mysql_query("UPDATE `stad` SET `drankp`='$drank2' WHERE `stad`='2'");
mysql_query("UPDATE `stad` SET `drankp`='$drank3' WHERE `stad`='3'");
mysql_query("UPDATE `stad` SET `drankp`='$drank4' WHERE `stad`='4'");
mysql_query("UPDATE `stad` SET `drankp`='$drank5' WHERE `stad`='5'");
mysql_query("UPDATE `stad` SET `drankp`='$drank6' WHERE `stad`='6'");
mysql_query("UPDATE `drugskoers` SET `nederwiet`='$nederwietrand1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `nederwiet`='$nederwietrand2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `nederwiet`='$nederwietrand3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `nederwiet`='$nederwietrand4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `nederwiet`='$nederwietrand5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `nederwiet`='$nederwietrand6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `paddo`='$paddorand1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `paddo`='$paddorand2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `paddo`='$paddorand3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `paddo`='$paddorand4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `paddo`='$paddorand5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `paddo`='$paddorand6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `xtc`='$xtcrand1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `xtc`='$xtcrand2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `xtc`='$xtcrand3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `xtc`='$xtcrand4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `xtc`='$xtcrand5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `xtc`='$xtcrand6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `lsd`='$lsdrand1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `lsd`='$lsdrand2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `lsd`='$lsdrand3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `lsd`='$lsdrand4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `lsd`='$lsdrand5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `lsd`='$lsdrand6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `speed`='$speedrand1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `speed`='$speedrand2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `speed`='$speedrand3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `speed`='$speedrand4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `speed`='$speedrand5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `speed`='$speedrand6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `opium`='$opiumrand1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `opium`='$opiumrand2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `opium`='$opiumrand3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `opium`='$opiumrand4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `opium`='$opiumrand5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `opium`='$opiumrand6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `pruimtabak`='$pruimtabak1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `pruimtabak`='$pruimtabak2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `pruimtabak`='$pruimtabak3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `pruimtabak`='$pruimtabak4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `pruimtabak`='$pruimtabak5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `pruimtabak`='$pruimtabak6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `vannelle`='$vannelle1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `vannelle`='$vannelle2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `vannelle`='$vannelle3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `vannelle`='$vannelle4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `vannelle`='$vannelle5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `vannelle`='$vannelle6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `drum`='$drum1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `drum`='$drum2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `drum`='$drum3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `drum`='$drum4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `drum`='$drum5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `drum`='$drum6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `lm`='$lm1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `lm`='$lm2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `lm`='$lm3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `lm`='$lm4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `lm`='$lm5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `lm`='$lm6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `kent`='$kent1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `kent`='$kent2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `kent`='$kent3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `kent`='$kent4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `kent`='$kent5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `kent`='$kent6' WHERE `land`='6'");
mysql_query("UPDATE `drugskoers` SET `panter`='$panter1' WHERE `land`='1'");
mysql_query("UPDATE `drugskoers` SET `panter`='$panter2' WHERE `land`='2'");
mysql_query("UPDATE `drugskoers` SET `panter`='$panter3' WHERE `land`='3'");
mysql_query("UPDATE `drugskoers` SET `panter`='$panter4' WHERE `land`='4'");
mysql_query("UPDATE `drugskoers` SET `panter`='$panter5' WHERE `land`='5'");
mysql_query("UPDATE `drugskoers` SET `panter`='$panter6' WHERE `land`='6'");
mysql_query("UPDATE `users` SET `safe`=`safe`-'1' WHERE `safe`>'0'");
mysql_query("UPDATE `users` SET `maffia`=`maffia`-'1' WHERE `maffia`>'0'");
mysql_query("UPDATE `users` SET `safe`='0' WHERE `safe`<'0'");
mysql_query("UPDATE `users` SET `killers`=`killers`+`untlevel`");
mysql_query("UPDATE `users` SET `maffia`='0' WHERE `maffia`<'0'");
mysql_query("UPDATE `users` SET `aangevallen`='0'");
mysql_query("UPDATE `users` SET `jointtijd`='0'");
mysql_query("UPDATE `users` SET `autorace`='0'");
mysql_query("UPDATE `users` SET `scooterrace`='0'");
mysql_query("UPDATE `users` SET `krak`='0'");
mysql_query("UPDATE `users` SET `nederlandrace`='0'");
mysql_query("UPDATE `users` SET `bank`=`bank`+`hoerenhuis`*'500'");
mysql_query("UPDATE `users` SET `contant`=`contant`+`stripclub`*800 WHERE `stripclub`>0");
mysql_query("UPDATE `users` SET `contant`=`contant`+'250',`bank`=`bank`+'250' WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
$geld                		= $data2->hoeren;
$geld2                      = $geld*5;
$geld3               		= $data2->hoerenwerkend;
$geld4                      = $geld*15;
$geld5                      = $geld4+$geld2;
$inkomen                    = $geld5;
mysql_query("UPDATE `users` SET `bank`=`bank`+'$inkomen' WHERE `hoeren`>'0'");
mysql_query("UPDATE `users` SET `hoerpimped`='0'");
}}?>

Toon Meer

Nu zou ik dit erin willen voegen, maar alles wat ik probeerde liep fout en hoop dat iemand mij kan helpen eventueel:

PHP

$dbres				= mysql_query("SELECT * FROM `families` WHERE `nachtclub` > 0");
  while($clan = mysql_fetch_object($dbres)) {
    if($clan->soort == 1)
      mysql_query("UPDATE `users` SET `cash`=`cash`+". (50*$clan->nachtclub) .",`bank`=`bank`+". (150*$clan->nachtclub) ." WHERE `clan`='{$clan->naam}'");
  }

Alvast bedankt

cri

Steeds zoekend:S

Dein

Probeer het zo eens:

PHP

$dbres                = mysql_query("SELECT * FROM `families` WHERE `nachtclub` > 0"); 
  while($clan = mysql_fetch_object($dbres)) { 
    if($clan->soort == 1) {
$nachtclub50 = 50 * $clan->nachtclub;
$nachtclub50 = 150 * $clan->nachtclub;
      mysql_query("UPDATE `users` SET `cash`=`cash`+ ".$nachtclub150.",`bank`=`bank`+ ".$nachtclub150." WHERE `clan`='".$clan->naam."'"); 
  }}

cri

Bedankt Dein voor de reactie, is reeds opgelost
:slotje:

Dein

Youre welcome!
:slotje:

ICTscripters

Dé plek voor IT

Dé plek voor IT

Developer Gezocht

Afspraken systeem met planbeperking

Na 15 jaar terug van weggeweest: iCriminals.nl is terug (BETA)!

Op zoek naar de legends

[FREE] WeFact Hosting module

Help testers nodig voor android app Urgent

Versio vervanger

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Meerdere mafia game template te koop

Verschillende domeinnamen los te koop

Verschillende domeinen

cron

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2