Файл: largewar.ru/kom.php
Строк: 67
<?
include 'look/g.php';
include 'look/c.php';
include 'look/cfg.php';
include 'look/vuvod.php';
include 'look/myhead.php';
$pass = base64_decode($pass);
$g=mysql_query("SELECT * FROM `tb_uzers` WHERE `nick`='$nick' AND `pass`='$pass' LIMIT 1");
if(mysql_num_rows($g)==1){
$pass = base64_encode($pass);
if($game=="save"){
$g=mysql_query("SELECT * FROM `tb_news` WHERE `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==0){
echo "Новость не существует";
include 'look/nog.php';
exit;
}
if($msg==""){echo "Вы не ввели коментарий";
include 'look/nog.php';
exit;
}
$query = "INSERT INTO tb_koments VALUES('$id','$nick','$aid','$msg')";
$result = mysql_query($query);
echo "Коментарий добавлен<li><a href="kom.php?id=$id">Назад</a>";
include 'look/nog.php';
exit;
}
if($game=="add"){
$g=mysql_query("SELECT * FROM `tb_news` WHERE `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==0){
echo "Новость не существует";
include 'look/nog.php';
exit;
}
echo'<form method="post" action="kom.php?game=save&id='.$id.'">';
echo "<br/>Коментарий:<br/>";
echo "<input class="button" name="msg" maxlength="300" title="Коментарий" emptyok="true"/><br/>";
echo '<input class="button" type="submit" value="Добавить"/></form>';
echo "<li><a href="kom.php?id=$id">Назад</a>";
include 'look/nog.php';
exit;
}
$g=mysql_query("SELECT * FROM `tb_news` WHERE `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==0){
echo "Новость не существует<br/>";
include 'look/nog.php';
exit;
}
$q = mysql_query("SELECT COUNT(`id`) FROM `tb_koments` WHERE `id`='$id'");
$kol = mysql_result($q, 0);
if($kol=="0"){
echo "Коментариев нет<br/>";
}else{
echo "Коментариев: $kol<br/>";
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$qi = mysql_query("SELECT * FROM `tb_koments` WHERE `id`='$id' ORDER by `aid` DESC LIMIT $startan,$num_msgs_an");
while($row=mysql_fetch_array($qi))
{
echo "$row[nick] - $row[msg]<br/>";
}
$q = mysql_query("SELECT COUNT(`id`) FROM `tb_koments` WHERE `id`='$id'");
$kol = mysql_result($q, 0);
if($startan!= 0) $page2left = ' <a href= kom.php?startan='. ($startan - 5) .'&page='.($page-1).'&id='.$id.'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= kom.php?startan='. ($startan + 5) .'&page='. ($page+1) .'&id='.$id.'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="kom.php?startan='.($startan - 5).'&page='.($page-1).'&id='.$id.'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="kom.php?startan='.($startan + 5).'&page='.($page+1).'&id='.$id.'">Далее</a><br/>';}
echo "<li><a href="kom.php?game=add&id=$id">Добавить коментарий</a>";
}else{echo"Пароль или логин неверны";}
include 'look/nog.php';
?>