Файл: online/riwar/Riwar.ru/anekdots.php
Строк: 816
<?php
//-----Создаем титл страницы-----//
$title = 'Анекдоты';
//-----Подключаем функции-----//
require_once ('system/function.php');
//-----Если гость,то...-----//
if(!$user['id']) {
header('Location: '.$HOME.'');
exit();
}
if (isset($_GET['act'])) {$act = strong($_GET['act']);} else {$act = 'index';}
switch ($act):
case "index":
require_once ('system/header.php');
//-----Если гость,то...-----//
if(!$user['id']) {
header('Location: '.$HOME.'');
exit();
}
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` WHERE `mod`='1' and `time` > '".(time()-((60*60)*24))."' and `user`!='".$user['id']."'"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$k_post = $start+1;
echo "<div class='player'>";
echo "<div class='player'><center><font color=orange>~Свежие Анекдоты~</font></center><div class='separ'></div>";
if ($k_post==0){
echo "Нет анекдотов!";
}
echo" </div>";
$q=mysql_query("SELECT * FROM `jokes` WHERE `mod`='1' and `time` > '".(time()-((60*60)*24))."' and `user`!='".$user['id']."' ORDER BY `time` LIMIT $start,$max");
while ($post = mysql_fetch_assoc($q)){
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$post['id'].'" and `user` = "'.$user['id'].'"'),0);
if($post['kat'] == 0){$kater = 'Разные';}
elseif($post['kat'] == 1){$kater = 'Про Вовочку';}
elseif($post['kat'] == 2){$kater = 'Про Новых Русских';}
elseif($post['kat'] == 3){$kater = 'Истории из жизни';}
echo ' <center>
<b><br>****<br><font color=green>'.$post['name'].'</b> </font>('.$kater.')<br />';
echo' '.nl2br(filter(smile(bb($post['text'])))).' <font color=grey><br>оформил(а) '.nick($post['user']).'</font><br /><b><font color=lightblue>Рейтинг: '.$post['golos'].'</b></font> <font color=lightgreen>['.$post['plus'].']</font> <font color=indianred>['.$post['minus'].'] </font> ';
if($laik < 1 && $post['user'] != $user['id']){
echo' Оценить: <a href="anekdots.php?act=laik&id='.$post['id'].'&yes"><font size = 4 color=lightgreen><b>+</b></font></a> <a href="anekdots.php?act=laik&id='.$post['id'].'&noy"><font size = 4 color=indianred><b>-</b></font></a>';
}
if ($user['level'] >= 2)echo ' <br /><font color=indianred><b>x</b></font> <a href="anekdots.php?act=delete&id='.$post['id'].'">Удалить анекдот</a><br /></center><div class="separ5"></div>';
}
if ($k_page>1)str('anekdots.php?act=index&',$k_page,$page); // Вывод страниц
echo" </div>";
echo '<a href="anekdots.php?act=moi" class="link">Мои Анекдоты ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `user`='".$user['id']."'"),0).']<font color=indianred>['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`='".$user['id']."'"),0).']</font></a>';
echo '<a href="anekdots.php?act=top" class="link">Популярные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `golos`>'0'"),0).']</a>';
echo '<a href="anekdots.php?act=raz" class="link">Разные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='0'"),0).']</a>';
echo '<a href="anekdots.php?act=vovchik" class="link">Про Вовочку ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='1'"),0).']</a>';
echo '<a href="anekdots.php?act=newrus" class="link">Про Новых Русских ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='2'"),0).']</a>';
echo '<a href="anekdots.php?act=history" class="link">Нереальные истории ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='3'"),0).']</a>';
echo '<a href="anekdots.php?act=add" class="link"><font color=lightgreen>Добавить анекдот</font></a>';
if($user['level']>=1){echo '<a href="anekdots.php?act=mod" class="link"><font color=indianred>На модерации ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`!='".$user['id']."'"),0).']</a></font>';}
break;
case "add":
$title = 'Добавление анекдота'; // заголовок страницы
require_once ('system/header.php');
if(isset($user)){
if(isset($_POST['text'])){
$text = strong($_POST['text']);
$name = strong($_POST['name']);
$kat = strong($_POST['kat']);
if (mb_strlen($text) >= 20 && mb_strlen($text) < 10000) {
if (mb_strlen($name) < 3 && mb_strlen($name) < 30) {
echo '<div class="player"><center><b>Введите название от 3 до 30 символов!</b></center></div>';
//-----Подключаем низ-----//
require_once ('system/footer.php');
exit();
}
$mod = 0;
mysql_query("INSERT INTO `jokes` (`user`, `name`, `text`, `time`, `mod`, `kat`) values('$user[id]', '$name', '$text', '".time()."', '$mod', '$kat')");
$jokes = mysql_insert_id();
$_SESSION['not'] = 'Ваш анекдот отправлен на модерацию!';
header('Location: /anekdots.php');
exit();
}else{$err[]='Анекдот не может привышать 10000 символв и быть менее 20ти';}
}
echo "<div class='player'><center>";
//здесь
echo '<form action="anekdots.php?act=add" method="post">';
echo 'Выберите категорию:<br/><select name="kat"><option value="0">Разные</option><option value="1">Про Вовочку</option>
<option value="2">Про новых русских</option><option value="3">Нереальные истории</option>
</select>
<br/>';
echo 'Название:<br /><input type="text" name="name" maxlength="20" /><br />';
echo 'Анекдот:<br />';
echo '<textarea name="text"></textarea><br />';
echo '<input class="submit" type="submit" value="Добавить" /><br />';
echo '<span style="color:Indianred">после модерации ваш анекдот будет добавлен в игру!<br>Добавление анекдотов в не соответствующую им категорию одобрены не будут!<font color=gold><br> После успешной модерации вам будет зачислено +1 золотой,+1 кристалл и +50 опыта!</font></span>';
echo '</form>';
echo" </div><center>";
}else{header("Location: ?");}
break;
case "raz":
$title = 'Категория (Разные)'; // заголовок страницы
require_once ('system/header.php');
//-----Если гость,то...-----//
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` WHERE `mod`='1' and `kat`='0' and `user`!='".$user['id']."'"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$k_post = $start+1;
echo "<div class='player'>";
echo "<div class='player'><center><font color=orange>~Разные Анекдоты~</font></center><div class='separ'></div>";
if ($k_post==0){
echo "Нет анекдотов!";
}
echo" </div>";
$q=mysql_query("SELECT * FROM `jokes` WHERE `mod`='1' and `kat`='0' and `user`!='".$user['id']."' ORDER BY `id` DESC, `id` DESC LIMIT $start, $max");
while ($post = mysql_fetch_assoc($q)){
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$post['id'].'" and `user` = "'.$user['id'].'"'),0);
echo ' <center>
<b><br>****<br><font color=green>'.$post['name'].'</b> </font><br />';
echo' '.nl2br(filter(smile(bb($post['text'])))).' <font color=grey><br>оформил(а) '.nick($post['user']).'</font><br /><b><font color=lightblue>Рейтинг: '.$post['golos'].'</b></font> <font color=lightgreen>['.$post['plus'].']</font> <font color=indianred>['.$post['minus'].'] </font> ';
if($laik < 1 && $post['user'] != $user['id']){
echo' Оценить: <a href="anekdots.php?act=raz&id='.$post['id'].'&yes"><font size = 4 color=lightgreen><b>+</b></font></a> <a href="anekdots.php?act=laik&id='.$post['id'].'&noy"><font size = 4 color=indianred><b>-</b></font></a>';
}
if ($user['level'] >= 2)echo ' <br /><font color=indianred><b>x</b></font> <a href="anekdots.php?act=delete&id='.$post['id'].'">Удалить анекдот</a><br /></center><div class="separ5"></div>';
}
if ($k_page>1)str('anekdots.php?act=raz&',$k_page,$page); // Вывод страниц
echo" </div>";
echo '<a href="anekdots.php?act=moi" class="link">Мои Анекдоты ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `user`='".$user['id']."'"),0).']<font color=indianred>['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`='".$user['id']."'"),0).']</font></a>';
echo '<a href="anekdots.php" class="link">Свежие ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `time` > '".(time()-((60*60)*24))."'"),0).']</a>';
echo '<a href="anekdots.php?act=top" class="link">Популярные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `golos`>'0'"),0).']</a>';
echo '<a href="anekdots.php?act=vovchik" class="link">Про Вовочку ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='1'"),0).']</a>';
echo '<a href="anekdots.php?act=newrus" class="link">Про Новых Русских ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='2'"),0).']</a>';
echo '<a href="anekdots.php?act=history" class="link">Нереальные истории ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='3'"),0).']</a>';
echo '<a href="anekdots.php?act=add" class="link"><font color=lightgreen>Добавить анекдот</font></a>';
if($user['level']>=1){echo '<a href="anekdots.php?act=mod" class="link"><font color=indianred>На модерации ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`!='".$user['id']."'"),0).']</a></font>';}
$id = intval($_GET['id']);
$jokes = mysql_fetch_assoc(mysql_query("SELECT * FROM `jokes` WHERE `id` = $id LIMIT 1"));
$juser = $jokes['user'];
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$jokes['id'].'" and `user` = "'.$user['id'].'"'),0);
if(isset($_GET['yes']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']+1)."', `plus` = '".($jokes['plus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('UPDATE `users` SET `sera` =`sera`+ "100" WHERE `id` = '.$jokes['user'].'');
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил положительно ваш анекдот +100 серебра!'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=raz');
exit();
}
if(isset($_GET['noy']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']-1)."', `minus` = '".($jokes['minus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил отрицательно ваш анекдот !'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=raz');
exit();
}
break;
case "top":
$title = 'Категория (Популярные)'; // заголовок страницы
require_once ('system/header.php');
//-----Если гость,то...-----//
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` WHERE `mod`='1' and `golos`>'0'"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$k_post = $start+1;
echo "<div class='player'>";
echo "<div class='player'><center><font color=orange>~Популярные Анекдоты~</font></center><div class='separ'></div>";
if ($k_post==0){
echo "Нет анекдотов!";
}
echo" </div>";
$q=mysql_query("SELECT * FROM `jokes` WHERE `mod`='1' and `golos`>'0' ORDER BY `golos` DESC, `id` DESC LIMIT $start, $max");
while ($post = mysql_fetch_assoc($q)){
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$post['id'].'" and `user` = "'.$user['id'].'"'),0);
if($post['kat'] == 0){$kater = 'Разные';}
elseif($post['kat'] == 1){$kater = 'Про Вовочку';}
elseif($post['kat'] == 2){$kater = 'Про Новых Русских';}
elseif($post['kat'] == 3){$kater = 'Нереальные истории';}
echo ' <center>
<b><br>****<br><font color=green>'.$post['name'].'</b> </font>('.$kater.')<br />';
echo' '.nl2br(filter(smile(bb($post['text'])))).' <font color=grey><br>оформил(а) '.nick($post['user']).'</font><br /><b><font color=lightblue>Рейтинг: '.$post['golos'].'</b></font> <font color=lightgreen>['.$post['plus'].']</font> <font color=indianred>['.$post['minus'].'] </font> ';
if($laik < 1 && $post['user'] != $user['id']){
echo' Оценить: <a href="anekdots.php?act=top&id='.$post['id'].'&yes"><font size = 4 color=lightgreen><b>+</b></font></a> <a href="anekdots.php?act=top&id='.$post['id'].'&noy"><font size = 4 color=indianred><b>-</b></font></a>';
}
if ($user['level'] >= 2)echo ' <br /><font color=indianred><b>x</b></font> <a href="anekdots.php?act=delete&id='.$post['id'].'">Удалить анекдот</a><br /></center><div class="separ5"></div>';
}
if ($k_page>1)str('anekdots.php?act=top&',$k_page,$page); // Вывод страниц
echo" </div>";
echo '<a href="anekdots.php?act=moi" class="link">Мои Анекдоты ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `user`='".$user['id']."'"),0).']<font color=indianred>['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`='".$user['id']."'"),0).']</font></a>';
echo '<a href="anekdots.php" class="link">Свежие ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `time` > '".(time()-((60*60)*24))."'"),0).']</a>';
echo '<a href="anekdots.php?act=raz" class="link">Разные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='0'"),0).']</a>';
echo '<a href="anekdots.php?act=vovchik" class="link">Про Вовочку ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='1'"),0).']</a>';
echo '<a href="anekdots.php?act=newrus" class="link">Про Новых Русских ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='2'"),0).']</a>';
echo '<a href="anekdots.php?act=history" class="link">Нереальные истории ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='3'"),0).']</a>';
echo '<a href="anekdots.php?act=add" class="link"><font color=lightgreen>Добавить анекдот</font></a>';
if($user['level']>=1){echo '<a href="anekdots.php?act=mod" class="link"><font color=indianred>На модерации ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`!='".$user['id']."'"),0).']</a></font>';}
$id = intval($_GET['id']);
$jokes = mysql_fetch_assoc(mysql_query("SELECT * FROM `jokes` WHERE `id` = $id LIMIT 1"));
$juser = $jokes['user'];
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$jokes['id'].'" and `user` = "'.$user['id'].'"'),0);
if(isset($_GET['yes']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']+1)."', `plus` = '".($jokes['plus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('UPDATE `users` SET `sera` =`sera`+ "100" WHERE `id` = '.$jokes['user'].'');
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил положительно ваш анекдот +100 серебра!'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=top&selection?');
exit();
}
if(isset($_GET['noy']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']-1)."', `minus` = '".($jokes['minus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил отрицательно ваш анекдот!'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=top');
exit();
}
break;
case "vovchik":
$title = 'Категория (Про Вовочку)'; // заголовок страницы
require_once ('system/header.php');
//-----Если гость,то...-----//
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` WHERE `mod`='1' and `kat`='1' and `user`!='".$user['id']."'"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$k_post = $start+1;
echo "<div class='player'>";
echo "<div class='player'><center><font color=orange>~Анекдоты про Вовочку~</font></center><div class='separ'></div>";
if ($k_post<1){
echo "Нет анекдотов!";
}
echo" </div>";
$q=mysql_query("SELECT * FROM `jokes` WHERE `mod`='1' and `kat`='1' and `user`!='".$user['id']."' ORDER BY `id` DESC, `id` DESC LIMIT $start, $max");
while ($post = mysql_fetch_assoc($q)){
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$post['id'].'" and `user` = "'.$user['id'].'"'),0);
echo ' <center>
<b><br>****<br><font color=green>'.$post['name'].'</b> </font><br />';
echo' '.nl2br(filter(smile(bb($post['text'])))).' <font color=grey><br>оформил(а) '.nick($post['user']).'</font><br /><b><font color=lightblue>Рейтинг: '.$post['golos'].'</b></font> <font color=lightgreen>['.$post['plus'].']</font> <font color=indianred>['.$post['minus'].'] </font> ';
if($laik < 1 && $post['user'] != $user['id']){
echo' Оценить: <a href="anekdots.php?act=vovchik&id='.$post['id'].'&yes"><font size = 4 color=lightgreen><b>+</b></font></a> <a href="anekdots.php?act=vovchik&id='.$post['id'].'&noy"><font size = 4 color=indianred><b>-</b></font></a>';
}
if ($user['level'] >= 2)echo ' <br /><font color=indianred><b>x</b></font> <a href="anekdots.php?act=delete&id='.$post['id'].'">Удалить анекдот</a><br /></center><div class="separ5"></div>';
}
if ($k_page>1)str('anekdots.php?act=vovchik&',$k_page,$page); // Вывод страниц
echo" </div>";
echo '<a href="anekdots.php?act=moi" class="link">Мои Анекдоты ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `user`='".$user['id']."'"),0).']<font color=indianred>['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`='".$user['id']."'"),0).']</font></a>';
echo '<a href="anekdots.php" class="link">Свежие ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `time` > '".(time()-((60*60)*24))."'"),0).']</a>';
echo '<a href="anekdots.php?act=top" class="link">Популярные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `golos`>'0'"),0).']</a>';
echo '<a href="anekdots.php?act=raz" class="link">Разные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='0'"),0).']</a>';
echo '<a href="anekdots.php?act=newrus" class="link">Про Новых Русских ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='2'"),0).']</a>';
echo '<a href="anekdots.php?act=history" class="link">Нереальные истории ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='3'"),0).']</a>';
echo '<a href="anekdots.php?act=add" class="link"><font color=lightgreen>Добавить анекдот</font></a>';
if($user['level']>=1){echo '<a href="anekdots.php?act=mod" class="link"><font color=indianred>На модерации ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`!='".$user['id']."'"),0).']</a></font>';}
$id = intval($_GET['id']);
$jokes = mysql_fetch_assoc(mysql_query("SELECT * FROM `jokes` WHERE `id` = $id LIMIT 1"));
$juser = $jokes['user'];
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$jokes['id'].'" and `user` = "'.$user['id'].'"'),0);
if(isset($_GET['yes']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']+1)."', `plus` = '".($jokes['plus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('UPDATE `users` SET `sera` =`sera`+ "100" WHERE `id` = '.$jokes['user'].'');
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил положительно ваш анекдот +100 серебра!'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=vovchik');
exit();
}
if(isset($_GET['noy']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']-1)."', `minus` = '".($jokes['minus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил отрицательно ваш анекдот!'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=vovchik');
exit();
}
break;
case "newrus":
$title = 'Категория (Про Новых Русских)'; // заголовок страницы
require_once ('system/header.php');
//-----Если гость,то...-----//
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` WHERE `mod`='1' and `kat`='2' and `user`!='".$user['id']."'"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$k_post = $start+1;
echo "<div class='player'>";
echo "<div class='player'><center><font color=orange>~Анекдоты про Новых Русских~</font></center><div class='separ'></div>";
if ($k_post<1){
echo "Нет анекдотов!";
}
echo" </div>";
$q=mysql_query("SELECT * FROM `jokes` WHERE `mod`='1' and `kat`='2' and `user`!='".$user['id']."' ORDER BY `id` DESC, `id` DESC LIMIT $start, $max");
while ($post = mysql_fetch_assoc($q)){
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$post['id'].'" and `user` = "'.$user['id'].'"'),0);
echo ' <center>
<b><br>****<br><font color=green>'.$post['name'].'</b> </font><br />';
echo' '.nl2br(filter(smile(bb($post['text'])))).' <font color=grey><br>оформил(а) '.nick($post['user']).'</font><br /><b><font color=lightblue>Рейтинг: '.$post['golos'].'</b></font> <font color=lightgreen>['.$post['plus'].']</font> <font color=indianred>['.$post['minus'].'] </font> ';
if($laik < 1 && $post['user'] != $user['id']){
echo' Оценить: <a href="anekdots.php?act=newrus&id='.$post['id'].'&yes"><font size = 4 color=lightgreen><b>+</b></font></a> <a href="anekdots.php?act=newrus&id='.$post['id'].'&noy"><font size = 4 color=indianred><b>-</b></font></a>';
}
if ($user['level'] >= 2)echo ' <br /><font color=indianred><b>x</b></font> <a href="anekdots.php?act=delete&id='.$post['id'].'">Удалить анекдот</a><br /></center><div class="separ5"></div>';
}
if ($k_page>1)str('anekdots.php?act=newrus&',$k_page,$page); // Вывод страниц
echo" </div>";
echo '<a href="anekdots.php?act=moi" class="link">Мои Анекдоты ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `user`='".$user['id']."'"),0).']<font color=indianred>['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`='".$user['id']."'"),0).']</font></a>';
echo '<a href="anekdots.php" class="link">Свежие ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `time` > '".(time()-((60*60)*24))."'"),0).']</a>';
echo '<a href="anekdots.php?act=top" class="link">Популярные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `golos`>'0'"),0).']</a>';
echo '<a href="anekdots.php?act=raz" class="link">Разные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='0'"),0).']</a>';
echo '<a href="anekdots.php?act=vovchik" class="link">Про Вовочку ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='1'"),0).']</a>';
echo '<a href="anekdots.php?act=history" class="link">Нереальные истории ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='3'"),0).']</a>';
echo '<a href="anekdots.php?act=add" class="link"><font color=lightgreen>Добавить анекдот</font></a>';
if($user['level']>=1){echo '<a href="anekdots.php?act=mod" class="link"><font color=indianred>На модерации ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`!='".$user['id']."'"),0).']</a></font>';}
$id = intval($_GET['id']);
$jokes = mysql_fetch_assoc(mysql_query("SELECT * FROM `jokes` WHERE `id` = $id LIMIT 1"));
$juser = $jokes['user'];
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$jokes['id'].'" and `user` = "'.$user['id'].'"'),0);
if(isset($_GET['yes']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']+1)."', `plus` = '".($jokes['plus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('UPDATE `users` SET `sera` =`sera`+ "100" WHERE `id` = '.$jokes['user'].'');
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил положительно ваш анекдот +100 серебра'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=newrus');
exit();
}
if(isset($_GET['noy']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']-1)."', `minus` = '".($jokes['minus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил отрицательно ваш анекдот !'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=newrus');
exit();
}
break;
case "history":
$title = 'Категория (Нереальные истори )'; // заголовок страницы
require_once ('system/header.php');
//-----Если гость,то...-----//
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` WHERE `mod`='1' and `kat`='3' and `user`!='".$user['id']."'"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$k_post = $start+1;
echo "<div class='player'>";
echo "<div class='player'><center><font color=orange>~Нереальные истории~</font></center><div class='separ'></div>";
if ($k_post<1){
echo "Нет анекдотов!";
}
echo" </div>";
$q=mysql_query("SELECT * FROM `jokes` WHERE `mod`='1' and `kat`='3' and `user`!='".$user['id']."' ORDER BY `id` DESC, `id` DESC LIMIT $start, $max");
while ($post = mysql_fetch_assoc($q)){
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$post['id'].'" and `user` = "'.$user['id'].'"'),0);
echo ' <center>
<b><br>****<br><font color=green>'.$post['name'].'</b> </font><br />';
echo' '.nl2br(filter(smile(bb($post['text'])))).' <font color=grey><br>оформил(а) '.nick($post['user']).'</font><br /><b><font color=lightblue>Рейтинг: '.$post['golos'].'</b></font> <font color=lightgreen>['.$post['plus'].']</font> <font color=indianred>['.$post['minus'].'] </font> ';
if($laik < 1 && $post['user'] != $user['id']){
echo' Оценить: <a href="anekdots.php?act=history&id='.$post['id'].'&yes"><font size = 4 color=lightgreen><b>+</b></font></a> <a href="anekdots.php?act=history&id='.$post['id'].'&noy"><font size = 4 color=indianred><b>-</b></font></a>';
}
if ($user['level'] >= 2)echo ' <br /><font color=indianred><b>x</b></font> <a href="anekdots.php?act=delete&id='.$post['id'].'">Удалить анекдот</a><br /></center><div class="separ5"></div>';
}
if ($k_page>1)str('anekdots.php?act=history&',$k_page,$page); // Вывод страниц
echo" </div>";
echo '<a href="anekdots.php?act=moi" class="link">Мои Анекдоты ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `user`='".$user['id']."'"),0).']<font color=indianred>['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`='".$user['id']."'"),0).']</font></a>';
echo '<a href="anekdots.php" class="link">Свежие ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `time` > '".(time()-((60*60)*24))."'"),0).']</a>';
echo '<a href="anekdots.php?act=top" class="link">Популярные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `golos`>'0'"),0).']</a>';
echo '<a href="anekdots.php?act=raz" class="link">Разные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='0'"),0).']</a>';
echo '<a href="anekdots.php?act=vovchik" class="link">Про Вовочку ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='1'"),0).']</a>';
echo '<a href="anekdots.php?act=newrus" class="link">Про Новых Русских ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='2'"),0).']</a>';
echo '<a href="anekdots.php?act=add" class="link"><font color=lightgreen>Добавить анекдот</font></a>';
if($user['level']>=1){echo '<a href="anekdots.php?act=mod" class="link"><font color=indianred>На модерации ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`!='".$user['id']."'"),0).']</a></font>';}
$id = intval($_GET['id']);
$jokes = mysql_fetch_assoc(mysql_query("SELECT * FROM `jokes` WHERE `id` = $id LIMIT 1"));
$juser = $jokes['user'];
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$jokes['id'].'" and `user` = "'.$user['id'].'"'),0);
if(isset($_GET['yes']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']+1)."', `plus` = '".($jokes['plus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('UPDATE `users` SET `sera` =`sera`+ "100" WHERE `id` = '.$jokes['user'].'');
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил положительно ваш анекдот +100 серебра'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=history');
exit();
}
if(isset($_GET['noy']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']-1)."', `minus` = '".($jokes['minus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил отрицательно ваш анекдот '");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: anekdots.php?act=history');
exit();
}
////
break;
case "moi":
$title = 'Категория (Мои анекдоты )'; // заголовок страницы
require_once ('system/header.php');
//-----Если гость,то...-----//
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` WHERE `mod`='1' and `user`='".$user['id']."'"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$k_post = $start+1;
echo "<div class='player'>";
echo "<div class='player'><center><font color=orange>~Мои Анекдоты~</font></center><div class='separ'></div>";
if ($k_post<1){
echo "Нет анекдотов!";
}
echo" </div>";
$q=mysql_query("SELECT * FROM `jokes` WHERE `mod`='1' and `user`='".$user['id']."' ORDER BY `id` DESC, `id` DESC LIMIT $start, $max");
while ($post = mysql_fetch_assoc($q)){
echo ' <center>
<b><br>****<br><font color=green>'.$post['name'].'</b> </font><br />';
echo' '.nl2br(filter(smile(bb($post['text'])))).' <font color=grey><br>оформил(а) '.nick($post['user']).'</font><br /><b><font color=lightblue>Рейтинг: '.$post['golos'].'</b></font> <font color=lightgreen>['.$post['plus'].']</font> <font color=indianred>['.$post['minus'].'] </font> ';
if ($user['id'] == $post['user'])echo ' <br /><font color=indianred><b>x</b></font> <a href="anekdots.php?act=delete&id='.$post['id'].'&ok">Удалить анекдот</a><br /></center><div class="separ5"></div>';
}
if ($k_page>1)str('anekdots.php?act=history&',$k_page,$page); // Вывод страниц
echo" </div>";
echo '<a href="anekdots.php" class="link">Свежие ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `time` > '".(time()-((60*60)*24))."'"),0).']</a>';
echo '<a href="anekdots.php?act=top" class="link">Популярные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `golos`>'0'"),0).']</a>';
echo '<a href="anekdots.php?act=raz" class="link">Разные ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='0'"),0).']</a>';
echo '<a href="anekdots.php?act=vovchik" class="link">Про Вовочку ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='1'"),0).']</a>';
echo '<a href="anekdots.php?act=newrus" class="link">Про Новых Русских ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='2'"),0).']</a>';
echo '<a href="anekdots.php?act=history" class="link">Нереальные истории ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='1' and `kat`='3'"),0).']</a>';
echo '<a href="anekdots.php?act=add" class="link"><font color=lightgreen>Добавить анекдот</font></a>';
if($user['level']>=1){echo '<a href="anekdots.php?act=mod" class="link"><font color=indianred>На модерации ['.mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` where `mod`='0' and `user`!='".$user['id']."'"),0).']</a></font>';}
/////
break;
case "mod":
$title = 'Модерация анекдотов'; // заголовок страницы
require_once ('system/header.php');
//-----Если гость,то...-----//
if(!$user['id']) {
header('Location: '.$HOME.'');
exit();
}
echo "<div class='player'>";
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jokes` WHERE `mod`='0'"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$k_post = $start+1;
if ($k_post==0){
echo "Нет анекдотов на модерации!";
}
$q=mysql_query("SELECT * FROM `jokes` WHERE `mod`='0' and `user`!='".$user['id']."'ORDER BY `id` ASC LIMIT $start, $max");
while ($post = mysql_fetch_assoc($q)){
echo "<div class='player'>";
if($post['kat'] == 0){$kater = 'Разные';}
elseif($post['kat'] == 1){$kater = 'Про Вовочку';}
elseif($post['kat'] == 2){$kater = 'Про Новых Русских';}
elseif($post['kat'] == 3){$kater = 'Нереальные истории';}
echo " <center>";
echo '<br>****<br>*'.$post['name'].'* от'.nick($post['user']).'<br> Заявленая Категория '.$kater.'<br>';
echo ''.nl2br(smile(bb($post['text']))).'<br />';
echo ' <a class="btn" href="anekdots.php?act=mod&id='.$post['id'].'&mod"><span class="end"><span class="label">Одобрить</a></span></span> ';
echo ' <a class="btn" href="anekdots.php?act=mod&id='.$post['id'].'&del"><span class="end"><span class="label">Отказать</a></span></span> ';
echo " </center>";
echo " </div>";
echo " </div>";
if(isset($_GET['mod']) && $user['level'] >= 1 && $user['id'] != $post['user']){
$id = intval($_GET['id']);
mysql_query('UPDATE `users` SET `zola` =`zola`+ "1", `kris` =`kris`+ "1" , `exp` =`exp`+ "50" WHERE `id` = '.$post['user'].'');
$tex = 'Ваш анекдот '.$post['name'].' успешно прошел модерацию! модерировал '.$user['login'].'!+1 золотой,+1 кристалл и +50 опыта!';
$text = strong($tex);
$con = mysql_result(mysql_query("SELECT COUNT(id) FROM `message_c` WHERE `kogo` = '".$post['user']."' and `kto` = '1' LIMIT 1"),0);
if($con == 0) {
mysql_query("INSERT INTO `message_c` SET `kto` = '1', `kogo` = '".$post['user']."', `time` = '".time()."', `posl_time` = '".time()."'");
mysql_query("INSERT INTO `message_c` SET `kto` = '".$post['user']."', `kogo` = '1', `time` = '".time()."', `posl_time` = '".time()."'");
}
mysql_query("UPDATE `message_c` SET `posl_time`='".time()."' WHERE `kogo` = '1' and `kto`='".$post['user']."' limit 1");
mysql_query("UPDATE `message_c` SET `posl_time`='".time()."' WHERE `kto` = '1' and `kogo`='".$post['user']."' limit 1");
mysql_query("INSERT INTO `message` SET `text` = '".$text."', `kto` = '1', `komy` = '".$post['user']."', `time` = '".time()."', `readlen` = '0'");
mysql_query("UPDATE `jokes` SET `mod` = '1', `time`='".time()."' WHERE `id` = '$id' LIMIT 1");
$_SESSION['not'] = 'Анекдот одобрен!';
header('Location: anekdots.php?act=mod');
exit();
}
if(isset($_GET['del']) && $user['level'] >= 1 && $user['id'] != $post['user']){
$id = intval($_GET['id']);
$tex = 'Ваш анекдот '.$post['name'].' не прошел модерацию! модерировал '.$user['login'].' Вы можете оставить жалобу в спец разделе форума! если вы не правы ваш аккаунт будет заблокирован!!';
$text = strong($tex);
$con = mysql_result(mysql_query("SELECT COUNT(id) FROM `message_c` WHERE `kogo` = '".$post['user']."' and `kto` = '1' LIMIT 1"),0);
if($con == 0) {
mysql_query("INSERT INTO `message_c` SET `kto` = '1', `kogo` = '".$post['user']."', `time` = '".time()."', `posl_time` = '".time()."'");
mysql_query("INSERT INTO `message_c` SET `kto` = '".$post['user']."', `kogo` = '1', `time` = '".time()."', `posl_time` = '".time()."'");
}
mysql_query("UPDATE `message_c` SET `posl_time`='".time()."' WHERE `kogo` = '1' and `kto`='".$post['user']."' limit 1");
mysql_query("UPDATE `message_c` SET `posl_time`='".time()."' WHERE `kto` = '1' and `kogo`='".$post['user']."' limit 1");
mysql_query("INSERT INTO `message` SET `text` = '".$text."', `kto` = '1', `komy` = '".$post['user']."', `time` = '".time()."', `readlen` = '0'");
mysql_query("DELETE FROM `jokes` WHERE `id` = '$id' LIMIT 1");
$_SESSION['err'] = 'Анекдот удален!';
header('Location: anekdots.php?act=mod');
exit();
}
}
echo '<a href="anekdots.php" class="link">Все анекдоты</a>';
break;
case "delete":
if(isset($_GET['id'])){$id = intval($_GET['id']);}else{header("Location: ?");}
$jokes = mysql_fetch_assoc(mysql_query("SELECT * FROM `jokes` WHERE `id` = $id LIMIT 1"));
$title = 'Удаление анекдота #'.$jokes['id']; // заголовок страницы
require_once ('system/header.php');
//-----Если гость,то...-----//
if(!$user['id']) {
header('Location: '.$HOME.'');
exit();
}
if(isset($_GET['ok']) && $user['level'] >= 2 or $user['id'] == $jokes['user']){
mysql_query("DELETE FROM `jokes` WHERE `id` = '$id' LIMIT 1");
$_SESSION['err'] = 'Анекдот удален!';
header('Location: /anekdots.php');
exit();
}
echo "<div class='player'>";
echo 'Анекдот от'.nick($jokes['user']).' <br>';
echo' '.nl2br(smile(bb($jokes['text']))).'<br />';
echo ' <a class="btn" href="anekdots.php?act=delete&id='.$id.'&ok"><span class="end"><span class="label">Удалить анекдот</a></span></span>';
echo '<a href="/anekdots" class="link">Все анекдоты</a>';
echo " </div>";
break;
case "laik":
echo " </div>";
$id = intval($_GET['id']);
if($user['id'] != $id['user'])header("Location: /anekdots.php");
if(isset($_GET['id'])){$id = intval($_GET['id']);}else{header("Location: ?");}
$jokes = mysql_fetch_assoc(mysql_query("SELECT * FROM `jokes` WHERE `id` = $id LIMIT 1"));
$juser = $jokes['user'];
$laik = mysql_result(mysql_query('SELECT COUNT(*) FROM `laik` WHERE `anekdot` = "'.$jokes['id'].'" and `user` = "'.$user['id'].'"'),0);
$title = 'Оценка анекдота #'.$jokes['id']; // заголовок страницы
require_once ('system/header.php');
//-----Если гость,то...-----//
if(!$user['id']) {
header('Location: '.$HOME.'');
exit();
}
if(isset($_GET['yes']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']+1)."', `plus` = '".($jokes['plus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('UPDATE `users` SET `sera` =`sera`+ "100" WHERE `id` = '.$jokes['user'].'');
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил положительно ваш анекдот +100 серебра!'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: /anekdots.php');
exit();
}
if(isset($_GET['noy']) && $laik < 1 && $user['id'] != $jokes['user']){
mysql_query("UPDATE `jokes` SET `golos` = '".($jokes['golos']-1)."', `minus` = '".($jokes['minus']+1)."' WHERE `id` = '".$id."' LIMIT 1");
mysql_query('INSERT INTO `laik` (`anekdot`,
`user`) VALUES ("'.$id.'",
"'.$user['id'].'")');
mysql_query("INSERT INTO `lenta` SET `readlen` = '0', `time` = '".time()."', `komy` = '".$jokes['user']."', `kto` = '".$user['id']."', `text` = 'оценил отрицательно ваш анекдот!'");
$_SESSION['not'] = 'Ваш голос учтен!';
header('Location: /anekdots.php');
exit();
}
echo "<div class='player'>";
echo '<a href="/anekdots" class="link">Все анекдоты</a>';
echo " </div>";
break;
default:
header("location: index.php?");
echo " </div>";
endswitch;
require_once ('system/footer.php');
?>