AdRotate Banner Manager - Version 5.0.1

Version Description

FREE = * [fix] Stats sometimes displaying wrong dates * [fix] Stats dropdowns showing wrong dates

Download this release

Release Info

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

Code changes from version 5.0 to 5.0.1

Files changed (5) hide show
  1. adrotate.php +2 -13
  2. dashboard/publisher/statistics-advert.php +2 -2
  3. dashboard/publisher/statistics-group.php +4 -4
  4. dashboard/publisher/statistics-main.php +11 -0
  5. readme.txt +8 -8
adrotate.php CHANGED
@@ -7,7 +7,7 @@ Author URI: https://www.arnan.me/
7
  Description: AdRotate Banner Manager - Monetise your website with adverts while keeping things simple. Start making money today!
8
  Text Domain: adrotate
9
  Domain Path: /languages/
10
- Version: 5.0
11
  License: GPLv3
12
  */
13
 
@@ -22,7 +22,7 @@ License: GPLv3
22
  ------------------------------------------------------------------------------------ */
23
 
24
  /*--- AdRotate values ---------------------------------------*/
25
- define("ADROTATE_DISPLAY", '5.0');
26
  define("ADROTATE_VERSION", 392);
27
  define("ADROTATE_DB_VERSION", 64);
28
  $plugin_folder = plugin_dir_path(__FILE__);
