// Ugly hack: limit 100 workaround for punbb internal limitation Ju 20070529 other hack since we're big order by posted desc /o\
$result = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN
'.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.num_replies=0 A
ND t.moved_to IS NULL and f.id!=7 and f.id!=43 and f.id!=8 and f.id!=4 order by posted desc limit 100') or error('Unable to fetch topic list', __FILE__, __LINE__,
$db->error());
Here is the code of the search.php action, the troubled query being search.php?action=show_unanswered
EDIT: the Ugly hack has recently been added by Ju (one of the admins).
Just ask if you need more information. thanks again for help