get_results("SELECT * FROM `".$wpdb->prefix."posts` WHERE `post_type` = 'adverts_posts' ORDER BY `id` ASC;");
if(is_array($adverts)) {
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 = '';
}
// 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 = adrotateswitch_format_advert('Ad King Pro', 'banner '.$advert->ID, $adcode, $imagetype, $image, 'Y', 'Y', 'Y', 'Y', 'N', $status, 6, 0, 0, 0);
$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', 'dayimpressions' => 0, 'daystarttime' => '0000', 'daystoptime' => '0000', 'day_mon' => 'Y', 'day_tue' => 'Y', 'day_wed' => 'Y', 'day_thu' => 'Y', 'day_fri' => 'Y', 'day_sat' => 'Y', 'day_sun' => 'Y'));
$schedule_id = $wpdb->insert_id;
$wpdb->insert($wpdb->prefix.'adrotate_linkmeta', array('ad' => $ad_id, 'group' => 0, 'user' => 0, 'schedule' => $schedule_id));
}
unset($advertdata, $adcode, $new_window, $track_link, $target_url, $status, $ad_id, $schedule_id);
}
}
} else {
wp_redirect('admin.php?page=adrotate-switch&s=2');
}
wp_redirect('admin.php?page=adrotate-switch&s=1');
} else {
adrotate_nonce_error();
}
}
?>