I got it to work...
I changed the SELECT query (line 14 of the part to be added to search.php) from:
Code:
$lastsearches=$DB_site->query("SELECT search.searchid,search.orderedids,search.dateline,search.query,search.userid,user.username,user.userid,user.usergroupid FROM " . TABLE_PREFIX . "search," . TABLE_PREFIX . "user WHERE query!='' AND user.userid = search.userid AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,15");
to (the table prefix on my board is vb3_)...
Code:
$lastsearches=$DB_site->query("SELECT vb3_search.searchid,vb3_search.orderedids,vb3_search.dateline,vb3_search.query,vb3_search.userid,vb3_user.username,vb3_user.userid,vb3_user.usergroupid FROM " . TABLE_PREFIX . "search," . TABLE_PREFIX . "user WHERE query!='' AND vb3_user.userid = vb3_search.userid ORDER BY searchid desc LIMIT 0,15");
I removed the usergroups, because I wanted mod/admin searches to show.
I also wrapped the search_forums template edit with this conditional, because I wanted only Admin to see the recent searches.
Code:
<if condition="$bbuserinfo[usergroupid] == 6">
</if>
thanks Boofo!