Code:
<?php
/*BEGIN_INFO
Use this module to Create an page whit the top downloads for each category<br />.
By Stugas-ddl.org
END_INFO*/
if(!defined("WCDDL_GUTS"))
exit;
foreach($core->allowed_types as $ty) {
$output .= '<table width="100%" border="0"><tr class="row2">
<td><font size="4">Top 10 <span class="'.strtolower($ty).'">'.ucfirst($ty).'</span> Downloads</font></td>
</tr>';
$dbc = mysql_query("SELECT id,title,dat FROM wcddl_downloads WHERE type = '".$ty."' ORDER BY views DESC LIMIT 10");
while($row = mysql_fetch_assoc($dbc))
$output .= '<tr class="row2"><td><font size="2" color="red"><a href="/?q='.$row['title'].'" target="_blank">'.$row['title'].'</a></font></a></td>
<td>'.date("d-m-Y",$row['dat']).'</td></tr>';
$output .= '</table><br>';
}
$core->setTemplateVar("downloadsbycategory",$output);
?>
Code:
<?=$core->templateVar("downloadsbycategory")?>