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

Размер файла: 16.02Kb
  1. <?
  2.  
  3. include_once("us.php");
  4. $id = $infoUserRows['id'];
  5.  
  6. list($maxOnl, $time) = explode("<>", file_get_contents("online.txt"));
  7. $online = mysql_result(
  8. mysql_query("SELECT COUNT(*)
  9. FROM `session`
  10. WHERE `time` > ".(time() - (10 * 60))), 0);
  11. if($online > intval($maxOnl))
  12. {
  13. fwrite(fopen('online.txt', 'w'), $online.'<>'.date('d.m.y H:i:s'));
  14. }
  15. if($version == "wml")
  16. {
  17. header('Content-type: text/vnd.wap.wml; charset=utf-8');
  18. header("Cache-Control: no-cache");
  19. echo(doctype("".date('H:i')." Форумы")."\r\n");
  20. echo($tag);
  21. /*if(!mysql_result(mysql_query("SELECT * FROM wcab WHERE id_user=".$id), 0))
  22. {
  23. echo ('<a href="'.$forumdir.'p=32&amp;s=1&amp;v=wml&amp;sid='.$sid.'&amp;rnd='.$ref.'">'.$tag.'<b>Оплата за общение!'.$tagC.'</b></a><br />');
  24. }*/
  25. if($authorize)
  26. {
  27. echo('<a href="./?p=24&amp;rnd='.$ref.'&amp;v=wml&amp;sid='.$sid.'">Приват');
  28. $private = mysql_result(
  29. mysql_query("SELECT COUNT(*)
  30. FROM `private`
  31. WHERE `name`='".$username."'
  32. AND `new`=1
  33. AND `mod`='i'"), 0);
  34. echo((empty($private) ? ' - 0</a>' : '</a> - <a href="./?p=24&amp;v=wml&amp;sid='.$sid.'&amp;new=1">'.$private.'</a>'));
  35. $sten = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE username='".$username."'"));
  36. $stenid=$sten['id'];
  37. echo(" | <a href=\"./?p=29&amp;rnd=".$ref."&amp;sid=".$sid."&amp;v=wml\">Стена");
  38. $st = mysql_result(
  39. mysql_query("SELECT COUNT(*)
  40. FROM `stena`
  41. WHERE `stenid`='".$stenid."'
  42. AND `s`=1"), 0);
  43. //echo((empty($st) ? ' - 0</a>' : '</a> - <a href="./?p=29&amp;stenid='.$stenid.'&amp;v=xhtml&amp;sid='.$sid.'&amp;sn=1">'.$st.'</a>'));
  44. echo((empty($st) ? ' - 0</a><br />' : ' - '.$st.'</a><br />'));
  45. if( in_array($status, array('admin', 'moderator')) )
  46. {
  47. //////////////////////////
  48. $mmfs = mysql_query("SELECT *
  49. FROM mforums
  50. ORDER BY mforums.pos"
  51. );
  52.  
  53. $mmaPosts = mysql_fetch_assoc(
  54. mysql_query("SELECT COUNT(*) AS cnt, MAX(mposts.time) AS mt
  55. FROM mposts
  56. LEFT JOIN mthemes
  57. ON mposts.id_theme=mthemes.id"));
  58. while($mmforums = mysql_fetch_assoc($mmfs))
  59. {
  60. $mmpcnt = mysql_fetch_assoc(
  61. mysql_query("SELECT COUNT(*) AS cnt, MAX(mposts.time) AS mt
  62. FROM mposts
  63. LEFT JOIN mthemes
  64. ON mposts.id_theme=mthemes.id
  65. WHERE id_forum=".$mmforums['id']));
  66. $mmlastTimeQ = mysql_query("SELECT * FROM `mcounter`
  67. WHERE `username`='".$username."'
  68. AND `fid`=".$mmforums['id']);
  69. $mmlastTimeR = mysql_fetch_assoc($mmlastTimeQ);
  70. $mmlastTime = $mmlastTimeR['time'];
  71.  
  72. $mmnPosts = mysql_result(
  73. mysql_query("SELECT COUNT(*)
  74. FROM mposts, mthemes
  75. WHERE mposts.id_theme=mthemes.id
  76. AND id_forum=".$mmforums['id']."
  77. AND mposts.time > '".$mmlastTime."'
  78. AND mposts.name != '".$username."'
  79. GROUP BY mthemes.id_forum"), 0);
  80.  
  81. if($mmnPosts < 1)
  82. {
  83. $mmnPosts = '0';
  84. }
  85. $mmnQPosts = $mmnPosts+$mmnQPosts;
  86. }
  87. /////////////////////////////////
  88. echo('<a href="./?p=1&amp;rnd='.$ref.'&amp;v='.$version.'&amp;sid='.$sid.'"><b>Модер-форум('.intval($mmnPosts).'/'.$mmaPosts['cnt'].')</b></a> | ');
  89. }
  90. if($status == "admin")
  91. {
  92. echo('<a href="./?p=27&amp;rnd='.$ref.'&amp;v=wml&amp;sid='.$sid.'"><b>Админка</b></a> | ');
  93. }
  94. if( in_array($status, array('admin', 'moderator')) )
  95. {
  96. echo("<a href='./?p=26&amp;back=" . base64_encode(htmlspecialchars($_SERVER['REQUEST_URI'])) . "&amp;sid=$sid&amp;v=wml'>Бан по нику</a><br />\r\n");
  97. }
  98. echo('<br />');
  99. }
  100. if($authorize)
  101. {
  102. $fs = mysql_query("SELECT *
  103. FROM forums
  104. ORDER BY forums.pos"
  105. );
  106.  
  107. $aPosts = mysql_fetch_assoc(
  108. mysql_query("SELECT COUNT(*) AS cnt, MAX(posts.time) AS mt
  109. FROM posts
  110. LEFT JOIN themes
  111. ON posts.id_theme=themes.id"));
  112. while($forums = mysql_fetch_assoc($fs))
  113. {
  114. $pcnt = mysql_fetch_assoc(
  115. mysql_query("SELECT COUNT(*) AS cnt, MAX(posts.time) AS mt
  116. FROM posts
  117. LEFT JOIN themes
  118. ON posts.id_theme=themes.id
  119. WHERE id_forum=".$forums['id']));
  120. $lastTimeQ = mysql_query("SELECT * FROM `counter`
  121. WHERE `username`='".$username."'
  122. AND `fid`=".$forums['id']);
  123. $lastTimeR = mysql_fetch_assoc($lastTimeQ);
  124. $lastTime = $lastTimeR['time'];
  125.  
  126. $nPosts = mysql_result(
  127. mysql_query("SELECT COUNT(*)
  128. FROM posts, themes
  129. WHERE posts.id_theme=themes.id
  130. AND id_forum=".$forums['id']."
  131. AND posts.time > '".$lastTime."'
  132. AND posts.name != '".$username."'
  133. GROUP BY themes.id_forum"), 0);
  134.  
  135. if($nPosts < 1)
  136. {
  137. $nPosts = '0';
  138. }
  139. $nQPosts = $nPosts+$nQPosts;
  140. }
  141. echo("Новых/Всего: <b>(".intval($nQPosts)."/".intval($aPosts['cnt']).")</b><br />");
  142. }
  143. else if (!$authorize)
  144. {
  145. $aPosts = mysql_fetch_assoc(
  146. mysql_query("SELECT COUNT(*) AS cnt, MAX(posts.time) AS mt
  147. FROM posts
  148. LEFT JOIN themes
  149. ON posts.id_theme=themes.id"));
  150.  
  151.  
  152. echo("Всего: <b>(".$aPosts['cnt'].")</b><br />");
  153. }
  154. }
  155. elseif($version == "xhtml")
  156. {
  157. header("Content-type: text/html; charset=utf-8");
  158. header("Last-Modified:".gmdate("D, d M Y H:i:s")." GMT");
  159. header("Cache-Control: no-cache, must-relative");
  160. echo('<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
  161. "http://www.w3.org/TR/html4/loose.dtd">
  162. <html>
  163. <head>
  164. <title>'.date('H:i').' Форумы</title>
  165. </head>
  166. <body bgcolor="'.$style['background'].'" link="'.$style['link'].'" vlink="'.$style['link'].'" text="#000000">
  167. <table align="center" border="0" cellspacing="1" cellpadding="5" width="350">
  168. <tr><td align="center" bgcolor="'.$style['title'].'">
  169. <font color="#FFFFFF"><b>Форумы</b></font>
  170. </td></tr>');
  171. /*if(!mysql_result(mysql_query("SELECT * FROM wcab WHERE id_user=".$id), 0))
  172. {
  173. echo ('<tr bgcolor="#deebf1"><td colspan="2"><a href="'.$forumdir.'p=32&amp;s=1&amp;v=xhtml&amp;sid='.$sid.'&amp;rnd='.$ref.'">'.$tag);
  174. //echo('<center><a href="http://uptraf.ru">UPTRAF.RU Скупает рекламу за 1000 руб!</a><br /></center>');
  175. echo('<a href="'.$forumdir.'p=32&amp;s=1&amp;v=xhtml&amp;sid='.$sid.'&amp;rnd='.$ref.'"><b>Оплата за общение!'.$tagC.'</b></a><br /></td></tr>');
  176. }*/
  177. echo('<tr><td bgcolor="'.$style['bottom'].'">
  178. '.$tag);
  179.  
  180. if($authorize)
  181. {
  182. echo('<a href="./?p=24&amp;rnd='.$ref.'&amp;v=xhtml&amp;sid='.$sid.'">Приват');
  183. $private = mysql_result(
  184. mysql_query("SELECT COUNT(*)
  185. FROM `private`
  186. WHERE `name`='".$username."'
  187. AND `new`=1
  188. AND `mod`='i'"), 0);
  189. echo((empty($private) ? ' - 0</a>' : '</a> - <a href="./?p=24&amp;v=xhtml&amp;sid='.$sid.'&amp;new=1">'.$private.'</a>'));
  190. $sten = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE username='".$username."'"));
  191. $stenid=$sten['id'];
  192. echo(" | <a href=\"./?p=29&amp;rnd=".$ref."&amp;sid=".$sid."&amp;v=xhtml\">Стена");
  193. $st = mysql_result(
  194. mysql_query("SELECT COUNT(*)
  195. FROM `stena`
  196. WHERE `stenid`='".$stenid."'
  197. AND `s`=1"), 0);
  198. //echo((empty($st) ? ' - 0</a>' : '</a> - <a href="./?p=29&amp;stenid='.$stenid.'&amp;v=xhtml&amp;sid='.$sid.'&amp;sn=1">'.$st.'</a>'));
  199. echo((empty($st) ? ' - 0</a>' : ' - '.$st.'</a>'));
  200. echo("<br />");
  201. }
  202.  
  203.  
  204.  
  205.  
  206. if( in_array($status, array('admin', 'moderator')) )
  207. {
  208. //////////////////////////
  209. $mmfs = mysql_query("SELECT *
  210. FROM mforums
  211. ORDER BY mforums.pos"
  212. );
  213.  
  214. $mmaPosts = mysql_fetch_assoc(
  215. mysql_query("SELECT COUNT(*) AS cnt, MAX(mposts.time) AS mt
  216. FROM mposts
  217. LEFT JOIN mthemes
  218. ON mposts.id_theme=mthemes.id"));
  219. while($mmforums = mysql_fetch_assoc($mmfs))
  220. {
  221. $mmpcnt = mysql_fetch_assoc(
  222. mysql_query("SELECT COUNT(*) AS cnt, MAX(mposts.time) AS mt
  223. FROM mposts
  224. LEFT JOIN mthemes
  225. ON mposts.id_theme=mthemes.id
  226. WHERE id_forum=".$mmforums['id']));
  227. $mmlastTimeQ = mysql_query("SELECT * FROM `mcounter`
  228. WHERE `username`='".$username."'
  229. AND `fid`=".$mmforums['id']);
  230. $mmlastTimeR = mysql_fetch_assoc($mmlastTimeQ);
  231. $mmlastTime = $mmlastTimeR['time'];
  232.  
  233. $mmnPosts = mysql_result(
  234. mysql_query("SELECT COUNT(*)
  235. FROM mposts, mthemes
  236. WHERE mposts.id_theme=mthemes.id
  237. AND id_forum=".$mmforums['id']."
  238. AND mposts.time > '".$mmlastTime."'
  239. AND mposts.name != '".$username."'
  240. GROUP BY mthemes.id_forum"), 0);
  241.  
  242. if($mmnPosts < 1)
  243. {
  244. $mmnPosts = '0';
  245. }
  246. $mmnQPosts = $mmnPosts+$mmnQPosts;
  247. }
  248. /////////////////////////////////
  249. echo('<a href="./?p=1&amp;rnd='.$ref.'&amp;v=xhtml&amp;sid='.$sid.'"><b>Модер-форум('.intval($mmnQPosts).'/'.$mmaPosts['cnt'].')</b></a> | ');
  250. }
  251.  
  252.  
  253.  
  254. if($status == "admin")
  255. {
  256. echo('<a href="./?p=27&amp;v=xhtml&amp;sid='.$sid.'"><b>Админка</b></a> | ');
  257. }
  258. if( in_array($status, array('admin', 'moderator')) )
  259. {
  260. echo("<a href='./?p=26&amp;back=" . base64_encode(htmlspecialchars($_SERVER['REQUEST_URI'])) . "&amp;sid=$sid&amp;v=xhtml'>Бан по нику</a><br />\r\n");
  261. }
  262.  
  263. /////////////////////////////////////////////
  264. if($authorize)
  265. {
  266. $fs = mysql_query("SELECT *
  267. FROM forums
  268. ORDER BY forums.pos"
  269. );
  270.  
  271. $aPosts = mysql_fetch_assoc(
  272. mysql_query("SELECT COUNT(*) AS cnt, MAX(posts.time) AS mt
  273. FROM posts
  274. LEFT JOIN themes
  275. ON posts.id_theme=themes.id"));
  276. while($forums = mysql_fetch_assoc($fs))
  277. {
  278. $pcnt = mysql_fetch_assoc(
  279. mysql_query("SELECT COUNT(*) AS cnt, MAX(posts.time) AS mt
  280. FROM posts
  281. LEFT JOIN themes
  282. ON posts.id_theme=themes.id
  283. WHERE id_forum=".$forums['id']));
  284. $lastTimeQ = mysql_query("SELECT * FROM `counter`
  285. WHERE `username`='".$username."'
  286. AND `fid`=".$forums['id']);
  287. $lastTimeR = mysql_fetch_assoc($lastTimeQ);
  288. $lastTime = $lastTimeR['time'];
  289.  
  290. $nPosts = mysql_result(
  291. mysql_query("SELECT COUNT(*)
  292. FROM posts, themes
  293. WHERE posts.id_theme=themes.id
  294. AND id_forum=".$forums['id']."
  295. AND posts.time > '".$lastTime."'
  296. AND posts.name != '".$username."'
  297. GROUP BY themes.id_forum"), 0);
  298.  
  299. if($nPosts < 1)
  300. {
  301. $nPosts = '0';
  302. }
  303. $nQPosts = $nPosts+$nQPosts;
  304. }
  305. echo("Новых/Всего: <b>(".intval($nQPosts)."/".intval($aPosts['cnt']).")</b>");
  306. }
  307. else
  308. {
  309. $aPosts = mysql_fetch_assoc(
  310. mysql_query("SELECT COUNT(*) AS cnt, MAX(posts.time) AS mt
  311. FROM posts
  312. LEFT JOIN themes
  313. ON posts.id_theme=themes.id"));
  314.  
  315.  
  316. echo("Всего: <b>(".$aPosts['cnt'].")</b>");
  317. }
  318.  
  319.  
  320. /////////////////////////////////////////////
  321.  
  322.  
  323. echo($tagC);
  324. echo('</td></tr><tr><td bgcolor="'.$style['text'].'">'.$tag);
  325. }
  326. $f = mysql_query("SELECT *
  327. FROM forums
  328. ORDER BY forums.pos"
  329. );
  330. if(isset($_GET['tarifs']))
  331. {
  332. echo('<u>Стоимость за 1 сообщение.</u><br />');
  333. }
  334. while($forums = mysql_fetch_assoc($f))
  335. {
  336. $pcnt = mysql_fetch_assoc(
  337. mysql_query("SELECT COUNT(*) AS cnt, MAX(posts.time) AS mt
  338. FROM posts
  339. LEFT JOIN themes
  340. ON posts.id_theme=themes.id
  341. WHERE id_forum=".$forums['id']));
  342. if($authorize)
  343. {
  344. $lastTimeQ = mysql_query("SELECT * FROM `counter`
  345. WHERE `username`='".$username."'
  346. AND `fid`=".$forums['id']);
  347. $lastTimeR = mysql_fetch_assoc($lastTimeQ);
  348. $lastTime = $lastTimeR['time'];
  349.  
  350. $newPosts = @intval(
  351. mysql_result(
  352. mysql_query("SELECT COUNT(*)
  353. FROM posts, themes
  354. WHERE posts.id_theme=themes.id
  355. AND id_forum=".$forums['id']."
  356. AND posts.time > '".$lastTime."'
  357. AND posts.name != '".$username."'
  358. GROUP BY themes.id_forum"), 0)).'/';
  359.  
  360. if($newPosts < 1)
  361. {
  362. $newPosts = '0/';
  363. }
  364.  
  365. }
  366. if(isset($_GET['tarifs']))
  367. {
  368. echo('<b>'.$forums['name'].'</b>');
  369. } else
  370. {
  371. echo(date("d/m H:i", $pcnt['mt'])."<b>(".$newPosts.intval($pcnt['cnt']).")</b><br />\r\n");
  372. if($authorize)
  373. {
  374. echo('<b><a href="./?p=2&amp;f='.$forums['id'].'&amp;rnd='.$ref.'&amp;sid='.$sid.'&amp;v='.$version.'">'.$forums['name'].'</a></b>');
  375. }
  376. else
  377. {
  378. echo('<b><a href="./?p=2&amp;f='.$forums['id'].'&amp;rnd='.$ref.'&amp;v='.$version.'">'.$forums['name'].'</a></b>');
  379. }
  380. }
  381. if(isset($_GET['tarifs']))
  382. {
  383. if($forums['id'] == "1")
  384. {
  385. echo(' - 0.1');
  386. }
  387. elseif($forums['id'] != "20" && $forums['id'] != "16" && $forums['id'] != "18" && $forums['id'] != "19")
  388. {
  389. echo(' - 0.3');
  390. }
  391. else
  392. {
  393. echo(' - 0.00');
  394. }
  395. }
  396. echo('<br /> <br />');
  397. }
  398. if(isset($_GET['tarifs']))
  399. {
  400. echo('<u>Все суммы указаны в рублях.</u><br />');
  401. }
  402. $fonl = mysql_query("SELECT nickname FROM `session` WHERE `time` > ".(time() - (10 * 60)));
  403. $uonl = mysql_num_rows($fonl);
  404. if($version == "wml")
  405. {
  406. echo('<br />');
  407. if($authorize)
  408. {
  409. echo('<a href="./?p=12&amp;sid='.$sid.'&amp;v=wml&amp;rnd='.$ref.'">Online: <b>'.intval($uonl).'</b></a><br />');
  410. echo('<a href="./?p=33&amp;v=wml&amp;sid='.$sid.'&amp;rnd='.$ref.'">Кабинет</a> | ');
  411. echo('<a href="./?p=20&amp;v=wml&amp;sid='.$sid.'">Поиск</a> | ');
  412. //echo('<a href="./?p=13&amp;sid='.$sid.'&amp;v=wml">Топ-20</a> | ');
  413. //echo('<a href="./?p=11&amp;stat&amp;sid='.$sid.'&amp;v=wml">Статистика</a> | ');
  414. //echo('<a href="./?p=14&amp;v=wml&amp;sid='.$sid.'">Помощь</a> | ');
  415. echo('<a href="./?p=28&amp;logout=1&amp;v=wml&amp;sid='.$sid.'"><b>Выход</b></a><br />');
  416. }
  417. else
  418. {
  419. echo('Online: <b>'.intval($uonl).'</b><br />');
  420. echo('<a href="./?p=19&amp;v=wml&amp;rnd='.$ref.'">Авторизация</a> | ');
  421. echo('<a href="./?p=20&amp;v=wml">Поиск</a> | ');
  422. //echo('<a href="./?p=11&amp;v=wml&amp;rnd='.$ref.'">Статистика</a> | ');
  423. echo('<a href="./?p=14&amp;v=wml">Помощь</a><br />');
  424. echo('<center>wml | <a href="./?v=xhtml">html</a><br /></center>');
  425. }
  426. echo($tagC.'
  427. </p></card></wml>');
  428. }
  429. elseif($version == "xhtml")
  430. {
  431. echo($tagC.'</td></tr>');
  432. echo("<tr><td bgcolor=\"".$style['bottom']."\">\r\n".$tag);
  433. if(!$authorize)
  434. {
  435. echo('Online: <b>'.intval($uonl).'</b><br />');
  436. echo('
  437. <a href="./?p=19&amp;v=xhtml&amp;rnd='.$ref.'">Авторизация</a> |
  438. <a href="./?p=20&amp;v=xhtml">Поиск</a> | ');
  439. //echo('<a href="./?p=11&amp;v=xhtml&amp;rnd='.$ref.'">Статистика</a> | ');
  440. echo('<a href="./?p=14&amp;v=xhtml">Помощь</a><br />');
  441. echo('<tr><td align="center" bgcolor="'.$style['bottom'].'">
  442. <center><a href="./?v=wml">wml</a> | html<br /></center></td></tr>');
  443. }
  444. else
  445. {
  446. echo('<a href="./?p=12&amp;sid='.$sid.'&amp;v=xhtml&amp;rnd='.$ref.'">Online: <b>'.intval($uonl).'</b></a><br />');
  447. echo('<a href="./?p=33&amp;v=xhtml&amp;sid='.$sid.'&amp;rnd='.$ref.'">Кабинет</a> | ');
  448. echo('<a href="./?p=20&amp;v=xhtml&amp;sid='.$sid.'">Поиск</a> | ');
  449. //echo('<a href="./?p=13&amp;sid='.$sid.'&amp;v=xhtml&amp;rnd='.$ref.'">Топ-20</a> | ');
  450. //echo('<a href="./?p=11&amp;sid='.$sid.'&amp;v=xhtml">Статистика</a> | ');
  451. //echo('<a href="./?p=14&amp;v=xhtml&amp;sid='.$sid.'">Помощь</a> | ');
  452. echo('<a href="./?p=28&amp;logout=1&amp;v=xhtml&amp;sid='.$sid.'"><b>Выход</b></a><br />');
  453. }
  454. echo($tagC.'</td></tr>');
  455. echo("</table>
  456. </body></html>");
  457. }
  458. ?>