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), ARRAY_A);
if($banner) {
if(adrotate_filter_schedule($banner)) {
$available = false;
}
} else {
$available = false;
}
if($available) {
$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`;"
, ARRAY_A);
if($ads) {
foreach($ads as $key => $ad) {
if(adrotate_filter_schedule($ad)) {
unset($ads[$key]);
}
}
$array_count = count($ads);
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
$ads = adrotate_shuffle($ads);
$ads = array_slice($ads, 0, $amount, 1);
foreach($ads as $key => $banner) {
$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++) {
$array_key = array_rand($ads, 1);
$image = str_replace('%folder%', $adrotate_config['banner_folder'], $ads[$array_key]['image']);
$output .= '
';
$output .= $before.adrotate_ad_output($ads[$array_key]['id'], $group->id, $ads[$array_key]['title'], $ads[$array_key]['bannercode'], $ads[$array_key]['tracker'], $image).$after;
$output .= '
';
if($columns == $group->gridcolumns AND $i != $block_count) {
$output .= '
';
$columns = 1;
} else {
$columns++;
}
if($adrotate_config['stats'] == 1 AND $ads[$array_key]['tracker'] == "Y") {
adrotate_count_impression($ads[$array_key]['id'], $group->id, 0);
}
unset($ads[$array_key]);
}
} else { // Default (single ad)
$array_key = array_rand($ads, 1);
$image = str_replace('%folder%', $adrotate_config['banner_folder'], $ads[$array_key]['image']);
$output .= '
';
$output .= $before.adrotate_ad_output($ads[$array_key]['id'], $group->id, $ads[$array_key]['title'], $ads[$array_key]['bannercode'], $ads[$array_key]['tracker'], $image).$after;
$output .= '
';
if($adrotate_config['stats'] == 1 AND $ads[$array_key]['tracker'] == "Y") {
adrotate_count_impression($ads[$array_key]['id'], $group->id, 0);
}
}
$output .= '
';
$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);
}
$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 on the', 'adrotate').' support forums';
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 on the', 'adrotate').' support forums';
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 such as Geo Targeting, Scheduling, Mobile Adverts, More advanced Post Injection, access to premium ticket support and much more...
';
echo ' Licenses start at € 49 and you can use coupon code GETADROTATEPRO to get a 10% discount on any AdRotate Professional license!
';
echo '
';
echo '
';
echo '
';
echo '
Hello
'.$displayname.'! You have been using
AdRotate for a few days. If you like or found a use for AdRotate Banner Manager, please share
your experience and write a review. Thanks for being 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.
';
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
'.$plugin_version.'!
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 Banner Manager '.$plugin_version.'
';
$pointer_content .= ''.__('Thank you for choosing AdRotate. Everything related to AdRotate Banner Manager 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 on the support page.', 'adrotate').'
';
$pointer_content .= ''.__('Ad blockers', 'adrotate').'
'.__('Please whitelist your website in your content blocker so your adverts and dashboard show up correctly. Take a look at this manual to', 'adrotate').' '.__('see how that works', 'adrotate').'.
';
?>
%s', 'https://ajdg.solutions/cart/?add-to-cart=1124&mtm_campaign=adrotate&mtm_keyword=action_links', 'Get AdRotate Pro');
$custom_actions['adrotate-help'] = sprintf('%s', admin_url('admin.php?page=adrotate-support'), 'Support');
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 ' | '.__('Get more features with AdRotate Professional', 'adrotate').' | ';
echo ' '.__('Starting at € 49.00', 'adrotate').' - '.__('Compare Licenses', 'adrotate').' » | ';
echo '
';
echo '';
echo '';
echo '';
echo '
.') '.__('AdRotate Professional has a lot more to offer for even better advertising management and premium support. Enjoy features like Geo Targeting, Schedules, more advanced Post Injection and much more. Check out the feature comparison tab on any of the product pages to see what AdRotate Pro has to offer for you! When you upgrade to AdRotate Professional make sure you use coupon GETADROTATEPRO on checkout for 10 percent off on any license.', 'adrotate').' '.__('Compare Licenses', 'adrotate').' »
| ';
echo '
'.__('Get a Single License', 'adrotate').'
'.__('One year of updates for one WordPress website.', 'adrotate').'
'.__('Go big with the Multi License', 'adrotate').'
'.__('One year of updates for up-to five WordPress websites.', 'adrotate').'
| ';
echo '
';
echo '';
echo '
';
echo '';
echo '';
echo '';
echo ' | '.__('Do you have a question?', 'adrotate').' | ';
echo ' '.__('Support AdRotate Banner Manager', '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').' '.__('Buy Support Ticket').'
| ';
echo '
.') '.__('Arnan needs your help. Please consider writing a review or sharing AdRotate in Social media if you find the plugin useful. Writing a review and sharing AdRotate on social media costs you nothing but doing so is super helpful.').'
'.__('Write review on WordPress.org').' '.__('Write review on ajdg.solutions').'
| ';
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.';
}
?>