Группа: Пользователь
Ранг: Мастер
Регистрация: 29.10.2009
<? php if( defined ( 'BASE_DIR' )) exit; $inc = substr ( dirname ( __FILE__ ), 0 , - 6 ); define ( 'BASE_DIR' , $inc ); $locale = $_SESSION [ 'lang' ]; if( $locale == 'ru' ) { @ setlocale ( LC_ALL , 'ru_RU.CP1251' , 'ru_RU.cp1251' , 'rus_RUS.CP1251' , 'Russian_Russia.1251' , 'ru_RU' , 'ru' , 'russian' ); } else { @ setlocale ( LC_ALL , $locale . _ . strtoupper ( $locale ), $locale ); } include_once( BASE_DIR . '/lib/sysinit.php' ); include_once( BASE_DIR . '/config/db.config.php' ); include_once( BASE_DIR . '/class/Class.DB.php' ); include_once( BASE_DIR . '/functions/Func.Session.php' ); session_start (); session_name ( 'SID' ); $handlec = opendir ( BASE_DIR . '/functions/' ); while ( $file = readdir ( $handlec )){ if( $file { 0 } != '.' ) { if( is_file ( BASE_DIR . '/functions/' . $file )) { include_once( BASE_DIR . '/functions/' . $file ); } } } closedir ( $handlec ); define ( "PREFIX" , $config [ 'dbprefix' ]); $GLOBALS [ 'db' ] = new DB ( $config [ 'dbhost' ], $config [ 'dbuser' ], $config [ 'dbpass' ], $config [ 'dbname' ]); $LC = @ $_SESSION [ 'Langcode' ]; header ( 'Content-type: text/html; charset=' . $_SESSION [ 'Charset' ]); define ( 'AJAX_OUTPUT' , 1 ); $q = preg_replace ( '/[^:-A-Za-zА-Яа-яЁё0-9_. ]/' , '' , win1251 (@ $_REQUEST [ 'q' ])); $q = strtolower ( $q ); session_start (); session_name ( 'SID' ); if (! $q ) return; $res = array(); $result = $GLOBALS [ 'db' ]-> Query ( "SELECT a.Titel_ { $LC } AS Name FROM " . PREFIX . "_shop_produkte as a, " . PREFIX . "_shop_kategorie as b WHERE a.Kategorie = b.Id AND b.Aktiv = '1' AND a.Titel_ { $LC } LIKE '%" . $q . "%' AND a.Aktiv='1' AND ( (a.Gruppen = '') OR (a.Gruppen LIKE '%, $_SESSION [ user_group ] ') OR (a.Gruppen LIKE ' $_SESSION [ user_group ] ,%') OR (a.Gruppen LIKE '%, $_SESSION [ user_group ] ,%') OR (a.Gruppen = ' $_SESSION [ user_group ] ')) ORDER BY a.Titel_ { $LC } ASC LIMIT 45 " ); while( $row = $result -> fetchrow ()) { array_push ( $res , $row -> Name ); } foreach ( $res as $key => $value ) { if ( strpos ( strtolower ( $value ), $q ) !== false ) echo stripslashes ( '"' . sysspecialchars ( $value )) . '"' . "\n" ; } ?>
Вложения