$left = $total; echo $total . " keywords\r\n"; $start_time = date('U'); $kws = array(); $keyword = new Keyword($db); $fp = fopen("../output/" . str_replace(" ", "_", $campaign->ga_campaign_name) . ".csv", "w+"); fputs($fp, "Campaign,Daily Budget,Language,Location,Proximity Targets,Ad Schedule,Ad Group,Max CPC,Keyword Type,Keyword,Image,Ad Name,Image Size,Display URL,Destination URL\r\n"); foreach ($resultArry as $val) { $adgroup = new GoogleImageAdGroup($db); $adgroup->giag_campaign_id = $campaign->ga_campaign_id; $adgroup->giag_display_url = DISPLAY_URL; $adgroup->buildDestinationUrl($val); $adgroup->save(); $adgroup->giag_name = "Ad " . $adgroup->giag_id . " " . $val['keyword']; $adgroup->save(); $ad = $adgroup->buildAds("http://images.kabel.co.il/photo/?url=" . $val['l_image'] . "§ion=realestate"); fputs($fp, "{$campaign->ga_campaign_name},20,iw,IL,,,{$adgroup}," . MAX_CPC . "\r\n"); foreach ($adgroup->ads as $add) { fputs($fp, "{$campaign->ga_campaign_name},,,,,,{$adgroup},,,," . $add->gia_image . "," . $add->gia_name . "," . $add->gia_size . "," . $adgroup->giag_display_url . ",\"" . $adgroup->giag_destination_url . "\"\r\n"); } $tmp = explode(" ", $val['keyword']); $search = ""; foreach ($tmp as $t) { $search .= " and (keyword LIKE '% " . addslashes($t) . " %' or keyword LIKE '% " . addslashes($t) . "' or keyword LIKE '" . addslashes($t) . " %')"; } $db->executeSQL("SELECT keyword_id, keyword FROM keywords WHERE 1 {$search}", $resultArry2, $rowsAffected); foreach ($resultArry2 as $r2) { if (!in_array($r2['keyword'], $kws)) { $c++; $data .= stripslashes($r2['keyword']) . "\r\n"; $kws[] = $r2['keyword'];
function testBuildAds() { $this->assertTrue($this->item->buildAds("test_source_image.jpg")); }