Extension:WSStats

MediaWiki extensions manual

WSStats Release status: stable
Implementation	Parser extension
Description	Collect page statistics
Author(s)	Charlot Cobben (Sen-Saitalk)
Latest version	1.0.8 (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.35.+;1.39+
Database changes	Yes
Composer	wikibase-solutions/w-s-stats
Parameters $wgWSSStats
Tags wikibasesolutions, page statistics
Hooks used ParserFirstCallInit BeforePageDisplay LoadExtensionSchemaUpdates AdminLinks AdminLinks
Licence	GNU General Public License 2.0 or later
Download	GitHub: project page git repository URL commit history Note: No localisation updates are provided by translatewiki.net . [README]

Version 1.0.8 will be the last release for MediaWiki Version 1.35.x

Version 2.0.0 is for MediaWiki version 1.39.x.

Make sure you update to at least version 1.0.6 due to a security risk

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

• 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
• 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

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.
• Done – Navigate to Special:Version on your wiki to verify that the extension is successfully installed.

Upgrading

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 parameters

By default Anonymous users and sysops are skipped from stats recording. To change this add following to LocalSettings.php..

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';

Using the parser functions

To retrieve statistics you can use the following parser function :

Ask number of hits for page id : 9868

This returns a number

{{#wsstats:id=9868}}

You can also ask for statistics based on title, instead of Page Id's.

Ask number of hits for page with title : Main Page

This returns a number

{{#wsstats:title=Main Page}}

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 example about this.

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

This returns a number

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

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

This returns a number

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

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

This returns a number

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

Filter results on registered users or anonymous users

This returns a number

{{#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}}

Get the top ten pages sorted by hits

This returns a table

{{#wsstats:stats}}

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

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 )

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

Get the top ten pages sorted by hits and show as csv

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

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

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

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

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

Get the result from WSArrays:
{{#caprint:<wsarray key name>}} 

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

New since version 1.0.7

This returns a table

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

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

This returns a table

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

This returns a table

{{#wsstats:stats
|unique}}

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

This returns a table

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

Using the 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:... ) 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 :

lua
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

If no statistics the result will be 0