<?php
echo'
<div id="content_top"> </div>


		<div id="content">


<h1 class="titel">Station</h1>
<center><img src="images/amerika.jpg"></center><br />
  <hr />';
  if(@$_GET['action'] == "cancel") {
    mysql_query("UPDATE users SET aankomst = '0000-00-00 00:00:00' WHERE id = '" . $own['id'] . "'");
    $own['aankomst'] = get_global_date("Y-m-d H:i:s");
  }


  if(strtotime($own['aankomst']) > tijd()) {
    echo "<div class=\"dark\">Je bent momenteel op reis naar <b>" . $steden[$own['bestemming']] . "</b>. Je arriveert om " . date("H:i", strtotime($own['aankomst'])) . ".<br />
          <a href=\"index.php?p=station&action=cancel\">Klik hier om de reis te annuleren</a>. Je bent je geld in dat geval kwijt.</div><br />";
    $disable = "disabled title=\"Je bent al op reis\"";
  } else {
  
  if(isset($_POST['submit']) && isset($_POST['city']) && !empty($steden[$_POST['city']])) {


    echo'<div class="dark">';
    
    $station = mysql_fetch_query("SELECT prijs FROM stations WHERE stad = '" . $_POST['city'] . "'");
    $owner = mysql_fetch_query("SELECT id FROM users LEFT JOIN stations ON (users.id = stations.eigenaar) WHERE stations.stad = '" . $_POST['city'] . "' AND users.id = stations.eigenaar");
    if(!empty($owner) && $owner['id'] == $own['id']) {
      $kosten = 0;
    } else {
      $kosten = (!empty($station['prijs'])) ? ($station['prijs']) : (15000);
    }
    if($own['cash'] >= $kosten) {
      if($own['stad'] != $_POST['city']) {
        $aankomst = get_global_date("i");
        if($aankomst < 30) {
          $tijd = tijd() - (get_global_date("i") * 60) - get_global_date("s") + (30 * 60);
          $aankomst = date("Y-m-d H:i:s", $tijd);
        } else {
          $tijd = strtotime(get_global_date("Y-m-d H:") . "30:00") + (30 * 60);
          $aankomst = date("Y-m-d H:i:s", $tijd);
        }
        echo "<font color=\"green\" style=\"font-weight: bold\">Je bent ingestapt in de trein naar " . $steden[$_POST['city']] . ". De trein zal arriveren om " . date("H:i", strtotime($aankomst)) . ". Een prettige reis gewenst!</font>";
        mysql_query("UPDATE users SET bestemming = '" . $_POST['city'] . "', aankomst = '" . $aankomst . "', cash = cash - '" . $kosten . "' WHERE id = '" . $own['id'] . "'");
        mysql_query("UPDATE users SET bank = bank + '" . $kosten . "' WHERE id = '" . @$owner['id'] . "'");
        $own['cash'] -= $kosten;
      } else {
        echo "<font color=\"red\" style=\"font-weight: bold\">Je zit al in " . $steden[$_POST['city']] . "!</font>";
     }
     
   } else {
     echo "<font color=\"red\" style=\"font-weight: bold\">Je hebt helaas niet genoeg geld om de trein naar " . $steden[$_POST['city']] . " te nemen.</font>";
   }
   echo'</div><br />';
 }
 }
  
  $owner = mysql_fetch_query("SELECT login FROM users LEFT JOIN stations ON (users.id = stations.eigenaar) WHERE stations.stad = '" . $own['stad'] . "' AND users.id = stations.eigenaar");
  $eigenaar = (!empty($owner)) ? ($owner['login']) : ("niemand");
  echo'
  Met het station kun je naar andere landen reizen. Elk half uur vertrekt er een trein uit ' . $steden[$own['stad']] . '.<br />
  De eigenaar van dit station is <b>' . $eigenaar . '</b>.<br />
  Hieronder staan de stations van ' . gamenaam . ' (met hun eigenaren en reiskosten) in een tabelletje weergegeven.<br /><br />
  
  <form method="post">
  <table width="100%" cellspacing="0" cellpadding="0">
    <tr>
      <td class="start" width="16">&nbsp;</td>
      <td class="start">Stad</td>
      <td class="start">Eigenaar</td>
      <td class="start">Reiskosten</td>
      <td class="start">Inwoners</td>
    </tr>';


  foreach($steden as $i => $stad) {
    $owner = mysql_fetch_query("SELECT id FROM users LEFT JOIN stations ON (users.id = stations.eigenaar) WHERE stations.stad = '" . $i . "' AND users.id = stations.eigenaar");
    $station = mysql_fetch_query("SELECT prijs FROM stations WHERE stad = '" . $i . "'");
    $eigenaar = (!empty($owner)) ? ('<a href="index.php?p=profile&uid=' . $owner['id'] . '">' . special_check($owner['id']) . '</a>') : ("niemand");
    if(@$owner['id'] == $own['id']) {
      $stad = '<a href="index.php?p=station_manage&city=' . $i . '" title="Klik hier om je station te beheren">' . $stad . '</a>';
    }
    
    if(empty($station['prijs'])) {
      $station['prijs'] = 15000;
    }
    echo'
      
    <tr>
      <td class="list"><input type="radio" name="city" value="' . $i . '" ' . @$disable . '></td>
      <td class="list">' . $stad . '</td>
      <td class="list">' . $eigenaar . '</td>
      <td class="list">' . groot($station['prijs']) . '</td>
      <td class="list">' . groot(mysql_num_rows(mysql_query("SELECT id FROM users WHERE stad = '" . $i . "'"))) . '</td>
    </tr>';
  }


  echo'
  </table><br />
  
  <input type="submit" name="submit" class="submit" value="Reizen" />
  </form>';


  echo'
		</div>
		<div id="content_bottom"> </div>';
?>