*
* File Name : suche.html
* Last Update : 2010-12-29
*/
include('glob/start.php');
create_thispage($thispage['id'],$thispage['uri'],$thispage['title']);
$search_cattitle = array(1=>"Datenbank",2=>"Screenshots",3=>"Videos",4=>"Downloads",5=>"News");
$search_cat = array(1=>SITE_PAGE_GAMES,2=>SITE_PAGE_GAMES,3=>SITE_PAGE_VIDEOS,4=>SITE_PAGE_DOWNLOADS,5=>SITE_PAGE_NEWS);
$search_source[SITE_PAGE_GAMES] = 'title,descr,entw,publ';
$search_source[SITE_PAGE_NEWS] = 'title,subtitle,text';
$search_source[SITE_PAGE_VIDEOS] = 'title,descr';
$search_source[SITE_PAGE_DOWNLOADS] = 'title,description';
if(isset($q)){
if($qpage[1] && $qpage[2] && $qpage[3] && $qpage[3] || !$qpage) $qpage_all = 1;
if($qpage_all){
$qpage[1] = 1;
$qpage[2] = 1;
$qpage[3] = 1;
$qpage[4] = 1;
$qpage[5] = 1;
}
}
$c_body = '
';
if(isset($q)){
if($qarr && $qpage){
foreach(array_keys($qpage) as $key){
if(array_key_exists($key, $search_cat)){
foreach($qarr2 as $val){
$query_forsearch[$key] .= (($query_forsearch[$key]) ? ' and ':NULL).' (LOWER(CONCAT('.$search_source[$search_cat[$key]].')) LIKE LOWER(\'%'.$val.'%\') COLLATE latin1_german1_ci)';
}
$result = $sm_db->query("SELECT id, title FROM ".$page[$page['childrendb'][$search_cat[$key]]]['dbtable']." WHERE ".$query_forsearch[$key]." and status='".STATUS_ONLINE."'".(($key==3 || $key==4)?" and server!=''":NULL)." ORDER BY title") or mysql_die($sm_db); $querynum2++;
while($result && $db = mysqli_fetch_assoc($result)){
if($key==2 && $games_comp[$db['id']]['img'] || $key!=2){
$title = preg_replace($qarr, "$0", stripslashes(htmlentities($db['title'])));
$zc_item[$key]++;
$text[$key] .= '
';
}
}
}
}
foreach($qpage as $key=>$val){
$c_body .= '
'.$search_cattitle[$key].' ('.(($zc_item[$key])?$zc_item[$key]:0).')
'.
(($text[$key])?'':'
Es wurden keine Treffer gefunden.
').'
';
}
}elseif(!$q){
$c_body .= '
Es wurden keine Suchbegriffe eingegeben.
';
}elseif(!$qpage){
$c_body .= '
Es wurden keine Seiten angegeben.
';
}
}
include('glob/end.php');
?>