openside("Download"); echo '<b><font color="#cc0000">To download files, you must be logged in</b></font></br><table width="100%" border="1">

<tr><td>';



$result = dbquery("SELECT download_id, download_title, download_count, download_cat FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 10");



echo '<b>Latest files:</b><br>';



$rows = dbrows($result);



if ($rows != 0) {



while ($row = mysql_fetch_array($result))



{



echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href="'.BASEDIR.'downloads.php?cat_id='.$row['download_cat'].'&download_id='.$row['download_id'].'">'.$row['download_title'].'</a><br>';



}



}



else {



echo 'Brak danych do wy&#347;wietlenia w statystykach'; }



echo '</td>';



echo '<td>';



$result = dbquery("SELECT download_id, download_title, download_count, download_cat FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 10");



echo '<b>Top download:</b><br>';



$rows = dbrows($result);



if ($rows != 0) {



while ($row = mysql_fetch_array($result))



{



echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href="'.BASEDIR.'downloads.php?cat_id='.$row['download_cat'].'&download_id='.$row['download_id'].'">'.$row['download_title'].' ('.$row['download_count'].')</a><br>';



}



}



else {



echo 'Brak danych do wy&#347;wietlenia w statystykach'; }





echo '</td>';



echo '</tr>

</table>';







closeside();