0) {
// Sort out adwidth and adheight
if((is_numeric($adwidth) AND $adwidth < 1 OR $adwidth > 9999) OR $adwidth == '' OR !is_numeric($adwidth)) {
$adwidth = '';
} else {
$adwidth = ' width="'.$adwidth.'"';
}
if((is_numeric($adheight) AND $adheight < 1 OR $adheight > 9999) OR $adheight == '' OR !is_numeric($adheight)) {
$adheight = '';
} else {
$adheight = ' height="'.$adheight.'"';
}
// Determine image settings ($basic_field has priority!)
if(strlen($basic_field) > 1) {
$imagetype = "field";
$image = $basic_field;
$asset = "![](\"%asset%\"".$adwidth.$adheight.")
";
} else if(strlen($basic_dropdown) > 1) {
$imagetype = "dropdown";
$image = WP_CONTENT_URL."/%folder%/".$basic_dropdown;
$asset = "";
} else {
$imagetype = $image = "";
$asset = $advert_text; // Text advert
}
// Open in a new window?
if(isset($new_window) AND strlen($new_window) != 0) {
$new_window = ' target="_blank"';
} else {
$new_window = '';
}
// Set nofollow?
if(isset($nofollow) AND strlen($nofollow) != 0) {
$nofollow = ' rel="nofollow"';
} else {
$nofollow = '';
}
// Generate code
$bannercode = "".$asset."";
}
// HTML5/FLASH advert
if(strlen($html5_dropdown) > 0) {
$imagetype = "dropdown";
$image = WP_CONTENT_URL."/%folder%/".$html5_dropdown;
// Sort out adwidth and adheight
if((is_numeric($html5_adwidth) AND $html5_adwidth < 1 OR $html5_adwidth > 9999) OR $html5_adwidth == '' OR !is_numeric($html5_adwidth)) {
$adwidth = '728';
} else {
$adwidth = $html5_adwidth;
}
if((is_numeric($html5_adheight) AND $html5_adheight < 1 OR $html5_adheight > 9999) OR $html5_adheight == '' OR !is_numeric($html5_adheight)) {
$adheight = '90';
} else {
$adheight = $html5_adheight;
}
// Set clickTAG?
if(isset($html5_clicktag) AND strlen($html5_targeturl) > 10) {
$clicktag = '?'.$html5_clicktag.'='.$html5_targeturl;
} else {
$clicktag = '';
}
// Determine advert type
$extension = explode(".", $html5_dropdown);
$extension = end($extension);
// Generate HTML5 code
if($extension == "html" OR $extension == "htm") {
$bannercode = "";
}
// Generate Flash advert
if($extension == "flv" OR $extension == "swf") {
$bannercode = "";
}
}
// Save the ad to the DB
$wpdb->update($wpdb->prefix.'adrotate', array('bannercode' => $bannercode, 'imagetype' => $imagetype, 'image' => $image), array('id' => $id));
adrotate_return('adrotate-ads', 226, array('view' => 'edit', 'ad'=> $id));
exit;
} else {
adrotate_return('adrotate-ads', 500);
}
} else {
adrotate_nonce_error();
exit;
}
}
/*-------------------------------------------------------------
Name: adrotate_insert_input
Purpose: Prepare input form on saving new or updated banners
Since: 0.1
-------------------------------------------------------------*/
function adrotate_insert_input() {
global $wpdb, $adrotate_config;
if(wp_verify_nonce($_POST['adrotate_nonce'], 'adrotate_save_ad')) {
// Mandatory
$id = $schedule_id = $author = $title = $bannercode = $active = '';
if(isset($_POST['adrotate_id'])) $id = $_POST['adrotate_id'];
if(isset($_POST['adrotate_schedule'])) $schedule_id = $_POST['adrotate_schedule'];
if(isset($_POST['adrotate_username'])) $author = $_POST['adrotate_username'];
if(isset($_POST['adrotate_title'])) $title = strip_tags(htmlspecialchars(trim($_POST['adrotate_title'], "\t\n "), ENT_QUOTES));
if(isset($_POST['adrotate_bannercode'])) $bannercode = htmlspecialchars(trim($_POST['adrotate_bannercode'], "\t\n "), ENT_QUOTES);
$thetime = adrotate_now();
if(isset($_POST['adrotate_active'])) $active = strip_tags(htmlspecialchars(trim($_POST['adrotate_active'], "\t\n "), ENT_QUOTES));
// Schedules
$sday = $smonth = $syear = $shour = $sminute = '';
if(isset($_POST['adrotate_sday'])) $sday = strip_tags(trim($_POST['adrotate_sday'], "\t\n "));
if(isset($_POST['adrotate_smonth'])) $smonth = strip_tags(trim($_POST['adrotate_smonth'], "\t\n "));
if(isset($_POST['adrotate_syear'])) $syear = strip_tags(trim($_POST['adrotate_syear'], "\t\n "));
if(isset($_POST['adrotate_shour'])) $shour = strip_tags(trim($_POST['adrotate_shour'], "\t\n "));
if(isset($_POST['adrotate_sminute'])) $sminute = strip_tags(trim($_POST['adrotate_sminute'], "\t\n "));
$eday = $emonth = $eyear = $ehour = $eminute = '';
if(isset($_POST['adrotate_eday'])) $eday = strip_tags(trim($_POST['adrotate_eday'], "\t\n "));
if(isset($_POST['adrotate_emonth'])) $emonth = strip_tags(trim($_POST['adrotate_emonth'], "\t\n "));
if(isset($_POST['adrotate_eyear'])) $eyear = strip_tags(trim($_POST['adrotate_eyear'], "\t\n "));
if(isset($_POST['adrotate_ehour'])) $ehour = strip_tags(trim($_POST['adrotate_ehour'], "\t\n "));
if(isset($_POST['adrotate_eminute'])) $eminute = strip_tags(trim($_POST['adrotate_eminute'], "\t\n "));
$maxclicks = $maxshown = '';
if(isset($_POST['adrotate_maxclicks'])) $maxclicks = strip_tags(trim($_POST['adrotate_maxclicks'], "\t\n "));
if(isset($_POST['adrotate_maxshown'])) $maxshown = strip_tags(trim($_POST['adrotate_maxshown'], "\t\n "));
// Advanced options
$advertiser = $image_field = $image_dropdown = $tracker = $show_everyone = '';
if(isset($_POST['adrotate_advertiser'])) $advertiser = 0;
if(isset($_POST['adrotate_image'])) $image_field = strip_tags(trim($_POST['adrotate_image'], "\t\n "));
if(isset($_POST['adrotate_image_dropdown'])) $image_dropdown = strip_tags(trim($_POST['adrotate_image_dropdown'], "\t\n "));
if(isset($_POST['adrotate_tracker'])) $tracker = strip_tags(trim($_POST['adrotate_tracker'], "\t\n "));
// Misc variables
$type = '';
$groups = array();
if(isset($_POST['groupselect'])) $groups = $_POST['groupselect'];
if(isset($_POST['adrotate_type'])) $type = strip_tags(trim($_POST['adrotate_type'], "\t\n "));
if(current_user_can('adrotate_ad_manage')) {
if(strlen($title) < 1) {
$title = 'Ad '.$id;
}
// Clean up bannercode
if(preg_match("/%ID%/", $bannercode)) $bannercode = str_replace('%ID%', '%id%', $bannercode);
if(preg_match("/%IMAGE%/", $bannercode)) $bannercode = str_replace('%IMAGE%', '%image%', $bannercode);
if(preg_match("/%TITLE%/", $bannercode)) $bannercode = str_replace('%TITLE%', '%title%', $bannercode);
if(preg_match("/%RANDOM%/", $bannercode)) $bannercode = str_replace('%RANDOM%', '%random%', $bannercode);
// Sort out start dates
if(strlen($smonth) > 0 AND !is_numeric($smonth)) $smonth = date_i18n('m');
if(strlen($sday) > 0 AND !is_numeric($sday)) $sday = date_i18n('d');
if(strlen($syear) > 0 AND !is_numeric($syear)) $syear = date_i18n('Y');
if(strlen($shour) > 0 AND !is_numeric($shour)) $shour = date_i18n('H');
if(strlen($sminute) > 0 AND !is_numeric($sminute)) $sminute = date_i18n('i');
if(($smonth > 0 AND $sday > 0 AND $syear > 0) AND strlen($shour) == 0) $shour = '00';
if(($smonth > 0 AND $sday > 0 AND $syear > 0) AND strlen($sminute) == 0) $sminute = '00';
if($smonth > 0 AND $sday > 0 AND $syear > 0) {
$startdate = mktime($shour, $sminute, 0, $smonth, $sday, $syear);
} else {
$startdate = 0;
}
// Sort out end dates
if(strlen($emonth) > 0 AND !is_numeric($emonth)) $emonth = $smonth;
if(strlen($eday) > 0 AND !is_numeric($eday)) $eday = $sday;
if(strlen($eyear) > 0 AND !is_numeric($eyear)) $eyear = $syear+1;
if(strlen($ehour) > 0 AND !is_numeric($ehour)) $ehour = $shour;
if(strlen($eminute) > 0 AND !is_numeric($eminute)) $eminute = $sminute;
if(($emonth > 0 AND $eday > 0 AND $eyear > 0) AND strlen($ehour) == 0) $ehour = '00';
if(($emonth > 0 AND $eday > 0 AND $eyear > 0) AND strlen($eminute) == 0) $eminute = '00';
if($emonth > 0 AND $eday > 0 AND $eyear > 0) {
$enddate = mktime($ehour, $eminute, 0, $emonth, $eday, $eyear);
} else {
$enddate = 0;
}
// Enddate is too early, reset to default
if($enddate <= $startdate) $enddate = $startdate + 7257600; // 84 days (12 weeks)
// Sort out click and impressions restrictions
if(strlen($maxclicks) < 1 OR !is_numeric($maxclicks)) $maxclicks = 0;
if(strlen($maxshown) < 1 OR !is_numeric($maxshown)) $maxshown = 0;
if(isset($tracker) AND strlen($tracker) != 0) $tracker = 'Y';
else $tracker = 'N';
// Determine image settings ($image_field has priority!)
if(strlen($image_field) > 1) {
$imagetype = "field";
$image = $image_field;
} else if(strlen($image_dropdown) > 1) {
$imagetype = "dropdown";
$image = WP_CONTENT_URL."/banners/".$image_dropdown;
} else {
$imagetype = "";
$image = "";
}
// Save schedule for new ads or update the existing one
if($type != 'empty') {
$wpdb->query($wpdb->prepare("DELETE FROM `{$wpdb->prefix}adrotate_schedule` WHERE `id` IN (SELECT `schedule` FROM `{$wpdb->prefix}adrotate_linkmeta` WHERE `schedule` != %d AND `schedule` > 0 AND `ad` = %d AND `group` = 0 AND `user` = 0);", $schedule_id, $id));
}
$wpdb->update($wpdb->prefix.'adrotate_schedule', array('starttime' => $startdate, 'stoptime' => $enddate, 'maxclicks' => $maxclicks, 'maximpressions' => $maxshown), array('id' => $schedule_id));
// Save the ad to the DB
$wpdb->update($wpdb->prefix.'adrotate', array('title' => $title, 'bannercode' => $bannercode, 'updated' => $thetime, 'author' => $author, 'imagetype' => $imagetype, 'image' => $image, 'tracker' => $tracker, 'responsive' => 'N', 'type' => $active), array('id' => $id));
// Fetch group records for the ad
$groupmeta = $wpdb->get_results($wpdb->prepare("SELECT `group` FROM `{$wpdb->prefix}adrotate_linkmeta` WHERE `ad` = %d AND `user` = 0 AND `schedule` = 0;", $id));
$group_array = array();
foreach($groupmeta as $meta) {
$group_array[] = $meta->group;
}
// Add new groups to this ad
$insert = array_diff($groups, $group_array);
foreach($insert as &$value) {
$wpdb->insert($wpdb->prefix.'adrotate_linkmeta', array('ad' => $id, 'group' => $value, 'user' => 0, 'schedule' => 0));
}
unset($value);
// Remove groups from this ad
$delete = array_diff($group_array, $groups);
foreach($delete as &$value) {
$wpdb->query($wpdb->prepare("DELETE FROM `{$wpdb->prefix}adrotate_linkmeta` WHERE `ad` = %d AND `group` = %d AND `user` = 0 AND `schedule` = 0;", $id, $value));
}
unset($value);
// Verify ad
if($type == "empty") {
$action = 'new';
} else {
$action = 'update';
}
if($active == "active") {
// Verify all ads
adrotate_prepare_evaluate_ads(false);
}
adrotate_return('adrotate-ads', 200);
exit;
} else {
adrotate_return('adrotate-ads', 500);
}
} else {
adrotate_nonce_error();
exit;
}
}
/*-------------------------------------------------------------
Name: adrotate_insert_group
Purpose: Save provided data for groups, update linkmeta where required
Since: 0.4
-------------------------------------------------------------*/
function adrotate_insert_group() {
global $wpdb, $adrotate_config;
if(wp_verify_nonce($_POST['adrotate_nonce'], 'adrotate_save_group')) {
$action = $id = $name = $modus = '';
if(isset($_POST['adrotate_action'])) $action = $_POST['adrotate_action'];
if(isset($_POST['adrotate_id'])) $id = $_POST['adrotate_id'];
if(isset($_POST['adrotate_groupname'])) $name = strip_tags(trim($_POST['adrotate_groupname'], "\t\n "));
if(isset($_POST['adrotate_modus'])) $modus = strip_tags(trim($_POST['adrotate_modus'], "\t\n "));
$rows = $columns = $adwidth = $adheight = $adspeed = '';
if(isset($_POST['adrotate_gridrows'])) $rows = strip_tags(trim($_POST['adrotate_gridrows'], "\t\n "));
if(isset($_POST['adrotate_gridcolumns'])) $columns = strip_tags(trim($_POST['adrotate_gridcolumns'], "\t\n "));
if(isset($_POST['adrotate_adwidth'])) $adwidth = strip_tags(trim($_POST['adrotate_adwidth'], "\t\n "));
if(isset($_POST['adrotate_adheight'])) $adheight = strip_tags(trim($_POST['adrotate_adheight'], "\t\n "));
if(isset($_POST['adrotate_adspeed'])) $adspeed = strip_tags(trim($_POST['adrotate_adspeed'], "\t\n "));
$ads = $admargin = $align = '';
if(isset($_POST['adselect'])) $ads = $_POST['adselect'];
if(isset($_POST['adrotate_admargin'])) $admargin = strip_tags(trim($_POST['adrotate_admargin'], "\t\n "));
if(isset($_POST['adrotate_align'])) $align = strip_tags(trim($_POST['adrotate_align'], "\t\n "));
$categories = $category_loc = $category_par = $pages = $page_loc = $page_par = '';
if(isset($_POST['adrotate_categories'])) $categories = $_POST['adrotate_categories'];
if(isset($_POST['adrotate_cat_location'])) $category_loc = $_POST['adrotate_cat_location'];
if(isset($_POST['adrotate_cat_paragraph'])) $category_par = $_POST['adrotate_cat_paragraph'];
if(isset($_POST['adrotate_pages'])) $pages = $_POST['adrotate_pages'];
if(isset($_POST['adrotate_page_location'])) $page_loc = $_POST['adrotate_page_location'];
if(isset($_POST['adrotate_page_paragraph'])) $page_par = $_POST['adrotate_page_paragraph'];
$wrapper_before = $wrapper_after = '';
if(isset($_POST['adrotate_wrapper_before'])) $wrapper_before = trim($_POST['adrotate_wrapper_before'], "\t\n ");
if(isset($_POST['adrotate_wrapper_after'])) $wrapper_after = trim($_POST['adrotate_wrapper_after'], "\t\n ");
if(current_user_can('adrotate_group_manage')) {
if(strlen($name) < 1) $name = 'Group '.$id;
if($modus < 0 OR $modus > 2) $modus = 0;
if($adspeed < 0 OR $adspeed > 99999) $adspeed = 6000;
if($align < 0 OR $align > 3) $align = 0;
// Sort out block shape
if($rows < 1 OR $rows == '' OR !is_numeric($rows)) $rows = 2;
if($columns < 1 OR $columns == '' OR !is_numeric($columns)) $columns = 2;
if((is_numeric($adwidth) AND $adwidth < 1 OR $adwidth > 9999) OR $adwidth == '' OR (!is_numeric($adwidth) AND $adwidth != 'auto')) $adwidth = '125';
if((is_numeric($adheight) AND $adheight < 1 OR $adheight > 9999) OR $adheight == '' OR (!is_numeric($adheight) AND $adheight != 'auto')) $adheight = '125';
if($admargin < 0 OR $admargin > 99 OR $admargin == '' OR !is_numeric($admargin)) $admargin = 0;
// Categories
if(!is_array($categories)) $categories = array();
$category = '';
foreach($categories as $key => $value) {
$category = $category.','.$value;
}
$category = trim($category, ', ');
if(strlen($category) < 1) $category = '';
if($category_par > 0) $category_loc = 4;
if($category_loc != 4) $category_par = 0;
// Pages
if(!is_array($pages)) $pages = array();
$page = '';
foreach($pages as $key => $value) {
$page = $page.','.$value;
}
$page = trim($page, ',');
if(strlen($page) < 1) $page = '';
if($page_par > 0) $page_loc = 4;
if($page_loc != 4) $page_par = 0;
// Fetch records for the group
$linkmeta = $wpdb->get_results($wpdb->prepare("SELECT `ad` FROM `{$wpdb->prefix}adrotate_linkmeta` WHERE `group` = %d AND `user` = 0;", $id));
foreach($linkmeta as $meta) {
$meta_array[] = $meta->ad;
}
if(empty($meta_array)) $meta_array = array();
if(empty($ads)) $ads = array();
// Add new ads to this group
$insert = array_diff($ads,$meta_array);
foreach($insert as &$value) {
$wpdb->insert($wpdb->prefix.'adrotate_linkmeta', array('ad' => $value, 'group' => $id, 'user' => 0));
}
unset($value);
// Remove ads from this group
$delete = array_diff($meta_array,$ads);
foreach($delete as &$value) {
$wpdb->query($wpdb->prepare("DELETE FROM `{$wpdb->prefix}adrotate_linkmeta` WHERE `ad` = %d AND `group` = %d AND `user` = 0;", $value, $id));
}
unset($value);
// Update the group itself
$wpdb->update($wpdb->prefix.'adrotate_groups', array('name' => $name, 'modus' => $modus, 'fallback' => 0, 'cat' => $category, 'cat_loc' => $category_loc, 'cat_par' => $category_par, 'page' => $page, 'page_loc' => $page_loc, 'page_par' => $page_par, 'wrapper_before' => $wrapper_before, 'wrapper_after' => $wrapper_after, 'align' => $align, 'gridrows' => $rows, 'gridcolumns' => $columns, 'admargin' => $admargin, 'adwidth' => $adwidth, 'adheight' => $adheight, 'adspeed' => $adspeed), array('id' => $id));
// Determine Dynamic Library requirement
$dynamic_count = $wpdb->get_var("SELECT COUNT(*) as `total` FROM `{$wpdb->prefix}adrotate_groups` WHERE `name` != '' AND `modus` = 1;");
update_option('adrotate_dynamic_required', $dynamic_count);
adrotate_return('adrotate-groups', 201);
exit;
} else {
adrotate_return('adrotate-groups', 500);
}
} else {
adrotate_nonce_error();
exit;
}
}
/*-------------------------------------------------------------
Name: adrotate_request_action
Purpose: Prepare action for banner or group from database
Since: 2.2
-------------------------------------------------------------*/
function adrotate_request_action() {
global $wpdb, $adrotate_config;
$banner_ids = $group_ids = '';
if(wp_verify_nonce($_POST['adrotate_nonce'],'adrotate_bulk_ads_active') OR wp_verify_nonce($_POST['adrotate_nonce'],'adrotate_bulk_ads_disable')
OR wp_verify_nonce($_POST['adrotate_nonce'],'adrotate_bulk_ads_error') OR wp_verify_nonce($_POST['adrotate_nonce'],'adrotate_bulk_ads_queue')
OR wp_verify_nonce($_POST['adrotate_nonce'],'adrotate_bulk_groups')) {
if(isset($_POST['bannercheck'])) $banner_ids = $_POST['bannercheck'];
if(isset($_POST['disabledbannercheck'])) $banner_ids = $_POST['disabledbannercheck'];
if(isset($_POST['errorbannercheck'])) $banner_ids = $_POST['errorbannercheck'];
if(isset($_POST['groupcheck'])) $group_ids = $_POST['groupcheck'];
if(isset($_POST['adrotate_id'])) $banner_ids = array($_POST['adrotate_id']);
// Determine which kind of action to use
if(isset($_POST['adrotate_action'])) {
// Default action call
$actions = $_POST['adrotate_action'];
} else if(isset($_POST['adrotate_disabled_action'])) {
// Disabled ads listing call
$actions = $_POST['adrotate_disabled_action'];
} else if(isset($_POST['adrotate_error_action'])) {
// Erroneous ads listing call
$actions = $_POST['adrotate_error_action'];
}
if(preg_match("/-/", $actions)) {
list($action, $specific) = explode("-", $actions);
} else {
$action = $actions;
}
if($banner_ids != '') {
$return = 'adrotate-ads';
if($action == 'export') {
if(current_user_can('adrotate_ad_manage')) {
adrotate_export($banner_ids);
$result_id = 215;
} else {
adrotate_return($return, 500);
}
}
foreach($banner_ids as $banner_id) {
if($action == 'deactivate') {
if(current_user_can('adrotate_ad_manage')) {
adrotate_active($banner_id, 'deactivate');
$result_id = 210;
} else {
adrotate_return($return, 500);
}
}
if($action == 'activate') {
if(current_user_can('adrotate_ad_manage')) {
adrotate_active($banner_id, 'activate');
$result_id = 211;
} else {
adrotate_return($return, 500);
}
}
if($action == 'delete') {
if(current_user_can('adrotate_ad_delete')) {
adrotate_delete($banner_id, 'banner');
$result_id = 203;
} else {
adrotate_return($return, 500);
}
}
if($action == 'reset') {
if(current_user_can('adrotate_ad_delete')) {
adrotate_reset($banner_id);
$result_id = 208;
} else {
adrotate_return($return, 500);
}
}
if($action == 'renew') {
if(current_user_can('adrotate_ad_manage')) {
adrotate_renew($banner_id, $specific);
$result_id = 209;
} else {
adrotate_return($return, 500);
}
}
}
// Verify all ads
adrotate_prepare_evaluate_ads(false);
}
if($group_ids != '') {
$return = 'adrotate-groups';
foreach($group_ids as $group_id) {
if($action == 'group_delete') {
if(current_user_can('adrotate_group_delete')) {
adrotate_delete($group_id, 'group');
$result_id = 204;
} else {
adrotate_return($return, 500);
}
}
if($action == 'group_delete_banners') {
if(current_user_can('adrotate_group_delete')) {
adrotate_delete($group_id, 'bannergroup');
$result_id = 213;
} else {
adrotate_return($return, 500);
}
}
}
}
adrotate_return($return, $result_id);
} else {
adrotate_nonce_error();
exit;
}
}
/*-------------------------------------------------------------
Name: adrotate_delete
Purpose: Remove banner or group from database
Receive: $id, $what
Return: -none-
Since: 0.1
-------------------------------------------------------------*/
function adrotate_delete($id, $what) {
global $wpdb;
if($id > 0) {
if($what == 'banner') {
$wpdb->query($wpdb->prepare("DELETE FROM `{$wpdb->prefix}adrotate` WHERE `id` = %d;", $id));
$wpdb->query($wpdb->prepare("DELETE FROM `{$wpdb->prefix}adrotate_linkmeta` WHERE `ad` = %d;", $id));
$wpdb->query($wpdb->prepare("DELETE FROM `{$wpdb->prefix}adrotate_stats` WHERE `ad` = %d;", $id));
} else if ($what == 'group') {
$wpdb->query($wpdb->prepare("DELETE FROM `{$wpdb->prefix}adrotate_groups` WHERE `id` = %d;", $id));
$wpdb->query($wpdb->prepare("DELETE FROM `{$wpdb->prefix}adrotate_linkmeta` WHERE `group` = %d;", $id));
} else if ($what == 'bannergroup') {
$linkmeta = $wpdb->get_results($wpdb->prepare("SELECT `ad` FROM `{$wpdb->prefix}adrotate_linkmeta` WHERE `group` = %d AND `user` = '0' AND `schedule` = '0';", $id));
foreach($linkmeta as $meta) {
adrotate_delete($meta->ad, 'banner');
}
unset($linkmeta);
adrotate_delete($id, 'group');
}
}
}
/*-------------------------------------------------------------
Name: adrotate_active
Purpose: Activate or Deactivate a banner
Since: 0.1
-------------------------------------------------------------*/
function adrotate_active($id, $what) {
global $wpdb;
if($id > 0) {
if($what == 'deactivate') {
$wpdb->update($wpdb->prefix.'adrotate', array('type' => 'disabled'), array('id' => $id));
}
if ($what == 'activate') {
// Determine status of ad
$adstate = adrotate_evaluate_ad($id);
$adtype = ($adstate == 'error' OR $adstate == 'expired') ? 'error' : 'active';
$wpdb->update($wpdb->prefix.'adrotate', array('type' => $adtype), array('id' => $id));
}
}
}
/*-------------------------------------------------------------
Name: adrotate_reset
Purpose: Reset statistics for a banner
Since: 2.2
-------------------------------------------------------------*/
function adrotate_reset($id) {
global $wpdb;
if($id > 0) {
$wpdb->query($wpdb->prepare("DELETE FROM `{$wpdb->prefix}adrotate_stats` WHERE `ad` = %d", $id));
}
}
/*-------------------------------------------------------------
Name: adrotate_renew
Purpose: Renew the end date of a banner with a new schedule starting where the last ended
Since: 2.2
-------------------------------------------------------------*/
function adrotate_renew($id, $howlong = 2592000) {
global $wpdb;
if($id > 0) {
$schedule_id = $wpdb->get_var($wpdb->prepare("SELECT `schedule` FROM `{$wpdb->prefix}adrotate_linkmeta` WHERE `ad` = %d AND `group` = 0 AND `user` = 0 ORDER BY `id` DESC LIMIT 1;", $id));
if($schedule_id > 0) {
$wpdb->query("UPDATE `{$wpdb->prefix}adrotate_schedule` SET `stoptime` = `stoptime` + $howlong WHERE `id` = $schedule_id;");
} else {
$now = adrotate_now();
$stoptime = $now + $howlong;
$wpdb->insert($wpdb->prefix.'adrotate_schedule', array('name' => 'Schedule for ad '.$id, 'starttime' => $now, 'stoptime' => $stoptime, 'maxclicks' => 0, 'maximpressions' => 0));
$wpdb->insert($wpdb->prefix.'adrotate_linkmeta', array('ad' => $id, 'group' => 0, 'user' => 0, 'schedule' => $wpdb->insert_id));
}
}
}
/*-------------------------------------------------------------
Name: adrotate_export
Purpose: Export selected banners
Since: 3.8.5
-------------------------------------------------------------*/
function adrotate_export($ids) {
if(is_array($ids)) {
adrotate_export_ads($ids);
}
}
/*-------------------------------------------------------------
Name: adrotate_options_submit
Purpose: Save options from dashboard
Since: 0.1
-------------------------------------------------------------*/
function adrotate_options_submit() {
if(wp_verify_nonce($_POST['adrotate_nonce_settings'],'adrotate_settings')) {
$settings_tab = esc_attr($_POST['adrotate_settings_tab']);
if($settings_tab == 'general') {
$config = get_option('adrotate_config');
$config['mobile_dynamic_mode'] = (isset($_POST['adrotate_mobile_dynamic_mode'])) ? 'Y' : 'N';
$config['jquery'] = (isset($_POST['adrotate_jquery'])) ? 'Y' : 'N';
$config['jsfooter'] = (isset($_POST['adrotate_jsfooter'])) ? 'Y' : 'N';
// Turn options off/reset them. Available in AdRotate Pro only
$config['textwidget_shortcodes'] = "N";
$config['banner_folder'] = "banners";
$config['notification_email'] = array();
$config['advertiser_email'] = array();
$config['enable_geo'] = 0;
$config['geo_cookie_life'] = 86400;
$config['geo_email'] = '';
$config['geo_pass'] = '';
$config['enable_advertisers'] = 'N';
$config['enable_editing'] = 'N';
$config['enable_geo_advertisers'] = 0;
update_option('adrotate_config', $config);
// Sort out crawlers
$crawlers = explode(',', trim($_POST['adrotate_crawlers']));
$new_crawlers = array();
foreach($crawlers as $crawler) {
$crawler = preg_replace('/[^a-zA-Z0-9\[\]\-_:; ]/i', '', trim($crawler));
if(strlen($crawler) > 0) $new_crawlers[] = $crawler;
}
update_option('adrotate_crawlers', $new_crawlers);
}
if($settings_tab == 'notifications') {
$notifications = get_option('adrotate_notifications');
$notifications['notification_dash'] = (isset($_POST['adrotate_notification_dash'])) ? 'Y' : 'N';
// Dashboard Notifications
$notifications['notification_dash_expired'] = (isset($_POST['adrotate_notification_dash_expired'])) ? 'Y' : 'N';
$notifications['notification_dash_soon'] = (isset($_POST['adrotate_notification_dash_soon'])) ? 'Y' : 'N';
// Turn options off. Available in AdRotate Pro only
$notifications['notification_email'] = 'N';
$notifications['notification_push'] = 'N';
$notifications['notification_email_publisher'] = array(get_option('admin_email'));
$notifications['notification_email_advertiser'] = array(get_option('admin_email'));
$notifications['notification_mail_geo'] = 'N';
$notifications['notification_mail_status'] = 'N';
$notifications['notification_mail_queue'] = 'N';
$notifications['notification_mail_approved'] = 'N';
$notifications['notification_mail_rejected'] = 'N';
$notifications['notification_push_user'] = '';
$notifications['notification_push_api'] = '';
$notifications['notification_push_geo'] = 'N';
$notifications['notification_push_status'] = 'N';
$notifications['notification_push_queue'] = 'N';
$notifications['notification_push_approved'] = 'N';
$notifications['notification_push_rejected'] = 'N';
update_option('adrotate_notifications', $notifications);
}
if($settings_tab == 'stats') {
$config = get_option('adrotate_config');
$stats = trim($_POST['adrotate_stats']);
$config['stats'] = (is_numeric($stats) AND $stats >= 0 AND $stats <= 3) ? $stats : 1;
$config['enable_loggedin_impressions'] = 'Y';
$config['enable_loggedin_clicks'] = 'Y';
$config['enable_clean_trackerdata'] = (isset($_POST['adrotate_enable_clean_trackerdata'])) ? 'Y' : 'N';
if($config['enable_clean_trackerdata'] == "Y" AND !wp_next_scheduled('adrotate_delete_transients')) {
wp_schedule_event(adrotate_now(), 'twicedaily', 'adrotate_delete_transients');
}
if($config['enable_clean_trackerdata'] == "N" AND wp_next_scheduled('adrotate_delete_transients')) {
wp_clear_scheduled_hook('adrotate_delete_transients');
}
$impression_timer = trim($_POST['adrotate_impression_timer']);
$config['impression_timer'] = (is_numeric($impression_timer) AND $impression_timer >= 10 AND $impression_timer <= 3600) ? $impression_timer : 60;
$click_timer = trim($_POST['adrotate_click_timer']);
$config['click_timer'] = (is_numeric($click_timer) AND $click_timer >= 60 AND $click_timer <= 86400) ? $click_timer : 86400;
update_option('adrotate_config', $config);
}
if($settings_tab == 'roles') {
$config = get_option('adrotate_config');
adrotate_set_capability($_POST['adrotate_ad_manage'], "adrotate_ad_manage");
adrotate_set_capability($_POST['adrotate_ad_delete'], "adrotate_ad_delete");
adrotate_set_capability($_POST['adrotate_group_manage'], "adrotate_group_manage");
adrotate_set_capability($_POST['adrotate_group_delete'], "adrotate_group_delete");
$config['ad_manage'] = $_POST['adrotate_ad_manage'];
$config['ad_delete'] = $_POST['adrotate_ad_delete'];
$config['group_manage'] = $_POST['adrotate_group_manage'];
$config['group_delete'] = $_POST['adrotate_group_delete'];
update_option('adrotate_config', $config);
}
if($settings_tab == 'misc') {
$config = get_option('adrotate_config');
$config['widgetalign'] = (isset($_POST['adrotate_widgetalign'])) ? 'Y' : 'N';
$config['widgetpadding'] = (isset($_POST['adrotate_widgetpadding'])) ? 'Y' : 'N';
$config['adminbar'] = (isset($_POST['adrotate_adminbar'])) ? 'Y' : 'N';
$config['hide_schedules'] = (isset($_POST['adrotate_hide_schedules'])) ? 'Y' : 'N';
$config['w3caching'] = (isset($_POST['adrotate_w3caching'])) ? 'Y' : 'N';
update_option('adrotate_config', $config);
}
if($settings_tab == 'maintenance') {
$debug = get_option('adrotate_debug');
$debug['general'] = (isset($_POST['adrotate_debug'])) ? true : false;
$debug['publisher'] = (isset($_POST['adrotate_debug_publisher'])) ? true : false;
$debug['timers'] = (isset($_POST['adrotate_debug_timers'])) ? true : false;
$debug['track'] = (isset($_POST['adrotate_debug_track'])) ? true : false;
update_option('adrotate_debug', $debug);
}
// Return to dashboard
adrotate_return('adrotate-settings', 400, array('tab' => $settings_tab));
} else {
adrotate_nonce_error();
exit;
}
}
/*-------------------------------------------------------------
Name: adrotate_prepare_roles
Purpose: Prepare user roles for WordPress
Since: 3.0
-------------------------------------------------------------*/
function adrotate_prepare_roles($action) {
if($action == 'add') {
add_role('adrotate_advertiser', __('AdRotate Advertiser', 'adrotate'), array('read' => 1));
}
if($action == 'remove') {
remove_role('adrotate_advertiser');
}
}
?>