Файл: www/android/who_rating.php
Строк: 60
<?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_and` where `id`='$id';")); echo' Имя: <a href="/android/'.$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_and` 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_and` 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_and` 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_and` 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>';?>