WordPress.org
Get WordPress

Plugin Directory

Changeset 3102453


Ignore:
Timestamp:
06/13/2024 06:09:25 PM (22 months ago)
Author:
edhicks
Message:

Bugfix

Location:
simple-webstats
Files:
111 added
3 edited

Legend:

Unmodified
Added
Removed

  • simple-webstats/trunk/inc/dashboard.php

    r3102307 r3102453  
    244244        {
    245245            $comparativeWhereClauses = $this->where_clauses(array_merge($timeBounds['comparativeWhereClauses'], array('v.timeonpage > 0')));
    246             $sql = $wpdb->prepare("SELECT * FROM (SELECT AVG(sub.timeonpage) AS val FROM (SELECT @row_index := @row_index + 1 AS row_index, v.timeonpage FROM %i AS v, (SELECT @row_index := -1) r %1s ORDER BY v.timeonpage) AS sub WHERE sub.row_index IN (FLOOR(@row_index / 2), CEIL(@row_index / 2))) AS a, (SELECT AVG(sub.timeonpage) AS comp FROM (SELECT @row_index := @row_index + 1 AS row_index, v.timeonpage FROM %i AS v, (SELECT @row_index := -1) r %1s ORDER BY v.timeonpage) AS sub WHERE sub.row_index IN (FLOOR(@row_index / 2), CEIL(@row_index / 2))) AS b", $wpdb->prefix.SWSTATS_VIEWS_TABLE, $whereClauses, $wpdb->prefix.SWSTATS_VIEWS_TABLE, $comparativeWhereClauses);
     246            $sql = $wpdb->prepare("SELECT * FROM (SELECT AVG(sub.timeonpage) AS val FROM (SELECT @row_index_a := @row_index_a + 1 AS row_index, v.timeonpage FROM %i AS v, (SELECT @row_index_a := -1) r %1s ORDER BY v.timeonpage) AS sub WHERE sub.row_index IN (FLOOR(@row_index_a / 2), CEIL(@row_index_a / 2))) AS a, (SELECT AVG(sub.timeonpage) AS comp FROM (SELECT @row_index_b := @row_index_b + 1 AS row_index, v.timeonpage FROM %i AS v, (SELECT @row_index_b := -1) r %1s ORDER BY v.timeonpage) AS sub WHERE sub.row_index IN (FLOOR(@row_index_b / 2), CEIL(@row_index_b / 2))) AS b", $wpdb->prefix.SWSTATS_VIEWS_TABLE, $whereClauses, $wpdb->prefix.SWSTATS_VIEWS_TABLE, $comparativeWhereClauses);
    247247        }
    248248        else
    … …  
    253253        if(isset($result[0]))
    254254        {
    255             if(isset($result[0]->val) && $result[0]->val && $data['viewsPerVisit']['value']) $dataPoint['value'] =  $result[0]->val * $data['viewsPerVisit']['value'];
     255            if(isset($result[0]->val) && $result[0]->val && $data['viewsPerVisit']['value']) $dataPoint['value'] = $result[0]->val * $data['viewsPerVisit']['value'];
    256256            if(($dataPoint['value'] !== null) && isset($result[0]->comp) && $result[0]->comp && $data['viewsPerVisit']['comparison']) $dataPoint['comparison'] = $result[0]->comp * $data['viewsPerVisit']['comparison'];
    257257        }

  • simple-webstats/trunk/readme.txt

    r3102307 r3102453  
    55Tested up to: 6.5
    66Requires PHP: 7.3
    7 Stable tag: 1.2.1
     7Stable tag: 1.2.2
    88License: GPLv2 or later
    99
    … …  
    5050== Changelog ==
    5151
     52= 1.2.2 =
     53
     54* Bugfix: Error in average time on site query was causing anomalous results.
     55
    5256= 1.2.1 =
    5357

  • simple-webstats/trunk/simple-webstats.php

    r3102307 r3102453  
    44* Plugin Name: Simple Webstats
    55* Description: Privacy-focused cookie-free web analytics for WordPress.
    6 * Version: 1.2.1
     6* Version: 1.2.2
    77* Requires at least: 4.6
    88* Requires PHP: 7.3
    … …  
    2020
    2121// config
    22 define('SWSTATS_VERSION', '1.2.1');
     22define('SWSTATS_VERSION', '1.2.2');
    2323define('SWSTATS_PATH',  plugin_dir_path(__FILE__));
    2424define('SWSTATS_URL',  plugin_dir_url(__FILE__));
Note: See TracChangeset for help on using the changeset viewer.