get_results("SELECT * FROM `".$wpdb->prefix."posts` WHERE `post_type` = 'adverts_posts' ORDER BY `id` ASC;");
foreach($adverts as $advert) {
$meta_advert = get_post_meta($advert->ID);
if($meta_advert['akp_media_type'][0] == 'image' OR $meta_advert['akp_media_type'][0] == 'text' OR $meta_advert['akp_media_type'][0] == 'adsense') {
// Open in new window?
if($meta_advert['akp_target'][0] == 'blank') {
$new_window = ' target="_blank"';
} else {
$new_window = '';
}
// Use jQuery Clicktracker?
if($adrotate_config['clicktracking'] == 'Y') {
$target_url = esc_attr($advert->post_title);
$track_link = '';
} else {
$target_url = '%link%';
$track_link = esc_attr($advert->post_title);
}
// Image Url and AdCode
$image = $imagetype = $adcode = '';
if($meta_advert['akp_media_type'][0] == 'image') {
$image_id = $wpdb->get_var("SELECT `ID` FROM `".$wpdb->prefix."posts` WHERE `post_type` = 'attachment' AND `post_parent` = ".$advert->ID." AND `post_status` = 'inherit' ORDER BY `id` ASC;");
$upload_dir = wp_upload_dir();
$adcode = '
';
$image = $upload_dir['baseurl'].get_post_meta($image_id, '_wp_attached_file', 1);
$imagetype = 'field';
} else if($meta_advert['akp_media_type'][0] == 'text') {
$adcode = ''.get_post_meta($advert->ID, 'akp_text', 1).'';
$image = '';
$imagetype = '';
} else if($meta_advert['akp_media_type'][0] == 'adsense') {
$adcode = get_post_meta($advert->ID, 'akp_adsense_code', 1);
$image = '';
$imagetype = '';
}
// Enabled or Disabled
if($advert->post_status == 'publish') {
$status = 'active';
} else {
$status = 'disabled';
}
// Format advert
$advertdata['title'] = '[Imported] Ad King Pro banner '.$advert->ID;
$advertdata['bannercode'] = $adcode;
$advertdata['thetime'] = $now;
$advertdata['updated'] = $now;
$advertdata['author'] = $current_user->user_login;
$advertdata['imagetype'] = $field;
$advertdata['image'] = $image;
$advertdata['link'] = $track_link;
$advertdata['tracker'] = 'Y';
$advertdata['responsive'] = 'N';
$advertdata['type'] = $status;
$advertdata['weight'] = 6;
$advertdata['sortorder'] = 0;
$advertdata['cbudget'] = 0;
$advertdata['ibudget'] = 0;
$advertdata['crate'] = 0;
$advertdata['irate'] = 0;
$advertdata['cities'] = array();
$advertdata['countries'] = array();
$wpdb->insert($wpdb->prefix."adrotate", $advertdata);
$ad_id = $wpdb->insert_id;
if($include_schedules == 1) {
$wpdb->insert($wpdb->prefix.'adrotate_schedule', array('name' => 'Imported schedule for advert '.$ad_id, 'starttime' => $now, 'stoptime' => $meta_advert['akp_expiry_date'][0], 'maxclicks' => 0, 'maximpressions' => 0, 'spread' => 'N', 'hourimpressions' => 0));
$schedule_id = $wpdb->insert_id;
$wpdb->insert($wpdb->prefix.'adrotate_linkmeta', array('ad' => $ad_id, 'group' => 0, 'block' => 0, 'user' => 0, 'schedule' => $schedule_id));
}
unset($advertdata, $adcode, $new_window, $track_link, $target_url, $status, $ad_id, $schedule_id);
}
}
wp_redirect('admin.php?page=adrotate-switch&s=1');
} else {
adrotate_nonce_error();
}
}
?>