Exemplo n.º 1
0
     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'];
         $keyword->load($r2['keyword_id']);
         foreach ($adgroup->ads as $aval) {
             $keyword->addToGoogleAd($aval->gia_id);
         }
         fputs($fp, "{$campaign->ga_campaign_name},,,,,,{$adgroup}," . MAX_CPC . "," . DEFAULT_MATCH_TYPE . "," . str_replace(",", " ", $keyword->keyword) . "\r\n");
     }
 }
 $cond = '';
 $db->executeSQL("SELECT * FROM {$table} WHERE keyword_id={$val['keyword_id']}", $resultArry2, $rowsAffected);
 foreach ($resultArry2[0] as $k => $v) {
     if ($k != 'keyword_id' && $k != 'l_latitude' && $k != 'l_longitude') {
         $cond .= " and {$k}='" . addslashes($v) . "'";
     }
 }
 $db->executeSQL("SELECT keyword_id FROM {$table} WHERE 1 {$cond}", $resultArry2, $rowsAffected);
 foreach ($resultArry2 as $r2) {
     $keyword->load($r2['keyword_id']);
     if (!in_array($keyword->keyword, $kws)) {