Hi all,
I'm looking for an extension or another (easy) way to have more detailed statistic.
I'd like to subdived the numbers on special:statistics to reflect activities according to months, years and perhaps even have the possibility to choose a time-span.
I've found the firestats-plugin, but that doesn't help me to get the overview of the wiki-usage-development I'm looking for.
Greetings Katharina
Katharina Wolkwitz wrote:
Hi all,
I'm looking for an extension or another (easy) way to have more detailed statistic.
I'd like to subdived the numbers on special:statistics to reflect activities according to months, years and perhaps even have the possibility to choose a time-span.
I've found the firestats-plugin, but that doesn't help me to get the overview of the wiki-usage-development I'm looking for.
Greetings Katharina
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
As far as I'm aware, such an extension doesn't exist :)
Snowolf
On 21/09/2007, Snowolf snowolf@snowolf.eu wrote:
As far as I'm aware, such an extension doesn't exist :)
No, but assuming she meant things like "edits per month", for example, then I would imagine it would be doable - you would probably hook various operations and update a custom statistics table, and you'd likely want to run a script to retroactively populate that.
Rob Church
Rob Church schrieb:
On 21/09/2007, Snowolf snowolf@snowolf.eu wrote:
As far as I'm aware, such an extension doesn't exist :)
No, but assuming she meant things like "edits per month", for example, then I would imagine it would be doable - you would probably hook various operations and update a custom statistics table, and you'd likely want to run a script to retroactively populate that.
Yes - that's what I meant. I'd like to track how (much) the wiki is used and how that usage changes throughout it's existence.
Could someone please adopt my wish and write an extension for me??? ;-) I'm not experienced enough in php-programming to write such an extension myself
Greetings Kate
Katharina Wolkwitz <wolkwitz@...> writes:
Yes - that's what I meant. I'd like to track how (much) the wiki is used and
how
that usage changes throughout it's existence.
Could someone please adopt my wish and write an extension for me??? I'm not experienced enough in php-programming to write such an extension
myself
Greetings Kate
I actually wrote exactly that extension a while ago, but forgot to uploaded into MediaWiki. After seeing this thread, I finally did so. You can find more information about the extension at http://www.mediawiki.org/wiki/Extension:Usage_Statistics
Paul.
Paul Grinberg schrieb:
I actually wrote exactly that extension a while ago, but forgot to uploaded into MediaWiki. After seeing this thread, I finally did so. You can find more information about the extension at http://www.mediawiki.org/wiki/Extension:Usage_Statistics
Great!!! I'll look into it. :-) :-) :-)
Kate
Nice extension. Note that is has a bug: you have hard-coded the database table prefix "wiki_" instead of using the global variable $wgDBprefix. So instead of
SELECT rev_user_text FROM wiki_page...
You should have:
SELECT rev_user_text FROM {$wgDBprefix}page...
Etc.
Anybody know if there's a SQL-to-gnuplot widget to directly plot the data returned by SQL queries?
DanB
On 21/09/2007, Daniel Barrett danb@vistaprint.com wrote:
SELECT rev_user_text FROM {$wgDBprefix}page...
Actually, you should use the Database::tableName() method to obtain the fully-prefixed name for a table; this also respects shared table settings, e.g. for users.
In general, though, use the Database::select() and other query-builder/wrapper functions to perform queries, if at all possible - it does a lot of the work of escaping various bits and dealing with constructing IN ( ..., ... ) clauses, and all manner of options and other fun.
Rob Church
mediawiki-l@lists.wikimedia.org