if (!$rowsAffected) { break; } $total = $rowsAffected; foreach ($resultArry as $val) { $campaign = new GoogleCampaign($db); $campaign->ga_campaign_name = "Real Estate Sale " . $val['l_geo_city']; $campaign->save(); echo $c . "/" . ++$i . "/" . $total . "\r\n"; $ag = new GoogleAdGroup($db); $ag->m_sMainTable = 'realestate'; $ag->gag_l_id = $val['l_id']; $ag->createName(); $ag->save(); $ag->buildAds(array('GoogleAdRealEstateRU5', 'GoogleAdRealEstateRU6', 'GoogleAdRealEstateRU7', 'GoogleAdRealEstateRU12', 'GoogleAdRealEstateRU13'), $val); $ag->buildRealestateKeywordsRU($val); $ag->saveAds($fp, $campaign->ga_campaign_name); if (!$ag->is_has_ads) { echo "no good ads\r\n"; continue; } $ag->m_aKeywords = array_unique($ag->m_aKeywords); foreach ($ag->m_aKeywords as $val2) { fputs($fp, "{$campaign->ga_campaign_name},,,,,," . $ag->gag_name . "," . MAX_CPC . "," . DEFAULT_MATCH_TYPE . ",{$val2}\r\n"); } $c++; $main_db->executeSQL("SELECT *, count(*) as cnt FROM realestate\n\tWHERE \tl_deal_type = 1 and \n\t\t\tl_www_id = 1369 and \n\t\t\tl_isActive = 1 and \n\t\t\tl_d_price > 1000 and\n\t\t\tl_geo_city LIKE '%{$val['l_geo_city']}%' and\n\t\t\tl_assetType = 'Квартира'\n\tGROUP BY \n\t\tl_geo_city \n\tORDER BY \n\t\tcnt DESC \n\tLIMIT 1", $resultArry2, $rowsAffected2); echo $c . "/" . ++$i . "/" . $total . "\r\n"; $ag->m_aKeywords = array(); $ag->ads = array(); $ag->buildAds(array('GoogleAdRealEstateRU8', 'GoogleAdRealEstateRU9', 'GoogleAdRealEstateRU10', 'GoogleAdRealEstateRU11', 'GoogleAdRealEstateRU12'), $resultArry2[0]);
} $total = $rowsAffected; foreach ($resultArry as $val) { $asset_types = explode("/", $val['l_assettype']); foreach ($asset_types as $asset_type) { $val['l_assettype_en'] = assetTypeEn($asset_type); $val['l_assettype'] = $asset_type; echo $c . "/" . ++$i . "/" . $total . "\r\n"; $ag = new GoogleAdGroup($db); $ag->m_sMainTable = 'realestate'; $ag->gag_l_id = $val['l_id']; $ag->createName($val); $ag->save(); $ag->buildAds(array('GoogleAdRealEstateRU9', 'GoogleAdRealEstateRU10', 'GoogleAdRealEstateRU11', 'GoogleAdRealEstateRU12', 'GoogleAdRealEstateRU13'), $val); //), $val); $ag->buildRealestateKeywordsRU($val); $ag->saveAds($fp, $campaign->ga_campaign_name); if (!$ag->is_has_ads) { echo "no good ads\r\n"; continue; } //$ag->m_aKeywords = array_unique($ag->m_aKeywords); //echo "Keywords count = ". count($ag->m_aKeywords)." "; $kc = 0; foreach ($ag->m_aKeywords as $v) { echo $v['keyword'] . "\n\r"; $kc++; $k++; $kk++; if ($k >= 2500) { break;