Query("SELECT * FROM " . PREFIX . "_queries_conditions WHERE Abfrage = '$id'"); $where = ''; $start = 0; while($row_ak = $sql_ak->fetchrow()) { $where = 'WHERE'; $uebergabe = true; $Operator = $row_ak->Operator; $Feld = $row_ak->Feld; $Wert = $row_ak->Wert; $AAnd = "AND DokumentId !='" . def_id() . "'"; $startBracket = ($start != 0) ? ' OR(' : '('; $lastbBracket = ($start != 0) ? ') ' : ') '; switch($Operator) { case '%%': $q_ab = " $startBracket RubrikFeld = '$Feld' AND Inhalt like '%$Wert%' $AAnd $lastbBracket"; break; case '%': $q_ab = " $startBracket RubrikFeld = '$Feld' AND Inhalt like '$Wert%' $AAnd $lastbBracket"; break; case '<': $q_ab = " $startBracket RubrikFeld = '$Feld' AND Inhalt < '$Wert' $AAnd $lastbBracket"; break; case '<=': $q_ab = " $startBracket RubrikFeld = '$Feld' AND Inhalt <= '$Wert' $AAnd $lastbBracket"; break; case '>': $q_ab = " $startBracket RubrikFeld = '$Feld' AND Inhalt > '$Wert' $AAnd $lastbBracket"; break; case '>=': $q_ab = " $startBracketRubrikFeld = '$Feld' AND Inhalt >= '$Wert' $AAnd $lastbBracket"; break; case '==': $q_ab = " $startBracket RubrikFeld = '$Feld' AND Inhalt = '$Wert' $AAnd $lastbBracket"; break; case '!=': $q_ab = " $startBracket RubrikFeld = '$Feld' AND Inhalt != '$Wert' $AAnd $lastbBracket"; break; case '--': $q_ab = " $startBracket RubrikFeld = '$Feld' AND Inhalt not like '%$Wert%' $AAnd $lastbBracket"; break; echo $q_ab; } $start++; $eq_string .= $q_ab; } $count_match = ''; $sql_feld = $GLOBALS['db']->Query("SELECT DokumentId,Inhalt FROM " . PREFIX . "_document_fields $where $eq_string"); $count_match = $sql_feld->numrows(); $ueb = ''; if($count_match > 0) { $ueb = "AND ("; $i = 0; while($row_feld = $sql_feld->fetchrow()) { $ueb .= (($i > 0) ? " OR " : ""); $ueb .= (@$_SESSION['comments_enable'] == 1) ? 'a.Id='.$row_feld->DokumentId : 'Id='.$row_feld->DokumentId; $i++; } $ueb .= ") "; } else { $ueb = (@$_SESSION['comments_enable'] == 1) ? "AND (a.Id = '0')" : "AND (Id = '0')"; } $ueb = ($uebergabe) ? $ueb : ''; return $ueb; } function cp_parse_request($id) { $sql_ab = $GLOBALS['db']->Query("SELECT * FROM " . PREFIX . "_queries WHERE Id = '$id'"); $row_ab = $sql_ab->fetchrow(); $sql_ab->Close(); if(is_object($row_ab)) { $eq = ''; $wo = ''; $suchart = ''; $first = ''; $second = ''; $limit = ($row_ab->Zahl < 1) ? 1 : $row_ab->Zahl; $template = $row_ab->Template; $geruest = $row_ab->AbGeruest; $Sortierung = $row_ab->Sortierung; $AscDesc = $row_ab->AscDesc; $ausgabe = $template; $return = ''; $link = ''; $q = $GLOBALS['db']->Query("SELECT Id FROM " . PREFIX . "_documents WHERE Id != '" . def_id() . "' AND Id != '2'" . cp_abkondition($row_ab->Id) . " AND RubrikId = '$row_ab->RubrikId' AND Geloescht != 1 AND DokStatus != 0 AND (DokEnde = 0 || DokEnde > " . time() . ") AND (DokStart = 0 || DokStart < " . time() . ") "); $num = $q->numrows(); $q->Close(); $seiten = ceil($num / $limit); $start = prepage(1) * $limit - $limit; if (@$_SESSION['comments_enable'] == 1) { $q = $GLOBALS['db']->Query("SELECT a.*, b.Id as c_id, b.DokId as c_dokid, COUNT(b.Id) as nums FROM " . PREFIX . "_documents as a LEFT JOIN " . PREFIX . "_module_comment_info as b ON a.Id = b.DokId WHERE a.Id != '" . def_id() . "' AND a.Id != '2'" . cp_abkondition($row_ab->Id) . " AND a.RubrikId = '$row_ab->RubrikId' AND a.Geloescht != 1 AND a.DokStatus != 0 AND (a.DokEnde = 0 || a.DokEnde > " . time() . ") AND (a.DokStart = 0 || a.DokStart < " . time() . ") GROUP BY a.Id ORDER BY $Sortierung $AscDesc LIMIT $start,$limit"); } else { $q = $GLOBALS['db']->Query("SELECT * FROM " . PREFIX . "_documents WHERE Id != '" . def_id() . "' AND Id != '2'" . cp_abkondition($row_ab->Id) . " AND RubrikId = '$row_ab->RubrikId' AND Geloescht != 1 AND DokStatus != 0 AND (DokEnde = 0 || DokEnde > " . time() . ") AND (DokStart = 0 || DokStart < " . time() . ") ORDER BY $Sortierung $AscDesc LIMIT $start,$limit"); } $sql_doc = $GLOBALS['db']->Query("SELECT Titel FROM " . PREFIX . "_documents WHERE Id = '" . def_id() . "'"); $row_doc = $sql_doc->fetchrow(); $sql_doc->Close(); $DocTitel = cp_parse_linkname(stripslashes($row_doc->Titel)); $page_nav = ($row_ab->Navi==1) ? pagenav($seiten, prepage(1), " {t} ") : ""; while($row = $q->fetchrow()) { // Переписано для ЧПУ // $link = (CP_REWRITE==1) ? cp_rewrite('/index.php?id=' . $row->Id . '&doc=' . cp_parse_linkname($row->Titel) ) : '/index.php?id=' . $row->Id . '&doc=' . cp_parse_linkname($row->Titel); $link = $row->Url; $return .= str_replace('[link]', $link, $template); $return = preg_replace("[\[cpabrub:([0-9-]*)\]\[([0-9-]*)\]]", "Id, \"\\2\"); ?>", $return); $return = str_replace('[views]', $row->Geklickt, $return); $return = (@$_SESSION['comments_enable'] == 1) ? str_replace('[comments]', $row->nums, $return) : str_replace('[comments]', "", $return); } $return = str_replace('[link]', $link, $return); $geruest = preg_replace("/(^[\r\n]*|[\r\n]+)[\s\t]*[\r\n]+/", "\n", $geruest); $geruest = str_replace(array("\r\n","\n","\r"),"",$geruest); $geruest = preg_replace("/\
"); $ausg = str_replace("[cp:replacement]", REQUEST_REPLACEMENT, $ausg); $ausg = str_replace("[cp:mediapath]", "/templates/" . T_PATH . "/", $ausg); switch($row->RubTyp) { case 'bild_links' : if(!empty($ausg)) $ausg = ''; $maxlength = ''; break; case 'bild_rechts' : if(!empty($ausg)) $ausg = ''; $maxlength = ''; break; case 'bild' : if(!empty($ausg)) $ausg = ''; $maxlength = ''; break; case 'link' : if(!empty($ausg)) $ausg = ''.phpReplace($ausg).''; $maxlength = ''; break; case 'link_ex' : if(!empty($ausg)) $ausg = ''.phpReplace($ausg).''; $maxlength = ''; break; } if($maxlength != '') $ausg = substr($ausg, 0, $maxlength) . ((strlen($ausg) >= $maxlength) ? '... ' : ''); echo $ausg; } else { } } ?>