<?php 

include 'includes/config.php';

logincheck();

include_once 'functies.php';



mysql_query("UPDATE `[users]` SET online=NOW() WHERE login='". $data['login'] ."'");



$query = mysql_query("SELECT *,UNIX_TIMESTAMP(`tijd`) AS `tijd` FROM `[reizen]` WHERE land='". $data['land'] ."'");

$beheerder = mysql_fetch_assoc($query);

?>

<html>

<head> 

<title>Luchthaven</title> 

<link rel="stylesheet" type="text/css" href="style/play.css">

</head>

<body>

<?=cHeader();?>

<form method="post">

<table cellpadding="2" cellspacing="0" width="80%" align="center">

<tr>

<td class="subTitle" colspan="3">Welkom op de Luchthaven</td>

</tr>

<?php

if(isset($_GET['Action']) and $_GET['Action'] == 'koop')

{

	if(!empty($beheerder['owner']))

	{

?>

<tr>

	<td class="mainTxt">De luchthaven staat niet te koop !<br/><?=name($beheerder['owner']);?> is de eigenaar.</td>

</tr>

<?php }else{  $check = mysql_query("SELECT owner FROM `[reizen]` WHERE owner='".$data['login']."'");

if($_SERVER['REQUEST_METHOD'] == 'POST')

{

	if($data['belcredits'] >= '100' and mysql_num_rows($check) == 0)

	{

		mysql_query("UPDATE `[users]` SET belcredits =`belcredits`-'100' WHERE login='".$data['login']."'");

		mysql_query("UPDATE `[reizen]` SET owner='".$data['login']."', winst='', klanten='' WHERE land='".$data['land']."'");

		header("Refresh: 2; URL=luchthaven.php");

		echo '<tr><td class="mainTxt">Je hebt succesvol de luchthaven gekocht.<br/>Je wordt binnen 3 seconden doorgestuurd.</td></tr>';

	}

}?>

<tr>

	<td class="mainTxt">De luchthaven kost <strong>100 credits</strong> (1x bellen bij de <a href="belservice.php"><strong>BelService</strong></a>).<br/>Je mag maar 1 luchthaven hebben. Dus als je er nog geen hebt, kun je deze kopen...<br/><br/>

<form method="post">

    <br/><br/><?php if($data['belcredits'] >= '100' and mysql_num_rows($check) == 0){ ?><input type="submit" class="button" value="Koop Luchthaven"/>

    <?php }elseif(mysql_num_rows($check) != 0){?><input type="submit" disabled class="button" value="Je hebt al een luchthaven !" />

	<?php }else{ ?><input type="submit" disabled class="button" value="Niet genoeg credits" />

    <?php } ?>

</form></td>

</tr>

<?php } echo '</table>';

 }

else

