$locale['top_001'] = "Download Top Week";
openside($locale['top_001']);
$result = dbquery(
"SELECT td.*, tu.*
FROM ".DB_DOWNLOADS." td
LEFT JOIN ".DB_USERS." tu ON td.download_user=tu.user_id
WHERE download_datestamp >= ".time()." - 604800
ORDER BY download_count DESC
LIMIT 5");
if (dbrows($result) != 0) {
echo"<table width='100%' cellpadding='0' class='tbl1' cellspacing='0'>";
while($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
$itemsubject = trimlink($data['download_title'], 20);
echo "<tr>\n<td class='$cell_color'>".THEME_BULLET." <a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."'>".$itemsubject ."</td>
<td class='$cell_color' align='right'>".$data['download_count']."</a></td></tr>\n";
}
echo "</table>";
} else {
echo "<center>No File</center>\n";
}
closeside();
Category Forum
Modifications and Requests - 8Labels
None yet
Statistics
3 participants
Notifications
You are not receiving notifications from this thread.
Related Questions