<?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'");
  }