0"; $res = mysql_query($SQL); if(mysql_num_rows($res)) { while ($line = mysql_fetch_assoc($res)) { $boardings_fix[$line['id']]=$line['name']; } } //города $cityes_fix=array(); $SQL="SELECT * FROM sunmar_cities WHERE id>0"; $res = mysql_query($SQL); if(mysql_num_rows($res)) { while ($line = mysql_fetch_assoc($res)) { $cityes_fix[$line['id']]=$line['name']; } } //страны $countries_fix=array(); $SQL="SELECT * FROM sunmar_country WHERE id>0"; $res = mysql_query($SQL); if(mysql_num_rows($res)) { while ($line = mysql_fetch_assoc($res)) { $countries_fix[$line['id']]=$line['name']; } } //тип комнаты $roomcategories_fix=array(); $SQL="SELECT * FROM sunmar_roomcategories WHERE id>0"; $res = mysql_query($SQL); if(mysql_num_rows($res)) { while ($line = mysql_fetch_assoc($res)) { $roomcategories_fix[$line['id']]=$line['name']; } } //размещение $rooms_fix=array(); $SQL="SELECT * FROM sunmar_roomtypes WHERE id>0"; $res = mysql_query($SQL); if(mysql_num_rows($res)) { while ($line = mysql_fetch_assoc($res)) { $rooms_fix[$line['id']]=$line['name']; } } //звезды $categories_fix=array(); $SQL="SELECT * FROM sunmar_categories WHERE id>0"; $res = mysql_query($SQL); if(mysql_num_rows($res)) { while ($line = mysql_fetch_assoc($res)) { $categories_fix[$line['id']]=$line['name']; } } $operator=785891; $countrys = array( 'Turkey' => 309, 'Egypt' => 315, ); $stars = array( '2*' => 29, '2*+' => 29, '3*' => 30, '3*+' => 30, '4*' => 40, '4*+' => 40, '4*HV'=>40, '5*' => 41, '5*+' => 41, '5*HV'=>41, ); $rooms = array( 'SNG' => 23, '1 PAX' => 23, 'DBL' => 17, '2 PAX' => 17, 'TRPL' => 26, 'DBL+EXB' => 26, '3 PAX' => 26, '4 PAX' => 85, '5 PAX' => 86, '6 PAX' => 120, '7 PAX' => 158, '8 PAX' => 159, ); $pansions = array( 'ALL INCLUSIVE' => 35, 'GALAXY CLUB' => 35, 'A`LA CARTE ALL INCLUSIVE' => 35, 'PREMIER PACKAGE' => 35, 'ULTRA ALL INCLUSIVE' => 42, 'SUPER ALL INCLUSIVE' => 42, 'PREMIUM ALL INCLUSIVE' => 42, 'DELUXE ALL INCLUSIVE' => 42, 'LUXURY ALL INCLUSIVE' => 42, 'EXTRA ALL INCLUSIVE' => 42, 'ABSOLUTE ULTRA' => 42, 'DELUXE AI' => 42, 'FAME STYLE ALL INCLUSIVE' => 42, 'ALL EXCLUSIVE AI' => 42, 'DIAMOND ALL INCLUSIVE' => 42, 'MAXX ALL INCLUSIVE' => 42, 'VIP ALL INCLUSIVE' => 42, 'HIGH CLASS AI' => 42, 'SUPERIOR ALL INCLUSIVE' => 42, 'MEGA ALL INCLUSIVE' => 42, 'HIGH END AI' => 42, 'AI Elegance' => 42, 'BED&BREAKFAST' => 36, 'SNACK ALL INCLUSIVE' => 38, 'HALF BOARD' => 38, 'HB DELUXE' => 38, 'FULL BOARD' => 37, 'SOFT AI' => 37, 'FB DELUXE' => 37, ); $citys = array( 'Moscow' => 33, 'Antalya' => 79, 'Dalaman' => 127, 'Hurghada' => 50, 'Sharm-El-Sheikh' => 80, ); $date_now=date('Y-m-i',time()+86400*30); $price_array=array(); $SQL="SELECT * FROM sunmar_spo_price WHERE ((download=0 and depature_date>'$date_now') or (download=1 and depature_date<='$date_now' and country='51') or download=5) LIMIT 50000"; // $SQL="SELECT * FROM sunmar_spo_price WHERE id=1061502"; $res = mysql_query($SQL); // var_dump(mysql_num_rows($res)); if(mysql_num_rows($res)) { while ($line = mysql_fetch_assoc($res)) { $price_array[]=$line; } } for ($w=0;$w28, "PROPERTY_SUNMAR"=>$hotel); $res = CIBlockElement::GetList(Array(), $arFilter, false, false, $arSelect); while($ob = $res->GetNext()) { // var_dump($ob); $id_hotel=$ob['ID']; $id_city=$ob['IBLOCK_SECTION_ID']; $id_star=$ob['PROPERTY_STAR_VALUE']; } if($id_hotel){ $new_hotel=$id_hotel; $new_city=$id_city; //$new_star=$stars[$star]; $new_star=Gate32_Sale::$stars_gate[$id_star]; $new_room=$rooms[$room]; $new_pansion=$pansions[$meal]; $new_depature_from=$citys[$depature_from]; $new_depature_to=$citys[$depature_to]; $new_depature_date=$depature_date; $new_days=$days; $new_price=$price; if ($new_hotel>0) { $new_status=0; } else { $new_status=2; } // $SQL = "INSERT IGNORE INTO gate_spo_price (id,date_from,date_to,country,city,hotel,operator,star,room,pansion,depature_from,depature_to,depature_date,days,price,status) VALUES ('$new_id','$new_date_from','$new_date_to','$new_country','$new_city','$new_hotel','$new_operator','$new_star','$new_room','$new_pansion','$new_depature_from','$new_depature_to','$new_depature_date','$new_days','$new_price','$new_status');"; // echo $SQL.'
'; // $q = mysql_query($SQL) or die (mysql_error()); // добавление в разделенные таблицы $SQL = "INSERT IGNORE INTO "; if($new_country == 309)($bd = "gate_spo_price_turkish"); if($new_country == 315)($bd = "gate_spo_price_egipt"); $SQL .= $bd."(id,date_from,date_to,country,city,hotel,operator,star,room,pansion,depature_from,depature_to,depature_date,days,price,status) VALUES ('$new_id','$new_date_from','$new_date_to','$new_country','$new_city','$new_hotel','$new_operator','$new_star','$new_room','$new_pansion','$new_depature_from','$new_depature_to','$new_depature_date','$new_days','$new_price','$new_status');"; $q = mysql_query($SQL) or die (mysql_error()); // var_dump($SQL); $SQL = "UPDATE sunmar_spo_price SET download=2 WHERE id=$id LIMIT 1"; $q = mysql_query($SQL) or die (mysql_error()); } else{ $SQL = "UPDATE sunmar_spo_price SET download=5 WHERE id=$id LIMIT 1"; $q = mysql_query($SQL) or die (mysql_error()); } unset($id_hotel); } $part_time = explode (" ", microtime()); $end_time = $part_time[0] + $part_time[1]; $totaltime= $end_time - $begin_time; print("Страница сгенерирована за $totaltime секунд"); ?>