base_query($sql.$sql_best);
$ad = $mydb->base_Fetch_Array();
/*Выборка объявления по ID*/
$sql_id = " WHERE ad_id='".$id."'";
$mydb->base_query($sql.$sql_id);
if (!($AdRow = $mydb->base_Fetch_Array())) {
header("Location: /classified/fail/");
exit();
}
/*Считаем просмотр*/
$sql = "UPDATE mb_ads SET ad_shows=ad_shows+1 WHERE ad_id='".$id."'";
$mydb->base_query($sql);
// Средняя цена на новый телефон
$sql = "SELECT * FROM mix_offers
LEFT JOIN mix_adv ON mix_adv.adv_id=mix_offers.of_advid
WHERE (
(of_name='".$AdRow["model_name"]."' OR of_name LIKE '%".$AdRow["model_name"]." %' OR of_name LIKE '%".$AdRow["model_name"]."' OR of_desc LIKE '%".$AdRow["model_name"].";%' OR of_name LIKE '%".$AdRow["model_name"].".%') ";
if (!empty($AdRow["model_syn1"])) $sql .= "OR (of_name='".$AdRow["model_syn1"]."' OR of_name LIKE '%".$AdRow["model_syn1"]." %' OR of_name LIKE '%".$AdRow["model_syn1"]."' OR of_desc LIKE '%".$AdRow["model_syn1"].";%' OR of_name LIKE '%".$AdRow["model_syn1"].".%') ";
if (!empty($AdRow["model_syn2"])) $sql .= "OR (of_name='".$AdRow["model_syn2"]."' OR of_name LIKE '%".$AdRow["model_syn2"]." %' OR of_name LIKE '%".$AdRow["model_syn2"]."' OR of_desc LIKE '%".$AdRow["model_syn2"].";%' OR of_name LIKE '%".$AdRow["model_syn2"].".%') ";
if (!empty($AdRow["model_syn3"])) $sql .= "OR (of_name='".$AdRow["model_syn3"]."' OR of_name LIKE '%".$AdRow["model_syn3"]." %' OR of_name LIKE '%".$AdRow["model_syn3"]."' OR of_desc LIKE '%".$AdRow["model_syn3"].";%' OR of_name LIKE '%".$AdRow["model_syn3"].".%') ";
$sql .= ") AND of_brand='".$AdRow["maker_id"]."' AND of_cat='9'";
$mydb->base_query($sql);
$total_offers = $mydb->base_num_rows(); //Кол-во предложений
$middle_newprice = array();
$tmp_adv = 0;
while ($row = $mydb->base_Fetch_Array())
{
$middle_newprice[] = $row["of_price"];
$rows[] = $row;
$tmp_adv = $row["adv_id"];
}
$middle_newprice = array_sum($middle_newprice)/count($middle_newprice);
//Цена на бу телефон
$sql = "SELECT ad_price FROM mb_ads WHERE ad_model='".$AdRow["model_id"]."'";
$mydb->base_query($sql);
$total_ads = $mydb->base_num_rows();
$middle_oldprice = array();
while ($row = $mydb->base_Fetch_Array())
{
$middle_oldprice[] = $row["ad_price"];
}
$middle_oldprice = array_sum($middle_oldprice)/count($middle_oldprice);
/*Фотки объявления*/
$sql = "SELECT * FROM mb_ads_pics WHERE p_ad='".$AdRow["ad_id"]."' ORDER BY p_id ASC";
$mydb->base_query($sql);
while ($row = $mydb->base_Fetch_Array())
{
$pics[]=$row["p_name"];
}
/*Служебные Переменные*/
$month = $monthn[date("n", $AdRow["ad_date"])];
$m = date("n", $AdRow["ad_buydate"]);
if ($m == 12 or $m == 1 or $m == 2) $when = "зимой";
if ($m == 3 or $m == 4 or $m == 5) $when = "весной";
if ($m == 6 or $m == 7 or $m == 8) $when = "летом";
if ($m == 9 or $m == 10 or $m == 11) $when = "осенью";
?>
Объявление № - СотоГид
