by jomasaco on Sun Sep 06, 2009
An near clone of recent search, it show the results by most searched
Create an new file on modules folder name wcddl_TopSearch.php
inside past
Code:
<?php
if(!defined("WCDDL_GUTS"))
exit;
/*BEGIN_INFO
Top 100 Searches.
END_INFO*/
$recentsLimit = 500; //Many results you want show
$recentsResults = array();
$recentsQuery = mysql_query("SELECT query, searches FROM wcddl_recents ORDER BY searches DESC LIMIT ".mysql_real_escape_string($recentsLimit)."");
while($recentsRow = mysql_fetch_assoc($recentsQuery)) {
$recentsRow['queryURL'] = $core->processURL($recentsRow['query']);
$recentsRow['query'] = strip_tags($recentsRow['query']);
$recentsRow['searches'] = $recentsRow['searches'] +1;
$recentsResults[] = '<a href="index.php?q='.$recentsRow['queryURL'].'" title="Searched '.$recentsRow['searches'].' Times">'.$recentsRow['query'].'</a>';
}
$recentsResult = implode(", ",$recentsResults);
$core->setTemplateVar("TopSearches",$recentsResult);
?>
In page where you want see the table place
Code:
<h2>Top Searches</h2>
<?=$core->templateVar("TopSearches")?>
</p>