From S23Wiki
Revision as of 13:12, 1 December 2011 by DrOwl (Talk | contribs) (Reverted edits by LimatongYahoya (talk) to last revision by Kghbln)

Jump to: navigation, search

Tasks for Wikistats


Unfortunately it has not been updated since 2007 and broke with recent MediaWiki versions. :( We'll see how much work a fix would be these days.

[1] MW 1.16.5 is not depreciated as MW 1.17.0, MW 1.18beta1 and MW 1.18rc1 (red) / MW 1.17.1 is legacy and MW 1.18.0 is stable (green) (mutante)
[1] Add Table for [ Pardus] (mutante)
[1] Add Table for [ LXDE] (mutante)
[1] Add Table for [] (mutante)
[1] Add 40 Shoutwikis from this [ trunk] (mutante)
[1] Add 200 000 Wikias from this [ trunk] (mutante)
[2] versioncheck.php wikipedias, and probably others, broken, tries to fetch wrong URLs Special:Versionapi.php?action=query&meta=siteinfo&format=xml (mutante)
[1] Create tasks out of [[Talk:Wikistats/MediaWiki-Versionen]] and [[Wikistats/MediaWiki-Versionen]] (Robih)
[3] Create Methods 12 API+W3M and 13 API+CURL and test them with [[mw:602]], [[mw:669]] (mutante)
[ ] Fix MySQL warnings for setting int="" and after that enable sql_mode TRADITIONAL again (mutante)
[ ] Add "Views" Columns to Largest, reset all "Views" values and freshly retrieve them. After two days, we can see, which of the figures actually have moved (mutante)
[ ] change all code that relates to statsurl and method8, save statsurl ending in "api.php" without any parameters, add parameters inside method8 function in one place (Mutante)
[ ] Multilingual seperated in table , see below | in which table and format? are they asking for it on meta?
[ ] [[#Add/update a list of sites using a particular MediaWiki extension]] | assigned user is not available (qoreqyas)
[23:59:30] <danny.b> i thought it would be like:
*** 2010-03-16
[00:00:55] <danny.b@> №  ↓ 	Language  ↓ 	Language (local)  ↓ 	Wiki  ↓ 	Good  ↓ 	Total  ↓ 	Edits  ↓ 	Admins  ↓ 	Users  ↓ 	Images  ↓ 	Updated  ↓
1 	English 	English 	en 	12056 	81933 	545316 	27 	208008 	7546 	2010-03-14 13:00:06
2 	French 	Français 	fr 	6748 	19273 	195935 	10 	7705 	152 	2010-03-14 13:00:09
3 	German 	Deutsch 	de 	2065 	26856 	216775 	13 	7906 	1625 	2010-03-14 13:00:12
5 	Czech 	Česky 	cs 	1517 	3723 	17463 	3 	1351 	4 	2010-03-14 13:00:22
6 	Spanish 	Español 	es 	912 	3986 	46042 	9 	11183 	23 	2010-03-14 13:00:07
7 	Italian 	Italiano 	it 	860 	8342 	55656 	3 	4176 	358 	2010-03-14 13:00:10
8 	Portuguese 	Português 	pt 	711 	4554 	24657 	1 	2730 	10 	2010-03-14 13:00:04
9 	Russian 	Russian language 	ru 	539 	1931 	18795 	2 	1944 	45 	2010-03-14 13:00:25
10 	Greek 	Ελληνικά 	el 	395 	2803 	19483 	3 	1161 	61 	2010-03-14 13:00:20
11 	Finnish 	Suomi 	fi 	224 	589 	3429 	2 	559 	1 	2010-03-14 13:00:23
12 	Japanese 	日本語 	ja 	118 	1325 	4948 	4 	1263 	2 	2010-03-14 13:00:03
-- 	Multilingual 	Multilingual 	beta 	1781 	6683 	64455 	16 	7946 	183 	2010-03-14 13:00:19


  • 0 fget
  • 1 text en
  • 2 w3m
  • 3 text de
  • 4 text fr
  • 5 text es
  • 6 gecko
  • 7 truth
  • 8 api
  • 11 curl

Regularly observe

Newly added Mediawikis

<wikistats type="newlyadded"></wikistats>

WSA log

<wikistats type="wsalog"></wikistats>

Retrieve method codes

mysql> select textstats as method,count(id) as num_used from mediawikis group by textstats;
| method | num_used |
|      0 |     1097 |
|      1 |       26 |
|      2 |       72 |
|      3 |       18 |
|      4 |        1 |
|      5 |        2 |
6 rows in set (0.01 sec)

update schedule

See also

Detected Errors

<wikistats type="inactive"></wikistats>

Request for adding wikis

Please add these wikis:

Thank you, Sergey Chernyshev 17:34, 25 May 2009 (UTC)

The third one had not a working statistics, the other two are added. RobiH 18:57, 25 May 2009 (UTC)

Hello, I hope I'm right here, can you add the following German wikis (mediaWiki), they all have more than 1.000 articles:

Thank you!--Yatina 00:04, 19 August 2008 (CEST)

Done. RobiH 22:04, 19 August 2008 (CEST)

Hello, I have just noticed that my wiki is not in the list: WikiSara Can you add it, please?--G.E. 16:54, 3 December 2008 (CET)

It is a Wikia. It will automatically be included from the official Wikia hostlist as soon as it appears there. RobiH 17:40, 14 January 2009 (UTC)

Hi, I've also noticed that a wiki I work on is not on the list: *Wikia Gaming Thanks. -- Wikia Gaming - AlphaTwo

Gaming Wikia is listed as "Cheatbase". RobiH 17:38, 14 January 2009 (UTC)
Hi, according to thiswikia has more than 6000 wiki sites now.It seems that wikia wikis created in recent time were not automatically included.--Ffaarr 03:24, 18 February 2009 (UTC)
some of the newly created sites in wikia are in this list--Ffaarr 02:53, 20 February 2009 (UTC)

Before we had 3362 Wikias. What ? 3362 vs. > 6000 ?

Damn?! Really?

starting ./hostlists/

Warning: file_get_contents( failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found


Made new hostlist update script, fetching data from

found 7232 lines (wikis) in the update file after running it,..

now inserting...and trying to fetch data...

mysql> delete from wikia; Query OK, 3362 rows affected (0.06 sec)

inserting from new file (with --force so duplicates do not stop others from being inserted)


7201 Wikis in database

Mutante 12:04, 23 February 2009 (UTC)

Thank you very much for adding a lot of sites into stats.

But I found many of the sites included before are now not listed in. For example [1][2] etc. I tried to find the reason and just found that the list here are not auto-added but added by hand. So there are many sites missed in that list and some sites are listed twice.

The List of the New ones has been added. RobiH 16:32, 25 February 2009 (UTC)

I found this site [3] are the complete sites for wikia.(Even the sites created this week are included)Is this data convenient to be inserted in?

This List is password protected and cannot be harvested by our robot. RobiH 16:32, 25 February 2009 (UTC)

Thank you very much.--Ffaarr 14:04, 23 February 2009 (UTC)

Ffaarr, maybe, if you have more contacts with Wikia people, try to convince them its a nice thing to provide a URL with a list of ALL Wikias that can be seen public without having to login. It would be perfect if it was: complete (including ALL Wikias), free of dupes, always up to date or at least updated frequently, publicly accesible and in plain text, XML or some form that is easy to parse. Shouldnt be that much work for somebody who has Wikia shell access, i think, just have to find the right people to talk into it. Mutante 20:47, 25 February 2009 (UTC)

Thank you very much.Newly created sites(maybe after 2007)are all included in these lists and newly created sites are daily updated by bot. this list here(the list you just adde in) So the newer sites are very complete now and only some of old sites sites created before 2007 are not listed in. I'll try to ask wikia for more complete information.

Another question.Does sites hosted by wikia but with different domain(like etc)listed in this table?Thank you very much.--Ffaarr 01:35, 26 February 2009 (UTC)

Added. RobiH 18:47, 3 March 2009 (UTC)
thank you very much.--Ffaarr 00:39, 4 March 2009 (UTC)

HI, I still didn't get answer from wikia. So I made a list of the main sites(sites with more articles) which are not listed in. here After added these sites I think it will make at least the list for 500+ article sites almost complete.Thank you --Ffaarr 02:59, 2 March 2009 (UTC)

I imported more wikis from the link you provided, actually 158 more that were not duplicates. Greets, Mutante 19:43, 4 March 2009 (UTC)

I'll take care of the list. Will ping you here once it's ready. --Avatar 05:28, 24 June 2009 (UTC)
Here it is:
Information is cached for 6 hours. If you need further information included into the list, tell me. --Avatar 11:21, 10 July 2009 (UTC)

Can you rename Betawiki to – 19:17, 7 May 2009 (UTC) (

Done. Mutante 21:06, 16 July 2009 (UTC)

Please add this wiki:

(is a new wiki in spanish and active with 20 articles at this moment) --Mnts 01:58, 11 August 2009 (UTC)

Please add New World Encyclopedia. Thanks! 23:54, 12 October 2009 (UTC)

Both done. RobiH 19:45, 13 October 2009 (UTC)

Bartender's Database

Hello! Can you please add ?
-- 14:03, 29 October 2009 (UTC)

Added. RobiH 21:04, 29 October 2009 (UTC)

Can you please add ? Thank you so much! Brunn 21:47, 4 April 2010 (UTC)


Can you please add I tried adding it, but I don't see it on the list. Thanks! -- 00:07, 14 April 2010 (UTC)

There it is. RobiH 16:55, 14 April 2010 (UTC)

= Rechnerlexikon

Could you add Thanks

Parsing error

It appears that the raw stats from the Wiki wikis are not being parsed properly. For example, the raw feed for Memory Alpha is


but the parsed and formatted stats line is

№	Name 			Good 	Total 	Edits 	Views 	Admins 	Users	 	Images 	Stub Ratio 	Last checked
12 	en.memory-alpha 	30318 	84194 	978820 	0 	510 	1373059 	22 	0.3601		2009-05-21 11:06:46

The admins stat is actually the active users number, and the images stat is actually the admins number.

Thanks! -- 14:24, 21 May 2009 (UTC)

I haved added "Active users" to the database, the update script and . update is currently running ... Mutante 21:19, 29 May 2009 (UTC)

Incorrect image counts

Image counts on look a wee bit questionable; zero images for all of editthis and 422 images for all uncyclomedia wikis? One individual wiki from one of these setsísticas is showing 77 525 images on the site's own MW1.16 statistics page - admittedly that is one of the larger wikis, but still it's one individual project among many.

Any chance that the MediaWiki 1.16 upgrades are breaking things? The "activeusers" field did not exist in special:statistics in some of the older MW versions but is standard now. (Not that this would explain Wikia, they're still running two versions behind Wikipedia and others) -- 23:09, 6 September 2009 (UTC)

I added the activeusers column to the update scripts and html pages of: wmspecials, wikiquotes, wikinews, wikibooks, wikisources, wikipedias, wiktionary, uncyclomedia, anarchopedias, wikiversity, gentoo.

Mediawikis, wikifur and wikia already had them. The others dont have activeusers columns in their stats yet.

For uncyclomedia i also added it in _wiki ,_csv, and _ssv. For wiktionary ,wikisources and wikipedia: _wiki . @Robih: But please check them and list for me what is missing now. Mutante 16:56, 4 October 2009 (UTC)

Add Creative Commons wiki

It is already in. RobiH 15:40, 14 July 2009 (UTC)

Add n:tr

Hi! Tr Wikinews is open: . Could you add it in ? Thanks, XalD 21:42, 14 August 2009 (UTC)

Alright, i have just added it. Greets, Mutante 21:06, 16 August 2009 (UTC)

Thanks a lot :) XalD 00:27, 26 August 2009 (UTC)


WikiFur's entries may need updating - we have completed our migration from Wikia - all sites are now hosted off subdomains of should be going away by the end of the month. GreenReaper 05:29, 22 August 2009 (UTC)

Thanks for the info. What about ? Mutante 18:57, 25 August 2009 (UTC)

WikiLurv is a separately-hosted and run wiki which is considered our Swedish partner, to the extent that we share interlanguage links and include them in our stats. It is not however hosted or controlled by WikiFur - the administrator decided they wanted the experience of running it themselves. TurriWiki is in a similar situation, except that it was founded separately a few months before WikiFur. GreenReaper 21:54, 25 August 2009 (UTC)
Oh, and there seems to be an additional entry in this list for "English Wikifur" with as the address. It is a duplicate of the unrunescape entry. The admin values for TurriWiki and WikiLurv also appear to be incorrect. GreenReaper 22:23, 25 August 2009 (UTC)
I notice you have added a WikiIndex link - our article over there is here. It uses a copy of the stats from s23, modified for compactness and to use short URLs where available. There's also one for Uncyclopedia. We don't have a WikiHive page, but they appear to have moved to new URLs, for example GreenReaper 00:53, 28 November 2009 (UTC)

Add/update a list of sites using a particular MediaWiki extension

The list of wikis using mw:extension:SpecialNamespaces needs to be updated to reflect that the MediaWiki page about the extension was moved (from "simple namepaces" to "SpecialNamespaces"). The list of wikis known to use some form of the extension includes all Illogicopedias and those portions of Uncyclopedia (Uncyclomedia) hosted outside Wikia:

Illogicopedias (by language, ISO):

Uncyclomedia individual wikis (non-Wikia, by language, ISO):

Uncyclomedia (misc):


Hi, i have updated the short name in my database. See reflecting the new name now. Now i will have to let it update somehow.. hold on. Mutante 19:42, 21 September 2009 (UTC)


Hi! Could you add [[Category:Wikinews]] in ? On the bottom, please. Thanks, XalD 21:23, 27 October 2009 (UTC)

Done. Mutante 05:35, 3 November 2009 (UTC)

Add Filkipedia

Please add -- 17:39, 14 December 2009 (UTC)

Added. RobiH 20:16, 14 December 2009 (UTC)

Belarusian (Tarashkevitsa) language name for Wikipedia

Hello! Аccording to the language title in the localization messages file [4] and IANA language subtag registry [5] (plain text is used there) the proper name of the orthography is Taraškievica, not Tarashkevitsa. I raised this question on meta and got no objections till now [6]. Could you please rename Tarashkevitsa to Taraškievica for be-x-old Wikipedia and correspondingly update the link to the English Wikipedia article to eitherškievica orškievica)_language ? Regards, —zedlik 03:23, 25 December 2009 (UTC)

Hi, I have made this change:

update wikipedias set lang="Belarusian (Taraškievica)" where prefix="be-x-old";

Is it good now? Mutante 19:43, 28 December 2009 (UTC)

Yes, now it looks great, thank you! —zedlik 00:44, 29 December 2009 (UTC)

Add LlamaWiki

Please add Thanks in advance! 16:47, 7 April 2010 (UTC)

Added. RobiH 17:04, 7 April 2010 (UTC)

Depth again

For wikis with <100,000 articles, increase the value of depth to be 500 for the depth to be irrelevant and be replaced by a --. Now this value is 300. Depth of ml.wikipedia is >300 and this depth increase has not been artificial.

I checked the source, and all i see is this:
if ($good==0) {

and the depth formula is:


so i did not really know how to fix what you are refering to. ?! Mutante 20:18, 10 April 2010 (UTC)

In this page, depth of malayalam wikipedia is shown as "--" instead of 301, which is the bug. This needs to be fixed. I had thought that there was a some code that showed if $depth >= 300, $depth = "--". Probably it is replaced somewhere else.. Where can I find the source code of the bot? --Jacob.jose 19:59, 11 April 2010 (UTC)

Ah, you are right, i found it:

if ($depth > 300 && $good < 100000) { $depth="--"; }

I have overlooked it somehow last time. Changed it to 500 like you proposed. Malayalam now reports a depth of 374 in [7]. Mutante 20:25, 13 April 2010 (UTC)

Add Marjorie-Wiki

Please add to the List. Thank you ;-) Lady Whistler 08:23, 8 June 2010 (UTC)

Added. RobiH 22:47, 8 June 2010 (UTC)

Add Metin2Wiki

Please add to the List. Thank you ;-) --CSRedRat 10:17, 1 August 2010 (UTC)

Added. RobiH 19:55, 1 August 2010 (UTC)
Can you given site appropriate an index "metin2wiki" in the statistican or give a direct reference on statistics of the given wiki-project? --CSRedRat 20:46, 1 August 2010 (UTC)
I cann't find statistics about my wiki, please give me link to my stats --CSRedRat 22:29, 3 August 2010 (UTC)
Find the stats at mw:3623 and mw:3624. RobiH 21:26, 5 August 2010 (UTC)
Thank you! --CSRedRat 21:45, 6 August 2010 (UTC)


Hi, may you add to the stats ( Thanks and cheers --kgh 12:33, 6 August 2010 (UTC) May you also provide the ID after instertion?

Added at ID mw:3625. RobiH 22:56, 6 August 2010 (UTC)
Cool, thanks a lot! I just realised that you linked to the main page with However it should be I would be nice to change this. Thank you and cheers --kgh 11:58, 8 August 2010 (UTC)
Fixed by using the "Special:Statistics?action=raw" URL instead of German localization. Mutante 21:35, 9 August 2010 (UTC)
Thank you! Cheers --kgh 22:37, 9 August 2010 (UTC)

More Wikis to add

These are cool wikis! Perhaps you would like to add them. Cheers --kgh 09:06, 16 August 2010 (UTC)

2 added, 3 already existed. RobiH 16:30, 16 August 2010 (UTC)
Ops, I should have checked better than I did. Thank you --kgh 09:07, 17 August 2010 (UTC)

Add ko.wikinews & frr.wikipedia and are now opened. Please add these projects. Thank you. Kwj2772 11:52, 21 August 2010 (UTC)

fix needed

IDs mw:742 and mw:743 need to be fixed in the same way as (mw:3625). Because of that the versions are not detected correctly. Thank you and cheers --kgh 20:37, 17 September 2010 (UTC)

We changed mw:3625 back to localized statistics. Our Statistics script is not designed to produce correct entry page links, its sole objective is to produce accurate statistics. Having correct entry page links is an unimportant collateral of our statistics effort. RobiH 18:13, 18 September 2010 (UTC)
No objections at all! I thought that the reason why the script does not pick up the versions correctly was somehow related to this. However it works now for 742 and 743. Thanks and cheers --kgh 08:45, 22 September 2010 (UTC)

Another Wiki to add

Added. RobiH 15:38, 15 October 2010 (UTC)

Add Sega Retro - Sonic Retro wiki now split into two MediaWiki installations

added. RobiH 18:36, 1 December 2010 (UTC)

More wikis

Hi I found these two wikis:

added. RobiH 18:35, 1 December 2010 (UTC)
added. RobiH 16:25, 5 December 2010 (UTC)

Perhaps you might want to add them. Cheers --kgh 12:06, 29 November 2010 (UTC)

Thank you! Cheers --kgh 22:24, 7 December 2010 (UTC)

Add Wowpedia

Please add - WoWWiki forked into a new wiki. Thank you. --Pcj 14:31, 1 December 2010 (UTC)

added. RobiH 18:36, 1 December 2010 (UTC)


Please add nl.wikinews here. Thanks! --XalD 02:45, 29 December 2010 (UTC)

Done.added it and updated the table. Mutante 17:51, 1 January 2011 (UTC)

please add

added. RobiH 20:28, 10 January 2011 (UTC)

add GuildWiki

Please add - GuildWiki forked away from Wikia. Thanks! Dr ishmael 22:42, 25 January 2011 (UTC)

Added. RobiH 18:39, 1 March 2011 (UTC)

Add Pilkipedia

hi can you add the stats page is

added. RobiH 13:15, 27 January 2011 (UTC)

Thanks , how do i see or find it in the list ? can you paste a link to the page it is on

mw:3688 RobiH 18:53, 27 January 2011 (UTC)

Add DCEwiki

You can add ?

Than you - Want 12:58, 28 January 2011 (UTC)
Done- id 3700 Mutante 10:53, 20 February 2011 (UTC)

add StFWiki

Hi, can you add please? Thanks! --Jonas Hoffmann 07:47, 1 March 2011 (UTC)

Added. RobiH 17:40, 1 March 2011 (UTC)

Version checks are broken

The MediaWiki version checks are broken. There is something wrong with the query it does. – 14:47, 15 March 2011 (CET)

Fixed. RobiH 17:38, 31 March 2011 (CEST)

Add Wizard101 Central Wiki

Hi there, can you add to the lists?

Like several of the previous ones, the site was moved away from wikia.

Thanks, ErinEmeraldflame

Added. RobiH 17:39, 31 March 2011 (CEST)


This wiki seems to be listed twice as MediaWiki_SynchroEdit_Demo and SynchroEdit (mediawiki) under id 7. They/it seems to be under heavy spam attack inflating the stats – 10:20, 16 April 2011 (CEST)

Dupe removed. RobiH 18:04, 16 April 2011 (CEST)

New Wikis

18:55 <Danny_B|backup> hi
18:56 <Danny_B|backup> there were couple new wikis recently started
18:56 <Danny_B|backup> could you please add them to s23 stats?
18:56 <Danny_B|backup> thanks

Which are missing exactly? Can you check, Robih?

Wenn ich welche einbauen soll, soll er mir sagen, welche er meint. RobiH 00:28, 13 April 2011 (CEST)
Ditto, keine Ahnung, das war deine Aufgabe nach neuen zu checken auf der SiteMatrix dann wohl. Wenn ich wüsste welche hätte ich längst geaddet. Mutante 22:28, 13 April 2011 (CEST)
Naja, wenn er WikiMedias meinen würde, hätte er das ja so geschrieben. RobiH 22:42, 13 April 2011 (CEST)


Here's another wiki to add: Jdpipe 15:49, 26 April 2011 (CEST)

added. RobiH 19:11, 26 April 2011 (CEST)


Yet another add-a-wiki-request: http://sä ( if international domain names are a problem). Best regards, Leo Wallentin 16:57, 14 May 2011 (CEST)

added. RobiH 23:31, 14 May 2011 (CEST)

Add ShoutWiki

ShoutWiki is a new popular wiki host, that currently is considered a strong alternative to Wikia, and is growing.. I think stats should be added for this farm. --Lewis Cawte 15:40, 8 June 2011 (CEST)

Give us a host list and we add them. RobiH 21:05, 8 June 2011 (CEST)
I'll see what I can do, how are new wikis managed, for Wikia & WMF? Is it a manual request or is it automatic? --Lewis Cawte 21:40, 8 June 2011 (CEST)

The team want to know what a host list is? --Lewis Cawte 22:14, 8 June 2011 (CEST)

A list of all Shoutwikis URLs on one page RobiH 21:45, 9 June 2011 (CEST)
The Shoutwiki list is now linked on the index page. Mutante 06:39, 13 October 2011 (CEST)

Add WikiQueer

Greetings - please consider adding WikiQueer to your Wikistats list - Tried using the form - and failed on second element. Thank you -- 10:07, 29 July 2011 (CEST)

Added. RobiH 19:34, 30 July 2011 (CEST)

Hello S23-Team,

could you please add to the list? It hit 24k articles last week.

Thanks a lot! - 18:51, 22 September 2011 (CEST)

Added. RobiH 22:11, 23 September 2011 (CEST)


In wikistats the wiki is called DaSch-Tour is linked to and the Wiki there is called Web Community Wiki. I send this request the fourth time trough different channels. Please RENAME it! -- 13:41, 21 October 2011 (CEST)

my post from mutantes talkpage: the wiki with the ID 3441 is listed as DaSch-Tour which is wrong, it should be Web Community Wiki. Please rename, thanks -- 00:19, 3 October 2011 (CEST) -- 02:02, 23 October 2011 (CEST)

It will be renamed as soon as we have finished developing the feature of renaming existing entries instead of deleting then and adding them from scratch. We hope this feature to be added in early 2012. RobiH 18:46, 23 October 2011 (CEST)