if ($id && preg_match("/^[0-9]+/",$id))
{
if ($cmd=="vote")
{
if ($rate && preg_match("/^[0-9]+/",$rate))
{
$old_time = time() - VOTE_IPS_LIFETIME;
mysqli_query($link, "DELETE FROM vote_ips WHERE tm<'".$old_time."'");
$result = mysqli_query($link, "SELECT rating,votecount FROM vote WHERE siteid='".$id."'");
$row = mysqli_fetch_array($result);
mysqli_free_result($result);
$row['rating'] += $rate;
$result1 = mysqli_query($link, "SELECT tm FROM vote_ips WHERE site_id='".$id."' AND ip='".getenv("REMOTE_ADDR")."'");
$row1 = mysqli_fetch_array($result1);
mysqli_free_result($result1);
if (!$row1['tm'])
{
mysqli_query($link, "UPDATE vote SET rating='".$row['rating']."', votecount=votecount+1 WHERE siteid='".$id."'");
mysqli_query($link, "INSERT INTO vote_ips VALUES ('".$id."','".time()."','".getenv("REMOTE_ADDR")."')");
}
else print("Вы уже голосовали.
");
}
else error("Неверные данные для оценки сайта.");
}
$result = mysqli_query($link, "SELECT name,url FROM sites WHERE id='".$id."'");
$row = mysqli_fetch_array($result);
?>
| Текущий рейтинг |
$res = mysqli_query($link, "SELECT rating,votecount FROM vote WHERE siteid='".$id."'");
$r = mysqli_fetch_array($res);
if ($r['votecount']) echo "".round($r['rating']/$r['votecount'],2)."";
else echo "нет";
mysqli_free_result($res);
?>
|
| Количество голосов |
if ($r['votecount']) echo "".$r['votecount'].""; else echo "0"; ?> |
mysqli_free_result($result);
}
?>
|
|
|