default:
$search["which"] = "(f_public=1 OR 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
}
}
.gif" alt="" width="12" height="13" /><img src="img/button/public_12x13_<?php
echo $row["f_public"];
?>
.gif" alt="" width="12" height="13" /></td>
</tr>
</table></td>
<td bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="1" /></td>
</tr>
<tr><td colspan="4" bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
<tr><td colspan="4" bgcolor="#CDDEE4"><img src="img/leer.gif" alt="" width="1" height="1" /></td></tr>
<tr><td colspan="4"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
<tr>
<td><img src="img/leer.gif" alt="" width="1" height="5" /></td>
<td><img src="img/leer.gif" alt="" width="1" height="5" /></td>
<td class="v10"><?php
echo $BL['KEYWORDS'] . ": " . html_specialchars($row["f_shortinfo"] . add_keywords_to_search($file_key, $row["f_keywords"]));
?>
</td>
<td><img src="img/leer.gif" alt="" width="1" height="5" /></td>
</tr>
<tr><td colspan="4"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
<?php
if ($thumb_image != false) {
?>
<tr><td colspan="4" bgcolor="#CDDEE4"><img src="img/leer.gif" alt="" width="1" height="1" /></td></tr>
<tr><td colspan="4" bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
<tr>
<td bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="1" /></td>
<td colspan="2" align="center" bgcolor="#F5F8F9"><?php
echo '<img src="' . PHPWCMS_IMAGES . $thumb_image[0] . '" border="0" ' . $thumb_image[3] . '>';
?>
