PageRenderTime 84ms CodeModel.GetById 12ms RepoModel.GetById 0ms app.codeStats 1ms

/inc/forum/forums.topics.php

https://bitbucket.org/wopkevries/blizzlike-313-website
PHP | 915 lines | 808 code | 91 blank | 16 comment | 187 complexity | 523fcbfb2b64f715fdd64f889be509ca MD5 | raw file
Possible License(s): LGPL-2.1
  1. <?php
  2. if (INCLUDED!==true) { include('index.htm'); exit; }
  3. ?>
  4. <style>
  5. select.icon-menu option {
  6. background-repeat: no-repeat;
  7. background-position: center left;
  8. padding-left: 30px;
  9. padding-bottom: 12px;
  10. }
  11. </style>
  12. <?php
  13. if ($_REQUEST['topic']!='') {
  14. if ($_REQUEST['topic']=='new' OR ($_REQUEST['topic']=='edit' AND $_REQUEST['t']!='')) {
  15. $forceshow=true;
  16. if ($_REQUEST['topic']=='edit' AND $_SERVER['REQUEST_METHOD']!='POST') {
  17. $rowj=mysql_fetch_array(mysql_query("SELECT *, ft.title as title, ft.category as category, ft.image as image
  18. FROM forum_posts fp
  19. LEFT JOIN (forum_topics ft) ON ft.id_topic = fp.id_topic
  20. LEFT JOIN (account a) ON a.id = fp.id_account
  21. WHERE fp.id_topic='".$_REQUEST['t']."' AND fp.isreply='0'
  22. ORDER BY `id_post` ASC ", $MySQL_CON));
  23. $rowk=mysql_fetch_array(mysql_query("SELECT id_post FROM forum_posts WHERE id_topic='".$_REQUEST['t']."' ORDER BY `id_post` DESC LIMIT 0, 1", $MySQL_CON));
  24. if ($_SESSION['userid']==$rowj['id_account'] AND ($SETTING['USER_EDIT_OWN_POSTS']=='1' OR ($SETTING['USER_EDIT_OWN_POSTS']=='2' AND $rowk['id_account']==$_SESSION['userid'])) OR $userlvl>0) {
  25. $_POST['subject']=$rowj['title'];
  26. $_POST['message']=$rowj['text'];
  27. $_POST['viewlevel']=$rowj['viewlevel'];
  28. $_POST['postlevel']=$rowj['postlevel'];
  29. $_POST['issticked']=$rowj['issticked'];
  30. $_POST['category']=$rowj['category'];
  31. $_POST['posticon']=$rowj['image'];
  32. $_POST['pollask']=$rowj['poll_question'];
  33. if ($rowj['poll_question']!='') {
  34. $getvote = mysql_query("SELECT name FROM forum_rel_topics_polls WHERE id_topic='".$_REQUEST['t']."' ORDER by id_poll ASC", $MySQL_CON);
  35. while ($rowg=mysql_fetch_array($getvote)) {
  36. $_POST['polloption'][] = $rowg['name'];
  37. }
  38. }
  39. $_POST['pollfor']=$rowj['poll_lasts'];
  40. $_POST['issigned']=$rowj['issignature'];
  41. $_POST['isbbcode']=$rowj['isbbcode'];
  42. } else {
  43. echo '<br><br><br><br>';
  44. errborder('You are not allowed to Edit this Topic.');
  45. echo '<br><br><br><br>';
  46. $forceshow=false;
  47. }
  48. } else if ($_REQUEST['topic']=='new' AND $_SERVER['REQUEST_METHOD']!='POST') {
  49. $_POST['issigned']='1';
  50. $_POST['isbbcode']='1';
  51. }
  52. ?>
  53. <form name="postForm" id="postForm" action="<?php
  54. if ($_REQUEST['topic']=='new') {
  55. echo '?n=forums&f='.$_REQUEST['f'].'&topic=new';
  56. } else if ($_REQUEST['topic']=='edit') {
  57. echo '?n=forums&t='.$_REQUEST['t'].'&topic=edit&r='.$_REQUEST['r'];
  58. }
  59. ?>" method="post">
  60. <?php
  61. if ($_POST['viewlevel']!='' AND alphanum($_POST['viewlevel'], true, false)==false OR $_POST['viewlevel']=='') { $_POST['viewlevel']='-1'; }
  62. if ($_POST['postlevel'] < '0') { $_POST['postlevel'] = '0'; }
  63. if ($_POST['viewlevel'] > $_POST['postlevel']) { $_POST['postlevel'] = $_POST['viewlevel']; }
  64. if ($_POST['pollfor']=='') { $_POST['pollfor']='0'; }
  65. if ($_POST['issigned']=='') { $_POST['issigned']='0'; } else if ($_POST['issigned']!='0') { $_POST['issigned']='1'; }
  66. if ($_POST['isbbcode']=='') { $_POST['isbbcode']='0'; } else if ($_POST['isbbcode']!='0') { $_POST['isbbcode']='1'; }
  67. if ($_POST['newpost']=='post') {
  68. if (strlen($_POST['subject'])<5) {
  69. $haserrors.='Subject field must have more than 5 characters.<br>';
  70. }
  71. if (strlen($_POST['message'])<5) {
  72. $haserrors.='Message field must have more than 5 characters.<br>';
  73. }
  74. if (strlen($_POST['pollask'])>0 AND strlen($_POST['pollask'])<3) {
  75. $haserrors.='Poll Question field must have more than 3 characters<br>';
  76. } else if (strlen($_POST['pollask'])>=3) {
  77. $j=0;
  78. for ($i=0;$i<count($_POST['polloption']);$i++) {
  79. if (strlen($_POST['polloption'][$i])>0) { $j++; }
  80. }
  81. if ($j<2) {
  82. $haserrors.='You need at least 2 Options fields filled in order to create a poll.<br>';
  83. }
  84. if ($_POST['pollfor']!='' AND alphanum($_POST['pollfor'],true,false)==false) {
  85. $haserrors.='Invalid value in a Poll Duration field.<br>';
  86. }
  87. }
  88. if ($haserrors=='') {
  89. if ($_REQUEST['topic']=='new') {
  90. if (strlen($_POST['pollask'])>0) { $pollstamp=date('y-m-d H:i:s'); } else { $pollstamp='0000-00-00 00:00:00'; }
  91. $query = "INSERT INTO forum_topics(title, poll_question, poll_lasts, id_forum, poll_stamp";
  92. if ($userlvl>0) { $query .= ", viewlevel, postlevel, issticked, category, image"; }
  93. $query .= ") VALUES('".$_POST["subject"]."','".$_POST["pollask"]."','".$_POST["pollfor"]."','".$_REQUEST["f"]."', '".$pollstamp."'";
  94. if ($userlvl>0) { $query .= ",'".$_POST["viewlevel"]."','".$_POST["postlevel"]."', '".$_POST["issticked"]."','".$_POST["category"]."',
  95. '".$_POST["posticon"]."'"; }
  96. $query .= ")";
  97. $query = mysql_query($query, $MySQL_CON) OR DIE(mysql_error());
  98. $lasttopicid = mysql_insert_id($MySQL_CON);
  99. $query = mysql_query("INSERT INTO forum_posts(text, date, hour, isreply, issignature, isbbcode, id_account, id_topic)
  100. VALUES('".$_POST['message']."','".date('Y-m-d')."','".date('H:i:s')."', 0,
  101. '".$_POST['issigned']."','".$_POST['isbbcode']."','".$_SESSION['userid']."','".$lasttopicid."')", $MySQL_CON) OR DIE(mysql_error());
  102. if (strlen($_POST['pollask'])>0) {
  103. for($i=0;$i<(count($_POST['polloption']));$i++) {
  104. if (strlen($_POST['polloption'][$i])>0) {
  105. $query = mysql_query("INSERT INTO forum_rel_topics_polls(id_topic, name)
  106. VALUES('".$lasttopicid."','".$_POST['polloption'][$i]."')", $MySQL_CON) OR DIE(mysql_error());
  107. }
  108. }
  109. }
  110. } else if ($_REQUEST['topic']=='edit') {
  111. $query = "UPDATE forum_topics SET title='".$_POST["subject"]."'";
  112. if ($userlvl>0) { $query .= ", viewlevel='".$_POST["viewlevel"]."', postlevel='".$_POST["postlevel"]."', issticked='".$_POST["issticked"]."',
  113. category='".$_POST["category"]."', image='".$_POST["posticon"]."'"; }
  114. $query .= "WHERE id_topic='".$_REQUEST['t']."'";
  115. $query = mysql_query($query, $MySQL_CON) OR DIE(mysql_error());
  116. $query = mysql_query("UPDATE forum_posts SET `text`='".$_POST['message']."', date_edit='".date('Y-m-d')."',
  117. hour_edit='".date('H:i:s')."', id_account_edit='".$_SESSION['userid']."',
  118. issignature='".$_POST['issigned']."', isbbcode='".$_POST['isbbcode']."' WHERE id_topic='".$_REQUEST['t']."' AND isreply=0", $MySQL_CON) OR DIE(mysql_error());
  119. if ($_POST['removepoll']=='1') {
  120. mysql_query("DELETE FROM forum_rel_topics_polls WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON);
  121. mysql_query("DELETE FROM forum_rel_account_polls WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON);
  122. mysql_query("DELETE FROM forum_rel_account_polls WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON);
  123. mysql_query("UPDATE forum_topics SET poll_question='', poll_lasts='0', poll_stamp='0000-00-00 00:00:00' WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON) OR DIE(mysql_error());
  124. } else {
  125. if (strlen($_POST['pollask'])>0) {
  126. $query = mysql_query("UPDATE forum_topics SET poll_question='".$_POST["pollask"]."', poll_lasts='".$_POST["pollfor"]."' WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON) OR DIE(mysql_error());
  127. }
  128. if (strlen($_POST['pollask'])>0) {
  129. for($i=0;$i<(count($_POST['polloption']));$i++) {
  130. if (strlen($_POST['polloption'][$i])>0) {
  131. $query = mysql_query("INSERT INTO forum_rel_topics_polls(id_topic, name)
  132. VALUES('".$_REQUEST['t']."','".$_POST['polloption'][$i]."')", $MySQL_CON) OR DIE(mysql_error());
  133. }
  134. }
  135. }
  136. }
  137. $lasttopicid = $_REQUEST['t'];
  138. }
  139. viewedtopic($lasttopicid);
  140. unset($_POST['subject']);
  141. unset($_POST['message']);
  142. echo '<br><br><br><br>';
  143. goodborder('Your message has been entered successfully.<META HTTP-EQUIV="Refresh" CONTENT="1; URL=?n=forums&t='.$lasttopicid.'">');
  144. newrssfeed();
  145. $forceshow=false;
  146. echo '<br><br><br><br>';
  147. }
  148. }
  149. if ($forceshow==true) {
  150. remslashall();
  151. ?>
  152. <input type=hidden name="newpost" value='post'>
  153. <div id="post" align=center>
  154. <div class="post-box">
  155. <div class="post-box-bottom">
  156. <div class="post-box-top">
  157. <div id="post-topic-shell">
  158. <div class="resultbox">
  159. <?php if ($haserrors!='') { echo errborder($haserrors); } ?>
  160. <div id="postdisplay">
  161. <div class="border">
  162. <div class="insert">
  163. <blockquote>
  164. <div class="post-top">
  165. <br/>
  166. <!-- end admin-container -->
  167. <div class="subject-container">
  168. <div class="subject-box">
  169. <div class="post-title"></div>
  170. <h1><span>Subject:</span></h1>
  171. <input name="subject" size="20" tabindex="3" maxlength="45" class="post-subject-field" value="<?php echo $_POST['subject']; ?>"/>
  172. </div>
  173. <!-- end subject-box -->
  174. <!-- end subject-message -->
  175. </div><!-- end subject-container -->
  176. <div class="message-container">
  177. <div class="post-ui-container">
  178. <div id="post-ui" style="width: 266px;">
  179. <div class="post-ui-left">
  180. <div class="post-ui-right"style="width: 266px;">
  181. <script language=javascript src="new-hp/js/quick_reply.js"></script>
  182. <style>
  183. #post li.bold { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-bold.gif') no-repeat; }
  184. #post li.italic { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-italic.gif') no-repeat; }
  185. #post li.underline { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-underline.gif') no-repeat; }
  186. #post li.list { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-list.gif') no-repeat; }
  187. #post li.left{ background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-left.gif') no-repeat; cursor: hand; }
  188. #post li.center { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-center.gif') no-repeat; cursor: hand; }
  189. #post li.right { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-right.gif') no-repeat; cursor: hand; }
  190. #post li.link { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-link.gif') no-repeat; cursor: hand; }
  191. #post li.image { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-image.gif') no-repeat; cursor: hand; }
  192. #post li.tabbed-list { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-tabbed-list.gif') no-repeat; }
  193. #post li.hr { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-hr.gif') no-repeat; }
  194. #post li.pre { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-pre.gif') no-repeat; }
  195. #post li.quote { background: url('new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/button-quote.gif') no-repeat; }
  196. </style>
  197. <ul>
  198. <li class="bold"><a href="javascript:edInsertTag(document.postForm.message, 0);" ><img src="new-hp/images/forum/pixel.gif" alt="bold" onmouseover="ddrivetip('Bold','#ffffff')"; onmouseout="hideddrivetip()" /></a></li>
  199. <li class="italic"><a href="javascript:edInsertTag(document.postForm.message, 1);"><img src="new-hp/images/forum/pixel.gif" alt="italic" onmouseover="ddrivetip('Italic','#ffffff')"; onmouseout="hideddrivetip()" /></a></li>
  200. <li class="underline"><a href="javascript:edInsertTag(document.postForm.message, 2);" ><img src="new-hp/images/forum/pixel.gif" alt="underline" onmouseover="ddrivetip('Underline','#ffffff')"; onmouseout="hideddrivetip()" /></a></li>
  201. <li class="left"><a href="javascript:edInsertTag(document.postForm.message, 3);" ><img src="new-hp/images/forum/pixel.gif" id=bbleft value="B" alt="Left" onmouseover="ddrivetip('Align Left','#ffffff')"; onmouseout="hideddrivetip()" ></a></li>
  202. <li class="center"><a href="javascript:edInsertTag(document.postForm.message, 4);" ><img src="new-hp/images/forum/pixel.gif" id=bbcenter value="I" alt="Center" onmouseover="ddrivetip('Align Center','#ffffff')"; onmouseout="hideddrivetip()" ></a></li>
  203. <li class="right"><a href="javascript:edInsertTag(document.postForm.message, 5);" ><img src="new-hp/images/forum/pixel.gif" id=bbright value="U" alt="Right" onmouseover="ddrivetip('Align Right','#ffffff')"; onmouseout="hideddrivetip()" ></a></li>
  204. <li class="link"><a href="javascript:edInsertLink(document.postForm.message, 2);" ><img src="new-hp/images/forum/pixel.gif" id=bblink value="Link" alt="Link" onmouseover="ddrivetip('Insert URL','#ffffff')"; onmouseout="hideddrivetip()" ></a></li>
  205. <li class="image"><a href="javascript:edInsertImage(document.postForm.message);" ><img src="new-hp/images/forum/pixel.gif" id=bbimage value="Image" alt="Image" onmouseover="ddrivetip('Insert Image','#ffffff')"; onmouseout="hideddrivetip()" ></a></li>
  206. <li class="quote"><a href="javascript:edInsertTag(document.postForm.message, 8);"><img src="new-hp/images/forum/pixel.gif" alt="quote" onmouseover="ddrivetip('Quote','#ffffff')"; onmouseout="hideddrivetip()" /></a></li>
  207. </ul>
  208. </div>
  209. </div>
  210. </div>
  211. </div>
  212. <div class="message-body-main">
  213. <div class="message-bottom">
  214. <div class="message-top">
  215. <h2><span>Message:</span></h2>
  216. <textarea name="message" id="message" tabindex="4" rows="5" cols="10" class="post-message-text"><?php echo $_POST['message'] ?></textarea>
  217. </div>
  218. </div>
  219. </div>
  220. </div><!-- end message-container -->
  221. <?php if ($userlvl>0) { ?>
  222. <div class="options-container">
  223. <div class="options-left">
  224. <div class="options-right">
  225. <?php
  226. $sz=165;
  227. if ($_POST['category']=='1') { $sz+=35; } else if ($_POST['category']=='3') { $sz+=70; }
  228. ?>
  229. <div class="options-bot" style="height: <?php echo $sz; ?>;">
  230. <div class="options-top" >
  231. <div class="sig-options" style="width: 500;" align=left>
  232. <span class="help-tip" style="font-size: 12px;">View Level:</span>&nbsp;&nbsp;
  233. <select name='viewlevel' onchange='document.postForm.newpost.value="viewlevel"; document.postForm.submit();'>
  234. <?php
  235. if ($userlvl > 3) { $ulvl = 3; } else { $ulvl=$userlvl; }
  236. for ($i=$rowz['viewlevel'];$i<=$ulvl;$i++) {
  237. echo '<option value="'.$i.'">'.$USER_LEVEL[$i];
  238. }
  239. ?>
  240. </select><br><br>
  241. <script>
  242. <?php if ($_POST['viewlevel']!='') { ?> document.postForm.viewlevel.value = '<?php echo $_POST['viewlevel']; ?>';<?php } ?>
  243. </script>
  244. <span class="help-tip" style="font-size: 12px;">Post Level:</span>&nbsp;&nbsp;
  245. <select name='postlevel'>
  246. <?php
  247. if ( $_POST['viewlevel'] < $rowz['postlevel'] ) {
  248. $postlvl = $rowz['postlevel'];
  249. } else if ( alphanum($_POST['viewlevel'],true, false)==false OR $_POST['viewlevel'] < 0 OR $_POST['viewlevel'] == '' ) {
  250. $postlvl=0;
  251. } else if ( $_POST['viewlevel'] >= $rowz['postlevel'] ) {
  252. $postlvl = $_POST['viewlevel'];
  253. } else if ( $_POST['viewlevel'] >= $rowz['viewlevel'] ) {
  254. $postlvl = $_POST['viewlevel'];
  255. } else {
  256. $postlvl = $rowz['viewlevel'];
  257. }
  258. for ($i=$postlvl;$i<=$userlvl;$i++) {
  259. echo '<option value="'.$i.'">'.$USER_LEVEL[$i];
  260. }
  261. ?>
  262. </select>
  263. <script>
  264. <?php if ($_POST['viewlevel']!='') { ?> document.postForm.postlevel.value = '<?php echo $_POST['postlevel']; ?>';<?php } ?>
  265. </script><br><br>
  266. <span class="help-tip" style="font-size: 12px;">Sticked:</span>&nbsp;&nbsp;
  267. <select name='issticked'>
  268. <option value='0' SELECTED>No
  269. <option value='1'>Yes
  270. </select>
  271. <script>
  272. <?php if ($_POST['viewlevel']!='') { ?> document.postForm.issticked.value = '<?php echo $_POST['issticked']; ?>';<?php } ?>
  273. </script><br><br>
  274. <span class="help-tip" style="font-size: 12px;">Category:</span>&nbsp;&nbsp;
  275. <select name='category' onchange='document.postForm.newpost.value="category"; document.postForm.submit();'>
  276. <option value='0'>None
  277. <option value='1'>News
  278. <option value='2'>Community
  279. <option value='3'>Contests
  280. </select>
  281. <script>
  282. <?php if ($_POST['viewlevel']!='') { ?> document.postForm.category.value = '<?php echo $_POST['category']; ?>';<?php } ?>
  283. </script>
  284. <?php if ($_POST['category']=='1') { ?>
  285. <br><br><div style="float: left;"><span class="help-tip">Choose Icon:</span>&nbsp;&nbsp;
  286. <select name='posticon' style="height:20px;" class="icon-menu" onchange='posticonex.src = "new-hp/images/icons/" + this.value;'>
  287. <?php
  288. foreach (glob('new-hp/images/icons/news-*.gif') as $tempname) {
  289. $tempname = str_replace(dirname($tempname).'/','',$tempname);
  290. echo '<option value="'.$tempname.' "style="background-image: url(new-hp/images/icons/'.$tempname.');">'.str_replace('.gif','',str_replace('news-','',$tempname));
  291. }
  292. ?>
  293. </select>&nbsp;&nbsp;</div><div style="float: left;"><img name='posticonex' src=''></div>
  294. <script>
  295. <?php if ($_POST['viewlevel']!='') { ?> document.postForm.posticon.value = '<?php echo $_POST['posticon']; ?>';
  296. document.postForm.posticonex.src = "new-hp/images/icons/" + document.postForm.posticon.value;<?php } ?>
  297. </script>
  298. <?php } else if ($_POST['category']>='3') { ?>
  299. <span class="help-tip"><br><br>Starting Day:&nbsp;&nbsp;<input type=text value="" name="startdate" size=12 maxlength=10>&nbsp;&nbsp;(dd/mm/yyyy)<br><br>
  300. Ending Day:&nbsp;&nbsp;&nbsp;<input type=text value="" name="startdate" size=12 maxlength=10>&nbsp;&nbsp;(dd/mm/yyyy)</span>
  301. <?php } ?>
  302. </div>
  303. </div>
  304. </div>
  305. </div>
  306. </div>
  307. </div>
  308. </div>
  309. <?php }
  310. if ($userlvl>=$SETTING['USER_POLL']) {
  311. ?>
  312. <div class="options-container">
  313. <div style="position: absolute;"><img src="new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/poll.gif"></div>
  314. <div class="options-left">
  315. <div class="options-right" align=left>
  316. <?php
  317. $maxpolls=10;
  318. $sz=160;
  319. $_POST['newpost'] = explode('.',$_POST['newpost']);
  320. $remi = $_POST['newpost'][1];
  321. $_POST['newpost'] = $_POST['newpost'][0];
  322. $ap=0;
  323. if ($_POST['newpost']=='addpoll' AND count($_POST['polloption'])<$maxpolls) { $ap=1; }
  324. else if ($_POST['newpost']=='removepoll') { $ap=0; }
  325. @remove_array_item($_POST['polloption'], $remi);
  326. if (mysql_num_rows(mysql_query("SELECT poll_question FROM forum_topics WHERE id_topic='".$_REQUEST['t']."' AND poll_question!=''", $MySQL_CON))>0) { $showrempoll=true; $sz+=35; }
  327. ?>
  328. <div class="options-bot" style="height: <?php if (count($_POST['polloption'])!=0) { echo (count($_POST['polloption'])*35+35+$sz); } else { echo '230'; }?>px;">
  329. <div class="options-top">
  330. <div class="sig-options" style="width: 500;">
  331. <br><br>
  332. <span class="help-tip">
  333. <? if (mysql_num_rows(mysql_query("SELECT * FROM forum_rel_topics_polls ft LEFT JOIN (forum_rel_account_polls fa) ON fa.id_poll=ft.id_poll WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON))==0) { ?>
  334. Question:&nbsp;&nbsp;<input type="text" name="pollask" size=40 maxlength=45 value='<?php echo $_POST['pollask'];?>'><br><br>
  335. Option 1:&nbsp;&nbsp;<input type="text" name="polloption[]" size=30 maxlength=45 value='<?php echo $_POST['polloption'][0];?>'><br><br>
  336. Option 2:&nbsp;&nbsp;<input type="text" name="polloption[]" size=30 maxlength=45 value='<?php echo $_POST['polloption'][1];?>'><br><br>
  337. <?php
  338. for($m=2;$m<count($_POST['polloption'])+$ap;$m++) {
  339. echo 'Option '.($m+1); ?>:&nbsp;&nbsp;<input type="text" name="polloption[]" size=30 maxlength=45 value='<?php echo $_POST['polloption'][$m];?>'>&nbsp;&nbsp;<input onClick="javascript:document.postForm.newpost.value = 'removepoll.<?php echo $m; ?>';" type="submit" value='Remove Option'><br><br><?php
  340. }
  341. ?>
  342. <?php if (count($_POST['polloption'])+$ap<$maxpolls) { ?><input onClick="javascript:document.postForm.newpost.value='addpoll';" type="submit" value='Add New Option'><?php } ?><br><br>
  343. Run poll for&nbsp;&nbsp;<input type="text" name="pollfor" size=2 maxlength=3 value='<?php echo $_POST['pollfor'];?>'>&nbsp;&nbsp;days. (Enter 0 or leave blank for a never-ending poll) <br><br>
  344. <? if ($_REQUEST['topic']=='edit' AND $showrempoll==true) { ?>Remove Poll:&nbsp;&nbsp;<input class="button" name="removepoll" type="checkbox" value="1"><?php } ?>
  345. <? } else {
  346. echo 'Question: '.$_POST['pollask'].'<br><br>';
  347. for($i=0;$i<(count($_POST['polloption'])+$ap);$i++) {
  348. echo 'Option '.($i+1) . ': '. $_POST['polloption'][$i].'<br><br>';
  349. }
  350. if ($_POST['pollfor']==0) { echo 'Poll never ends.';}
  351. else { echo 'Run poll for '.$_POST['pollfor'].' days.'; }
  352. echo '<br><br><br>';
  353. echo 'Remove Poll:&nbsp;&nbsp;<input class="button" name="removepoll" type="checkbox" value="1">';
  354. }
  355. ?>
  356. </span>
  357. </div>
  358. </div>
  359. </div>
  360. </div>
  361. </div>
  362. </div>
  363. <!-- end options-container -->
  364. <?
  365. }
  366. ?>
  367. <div class="options-container">
  368. <div class="options-left">
  369. <div class="options-right">
  370. <div class="options-bot">
  371. <div class="options-top">
  372. <div class="sig-options" style="margin: 4px 30px auto;">
  373. <ul>
  374. <li class="check-box"><input class="button" type="checkbox" id="signed" name="issigned" value="1" checked="true" /></li>
  375. <li class="sig-desc"><label for='signed'>Include signature</label>&nbsp;&nbsp;</li>
  376. </ul>
  377. <img src="new-h/images/pixel.gif" width=0 height=4>
  378. <ul>
  379. <li class="check-box"><input class="button" type="checkbox" id="bbcode" name="isbbcode" value="1" checked="true" /></li>
  380. <li class="sig-desc"><label for='bbcode'>Enable BBCode</label></li>
  381. </ul>
  382. </div><!-- end sig-options-->
  383. <div class="post-button">
  384. <div class="post-button-left">
  385. <div class="post-button-right">
  386. <ul>
  387. <li><input type="image" class="button" src="new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/preview.gif" onClick="javascript: document.postForm.newpost.value = 'preview'"/></li>
  388. <li><input type="image" class="button" src="new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/post.gif" onClick="javascript: document.postForm.newpost.value = 'post'"/></li>
  389. </ul>
  390. </div><!-- end post-button-right -->
  391. </div><!-- end post-button-left -->
  392. </div><!-- end post-button-->
  393. </div>
  394. </div>
  395. </div>
  396. </div>
  397. </div>
  398. <!-- end options-container -->
  399. </div><!-- end post-top -->
  400. </blockquote>
  401. </div><!-- end insert -->
  402. </div><!-- end border -->
  403. </div><!-- end postdisplay -->
  404. </div><!-- end resultbox -->
  405. </div><!-- End div postshell -->
  406. </div><!-- end post-box-top -->
  407. </div><!-- end post-box-bottom -->
  408. </div><!-- end post-box -->
  409. </div><!-- end post -->
  410. </form>
  411. <div id="postbackground">
  412. <div class="right">
  413. <!-- Edit/Quoted/Reply Post -->
  414. </div></div>
  415. <div class="forum-index">
  416. <div class="findex">
  417. <a href="?n=forums"><img src="new-hp/images/<?php echo $_LANG['LANG']['SHORT_TAG']; ?>/forum/forum-index.gif" width="104" height="41" border="0" alt="forum-index" title="Forum Index" /></a>
  418. </div>
  419. </div>
  420. </div>
  421. <script>
  422. document.postForm.issigned.checked=<?php echo $_POST['issigned']; ?>;
  423. document.postForm.isbbcode.checked=<?php echo $_POST['isbbcode']; ?>;
  424. </script>
  425. <?
  426. }
  427. } else if ($_REQUEST['topic']=='remove') {
  428. $rowj=mysql_fetch_array(mysql_query("SELECT *, a.gmlevel as gmlvl
  429. FROM forum_posts fp
  430. LEFT JOIN (account a) ON a.id = fp.id_account
  431. WHERE id_topic='".$_REQUEST['t']."' AND isreply=0
  432. ORDER BY `id_post` ASC ", $MySQL_CON));
  433. $rowk=mysql_fetch_array(mysql_query("SELECT id_post FROM forum_posts WHERE id_topic='".$_REQUEST['t']."' ORDER BY `id_post` DESC LIMIT 0, 1", $MySQL_CON));
  434. if ($_SESSION['userid']==$rowj['id_account'] AND ($SETTING['USER_REMOVE_OWN_POSTS']=='1' OR ($SETTING['USER_REMOVE_OWN_POSTS']=='2' AND $rowk['id_account']==$_SESSION['userid'])) OR $userlvl>0) {
  435. if ($_REQUEST['g']=='true') {
  436. if (mysql_query("UPDATE forum_topics SET id_forum_moved = '0' WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON)) {
  437. echo '<br><br><br><br>';
  438. goodborder('Ghost Topic Removed Successfuly.<META HTTP-EQUIV="Refresh" CONTENT="1; URL=?n=forums&f='.$rowz['id_forum'].'">');
  439. echo '<br><br><br><br>';
  440. } else {
  441. echo '<br><br><br><br>';
  442. errborder('Couldn\'t Remove Ghost Topic.');
  443. echo '<br><br><br><br>';
  444. }
  445. $forceshow=false;
  446. } else if ($_SERVER['REQUEST_METHOD']=='POST') {
  447. $qrem1 = mysql_query("DELETE FROM forum_topics WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON);
  448. $qrem = mysql_query("DELETE FROM forum_views WHERE id_topic NOT IN (SELECT id_topic FROM forum_topics)", $MySQL_CON);
  449. if ($qrem1) { mysql_query("DELETE FROM forum_posts WHERE id_topic NOT IN (SELECT id_topic FROM forum_topics)", $MySQL_CON);
  450. echo '<br><br><br><br>';
  451. goodborder('Topic Removed Successfuly.<META HTTP-EQUIV="Refresh" CONTENT="1; URL=?n=forums&f='.$rowz['id_forum'].'">');
  452. echo '<br><br><br><br>';
  453. newrssfeed();
  454. } else {
  455. echo '<br><br><br><br>';
  456. errborder('Couldn\'t Remove Topic.');
  457. echo '<br><br><br><br>';
  458. }
  459. } else {
  460. $forceshow=true;
  461. }
  462. } else {
  463. echo '<br><br><br><br>';
  464. errborder('You are not allowed to Remove this Topic.');
  465. echo '<br><br><br><br>';
  466. $forceshow=false;
  467. }
  468. if ($forceshow==true) {
  469. ?>
  470. <br><br><br><br>
  471. <div align=center><form method=post action='?n=forums&t=<?php echo $_REQUEST['t']; ?>&topic=<?php echo $_REQUEST['topic']; ?>'><div align=center style="width: 200px; border: 2px solid orange; color: white;"><br>You sure you want to Remove this Topic aswell as All Posts?<br><br>
  472. <input onclick="window.location='<?php echo $_SERVER['HTTP_REFERER']; ?>'" type=button value="No" style="width: 90px; height: 30px;" >&nbsp;&nbsp;<input type=submit value="Yes" style="width: 90px; height: 30px;" >
  473. <br><br></div></form></div>
  474. <br><br><br><br>
  475. <?
  476. }
  477. } else if ($_REQUEST['topic']=='move') {
  478. $rowj=mysql_fetch_array(mysql_query("SELECT * FROM forum_posts fp WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON));
  479. if ($rowj['postlevel']<=$userlvl AND $userlvl>1) {
  480. if ($_SERVER['REQUEST_METHOD']=='POST' AND $_POST['moveto']!='') {
  481. if ($_POST['lghost']=='1') {
  482. @mysql_query("UPDATE forum_topics SET id_forum_moved=id_forum WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON);
  483. } else {
  484. @mysql_query("UPDATE forum_topics SET id_forum_moved='0' WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON);
  485. }
  486. if (mysql_query("UPDATE forum_topics SET id_forum='".$_POST['moveto']."' WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON)){
  487. echo '<br><br><br><br>';
  488. goodborder('Topic Moved Successfuly.<META HTTP-EQUIV="Refresh" CONTENT="1; URL=?n=forums&f='.$_POST['moveto'].'">');
  489. echo '<br><br><br><br>';
  490. } else {
  491. echo '<br><br><br><br>';
  492. errborder('Couldn\'t Move the Topic.');
  493. echo '<br><br><br><br>';
  494. }
  495. } else {
  496. $forceshow=true;
  497. }
  498. } else {
  499. echo '<br><br><br><br>';
  500. errborder('You are not allowed to Move this Topic.');
  501. echo '<br><br><br><br>';
  502. $forceshow=false;
  503. }
  504. if ($forceshow==true) {
  505. ?>
  506. <br><br><br><br>
  507. <div align=center><form method=post action='?n=forums&t=<?php echo $_REQUEST['t']; ?>&topic=<?php echo $_REQUEST['topic']; ?>'><div align=center style="width: 200px; border: 2px solid orange; color: white;"><br>Move this Topic to:<br><br>
  508. <select name="moveto" class="icon-menu" style="height: 20px;">
  509. <?php
  510. $rowq=mysql_query("SELECT image, id_forum, title FROM forums WHERE id_forum!='".$rowz['id_forum']."' AND postlevel <= '".$userlvl."'", $MySQL_CON);
  511. while ($rowb = mysql_fetch_array($rowq)) {
  512. echo '<option value="'.$rowb['id_forum'].'" style="background: url(new-hp/images/forum/forumbullets/'.$rowb['image'].') no-repeat; padding-left: 40px; padding-bottom: 26px;">'.$rowb['title'];
  513. }
  514. ?>
  515. </select><br><br>
  516. <input type=checkbox value='1' name="lghost" id="idlghost"><label for="idlghost">Leave Ghost?</label><br><br>
  517. <input onclick="window.location='<?php echo $_SERVER['HTTP_REFERER']; ?>'" type=button value="Cancel" style="width: 90px; height: 30px;" >&nbsp;&nbsp;<input type=submit value="Move" style="width: 90px; height: 30px;" >
  518. <br><br></div></form></div>
  519. <br><br><br><br>
  520. <?
  521. }
  522. } else {
  523. echo '<br><br><br><br>';
  524. errborder('Invalid Function!');
  525. echo '<br><br><br><br>';
  526. }
  527. } else {
  528. //0 - Viewed | 1 - Unviewed | 2 - New | 3 - Update
  529. $TOPIC_VIEW = array(
  530. 0 => 'square-grey.gif',
  531. 1 => 'square.gif',
  532. 2 => 'square-new.gif',
  533. 3 => 'square-update.gif'
  534. );
  535. function reorder($set) {
  536. if ($_REQUEST['z']=='desc') { echo 'asc'; } else { echo 'desc'; }
  537. }
  538. if ($_REQUEST['z']=='asc') { $_REQUEST['z']='desc'; } else { $_REQUEST['z']='asc'; }
  539. if ($_REQUEST['sort']=='') { $_REQUEST['sort']='lastreply'; }
  540. ?>
  541. <!--[if gt IE 6]>
  542. <div class="ie7margin"></div>
  543. <![endif]-->
  544. <table cellspacing="0" cellpadding="1" border="0" width="100%" class="board-clear">
  545. <tr>
  546. <td class="tableoutline">
  547. <table cellspacing="0"cellpadding="0" border="0" width="100%" class="tableoutline">
  548. <tr>
  549. <td align=center>
  550. <div class="theader">
  551. <div class="lpage">
  552. <span>
  553. <?php
  554. if ($_REQUEST['p']=='' OR alphanum($_REQUEST['p'],true,false)==false OR $_REQUEST['p']=='0') { $_REQUEST['p']=1; }
  555. $qquery = mysql_query("SELECT * FROM `forum_topics` ft WHERE ft.`viewlevel` <= '".$userlvl."' and (`id_forum`='".$_REQUEST['f']."' OR `id_forum_moved`='".$_REQUEST['f']."') ORDER BY issticked DESC, id_topic DESC", $MySQL_CON) or die (mysql_error());
  556. if (mysql_num_rows($qquery)>0) {
  557. ?>
  558. <table cellpadding = "0" cellspacing = "0" border = "0" >
  559. <tbody>
  560. <tr>
  561. <td>
  562. <?php
  563. $qqueryb = mysql_query("SELECT id_topic FROM `forum_topics` WHERE `viewlevel` <= '".$userlvl."' and `id_forum`='".$_REQUEST['f']."'", $MySQL_CON) or die (mysql_error());
  564. $pagination = pages($_REQUEST['p'], mysql_num_rows($qqueryb), $ttpage, '?n=forums&f='.$_REQUEST['f'], '&nbsp;.&nbsp;', $arrows=true);
  565. echo $pagination;
  566. ?>
  567. </td></tr></tbody></table>
  568. </span>
  569. </div>
  570. <div class="rpage" style ="width: 250px;">
  571. <ul>
  572. <li>
  573. <select class="gray" id="ordertopics" onchange="javascript: window.location.href='?n=forums&f=<? echo $_REQUEST['f']; ?>&sort=<?php echo $_REQUEST['sort']; ?>&z='+this.value">
  574. <option value="asc" >Ascending</option>
  575. <option value="desc" SELECTED>Descending</option>
  576. </select>
  577. </li>
  578. <li>
  579. <select class="gray" id="sorttopics" onchange="javascript: window.location.href='?n=forums&f=<? echo $_REQUEST['f']; ?>&sort='+this.value+'&z=<?php reorder($_REQUEST['z']); ?>'">
  580. <option value="lastreply" SELECTED>Latest Reply</option>
  581. <option value="created">Creation Date</option>
  582. <option value="views"># of Views</option>
  583. <option value="replies"># of Replies</option>
  584. <option value="subject">Subject</option>
  585. <option value="author">Author</option>
  586. </select>&nbsp;
  587. </li>
  588. <li style="margin: 3px 2px 0pt 3px;">
  589. <span><b>Sort by:&nbsp;</b></span>
  590. </li>
  591. </ul>
  592. </div>
  593. </div>
  594. <script>
  595. document.getElementById('ordertopics').value = "<? reorder($_REQUEST['z']); ?>";
  596. document.getElementById('sorttopics').value = "<? echo $_REQUEST['sort']; ?>";
  597. </script>
  598. <div id="postbackground">
  599. <div class="right">
  600. <table width="90%" border="0" cellpadding="0" cellspacing="0" class="tableoutline" style="margin: 0 auto;">
  601. <tr>
  602. <td class="tableheader" style="text-align: center; width:120px;"><img SRC="new-hp/images/forum/icons/flag.gif" border="0" width="18" height="13"alt="forum-flag" title="Flags" /></td>
  603. <td class="tableheader">
  604. <table cellspacing="0" cellpadding="0" border="0">
  605. <tr>
  606. <td><img SRC="new-hp/images/pixel.gif" border="0" width="1" height="22" alt="" /></td>
  607. <td style="padding: 0 0 0 5px;"><span>
  608. <a class="filter" HREF="?n=forums&f=<? echo $_REQUEST['f']; ?>&sort=subject&z=<? if ($_REQUEST['sort']=='subject') { echo $_REQUEST['z']; } else { reorder($_REQUEST['z']); } ?>">Subject<? if ($_REQUEST['sort']=='subject') { ?><img border=0 src="new-hp/images/forum/arrow-<? echo reorder($_REQUEST['z']); ?>.gif"><?php } ?></a></span></td>
  609. </tr>
  610. </table>
  611. </td>
  612. <td align="center" class="tableheader"><span>
  613. <a class="filter" HREF="?n=forums&f=<? echo $_REQUEST['f']; ?>&sort=author&z=<? if ($_REQUEST['sort']=='author') { echo $_REQUEST['z']; } else { reorder($_REQUEST['z']); } ?>">Author<? if ($_REQUEST['sort']=='author') { ?><img border=0 src="new-hp/images/forum/arrow-<? echo reorder($_REQUEST['z']); ?>.gif"><?php } ?></a><br /><img SRC="new-hp/images/pixel.gif" width="25" height="1" alt="" /></span></td>
  614. <td align="center" class="tableheader"><span>
  615. <a class="filter" HREF="?n=forums&f=<? echo $_REQUEST['f']; ?>&sort=replies&z=<? if ($_REQUEST['sort']=='replies') { echo $_REQUEST['z']; } else { reorder($_REQUEST['z']); } ?>">Replies<? if ($_REQUEST['sort']=='replies') { ?><img border=0 src="new-hp/images/forum/arrow-<? echo reorder($_REQUEST['z']); ?>.gif"><?php } ?></a><br /><img SRC="new-hp/images/pixel.gif" width="25" height="1" alt="" /></span></td>
  616. <td align="center" class="tableheader"><span>
  617. <a class="filter" HREF="?n=forums&f=<? echo $_REQUEST['f']; ?>&sort=views&z=<? if ($_REQUEST['sort']=='views') { echo $_REQUEST['z']; } else { reorder($_REQUEST['z']); } ?>">Views<? if ($_REQUEST['sort']=='views') { ?><img border=0 src="new-hp/images/forum/arrow-<? echo reorder($_REQUEST['z']); ?>.gif"><?php } ?></a><br /><img SRC="new-hp/images/pixel.gif" width="25" height="1" alt="" /></span></td>
  618. <td align="center" class="tableheader"><span>
  619. <a class="filter" HREF="?n=forums&f=<? echo $_REQUEST['f']; ?>&sort=lastreply&z=<? if ($_REQUEST['sort']=='lastreply') { echo $_REQUEST['z']; } else { reorder($_REQUEST['z']); } ?>">Last Post<? if ($_REQUEST['sort']=='lastreply') { ?><img border=0 src="new-hp/images/forum/arrow-<? echo reorder($_REQUEST['z']); ?>.gif"><?php } ?></a><br /><img SRC="new-hp/images/pixel.gif" width="25" height="1" alt="" /></span></td>
  620. <?php
  621. if ($userlvl>=$rowz['postlevel'] AND $userlvl>=1) { ?>
  622. <td align="center" class="tableheader"><span>
  623. <a class="filter">Manage</a><br /><img SRC="new-hp/images/pixel.gif" width="25" height="1" alt="" /></span></td>
  624. <?php } ?>
  625. </tr>
  626. <?php
  627. while ($rowc = mysql_fetch_array($qquery)) {
  628. $author = mysql_query("SELECT fp.id_post, fp.id_account, fp.`date`, fp.`hour`, a.gmlevel as gmlvl, fa.displayname as dn FROM `forum_posts` fp
  629. LEFT JOIN `forum_accounts` fa ON (fa.id_account = fp.id_account)
  630. LEFT JOIN `account` a ON (fa.id_account = a.id)
  631. WHERE fp.id_topic='".$rowc['id_topic']."'
  632. ORDER BY fp.id_post ASC LIMIT 0, 1", $MySQL_CON) or die (mysql_error());
  633. $rowauthor = mysql_fetch_array($author);
  634. $rowtotalrows = mysql_query("SELECT id_post FROM forum_posts WHERE id_topic='".$rowc['id_topic']."'", $MySQL_CON) or die (mysql_error());
  635. $blizzreply = mysql_query("SELECT id_post FROM `forum_posts` fp
  636. LEFT JOIN (`account` a) ON fp.id_account = a.id
  637. WHERE fp.id_topic='".$rowc['id_topic']."' AND a.gmlevel > 0
  638. ORDER BY fp.id_post ASC LIMIT 0, 1", $MySQL_CON) or die (mysql_error());
  639. $lastreply = mysql_query("SELECT id_post, DATE_FORMAT(CONVERT_TZ(CONCAT(`date`, ' ', `hour`), '".$GMT[$SETTING['WEB_GMT']][0]."', '".$usergmt."'), '%h:%i %p') as houri,
  640. TIMESTAMPDIFF(MINUTE, CONCAT(`date`, ' ', `hour`), NOW()) as datei,
  641. DATE_FORMAT(CONVERT_TZ(CONCAT(`date`, ' ', `hour`), '".$GMT[$SETTING['WEB_GMT']][0]."', '".$usergmt."'), '%Y-%m-%d') as `date`,
  642. fa.displayname as dn FROM `forum_posts` fp
  643. LEFT JOIN (`forum_accounts` fa) ON fa.id_account = fp.id_account
  644. WHERE fp.id_topic='".$rowc['id_topic']."'
  645. ORDER BY fp.id_post DESC LIMIT 0, 1", $MySQL_CON) or die (mysql_error());
  646. $rowlastreply = mysql_fetch_array($lastreply);
  647. if (isset($_SESSION['userid'])) {
  648. $topicviewed = mysql_query("SELECT `time` FROM forum_views WHERE id_topic='".$rowc['id_topic']."' AND id_account='".$_SESSION['userid']."'", $MySQL_CON) or die (mysql_error());
  649. if (mysql_num_rows($topicviewed)==1) {
  650. $updatelink = mysql_fetch_array($topicviewed);
  651. $topicviewed = mysql_query("SELECT id_post FROM forum_posts
  652. WHERE id_topic='".$rowc['id_topic']."' AND isreply=1 AND TIMESTAMPDIFF(SECOND, '".$updatelink['time']."', CONCAT(`date`, ' ', `hour`))>0 ORDER BY `date`, `hour`, `id_post`", $MySQL_CON) or die (mysql_error());
  653. if (mysql_num_rows($topicviewed)>0) {
  654. $updatelink = ceil(((mysql_num_rows($rowtotalrows) - mysql_num_rows($topicviewed)) / $tppage));
  655. $row = mysql_fetch_array($topicviewed);
  656. $updatelink='#'.$row['id_post'];
  657. $rowtopicviewed = 3;
  658. } else {
  659. $rowtopicviewed = 0;
  660. }
  661. } else {
  662. $topicviewed = mysql_query("SELECT a.id FROM account a, forum_posts fp
  663. WHERE a.id='".$_SESSION['userid']."' AND fp.id_post='".$rowauthor['id_post']."' AND
  664. TIMESTAMPDIFF(SECOND, a.`joindate`, '".$rowauthor['date']." ".$rowauthor['hour']."')>0", $MySQL_CON) or die (mysql_error());
  665. if (mysql_num_rows($topicviewed)==1) {
  666. $rowtopicviewed = 2;
  667. } else {
  668. $rowtopicviewed = 1;
  669. }
  670. }
  671. } else {
  672. $rowtopicviewed = 1;
  673. }
  674. if (mysql_num_rows($blizzreply)>0) {
  675. $rowblizzreply = mysql_fetch_array($blizzreply);
  676. $blizzreplyloc = mysql_query("SELECT id_post FROM `forum_posts` fp
  677. WHERE fp.id_post<='".$rowblizzreply['id_post']."' AND fp.id_topic='".$rowc['id_topic']."'
  678. ORDER BY `date` ASC, `hour` ASC", $MySQL_CON) or die (mysql_error());
  679. $totalpages=mysql_num_rows($blizzreplyloc)/$tppage;
  680. $totalpages=explode(".", $totalpages);
  681. if ($totalpages[1]!=0) { $totalpages[0]+=1; }
  682. $blizzreply = '<a HREF="?n=forums&t='.$rowc['id_topic'].'&p='.$totalpages[0].'#'.$rowblizzreply['id_post'].'"><img SRC="new-hp/images/forum/icons/blizz.gif" border="0" title="Blizzard Response" alt="blizz-response" /></a>';
  683. } else {
  684. $blizzreply = '<img SRC="new-hp/images/pixel.gif" width="22" height="15" border="0" alt="" />';
  685. }
  686. if ($rowz['postlevel']>$rowc['postlevel']) { $rowc['postlevel']=$rowz['postlevel']; }
  687. $ROWF['userview'][] = $rowtopicviewed; //2
  688. $ROWF['lastreply'][] = strtolower('In '. $rowlastreply['date'].' at '. $rowlastreply['houri'] . ' by <b>'.$rowlastreply['dn'].'</b>');
  689. $ROWF['created'][] = $rowc['date'].' '.$rowc['hour']; //4
  690. $ROWF['subject'][] = strtolower($rowc['title']);
  691. $ROWF['author'][] = strtolower($rowauthor['dn']);
  692. $ROWF['trows'][] = mysql_num_rows($rowtotalrows);
  693. $ROWF['replies'][] = ($ROWF['trows'][count($ROWF['trows'])-1] - 1);
  694. $ROWF['views'][] = ($rowc['views'] + mysql_num_rows(mysql_query("SELECT id_topic FROM forum_views WHERE id_topic='".$rowc['id_topic']."'", $MySQL_CON)));
  695. $ROWF['blocked'][] = $rowc['postlevel'];
  696. $ROWF['poll'][] = $rowc['poll_question'];
  697. $ROWF['blizzreply'][] = $blizzreply;
  698. $ROWF['moved'][] = $rowc['id_forum_moved'];
  699. $ROWF['updated'][] = $updatelink[0];
  700. $ROWF['idtopic'][] = $rowc['id_topic'];
  701. $ROWF['postlevel'][] = $rowc['postlevel'];
  702. //Bypass Case Sensivity!
  703. $ROWF['lastreplyH'][] = 'In '. $rowlastreply['date'].' at '. $rowlastreply['houri']. ' by <b>'.$rowlastreply['dn'].'</b>';
  704. $ROWF['subjectH'][] = $rowc['title'];
  705. $ROWF['authorH'][] = $rowauthor['dn']. '|' . $rowauthor['gmlvl'];
  706. //start counting from here
  707. $ROWF['sticked'][] = $rowc['issticked'];
  708. }
  709. if ($_REQUEST['z']=='desc') { $_REQUEST['z']='asc'; } else { $_REQUEST['z']='desc'; }
  710. foreach ($ROWF as $key=>$value) {
  711. if ($key==$_REQUEST['sort']) {
  712. $scode = "\$ROWF['".$key."'], SORT_".strtoupper($_REQUEST['z']).", SORT_STRING, " . $scode;
  713. } else {
  714. if ($key=='sticked') {
  715. $scode = "\$ROWF['".$key."'], SORT_DESC, SORT_STRING, " . $scode;
  716. } else {
  717. if ($key=='userview') { $scode .= "\$ROWF['".$key."'], SORT_DESC, SORT_STRING, "; }
  718. $scode .= "\$ROWF['".$key."'], ";
  719. }
  720. }
  721. }
  722. eval(str_replace(', )',')',"array_multisort(".$scode.");"));
  723. $i='a';
  724. $k=(($_REQUEST['p']-1)*$ttpage);
  725. while ($k<((($_REQUEST['p']-1)*$ttpage)+$ttpage) AND $k<count($ROWF['idtopic'])) {
  726. $gmlevel=explode('|', $ROWF['authorH'][$k]);$ROWF['authorH'][$k]=$gmlevel[0];$gmlevel=$gmlevel[1];
  727. echo '<tr class="rows">
  728. <td class="n'.$i.'1" style="width:120px;">';
  729. if ($ROWF['sticked'][$k]=='1') { echo '<img SRC="new-hp/images/forum/icons/sticky.gif" border="0" width="22" height="15" title="Sticky thread" />'; }
  730. else { echo '<img SRC="new-hp/images/pixel.gif" width="22" height="15" border="0" alt="" />'; }
  731. echo '&nbsp;';
  732. if (($ROWF['blocked'][$k]>0 AND $userlvl<0) OR ($ROWF['blocked'][$k]>$userlvl AND $userlvl>=0)) { echo '<img SRC="new-hp/images/forum/icons/lock-icon.gif" width="15" height="16" border="0" title="Locked thread" alt="locked" />'; }
  733. else { echo '<img SRC="new-hp/images/pixel.gif" width="15" height="16" border="0" alt="" />'; }
  734. echo '&nbsp;';
  735. if ($ROWF['poll'][$k]!='') { echo '<img SRC="new-hp/images/forum/icons/poll.gif" border="0" title="Poll Thread" alt="Poll Thread" />'; }
  736. else { echo '<img SRC="new-hp/images/pixel.gif" width="20" height="17" border="0" alt="" />'; }
  737. echo '&nbsp;';
  738. echo $ROWF['blizzreply'][$k];
  739. echo '&nbsp;';
  740. if ($ROWF['moved'][$k]!='0') { echo '<img SRC="new-hp/images/forum/icons/arrow.gif" border="0" title="Thread Moved" alt="Moved" />'; }
  741. else { echo '<img SRC="new-hp/images/pixel.gif" width="17" height="11" border="0" alt="" />'; }
  742. echo '</td>
  743. <td class="t'.$i.'2">';
  744. if ($ROWF['userview'][$k]==3) {
  745. echo '<a HREF="?n=forums&t='.$ROWF['idtopic'][$k].'&p='.$ROWF['updated'][$k].'"><img SRC="new-hp/images/forum/'.$TOPIC_VIEW[$ROWF['userview'][$k]].'" width="15" height="15" style="vertical-align:middle;" border="0" alt="square" /></a>';
  746. } else {
  747. echo '<a HREF="?n=forums&t='.$ROWF['idtopic'][$k].'"><img SRC="new-hp/images/forum/'.$TOPIC_VIEW[$ROWF['userview'][$k]].'" width="15" height="15" style="vertical-align:middle;" border="0" alt="square" /></a>';
  748. }
  749. if ($_REQUEST['hl']!='') { $ROWF['subjectH'][$k] = preg_replace('/'.$_REQUEST['hl'].'/is','<span class="highlight">'.$_REQUEST['hl'].'</span>',$ROWF['subjectH'][$k]); }
  750. echo '<a HREF="?n=forums&t='.$ROWF['idtopic'][$k].'" class="active">'.$ROWF['subjectH'][$k].'</a>';
  751. if (($ROWF['trows'][$k]/$tppage)>1) { echo ' <small>[Page: '.pages(0, $ROWF['trows'][$k], $tppage, '?n=forums&t='.$ROWF['idtopic'][$k], '&nbsp;.&nbsp;', false, 5, false).']</small>'; }
  752. echo'</td>
  753. <td class="t'.$i.'3" style="white-space:nowrap">';
  754. if ($gmlevel>0) {
  755. echo '<span title="Blizzard Rep">
  756. <span class=" blue">'.$ROWF['authorH'][$k].'</span>
  757. <img SRC="new-hp/images/forum/icons/blizz.gif" border="0" alt="Blizzard Rep" />
  758. </span>';
  759. } else {
  760. echo $ROWF['authorH'][$k];
  761. }
  762. echo '</td>';
  763. echo '<td class="t'.$i.'4">'.$ROWF['replies'][$k].'</td>
  764. <td class="t'.$i.'5">'.$ROWF['views'][$k].'</td>
  765. <td class="t'.$i.'6" style="white-space: nowrap">'.$ROWF['lastreplyH'][$k].'</td>';
  766. if ($userlvl >= $ROWF['postlevel'][$k] AND $userlvl>=$rowz['postlevel'] AND $userlvl>=1) {
  767. if ($ROWF['moved'][$k]>'0' AND $ROWF['moved'][$k]==$rowz['id_forum']) {
  768. echo'<td class="t'.$i.'1" style="white-space: nowrap; width: 0px;"><a href="?n=forums&t='.$ROWF['idtopic'][$k].'&topic=remove&g=true"><img onmouseover="ddrivetip(\'Remove Ghost\',\'#ffffff\')"; onmouseout="hideddrivetip()" border=0 src="new-hp/images/v2/remove.gif">
  769. </a></td>';
  770. } else {
  771. echo'<td class="t'.$i.'1" style="white-space: nowrap; width: 0px;">
  772. <a href="?n=forums&t='.$ROWF['idtopic'][$k].'&topic=move"><img onmouseover="ddrivetip(\'Move\',\'#ffffff\')"; onmouseout="hideddrivetip()" border=0 src="new-hp/images/forum/icons/arrow.gif"></a>
  773. <a href="?n=forums&t='.$ROWF['idtopic'][$k].'&topic=edit"><img onmouseover="ddrivetip(\'Edit\',\'#ffffff\')"; onmouseout="hideddrivetip()" border=0 src="new-hp/images/v2/edit.gif"></a>
  774. &nbsp;<a href="?n=forums&t='.$ROWF['idtopic'][$k].'&topic=remove"><img onmouseover="ddrivetip(\'Remove\',\'#ffffff\')"; onmouseout="hideddrivetip()" border=0 src="new-hp/images/v2/remove.gif">
  775. </a></td>';
  776. }
  777. }
  778. else if ($userlvl>=1) { echo '<td class="t'.$i.'1" style="white-space: nowrap; width: 0px;">&nbsp;</td>'; }
  779. echo '</tr>';
  780. if ($i=='a') { $i=''; } else { $i='a'; }
  781. $k++;
  782. }
  783. } else {
  784. echo '<tr><td><br>';
  785. echo '<div align=center style="color: white;">Forum do not contains any topics or you not allowed to see them.</div>';
  786. echo '<br><td></tr>';
  787. }
  788. ?>
  789. </table>
  790. </div>
  791. </div>
  792. <div class="theader">
  793. <div class="lpage">
  794. <table cellpadding = "0" cellspacing = "0" border = "0">
  795. <tbody><tr>
  796. <td>
  797. <?php
  798. echo $pagination;
  799. ?>
  800. </td></tr></tbody></table>
  801. </div>
  802. </div>
  803. <div class="tbottom"></div>
  804. <div style="position: relative; width: 100%;">
  805. <div style="position: absolute; right: 20px; top: -38px;">
  806. <span><small class="nav">Forum Nav :</small></span>
  807. <small>
  808. <select id="selectNavfooter" onchange="javascript:window.location='?n=forums&f=' + this.value" style="display:inline; width: 185px; margin-left: 10px;">
  809. <?php echo $allf; ?>
  810. </select>
  811. </small>
  812. <a href="#" onclick="javascript:window.location='?n=forums&f=' + selectNavfooter.value" class="index"><img SRC="new-hp/images/forum/jump-button.gif" alt="Jump To This Forum" width="21" height="19" border="0" style="margin-bottom: 3px;" align="top" title="Jump To This Forum"/></a>
  813. </div>
  814. </div>
  815. </td>
  816. </tr>
  817. </table>
  818. </td>
  819. </tr>
  820. </table>
  821. <?
  822. iconlegend();
  823. }
  824. ?>