searchbot adaption - 2008/11/18 18:57
Hi Chris..
two questions..
I am looking at the php of the searchbot and I am trying to do two things
1. I want the marker ID in the url that is "conc'ed" up inside that bit of php.. (so I can auto open the correct marker using javascript)
2. I want the searchbot to display only certain maps, so some maps that are published do not need to be displayed in the search results. As every search result displayed is in fact just a link to a certain map I mean.
Could you help me out by giving me some pointers?
It is this piece of the code I am loking at and to be honest that is about all I can manage. I am such a php-noob. Remarkable that I undestand what it sort of does..
$query = "SELECT a.name AS title,"
// . "n a.description AS text,"
. "n '' AS created,"
. "n b.title AS section,"
. "n '2' AS browsernav,"
. "n CONCAT( 'index.php?option=" . $comp . "&task=".$task."&mapId=', b.id ) AS href"
. "n FROM #__gmaps_markers AS a, #__gmaps_maps as b, #__gmaps_points as c"
. "n WHERE c.map_id = b.id and c.item_id = a.id"
. " and ( UPpER(a.name) LIKE UPPER('%$text%')"
. "n OR UPPER(a.description) LIKE UPPER('%$text%'))"
. "n ORDER BY a.name"
;
The administrator has disabled public write access.
|
