1
Hi
A MySQL FULLTEXT index will make the search in a big forum (>300.000 postings) faster (and btw. fix a huge denial-of-service security hole which can be used to block a whole XOOPS site). MySQL >= 4.1 is required.
1. Go to modules/newbb/include/search.php
replace the switch($searchin) {....} through the following:
le="color: #000000"><?php switch ($searchin) { case 'title': $sql .= " AND (MATCH(p.subject) AGAINST('$queryarray[0]' IN BOOLEAN MODE)"; for($i=1;$i<$count;$i++){ $sql .= " $andor "; $sql .= "MATCH(p.subject) AGAINST('$queryarray[$i]' IN BOOLEAN MODE)"; } $sql .= ") "; break; case 'text': $sql .= " AND (MATCH(pt.post_text) AGAINST('$queryarray[0]' IN BOOLEAN MODE)"; for($i=1;$i<$count;$i++){ $sql .= " $andor "; $sql .= "MATCH(pt.post_text) AGAINST('$queryarray[$i]' IN BOOLEAN MODE)"; } $sql .= ") "; break; case 'both' : default; $sql .= " AND ((MATCH(p.subject) AGAINST('$queryarray[0]' IN BOOLEAN MODE) OR MATCH(pt.post_text) AGAINST('$queryarray[0]' IN BOOLEAN MODE))"; for($i=1;$i<$count;$i++){ $sql .= " $andor "; $sql .= "(MATCH(p.subject) AGAINST('$queryarray[$i]' IN BOOLEAN MODE) OR MATCH(pt.post_text) AGAINST('$queryarray[$i]' IN BOOLEAN MODE))"; } $sql .= ") "; break; }
2. Use phpmyadmin to add a fulltext index to the following columns:
YOURPREFIX_bb_posts.subject
YOURPREFIX_bb_posts_text.post_text
(go to the table structure and press the "T" Button in the column to add a Fulltext search index). This will take up to 5 minutes for big forum tables.
3. Lower the min length for a search word to 4 in the XOOPS preferences.
greetings
birdseedmusic
