
05-30-2002, 03:15 PM
|
|
|
Join Date: May 2002
Location: Australia
Posts: 246
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
hack work perfectly !
patvdv your code is giving me error can you check your code as i'd like to have your layout
Mone'
Quote:
Originally posted by patvdv
Change the PHP code in search.php like this:
PHP Code:
// begin last search hack by JP
$colstart1="<td bgcolor='{ secondaltcolor }'><smallfont>";
$colstart2="<td align='center' bgcolor=' { firstaltcolor }' width=15%><smallfont>";
$colend="</smallfont></td>";
$lastsearches=$DB_site->query('SELECT searchid,postids,dateline,querystring FROM search LEFT JOIN user USING (userid) WHERE queryst
ring!="" AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,10');
while ($lastsearchcount=$DB_site->fetch_array($lastsearches)):
$lastsearchdate=vbdate($dateformat,$lastsearchcount[dateline]);
$lastsearchtime=vbdate($timeformat,$lastsearchcount[dateline]);
$ourlastquery=$lastsearchcount[querystring];
$ourlastquery=bbcodeparse($ourlastquery);
$ourlastquery=censortext($ourlastquery);
$lastsearchresultscount="$lastsearchcount[postids]";
$lastsearchresultscount=explode(",",$lastsearchresultscount);
$lastsearchresultscount=sizeof($lastsearchresultscount);
$lastsearchmatches.="$lastsearchresultscount posts<br>";
$lastsearchkeywords.="<a href='search.php?s=&action=showresults&searchid=$lastsearchcount[searchid]&sortby=lastpost&sortorder=desce
nding'>$ourlastquery</a><br>";
$lastsearchtimestamp.="$lastsearchdate at $lastsearchtime<br>";
endwhile;
$lastsearch="<tr>".$colstart2.$lastsearchmatches.$colend.$colstart1.$lastsearchkeywords.$colend.$colstart2.$lastsearchtimestamp.$co
lend."</tr>";
// end last search hack by JP
It will also use alternating colours for the columns
|
|