get_row($wpdb->prepare("SELECT `id`, `title`, `bannercode`, `tracker`, `image` FROM `{$wpdb->prefix}adrotate` WHERE `id` = %d AND (`type` = 'active' OR `type` = '2days' OR `type` = '7days');", $banner_id));
if($banner) {
$selected = array($banner->id => 0);
$selected = adrotate_filter_schedule($selected, $banner);
} else {
$selected = false;
}
if($selected) {
$image = str_replace('%folder%', $adrotate_config['banner_folder'], $banner->image);
if($individual == true) $output .= '';
$output .= adrotate_ad_output($banner->id, 0, $banner->title, $banner->bannercode, $banner->tracker, $image);
if($individual == true) $output .= '
';
if($adrotate_config['stats'] == 1) {
adrotate_count_impression($banner->id, 0, 0);
}
} else {
$output .= adrotate_error('ad_expired', array($banner_id));
}
unset($banner);
} else {
$output .= adrotate_error('ad_no_id');
}
return $output;
}
/*-------------------------------------------------------------
Name: adrotate_group
Purpose: Fetch ads in specified group(s) and show a random ad
Since: 3.0
-------------------------------------------------------------*/
function adrotate_group($group_ids, $fallback = 0, $weight = 0, $site = 0) {
global $wpdb, $adrotate_config;
$output = $group_select = '';
if($group_ids) {
$now = adrotate_now();
$group_array = (preg_match('/,/is', $group_ids)) ? explode(",", $group_ids) : array($group_ids);
$group_array = array_filter($group_array);
foreach($group_array as $key => $value) {
$group_select .= " `{$wpdb->prefix}adrotate_linkmeta`.`group` = ".$wpdb->prepare('%d', $value)." OR";
}
$group_select = rtrim($group_select, " OR");
$group = $wpdb->get_row($wpdb->prepare("SELECT * FROM `{$wpdb->prefix}adrotate_groups` WHERE `name` != '' AND `id` = %d;", $group_array[0]));
if($group) {
// Get all ads in all selected groups
$ads = $wpdb->get_results(
"SELECT
`{$wpdb->prefix}adrotate`.`id`,
`{$wpdb->prefix}adrotate`.`title`,
`{$wpdb->prefix}adrotate`.`bannercode`,
`{$wpdb->prefix}adrotate`.`image`,
`{$wpdb->prefix}adrotate`.`tracker`,
`{$wpdb->prefix}adrotate_linkmeta`.`group`
FROM
`{$wpdb->prefix}adrotate`,
`{$wpdb->prefix}adrotate_linkmeta`
WHERE
({$group_select})
AND `{$wpdb->prefix}adrotate_linkmeta`.`user` = 0
AND `{$wpdb->prefix}adrotate`.`id` = `{$wpdb->prefix}adrotate_linkmeta`.`ad`
AND (`{$wpdb->prefix}adrotate`.`type` = 'active'
OR `{$wpdb->prefix}adrotate`.`type` = '2days'
OR `{$wpdb->prefix}adrotate`.`type` = '7days')
GROUP BY `{$wpdb->prefix}adrotate`.`id`
ORDER BY `{$wpdb->prefix}adrotate`.`id`;");
if($ads) {
foreach($ads as $ad) {
$selected[$ad->id] = $ad;
$selected = adrotate_filter_schedule($selected, $ad);
}
unset($ads);
$array_count = count($selected);
if($array_count > 0) {
$before = $after = '';
$before = str_replace('%id%', $group_array[0], stripslashes(html_entity_decode($group->wrapper_before, ENT_QUOTES)));
$after = str_replace('%id%', $group_array[0], stripslashes(html_entity_decode($group->wrapper_after, ENT_QUOTES)));
$output .= '';
// Kill dynamic mode for mobile users
if($adrotate_config['mobile_dynamic_mode'] == 'Y' AND $group->modus == 1 AND wp_is_mobile()) {
$group->modus = 0;
}
if($group->modus == 1) { // Dynamic ads
$i = 1;
// Limit group to save resources
$amount = ($group->adspeed >= 10000) ? 10 : 20;
// Randomize and trim output
$selected = adrotate_shuffle($selected);
foreach($selected as $key => $banner) {
if($i <= $amount) {
$image = str_replace('%folder%', $adrotate_config['banner_folder'], $banner->image);
$output .= '
';
$output .= $before.adrotate_ad_output($banner->id, $group->id, $banner->title, $banner->bannercode, $banner->tracker, $image).$after;
$output .= '
';
$i++;
}
}
} else if($group->modus == 2) { // Block of ads
$block_count = $group->gridcolumns * $group->gridrows;
if($array_count < $block_count) $block_count = $array_count;
$columns = 1;
for($i=1;$i<=$block_count;$i++) {
$banner_id = array_rand($selected, 1);
$image = str_replace('%folder%', $adrotate_config['banner_folder'], $selected[$banner_id]->image);
$output .= '
';
$output .= $before.adrotate_ad_output($selected[$banner_id]->id, $group->id, $selected[$banner_id]->title, $selected[$banner_id]->bannercode, $selected[$banner_id]->tracker, $image).$after;
$output .= '
';
if($columns == $group->gridcolumns AND $i != $block_count) {
$output .= '
';
$columns = 1;
} else {
$columns++;
}
if($adrotate_config['stats'] == 1){
adrotate_count_impression($selected[$banner_id]->id, $group->id, 0);
}
unset($selected[$banner_id]);
}
} else { // Default (single ad)
$banner_id = array_rand($selected, 1);
$image = str_replace('%folder%', $adrotate_config['banner_folder'], $selected[$banner_id]->image);
$output .= '
';
$output .= $before.adrotate_ad_output($selected[$banner_id]->id, $group->id, $selected[$banner_id]->title, $selected[$banner_id]->bannercode, $selected[$banner_id]->tracker, $image).$after;
$output .= '
';
if($adrotate_config['stats'] == 1){
adrotate_count_impression($selected[$banner_id]->id, $group->id, 0);
}
}
$output .= '
'.__('Oh no! Something went wrong!', 'adrotate').'
';
echo ' '.__('WordPress was unable to verify the authenticity of the url you have clicked. Verify if the url used is valid or log in via your browser.', 'adrotate').'
';
echo ' '.__('If you have received the url you want to visit via email, you are being tricked!', 'adrotate').'
';
echo ' '.__('Contact support if the issue persists:', 'adrotate').' AJdG Solutions Support.
';
}
/*-------------------------------------------------------------
Name: adrotate_error
Purpose: Show errors for problems in using AdRotate, should they occur
Since: 3.0
-------------------------------------------------------------*/
function adrotate_error($action, $arg = null) {
switch($action) {
// Ads
case "ad_expired" :
$result = '';
return $result;
break;
case "ad_unqualified" :
$result = '';
return $result;
break;
case "ad_no_id" :
$result = ''.__('Error, no Ad ID set! Check your syntax!', 'adrotate').'';
return $result;
break;
// Groups
case "group_no_id" :
$result = ''.__('Error, no group ID set! Check your syntax!', 'adrotate').'';
return $result;
break;
case "group_not_found" :
$result = ''.__('Error, group does not exist! Check your syntax!', 'adrotate').' (ID: '.$arg[0].')';
return $result;
break;
// Database
case "db_error" :
$result = ''.__('There was an error locating the database tables for AdRotate. Please deactivate and re-activate AdRotate from the plugin page!!', 'adrotate').'
'.__('If this does not solve the issue please seek support at', 'adrotate').' ajdg.solutions/forums/forum/adrotate-for-wordpress/';
return $result;
break;
// Possible XSS or malformed URL
case "error_loading_item" :
$result = ''.__('There was an error loading the page. Please try again by reloading the page via the menu on the left.', 'adrotate').'
'.__('If the issue persists please seek help at', 'adrotate').' ajdg.solutions/forums/forum/adrotate-for-wordpress/';
return $result;
break;
// Misc
default:
$result = ''.__('An unknown error occured.', 'adrotate').' (ID: '.$arg[0].')';
return $result;
break;
}
}
/*-------------------------------------------------------------
Name: adrotate_dashboard_error
Purpose: Show errors for problems in using AdRotate
Since: 3.19.1
-------------------------------------------------------------*/
function adrotate_dashboard_error() {
global $adrotate_config;
// Adverts
$status = get_option('adrotate_advert_status');
$adrotate_notifications = get_option("adrotate_notifications");
if($adrotate_notifications['notification_dash'] == "Y") {
if($status['expired'] > 0 AND $adrotate_notifications['notification_dash_expired'] == "Y") {
$error['advert_expired'] = sprintf(_n('One advert is expired.', '%1$s adverts expired!', $status['expired'], 'adrotate'), $status['expired']).' '.__('Check adverts', 'adrotate').'!';
}
if($status['expiressoon'] > 0 AND $adrotate_notifications['notification_dash_soon'] == "Y") {
$error['advert_soon'] = sprintf(_n('One advert expires soon.', '%1$s adverts are almost expiring!', $status['expiressoon'], 'adrotate'), $status['expiressoon']).' '.__('Check adverts', 'adrotate').'!';
}
}
if($status['error'] > 0) {
$error['advert_config'] = sprintf(_n('One advert with configuration errors.', '%1$s adverts have configuration errors!', $status['error'], 'adrotate'), $status['error']).' '.__('Check adverts', 'adrotate').'!';
}
// Caching
if($adrotate_config['w3caching'] == "Y" AND !is_plugin_active('w3-total-cache/w3-total-cache.php')) {
$error['w3tc_not_active'] = __('You have enabled caching support but W3 Total Cache is not active on your site!', 'adrotate').' '.__('Disable W3 Total Cache Support', 'adrotate').'.';
}
if($adrotate_config['w3caching'] == "Y" AND !defined('W3TC_DYNAMIC_SECURITY')) {
$error['w3tc_no_hash'] = __('You have enable caching support but the W3TC_DYNAMIC_SECURITY definition is not set.', 'adrotate').' '.__('How to configure W3 Total Cache', 'adrotate').'.';
}
if($adrotate_config['borlabscache'] == "Y" AND !is_plugin_active('borlabs-cache/borlabs-cache.php')) {
$error['borlabs_not_active'] = __('You have enable caching support but Borlabs Cache is not active on your site!', 'adrotate-pro').' '.__('Disable Borlabs Cache Support', 'adrotate-pro').'.';
}
if($adrotate_config['borlabscache'] == "Y" AND is_plugin_active('borlabs-cache/borlabs-cache.php')) {
if(\Borlabs\Factory::get('Cache\Config')->get('cacheActivated') == 'yes') {
$borlabscache = \Borlabs\Factory::get('Cache\Config')->get('fragmentCaching');
if(strlen($borlabscache) < 1) {
$error['borlabs_fragment_error'] = __('You have enabled Borlabs Cache support but Fragment caching is not enabled!', 'adrotate-pro').' '.__('Enable Fragment Caching', 'adrotate-pro').'.';
}
}
}
// Misc
if(!is_writable(WP_CONTENT_DIR."/".$adrotate_config['banner_folder'])) {
$error['banners_folder'] = __('Your AdRotate Banner folder is not writable or does not exist.', 'adrotate').' '.__('Set up your banner folder', 'adrotate').'.';
}
if(is_dir(WP_PLUGIN_DIR."/adrotate-pro/")) {
$error['adrotate_exists'] = __('You have the AdRotate Professional installed. Please check out the upgrade manual and switch over to AdRotate Pro!', 'adrotate-pro').' '.__('Upgrade instructions', 'adrotate-pro').'.';
}
if(is_dir(WP_PLUGIN_DIR."/adrotate_new/") OR is_dir(WP_PLUGIN_DIR."/adrotate-pro_new/")) {
$error['adrotate_exists'] = __('Something is wrong with your installation of AdRotate. Either the plugin is installed twice or your current installation has the wrong folder name. Please install the plugin properly!', 'adrotate-pro').' '.__('Installation instructions', 'adrotate-pro').'.';
}
$error = (isset($error) AND is_array($error)) ? $error : false;
return $error;
}
/*-------------------------------------------------------------
Name: adrotate_notifications_dashboard
Purpose: Notify user of expired banners in the dashboard
Since: 3.0
-------------------------------------------------------------*/
function adrotate_notifications_dashboard() {
global $current_user;
if(current_user_can('adrotate_ad_manage')) {
$displayname = (strlen($current_user->user_firstname) > 0) ? $current_user->user_firstname : $current_user->display_name;
$page = (isset($_GET['page'])) ? $_GET['page'] : '';
// These only show on AdRotate pages
if(strpos($page, 'adrotate') !== false) {
if(isset($_GET['hide']) AND $_GET['hide'] == 0) update_option('adrotate_hide_getpro', adrotate_now() + (31 * DAY_IN_SECONDS));
if(isset($_GET['hide']) AND $_GET['hide'] == 1) update_option('adrotate_hide_review', 1);
if(isset($_GET['hide']) AND $_GET['hide'] == 2) update_option('adrotate_hide_competition', 1);
if(isset($_GET['hide']) AND $_GET['hide'] == 3) update_option('adrotate_hide_birthday', adrotate_now() + (10 * MONTH_IN_SECONDS));
// Get AdRotate Pro
$getpro_banner = get_option('adrotate_hide_getpro');
if($getpro_banner < adrotate_now()) {
echo '';
echo '
';
echo '
Hello '.$displayname.'. Have you considered upgrading to AdRotate Professional yet?
Get extra features like Geo Targeting, Scheduling, mobile adverts, access to premium support and much more for only €39 EUR.
Use coupon code getadrotatepro and get a 10% discount on any AdRotate Professional license! Thank you for your support!
';
echo '
';
echo '
';
echo '
';
echo '
Welcome back
'.$displayname.'! You have been using
AdRotate Banner Manager for a few days. If you like AdRotate Banner Manager, please share
your experience.
If you have questions, complaints or something else that does not belong in a review, please use the
support forum!
';
echo '
';
echo '
';
echo '
';
echo '
Hey
'.$displayname.'! Did you know it is Arnan his birtyday this month? February 9th to be exact. Wish him a happy birthday via Twitter!
Who is Arnan? He made AdRotate for you - Check out his
website or
send a gift.
';
echo '
';
echo '
';
echo '
';
echo '
AdRotate Banner Manager has detected '._n('one issue that requires', 'several issues that require', count($adrotate_has_error), 'adrotate').' '.__('your attention:', 'adrotate').'
';
foreach($adrotate_has_error as $error => $message) {
echo '» '.$message.'
';
}
echo '
';
echo '
';
echo '
';
echo '
Thanks for updating
'.$displayname.'! You have almost completed updating
AdRotate to version
'.ADROTATE_DISPLAY.'!
To complete the update
click the button on the right. This may take a few seconds to complete!
For an overview of what has changed take a look at the
development page and usually there is an article on
the blog with more information as well.
';
echo '
';
echo '
AdRotate '.ADROTATE_DISPLAY.'
';
$pointer_content .= ''.__('Thank you for choosing AdRotate Banner Manager. Everything related to AdRotate is in this menu. If you need help getting started take a look at the', 'adrotate').' '.__('manuals', 'adrotate').' '.__('and', 'adrotate').' '.__('forums', 'adrotate').'. These links are also available in the help tab in the top right.
';
$pointer_content .= 'AdRotate Professional - Learn more »
If you like AdRotate Banner Manager please consider upgrading to AdRotate Professional and benefit from many extra features to make your campaigns more profitable!
';
$pointer_content .= 'Ad blockers
Disable your ad blocker in your browser so your adverts and dashboard show up correctly. Take a look at this manual to whitelist your site.
';
?>
add_help_tab(array(
'id' => 'adrotate_thanks',
'title' => 'Thanks to you',
'content' => 'Thank you for using AdRotate
'.
'AdRotate is becoming one of the most popular WordPress plugins for Advertising and is a household name for many companies and websites around the world. AdRotate wouldn\'t be possible without your support and my life wouldn\'t be what it is today without your help.
- Arnan
'.
'Business: Visit ajdg.solutions website.
'.
'Personal: Take a look at the arnan.me website, also Arnan has Twitter and he is on LinkedIn.
'
)
);
$screen->add_help_tab(array(
'id' => 'adrotate_support',
'title' => 'Getting Support',
'content' => 'Get help using AdRotate
'.
'Everyone needs some help sometimes. AdRotate has many guides and manuals as well as a Support Forum on the AdRotate website to get you going.
All the relevant links to getting help and the Professional Services I offer can be found on the Support dashboard.
'.
'Take a look at the AdRotate Manuals and the Support Forum here. Also check out recommended products and services I use.
'
)
);
}
/*-------------------------------------------------------------
Name: adrotate_action_links
Purpose: Plugin page link
Since: 4.11
-------------------------------------------------------------*/
function adrotate_action_links($links) {
$custom_actions = array();
$custom_actions['adrotate-pro'] = sprintf('%s', 'https://ajdg.solutions/cart/?add-to-cart=1124&pk_campaign=adrotatefree&pk_keyword=action_links&pk_content=buy_single', 'Get Pro');
$custom_actions['adrotate-help'] = sprintf('%s', 'https://ajdg.solutions/support/?pk_campaign=adrotatefree&pk_keyword=action_links&pk_content=support_link', 'Support');
$custom_actions['adrotate-ajdg'] = sprintf('%s', 'https://ajdg.solutions/?pk_campaign=adrotatefree&pk_keyword=action_links', 'AJdG Solutions');
return array_merge($custom_actions, $links);
}
/*-------------------------------------------------------------
Name: adrotate_credits
Purpose: Promotional stuff shown throughout the plugin
Since: 3.7
-------------------------------------------------------------*/
function adrotate_credits() {
echo '';
echo '';
echo '';
echo ' | '.__('Help AdRotate Grow', 'adrotate').' | ';
echo ' '.__('AdRotate Professional', 'adrotate').' | ';
echo '
';
echo '';
echo '';
echo '';
echo '.') | ';
echo ''.__("Many users only think to review AdRotate when something goes wrong while thousands of people happily use AdRotate.", 'adrotate').' '. __("If you find AdRotate useful please leave your", 'adrotate').' '.__('rating','adrotate').' '.__('and','adrotate').' '.__('review','adrotate').' '.__('on WordPress.org to help AdRotate grow in a positive way', 'adrotate').'! | ';
echo '.') '.__('Get more advanced features like Geo Targeting, scheduling and much more with AdRotate Pro.', 'adrotate').' '.__('Includes premium support and free updates for one year!', 'adrotate').'
So why wait? '.__('Get started today', 'adrotate').' » | ';
echo '
';
echo '';
echo '
';
echo adrotate_trademark();
}
/*-------------------------------------------------------------
Name: adrotate_trademark
Purpose: Trademark notice
Since: 3.9.14
-------------------------------------------------------------*/
function adrotate_trademark() {
return 'AdRotate® is a registered trademark.';
}
?>