0) {
while($r = dbarray($wynik)) {
echo "
| ".$r['download_title']." |
";
echo "
| ";
echo "".nl2br(stripinput($r['download_cat_description']))."";
echo " |
";
echo "
| ".showdate("%d.%m.%Y %H:%M:%S", $r['download_datestamp'])." |
Pobrano: ".$r['download_coun']." |
";
echo "| Pobierz Plik |
";
}
}
closetable();
} else
{[/color]
if (isset($download_id) && !isNum($download_id)) fallback("index.php");
if (iMEMBER) {
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(BASEDIR."downloads.php");
}
}
if (!isset($cat_id)) {
opentable($locale['400']);
tablebreak();
$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 = 1;
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) echo tablebreak();
$num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
echo "
| ".$data['download_cat_name']." |
";
if ($data['download_cat_description']) {
echo "
| ";
echo "".nl2br(stripinput($data['download_cat_description']))."";
echo " |
";
}
echo "
| ".$locale['D001'].$num." |
".$locale['D002']." |
";
$counter++;
}
[color=red]$ilosc = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
echo "";
echo "
| Wszystkie pliki: |
| ";
echo "AAAAAAAAA";
echo " |
";
echo "
| Plików: ".dbresult($ilosc, 0)." |
WejdĽ: |
";[/color]
tablebreak();
} else {
echo "
\n".$locale['430']."
\n\n";
}
closetable();
} else {
include INCLUDES."comments_include.php";
include INCLUDES."ratings_include.php";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_id='$info_id'");
if ($info_id) {
while ($data = dbarray($result)) {
opentable($locale['400']." » ".$data['download_title']);
echo "
| ".$locale['D003']." |
";
if ($data['download_screen']) {
echo "![](".$data[) ";
echo "
[ ".$locale['D004']." ] | ";
} else {
echo "
";
echo "
[ ".$locale['D004']." ]";
}
echo "".$locale['D005']." |
".$data['download_title']." |
| ".$locale['D006']." |
".$data['download_author']." |
| ".$locale['D007']." |
".$data['download_filesize']." |
| ".$locale['D008']." |
".$data['download_license']." |
| ".$locale['D009']." |
".showdate("%d.%m.%Y %H:%M:%S", $data['download_datestamp'])." |
| ".$locale['D010']." |
".$data['download_count']." |
| ".$locale['D011']." |
".$data['download_os']." |
| ";
if ($data['download_copyright']) {
echo $data['download_copyright'];
} else {
echo " ";
}
echo " | ";
echo "
";
tablebreak();
if ($data['download_description']) {
echo "
| ".$locale['D012']." |
| ".nl2br(stripinput($data['download_description']))." |
";
tablebreak();
}
echo "
";
closetable();
if ($act == "rate") {
showratings("D",$info_id,FUSION_SELF."?cat_id=$cat_id&info_id=$info_id&act=rate");
}
if ($act == "comment") {
showcomments("D","downloads","download_id",$info_id,FUSION_SELF."?cat_id=$cat_id&info_id=$info_id&act=comment");
}
}
} 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']);
tablebreak();
echo "";
echo "";
echo "| \n";
echo (FUSION_QUERY == "cat_id=$cat_id" || $sort == 1 ? "".$locale['D014']."" : "".$locale['D014']."")." | \n";
echo "\n";
echo ($sort == 3 ? "".$locale['D015']."" : "".$locale['D015']."")." | \n";
echo "\n";
echo ($sort == 2 ? "".$locale['D016']."" : "".$locale['D016']."")." | \n";
echo "
";
$rows = dbcount("(*)", "downloads", "download_cat='$cat_id'");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if (!isset($sort) || !isNum($sort)) $sort = 1;
if ($sort == 1) $sorting = "download_title ASC";
if ($sort == 2) $sorting = "download_count DESC";
if ($sort == 3) $sorting = "download_datestamp DESC, download_title ASC";
if ($rows != 0) {
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_cat='$cat_id' ORDER BY $sorting LIMIT $rowstart,20");
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
$new = " ".$locale['410']."";
} else {
$new = "";
}
echo "
| ".$data['download_title']." $new |
";
if ($data['download_description']) {
echo "
| ";
echo "".nl2br(stripinput($data['download_description']))."";
echo " |
";
}
echo "
| ".showdate("%d.%m.%Y %H:%M:%S", $data['download_datestamp'])." |
".$locale['D017'].$data['download_count']." |
".$locale['D018']." |
| ".$data['download_filesize']." |
".$data['download_license']." | ";
$wynik = dbquery("SELECT SUM(rating_vote) FROM ".$db_prefix."ratings WHERE rating_type='D' AND rating_item_id='".$data['download_id']."'");
$info = dbresult($wynik,0);
$num_rating = dbcount("(rating_vote)", "ratings", "rating_type='D' AND rating_item_id='".$data['download_id']."'");
$wyn_rating = ($num_rating ? $info / $num_rating : 0);
echo "".$locale['D019']."![](".IMAGES."rate/".ceil($wyn_rating).".gif "\".$locale[") |
".$locale['D020']." |
";
echo ($i != $numrows ? tablebreak() : "\n"); $i++;
}
tablebreak();
closetable();
if ($rows > 20) echo "\n".makePageNav($rowstart,20,$rows,3,FUSION_SELF."?cat_id=$cat_id&sort=$sort&")."\n
\n";
} else {
echo $locale['431']."\n";
closetable();
}
}
}
if ($res == 0) redirect(FUSION_SELF);
}
}
[color=red]}[/color]
require_once "side_right.php";
require_once "footer.php";
?>