base_query($sql); $amount = $mydb->base_num_rows(); if ($amount == 0) { header('HTTP/1.0 404 Not Found'); exit(); } while ($row = $mydb->base_Fetch_Array()) $section_row = $row; if (!empty($marka)) { $sql = "SELECT maker_id, maker_name, maker_desc FROM makers WHERE maker_name='".$marka."'"; $mydb->base_query($sql); if (!($row = $mydb->base_Fetch_Array())) die("Ошибка #10678"); $brand = $row["maker_id"]; $brand_name = $row["maker_name"]; } if (!empty($ser_alias)) { $sql = "SELECT * FROM mb_series WHERE ser_alias='".$ser_alias."' AND ser_brand_id='".$brand."'"; $mydb->base_query($sql); if (!($row = $mydb->base_Fetch_Array())) die("Ошибка #10679"); $ser_id = $row["ser_id"]; $ser_name = $row["ser_name"]; $ser_desc = $row["ser_desc"]; $ser_models = $row["ser_models"]; } $mods = explode(",", $ser_models); /*Выборка моделей*/ $sql = "SELECT DISTINCT models.model_id, models.model_name, models.model_bestprice, models.model_offers, makers.maker_name, makers.maker_id, sections.alias FROM models LEFT JOIN makers ON makers.maker_id=models.maker_id LEFT JOIN sections ON sections.id=models.section_id WHERE 1"; if (count($mods) != 0) { $sql .= " AND (model_id='0'"; foreach ($mods as $key => $msg) { $sql .= " OR model_id='".$msg."'"; } $sql .= ")"; } $sql .= " ORDER BY "; $sql .= "model_offers DESC"; $mydb->base_query($sql); while ($row = $mydb->base_Fetch_Array()) { $items[] = $row; $pics_ids[] = $row["model_id"]; } /*Выбор фоток для выбранных объявлений*/ if (count($pics_ids)!=0) { $sql = "SELECT * FROM pics WHERE model_id='0'"; foreach ($pics_ids as $key => $msg) { $sql .= " OR model_id='".$msg."'"; } $sql .= " ORDER BY id ASC"; $mydb->base_query($sql); while ($row = $mydb->base_Fetch_Array()) { $pics[$row["model_id"]][] = $row["pic_name"]; } } /*Выбор брендов для формы поиска*/ $brands[] = "не важно"; $brands_v[] = 0; $sql = "SELECT * FROM makers LEFT JOIN sections ON sections.id=makers.section_id WHERE alias='".$section."' ORDER BY maker_name ASC"; $mydb->base_query($sql); while ($row = $mydb->base_Fetch_Array()) { $brands[] = $row["maker_name"]; $brands_v[] = $row["maker_id"]; } /*Варианты типа корпуса*/ $sql = "SELECT * FROM properties WHERE prop_id='38'"; $mydb->base_query($sql); $row = $mydb->base_Fetch_Array(); $forms_arr = unserialize($row["prop_params"]); $forms[] = "не важно"; $forms_v[] = 0; foreach ($forms_arr as $key => $msg) { $forms[]=strtolower($msg); $forms_v[]=$key+1; } //$title = $section_row["name"]." ".$brand_name.". Купить ".$section_row["name"]." ".$brand_name." в каталоге интернет-магазинов, сравнив цены, отзывы, характеристики"; $title = "Серия ".$ser_name.", ".$section_row["name"]." ".$brand_name; ?> - СотоГид