<?php
include'config.php';
$id = intval($_GET['id']);
$beoordeling_naam = mysql_result(mysql_query('SELECT casino FROM list WHERE id = ' . $id . ''), 0);
$beoordeling_beschrijving = mysql_result(mysql_query('SELECT description FROM list WHERE id = ' . $id . ''), 0);
$url = mysql_query('SELECT * from list WHERE id = ' . $id);
$fetch = mysql_fetch_assoc($url);

echo'<table><tr><td style="width: 75%;">';
echo'<div class="font3">' . $beoordeling_naam . '</div></td><td style="text-align: right;">';
$beoordeling_totaal = mysql_result(mysql_query('SELECT SUM(rating) FROM website_' . $beoordeling_naam . ''), 0);
//$optellen += $fetch['beoordeling'];
$totaal = mysql_result(mysql_query('SELECT COUNT(*) FROM website_' . $beoordeling_naam . ''), 0);
$exists = mysql_result(mysql_query('SELECT id FROM list ORDER BY id DESC'), 0);
    $query = "UPDATE `list` SET `rating` = '$gemiddelde' WHERE `id` = '$id'";
    mysql_query('UPDATE list SET votes = ' . $totaal . ' WHERE id = ' . $id . '');
if($totaal == '1'){
    $gemiddelde = $beoordeling_totaal;
}
else{
    $gemiddelde = $beoordeling_totaal / $totaal;

}
$gemiddelde = $beoordeling_totaal / $totaal;
mysql_query('UPDATE list SET rating = ' . $gemiddelde . ' WHERE id = ' . $id . '');
//echo $query;
//echo"$gemiddelde<br />$beoordeling_totaal<br />$totaal<br />";
if($id <= $exists){
if($gemiddelde == '0'){
    echo'Score:<div class="font3">5</div>';
}
else{
    echo'Score:<div class="font3">' . round($gemiddelde, 2) . '</div>';
}
echo'</td><td style="text-align: right;">';
$sql = "SELECT id FROM list WHERE id='$id'";
$result = mysql_query($sql);

if(mysql_num_rows($result) >0){
?>
<form method="post">
<select size="1" name="rating">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
    <option value="7">7</option>
    <option value="8">8</option>
    <option value="9">9</option>
    <option value="10">10</option>
</select>
<input type="submit" value="Send" />
</form>
<?php
if($_SERVER['REQUEST_METHOD'] == 'POST'){
    $beoordeling_user = $_POST['rating'];
    if($beoordeling_user == ''){
        echo'';
    }
    else{
        if($beoordeling_user > '10' OR $beoordeling_user < '1'){
            echo'Hacker!';
        }
        else{
        mysql_query('INSERT INTO website_' . $beoordeling_naam . ' (rating, ip) VALUES ("' . mysql_real_escape_string($beoordeling_user) . '", "' . mysql_real_escape_string($_SERVER['REMOTE_ADDR']) . '")');
        echo'You have voted ' . $beoordeling_user;
}
}
header('REFRESH: 0');
}
}
}else{
   echo'This page does not exist yet.';
}
'</td></tr>';
if($fetch['image'] == ''){
    echo '<tr><td colspan="3">' . nl2br($beoordeling_beschrijving) . '</td></tr>';
}
else{
    echo '<tr><td colspan="3"><div class="casinologo"><img src="' . $fetch['image'] . '"/></div><hr />' . nl2br($beoordeling_beschrijving) . '</td></tr>';
}
echo '<tr><td colspan="1" style="width: 250px;">The website:</td>';
echo'<td colspan="2"><a href="' . $fetch['url'] . '">Click here</a></td></tr>';
echo'</table>';
?>