get_results("SELECT * FROM `".$wpdb->prefix."useful_banner_manager_banners` ORDER BY `id` ASC;"); if(is_array($adverts)) { foreach($adverts as $advert) { // target attr $new_window = ' target="'.esc_attr($advert->link_target).'"'; // rel attr $link_rel = ' rel="'.esc_attr($advert->link_rel).'"'; // alt attr $alt_attr = ' alt="'.esc_attr($advert->banner_alt).'"'; $adcode = ''; // Enabled or Disabled if($advert->is_visible == 'yes') { $status = 'active'; } else { $status = 'disabled'; } // Format advert $image = esc_attr($advert->id).'-'.esc_attr($advert->banner_name).'.'.esc_attr($advert->banner_type); $advertdata = adrotateswitch_format_advert('Max Banner Ads', $advert->banner_title, $adcode, 'field', $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) { list($eyear, $emonth, $eday) = explode('-', esc_attr($advert->active_until)); $end_date = gmmktime(0, 0, 0, $emonth, $eday, $eyear); $wpdb->insert($wpdb->prefix.'adrotate_schedule', array('name' => 'Imported schedule for advert '.$ad_id, 'starttime' => $now, 'stoptime' => $end_date, 'maxclicks' => 0, 'maximpressions' => 0, 'spread' => 'N', 'hourimpressions' => 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, $link_rel, $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(); } } ?>