Difference between revisions of "Wikistats/ToDo"

From S23Wiki
Jump to: navigation, search
(Tasks for Wikistats)
Line 249: Line 249:
(is a new wiki in spanish and active with 20 articles at this moment) --[[User:Mnts|Mnts]] 01:58, 11 August 2009 (UTC)
(is a new wiki in spanish and active with 20 articles at this moment) --[[User:Mnts|Mnts]] 01:58, 11 August 2009 (UTC)
Please add [http://www.newworldencyclopedia.org/entry/Special:Statistics New World Encyclopedia]. Thanks! [[Special:Contributions/|]] 23:54, 12 October 2009 (UTC)
==Parsing error==
==Parsing error==

Revision as of 16:54, 12 October 2009

Tasks for Wikistats

<tasks> [1] #Add/update a list of sites using a particular MediaWiki extension (mutante) [2] #Incorrect image counts add activeusers to _wiki,_csv,_ssv (mutante) </tasks>

Regularly observe

WSA log

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

Retrieve method codes

method code get with parse what used x times
0 file_get_contents() raw numbers 1602
1 file_get_contents() text-en 138
2 lynx -dump raw numbers 37
3 file_get_contents() text-de 36
4 file_get_contents() text-es 3
5 file_get_contents() text-fr 2
8 lynx -dump text-en 2
9  ?  ? 4
10 lynx -dump text-fr 1
11 wget -S -O - raw numbers 1

(mysql> select textstats,count(id) from mediawikis group by textstats;)

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/update_wikia.sh

Warning: file_get_contents(http://www.wikia.com/dbdumps/dbdumps.html): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found


Made new hostlist update script, fetching data from

http://www.wikia.com/wiki/Wikia:List_of_Wikia/A http://www.wikia.com/wiki/Wikia:List_of_Wikia/D http://www.wikia.com/wiki/Wikia:List_of_Wikia/H http://www.wikia.com/wiki/Wikia:List_of_Wikia/M http://www.wikia.com/wiki/Wikia:List_of_Wikia/Q http://www.wikia.com/wiki/Wikia:List_of_Wikia/T

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 wowwiki.com/ memory-alpha.org/ wiki.ffxiclopedia.org/ 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 translatewiki.net? – 19:17, 7 May 2009 (UTC) (http://translatewiki.net/wiki/User:Nike)

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)

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 http://s23.org/wikistats/wikia_html.php?sort=ausers_desc . update is currently running ... Mutante 21:19, 29 May 2009 (UTC)

Incorrect image counts

Image counts on http://s23.org/wikistats/ 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 http://desciclopedia.org/wiki/Especial:Estatí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: http://tr.wikinews.org/wiki/Ana_sayfa . Could you add it in http://s23.org/wikistats/wikinews_wiki.php ? 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 wikifur.com. furry.wikia.com should be going away by the end of the month. GreenReaper 05:29, 22 August 2009 (UTC)

Thanks for the info. What about http://www.wikilurv.se/ ? 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 unrunescape.wikia.com 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)

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

The list of wikis using mw:extension:SpecialNamespaces http://s23.org/wikistats/mediawiki_extensions.php?id=991 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 http://s23.org/wikistats/mediawiki_extensions.php?id=991 reflecting the new name now. Now i will have to let it update somehow.. hold on. Mutante 19:42, 21 September 2009 (UTC)