openside("Siuntinių kategorijos");
$result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name");
$rows = dbrows($result);
if ($rows != 0) {
$counter = 0; $columns = 2;
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) echo "";
$num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
echo "<img src='http://eizo0x.xz.lt/images/failas.gif'> <a style='color:#FFF;' href='".BASEDIR."downloads.php?cat_id=".$data['download_cat_id']."'>".$data['download_cat_name']."</a> <span class='small2'>($num)</span>";
echo "<br>" ;
$counter++;
}
echo "<br>";

$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
echo "<img src='".THEME."images/bullet.gif'> Siuntinių: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads");
echo "<img src='".THEME."images/bullet.gif'> Atsisiųsta: [".dbresult($result, 0)."]<br>";

} else {
echo "<center><br>\n&#352;iai panelei n&#279;ra turinio<br><br></center>\n";
}
closeside();