<?php
  mysql_query("UPDATE users SET stad = bestemming, aankomst = '0000-00-00 00:00:00' WHERE UNIX_TIMESTAMP(aankomst) < '" . tijd() . "' AND aankomst != '0000-00-00 00:00:00'");


  //CRON
  
  $update = mysql_fetch_query("SELECT time FROM cron WHERE name = 'hour' LIMIT 1");
  $lol = $update['time'];
  
  if(tijd() - strtotime($lol) >= 3600) {
    $update = floor((tijd() - strtotime($lol)) / 3600);
    mysql_query("UPDATE users SET cash = cash + '" . (250 * $update) . "' WHERE '" . tijd() . "' - UNIX_TIMESTAMP(online) < '180'");
    mysql_query("UPDATE users SET maffia = maffia - '" . (1 * $update) . "' WHERE maffia > '0'");
    mysql_query("UPDATE users SET maffia = '0' WHERE maffia < '0'");
    mysql_query("UPDATE users SET bank = bank + bitcheswerken * '" . ($update * 15) . "'");


    mysql_query("UPDATE users SET safe = safe - '" . (1 * $update) . "' WHERE safe > '0'");
    mysql_query("UPDATE users SET safe = '0' WHERE safe < '0'");


      $selection = "";
      foreach($steden as $i => $stad) {
        $selection .= ", koersen_" . $i;
      }
    
    $drinks = mysql_query("SELECT naam" . $selection . " FROM drank");
    while($krat = mysql_fetch_array($drinks, MYSQL_ASSOC)) {
      foreach($steden as $i => $stad) {
        $krat['koersen_' . $i] = rand(500, 6000);
        mysql_query("UPDATE drank SET koersen_" . $i . " = '" . $krat['koersen_' . $i] . "' WHERE naam = '" . $krat['naam'] . "'");
      }
    }
    mysql_query("UPDATE cron SET time = '" . get_global_date("Y-m-d H") . ":00:00' WHERE name = 'hour'");
  }

<?php
// DIT BESTAND ROEPT DE SERVER ELKE UUR AAN!
$host = "localhost";
$user = "database_username";
$passwd = "database_password";
$database = "database_naam";


mysql_connect($host, $user, $passwd) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());


// HomeMissie
$Homesql = mysql_query("SELECT `staat`, `aantal`, `fam` FROM `plattegrond_fam`") or die(mysql_error());
while($Homeres = mysql_fetch_assoc($Homesql))
{
$famm = mysql_query("SELECT `dag` FROM `familie` WHERE `id`=".$Homeres['fam']) or die(mysql_error());
$fam = mysql_fetch_assoc($famm);
                if($fam['dag'] >= 7){
    $staat = $Homeres['staat'];
    $aantal = $Homeres['aantal'];


    if($staat == 1 && $aantal == 57){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
    } 
    if($staat == 2 && $aantal == 86){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
    } 
    if($staat == 3 && $aantal == 60){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
    } 
    if($staat == 4 && $aantal == 113){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
    } 
    if($staat == 5 && $aantal == 69){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
    } 
    if($staat == 6 && $aantal == 49){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
    } 
    if($staat == 7 && $aantal == 68){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
    } 
    if($staat == 8 && $aantal == 154){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$famID) or die(mysql_error());
    } 
    if($staat == 9 && $aantal == 79){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$famID) or die(mysql_error());
    } 
    if($staat == 10 && $aantal == 84){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$famID) or die(mysql_error());
    } 
    if($staat == 11 && $aantal == 119){
        mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$famID) or die(mysql_error());
    }
}
}