Автомобилей: 0 Запчастей: 0 Посетителей online: 5 Зарегистрируйтесь в системе прямо сейчас - это чрезвычайно просто и абсолютно бесплатно! e-mail:    пароль:    забыли пароль? '; echo " "; echo "рекомендуем :: автосалоны ta4ka.ru "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // empty line echo ""; echo ""; echo ""; echo ""; echo ""; // empty line echo ""; // echo ""; echo ""; // empty line echo ""; echo ""; echo ""; echo " "; echo "Марка "; // $cars_names=mysql_query("select * from cars_names order by name"); $partner_name=$_POST[partner_name]; $vendor=$_POST[vendor]; $offers_query="select cars_names.id,cars_names.name,count(*) from ta4ka_partners,cars_names where (cars_names.id=ta4ka_partners.cars1_id or cars_names.id=ta4ka_partners.cars2_id or cars_names.id=ta4ka_partners.cars3_id) and show_=1 group by cars_names.id order by cars_names.name"; // echo "[$offers_query]"; echo "любая"; $cars_names=mysql_query($offers_query); $t_cars_names=($cars_names!=NULL)?mysql_num_rows($cars_names):0; for ($i=0;$i<$t_cars_names;$i++) { $c_id=mysql_result($cars_names,$i,"id"); $c_name=mysql_result($cars_names,$i,"name"); $s=($c_id==$vendor)?" selected":""; $now=time(0); // $offers=mysql_query("select count(*) from ta4ka_offers where what=".intval($p)." and validtill>=$now and vendor=$c_id"); // if ($offers!=NULL) // if (mysql_result($offers,0,"count(*)")>0) echo "$c_name"; } $city=$_POST["city"]; if ($city=="" && $GEO_city_id!="") $city=$GEO_city_id; echo ""; echo " Город "; echo "любой"; $cities_query="select cities.id,cities.name,count(*) from ta4ka_partners,cities where cities.id=ta4ka_partners.city_id and show_=1 group by cities.id order by cities.name"; $cities=mysql_query($cities_query); $t_cities=@mysql_num_rows($cities); for ($i=0;$i<$t_cities;$i++) { $c_id=mysql_result($cities,$i,"id"); $c_name=mysql_result($cities,$i,"name"); echo "$c_name"; } echo ""; echo " "; echo "Ближайшая станция метро "; echo "любая"; $stations=mysql_query("select * from metro_stations where city_id=$city order by name"); $t_stations=@mysql_num_rows($stations); for ($i=0;$i<$t_stations;$i++) { $s_id=mysql_result($stations,$i,"id"); $s_name=mysql_result($stations,$i,"name"); echo "$s_name"; } echo ""; echo " "; echo "Наименование автосалона "; echo ""; echo " Автозапчасти"; // echo " Автосервис"; echo " Продажа грузовых автомобилей"; echo " Продажа легковых автомобилей"; echo " Торговля аварийными автомобилями"; echo " "; echo " "; if ($_POST[search]!="") { $search_query="select * from ta4ka_partners where id>0 and show_=1 ". ((trim($partner_name)!="")?" and name like '%$partner_name%'":""). (($_POST[vendor]!=-1)?" and (". ($_POST[vendor]!=-1?"cars1_id=$_POST[vendor]":"cars1_id!=''"). " or ". ($_POST[vendor]!=-1?"cars2_id=$_POST[vendor]":"cars2_id!=''"). " or ". ($_POST[vendor]!=-1?"cars3_id=$_POST[vendor]":"cars3_id!=''"). ")":""). (($city!=-1)?" and city_id=$city":""). (($_POST[metro]!=-1)?" and metro_id=$_POST[metro]":""). (($_POST[parts]==1)?" and act_parts=1":""). (($_POST[service]==1)?" and act_service=1":""). (($_POST[moving]==1)?" and act_moving=1":""). (($_POST[cars]==1)?" and act_cars=1":""). (($_POST[crashed]==1)?" and act_crashed=1":"") ; // echo "[$search_query]"; $partners=mysql_query($search_query); $t_partners=@mysql_num_rows($partners); if ($t_partners==0) echo "Ничего не найдено"; else { echo ""; // echo ""; for ($i=0;$i<$t_partners;$i++) { $p_id=mysql_result($partners,$i,"id"); $p_cars1_id=mysql_result($partners,$i,"cars1_id"); $p_cars2_id=mysql_result($partners,$i,"cars2_id"); $p_cars3_id=mysql_result($partners,$i,"cars3_id"); $p_cars1_name=@mysql_result(@mysql_query("select name from cars_names where id=$p_cars1_id"),0,"name"); $p_cars2_name=@mysql_result(@mysql_query("select name from cars_names where id=$p_cars2_id"),0,"name"); $p_cars3_name=@mysql_result(@mysql_query("select name from cars_names where id=$p_cars3_id"),0,"name"); $p_name=mysql_result($partners,$i,"name"); $p_city_id=mysql_result($partners,$i,"city_id"); $p_city_name=@mysql_result(@mysql_query("select name from cities where id=$p_city_id"),0,"name"); $p_address=mysql_result($partners,$i,"address"); $p_phone=mysql_result($partners,$i,"phone"); $p_web=mysql_result($partners,$i,"web"); $p_email=mysql_result($partners,$i,"email"); $p_comments=mysql_result($partners,$i,"comments"); $p_user_id=mysql_result($partners,$i,"user_id"); echo ""; } echo " Марка Партнер ta4ka.ru Адрес Телефон WWW / E-mail Примечания Прайс-листы "; echo ""; echo ""; $c_names=""; echo ""; echo ""; echo ""; echo " "; if ($p_user_id) echo ""; echo "$p_name"; if ($p_user_id) echo " "; if ($p_user_id) echo ""; if ($p_cars1_name!="") $c_names.=(($c_names=="")?"":", ").$p_cars1_name; if ($p_cars2_name!="") $c_names.=(($c_names=="")?"":", ").$p_cars2_name; if ($p_cars3_name!="") $c_names.=(($c_names=="")?"":", ").$p_cars3_name; if ($c_names!="") echo "Специализация: $c_names "; // echo (($p_city_name!="")?"$p_city_name ":""); echo "$p_address $p_phone ".(($p_web!="")?"$p_web ":"")."$p_email $p_comments "; $prices=mysql_query("select * from ta4ka_files where partner_id=$p_id and type=1"); $t_prices=@mysql_num_rows($prices); if ($t_prices==0) { } else { echo "Прайс-листы: "; for ($x=0;$x<$t_prices;$x++) { $filename=mysql_result($prices,$x,"filename"); $stuff=split("/",$filename); $filename=$stuff[count($stuff)-1]; echo "$filename "; } } echo " "; $photo_filename=@mysql_result(@mysql_query("select filename from ta4ka_files where partner_id=$p_id and type=0"),0,"filename"); $stuff=split("/",$photo_filename); $photo_filename=$stuff[count($stuff)-1]; if ($photo_filename!="") echo " "; if ($p_user_id) echo ""; echo " "; } echo " "; } echo " "; ?> Fatal error: Uncaught Error: Class 'TNX_n' not found in /var/www/ta4ka.ru/index.php:970 Stack trace: #0 {main} thrown in /var/www/ta4ka.ru/index.php on line 970