Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Strict search matching not partial  (Read 3592 times)

0 Members and 1 Guest are viewing this topic.

busterjet

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Strict search matching not partial
« on: April 09, 2005, 12:03:21 pm »

Hello

By default, Coppermine search looks for partial matches for words:

eg search for USA and you will also get results for saUSAges

How can I alter the code so that search matches complete words only?

Many thanks

James
http://www.freedigitalphotos.net
Logged

busterjet

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Strict search matching not partial
« Reply #1 on: January 20, 2006, 07:03:46 pm »

OK I figured this out. I am using Coppermine 1.3.2 so don't know if this works with other versions:

To change to strict search:

Open include/search.inc.php and replace all the code with this: (sorry I did this months ago and cannot be sure which bit I changed, so I have to post the whole page.

James
http://www.freedigitalphotos.net

Code: [Select]
<?php
// ------------------------------------------------------------------------- //
// Coppermine Photo Gallery 1.3.2                                            //
// ------------------------------------------------------------------------- //
// Copyright © 2002-2004 Gregory DEMAR                                    //
// http://www.chezgreg.net/coppermine/                                      //
// ------------------------------------------------------------------------- //
// Updated by the Coppermine Dev Team                                        //
// (http://coppermine.sf.net/team/)                                          //
// see /docs/credits.html for details                                        //
// ------------------------------------------------------------------------- //
// 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.                                      //
// ------------------------------------------------------------------------- //
// CVS version: $Id: search.inc.php,v 1.5 2004/07/24 15:04:09 gaugau Exp $
// ------------------------------------------------------------------------- //

/**
* functions_search.php
*
*                              -------------------
*
*      begin                : Wed Sep 05 2001
*
*      copyright            : © 2001 The phpBB Group
*
*      email                : support@phpbb.com
*
*
*
*      $Id: search.inc.php,v 1.5 2004/07/24 15:04:09 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($set0, -1) . ') ';
                    } else {
                        
$pic_set .= ' pid in (' substr($set0, -1) . ') ';
                    }
                } else {
                    if (
$current_match_type == 'not') {
                        
$pic_set .= ' and pid not in (' substr($set0, -1) . ') ';
                    } else {
                        
$pic_set .= ' ' $current_match_type ' pid in (' substr($set0, -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();
}

?>

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Strict search matching not partial
« Reply #2 on: January 21, 2006, 06:22:41 am »

Not related, but applicable to your site: http://forum.coppermine-gallery.net/index.php?topic=22132.0
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 19 queries.