$value) {
if(trim($value)) $search["key"][$key] = trim($value);
}
unset($search_string);
if(isset($search["key"]) && sizeof($search["key"])) {
//check for AND or OR
$search["andor"] = (intval($_POST["file_andor"])) ? 1 : 0;
$search["which"] = intval($_POST["file_which"]);
switch($search["which"]) {
case 0: $search["which"]="f_public=0 AND f_uid=".$_SESSION["wcs_user_id"]; break;
case 1: $search["which"]="f_public=1"; break;
default: $search["which"]="(f_public=1 OR (f_public=0 AND f_uid=".$_SESSION["wcs_user_id"]."))"; break;
}
$file_key = get_list_of_file_keywords(); //Auslesen der File Schlüsselwörter
//Aufbau des eigentlichen Suchstrings
$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_file WHERE f_aktiv=1 AND f_trash=0 AND f_kid=1 AND ";
$sql.= $search["which"].";"; //ob public oder private order keine Angabe
if($result = mysql_query($sql, $db) or die ("error while running search")) {
while($row = mysql_fetch_array($result)) {
$search["string"] = $row["f_name"]." ".$row["f_shortinfo"]." ".$row["f_longinfo"];
$search["string"] = str_replace("\r\n", " ", $search["string"]);
$search["string"] = str_replace("\n", " ", $search["string"]);
$search["string"] .= add_keywords_to_search ($file_key, $row["f_keywords"]); //fügt freie Keywords zum Suchstring hinzu
foreach($search["key"] as $value) {
if(preg_match("/".preg_quote($value,"/")."/i", $search["string"])) {
if($search["andor"]) {
if(!isset($search["result"][$row["f_id"]])) {; //AND clause
$search["result"][$row["f_id"]] = 1;
} else {
$search["result"][$row["f_id"]]++;
}
} else {
$search["result"][$row["f_id"]] = 1; //OR clause
}
}
}
}
if(isset($search["result"]) && sizeof($search["result"]) && $search["andor"]) {
//Prüfen, ob die AND bedingung erfüllt ist
//gilt nur, wenn Anzahl Suchworte = Anzahl Funde im String
$search["count_key"] = sizeof($search["key"]);
foreach($search["result"] as $key => $value) {
if($search["count_key"] != $value) unset($search["result"][$key]);
}
}
}
} else {
$search["error"][1] = $BL['be_fsearch_err1'];
}
} else {
$search["error"][1] = $BL['be_fsearch_err1'];
}
}
?>
\n";
echo "![](\"img/leer.gif\") |
\n";
$sl=0; $search["filelist"] = " ";
foreach($search["result"] as $key => $value) {
if($sl) $search["filelist"] .=" OR ";
$search["filelist"] .= "f_id=".intval($key);
$sl++;
}
//Listing der gefundenen Dateien
$file_sql = "SELECT * FROM ".DB_PREPEND."phpwcms_file WHERE (".
( (trim($search["filelist"])) ? $search["filelist"] : 0 ).
") AND f_kid=1 AND f_trash=0 ORDER BY f_name;";
if($file_result = mysql_query($file_sql, $db) or die ("error while listing files")) {
$file_durchlauf = 0;
while($file_row = mysql_fetch_array($file_result)) {
$filename = html_specialchars($file_row["f_name"]);
if(!$file_durchlauf) { //Aufbau der Zeile zum Einfließen der Filelisten-Tavbelle
echo "\n";
} else {
echo " | \n";
}
echo "\n";
echo " | \n";
echo "";
echo "![](\"img/icons/small_".extimg($file_row["f_ext"])."\") | \n";
echo "";
//echo "";
echo $filename."";
echo " | \n";
echo "";
echo "".
"![](\"img/button/download_disc.gif\") ";
echo ""; //Spacer
echo " | \n";
//Ende Aufbau
echo " \n";
if($_SESSION["wcs_user_thumb"]) {
$thumb_image = get_cached_image(
array( "target_ext" => $file_row["f_ext"],
"image_name" => $file_row["f_hash"] . '.' . $file_row["f_ext"],
"thumb_name" => md5($file_row["f_hash"].$phpwcms["img_list_width"].$phpwcms["img_list_height"].$phpwcms["sharpen_level"])
)
);
if($thumb_image != false) {
echo "\n";
echo " | \n";
echo " | \n";
echo ' | \n";
echo " | \n \n";
echo " | \n \n";
}
}
/*
if($file_row["f_thumb_list"] && $_SESSION["wcs_user_thumb"]) { //Wenn List Preview Image verfügbar
echo "\n";
echo " | \n";
echo " | \n";
echo "![](\"".$phpwcms["file_tmp"].$phpwcms["dir_thlist"].$file_row["f_thumb_list"]."\") | \n";
echo " | \n \n";
echo " | \n \n";
}
*/
$file_durchlauf++;
}
if($file_durchlauf) { //Abschluss der Filelisten-Tabelle
echo " \n";
echo " |
|
\n"; //Abstand vor
} else {
echo "";
echo "
";
echo " ".$BL['be_fsearch_nonfound'];
echo "
|
\n";
}
} //Ende Liste Dateien
echo "\n"; //Ende Tabelle
} else {
//kein gültiges Suchergebnis
if(isset($search["string"])) {
echo "
";
echo " ".$BL['be_fsearch_nonfound'];
echo "
";
} else {
echo "
";
echo " ".$BL['be_fsearch_fillin'];
echo "
";
}
}
?>