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

Конкурс дизайнеров на 15000 рублей
БИРЖА РЕКЛАМЫ С ПРЯМЫМИ ССЫЛКАМИ
Размер файла: 11.63Kb 
  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. echo implode(' › ', $tree);
  24. echo '</div>'; 
  25.  
  26. if ($topicRes['close'])
  27.   echo '<div class="error">Тема закрыта!</div>';
  28.  
  29. if ($topicRes['poll_name']){
  30.   if ($user_id)
  31.     $pollCheck = $sql->query("SELECT COUNT(*) FROM `forum_polled` WHERE `refid` = '$topic' AND `user_id` = '$user_id' LIMIT 1 ")->result();
  32.  
  33.  
  34.   echo '<div class="msg"><strong>'.text::output($topicRes['poll_name']).'</strong><br />';
  35.   if ($pollSet['poll_close'] == 0 && !isset($_GET['results']) && $user_id && $pollCheck == 0 && !$topicRes['close']){
  36.     echo '<form action="index.php?act=poll&amp;topic='.$topic.'&amp;page='.$cur_page.'" method="post">';
  37.     while ($pollRes = mysqli_fetch_assoc($pollReq))
  38.     {
  39.       echo '<label><input type="'.($pollSet['poll_mod'] < 1 ? 'radio' : 'checkbox').'" name="var[]" value="'.$pollRes['id'].'" /> '.text::output($pollRes['name']).'</label><br />';          
  40.     }
  41.     echo '<input type="submit" name="poll" value="Отдать голос" /><br /><a href="index.php?topic='.$topic.'&amp;page='.$cur_page.'&amp;results"><strong>Результаты</strong></a></form>';  
  42.   }else{
  43.    
  44.     while ($pollRes = mysqli_fetch_assoc($pollReq)){
  45.       echo text::output($pollRes['name']).' ('.$pollRes['count'].')<br />';
  46.       $poll_count = $pollSet['total_polls'] ? @round(100 / $pollSet['total_polls'] * $pollRes['count']) : 0;
  47.       echo '<div style="background: #fff; border: 1px solid #ccc;"><div style="background:green; height: 5px; width: '.$poll_count.'%; min-width: 3px"></div></div>';
  48.     }
  49.  
  50.     echo 'Проголосовало: '.($user_id ? '<a href="index.php?act=polled&amp;topic='.$topic.'">'.$pollSet['total_polled'].'</a>' : $pollSet['total_polled']);
  51.     if ($user_id && !$pollCheck && !$pollSet['poll_close'])
  52.       echo '<br /><a href="index.php?topic='.$topic.'&amp;page='.$cur_page.'"><strong>Отдать голос</strong></a>';
  53.   }
  54.   echo '</div>';
  55. }
  56.  
  57. $total = $sql->query("SELECT COUNT(*) FROM `forum_posts` WHERE `refid` = '$topic' ")->result();
  58. $page = new page($total, $set['p_str']);
  59. if ($total){
  60.   $req = mysqli_query($sql->db, "SELECT `forum_posts`.*, `forum_posts`.`id` AS `pid`, `forum_posts`.`user` AS `name`, `user`.`date_last`,`user`.`nick`, `user`.`id`, `user`.`pol`, `user`.`group_access` 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());
  61.  
  62.     $page->display('index.php?topic='.$topic.'&amp;');
  63.  
  64.   if ($topicRes['clip'] && $cur_page > 1){
  65.     echo '<div class="user">';
  66.     $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();
  67.  
  68.     $postHeader = ' <span class="gray">'.Core::time($firstPost['time']).'</span> <a href="index.php?post='.$firstPost['pid'].'" title="Ссылка на пост">#1</a>';
  69.     
  70.     $postText = quote(text::output($firstPost['text']));
  71.  
  72.     if ($firstPost['files']){
  73.       $postFile = $sql->query("SELECT * FROM `forum_files` WHERE `refid` = '".$firstPost['pid']."' LIMIT ".$firstPost['files']." ");
  74.       $postText .= '<div class="func">Файл(ы):<br />';
  75.       while ($postFileRes = $sql->fetch()){
  76.         $postText .= show_file($postFileRes).'<br />';
  77.       }
  78.       $postText .= '</div>';
  79.     }
  80.  
  81.     if ($firstPost['edit']){
  82.       $edit = explode(':|:', $firstPost['edit']);
  83.       $postText .= '<div style="font-size: x-small; color: gray">Изменил(а) '.$edit['0'].' '.Core::time($edit['1']).'</div>';
  84.     }
  85.     
  86.     if ($firstPost['rating'] > 0) $color = 'C0FFC0';
  87.     elseif ($firstPost['rating'] < 0) $color = 'F196A8';
  88.     else $color = 'CCCCCC';
  89.     if ($user_id && $firstPost['user_id'] != $user_id){
  90.       $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>';
  91.     }else{
  92.       $postText .= '<div style="font-size: x-small">Рейтинг: <span style="background:#'.$color.'">&nbsp;'.$firstPost['rating'].'&nbsp;</span></div>';
  93.     }
  94.     
  95.     $postSub = '';
  96.     if ((($user_id == $firstPost['user_id']) && !$topicRes['close']) || $moder){
  97.       $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>';
  98.     }
  99.     $postText .= '<br />'.$postSub;
  100.     $postArray = array('staus' => $postHeader, 'post' => $postText);
  101.     echo Core::user_show($firstPost, $postArray);
  102.     echo '</div>';
  103.   }
  104.  
  105.   if ($moder)
  106.     echo '<form action="index.php?act=massdelpost&amp;topic='.$topic.'&amp;page='.$cur_page.'" method="post">';
  107.   
  108.   
  109.   while ($res = $sql->fetch($req)){
  110.  
  111.     echo '<div name="p'.$res['pid'].'" id="p'.$res['pid'].'" class="'.($res['id'] == $topicRes['user_id'] ? 'p_t' : 'p_m').'">';
  112.  
  113.     $header = ' <span class="gray">'.Core::time($res['time']).'</span> <a href="index.php?post='.$res['pid'].'" title="Ссылка на пост">#'.$i++.'</a>';
  114.  
  115.     $text = quote(text::output($res['text']));
  116.  
  117.  
  118.     if ($res['files']){
  119.       $file = $sql->query("SELECT * FROM `forum_files` WHERE `refid` = '".$res['pid']."' LIMIT ".$res['files']." ");
  120.       $text .= '<div class="news" style="clear:both">Файлы:<br />';
  121.       while($fileRes = $sql->fetch()){
  122.         $text .= show_file($fileRes).'<br />';
  123.       }
  124.       $text .= '</div>';
  125.     }
  126.     
  127.     if ($res['edit']){
  128.       $edit = explode(':|:', $res['edit']);
  129.       $text .= '<div style="font-size: x-small; color: gray">изменено: '.$edit['0'].' '.Core::time($edit['1']).'</div>';
  130.     }
  131.     
  132.     $sub = '';
  133.     
  134.     if ($res['rating'] > 0) $color = 'C0FFC0';
  135.     elseif ($res['rating'] < 0) $color = 'F196A8';
  136.     else $color = 'CCCCCC';
  137.     if ($user_id && $res['user_id'] != $user_id && !$topicRes['close']){
  138.       $sub .= '<br />[&nbsp;&nbsp;<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>&nbsp;&nbsp;]&nbsp;&nbsp;';
  139.     }else{
  140.       $sub .= '<br />[&nbsp;&nbsp;<span style="background:#'.$color.'">&nbsp;'.$res['rating'].'&nbsp;</span>&nbsp;&nbsp;]&nbsp;';
  141.     }
  142.      
  143.     
  144.     if (($user_id && $user_id != $res['user_id'] && !$topicRes['close']) || ($user_id != $res['user_id'] && $moder)){
  145.       $sub .= '[&nbsp;&nbsp;<a href="index.php?act=addpost&amp;post='.$res['pid'].'&amp;topic='.$topic.'&amp;page='.$cur_page.'">Ответ</a>&nbsp;&nbsp;]&nbsp;[&nbsp;&nbsp;<a href="index.php?act=addpost&amp;quote&amp;post='.$res['pid'].'&amp;topic='.$topic.'&amp;page='.$cur_page.'">Цитата</a>&nbsp;&nbsp;]&nbsp;';
  146.     }
  147.  
  148.     if ((($user_id == $res['user_id'] && !$topicRes['close'] && $res['time'] > time() - 300) || ($user_id == $res['user_id'] && (!$i && (!$cur_page || $cur_page == 1)))) || ($moder)){
  149.       $sub .= '[&nbsp;&nbsp;<a href="index.php?act=editpost&amp;topic='.$topic.'&amp;post='.$res['pid'].'&amp;page='.$cur_page.'">Изменить</a>&nbsp;&nbsp;]&nbsp;[&nbsp;&nbsp;<a href="index.php?act=delpost&amp;topic='.$topic.'&amp;post='.$res['pid'].'&amp;page='.$cur_page.'">Удалить</a>&nbsp;&nbsp;]';
  150.     }
  151.     if ($moder)
  152.       $sub .= ' <input type="checkbox" name="delch[]" value="'.$res['pid'].'" /> ';
  153.  
  154. $text .= $sub;
  155.  
  156.     $array = array('status' => $header, 'post' => $text);
  157.     echo Core::user_show($res, $array, 'new');
  158.     echo '</div>';
  159.     
  160.   }
  161.  
  162.   if ($moder)
  163.     echo '<div class="rmenu"><input type="submit" value="Удалить" /></div></form>';
  164.  
  165. }else{
  166.   echo '<div class="p_m">Пусто</div>';
  167. }
  168.  
  169. if (($user_id && !$topicRes['close']) || $moder){
  170.   echo '<div class="msg"><form id="form" name="form" action="index.php?act=addpost&amp;topic='.$topic.'&amp;page='.$cur_page.'" method="post">';
  171.  
  172.     echo 'Быстрый ответ <img style="cursor: pointer;" onclick="alert(this.title);" src="images/question.png" alt="?" title="Для предпросмотра или прикрепления файлов нажмите на кнопку: Расшир. форма" />:<br /><textarea name="text" style="width:70%;height:50px"></textarea>';
  173.     echo '<br /><input type="submit" name="send" value="Отправить" /> <input type="submit" name="preview" value="Расшир. форма" />';
  174.  
  175.   echo '</form></div>';
  176. }
  177.  
  178. if ($total){
  179.   echo '<div  name="down" id="down" class="fmenu"><a href="#up">↑</a> Сообщений: '.$total.'</div>';
  180.  
  181.     $page->display('index.php?topic='.$topic.'&amp;');
  182.  
  183. }
  184.  
  185.  
  186. if ($topicRes['curator']){
  187.   $curator = $sql->query("SELECT `id`, `nick`, `date_reg`, `date_last`, `pol`, `group_access` FROM `user` WHERE `id` = '".$topicRes['curator']."' LIMIT 1 ")->fetch();
  188.   echo '<div class="menu_razd">Куратор темы: '.Core::user_show($curator).'</div>';
  189. }
  190.  
  191. echo '<div class="menu"><a href="index.php?act=search&amp;topic='.$topic.'">Поиск</a><br />
  192. <a href="index.php?act=loadtopic&amp;topic='.$topic.'&amp;">Скачать тему</a><br />
  193. ';
  194.  
  195. if ($user_id){
  196.   $favourites = $sql->query("SELECT COUNT(*) FROM `forum_favourites` WHERE `topic` = '$topic' AND `user_id` = '$user_id' LIMIT 1 ")->result();
  197.   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 />';
  198. }
  199.  
  200. echo '<a href="index.php?act=files&amp;topic='.$topic.'">Файлы темы</a></div>';
  201.  
  202. if ($moder || (isset($curator['id']) && $curator['id'] == $user_id))
  203. {
  204.   echo '<div class="menu"><a href="index.php?act=edittopic&amp;topic='.$topic.'&amp;page='.$cur_page.'">Изменить</a> <br />';
  205.   echo $moder ? ' <a href="index.php?act=deltopic&amp;topic='.$topic.'">Удалить</a> <br /><a href="index.php?act=movetopic&amp;topic='.$topic.'&amp;page='.$cur_page.'">Перенести</a>' : '';
  206.   echo '</div>';
  207. }