openside("Kategorijos");

 

$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);

 

$siandien = dbcount("(download_id)", $db_prefix."downloads", "download_datestamp>='".$siandien2."'");

$vakar = dbcount("(download_id)", $db_prefix."downloads", "download_datestamp>='".$vakar2."' && download_datestamp<='".$siandien2."'");

$savaite = dbcount("(download_id)", $db_prefix."downloads", "download_datestamp>='".$savaite2."'");

$menesi = dbcount("(download_id)", $db_prefix."downloads", "download_datestamp>='".$menesi2."'");

$metais = dbcount("(download_id)", $db_prefix."downloads", "download_datestamp>='".$metais2."'");

 

echo "Įdėta siuntinių: <b>$dainos</b><br />\n";

echo "Šiandien: <b>$siandien</b><br />\n";

echo "Vakar: <b>$vakar</b><br />\n";

echo "Šią savaitę: <b>$savaite</b><br />\n";

echo "Šį mėnesį: <b>$menesi</b><br />\n";

echo "Šiais metais: <b>$metais</b><br />\n<br />\n";

$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>";

closeside();