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

Конкурс дизайнеров на 15000 рублей
контркультура падонки бабруйск
Размер файла: 37.52Kb 
  1. <?php
  2.  
  3. require"../system/config.php";
  4. require"../system/func.php";
  5. if(!empty($_GET['id_them']) and !empty($_GET['id_forum'])){$qaq=mysql_fetch_assoc(mysql_query("SELECT `ftname` FROM `forum_themes` WHERE `id_them`='".$_GET['id_them']."' LIMIT 1")); $title=$qaq['ftname'];}
  6.  
  7. if(!empty($_GET['id_forum']) and empty($_GET['id_them'])){$qaq=mysql_fetch_assoc(mysql_query("SELECT `fname` FROM `forum_kategory` WHERE `id_forum`='".$_GET['id_forum']."' LIMIT 1")); $title=$qaq['fname'];}
  8. if(empty($_GET['id_them']) or empty($_GET['id_forum'])){
  9.  
  10. $title='Форум';}
  11. require"../system/head.php";
  12. require"../system/error.php";
  13. $page = abs((int)$_GET['page']);
  14. $act = prov($_GET['act']);
  15. switch($mod){
  16. default:
  17. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  18.  
  19. echo'<div class="i">Форум<br></div>';
  20. echo'<div class="p"></a><a href="/pages/help.php">Помощь</a>|<a href="/forum/search.php?act=go">Поиск</a>|<a href="/pages/admins.php">Команда</a>|';
  21. echo'<a href="/forum/top-list.php">Топ-лист</a>|<a href="/forum/top-themes.php">Топ-тем</a><br>';
  22. if($vhod==1){echo'- <a href="/forum/my_themes.php">Мои темы</a><br>';}
  23. echo'- <a href="/forum/new_themes.php">Новые темы</a></div>';
  24. $forums=mysql_query("select * from forum_kategory where gde='0' order by id_forum desc");
  25. $kol=mysql_num_rows($forums);
  26. $pforums=mysql_query("select * from forum_kategory where gde='$id_forum' order by id_forum desc");
  27. $pkol=mysql_num_rows($pforums);
  28. if($kol==0){
  29. echo'<div class="p">
  30. Пока нет разделов...<br>
  31. </div>';
  32. }else{
  33. while($forum=mysql_fetch_array($forums)){
  34. $themes=mysql_num_rows(mysql_query("select * from forum_themes where id_kat='".$forum['id_forum']."'"));
  35. $messages=mysql_num_rows(mysql_query("select * from forum_messages where id_kat='".$forum['id_forum']."'"));
  36. echo'<div class="i"><a href="/forum/'.$forum['id_forum'].'/">'.$forum['fname'].'</a> ['.(PodTem($forum['id_forum'])+$themes).'/'.(PodMes($forum['id_forum'])+$messages).']
  37. </div>'; 
  38.  
  39. if($id_forum==$forum['id_forum']){
  40. if($pkol!=0){
  41. while($pforum=mysql_fetch_array($pforums)){
  42. $pthemes=mysql_num_rows(mysql_query("select * from forum_themes where id_kat='".$pforum['id_forum']."'"));
  43. $pmessages=mysql_num_rows(mysql_query("select * from forum_messages where id_kat='".$pforum['id_forum']."'"));
  44. echo'<div class="p"><img src="/design/default/act.gif" alt="-"> <a href="/forum/view/'.$pforum['id_forum'].'/">'.$pforum['fname'].'</a> ['.(PodTem($pforum['id_forum'])+$pthemes).'/'.(PodMes($pforum['id_forum'])+$pmessages).']</div>';
  45. }}else{echo'Подфорумы не созданы';}
  46. }
  47.  
  48. }
  49. $onli=mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `gdeon` LIKE '/forum/%' AND `online`>'".(time()-120)."'"),0);
  50. $guei=mysql_result(mysql_query("SELECT COUNT(*) FROM `online` WHERE `query` LIKE '/forum/%' AND `timer`>'".(time()-120)."'"),0);
  51. $whodp=$onli+$guei;
  52.  
  53. $coufile=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f`!=''"),0);
  54. echo'<div class="p"><img src="/design/default/act.gif" alt="-"> <a href="/pages/online.php?act=forum">Online: '.$whodp.' ['.$onli.'/'.$guei.']</a><br>';
  55. if($vhod==1){echo'<img src="/design/default/act.gif" alt="-"> <a href="/pages/menu.php">Профиль</a><br><img src="/design/default/act.gif" alt="-"> 
  56. <a href="/pages/post.php">Приват</a><br>';}
  57. echo'<img src="/design/default/act.gif" alt="-"> <a href="/forum/new_messages.php">Найти новые</a><br><img src="/design/default/act.gif" alt="-"> <a href="/forum/files.php">Файлы форума</a> ['.$coufile.']</div>';
  58. }
  59. break;
  60. //Вывод тем раздела
  61. case'1':
  62. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  63. $razdel=mysql_query("select * from forum_kategory where id_forum='$id_forum' limit 1");
  64. if(mysql_num_rows($razdel)==0){
  65. echo'<div class="i">Форум<br></div>';
  66.  
  67. echo'<div class="p">Ошибка! Такого раздела форума не существует!<br></div>';
  68. }else{
  69. $nrazdel=mysql_fetch_assoc($razdel);
  70.  
  71. echo'<div class="p"><a href="/forum/?">Форум</a>|';
  72. if($nrazdel['gde']!=0){ $fng=mysql_fetch_assoc(mysql_query("SELECT `fname`,`id_forum` FROM `forum_kategory` WHERE `id_forum`='".$nrazdel['gde']."' AND `gde`='0' LIMIT 1")); echo'<a href="/forum/'.$fng['id_forum'].'/">'.$fng['fname'].'</a>|';} echo $nrazdel['fname'].'<br>
  73. </div>';
  74.  
  75.  
  76.  
  77. $num=10;
  78.  
  79. $kol=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_themes` WHERE `id_kat`='$id_forum'"),0);
  80. $total=$kol;
  81. if($page < 0 || $page > $total) $page = 0;
  82. if ($total < $page + 10) $end = $total;
  83. else $end = $page + 10;
  84. if($kol==0){
  85. if($nrazdel['stat']==0){echo'<div class="p">Пока нет тем...<br></div>';}
  86. }else{
  87. $vforum=mysql_query("select * from forum_themes where id_kat='$id_forum' order by zakr='1' desc, updater desc limit $page,$num");
  88. while($forum=mysql_fetch_array($vforum)){
  89. $messages=mysql_num_rows(mysql_query("select * from forum_messages where id_them='".$forum['id_them']."'"));
  90. echo'<div class="p">';
  91. if($forum['zakr']==1){echo'[!] ';}
  92. if($forum['otkr']==1){echo'[#] ';}
  93. echo'<a href="/forum/theme/'.$id_forum.'/'.$forum['id_them'].'/">'.$forum['ftname'].'</a> ['.$messages.'] ';
  94. if($messages==0){$nbp=mysql_fetch_assoc(mysql_query("SELECT `id_user` FROM `forum_themes` WHERE `id_them`='".$forum['id_them']."' LIMIT 1"));}else{
  95. $res=mysql_fetch_assoc(mysql_query("SELECT `id_mes`  FROM `forum_messages` WHERE `id_them`='".$forum['id_them']."' ORDER BY `timer` DESC LIMIT 1"));
  96. $nbp=mysql_fetch_assoc(mysql_query("SELECT `id_user` FROM `forum_messages` WHERE `id_mes`='".$res['id_mes']."' LIMIT 1"));}
  97. echo nik_tri($nbp['id_user']).' ';
  98. if($messages>10){
  99. $stbud=round($messages,-1);
  100. $skcf=strlen($messages);
  101. $skcf=strlen($messages);
  102. $poslc=substr($messages,($skcf-1),$skcf);
  103. if($poslc>=5 or $poslc=='0'){
  104. $stbud=$stbud-10;
  105. }
  106. echo'<a href="/forum/theme/'.$id_forum.'/'.$forum['id_them'].'/page='.$stbud.'"><b>&#187;</b></a><br>';
  107. }else{
  108. echo'<br>';
  109. }
  110. echo'</div>';
  111. }
  112. }
  113. echo'</div>';
  114. if($nrazdel['stat']==0){$coufile=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f`!='' AND `id_kat`='$id_forum'"),0); echo'<div class="p"><img src="/design/default/act.gif" alt="-"> <a href="/forum/files.php?id_forum='.$id_forum.'">Файлы подфорума</a> ['.$coufile.']</div>
  115. ';}}
  116. if($total>10){
  117. strmpage($page, 10, $total, "/forum/view/$id_forum/");}
  118. if($vhod==1){
  119. echo'<div class="p"><a href="/forum/?mod=2&amp;id_forum='.$id_forum.'" class="but">Начать новую тему</a><br></div>';
  120. }
  121.  break;
  122.  
  123.  
  124. //Форма добавления темы
  125. case'2':
  126. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  127. $razdel=mysql_query("select * from forum_kategory where id_forum='$id_forum' limit 1");
  128. if(mysql_num_rows($razdel)==0){
  129. echo'<div class="i">Форум<br></div>';
  130.  
  131. echo'<div class="p">Ошибка! Упущены обязательные данные!<br></div>';
  132. }else{
  133. if($vhod==1){
  134. echo'<div class="i">Новая тема<br></div>';
  135. echo'<div class="p"><form action="/forum/?mod=3&amp;id_forum='.$id_forum.'" method="post">
  136. Тема:<br>
  137. <input type="text" name="nathem" maxlength="150" size="18" class="form"><br>
  138. Сообщение:<br>
  139. <textarea cols="20" rows="3" name="soob" class="form"></textarea><br>';
  140. if($adm_pr==2 or $adm_pr==3 or $adm_pr==4){
  141. echo'<input type="checkbox" value="1" name="zakrep" class="form"> Закрепить<br>';
  142. }
  143. echo'<input type="submit" value="Добавить"  class="but"><br></form></div>';
  144. }else{
  145. echo'<div class="i">Форум<br></div>
  146. <div class="p">Ошибка! Добавлять темы могут только авторизованные пользователи!<br></div>';
  147. }
  148. }
  149.  
  150.  
  151. break;
  152.  
  153.  
  154. //Добавление темы
  155. case'3':
  156. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  157. $prerr=mysql_num_rows(mysql_query("SELECT * FROM `forum_kategory` WHERE `id_forum`='$id_forum' AND `stat`='1' LIMIT 1"));
  158.  
  159. if($prerr!=0){ echo'В этот подфорум,запрещено добавлять темы';
  160. require"../system/foot.php";
  161. exit;}
  162. $razdel=mysql_query("select * from forum_kategory where id_forum='$id_forum' limit 1");
  163. if(mysql_num_rows($razdel)==0){
  164. echo'<div class="i">Форум<br></div>';
  165. echo'<div class="p">Ошибка! Упущены обязательные данные!<br></div>';
  166. }else{
  167. if($vhod==1){
  168. if(isset($_POST['soob'])){$soob=prov($_POST['soob'],10000);}else{$soob='';}
  169. if(isset($_POST['nathem'])){$nathem=prov($_POST['nathem'],150);}else{$nathem='';}
  170. if(isset($_POST['zakrep'])){$zakrep=cifry($_POST['zakrep']);}else{$zakrep=0;}
  171. if($zakrep==1 and ($adm_pr==2 or $adm_pr==3 or $adm_pr==4)){$zakrep=1;}else{$zakrep=0;}
  172. echo'<div class="i">Новая тема<br></div>';
  173. if(empty($soob) or strlen($soob)<3 or empty($nathem) or strlen($nathem)<5){
  174. echo'<div class="p">Ошибка! Cообщение или тема слишком короткие!<br></div>';
  175. }else{
  176. $flud=mysql_num_rows(mysql_query("select * from forum_themes where id_user='$id_user' and timer>'".time()."'"));
  177. $povtor=mysql_num_rows(mysql_query("select * from forum_themes where id_user='$id_user' and ftname='$nathem'"));
  178. if($flud==0 and $povtor==0){
  179.  
  180. mysql_query("insert into forum_themes set id_kat='$id_forum', ftname='$nathem', fttext='$soob', ftdater='".date('d.m.Y - H:i:s')."', pervoe='".date('d.m.Y - H:i:s')."', timer='".(time()+8)."', id_user='$id_user', updater='".time()."', zakr='$zakrep'");
  181. mysql_query("update users set balls=balls+1 where id_user='$id_user' limit 1");
  182. $qm=mysql_fetch_assoc(mysql_query("SELECT `id_them`,`id_kat` FROM `forum_themes` ORDER BY `id_them` DESC LIMIT 1"));
  183. header('Location: /forum/theme/'.$qm['id_kat'].'/'.$qm['id_them'].'/isset=yestheme');
  184.  
  185. }else{
  186. echo'<div class="p">Ошибка! Вы слишком часто пытаетесь добавить тему либо такая тема уже есть в базе!<br></div>';
  187. }
  188. }
  189. }else{
  190. echo'<div class="i">Форум<br></div>
  191. <div class="p">Ошибка! Добавлять темы могут только авторизованные пользователи!<br></div>';
  192. }
  193. }
  194.  
  195. break;
  196. //Вывод сообщений темы
  197. case'4':
  198. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;}
  199. if(isset($_GET['id_forum'])){
  200. $id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  201. $razdel=mysql_query("select * from forum_kategory where id_forum='$id_forum' limit 1");
  202. $tema=mysql_query("select * from forum_themes where id_them='$id_them' limit 1");
  203. if(mysql_num_rows($tema)==0 or mysql_num_rows($razdel)==0){
  204. echo'<div class="i">Форум<br></div>';
  205. echo'<div class="p">Ошибка! Такой темы нет!<br></div>';
  206. }else{
  207. $nthem=mysql_fetch_array($tema);
  208. $fnt=mysql_fetch_assoc($razdel);
  209. echo'<div class="p"><a href="/forum/?">Форум</a>|';  
  210.  if($fnt['gde']!=0){ $fng=mysql_fetch_assoc(mysql_query("SELECT `fname`,`id_forum` FROM `forum_kategory` WHERE `id_forum`='".$fnt['gde']."' AND `gde`='0' LIMIT 1")); 
  211. echo'<a href="/forum/'.$fng['id_forum'].'/">
  212. '.$fng['fname'].'</a>|';}
  213. echo'<a href="/forum/view/'.$id_forum.'/">'.$fnt['fname'].'</a><br>'.vizual($nthem['ftname']).'</div>';
  214. if($nthem['otkr']==0 and ($adm_pr==2 or $adm_pr==3 or $adm_pr==4)){
  215. echo'<img src="/design/default/act.gif" alt="-"> <a href="/mpanel/control.php?mod=29&amp;id_them='.$id_them.'">Закрыть</a><br>';
  216. }
  217. if($nthem['otkr']==1){
  218. echo'<div class="p">Тема закрыта!<br></div>';
  219. if($adm_pr==2 or $adm_pr==3 or $adm_pr==4){
  220. echo'<img src="/design/default/act.gif" alt="-"> <a href="/mpanel/control.php?mod=30&amp;id_them='.$id_them.'">Открыть</a><br>';
  221. }
  222. }
  223.  
  224. if($nthem['zakr']==0 and ($adm_pr==2 or $adm_pr==3 or $adm_pr==4)){
  225. echo'<img src="/design/default/act.gif" alt="-"> <a href="/mpanel/control.php?mod=31&amp;id_them='.$id_them.'">Закрепить</a><br>';
  226. }
  227. if($nthem['zakr']==1){
  228. echo'<div class="p">Тема закреплена!<br></div>';
  229. if($adm_pr==2 or $adm_pr==3 or $adm_pr==4){
  230. echo'<img src="/design/default/act.gif" alt="-"> <a href="/mpanel/control.php?mod=32&amp;id_them='.$id_them.'">Открепить</a><br>';
  231. }
  232. }
  233. if($adm_pr==2 or $adm_pr==3 or $adm_pr==4){ echo'<img src="/design/default/act.gif" alt="-"> <a href="/mpanel/control.php?mod=56&amp;id_them='.$id_them.'">Перенести</a><br><img src="/design/default/act.gif" alt="-"> <a href="/mpanel/control.php?mod=43&amp;
  234. id_them='.$id_them.'">Удалить</a><br>';}
  235. if($vhod==1){
  236. $er5=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id_them' AND `id_kat`='$id_forum' AND `id_user`='$id_user'"));
  237. $er6=mysql_num_rows(mysql_query("SELECT * FROM `forum_votes` WHERE `id_them`='$id_them' AND `id_user`='$id_user'"));
  238. if($er5==1){
  239. if($er6==0){ 
  240. echo'<img src="/design/default/act.gif" alt="-"> <a href="/forum/?mod=26&amp;id_forum='.$id_forum.'&amp;id_them='.$id_them.'">Создать голосование</a><br>'; 
  241. }}}
  242. if($page<10){
  243. if($vhod==1){
  244.  
  245. $er1=mysql_num_rows(mysql_query("SELECT * FROM `forum_votes` WHERE `id_them`='$id_them'"));
  246. $er2=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id_them' AND `id_kat`='$id_forum'"));
  247. $er3=mysql_num_rows(mysql_query("SELECT * FROM `forum_votes_otv` WHERE `id_them`='$id_them' AND `id_user`='$id_user'"));
  248. if($er1>=1){
  249. if($er2==1){
  250. if($er3==0){
  251. if($_GET['act']!="vote"){
  252. $qw=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_votes` WHERE `id_them`='$id_them' AND `type`='name'"));
  253. if(time()<$qw['time']){
  254. echo'<form action="/forum/?mod=27&amp;id_forum='.$id_forum.'&amp;id_them='.$id_them.'" method="post"><table align="center" width="100%">';
  255.  
  256. $qj=mysql_query("SELECT * FROM `forum_votes` WHERE `id_them`='$id_them' AND `type`='text' ORDER BY `id`");
  257. echo'<tr><td><b>'.$qw['text'].'</b></td></tr>';
  258. while($tr=mysql_fetch_array($qj)){echo'<tr><td>'.$tr['text'].'</td><td><input name="otv" type="radio" class="but" value="'.$tr['id'].'"></td></tr>';
  259. }
  260. echo'<tr><td><input type="submit" class="but" value="Голосовать"> [<a href="/forum/theme/'.$id_forum.'/'.$id_them.'/vote/">Результаты</a>]</td></tr></table></form>';}
  261. }}
  262. if($_GET['act']=="vote" or $er3>0){
  263. echo'<table align="center" width="100%">';
  264. $qw=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_votes` WHERE `id_them`='$id_them' AND `type`='name'"));
  265. $qj=mysql_query("SELECT * FROM `forum_votes` WHERE `id_them`='$id_them' AND `type`='text' ORDER BY `id`");
  266. echo'<tr><td><b>'.$qw['text'].'</b></td></tr>';
  267. while($tr=mysql_fetch_array($qj)){
  268. $we=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_votes_otv` WHERE `id_them`='$id_them' AND `id_otv`='".$tr['id']."'"),0);
  269. $wa=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_votes_otv` WHERE `id_them`='$id_them'"),0);
  270. $proc=round(($we*100)/$wa);
  271. echo'<tr><td>'.$tr['text'].'</td><td>'.$proc.' %</td></tr>';
  272. }
  273. echo'</table>';
  274. }
  275. }}
  276. }
  277. }
  278. $num=10;
  279. $kol=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `id_them`='$id_them'"),0);
  280. $total=$kol;
  281. if($page < 0 || $page > $total) $page = 0;
  282.  
  283. if ($total < $page + 10) $end = $total;
  284. else $end = $page + 10; $vforum=mysql_query("select * from forum_messages where id_them='$id_them' order by id_mes asc limit $page,$num");
  285. if(empty($page)){
  286. $kolmg=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `id_user`='".$nthem['id_user']."'"),0);
  287. echo'<div class="p"><b>1.</b>'.nik_one($nthem['id_user']).'['.$kolmg.']';
  288.  if($id_user==$nthem['id_user'] or $adm_pr==2 or $adm_pr==3 or $adm_pr==4){echo' <a href="/forum/?mod=19&amp;id_them='.$id_them.'&amp;id_forum='.$id_forum.'">[Изм]</a>';}
  289. echo'['.$nthem['pervoe'].']<br>
  290. '.vizual($nthem['fttext']).'<br></div>';
  291. }
  292. $nomer=$page+1;
  293. while($forum=mysql_fetch_array($vforum)){
  294. $nomer++;
  295. $kolms=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `id_user`='".$forum['id_user']."'"),0);
  296. echo'<div class="p"><b>'.$nomer.'.</b> '.nik_one($forum['id_user']).'['.$kolms.']';
  297. if($adm_pr==2 or $adm_pr==3 or $adm_pr==4){
  298. echo' [<a href="/mpanel/control.php?mod=42&amp;id_soob='.$forum['id_mes'].'"><font color="red">Del</font></a>]<br>';}
  299. if($vhod==1 and $forum['id_user']!=$id_user){echo'<a href="/forum/?mod=7&amp;id_uz='.$forum['id_user'].'&amp;page='.$page.'&amp;id_them='.$id_them.'&amp;id_forum='.$id_forum.'">Отв</a>|';} if($vhod==1 and $forum['id_user']==$id_user){echo'<a href="/forum/?mod=17&amp;
  300. page='.$page.'&amp;id_mes='.$forum['id_mes'].'&amp;id_them='.$id_them.'&amp;id_forum='.$id_forum.'">Изм</a>|';} if($vhod==1 and $forum['id_user']!=$id_user){echo'<a href="/forum/?mod=7&amp;page='.$page.'&amp;id_mes='.$forum['id_mes'].'&amp;id_them='.$id_them.'&amp;
  301. id_forum='.$id_forum.'">Цит</a>';} echo'<br>['.$forum['fmdater'].']<br>
  302. '.vizual($forum['fmtext']);
  303. if($forum['red_time']!=0 || $forum['red_time']!=0){echo'<br>______<br>посл.ред. '.date_fixed($forum['red_time']).'<br>Всего '.$forum['red_kol'].' раз';}
  304. echo'<br>';
  305. if($forum['file_f']!=""){
  306. $namfl=str_replace('files/','',$forum['file_f']);
  307. echo'<br/><img src="'.$dirsite.'/images/icon_clip.gif" alt=""> <a href="/forum/load.php?id_mess='.$forum['id_mes'].'">'.$namfl.'</a><br>Скачан: '.$forum['file_c'].' раз'; } echo'</div>';
  308. }
  309. strmpage($page, 10, $total, "/forum/theme/$id_forum/$id_them/");
  310. $deq='/forum/index.php?mod=4&amp;id_forum='.$id_forum.'&amp;id_them='.$id_them;
  311. $onl=mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `gdeon` LIKE '$deq%' AND `online`>'".(time()-120)."'"),0);
  312. $coufile=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f`!='' AND `id_them`='$id_them'"),0);
  313. $gue=mysql_result(mysql_query("SELECT COUNT(*) FROM `online` WHERE `query` LIKE '$deq%' AND `timer`>'".(time()-120)."'"),0);
  314. $whotut=$onl+$gue;
  315. echo'<div class="p">';
  316. if($vhod==1 and $nthem['otkr']==0){
  317. echo'<a href="/forum/?mod=7&amp;id_forum='.$id_forum.'&amp;id_them='.$id_them.'&amp;page='.$page.'" class="but">
  318. Ответить на тему</a><br>';} 
  319. echo'<a href="/forum/?mod=24&amp;id_theme='.$id_them.'" class="but">
  320. Фильтр сообщений</a><br>
  321. <a href="/forum/txt.php?id_theme='.$id_them.'" class="but">Скачать в txt</a><br>
  322. <a href="/forum/?mod=23&amp;id_forum='.$id_forum.'&amp;id_them='.$id_them.'">Кто тут?</a> ['.$whotut.']<br><a href="/forum/files.php?id_them='.$id_them.'">Файлы темы</a> ['.$coufile.']</div>';
  323. }
  324.  
  325. break;
  326. case'7':
  327. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;}
  328. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;}
  329. if(isset($_GET['id_mes'])){$id_mes=cifry($_GET['id_mes']);}else{$id_mes='';}
  330.  
  331. if(isset($_GET['id_uz'])){$id_uz=cifry($_GET['id_uz']);}else{$id_uz='';}
  332.  
  333. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  334. $razdel=mysql_query("select * from forum_kategory where id_forum='$id_forum' limit 1");
  335. $tema=mysql_query("select * from forum_themes where id_them='$id_them' limit 1");
  336. if(mysql_num_rows($tema)==0 or mysql_num_rows($razdel)==0){
  337. echo'<div class="i">Форум<br></div>';
  338. echo'<div class="p">Ошибка! Упущены обязательные данные!<br></div>';
  339. }else{
  340. echo'<div class="i">Сообщение<br></div>';
  341. $nthem=mysql_fetch_array($tema);
  342.  
  343. if($nthem['otkr']==1){
  344. echo'<div class="p">Ошибка! Тема закрыта!<br></div>';}
  345.  
  346.  
  347.  
  348. if(isset($id_uz) || isset($id_mes)){
  349. if($id_uz!=""){  $qq=mysql_query("SELECT `login`,`id_user` FROM `users` WHERE `id_user`='$id_uz'"); if(mysql_num_rows($qq)!=0){ $dad=mysql_fetch_assoc($qq); $chto='[b]'.prov($dad['login']).'[/b], ';}else{ echo'ERROR'; require"../system/foot.php"; exit;}}
  350.  
  351. if($id_mes!=""){  $qq=mysql_query("SELECT `id_user`,`fmtext`,`fmdater` FROM `forum_messages` WHERE `id_mes`='$id_mes'");
  352. if(mysql_num_rows($qq)!=0){
  353.  
  354. $dad=mysql_fetch_assoc($qq); $tamt=mysql_fetch_assoc(mysql_query("SELECT `login` FROM `users` WHERE `id_user`='".$dad['id_user']."'"));
  355. $chto='[q][b]'.prov($tamt['login']).'[/b], '.prov($dad['fmdater']).' '.dec_text($dad['fmtext']).'[/q]';}else{ echo'ERROR'; require"../system/foot.php"; exit;}}}
  356. echo'<div class="i">Ответ на тему</div>
  357. <form action="/forum/?mod=6&amp;id_forum='.$id_forum.'&amp;id_them='.$id_them.'&amp;page='.$page.'" method="post" enctype="multipart/form-data">
  358. Сообщение:<br>
  359. <textarea cols="20" rows="3" name="soob" class="form">'.dec_text($chto).'</textarea><br>Прикрепить файл (max. 500кб):<br><input type="file" name="file" size="15" value="Обзор"><br>
  360. <input type="submit" class="but" value="Написать"><br>
  361. </form>';}
  362. break;
  363.  
  364. //Добавление сообщения
  365. case'6':
  366. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;}
  367. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  368. $razdel=mysql_query("select * from forum_kategory where id_forum='$id_forum' limit 1");
  369. $tema=mysql_query("select * from forum_themes where id_them='$id_them' limit 1");
  370. if(mysql_num_rows($tema)==0 or mysql_num_rows($razdel)==0){
  371. echo'<div class="i">Форум<br></div>';
  372. echo'<div class="p">Ошибка! Упущены обязательные данные!<br></div>';
  373. }else{
  374. if(isset($_POST['soob'])){$soob=prov($_POST['soob'],8000);}else{$soob='';}
  375. echo'<div class="i">Сообщение<br></div>';
  376. if(empty($soob) or strlen($soob)<3){
  377. echo'<div class="p">Ошибка! Ваше сообщение слишком короткое!<br></div>';
  378. }else{
  379. $nthem=mysql_fetch_array($tema);
  380. $flud=mysql_num_rows(mysql_query("select * from forum_messages where id_user='$id_user' and timer>'".time()."'"));
  381. $povtor=mysql_num_rows(mysql_query("select * from forum_messages where id_user='$id_user' and fmtext='$soob'"));
  382. if($flud==0 and $povtor==0){
  383. if($vhod==1){
  384. if($nthem['otkr']==1){
  385. echo'<div class="p">Ошибка! Тема закрыта!<br></div>';
  386. }else{ $rand=mt_rand(1111,9999);
  387. $avat_size=$_FILES['file']['size'];
  388. $avat_name=$_FILES['file']['name']; $av_file = $_FILES['file']['tmp_name']; $av_string = substr($av_file[0], 0, 3); $ext = strtolower(substr($avat_name, 1 + strrpos($avat_name, "."))); $mn=substr_count("$avat_name",".");
  389. if($ext=="" || $ext=="jpg" || $ext=="gif" || $ext=="jpeg" || $ext=="png" || $ext=="mid" || $ext=="mp4" || $ext=="mp3" || $ext=="wav" || $ext=="mmf" || $ext=="wma" || $ext=="wmv" || $ext=="3gp" || $ext=="3gpp" || $ext=="zip" || $ext=="rar" || $ext=="gz" || $ext=="jar"
  390. || $ext=="swf" || $ext=="sis" || $ext=="jad"){  if($avat_size>=0 && $avat_size<=500000){
  391. $avfl=explode(".",$avat_name);
  392. if($ext!=""){ copy($_FILES['file']['tmp_name'], 'files/'.$avfl[0].'_'.$rand.'.'.$ext);
  393. $fipe='files/'.$avfl[0].'_'.$rand.'.'.$ext;
  394. }else{$fipe='';} $fttp=0;
  395. $ftimer=time()+20;
  396. mysql_query("insert into forum_messages set fmtext='$soob', id_kat='$id_forum', file_f='$fipe', file_c='$fttp', id_them='$id_them', fmdater='".date('d.m.Y - H:i:s')."', timer='$ftimer', id_user='$id_user'");
  397. mysql_query("update users set balls=balls+1 where id_user='$id_user' limit 1");
  398. mysql_query("update forum_themes set ftdater='".date('d.m.Y - H:i:s')."', updater='".time()."' where id_them='$id_them' limit 1");
  399. header("Location: /forum/theme/$id_forum/$id_them/page=$page&isset=yesmess");
  400.  
  401. }else{echo'Ошибка, недопустимый вес файла! Разрешается загружать весом до 500 килобайт<br>';}}else{echo'Ошибка, недопустимое расширение файла!';}
  402. $chtob=mysql_num_rows(mysql_query("select * from forum_messages where id_them='$id_them'"));
  403. if($chtob>10){
  404. $stbud=round($chtob,-1);
  405. $skcf=strlen($chtob);
  406. $poslc=substr($chtob,($skcf-1),$skcf);
  407. if($poslc>=5 or $poslc=='0'){
  408. $stbud=$stbud-10;
  409. }
  410. }
  411. }
  412. }else{
  413. echo'<div class="p">Ошибка! Добавлять сообщения могут только авторизованные пользователи!<br></div>';
  414. }
  415. }else{
  416. echo'<div class="p">Ошибка! Вы слишком часто пытаетесь добавить сообщение либо такое сообщение уже есть в базе!<br></div>';
  417. }
  418. }
  419. }
  420. break;
  421. case'17':
  422. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;}
  423.  
  424.  
  425. if(isset($_GET['id_mes'])){$id_mes=cifry($_GET['id_mes']);}else{$id_mes='';}
  426.  
  427. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  428.  
  429. $erqone=mysql_num_rows(mysql_query("SELECT * FROM `forum_messages` WHERE `id_mes`='$id_mes'"));
  430. if($erqone==0){header("Location: /forum/"); exit;}
  431.  
  432. $erqtwo=mysql_num_rows(mysql_query("SELECT * FROM `forum_messages` WHERE `id_mes`='$id_mes' AND `id_user`='$id_user'"));
  433. if($erqtwo==0){header("Location: /forum/"); exit;}
  434. $razdel=mysql_query("select * from forum_kategory where id_forum='$id_forum' limit 1");
  435. $tema=mysql_query("select * from forum_themes where id_them='$id_them' limit 1");
  436. if(mysql_num_rows($tema)==0 or mysql_num_rows($razdel)==0){
  437. echo'<div class="i">Форум<br></div>';
  438. echo'<div class="p">Ошибка! Упущены обязательные данные!<br></div>';
  439. }else{
  440.  
  441. $nthem=mysql_fetch_array($tema);
  442.  
  443. if($nthem['otkr']==1){
  444. echo'<div class="p">Ошибка! Тема закрыта!<br></div>';}
  445.  
  446. $qq=mysql_fetch_array(mysql_query("SELECT `fmtext` FROM `forum_messages` WHERE `id_mes`='$id_mes'"));
  447.  
  448. $qq['fmtext']=str_replace('\r\n','[br/]',$qq['fmtext']);
  449.  
  450. $qq['fmtext']=str_replace('\r\ n','[br/]',$qq['fmtext']);
  451. echo'<form action="/forum/?mod=18&amp;id_mes='.$id_mes.'&amp;id_forum='.$id_forum.'&amp;id_them='.$id_them.'&amp;page='.$page.'" method="post">Сообщение:<br><textarea cols="20" rows="3" name="fmtext" class="form">'.dec_text($qq['fmtext']).'</textarea>
  452. <br><input type="submit" value="Редактировать" class="but"/></form>';
  453. }
  454. break;
  455.  
  456. case'18':
  457. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;}
  458.  
  459.  
  460. if(isset($_GET['id_mes'])){$id_mes=cifry($_GET['id_mes']);}else{$id_mes='';}
  461.  
  462. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  463. $erqone=mysql_num_rows(mysql_query("SELECT * FROM `forum_messages` WHERE `id_mes`='$id_mes'"));
  464. if($erqone==0){header("Location: /forum/"); exit;}
  465. $erqtwo=mysql_num_rows(mysql_query("SELECT * FROM `forum_messages` WHERE `id_mes`='$id_mes' AND `id_user`='$id_user'"));
  466. if($erqtwo==0){header("Location: /forum/"); exit;}
  467. $razdel=mysql_query("select * from forum_kategory where id_forum='$id_forum' limit 1");
  468. $tema=mysql_query("select * from forum_themes where id_them='$id_them' limit 1");
  469. if(mysql_num_rows($tema)==0 or mysql_num_rows($razdel)==0){
  470. echo'<div class="i">Форум<br></div>';
  471. echo'<div class="p">Ошибка! Упущены обязательные данные!<br></div>';
  472. }else{
  473. $fmtext=prov($_POST['fmtext']);
  474. if($fmtext==""){echo'Сообщение пустое'; require"../system/foot.php"; exit;}
  475. $nthem=mysql_fetch_array($tema);
  476.  
  477. if($nthem['otkr']==1){
  478. echo'<div class="p">Ошибка! Тема закрыта!<br></div>';}
  479. $dd=mysql_fetch_array(mysql_query("SELECT `red_kol` FROM `forum_messages` WHERE `id_mes`='$id_mes'"));
  480. $sam=$dd['red_kol']+1;
  481. mysql_query("UPDATE `forum_messages` SET `red_kol`='$sam', `red_time`='".time()."', `fmtext`='$fmtext' WHERE `id_mes`='$id_mes'");
  482. header("Location: /forum/theme/$id_forum/$id_them/page=$page&isset=yesedit");
  483.  
  484. $chtob=mysql_num_rows(mysql_query("select * from forum_messages where id_them='$id_them'"));
  485.  
  486. if($chtob>10){
  487. $stbud=round($chtob,-1);
  488. $skcf=strlen($chtob);
  489. $poslc=substr($chtob,($skcf-1),$skcf);
  490. if($poslc>=5 or $poslc=='0'){
  491. $stbud=$stbud-10;
  492. }
  493. }}
  494. break;
  495.  
  496. case'19':
  497.  
  498. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;} if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  499. $razdel=mysql_num_rows(mysql_query("SELECT * FROM `forum_kategory` WHERE `id_forum`='$id_forum' LIMIT 1"));
  500. $azdel=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id_them' LIMIT 1"));
  501. if($razdel==0 or $azdel==0){
  502. echo'<div class="i">Форум<br></div>';
  503.  
  504. echo'<div class="p">Ошибка! Упущены обязательные данные!<br></div>';}else{ $prver=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_user`='$id_user' AND `id_them`='$id_them' LIMIT 1"));
  505. if($prver!=0 or $adm_pr==2 or $adm_pr==3 or $adm_pr==4){
  506.  
  507. if($vhod==1){
  508. $qq=mysql_fetch_array(mysql_query("SELECT `fttext`,`ftname` FROM `forum_themes` WHERE `id_them`='$id_them' LIMIT 1")); echo'<div class="i">Редактирование темы<br></div>';
  509. echo'<div class="p"><form action="/forum/?mod=20&amp;id_forum='.$id_forum.'&amp;id_them='.$id_them.'" method="post">
  510. Тема:<br>
  511. <input type="text" name="nathem" maxlength="150" class="form" size="18" value="'.dec_text($qq['ftname']).'"><br>
  512. Сообщение:<br>
  513. <textarea cols="20" rows="3" name="soob" class="form">'.dec_text($qq['fttext']).'</textarea><br>';
  514. if($adm_pr==2 or $adm_pr==3 or $adm_pr==4){
  515. echo'<input type="checkbox" value="1" name="zakrep" class="form"> Закрепить<br>';
  516. }
  517. echo'<input type="submit" value="Редактировать"  class="but"><br></form></div>';
  518. }else{
  519. echo'<div class="i">Форум<br></div>
  520. <div class="p">Ошибка! Вы не авторизованы<br></div>';
  521. }
  522. }else{echo'<div class="i">Форум<br></div>';
  523.  
  524. echo'<div class="p">Фатальная Ошибка!<br></div>';}}
  525.  
  526. break;
  527.  
  528.  
  529. //Редактирование темы
  530. case'20':
  531.  
  532. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;} if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  533. $razdel=mysql_num_rows(mysql_query("SELECT * FROM `forum_kategory` WHERE `id_forum`='$id_forum' LIMIT 1"));
  534. $azdel=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id_them' LIMIT 1"));
  535. if($razdel==0 or $azdel==0){
  536. echo'<div class="i">Форум<br></div>';
  537.  
  538. echo'<div class="p">Ошибка! Упущены обязательные данные!<br></div>';}else{$prver=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_user`='$id_user' AND `id_them`='$id_them' LIMIT 1"));  if($prver!=0 or $adm_pr==2
  539. or $adm_pr==3 or $adm_pr==4){
  540.  
  541. if($vhod==1){
  542. if(isset($_POST['soob'])){$soob=prov($_POST['soob'],4000);}else{$soob='';}
  543. if(isset($_POST['nathem'])){$nathem=prov($_POST['nathem'],150);}else{$nathem='';}
  544. if(isset($_POST['zakrep'])){$zakrep=cifry($_POST['zakrep']);}else{$zakrep=0;}
  545. if($zakrep==1 and ($adm_pr==2 or $adm_pr==3 or $adm_pr==4)){$zakrep=1;}else{$zakrep=0;}
  546. echo'<div class="i">Редактирование темы<br></div>';
  547. if(empty($soob) or strlen($soob)<3 or empty($nathem) or strlen($nathem)<5){
  548. echo'<div class="p">Ошибка! Cообщение или тема слишком короткие!<br></div>';
  549. }else{
  550. mysql_query("UPDATE `forum_themes` SET `ftname`='$nathem', `fttext`='$soob', zakr='$zakrep' WHERE `id_them`='$id_them'");
  551.  
  552. header("Location: /forum/theme/$id_forum/$id_them/isset=yesedit");
  553. }
  554. }else{
  555. echo'<div class="i">Форум<br></div>
  556. <div class="p">Ошибка! Вы не авторизованы!<br></div>';
  557. }}else{echo'<div class="i">Форум<br></div>';
  558.  
  559. echo'<div class="p">Фатальная Ошибка!<br></div>';}
  560. }
  561. break;
  562. case'24':
  563. echo'<div class="i">Фильтрация постов</div>'; 
  564. $id=(int)$_GET['id_theme']; $erg=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id' LIMIT 1")); if($erg==1){ $query=mysql_query("SELECT DISTINCT `id_user` FROM `forum_messages`
  565. WHERE `id_them`='$id' ORDER BY `id_user`"); echo'<form action="index.php?mod=25&amp;id_theme='.$id.'" method="post">';
  566. while($data=mysql_fetch_array($query)){
  567.  $cou=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `id_them`='$id' AND `id_user`='".$data['id_user']."'"),0);
  568. echo'<input type="checkbox" name="avtor[]" value="'.$data['id_user'].'"> '.nik_tri($data['id_user']).' ['.$cou.']<br>';}
  569. echo'<div class="p">Выберите нужных авторов и нажимите "Фильтровать", для того чтобы видеть сообщения только от выбраных авторов</div><input type="submit" value="Фильтровать"
  570. class="but"/></form>'; }else{ echo'ERROR';} break;
  571. case'25':
  572. if(empty($_POST['avtor'])){echo'Ничего не выбрано';}else{ $id=(int)$_GET['id_theme']; $erg=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id' LIMIT 1")); if($erg==1){
  573. echo'<div class="i">Сообщения от</div><div class="p">'; 
  574. foreach($_POST['avtor'] as $gm){ echo nik_tri($gm).',';
  575.  
  576. } echo'</div>'; 
  577. foreach($_POST['avtor'] as $p){
  578.  
  579. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `id_them`='$id' AND `id_user`='$p' ORDER BY `id_user`");
  580. while($forum=mysql_fetch_array($query)){
  581. echo'<div class="p">'.nik_one($forum['id_user']);
  582. echo'<br>['.$forum['fmdater'].']<br>
  583. '.vizual($forum['fmtext']);
  584. if($forum['red_time']!=0 || $forum['red_time']!=0){echo'<br>______<br>посл.ред. '.date_fixed($forum['red_time']).'<br>Всего '.$forum['red_kol'].' раз';}
  585. echo'<br>';
  586. if($forum['file_f']!=""){
  587. $namfl=str_replace('files/','',$forum['file_f']);
  588. echo'<br/><img src="'.$dirsite.'/images/icon_clip.gif" alt=""> <a href="/forum/load.php?id_mess='.$forum['id_mes'].'">'.$namfl.'</a><br>Скачан: '.$forum['file_c'].' раз'; } echo'</div>';
  589. }
  590. }}else{echo'ERROR';}} break;
  591. case'26':
  592. if($vhod==1){
  593.  
  594. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  595. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;}
  596. $er1=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id_them' AND `id_kat`='$id_forum' AND `id_user`='$id_user'"));
  597. $er2=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id_them' AND `id_kat`='$id_forum'"));
  598. $er3=mysql_num_rows(mysql_query("SELECT * FROM `forum_votes` WHERE `id_them`='$id_them' AND `id_user`='$id_user'"));
  599. if($er1==1){
  600. if($er2==1){
  601. if($er3==0){
  602. if(empty($_POST['vote']) or empty($_POST['otv']) or empty($_POST['time'])){
  603. echo'<form action="/forum/?mod=26&amp;id_forum='.$id_forum.'&amp;id_them='.$id_them.'" method="post">';
  604. if($_POST['kol']>=2){ 
  605. $kol=(int)$_POST['kol'];
  606. echo'Вопрос?<br><input type="text" name="vote" class="form" size="18"><br>Варианты ответов<br>';
  607. for($i=0; $i<$kol; $i++){echo'<input type="text" name="otv[]" class="form" size="18"><br>';}
  608. echo'Сколько дней вести голосование?<br><input type="text" name="time" class="form" size="8"><br>';
  609. }else{
  610. echo'Меньше двух вариантов нельзя<hr>Сколько вариантов?<br><input type="text" name="kol" class="form" size="5">';
  611. }
  612. echo'<input type="submit" class="but" value="OK"></form>';
  613.  
  614. }else{
  615. $otve=$_POST['otv'];
  616. $vote=prov($_POST['vote'],100);
  617. $time=(int)$_POST['time'];
  618. $tame=time()+($time*86400);
  619. mysql_query("INSERT INTO `forum_votes` SET `id_user`='$id_user', `type`='name',`text`='$vote', `time`='$tame', `id_them`='$id_them'");
  620. foreach($otve as $otv){
  621. mysql_query("INSERT INTO `forum_votes` SET `type`='text',`text`='".prov($otv)."', `id_them`='$id_them'");
  622. }
  623. echo'<div class="p">Успешно добавлено<br><a href="/forum/theme/'.$id_forum.'/'.$id_them.'/">В тему</a>';
  624.  
  625. }
  626.  
  627.  
  628.  
  629. }else{echo'Уже создано';}
  630. }else{echo'Нет такой темы';}
  631. }else{echo'Вы не автор темы';}
  632. }else{echo'Вы не авторизованы';}
  633. break;
  634. case'27';
  635.  
  636. if($vhod==1){
  637.  
  638. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  639. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;}
  640. if(!empty($_POST['otv'])){$otv=cifry($_POST['otv']);}else{header('Location: /forum/theme/'.$id_forum.'/'.$id_them.'/'); exit;}
  641.  
  642. $er1=mysql_num_rows(mysql_query("SELECT * FROM `forum_votes` WHERE `id_them`='$id_them'"));
  643. $er2=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id_them' AND `id_kat`='$id_forum'"));
  644. $er3=mysql_num_rows(mysql_query("SELECT * FROM `forum_votes_otv` WHERE `id_them`='$id_them' AND `id_user`='$id_user'"));
  645. if($er1>=1){
  646. if($er2==1){
  647. if($er3==0){
  648. mysql_query("INSERT INTO `forum_votes_otv` SET `id_them`='$id_them', `id_user`='$id_user', `id_otv`='$otv'");
  649. header('Location: /forum/theme/'.$id_forum.'/'.$id_them.'/');
  650. }else{echo'Вы уже голосовали';}
  651. }else{echo'Нет такой темы';}
  652. }else{echo'Fatal error';}
  653. }else{echo'Вы не авторизованы';}
  654. break;
  655.  
  656. case'23':
  657. echo'<div class="i">Кто в этой теме</div>';
  658. $id_f=(int)$_GET['id_forum']; $id_t=(int)$_GET['id_them'];  $ert=mysql_num_rows(mysql_query("SELECT * FROM `forum_themes` WHERE `id_them`='$id_t' LIMIT 1")); $erf=mysql_num_rows(mysql_query("SELECT * FROM `forum_kategory` WHERE `id_forum`='$id_f' LIMIT 1"));
  659. if($ert!=0 or $erf!=0){$deq='/forum/index.php?mod=4&amp;id_forum='.$id_f.'&amp;id_them='.$id_t;
  660. $online=mysql_query("SELECT `id_user` FROM `users` WHERE `gdeon` LIKE '$deq%' AND `online`>'".(time()-120)."'");
  661. $nasaj=mysql_num_rows($online);
  662. echo'<div class="p">Зареганых: '.$nasaj.'<br></div>';
  663. if($nasaj!=0){
  664. while($naso=mysql_fetch_array($online)){
  665. echo nik_tri($naso['id_user']).',';}
  666. }
  667. $guests=mysql_query("SELECT * FROM `online` WHERE `query` LIKE '$deq%' AND `timer`>'".(time()-120)."'");
  668. $gkol=mysql_num_rows($guests);
  669. echo'<div class="p">Гости: '.$gkol.'</div>';
  670. if($gkol!=0){
  671. $vcg=0;
  672.  
  673. while($guest=mysql_fetch_array($guests)){$vcg++;
  674. echo'<div class="p"><b>'.$vcg.'.</b> IP: '.$guest['iper'].'<br>UA: '.$guest['uaer'];  echo'<br>';}
  675. } echo'<div class="p"><a href="/forum/theme/'.$id_f.'/'.$id_t.'/">К теме</a></div>';}else{echo'ERROR';} break;
  676. }
  677.  
  678. require"../system/foot.php";
  679. ?>