Yep! Go to models/hotspot.php and change the search function to this:
public function search($searchWord, $offset = null, $limit = null) {
$db = JFactory::getDBO();
$data = array();
$words = explode(' ', $searchWord);
$where = array();
foreach($words as $value) {
$searchWord = $db->Quote( '%'.$db->getEscaped( $value, true ).'%', false );
$where[] = 'm.name LIKE ' . $searchWord;
$where[] = 'm.description LIKE ' . $searchWord;
$where[] = 'm.description_small LIKE '. $searchWord;
$where[] = 'c.cat_name LIKE '. $searchWord;
}
$query = 'SELECT SQL_CALC_FOUND_ROWS m.id AS hotspots_id, m.*,c.* FROM ' . $db->nameQuote('#__hotspots_marker') . 'AS m'
. ' LEFT JOIN ' . $db->nameQuote('#__hotspots_categorie') . 'AS c'
. ' ON m.catid = c.id '
. ' WHERE '
. '(' . implode( ') OR (', $where) . ')'
. ' AND (m.published = 1 AND c.published = 1 )'
. ' ORDER BY m.name ASC';
if($offset >= 0 && $limit > 0) {
$db->setQuery($query, $offset, $limit);
} else {
$db->setQuery($query);
}
$data['hotspots'] = $db->loadObjectList();
$db->setQuery('SELECT FOUND_ROWS()');
$data['count'] = $db->loadResult();
return $data;
}
This should do the trick and now your query should return results.
And to be honest - since in few hours we will see joomla 2.5 - I want to integrate our search with finder... I'll need to research what needs to be done, but finder seems to be an awesome edition to the CMS...
Cheers,
Daniel
