BIJ MIJ EEN STUKKIE PHP VOOR RD-WORKS.NL 
Mijne is mooier dan de jouwne Dr. O Ja Joh
<?session_start();
if ($_SESSION['rang'] == "admin"){
$user = ($_SESSION['user']);
include ("db.php");
$query = mysql_query("SELECT * FROM plaatje");
$results = mysql_num_rows($query);
$plaantal = ($results);
$queryu = mysql_query("SELECT * FROM user WHERE rang ='user'");
$resultsu = mysql_num_rows($queryu);
$useraantal = ($resultsu);
$querya = mysql_query("SELECT * FROM user WHERE rang ='admin'");
$resultsa = mysql_num_rows($querya);
$adminaantal = ($resultsa);
$querybl = mysql_query("SELECT * FROM user WHERE geblockt ='1'");
$resultsbl = mysql_num_rows($querybl);
$blaantal = ($resultsbl);
/////////////////////////// STEMMEN OP VRAGEN ////////////////////
$querypoll = mysql_query("SELECT * FROM poll WHERE `show` = '1' ");
$resultspoll = mysql_num_rows($querypoll);
$aantalpoll = ($resultspoll);
while ($recordpoll = mysql_fetch_object($querypoll)) {
$vraag = ($recordpoll->vraag);
$aant = ($recordpoll->aant);
$bant = ($recordpoll->bant);
$cant = ($recordpoll->cant);
$dant = ($recordpoll->dant);
$eant = ($recordpoll->eant);
$pollid = ($recordpoll->id);
}
$querytot = mysql_query("SELECT * FROM pollant WHERE pollid = '".$pollid."'");
$resultstot = mysql_num_rows($querytot);
$aantaltot = ($resultstot);
$queryaa = mysql_query("SELECT * FROM pollant WHERE ant = 'a' AND pollid = '".$pollid."'");
$resultsaa = mysql_num_rows($queryaa);
$aantalaa = ($resultsaa);
$queryab = mysql_query("SELECT * FROM pollant WHERE ant = 'b' AND pollid = '".$pollid."'");
$resultsab = mysql_num_rows($queryab);
$aantalab = ($resultsab);
$queryac = mysql_query("SELECT * FROM pollant WHERE ant = 'c' AND pollid = '".$pollid."'");
$resultsac = mysql_num_rows($queryac);
$aantalac = ($resultsac);
$queryad = mysql_query("SELECT * FROM pollant WHERE ant = 'd' AND pollid = '".$pollid."'");
$resultsad = mysql_num_rows($queryad);
$aantalad = ($resultsad);
$queryae = mysql_query("SELECT * FROM pollant WHERE ant = 'e' AND pollid = '".$pollid."'");
$resultsae = mysql_num_rows($queryae);
$aantalae = ($resultsae);
if ($eant != "") {
$polluitslag = ("<tr><td><font class=in>".$aant."</td><td><font class=in><b>".$aantalaa."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$bant."</td><td><font class=in><b>".$aantalab."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$cant."</td><td><font class=in><b>".$aantalac."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$dant."</td><td><font class=in><b>".$aantalad."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$eant."</td><td><font class=in><b>".$aantalae."</td><td><font class=in>Stemmen</td></tr>");
}
else if ($dant != "") {
$polluitslag = ("<tr><td><font class=in>".$aant."</td><td><font class=in><b>".$aantalaa."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$bant."</td><td><font class=in><b>".$aantalab."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$cant."</td><td><font class=in><b>".$aantalac."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$dant."</td><td><font class=in><b>".$aantalad."</td><td><font class=in>Stemmen</td></tr>");
}
else if ($cant != "") {
$polluitslag = ("<tr><td><font class=in>".$aant."</td><td><font class=in><b>".$aantalaa."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$bant."</td><td><font class=in><b>".$aantalab."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$cant."</td><td><font class=in><b>".$aantalac."</td><td><font class=in>Stemmen</td></tr>");
}
else if ($bant != "") {
$polluitslag = ("<tr><td><font class=in>".$aant."</td><td><font class=in><b>".$aantalaa."</td><td><font class=in>Stemmen</td></tr><tr><td><font class=in>".$bant."</td><td><font class=in><b>".$aantalab."</td><td><font class=in>Stemmen</td></tr>");
}
else if ($aant != "") {
$polluitslag = ("<tr><td><font class=in><font color=red>FOUT IN POLL SYSTEEM</td><td></td><td></td></tr>");
}
else if ($aant == "0") {
$polluitslag = ("<tr><td><font class=in><font color=red>Er zijn nog geen stemmen geweest</td><td></td><td></td></tr>");
}
/////////////////////////////////////// TELLER GEGEVENS OPVRAGEN /////////////////////////
$statdag = date("j");
$statmaand = date("n");
$statjaar = date("Y");
$sqld = "SELECT * FROM log WHERE datumdag = '".$statdag."' AND datummaand = '".$statmaand."' AND datumjaar = '".$statjaar."'";
$resultaatd = mysql_query($sqld);
$aantald = mysql_num_rows($resultaatd);
$sqlm = "SELECT * FROM log WHERE datummaand = '".$statmaand."' AND datumjaar = '".$statjaar."'";
$resultaatm = mysql_query($sqlm);
$aantalm = mysql_num_rows($resultaatm);
include ("inc.php");
?>
<title>Rd-Works.nl - Admin area</title>
</head>
<body>
<? include ("reclame1.php");?>
<br>
<center>
<table cellpadding=0 cellspacing=0><tr><td class=ban></td><td class=klein></td><td class=stukje></td><td class=groen><center><font class=in><? echo "<br>".date("d-m-Y")."<br>".date("H:i")."";?></td></tr></table>
<table class=main cellpadding=4 cellspacing=0 border=1 bordercolor=#AEC739 style="border-top: none">
<tr><td style="border-top: none" class=menu valign=top>
<center><img src="images/menu.gif"><br><hr width="80%" color=#AEC739>
</center><font class=menu><br>
<a href="#" class=link>- <font color=#B70505><b>Main</b></font></a><Br>
<a href="userlijst.php" class=link>- Userlijst</a><Br>
<Br><Br>
<a href="<? echo "".$homelink."";?>?loguit" class=link>- <b>Loguit</b></a><Br>
</td>
<td class=in style="border-left: none; border-top: none" valign=top cellpadding=40>
<font class=in>
<br>
<b>Welkom Admin,</b><br>
<br>
<b>- Site statustieken</b>
<table border=0 cellspacing=0 cellpadding=2>
<tr><td colspan=2><hr color=#B70505 align=left></td></tr>
<tr><td>
<font class=in>Plaatjes:</td><td align=right><font class=in> <b><? echo "".$plaantal."";?></b></td></tr><tr><td>
<font class=in>Users:</td><td align=right><font class=in> <b><? echo "".$useraantal."";?></b></td></tr><tr><td>
<font class=in>Geblockt:</td><td align=right><font class=in> <b><? echo "".$blaantal."";?></b></td></tr><tr><td>
<font class=in>Admin's:</td><td align=right><font class=in> <b><? echo "".$adminaantal."";?></b></td></tr><tr><td>
<font class=in>Bezoekers vandaag:</td><td align=right><font class=in> <b><? echo "".$aantald."";?></b></td></tr><tr><td>
<font class=in>Bezoekers deze maand:</td><td align=right><font class=in> <b><? echo "".$aantalm."";?></b></td></tr>
<tr><td colspan=2><hr color=#B70505 align=left></td></tr>
</table>
<br><b>- Poll statustieken</b>
<table><tr><td colspan=3><hr color=#B70505 width=100% align=left><center><font class=in><? echo "".$vraag."";?></center><hr color=#B70505 width=100% align=left></tr>
<? echo "".$polluitslag."";?>
</td></tr><tr><td colspan=3><hr color=#B70505 width=100% align=left></td></tr>
<tr><td><font class=in><b>Totaal</b></td><td><div align=left><font class=in><b><? echo "".$aantaltot."";?></font></div></b></td><td><div align=left><font class=in>Stemmen</font></div></td></tr></table>
<br>
</td></tr>
</table>
<? include ("footer.php");?>
<?
}
else { echo "Geen juiste rechten<br>Controleer of je account al is geactiveerd.";}?>