PageRenderTime 58ms CodeModel.GetById 27ms RepoModel.GetById 0ms app.codeStats 0ms

/forum/Sources/Search.php

https://github.com/leftnode/nooges.com
PHP | 2064 lines | 1620 code | 227 blank | 217 comment | 326 complexity | 75b58a541be1b184143474b02437da0e MD5 | raw file

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. /**********************************************************************************
    3. 

  3. * Search.php                                                                      *
    4. 

  4. ***********************************************************************************
    5. 

  5. * SMF: Simple Machines Forum                                                      *
    6. 

  6. * Open-Source Project Inspired by Zef Hemel (zef@zefhemel.com)                    *
    7. 

  7. * =============================================================================== *
    8. 

  8. * Software Version:           SMF 2.0 RC2                                         *
    9. 

  9. * Software by:                Simple Machines (http://www.simplemachines.org)     *
    10. 

  10. * Copyright 2006-2009 by:     Simple Machines LLC (http://www.simplemachines.org) *
    11. 

  11. *           2001-2006 by:     Lewis Media (http://www.lewismedia.com)             *
    12. 

  12. * Support, News, Updates at:  http://www.simplemachines.org                       *
    13. 

  13. ***********************************************************************************
    14. 

  14. * This program is free software; you may redistribute it and/or modify it under   *
    15. 

  15. * the terms of the provided license as published by Simple Machines LLC.          *
    16. 

  16. *                                                                                 *
    17. 

  17. * This program is distributed in the hope that it is and will be useful, but      *
    18. 

  18. * WITHOUT ANY WARRANTIES; without even any implied warranty of MERCHANTABILITY    *
    19. 

  19. * or FITNESS FOR A PARTICULAR PURPOSE.                                            *
    20. 

  20. *                                                                                 *
    21. 

  21. * See the "license.txt" file for details of the Simple Machines license.          *
    22. 

  22. * The latest version can always be found at http://www.simplemachines.org.        *
    23. 

  23. **********************************************************************************/
    24. 

  24. 

  25. if (!defined('SMF'))
    26. 

  26. 	die('Hacking attempt...');
    27. 

  27. 

  28. /*	These functions are here for searching, and they are:
    29. 

    30. 

  30. 	void PlushSearch1()
    31. 

  31. 		- shows the screen to search forum posts (action=search), and uses the
    32. 

  32. 		  simple version if the simpleSearch setting is enabled.
    33. 

  33. 		- uses the main sub template of the Search template.
    34. 

  34. 		- uses the Search language file.
    35. 

  35. 		- requires the search_posts permission.
    36. 

  36. 		- decodes and loads search parameters given in the URL (if any).
    37. 

  37. 		- the form redirects to index.php?action=search2.
    38. 

    39. 

  39. 	void PlushSearch2()
    40. 

  40. 		- checks user input and searches the messages table for messages
    41. 

  41. 		  matching the query.
    42. 

  42. 		- requires the search_posts permission.
    43. 

  43. 		- uses the results sub template of the Search template.
    44. 

  44. 		- uses the Search language file.
    45. 

  45. 		- stores the results into the search cache.
    46. 

  46. 		- show the results of the search query.
    47. 

    48. 

  48. 	array prepareSearchContext(bool reset = false)
    49. 

  49. 		- callback function for the results sub template.
    50. 

  50. 		- loads the necessary contextual data to show a search result.
    51. 

    52. 

  52. 	int searchSort(string $wordA, string $wordB)
    53. 

  53. 		- callback function for usort used to sort the fulltext results.
    54. 

  54. 		- passes sorting duty to the current API.
    55. 

  55. */
    56. 

  56. 

  57. // This defines two version types for checking the API's are compatible with this version of SMF.
    58. 

  58. $GLOBALS['search_versions'] = array(
    59. 

  59. 	// This is the forum version but is repeated due to some people rewriting $forum_version.
    60. 

  60. 	'forum_version' => 'SMF 2.0 RC2',
    61. 

  61. 	// This is the minimum version of SMF that an API could have been written for to work. (strtr to stop accidentally updating version on release)
    62. 

  62. 	'search_version' => strtr('SMF 2+0=Beta=2', array('+' => '.', '=' => ' ')),
    63. 

  63. );
    64. 

  64. 

  65. // Ask the user what they want to search for.
    66. 

  66. function PlushSearch1()
    67. 

  67. {
    68. 

  68. 	global $txt, $scripturl, $modSettings, $user_info, $context, $smcFunc, $sourcedir;
    69. 

  69. 

  70. 	// Is the load average too high to allow searching just now?
    71. 

  71. 	if (!empty($context['load_average']) && !empty($modSettings['loadavg_search']) && $context['load_average'] >= $modSettings['loadavg_search'])
    72. 

  72. 		fatal_lang_error('loadavg_search_disabled', false);
    73. 

  73. 

  74. 	loadLanguage('Search');
    75. 

  75. 	// Don't load this in XML mode.
    76. 

  76. 	if (!isset($_REQUEST['xml']))
    77. 

  77. 		loadTemplate('Search');
    78. 

  78. 

  79. 	// Check the user's permissions.
    80. 

  80. 	isAllowedTo('search_posts');
    81. 

  81. 

  82. 	// Link tree....
    83. 

  83. 	$context['linktree'][] = array(
    84. 

  84. 		'url' => $scripturl . '?action=search',
    85. 

  85. 		'name' => $txt['search']
    86. 

  86. 	);
    87. 

  87. 

  88. 	// This is hard coded maximum string length.
    89. 

  89. 	$context['search_string_limit'] = 100;
    90. 

  90. 

  91. 	$context['require_verification'] = $user_info['is_guest'] && !empty($modSettings['search_enable_captcha']) && empty($_SESSION['ss_vv_passed']);
    92. 

  92. 	if ($context['require_verification'])
    93. 

  93. 	{
    94. 

  94. 		require_once($sourcedir . '/Subs-Editor.php');
    95. 

  95. 		$verificationOptions = array(
    96. 

  96. 			'id' => 'search',
    97. 

  97. 		);
    98. 

  98. 		$context['require_verification'] = create_control_verification($verificationOptions);
    99. 

  99. 		$context['visual_verification_id'] = $verificationOptions['id'];
    100. 

  100. 	}
    101. 

  101. 

  102. 	// If you got back from search2 by using the linktree, you get your original search parameters back.
    103. 

  103. 	if (isset($_REQUEST['params']))
    104. 

  104. 	{
    105. 

  105. 		$temp_params = explode('|"|', base64_decode(strtr($_REQUEST['params'], array(' ' => '+'))));
    106. 

  106. 		$context['search_params'] = array();
    107. 

  107. 		foreach ($temp_params as $i => $data)
    108. 

  108. 		{
    109. 

  109. 			@list ($k, $v) = explode('|\'|', $data);
    110. 

  110. 			$context['search_params'][$k] = $v;
    111. 

  111. 		}
    112. 

  112. 		if (isset($context['search_params']['brd']))
    113. 

  113. 			$context['search_params']['brd'] = $context['search_params']['brd'] == '' ? array() : explode(',', $context['search_params']['brd']);
    114. 

  114. 	}
    115. 

  115. 	if (isset($_REQUEST['search']))
    116. 

  116. 		$context['search_params']['search'] = un_htmlspecialchars($_REQUEST['search']);
    117. 

  117. 

  118. 	if (isset($context['search_params']['search']))
    119. 

  119. 		$context['search_params']['search'] = htmlspecialchars($context['search_params']['search']);
    120. 

  120. 	if (isset($context['search_params']['userspec']))
    121. 

  121. 		$context['search_params']['userspec'] = htmlspecialchars($context['search_params']['userspec']);
    122. 

  122. 	if (!empty($context['search_params']['searchtype']))
    123. 

  123. 		$context['search_params']['searchtype'] = 2;
    124. 

  124. 	if (!empty($context['search_params']['minage']))
    125. 

  125. 		$context['search_params']['minage'] = (int) $context['search_params']['minage'];
    126. 

  126. 	if (!empty($context['search_params']['maxage']))
    127. 

  127. 		$context['search_params']['maxage'] = (int) $context['search_params']['maxage'];
    128. 

  128. 

  129. 	$context['search_params']['show_complete'] = !empty($context['search_params']['show_complete']);
    130. 

  130. 	$context['search_params']['subject_only'] = !empty($context['search_params']['subject_only']);
    131. 

  131. 

  132. 	// Load the error text strings if there were errors in the search.
    133. 

  133. 	if (!empty($context['search_errors']))
    134. 

  134. 	{
    135. 

  135. 		loadLanguage('Errors');
    136. 

  136. 		$context['search_errors']['messages'] = array();
    137. 

  137. 		foreach ($context['search_errors'] as $search_error => $dummy)
    138. 

  138. 		{
    139. 

  139. 			if ($search_error === 'messages')
    140. 

  140. 				continue;
    141. 

  141. 

  142. 			$context['search_errors']['messages'][] = $txt['error_' . $search_error];
    143. 

  143. 		}
    144. 

  144. 	}
    145. 

  145. 

  146. 	// Find all the boards this user is allowed to see.
    147. 

  147. 	$request = $smcFunc['db_query']('order_by_board_order', '
    148. 

  148. 		SELECT b.id_cat, c.name AS cat_name, b.id_board, b.name, b.child_level
    149. 

  149. 		FROM {db_prefix}boards AS b
    150. 

  150. 			LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
    151. 

  151. 		WHERE {query_see_board}',
    152. 

  152. 		array(
    153. 

  153. 		)
    154. 

  154. 	);
    155. 

  155. 	$context['num_boards'] = $smcFunc['db_num_rows']($request);
    156. 

  156. 	$context['boards_check_all'] = true;
    157. 

  157. 	$context['categories'] = array();
    158. 

  158. 	while ($row = $smcFunc['db_fetch_assoc']($request))
    159. 

  159. 	{
    160. 

  160. 		// This category hasn't been set up yet..
    161. 

  161. 		if (!isset($context['categories'][$row['id_cat']]))
    162. 

  162. 			$context['categories'][$row['id_cat']] = array(
    163. 

  163. 				'id' => $row['id_cat'],
    164. 

  164. 				'name' => $row['cat_name'],
    165. 

  165. 				'boards' => array()
    166. 

  166. 			);
    167. 

  167. 

  168. 		// Set this board up, and let the template know when it's a child.  (indent them..)
    169. 

  169. 		$context['categories'][$row['id_cat']]['boards'][$row['id_board']] = array(
    170. 

  170. 			'id' => $row['id_board'],
    171. 

  171. 			'name' => $row['name'],
    172. 

  172. 			'child_level' => $row['child_level'],
    173. 

  173. 			'selected' => (empty($context['search_params']['brd']) && (empty($modSettings['recycle_enable']) || $row['id_board'] != $modSettings['recycle_board']) && !in_array($row['id_board'], $user_info['ignoreboards'])) || (!empty($context['search_params']['brd']) && in_array($row['id_board'], $context['search_params']['brd']))
    174. 

  174. 		);
    175. 

  175. 

  176. 		// If a board wasn't checked that probably should have been ensure the board selection is selected, yo!
    177. 

  177. 		if (!$context['categories'][$row['id_cat']]['boards'][$row['id_board']]['selected'] && (empty($modSettings['recycle_enable']) || $row['id_board'] != $modSettings['recycle_board']))
    178. 

  178. 			$context['boards_check_all'] = false;
    179. 

  179. 	}
    180. 

  180. 	$smcFunc['db_free_result']($request);
    181. 

  181. 

  182. 	// Now, let's sort the list of categories into the boards for templates that like that.
    183. 

  183. 	$temp_boards = array();
    184. 

  184. 	foreach ($context['categories'] as $category)
    185. 

  185. 	{
    186. 

  186. 		$temp_boards[] = array(
    187. 

  187. 			'name' => $category['name'],
    188. 

  188. 			'child_ids' => array_keys($category['boards'])
    189. 

  189. 		);
    190. 

  190. 		$temp_boards = array_merge($temp_boards, array_values($category['boards']));
    191. 

  191. 

  192. 		// Include a list of boards per category for easy toggling.
    193. 

  193. 		$context['categories'][$category['id']]['child_ids'] = array_keys($category['boards']);
    194. 

  194. 	}
    195. 

  195. 

  196. 	$max_boards = ceil(count($temp_boards) / 2);
    197. 

  197. 	if ($max_boards == 1)
    198. 

  198. 		$max_boards = 2;
    199. 

  199. 

  200. 	// Now, alternate them so they can be shown left and right ;).
    201. 

  201. 	$context['board_columns'] = array();
    202. 

  202. 	for ($i = 0; $i < $max_boards; $i++)
    203. 

  203. 	{
    204. 

  204. 		$context['board_columns'][] = $temp_boards[$i];
    205. 

  205. 		if (isset($temp_boards[$i + $max_boards]))
    206. 

  206. 			$context['board_columns'][] = $temp_boards[$i + $max_boards];
    207. 

  207. 		else
    208. 

  208. 			$context['board_columns'][] = array();
    209. 

  209. 	}
    210. 

  210. 

  211. 	if (!empty($_REQUEST['topic']))
    212. 

  212. 	{
    213. 

  213. 		$context['search_params']['topic'] = (int) $_REQUEST['topic'];
    214. 

  214. 		$context['search_params']['show_complete'] = true;
    215. 

  215. 	}
    216. 

  216. 	if (!empty($context['search_params']['topic']))
    217. 

  217. 	{
    218. 

  218. 		$context['search_params']['topic'] = (int) $context['search_params']['topic'];
    219. 

  219. 

  220. 		$context['search_topic'] = array(
    221. 

  221. 			'id' => $context['search_params']['topic'],
    222. 

  222. 			'href' => $scripturl . '?topic=' . $context['search_params']['topic'] . '.0',
    223. 

  223. 		);
    224. 

  224. 

  225. 		$request = $smcFunc['db_query']('', '
    226. 

  226. 			SELECT ms.subject
    227. 

  227. 			FROM {db_prefix}topics AS t
    228. 

  228. 				INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
    229. 

  229. 				INNER JOIN {db_prefix}messages AS ms ON (ms.id_msg = t.id_first_msg)
    230. 

  230. 			WHERE t.id_topic = {int:search_topic_id}
    231. 

  231. 				AND {query_see_board}' . ($modSettings['postmod_active'] ? '
    232. 

  232. 				AND t.approved = {int:is_approved_true}' : '') . '
    233. 

  233. 			LIMIT 1',
    234. 

  234. 			array(
    235. 

  235. 				'is_approved_true' => 1,
    236. 

  236. 				'search_topic_id' => $context['search_params']['topic'],
    237. 

  237. 			)
    238. 

  238. 		);
    239. 

  239. 

  240. 		if ($smcFunc['db_num_rows']($request) == 0)
    241. 

  241. 			fatal_lang_error('topic_gone', false);
    242. 

  242. 

  243. 		list ($context['search_topic']['subject']) = $smcFunc['db_fetch_row']($request);
    244. 

  244. 		$smcFunc['db_free_result']($request);
    245. 

  245. 

  246. 		$context['search_topic']['link'] = '<a href="' . $context['search_topic']['href'] . '">' . $context['search_topic']['subject'] . '</a>';
    247. 

  247. 	}
    248. 

  248. 

  249. 	// Simple or not?
    250. 

  250. 	$context['simple_search'] = isset($context['search_params']['advanced']) ? empty($context['search_params']['advanced']) : !empty($modSettings['simpleSearch']) && !isset($_REQUEST['advanced']);
    251. 

  251. 	$context['page_title'] = $txt['set_parameters'];
    252. 

  252. }
    253. 

  253. 

  254. // Gather the results and show them.
    255. 

  255. function PlushSearch2()
    256. 

  256. {
    257. 

  257. 	global $scripturl, $modSettings, $sourcedir, $txt, $db_connection;
    258. 

  258. 	global $user_info, $context, $options, $messages_request, $boards_can;
    259. 

  259. 	global $excludedWords, $participants, $smcFunc, $search_versions, $searchAPI;
    260. 

  260. 

  261. 	if (!empty($context['load_average']) && !empty($modSettings['loadavg_search']) && $context['load_average'] >= $modSettings['loadavg_search'])
    262. 

  262. 		fatal_lang_error('loadavg_search_disabled', false);
    263. 

  263. 

  264. 	// No, no, no... this is a bit hard on the server, so don't you go prefetching it!
    265. 

  265. 	if (isset($_SERVER['HTTP_X_MOZ']) && $_SERVER['HTTP_X_MOZ'] == 'prefetch')
    266. 

  266. 	{
    267. 

  267. 		ob_end_clean();
    268. 

  268. 		header('HTTP/1.1 403 Forbidden');
    269. 

  269. 		die;
    270. 

  270. 	}
    271. 

  271. 

  272. 	$weight_factors = array(
    273. 

  273. 		'frequency',
    274. 

  274. 		'age',
    275. 

  275. 		'length',
    276. 

  276. 		'subject',
    277. 

  277. 		'first_message',
    278. 

  278. 		'sticky',
    279. 

  279. 	);
    280. 

  280. 

  281. 	$weight = array();
    282. 

  282. 	$weight_total = 0;
    283. 

  283. 	foreach ($weight_factors as $weight_factor)
    284. 

  284. 	{
    285. 

  285. 		$weight[$weight_factor] = empty($modSettings['search_weight_' . $weight_factor]) ? 0 : (int) $modSettings['search_weight_' . $weight_factor];
    286. 

  286. 		$weight_total += $weight[$weight_factor];
    287. 

  287. 	}
    288. 

  288. 

  289. 	// Zero weight.  Weightless :P.
    290. 

  290. 	if (empty($weight_total))
    291. 

  291. 		fatal_lang_error('search_invalid_weights');
    292. 

  292. 

  293. 	// These vars don't require an interface, they're just here for tweaking.
    294. 

  294. 	$recentPercentage = 0.30;
    295. 

  295. 	$humungousTopicPosts = 200;
    296. 

  296. 	$maxMembersToSearch = 500;
    297. 

  297. 	$maxMessageResults = empty($modSettings['search_max_results']) ? 0 : $modSettings['search_max_results'] * 5;
    298. 

  298. 

  299. 	// Start with no errors.
    300. 

  300. 	$context['search_errors'] = array();
    301. 

  301. 

  302. 	// Number of pages hard maximum - normally not set at all.
    303. 

  303. 	$modSettings['search_max_results'] = empty($modSettings['search_max_results']) ? 200 * $modSettings['search_results_per_page'] : (int) $modSettings['search_max_results'];
    304. 

  304. 	// Maximum length of the string.
    305. 

  305. 	$context['search_string_limit'] = 100;
    306. 

  306. 

  307. 	loadLanguage('Search');
    308. 

  308. 	if (!isset($_REQUEST['xml']))
    309. 

  309. 		loadTemplate('Search');
    310. 

  310. 	//If we're doing XML we need to use the results template regardless really.
    311. 

  311. 	else
    312. 

  312. 		$context['sub_template'] = 'results';
    313. 

  313. 

  314. 	// Are you allowed?
    315. 

  315. 	isAllowedTo('search_posts');
    316. 

  316. 

  317. 	require_once($sourcedir . '/Display.php');
    318. 

  318. 

  319. 	// Search has a special database set.
    320. 

  320. 	db_extend('search');
    321. 

  321. 

  322. 	// Load up the search API we are going to use.
    323. 

  323. 	$modSettings['search_index'] = empty($modSettings['search_index']) ? 'standard' : $modSettings['search_index'];
    324. 

  324. 	if (!file_exists($sourcedir . '/SearchAPI-' . ucwords($modSettings['search_index']) . '.php'))
    325. 

  325. 		fatal_lang_error('search_api_missing');
    326. 

  326. 	loadClassFile('SearchAPI-' . ucwords($modSettings['search_index']) . '.php');
    327. 

  327. 

  328. 	// Create an instance of the search API and check it is valid for this version of SMF.
    329. 

  329. 	$search_class_name = $modSettings['search_index'] . '_search';
    330. 

  330. 	$searchAPI = new $search_class_name();
    331. 

  331. 	if (!$searchAPI || ($searchAPI->supportsMethod('isValid') && !$searchAPI->isValid()) || $search_versions['forum_version'] < $searchAPI->min_smf_version || $search_versions['search_version'] > $searchAPI->version_compatible)
    332. 

  332. 	{
    333. 

  333. 		// Log the error.
    334. 

  334. 		loadLanguage('Errors');
    335. 

  335. 		log_error(sprintf($txt['search_api_not_compatible'], 'SearchAPI-' . ucwords($modSettings['search_index']) . '.php'), 'critical');
    336. 

  336. 

  337. 		loadClassFile('SearchAPI-Standard.php');
    338. 

  338. 		$searchAPI = new standard_search();
    339. 

  339. 	}
    340. 

  340. 

  341. 	// $search_params will carry all settings that differ from the default search parameters.
    342. 

  342. 	// That way, the URLs involved in a search page will be kept as short as possible.
    343. 

  343. 	$search_params = array();
    344. 

  344. 

  345. 	if (isset($_REQUEST['params']))
    346. 

  346. 	{
    347. 

  347. 		$temp_params = explode('|"|', base64_decode(strtr($_REQUEST['params'], array(' ' => '+'))));
    348. 

  348. 		foreach ($temp_params as $i => $data)
    349. 

  349. 		{
    350. 

  350. 			@list ($k, $v) = explode('|\'|', $data);
    351. 

  351. 			$search_params[$k] = $v;
    352. 

  352. 		}
    353. 

  353. 		if (isset($search_params['brd']))
    354. 

  354. 			$search_params['brd'] = empty($search_params['brd']) ? array() : explode(',', $search_params['brd']);
    355. 

  355. 	}
    356. 

  356. 

  357. 	// Store whether simple search was used (needed if the user wants to do another query).
    358. 

  358. 	if (!isset($search_params['advanced']))
    359. 

  359. 		$search_params['advanced'] = empty($_REQUEST['advanced']) ? 0 : 1;
    360. 

  360. 

  361. 	// 1 => 'allwords' (default, don't set as param) / 2 => 'anywords'.
    362. 

  362. 	if (!empty($search_params['searchtype']) || (!empty($_REQUEST['searchtype']) && $_REQUEST['searchtype'] == 2))
    363. 

  363. 		$search_params['searchtype'] = 2;
    364. 

  364. 

  365. 	// Minimum age of messages. Default to zero (don't set param in that case).
    366. 

  366. 	if (!empty($search_params['minage']) || (!empty($_REQUEST['minage']) && $_REQUEST['minage'] > 0))
    367. 

  367. 		$search_params['minage'] = !empty($search_params['minage']) ? (int) $search_params['minage'] : (int) $_REQUEST['minage'];
    368. 

  368. 

  369. 	// Maximum age of messages. Default to infinite (9999 days: param not set).
    370. 

  370. 	if (!empty($search_params['maxage']) || (!empty($_REQUEST['maxage']) && $_REQUEST['maxage'] < 9999))
    371. 

  371. 		$search_params['maxage'] = !empty($search_params['maxage']) ? (int) $search_params['maxage'] : (int) $_REQUEST['maxage'];
    372. 

  372. 

  373. 	// Searching a specific topic?
    374. 

  374. 	if (!empty($_REQUEST['topic']))
    375. 

  375. 	{
    376. 

  376. 		$search_params['topic'] = (int) $_REQUEST['topic'];
    377. 

  377. 		$search_params['show_complete'] = true;
    378. 

  378. 	}
    379. 

  379. 	elseif (!empty($search_params['topic']))
    380. 

  380. 		$search_params['topic'] = (int) $search_params['topic'];
    381. 

  381. 

  382. 	if (!empty($search_params['minage']) || !empty($search_params['maxage']))
    383. 

  383. 	{
    384. 

  384. 		$request = $smcFunc['db_query']('', '
    385. 

  385. 			SELECT ' . (empty($search_params['maxage']) ? '0, ' : 'IFNULL(MIN(id_msg), -1), ') . (empty($search_params['minage']) ? '0' : 'IFNULL(MAX(id_msg), -1)') . '
    386. 

  386. 			FROM {db_prefix}messages
    387. 

  387. 			WHERE 1=1' . ($modSettings['postmod_active'] ? '
    388. 

  388. 				AND approved = {int:is_approved_true}' : '') . (empty($search_params['minage']) ? '' : '
    389. 

  389. 				AND poster_time <= {int:timestamp_minimum_age}') . (empty($search_params['maxage']) ? '' : '
    390. 

  390. 				AND poster_time >= {int:timestamp_maximum_age}'),
    391. 

  391. 			array(
    392. 

  392. 				'timestamp_minimum_age' => empty($search_params['minage']) ? 0 : time() - 86400 * $search_params['minage'],
    393. 

  393. 				'timestamp_maximum_age' => empty($search_params['maxage']) ? 0 : time() - 86400 * $search_params['maxage'],
    394. 

  394. 				'is_approved_true' => 1,
    395. 

  395. 			)
    396. 

  396. 		);
    397. 

  397. 		list ($minMsgID, $maxMsgID) = $smcFunc['db_fetch_row']($request);
    398. 

  398. 		if ($minMsgID < 0 || $maxMsgID < 0)
    399. 

  399. 			$context['search_errors']['no_messages_in_time_frame'] = true;
    400. 

  400. 		$smcFunc['db_free_result']($request);
    401. 

  401. 	}
    402. 

  402. 

  403. 	// Default the user name to a wildcard matching every user (*).
    404. 

  404. 	if (!empty($search_params['userspec']) || (!empty($_REQUEST['userspec']) && $_REQUEST['userspec'] != '*'))
    405. 

  405. 		$search_params['userspec'] = isset($search_params['userspec']) ? $search_params['userspec'] : $_REQUEST['userspec'];
    406. 

  406. 

  407. 	// If there's no specific user, then don't mention it in the main query.
    408. 

  408. 	if (empty($search_params['userspec']))
    409. 

  409. 		$userQuery = '';
    410. 

  410. 	else
    411. 

  411. 	{
    412. 

  412. 		$userString = strtr($smcFunc['htmlspecialchars']($search_params['userspec'], ENT_QUOTES), array('&quot;' => '"'));
    413. 

  413. 		$userString = strtr($userString, array('%' => '\%', '_' => '\_', '*' => '%', '?' => '_'));
    414. 

  414. 

  415. 		preg_match_all('~"([^"]+)"~', $userString, $matches);
    416. 

  416. 		$possible_users = array_merge($matches[1], explode(',', preg_replace('~"[^"]+"~', '', $userString)));
    417. 

  417. 

  418. 		for ($k = 0, $n = count($possible_users); $k < $n; $k++)
    419. 

  419. 		{
    420. 

  420. 			$possible_users[$k] = trim($possible_users[$k]);
    421. 

  421. 

  422. 			if (strlen($possible_users[$k]) == 0)
    423. 

  423. 				unset($possible_users[$k]);
    424. 

  424. 		}
    425. 

  425. 

  426. 		// Create a list of database-escaped search names.
    427. 

  427. 		$realNameMatches = array();
    428. 

  428. 		foreach ($possible_users as $possible_user)
    429. 

  429. 			$realNameMatches[] = $smcFunc['db_quote'](
    430. 

  430. 				'{string:possible_user}',
    431. 

  431. 				array(
    432. 

  432. 					'possible_user' => $possible_user
    433. 

  433. 				)
    434. 

  434. 			);
    435. 

  435. 

  436. 		// Retrieve a list of possible members.
    437. 

  437. 		$request = $smcFunc['db_query']('', '
    438. 

  438. 			SELECT id_member
    439. 

  439. 			FROM {db_prefix}members
    440. 

  440. 			WHERE {raw:match_possible_users}',
    441. 

  441. 			array(
    442. 

  442. 				'match_possible_users' => 'real_name LIKE ' . implode(' OR real_name LIKE ', $realNameMatches),
    443. 

  443. 			)
    444. 

  444. 		);
    445. 

  445. 		// Simply do nothing if there're too many members matching the criteria.
    446. 

  446. 		if ($smcFunc['db_num_rows']($request) > $maxMembersToSearch)
    447. 

  447. 			$userQuery = '';
    448. 

  448. 		elseif ($smcFunc['db_num_rows']($request) == 0)
    449. 

  449. 		{
    450. 

  450. 			$userQuery = $smcFunc['db_quote'](
    451. 

  451. 				'm.id_member = {int:id_member_guest} AND ({raw:match_possible_guest_names})',
    452. 

  452. 				array(
    453. 

  453. 					'id_member_guest' => 0,
    454. 

  454. 					'match_possible_guest_names' => 'm.poster_name LIKE ' . implode(' OR m.poster_name LIKE ', $realNameMatches),
    455. 

  455. 				)
    456. 

  456. 			);
    457. 

  457. 		}
    458. 

  458. 		else
    459. 

  459. 		{
    460. 

  460. 			$memberlist = array();
    461. 

  461. 			while ($row = $smcFunc['db_fetch_assoc']($request))
    462. 

  462. 				$memberlist[] = $row['id_member'];
    463. 

  463. 			$userQuery = $smcFunc['db_quote'](
    464. 

  464. 				'(m.id_member IN ({array_int:matched_members}) OR (m.id_member = {int:id_member_guest} AND ({raw:match_possible_guest_names})))',
    465. 

  465. 				array(
    466. 

  466. 					'matched_members' => $memberlist,
    467. 

  467. 					'id_member_guest' => 0,
    468. 

  468. 					'match_possible_guest_names' => 'm.poster_name LIKE ' . implode(' OR m.poster_name LIKE ', $realNameMatches),
    469. 

  469. 				)
    470. 

  470. 			);
    471. 

  471. 		}
    472. 

  472. 		$smcFunc['db_free_result']($request);
    473. 

  473. 	}
    474. 

  474. 

  475. 	// If the boards were passed by URL (params=), temporarily put them back in $_REQUEST.
    476. 

  476. 	if (!empty($search_params['brd']) && is_array($search_params['brd']))
    477. 

  477. 		$_REQUEST['brd'] = $search_params['brd'];
    478. 

  478. 

  479. 	// Ensure that brd is an array.
    480. 

  480. 	if (!empty($_REQUEST['brd']) && !is_array($_REQUEST['brd']))
    481. 

  481. 		$_REQUEST['brd'] = strpos($_REQUEST['brd'], ',') !== false ? explode(',', $_REQUEST['brd']) : array($_REQUEST['brd']);
    482. 

  482. 

  483. 	// Make sure all boards are integers.
    484. 

  484. 	if (!empty($_REQUEST['brd']))
    485. 

  485. 		foreach ($_REQUEST['brd'] as $id => $brd)
    486. 

  486. 			$_REQUEST['brd'][$id] = (int) $brd;
    487. 

  487. 

  488. 	// Special case for boards: searching just one topic?
    489. 

  489. 	if (!empty($search_params['topic']))
    490. 

  490. 	{
    491. 

  491. 		$request = $smcFunc['db_query']('', '
    492. 

  492. 			SELECT b.id_board
    493. 

  493. 			FROM {db_prefix}topics AS t
    494. 

  494. 				INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
    495. 

  495. 			WHERE t.id_topic = {int:search_topic_id}
    496. 

  496. 				AND {query_see_board}' . ($modSettings['postmod_active'] ? '
    497. 

  497. 				AND t.approved = {int:is_approved_true}' : '') . '
    498. 

  498. 			LIMIT 1',
    499. 

  499. 			array(
    500. 

  500. 				'search_topic_id' => $search_params['topic'],
    501. 

  501. 				'is_approved_true' => 1,
    502. 

  502. 			)
    503. 

  503. 		);
    504. 

  504. 

  505. 		if ($smcFunc['db_num_rows']($request) == 0)
    506. 

  506. 			fatal_lang_error('topic_gone', false);
    507. 

  507. 

  508. 		$search_params['brd'] = array();
    509. 

  509. 		list ($search_params['brd'][0]) = $smcFunc['db_fetch_row']($request);
    510. 

  510. 		$smcFunc['db_free_result']($request);
    511. 

  511. 	}
    512. 

  512. 	// Select all boards you've selected AND are allowed to see.
    513. 

  513. 	elseif ($user_info['is_admin'] && (!empty($search_params['advanced']) || !empty($_REQUEST['brd'])))
    514. 

  514. 		$search_params['brd'] = empty($_REQUEST['brd']) ? array() : $_REQUEST['brd'];
    515. 

  515. 	else
    516. 

  516. 	{
    517. 

  517. 		$see_board = empty($search_params['advanced']) ? 'query_wanna_see_board' : 'query_see_board';
    518. 

  518. 		$request = $smcFunc['db_query']('', '
    519. 

  519. 			SELECT b.id_board
    520. 

  520. 			FROM {db_prefix}boards AS b
    521. 

  521. 			WHERE {raw:boards_allowed_to_see}' . (empty($_REQUEST['brd']) ? (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
    522. 

  522. 				AND b.id_board != {int:recycle_board_id}' : '') : '
    523. 

  523. 				AND b.id_board IN ({array_int:selected_search_boards})'),
    524. 

  524. 			array(
    525. 

  525. 				'boards_allowed_to_see' => $user_info[$see_board],
    526. 

  526. 				'selected_search_boards' => empty($_REQUEST['brd']) ? array() : $_REQUEST['brd'],
    527. 

  527. 				'recycle_board_id' => $modSettings['recycle_board'],
    528. 

  528. 			)
    529. 

  529. 		);
    530. 

  530. 		$search_params['brd'] = array();
    531. 

  531. 		while ($row = $smcFunc['db_fetch_assoc']($request))
    532. 

  532. 			$search_params['brd'][] = $row['id_board'];
    533. 

  533. 		$smcFunc['db_free_result']($request);
    534. 

  534. 

  535. 		// This error should pro'bly only happen for hackers.
    536. 

  536. 		if (empty($search_params['brd']))
    537. 

  537. 			$context['search_errors']['no_boards_selected'] = true;
    538. 

  538. 	}
    539. 

  539. 

  540. 	if (count($search_params['brd']) != 0)
    541. 

  541. 	{
    542. 

  542. 		foreach ($search_params['brd'] as $k => $v)
    543. 

  543. 			$search_params['brd'][$k] = (int) $v;
    544. 

  544. 

  545. 		// If we've selected all boards, this parameter can be left empty.
    546. 

  546. 		$request = $smcFunc['db_query']('', '
    547. 

  547. 			SELECT COUNT(*)
    548. 

  548. 			FROM {db_prefix}boards',
    549. 

  549. 			array(
    550. 

  550. 			)
    551. 

  551. 		);
    552. 

  552. 		list ($num_boards) = $smcFunc['db_fetch_row']($request);
    553. 

  553. 		$smcFunc['db_free_result']($request);
    554. 

  554. 

  555. 		if (count($search_params['brd']) == $num_boards)
    556. 

  556. 			$boardQuery = '';
    557. 

  557. 		elseif (count($search_params['brd']) == $num_boards - 1 && !empty($modSettings['recycle_board']) && !in_array($modSettings['recycle_board'], $search_params['brd']))
    558. 

  558. 			$boardQuery = '!= ' . $modSettings['recycle_board'];
    559. 

  559. 		else
    560. 

  560. 			$boardQuery = 'IN (' . implode(', ', $search_params['brd']) . ')';
    561. 

  561. 	}
    562. 

  562. 	else
    563. 

  563. 		$boardQuery = '';
    564. 

  564. 

  565. 	$search_params['show_complete'] = !empty($search_params['show_complete']) || !empty($_REQUEST['show_complete']);
    566. 

  566. 	$search_params['subject_only'] = !empty($search_params['subject_only']) || !empty($_REQUEST['subject_only']);
    567. 

  567. 

  568. 	$context['compact'] = !$search_params['show_complete'];
    569. 

  569. 

  570. 	// Get the sorting parameters right. Default to sort by relevance descending.
    571. 

  571. 	$sort_columns = array(
    572. 

  572. 		'relevance',
    573. 

  573. 		'num_replies',
    574. 

  574. 		'id_msg',
    575. 

  575. 	);
    576. 

  576. 	if (empty($search_params['sort']) && !empty($_REQUEST['sort']))
    577. 

  577. 		list ($search_params['sort'], $search_params['sort_dir']) = array_pad(explode('|', $_REQUEST['sort']), 2, '');
    578. 

  578. 	$search_params['sort'] = !empty($search_params['sort']) && in_array($search_params['sort'], $sort_columns) ? $search_params['sort'] : 'relevance';
    579. 

  579. 	if (!empty($search_params['topic']) && $search_params['sort'] === 'num_replies')
    580. 

  580. 		$search_params['sort'] = 'id_msg';
    581. 

  581. 

  582. 	// Sorting direction: descending unless stated otherwise.
    583. 

  583. 	$search_params['sort_dir'] = !empty($search_params['sort_dir']) && $search_params['sort_dir'] == 'asc' ? 'asc' : 'desc';
    584. 

  584. 

  585. 	// Determine some values needed to calculate the relevance.
    586. 

  586. 	$minMsg = (int) ((1 - $recentPercentage) * $modSettings['maxMsgID']);
    587. 

  587. 	$recentMsg = $modSettings['maxMsgID'] - $minMsg;
    588. 

  588. 

  589. 

  590. 	// *** Parse the search query
    591. 

  591. 

  592. 	// Unfortunately, searching for words like this is going to be slow, so we're blacklisting them.
    593. 

  593. 	// !!! Setting to add more here?
    594. 

  594. 	// !!! Maybe only blacklist if they are the only word, or "any" is used?
    595. 

  595. 	$blacklisted_words = array('img', 'url', 'quote', 'www', 'http', 'the', 'is', 'it', 'are', 'if');
    596. 

  596. 

  597. 	// What are we searching for?
    598. 

  598. 	if (empty($search_params['search']))
    599. 

  599. 	{
    600. 

  600. 		if (isset($_GET['search']))
    601. 

  601. 			$search_params['search'] = un_htmlspecialchars($_GET['search']);
    602. 

  602. 		elseif (isset($_POST['search']))
    603. 

  603. 			$search_params['search'] = $_POST['search'];
    604. 

  604. 		else
    605. 

  605. 			$search_params['search'] = '';
    606. 

  606. 	}
    607. 

  607. 

  608. 	// Nothing??
    609. 

  609. 	if (!isset($search_params['search']) || $search_params['search'] == '')
    610. 

  610. 		$context['search_errors']['invalid_search_string'] = true;
    611. 

  611. 	// Too long?
    612. 

  612. 	elseif ($smcFunc['strlen']($search_params['search']) > $context['search_string_limit'])
    613. 

  613. 	{
    614. 

  614. 		$context['search_errors']['string_too_long'] = true;
    615. 

  615. 		$txt['error_string_too_long'] = sprintf($txt['error_string_too_long'], $context['search_string_limit']);
    616. 

  616. 	}
    617. 

  617. 

  618. 	// Change non-word characters into spaces.
    619. 

  619. 	$stripped_query = preg_replace('~(?:[\x0B\0' . ($context['utf8'] ? ($context['server']['complex_preg_chars'] ? '\x{A0}' : "\xC2\xA0") : '\xA0') . '\t\r\s\n(){}\\[\\]<>!@$%^*.,:+=`\~\?/\\\\]+|&(?:amp|lt|gt|quot);)+~' . ($context['utf8'] ? 'u' : ''), ' ', $search_params['search']);
    620. 

  620. 

  621. 	// Make the query lower case. It's gonna be case insensitive anyway.
    622. 

  622. 	$stripped_query = un_htmlspecialchars($smcFunc['strtolower']($stripped_query));
    623. 

  623. 

  624. 	// This (hidden) setting will do fulltext searching in the most basic way.
    625. 

  625. 	if (!empty($modSettings['search_simple_fulltext']))
    626. 

  626. 		$stripped_query = strtr($stripped_query, array('"' => ''));
    627. 

  627. 

  628. 	$no_regexp = preg_match('~&#(?:\d{1,7}|x[0-9a-fA-F]{1,6});~', $stripped_query) === 1;
    629. 

  629. 

  630. 	// Extract phrase parts first (e.g. some words "this is a phrase" some more words.)
    631. 

  631. 	preg_match_all('/(?:^|\s)([-]?)"([^"]+)"(?:$|\s)/', $stripped_query, $matches, PREG_PATTERN_ORDER);
    632. 

  632. 	$phraseArray = $matches[2];
    633. 

  633. 

  634. 	// Remove the phrase parts and extract the words.
    635. 

  635. 	$wordArray = explode(' ', preg_replace('~(?:^|\s)(?:[-]?)"(?:[^"]+)"(?:$|\s)~' . ($context['utf8'] ? 'u' : ''), ' ', $search_params['search']));
    636. 

  636. 

  637. 	// A minus sign in front of a word excludes the word.... so...
    638. 

  638. 	$excludedWords = array();
    639. 

  639. 	$excludedIndexWords = array();
    640. 

  640. 	$excludedSubjectWords = array();
    641. 

  641. 	$excludedPhrases = array();
    642. 

  642. 

  643. 	// .. first, we check for things like -"some words", but not "-some words".
    644. 

  644. 	foreach ($matches[1] as $index => $word)
    645. 

  645. 		if ($word === '-')
    646. 

  646. 		{
    647. 

  647. 			if (($word = trim($phraseArray[$index], '-_\' ')) !== '' && !in_array($word, $blacklisted_words))
    648. 

  648. 				$excludedWords[] = $word;
    649. 

  649. 			unset($phraseArray[$index]);
    650. 

  650. 		}
    651. 

  651. 

  652. 	// Now we look for -test, etc.... normaller.
    653. 

  653. 	foreach ($wordArray as $index => $word)
    654. 

  654. 		if (strpos(trim($word), '-') === 0)
    655. 

  655. 		{
    656. 

  656. 			if (($word = trim($word, '-_\' ')) !== '' && !in_array($word, $blacklisted_words))
    657. 

  657. 				$excludedWords[] = $word;
    658. 

  658. 			unset($wordArray[$index]);
    659. 

  659. 		}
    660. 

  660. 

  661. 	// The remaining words and phrases are all included.
    662. 

  662. 	$searchArray = array_merge($phraseArray, $wordArray);
    663. 

  663. 

  664. 	// Trim everything and make sure there are no words that are the same.
    665. 

  665. 	foreach ($searchArray as $index => $value)
    666. 

  666. 	{
    667. 

  667. 		if (($searchArray[$index] = trim($value, '-_\' ')) === '' || in_array($searchArray[$index], $blacklisted_words))
    668. 

  668. 			unset($searchArray[$index]);
    669. 

  669. 		// Don't allow very, very short words.
    670. 

  670. 		elseif (strlen($value) < 2)
    671. 

  671. 		{
    672. 

  672. 			$context['search_errors']['search_string_small_words'] = true;
    673. 

  673. 			unset($searchArray[$index]);
    674. 

  674. 		}
    675. 

  675. 		else
    676. 

  676. 			$searchArray[$index] = $searchArray[$index];
    677. 

  677. 	}
    678. 

  678. 	$searchArray = array_slice(array_unique($searchArray), 0, 10);
    679. 

  679. 

  680. 	// Create an array of replacements for highlighting.
    681. 

  681. 	$context['mark'] = array();
    682. 

  682. 	foreach ($searchArray as $word)
    683. 

  683. 		$context['mark'][$word] = '<strong class="highlight">' . $word . '</strong>';
    684. 

  684. 

  685. 	// Initialize two arrays storing the words that have to be searched for.
    686. 

  686. 	$orParts = array();
    687. 

  687. 	$searchWords = array();
    688. 

  688. 

  689. 	// Make sure at least one word is being searched for.
    690. 

  690. 	if (empty($searchArray))
    691. 

  691. 		$context['search_errors']['invalid_search_string'] = true;
    692. 

  692. 	// All words/sentences must match.
    693. 

  693. 	elseif (empty($search_params['searchtype']))
    694. 

  694. 		$orParts[0] = $searchArray;
    695. 

  695. 	// Any word/sentence must match.
    696. 

  696. 	else
    697. 

  697. 		foreach ($searchArray as $index => $value)
    698. 

  698. 			$orParts[$index] = array($value);
    699. 

  699. 

  700. 	// Don't allow duplicate error messages if one string is too short.
    701. 

  701. 	if (isset($context['search_errors']['search_string_small_words'], $context['search_errors']['invalid_search_string']))
    702. 

  702. 		unset($context['search_errors']['invalid_search_string']);
    703. 

  703. 	// Make sure the excluded words are in all or-branches.
    704. 

  704. 	foreach ($orParts as $orIndex => $andParts)
    705. 

  705. 		foreach ($excludedWords as $word)
    706. 

  706. 			$orParts[$orIndex][] = $word;
    707. 

  707. 

  708. 	// Determine the or-branches and the fulltext search words.
    709. 

  709. 	foreach ($orParts as $orIndex => $andParts)
    710. 

  710. 	{
    711. 

  711. 		$searchWords[$orIndex] = array(
    712. 

  712. 			'indexed_words' => array(),
    713. 

  713. 			'words' => array(),
    714. 

  714. 			'subject_words' => array(),
    715. 

  715. 			'all_words' => array(),
    716. 

  716. 		);
    717. 

  717. 

  718. 		// Sort the indexed words (large words -> small words -> excluded words).
    719. 

  719. 		if ($searchAPI->supportsMethod('searchSort'))
    720. 

  720. 			usort($orParts[$orIndex], 'searchSort');
    721. 

  721. 

  722. 		foreach ($orParts[$orIndex] as $word)
    723. 

  723. 		{
    724. 

  724. 			$is_excluded = in_array($word, $excludedWords);
    725. 

  725. 

  726. 			$searchWords[$orIndex]['all_words'][] = $word;
    727. 

  727. 

  728. 			$subjectWords = text2words($word);
    729. 

  729. 			if (!$is_excluded || count($subjectWords) === 1)
    730. 

  730. 			{
    731. 

  731. 				$searchWords[$orIndex]['subject_words'] = array_merge($searchWords[$orIndex]['subject_words'], $subjectWords);
    732. 

  732. 				if ($is_excluded)
    733. 

  733. 					$excludedSubjectWords = array_merge($excludedSubjectWords, $subjectWords);
    734. 

  734. 			}
    735. 

  735. 			else
    736. 

  736. 				$excludedPhrases[] = $word;
    737. 

  737. 

  738. 			// Have we got indexes to prepare?
    739. 

  739. 			if ($searchAPI->supportsMethod('prepareIndexes'))
    740. 

  740. 				$searchAPI->prepareIndexes($word, $searchWords[$orIndex], $excludedIndexWords, $is_excluded);
    741. 

  741. 		}
    742. 

  742. 

  743. 		// Search_force_index requires all AND parts to have at least one fulltext word.
    744. 

  744. 		if (!empty($modSettings['search_force_index']) && empty($searchWords[$orIndex]['indexed_words']))
    745. 

  745. 		{
    746. 

  746. 			$context['search_errors']['query_not_specific_enough'] = true;
    747. 

  747. 			break;
    748. 

  748. 		}
    749. 

  749. 

  750. 		// Make sure we aren't searching for too many indexed words.
    751. 

  751. 		else
    752. 

  752. 		{
    753. 

  753. 			$searchWords[$orIndex]['indexed_words'] = array_slice($searchWords[$orIndex]['indexed_words'], 0, 7);
    754. 

  754. 			$searchWords[$orIndex]['subject_words'] = array_slice($searchWords[$orIndex]['subject_words'], 0, 7);
    755. 

  755. 		}
    756. 

  756. 	}
    757. 

  757. 

  758. 	// *** Spell checking
    759. 

  759. 	$context['show_spellchecking'] = !empty($modSettings['enableSpellChecking']) && function_exists('pspell_new');
    760. 

  760. 	if ($context['show_spellchecking'])
    761. 

  761. 	{
    762. 

  762. 		// Windows fix.
    763. 

  763. 		ob_start();
    764. 

  764. 		$old = error_reporting(0);
    765. 

  765. 		pspell_new('en');
    766. 

  766. 		$pspell_link = pspell_new($txt['lang_dictionary'], $txt['lang_spelling'], '', strtr($txt['lang_character_set'], array('iso-' => 'iso', 'ISO-' => 'iso')), PSPELL_FAST | PSPELL_RUN_TOGETHER);
    767. 

  767. 		error_reporting($old);
    768. 

  768. 

  769. 		if (!$pspell_link)
    770. 

  770. 			$pspell_link = pspell_new('en', '', '', '', PSPELL_FAST | PSPELL_RUN_TOGETHER);
    771. 

  771. 

  772. 		ob_end_clean();
    773. 

  773. 

  774. 		$did_you_mean = array('search' => array(), 'display' => array());
    775. 

  775. 		$found_misspelling = false;
    776. 

  776. 		foreach ($searchArray as $word)
    777. 

  777. 		{
    778. 

  778. 			if (empty($pspell_link))
    779. 

  779. 				continue;
    780. 

  780. 

  781. 			$word = $word;
    782. 

  782. 			// Don't check phrases.
    783. 

  783. 			if (preg_match('~^\w+$~', $word) === 0)
    784. 

  784. 			{
    785. 

  785. 				$did_you_mean['search'][] = '"' . $word . '"';
    786. 

  786. 				$did_you_mean['display'][] = '&quot;' . $smcFunc['htmlspecialchars']($word) . '&quot;';
    787. 

  787. 				continue;
    788. 

  788. 			}
    789. 

  789. 			// For some strange reason spell check can crash PHP on decimals.
    790. 

  790. 			elseif (preg_match('~\d~', $word) === 1)
    791. 

  791. 			{
    792. 

  792. 				$did_you_mean['search'][] = $word;
    793. 

  793. 				$did_you_mean['display'][] = $smcFunc['htmlspecialchars']($word);
    794. 

  794. 				continue;
    795. 

  795. 			}
    796. 

  796. 			elseif (pspell_check($pspell_link, $word))
    797. 

  797. 			{
    798. 

  798. 				$did_you_mean['search'][] = $word;
    799. 

  799. 				$did_you_mean['display'][] = $smcFunc['htmlspecialchars']($word);
    800. 

  800. 				continue;
    801. 

  801. 			}
    802. 

  802. 

  803. 			$suggestions = pspell_suggest($pspell_link, $word);
    804. 

  804. 			foreach ($suggestions as $i => $s)
    805. 

  805. 			{
    806. 

  806. 				// Search is case insensitive.
    807. 

  807. 				if ($smcFunc['strtolower']($s) == $smcFunc['strtolower']($word))
    808. 

  808. 					unset($suggestions[$i]);
    809. 

  809. 				// Plus, don't suggest something the user thinks is rude!
    810. 

  810. 				elseif ($suggestions[$i] != censorText($s))
    811. 

  811. 					unset($suggestions[$i]);
    812. 

  812. 			}
    813. 

  813. 

  814. 			// Anything found?  If so, correct it!
    815. 

  815. 			if (!empty($suggestions))
    816. 

  816. 			{
    817. 

  817. 				$suggestions = array_values($suggestions);
    818. 

  818. 				$did_you_mean['search'][] = $suggestions[0];
    819. 

  819. 				$did_you_mean['display'][] = '<em><strong>' . $smcFunc['htmlspecialchars']($suggestions[0]) . '</strong></em>';
    820. 

  820. 				$found_misspelling = true;
    821. 

  821. 			}
    822. 

  822. 			else
    823. 

  823. 			{
    824. 

  824. 				$did_you_mean['search'][] = $word;
    825. 

  825. 				$did_you_mean['display'][] = $smcFunc['htmlspecialchars']($word);
    826. 

  826. 			}
    827. 

  827. 		}
    828. 

  828. 

  829. 		if ($found_misspelling)
    830. 

  830. 		{
    831. 

  831. 			// Don't spell check excluded words, but add them still...
    832. 

  832. 			$temp_excluded = array('search' => array(), 'display' => array());
    833. 

  833. 			foreach ($excludedWords as $word)
    834. 

  834. 			{
    835. 

  835. 				$word = $word;
    836. 

  836. 

  837. 				if (preg_match('~^\w+$~', $word) == 0)
    838. 

  838. 				{
    839. 

  839. 					$temp_excluded['search'][] = '-"' . $word . '"';
    840. 

  840. 					$temp_excluded['display'][] = '-&quot;' . $smcFunc['htmlspecialchars']($word) . '&quot;';
    841. 

  841. 				}
    842. 

  842. 				else
    843. 

  843. 				{
    844. 

  844. 					$temp_excluded['search'][] = '-' . $word;
    845. 

  845. 					$temp_excluded['display'][] = '-' . $smcFunc['htmlspecialchars']($word);
    846. 

  846. 				}
    847. 

  847. 			}
    848. 

  848. 

  849. 			$did_you_mean['search'] = array_merge($did_you_mean['search'], $temp_excluded['search']);
    850. 

  850. 			$did_you_mean['display'] = array_merge($did_you_mean['display'], $temp_excluded['display']);
    851. 

  851. 

  852. 			$temp_params = $search_params;
    853. 

  853. 			$temp_params['search'] = implode(' ', $did_you_mean['search']);
    854. 

  854. 			if (isset($temp_params['brd']))
    855. 

  855. 				$temp_params['brd'] = implode(',', $temp_params['brd']);
    856. 

  856. 			$context['params'] = array();
    857. 

  857. 			foreach ($temp_params as $k => $v)
    858. 

  858. 				$context['did_you_mean_params'][] = $k . '|\'|' . $v;
    859. 

  859. 			$context['did_you_mean_params'] = base64_encode(implode('|"|', $context['did_you_mean_params']));
    860. 

  860. 			$context['did_you_mean'] = implode(' ', $did_you_mean['display']);
    861. 

  861. 		}
    862. 

  862. 	}
    863. 

  863. 

  864. 	// Let the user adjust the search query, should they wish?
    865. 

  865. 	$context['search_params'] = $search_params;
    866. 

  866. 	if (isset($context['search_params']['search']))
    867. 

  867. 		$context['search_params']['search'] = $smcFunc['htmlspecialchars']($context['search_params']['search']);
    868. 

  868. 	if (isset($context['search_params']['userspec']))
    869. 

  869. 		$context['search_params']['userspec'] = $smcFunc['htmlspecialchars']($context['search_params']['userspec']);
    870. 

  870. 

  871. 	// Do we have captcha enabled?
    872. 

  872. 	if ($user_info['is_guest'] && !empty($modSettings['search_enable_captcha']) && empty($_SESSION['ss_vv_passed']) && (empty($_SESSION['last_ss']) || $_SESSION['last_ss'] != $search_params['search']))
    873. 

  873. 	{
    874. 

  874. 		// If we come from another search box tone down the error...
    875. 

  875. 		if (!isset($_REQUEST['search_vv']))
    876. 

  876. 			$context['search_errors']['need_verification_code'] = true;
    877. 

  877. 		else
    878. 

  878. 		{
    879. 

  879. 			require_once($sourcedir . '/Subs-Editor.php');
    880. 

  880. 			$verificationOptions = array(
    881. 

  881. 				'id' => 'search',
    882. 

  882. 			);
    883. 

  883. 			$context['require_verification'] = create_control_verification($verificationOptions, true);
    884. 

  884. 

  885. 			if (is_array($context['require_verification']))
    886. 

  886. 			{
    887. 

  887. 				foreach ($context['require_verification'] as $error)
    888. 

  888. 					$context['search_errors'][$error] = true;
    889. 

  889. 			}
    890. 

  890. 			// Don't keep asking for it - they've proven themselves worthy.
    891. 

  891. 			else
    892. 

  892. 				$_SESSION['ss_vv_passed'] = true;
    893. 

  893. 		}
    894. 

  894. 	}
    895. 

  895. 

  896. 	// *** Encode all search params
    897. 

  897. 

  898. 	// All search params have been checked, let's compile them to a single string... made less simple by PHP 4.3.9 and below.
    899. 

  899. 	$temp_params = $search_params;
    900. 

  900. 	if (isset($temp_params['brd']))
    901. 

  901. 		$temp_params['brd'] = implode(',', $temp_params['brd']);
    902. 

  902. 	$context['params'] = array();
    903. 

  903. 	foreach ($temp_params as $k => $v)
    904. 

  904. 		$context['params'][] = $k . '|\'|' . $v;
    905. 

  905. 	$context['params'] = base64_encode(implode('|"|', $context['params']));
    906. 

  906. 

  907. 	// ... and add the links to the link tree.
    908. 

  908. 	$context['linktree'][] = array(
    909. 

  909. 		'url' => $scripturl . '?action=search;params=' . $context['params'],
    910. 

  910. 		'name' => $txt['search']
    911. 

  911. 	);
    912. 

  912. 	$context['linktree'][] = array(
    913. 

  913. 		'url' => $scripturl . '?action=search2;params=' . $context['params'],
    914. 

  914. 		'name' => $txt['search_results']
    915. 

  915. 	);
    916. 

  916. 

  917. 

  918. 	// *** A last error check
    919. 

  919. 

  920. 	// One or more search errors? Go back to the first search screen.
    921. 

  921. 	if (!empty($context['search_errors']))
    922. 

  922. 	{
    923. 

  923. 		$_REQUEST['params'] = $context['params'];
    924. 

  924. 		return PlushSearch1();
    925. 

  925. 	}
    926. 

  926. 

  927. 	// Spam me not, Spam-a-lot?
    928. 

  928. 	if (empty($_SESSION['last_ss']) || $_SESSION['last_ss'] != $search_params['search'])
    929. 

  929. 		spamProtection('search');
    930. 

  930. 	// Store the last search string to allow pages of results to be browsed.
    931. 

  931. 	$_SESSION['last_ss'] = $search_params['search'];
    932. 

  932. 

  933. 	// *** Reserve an ID for caching the search results.
    934. 

  934. 	$query_params = array_merge($search_params, array(
    935. 

  935. 		'min_msg_id' => isset($minMsgID) ? (int) $minMsgID : 0,
    936. 

  936. 		'max_msg_id' => isset($maxMsgID) ? (int) $maxMsgID : 0,
    937. 

  937. 		'memberlist' => !empty($memberlist) ? $memberlist : array(),
    938. 

  938. 	));
    939. 

  939. 

  940. 	// Can this search rely on the API given the parameters?
    941. 

  941. 	if ($searchAPI->supportsMethod('searchQuery', $query_params))
    942. 

  942. 	{
    943. 

  943. 		$participants = array();
    944. 

  944. 		$searchArray = array();
    945. 

  945. 

  946. 		$num_results = $searchAPI->searchQuery($query_params, $searchWords, $excludedIndexWords, $participants, $searchArray);
    947. 

  947. 	}
    948. 

  948. 

  949. 	// Update the cache if the current search term is not yet cached.
    950. 

  950. 	else
    951. 

  951. 	{
    952. 

  952. 		$update_cache = empty($_SESSION['search_cache']) || ($_SESSION['search_cache']['params'] != $context['params']);
    953. 

  953. 		if ($update_cache)
    954. 

  954. 		{
    955. 

  955. 			// Increase the pointer...
    956. 

  956. 			$modSettings['search_pointer'] = empty($modSettings['search_pointer']) ? 0 : (int) $modSettings['search_pointer'];
    957. 

  957. 			// ...and store it right off.
    958. 

  958. 			updateSettings(array('search_pointer' => $modSettings['search_pointer'] >= 255 ? 0 : $modSettings['search_pointer'] + 1));
    959. 

  959. 			// As long as you don't change the parameters, the cache result is yours.
    960. 

  960. 			$_SESSION['search_cache'] = array(
    961. 

  961. 				'id_search' => $modSettings['search_pointer'],
    962. 

  962. 				'num_results' => -1,
    963. 

  963. 				'params' => $context['params'],
    964. 

  964. 			);
    965. 

  965. 

  966. 			// Clear the previous cache of the final results cache.
    967. 

  967. 			$smcFunc['db_search_query']('delete_log_search_results', '
    968. 

  968. 				DELETE FROM {db_prefix}log_search_results
    969. 

  969. 				WHERE id_search = {int:search_id}',
    970. 

  970. 				array(
    971. 

  971. 					'search_id' => $_SESSION['search_cache']['id_search'],
    972. 

  972. 				)
    973. 

  973. 			);
    974. 

  974. 

  975. 			if ($search_params['subject_only'])
    976. 

  976. 			{
    977. 

  977. 				// We do this to try and avoid duplicate keys on databases not supporting INSERT IGNORE.
    978. 

  978. 				$inserts = array();
    979. 

  979. 				foreach ($searchWords as $orIndex => $words)
    980. 

  980. 				{
    981. 

  981. 					$subject_query_params = array();
    982. 

  982. 					$subject_query = array(
    983. 

  983. 						'from' => '{db_prefix}topics AS t',
    984. 

  984. 						'inner_join' => array(),
    985. 

  985. 						'left_join' => array(),
    986. 

  986. 						'where' => array(),
    987. 

  987. 					);
    988. 

  988. 

  989. 					if ($modSettings['postmod_active'])
    990. 

  990. 						$subject_query['where'][] = 't.approved = {int:is_approved}';
    991. 

  991. 

  992. 					$numTables = 0;
    993. 

  993. 					$prev_join = 0;
    994. 

  994. 					$numSubjectResults = 0;
    995. 

  995. 					foreach ($words['subject_words'] as $subjectWord)
    996. 

  996. 					{
    997. 

  997. 						$numTables++;
    998. 

  998. 						if (in_array($subjectWord, $excludedSubjectWords))
    999. 

  999. 						{
    1000. 

  1000. 							$subject_query['left_join'][] = '{db_prefix}log_search_subjects AS subj' . $numTables . ' ON (subj' . $numTables . '.word ' . (empty($modSettings['search_match_words']) ? 'LIKE {string:subject_words_' . $numTables . '_wild}' : '= {string:subject_words_' . $numTables . '}') . ' AND subj' . $numTables . '.id_topic = t.id_topic)';
    1001. 

  1001. 							$subject_query['where'][] = '(subj' . $numTables . '.word IS NULL)';
    1002. 

  1002. 						}
    1003. 

  1003. 						else
    1004. 

  1004. 						{
    1005. 

  1005. 							$subject_query['inner_join'][] = '{db_prefix}log_search_subjects AS subj' . $numTables . ' ON (subj' . $numTables . '.id_topic = ' . ($prev_join === 0 ? 't' : 'subj' . $prev_join) . '.id_topic)';
    1006. 

  1006. 							$subject_query['where'][] = 'subj' . $numTables . '.word ' . (empty($modSettings['search_match_words']) ? 'LIKE {string:subject_words_' . $numTables . '_wild}' : '= {string:subject_words_' . $numTables . '}');
    1007. 

  1007. 							$prev_join = $numTables;
    1008. 

  1008. 						}
    1009. 

  1009. 						$subject_query_params['subject_words_' . $numTables] = $subjectWord;
    1010. 

  1010. 						$subject_query_params['subject_words_' . $numTables . '_wild'] = '%' . $subjectWord . '%';
    1011. 

  1011. 					}
    1012. 

  1012. 

  1013. 					if (!empty($userQuery))
    1014. 

  1014. 					{
    1015. 

  1015. 						if ($subject_query['from'] != '{db_prefix}messages AS m')
    1016. 

  1016. 						{
    1017. 

  1017. 							$subject_query['inner_join'][] = '{db_prefix}messages AS m ON (m.id_topic = t.id_topic)';
    1018. 

  1018. 						}
    1019. 

  1019. 						$subject_query['where'][] = $userQuery;
    1020. 

  1020. 					}
    1021. 

  1021. 					if (!empty($search_params['topic']))
    1022. 

  1022. 						$subject_query['where'][] = 't.id_topic = ' . $search_params['topic'];
    1023. 

  1023. 					if (!empty($minMsgID))
    1024. 

  1024. 						$subject_query['where'][] = 't.id_first_msg >= ' . $minMsgID;
    1025. 

  1025. 					if (!empty($maxMsgID))
    1026. 

  1026. 						$subject_query['where'][] = 't.id_last_msg <= ' . $maxMsgID;
    1027. 

  1027. 					if (!empty($boardQuery))
    1028. 

  1028. 						$subject_query['where'][] = 't.id_board ' . $boardQuery;
    1029. 

  1029. 					if (!empty($excludedPhrases))
    1030. 

  1030. 					{
    1031. 

  1031. 						if ($subject_query['from'] != '{db_prefix}messages AS m')
    1032. 

  1032. 						{
    1033. 

  1033. 							$subject_query['inner_join'][] = '{db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)';
    1034. 

  1034. 						}
    1035. 

  1035. 						$count = 0;
    1036. 

  1036. 						foreach ($excludedPhrases as $phrase)
    1037. 

  1037. 						{
    1038. 

  1038. 							$subject_query['where'][] = 'm.subject NOT ' . (empty($modSettings['search_match_words']) || $no_regexp ? ' LIKE ' : ' RLIKE ') . '{string:excluded_phrases_' . $count . '}';
    1039. 

  1039. 							$subject_query_params['excluded_phrases_' . $count++] = empty($modSettings['search_match_words']) || $no_regexp ? '%' . strtr($phrase, array('_' => '\\_', '%' => '\\%')) . '%' : '[[:<:]]' . addcslashes(preg_replace(array('/([\[\]$.+*?|{}()])/'), array('[$1]'), $phrase), '\\\'') . '[[:>:]]';
    1040. 

  1040. 						}
    1041. 

  1041. 					}
    1042. 

  1042. 

  1043. 					$ignoreRequest = $smcFunc['db_search_query']('insert_log_search_results_subject',
    1044. 

  1044. 						($smcFunc['db_support_ignore'] ? '
    1045. 

  1045. 						INSERT IGNORE INTO {db_prefix}log_search_results
    1046. 

  1046. 							(id_search, id_topic, relevance, id_msg, num_matches)' : '') . '
    1047. 

  1047. 						SELECT
    1048. 

  1048. 							{int:id_search},
    1049. 

  1049. 							t.id_topic,
    1050. 

  1050. 							1000 * (
    1051. 

  1051. 								{int:weight_frequency} / (t.num_replies + 1) +
    1052. 

  1052. 								{int:weight_age} * CASE WHEN t.id_first_msg < {int:min_msg} THEN 0 ELSE (t.id_first_msg - {int:min_msg}) / {int:recent_message} END +
    1053. 

  1053. 								{int:weight_length} * CASE WHEN t.num_replies < {int:huge_topic_posts} THEN t.num_replies / {int:huge_topic_posts} ELSE 1 END +
    1054. 

  1054. 								{int:weight_subject} +
    1055. 

  1055. 								{int:weight_sticky} * t.is_sticky
    1056. 

  1056. 							) / {int:weight_total} AS relevance,
    1057. 

  1057. 							' . (empty($userQuery) ? 't.id_first_msg' : 'm.id_msg') . ',
    1058. 

  1058. 							1
    1059. 

  1059. 						FROM ' . $subject_query['from'] . (empty($subject_query['inner_join']) ? '' : '
    1060. 

  1060. 							INNER JOIN ' . implode('
    1061. 

  1061. 							INNER JOIN ', $subject_query['inner_join'])) . (empty($subject_query['left_join']) ? '' : '
    1062. 

  1062. 							LEFT JOIN ' . implode('
    1063. 

  1063. 							LEFT JOIN ', $subject_query['left_join'])) . '
    1064. 

  1064. 						WHERE ' . implode('
    1065. 

  1065. 							AND ', $subject_query['where']) . (empty($modSettings['search_max_results']) ? '' : '
    1066. 

  1066. 						LIMIT ' . ($modSettings['search_max_results'] - $numSubjectResults)),
    1067. 

  1067. 						array_merge($subject_query_params, array(
    1068. 

  1068. 							'id_search' => $_SESSION['search_cache']['id_search'],
    1069. 

  1069. 							'weight_age' => $weight['age'],
    1070. 

  1070. 							'weight_frequency' => $weight['frequency'],
    1071. 

  1071. 							'weight_length' => $weight['length'],
    1072. 

  1072. 							'weight_sticky' => $weight['sticky'],
    1073. 

  1073. 							'weight_subject' => $weight['subject'],
    1074. 

  1074. 							'weight_total' => $weight_total,
    1075. 

  1075. 							'min_msg' => $minMsg,
    1076. 

  1076. 							'recent_message' => $recentMsg,
    1077. 

  1077. 							'huge_topic_posts' => $humungousTopicPosts,
    1078. 

  1078. 							'is_approved' => 1,
    1079. 

  1079. 						))
    1080. 

  1080. 					);
    1081. 

  1081. 

  1082. 					// If the database doesn't support IGNORE to make this fast we need to do some tracking.
    1083. 

  1083. 					if (!$smcFunc['db_support_ignore'])
    1084. 

  1084. 					{
    1085. 

  1085. 						while ($row = $smcFunc['db_fetch_row']($ignoreRequest))
    1086. 

  1086. 						{
    1087. 

  1087. 							// No duplicates!
    1088. 

  1088. 							if (isset($inserts[$row[1]]))
    1089. 

  1089. 								continue;
    1090. 

  1090. 

  1091. 							foreach ($row as $key => $value)
    1092. 

  1092. 								$inserts[$row[1]][] = (int) $row[$key];
    1093. 

  1093. 						}
    1094. 

  1094. 						$smcFunc['db_free_result']($ignoreRequest);
    1095. 

  1095. 						$numSubjectResults = count($inserts);
    1096. 

  1096. 					}
    1097. 

  1097. 					else
    1098. 

  1098. 						$numSubjectResults += $smcFunc['db_affected_rows']();
    1099. 

  1099. 

  1100. 					if (!empty($modSettings['search_max_results']) && $numSubjectResults >= $modSettings['search_max_results'])
    1101. 

  1101. 						break;
    1102. 

  1102. 				}
    1103. 

  1103. 

  1104. 				// If there's data to be inserted for non-IGNORE databases do it here!
    1105. 

  1105. 				if (!empty($inserts))
    1106. 

  1106. 				{
    1107. 

  1107. 					$smcFunc['db_insert']('',
    1108. 

  1108. 						'{db_prefix}log_search_results',
    1109. 

  1109. 						array('id_search' => 'int', 'id_topic' => 'int', 'relevance' => 'int', 'id_msg' => 'int', 'num_matches' => 'int'),
    1110. 

  1110. 						$inserts,
    1111. 

  1111. 						array('id_search', 'id_topic')
    1112. 

  1112. 					);
    1113. 

  1113. 				}
    1114. 

  1114. 

  1115. 				$_SESSION['search_cache']['num_results'] = $numSubjectResults;
    1116. 

  1116. 			}
    1117. 

  1117. 			else
    1118. 

  1118. 			{
    1119. 

  1119. 				$main_query = array(
    1120. 

  1120. 					'select' => array(
    1121. 

  1121. 						'id_search' => $_SESSION['search_cache']['id_search'],
    1122. 

  1122. 						'relevance' => '0',
    1123. 

  1123. 					),
    1124. 

  1124. 					'weights' => array(),
    1125. 

  1125. 					'from' => '{db_prefix}topics AS t',
    1126. 

  1126. 					'inner_join' => array(
    1127. 

  1127. 						'{db_prefix}messages AS m ON (m.id_topic = t.id_topic)'
    1128. 

  1128. 					),
    1129. 

  1129. 					'left_join' => array(),
    1130. 

  1130. 					'where' => array(),
    1131. 

  1131. 					'group_by' => array(),
    1132. 

  1132. 					'parameters' => array(
    1133. 

  1133. 						'min_msg' => $minMsg,
    1134. 

  1134. 						'recent_message' => $recentMsg,
    1135. 

  1135. 						'huge_topic_posts' => $humungousTopicPosts,
    1136. 

  1136. 						'is_approved' => 1,
    1137. 

  1137. 					),
    1138. 

  1138. 				);
    1139. 

  1139. 

  1140. 				if (empty($search_params['topic']))
    1141. 

  1141. 				{
    1142. 

  1142. 					$main_query['select']['id_topic'] = 't.id_topic';
    1143. 

  1143. 					$main_query['select']['id_msg'] = 'MAX(m.id_msg) AS id_msg';
    1144. 

  1144. 					$main_query['select']['num_matches'] = 'COUNT(*) AS num_matches';
    1145. 

  1145. 

  1146. 					$main_query['weights'] = array(
    1147. 

  1147. 						'frequency' => 'COUNT(*) / (MAX(t.num_replies) + 1)',
    1148. 

  1148. 						'age' => 'CASE WHEN MAX(m.id_msg) < {int:min_msg} THEN 0 ELSE (MAX(m.id_msg) - {int:min_msg}) / {int:recent_message} END',
    1149. 

  1149. 						'length' => 'CASE WHEN MAX(t.num_replies) < {int:huge_topic_posts} THEN MAX(t.num_replies) / {int:huge_topic_posts} ELSE 1 END',
    1150. 

  1150. 						'subject' => '0',
    1151. 

  1151. 						'first_message' => 'CASE WHEN MIN(m.id_msg) = MAX(t.id_first_msg) THEN 1 ELSE 0 END',
    1152. 

  1152. 						'sticky' => 'MAX(t.is_sticky)',
    1153. 

  1153. 					);
    1154. 

  1154. 

  1155. 					$main_query['group_by'][] = 't.id_topic';
    1156. 

  1156. 				}
    1157. 

  1157. 				else
    1158. 

  1158. 				{
    1159. 

  1159. 					// This is outrageous!
    1160. 

  1160. 					$main_query['select']['id_topic'] = 'm.id_msg AS id_topic';
    1161. 

  1161. 					$main_query['select']['id_msg'] = 'm.id_msg';
    1162. 

  1162. 					$main_query['select']['num_matches'] = '1 AS num_matches';
    1163. 

  1163. 

  1164. 					$main_query['weights'] = array(
    1165. 

  1165. 						'age' => '((m.id_msg - t.id_first_msg) / CASE WHEN t.id_last_msg = t.id_first_msg THEN 1 ELSE t.id_last_msg - t.id_first_msg END)',
    1166. 

  1166. 						'first_message' => 'CASE WHEN m.id_msg = t.id_first_msg THEN 1 ELSE 0 END',
    1167. 

  1167. 					);
    1168. 

  1168. 

  1169. 					$main_query['where'][] = 't.id_topic = {int:topic}';
    1170. 

  1170. 					$main_query['parameters']['topic'] = $search_params['topic'];
    1171. 

  1171. 				}
    1172. 

  1172. 

  1173. 

  1174. 				// *** Get the subject results.
    1175. 

  1175. 				$numSubjectResults = 0;
    1176. 

  1176. 				if (empty($search_params['topic']))
    1177. 

  1177. 				{
    1178. 

  1178. 					$inserts = array();
    1179. 

  1179. 					// Create a temporary table to store some preliminary results in.
    1180. 

  1180. 					$smcFunc['db_search_query']('drop_tmp_log_search_topics', '
    1181. 

  1181. 						DROP TABLE IF EXISTS {db_prefix}tmp_log_search_topics',
    1182. 

  1182. 						array(
    1183. 

  1183. 							'db_error_skip' => true,
    1184. 

  1184. 						)
    1185. 

  1185. 					);
    1186. 

  1186. 					$createTemporary = $smcFunc['db_search_query']('create_tmp_log_search_topics', '
    1187. 

  1187. 						CREATE TEMPORARY TABLE {db_prefix}tmp_log_search_topics (
    1188. 

  1188. 							id_topic mediumint(8) unsigned NOT NULL default {string:string_zero},
    1189. 

  1189. 							PRIMARY KEY (id_topic)
    1190. 

  1190. 						) TYPE=HEAP',
    1191. 

  1191. 						array(
    1192. 

  1192. 							'string_zero' => '0',
    1193. 

  1193. 							'db_error_skip' => true,
    1194. 

  1194. 						)
    1195. 

  1195. 					) !== false;
    1196. 

  1196. 

  1197. 					// Clean up some previous cache.
    1198. 

  1198. 					if (!$createTemporary)
    1199. 

  1199. 						$smcFunc['db_search_query']('delete_log_search_topics', '
    1200. 

  1200. 							DELETE FROM {db_prefix}log_search_topics
    1201. 

  1201. 							WHERE id_search = {int:search_id}',
    1202. 

  1202. 							array(
    1203. 

  1203. 								'search_id' => $_SESSION['search_cache']['id_search'],
    1204. 

  1204. 							)
    1205. 

  1205. 						);
    1206. 

  1206. 

  1207. 					foreach ($searchWords as $orIndex => $words)
    1208. 

  1208. 					{
    1209. 

  1209. 						$subject_query = array(
    1210. 

  1210. 							'from' => '{db_prefix}topics AS t',
    1211. 

  1211. 							'inner_join' => array(),
    1212. 

  1212. 							'left_join' => array(),
    1213. 

  1213. 							'where' => array(),
    1214. 

  1214. 							'params' => array(),
    1215. 

  1215. 						);
    1216. 

  1216. 

  1217. 						$numTables = 0;
    1218. 

  1218. 						$prev_join = 0;
    1219. 

  1219. 						$count = 0;
    1220. 

  1220. 						foreach ($words['subject_words'] as $subjectWord)
    1221. 

  1221. 						{
    1222. 

  1222. 							$numTables++;
    1223. 

  1223. 							if (in_array($subjectWord, $excludedSubjectWords))
    1224. 

  1224. 							{
    1225. 

  1225. 								if ($subject_query['from'] != '{db_prefix}messages AS m')
    1226. 

  1226. 								{
    1227. 

  1227. 									$subject_query['inner_join'][] = '{db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)';
    1228. 

  1228. 								}
    1229. 

  1229. 								$subject_query['left_join'][] = '{db_prefix}log_search_subjects AS subj' . $numTables . ' ON (subj' . $numTables . '.word ' . (empty($modSettings['search_match_words']) ? 'LIKE {string:subject_not_' . $count . '}' : '= {string:subject_not_' . $count . '}') . ' AND subj' . $numTables . '.id_topic = t.id_topic)';
    1230. 

  1230. 								$subject_query['params']['subject_not_' . $count] = empty($modSettings['search_match_words']) ? '%' . $subjectWord . '%' : $subjectWord;
    1231. 

  1231. 

  1232. 								$subject_query['where'][] = '(subj' . $numTables . '.word IS NULL)';
    1233. 

  1233. 								$subject_query['where'][] = 'm.body NOT ' . (empty($modSettings['search_match_words']) || $no_regexp ? ' LIKE ' : ' RLIKE ') . '{string:body_not_' . $count . '}';
    1234. 

  1234. 								$subject_query['params']['body_not_' . $count++] = empty($modSettings['search_match_words']) || $no_regexp ? '%' . strtr($subjectWord, array('_' => '\\_', '%' => '\\%')) . '%' : '[[:<:]]' . addcslashes(preg_replace(array('/([\[\]$.+*?|{}()])/'), array('[$1]'), $subjectWord), '\\\'') . '[[:>:]]';
    1235. 

  1235. 							}
    1236. 

  1236. 							else
    1237. 

  1237. 							{
    1238. 

  1238. 								$subject_q…
    1239.

Large files files are truncated, but you can click here to view the full file