openside("Download");

$wynik = dbquery("SELECT * FROM ".$db_prefix."pdp_downloads a LEFT JOIN ".$db_prefix."pdp_cats u ON a.cat_id=u.cat_id ORDER BY dl_ctime DESC LIMIT 0,10");



echo "<table border='0' width='100%' class='small'>"; 



echo "<tr>";

echo "<td align='center' class='tbl2' colspan='2'><b>Najnowsze pliki:</b></td>";

echo "</tr>\n";



if(dbrows($wynik) > 0) { 



while($r = dbarray($wynik)) { 



echo "<tr><td class='small'><img src='".THEME."images/bullet.gif'> [<a href='".BASEDIR."infusions/pro_download_panel/download.php?catid=".$r['cat_id']."'>".trimlink($r['cat_name'], 6)."</a>] <a href='".INFUSIONS."pro_download_panel/download.php"."?did=".$r['download_id']."'>





".$r['dl_name']."</a></td><td align='right' class='small'>".$r['dl_count']."</td></tr>";



}

echo "</table>"; 



}





$wynik = dbquery("SELECT * FROM ".$db_prefix."pdp_downloads a LEFT JOIN ".$db_prefix."pdp_cats u ON a.cat_id=u.cat_id ORDER BY dl_count DESC LIMIT 0,10");



echo "<table border='0' width='100%' class='small'>"; 



echo "<tr>";

echo "<td align='center' class='tbl2' colspan='2'><b>Top 10 Download:</b></td>";

echo "</tr>\n";



if(dbrows($wynik) > 0) { 



while($r = dbarray($wynik)) { 



echo "<tr><td class='small'><img src='".THEME."images/bullet.gif'> [<a href='".BASEDIR."infusions/pro_download_panel/download.php?catid=".$r['cat_id']."'>".trimlink($r['cat_name'], 6)."</a>] <a href='".INFUSIONS."pro_download_panel/download.php"."?did=".$r['download_id']."'>





".$r['dl_name']."</a></td><td align='right' class='small'>".$r['dl_count']."</td></tr>";



}

echo "</table>"; 



}



closeside();