$mb ) {
$mysize = sprintf ("%01.2f",$size/$mb) . " MB";
} elseif ( $size >= 1024 ) {
$mysize = sprintf ("%01.2f",$size/1024) . " Kb";
} else {
$mysize = $size . " bytes";
}
$mysize="(".$mysize.")";
return $mysize;
}
if (isset($download_id)) {
$result = dbquery("UPDATE ".$fusion_prefix."downloads SET download_count=download_count+1 WHERE download_id='$download_id'");
$result = dbquery("SELECT download_url FROM ".$fusion_prefix."downloads WHERE download_id='$download_id'");
$data = dbarray($result);
header ("Location: ".$data['download_url']);
}
if (isset($file_id)) {
opentable(LAN_400);
$result = dbquery("SELECT * FROM ".$fusion_prefix."downloads WHERE download_id='$file_id'");
$numrows = dbrows($result);
$i = 1;
while ($data = dbarray($result)) {
echo "![\"".$data['download_title']."\"](\"images/topics/".$data['download_os']."\" "\\"\".$data['download_title'].\"\\"") |
".$data['download_title']." ".CoolSize($data['download_filesize'])." $new
\n";
if ($data['download_description'] != "") echo $data['download_description']."
|
| \n";
$dado=explode(' ',$data['download_datestamp']);
$dodanie=$dado[0];
echo "".LAN_414." ".$dodanie." |
".LAN_413." ".$data['download_version']." |
Rozmiar: ".CoolSize($data['download_filesize'])." |
".LAN_411." |
".LAN_415." ".$data['download_count']."\n";
echo " |
\n";
$i++;
}
echo "
";
closetable();
}
if (!isset($cat_id)) {
opentable(LAN_400);
$result = dbquery("SELECT * FROM ".$fusion_prefix."download_cats WHERE download_parent_id=0 ORDER BY download_cat_name");
$rows = dbrows($result);
if ($rows != 0) {
$columns = 2; $counter = 0;
echo "\n\n";
while ($data = dbarray($result)) {
if ($counter != 0) if($counter % $columns == 0) echo "
\n\n";
$num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
// ile plików
$id_cat=$data['download_cat_id'];
$result5 = dbquery("SELECT * FROM ".$fusion_prefix."download_cats WHERE download_parent_id='$id_cat'");
while ($liczo=dbarray($result5)) {
$kateg=$liczo['download_cat_id'];
$dum = dbcount("(download_cat)", "downloads", "download_cat='$kateg'");
$num=$dum+$num;
}
//koniec
$result2 = dbquery("SELECT * FROM ".$fusion_prefix."download_cats WHERE download_parent_id='$id_cat'");
$ile_cat=mysql_num_rows($result2);
echo "
".$data['download_cat_name']." ($ile_cat podkategorii - $num plików)
";
if ($data['download_cat_description'] != "") echo "
\n".$data['download_cat_description']."";
// podkategorie
$rows2 = dbrows($result2);
if ($rows2 != 0) {
while ($data2 = dbarray($result2)) {
if ($counter2 != 0)
echo "".$data2['download_cat_name'].", ";
if ($data2['download_cat_description'] != "") echo "
\n".$data2['download_cat_description']."";
$counter2++;
}
}
// koniec
echo " | \n";
$counter++;
$totp=$totp+$num;
$num=0;
}
echo "
\n
\n
PLIKÓW W BAZIE: $totp
";
} else {
echo "
\n".LAN_430."
\n\n";
}
closetable();
} else {
if (!isNum($cat_id)) { header("Location:".$PHP_SELF); exit; }
if ($data = dbarray(dbquery("SELECT * FROM ".$fusion_prefix."download_cats WHERE download_cat_id='$cat_id'"))) {
opentable(LAN_400.": ".$data['download_cat_name']);
// podkategorie
$rezultat = dbquery("SELECT * FROM ".$fusion_prefix."download_cats WHERE download_parent_id='$cat_id' ORDER BY download_cat_name");
$wiersze = dbrows($rezultat);
if ($wiersze != 0) {
$cols = 2; $licz = 0;
echo "\n| PODKATEGORIE |
\n";
while ($dane = dbarray($rezultat)) {
if ($licz != 0) if($licz % $cols == 0) echo "
\n\n";
$ilep = dbcount("(download_cat)", "downloads", "download_cat='".$dane['download_cat_id']."'");
$id_cat=$dane['download_cat_id'];
$rezultat2 = dbquery("SELECT * FROM ".$fusion_prefix."download_cats WHERE download_parent_id='$id_cat'");
$ile_cat=mysql_num_rows($rezultat2);
echo "".$dane['download_cat_name']." ($ile_cat podkategorii - $ilep plików)
";
if ($dane['download_cat_description'] != "") echo "
\n".$dane['download_cat_description']."";
echo " | \n";
$licz++;
}
echo "
\n
\n";
} else {
$podk=LAN_430;
$podkat=explode(' ',$podk);
$pod=$podkat[0]." pod".$podkat[1];
echo "
$pod
\n";
}
// koniec
echo "
";
$rows = dbcount("(*)", "downloads", "download_cat='$cat_id'");
if (!$rowstart) $rowstart = 0;
if ($rows != 0) {
echo "
PLIKI
";
$result = dbquery("SELECT * FROM ".$fusion_prefix."downloads WHERE download_cat='$cat_id' ORDER BY download_title LIMIT $rowstart,15");
$numrows = dbrows($result);
$i = 1;
while ($data = dbarray($result)) {
echo " | ".$data['download_title']." ".CoolSize($data['download_filesize'])." $new
\n";
if ($data['download_description'] != "") echo $data['download_description']."
|
| \n";
$dado=explode(' ',$data['download_datestamp']);
$dodanie=$dado[0];
echo "".LAN_414." ".$dodanie." |
".LAN_413." ".$data['download_version']." |
Rozmiar: ".CoolSize($data['download_filesize'])." |
".LAN_411." |
".LAN_415." ".$data['download_count']."\n";
echo " |
\n";
$i++;
}
echo "
";
closetable();
echo "\n".makePageNav($rowstart,15,$rows,3,"$PHP_SELF?cat_id=$cat_id&")."\n
\n";
} else {
echo "
".LAN_431."
\n";
echo "
";
closetable();
}
} else {
header("Location:".$PHP_SELF); exit;
}
}
include "side_right.php";
include "footer.php";
?>