Extension:WSStats

MediaWiki extensions manual
WSStats
Release status: stable
Implementation Parser extension
Description Allows to collect page statistics
Author(s) Charlot Cobben (Sen-Saitalk)
Latest version 2.0.0 (28-09-2023)
Compatibility policy For every MediaWiki release that is a Long Term Support release there is a corresponding branch in the extension.
MediaWiki 1.39+
Database changes Yes
Composer wikibase-solutions/w-s-stats
License GNU General Public License 2.0 or later
Download
README
  • $wgWSSStats
  • <wsstats>

The WSStats extension counts pageviews by user using the before page display hook. There is no client JavaScript run or any trackers installed.

Make sure you update to either version 1.0.8 (MW 1.35.x) or 2.0.0 (MW 1.39.x) due to a security risk

Installation

  • Download and place the file(s) in a directory called WSStats in your extensions/ folder.
  • Add the following code at the bottom of your LocalSettings.php file:
    wfLoadExtension( 'WSStats' );
    
  • Run the update script which will automatically create the necessary database tables that this extension needs.
  • Configure as required
  •   Done – Navigate to Special:Version on your wiki to verify that the extension is successfully installed.

Upgrading

Make sure you always create a backup of your database first!

If you are upgrading from a version before 2.0, then you must visit the special page "Special:WSStats". If the database tables need updating, it will show you there and you can update the tables. You will have to update the tables for statistics to be accurate. This is because we now allow to get statistics based on page titles, while the previous version of WSStats did not store titles.

Configuration

By default anonymous users and sysops are skipped from stats recording. To change this add the following to your "LocalSettings.php" file:

Start with:

$wgWSStats=[];

Allow statistics for anonymous users:

// Record anonymous users
$wgWSStats['skip_anonymous'] = false;

By default special pages are counted as well. To omit special pages set the following:

// Special Pages statistics
$wgWSStats['countSpecialPages'] = false; // defaults to true

Skip users in the following groups..

// Skip if user is in following groups
$wgWSStats['skip_user_groups'][]= 'sysop';
$wgWSStats['skip_user_groups'][]= 'admin';

Skip page with certain text in their referer URL. Default action=edit and veaction=edit are ignored. This configuration option is case sensitive:

$wgWSStats['ignore_in_url'][] = 'Template:Test';
$wgWSStats['ignore_in_url'][] = 'action=edit';

Usage

To retrieve statistics you can use the following parser function:

Ask number of hits for page id 9868:

