28
OK, sorry for the delay
In SimplyWiki 1.1, open include/search.php and replace the search function with this
le="color: #000000"><?php function swiki_search($queryarray, $andor, $limit, $offset, $userid) { global $xoopsDB; $sql = 'SELECT * FROM '.$xoopsDB->prefix('wiki_pages').' p, '.$xoopsDB->prefix('wiki_revisions').' r WHERE p.pageid=r.pageid AND p.lastmodified=r.modified'; if (is_array($queryarray) && ($count = count($queryarray))) { $sql .= ' AND (p.title LIKE "%'.$queryarray[0].'%" OR r.body LIKE "%'.$queryarray[0].'%")'; for($i = 1; $i < $count; $i++) { $sql .= ' $andor (p.title LIKE "%'.$queryarray[$i].'%" OR r.body LIKE "%'.$queryarray[$i].'%")'; } } else { $sql .= ' AND r.userid='.$userid.''; } $sql .= ' ORDER BY r.modified DESC'; $items = array(); $prf = new WiwiProfile(); $result = $xoopsDB->query($sql, $limit, $offset); while($myrow = $xoopsDB->fetchArray($result)) { $prf->load($myrow['prid']); if ($prf->canRead()) { $items[] = array( 'title' => $myrow['title'], 'link' => 'index.php?page='.$myrow['keyword'], 'time' => formatTimestamp(strtotime($myrow['modified']), _SHORTDATESTRING), 'uid' => $myrow['userid'], 'image' => '../../images/quote.gif' ); } } return $items; }
Looking at 1.0 (Wiwimod 0.8.3+), I don't think it works there, either - the LIKE conditions are not properly enclosed in quotes and there are no wildcards.