@@ -393,17 +393,6 @@ function adrotate_statistics() {
393
 
394
  <?php
395
  if ($view == "") {
396
- $stats = adrotate_prepare_fullreport();
397
- $stats_graph_month = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `thetime` >= {$monthstart} AND `thetime` <= {$monthend};", ARRAY_A);
398
- if(empty($stats_graph_month['impressions'])) $stats_graph_month['impressions'] = 0;
399
- if(empty($stats_graph_month['clicks'])) $stats_graph_month['clicks'] = 0;
400
-
401
- // Get Click Through Rate
402
- $ctr_alltime = adrotate_ctr($stats['overall_clicks'], $stats['overall_impressions']);
403
- $ctr_last_month = adrotate_ctr($stats['last_month_clicks'], $stats['last_month_impressions']);
404
- $ctr_this_month = adrotate_ctr($stats['this_month_clicks'], $stats['this_month_impressions']);
405
- $ctr_graph_month = adrotate_ctr($stats_graph_month['clicks'], $stats_graph_month['impressions']);
406
-
407
  include("dashboard/publisher/statistics-main.php");
408
  } else if($view == "advert") {
409
  include("dashboard/publisher/statistics-advert.php");
7
  Description: AdRotate Banner Manager - Monetise your website with adverts while keeping things simple. Start making money today!
8
  Text Domain: adrotate
9
  Domain Path: /languages/
10
+ Version: 5.0.1
11
  License: GPLv3
12
  */
13
 
22
  ------------------------------------------------------------------------------------ */
23
 
24
  /*--- AdRotate values ---------------------------------------*/
25
+ define("ADROTATE_DISPLAY", '5.0.1');
26
  define("ADROTATE_VERSION", 392);
27
  define("ADROTATE_DB_VERSION", 64);
28
  $plugin_folder = plugin_dir_path(__FILE__);
393
 
394
  <?php
395
  if ($view == "") {
 
 
 
 
 
 
 
 
 
 
 
396
  include("dashboard/publisher/statistics-main.php");
397
  } else if($view == "advert") {
398
  include("dashboard/publisher/statistics-advert.php");
dashboard/publisher/statistics-advert.php CHANGED
@@ -13,8 +13,8 @@ $banner = $wpdb->get_row("SELECT `title`, `tracker`, `type` FROM `{$wpdb->prefix
13
 
14
  $stats = adrotate_stats($id, false);
15
  $stats_today = adrotate_stats($id, false, adrotate_date_start('day'));
16
- $stats_last_month = adrotate_stats($id, false, get_date_from_gmt(gmmktime(0, 0, 0, gmdate("m")-1, 1, gmdate("Y")), 'U'), get_date_from_gmt(gmmktime(0, 0, 0, gmdate("m"), 0, gmdate("Y")), 'U'));
17
- $stats_this_month = adrotate_stats($id, false, get_date_from_gmt(gmmktime(0, 0, 0, gmdate("m"), 1, gmdate("Y")), 'U'), get_date_from_gmt(gmmktime(0, 0, 0, gmdate("m"), gmdate("t"), gmdate("Y")), 'U'));
18
  $stats_graph_month = adrotate_stats($id, false, $monthstart, $monthend);
19
 
20
  // Prevent gaps in display
13
 
14
  $stats = adrotate_stats($id, false);
15
  $stats_today = adrotate_stats($id, false, adrotate_date_start('day'));
16
+ $stats_last_month = adrotate_stats($id, false, gmmktime(0, 0, 0, gmdate("m")-1, 1, gmdate("Y")), gmmktime(0, 0, 0, gmdate("m"), 0, gmdate("Y")));
17
+ $stats_this_month = adrotate_stats($id, false, gmmktime(0, 0, 0, gmdate("m"), 1, gmdate("Y")), gmmktime(0, 0, 0, gmdate("m"), gmdate("t"), gmdate("Y")));
18
  $stats_graph_month = adrotate_stats($id, false, $monthstart, $monthend);
19
 
20
  // Prevent gaps in display
dashboard/publisher/statistics-group.php CHANGED
@@ -13,12 +13,12 @@ $title = $wpdb->get_var("SELECT `name` FROM `{$wpdb->prefix}adrotate_groups` WHE
13
  $stats = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id};", ARRAY_A);
14
  $stats_today = $wpdb->get_row("SELECT `clicks`, `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id} AND `thetime` = {$today};", ARRAY_A);
15
 
16
- $start_last_month = get_date_from_gmt(gmmktime(0, 0, 0, gmdate("m")-1, 1, gmdate("Y")), 'U');
17
- $end_last_month = get_date_from_gmt(gmmktime(0, 0, 0, gmdate("m")-1, gmdate("t"), gmdate("Y")), 'U');
18
  $stats_last_month = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id} AND `thetime` >= {$start_last_month} AND `thetime` <= {$end_last_month};", ARRAY_A);
19
 
20
- $start_this_month = get_date_from_gmt(gmmktime(0, 0, 0, gmdate("m"), 1, gmdate("Y")), 'U');
21
- $end_this_month = get_date_from_gmt(gmmktime(0, 0, 0, gmdate("m"), gmdate("t"), gmdate("Y")), 'U');
22
  $stats_this_month = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id} AND `thetime` >= {$start_this_month} AND `thetime` <= {$end_this_month};", ARRAY_A);
23
 
24
  $stats_graph_month = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id} AND `thetime` >= {$monthstart} AND `thetime` <= {$monthend};", ARRAY_A);
13
  $stats = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id};", ARRAY_A);
14
  $stats_today = $wpdb->get_row("SELECT `clicks`, `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id} AND `thetime` = {$today};", ARRAY_A);
15
 
16
+ $start_last_month = gmmktime(0, 0, 0, gmdate("m")-1, 1, gmdate("Y"));
17
+ $end_last_month = gmmktime(0, 0, 0, gmdate("m")-1, gmdate("t"), gmdate("Y"));
18
  $stats_last_month = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id} AND `thetime` >= {$start_last_month} AND `thetime` <= {$end_last_month};", ARRAY_A);
19
 
20
+ $start_this_month = gmmktime(0, 0, 0, gmdate("m"), 1, gmdate("Y"));
21
+ $end_this_month = gmmktime(0, 0, 0, gmdate("m"), gmdate("t"), gmdate("Y"));
22
  $stats_this_month = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id} AND `thetime` >= {$start_this_month} AND `thetime` <= {$end_this_month};", ARRAY_A);
23
 
24
  $stats_graph_month = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `group` = {$id} AND `thetime` >= {$monthstart} AND `thetime` <= {$monthend};", ARRAY_A);
