Файл: art.php
Строк: 75
<?php
///Автор: Kurama
///bymas.ru/id17706
require ('config/func.php');
require ('config/header.php');
if(isset($_GET['id']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `art` WHERE `id` = '".intval($_GET['id'])."'"),0) == true){
$art = mysql_fetch_assoc(mysql_query("SELECT * FROM `art` WHERE `id` = '".intval($_GET['id'])."'"));
}else{
header('Location: /');
die();
}
$count = mysql_result(mysql_query("SELECT COUNT(id) FROM `com` WHERE `art` = '".$art['id']."'"),0);
$cat = mysql_fetch_assoc(mysql_query("select *from `cat` where `id` = '".$art['cat']."'"));
if(isset($_POST['go'])){
mysql_query("update `art` set `read` = '".($art['read'] + 1)."' WHERE `id` = '".$art['id']."'");
header('Location: '.$art['url'].'');
exit;
}
$rate_plus = mysql_result(mysql_query("select count(rate) from `game_rate` where `art` = '".$art['id']."' and `rate_minus` = 0"),0);
$rate_minus = mysql_result(mysql_query("select count(rate_minus) from `game_rate` where `art` = '".$art['id']."' and `rate` = 0 "),0);
$check = mysql_result(mysql_query("select * from `game_rate` where `user` = '".$user['id']."' and `art` = '".$art['id']."'"),0);
if(isset($_POST['rate'])){
$rate = text($_POST['rate']);
if($check > 0) $err = 'Вы уже голосовали за эту игру';
if(!isset($user['id'])) $err = 'Для голосования вам необходимо авторизоваться';
if(!isset($err)){
if($rate == 1){
mysql_query("insert into `game_rate` set `rate_minus` = 1, `rate` = 0, `user` = '".$user['id']."', `art` = '".$art['id']."', `time` = '".time()."'");
}
if($rate == 2){
mysql_query("insert into `game_rate` set `rate` = 1, `rate_minus` = 0, `user` = '".$user['id']."', `art` = '".$art['id']."', `time` = '".time()."'");
}
header('Location: ?');
exit;
}else{
$_SESSION['notif'] = $err;
header('Location: ?');
exit;
}
}
echo ' <div class="title"><center>'.$art['name'].'</center></div>';
echo ' <div class="menu"><center><img src="'.$art['img'].'" width="160" alt="'.$art['name'].'"/></center></div>';
echo ' <div class="menu"><center> '.$art['text'].'</center>';
if(!empty($art['ins'])){
?></br><b>Разработчик:</b> <font color="grey"><?=$art['ins'];?></font><?
}
echo '</div><form class="menu center" method="post" action=""><center><input name="go" type="submit" value="Играть"></center><br></form>';
?><div class="menu"> Рейтинг игры: <font color="green"> <?=$rate_plus;?> </font>| <font color="red"><?=$rate_minus;?></font></div><?
if($check < 1){
?> <form class="menu" method="post" action="">Вам понравилась игра?</br><select name="rate"><option value="2">Да</option><option value="1">Нет</option></select><br/><input type="submit" value="Голосовать"></br></form><?
}
echo '<div class="menu">Просмотров: '.$art['read'].'</div> <div class="menu"><a href="/art/'.$art['id'].'/com/"> Обсудить ('.$count.')</a> </div>';
$g = mysql_query("SELECT * FROM `game_user` WHERE `user`='".$user['id']."' and `game` = '".$art['id']."'");
if($user['adm'] == 2){
?><div class="menu"><a href="/adm/game/<?=$art['id'];?>/set/"> Редактировать</a></div><?
}
if($art['cat'] != 11){
if(isset($user['id'])){
if(mysql_num_rows($g) == '0'){
echo ' <div class="menu"><a href="add/">Добавить в «Мои игры»</a></div>';
}else{
echo ' <div class="menu"><font color="gray">Добавлена</font></div>';
}
}
}
echo '<div class="menu">Категория: <a href="/cat/'.$cat['id'].'/"> '.$cat['name'].'</a></div> ';
require ('config/footer.php');
?>