openside("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 = 4;
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 2)) echo "";
$num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
echo "<img src='http://mp3doze.lt/images/failas.gif'> <a style='color:#4434;' href='".BASEDIR.seoname($data['download_cat_name']).",dainos-kategorija".$data['download_cat_id'].".html'>".$data['download_cat_name']." </a><span class='".$data['download_cat_name']."' title='".$data['download_cat_name']."'>($num)</span>";
echo "<hr>" ;
$counter++;
}
echo "";
 
$diena = date("d", time());
$menesis = date("m", time());
$metai = date("Y", time());
$savaite = date("w", time());
$savaite == 0 ? $savaite = 7 : "";
$savaite = $savaite - 1;
$dabar = time();
$siandien2 = mktime(0,0,0,$menesis,$diena,$metai);
$vakar2 = mktime(0,0,0,$menesis,$diena-1,$metai);
$savaite2 = mktime(0,0,0,$menesis,$diena-$savaite,$metai);
$menesi2 = mktime(0,0,0,$menesis,1,$metai);
$metais2 = mktime(0,0,0,1,1,$metai);
 
$dainos = dbcount("(download_id)", "downloads");
$siandien = dbcount("(download_id)", "downloads", "download_datestamp>='".$siandien2."'");
$vakar = dbcount("(download_id)", "downloads", "download_datestamp>='".$vakar2."' && download_datestamp<='".$siandien2."'");
$savaite = dbcount("(download_id)", "downloads", "download_datestamp>='".$savaite2."'");
$menesi = dbcount("(download_id)", "downloads", "download_datestamp>='".$menesi2."'");
$metais = dbcount("(download_id)", "downloads", "download_datestamp>='".$metais2."'");
 
$diena = date("d", time());
$menesis = date("m", time());
$metai = date("Y", time());
$savaite = date("w", time());
$savaite == 0 ? $savaite = 7 : "";
$savaite = $savaite - 1;
$dabar = time();
$siandien2 = mktime(0,0,0,$menesis,$diena,$metai);
$vakar2 = mktime(0,0,0,$menesis,$diena-1,$metai);
$savaite2 = mktime(0,0,0,$menesis,$diena-$savaite,$metai);
$menesi2 = mktime(0,0,0,$menesis,1,$metai);
$metais2 = mktime(0,0,0,1,1,$metai);
 
$dainos = dbcount("(download_id)", "downloads");
$siandien = dbcount("(download_id)", "downloads", "download_datestamp>='".$siandien2."'");
$vakar = dbcount("(download_id)", "downloads", "download_datestamp>='".$vakar2."' && download_datestamp<='".$siandien2."'");
$savaite = dbcount("(download_id)", "downloads", "download_datestamp>='".$savaite2."'");
$menesi = dbcount("(download_id)", "downloads", "download_datestamp>='".$menesi2."'");
$metais = dbcount("(download_id)", "downloads", "download_datestamp>='".$metais2."'");
 
$parsi = dbresult(dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads"), 0);
echo "<img src='http://emp3.wu.lt/images/icons/audio_file.png'>Įdėta dainų: <b>$dainos</b><br />\n";
echo "<img src='http://emp3.wu.lt/images/icons/music_cd.png'>Šiandien: <b>$siandien</b><br />\n";
echo "<img src='http://emp3.wu.lt/images/icons/sounds.png'>Vakar: <b>$vakar</b><br />\n";
echo "<img src='http://emp3.wu.lt/images/icons/cd.png'>Šią savaitę: <b>$savaite</b><br />\n";
echo "<img src='http://emp3.wu.lt/images/icons/cdr.png'>Šį mėnesį: <b>$menesi</b><br />\n";
echo "<img src='http://emp3.wu.lt/images/icons/folderis.png'>Šiais metais: <b>$metais</b><br/>\n";
echo "<img src='http://emp3.wu.lt/images/icons/dashboard.png'>Atsisiųsta <b>".$parsi."</b>\n";
 
} else {
echo "<center><br><span style='color:lime'><b>Muzik&#261; siun&#269;iasi tik nariai </b></span><a href='http://emp3.wu.lt/register.php' target='_blank'><span style='color:red'><b>Registruokis!</b></span></a><br><br></center>\n";
}
closeside();