time()+($settings['timeoffset']*3600)) { $new = " ".$locale['410'].""; } else { $new = ""; } $time = $data['download_datestamp']; $laikas = showdate( "%d.%m.%y", $time); $download_description = stripslashes($data['download_description']); $kat = dbresult(dbquery("SELECT download_cat_name FROM ".$db_prefix."download_cats WHERE download_cat_id='$id'"), 0); echo "\n"; echo "\n"; echo "\n\n"; echo "

Siuntiniai >> $kat > ".$data['download_title']."

Patalpino: $download_description
Data: $laikas

"; echo '

'; echo "

\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 "

Siuntiniai tik nariams !
| | "; 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); $download_description = stripslashes($data['download_description']); echo "\n"; echo "\n"; echo "\n\n"; echo "

".$data['download_title']."

Pridëtas: $laikas| $download_description

"; echo '

'; echo "

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

\n"; $i++; } } closetable(); if ($rows > 15) echo "

\n".makePageNav($rowstart,15,$rows,3,FUSION_SELF."?cat_id=$cat_id&")."\n

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