The current Sobi2 searchbot produced by the authors (great component, BTW) only searches the text of directory listings, not the categories they reside in.
It would be great to have a searchbot that searches jos_sobi2_categories (fields 'name' 'description' and 'introtext'
, not just jos_sobi2_item. This should be pretty simple, but it's beyond my expertise...so far.
Thanks for any help...and if it's JPromoter SEF compatible, that's even better.
Here is the code of the original searchbot:
| Code: |
<?php
/**
* @version $Id: sobi2.searchbot.php 909 2007-06-24 13:29:03Z Radek Suski $
* @package SOBI2 searchbot
* @copyright Copyright (C) 2006 Sigsiu.NET (http://sigsiu.net). All rights reserved.
* @license see http://www.gnu.org/copyleft/gpl.html GNU/GPL.
* package_name is free software and parts of it may contain or be derived from the
* GNU General Public License or other free or open source software licenses.
* sobi2.searchbot.php 26-Sep-2006 11:25:39 Radek
*/
/** ensure this file is being included by a parent file */
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
$_MAMBOTS->registerFunction( 'onSearch', 'botSearchSOBI2' );
function searchSobi($catid = 0, $phrase = 'any', $ordering = null, $searchbot = false, $searchString = null, $config) {
global $mosConfig_offset, $database;
$items = null;
$countResults = 0;
$fieldData = array();
$and = null;
$dataForFields = array();
$sobi2IDs = array();
if($ordering)
$config->listingOrdering = $ordering;
if(!$phrase || $phrase == null)
$phrase = 'any';
if($searchString) {
$customFields = true;
$searchString = $config->clearSQLinjection(trim($searchString));
switch ($phrase) {
case 'exact':
$where = "LOWER(sdata.data_txt) LIKE '%{$searchString}%'";
break;
case 'any':
case 'all':
if($phrase == 'any')
$and_or = ' OR ';
else if($phrase == 'all')
$and_or = ' AND ';
$words = explode( ' ', $searchString );
$count = 0;
foreach ($words as $word) {
if($count != 0)
$where .= "{$and_or} LOWER(sdata.data_txt) LIKE '%{$word}%' ";
else
$where = " LOWER(sdata.data_txt) LIKE '%{$word}%' ";
$count++;
}
break;
}
/*
* now get the fields in there we have to looking for
*/
$query = "SELECT sobifields.fieldid " .
"FROM `#__sobi2_fields` AS sobifields " .
"WHERE ((`in_search` = 1 OR `in_search` = 2 ) AND `enabled` = 1)";
$database->setQuery( $query );
$searchInTo = $database->loadObjectList();
$and = null;
if(count($searchInTo) != 0) {
foreach($searchInTo as $field) {
$query = "SELECT DISTINCT `itemid` " .
"FROM `#__sobi2_fields` AS sfield " .
"LEFT JOIN `#__sobi2_fields_data` AS sdata ON sfield.fieldid = sdata.fieldid " .
"WHERE (sfield.fieldid = '{$field->fieldid}' AND {$where})";
$database->setQuery($query);
if(count($database->loadObjectList()) > 0) {
foreach($database->loadObjectList() as $item) {
$sobi2IDs[] = $item->itemid;
}
}
else
$customFields = false;
}
}
$sobi2IDs = array_unique($sobi2IDs);
/*
* last part - getting this information from sobi2_items table
*/
switch ($phrase) {
case 'exact':
$where = "LOWER(title) LIKE '%{$searchString}%' ";
$where .= "OR LOWER(metakey) LIKE '%{$searchString}%' ";
$where .= "OR LOWER(metadesc) LIKE '%{$searchString}%' ";
break;
case 'any':
case 'all':
if($phrase == 'any')
$and_or = ' OR ';
else if($phrase == 'all')
$and_or = ' AND ';
$words = explode( ' ', $searchString );
$count = 0;
foreach ($words as $word) {
if($count != 0)
$where .= "{$and_or} ( LOWER(title) LIKE '%{$word}%' ) ";
else
$where = "(( LOWER(title) LIKE '%{$word}%' )";
$count++;
}
$count = 0;
foreach ($words as $word) {
if($count != 0)
$where .= "{$and_or} ( LOWER(metakey) LIKE '%{$word}%' ) ";
else
$where .= "OR ( LOWER(metakey) LIKE '%{$word}%' ) ";
$count++;
}
$count = 0;
foreach ($words as $word) {
if($count != 0)
$where .= "{$and_or} ( LOWER(metadesc) LIKE '%{$word}%' ) ";
else
$where .= "OR ( LOWER(metadesc) LIKE '%{$word}%' )";
$count++;
}
$where .= "«») ";
break;
}
$and = str_replace("sdata.itemid","`itemid`",$and);
$query = "SELECT DISTINCT `itemid` FROM `#__sobi2_item` WHERE ({$where} {$and})";
$database->setQuery($query);
if(count($database->loadObjectList()) > 0) {
foreach($database->loadObjectList() as $item)
$sobi2IDs[] = $item->itemid;
}
$sobi2IDs = array_unique($sobi2IDs);
if(count($sobi2IDs) != 0) {
/*
* now we have all id's from items contains search strings
*/
$count = 0;
foreach($sobi2IDs as $sobi2 => $id) {
if($count != 0)
$whereId .= "OR items.itemid = '{$id}' ";
else
$whereId = " items.itemid = '{$id}' ";
$count++;
}
$now = date( 'Y-m-d H:i:«»s', time() + $mosConfig_offset * 60 * 60 );
$query = "SELECT itemid, title, owner, image, icon, metadesc, publish_up FROM `#__sobi2_item` AS items " .
"WHERE ( ({$whereId}) AND `published` = 1 AND (`publish_down` > '{$now}' OR `publish_down` = '{$config->nullDate}' ) ) ORDER BY {$config->listingOrdering}";
$database->setQuery($query);
$items = $database->loadObjectList();
$sobi2IDs = array_unique($sobi2IDs);
$countResults = count($sobi2IDs);
}
}
/*
* end of search function
*/
return $items;
}
function botSearchSOBI2( $text, $phrase = 'any', $ordering = null ) {
global $database, $my,$mosConfig_absolute_path;
require_once($mosConfig_absolute_path.'/components/com_sobi2/config.class.php' );
$config = new sobi2Config;
switch ( $ordering ) {
case 'oldest':
$order = 'items.publish_up ASC';
break;
case 'popular':
$order='items.hits ASC';
break;
case 'alpha':
$order = 'items.title ASC';
break;
case 'newest':
default:
$order = 'items.publish_up DESC';
}
$sobiItems = searchSobi(0, $phrase, $order, true, $text, $config);
$rows = array();
if(count($sobiItems) != 0) {
foreach($sobiItems as $sobi) {
$data = new sobiSearchResults ;
$data->title = $sobi->title;
$data->created = $sobi->publish_up;
$data->section = $config->componentName;
$query = "SELECT `data_txt` FROM `#__sobi2_fields_data` WHERE `itemid` = {$sobi->itemid} AND `fieldid` = '13'";
$database->setQuery($query);
$desc = $database->loadResult();
if($desc)
$data->text = $config->getSobiStr($desc);
else
$data->text = $sobi->metadesc;
$data->browsernav = 2;
$url='index.php?option=com_sobi2&amp;sobi2Task=sobi2Details&amp;sobi2Id='.$sobi->itemid.'&amp;Itemid='.$config->sobi2Itemid;
$url = sefRelToAbs($url);
$data->href = $url;
$rows[] = $data;
unset($data);
}
}
return $rows;
}
class sobiSearchResults {
var $title = null;
var $created = null;
var $section = null;
var $text = null;
var $browsernav = null;
var $url = null;
}
?>
|
Forum 
Favoured: 0
