require "login.php";
include ("header.inc.php");
include ("config.php");
mysql_connect( "$dbhost", "$dbuser", "$dbpass") or die("$wort_konnte_datenbankverbindung_nicht_herstellen");
@mysql_select_db( "$dbname") or die("$wort_datenbank_nicht_gefunden");
if($action=="search_dl"){download_search_action($keyword); echo"
Zurück";}else{
if (check_rights($_GET['fileid'])){
$result=mysql_query("SELECT * from $tabledownload where id='$_GET[fileid]'");
$row = mysql_fetch_array($result);
$id=$row["id"];
$filename=$row["filename"];
$beschreibung=$row["beschreibung"];
$downloadfile=$row["downloadfile"];
$downloads=$row["downloads"];
$version_neu=$row["version"];
$needs=$row["needs"];
$downloadgroesse=$row["groesse"];
$screen=$row["screen"];
$entry=$row["entry"];
$lastmodify=$row["lastmodify"];
$uploader=$row["uploader"];
$show_downloads = number_format($downloads,0,$nummer_dezimal_trennzeichen,$nummer_tausend_trennzeichen);
$result5 = mysql_query("select * from $tableuser where id='$uploader'");
$row5 = mysql_fetch_array($result5);
$uploadername=$row5["username"];
$result4 = mysql_query("select * from $tablekom where fileid='$id'");
$anzahl_kommentare=mysql_num_rows($result4);
$result2=mysql_query("SELECT * from $tablebewertungen where fileid='$id'");
if ($result2) {
$row2 = mysql_fetch_array($result2);
$gesamt=$row2["gesamt"];
$stimmen=$row2["stimmen"];
}
// Ganze Sterne
if ($stimmen>0) {
$ganze_sterne = (int) ($gesamt/$stimmen);
} else {
$ganze_sterne = 0; }
// Halbe Sterne
if ($stimmen>0) {
$rest = (($gesamt)-($ganze_sterne*$stimmen))/$stimmen;
if ($rest<=0.24) {$halber_stern="stern_grau.gif";}
if ($rest>0.24) {$halber_stern="stern_ein_viertel.gif";}
if ($rest>0.49) {$halber_stern="stern_halb.gif";}
if ($rest>0.74) {$halber_stern="stern_drei_viertel.gif";}
} else { $rest = 0; }
// Leere Sterne
if ($rest>0) {
$leere_sterne = 9-$ganze_sterne;
} else {
$leere_sterne = 10-$ganze_sterne;}
?>