123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106 |
- <?php
- /**
- * Simple Machines Forum (SMF)
- *
- * @package SMF
- * @author Simple Machines http://www.simplemachines.org
- * @copyright 2011 Simple Machines
- * @license http://www.simplemachines.org/about/smf/license.php BSD
- *
- * @version 2.0
- */
- if (!defined('SMF'))
- die('Hacking attempt...');
- /* This file contains database functions specific to search related activity.
- void db_search_init()
- - adds the functions in this file to the $smcFunc array
- boolean smf_db_search_support($search_type)
- - whether this database type support the search type $search_type
- void smf_db_create_word_search($size)
- - create the custom word index table
- resource smf_db_search_query($identifier, $db_string, $db_values = array(), $connection = null)
- - returns the correct query for this search type.
- */
- // Add the file functions to the $smcFunc array.
- function db_search_init()
- {
- global $smcFunc;
- if (!isset($smcFunc['db_search_query']) || $smcFunc['db_search_query'] != 'smf_db_search_query')
- $smcFunc += array(
- 'db_search_query' => 'smf_db_search_query',
- 'db_search_support' => 'smf_db_search_support',
- 'db_create_word_search' => 'smf_db_create_word_search',
- 'db_support_ignore' => false,
- );
- }
- // Does this database type support this search type?
- function smf_db_search_support($search_type)
- {
- $supported_types = array('custom');
- return in_array($search_type, $supported_types);
- }
- // Returns the correct query for this search type.
- function smf_db_search_query($identifier, $db_string, $db_values = array(), $connection = null)
- {
- global $smcFunc;
- $replacements = array(
- 'create_tmp_log_search_topics' => array(
- '~mediumint\(\d\)~i' => 'int',
- '~TYPE=HEAP~i' => '',
- ),
- 'create_tmp_log_search_messages' => array(
- '~mediumint\(\d\)~i' => 'int',
- '~TYPE=HEAP~i' => '',
- ),
- );
- if (isset($replacements[$identifier]))
- $db_string = preg_replace(array_keys($replacements[$identifier]), array_values($replacements[$identifier]), $db_string);
- elseif (preg_match('~^\s*INSERT\sIGNORE~i', $db_string) != 0)
- {
- $db_string = preg_replace('~^\s*INSERT\sIGNORE~i', 'INSERT', $db_string);
- // Don't error on multi-insert.
- $db_values['db_error_skip'] = true;
- }
- $return = $smcFunc['db_query']('', $db_string,
- $db_values, $connection
- );
- return $return;
- }
- // Highly specific - create the custom word index table!
- function smf_db_create_word_search($size)
- {
- global $smcFunc;
- $size = 'int';
- $smcFunc['db_query']('', '
- CREATE TABLE {db_prefix}log_search_words (
- id_word {raw:size} NOT NULL default {string:string_zero},
- id_msg int(10) NOT NULL default {string:string_zero},
- PRIMARY KEY (id_word, id_msg)
- )',
- array(
- 'size' => $size,
- 'string_zero' => '0',
- )
- );
- }
- ?>
|