Hallo allemaal ik ben begonnen met mijn eigen criminals.
Nu heb ik de crons gemaakt maar nu telt hij elke seconde de rente bij contant en bank geld
dit moet eigenlijk elk uur doen
dit is mijn cron
PHP
<?php
$lastupdate = $sql->query("SELECT online FROM users ORDER BY online DESC LIMIT 1");
$lastupdate = $sql->fetch($lastupdate, assoc);
$lastupdate = strtotime($lastupdate['online']);
$sec = strtotime(date("Y-m-d H", $lastupdate) . "00:00:00");
$verschil = floor((time() - $sec) / 1);
//sec:
if($verschil > 100) {
$sql->query("UPDATE users SET health = '100'");
}
$hour = strtotime(date("Y-m-d H", $lastupdate) . "00:00:00");
$verschil = floor((time() - $hour) / 3600);
//HOUR:
if($verschil > 0) {
$sql->query("UPDATE users SET veilig = veilig - '" . $verschil . "' WHERE veilig > '" . $verschil . "'");
$sql->query("UPDATE users SET veilig = '0' WHERE veilig <= '" . $verschil . "'");
$sql->query("UPDATE users SET maffia = maffia - '" . $verschil . "' WHERE maffia > '" . $verschil . "'");
$sql->query("UPDATE users SET maffia = '0' WHERE maffia <= '" . $verschil . "'");
$sql->query("UPDATE users SET bank = bank + '" . ($verschil * 250) . "'") or die(mysql_error());
$sql->query("UPDATE users SET bank = bank + '" . ($verschil * 250) . "' WHERE betaald > '0'") or die(mysql_error());
$sql->query("UPDATE users SET cash = cash + '" . ($verschil * 500) . "' WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(online) <= '180'") or die(mysql_error());
//DRUGS EN DRANK:
$drugs = $sql->query("SELECT resetvalue, stad, naam FROM koersen");
while($drug = $sql->fetch($drugs, assoc)) {
$values = explode(', ', $drug['resetvalue']);
$sql->query("UPDATE koersen SET koers = '" . rand($values[0], $values[1]) . "' WHERE resetvalue = '" . $drug['resetvalue'] . "' AND stad = '" . $drug['stad'] . "' AND naam = '" . $drug['naam'] . "'") or die(mysql_error());
}
}
//DAY:
$day = strtotime(date("Y-m-d", $lastupdate) . " 00:00:00");
$verschil = floor((time() - $day) / 86400);
if($verschil > 0) {
$sql->query("UPDATE users SET betaald = betaald - '" . $verschil . "' WHERE betaald > '" . $verschil . "'");
$sql->query("UPDATE users SET betaald = '0' WHERE betaald <= '" . $verschil . "'");
$sql->query("UPDATE users SET vakantie = vakantie - '" . $verschil . "' WHERE vakantie > '" . $verschil . "'");
$sql->query("UPDATE users SET vakantie = '0' WHERE vakantie <= '" . $verschil . "'");
$sql->query("UPDATE users SET respect_uitdelen = respect_uitdelen + '" . $verschil . "'");
$sql->query("UPDATE users SET bank = bank + (bank * '0.10') * '" . $verschil . "' WHERE rentedagen > '0'");
$sql->query("UPDATE users SET bank = bank + (bank * '0.05') * '" . $verschil . "' WHERE rentedagen <= '0' AND betaald > '0'");
$sql->query("UPDATE users SET bank = bank + (bank * '0.03') * '" . $verschil . "' WHERE rentedagen <= '0' AND betaald <= '0'");
$sql->query("UPDATE users SET rentedagen = rentedagen - '" . $verschil . "' WHERE rentedagen > '" . $verschil . "'");
$sql->query("UPDATE users SET rentedagen = '0' WHERE rentedagen <= '" . $verschil . "'");
$sql->query("UPDATE users SET roulette = '0'");
$sql->query("UPDATE users SET nederwiet = nederwiet + nederwietup");
$sql->query("UPDATE users SET xtc = xtc + xtcup");
$sql->query("UPDATE users SET lsd = lsd + lsdup");
$sql->query("UPDATE users SET speed = speed + speedup");
$sql->query("UPDATE users SET opium = opium + opiumup");
$sql->query("UPDATE users SET storten = stortenreset");
$sql->query("DELETE FROM clicks WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(datum) >= '432000'");
$sql->query("DELETE FROM berichten WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(datum) >= '432000'");
$sql->query("DELETE FROM attacklog WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(datum) >= '432000'");
}
$week = strtotime(date("Y-m-d H", $lastupdate) . "00:00:00");
$verschil = floor((time() - $week) / 604800);
//week:
if($verschil <= 0) {
$sql->query("UPDATE users SET health = '100'");
}
Toon Meer
Wat doe ik fout?