{



$gn1 = mysql_query("SELECT *,UNIX_TIMESTAMP(`rtijd`) AS `rtijd`,0 FROM `[users]` WHERE login='". $data['login'] ."'");

$gn = mysql_fetch_assoc($gn1);  

	if($gn['rtijd'] + $gn['rtijden'] > time()){

	$verschil1 = $gn['rtijd'] + $gn['rtijden'] - time() - 3600;

	$verschil = date("H:i:s", "$verschil1");

?>

<tr><td class="mainTxt" colspan="3">

Je hebt het afgelopen minuut al gereist.<br />Je kan over <?=$verschil;?> seconden weer reizen.</td></tr>

<?php

exit;

}



if($beheerder['owner'] == "")

{?><tr><td class="mainTxt" colspan="3">Deze Luchthaven is eigendom van niemand..<br />

Je kan het kopen d.m.v. belcredits.<br/>Klik <a href="luchthaven.php?Action=koop"><strong>hier</strong></a> om deze Luchthaven te kopen.</td>

</tr>

<?php

exit;

}



if($data['login'] == $beheerder['owner']) { ?>

<tr>

<td class="mainTxt" colspan="3">

<strong>Klanten:</strong> Je hebt in totaal <?=$beheerder['klanten'];?> klanten gehad.<br>

<strong>Winst:</strong> Je hebt in totaal &euro; <?=$beheerder['winst'];?>,- winst gehad.<br/>

<br>

<strong>De huidige prijs is:</strong> &euro; <?=$beheerder['geld'];?>,-<br>

Verander de prijs naar: <input name="prijs" type="text" value="<?=$beheerder['geld'];?>" size="15">

<br>

<input name="verander" type="submit" class="button" value="Verander"><br>

</td></tr>

<?php

if(isset($_POST['verander'])){

echo '<tr><td class="mainTxt" colspan="3">';

	if(!is_numeric($_POST['prijs'])) {

	echo 'Je inzet mag enkel getallen van 0-9 bevatten.';

	}

	elseif($_POST['prijs'] < 1000 || $_POST['prijs'] > 30000 || $_POST['prijs'] < 0) {

	echo 'Je reisprijs moet minimum 1000 tot max. 30000';

	}

	elseif(strlen($_POST['prijs']) > 5) {

	echo 'Je reisprijs mag max. 5 tekens bevatten.';

	}

	else

	{

		$prijs = htmlentities(mysql_real_escape_string($_POST['prijs']));

		$bod = htmlentities(mysql_real_escape_string($_POST['bod']));

		mysql_query("UPDATE `[reizen]` SET geld='". $prijs ."' WHERE owner='". $data['login'] ."'");

		echo 'Je hebt de prijs succesvol veranderd.';

	}

	echo "</td></tr>";

}

} // einde owner 

$dbres = mysql_query("SELECT id FROM `[users]` WHERE `land`='1'");

$belgie = mysql_num_rows($dbres);

$dbres = mysql_query("SELECT id FROM `[users]` WHERE `land`='2'");

$duitsland = mysql_num_rows($dbres);

$dbres = mysql_query("SELECT id FROM `[users]` WHERE `land`='3'");

$engeland = mysql_num_rows($dbres);

$dbres = mysql_query("SELECT id FROM `[users]` WHERE `land`='4'");

$frankrijk = mysql_num_rows($dbres);

$dbres = mysql_query("SELECT id FROM `[users]` WHERE `land`='5'");

$griekenland = mysql_num_rows($dbres);

$dbres = mysql_query("SELECT id FROM `[users]` WHERE `land`='6'");

$italie = mysql_num_rows($dbres);

$dbres = mysql_query("SELECT id FROM `[users]` WHERE `land`='7'");

$nederland = mysql_num_rows($dbres);



if(isset($_POST['vlieg'])) {

echo '<tr><td class="mainTxt" colspan="3">';

	if($data['land'] == $_POST['land'])

	{

	echo 'Je zit al in <strong>'. $sLand .'</strong>.';

	}

else if($_POST['land'] == 0 OR $_POST['land'] == '')

	{

	echo 'Je Moet wel een Land Selecteren anders kan je niet Vliegen!';	

	}

	elseif($beheerder['geld'] > $data['cash']) {

		echo 'Je hebt <strong>niet</strong> genoeg geld, je hebt &euro; '. $beheerder['geld'] .',- nodig.';

	}

	else

	{

	$land = array("","Nederland","Duitsland","Engeland","Frankrijk","Griekenland","Italie","belgie","");

	$sLand = $land[$_POST['land']];

	$land = htmlentities(mysql_real_escape_string($_POST['land']));

	mysql_query("UPDATE `[users]` SET land='". $land ."', cash=`cash`-". $beheerder['geld'] .", rtijd=NOW(), `rtijden`='60' WHERE login='". $data['login'] ."'");

	mysql_query("UPDATE `[users]` SET bank=`bank`+'".$beheerder['geld']."' WHERE login='". $beheerder['owner'] ."'") or die (mysql_error());

	mysql_query("UPDATE `[reizen]` SET winst=`winst`+'". $beheerder['geld'] ."', klanten=`klanten`+'1' WHERE land='". $data['land'] ."'") or die (mysql_error());

	echo 'Welkom in <strong>'. $sLand .'</strong>, je kan over een minuut weer vliegen.';

    }

	echo "</td></tr>";

}

?>

<tr>

	<td class="mainTxt" colspan="3">Je bent momenteel in <strong><?=landImageName($data['land']);?></strong>.<br>

	De vlucht kost <strong>&euro; <?=$beheerder['geld'];?></strong>,-.<br>

	De eigenaar van deze Luchthaven is <?=name($beheerder['owner']);?>.<br>

	</td>

</tr>

</table>

<br>

<table cellpadding="2" cellspacing="0" width="87%" align="center">

<tr>

<td class="subTitle" width="38" align="center">#</td>

<td class="subTitle" width="624" align="center">Land</td>

<td class="subTitle" width="191" align="center">Inwoners</td>

</tr>

<tr>

<td class="mainTxt"><input name="land" value="1" type="radio"<?php if($data['land'] == '1'){?> disabled="disabled"<?php }?>></td>

<td class="mainTxt"><img src="images/game/landen/nederland.gif" width="18" height="12"> Nederland</td>

<td class="mainTxt"><?=$belgie;?></td>

</tr>

<tr>

<td class="mainTxt"><input name="land" value="2" type="radio"<?php if($data['land'] == '2'){?> disabled="disabled"<?php }?>></td>

<td class="mainTxt"><img src="images/game/landen/duitsland.gif" width="18" height="12"> Duitsland</td>

<td class="mainTxt"><?=$duitsland;?></td>

</tr>

<tr>

<td class="mainTxt"><input name="land" value="3" type="radio"<?php if($data['land'] == '3'){?> disabled="disabled"<?php }?>></td>

<td class="mainTxt"><img src="images/game/landen/engeland.gif" width="18" height="12"> Engeland</td>

<td class="mainTxt"><?=$engeland;?></td>

</tr>

<tr>

<td class="mainTxt"><input name="land" value="4" type="radio"<?php if($data['land'] == '4'){?> disabled="disabled"<?php }?>></td>

<td class="mainTxt"><img src="images/game/landen/frankrijk.gif" width="18" height="12"> Frankrijk</td>

<td class="mainTxt"><?=$frankrijk;?></td>

</tr>

<tr>

<td class="mainTxt"><input name="land" value="5" type="radio"<?php if($data['land'] == '5'){?> disabled="disabled"<?php }?>></td>

<td class="mainTxt"><img src="images/game/landen/griekenland.gif" width="18" height="12"> Griekenland</td>

<td class="mainTxt"><?=$griekenland;?></td>

</tr>

<tr>

<td class="mainTxt"><input name="land" value="6" type="radio"<?php if($data['land'] == '6'){?> disabled="disabled"<?php }?>></td>

<td class="mainTxt"><img src="images/game/landen/italie.gif" width="18" height="12"> Italië</td>

<td class="mainTxt"><?=$engeland;?></td>

</tr>

<tr>

<td class="mainTxt"><input name="land" value="7" type="radio"<?php if($data['land'] == '7'){?> disabled="disabled"<?php }?>></td>

<td class="mainTxt"><img src="images/game/landen/belgie.gif" width="18" height="12"> Belgie</td>

<td class="mainTxt"><?=$nederland;?></td>

</tr>

<tr>

	<td class="mainTxt" colspan="3"><input name="vlieg" type="submit" class="button" value="Neem deze vlucht"></td>

</tr>

</table>

</form>

<?php } ?>

</body>

</html>