define("DB_DOWNLOADS", $db_prefix."downloads");
$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)", "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."'");
$result = dbquery("SELECT download_id, download_title FROM ".DB_DOWNLOADS." ORDER BY download_datestamp DESC LIMIT 0,1");
if (dbrows($result)) {
$data = dbarray($result);
} else {
$data['download_id'] = "";
$data['download_title'] = "";
}
$parsi = dbresult(dbquery("SELECT SUM(download_count) FROM ".DB_DOWNLOADS), 0);
 
opentable("Siuntini� Statistika");
   echo "<table align='center' cellpadding='0' cellspacing='0' class='decolor2'>\n<tr>
   <td align='center' width='80'>";
   echo "</td>
   <td align='left' width='190'>";
   if (!defined("IN_FUSION")) { header("Location:../../index.php"); exit; }
echo '<b>Naujausi Siuntiniai</b>';
   $result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 0,10");
   if (dbrows($result) != 0) {
   echo "<table width='310' cellpadding='0' cellspacing='0'>";
   while ($data = dbarray($result)) {
   echo "<tr>
   <td class='small2'>
   <img src='".THEME."images/bullet.gif'>
   <a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='small2'>".trimlink($data['download_title'], 40)."</a>
   </td>
   <td align='right'>[".$data['download_count']."]</td>
   </tr>";
   }
   echo "</table>";
   } else {
   echo "<div style='text-align:center'>N&#279;ra siuntini&#371;</div>\n";
   }
   echo "</td>
   <td align='center' width='80'>";
   echo "</td>
   <td align='right' width='190'>";
   if (!defined("IN_FUSION")) { header("Location:../../index.php"); exit; }
echo '<b>Siun�iamiausi Siuntiniai</b>';
   $result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 0,10");
   if (dbrows($result) != 0) {
   echo "<table width='310' cellpadding='0' cellspacing='0'>";
   while ($data = dbarray($result)) {
   echo "<tr>
   <td class='small2'>
   <img src='".THEME."images/bullet.gif'>
   <a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='small2'>".trimlink($data['download_title'], 40)."</a>
   </td>
   <td align='right'>[".$data['download_count']."]</td>
   </tr>";
   }
   echo "</table>";
   } else {
   echo "<div style='text-align:center'>N&#279;ra siuntini&#371;</div>\n";
   }
   echo "</td>
   <td align='right' width='525'>";
   echo "</td>
 
   </tr>
   </table>";
 
echo "�d�ta siuntini�: <b>$dainos</b>";
echo "?iandien: <b>$siandien</b>";
echo "Vakar: <b>$vakar</b>";
echo "?i� savait�: <b>$savaite</b>";
echo "?� m�nes�: <b>$menesi</b>";
echo "?iais metais: <b>$metais</b>";
echo "Atsisi�sta [".$parsi."]\n";
 
closetable();
Parsed in 0.083 seconds, using GeSHi 1.0.8.10