PageRenderTime 73ms CodeModel.GetById 21ms RepoModel.GetById 1ms app.codeStats 0ms

/inc/classes/board-post.class.php

https://github.com/Laurelai/tsukiboards
PHP | 979 lines | 692 code | 106 blank | 181 comment | 267 complexity | eae7147bc21910839f24a5c650a29e4d MD5 | raw file
Possible License(s): GPL-2.0, LGPL-2.1 
    

  1. <?php

    2. 

  2. /*

    3. 

  3.  * This file is part of kusaba.

    4. 

  4.  *

    5. 

  5.  * kusaba is free software; you can redistribute it and/or modify it under the

    6. 

  6.  * terms of the GNU General Public License as published by the Free Software

    7. 

  7.  * Foundation; either version 2 of the License, or (at your option) any later

    8. 

  8.  * version.

    9. 

  9.  *

    10. 

  10.  * kusaba is distributed in the hope that it will be useful, but WITHOUT ANY

    11. 

  11.  * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR

    12. 

  12.  * A PARTICULAR PURPOSE. See the GNU General Public License for more details.

    13. 

  13.  *

    14. 

  14.  * You should have received a copy of the GNU General Public License along with

    15. 

  15.  * kusaba; if not, write to the Free Software Foundation, Inc.,

    16. 

  16.  * 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA

    17. 

  17.  */

    18. 

  18. /**

    19. 

  19.  * Board and Post classes

    20. 

  20.  *

    21. 

  21.  * @package kusaba

    22. 

  22.  */

    23. 

  23. /**

    24. 

  24.  * Board class

    25. 

  25.  *

    26. 

  26.  * Contains all board configurations.  This class handles all board page

    27. 

  27.  * rendering, using the templates

    28. 

  28.  *

    29. 

  29.  * @package kusaba

    30. 

  30.  *

    31. 

  31.  * TODO: replace repetitive code blocks with functions.

    32. 

  32.  */

    33. 

  33. class Board {

    34. 

  34. 	/* Declare the public variables */

    35. 

  35. 	/**

    36. 

  36. 	 * Array to hold the boards settings

    37. 

  37. 	 */

    38. 

  38. 	var $board = array();

    39. 

  39. 	/**

    40. 

  40. 	 * Archive directory, set when archiving is enabled

    41. 

  41. 	 *

    42. 

  42. 	 * @var string Archive directory

    43. 

  43. 	 */

    44. 

  44. 	var $archive_dir;

    45. 

  45. 	/**

    46. 

  46. 	 * Dwoo class

    47. 

  47. 	 *

    48. 

  48. 	 * @var class Dwoo

    49. 

  49. 	 */

    50. 

  50. 	var $dwoo;

    51. 

  51. 	/**

    52. 

  52. 	 * Dwoo data class

    53. 

  53. 	 *

    54. 

  54. 	 * @var class Dwoo

    55. 

  55. 	 */

    56. 

  56. 	var $dwoo_data;

    57. 

  57. 	/**

    58. 

  58. 	 * Load balancer class

    59. 

  59. 	 *

    60. 

  60. 	 * @var class Load balancer

    61. 

  61. 	 */

    62. 

  62. 	var $loadbalancer;

    63. 

  63. 

    64. 

  64. 	/**

    65. 

  65. 	 * Initialization function for the Board class, which is called when a new

    66. 

  66. 	 * instance of this class is created. Takes a board directory as an

    67. 

  67. 	 * argument

    68. 

  68. 	 *

    69. 

  69. 	 * @param string $board Board name/directory

    70. 

  70. 	 * @param boolean $extra grab additional data for page generation purposes. Only false if all that's needed is the board info.

    71. 

  71. 	 * @return class

    72. 

  72. 	 */

    73. 

  73. 	function Board($board, $extra = true) {

    74. 

  74. 		global $tc_db, $CURRENTLOCALE;

    75. 

  75. 

    76. 

  76. 		// If the instance was created with the board argument present, get all of the board info and configuration values and save it inside of the class

    77. 

  77. 		if ($board!='') {

    78. 

  78. 			$query = "SELECT * FROM `".KU_DBPREFIX."boards` WHERE `name` = ".$tc_db->qstr($board)." LIMIT 1";

    79. 

  79. 			$results = $tc_db->GetAll($query);

    80. 

  80. 			foreach ($results[0] as $key=>$line) {

    81. 

  81. 				if (!is_numeric($key)) {

    82. 

  82. 					$this->board[$key] = $line;

    83. 

  83. 				}

    84. 

  84. 			}

    85. 

  85. 			// Type

    86. 

  86. 			$types = array('img', 'txt', 'oek', 'upl');

    87. 

  87. 			$this->board['text_readable'] = $types[$this->board['type']];

    88. 

  88. 			if ($extra) {

    89. 

  89. 				// Boardlist

    90. 

  90. 				$this->board['boardlist'] = $this->DisplayBoardList();

    91. 

  91. 

    92. 

  92. 				// Get the unique posts for this board

    93. 

  93. 				$this->board['uniqueposts']   = $tc_db->GetOne("SELECT COUNT(DISTINCT `ipmd5`) FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id']. " AND  `IS_DELETED` = 0");

    94. 

  94. 			

    95. 

  95. 				if($this->board['type'] != 1) {

    96. 

  96. 					$this->board['filetypes_allowed'] = $tc_db->GetAll("SELECT ".KU_DBPREFIX."filetypes.filetype FROM ".KU_DBPREFIX."boards, ".KU_DBPREFIX."filetypes, ".KU_DBPREFIX."board_filetypes WHERE ".KU_DBPREFIX."boards.id = " . $this->board['id'] . " AND ".KU_DBPREFIX."board_filetypes.boardid = " . $this->board['id'] . " AND ".KU_DBPREFIX."board_filetypes.typeid = ".KU_DBPREFIX."filetypes.id ORDER BY ".KU_DBPREFIX."filetypes.filetype ASC;");

    97. 

  97. 				}

    98. 

  98. 				

    99. 

  99. 				if ($this->board['locale'] && $this->board['locale'] != KU_LOCALE) {

    100. 

  100. 					changeLocale($this->board['locale']);

    101. 

  101. 				}

    102. 

  102. 			}

    103. 

  103. 			$this->board['loadbalanceurl_formatted'] = ($this->board['loadbalanceurl'] != '') ? substr($this->board['loadbalanceurl'], 0, strrpos($this->board['loadbalanceurl'], '/')) : '';

    104. 

  104. 

    105. 

  105. 			if ($this->board['loadbalanceurl'] != '' && $this->board['loadbalancepassword'] != '') {

    106. 

  106. 				require_once KU_ROOTDIR . 'inc/classes/loadbalancer.class.php';

    107. 

  107. 				$this->loadbalancer = new Load_Balancer;

    108. 

  108. 

    109. 

  109. 				$this->loadbalancer->url = $this->board['loadbalanceurl'];

    110. 

  110. 				$this->loadbalancer->password = $this->board['loadbalancepassword'];

    111. 

  111. 			}

    112. 

  112. 		}

    113. 

  113. 	}

    114. 

  114. 

    115. 

  115. 	function __destruct() {

    116. 

  116. 		changeLocale(KU_LOCALE);

    117. 

  117. 	}

    118. 

  118. 	

    119. 

  119. 	/**

    120. 

  120. 	 * Regenerate all board and thread pages

    121. 

  121. 	 */

    122. 

  122. 	function RegenerateAll() {

    123. 

  123. 		$this->RegeneratePages();

    124. 

  124. 		$this->RegenerateThreads();

    125. 

  125. 	}

    126. 

  126. 

    127. 

  127. 	/**

    128. 

  128. 	 * Regenerate all pages

    129. 

  129. 	 */

    130. 

  130. 	function RegeneratePages() {

    131. 

  131. 		global $tc_db, $CURRENTLOCALE;

    132. 

  132. 		

    133. 

  133. 		$this->InitializeDwoo();

    134. 

  134. 		$results = $tc_db->GetAll("SELECT `filetype` FROM `" . KU_DBPREFIX . "embeds`");

    135. 

  135. 		foreach ($results as $line) {

    136. 

  136. 			$this->board['filetypes'][] .= $line[0];

    137. 

  137. 		}

    138. 

  138. 		$this->dwoo_data->assign('filetypes', $this->board['filetypes']);

    139. 

  139. 		$maxpages = $this->board['maxpages'];

    140. 

  140. 		$numposts = $tc_db->GetAll("SELECT COUNT(*) FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id'] . " AND `parentid` = 0 AND `IS_DELETED` = 0");

    141. 

  141. 

    142. 

  142. 		if ($this->board['type'] == 1) {

    143. 

  143. 			$postsperpage = KU_THREADSTXT;

    144. 

  144. 		} elseif ($this->board['type'] == 3) {

    145. 

  145. 			$postsperpage = 30;

    146. 

  146. 		} else {

    147. 

  147. 			$postsperpage = KU_THREADS;

    148. 

  148. 		}

    149. 

  149. 		$i = 0;

    150. 

  150. 		$liststooutput = 0;

    151. 

  151. 		$totalpages = calculatenumpages($this->board['type'], ($numposts[0][0]-1));

    152. 

  152. 		if ($totalpages == '-1') {

    153. 

  153. 			$totalpages = 0;

    154. 

  154. 		}

    155. 

  155. 		$this->dwoo_data->assign('numpages', $totalpages);

    156. 

  156. 		while ($i <= $totalpages) {

    157. 

  157. 			$newposts = Array();

    158. 

  158. 			$this->dwoo_data->assign('thispage', $i);

    159. 

  159. 			$threads = $tc_db->GetAll("SELECT * FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id'] . " AND `parentid` = 0 AND `IS_DELETED` = 0 ORDER BY `stickied` DESC, `bumped` DESC LIMIT ". ($postsperpage)." OFFSET ". $postsperpage * $i);

    160. 

  160. 

    161. 

  161. 			$executiontime_start_page = microtime_float();

    162. 

  162. 			foreach ($threads as $k=>$thread) {

    163. 

  163. 				// If the thread is on the page set to mark, && hasn't been marked yet, mark it

    164. 

  164. 				if ($thread['deleted_timestamp'] == 0 && $this->board['markpage'] > 0 && $i >= $this->board['markpage']) {

    165. 

  165. 					$tc_db->Execute("UPDATE `".KU_DBPREFIX."posts` SET `deleted_timestamp` = '" . (time() + 7200) . "' WHERE `boardid` = " . $tc_db->qstr($this->board['id'])." AND `id` = '" . $thread['id'] . "'");

    166. 

  166. 					clearPostCache($thread['id'], $this->board['name']);

    167. 

  167. 					$this->RegenerateThreads($thread['id']);

    168. 

  168. 					$this->dwoo_data->assign('replythread', 0);

    169. 

  169. 				}

    170. 

  170. 				$thread = $this->BuildPost($thread, true);

    171. 

  171. 				

    172. 

  172. 				if ($this->board['type'] != 3) {

    173. 

  173. 					$omitids = '';

    174. 

  174. 					$posts = $tc_db->GetAll("SELECT * FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id']." AND `parentid` = ".$thread['id']." " . (($this->board['type'] != 1) ? ("AND `IS_DELETED` = 0") : ("")) . " ORDER BY `id` DESC LIMIT ".(($thread['stickied'] == 1) ? (KU_REPLIESSTICKY) : (KU_REPLIES)));

    175. 

  175. 					foreach ($posts as $key=>$post) {

    176. 

  176. 						$omitids .= $post['id'].",";

    177. 

  177. 						$posts[$key] = $this->BuildPost($post, true);

    178. 

  178. 					}

    179. 

  179. 

    180. 

  180. 					$posts = array_reverse($posts);

    181. 

  181. 					$omitids = substr($omitids, 0, -1);

    182. 

  182. 					array_unshift($posts, $thread);

    183. 

  183. 					$newposts[] = $posts;

    184. 

  184. 				} else {

    185. 

  185. 					if (!$thread['tag']) $thread['tag'] = '*';

    186. 

  186. 					$newposts[] = $thread;

    187. 

  187. 				}

    188. 

  188. 				$replycount = Array();

    189. 

  189. 				if ($this->board['type'] == 1 || $this->board['type'] == 3 ) {

    190. 

  190. 					$replycount = $tc_db->GetAll("SELECT COUNT(`id`) FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $tc_db->qstr($this->board['id'])." AND `parentid` = " . $thread['id']);

    191. 

  191. 				} else {

    192. 

  192. 					$replycount = $tc_db->GetAll("SELECT COUNT(`id`) AS replies, SUM(CASE WHEN `file_md5` = '' THEN 0 ELSE 1 END) AS files FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id']."  AND `parentid` = ".$thread['id']." AND `is_deleted` = 0 AND `id` NOT IN (" . $omitids . ")");

    193. 

  193. 				}

    194. 

  194. 				// Workaround for upload boards

    195. 

  195. 				if ($this->board['type'] == 3) {

    196. 

  196. 					$newposts[$k]['replies'] = $replycount[0][0];

    197. 

  197. 				} else {

    198. 

  198. 					$newposts[$k][0]['replies'] = $replycount[0][0];

    199. 

  199. 					$newposts[$k][0]['images'] = (isset($replycount[0][1]) ? $replycount[0][1] : '');

    200. 

  200. 				}

    201. 

  201. 			}

    202. 

  202. 			if ($this->board['type'] == 0 && !isset($embeds)) {

    203. 

  203. 				$embeds = $tc_db->GetAll("SELECT * FROM `" . KU_DBPREFIX . "embeds`");

    204. 

  204. 				$this->dwoo_data->assign('embeds', $embeds);

    205. 

  205. 			}

    206. 

  206. 			if (!isset($header)){

    207. 

  207. 				$header = $this->PageHeader();

    208. 

  208. 				$header = str_replace("<!sm_threadid>", 0, $header);

    209. 

  209. 			}

    210. 

  210. 			if (!isset($postbox)) {

    211. 

  211. 				$postbox = $this->Postbox();

    212. 

  212. 				$postbox = str_replace("<!sm_threadid>", 0, $postbox);

    213. 

  213. 			}

    214. 

  214. 			$this->dwoo_data->assign('posts', $newposts);

    215. 

  215. 			$this->dwoo_data->assign('file_path', getCLBoardPath($this->board['name'], $this->board['loadbalanceurl_formatted'], ''));

    216. 

  216. 

    217. 

  217. 			$content = $this->dwoo->get(KU_TEMPLATEDIR . '/' . $this->board['text_readable'] . '_board_page.tpl', $this->dwoo_data);

    218. 

  218. 			$footer = $this->Footer(false, (microtime_float() - $executiontime_start_page), (($this->board['type'] == 1) ? (true) : (false)));

    219. 

  219. 			$content = $header.$postbox.$content.$footer;

    220. 

  220. 

    221. 

  221. 			$content = str_replace("\t", '',$content);

    222. 

  222. 			$content = str_replace("&nbsp;\r\n", '&nbsp;',$content);

    223. 

  223. 

    224. 

  224. 			if ($i == 0) {

    225. 

  225. 				$page = KU_BOARDSDIR.$this->board['name'].'/'.KU_FIRSTPAGE;

    226. 

  226. 				$this->PrintPage($page, $content, $this->board['name']);

    227. 

  227. 			} else {

    228. 

  228. 				$page = KU_BOARDSDIR.$this->board['name'].'/'.$i.'.html';

    229. 

  229. 				$this->PrintPage($page, $content, $this->board['name']);

    230. 

  230. 			}

    231. 

  231. 			$i++;

    232. 

  232. 		}

    233. 

  233. 		// If text board, rebuild thread list html files 

    234. 

  234. 		if ($this->board['type'] == 1) {

    235. 

  235. 			$numpostsleft = $tc_db->GetOne("SELECT COUNT(*) FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id'] . " AND `IS_DELETED` = 0 AND `parentid` = 0");

    236. 

  236. 			$liststooutput = floor(($numpostsleft-1) / 40);

    237. 

  237. 			$this->dwoo_data->assign('numpages', $liststooutput+1);

    238. 

  238. 			$listpage = 0;

    239. 

  239. 			$currentpostwave = 0;

    240. 

  240. 			while ($numpostsleft>0) {

    241. 

  241. 				$this->dwoo_data->assign('thispage', $listpage+1);

    242. 

  242. 				$executiontime_start_list = microtime_float();

    243. 

  243. 				$page = $this->PageHeader(0, $currentpostwave, $liststooutput);

    244. 

  244. 				$this->Footer(false, (microtime_float()-$executiontime_start_list), true);

    245. 

  245. 				if ($listpage==0) {

    246. 

  246. 					$this->PrintPage(KU_BOARDSDIR.$this->board['name'].'/list.html', $page, $this->board['name']);

    247. 

  247. 				} else {

    248. 

  248. 					$this->PrintPage(KU_BOARDSDIR.$this->board['name'].'/list'.($listpage+1).'.html', $page, $this->board['name']);

    249. 

  249. 				}

    250. 

  250. 				$currentpostwave += 40;

    251. 

  251. 				$numpostsleft -= 40;

    252. 

  252. 				$listpage++;

    253. 

  253. 			}

    254. 

  254. 		}

    255. 

  255. 		// If the board has catalog mode enabled, build it 

    256. 

  256. 		if ($this->board['enablecatalog'] == 1 && ($this->board['type'] == 0 || $this->board['type'] == 2)) {

    257. 

  257. 			$executiontime_start_catalog = microtime_float();

    258. 

  258. 			$catalog_head = $this->PageHeader().

    259. 

  259. 			'&#91;<a href="' . KU_BOARDSFOLDER . $this->board['name'] . '/">'._gettext('Return').'</a>&#93; <div class="catalogmode">'._gettext('Catalog Mode').'</div>' . "\n" .

    260. 

  260. 			'<table border="1" align="center">' . "\n" . '<tr>' . "\n";

    261. 

  261. 			$catalog_page = '';

    262. 

  262. 			$results = $tc_db->GetAll("SELECT `id` , `subject` , `file` , `file_type` FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id'] . " AND `IS_DELETED` = 0 AND `parentid` = 0 ORDER BY `stickied` DESC, `bumped` DESC");

    263. 

  263. 			$numresults = count($results);

    264. 

  264. 			if ($numresults > 0) {

    265. 

  265. 				$celnum = 0;

    266. 

  266. 				$trbreak = 0;

    267. 

  267. 				$row = 1;

    268. 

  268. 				// Calculate the number of rows we will actually output

    269. 

  269. 				$maxrows = max(1, (($numresults - ($numresults % 12)) / 12));

    270. 

  270. 				foreach ($results as $line) {

    271. 

  271. 					$celnum++;

    272. 

  272. 					$trbreak++;

    273. 

  273. 					if ($trbreak == 13 && $celnum != $numresults) {

    274. 

  274. 						$catalog_page .= '</tr>' . "\n" . '<tr>' . "\n";

    275. 

  275. 						$row++;

    276. 

  276. 						$trbreak = 1;

    277. 

  277. 					}

    278. 

  278. 					if ($row <= $maxrows) {

    279. 

  279. 						$replies = $tc_db->GetOne("SELECT COUNT(*) FROM `".KU_DBPREFIX."posts` WHERE `boardid` = " . $this->board['id'] . " AND `IS_DELETED` = 0 AND `parentid` = " . $line['id']);

    280. 

  280. 						$catalog_page .= '<td valign="middle">' . "\n" .

    281. 

  281. 						'<a href="' . KU_BOARDSFOLDER . $this->board['name'] . '/res/' . $line['id'] . '.html"';

    282. 

  282. 						if ($line['subject'] != '') {

    283. 

  283. 							$catalog_page .= ' title="' . $line['subject'] . '"';

    284. 

  284. 						}

    285. 

  285. 						$catalog_page .= '>';

    286. 

  286. 						if ($line['file'] != '' && $line['file'] != 'removed') {

    287. 

  287. 							if ($line['file_type'] == 'jpg' || $line['file_type'] == 'png' || $line['file_type'] == 'gif') {

    288. 

  288. 								$file_path = getCLBoardPath($this->board['name'], $this->board['loadbalanceurl_formatted'], $this->archive_dir);

    289. 

  289. 								$catalog_page .= '<img src="' . $file_path . '/thumb/' . $line['file'] . 'c.' . $line['file_type'] . '" alt="' . $line['id'] . '" border="0" />';

    290. 

  290. 							} else {

    291. 

  291. 								$catalog_page .= _gettext('File');

    292. 

  292. 							}

    293. 

  293. 						} elseif ($line['file'] == 'removed') {

    294. 

  294. 							$catalog_page .= 'Rem.';

    295. 

  295. 						} else {

    296. 

  296. 							$catalog_page .= _gettext('None');

    297. 

  297. 						}

    298. 

  298. 						$catalog_page .= '</a><br />' . "\n" . '<small>' . $replies . '</small>' . "\n" . '</td>' . "\n";

    299. 

  299. 					}

    300. 

  300. 				}

    301. 

  301. 			} else {

    302. 

  302. 				$catalog_page .= '<td>' . "\n" .

    303. 

  303. 				_gettext('No threads.') . "\n" .

    304. 

  304. 				'</td>' . "\n";

    305. 

  305. 			}

    306. 

  306. 

    307. 

  307. 			$catalog_page .= '</tr>' . "\n" . '</table><br /><hr />' .

    308. 

  308. 			$this->Footer(false, (microtime_float()-$executiontime_start_catalog));

    309. 

  309. 

    310. 

  310. 			$this->PrintPage(KU_BOARDSDIR . $this->board['name'] . '/catalog.html', $catalog_head.$catalog_page, $this->board['name']);

    311. 

  311. 		}

    312. 

  312. 		// Delete old pages 

    313. 

  313. 		$dir = KU_BOARDSDIR.$this->board['name'];

    314. 

  314. 		$files = glob ("$dir/*.html");

    315. 

  315. 		if (is_array($files)) {

    316. 

  316. 			foreach ($files as $htmlfile) {

    317. 

  317. 				if (preg_match("/[0-9+].html/", $htmlfile)) {

    318. 

  318. 					if (substr(basename($htmlfile), 0, strpos(basename($htmlfile), '.html'))>$totalpages) {

    319. 

  319. 						unlink($htmlfile);

    320. 

  320. 					}

    321. 

  321. 				}

    322. 

  322. 				if (preg_match("/list[0-9+].html/", $htmlfile)) {

    323. 

  323. 					if (substr(basename($htmlfile), 4, strpos(basename($htmlfile), '.html'))>($liststooutput+1)) {

    324. 

  324. 						unlink($htmlfile);

    325. 

  325. 					}

    326. 

  326. 				}

    327. 

  327. 				if (preg_match("/catalog.html/", $htmlfile)) {

    328. 

  328. 					if (!($this->board['enablecatalog'] == 1 && ($this->board['type'] == 0 || $this->board['type'] == 2))) {

    329. 

  329. 						unlink($htmlfile);

    330. 

  330. 					}

    331. 

  331. 				}

    332. 

  332. 			}

    333. 

  333. 		}

    334. 

  334. 	}

    335. 

  335. 

    336. 

  336. 	/**

    337. 

  337. 	 * Regenerate each thread's corresponding html file, starting with the most recently bumped

    338. 

  338. 	 */

    339. 

  339. 	function RegenerateThreads($id = 0) {

    340. 

  340. 		global $tc_db, $CURRENTLOCALE;

    341. 

  341. 		require_once(KU_ROOTDIR."lib/dwoo.php");

    342. 

  342. 		if (!isset($this->dwoo)) { $this->dwoo = New Dwoo; $this->dwoo_data = new Dwoo_Data(); $this->InitializeDwoo(); }

    343. 

  343. 		$embeds = Array();

    344. 

  344. 		$numimages = 0;

    345. 

  345. 		if ($this->board['type'] != 1 && !$embeds) {

    346. 

  346. 				$embeds = $tc_db->GetAll("SELECT * FROM `" . KU_DBPREFIX . "embeds`");

    347. 

  347. 				$this->dwoo_data->assign('embeds', $embeds);

    348. 

  348. 				foreach ($embeds as $embed) {

    349. 

  349. 					$this->board['filetypes'][] .= $embed['filetype'];

    350. 

  350. 				}

    351. 

  351. 				$this->dwoo_data->assign('filetypes', $this->board['filetypes']);

    352. 

  352. 		}

    353. 

  353. 		if ($id == 0) {

    354. 

  354. 			// Build every thread

    355. 

  355. 			$header = $this->PageHeader(1);

    356. 

  356. 			if ($this->board['type'] != 2){

    357. 

  357. 				$postbox = $this->Postbox(1);

    358. 

  358. 			}

    359. 

  359. 			$threads = $tc_db->GetAll("SELECT * FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id'] . " AND `parentid` = 0 AND `IS_DELETED` = 0 ORDER BY `id` DESC");

    360. 

  360. 

    361. 

  361. 			if (count($threads) > 0) {

    362. 

  362. 				foreach($threads as $thread) {

    363. 

  363. 					$numimages = 0;

    364. 

  364. 					$executiontime_start_thread = microtime_float();

    365. 

  365. 					$posts = $tc_db->GetAll("SELECT * FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id'] . " AND (`id` = " . $thread['id'] . " OR `parentid` = " . $thread['id'] . ") " . (($this->board['type'] != 1) ? ("AND `IS_DELETED` = 0") : ("")) . " ORDER BY `id` ASC");

    366. 

  366. 					if ($this->board['type'] != 1 || ((isset($posts[0]['IS_DELETED']) && $posts[0]['IS_DELETED'] == 0) || (isset($posts[0]['is_deleted']) && $posts[0]['is_deleted'] == 0))) { 

    367. 

  367. 						// There might be a chance that the post was deleted during another RegenerateThreads() session, if there are no posts, move on to the next thread.

    368. 

  368. 						if(count($posts) > 0){

    369. 

  369. 							foreach ($posts as $key=>$post) {

    370. 

  370. 								if (($post['file_type'] == 'jpg' || $post['file_type'] == 'gif' || $post['file_type'] == 'png') && $post['parentid'] != 0) {

    371. 

  371. 									$numimages++;

    372. 

  372. 								}

    373. 

  373. 								$posts[$key] = $this->BuildPost($post, false);

    374. 

  374. 							}

    375. 

  375. 

    376. 

  376. 							$header_replaced = str_replace("<!sm_threadid>", $thread['id'], $header);

    377. 

  377. 							$this->dwoo_data->assign('numimages', $numimages);

    378. 

  378. 							$this->dwoo_data->assign('replythread', $thread['id']);

    379. 

  379. 							$this->dwoo_data->assign('posts', $posts);

    380. 

  380. 							$this->dwoo_data->assign('file_path', getCLBoardPath($this->board['name'], $this->board['loadbalanceurl_formatted'], ''));

    381. 

  381. 							if ($this->board['type'] != 2){

    382. 

  382. 								$postbox_replaced = str_replace("<!sm_threadid>", $thread['id'], $postbox);

    383. 

  383. 							}

    384. 

  384. 							else {

    385. 

  385. 								$postbox_replaced = $this->Postbox($thread['id']);

    386. 

  386. 							}

    387. 

  387. 							$reply	 = $this->dwoo->get(KU_TEMPLATEDIR . '/' . $this->board['text_readable'] . '_reply_header.tpl', $this->dwoo_data);

    388. 

  388. 							$content = $this->dwoo->get(KU_TEMPLATEDIR . '/' . $this->board['text_readable'] . '_thread.tpl', $this->dwoo_data);

    389. 

  389. 							if (!isset($footer)) $footer = $this->Footer(false, (microtime_float() - $executiontime_start_thread), (($this->board['type'] == 1) ? (true) : (false)));

    390. 

  390. 							$content = $header_replaced.$reply.$postbox_replaced.$content.$footer;

    391. 

  391. 

    392. 

  392. 							$content = str_replace("\t", '',$content);

    393. 

  393. 							$content = str_replace("&nbsp;\r\n", '&nbsp;',$content);

    394. 

  394. 

    395. 

  395. 							$this->PrintPage(KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/res/' . $thread['id'] . '.html', $content, $this->board['name']);

    396. 

  396. 							if (KU_FIRSTLAST) {

    397. 

  397. 

    398. 

  398. 								$replycount = (count($posts)-1);

    399. 

  399. 								if ($replycount > 50) {

    400. 

  400. 									$this->dwoo_data->assign('replycount', $replycount);

    401. 

  401. 									$this->dwoo_data->assign('modifier', "last50");

    402. 

  402. 

    403. 

  403. 									// Grab the last 50 replies

    404. 

  404. 									$posts50 = array_slice($posts, -50, 50);

    405. 

  405. 

    406. 

  406. 									// Add on the OP

    407. 

  407. 									array_unshift($posts50, $posts[0]);

    408. 

  408. 									

    409. 

  409. 									$this->dwoo_data->assign('posts', $posts50);

    410. 

  410. 

    411. 

  411. 									$content = $this->dwoo->get(KU_TEMPLATEDIR . '/img_thread.tpl', $this->dwoo_data);

    412. 

  412. 									$content = $header_replaced.$reply.$postbox_replaced.$content.$footer;

    413. 

  413. 									$content = str_replace("\t", '',$content);

    414. 

  414. 									$content = str_replace("&nbsp;\r\n", '&nbsp;',$content);

    415. 

  415. 

    416. 

  416. 									unset($posts50);

    417. 

  417. 

    418. 

  418. 									$this->PrintPage(KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/res/' . $thread['id'] . '+50.html', $content, $this->board['name']);

    419. 

  419. 									if ($replycount > 100) {

    420. 

  420. 										$this->dwoo_data->assign('modifier', "first100");

    421. 

  421. 

    422. 

  422. 										// Grab the first 100 posts

    423. 

  423. 										$posts100 = array_slice($posts, 0, 100);

    424. 

  424. 

    425. 

  425. 										$this->dwoo_data->assign('posts', $posts100);

    426. 

  426. 

    427. 

  427. 										$content = $this->dwoo->get(KU_TEMPLATEDIR . '/img_thread.tpl', $this->dwoo_data);

    428. 

  428. 										$content = $header_replaced.$reply.$postbox_replaced.$content.$footer;

    429. 

  429. 										$content = str_replace("\t", '',$content);

    430. 

  430. 										$content = str_replace("&nbsp;\r\n", '&nbsp;',$content);

    431. 

  431. 

    432. 

  432. 										unset($posts100);

    433. 

  433. 										

    434. 

  434. 										$this->PrintPage(KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/res/' . $thread['id'] . '-100.html', $content, $this->board['name']);

    435. 

  435. 									}

    436. 

  436. 									$this->dwoo_data->assign('modifier', "");

    437. 

  437. 								}

    438. 

  438. 							}

    439. 

  439. 						}

    440. 

  440. 					}

    441. 

  441. 				}

    442. 

  442. 			}

    443. 

  443. 		} else {

    444. 

  444. 			$executiontime_start_thread = microtime_float();

    445. 

  445. 			// Build only that thread

    446. 

  446. 			$thread = $tc_db->GetAll("SELECT * FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id'] . " AND (`id` = " . $id . " OR `parentid` = " . $id . ") " . (($this->board['type'] != 1) ? ("AND `IS_DELETED` = 0") : ("")) . " ORDER BY `id` ASC");

    447. 

  447. 			if ($this->board['type'] != 1 || ((isset($thread[0]['IS_DELETED']) && $thread[0]['IS_DELETED'] == 0) || (isset($thread[0]['is_deleted']) && $thread[0]['is_deleted'] == 0))) { 

    448. 

  448. 				foreach ($thread as $key=>$post) {

    449. 

  449. 					if (($post['file_type'] == 'jpg' || $post['file_type'] == 'gif' || $post['file_type'] == 'png') && $post['parentid'] != 0) {

    450. 

  450. 						$numimages++;

    451. 

  451. 					}

    452. 

  452. 					$thread[$key] = $this->BuildPost($post, false);

    453. 

  453. 				}

    454. 

  454. 				$header = $this->PageHeader($id);

    455. 

  455. 				$postbox = $this->Postbox($id);

    456. 

  456. 				$this->dwoo_data->assign('numimages', $numimages);

    457. 

  457. 				$header = str_replace("<!sm_threadid>", $id, $header);

    458. 

  458. 

    459. 

  459. 				$this->dwoo_data->assign('replythread', $id);

    460. 

  460. 				if ($this->board['type'] != 2){

    461. 

  461. 					$postbox = str_replace("<!sm_threadid>", $id, $postbox);

    462. 

  462. 				}

    463. 

  463. 

    464. 

  464. 				$this->dwoo_data->assign('threadid', $thread[0]['id']);

    465. 

  465. 				$this->dwoo_data->assign('posts', $thread);

    466. 

  466. 				$this->dwoo_data->assign('file_path', getCLBoardPath($this->board['name'], $this->board['loadbalanceurl_formatted'], ''));

    467. 

  467. 				

    468. 

  468. 				$postbox = $this->dwoo->get(KU_TEMPLATEDIR . '/' . $this->board['text_readable'] . '_reply_header.tpl', $this->dwoo_data).$postbox;

    469. 

  469. 				$content = $this->dwoo->get(KU_TEMPLATEDIR . '/' . $this->board['text_readable'] . '_thread.tpl', $this->dwoo_data);

    470. 

  470. 				

    471. 

  471. 				if (!isset($footer)) $footer = $this->Footer(false, (microtime_float() - $executiontime_start_thread), (($this->board['type'] == 1) ? (true) : (false)));

    472. 

  472. 				$content = $header.$postbox.$content.$footer;

    473. 

  473. 

    474. 

  474. 				$content = str_replace("\t", '',$content);

    475. 

  475. 				$content = str_replace("&nbsp;\r\n", '&nbsp;',$content);

    476. 

  476. 

    477. 

  477. 				$this->PrintPage(KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/res/' . $id . '.html', $content, $this->board['name']);

    478. 

  478. 				if (KU_FIRSTLAST) {

    479. 

  479. 					$replycount = $tc_db->GetOne("SELECT COUNT(`id`) FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $this->board['id'] . " AND `parentid` = " . $id . " AND `IS_DELETED` = 0");

    480. 

  480. 					if ($replycount > 50) {

    481. 

  481. 						$this->dwoo_data->assign('replycount', $replycount);

    482. 

  482. 						$this->dwoo_data->assign('modifier', "last50");

    483. 

  483. 

    484. 

  484. 						// Grab the last 50 replies

    485. 

  485. 						$posts50 = array_slice($thread, -50, 50);

    486. 

  486. 

    487. 

  487. 						// Add the thread to the top of this, since it wont be included in the result

    488. 

  488. 						array_unshift($posts50, $thread[0]); 

    489. 

  489. 

    490. 

  490. 						$this->dwoo_data->assign('posts', $posts50);

    491. 

  491. 

    492. 

  492. 						$content = $this->dwoo->get(KU_TEMPLATEDIR . '/img_thread.tpl', $this->dwoo_data);

    493. 

  493. 						$content = $header.$reply.$postbox.$content.$footer;

    494. 

  494. 						$content = str_replace("\t", '',$content);

    495. 

  495. 						$content = str_replace("&nbsp;\r\n", '&nbsp;',$content);

    496. 

  496. 

    497. 

  497. 						unset($posts50);					

    498. 

  498. 

    499. 

  499. 						$this->PrintPage(KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/res/' . $id . '+50.html', $content, $this->board['name']);

    500. 

  500. 						if ($replycount > 100) {

    501. 

  501. 							$this->dwoo_data->assign('modifier', "first100");

    502. 

  502. 

    503. 

  503. 							// Grab the first 100 posts

    504. 

  504. 							$posts100 = array_slice($thread, 0, 100);

    505. 

  505. 

    506. 

  506. 							$this->dwoo_data->assign('posts', $posts100);

    507. 

  507. 

    508. 

  508. 							$this->dwoo_data->assign('posts', $posts);

    509. 

  509. 							$content = $this->dwoo->get(KU_TEMPLATEDIR . '/img_thread.tpl', $this->dwoo_data);

    510. 

  510. 							$content = $header.$reply.$postbox.$content.$footer;

    511. 

  511. 							$content = str_replace("\t", '',$content);

    512. 

  512. 							$content = str_replace("&nbsp;\r\n", '&nbsp;',$content);

    513. 

  513. 

    514. 

  514. 							unset($posts100);

    515. 

  515. 

    516. 

  516. 							$this->PrintPage(KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/res/' . $id . '-100.html', $content, $this->board['name']);

    517. 

  517. 						}

    518. 

  518. 						$this->dwoo_data->assign('modifier', "");

    519. 

  519. 					}

    520. 

  520. 				}

    521. 

  521. 			}

    522. 

  522. 		}

    523. 

  523. 	}

    524. 

  524. 

    525. 

  525. 	function BuildPost($post, $page) {

    526. 

  526. 		global $CURRENTLOCALE;

    527. 

  527. 		if ($this->board['type'] == 1 && ((isset($post['IS_DELETED']) && $post['IS_DELETED'] == 1) || (isset($post['is_deleted']) && $post['is_deleted'] == 1))) { 

    528. 

  528. 			$post['name'] = '';

    529. 

  529. 			$post['email'] = '';

    530. 

  530. 			$post['tripcode'] = _gettext('Deleted');

    531. 

  531. 			$post['message'] = '<font color="gray">'._gettext('This post has been deleted.').'</font>';

    532. 

  532. 		}

    533. 

  533. 		$dateEmail = (empty($this->board['anonymous'])) ? $post['email'] : 0;

    534. 

  534. 		$post['message'] = stripslashes(formatLongMessage($post['message'], $this->board['name'], (($post['parentid'] == 0) ? ($post['id']) : ($post['parentid'])), $page));

    535. 

  535. 		$post['timestamp_formatted'] = formatDate($post['timestamp'], 'post', $CURRENTLOCALE, $dateEmail);

    536. 

  536. 		$post['reflink'] = formatReflink($this->board['name'], (($post['parentid'] == 0) ? ($post['id']) : ($post['parentid'])), $post['id'], $CURRENTLOCALE);

    537. 

  537. 		if (isset($this->board['filetypes']) && in_array($post['file_type'], $this->board['filetypes'])) {

    538. 

  538. 			$post['videobox'] = embeddedVideoBox($post);

    539. 

  539. 		}

    540. 

  540. 		if ($post['file_type'] == 'mp3' && $this->board['loadbalanceurl'] == '') {

    541. 

  541. 			//Grab the ID3 info. TODO: Make this work for load-balanced boards.

    542. 

  542. 			// include getID3() library

    543. 

  543. 

    544. 

  544. 			require_once(KU_ROOTDIR . 'lib/getid3/getid3.php');

    545. 

  545. 

    546. 

  546. 			// Initialize getID3 engine

    547. 

  547. 			$getID3 = new getID3;

    548. 

  548. 

    549. 

  549. 			$post['id3'] = $getID3->analyze(KU_BOARDSDIR.$this->board['name'].'/src/'.$post['file'].'.mp3');

    550. 

  550. 			getid3_lib::CopyTagsToComments($post['id3']);

    551. 

  551. 		}

    552. 

  552. 		if ($post['file_type']!='jpg'&&$post['file_type']!='gif'&&$post['file_type']!='png'&&$post['file_type']!=''&&!in_array($post['file_type'], $this->board['filetypes'])) {

    553. 

  553. 			if(!isset($filetype_info[$post['file_type']])) $filetype_info[$post['file_type']] = getfiletypeinfo($post['file_type']);

    554. 

  554. 			$post['nonstandard_file'] = KU_WEBPATH . '/inc/filetypes/' . $filetype_info[$post['file_type']][0];

    555. 

  555. 			if($post['thumb_w']!=0&&$post['thumb_h']!=0) {

    556. 

  556. 				if(file_exists(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$post['file'].'s.jpg'))

    557. 

  557. 					$post['nonstandard_file'] = KU_WEBPATH . '/' .$this->board['name'].'/thumb/'.$post['file'].'s.jpg';

    558. 

  558. 				elseif(file_exists(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$post['file'].'s.png'))

    559. 

  559. 					$post['nonstandard_file'] = KU_WEBPATH . '/' .$this->board['name'].'/thumb/'.$post['file'].'s.png';

    560. 

  560. 				elseif(file_exists(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$post['file'].'s.gif'))

    561. 

  561. 					$post['nonstandard_file'] = KU_WEBPATH . '/' .$this->board['name'].'/thumb/'.$post['file'].'s.gif';

    562. 

  562. 				else {

    563. 

  563. 					$post['thumb_w'] = $filetype_info[$post['file_type']][1];

    564. 

  564. 					$post['thumb_h'] = $filetype_info[$post['file_type']][2];

    565. 

  565. 				}

    566. 

  566. 			}

    567. 

  567. 			else {

    568. 

  568. 				$post['thumb_w'] = $filetype_info[$post['file_type']][1];

    569. 

  569. 				$post['thumb_h'] = $filetype_info[$post['file_type']][2];

    570. 

  570. 			}

    571. 

  571. 		}

    572. 

  572. 		

    573. 

  573. 		return $post;

    574. 

  574. 	}

    575. 

  575. 	

    576. 

  576. 	/**

    577. 

  577. 	 * Build the page header

    578. 

  578. 	 *

    579. 

  579. 	 * @param integer $replythread The ID of the thread the header is being build for.  0 if it is for a board page

    580. 

  580. 	 * @param integer $liststart The number which the thread list starts on (text boards only)

    581. 

  581. 	 * @param integer $liststooutput The number of list pages which will be generated (text boards only)

    582. 

  582. 	 * @return string The built header

    583. 

  583. 	 */

    584. 

  584. 	function PageHeader($replythread = '0', $liststart = '0', $liststooutput = '-1') {

    585. 

  585. 		global $tc_db, $CURRENTLOCALE;

    586. 

  586. 

    587. 

  587. 		$tpl = Array();

    588. 

  588. 

    589. 

  589. 		$tpl['htmloptions'] = ((KU_LOCALE == 'he' && empty($this->board['locale'])) || $this->board['locale'] == 'he') ? ' dir="rtl"' : '' ;

    590. 

  590. 

    591. 

  591. 		$tpl['title'] = '';

    592. 

  592. 

    593. 

  593. 		if (KU_DIRTITLE) {

    594. 

  594. 			$tpl['title'] .= '/' . $this->board['name'] . '/ - ';

    595. 

  595. 		}

    596. 

  596. 		$tpl['title'] .= $this->board['desc'];

    597. 

  597. 

    598. 

  598. 		$ad_top = 185;

    599. 

  599. 		$ad_right = 25;

    600. 

  600. 		if ($this->board['type']==1) {

    601. 

  601. 			$ad_top -= 50;

    602. 

  602. 		} else {

    603. 

  603. 			if ($replythread!=0) {

    604. 

  604. 				$ad_top += 50;

    605. 

  605. 			}

    606. 

  606. 		}

    607. 

  607. 		if ($this->board['type']==2) {

    608. 

  608. 			$ad_top += 40;

    609. 

  609. 		}

    610. 

  610. 		$this->dwoo_data->assign('title', $tpl['title']);

    611. 

  611. 		$this->dwoo_data->assign('htmloptions', $tpl['htmloptions']);

    612. 

  612. 		$this->dwoo_data->assign('locale', $CURRENTLOCALE);

    613. 

  613. 		$this->dwoo_data->assign('ad_top', $ad_top);

    614. 

  614. 		$this->dwoo_data->assign('ad_right', $ad_right);

    615. 

  615. 		$this->dwoo_data->assign('board', $this->board);

    616. 

  616. 		$this->dwoo_data->assign('replythread', $replythread);

    617. 

  617. 		if ($this->board['type'] != 1) {

    618. 

  618. 			$topads = $tc_db->GetOne("SELECT code FROM `" . KU_DBPREFIX . "ads` WHERE `position` = 'top' AND `disp` = '1'");

    619. 

  619. 			$this->dwoo_data->assign('topads', $topads);

    620. 

  620. 			$this->dwoo_data->assign('ku_styles', explode(':', KU_STYLES));

    621. 

  621. 			$this->dwoo_data->assign('ku_defaultstyle', (!empty($this->board['defaultstyle']) ? ($this->board['defaultstyle']) : (KU_DEFAULTSTYLE)));

    622. 

  622. 		} else {

    623. 

  623. 			$this->dwoo_data->assign('ku_styles', explode(':', KU_TXTSTYLES));

    624. 

  624. 			$this->dwoo_data->assign('ku_defaultstyle', (!empty($this->board['defaultstyle']) ? ($this->board['defaultstyle']) : (KU_DEFAULTTXTSTYLE)));

    625. 

  625. 		}

    626. 

  626. 		$this->dwoo_data->assign('boardlist', $this->board['boardlist']);

    627. 

  627. 

    628. 

  628. 		$global_header = $this->dwoo->get(KU_TEMPLATEDIR . '/global_board_header.tpl', $this->dwoo_data);

    629. 

  629. 

    630. 

  630. 		if ($this->board['type'] != 1) {

    631. 

  631. 			$header = $this->dwoo->get(KU_TEMPLATEDIR . '/' . $this->board['text_readable'] . '_header.tpl', $this->dwoo_data);

    632. 

  632. 		} else {

    633. 

  633. 			if ($liststooutput == -1) {

    634. 

  634. 				$this->dwoo_data->assign('isindex', true);

    635. 

  635. 			} else {

    636. 

  636. 				$this->dwoo_data->assign('isindex', false);

    637. 

  637. 			}

    638. 

  638. 			if ($replythread != 0) $this->dwoo_data->assign('isthread', true);

    639. 

  639. 			$header = $this->dwoo->get(KU_TEMPLATEDIR . '/txt_header.tpl', $this->dwoo_data);

    640. 

  640. 

    641. 

  641. 			if ($replythread == 0) {

    642. 

  642. 				$startrecord = ($liststooutput >= 0 || $this->board['compactlist']) ? 40 : KU_THREADSTXT ;

    643. 

  643. 				$threads = $tc_db->GetAll("SELECT * FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $tc_db->qstr($this->board['id']) . " AND `parentid` = 0 AND `IS_DELETED` = 0 ORDER BY `stickied` DESC, `bumped` DESC LIMIT " . $startrecord . " OFFSET " . $liststart);

    644. 

  644. 				foreach($threads AS $key=>$thread) {

    645. 

  645. 					$replycount = $tc_db->GetOne("SELECT COUNT(`id`) FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $tc_db->qstr($this->board['id']) . " AND `parentid` = " . $thread['id']);

    646. 

  646. 					$threads[$key]['replies'] = $replycount;

    647. 

  647. 				}

    648. 

  648. 				$this->dwoo_data->assign('threads', $threads);

    649. 

  649. 				$header .= $this->dwoo->get(KU_TEMPLATEDIR . '/txt_threadlist.tpl', $this->dwoo_data);

    650. 

  650. 			}

    651. 

  651. 		}

    652. 

  652. 

    653. 

  653. 		return $global_header.$header;

    654. 

  654. 	}

    655. 

  655. 

    656. 

  656. 	/**

    657. 

  657. 	 * Build the page header for an oekaki posting

    658. 

  658. 	 *

    659. 

  659. 	 * @param integer $replyto The ID of the thread being replied to.  0 for a new thread

    660. 

  660. 	 */

    661. 

  661. 	function OekakiHeader($replyto, $postoek) {

    662. 

  662. 		$executiontime_start = microtime_float();

    663. 

  663. 		$this->InitializeDwoo();

    664. 

  664. 

    665. 

  665. 		$page = $this->PageHeader();

    666. 

  666. 		$this->dwoo_data->assign('replythread', $replyto);

    667. 

  667. 		$page .= $this->Postbox();

    668. 

  668. 

    669. 

  669. 		$executiontime_stop = microtime_float();

    670. 

  670. 

    671. 

  671. 		$page .= $this->Footer(false, ($executiontime_stop - $executiontime_start));

    672. 

  672. 

    673. 

  673. 		$this->PrintPage('', $page, true);

    674. 

  674. 	}

    675. 

  675. 

    676. 

  676. 	/**

    677. 

  677. 	 * Generate the postbox area

    678. 

  678. 	 *

    679. 

  679. 	 * @param integer $replythread The ID of the thread being replied to.  0 if not replying

    680. 

  680. 	 * @param string $postboxnotice The postbox notice

    681. 

  681. 	 * @return string The generated postbox

    682. 

  682. 	 */

    683. 

  683. 	function Postbox($replythread = 0) {

    684. 

  684. 		global $tc_db;

    685. 

  685. 		if (KU_BLOTTER && $this->board['type'] != 1) {

    686. 

  686. 			$this->dwoo_data->assign('blotter', getBlotter());

    687. 

  687. 			$this->dwoo_data->assign('blotter_updated', getBlotterLastUpdated());

    688. 

  688. 		}

    689. 

  689. 		$postbox = '';

    690. 

  690. 

    691. 

  691. 		if ($this->board['type'] == 2 && $replythread > 0) {

    692. 

  692. 			$oekposts = $tc_db->GetAll("SELECT `id` FROM `" . KU_DBPREFIX."posts` WHERE `boardid` = " . $this->board['id']." AND (`id` = ".$replythread." OR `parentid` = ".$replythread.") AND `file` != '' AND `file` != 'removed' AND `file_type` IN ('jpg', 'gif', 'png') AND `IS_DELETED` = 0 ORDER BY `parentid` ASC, `timestamp` ASC");

    693. 

  693. 			$this->dwoo_data->assign('oekposts', $oekposts);

    694. 

  694. 		}

    695. 

  695. 		if ($this->board['enablecaptcha'] ==  1)

    696. 

  696. 		{

    697. 

  697. 			if( KU_CAPTCHA_TYPE == 'recaptcha' )

    698. 

  698. 			{

    699. 

  699. 				// RH - use reCAPTCHA challenge instead of the faptcha

    700. 

  700. 				require_once(KU_ROOTDIR.'recaptchalib.php');

    701. 

  701. 				$publickey = "6LdVg8YSAAAAAOhqx0eFT1Pi49fOavnYgy7e-lTO";

    702. 

  702. 				$this->dwoo_data->assign('faptcha_input', recaptcha_get_html($publickey));  // Originally assigned to 'recaptcha', bit lazy doing this, maybe template can have both?

    703. 

  703. 			}

    704. 

  704. 			else if( KU_CAPTCHA_TYPE == 'faptcha' )

    705. 

  705. 			{

    706. 

  706. 				// RH - Textbox to type the faptcha answer into = "captcha", calling it this reuses existing validation JS

    707. 

  707. 				//      Likewise we call the image 'captchaimage' as before

    708. 

  708. 				// 06/01/2012 SRC now also appends random querystring in case of caching issues

    709. 

  709. 				// 15/01/2012 blank answer textbox on refresh to avoid accidental wrong answers

    710. 

  710. 				$faptcha_image = '<a href="#" onclick="javascript:document.getElementById(\'captchaimage\').src = \''. KU_CGIPATH . '/faptcha.php?\' + Math.random();javascript:document.getElementById(\'captcha\').value=\'\';return false;"> <IMG ID="captchaimage" SRC="'. KU_WEBFOLDER .'faptcha.php?'.mt_rand().'" border="0" alt="Click for a new faptcha" title="Click for a new faptcha"> </A>';

    711. 

  711. 				$faptcha_input = '<BR><input type="text" name="captcha" id="captcha" title="Enter character\'s name (common nicknames accepted ... probably)" size="28" maxlength="75" accesskey="c" />';

    712. 

  712. 				$this->dwoo_data->assign('faptcha_image', $faptcha_image);	// the faptcha image

    713. 

  713. 				$this->dwoo_data->assign('faptcha_input', $faptcha_input);	// faptcha answer input textbox

    714. 

  714. 			}

    715. 

  715. 			else

    716. 

  716. 			{

    717. 

  717. 				die("ERROR: Unrecognised captcha type set in config.php! (KU_CAPTCHA_TYPE)");

    718. 

  718. 			}

    719. 

  719. 		}

    720. 

  720. 		if(($this->board['type'] == 1 && $replythread == 0) || $this->board['type'] != 1) {

    721. 

  721. 			$postbox .= $this->dwoo->get(KU_TEMPLATEDIR . '/' . $this->board['text_readable'] . '_post_box.tpl', $this->dwoo_data);

    722. 

  722. 		}

    723. 

  723. 		return $postbox;

    724. 

  724. 	}

    725. 

  725. 

    726. 

  726. 	/**

    727. 

  727. 	 * Display the user-defined list of boards found in boards.html

    728. 

  728. 	 *

    729. 

  729. 	 * @param boolean $is_textboard If the board this is being displayed for is a text board

    730. 

  730. 	 * @return string The board list

    731. 

  731. 	 */

    732. 

  732. 	function DisplayBoardList($is_textboard = false) {

    733. 

  733. 		if (KU_GENERATEBOARDLIST) {

    734. 

  734. 			global $tc_db;

    735. 

  735. 

    736. 

  736. 			$output = '';

    737. 

  737. 			$results = $tc_db->GetAll("SELECT `id` FROM `" . KU_DBPREFIX . "sections` ORDER BY `order` ASC");

    738. 

  738. 			$boards = array();

    739. 

  739. 			foreach($results AS $line) {

    740. 

  740. 				$results2 = $tc_db->GetAll("SELECT * FROM `" . KU_DBPREFIX . "boards` WHERE `section` = '" . $line['id'] . "' ORDER BY `order` ASC, `name` ASC");

    741. 

  741. 				foreach($results2 AS $line2) {

    742. 

  742. 					$boards[$line['id']][$line2['id']]['name'] = htmlspecialchars($line2['name']);

    743. 

  743. 					$boards[$line['id']][$line2['id']]['desc'] = htmlspecialchars($line2['desc']);

    744. 

  744. 				}

    745. 

  745. 			}

    746. 

  746. 		} else {

    747. 

  747. 			$boards = KU_ROOTDIR . 'boards.html';

    748. 

  748. 		}

    749. 

  749. 

    750. 

  750. 		return $boards;

    751. 

  751. 	}

    752. 

  752. 

    753. 

  753. 

    754. 

  754. 	/**

    755. 

  755. 	 * Display the page footer

    756. 

  756. 	 *

    757. 

  757. 	 * @param boolean $noboardlist Force the board list to not be displayed

    758. 

  758. 	 * @param string $executiontime The time it took the page to be created

    759. 

  759. 	 * @param boolean $hide_extra Hide extra footer information, and display the manage link

    760. 

  760. 	 * @return string The generated footer

    761. 

  761. 	 */

    762. 

  762. 	function Footer($noboardlist = false, $executiontime = '', $hide_extra = false) {

    763. 

  763. 		global $tc_db, $dwoo, $dwoo_data;

    764. 

  764. 

    765. 

  765. 		$footer = '';

    766. 

  766. 

    767. 

  767. 		if ($hide_extra || $noboardlist) $this->dwoo_data->assign('boardlist', '');

    768. 

  768. 

    769. 

  769. 		if ($executiontime != '') $this->dwoo_data->assign('executiontime', round($executiontime, 2));

    770. 

  770. 		

    771. 

  771. 		$botads = $tc_db->GetOne("SELECT code FROM `" . KU_DBPREFIX . "ads` WHERE `position` = 'bot' AND `disp` = '1'");

    772. 

  772. 		$this->dwoo_data->assign('botads', $botads);

    773. 

  773. 		$footer = $this->dwoo->get(KU_TEMPLATEDIR . '/' . $this->board['text_readable'] . '_footer.tpl', $this->dwoo_data);

    774. 

  774. 		

    775. 

  775. 		$footer .= $this->dwoo->get(KU_TEMPLATEDIR . '/global_board_footer.tpl', $this->dwoo_data);

    776. 

  776. 

    777. 

  777. 		return $footer;

    778. 

  778. 	}

    779. 

  779. 

    780. 

  780. 	/**

    781. 

  781. 	 * Finalize the page and print it to the specified filename

    782. 

  782. 	 *

    783. 

  783. 	 * @param string $filename File to print the page to

    784. 

  784. 	 * @param string $contents Page contents

    785. 

  785. 	 * @param string $board Board which the file is being generated for

    786. 

  786. 	 * @return string The page contents, if requested

    787. 

  787. 	 */

    788. 

  788. 	function PrintPage($filename, $contents, $board) {

    789. 

  789. 

    790. 

  790. 		if ($board !== true) {

    791. 

  791. 			print_page($filename, $contents, $board);

    792. 

  792. 		} else {

    793. 

  793. 			echo $contents;

    794. 

  794. 		}

    795. 

  795. 	}

    796. 

  796. 

    797. 

  797. 	/**

    798. 

  798. 	 * Initialize the instance of smary which will be used for generating pages

    799. 

  799. 	 */

    800. 

  800. 	function InitializeDwoo() {

    801. 

  801. 

    802. 

  802. 		require_once KU_ROOTDIR . 'lib/dwoo.php';

    803. 

  803. 		$this->dwoo = new Dwoo();

    804. 

  804. 		$this->dwoo_data = new Dwoo_Data();

    805. 

  805. 

    806. 

  806. 		$this->dwoo_data->assign('cwebpath', getCWebpath());

    807. 

  807. 		$this->dwoo_data->assign('boardpath', getCLBoardPath());

    808. 

  808. 	}

    809. 

  809. 

    810. 

  810. 	/**

    811. 

  811. 	 * Enable/disable archive mode

    812. 

  812. 	 *

    813. 

  813. 	 * @param boolean $mode True/false for enabling/disabling archive mode

    814. 

  814. 	 */

    815. 

  815. 	function ArchiveMode($mode) {

    816. 

  816. 		$this->archive_dir = ($mode && $this->board['enablearchiving'] == 1) ? '/arch' : '';

    817. 

  817. 	}

    818. 

  818. }

    819. 

  819. 

    820. 

  820. /**

    821. 

  821.  * Post class

    822. 

  822.  *

    823. 

  823.  * Used for post insertion, deletion, and reporting.

    824. 

  824.  *

    825. 

  825.  * @package kusaba

    826. 

  826.  */

    827. 

  827. class Post extends Board {

    828. 

  828. 	// Declare the public variables

    829. 

  829. 	var $post = Array();

    830. 

  830. 

    831. 

  831. 	function Post($postid, $board, $boardid, $is_inserting = false) {

    832. 

  832. 		global $tc_db;

    833. 

  833. 

    834. 

  834. 		$results = $tc_db->GetAll("SELECT * FROM `".KU_DBPREFIX."posts` WHERE `boardid` = '" . $boardid . "' AND `id` = ".$tc_db->qstr($postid)." LIMIT 1");

    835. 

  835. 		if (count($results)==0&&!$is_inserting) {

    836. 

  836. 			exitWithErrorPage('Invalid post ID.');

    837. 

  837. 		} elseif ($is_inserting) {

    838. 

  838. 			$this->Board($board, false);

    839. 

  839. 		} else {

    840. 

  840. 			foreach ($results[0] as $key=>$line) {

    841. 

  841. 				if (!is_numeric($key)) $this->post[$key] = $line;

    842. 

  842. 			}

    843. 

  843. 			$results = $tc_db->GetAll("SELECT `cleared` FROM `".KU_DBPREFIX."reports` WHERE `postid` = ".$tc_db->qstr($this->post['id'])." LIMIT 1");

    844. 

  844. 			if (count($results)>0) {

    845. 

  845. 				foreach($results AS $line) {

    846. 

  846. 					$this->post['isreported'] = ($line['cleared'] == 0) ? true : 'cleared';

    847. 

  847. 				}

    848. 

  848. 			} else {

    849. 

  849. 				$this->post['isreported'] = false;

    850. 

  850. 			}

    851. 

  851. 			$this->post['isthread'] = ($this->post['parentid'] == 0) ? true : false;

    852. 

  852. 			if (empty($this->board) || $this->board['name'] != $board) {

    853. 

  853. 				$this->Board($board, false);

    854. 

  854. 			}

    855. 

  855. 		}

    856. 

  856. 	}

    857. 

  857. 

    858. 

  858. 	function Delete($allow_archive = false) {

    859. 

  859. 		global $tc_db;

    860. 

  860. 

    861. 

  861. 		$i = 0;

    862. 

  862. 		if ($this->post['isthread'] == true) {

    863. 

  863. 			if ($allow_archive && $this->board['enablearchiving'] == 1 && $this->board['loadbalanceurl'] == '') {

    864. 

  864. 				$this->ArchiveMode(true);

    865. 

  865. 				$this->RegenerateThreads($this->post['id']);

    866. 

  866. 				@copy(KU_BOARDSDIR . $this->board['name'] . '/src/' . $this->post['file'] . '.' . $this->post['filetype'], KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/src/' . $this->post['file'] . '.' . $this->post['filetype']);

    867. 

  867. 				@copy(KU_BOARDSDIR . $this->board['name'] . '/thumb/' . $this->post['file'] . 's.' . $this->post['filetype'], KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/thumb/' . $this->post['file'] . 's.' . $this->post['filetype']);

    868. 

  868. 			}

    869. 

  869. 			$results = $tc_db->GetAll("SELECT `id`, `file`, `file_type` FROM `".KU_DBPREFIX."posts` WHERE `boardid` = '" . $this->board['id'] . "' AND `IS_DELETED` = 0 AND `parentid` = ".$tc_db->qstr($this->post['id']));

    870. 

  870. 			foreach($results AS $line) {

    871. 

  871. 				$i++;

    872. 

  872. 				if ($allow_archive && $this->board['enablearchiving'] == 1) {

    873. 

  873. 					@copy(KU_BOARDSDIR . $this->board['name'] . '/src/' . $line['file'] . '.' . $line['file_type'], KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/src/' . $line['file'] . '.' . $line['file_type']);

    874. 

  874. 					@copy(KU_BOARDSDIR . $this->board['name'] . '/thumb/' . $line['file'] . 's.' . $line['file_type'], KU_BOARDSDIR . $this->board['name'] . $this->archive_dir . '/thumb/' . $line['file'] . 's.' . $line['file_type']);

    875. 

  875. 				}

    876. 

  876. 			}

    877. 

  877. 			if ($allow_archive && $this->board['enablearchiving'] == 1) {

    878. 

  878. 				$this->ArchiveMode(false);

    879. 

  879. 			}

    880. 

  880. 			@unlink(KU_BOARDSDIR.$this->board['name'].'/res/'.$this->post['id'].'.html');

    881. 

  881. 			@unlink(KU_BOARDSDIR.$this->board['name'].'/res/'.$this->post['id'].'-100.html');

    882. 

  882. 			@unlink(KU_BOARDSDIR.$this->board['name'].'/res/'.$this->post['id'].'+50.html');

    883. 

  883. 			$this->DeleteFile(false, true);

    884. 

  884. 			foreach($results AS $line) {

    885. 

  885. 				$tc_db->Execute("UPDATE `".KU_DBPREFIX."posts` SET `IS_DELETED` = 1 , `deleted_timestamp` = '" . time() . "' WHERE `boardid` = '" . $this->board['id'] . "' AND `id` = '".$line['id']."' AND `parentid` = ".$tc_db->qstr($this->post['id']));

    886. 

  886. 				clearPostCache($line['id'], $this->board['name']);

    887. 

  887. 			}

    888. 

  888. 			$tc_db->Execute("DELETE FROM `".KU_DBPREFIX."watchedthreads` WHERE `threadid` = ".$tc_db->qstr($this->post['id'])." AND `board` = '".$this->board['name']."'");

    889. 

  889. 			$tc_db->Execute("UPDATE `".KU_DBPREFIX."posts` SET `IS_DELETED` = 1 , `deleted_timestamp` = '" . time() . "' WHERE `boardid` = '" . $this->board['id'] . "' AND `id` = ".$tc_db->qstr($this->post['id']));

    890. 

  890. 			clearPostCache($this->post['id'], $this->board['name']);

    891. 

  891. 

    892. 

  892. 			return $i.' ';

    893. 

  893. 		} else {

    894. 

  894. 			$this->DeleteFile(false);

    895. 

  895. 			$tc_db->Execute("UPDATE `".KU_DBPREFIX."posts` SET `IS_DELETED` = 1 , `deleted_timestamp` = '" . time() . "' WHERE `boardid` = '" . $this->board['id'] . "' AND `id` = ".$tc_db->qstr($this->post['id']));

    896. 

  896. 			clearPostCache($this->post['id'], $this->board['name']);

    897. 

  897. 

    898. 

  898. 			return true;

    899. 

  899. 		}

    900. 

  900. 	}

    901. 

  901. 

    902. 

  902. 	function DeleteFile($update_to_removed = true, $whole_thread = false) {

    903. 

  903. 		global $tc_db;

    904. 

  904. 		if ($whole_thread && $this->post['isthread']) {

    905. 

  905. 			$results = $tc_db->GetAll("SELECT `id`, `file`, `file_type` FROM `".KU_DBPREFIX."posts` WHERE `boardid` = " . $this->board['id'] . " AND `IS_DELETED` = 0 AND `parentid` = ".$tc_db->qstr($this->post['id']));

    906. 

  906. 			if (count($results)>0) {

    907. 

  907. 				foreach($results AS $line) {

    908. 

  908. 					if ($line['file'] != '' && $line['file'] != 'removed') {

    909. 

  909. 						if ($this->board['loadbalanceurl'] != '') {

    910. 

  910. 							$this->loadbalancer->Delete($line['file'], $line['file_type']);

    911. 

  911. 						} else {

    912. 

  912. 							@unlink(KU_BOARDSDIR.$this->board['name'].'/src/'.$line['file'].'.'.$line['file_type']);

    913. 

  913. 							@unlink(KU_BOARDSDIR.$this->board['name'].'/src/'.$line['file'].'.pch');

    914. 

  914. 							@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$line['file'].'s.'.$line['file_type']);

    915. 

  915. 							@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$line['file'].'c.'.$line['file_type']);

    916. 

  916. 							if ($line['file_type'] == 'mp3') {

    917. 

  917. 								@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$line['file'].'s.jpg');

    918. 

  918. 								@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$line['file'].'s.png');

    919. 

  919. 								@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$line['file'].'s.gif');

    920. 

  920. 							}

    921. 

  921. 						}

    922. 

  922. 						if ($update_to_removed) {

    923. 

  923. 							$tc_db->Execute("UPDATE `".KU_DBPREFIX."posts` SET `file` = 'removed', `file_md5` = '' WHERE `boardid` = '" . $this->board['id'] . "' AND `id` = ".$line['id']);

    924. 

  924. 							clearPostCache($line['id'], $this->board['name']);

    925. 

  925. 						}

    926. 

  926. 					}

    927. 

  927. 				}

    928. 

  928. 			}

    929. 

  929. 			$this->DeleteFile($update_to_removed);

    930. 

  930. 		} else {

    931. 

  931. 			if ($this->post['file']!=''&&$this->post['file']!='removed') {

    932. 

  932. 				if ($this->board['loadbalanceurl'] != '') {

    933. 

  933. 					$this->loadbalancer->Delete($this->post['file'], $this->post['filetype']);

    934. 

  934. 				} else {

    935. 

  935. 						@unlink(KU_BOARDSDIR.$this->board['name'].'/src/'.$this->post['file'].'.'.$this->post['file_type']);

    936. 

  936. 						@unlink(KU_BOARDSDIR.$this->board['name'].'/src/'.$this->post['file'].'.pch');

    937. 

  937. 						@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$this->post['file'].'s.'.$this->post['file_type']);

    938. 

  938. 						@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$this->post['file'].'c.'.$this->post['file_type']);

    939. 

  939. 						if ($this->post['file_type'] == 'mp3') {

    940. 

  940. 							@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$this->post['file'].'s.jpg');

    941. 

  941. 							@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$this->post['file'].'s.png');

    942. 

  942. 							@unlink(KU_BOARDSDIR.$this->board['name'].'/thumb/'.$this->post['file'].'s.gif');

    943. 

  943. 						}

    944. 

  944. 				}

    945. 

  945. 				if ($update_to_removed) {

    946. 

  946. 					$tc_db->Execute("UPDATE `".KU_DBPREFIX."posts` SET `file` = 'removed', `file_md5` = '' WHERE `boardid` = '" . $this->board['id'] . "' AND `id` = ".$tc_db->qstr($this->post['id']));

    947. 

  947. 					clearPostCache($this->post['id'], $this->board['name']);

    948. 

  948. 				}

    949. 

  949. 			}

    950. 

  950. 		}

    951. 

  951. 	}

    952. 

  952. 

    953. 

  953. 	function Insert($parentid, $name, $tripcode, $email, $subject, $message, $filename, $file_original, $filetype, $file_md5, $image_w, $image_h, $filesize, $thumb_w, $thumb_h, $password, $timestamp, $bumped, $ip, $posterauthority, $tag, $stickied, $locked, $boardid) {

    954. 

  954. 		global $tc_db;

    955. 

  955. 

    956. 

  956. 		// RH - ipmd5 now salted (insecure poster ID issue)

    957. 

  957. 		$query = "INSERT INTO `".KU_DBPREFIX."posts` ( `parentid` , `boardid`, `name` , `tripcode` , `email` , `subject` , `message` , `file` , `file_original`, `file_type` , `file_md5` , `image_w` , `image_h` , `file_size` , `file_size_formatted` , `thumb_w` , `thumb_h` , `password` , `timestamp` , `bumped` , `ip` , `ipmd5` , `posterauthority` , `tag` , `stickied` , `locked` ) VALUES ( ".$tc_db->qstr($parentid).", ".$tc_db->qstr($boardid).", ".$tc_db->qstr($name).", ".$tc_db->qstr($tripcode).", ".$tc_db->qstr($email).", ".$tc_db->qstr($subject).", ".$tc_db->qstr($message).", ".$tc_db->qstr($filename).", ".$tc_db->qstr($file_original).", ".$tc_db->qstr($filetype).", ".$tc_db->qstr($file_md5).", ".$tc_db->qstr(intval($image_w)).", ".$tc_db->qstr(intval($image_h)).", ".$tc_db->qstr($filesize).", ".$tc_db->qstr(ConvertBytes($filesize)).", ".$tc_db->qstr($thumb_w).", ".$tc_db->qstr($thumb_h).", ".$tc_db->qstr($password).", ".$tc_db->qstr($timestamp).", ".$tc_db->qstr($bumped).", ".$tc_db->qstr(md5_encrypt($ip, KU_RANDOMSEED)).", '".md5(KU_SALT.$ip)."', ".$tc_db->qstr($posterauthority).", ".$tc_db->qstr($tag).", ".$tc_db->qstr($stickied).", ".$tc_db->qstr($locked)." )";

    958. 

  958. 		$tc_db->Execute($query);

    959. 

  959. 		$id = $tc_db->Insert_Id();

    960. 

  960. 		if(!$id || KU_DBTYPE == 'sqlite') {

    961. 

  961. 			// Non-mysql installs don't return the insert ID after insertion, we need to manually get it.

    962. 

  962. 			$id = $tc_db->GetOne("SELECT `id` FROM `".KU_DBPREFIX."posts` WHERE `boardid` = ".$tc_db->qstr($boardid)." AND timestamp = ".$tc_db->qstr($timestamp)." AND `ipmd5` = '".md5(KU_SALT.$ip)."' LIMIT 1");

    963. 

  963. 		}

    964. 

  964. 

    965. 

  965. 		if ($id == 1 && $this->board['start'] > 1) {

    966. 

  966. 			$tc_db->Execute("UPDATE `".KU_DBPREFIX."posts` SET `id` = '".$this->board['start']."' WHERE `boardid` = ".$boardid);

    967. 

  967. 			return $this->board['start'];

    968. 

  968. 		}

    969. 

  969. 		return $id;

    970. 

  970. 	}

    971. 

  971. 

    972. 

  972. 	function Report() {

    973. 

  973. 		global $tc_db;

    974. 

  974. 

    975. 

  975. 		return $tc_db->Execute("INSERT INTO `".KU_DBPREFIX."reports` ( `board` , `postid` , `when` , `ip`, `reason` ) VALUES ( " . $tc_db->qstr($this->board['name']) . " , " . $tc_db->qstr($this->post['id']) . " , ".time()." , '" . md5_encrypt($_SERVER['REMOTE_ADDR'], KU_RANDOMSEED) . "', " . $tc_db->qstr($_POST['reportreason']) . " )");

    976. 

  976. 	}

    977. 

  977. }

    978. 

  978. 

    979. 

  979. ?>

    980. 

  980.