Просмотр файла forum/includes/showtopic.php

Конкурс дизайнеров на 15000 рублей
Размер файла: 12.01Kb 
  1. <?php
  2. # Script by seg0ro http://mobilarts.ru
  3. # Not for sale!!!
  4.  
  5.  
  6. $cur_page = isset($_GET['page']) ? intval($_GET['page']) : 1;
  7. if ($user_id){
  8.   $lastPost = explode(':|:', $topicRes['lastpost']);
  9.    $sql->query("SELECT * FROM `forum_readed` WHERE `topic` = '$topic' AND `user_id` = '$user_id' LIMIT 1 ");
  10.   if ($sql->num_rows() > 0){
  11.     $readedRes = $sql->fetch();
  12.     if ($topicRes['time'] > $readedRes['time'])
  13.       $sql->query("UPDATE `forum_readed` SET `time` = '".time()."', `lastpost` = '".$lastPost['1']."' WHERE `topic` = '$topic' AND `user_id` = '$user_id' ");
  14.   }else{
  15.     $sql->query("INSERT INTO `forum_readed` SET  `topic` = '$topic', `user_id` = '$user_id', `time` = '".time()."', `lastpost` = '".$lastPost['1']."' ");
  16.   }
  17. }
  18. //$pollSet = $sql->query('select `poll_set` from `forum_topics` where `id` = '.$topic)->result();
  19. echo forum_counter();
  20.  
  21. $tree = array('<a href="index.php">Форум</a>', '<a href="index.php?forum='.$topicRes['refid'].'">'.text::output($topicRes['forum']).'</a>', text::output($topicRes['name']));
  22. echo '<div name="up" id="up" class="fmenu"><a href="#down">↓</a> ';
  23. foreach ($tree as $menu)
  24. {
  25.     echo $menu . ' &nbsp; ';
  26. }
  27. echo '</div>';
  28.  
  29. if ($topicRes['close'])
  30.   echo '<div class="rmenu">Тема закрыта!</div>';
  31.  
  32. if ($topicRes['poll_name']){
  33.   if ($user_id)
  34.     $pollCheck = $sql->query("SELECT COUNT(*) FROM `forum_polled` WHERE `refid` = '$topic' AND `user_id` = '$user_id' LIMIT 1 ")->result();
  35.  
  36.  
  37.   echo '<div class="msg"><strong>'.text::output($topicRes['poll_name']).'</strong><br />';
  38.   if ($pollSet['poll_close'] == 0 && !isset($_GET['results']) && $user_id && $pollCheck == 0 && !$topicRes['close']){
  39.     echo '<form action="index.php?act=poll&amp;topic='.$topic.'&amp;page='.$cur_page.'" method="post">';
  40.     while ($pollRes = mysqli_fetch_assoc($pollReq))
  41.     {
  42.       echo '<label><input type="'.($pollSet['poll_mod'] < 1 ? 'radio' : 'checkbox').'" name="var[]" value="'.$pollRes['id'].'" /> '.text::output($pollRes['name']).'</label><br />';          
  43.     }
  44.     echo '<input type="submit" name="poll" value="Отдать голос" /><br /><a href="index.php?topic='.$topic.'&amp;page='.$cur_page.'&amp;results"><strong>Результаты</strong></a></form>';  
  45.   }else{
  46.    
  47.     while ($pollRes = mysqli_fetch_assoc($pollReq)){
  48.       echo text::output($pollRes['name']).' ('.$pollRes['count'].')<br />';
  49.       $poll_count = $pollSet['total_polls'] ? @round(100 / $pollSet['total_polls'] * $pollRes['count']) : 0;
  50.       echo '<div style="background: #fff; border: 1px solid #ccc;"><div style="background:green; height: 5px; width: '.$poll_count.'%; min-width: 3px"></div></div>';
  51.     }
  52.  
  53.     echo 'Проголосовало: '.($user_id ? '<a href="index.php?act=polled&amp;topic='.$topic.'">'.$pollSet['total_polled'].'</a>' : $pollSet['total_polled']);
  54.     if ($user_id && !$pollCheck && !$pollSet['poll_close'])
  55.       echo '<br /><a href="index.php?topic='.$topic.'&amp;page='.$cur_page.'"><strong>Отдать голос</strong></a>';
  56.   }
  57.   echo '</div>';
  58. }
  59.  
  60. $total = $sql->query("SELECT COUNT(*) FROM `forum_posts` WHERE `refid` = '$topic' ")->result();
  61. $page = new page($total, $set['p_str']);
  62. if ($total){
  63.   $req = mysqli_query($sql->db, "SELECT `forum_posts`.*, `forum_posts`.`id` AS `pid`, `forum_posts`.`user` AS `name`, `user`.`nick`, `user`.`id`, `user`.`pol` FROM `forum_posts` LEFT JOIN `user` ON `forum_posts`.`user_id` = `user`.`id` WHERE `forum_posts`.`refid` = '$topic' ORDER BY `forum_posts`.`time` ASC LIMIT ".$page->limit());
  64.  
  65.  
  66.     $page->display('index.php?topic='.$topic.'&amp;');
  67.  
  68.   if ($topicRes['clip'] && $cur_page > 1){
  69.     echo '<div class="user">';
  70.     $firstPost =$sql->query("SELECT `forum_posts`.*, `forum_posts`.`id` AS `pid`, `user`.`id`, `user`.`pol`, `user`.`nick` FROM `forum_posts` LEFT JOIN `user` ON `forum_posts`.`user_id` = `user`.`id` WHERE `forum_posts`.`refid` = '$topic' ORDER BY `forum_posts`.`time` ASC LIMIT 1 ")->fetch();
  71.  
  72.     $postHeader = ' <span class="gray">'.Core::time($firstPost['time']).'</span> <a href="index.php?post='.$firstPost['pid'].'" title="Ссылка на пост">#1</a>';
  73.     
  74.     $postText = quote(text::output($firstPost['text']));
  75.  
  76.     if ($firstPost['files']){
  77.       $postFile = $sql->query("SELECT * FROM `forum_files` WHERE `refid` = '".$firstPost['pid']."' LIMIT ".$firstPost['files']." ");
  78.       $postText .= '<div class="func">Файл(ы):<br />';
  79.       while ($postFileRes = $sql->fetch()){
  80.         $postText .= show_file($postFileRes).'<br />';
  81.       }
  82.       $postText .= '</div>';
  83.     }
  84.  
  85.     if ($firstPost['edit']){
  86.       $edit = explode(':|:', $firstPost['edit']);
  87.       $postText .= '<div style="font-size: x-small; color: gray">Изменил(а) '.$edit['0'].' '.Core::time($edit['1']).'</div>';
  88.     }
  89.     
  90.     if ($firstPost['rating'] > 0) $color = 'C0FFC0';
  91.     elseif ($firstPost['rating'] < 0) $color = 'F196A8';
  92.     else $color = 'CCCCCC';
  93.     if ($user_id && $firstPost['user_id'] != $user_id){
  94.       $postText .= '<div style="font-size: x-small">Рейтинг: <a href="index.php?act=rating&amp;topic='.$topic.'&amp;post='.$firstPost['pid'].'&amp;plus"><img src="images/plus.png" alt="+" /></a> <span style="background:#'.$color.'">&nbsp;'.$firstPost['rating'].'&nbsp;</span> <a href="index.php?act=rating&amp;topic='.$topic.'&amp;post='.$firstPost['pid'].'&amp;minus"><img src="images/minus.png" alt="-" /></a></div>';
  95.     }else{
  96.       $postText .= '<div style="font-size: x-small">Рейтинг: <span style="background:#'.$color.'">&nbsp;'.$firstPost['rating'].'&nbsp;</span></div>';
  97.     }
  98.     
  99.     $postSub = '';
  100.     if ((($user_id == $firstPost['user_id']) && !$topicRes['close']) || $moder){
  101.       $postSub .= '<a href="index.php?act=editpost&amp;topic='.$topic.'&amp;post='.$firstPost['pid'].'&amp;page='.$cur_page.'">Изменить</a>  |  <a href="index.php?act=delpost&amp;topic='.$topic.'&amp;post='.$firstPost['pid'].'&amp;page='.$cur_page.'">Удалить</a>';
  102.     }
  103.     $postText .= '<br />'.$postSub;
  104.     $postArray = array('staus' => $postHeader, 'post' => $postText);
  105.     echo Core::user_show($firstPost, $postArray);
  106.     echo '</div>';
  107.   }
  108.  
  109.   if ($moder)
  110.     echo '<form action="index.php?act=massdelpost&amp;topic='.$topic.'&amp;page='.$cur_page.'" method="post">';
  111.   
  112.   $i = $page->start();
  113.   
  114.   while ($res = $sql->fetch($req)){
  115.     ++$i;
  116.     echo $i % 2 ? '<div name="p'.$res['pid'].'" id="p'.$res['pid'].'" class="p_m">' : '<div name="p'.$res['pid'].'" id="p'.$res['pid'].'" class="p_t">';
  117.    
  118.     $header = ' <span class="gray">'.Core::time($res['time']).'</span> <a href="index.php?post='.$res['pid'].'" title="Ссылка на пост">#'.$i.'</a>';
  119.  
  120.     $text = quote(text::output($res['text']));
  121.  
  122.  
  123.     if ($res['files']){
  124.       $file = $sql->query("SELECT * FROM `forum_files` WHERE `refid` = '".$res['pid']."' LIMIT ".$res['files']." ");
  125.       $text .= '<div class="func">Файл(ы):<br />';
  126.       while($fileRes = $sql->fetch()){
  127.         $text .= show_file($fileRes).'<br />';
  128.       }
  129.       $text .= '</div>';
  130.     }
  131.     
  132.     if ($res['edit']){
  133.       $edit = explode(':|:', $res['edit']);
  134.       $text .= '<div style="font-size: x-small; color: gray">Изменил(а) '.$edit['0'].' '.Core::time($edit['1']).'</div>';
  135.     }
  136.     
  137.     if ($res['rating'] > 0) $color = 'C0FFC0';
  138.     elseif ($res['rating'] < 0) $color = 'F196A8';
  139.     else $color = 'CCCCCC';
  140.     if ($user_id && $res['user_id'] != $user_id && !$topicRes['close']){
  141.       $text .= '<div style="font-size: x-small">Рейтинг: <a href="index.php?act=rating&amp;topic='.$topic.'&amp;post='.$res['pid'].'&amp;plus"><img src="images/plus.png" alt="+" /></a> <span style="background:#'.$color.'">&nbsp;'.$res['rating'].'&nbsp;</span> <a href="index.php?act=rating&amp;topic='.$topic.'&amp;post='.$res['pid'].'&amp;minus"><img src="images/minus.png" alt="-" /></a></div>';
  142.     }else{
  143.       $text .= '<div style="font-size: x-small">Рейтинг: <span style="background:#'.$color.'">&nbsp;'.$res['rating'].'&nbsp;</span></div>';
  144.     }
  145.      
  146.     $sub = '';
  147.     if (($user_id && $user_id != $res['user_id'] && !$topicRes['close']) || ($user_id != $res['user_id'] && $moder)){
  148.       $sub .= '<a href="index.php?act=addpost&amp;post='.$res['pid'].'&amp;topic='.$topic.'&amp;page='.$cur_page.'">Ответ</a> <a href="index.php?act=addpost&amp;quote&amp;post='.$res['pid'].'&amp;topic='.$topic.'&amp;page='.$cur_page.'">Цитата</a>';
  149.     }
  150.  
  151.     if ((($user_id == $res['user_id'] && !$topicRes['close'] && $res['time'] > time() - 300) || ($user_id == $res['user_id'] && (!$i && (!$cur_page || $cur_page == 1)))) || ($moder)){
  152.       $sub .= ' <a href="index.php?act=editpost&amp;topic='.$topic.'&amp;post='.$res['pid'].'&amp;page='.$cur_page.'">Изменить</a>  |  <a href="index.php?act=delpost&amp;topic='.$topic.'&amp;post='.$res['pid'].'&amp;page='.$cur_page.'">Удалить</a>';
  153.     }
  154.     if ($moder)
  155.       $sub .= '<input type="checkbox" name="delch[]" value="'.$res['pid'].'" /> ';
  156.  
  157. $text .= $sub;
  158.  
  159.     $array = array('status' => $header, 'post' => $text);
  160.     echo Core::user_show($res, $array);
  161.     echo '</div>';
  162.     
  163.   }
  164.   if (!$i) echo '<div class="p_m">Неверные данные. Убедитесь в правильности ввода страницы!</div>';
  165.  
  166.   if ($moder)
  167.     echo '<div class="rmenu"><input type="submit" value="Удалить" /></div></form>';
  168.  
  169. }else{
  170.   echo '<div class="p_m">Пусто</div>';
  171. }
  172.  
  173. if (($user_id && !$topicRes['close']) || $moder){
  174.   echo '<div class="msg"><form id="form" name="form" action="index.php?act=addpost&amp;topic='.$topic.'&amp;page='.$cur_page.'" method="post">';
  175.  
  176.     echo 'Быстрый ответ <img style="cursor: pointer;" onclick="alert(this.title);" src="images/question.png" alt="?" title="Для предпросмотра или прикрепления файлов нажмите на кнопку: Расшир. форма" />:<br /><textarea name="text"></textarea>';
  177.     echo '<br /><input type="submit" name="send" value="Отправить" /> <input type="submit" name="preview" value="Расшир. форма" />';
  178.  
  179.   echo '</form></div>';
  180. }
  181.  
  182. if ($total){
  183.   echo '<div  name="down" id="down" class="fmenu"><a href="#up">↑</a> Сообщений: '.$total.'</div>';
  184.  
  185.     $page->display('index.php?topic='.$topic.'&amp;');
  186.  
  187. }
  188.  
  189. $onltime = time() - 300;
  190. $online_u = $sql->query("SELECT COUNT(*) FROM `user` WHERE `date_last` > $onltime AND `url` = 'forum,$topic' ")->result();
  191.  
  192. if ($topicRes['curator']){
  193.   $curator = $sql->query("SELECT `lastdate`, `sex`, `datereg`, `id`, `name` FROM `users` WHERE `id` = '".$topicRes['curator']."' LIMIT 1 ")->fetch();
  194.   $arrayCurator = array('header' => '', 'body' => '', 'sub' => '', 'iphide' => 1);
  195.   core::$user_set['avatar'] = 0;
  196.   echo '<p>Куратор темы: '.functions::display_user($curator, $arrayCurator).'</p>';
  197. }
  198.  
  199. echo '<p><a href="index.php?act=search&amp;topic='.$topic.'">Поиск</a><br />
  200. <a href="index.php?act=onforum&amp;topic='.$topic.'">Кто в теме</a> ('.$online_u.')<br />
  201. <a href="rss.php?topic='.$topic.'">Rss-канал</a><br />
  202. <a href="index.php?act=loadtopic&amp;topic='.$topic.'&amp;">Скачать тему</a><br />
  203. ';
  204.  
  205. if ($user_id){
  206.   $favourites = $sql->query("SELECT COUNT(*) FROM `forum_favourites` WHERE `topic` = '$topic' AND `user_id` = '$user_id' LIMIT 1 ")->result();
  207.   echo $favourites ? '<a href="index.php?act=my&amp;delfavourite&amp;topic='.$topic.'&amp;page='.$cur_page.'">Из избранного</a><br />' : '<a href="index.php?act=my&amp;addfavourite&amp;topic='.$topic.'&amp;page='.$cur_page.'">В избранное</a><br />';
  208. }
  209.  
  210. echo '<a href="index.php?act=files&amp;topic='.$topic.'">Файлы темы</a></p>';
  211.  
  212. if ($moder){
  213.   echo '<div class="rmenu"><a href="index.php?act=edittopic&amp;topic='.$topic.'&amp;page='.$cur_page.'">Изменить</a> &nbsp; ';
  214.   echo $moder ? ' <a href="index.php?act=deltopic&amp;topic='.$topic.'">Удалить</a> &nbsp; ' : '';
  215.   echo ' <a href="index.php?act=movetopic&amp;topic='.$topic.'&amp;page='.$cur_page.'">Перенести</a>';
  216.   echo '</div>';
  217. }