Statistics Plugin

This plugin provides logging and statistics on views and visitors of your wiki. The statistics are not very wiki centric but are more close to what you'd expect from a typical web statistics package. It should be most useful to people using DokuWiki as their blog or homepage.

This plugin needs a MySQL database. You need at least MySQL 4.1, MySQL 5.0 or higher is recommended.

The following statistics are currently provided:

• Popular Pages
  • the most viewed pages in the selected time frame
• Incoming Links
  • the top referrers in the selected time frame
• New Incoming Links
  • the top referrers which were not seen before the selected time frame
• Outgoing Links
  • the most clicked outgoing links in the selected time frame
• Search Phrases
  • the top search phrases people used in search engines to find your wiki in the selected time frame
• Search Words
  • the top search keywords people used in search engines to find your wiki in the selected time frame
• Search Engines
  • the most used search engines to find your wiki in the selected time frame
• Browsers
  • the most used browsers to view your wiki in the selected time frame
• Operating Systems
  • the most used operating systems used by your visitors in the selected time frame
• Countries
  • where your visitors came from in the selected time frame
• Resolution
  • the screen resolution used by your visitors in the selected time frame

For many of these stats, graphical diagrams are provided as well.

• statistics-plugin-latest.tgz

Alternatively you can check out the plugin from my darcs repository with

darcs get http://dev.splitbrain.org/darcs/dwplugins/statistics

• 15 Jun 16:58 - fixed comment lines in db.sql
• 15 Jun 16:52 - Massive performance improvements
• 10 Feb 09:59 - don't count social bookmark sites as search [sql fix for old stats included]
• 07 Feb 18:29 - link search terms to engines
• 06 Feb 21:38 - set time frame through it's own function
• 04 Feb 12:45 - Search statistics
• 04 Feb 11:29 - js fix
• 04 Feb 11:24 - fixed some search related errors

1. Install the plugin through the Plugin Manager or manually.
2. Create the MySQL database. Without this you wont be able to do the next step.
3. Create the needed MySQL tables with the provided db.sql file
4. Configure the database access through the Config Manager

To create the needed MySQL tables you can

• either use phpmyadmin's import function
  • Select the database that is used by your DokuWiki and chose “Import” from the top-menu, then upload the file.
• import manually using MySQL in your shell

Method 1

# mysql -u db_user -p your_dokuwiki_database < /full/path/to/db.sql

Method 2

# mysql -u db_user -p your_dokuwiki_database
Enter password:
[...]
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \. /full/path/to/db.sql

Upgrades may require database upgrades. Check the provided db.sql file. Updates statements are marked with their dates. Execute them on your database to upgrade it.

• Country resolution is provided by hostip.info
• OS, Browser and Search Engine lookup tables come from awstats
• Graphs are created by Zack Bloom's Advanced Graphing Class (modified for PHP4)

• Currently only users with JavaScript enabled are logged
  • this can be easily fixed by placing some <noscript> code in the template, I just need to investigate that
  • when fixed, stats about search bots could be added
• some more wiki specific data would be nice (edits, minor edits, internal searchs)
• the search word parsing is a bit flaky (“don't” is two words)

Nice plugin… is there anyway to put the statistics on the a non admin page so users can view them?
Thanks!
Austen

Hi, I really like this! It works even when you have the rest of your wiki not in the DB. But I would also want to show my users the statistics, without giving them Admin access. How could I do this?
Thanks for the work,
Julian

Nice work!
It would be better if multiple visits of a page by the same user in a short period of time (like reload) would count as one hit…
Hansel

Can you, please, help me find out how to do step 3 in the instruction. How do I configure the database access through the Config Manager?
Elena

Can the search phrase engine be updated to support Microsoft's Bing please?

Any chance of getting this to support sqllite?
=G=