/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright � 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."downloads.php";

if (isset($download_id) && !isNum($download_id)) fallback("index.php");

if (isset($download_id)) {
$res = 0;
if ($data = dbarray(dbquery("SELECT download_url,download_cat FROM ".$db_prefix."downloads WHERE download_id='$download_id'"))) {
$cdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$data['download_cat']."'"));
if (checkgroup($cdata['download_cat_access'])) {
$res = 1;
$result = dbquery("UPDATE ".$db_prefix."downloads SET download_count=download_count+1 WHERE download_id='$download_id'");
redirect($data['download_url']);
}
}
if ($res == 0) redirect("downloads.php");
}



if (isset($d_id)) {
include INCLUDES."ratings_include.php";
include INCLUDES."comments_include.php";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_id='$d_id'");
while ($data = dbarray($result)) {
$id = $data['download_cat'];
if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
$new = " ".$locale['410']."";
} else {
$new = "";
}
$time = $data['download_datestamp'];
$laikas = showdate( "%d.%m.%y", $time);
$kat = dbresult(dbquery("SELECT download_cat_name FROM ".$db_prefix."download_cats WHERE download_cat_id='$id'"), 0);
echo "\n";
echo "

\n";
if ($data['download_description'] != "") echo "\n
\n\n";
echo "\n



\n";
$kom = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments WHERE comment_type='D' AND comment_item_id='$id'");
$kon = dbresult($kom, 0);
if ($kon == 0) { $komentarai = 0; } else { $komentarai = $kon; }

echo "\n\n\n";
echo "\n\n\n";
echo "

Siuntiniai >> $kat > ".$data['download_title']." Pridëtas: $laikas
"; if(preg_match('/zippyshare/i' , $data['download_url'])){ echo zip($data['download_url']); } echo "".$data['download_version'].""; echo ' '; echo "
	".$locale['411']." ".$data['download_license']."	Komentarai: $komentarai
".$locale['415']." ".$data['download_count']."	Dydis: ".($data['download_filesize'] ? "".$data['download_filesize']."" : "Nëra")."

\n";

if ($i != $numrows) { echo "\n"; $i++; }
}

showcomments("D","downloads","download_id",$d_id,FUSION_SELF."?d_id=$d_id");

showratings("D",$d_id,FUSION_SELF."?d_id=$d_id");

} else {



if (!isset($cat_id)) {
opentable($locale['400']);
$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;
echo "";
echo "";

echo "

";

while ($data = dbarray($result)) {

$num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
echo "


";
$counter++;
}
echo "

Ieðkoti Siuntini�:
	".$data['download_cat_name']." ($num) ".$data['download_cat_description']."

Statistika

"; $dataq = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 0,1")); echo " "; $datax = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 0,1")); echo " "; $cats = dbresult(dbquery("SELECT count(download_cat_id) FROM ".$db_prefix."download_cats"), 0); echo " "; $countd = dbresult(dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads"), 0); echo " "; $counth = dbresult(dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads"), 0); echo " "; echo " Naujausias siuntinys: ".$dataq['download_title']." Populiariausias: ".$datax['download_title']." Kategorij�: $cats Siuntini�: $countd Atsisi�sta: $counth

";

$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 0,20");
if (dbrows($result)) {

echo "





";
while ($data = dbarray($result)) {
$time = $data['download_datestamp'];
$laikas = showdate( "%d.%m.%y", $time);
echo "






";
}
echo "

Naujausi siuntiniai	Data	Siuntimai
".$data['download_title']."	$laikas	".$data['download_count']."

";
}


} else {
echo "
\n".$locale['430']."

\n\n";
}
closetable();
} else {
$res = 0;
if (!isNum($cat_id)) fallback(FUSION_SELF);
$result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='$cat_id'");
if (dbrows($result) != 0) {
$cdata = dbarray($result);
if (checkgroup($cdata['download_cat_access'])) {
$res = 1;
opentable($locale['400'].": ".$cdata['download_cat_name']);
$rows = dbcount("(*)", "downloads", "download_cat='$cat_id'");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_cat='$cat_id' ORDER BY ".$cdata['download_cat_sorting']." LIMIT $rowstart,15");
//s
$catdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='$cat_id'"));
$count = dbresult(dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads WHERE download_cat='$cat_id'"), 0);
echo "

Siuntiniai � ".$catdata['download_cat_name']." ".$catdata['download_cat_description']." Siuntim� kategorijoje: $count

";
//e


$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
$id = $data['download_id'];
if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
$new = " ".$locale['410']."";
} else {
$new = "";
}
$time = $data['download_datestamp'];
$laikas = showdate( "%d.%m.%y", $time);
echo "\n";
echo "

\n";
if ($data['download_description'] != "")
echo "\n
\n";
$kom = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments WHERE comment_type='D' AND comment_item_id='$id'");
$kon = dbresult($kom, 0);
if ($kon == 0) { $komentarai = 0; } else { $komentarai = $kon; }

echo "
\n\n\n";
echo "\n\n\n";
echo "

".$data['download_title']." Pridëtas: $laikas
"; if(preg_match('/zippyshare/i' , $data['download_url'])){ echo zip($data['download_url']); } echo "".$data['download_version'].""; echo ' '; echo"
	".$locale['411']." ".$data['download_license']."	Komentarai: $komentarai
".$locale['415']." ".$data['download_count']."	Dydis: ".($data['download_filesize'] ? "".$data['download_filesize']."" : "Nëra")."

\n";

if ($i != $numrows) { echo "\n"; $i++; }
}
closetable();
if ($rows > 15) echo "\n";
} else {
echo $locale['431']."\n";
closetable();
}
}
}
if ($res == 0) redirect(FUSION_SELF);
}
}
require_once "side_right.php";
require_once "footer.php";
?>