Features / Usability

Posted by seromine 10 Oct 2008 16:35 GMT-0000 posts: 130

Terribly sorry! Looks like I posted the wrong searchlib.php from another server!

Attached is the correct one, and sorry to waste your time. Below is the relevant section of the code. Notice the html_entity_decode....this was the crux of the solution, but might open itself up to sql injection type stuff...not an issue for me, as we are behind a firewall...but knowing this improved the issue for us, there might be some additional workaround someone might be able to figure out....

if ($fulltext) {
			$words = html_entity_decode($words);
			$qwords = $this->db->quote($words);

			$sqlft = 'MATCH(' . join(',', $h['search']). ') AGAINST (' . $qwords . ' IN BOOLEAN MODE)';
			$sqlWhere .= ' AND ' . $sqlft ;
			$sqlFields .= ', ' . $sqlft . ' AS relevance';
			$orderby = 'relevance desc, ' . $orderby;