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);
$output .= '';
$output .= adrotate_ad_output($banner->id, 0, $banner->title, $banner->bannercode, $banner->tracker, $image);
$output .= '
';
if($adrotate_config['stats'] == 1 AND $banner->tracker == "Y") {
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, $opt = null) {
global $wpdb, $adrotate_config;
$output = $group_select = '';
if($group_ids) {
$options = wp_parse_args($opt, array());
$now = current_time('timestamp');
$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 AND $selected[$banner_id]->tracker == "Y") {
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 AND $selected[$banner_id]->tracker == "Y") {
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 Advert 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').' '.__('Disable Borlabs Cache Support', 'adrotate').'.';
}
if($adrotate_config['borlabscache'] == "Y" AND is_plugin_active('borlabs-cache/borlabs-cache.php')) {
$borlabs_config = get_option('BorlabsCacheConfigInactive');
if($borlabs_config['cacheActivated'] == 'yes' AND strlen($borlabs_config['fragmentCaching']) < 1) {
$error['borlabs_fragment_error'] = __('You have enabled Borlabs Cache support but Fragment caching is not enabled!', 'adrotate').' '.__('Enable Fragment Caching', 'adrotate').'.';
}
unset($borlabs_config);
}
// 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 AdRotate Professional installed. Please switch to AdRotate Pro! You can delete this plugin after AdRotate Pro is activated.', 'adrotate').' '.__('Switch plugins', 'adrotate').'.';
}
if(basename(__DIR__) != 'adrotate' AND basename(__DIR__) != 'adrotate-pro') {
$error['adrotate_folder_names'] = __('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').' '.__('Installation instructions', 'adrotate').'.';
}
$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', current_time('timestamp') + (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_birthday', current_time('timestamp') + (10 * MONTH_IN_SECONDS));
// Get AdRotate Pro
$getpro_banner = get_option('adrotate_hide_getpro');
if($getpro_banner < current_time('timestamp')) {
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 starting at only €39 EUR.
';
if(adrotate_is_classicpress()) {
echo ' Use coupon code GOTCLASSICPRESS and get a 20% special ClassicPress discount on any AdRotate Professional license! Thank you for your consideration!
';
} else {
echo ' Use coupon code
GETADROTATEPRO and get a 10% discount on any
AdRotate Professional license! Thank you for your consideration!
';
echo '
';
echo '
Hello
'.$displayname.'! You have been using
AdRotate for a few days. If you like AdRotate, please share
your experience and help promote AdRotate.
Tell your followers that you use AdRotate. A
Tweet or
Facebook Share helps a lot and is super awesome!
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 Telegram!
Who is Arnan? He made AdRotate for you - Check out his
website or
send a gift.
';
echo '
';
echo '
';
echo '
';
echo '
AdRotate 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. 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 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 one of the most popular WordPress plugins for Advertising and is a household name for many companies and news sites around the world. AdRotate would not be possible without your support and my life would not be what it is today without your help.
- Arnan
'.
'My website ajdg.solutions.
My profile Arnan de Gans.
'
)
);
$screen->add_help_tab(array(
'id' => 'adrotate_support',
'title' => 'Getting Support',
'content' => 'Get help using AdRotate
'.
'AdRotate has many guides and manuals as well as a Support Forum on the AdRotate website to answer most common questions.
All the relevant links to getting help and the Professional Services I offer can be found on the Support dashboard.
'.
'AdRotate Manuals
AJdG Solutions Support Forum
Recommended products and services
'
)
);
$screen->add_help_tab(array(
'id' => 'adrotate_social',
'title' => 'Spread the word',
'content' => 'Tell your friends
'.
'Consider writing a review or sharing AdRotate in Social media if you like the plugin or if you find it useful. Writing a review and sharing AdRotate on social media costs you nothing but doing so is super helpful as promotion which helps to ensure future development.
'.
''.__('Post Tweet').' '.__('Share on Facebook').' '.__('Write review on wordpress.org').'
- '.__('Thank you very much for your help and support!').'
'
)
);
}
/*-------------------------------------------------------------
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', admin_url('admin.php?page=adrotate-support'), 'Support');
$custom_actions['adrotate-news'] = sprintf('%s', 'https://ajdg.solutions/blog/?pk_campaign=adrotatefree&pk_keyword=action_links', 'News');
$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 ' | '.__('Need help fast? Or do you have a question?', 'adrotate').' | ';
echo ' '.__('Help AdRotate Grow', 'adrotate').' | ';
echo ' '.__('Get more features with AdRotate Pro', 'adrotate').' | ';
echo '
';
echo '';
echo '';
echo '';
echo '.') '.__('If you need help, or have questions about AdRotate, the best and fastest way to get your answer is via the AdRotate support forum. Usually I answer questions the same day, often with a solution in the first answer.').'
'.__('AdRotate Manuals').' '.__('Support Forums').'
'.__('When posting on the forum, please include a brief description of the problem, include any errors or symptoms. Often it helps if you try to explain what you are trying to do. Providing some extra information always helps with gettng a better answer or advise.').' | ';
echo '.') '.__('Consider writing a review, sharing AdRotate in Social media or making a donation if you like the plugin or if you find it useful. Writing a review and sharing AdRotate on social media costs you nothing but doing so is super helpful as promotion which helps to ensure future development.').'
'.__('Post Tweet').' '.__('Share on Facebook').' '.__('Write review on WordPress.org').'
- '.__('Thank you very much for your help and support!').' | ';
echo '.') '.__('AdRotate Professional has a lot more functions for even better advertising management. Check out the feature comparison tab on any of the product pages to see what AdRotate Pro has to offer for you!', 'adrotate').' '.__('Compare Licenses', 'adrotate').' »
'.__('Single License', 'adrotate').' (€ 39.00)
'.__('Use on ONE WordPress installation.', 'adrotate').' '.__('Buy now', 'adrotate').' »
'.__('Multi License', 'adrotate').' (€ 99.00)
'.__('Use on up to FIVE WordPress installations.', 'adrotate').' '.__('Buy now', '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.';
}
?>