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

Конкурс дизайнеров на 15000 рублей
Милый пушистый сайт !!!!
Размер файла: 9.67Kb 
  1. <?php
  2.  
  3. # Forum by seg0ro (http://mobilarts.ru)
  4.  
  5. include '../engine/includes/start.php';
  6. require_once ('includes/functions.php');
  7. include_once 'includes/journal.php';
  8. $set['title'] = 'Форум';
  9. $i = 1;
  10. Core::get(array('page.class', 'text.class'), 'classes');
  11.  
  12. if ($forum){
  13.   $sql->query("SELECT * FROM `forum_forums` WHERE `id` = '$forum' LIMIT 1 ");
  14.   if (!$sql->num_rows()){
  15.     include H . 'engine/includes/head.php';
  16.     echo Core::msg_show('Такого форума не существует!<br /><a href="index.php">Форум</a>');
  17.     include H . 'engine/includes/foot.php';
  18.     
  19.   }
  20.   $forumRes = $sql->fetch();
  21.  
  22.   if ($forumRes['refid'])
  23.     $forumRefid = $sql->query("SELECT `name` FROM `forum_forums` WHERE `id` = '".$forumRes['refid']."' LIMIT 1 ")->fetch();
  24.     $set['title'] = htmlspecialchars($forumRes['name']);
  25. }
  26.  
  27. if($topic){
  28.   $topicReq = $sql->query("SELECT * FROM `forum_topics` WHERE `id` = '$topic' LIMIT 1 ");
  29.   if (!$sql->num_rows()){
  30.     include H . 'engine/includes/head.php';
  31.     echo Core::msg_show('Такой темы не существует!<br /><a href="index.php">Форум</a>');
  32.     include H . 'engine/includes/foot.php';
  33.     
  34.   }
  35.   $topicRes = $sql->fetch();
  36.  
  37.   if (!empty($topicRes['poll_name'])){
  38.     $pollReq = mysqli_query($sql->db, "SELECT * FROM `forum_polls` WHERE `refid` = '$topic' ORDER BY `id` ASC LIMIT 20 ");
  39.     $pollSet = unserialize($topicRes['poll_set']);
  40.   }
  41.  
  42.   $set['title'] = htmlspecialchars($topicRes['name']);
  43.  
  44.   if($post){
  45.     $sql->query("SELECT * FROM `forum_posts` WHERE `id` = '$post' LIMIT 1 ");
  46.     if (!$sql->num_rows()){
  47.       include H . 'engine/includes/head.php';
  48.       echo Core::msg_show('Такого поста не существует!<br /><a href="index.php">Форум</a>');
  49.       include H . 'engine/includes/foot.php';
  50.       
  51.     }
  52.     $postRes = $sql->fetch();
  53.  
  54.     $set['title'] = htmlspecialchars($topicRes['name']).' | Пост: '.$post;
  55.   }else{
  56.     $topicRefid = $sql->query("SELECT `id`, `refid`, `name` FROM `forum_forums` WHERE `id` = '".$topicRes['refid']."' LIMIT 1 ")->result();
  57.   }
  58.  
  59.   if ($user_id && $topicRes['curator'] == $user_id)
  60.     $rights = 3;
  61.  
  62. }
  63.  
  64. if($file){
  65.   $fileReq = mysqli_query($sql->db, "SELECT * FROM `forum_files` WHERE `id` = '$file' LIMIT 1 ");
  66.   if (!mysqli_num_rows($fileReq)){
  67.     include H . 'engine/includes/head.php';
  68.     echo Core::msg_show('Такого файла не существует!<br /><a href="index.php">Форум</a>');
  69.     include H . 'engine/includes/foot.php';
  70.     
  71.   }
  72.   $fileRes = mysqli_fetch_assoc($fileReq);
  73.  
  74.   $fileRefid = $sql->query("SELECT `id`, `name`, `close` FROM `forum_topics` WHERE `id` = '".$fileRes['topic']."' LIMIT 1 ")->fetch();
  75.  
  76.   $set['title'] = title($fileRefid['name']).' | Файл: '.$file;
  77. }
  78.  
  79. $arrayIncludes = array('addforum', 'addpost', 'addtopic', 'clean', 'delfile', 'delforum', 'delpoll', 'delpost', 'deltopic', 'download', 'editforum', 'editpost', 'edittopic', 'files', 'last', 'loadtopic', 'massdelpost', 'movetopic', 'moveforum', 'my', 'onforum', 'poll', 'polled', 'rating', 'search');
  80.  
  81. if (in_array($act, $arrayIncludes) && file_exists('includes/'.$act.'.php')){
  82.   require_once ('includes/'.$act.'.php');
  83. }else{
  84.   
  85.   include H . 'engine/includes/head.php';
  86.  
  87.     
  88.   if ($topic){
  89.     if (isset($_GET['unread'])){
  90.       $resReaded = $sql->query("SELECT `time`, `lastpost` FROM `forum_readed` WHERE `topic` = '$topic' AND `user_id` = '$user_id' LIMIT 1 ")->fetch();
  91.       if ($resReaded['time'] && $resReaded['lastpost'] > 0){
  92.         $gopage = ceil($sql->query("SELECT COUNT(*) FROM `forum_posts` WHERE `refid` = '$topic' AND `id` <= '".$resReaded['lastpost']."' ")->result() / $set['p_str']);
  93.         header ('Location: index.php?topic='.$topic.'&page='.$gopage.'#p'.$resReaded['lastpost']);
  94.       }else{
  95.         header ('Location: index.php?topic='.$topic);
  96.       }
  97.       include H . 'engine/includes/foot.php';
  98.       
  99.     }
  100.     
  101.     require_once('includes/showtopic.php');
  102.     include H . 'engine/includes/foot.php';
  103.     
  104.   }
  105.   
  106.   if ($post){
  107.     $sql->query("SELECT `refid` FROM `forum_posts` WHERE `id` = '$post' LIMIT 1 ");
  108.     if (!$sql->num_rows()){
  109.       include H . 'engine/includes/head.php';
  110.       echo Core::msg_show('Такого поста не существует!<br /><a href="index.php">Форум</a>');
  111.       include H . 'engine/includes/foot.php';
  112.       
  113.     }
  114.     $postRes = $sql->fetch(); 
  115.   
  116.     $go = ceil(($sql->query("SELECT COUNT(*) FROM `forum_posts` WHERE `refid` = '".$postRes['refid']."' AND `id` <= '$post' ")->result()) / $set['p_str']);
  117.  
  118.     header('Location: index.php?topic='.$postRes['refid'].'&page='.$go.'#p'.$post);
  119.  
  120.     include H . 'engine/includes/foot.php';
  121.     
  122.   }
  123.   if ($admin)
  124.     echo '
  125. <script language="JavaScript" type="text/javascript">function show_hide(elem) {
  126.   obj = document.getElementById(elem);
  127.   if(obj.style.display == "none") obj.style.display = "inline";
  128.   else obj.style.display = "none";
  129. }</script>
  130. ';
  131.   
  132.   if ($forum){
  133.     if ($forumRes['refid'])
  134.       $tree = array('<a href="index.php">Форум</a>', '<a href="index.php?forum='.$forumRes['refid'].'">'.text::output($forumRefid['name']).'</a>', text::output($forumRes['name']));
  135.     else
  136.       $tree = array('<a href="index.php">Форум</a>', text::output($forumRes['name']));
  137.   }else{
  138.     $tree = array('Форум');
  139.     
  140.     $total = $sql->query("SELECT * FROM `forum_forums` WHERE `refid` < '1' ORDER BY `realid` ASC ")->num_rows();
  141.     
  142.   }
  143.   
  144.   echo forum_counter();
  145.   echo '<div class="fmenu">';
  146.   foreach ($tree as $menu)
  147.     {
  148.         echo $menu . '  &nbsp;  ';
  149.     }
  150.   echo '</div>';
  151.   
  152.   if ($user_id && $forum && $forumRes['type'] == 1)
  153.       echo '<div class="msg"><a href="index.php?act=addtopic&amp;forum='.$forum.'">Новая тема</a></div>';
  154.   
  155.   
  156.   if ($forum){
  157.     if ($forumRes['type'] == 1){
  158.       $total = $sql->query("SELECT COUNT(*) FROM `forum_topics` WHERE `refid` = '$forum' ")->result();
  159.         $page = new page($total, $set['p_str']);
  160.     
  161.       if ($total){
  162.         $sql->query("SELECT * FROM `forum_topics` WHERE `refid` = '$forum' ORDER BY `time` DESC LIMIT ".$page->limit()); // `sticky` DESC,
  163.  
  164.         if ($page->k_page() > 5)
  165.             $page->display('index.php?forum='.$forum.'&amp;');
  166.     
  167.         while ($res = $sql->fetch()){
  168.  
  169.           echo $i % 2 ? '<div class="p_t">' : '<div class="p_m">'; 
  170.           $sub = 'Автор: '.$res['user'];
  171.             if ($res['count'] > 1){
  172.               $lastPost = explode(':|:', $res['lastpost']);
  173.               $sub .= ' <a href="index.php?post='.$lastPost[1].'">Посл.</a>: '.$lastPost[0];
  174.             }
  175.             $sub .= ' '.Core::time($res['time']).'<br />';
  176.           echo show_topic($res, $sub);
  177.           echo '</div>';
  178.           ++$i;
  179.         }
  180.         
  181.         echo '<div class="fmenu">Тем: '.$total.'</div>';
  182.        
  183.         $page->display('index.php?forum='.$forum.'&amp;');
  184.         
  185.       }else{
  186.         echo '<div class="p_m">Пусто</div>';
  187.       }  
  188.       $adm = '<a href="index.php?act=editforum&amp;forum='.$forum.'">Изменить форум</a>';  
  189.     }else{
  190.       $req = $sql->query("SELECT * FROM `forum_forums` WHERE `refid` = '$forum' ORDER BY `realid` ASC ");
  191.       $total = $sql->num_rows();
  192.       if ($total){
  193.         while ($res = $sql->fetch()){
  194.           echo $i % 2 ? '<div class="p_t">' : '<div class="p_m">'; 
  195.           echo show_folder($res);  
  196.           echo '</div>';
  197.           ++$i;
  198.         }
  199.         
  200.         echo '<div class="fmenu">Подфорумов: '.$total.'</div>';  
  201.       }else{
  202.         echo '<div class="post">Пусто</div>';
  203.       }
  204.       
  205.       $adm = '<a href="index.php?act=addforum&amp;forum='.$forum.'">Создать подфорум</a><br /><a href="index.php?act=editforum&amp;forum='.$forum.'">Изменить форум</a>';
  206.     }
  207.   
  208.   }
  209.     else
  210.     {
  211.     $total = $sql->query("SELECT COUNT(*) FROM `forum_forums` WHERE `refid` = '$forum'")->result();
  212.     $page = new page($total, $set['p_str']);
  213.     $sql->query("SELECT * FROM `forum_forums` WHERE `refid` = '$forum' ORDER BY `realid`  DESC LIMIT ". $page->limit());
  214.     if($total){
  215.       while ($res = $sql->fetch()){
  216.         echo $i % 2 ? '<div class="p_t">' : '<div class="p_m">'; 
  217.         echo show_folder($res);  //echo '<br />'.var_dump($res);
  218.         echo '</div>';
  219.         ++$i;
  220.       }
  221.       
  222.       $topics = $sql->query("SELECT COUNT(*) FROM `forum_topics` ")->result();
  223.       $posts = $sql->query("SELECT COUNT(*) FROM `forum_posts` ")->result();
  224.       echo '<div class="fmenu">Тем: '.$topics.', Сообщений: '.$posts.'</div>';  
  225.     }else{
  226.       echo '<div class="p_m">Пусто</div>';
  227.     }
  228.     
  229.     $adm = '<a href="index.php?act=addforum">Создать форум</a><br /><a href="index.php?act=clean">Чистка форума</a>';
  230.   }
  231.   
  232.   echo '<div class="menu"><a href="index.php?act=search">Поиск</a><br /><a href="index.php?act=files">Файлы форума</a></div>';
  233.  
  234.   if ($forum && $forumRes['type'] == 1){
  235.     echo '<p><img src="images/new.png" alt="+" title="Есть новые сообщения" /> Есть новые сообщения <small>(только для зарегистрированых)</small><br />
  236. <img src="images/sticky.png" alt="^" title="Тема закреплена" /> Прикреплённая тема<br />
  237. <img src="images/close.png" alt="#" title="Тема закрыта" /> Закрытая тема<br />
  238. <img src="images/poll.png" alt="*" title="Голосование" /> В теме есть голосование</p>';  
  239.   }
  240.     
  241.   if ($admin)
  242.     echo '<div class="menu">'.$adm.'</div>';
  243. }
  244.  
  245. include H . 'engine/includes/foot.php';