dashboard/publisher/statistics-main.php CHANGED
@@ -8,6 +8,17 @@
8
  * By using this code you agree to indemnify Arnan de Gans from any
9
  * liability that might arise from it's use.
10
  ------------------------------------------------------------------------------------ */
 
 
 
 
 
 
 
 
 
 
 
11
  ?>
12
  <h2><?php _e('Statistics', 'adrotate'); ?></h2>
13
 
8
  * By using this code you agree to indemnify Arnan de Gans from any
9
  * liability that might arise from it's use.
10
  ------------------------------------------------------------------------------------ */
11
+
12
+ $stats = adrotate_prepare_fullreport();
13
+ $stats_graph_month = $wpdb->get_row("SELECT SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `{$wpdb->prefix}adrotate_stats` WHERE `thetime` >= {$monthstart} AND `thetime` <= {$monthend};", ARRAY_A);
14
+ if(empty($stats_graph_month['impressions'])) $stats_graph_month['impressions'] = 0;
15
+ if(empty($stats_graph_month['clicks'])) $stats_graph_month['clicks'] = 0;
16
+
17
+ // Get Click Through Rate
18
+ $ctr_alltime = adrotate_ctr($stats['overall_clicks'], $stats['overall_impressions']);
19
+ $ctr_last_month = adrotate_ctr($stats['last_month_clicks'], $stats['last_month_impressions']);
20
+ $ctr_this_month = adrotate_ctr($stats['this_month_clicks'], $stats['this_month_impressions']);
21
+ $ctr_graph_month = adrotate_ctr($stats_graph_month['clicks'], $stats_graph_month['impressions']);
22
  ?>
23
  <h2><?php _e('Statistics', 'adrotate'); ?></h2>
24
 
readme.txt CHANGED
@@ -3,8 +3,9 @@ Contributors: adegans
3
  Donate link: https://www.arnan.me/donate.html
4
  Tags: ads, advert, adsense, advertising, doubleclick, responsive adverts, ad manager, banner manager, advert manager, monetise, advertisement, banner
5
  Requires at least: 3.8
 
6
  Tested up to: 5.1
7
- Stable tag: 5.0
8
  License: GPLv3
9
 
10
  Monetise your website with adverts while keeping things simple. Start making money today!
@@ -97,14 +98,13 @@ You can also post your questions on the [forum](https://ajdg.solutions/forums/)!
97
 
98
  Be a Professional and go Pro. With [AdRotate Professional](https://ajdg.solutions/plugins/adrotate-for-wordpress/)!
99
 
100
- = 5.0 FREE =
101
- * [new] Advertising Partners dashboard
102
- * [update] Better localized dates for stats
103
- * [update] Dashboard formatting and layout
104
 
105
- = 4.18.2 PRO =
106
- * [fix] Incorrect slug for updates
107
- * [i18n] Updated translation files
108
 
109
  All recent changes are available on the [AdRotate website](https://ajdg.solutions/plugins/adrotate-for-wordpress/development/).
110
 
3
  Donate link: https://www.arnan.me/donate.html
4
  Tags: ads, advert, adsense, advertising, doubleclick, responsive adverts, ad manager, banner manager, advert manager, monetise, advertisement, banner
5
  Requires at least: 3.8
6
+ Requires PHP: 5.6
7
  Tested up to: 5.1
8
+ Stable tag: 5.0.1
9
  License: GPLv3
10
 
11
  Monetise your website with adverts while keeping things simple. Start making money today!
98
 
99
  Be a Professional and go Pro. With [AdRotate Professional](https://ajdg.solutions/plugins/adrotate-for-wordpress/)!
100
 
101
+ = 5.0.1 FREE =
102
+ * [fix] Stats sometimes displaying wrong dates
103
+ * [fix] Stats dropdowns showing wrong dates
 
104
 
105
+ = 5.0.1 PRO =
106
+ * [fix] Stats sometimes displaying wrong dates
107
+ * [fix] Stats dropdowns showing wrong dates
108
 
109
  All recent changes are available on the [AdRotate website](https://ajdg.solutions/plugins/adrotate-for-wordpress/development/).
110