Chris@76: <?php
Chris@76: 
Chris@76: /**
Chris@76:  * Simple Machines Forum (SMF)
Chris@76:  *
Chris@76:  * @package SMF
Chris@76:  * @author Simple Machines http://www.simplemachines.org
Chris@76:  * @copyright 2011 Simple Machines
Chris@76:  * @license http://www.simplemachines.org/about/smf/license.php BSD
Chris@76:  *
Chris@76:  * @version 2.0
Chris@76:  */
Chris@76: 
Chris@76: if (!defined('SMF'))
Chris@76: 	die('Hacking attempt...');
Chris@76: 
Chris@76: /*	This file contains database functions specific to search related activity.
Chris@76: 
Chris@76: 	void db_search_init()
Chris@76: 		- adds the functions in this file to the $smcFunc array
Chris@76: 
Chris@76: 	boolean smf_db_search_support($search_type)
Chris@76: 		- whether this database type support the search type $search_type
Chris@76: 
Chris@76: 	void smf_db_create_word_search($size)
Chris@76:  		- create the custom word index table
Chris@76: 
Chris@76: */
Chris@76: 
Chris@76: // Add the file functions to the $smcFunc array.
Chris@76: function db_search_init()
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	if (!isset($smcFunc['db_search_query']) || $smcFunc['db_search_query'] != 'smf_db_query')
Chris@76: 		$smcFunc += array(
Chris@76: 			'db_search_query' => 'smf_db_query',
Chris@76: 			'db_search_support' => 'smf_db_search_support',
Chris@76: 			'db_create_word_search' => 'smf_db_create_word_search',
Chris@76: 			'db_support_ignore' => true,
Chris@76: 		);
Chris@76: }
Chris@76: 
Chris@76: // Does this database type support this search type?
Chris@76: function smf_db_search_support($search_type)
Chris@76: {
Chris@76: 	$supported_types = array('fulltext');
Chris@76: 
Chris@76: 	return in_array($search_type, $supported_types);
Chris@76: }
Chris@76: 
Chris@76: // Highly specific - create the custom word index table!
Chris@76: function smf_db_create_word_search($size)
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	if ($size == 'small')
Chris@76: 		$size = 'smallint(5)';
Chris@76: 	elseif ($size == 'medium')
Chris@76: 		$size = 'mediumint(8)';
Chris@76: 	else
Chris@76: 		$size = 'int(10)';
Chris@76: 
Chris@76: 	$smcFunc['db_query']('', '
Chris@76: 		CREATE TABLE {db_prefix}log_search_words (
Chris@76: 			id_word {raw:size} unsigned NOT NULL default {string:string_zero},
Chris@76: 			id_msg int(10) unsigned NOT NULL default {string:string_zero},
Chris@76: 			PRIMARY KEY (id_word, id_msg)
Chris@76: 		) ENGINE=InnoDB',
Chris@76: 		array(
Chris@76: 			'string_zero' => '0',
Chris@76: 			'size' => $size,
Chris@76: 		)
Chris@76: 	);
Chris@76: }
Chris@76: 
Chris@76: ?>