| $wort_bitte_die_felder_ausfuellen |
";
include "footer.inc.php";
exit;
}
if ($action=="search"&&$s_titel==""&&$s_beschreibung=="") {
echo "| $wort_bitte_die_felder_ausfuellen |
";
include "footer.inc.php";
exit;
}
if ($action=="search") {
$user_id = mysql_query("SELECT id FROM $tableuser WHERE username='$s_user'");
$user_id = mysql_fetch_array($user_id);
//Nur User
if ($s_user!="" && $s_string=="") {
$query = "SELECT * FROM $tabledownload WHERE
uploader='$user_id[0]'";
}
//Nur Titel
if ($s_user=="" && $s_string!="" && $s_beschreibung=="" && $s_titel=="ON") {
$query = "SELECT * FROM $tabledownload WHERE
filename LIKE '%$s_string%'";
}
//Nur Beschreibung
if ($s_user=="" && $s_string!="" && $s_beschreibung=="ON" && $s_titel=="") {
$query = "SELECT * FROM $tabledownload WHERE
beschreibung LIKE '%$s_string%'";
}
//Titel und Beschreibung
if ($s_user=="" && $s_string!="" && $s_beschreibung=="ON" && $s_titel=="ON") {
$query = "SELECT * FROM $tabledownload WHERE
beschreibung LIKE '%$s_string%' OR
filename LIKE '%$s_string%'";
}
//Titel und Beschreibung und User
if ($s_user!="" && $s_string!="" && $s_beschreibung=="ON" && $s_titel=="ON") {
$query = "SELECT * FROM $tabledownload WHERE
beschreibung LIKE '%$s_string%' OR
filename LIKE '%$s_string%' AND
uploader='$user_id[0]'";
}
//Beschreibung mit User
if ($s_user!="" && $s_string!="" && $s_beschreibung=="ON" && $s_titel=="") {
$query = "SELECT * FROM $tabledownload WHERE
beschreibung LIKE '%$s_string%' AND
uploader='$user_id[0]'";
}
//Titel mit User
if ($s_user!="" && $s_string!="" && $s_beschreibung=="" && $s_titel=="ON") {
$query = "SELECT * FROM $tabledownload WHERE
filename LIKE '%$s_string%' AND
uploader='$user_id[0]'";
}
$result = mysql_query($query);
$treffer_anzahl=0;
echo"
| Download-Suche |
| $wort_name | $wort_kategorie | $wort_downloads |
";
while($row = mysql_fetch_array($result)){
$id = $row["id"];
$filename = $row["filename"];
$kat_id = $row["kat_id"];
$downloads = $row["downloads"];
$kat = mysql_query("SELECT * FROM $tablekategorien WHERE id = '$kat_id'");
$kat_result = mysql_fetch_array($kat);
$kat_name = $kat_result["kategorie"];
$treffer_anzahl++;
$show_downloads = number_format($downloads,0,$nummer_dezimal_trennzeichen,$nummer_tausend_trennzeichen);
if (check_rights($id)){
echo"
| $filename | $kat_name | $show_downloads |
";
}
}
if ($treffer_anzahl==0){
echo"$wort_es_wurden_keine_downloads_gefunden | ";
}
echo"
";
} else {
echo "
";
}
include "footer.inc.php";
?>