AdRotate Banner Manager - Version 5.8.5

Version Description

Enjoy this latest update with the latest tweaks and improvements for AdRotate for WordPress!

Download this release

Release Info

Developer adegans
Plugin Icon 128x128 AdRotate Banner Manager
Version 5.8.5
Comparing to
See all releases

Code changes from version 5.8.4 to 5.8.5

Files changed (8) hide show
  1. adrotate-functions.php +1 -0
  2. adrotate-output.php +15 -16
  3. adrotate-statistics.php +5 -5
  4. adrotate.php +2 -2
  5. dashboard/info.php +6 -5
  6. library/dashboard.css +3 -0
  7. library/goosebox.js +19 -0
  8. readme.txt +8 -24
adrotate-functions.php CHANGED
@@ -529,6 +529,7 @@ function adrotate_dashboard_scripts() {
529
  wp_enqueue_script('raphael', plugins_url('/library/raphael-min.js', __FILE__), array('jquery'));
530
  wp_enqueue_script('elycharts', plugins_url('/library/elycharts.min.js', __FILE__), array('jquery', 'raphael'));
531
  wp_enqueue_script('textatcursor', plugins_url('/library/textatcursor.js', __FILE__), ADROTATE_VERSION);
 
532
  wp_enqueue_script('tablesorter', plugins_url('/library/jquery.tablesorter.min.js', __FILE__), array('jquery'), ADROTATE_VERSION);
533
  wp_enqueue_script('adrotate-tablesorter', plugins_url('/library/jquery.adrotate.tablesorter.js', __FILE__), array('jquery', 'tablesorter'), ADROTATE_VERSION);
534
  wp_enqueue_script('adrotate-datepicker', plugins_url('/library/jquery.adrotate.datepicker.js', __FILE__), array('jquery'), ADROTATE_VERSION);
529
  wp_enqueue_script('raphael', plugins_url('/library/raphael-min.js', __FILE__), array('jquery'));
530
  wp_enqueue_script('elycharts', plugins_url('/library/elycharts.min.js', __FILE__), array('jquery', 'raphael'));
531
  wp_enqueue_script('textatcursor', plugins_url('/library/textatcursor.js', __FILE__), ADROTATE_VERSION);
532
+ wp_enqueue_script('goosebox', plugins_url('/library/goosebox.js', __FILE__), ADROTATE_VERSION);
533
  wp_enqueue_script('tablesorter', plugins_url('/library/jquery.tablesorter.min.js', __FILE__), array('jquery'), ADROTATE_VERSION);
534
  wp_enqueue_script('adrotate-tablesorter', plugins_url('/library/jquery.adrotate.tablesorter.js', __FILE__), array('jquery', 'tablesorter'), ADROTATE_VERSION);
535
  wp_enqueue_script('adrotate-datepicker', plugins_url('/library/jquery.adrotate.datepicker.js', __FILE__), array('jquery'), ADROTATE_VERSION);
adrotate-output.php CHANGED
@@ -676,18 +676,17 @@ function adrotate_notifications_dashboard() {
676
  if(strpos($page, 'adrotate') !== false) {
677
  if(isset($_GET['hide']) AND $_GET['hide'] == 0) update_option('adrotate_hide_getpro', adrotate_now() + (31 * DAY_IN_SECONDS));
678
  if(isset($_GET['hide']) AND $_GET['hide'] == 1) update_option('adrotate_hide_review', 1);
679
- if(isset($_GET['hide']) AND $_GET['hide'] == 2) update_option('adrotate_hide_competition', 1);
680
- if(isset($_GET['hide']) AND $_GET['hide'] == 3) update_option('adrotate_hide_birthday', adrotate_now() + (10 * MONTH_IN_SECONDS));
681
-
682
  // Get AdRotate Pro
683
  $getpro_banner = get_option('adrotate_hide_getpro');
684
  if($getpro_banner < adrotate_now()) {
685
- echo '<div class="ajdg-notification notice" style="">';
686
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/notification.png', __FILE__).'\');"><span></span></div>';
687
  echo ' <div class="ajdg-notification-message">Hello <strong>'.$displayname.'</strong>. Have you considered upgrading to <strong>AdRotate Professional</strong> yet?<br />Get extra features like Geo Targeting, Scheduling, mobile adverts, access to premium support and much more starting at only &euro;39 EUR.<br />Use coupon code <strong>getadrotatepro</strong> and get a 10% discount on any <strong>AdRotate Professional</strong> license! Thank you for your consideration!</div>';
688
  echo ' <div class="ajdg-notification-cta">';
689
  echo ' <a href="'.admin_url('admin.php?page=adrotate-pro').'" class="ajdg-notification-act button-primary">Get AdRotate Pro</a>';
690
- echo ' <a href="admin.php?page=adrotate&hide=0" class="ajdg-notification-dismiss">Maybe later</a>';
691
  echo ' </div>';
692
  echo '</div>';
693
  }
@@ -695,12 +694,12 @@ function adrotate_notifications_dashboard() {
695
  // Write a review
696
  $review_banner = get_option('adrotate_hide_review');
697
  if($review_banner != 1 AND $review_banner < (adrotate_now() - (8 * DAY_IN_SECONDS))) {
698
- echo '<div class="ajdg-notification notice" style="">';
699
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/notification.png', __FILE__).'\');"><span></span></div>';
700
- echo ' <div class="ajdg-notification-message">Welcome back <strong>'.$displayname.'</strong>! You have been using <strong>AdRotate Banner Manager</strong> for a few days. If you like AdRotate Banner Manager, please share <strong>your experience</strong>.<br />If you have questions, complaints or something else that does not belong in a review, please use the <a href="admin.php?page=adrotate-support">support forum</a>!</div>';
701
  echo ' <div class="ajdg-notification-cta">';
702
- echo ' <a href="https://wordpress.org/support/view/plugin-reviews/adrotate?rate=5#postform" class="ajdg-notification-act button-primary">Review AdRotate</a>';
703
- echo ' <a href="admin.php?page=adrotate&hide=1" class="ajdg-notification-dismiss">Maybe later</a>';
704
  echo ' </div>';
705
  echo '</div>';
706
  }
@@ -708,12 +707,12 @@ function adrotate_notifications_dashboard() {
708
  // Birthday
709
  $birthday_banner = get_option('adrotate_hide_birthday');
710
  if($birthday_banner < adrotate_now() AND date('M',adrotate_date_start('day')) == 'Feb') {
711
- echo '<div class="ajdg-notification notice" style="">';
712
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/birthday.png', __FILE__).'\');"><span></span></div>';
713
  echo ' <div class="ajdg-notification-message">Hey <strong>'.$displayname.'</strong>! Did you know it is Arnan his birtyday this month? February 9th to be exact. Wish him a happy birthday via Twitter!<br />Who is Arnan? He made AdRotate for you - Check out his <a href="https://www.arnan.me/?pk_campaign=adrotatefree&pk_keyword=birthday_banner" target="_blank">website</a> or <a href="https://www.arnan.me/donate.html?pk_campaign=adrotatefree&pk_keyword=birthday_banner" target="_blank">send a gift</a>.</div>';
714
  echo ' <div class="ajdg-notification-cta">';
715
- echo ' <a href="https://twitter.com/intent/tweet?text=Happy%20Birthday%20@arnandegans!%20From%20'.$displayname.'%20at%20'.home_url().'&hashtags=birthday,adrotate" target="_blank" class="ajdg-notification-act button-primary">Wish Happy Birthday</a>';
716
- echo ' <a href="admin.php?page=adrotate&hide=3" class="ajdg-notification-dismiss">Not now</a>';
717
  echo ' </div>';
718
  echo '</div>';
719
  }
@@ -724,7 +723,7 @@ function adrotate_notifications_dashboard() {
724
  if($adrotate_has_error) {
725
  echo '<div class="ajdg-notification notice" style="">';
726
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/notification.png', __FILE__).'\');"><span></span></div>';
727
- echo ' <div class="ajdg-notification-message"><strong>AdRotate Banner Manager</strong> has detected '._n('one issue that requires', 'several issues that require', count($adrotate_has_error), 'adrotate').' '.__('your attention:', 'adrotate').'<br />';
728
  foreach($adrotate_has_error as $error => $message) {
729
  echo '&raquo; '.$message.'<br />';
730
  }
@@ -742,7 +741,7 @@ function adrotate_notifications_dashboard() {
742
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/notification.png', __FILE__).'\');"><span></span></div>';
743
  echo ' <div class="ajdg-notification-message">Thanks for updating <strong>'.$displayname.'</strong>! You have almost completed updating <strong>AdRotate</strong> to version <strong>'.ADROTATE_DISPLAY.'</strong>!<br />To complete the update <strong>click the button on the right</strong>. This may take a few seconds to complete!<br />For an overview of what has changed take a look at the <a href="https://ajdg.solutions/support/adrotate-development/?pk_campaign=adrotatefree&pk_keyword=finish_update_notification" target="_blank">development page</a> and usually there is an article on <a href="https://ajdg.solutions/blog/" target="_blank">the blog</a> with more information as well.</div>';
744
  echo ' <div class="ajdg-notification-cta">';
745
- echo ' <a href="admin.php?page=adrotate-settings&tab=maintenance&action=update-db" class="ajdg-notification-act button-primary update-button">Finish update</a>';
746
  echo ' </div>';
747
  echo '</div>';
748
  }
@@ -755,9 +754,9 @@ function adrotate_notifications_dashboard() {
755
  -------------------------------------------------------------*/
756
  function adrotate_welcome_pointer() {
757
  $pointer_content = '<h3>AdRotate '.ADROTATE_DISPLAY.'</h3>';
758
- $pointer_content .= '<p>'.__('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').' <a href="http:\/\/ajdg.solutions\/support\/adrotate-manuals\/" target="_blank">'.__('manuals', 'adrotate').'</a> '.__('and', 'adrotate').' <a href="https:\/\/ajdg.solutions\/forums\/forum\/adrotate-for-wordpress\/" target="_blank">'.__('forums', 'adrotate').'</a>. These links are also available in the help tab in the top right.</p>';
759
 
760
- $pointer_content .= '<p><strong>AdRotate Professional - <a href="admin.php?page=adrotate-pro">Learn more &raquo;</a></strong><br />If you like AdRotate Banner Manager please consider upgrading to AdRotate Professional and benefit from many <a href="admin.php?page=adrotate-pro">extra features</a> to make your campaigns more profitable!</p>';
761
 
762
  $pointer_content .= '<p><strong>Ad blockers</strong><br />Disable your ad blocker in your browser so your adverts and dashboard show up correctly. Take a look at this manual to <a href="https://ajdg.solutions/support/adrotate-manuals/configure-adblockers-for-your-own-website/" target="_blank">whitelist your site</a>.</p>';
763
  ?>
676
  if(strpos($page, 'adrotate') !== false) {
677
  if(isset($_GET['hide']) AND $_GET['hide'] == 0) update_option('adrotate_hide_getpro', adrotate_now() + (31 * DAY_IN_SECONDS));
678
  if(isset($_GET['hide']) AND $_GET['hide'] == 1) update_option('adrotate_hide_review', 1);
679
+ if(isset($_GET['hide']) AND $_GET['hide'] == 2) update_option('adrotate_hide_birthday', adrotate_now() + (10 * MONTH_IN_SECONDS));
680
+
 
681
  // Get AdRotate Pro
682
  $getpro_banner = get_option('adrotate_hide_getpro');
683
  if($getpro_banner < adrotate_now()) {
684
+ echo '<div class="ajdg-notification notice">';
685
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/notification.png', __FILE__).'\');"><span></span></div>';
686
  echo ' <div class="ajdg-notification-message">Hello <strong>'.$displayname.'</strong>. Have you considered upgrading to <strong>AdRotate Professional</strong> yet?<br />Get extra features like Geo Targeting, Scheduling, mobile adverts, access to premium support and much more starting at only &euro;39 EUR.<br />Use coupon code <strong>getadrotatepro</strong> and get a 10% discount on any <strong>AdRotate Professional</strong> license! Thank you for your consideration!</div>';
687
  echo ' <div class="ajdg-notification-cta">';
688
  echo ' <a href="'.admin_url('admin.php?page=adrotate-pro').'" class="ajdg-notification-act button-primary">Get AdRotate Pro</a>';
689
+ echo ' <a href="'.admin_url('admin.php?page=adrotate').'&hide=0" class="ajdg-notification-dismiss">Maybe later</a>';
690
  echo ' </div>';
691
  echo '</div>';
692
  }
694
  // Write a review
695
  $review_banner = get_option('adrotate_hide_review');
696
  if($review_banner != 1 AND $review_banner < (adrotate_now() - (8 * DAY_IN_SECONDS))) {
697
+ echo '<div class="ajdg-notification notice">';
698
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/notification.png', __FILE__).'\');"><span></span></div>';
699
+ echo ' <div class="ajdg-notification-message">Hello <strong>'.$displayname.'</strong>! You have been using <strong>AdRotate</strong> for a few days. If you like AdRotate, please share <strong>your experience</strong> and help promote AdRotate.<br />Tell your followers that you use AdRotate. A <a href="https://twitter.com/intent/tweet?hashtags=wordpress%2Cplugin%2Cadvertising&related=arnandegans%2Cwordpress&text=I%20am%20using%20AdRotate%20for%20@WordPress.%20Check%20it%20out.&url=https%3A%2F%2Fwordpress.org/plugins/adrotate/" target="_blank" class="ajdg-notification-act goosebox">Tweet</a> or <a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwordpress.org%2Fplugins%2Fadrotate%2F&amp;src=adrotate" target="_blank" class="ajdg-notification-act goosebox">Facebook Share</a> helps a lot and is super awesome!<br />If you have questions, complaints or something else that does not belong in a review, please use the <a href="'.admin_url('admin.php?page=adrotate-support').'">support forum</a>!</div>';
700
  echo ' <div class="ajdg-notification-cta">';
701
+ echo ' <a href="https://wordpress.org/support/view/plugin-reviews/adrotate?rate=5#postform" class="ajdg-notification-act button-primary">Write Review</a>';
702
+ echo ' <a href="'.admin_url('admin.php?page=adrotate').'&hide=1" class="ajdg-notification-dismiss">Maybe later</a>';
703
  echo ' </div>';
704
  echo '</div>';
705
  }
707
  // Birthday
708
  $birthday_banner = get_option('adrotate_hide_birthday');
709
  if($birthday_banner < adrotate_now() AND date('M',adrotate_date_start('day')) == 'Feb') {
710
+ echo '<div class="ajdg-notification notice">';
711
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/birthday.png', __FILE__).'\');"><span></span></div>';
712
  echo ' <div class="ajdg-notification-message">Hey <strong>'.$displayname.'</strong>! Did you know it is Arnan his birtyday this month? February 9th to be exact. Wish him a happy birthday via Twitter!<br />Who is Arnan? He made AdRotate for you - Check out his <a href="https://www.arnan.me/?pk_campaign=adrotatefree&pk_keyword=birthday_banner" target="_blank">website</a> or <a href="https://www.arnan.me/donate.html?pk_campaign=adrotatefree&pk_keyword=birthday_banner" target="_blank">send a gift</a>.</div>';
713
  echo ' <div class="ajdg-notification-cta">';
714
+ echo ' <a href="https://twitter.com/intent/tweet?text=Happy%20Birthday%20@arnandegans!%20From%20'.$displayname.'%20at%20'.home_url().'&hashtags=birthday,adrotate" target="_blank" class="ajdg-notification-act button-primary goosebox"><i class="icn-t">Wish Happy Birthday</a>';
715
+ echo ' <a href="'.admin_url('admin.php?page=adrotate').'&hide=2" class="ajdg-notification-dismiss">Not now</a>';
716
  echo ' </div>';
717
  echo '</div>';
718
  }
723
  if($adrotate_has_error) {
724
  echo '<div class="ajdg-notification notice" style="">';
725
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/notification.png', __FILE__).'\');"><span></span></div>';
726
+ echo ' <div class="ajdg-notification-message"><strong>AdRotate</strong> has detected '._n('one issue that requires', 'several issues that require', count($adrotate_has_error), 'adrotate').' '.__('your attention:', 'adrotate').'<br />';
727
  foreach($adrotate_has_error as $error => $message) {
728
  echo '&raquo; '.$message.'<br />';
729
  }
741
  echo ' <div class="ajdg-notification-logo" style="background-image: url(\''.plugins_url('/images/notification.png', __FILE__).'\');"><span></span></div>';
742
  echo ' <div class="ajdg-notification-message">Thanks for updating <strong>'.$displayname.'</strong>! You have almost completed updating <strong>AdRotate</strong> to version <strong>'.ADROTATE_DISPLAY.'</strong>!<br />To complete the update <strong>click the button on the right</strong>. This may take a few seconds to complete!<br />For an overview of what has changed take a look at the <a href="https://ajdg.solutions/support/adrotate-development/?pk_campaign=adrotatefree&pk_keyword=finish_update_notification" target="_blank">development page</a> and usually there is an article on <a href="https://ajdg.solutions/blog/" target="_blank">the blog</a> with more information as well.</div>';
743
  echo ' <div class="ajdg-notification-cta">';
744
+ echo ' <a href="'.admin_url('admin.php?page=adrotate-settings').'&tab=maintenance&action=update-db" class="ajdg-notification-act button-primary update-button">Finish update</a>';
745
  echo ' </div>';
746
  echo '</div>';
747
  }
754
  -------------------------------------------------------------*/
755
  function adrotate_welcome_pointer() {
756
  $pointer_content = '<h3>AdRotate '.ADROTATE_DISPLAY.'</h3>';
757
+ $pointer_content .= '<p>'.__('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').' <a href="http:\/\/ajdg.solutions\/support\/adrotate-manuals\/" target="_blank">'.__('manuals', 'adrotate').'</a> '.__('and', 'adrotate').' <a href="https:\/\/ajdg.solutions\/forums\/forum\/adrotate-for-wordpress\/" target="_blank">'.__('forums', 'adrotate').'</a>. These links are also available in the help tab in the top right.</p>';
758
 
759
+ $pointer_content .= '<p><strong>AdRotate Professional - <a href="admin.php?page=adrotate-pro">Learn more &raquo;</a></strong><br />If you like AdRotate please consider upgrading to AdRotate Professional and benefit from many <a href="admin.php?page=adrotate-pro">extra features</a> to make your campaigns more profitable!</p>';
760
 
761
  $pointer_content .= '<p><strong>Ad blockers</strong><br />Disable your ad blocker in your browser so your adverts and dashboard show up correctly. Take a look at this manual to <a href="https://ajdg.solutions/support/adrotate-manuals/configure-adblockers-for-your-own-website/" target="_blank">whitelist your site</a>.</p>';
762
  ?>
adrotate-statistics.php CHANGED
@@ -96,7 +96,7 @@ function adrotate_stats($ad, $archive = false, $when = 0, $until = 0) {
96
  global $wpdb;
97
 
98
  if($when > 0 AND is_numeric($when) AND $until > 0 AND is_numeric($until)) { // date range
99
- $whenquery = " AND `thetime` >= '$when' AND `thetime` <= '$until' GROUP BY `ad` ASC";
100
  } else if($when > 0 AND is_numeric($when) AND $until == 0) { // one day
101
  $until = $when + 86400;
102
  $whenquery = " AND `thetime` >= '$when' AND `thetime` <= '$until'";
@@ -186,19 +186,19 @@ function adrotate_stats_graph($type, $archive = false, $id, $chartid, $start, $e
186
  }
187
 
188
  if($type == 'ads' OR $type == 'advertiser') {
189
- $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}{$table}` WHERE `ad` = %d AND `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ASC;", $id, $start, $end), ARRAY_A);
190
  }
191
 
192
  if($type == 'groups') {
193
- $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}{$table}` WHERE `group` = %d AND `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ASC;", $id, $start, $end), ARRAY_A);
194
  }
195
 
196
  if($type == 'fullreport') {
197
- $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}{$table}` WHERE `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ASC;", $start, $end), ARRAY_A);
198
  }
199
 
200
  if($type == 'advertiserfull') {
201
- $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}{$table}`, `{$wpdb->prefix}adrotate_linkmeta` WHERE `{$wpdb->prefix}adrotate_stats`.`ad` = `{$wpdb->prefix}adrotate_linkmeta`.`ad` AND `{$wpdb->prefix}adrotate_linkmeta`.`user` = %d AND `{$wpdb->prefix}adrotate_stats`.`thetime` >= %d AND `{$wpdb->prefix}adrotate_stats`.`thetime` <= %d GROUP BY `thetime` ASC;", $id, $start, $end), ARRAY_A);
202
  }
203
 
204
  if($stats) {
96
  global $wpdb;
97
 
98
  if($when > 0 AND is_numeric($when) AND $until > 0 AND is_numeric($until)) { // date range
99
+ $whenquery = " AND `thetime` >= '$when' AND `thetime` <= '$until' GROUP BY `ad` ORDER BY `ad` ASC";
100
  } else if($when > 0 AND is_numeric($when) AND $until == 0) { // one day
101
  $until = $when + 86400;
102
  $whenquery = " AND `thetime` >= '$when' AND `thetime` <= '$until'";
186
  }
187
 
188
  if($type == 'ads' OR $type == 'advertiser') {
189
+ $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}{$table}` WHERE `ad` = %d AND `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ORDER BY `thetime` ASC;", $id, $start, $end), ARRAY_A);
190
  }
191
 
192
  if($type == 'groups') {
193
+ $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}{$table}` WHERE `group` = %d AND `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ORDER BY `thetime` ASC;", $id, $start, $end), ARRAY_A);
194
  }
195
 
196
  if($type == 'fullreport') {
197
+ $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}{$table}` WHERE `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ORDER BY `thetime` ASC;", $start, $end), ARRAY_A);
198
  }
199
 
200
  if($type == 'advertiserfull') {
201
+ $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}{$table}`, `{$wpdb->prefix}adrotate_linkmeta` WHERE `{$wpdb->prefix}adrotate_stats`.`ad` = `{$wpdb->prefix}adrotate_linkmeta`.`ad` AND `{$wpdb->prefix}adrotate_linkmeta`.`user` = %d AND `{$wpdb->prefix}adrotate_stats`.`thetime` >= %d AND `{$wpdb->prefix}adrotate_stats`.`thetime` <= %d GROUP BY `thetime` ORDER BY `thetime` ASC;", $id, $start, $end), ARRAY_A);
202
  }
203
 
204
  if($stats) {
adrotate.php CHANGED
@@ -6,7 +6,7 @@ Author: Arnan de Gans
6
  Author URI: https://www.arnan.me/?pk_campaign=adrotatefree&pk_keyword=plugin_info
7
  Description: Monetise your website with adverts while keeping things simple. Start making money today!
8
  Text Domain: adrotate
9
- Version: 5.8.4
10
  License: GPLv3
11
  */
12
 
@@ -21,7 +21,7 @@ License: GPLv3
21
  ------------------------------------------------------------------------------------ */
22
 
23
  /*--- AdRotate values ---------------------------------------*/
24
- define("ADROTATE_DISPLAY", '5.8.4');
25
  define("ADROTATE_VERSION", 399);
26
  define("ADROTATE_DB_VERSION", 66);
27
  $plugin_folder = plugin_dir_path(__FILE__);
6
  Author URI: https://www.arnan.me/?pk_campaign=adrotatefree&pk_keyword=plugin_info
7
  Description: Monetise your website with adverts while keeping things simple. Start making money today!
8
  Text Domain: adrotate
9
+ Version: 5.8.5
10
  License: GPLv3
11
  */
12
 
21
  ------------------------------------------------------------------------------------ */
22
 
23
  /*--- AdRotate values ---------------------------------------*/
24
+ define("ADROTATE_DISPLAY", '5.8.5');
25
  define("ADROTATE_VERSION", 399);
26
  define("ADROTATE_DB_VERSION", 66);
27
  $plugin_folder = plugin_dir_path(__FILE__);
dashboard/info.php CHANGED
@@ -44,11 +44,12 @@ $data = get_option("adrotate_advert_status");
44
  </div>
45
 
46
  <div class="ajdg-postbox">
47
- <h2 class="ajdg-postbox-title">AdRotate Banner Manager</h2>
48
  <div id="services" class="ajdg-postbox-content">
49
- <p><strong>Your help and support is important</strong></p>
50
- <p>Consider writing a review or making a donation if you like the plugin or if you find the plugin useful. Reviews cost you nothing but are super helpful as promotion which helps to ensure future development. Thank you for your consideration and support!</p>
51
- <center><a class="button-primary" href="https://ajdg.solutions/go/donate/adrotatefree" target="_blank">Donate via Paypal</a> <a class="button" target="_blank" href="https://wordpress.org/support/plugin/adrotate/reviews/?rate=5#new-post">Write review on WordPress.org</a></center></p>
 
52
 
53
  <p><strong>More plugins and services</strong></p>
54
  <p>Check out these and more services in more details on my website. I also make more plugins. If you like AdRotate - Maybe you like some of those as well. Take a look at the <a href="https://ajdg.solutions/plugins/?pk_campaign=adrotatefree&pk_keyword=info_page" target="_blank">plugins</a> and overall <a href="https://ajdg.solutions/pricing/?pk_campaign=adrotatefree&pk_keyword=info_page" target="_blank">pricing</a> page for more.</p>
@@ -125,7 +126,7 @@ $data = get_option("adrotate_advert_status");
125
 
126
  <hr>
127
  <h1><?php _e('Advertising Partners & Affiliates', 'adrotate'); ?></h1>
128
- <em><?php _e('A selection of quality advertiser networks and useful products. If you need adverts or just want more or more diverse adverts. Check out these great options!', 'adrotate'); ?><br /><?php _e('Check out these and other preferred products or providers on my', 'adrotate'); ?> <a rel="nofollow" href="https://ajdg.solutions/recommended-products/&pk_campaign=adrotatefree&pk_keyword=info_page"><?php _e('recommended products page', 'adrotate'); ?></a>.</em>
129
 
130
  <div id="dashboard-widgets-wrap">
131
  <div id="dashboard-widgets" class="metabox-holder">
44
  </div>
45
 
46
  <div class="ajdg-postbox">
47
+ <h2 class="ajdg-postbox-title">AdRotate</h2>
48
  <div id="services" class="ajdg-postbox-content">
49
+ <p><strong>Your help is important</strong></p>
50
+ <p>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. Thank you for your consideration and support!</p>
51
+
52
+ <p><a href="https://twitter.com/intent/tweet?hashtags=wordpress%2Cplugin%2Cadvertising&related=arnandegans%2Cwordpress&text=I%20am%20using%20AdRotate%20for%20@WordPress.%20Check%20it%20out.&url=https%3A%2F%2Fwordpress.org/plugins/adrotate/" target="_blank" class="button-primary goosebox"><i class="icn-t"></i>Post Tweet</a> <a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwordpress.org%2Fplugins%2Fadrotate%2F&amp;src=adrotate" target="_blank" class="button-primary goosebox"><i class="icn-fb"></i>Share on Facebook</a> <a class="button-primary" href="https://ajdg.solutions/go/donate/adrotatefree" target="_blank">Donate via Paypal</a> <a class="button" target="_blank" href="https://wordpress.org/support/plugin/adrotate/reviews/?rate=5#new-post">Write review on WordPress.org</a></p>
53
 
54
  <p><strong>More plugins and services</strong></p>
55
  <p>Check out these and more services in more details on my website. I also make more plugins. If you like AdRotate - Maybe you like some of those as well. Take a look at the <a href="https://ajdg.solutions/plugins/?pk_campaign=adrotatefree&pk_keyword=info_page" target="_blank">plugins</a> and overall <a href="https://ajdg.solutions/pricing/?pk_campaign=adrotatefree&pk_keyword=info_page" target="_blank">pricing</a> page for more.</p>
126
 
127
  <hr>
128
  <h1><?php _e('Advertising Partners & Affiliates', 'adrotate'); ?></h1>
129
+ <em><?php _e('A selection of quality advertiser networks and useful products. If you need adverts or just want more or more diverse adverts. Check out these great options!', 'adrotate'); ?><br /><?php _e('Check out these and other preferred products or providers on my', 'adrotate'); ?> <a rel="nofollow" href="https://ajdg.solutions/recommended-products/?pk_campaign=adrotatefree&pk_keyword=info_page"><?php _e('recommended products page', 'adrotate'); ?></a>.</em>
130
 
131
  <div id="dashboard-widgets-wrap">
132
  <div id="dashboard-widgets" class="metabox-holder">
library/dashboard.css CHANGED
@@ -29,6 +29,9 @@
29
  .wp-core-ui .ajdg-notification-cta a, .wp-core-ui .ajdg-notification-cta .button-primary:active { vertical-align: middle; }
30
  .ajdg-notification-dismiss { background: transparent; margin-left: 20px; border: 0; cursor: pointer; color: #BBB; text-decoration: none; }
31
 
 
 
 
32
  /* Update button */
33
  .update-button { -webkit-animation: glowing 1500ms infinite; -moz-animation: glowing 1500ms infinite; -o-animation: glowing 1500ms infinite; animation: glowing 1500ms infinite; }
34
  @-webkit-keyframes glowing { 0% { -webkit-box-shadow: 0 0 3px #1fa4d1; } 50% { -webkit-box-shadow: 0 0 40px #466f82; } 100% { -webkit-box-shadow: 0 0 3px #1fa4d1; } }
29
  .wp-core-ui .ajdg-notification-cta a, .wp-core-ui .ajdg-notification-cta .button-primary:active { vertical-align: middle; }
30
  .ajdg-notification-dismiss { background: transparent; margin-left: 20px; border: 0; cursor: pointer; color: #BBB; text-decoration: none; }
31
 
32
+ .icn-fb { position: relative; top: 2px; margin-right: 3px; display: inline-block; width: 14px; height: 14px; background: transparent 0 0 no-repeat; background-image: url(data:image/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2016%2016%22%20class%3D%22_1pbq%22%20color%3D%22%23ffffff%22%3E%3Cpath%20fill%3D%22%23ffffff%22%20fill-rule%3D%22evenodd%22%20d%3D%22M4.55%2C7%20C4.7984%2C7%205%2C7.23403636%205%2C7.52247273%20L5%2C13.4775273%0A%20%20%20%20%20%20%20%20%20%20C5%2C13.7659636%204.7984%2C14%204.55%2C14%20L2.45%2C14%20C2.2016%2C14%202%2C13.7659636%0A%20%20%20%20%20%20%20%20%20%202%2C13.4775273%20L2%2C7.52247273%20C2%2C7.23403636%202.2016%2C7%202.45%2C7%20L4.55%2C7%20Z%0A%20%20%20%20%20%20%20%20%20%20M6.54470232%2C13.2%20C6.24016877%2C13.1641086%206.01734614%2C12.8982791%0A%20%20%20%20%20%20%20%20%20%206%2C12.5737979%20C6.01734614%2C12.5737979%206.01344187%2C9.66805666%206%2C8.14398693%0A%20%20%20%20%20%20%20%20%20%20C6.01344187%2C7.61903931%206.10849456%2C6.68623352%206.39801308%2C6.27384278%0A%20%20%20%20%20%20%20%20%20%20C7.10556287%2C5.26600749%207.60281698%2C4.6079584%207.89206808%2C4.22570082%0A%20%20%20%20%20%20%20%20%20%20C8.18126341%2C3.8435016%208.52813047%2C3.4708734%208.53777961%2C3.18572676%0A%20%20%20%20%20%20%20%20%20%20C8.55077527%2C2.80206854%208.53655255%2C2.79471518%208.53777961%2C2.35555666%0A%20%20%20%20%20%20%20%20%20%20C8.53900667%2C1.91639814%208.74565444%2C1.5%209.27139313%2C1.5%20C9.52544997%2C1.5%0A%20%20%20%20%20%20%20%20%20%209.7301456%2C1.55690094%209.91922413%2C1.80084547%20C10.2223633%2C2.15596568%0A%20%20%20%20%20%20%20%20%20%2010.4343097%2C2.71884727%2010.4343097%2C3.60971169%20C10.4343097%2C4.50057612%0A%20%20%20%20%20%20%20%20%20%209.50989975%2C6.1729303%209.50815961%2C6.18%20C9.50815961%2C6.18%0A%20%20%20%20%20%20%20%20%20%2013.5457098%2C6.17908951%2013.5464084%2C6.18%20C14.1635544%2C6.17587601%0A%20%20%20%20%20%20%20%20%20%2014.5%2C6.72543196%2014.5%2C7.29718426%20C14.5%2C7.83263667%2014.1341135%2C8.27897346%0A%20%20%20%20%20%20%20%20%20%2013.6539433%2C8.3540827%20C13.9452023%2C8.49286263%2014.1544715%2C8.82364675%0A%20%20%20%20%20%20%20%20%20%2014.1544715%2C9.20555417%20C14.1544715%2C9.68159617%2013.8293011%2C10.0782687%0A%20%20%20%20%20%20%20%20%20%2013.3983805%2C10.1458495%20C13.6304619%2C10.2907572%2013.7736931%2C10.5516845%0A%20%20%20%20%20%20%20%20%20%2013.7736931%2C10.847511%20C13.7736931%2C11.2459343%2013.5138356%2C11.5808619%0A%20%20%20%20%20%20%20%20%20%2013.1594388%2C11.6612236%20C13.3701582%2C11.7991865%2013.5063617%2C12.0543945%0A%20%20%20%20%20%20%20%20%20%2013.5063617%2C12.3429843%20C13.5063617%2C12.7952155%2013.1715421%2C13.1656844%0A%20%20%20%20%20%20%20%20%20%2012.7434661%2C13.2%20L6.54470232%2C13.2%20Z%22%3E%3C%2Fpath%3E%3C%2Fsvg%3E); }
33
+ .icn-t { position: relative; top: 2px; margin-right: 3px; display: inline-block; width: 14px; height: 14px; background: transparent 0 0 no-repeat; background-image: url(data:image/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2072%2072%22%3E%3Cpath%20fill%3D%22none%22%20d%3D%22M0%200h72v72H0z%22%2F%3E%3Cpath%20class%3D%22icon%22%20fill%3D%22%23fff%22%20d%3D%22M68.812%2015.14c-2.348%201.04-4.87%201.744-7.52%202.06%202.704-1.62%204.78-4.186%205.757-7.243-2.53%201.5-5.33%202.592-8.314%203.176C56.35%2010.59%2052.948%209%2049.182%209c-7.23%200-13.092%205.86-13.092%2013.093%200%201.026.118%202.02.338%202.98C25.543%2024.527%2015.9%2019.318%209.44%2011.396c-1.125%201.936-1.77%204.184-1.77%206.58%200%204.543%202.312%208.552%205.824%2010.9-2.146-.07-4.165-.658-5.93-1.64-.002.056-.002.11-.002.163%200%206.345%204.513%2011.638%2010.504%2012.84-1.1.298-2.256.457-3.45.457-.845%200-1.666-.078-2.464-.23%201.667%205.2%206.5%208.985%2012.23%209.09-4.482%203.51-10.13%205.605-16.26%205.605-1.055%200-2.096-.06-3.122-.184%205.794%203.717%2012.676%205.882%2020.067%205.882%2024.083%200%2037.25-19.95%2037.25-37.25%200-.565-.013-1.133-.038-1.693%202.558-1.847%204.778-4.15%206.532-6.774z%22%2F%3E%3C%2Fsvg%3E); }
34
+
35
  /* Update button */
36
  .update-button { -webkit-animation: glowing 1500ms infinite; -moz-animation: glowing 1500ms infinite; -o-animation: glowing 1500ms infinite; animation: glowing 1500ms infinite; }
37
  @-webkit-keyframes glowing { 0% { -webkit-box-shadow: 0 0 3px #1fa4d1; } 50% { -webkit-box-shadow: 0 0 40px #466f82; } 100% { -webkit-box-shadow: 0 0 3px #1fa4d1; } }
library/goosebox.js ADDED
@@ -0,0 +1,19 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ /*
2
+ Popups that work
3
+ Version: 1.0
4
+ Original code: Arnan de Gans
5
+ Copyright: See notice in adrotate-pro.php
6
+ */
7
+ jQuery(document).ready(function($) {
8
+ $('.goosebox').click(function() {
9
+
10
+ var left = (screen.width/2)-375;
11
+ var top = (screen.height/2)-275;
12
+ var NWin = window.open($(this).prop('href'), 'Spread the word', 'toolbar=no, location=no, status=no, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=750, height=550, top='+top+', left='+left);
13
+
14
+ if (window.focus) {
15
+ NWin.focus();
16
+ }
17
+ return false;
18
+ });
19
+ });
readme.txt CHANGED
@@ -4,8 +4,8 @@ Donate link: https://ajdg.solutions/go/donate/adrotatefree
4
  Tags: adverts, ads, banners, advert manager, ad manager, banner manager, monetise, revenue, place banners, adsense, dfp, doubleclick, amazon, affiliate, referral
5
  Requires at least: 4.6
6
  Requires PHP: 5.6
7
- Tested up to: 5.4.1
8
- Stable tag: 5.8.4
9
  License: GPLv3
10
 
11
  AdRotate is the only advert manager you'll ever need for WordPress.
@@ -61,28 +61,18 @@ For more detailed instructions check out the [installation steps](https://ajdg.s
61
 
62
  For the full changelog check out the [development page](https://ajdg.solutions/support/adrotate-development/?pk_campaign=adrotatefree&pk_keyword=readme).
63
 
 
 
 
 
64
  = AdRotate 5.8.4 =
65
- * [fix] Possible XSS vulnerability for certain urls
66
 
67
  = AdRotate 5.8.3.1 =
68
  * [i18n] Updated Dutch translation
69
  * [i18n] Updated French translation
70
  * [i18n] Updated Italian translation
71
 
72
- = AdRotate 5.8.3 =
73
- * [new] Configuration notifications when editing groups
74
- * [new] Portable adverts
75
- * [change] Dashboard tweaks
76
- * [fix] 'Unexpected output' notice on activation of the plugin
77
- * [i18n] Updated Dutch, French, German and Italian
78
-
79
- = AdRotate 5.8.2 =
80
- * Improved WordPress 5.4.1 compatibility
81
- * [i18n] Updated french translation
82
-
83
- = AdRotate 5.8.1 =
84
- * [fix] Uninstall not working for some people
85
-
86
  Be a Pro and get [AdRotate Professional](https://ajdg.solutions/product-category/adrotate-pro/?pk_campaign=adrotatefree&pk_keyword=readme)!
87
 
88
  = AdRotate Professional 5.8.3 =
@@ -103,9 +93,6 @@ Be a Pro and get [AdRotate Professional](https://ajdg.solutions/product-category
103
  * Improved WordPress 5.4.1 compatibility
104
  * [i18n] Updated french translation
105
 
106
- = AdRotate Professional 5.8.1 =
107
- * [fix] Uninstall not working for some people
108
-
109
  == Upgrade Notice ==
110
 
111
  Enjoy this latest update with the latest tweaks and improvements for AdRotate for WordPress!
@@ -121,7 +108,7 @@ Yes, clicks and impressions.
121
 
122
  = Can I use my adverts from Google AdSense? =
123
  Yes, usually you can use their code as-is.
124
- Googles new Auto-Ads are supported as well.
125
 
126
  = Does AdRotate support HTML5 adverts? =
127
  Yes!
@@ -153,9 +140,6 @@ Yes!
153
  = Does AdRotate work with bbPress? =
154
  Yes!
155
 
156
- = Are emails sent by AdRotate sent through my installed SMTP plugin? =
157
- Yes! Such plugins take over the wp_mail() function which is what AdRotate uses.
158
-
159
  == Screenshots ==
160
 
161
  1. The AdRotate menu
4
  Tags: adverts, ads, banners, advert manager, ad manager, banner manager, monetise, revenue, place banners, adsense, dfp, doubleclick, amazon, affiliate, referral
5
  Requires at least: 4.6
6
  Requires PHP: 5.6
7
+ Tested up to: 5.4.2
8
+ Stable tag: 5.8.5
9
  License: GPLv3
10
 
11
  AdRotate is the only advert manager you'll ever need for WordPress.
61
 
62
  For the full changelog check out the [development page](https://ajdg.solutions/support/adrotate-development/?pk_campaign=adrotatefree&pk_keyword=readme).
63
 
64
+ = AdRotate 5.8.5 =
65
+ * [fix] Improved MySQL 8 compatibility
66
+ * [change] Improved dashboard notifications
67
+
68
  = AdRotate 5.8.4 =
69
+ * [fix] Possible SQL injection vulnerability for certain urls
70
 
71
  = AdRotate 5.8.3.1 =
72
  * [i18n] Updated Dutch translation
73
  * [i18n] Updated French translation
74
  * [i18n] Updated Italian translation
75
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
76
  Be a Pro and get [AdRotate Professional](https://ajdg.solutions/product-category/adrotate-pro/?pk_campaign=adrotatefree&pk_keyword=readme)!
77
 
78
  = AdRotate Professional 5.8.3 =
93
  * Improved WordPress 5.4.1 compatibility
94
  * [i18n] Updated french translation
95
 
 
 
 
96
  == Upgrade Notice ==
97
 
98
  Enjoy this latest update with the latest tweaks and improvements for AdRotate for WordPress!
108
 
109
  = Can I use my adverts from Google AdSense? =
110
  Yes, usually you can use their code as-is.
111
+ Googles new Auto-Ads work as well.
112
 
113
  = Does AdRotate support HTML5 adverts? =
114
  Yes!
140
  = Does AdRotate work with bbPress? =
141
  Yes!
142
 
 
 
 
143
  == Screenshots ==
144
 
145
  1. The AdRotate menu