General Support: UPDATED : Advance Search Function for Plogger

I have added the ability to "exact phrase match" along with multiple phrases, and and like statements. It is a revision on the + search created by sidtheduck.

Edits all go in plog-functions.

YOU WILL HAVE TO CHANGE THE FIELDS TO REFLECT THE FIELDS YOU WANT TO SEARCH!!! DO not think that my fields exist in your database.

FIRST edit your search function to look something like this:

<code>function plogger_init_search($arr) {
$arr['searchterms'] = trim($arr['searchterms']);

if (strstr($arr['searchterms'],'*+'))
{
$terms = explode('*+*',substr($arr['searchterms'],1,-1));
$case = "AND";
}
else if (strstr($arr['searchterms'],'*'))
{
$terms = explode('* *',substr($arr['searchterms'],1,-1));
$case = " OR";
}
else
{
$terms = explode(" ",$arr['searchterms']);
$case = " OR";
}

$from = 0;
$limit = 20;

if (isset($arr['from']) && $arr['from'] > 0) {
$from = $arr['from'];
}

// enforce hard-coded max limit
if (isset($arr['limit']) && $arr['limit'] > 0 && $arr['limit'] <= 100) {
$limit = $arr['limit'];
}

$query = " FROM `".TABLE_PREFIX."pictures` p LEFT JOIN `".TABLE_PREFIX."comments` c
ON p.`id` = c.`parent_id` ";

if ((count($terms) != 1) || ($terms[0] != '')){
$query .= " WHERE ";
foreach ((array)$terms as $term) {
$query .= " (";
$term = mysql_real_escape_string($term);
$multi_term = explode("+",$term);
if (count($multi_term)>1) {
$path = implode("%' AND `path` LIKE '%",$multi_term);
$description = implode("%' AND `description` LIKE '%",$multi_term);
$comment = implode("%' AND `comment` LIKE '%",$multi_term);
$caption = implode("%' AND `caption` LIKE '%",$multi_term);
$EXIF_subj_ref = implode("%' AND `EXIF_subj_ref` LIKE '%",$multi_term);
$EXIF_cont_loc_name = implode("%' AND `EXIF_cont_loc_name` LIKE '%",$multi_term);
$EXIF_city = implode("%' AND `EXIF_city` LIKE '%",$multi_term);
$EXIF_state = implode("%' AND `EXIF_state` LIKE '%",$multi_term);
$EXIF_country = implode("%' AND `EXIF_country` LIKE '%",$multi_term);
$EXIF_credit = implode("%' AND `EXIF_credit` LIKE '%",$multi_term);
$EXIF_source = implode("%' AND `EXIF_source` LIKE '%",$multi_term);
$EXIF_contact = implode("%' AND `EXIF_contact` LIKE '%",$multi_term);
$EXIF_caption = implode("%' AND `EXIF_caption` LIKE '%",$multi_term);
$EXIF_make = implode("%' AND `EXIF_make` LIKE '%",$multi_term);
$EXIF_model = implode("%' AND `EXIF_model` LIKE '%",$multi_term);
$EXIF_copyright = implode("%' AND `EXIF_copyright` LIKE '%",$multi_term);
$EXIF_artist = implode("%' AND `EXIF_artist` LIKE '%",$multi_term);
$EXIF_lat_ref = implode("%' AND `EXIF_lat_ref` LIKE '%",$multi_term);
$EXIF_long_ref = implode("%' AND `EXIF_long_ref` LIKE '%",$multi_term);
$EXIF_lat = implode("%' AND `EXIF_lat` LIKE '%",$multi_term);
$EXIF_long = implode("%' AND `EXIF_long` LIKE '%",$multi_term);
$EXIF_date_time_dig = implode("%' AND `EXIF_date_time_dig` LIKE '%",$multi_term);
$EXIF_date_time_orig = implode("%' AND `EXIF_date_time_orig` LIKE '%",$multi_term);
$EXIF_img_hist = implode("%' AND `EXIF_img_hist` LIKE '%",$multi_term);
$EXIF_usr_comment = implode("%' AND `EXIF_usr_comment` LIKE '%",$multi_term);
$EXIF_comment = implode("%' AND `EXIF_comment` LIKE '%",$multi_term);
$EXIF_keyword = implode("%' AND `EXIF_keyword` LIKE '%",$multi_term);
} else {
$path = $description = $comment = $caption = $EXIF_subj_ref = $EXIF_cont_loc_name = $EXIF_city = $EXIF_state = $EXIF_country = $EXIF_credit = $EXIF_source = $EXIF_contact = $EXIF_caption = $EXIF_make = $EXIF_model = $EXIF_copyright = $EXIF_artist = $EXIF_lat_ref = $EXIF_long_ref = $EXIF_lat = $EXIF_long = $EXIF_date_time_dig = $EXIF_date_time_orig = $EXIF_img_hist = $EXIF_usr_comment = $EXIF_comment =$EXIF_keyword = $term;
} $query .= "
`path` LIKE '%$path%' OR
`description` LIKE '%$description%' OR
`comment` LIKE '%$comment%' OR
`caption` LIKE '%$caption%' OR
`EXIF_subj_ref` LIKE '%$EXIF_subj_ref%' OR
`EXIF_cont_loc_name` LIKE '%$EXIF_cont_loc_name%' OR
`EXIF_city` LIKE '%$EXIF_city%' OR
`EXIF_state` LIKE '%$EXIF_state%' OR
`EXIF_country` LIKE '%$EXIF_country%' OR
`EXIF_credit` LIKE '%$EXIF_credit%' OR
`EXIF_source` LIKE '%$EXIF_source%' OR
`EXIF_contact` LIKE '%$EXIF_contact%' OR
`EXIF_caption` LIKE '%$EXIF_caption%' OR
`EXIF_make` LIKE '%$EXIF_make%' OR
`EXIF_model` LIKE '%$EXIF_model%' OR
`EXIF_copyright` LIKE '%$EXIF_copyright%' OR
`EXIF_artist` LIKE '%$EXIF_artist%' OR
`EXIF_lat_ref` LIKE '%$EXIF_lat_ref%' OR
`EXIF_long_ref` LIKE '%$EXIF_long_ref%' OR
`EXIF_lat` LIKE '%$EXIF_lat%' OR
`EXIF_long` LIKE '%$EXIF_long%' OR
`EXIF_date_time_dig` LIKE '%$EXIF_date_time_dig%' OR
`EXIF_date_time_orig` LIKE '%$EXIF_date_time_orig%' OR
`EXIF_img_hist` LIKE '%$EXIF_img_hist%' OR
`EXIF_usr_comment` LIKE '%$EXIF_usr_comment%' OR
`EXIF_comment` LIKE '%$EXIF_comment%' OR
`EXIF_keyword` LIKE '%$EXIF_keyword%' ) $case";
}
$query = substr($query, 0, strlen($query) - 5) .") ";
} else {
// no search terms? no results either
$query .= " WHERE 1 = 0";
}

$sort_fields = array('date_submitted','id');
$sortby = 'date_submitted';

if (isset($arr['sortby']) && in_array($arr['sortby'],$sort_fields)) {
$sortby = $arr['sortby'];
}

$sortdir = ' ASC';

if (isset($arr['sortdir']) && 'desc' == $arr['sortdir']) {
$sortdir = ' DESC';
}

$result = run_query("SELECT COUNT(DISTINCT p.`id`) AS cnt " . $query);
$row = mysql_fetch_assoc($result);

$GLOBALS["total_pictures"] = $row["cnt"];
// and I need sort order here as well
// from and limit too
$result = run_query("SELECT p.*,c.`comment`,
UNIX_TIMESTAMP(`date_submitted`) AS `unix_date_submitted` ".$query .
" GROUP BY p.`id` ORDER BY `$sortby` $sortdir LIMIT $from,$limit");

$GLOBALS["available_pictures"] = mysql_num_rows($result);
$GLOBALS["picture_counter"] = 0;
$GLOBALS["picture_dbh"] = $result;

}
</code>