= 3 ) { $query = addslashes($query); $navquery = $query ; $query = str_replace('-', ' ', $query); // $result = sql_query("select lid, cid, sid, title, price, headline, description, datum, hits, pic, contacter from ".$prefix."_add_adds where (title LIKE '%$query%' OR headline LIKE '%$query%' or description LIKE '%$query%') and isValidated = 'Yes' and isChanged = 'No' ORDER BY $orderby LIMIT $min,$linksresults", $dbi); // $fullcountresult=sql_query("select lid, title, description, datum, hits, pic from ".$prefix."_add_adds where (title LIKE '%$query%' or headline LIKE '%$query%' or description LIKE '%$query%') and isValidated = 'Yes' and isChanged = 'No'", $dbi); // $totalselectedlinks = sql_num_rows($fullcountresult, $dbi); // $nrows = sql_num_rows($result, $dbi); // $result = sql_query("select title,cdescription, parentid, adds from ".$prefix."_add_categories where cid=$cid", $dbi); // list($title,$description,$parentid,$adds)=sql_fetch_row($result, $dbi); $x=0; $index=1; $pagetitle = trim($query); $metakey=getparentmeta($parentid, $topic); if ($keywords){ $pagemeta = $metakey . ", " . $keywords; } else { $pagemeta = $metakey; } $pagemeta = str_replace('&', '&', $pagemeta); $pagemeta = trim($pagemeta); $topic = str_replace('&', '&', $topic); $pagetopic = trim($topic); $pagedescription = "Artikel mit dem Schlagwort $query"; $pagedescription .= trim(nl2br($description)); $pageheadline = trim(stripslashes($headline)); $pageauthor = $price . " - " . $contacter ; $pageauthor = str_replace('&', '&', $pageauthor); $pageauthor = trim($pageauthor); } include("header.php"); $the_query = stripslashes($navquery); $the_query = str_replace("\'", "'", $the_query); menu(1); OpenTable(); if ($query != "") { if ($nrows>=0) { echo "

Schlagwort $the_query \"${the_query}


"; echo "

"._CSF_USUBCATEGORIES."

"; echo "
\n"; /* echo ""; */ echo "

Artikel zu dem Schlagwort $the_query

"; echo "

"; $orderbyTrans = convertorderbytrans($orderby); echo "
"._CSF_SORTADDSBY.": " .""._CSF_TITLE." (A\D)" .""._CSF_DATE." (A\D)" ."
"._CSF_SITESSORTED.": $orderbyTrans

"; // $resultdata = sql_query("select lid, cid, sid, title, price, headline, description, datum, hits, pic, contacter from ".$prefix."_add_adds where (title LIKE '%$query%' OR description LIKE '%$query%' or town like '%$query%') and isValidated = 'Yes' and isChanged = 'No' ORDER BY $orderby LIMIT $min,$linksresults", $dbi); $resultdata = sql_query("select lid, cid, sid, title, price, headline, description, datum, hits, pic, contacter from ".$prefix."_add_adds where (keywords LIKE '%$query%') and isValidated = 'Yes' and isChanged = 'No' ORDER BY $orderby LIMIT $min,$linksresults", $dbi); while(list($lid, $cid, $sid, $title, $price, $headline, $description, $time, $hits, $pic, $contacter) = sql_fetch_row($resultdata, $dbi)) { $cnewsline_light = "naddsline_light"; $cnewsline = "naddsline"; if ($newsline == $cnewsline) { $newsline = $cnewsline_light; } else { $newsline = $cnewsline; } echo "
"; $title = stripslashes($title); $description = stripslashes($description); $transfertitle = str_replace (" ", "_", $title); $title = ereg_replace($query, "$query", $title); $descshort = ($description) ? substr(htmlentities(strip_tags(stripslashes($description))),0,300).' ...' : ""; echo "
$title
"; echo "${descshort} [mehr]

"; echo "
$datetime
(${hits} gelesen)
"; echo "
\n"; /* Ende newsline */ $x++; } echo "
"; /* Ende newsadds */ echo "
\n"; echo "
" ."
"; $orderby = convertorderbyout($orderby); } else { echo "

"._CSF_NOMATCHES."

"._CSF_GOBACK."
"; } /* Calculates how many pages exist. Which page one should be on, etc... */ $linkpagesint = ($totalselectedlinks / $linksresults); $linkpageremainder = ($totalselectedlinks % $linksresults); if ($linkpageremainder != 0) { $linkpages = ceil($linkpagesint); if ($totalselectedlinks < $linksresults) { $linkpageremainder = 0; } } else { $linkpages = $linkpagesint; } /* Page Numbering */ if ($linkpages!=1 && $linkpages!=0) { echo "

" .""._CSF_SELECTPAGE.": "; $prev=$min-$linksresults; if ($prev>=0) { // echo "  [ " echo "  [ " ." << "._CSF_PREVIOUS." ] "; } $counter = 1; $currentpage = ($max / $linksresults); while ($counter<=$linkpages ) { $cpage = $counter; $mintemp = ($perpage * $counter) - $linksresults + 1; if ($counter == $currentpage) { echo "$counter "; } else { // echo "$counter "; echo "$counter "; } $counter++; } $next=$min+$linksresults; if ($x>=$perpage) { // echo "  [ " echo "  [ " ." "._CSF_NEXT." >> ]"; } } } else { echo "
dies sind zu wenige paramater"._CSF_NOMATCHES."


"; echo "

" ."Alta Vista - " ."HotBot - " ."Infoseek - " ."Deja News - " ."Lycos - " ."Yahoo" ."
" ."LinuxStart - " ."1stLinuxSearch - " ."Google - " ."LinuxLinks - " ."Freshmeat - " ."JustLinux" ."
"; } CloseTable(); copyright(); include("footer.php"); ?>