diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-06-07 19:32:23 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-06-07 19:32:23 +0000 |
| commit | 0e7adebad6e61c066b52e5480d5aa36a23571388 (patch) | |
| tree | 084461c12434d2b18e791d482ee352566fc0b65e /phpBB/includes/search/search.php | |
| parent | 13b9021ae436a625aed61ba20b9d337bf585f6ba (diff) | |
| download | forums-0e7adebad6e61c066b52e5480d5aa36a23571388.tar forums-0e7adebad6e61c066b52e5480d5aa36a23571388.tar.gz forums-0e7adebad6e61c066b52e5480d5aa36a23571388.tar.bz2 forums-0e7adebad6e61c066b52e5480d5aa36a23571388.tar.xz forums-0e7adebad6e61c066b52e5480d5aa36a23571388.zip | |
ok, sorry for this. :/
- cleaned up table names/constants
git-svn-id: file:///svn/phpbb/trunk@6021 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/search/search.php')
| -rwxr-xr-x | phpBB/includes/search/search.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/phpBB/includes/search/search.php b/phpBB/includes/search/search.php index fc9cf2bf02..3cbb5be62a 100755 --- a/phpBB/includes/search/search.php +++ b/phpBB/includes/search/search.php @@ -178,7 +178,7 @@ class search_backend if (!empty($keywords) || sizeof($author_ary)) { $sql = 'SELECT search_time - FROM ' . SEARCH_TABLE . ' + FROM ' . SEARCH_RESULTS_TABLE . ' WHERE search_key = \'' . $db->sql_escape($search_key) . '\''; $result = $db->sql_query($sql); @@ -191,7 +191,7 @@ class search_backend 'search_authors' => ' ' . implode(' ', $author_ary) . ' ' ); - $sql = 'INSERT INTO ' . SEARCH_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary); + $sql = 'INSERT INTO ' . SEARCH_RESULTS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary); $db->sql_query($sql); } $db->sql_freeresult($result); @@ -251,7 +251,7 @@ class search_backend } $cache->put('_search_results_' . $search_key, $store, $config['search_store_results']); - $sql = 'UPDATE ' . SEARCH_TABLE . ' + $sql = 'UPDATE ' . SEARCH_RESULTS_TABLE . ' SET search_time = ' . time() . ' WHERE search_key = \'' . $db->sql_escape($search_key) . '\''; $db->sql_query($sql); @@ -279,7 +279,7 @@ class search_backend } $sql = 'SELECT search_key - FROM ' . SEARCH_TABLE . " + FROM ' . SEARCH_RESULTS_TABLE . " WHERE search_keywords LIKE '%*%' $sql_where"; $result = $db->sql_query($sql); @@ -300,7 +300,7 @@ class search_backend } $sql = 'SELECT search_key - FROM ' . SEARCH_TABLE . " + FROM ' . SEARCH_RESULTS_TABLE . " WHERE $sql_where"; $result = $db->sql_query($sql); @@ -312,7 +312,7 @@ class search_backend } $sql = 'DELETE - FROM ' . SEARCH_TABLE . ' + FROM ' . SEARCH_RESULTS_TABLE . ' WHERE search_time < ' . (time() - $config['search_store_results']); $db->sql_query($sql); } |