search in review, authors, tags,... by keywords

[sidhashem]

Hi, Thanks to your excellent Component. But I have a problem and I need when a user search by keyword, all of the parameters specially reviews being searched.

[federica]

Hi sidhashem,
modify the file components/com_abook/models/search.php line 156
from:

Code Select Expand

if ($this->getState('filter.search') !='') {
$filtersearch=$db->escape($this->getState('filter.search'));
$query->where('(LOWER( a.title ) LIKE "%'.$filtersearch.'%" OR (LOWER( a.subtitle) LIKE "%'.$filtersearch.'%") OR (a.catalogo LIKE"%'.$filtersearch.'%") OR (a.isbn LIKE "%'.$filtersearch.'%"))');

}
to:

Code Select Expand

if ($this->getState('filter.search') !='') {
                        $filtersearch=$db->escape($this->getState('filter.search'));
                        $query->where('(LOWER( a.title ) LIKE "%'.$filtersearch.'%" OR LOWER( a.subtitle) LIKE "%'.$filtersearch.'%" OR a.catalogo LIKE "%'.$filtersearch.'%" OR a.isbn LIKE "%'.$filtersearch.'%" OR LOWER( a.description ) LIKE "%'.$filtersearch.'%")');
                }