In search.php look for:
PHP Code:
$searchforumbits=getsearchforums();
Under it add:
PHP Code:
//WL 26-MAR-2001
//Show Last Ten Searches.
$latestsearches = $DB_site->query("SELECT searchid, querystring, username, dateline FROM search LEFT JOIN user on (search.userid=user.userid) WHERE querystring <> '' ORDER BY dateline DESC LIMIT 10");
$toggle = "#DEDEDE";
while ($latestsearch=$DB_site->fetch_array($latestsearches)) {
$latestsearch['date']=vbdate($dateformat,$latestsearch['dateline']);
$latestsearch['time']=vbdate($timeformat,$latestsearch['dateline']);
if ($toggle%2==0) {
$backcolor="#DEDEDE";
} else {
$backcolor="#EFEFEF";
}
eval("\$searchbits .= \"".gettemplate("search_latestbit")."\";");
$toggle++;
}
//End Latest Searches.
Create a template called search_latestbit:
Code:
<tr color="$backcolor">
<td><normalfont><a href="search.php?s=$session[sessionhash]&action=showresults&searchid=$latestsearch[searchid]">$latestsearch[querystring]</a></normalfont></td>
<td>$latestsearch[date] $latestsearch[time]</td>
</tr>
Modify your searchintro template to include:
Code:
<table bgcolor="#FFFFFF" border=0 cellpadding=4 cellspacing=1 width="100%">
<tr bgcolor="#6c6081"><TD COLSPAN=2>
<normalfont color="#afa3c5" class=thtcolor><B>Last Ten Searches</B></normalfont></td></tr>
<tr>
<tr bgcolor="#6c6081">
<td width="65%"><normalfont color="#f5d300">Search Text</normalfont></td>
<td width="35%"><normalfont color="#f5d300">Performed At:</normalfont></td>
</tr>
$searchbits
</table>