openside("Statystyki download");

$stat = dbquery("SELECT 

(SELECT COUNT(*) FROM ".DB_DOWNLOAD_CATS.") AS kategori,

(SELECT COUNT(*) FROM ".DB_DOWNLOADS.") AS plikow,

(SELECT SUM(download_count) FROM ".DB_DOWNLOADS.") AS pobran

");

$r = dbarray($stat);



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

<tr><td class='small'>Liczba kategorii:</td><td align='right' class='small'>".number_format($r['kategori'])."</td></tr>

<tr><td class='small'>Liczba plików:</td><td align='right' class='small'>".number_format($r['plikow'])."</td></tr>

<tr><td class='small'>Liczba pobrań:</td><td align='right' class='small'>".number_format($r['pobran'])."</td></tr>

</table>";

closeside();