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

Конкурс дизайнеров на 15000 рублей
контркультура падонки бабруйск
Размер файла: 22.17Kb 
  1. <?php
  2.  
  3. $title='Файлы'; 
  4. require"../system/config.php";
  5.  require"../system/func.php";
  6.  require"../system/head.php";
  7.  require"../system/error.php";  
  8.  echo'<div class="i" align="center">'.$title.'</div>';
  9.  
  10. if(isset($_GET['id_forum'])){$id_forum=cifry($_GET['id_forum']);}else{$id_forum=0;}
  11. if(isset($_GET['id_them'])){$id_them=cifry($_GET['id_them']);}else{$id_them=0;}
  12.  switch($_GET['act']){
  13. default:
  14. if($id_forum==0 and $id_them==0){ $all=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f`!=''"),0);    $cou8=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.mp3' OR `file_f` LIKE '%.wav' OR `file_f` LIKE '%.mid' OR `file_f` LIKE '%.wma' OR `file_f` LIKE '%.mmf' OR `file_f` LIKE '%.amr'"),0);
  15. $cou1=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.exe'"),0); $cou2=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.sis'"),0);
  16. $cou3=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.jar' OR `file_f` LIKE '%.jad'"),0); $cou4=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.txt'"),0); $cou6=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.3gp' OR `file_f` LIKE '%.mp4' OR `file_f` LIKE '%.avi'"),0); $cou5=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.zip' OR `file_f` LIKE '%.rar'"),0);
  17. $cou7=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.gif' OR `file_f` LIKE '%.jpg' OR `file_f` LIKE '%.png' OR `file_f` LIKE '%.jpeg'"),0); echo'<div class="p"><img src="/images/forum/1.png" alt=""> <a href="/forum/files.php?act=view&amp;fid=1">Приложения EXE</a> ['.$cou1.']</div><div class="p"><img src="/images/forum/2.png" alt=""> <a href="/forum/files.php?act=view&amp;fid=2">Приложения SIS</a> ['.$cou2.']</div>
  18. <div class="p"><img src="/images/forum/3.png" alt=""> <a href="/forum/files.php?act=view&amp;fid=3">Приложения JAVA</a> ['.$cou3.']</div><div class="p"><img src="/images/forum/4.png" alt=""> <a href="/forum/files.php?act=view&amp;fid=4">Текстовые файлы</a> ['.$cou4.']</div>
  19. <div class="p"><img src="/images/forum/5.png" alt=""> <a href="/forum/files.php?act=view&amp;fid=5">Архивы</a> ['.$cou5.']</div><div class="p"><img src="/images/forum/6.png" alt=""> <a href="/forum/files.php?act=view&amp;fid=6">Видео</a> ['.$cou6.']</div><div class="p"><img src="/images/forum/7.png" alt=""> <a href="/forum/files.php?act=view&amp;fid=7">Картинки</a> ['.$cou7.']</div>
  20. <div class="p"><img src="/images/forum/8.png" alt=""> <a href="/forum/files.php?act=view&amp;fid=8">Музыка</a> ['.$cou8.']</div>';  echo'<div class="p">Файлов: '.$all.'</div>';}
  21. if($id_forum!=0 and $id_them==0){ $all=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f`!='' AND `id_kat`='$id_forum'"),0);    $cou8=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.mp3' OR `file_f` LIKE '%.wav' OR `file_f` LIKE '%.mid' OR `file_f` LIKE '%.wma' OR `file_f` LIKE '%.mmf' OR `file_f` LIKE '%.amr') AND `id_kat`='$id_forum'"),0); $cou1=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.exe' AND `id_kat`='$id_forum'"),0); $cou2=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.sis' AND `id_kat`='$id_forum'"),0); $cou3=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.jar' OR `file_f` LIKE '%.jad') AND `id_kat`='$id_forum'"),0); $cou4=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.txt' AND `id_kat`='$id_forum'"),0);  $cou6=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.3gp' OR `file_f` LIKE '%.mp4' OR `file_f` LIKE '%.avi') AND `id_kat`='$id_forum'"),0);  $cou5=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.zip' OR `file_f` LIKE '%.rar') AND `id_kat`='$id_forum'"),0);
  22. $cou7=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.gif' OR `file_f` LIKE '%.jpg' OR `file_f` LIKE '%.png' OR `file_f` LIKE '%.jpeg') AND `id_kat`='$id_forum'"),0); echo'<div class="p"><img src="/images/forum/1.png" alt=""> <a href="/forum/files.php?act=view&amp;id_forum='.$id_forum.'&amp;fid=1">Приложения EXE</a> ['.$cou1.']</div><div class="p"><img src="/images/forum/2.png" alt=""> <a href="/forum/files.php?act=view&amp;id_forum='.$id_forum.'&amp;fid=2">Приложения SIS</a> ['.$cou2.']</div><div class="p"><img src="/images/forum/3.png" alt=""> <a href="/forum/files.php?act=view&amp;id_forum='.$id_forum.'&amp;fid=3">Приложения JAVA</a> ['.$cou3.']</div><div class="p"><img src="/images/forum/4.png" alt=""> <a href="/forum/files.php?act=view&amp;id_forum='.$id_forum.'&amp;fid=4">Текстовые файлы</a> ['.$cou4.']</div><div class="p"><img src="/images/forum/5.png" alt=""> <a href="/forum/files.php?act=view&amp;id_forum='.$id_forum.'&amp;fid=5">Архивы</a> ['.$cou5.']</div>
  23. <div class="p"><img src="/images/forum/6.png" alt=""> <a href="/forum/files.php?act=view&amp;id_forum='.$id_forum.'&amp;fid=6">Видео</a> ['.$cou6.']</div><div class="p"><img src="/images/forum/7.png" alt=""> <a href="/forum/files.php?act=view&amp;id_forum='.$id_forum.'&amp;fid=7">Картинки</a> ['.$cou7.']</div><div class="p"><img src="/images/forum/8.png" alt=""> <a href="/forum/files.php?act=view&amp;id_forum='.$id_forum.'&amp;fid=8">Музыка</a> ['.$cou8.']</div>';
  24. echo'<div class="p">Файлов: '.$all.'</div>';}
  25. if($id_forum==0 and $id_them!=0){ $all=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f`!='' AND `id_them`='$id_them'"),0);    $cou8=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.mp3' OR `file_f` LIKE '%.wav' OR `file_f` LIKE '%.mid' OR `file_f` LIKE '%.wma' OR `file_f` LIKE '%.mmf' OR `file_f` LIKE '%.amr') AND `id_them`='$id_them'"),0); $cou1=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.exe' AND `id_them`='$id_them'"),0); $cou2=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.sis' AND `id_them`='$id_them'"),0); $cou3=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.jar' OR `file_f` LIKE '%.jad') AND `id_them`='$id_them'"),0); $cou4=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.txt' AND `id_them`='$id_them'"),0);  $cou6=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.3gp' OR `file_f` LIKE '%.mp4' OR `file_f` LIKE '%.avi') AND `id_them`='$id_them'"),0);  $cou5=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.zip' OR `file_f` LIKE '%.rar') AND `id_them`='$id_them'"),0);
  26. $cou7=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE (`file_f` LIKE '%.gif' OR `file_f` LIKE '%.jpg' OR `file_f` LIKE '%.png' OR `file_f` LIKE '%.jpeg') AND `id_them`='$id_them'"),0); echo'<div class="p"><img src="/images/forum/1.png" alt=""> <a href="/forum/files.php?act=view&amp;id_them='.$id_them.'&amp;fid=1">Приложения EXE</a> ['.$cou1.']</div><div class="p"><img src="/images/forum/2.png" alt=""> <a href="/forum/files.php?act=view&amp;id_them='.$id_them.'&amp;fid=2">Приложения SIS</a> ['.$cou2.']</div><div class="p"><img src="/images/forum/3.png" alt=""> <a href="/forum/files.php?act=view&amp;id_them='.$id_them.'&amp;fid=3">Приложения JAVA</a> ['.$cou3.']</div><div class="p"><img src="/images/forum/4.png" alt=""> <a href="/forum/files.php?act=view&amp;id_them='.$id_them.'&amp;fid=4">Текстовые файлы</a> ['.$cou4.']</div><div class="p"><img src="/images/forum/5.png" alt=""> <a href="/forum/files.php?act=view&amp;id_them='.$id_them.'&amp;fid=5">Архивы</a> ['.$cou5.']</div><div class="p"><img src="/images/forum/6.png" alt=""> <a href="/forum/files.php?act=view&amp;id_them='.$id_them.'&amp;fid=6">Видео</a> ['.$cou6.']</div><div class="p"><img src="/images/forum/7.png" alt=""> <a href="/forum/files.php?act=view&amp;id_them='.$id_them.'&amp;fid=7">Картинки</a> ['.$cou7.']</div><div class="p"><img src="/images/forum/8.png" alt=""> <a href="/forum/files.php?act=view&amp;id_them='.$id_them.'&amp;fid=8">Музыка</a> ['.$cou8.']</div>';  echo'<div class="p">Файлов: '.$all.'</div>';} break;
  27. case'view':
  28. $id_forum=(int)$_GET['id_forum'];
  29. $id_them=(int)$_GET['id_them'];
  30. $fid=(int)$_GET['fid'];
  31. if($id_forum==0 and $id_them==0){
  32. if($fid==1){
  33. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.exe'"),0); $page = abs((int)$_GET['page']);
  34.  
  35. if($page < 0 || $page > $total) $page = 0;
  36.  
  37. if ($total < $page + 10) $end = $total;
  38. else $end = $page + 10;
  39. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.exe' ORDER BY `id_mes` DESC LIMIT $page,10");}
  40.  
  41. if($fid==2){
  42. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.sis'"),0); $page = abs((int)$_GET['page']);
  43.  
  44.  
  45.  
  46. if($page < 0 || $page > $total) $page = 0;
  47.  
  48. if ($total < $page + 10) $end = $total;
  49. else $end = $page + 10;
  50. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.sis' ORDER BY `id_mes` DESC LIMIT $page,10");}
  51.  
  52. if($fid==3){
  53. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.jar' OR `file_f` LIKE '%.jad'"),0); $page = abs((int)$_GET['page']);
  54.  
  55. if($page < 0 || $page > $total) $page = 0;
  56.  
  57. if ($total < $page + 10) $end = $total;
  58. else $end = $page + 10;
  59. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.jar' OR `file_f` LIKE '%.jad' ORDER BY `id_mes` DESC LIMIT $page,10");}
  60.  
  61. if($fid==4){
  62. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.txt'"),0); $page = abs((int)$_GET['page']);
  63.  
  64. if($page < 0 || $page > $total) $page = 0;
  65.  
  66. if ($total < $page + 10) $end = $total;
  67. else $end = $page + 10;
  68. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.txt' ORDER BY `id_mes` DESC LIMIT $page,10");}
  69.  
  70. if($fid==5){
  71. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.zip' OR `file_f` LIKE '%.rar'"),0); $page = abs((int)$_GET['page']);
  72.  
  73. if($page < 0 || $page > $total) $page = 0;
  74.  
  75. if ($total < $page + 10) $end = $total;
  76. else $end = $page + 10;
  77. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.zip' OR `file_f` LIKE '%.rar' ORDER BY `id_mes` DESC LIMIT $page,10");}
  78.  
  79. if($fid==6){
  80. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.mp4' OR `file_f` LIKE '%.3gp' OR `file_f` LIKE '%.avi'"),0); $page = abs((int)$_GET['page']);
  81.  
  82. if($page < 0 || $page > $total) $page = 0;
  83.  
  84. if ($total < $page + 10) $end = $total;
  85. else $end = $page + 10;
  86. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.mp4' OR `file_f` LIKE '%.3gp' OR `file_f` LIKE '%.avi' ORDER BY `id_mes` DESC LIMIT $page,10");}
  87.  
  88. if($fid==7){
  89. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.png' OR `file_f` LIKE '%.jpg' OR `file_f` LIKE '%.gif' OR `file_f` LIKE '%.jpeg'"),0); $page = abs((int)$_GET['page']);
  90.  
  91. if($page < 0 || $page > $total) $page = 0;
  92.  
  93. if ($total < $page + 10) $end = $total;
  94. else $end = $page + 10;
  95. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.png' OR `file_f` LIKE '%.jpg' OR `file_f` LIKE '%.jpeg' OR `file_f` LIKE '%.png' ORDER BY `id_mes` DESC LIMIT $page,10");}
  96.  
  97. if($fid==8){
  98. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.mmf' OR `file_f` LIKE '%.mp3' OR `file_f` LIKE '%.wav' OR `file_f` LIKE '%.amr' OR `file_f` LIKE '%.wma' OR `file_f` LIKE '%.mid'"),0); $page = abs((int)$_GET['page']);
  99.  
  100. if($page < 0 || $page > $total) $page = 0;
  101. if ($total < $page + 10) $end = $total;
  102. else $end = $page + 10;
  103. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.mmf' OR `file_f` LIKE '%.mp3' OR `file_f` LIKE '%.wav' OR `file_f` LIKE '%.amr' OR `file_f` LIKE '%.wma' OR `file_f` LIKE '%.mid' ORDER BY `id_mes` DESC LIMIT $page,10");}
  104. if($total!=0){
  105. while($data=mysql_fetch_array($query)){ $q=mysql_fetch_assoc(mysql_query("SELECT `ftname` FROM `forum_themes` WHERE `id_them`='".$data['id_them']."' LIMIT 1"));
  106. echo'<div class="p">&#187; <a href="load.php?id_mess='.$data['id_mes'].'">'.str_replace('files/','',$data['file_f']).'</a> ['.$data['file_c'].']<br/>Тема: <a href="/forum/theme/'.$data['id_kat'].'/'.$data['id_them'].'/">'.$q['ftname'].'</a><br>'.vizual($data['fmtext']).'<br>Хто: '.nik_tri($data['id_user']).'<br>Когда: '.date_fixed($data['timer']).'</div>';}
  107. strpage($page, 10, $total, 'files.php','act=view&amp;fid='.$fid); }else{echo'Пусто';}
  108. }
  109.  
  110. if($id_forum!=0 and $id_them==0){
  111. if($fid==1){
  112. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.exe' AND `id_forum`='$id_forum'"),0); $page = abs((int)$_GET['page']);
  113.  
  114. if($page < 0 || $page > $total) $page = 0;
  115.  
  116. if ($total < $page + 10) $end = $total;
  117. else $end = $page + 10;
  118. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.exe' AND `id_forum`='$id_forum' ORDER BY `id_mes` DESC LIMIT $page,10");}
  119.  
  120. if($fid==2){
  121. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.sis' AND `id_forum`='$id_forum'"),0); $page = abs((int)$_GET['page']);
  122.  
  123.  
  124.  
  125. if($page < 0 || $page > $total) $page = 0;
  126.  
  127. if ($total < $page + 10) $end = $total;
  128. else $end = $page + 10;
  129. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.sis' AND `id_forum`='$id_forum' ORDER BY `id_mes` DESC LIMIT $page,10");}
  130.  
  131. if($fid==3){
  132. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.jar' OR `file_f` LIKE '%.jad' AND `id_forum`='$id_forum'"),0); $page = abs((int)$_GET['page']);
  133.  
  134. if($page < 0 || $page > $total) $page = 0;
  135. if ($total < $page + 10) $end = $total;
  136. else $end = $page + 10;
  137. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.jar' OR `file_f` LIKE '%.jad' AND `id_forum`='$id_forum' ORDER BY `id_mes` DESC LIMIT $page,10");}
  138.  
  139. if($fid==4){
  140. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.txt' AND `id_forum`='$id_forum'"),0);
  141. $page = abs((int)$_GET['page']);
  142.  
  143. if($page < 0 || $page > $total) $page = 0;
  144.  
  145. if ($total < $page + 10) $end = $total;
  146. else $end = $page + 10;
  147. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.txt' AND `id_forum`='$id_forum' ORDER BY `id_mes` DESC LIMIT $page,10");}
  148.  
  149. if($fid==5){
  150. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.zip' OR `file_f` LIKE '%.rar' AND `id_forum`='$id_forum'"),0); $page = abs((int)$_GET['page']);
  151.  
  152. if($page < 0 || $page > $total) $page = 0;
  153.  
  154. if ($total < $page + 10) $end = $total;
  155. else $end = $page + 10;
  156. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.zip' OR `file_f` LIKE '%.rar' AND `id_forum`='$id_forum' ORDER BY `id_mes` DESC LIMIT $page,10");}
  157.  
  158. if($fid==6){
  159. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.mp4' OR `file_f` LIKE '%.3gp' OR `file_f` LIKE '%.avi' AND `id_forum`='$id_forum'"),0);
  160. $page = abs((int)$_GET['page']);
  161.  
  162. if($page < 0 || $page > $total) $page = 0;
  163.  
  164. if ($total < $page + 10) $end = $total;
  165. else $end = $page + 10;
  166. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.mp4' OR `file_f` LIKE '%.3gp' OR `file_f` LIKE '%.avi' AND `id_forum`='$id_forum' ORDER BY `id_mes` DESC LIMIT $page,10");}
  167.  
  168. if($fid==7){
  169. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.png' OR `file_f` LIKE '%.jpg' OR `file_f` LIKE '%.gif' OR `file_f` LIKE '%.jpeg' AND `id_forum`='$id_forum'"),0); $page = abs((int)$_GET['page']);
  170.  
  171. if($page < 0 || $page > $total) $page = 0;
  172.  
  173. if ($total < $page + 10) $end = $total;
  174. else $end = $page + 10;
  175. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.png' OR `file_f` LIKE '%.jpg' OR `file_f` LIKE '%.jpeg' OR `file_f` LIKE '%.png' AND `id_forum`='$id_forum' ORDER BY `id_mes` DESC LIMIT $page,10");}
  176.  
  177. if($fid==8){
  178. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.mmf' OR `file_f` LIKE '%.mp3' OR `file_f` LIKE '%.wav' OR `file_f` LIKE '%.amr' OR `file_f` LIKE '%.wma' OR `file_f` LIKE '%.mid' AND `id_forum`='$id_forum'"),0); $page = abs((int)$_GET['page']);
  179.  
  180. if($page < 0 || $page > $total) $page = 0;
  181. if ($total < $page + 10) $end = $total;
  182. else $end = $page + 10;
  183. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.mmf' OR `file_f` LIKE '%.mp3' OR `file_f` LIKE '%.wav' OR `file_f` LIKE '%.amr' OR `file_f` LIKE '%.wma' OR `file_f` LIKE '%.mid' AND `id_forum`='$id_forum' ORDER BY `id_mes` DESC LIMIT $page,10");}
  184. if($total!=0){
  185. while($data=mysql_fetch_array($query)){ $q=mysql_fetch_assoc(mysql_query("SELECT `ftname` FROM `forum_themes` WHERE `id_them`='".$data['id_them']."' LIMIT 1"));
  186. echo'<div class="p">&#187; <a href="load.php?id_mess='.$data['id_mes'].'">'.str_replace('files/','',$data['file_f']).'</a> ['.$data['file_c'].']<br/>Тема:
  187. <a href="/forum/theme/'.$data['id_kat'].'/'.$data['id_them'].'/">'.$q['ftname'].'</a><br>'.vizual($data['fmtext']).'<br>Хто: '.nik_tri($data['id_user']).'<br>Когда: '.date_fixed($data['timer']).'</div>';}
  188. strpage($page, 10, $total, 'files.php','act=view&amp;id_forum='.$id_forum.'&amp;fid='.$fid); }else{echo'Пусто';}
  189. }
  190.  
  191.  
  192.  
  193. if($id_forum==0 and $id_them!=0){
  194. if($fid==1){
  195. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.exe' AND `id_them`='$id_them'"),0); $page = abs((int)$_GET['page']);
  196.  
  197. if($page < 0 || $page > $total) $page = 0;
  198.  
  199. if ($total < $page + 10) $end = $total;
  200. else $end = $page + 10;
  201. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.exe' AND `id_them`='$id_them' ORDER BY `id_mes` DESC LIMIT $page,10");}
  202.  
  203. if($fid==2){
  204. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.sis' AND `id_them`='$id_them'"),0); $page = abs((int)$_GET['page']);
  205.  
  206.  
  207.  
  208. if($page < 0 || $page > $total) $page = 0;
  209.  
  210. if ($total < $page + 10) $end = $total;
  211. else $end = $page + 10;
  212. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.sis' AND `id_them`='$id_them' ORDER BY `id_mes` DESC LIMIT $page,10");}
  213.  
  214. if($fid==3){
  215. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.jar' OR `file_f` LIKE '%.jad' AND `id_them`='$id_them'"),0); $page = abs((int)$_GET['page']);
  216.  
  217. if($page < 0 || $page > $total) $page = 0;
  218. if ($total < $page + 10) $end = $total;
  219. else $end = $page + 10;
  220. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.jar' OR `file_f` LIKE '%.jad' AND `id_them`='$id_them' ORDER BY `id_mes` DESC LIMIT $page,10");}
  221.  
  222. if($fid==4){
  223. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.txt' AND `id_them`='$id_them'"),0); $page = abs((int)$_GET['page']);
  224.  
  225. if($page < 0 || $page > $total) $page = 0;
  226.  
  227. if ($total < $page + 10) $end = $total;
  228. else $end = $page + 10;
  229. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.txt' AND `id_them`='$id_them' ORDER BY `id_mes` DESC LIMIT $page,10");}
  230.  
  231. if($fid==5){
  232. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.zip' OR `file_f` LIKE '%.rar' AND `id_them`='$id_them'"),0); $page = abs((int)$_GET['page']);
  233.  
  234. if($page < 0 || $page > $total) $page = 0;
  235.  
  236. if ($total < $page + 10) $end = $total;
  237. else $end = $page + 10;
  238. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.zip' OR `file_f` LIKE '%.rar' AND `id_them`='$id_them' ORDER BY `id_mes` DESC LIMIT $page,10");}
  239.  
  240. if($fid==6){
  241. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.mp4' OR `file_f` LIKE '%.3gp' OR `file_f` LIKE '%.avi' AND `id_them`='$id_them'"),0); $page = abs((int)$_GET['page']);
  242.  
  243. if($page < 0 || $page > $total) $page = 0;
  244.  
  245. if ($total < $page + 10) $end = $total;
  246. else $end = $page + 10;
  247. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.mp4' OR `file_f` LIKE '%.3gp' OR `file_f` LIKE '%.avi' AND `id_them`='$id_them' ORDER BY `id_mes` DESC LIMIT $page,10");}
  248.  
  249. if($fid==7){
  250. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.png' OR `file_f` LIKE '%.jpg' OR `file_f` LIKE '%.gif' OR `file_f` LIKE '%.jpeg' AND `id_them`='$id_them'"),0); $page = abs((int)$_GET['page']);
  251.  
  252. if($page < 0 || $page > $total) $page = 0;
  253.  
  254. if ($total < $page + 10) $end = $total;
  255. else $end = $page + 10;
  256. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.png' OR `file_f` LIKE '%.jpg' OR `file_f` LIKE '%.jpeg' OR `file_f` LIKE '%.png' AND `id_them`='$id_them' ORDER BY `id_mes` DESC LIMIT $page,10");}
  257.  
  258. if($fid==8){
  259. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_messages` WHERE `file_f` LIKE '%.mmf' OR `file_f` LIKE '%.mp3' OR `file_f` LIKE '%.wav' OR `file_f` LIKE '%.amr' OR `file_f` LIKE '%.wma' OR `file_f` LIKE '%.mid' AND `id_them`='$id_them'"),0); $page = abs((int)$_GET['page']);
  260.  
  261. if($page < 0 || $page > $total) $page = 0;
  262. if ($total < $page + 10) $end = $total;
  263. else $end = $page + 10;
  264. $query=mysql_query("SELECT * FROM `forum_messages` WHERE `file_f` LIKE '%.mmf' OR `file_f` LIKE '%.mp3' OR `file_f` LIKE '%.wav' OR `file_f` LIKE '%.amr' OR `file_f` LIKE '%.wma' OR `file_f` LIKE '%.mid' AND `id_them`='$id_them' ORDER BY `id_mes` DESC LIMIT $page,10");}
  265. if($total!=0){
  266. while($data=mysql_fetch_array($query)){ $q=mysql_fetch_assoc(mysql_query("SELECT `ftname` FROM `forum_themes` WHERE `id_them`='".$data['id_them']."' LIMIT 1"));
  267. echo'<div class="p">&#187; <a href="load.php?id_mess='.$data['id_mes'].'">'.str_replace('files/','',$data['file_f']).'</a> ['.$data['file_c'].']<br/>Тема: <a href="/forum/theme/'.$data['id_kat'].'/'.$data['id_them'].'/">'.$q['ftname'].'</a><br>'.vizual($data['fmtext']).'<br>Хто: '.nik_tri($data['id_user']).'<br>Когда: '.date_fixed($data['timer']).'</div>';}
  268. strpage($page, 10, $total, 'files.php','act=view&amp;id_them='.$id_them.'&amp;fid='.$fid); }else{echo'Пусто';}
  269. }
  270.  
  271.  
  272.  
  273.  
  274. break;
  275. }
  276. require"../system/foot.php"; ?>