CINXE.COM

<!DOCTYPE html> <html lang="en" dir="ltr" class="no-js"> <head> <meta charset="utf-8" /> <title>plugin:statistics [DokuWiki]</title> <meta name="generator" content="DokuWiki"/> <meta name="theme-color" content="#008800"/> <meta name="robots" content="index,follow"/> <meta name="keywords" content="plugin,statistics"/> <link rel="search" type="application/opensearchdescription+xml" href="/lib/exe/opensearch.php" title="DokuWiki"/> <link rel="start" href="/"/> <link rel="contents" href="/plugin:statistics?do=index" title="Sitemap"/> <link rel="manifest" href="/lib/exe/manifest.php"/> <link rel="alternate" type="application/rss+xml" title="Recent Changes" href="/feed.php"/> <link rel="alternate" type="application/rss+xml" title="Current namespace" href="/feed.php?mode=list&ns=plugin"/> <link rel="edit" title="Edit this page" href="/plugin:statistics?do=edit"/> <link rel="alternate" type="text/html" title="Plain HTML" href="/_export/xhtml/plugin:statistics"/> <link rel="alternate" type="text/plain" title="Wiki Markup" href="/_export/raw/plugin:statistics"/> <link rel="canonical" href="https://www.dokuwiki.org/plugin:statistics"/> <link rel="stylesheet" href="/lib/exe/css.php?t=dokuwiki&tseed=826e08a6afc6f3af33bf3037d5fc6458"/> <script >var NS='plugin';var JSINFO = {"plugins":{"edittable":{"default columnwidth":""}},"id":"plugin:statistics","namespace":"plugin","ACT":"show","useHeadingNavigation":0,"useHeadingContent":0};(function(H){H.className=H.className.replace(/\bno-js\b/,'js')})(document.documentElement);</script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.4/jquery.min.js" defer="defer"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.13.2/jquery-ui.min.js" defer="defer"></script> <script src="/lib/exe/js.php?t=dokuwiki&tseed=826e08a6afc6f3af33bf3037d5fc6458&lang=en" defer="defer"></script> <meta name="viewport" content="width=device-width,initial-scale=1" /> <link rel="shortcut icon" href="/lib/tpl/dokuwiki/images/favicon.ico" /> <link rel="apple-touch-icon" href="/lib/tpl/dokuwiki/images/apple-touch-icon.png" /> <meta name="verify-v1" content="OVxl3gsCv2MhZqh1cBQyl0JytWXSwXMjyvwc+4w3WtA=" /> <meta name="google-site-verification" content="YhTVK69hW94ZXUtc2zSLPxTkZKbZIn0zK67mz5WQB-E" />  <script async src="https://www.googletagmanager.com/gtag/js?id=UA-83791-1"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-83791-1', { 'anonymize_ip': true }); </script> </head> <body> <div id="dokuwiki__site"><div id="dokuwiki__top" class="site dokuwiki mode_show tpl_dokuwiki showSidebar hasSidebar">  <header id="dokuwiki__header"><div class="pad group"> <div class="headings group"> <ul class="a11y skip"> <li><a href="#dokuwiki__content">skip to content</a></li> </ul> <h1 class="logo"><a href="/start" accesskey="h" title="Home [h]"><img src="/lib/tpl/dokuwiki/images/logo.png" width="64" height="64" alt="" /><span>DokuWiki</span></a></h1> <p class="claim">It's better when it's simple</p> </div> <div class="tools group">  <div id="dokuwiki__usertools"> <h3 class="a11y">User Tools</h3> <ul> <li class="action login"><a href="/plugin:statistics?do=login&sectok=" title="Log In" rel="nofollow"><span>Log In</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M10 17.25V14H3v-4h7V6.75L15.25 12 10 17.25M8 2h9a2 2 0 0 1 2 2v16a2 2 0 0 1-2 2H8a2 2 0 0 1-2-2v-4h2v4h9V4H8v4H6V4a2 2 0 0 1 2-2z"/></svg></a></li> </ul> </div>  <div id="dokuwiki__sitetools"> <h3 class="a11y">Site Tools</h3> <form action="/start" method="get" role="search" class="search doku_form" id="dw__search" accept-charset="utf-8"><input type="hidden" name="do" value="search" /><input type="hidden" name="id" value="plugin:statistics" /><div class="no"><input name="q" type="text" class="edit" title="[F]" accesskey="f" placeholder="Search" autocomplete="on" id="qsearch__in" value="" /><button value="1" type="submit" title="Search">Search</button><div id="qsearch__out" class="ajax_qsearch JSpopup"></div></div></form> <div class="mobileTools"> <form action="/doku.php" method="get" accept-charset="utf-8"><div class="no"><input type="hidden" name="id" value="plugin:statistics" /><select name="do" class="edit quickselect" title="Tools"><option value="">Tools</option><optgroup label="Page Tools"><option value="edit">Edit this page</option><option value="revisions">Old revisions</option><option value="backlink">Backlinks</option></optgroup><optgroup label="Site Tools"><option value="recent">Recent Changes</option><option value="media">Media Manager</option><option value="index">Sitemap</option></optgroup><optgroup label="User Tools"><option value="login">Log In</option></optgroup></select><button type="submit">></button></div></form> </div> <ul> <li class="action recent"><a href="/plugin:statistics?do=recent" title="Recent Changes [r]" rel="nofollow" accesskey="r">Recent Changes</a></li><li class="action media"><a href="/plugin:statistics?do=media&ns=plugin" title="Media Manager" rel="nofollow">Media Manager</a></li><li class="action index"><a href="/plugin:statistics?do=index" title="Sitemap [x]" rel="nofollow" accesskey="x">Sitemap</a></li> </ul> </div> </div>  <div class="breadcrumbs"> <div class="trace"><span class="bchead">Trace:</span> <span class="bcsep">•</span> <span class="curid"><bdi><a href="/plugin:statistics" class="breadcrumbs" title="plugin:statistics">statistics</a></bdi></span></div> </div> <hr class="a11y" /> </div></header> <div class="wrapper group">  <nav id="dokuwiki__aside" aria-label="Sidebar"><div class="pad aside include group"> <h3 class="toggle">Sidebar</h3> <div class="content"><div class="group"> <p> <strong>Learn about DokuWiki</strong> </p> <ul> <li class="level1"><div class="li"> <a href="/features" class="wikilink1" title="features" data-wiki-id="features">Features</a> & <a href="/blogroll" class="wikilink1" title="blogroll" data-wiki-id="blogroll">reviews</a> </div> </li> <li class="level1"><div class="li"> <a href="/install" class="wikilink1" title="install" data-wiki-id="install">Installation guide</a></div> </li> <li class="level1"><div class="li"> <a href="/manual" class="wikilink1" title="manual" data-wiki-id="manual">User manual</a> & <a href="/wiki:syntax" class="wikilink1" title="wiki:syntax" data-wiki-id="wiki:syntax">syntax</a></div> </li> <li class="level1"><div class="li"> <a href="/changes" class="wikilink1" title="changes" data-wiki-id="changes">Release notes</a></div> </li> <li class="level1"><div class="li"> <a href="/faq" class="wikilink1" title="faq" data-wiki-id="faq">FAQ</a></div> </li> </ul> <p> <strong>Advanced Use</strong> </p> <ul> <li class="level1"><div class="li"> <a href="/extensions" class="wikilink1" title="extensions" data-wiki-id="extensions">Extensions</a></div> </li> <li class="level1"><div class="li"> <a href="/development" class="wikilink1" title="development" data-wiki-id="development">Development manual</a></div> </li> </ul> <p> <strong>Corporate Use</strong> </p> <ul> <li class="level1"><div class="li"> <a href="/faq:support" class="wikilink1" title="faq:support" data-wiki-id="faq:support">Get support</a></div> </li> <li class="level1"><div class="li"> <a href="/donate" class="wikilink1" title="donate" data-wiki-id="donate">Donations</a></div> </li> </ul> <p> <strong>Our Community</strong> </p> <ul> <li class="level1"><div class="li"> <a href="/teams:getting_involved" class="wikilink1" title="teams:getting_involved" data-wiki-id="teams:getting_involved">Get involved</a></div> </li> <li class="level1"><div class="li"> <a href="/dokuinstall" class="wikilink1" title="dokuinstall" data-wiki-id="dokuinstall">Users</a></div> </li> <li class="level1"><div class="li"> <a href="http://forum.dokuwiki.org" class="urlextern" title="http://forum.dokuwiki.org">User forum</a></div> </li> <li class="level1"><div class="li"> <a href="/mailinglist" class="wikilink1" title="mailinglist" data-wiki-id="mailinglist">Development mailinglist</a></div> </li> </ul> <hr /> <p> Follow us on <a href="https://phpc.social/@dokuwiki" class="urlextern" title="https://phpc.social/@dokuwiki">Mastodon</a> and other <a href="/social" class="wikilink1" title="social" data-wiki-id="social">social networks</a>. </p> <p> <a href="/privacy" class="wikilink1" title="privacy" data-wiki-id="privacy">Our Privacy Policy</a> </p> </div></div> </div></nav>  <main id="dokuwiki__content"><div class="pad group"> <div class="pageId"><span>plugin:statistics</span></div> <div class="page group">   <div id="dw__toc" class="dw__toc"> <h3 class="toggle">Table of Contents</h3> <div> <ul class="toc"> <li class="level1"><div class="li"><a href="#statistics_plugin">Statistics Plugin</a></div> <ul class="toc"> <li class="level2"><div class="li"><a href="#download">Download</a></div> <ul class="toc"> <li class="level3"><div class="li"><a href="#changes">Changes</a></div></li> </ul> </li> <li class="level2"><div class="li"><a href="#installing">Installing</a></div> <ul class="toc"> <li class="level3"><div class="li"><a href="#requirements">Requirements</a></div></li> <li class="level3"><div class="li"><a href="#installation">Installation</a></div></li> <li class="level3"><div class="li"><a href="#db_creation">DB creation</a></div></li> </ul> </li> <li class="level2"><div class="li"><a href="#upgrading">Upgrading</a></div></li> <li class="level2"><div class="li"><a href="#known_limitations">Known limitations</a></div></li> </ul></li> </ul> </div> </div>  <h1 class="sectionedit1" id="statistics_plugin">Statistics Plugin</h1> <div class="level1"> <div class="pluginrepo_entry"><div class="usageInfo"><div class="compatibility"><p class="label">Compatible with DokuWiki</p><p>Hrun, Ponder Stibbons, Binky, Weatherwax, Elenor of Tsort, Detritus</p></div><ul class="actions"><li><a class="download" href="https://github.com/splitbrain/dokuwiki-plugin-statistics/zipball/master">Download</a></li><li><a class="bugs" href="https://github.com/splitbrain/dokuwiki-plugin-statistics/issues">Report bugs</a></li><li><a class="donate" href="http://donate.dokuwiki.org/statistics">Donate</a></li></ul><div class="clearer"></div></div><div class="mainInfo"><p class="description"><a class="media" href="/plugins"><img alt="plugin" class="medialeft" src="/lib/plugins/pluginrepo/images/dwplugin.png" width="60" height="60" /></a> Log and analyze access statistics</p></div><div class="metaInfo"><dl><dt>Last updated on</dt><dd>2024-01-30</dd><dt>Provides</dt><dd><a href="/plugins?plugintype=2#extension__table" class="wikilink1" title="List all Admin plugins">Admin</a>, <a href="/plugins?plugintype=4#extension__table" class="wikilink1" title="List all Action plugins">Action</a></dd><dt>Repository</dt><dd><a class="urlextern" href="https://github.com/splitbrain/dokuwiki-plugin-statistics">Source</a></dd></dl></div><div class="moreInfo"><p class="similar">Similar to <a href="/plugin:logstats" class="wikilink1" title="plugin:logstats" data-wiki-id="plugin:logstats">logstats</a>, <a href="/plugin:quickstats" class="wikilink1" title="plugin:quickstats" data-wiki-id="plugin:quickstats">quickstats</a>, <a href="/plugin:statdisplay" class="wikilink1" title="plugin:statdisplay" data-wiki-id="plugin:statdisplay">statdisplay</a></p><p class="tags">Tagged with <a href="/plugins?plugintag=logging#extension__table" class="wikilink1" title="List all plugins with this tag">logging</a>, <a href="/plugins?plugintag=mysql#extension__table" class="wikilink1" title="List all plugins with this tag">mysql</a>, <a href="/plugins?plugintag=statistics#extension__table" class="wikilink1" title="List all plugins with this tag">statistics</a></p></div><div class="authorInfo"><strong>By <a href="mailto:andi%20%5Bat%5D%20splitbrain%20%5Bdot%5D%20org" class="mail" title="andi [at] splitbrain [dot] org">Andreas Gohr</a></strong><ul><li><a href="/plugin:badbehaviour" class="wikilink1" title="plugin:badbehaviour" data-wiki-id="plugin:badbehaviour">badbehaviour</a></li> <li><a href="/plugin:amazon" class="wikilink1" title="plugin:amazon" data-wiki-id="plugin:amazon">amazon</a></li> <li><a href="/plugin:xfortune" class="wikilink1" title="plugin:xfortune" data-wiki-id="plugin:xfortune">xfortune</a></li> <li><a href="/plugin:translation" class="wikilink1" title="plugin:translation" data-wiki-id="plugin:translation">translation</a></li> <li><a href="/plugin:captcha" class="wikilink1" title="plugin:captcha" data-wiki-id="plugin:captcha">captcha</a></li> <li><a href="/plugin:graphviz" class="wikilink1" title="plugin:graphviz" data-wiki-id="plugin:graphviz">graphviz</a></li> <li><a href="/plugin:acl" class="wikilink1" title="plugin:acl" data-wiki-id="plugin:acl">acl</a></li> <li><a href="/plugin:info" class="wikilink1" title="plugin:info" data-wiki-id="plugin:info">info</a></li> <li><a href="/plugin:ditaa" class="wikilink1" title="plugin:ditaa" data-wiki-id="plugin:ditaa">ditaa</a></li> <li><a href="/plugin:readability" class="wikilink1" title="plugin:readability" data-wiki-id="plugin:readability">readability</a></li> <li>and 60 more</li></ul></div></div> <p> This plugin provides logging and statistics on views and visitors of your wiki. The statistics are a mix of wiki centric stats (like number of edits) and typical web statistics (views, visitors). It should be most useful to people using <a href="/dokuwiki" class="wikilink1" title="dokuwiki" data-wiki-id="dokuwiki">DokuWiki</a> as their blog or homepage but provides useful stats for internal use as well. </p> <p> <img src="/lib/images/smileys/exclaim.svg" class="icon smiley" alt=":!:" /> This plugin needs a MySQL database. You need at least MySQL 4.1, MySQL 5.0 or higher is recommended. </p> <p> The following statistics are currently provided: </p> <ul> <li class="level1 node"><div class="li"> Dashboard</div> <ul> <li class="level2"><div class="li"> general statistics like Bounces, Returning Vistors, Average Session lengths</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Popular Pages</div> <ul> <li class="level2"><div class="li"> the most viewed pages</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Incoming Links</div> <ul> <li class="level2"><div class="li"> the top referrers</div> </li> </ul> </li> <li class="level1 node"><div class="li"> New Incoming Links</div> <ul> <li class="level2"><div class="li"> the top referrers which were not seen before the selected time frame</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Outgoing Links</div> <ul> <li class="level2"><div class="li"> the most clicked outgoing links</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Search Engines</div> <ul> <li class="level2"><div class="li"> the most used search engines to find your wiki</div> </li> </ul> </li> <li class="level1 node"><div class="li"> External Search Phrases</div> <ul> <li class="level2"><div class="li"> the top search phrases people used in search engines to find your wiki</div> </li> </ul> </li> <li class="level1 node"><div class="li"> External Search Words</div> <ul> <li class="level2"><div class="li"> the top search keywords people used in search engines to find your wiki</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Internal Search Phrases</div> <ul> <li class="level2"><div class="li"> the top search phrases people used in your integrated wiki search</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Internal Search Words</div> <ul> <li class="level2"><div class="li"> the top search keywords people used in your integrated wiki search</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Browsers</div> <ul> <li class="level2"><div class="li"> the most used browsers to view your wiki</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Operating Systems</div> <ul> <li class="level2"><div class="li"> the most used operating systems used by your visitors</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Countries</div> <ul> <li class="level2"><div class="li"> where your visitors came from in the selected time frame</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Screensize</div> <ul> <li class="level2"><div class="li"> the screen size your visitors have</div> </li> </ul> </li> <li class="level1 node"><div class="li"> Resolution</div> <ul> <li class="level2"><div class="li"> the screen resolution used by your visitors</div> </li> </ul> </li> </ul> <p> For nearly all these stats, graphical diagrams are provided as well. </p> </div> <div class="secedit editbutton_section editbutton_1"><form class="button btn_secedit" method="post" action="/plugin:statistics"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1707513615" /><input type="hidden" name="summary" value="[Statistics Plugin] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="statistics_plugin" /><input type="hidden" name="codeblockOffset" value="0" /><input type="hidden" name="range" value="1-2387" /><button type="submit" title="Statistics Plugin">Edit</button></div></form></div> <h2 class="sectionedit2" id="download">Download</h2> <div class="level2"> <p> Please use the download link provided above for downloading the plugin. Be sure to read about <a href="#upgrading" title="plugin:statistics ↵" class="wikilink1">upgrading</a> first, if you are running an older version already. </p> </div> <div class="secedit editbutton_section editbutton_2"><form class="button btn_secedit" method="post" action="/plugin:statistics"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1707513615" /><input type="hidden" name="summary" value="[Download] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="download" /><input type="hidden" name="codeblockOffset" value="0" /><input type="hidden" name="range" value="2388-2571" /><button type="submit" title="Download">Edit</button></div></form></div> <h3 class="sectionedit3" id="changes">Changes</h3> <div class="level3"> <ul class="rss"><li><div class="li"><a href="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/e5d292fc84583623baa1478e10f4a89093093c30" class="urlextern" title="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/e5d292fc84583623baa1478e10f4a89093093c30">Merge pull request #75 from dokuwiki-translate/lang_update_846_171303…</a> (2024-07-29 08:19)</div></li><li><div class="li"><a href="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/690900c63bc3da308f27ade782f6c521aecf82ed" class="urlextern" title="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/690900c63bc3da308f27ade782f6c521aecf82ed">translation update</a> (2024-04-13 19:50)</div></li><li><div class="li"><a href="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/67ade7fd8cf24aab92ce84c367931a58370e3d02" class="urlextern" title="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/67ade7fd8cf24aab92ce84c367931a58370e3d02">Version upped</a> (2024-01-30 23:50)</div></li><li><div class="li"><a href="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/6fc633854ea5d414e504ecd6c7fcf1f4e04ce270" class="urlextern" title="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/6fc633854ea5d414e504ecd6c7fcf1f4e04ce270">check for permissions in img.php. fixes #72</a> (2024-01-30 15:49)</div></li><li><div class="li"><a href="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/66545d6b1226ca92f79a45f2bb2aa9de95ac5405" class="urlextern" title="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/66545d6b1226ca92f79a45f2bb2aa9de95ac5405">Version upped</a> (2023-12-12 23:50)</div></li><li><div class="li"><a href="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/278606db8d51bc29657a13c28fca01e42ae81b95" class="urlextern" title="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/278606db8d51bc29657a13c28fca01e42ae81b95">Merge pull request #70 from execonic/master</a> (2023-12-12 14:14)</div></li><li><div class="li"><a href="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/5d8b6a58cdbf6405bcd0f2df7c4ebf39c8b7956f" class="urlextern" title="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/5d8b6a58cdbf6405bcd0f2df7c4ebf39c8b7956f">Add Windows 10 icon</a> (2023-12-08 15:31)</div></li><li><div class="li"><a href="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/48d50cf00ce6e2ae8a9d767b23ed274512042ee8" class="urlextern" title="https://github.com/splitbrain/dokuwiki-plugin-statistics/commit/48d50cf00ce6e2ae8a9d767b23ed274512042ee8">Fix IPv6 statistics bug</a> (2023-12-07 17:16)</div></li></ul> </div> <div class="secedit editbutton_section editbutton_3"><form class="button btn_secedit" method="post" action="/plugin:statistics"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1707513615" /><input type="hidden" name="summary" value="[Changes] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="changes" /><input type="hidden" name="codeblockOffset" value="0" /><input type="hidden" name="range" value="2572-2681" /><button type="submit" title="Changes">Edit</button></div></form></div> <h2 class="sectionedit4" id="installing">Installing</h2> <div class="level2"> </div> <div class="secedit editbutton_section editbutton_4"><form class="button btn_secedit" method="post" action="/plugin:statistics"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1707513615" /><input type="hidden" name="summary" value="[Installing] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="installing" /><input type="hidden" name="codeblockOffset" value="0" /><input type="hidden" name="range" value="2682-2705" /><button type="submit" title="Installing">Edit</button></div></form></div> <h3 class="sectionedit5" id="requirements">Requirements</h3> <div class="level3"> <ul> <li class="level1"><div class="li"> A MySQL datatabase</div> </li> <li class="level1"><div class="li"> mysqli extension for PHP</div> </li> <li class="level1"><div class="li"> libgd extension for PHP</div> </li> </ul> </div> <div class="secedit editbutton_section editbutton_5"><form class="button btn_secedit" method="post" action="/plugin:statistics"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1707513615" /><input type="hidden" name="summary" value="[Requirements] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="requirements" /><input type="hidden" name="codeblockOffset" value="0" /><input type="hidden" name="range" value="2706-2810" /><button type="submit" title="Requirements">Edit</button></div></form></div> <h3 class="sectionedit6" id="installation">Installation</h3> <div class="level3"> <ol> <li class="level1"><div class="li"> Install the plugin through the <a href="/plugin:extension" class="wikilink1" title="plugin:extension" data-wiki-id="plugin:extension">Extension</a> Manager or manually.</div> </li> <li class="level1"><div class="li"> Create the MySQL database (see below). Without this you wont be <strong>able</strong> to do the next step.</div> </li> <li class="level1"><div class="li"> Create the needed MySQL tables with the provided <code>db.sql</code> file </div> </li> <li class="level1"><div class="li"> Configure the database access through the <a href="/plugin:config" class="wikilink1" title="plugin:config" data-wiki-id="plugin:config">Config Manager</a></div> </li> </ol> </div> <div class="secedit editbutton_section editbutton_6"><form class="button btn_secedit" method="post" action="/plugin:statistics"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1707513615" /><input type="hidden" name="summary" value="[Installation] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="installation" /><input type="hidden" name="codeblockOffset" value="0" /><input type="hidden" name="range" value="2811-3160" /><button type="submit" title="Installation">Edit</button></div></form></div> <h3 class="sectionedit7" id="db_creation">DB creation</h3> <div class="level3"> <p> On the shell run the following commands: </p> <pre class="code"># mysql -u root -p MariaDB [(none)]> CREATE DATABASE stats; MariaDB [(none)]> \q</pre> <p> To create the needed MySQL tables you can </p> <ol> <li class="level1 node"><div class="li"> either use phpmyadmin's import function </div> <ul> <li class="level2"><div class="li"> Select the database that is used by your DokuWiki and chose “Import” from the top-menu, then upload the file.</div> </li> </ul> </li> <li class="level1"><div class="li"> import manually using MySQL in your shell <pre class="code"># mysql -u db_user -p your_dokuwiki_database < /full/path/to/db.sql</pre> </div> </li> </ol> </div> <div class="secedit editbutton_section editbutton_7"><form class="button btn_secedit" method="post" action="/plugin:statistics"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1707513615" /><input type="hidden" name="summary" value="[DB creation] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="db_creation" /><input type="hidden" name="codeblockOffset" value="0" /><input type="hidden" name="range" value="3161-3657" /><button type="submit" title="DB creation">Edit</button></div></form></div> <h2 class="sectionedit8" id="upgrading">Upgrading</h2> <div class="level2"> <p> Upgrades will most probably require database upgrades. I recommend to do them <em>before</em> updating the plugin. </p> <ol> <li class="level1"><div class="li"> Have a look at the current <a href="https://github.com/splitbrain/dokuwiki-plugin-statistics/blob/master/db.sql" class="urlextern" title="https://github.com/splitbrain/dokuwiki-plugin-statistics/blob/master/db.sql">db.sql</a>.</div> </li> <li class="level1"><div class="li"> Search this file for lines starting with <code>-- UPGRADE</code></div> </li> <li class="level1"><div class="li"> Find the first such line containing a date newer than your plugin version</div> </li> <li class="level1"><div class="li"> Copy all following lines and apply them to your existing database</div> </li> </ol> <p> Please note that, depending on the amount of data in your database, these updates can take a really long time. I suggest to run these updates via the command line instead of using a web based tool like PHPMyAdmin. </p> </div> <div class="secedit editbutton_section editbutton_8"><form class="button btn_secedit" method="post" action="/plugin:statistics"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1707513615" /><input type="hidden" name="summary" value="[Upgrading] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="upgrading" /><input type="hidden" name="codeblockOffset" value="2" /><input type="hidden" name="range" value="3658-4338" /><button type="submit" title="Upgrading">Edit</button></div></form></div> <h2 class="sectionedit9" id="known_limitations">Known limitations</h2> <div class="level2"> <ul> <li class="level1 node"><div class="li"> Currently only users with JavaScript enabled are logged</div> <ul> <li class="level2"><div class="li"> this can be easily fixed by placing some <noscript> code in the template, I just need to investigate that</div> </li> <li class="level2"><div class="li"> when fixed, stats about search bots could be added</div> </li> </ul> </li> <li class="level1"><div class="li"> the search word parsing is a bit flaky (“don't” is two words)</div> </li> </ul> </div> <div class="secedit editbutton_section editbutton_9"><form class="button btn_secedit" method="post" action="/plugin:statistics"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1707513615" /><input type="hidden" name="summary" value="[Known limitations] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="known_limitations" /><input type="hidden" name="codeblockOffset" value="2" /><input type="hidden" name="range" value="4339-" /><button type="submit" title="Known limitations">Edit</button></div></form></div>  </div> <div class="docInfo"><bdi>plugin/statistics.txt</bdi> · Last modified: 2024-02-09 22:20 by <bdi>Aleksandr</bdi></div> <hr class="a11y" /> </div></main>  <nav id="dokuwiki__pagetools" aria-labelledby="dokuwiki__pagetools__heading"> <h3 class="a11y" id="dokuwiki__pagetools__heading">Page Tools</h3> <div class="tools"> <ul> <li class="edit"><a href="/plugin:statistics?do=edit" title="Edit this page [e]" rel="nofollow" accesskey="e"><span>Edit this page</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M20.71 7.04c.39-.39.39-1.04 0-1.41l-2.34-2.34c-.37-.39-1.02-.39-1.41 0l-1.84 1.83 3.75 3.75M3 17.25V21h3.75L17.81 9.93l-3.75-3.75L3 17.25z"/></svg></a></li><li class="revs"><a href="/plugin:statistics?do=revisions" title="Old revisions [o]" rel="nofollow" accesskey="o"><span>Old revisions</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M11 7v5.11l4.71 2.79.79-1.28-4-2.37V7m0-5C8.97 2 5.91 3.92 4.27 6.77L2 4.5V11h6.5L5.75 8.25C6.96 5.73 9.5 4 12.5 4a7.5 7.5 0 0 1 7.5 7.5 7.5 7.5 0 0 1-7.5 7.5c-3.27 0-6.03-2.09-7.06-5h-2.1c1.1 4.03 4.77 7 9.16 7 5.24 0 9.5-4.25 9.5-9.5A9.5 9.5 0 0 0 12.5 2z"/></svg></a></li><li class="backlink"><a href="/plugin:statistics?do=backlink" title="Backlinks" rel="nofollow"><span>Backlinks</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M10.59 13.41c.41.39.41 1.03 0 1.42-.39.39-1.03.39-1.42 0a5.003 5.003 0 0 1 0-7.07l3.54-3.54a5.003 5.003 0 0 1 7.07 0 5.003 5.003 0 0 1 0 7.07l-1.49 1.49c.01-.82-.12-1.64-.4-2.42l.47-.48a2.982 2.982 0 0 0 0-4.24 2.982 2.982 0 0 0-4.24 0l-3.53 3.53a2.982 2.982 0 0 0 0 4.24m2.82-4.24c.39-.39 1.03-.39 1.42 0a5.003 5.003 0 0 1 0 7.07l-3.54 3.54a5.003 5.003 0 0 1-7.07 0 5.003 5.003 0 0 1 0-7.07l1.49-1.49c-.01.82.12 1.64.4 2.43l-.47.47a2.982 2.982 0 0 0 0 4.24 2.982 2.982 0 0 0 4.24 0l3.53-3.53a2.982 2.982 0 0 0 0-4.24.973.973 0 0 1 0-1.42z"/></svg></a></li><li class="top"><a href="#dokuwiki__top" title="Back to top [t]" rel="nofollow" accesskey="t"><span>Back to top</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M13 20h-2V8l-5.5 5.5-1.42-1.42L12 4.16l7.92 7.92-1.42 1.42L13 8v12z"/></svg></a></li> </ul> </div> </nav> </div>  <footer id="dokuwiki__footer"><div class="pad"> <div class="license">Except where otherwise noted, content on this wiki is licensed under the following license: <bdi><a href="https://creativecommons.org/licenses/by-sa/4.0/deed.en" rel="license" class="urlextern">CC Attribution-Share Alike 4.0 International</a></bdi></div> <div class="buttons"> <a href="https://creativecommons.org/licenses/by-sa/4.0/deed.en" rel="license"><img src="/lib/images/license/button/cc-by-sa.png" alt="CC Attribution-Share Alike 4.0 International" /></a> <a href="https://www.dokuwiki.org/donate" title="Donate" ><img src="/lib/tpl/dokuwiki/images/button-donate.gif" width="80" height="15" alt="Donate" /></a> <a href="https://php.net" title="Powered by PHP" ><img src="/lib/tpl/dokuwiki/images/button-php.gif" width="80" height="15" alt="Powered by PHP" /></a> <a href="//validator.w3.org/check/referer" title="Valid HTML5" ><img src="/lib/tpl/dokuwiki/images/button-html5.png" width="80" height="15" alt="Valid HTML5" /></a> <a href="//jigsaw.w3.org/css-validator/check/referer?profile=css3" title="Valid CSS" ><img src="/lib/tpl/dokuwiki/images/button-css.png" width="80" height="15" alt="Valid CSS" /></a> <a href="https://dokuwiki.org/" title="Driven by DokuWiki" ><img src="/lib/tpl/dokuwiki/images/button-dw.png" width="80" height="15" alt="Driven by DokuWiki" /></a> </div> <div style="margin-top: 2em; font-size:90%" class="dokuwiki"><div style="float:right"><a href="http://www.splitbrain.org/personal#imprint" style="float:right; text-decoration: none; color:#333">Imprint</a></div></div> <style type="text/css"> @media screen { body { padding-top: 30px; } #global__header { position: absolute; top: 0; left: 0; text-align: left; vertical-align: middle; line-height: 1.5; background-color: #333; box-shadow: 0 0 8px rgba(0,0,0,0.5); width: 100%; margin: 0; padding: 5px 20px; -moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box; white-space: nowrap; overflow: hidden; } #global__header h2 { position: absolute; left: -99999em; top: 0; overflow: hidden; display: inline; } #global__header ul, #global__header li { margin: 0; padding: 0; list-style: none; display: inline; line-height: 1.5; } #global__header a { color: #bbb; text-decoration: none; margin-right: 20px; font-size: 14px; font-weight: normal; } #global__header a:hover, #global__header a:active, #global__header a:focus { color: #fff; text-decoration: underline; } #global__header form { float: right; margin: 0 0 0 20px; } #global__header input { background-color: #333; background-image: none; border: 1px solid #bbb; color: #fff; box-shadow: none; border-radius: 2px; margin: 0; line-height: normal; padding: 1px 0 1px 0; height: auto; } #global__header input.button { border: none; color: #bbb; } #global__header input.button:hover, #global__header input.button:active, #global__header input.button:focus { color: #fff; text-decoration: underline; } } /* /@media */ @media only screen and (min-width: 601px) { /* changes specific for www.dokuwiki.org */ #dokuwiki__header { padding-top: 3em; } #dokuwiki__usertools { top: 3em; } /* changes specific for bugs.dokuwiki.org */ div#container div#showtask { top: 40px; } } /* /@media */ @media only screen and (max-width: 600px) { body { padding-top: 0; } #global__header { position: static; white-space: normal; overflow: auto; } #global__header form { float: none; display: block; margin: 0 0 .4em; } } /* /@media */ @media print { #global__header { display: none; } } /* /@media */ </style> <div id="global__header"> <h2>Global DokuWiki Links</h2> <form method="get" action="https://search.dokuwiki.org/" target="_top"> <input type="text" name="q" title="Search all DokuWiki sites at once" class="input" /> <input type="submit" title="Search all DokuWiki sites at once" value="Search" class="button" /> </form> <ul> <li><a href="https://download.dokuwiki.org" title="Download the latest release" target="_top">Download</a></li> <li><a href="https://www.dokuwiki.org" title="Read the DokuWiki documentation" target="_top">Wiki</a></li> <li><a href="https://forum.dokuwiki.org" title="Ask questions in the DokuWiki forum" target="_top">Forum</a></li> <li><a href="https://irc.dokuwiki.org" title="Check IRC chat logs or join the chat" target="_top">IRC</a></li> <li><a href="https://github.com/splitbrain/dokuwiki/issues" title="Report and track bugs" target="_top">Bugs</a></li> <li><a href="https://translate.dokuwiki.org/" title="Help translating the DokuWiki interface" target="_top">Translate</a></li> <li><a href="https://github.com/splitbrain/dokuwiki" title="Access the most recent git commits" target="_top">Git</a></li> <li><a href="https://xref.dokuwiki.org/reference/dokuwiki/" title="Cross-Reference of the DokuWiki source code" target="_top">XRef</a></li> <li><a href="https://codesearch.dokuwiki.org/" title="Search through the sources of DokuWiki, plugins and templates" target="_top">Code Search</a></li> </ul> </div>  </div></footer> </div></div> <div class="no"><img src="/lib/exe/taskrunner.php?id=plugin%3Astatistics&1732438085" width="2" height="1" alt="" /></div> <div id="screen__mode" class="no"></div></body> </html>