get_results("SELECT * FROM `".$wpdb->prefix."mban_banner` ORDER BY `id` ASC;"); foreach($adverts as $advert) { // Use jQuery Clicktracker? if($adrotate_config['clicktracking'] == 'Y') { $target_url = esc_attr($advert->target); $track_link = ''; } else { $target_url = '%link%'; $track_link = esc_attr($advert->target); } $adcode = ''; // Enabled or Disabled if($advert->status == 1) { $status = 'active'; } else { $status = 'disabled'; } // Format advert $advertdata['title'] = '[Imported] '.esc_attr($advert->name); $advertdata['bannercode'] = $adcode; $advertdata['thetime'] = $now; $advertdata['updated'] = $now; $advertdata['author'] = $current_user->user_login; $advertdata['imagetype'] = 'field'; $advertdata['image'] = esc_attr($advert->image_url); $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) { list($smonth, $sday, $syear) = explode('/', esc_attr($advert->start_date)); $start_date = gmmktime(0, 0, 0, $smonth, $sday, $syear); list($emonth, $eday, $eyear) = explode('/', esc_attr($advert->end_date)); $end_date = gmmktime(0, 0, 0, $emonth, $eday, $eyear); $wpdb->insert($wpdb->prefix.'adrotate_schedule', array('name' => 'Imported schedule for advert '.$ad_id, 'starttime' => $start_date, 'stoptime' => $end_date, 'maxclicks' => 0, 'maximpressions' => 0, 'spread' => 'N', 'dayimpressions' => 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)); } if($include_stats == 1) { $wpdb->insert($wpdb->prefix.'adrotate_stats', array('ad' => $ad_id, 'group' => 0, 'block' => 0, 'thetime' => $now, 'clicks' => esc_attr($advert->clicks), 'impressions' => 0)); } 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(); } } ?>