<?php
    $result = dbquery("ALTER TABLE ".$db_prefix."downloads ADD download_count_s INT UNSIGNED NOT NULL ,
    ADD download_count_m INT UNSIGNED NOT NULL");
    $result = dbquery("ALTER TABLE ".$db_prefix."settings ADD menesis TINYINT( 2 ) UNSIGNED NOT NULL ,
    ADD savaite TINYINT( 2 ) UNSIGNED NOT NULL");
    ?>

download_count=download_count+1, download_count_s=download_count_s+1, download_count_m=download_count_m+1

 
if (date("m", time()) != $settings['menesis']) {
 
$result = dbquery("UPDATE ".$db_prefix."downloads SET download_count_m='0'");
 
$result = dbquery("UPDATE ".$db_prefix."settings SET menesis='".date("m", time())."'");
 
}
 
if (date("W", time()) != $settings['savaite']) {
 
$result = dbquery("UPDATE ".$db_prefix."downloads SET download_count_s='0'");
 
$result = dbquery("UPDATE ".$db_prefix."settings SET savaite='".date("W", time())."'");
 
}
 
 
 
echo "<table width='100%'>
 
<tr>
 
<td width='33%'>";
 
openside("Savaitės topas");
 
 
 
echo "<div class='side-label'><b></b></div>\n";
 
$result = dbquery("SELECT download_cat, download_title, download_count_s FROM ".$db_prefix."downloads ORDER BY download_count_s DESC LIMIT 20");
 
if (dbrows($result) != 0) {
 
 
 
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
 
 
 
while($data = dbarray($result)) {
 
 
 
$itemsubject = trimlink($data['download_title'], 40);
 
echo "<tr>\n<td class='small'><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='side'>$itemsubject</a></td>\n
 
<td align='right'>".$data['download_count_s']."</td>\n</tr>\n";
 
}
 
echo "</table>";
 
 
 
} else {
 
echo "<center>".$locale['004']."</center>\n";
 
}
 
closeside();
 
 
 
 
 
echo "</td>
 
 
 
<td width='33%'>";
 
openside("Mėnėsio topas");
 
echo "<div class='side-label'><b></b></div>\n";
 
 
 
$result = dbquery("SELECT download_cat, download_title, download_count_m FROM ".$db_prefix."downloads ORDER BY download_count_m DESC LIMIT 20");
 
if (dbrows($result) != 0) {
 
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
 
while($data = dbarray($result)) {
 
$itemsubject = trimlink($data['download_title'], 40);
 
echo "<tr>\n<td class='small'><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='side'>$itemsubject</a></td>\n
 
<td align='right'>".$data['download_count_m']."</td>\n</tr>\n";
 
}
 
echo "</table>";
 
} else {
 
echo "<center>".$locale['004']."</center>\n";
 
}
 
 
 
closeside();
 
echo "</tr>
 
</table>";