{{#wsstats:id=9868}}

This returns a number


You can also ask for statistics based on title, instead of page ID's:

Ask number of hits for page with title Main Page:

{{#wsstats:title=Main Page}}

This returns a number


About dates. Dates are in a format of YYYY-MM-DD. Internally WSStats works with Date and Time. This means a date of 2023-10-30 will internally become 2023-10-30 00:00:00. You can also search by date and time. See the examples about this.


Ask number of hits for page ID 714 since start date 2018-09-01:

{{#wsstats:id=714
|start date=2023-09-01
}}

This returns a number


Ask number of hits for page ID 714 since start date 2018-02-01 and end date 2018-09-08:

{{#wsstats:id=714
|start date=2023-02-01|end date=2023-09-08
}}

This returns a number


You can also get statistics based on date and time Get number of hits for page ID 714 from start date 2023-10-30 14:00:00 and end date 2023-10-30 16:00:00:

{{#wsstats:id=714
|start date=2023-10-30 14:00:00
|end date=2023-10-30 16:00:00
}}

This returns a number


Filter results on registered users or anonymous users:

{{#wsstats:id=714
|start date=2023-02-01
|end date=2023-02-08
|type=only anonymous
}}

This returns a number

{{#wsstats:id=714
|start date=2023-02-01
|end date=2023-02-08
|type=only user
}}

This returns a number


Get the top ten pages sorted by hits:

{{#wsstats:stats}}

This returns a table


Get the top ten pages sorted by hits in a date range:

{{#wsstats:stats
|start date=2023-02-01
|end date=2023-02-08
}}

This returns a table from 2018-02-01 00:00:00 up to 2018-02-08 00:00:00 ( so not including 2018-02-08 )


Get the top ten pages sorted by hits and show as CSV:

{{#wsstats:stats
|format:csv
}}

This returns a string with the results comma seperated (e.g. 1230;51,1;17,921)


Get the top ten pages sorted by hits and insert in a WSArrays variable:

{{#wsstats:stats
|format:wsarrays}}
|name=<wsarray key name>
}}

This returns an empty string and sets the WSArray key. Nothing happens when the WSArrays extension is not installed.


Get the result from WSArrays:

{{#caprint:<wsarray key name>}}


New since version 1.0.7:

Get statistics of one page during a time period and limit to 100 results:

{{#wsstats:stats
|id=1
|start date=2023-02-01
|end date=2023-02-08
|limit 100
}}

This returns a table


For all queries you can add a unique identifier to only return unique views:

{{#wsstats:stats
|start date=2023-02-01
|end date=2023-02-08
|unique
}}

This returns a table

{{#wsstats:stats
|unique
}}

This returns a table


For all top ten stats queries you can add limit to get less or more than ten results:

{{#wsstats:stats
|unique
|limit=20
}}

This returns a table

lua functions

New in version 2.0

There are two Lua function you can use.

For the parser function that returns a table ({{#wsstats:stats..}}) you can use wsstats.stats().

For the parser function that returns a number ({{#wsstats:stat..}}) you can use wsstats.stat().

All the arguments are the same as for the parser functions, except:

  • start date = startDate
  • end date = endDate
Example

If you create a Module called WSStats and you add the following content:

local p = {}

function p.stats(frame)
  stats = mw.wsstats.stats( frame.args )
  return stats

end

function p.stat(frame)
  stat = mw.wsstats.stat( frame.args )
  return stat

end

return p

You can then do calls like :

{{#invoke:wsstats|stats}} // returns a Lua table
{{#invoke:wsstats|stat|id=1|startDate=2023-09-25|endDate=2023-09-26}}
Date format to use
Date formats
Date Translates to
2018-02-01 First of February 2018
2018-02-01 11 First of February 2018 at 11am
2018-02-01 11:15 First of February 2018 at a quarter past eleven in the morning
2018-02-01 14:15:30 First of February 2018 at a quarter past two in the afternoon and 30 seconds

The result will be 0 if there are no statistics available.

Version history

  • Version 2.0.0 : REL 1.39 only. Added statistics for Special Pages. Lua equivalent functions for statistics. Special Page added.
  • Version 1.0.8 : Removed global references // last release for MediaWiki Version 1.35.x
  • Version 1.0.7 : Added statistics over time for pages
  • Version 1.0.6 : Fixed path to sql tables
  • Version 1.0.5 : Rewrote database queries to use MW database abstraction layer. extension manifest 2 and all user input is validated.
  • Version 1.0.4 : Security fix! Unhandled user input. Update to 1.0.4 as soon as possible.
  • Version 1.0.3 : Top X list changed as it no longer shows deleted pages
  • Version 1.0.2 : Catched request for title on a non-existing page
  • Version 1.0.1 : Code clean-up and i18n messages added
  • Version 1.0.0 : Added support for setting limit and export as WSArrays
  • Version 0.8.2 : Added support for filtering only unique visitors
  • Version 0.8.1 : adminlinks added
  • Version 0.8.0 : Clean Up
  • Version 0.1.9 : Fetch Title changes
  • Version 0.1.8 : Removed dbprefix class variable
  • Version 0.1.7 : Show top visited pages with date range. Show as csv option
  • Version 0.1.6 : Filter results on user or anonymous
  • Version 0.1.5 : Added more configuration options
  • Version 0.1.3 : Fixed error in MySQL
  • Version 0.1.2 : Skip usergroup results
  • Version 0.1.1 : Initial release