Файл: www/video/who_rating.php
Строк: 54
<?php
include '../config.php';
$ankr['id']=intval($_GET['id']);
if(!isset($_GET['id']))$ankr[id]=$aut[id];
div('Список проголосовавших');
$ida=$ankr['id'];
$id=intval($_GET['id']);
$game=mysql_fetch_array(mysql_query("select * from `games_video` where `id`='$id';"));
echo' Имя: <a href="/video/'.$id.'/">'.$game['name'].'</a><br/>Текущий рейтинг: (+/-): <font style="color:green"><b>'.$game['pos_rating'].'</b></font>/<font style="color:red"><b>'.$game['neg_rating'].'</font><br/>'.graph_rating($game['pos_rating'],$game['neg_rating']).'<br/>';
echo "Положительный голоса оставили [$game[pos_rating]]<div class='msg1'>";
$q_reyt = mysql_query("SELECT DISTINCT `id_user` FROM `games_reyt_video` WHERE `id_game` = '".$ankr['id']."' and `or` = '1' ORDER BY `id_user` DESC");
while ($reyt = mysql_fetch_array($q_reyt))
{
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `id`='$reyt[id_user]'"));
$pl_c = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_reyt_video` WHERE `id_game` = '".$ankr['id']."' AND `id_user` = '".$ank['id']."' AND `or` = '1'"),0);
if($pl_c==1)echo "<a href='../info.php?id=$ank[id]'>$ank[login]</a>, ";
else echo "<a href='../info.php?id=$ank[id]'>$ank[login]</a> [<b>$pl_c</b>], ";
}
echo '</div>';
echo "Отрицательные голоса оставили [$game[neg_rating]]<div class='msg1'>";
$q_reyt = mysql_query("SELECT DISTINCT `id_user` FROM `games_reyt_video` WHERE `id_game` = '".$ankr['id']."' and `or` = '0' ORDER BY `id_user` DESC");
while ($reyt = mysql_fetch_array($q_reyt))
{
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `id`='$reyt[id_user]'"));
$min_c = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_reyt_video` WHERE `id_game` = '".$ankr['id']."' AND `id_user` = '".$ank['id']."' AND `or` = '0'"),0);
if($min_c==1)echo "<a href='/info.php?id=$ank[id]'>$ank[login]</a>, ";
else echo "<a href='/info.php?id=$ank[id]'>$ank[login]</a> [<b>$min_c</b>], ";
}
echo '</div>';
echo '</div>';
include '../foot.php';
echo '</div>';
?>