<?
$dbres = mysql_query("SELECT * FROM `users` WHERE `activated`='1'");
$gebruikers = mysql_num_rows($dbres);
$dbres = mysql_query("SELECT * FROM `users` WHERE `status`='levend' AND `activated`='1'");
$levend = mysql_num_rows($dbres);
$dbres = mysql_query("SELECT * FROM `users` WHERE `status`='dood' AND `activated`='1'");
$dood = mysql_num_rows($dbres);








$dbres = mysql_query("SELECT * FROM `users`");
while($blah = mysql_fetch_object($dbres)){
  $cash = $cash+$blah->zak;
  $bank = $bank+$blah->bank;
  $kogel = $kogel+$blah->kogels;
}
$bank = number_format($bank, 0, ',' , ',');
$cash = number_format($cash, 0, ',' , ',');
$kogel = number_format($kogel, 0, ',' , ',');
$dbres = mysql_query("SELECT * FROM `users` WHERE  UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
$online = mysql_num_rows($dbres);
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Groningen'");
$Groningen = mysql_fetch_object($dbres);
$sGroningen = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Groningen' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Arnhem'");
$Arnhem = mysql_fetch_object($dbres);
$sArnhem = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Arnhem' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Rotterdam'");
$Rotterdam = mysql_fetch_object($dbres);
$sRotterdam = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Rotterdam' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Amsterdam'");
$amsterdam = mysql_fetch_object($dbres);
$samsterdam = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Amsterdam' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Amersfoort'");
$Amersfoort = mysql_fetch_object($dbres);
$sAmersfoort = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Amersfoort' AND `status`='levend'"));
$dbres = mysql_query("SELECT * FROM `stad` WHERE `stad`='Den_Bosch'");
$den_bosch = mysql_fetch_object($dbres);
$sden_bosch = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `stad`='Den_Bosch' AND `status`='levend'"));
print <<<ENDHTML
<table width=100% align=center>
  <tr> 
    <td class="subTitle"><b>Statistieken</b></td>
  </tr>








  <tr><td>&nbsp;&nbsp;</td></tr>
  <tr> 
    <td class="mainTxt">
  <table width=100%><tr><td align=center><b>Gebruikers</b><br><br>
<table border="0" width="39%">
	<tr>
		<td>Totaal aantal spelers</td>
		<td>$gebruikers</td>
	</tr>
	<tr>
		<td>Totaal aantal levende spelers</td>
		<td>$levend</td>
	</tr>
	<tr>
		<td>Totaal aantal dode spelers</td>
		<td>$dood</td>
	</tr>
	<tr>
		<td>Totaal aantal online spelers</td>
		<td>$online</td>
	</tr>
	<tr>
		<td>Totaal geld op zak</td>
		<td>&euro; $cash</td>
	</tr>




	<tr>
		<td>Totaal geld op de bank</td>
		<td>&euro; $bank</td>
	</tr>
	<tr>
		<td>Totaal aantal kogels</td>
		<td>$kogel</td>
	</tr>
	</td></tr></table></table>