| 0,0 → 1,218 |
|---|
| <?php |
| /************************* |
| Coppermine Photo Gallery |
| ************************ |
| Copyright (c) 2003-2005 Coppermine Dev Team |
| v1.1 originaly written by Gregory DEMAR |
| |
| This program is free software; you can redistribute it and/or modify |
| it under the terms of the GNU General Public License as published by |
| the Free Software Foundation; either version 2 of the License, or |
| (at your option) any later version. |
| ******************************************** |
| Coppermine version: 1.3.3 |
| $Source: /cvsroot/coppermine/stable/include/search.inc.php,v $ |
| $Revision: 1.6 $ |
| $Author: gaugau $ |
| $Date: 2005/04/19 03:17:11 $ |
| **********************************************/ |
| |
| /** |
| * functions_search.php |
| * |
| * ------------------- |
| * |
| * begin : Wed Sep 05 2001 |
| * |
| * copyright : (C) 2001 The phpBB Group |
| * |
| * email : support@phpbb.com |
| * |
| * |
| * |
| * $Id: search.inc.php,v 1.6 2005/04/19 03:17:11 gaugau Exp $ |
| */ |
| |
| // encoding match for workaround |
| |
| $multibyte_charset = 'utf-8, big5, shift_jis, euc-kr, gb2312'; |
| |
| $charset = $CONFIG['charset'] == 'language file' ? $GLOBALS['lang_charset'] : $CONFIG['charset']; |
| |
| $mb_charset = stristr($multibyte_charset, $charset); |
| |
| function clean_words(&$entry, $mb_charset) |
| { |
| global $charset, $multibyte_charset; |
| |
| static $drop_char_match = array('^', '$', '&', '(', ')', '<', '>', '`', '\'', '"', '|', ',', '@', '_', '?', '%', '~', '.', '[', ']', '{', '}', ':', '\\', '/', '=', '#', '\'', ';', '!'); |
| |
| static $drop_char_replace = array(' ', ' ', ' ', ' ', ' ', ' ', ' ', '', '', ' ', ' ', ' ', ' ', '', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ' , ' ', ' ', ' ', ' ', ' ', ' '); |
| |
| $entry = ' ' . strtolower($entry) . ' '; |
| // Replace line endings by a space |
| $entry = preg_replace('/[\n\r]/is', ' ', $entry); |
| // + and - becomes and & not |
| $entry = str_replace(' +', ' and ', $entry); |
| |
| $entry = str_replace(' -', ' not ', $entry); |
| |
| // Filter out strange characters like ^, $, &, change "it's" to "its" |
| |
| if (!$mb_charset) for($i = 0; $i < count($drop_char_match); $i++) { |
| $entry = str_replace($drop_char_match[$i], $drop_char_replace[$i], $entry); |
| } |
| // 'words' that consist of <3 or >20 characters are removed. |
| // $entry = preg_replace('/\b([a-z0-9]{1,2}|[a-z0-9]{21,})\b/',' ', $entry); |
| return $entry; |
| } |
| |
| if (defined('USE_MYSQL_SEARCH') && $query_all) { |
| // If using MySQL 4 or above we use boolean search |
| $mysql_version = mysql_get_server_info(); |
| |
| if ($mysql_version >= '4') { |
| $boolean_mode = 'IN BOOLEAN MODE'; |
| } else { |
| $boolean_mode = ''; |
| } |
| |
| $result = db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_PICTURES']} WHERE MATCH(filename, title, caption, keywords) AGAINST ('$search_string' $boolean_mode) AND approved = 'YES' $ALBUM_SET"); |
| |
| $nbEnr = mysql_fetch_array($result); |
| |
| $count = $nbEnr[0]; |
| |
| mysql_free_result($result); |
| |
| if ($select_columns != '*') $select_columns .= ', title, caption'; |
| |
| $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE MATCH(filename, title, caption, keywords) AGAINST ('$search_string' $boolean_mode) AND approved = 'YES' $ALBUM_SET $limit"); |
| |
| $rowset = db_fetch_rowset($result); |
| |
| mysql_free_result($result); |
| |
| if ($set_caption) foreach ($rowset as $key => $row) { |
| $caption = $rowset[$key]['title'] ? "<span class=\"thumb_title\">" . $rowset[$key]['title'] . "</span>" : ''; |
| |
| if ($CONFIG['caption_in_thumbview']) { |
| $caption .= $rowset[$key]['caption'] ? "<span class=\"thumb_caption\">" . bb_decode($rowset[$key]['caption']) . "</span>" : ''; |
| } |
| |
| $rowset[$key]['caption_text'] = $caption; |
| } |
| } elseif ($search_string != '') { |
| $split_search = array(); |
| |
| $split_search = split(' ', clean_words($search_string, $mb_charset)); |
| |
| $current_match_type = 'and'; |
| |
| $pic_set = ''; |
| |
| for($i = 0; $i < count($split_search); $i++) { |
| switch ($split_search[$i]) { |
| case 'and': |
| |
| $current_match_type = 'and'; |
| |
| break; |
| |
| case 'or': |
| |
| $current_match_type = 'or'; |
| |
| break; |
| |
| case 'not': |
| |
| $current_match_type = 'not'; |
| |
| break; |
| |
| default: |
| |
| if (empty($split_search[$i])) break; |
| |
| $match_word = '%' . str_replace('*', '%', addslashes($split_search[$i])) . '%'; |
| |
| $match_keyword = '% ' . str_replace('*', '%', addslashes($split_search[$i])) . ' %'; |
| |
| $sql = "SELECT pid " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE CONCAT(' ', keywords, ' ') LIKE '$match_keyword' "; |
| |
| if ($query_all) $sql .= "OR filename LIKE '$match_word' " . "OR title LIKE '$match_word' " . "OR caption LIKE '$match_word' " . "OR user1 LIKE '$match_word' " . "OR user2 LIKE '$match_word' " . "OR user3 LIKE '$match_word' " . "OR user4 LIKE '$match_word' "; |
| |
| $result = db_query($sql); |
| |
| $set = ''; |
| |
| while ($row = mysql_fetch_array($result)) { |
| $set .= $row['pid'] . ','; |
| } // while |
| if (empty($set)) { |
| $set = "'',"; |
| } |
| |
| if (empty($pic_set)) { |
| if ($current_match_type == 'not') { |
| $pic_set .= ' pid not in (' . substr($set, 0, -1) . ') '; |
| } else { |
| $pic_set .= ' pid in (' . substr($set, 0, -1) . ') '; |
| } |
| } else { |
| if ($current_match_type == 'not') { |
| $pic_set .= ' and pid not in (' . substr($set, 0, -1) . ') '; |
| } else { |
| $pic_set .= ' ' . $current_match_type . ' pid in (' . substr($set, 0, -1) . ') '; |
| } |
| } |
| |
| mysql_free_result($result); |
| |
| $current_match_type = 'and'; |
| } |
| } |
| |
| if (!empty($pic_set)) { |
| $sql = "SELECT COUNT(*) " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE ($pic_set) " . "AND approved = 'YES' " . "$ALBUM_SET"; |
| |
| $result = db_query($sql); |
| |
| $nbEnr = mysql_fetch_array($result); |
| |
| $count = $nbEnr[0]; |
| |
| mysql_free_result($result); |
| |
| if ($select_columns != '*') $select_columns .= ', title, caption'; |
| |
| $sql = "SELECT $select_columns " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE ($pic_set) " . "AND approved = 'YES' " . "$ALBUM_SET $limit"; |
| |
| $result = db_query($sql); |
| |
| $rowset = db_fetch_rowset($result); |
| |
| mysql_free_result($result); |
| |
| if ($set_caption) foreach ($rowset as $key => $row) { |
| $caption = $rowset[$key]['title'] ? "<span class=\"thumb_title\">" . $rowset[$key]['title'] . "</span>" : ''; |
| |
| if ($CONFIG['caption_in_thumbview']) { |
| $caption .= $rowset[$key]['caption'] ? "<span class=\"thumb_caption\">" . bb_decode($rowset[$key]['caption']) . "</span>" : ''; |
| } |
| |
| $rowset[$key]['caption_text'] = $caption; |
| } |
| } else { |
| $count = 0; |
| |
| $rowset = array(); |
| } |
| } else { |
| $count = 0; |
| |
| $rowset = array(); |
| } |
| |
| ?> |