<?php
ob_start();
include("config.php");
	if(! check_login()) { 
	exit;
	}

?>

<html>
<head>
<title>Ultimatecrime- Intranet - Landen statistieken</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="description" content="Wat is het leidende netwerk in ieder land? Ook prijzen van drugs, wapens & ammo">
<meta name="keywords" content="world, gangster, criminal, mafia, games, game, multiplayer, rpg, mmorpg, online game, online multiplayer">
<meta name="Robots" CONTENT="follow">
<meta name="REVISIT-AFTER" CONTENT="7 days">
<link rel="stylesheet" type="text/css" href="style_general.css">
</head>
<body background="layout/images/layout_12.gif" bgproperties="fixed">
<br>
<br>
<br>

<table align="center" width="600">
	<tr>
		<td class="subTitle"colspan="3">
		<b>Ammoclip prijzen Grote Raad & Aantal kogels per fabriek</b>
		</td>
	</tr>
 	<tr>
		<td class="subTitle" align="center" width="200"><b>Stad - Land</b></td>
		<td class="subTitle" align="center" width="200"><b>Ammo prijs</b></td>
		<td class="subTitle" align="center" width="200"><b>Kogels</b></td>
	</tr>

<?php

$dbres	=	mysql_query("SELECT * FROM `clipsfabriek_spel` ORDER BY `land`");
	while($drugs = mysql_fetch_object($dbres)){

?>

	<tr onMouseOver="this.style.backgroundColor='#6F5E4A';" onMouseOut="this.style.backgroundColor='#4B3D32';" style="background-color: #4B3D32;">
		<td align="center" class="justborderS" width="200"><?php echo $drugs->land; ?></td>
		<td align="center" class="justborderS" width="200">&euro;<?php echo geld($drugs->prijs); ?></td>
		<td align="center" class="justborderS" width="200"><?php echo $drugs->aantal; ?></td>
	</tr>

<?php

	}

?>

</table>
<br>
<table align="center" width="600">
	<tr>
		<td class="subTitle"colspan="4">
		<b>Ziekenhuizen</b>
		</td>
	</tr>
 	<tr>
		<td class="subTitle" align="center" width="150"><b>Stad - Land</b></td>
		<td class="subTitle" align="center" width="150"><b>Eigenaar</b></td>
		<td class="subTitle" align="center" width="150"><b>Aantal( O )</b></td>
		<td class="subTitle" align="center" width="150"><b>Prijs( O )</b></td>
	</tr>

<?php

$dbres	=	mysql_query("SELECT * FROM `ziekenhuis` ORDER BY `land`");
	while($drugs = mysql_fetch_object($dbres)){

		if($drugs->owner == ""){
		$owner	=	"<b>Geen</b>";
		} else {
		$owner	=	"<a href=\"speler-profiel.php?x={$drugs->owner}\" target=\"content\">{$drugs->owner}</a>";
		}

?>

	<tr onMouseOver="this.style.backgroundColor='#6F5E4A';" onMouseOut="this.style.backgroundColor='#4B3D32';" style="background-color: #4B3D32;">
		<td align="center" class="justborderS" width="150"><?php echo $drugs->land; ?></td>
		<td align="center" class="justborderS" width="150"><?php echo $owner; ?></td>
		<td align="center" class="justborderS" width="150"><?php echo $drugs->aantalo; ?></td>
		<td align="center" class="justborderS" width="150">&euro;<?php echo geld($drugs->prijso); ?></td>
	</tr>

<?php

	}

?>

</table>
<br>
<table align="center" width="600">
	<tr>
		<td class="subTitle"colspan="4">
		<b>Private ammo depots</b>
		</td>
	</tr>
 	<tr>
		<td class="subTitle" align="center" width="150"><b>Stad - Land</b></td>
		<td class="subTitle" align="center" width="150"><b>Eigenaar</b></td>
		<td class="subTitle" align="center" width="150"><b>Aantal</b></td>
		<td class="subTitle" align="center" width="150"><b>Prijs</b></td>
	</tr>

<?php

$dbres	=	mysql_query("SELECT * FROM `clipsfabriek` ORDER BY `land`");
	while($drugs = mysql_fetch_object($dbres)){

		if($drugs->owner == ""){
		$owner	=	"<b>Geen</b>";
		} else {
		$owner	=	"<a href=\"speler-profiel.php?x={$drugs->owner}\" target=\"content\">{$drugs->owner}</a>";
		}

?>

	<tr onMouseOver="this.style.backgroundColor='#6F5E4A';" onMouseOut="this.style.backgroundColor='#4B3D32';" style="background-color: #4B3D32;">
		<td align="center" class="justborderS" width="150"><?php echo $drugs->land; ?></td>
		<td align="center" class="justborderS" width="150"><?php echo $owner; ?></td>
		<td align="center" class="justborderS" width="150"><?php echo $drugs->kogels; ?></td>
		<td align="center" class="justborderS" width="150">&euro;<?php echo geld($drugs->prijs); ?></td>
	</tr>

<?php

	}

?>

</table>
<br>
<table align="center" width="600">
	<tr>
		<td class="subTitle"colspan="4">
		<b>Drugsprijzen per stad</b>
		</td>
	</tr>
 	<tr>
		<td class="subTitle" align="center" width="150"><b>Stad - Land</b></td>
		<td class="subTitle" align="center" width="150"><b>Wiet</b></td>
		<td class="subTitle" align="center" width="150"><b>Hasj</b></td>
		<td class="subTitle" align="center" width="150"><b>Coke</b></td>
	</tr>

<?php

$dbres	=	mysql_query("SELECT * FROM `drugs` ORDER BY `land`");
	while($drugs = mysql_fetch_object($dbres)){

?>

	<tr onMouseOver="this.style.backgroundColor='#6F5E4A';" onMouseOut="this.style.backgroundColor='#4B3D32';" style="background-color: #4B3D32;">
		<td align="center" class="justborderS" width="150"><?php echo $drugs->land; ?></td>
		<td align="center" class="justborderS" width="150">&euro;<?php echo geld($drugs->Wiet); ?></td>
		<td align="center" class="justborderS" width="150">&euro;<?php echo geld($drugs->Hasj); ?></td>
		<td align="center" class="justborderS" width="150">&euro;<?php echo geld($drugs->Coke); ?></td>
	</tr>

<?php

	}

?>

</table>
</body>
</html>


