Search Description, Title and Keywords

[dpi]

Hello,
Now do I search by the description and the picture does not appear.
If you search by Keywords already appear.
I wonder how to change this?
I do full description of the image and that's what matters up in searches.
The Keywords are almost always the same, only interested in a second plane.
Please help change the search of images,
thank you,
PO

[admin]

If you open the file /members/content_list_vars.php you will find the code:

Code: Select all

      //Slow query. With '%' and 'like' - faster
      //$com2.=" (b.title rlike '[[:<:]]".$sch[$i]."[[:>:]]' or b.description rlike '[[:<:]]".$sch[$i]."[[:>:]]' or b.keywords rlike '[[:<:]]".$sch[$i]."[[:>:]]') ";
      
      //Cirillic
      //$com2.=" (UCASE(b.title) like UCASE('%".$sch[$i]."%') or UCASE(b.description) like UCASE('%".$sch[$i]."%') or UCASE(b.keywords) like UCASE('%".$sch[$i]."%')) ";
      
      //Fast query
      //$com2.=" (b.title like '%".$sch[$i]."%' or b.description like '%".$sch[$i]."%' or b.keywords like '%".$sch[$i]."%') ";
      
      //Fast query. It searches without 'description'.
      $com2.=" (b.title like '%".$sch[$i]."%' or b.keywords like '%".$sch[$i]."%') ";

You can search in the titles, keywords and descriptions, search a entire or only a part of the word.

Now the active option is without the description:

Code: Select all

//Fast query. It searches without 'description'.
      $com2.=" (b.title like '%".$sch[$i]."%' or b.keywords like '%".$sch[$i]."%') ";

You can change it.

[mj72]

The line under Slow query: Removed // at the beginning.

The line under Fast query: Added // at the beginning.

GREAT, thanks a lot!!

All searchwords is essential for the user to find photos.
Maybe it could be added in next version under Settings...?

[mj72]

Tried a lot of combinations without succes.

I want to search title, keywords and description.
I want only to search for entire words.

//Fast query
$com2.=" (b.title like '%".$sch[$i]."%' or b.description like '%".$sch[$i]."%' or b.keywords like '%".$sch[$i]."%') ";

searches in part of the word.