Wikistats/ToDo

Tasks for Wikistats
[1] Finish Checklist for ACC-Wiki, ScribbleWiki, Wik.is, WMSpecial (mutante) [1] New URLs for these 50 Wikias OR refresh hostlist | list below (mutante) [x] New URLs for IDs 154, 1912 (mutante) [1] Coalesced: Merge into Index (mutante) [ ] Check statuses (mutante) [ ] Check oldest (robiH) [2] Revamp Cron from fixed scheduled times to big sequential loop, guarded by hourly automatic test if process is still running with automatic restart if necessary (mutante) [2] User talk:MattisManzel (MattisManzel) [2] Update sources on Wikistats (mutante) [2] Start collecting historic data (mutante) [2] Host graphical stats on S23 (mutante) [3] meta:User:mutante/Wikistats [3] Keep track of WikiXray

* [ ] is supposed to mean its a permanent task

New Wikia URLs
update wikia set name="kirby",statsurl="http://kirby.wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.kirby"; update wikia set name="activeworlds",statsurl="http://activeworlds.wikia.com/index.php?title=Special:Statistics&action=raw" where name="active_worlds"; update wikia set name="frikipaideia",statsurl="http://frikipaideia.wikia.com/index.php?title=Special:Statistics&action=raw" where name="anegkyklopaideia"; update wikia set name="anarchyonline",statsurl="http://anarchyonline.wikia.com/index.php?title=Special:Statistics&action=raw" where name="aokb"; update wikia set name="pnp.fallout",statsurl="http://pnp.fallout.wikia.com/index.php?title=Special:Statistics&action=raw" where name="falloutpnp"; update wikia set name="pt-br.cinema",statsurl="http://pt-br.cinema.wikia.com/index.php?title=Special:Statistics&action=raw" where name="cinemacultura"; update wikia set name="retrogames",statsurl="http://retrogames.wikia.com/index.php?title=Special:Statistics&action=raw" where name="classicpcgames"; update wikia set name="aspatria",statsurl="http://aspatria.wikia.com/index.php?title=Special:Statistics&action=raw" where name="aspatria"; update wikia set name="coldplay",statsurl="http://coldplay.wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.coldplay"; update wikia set name="globallives",statsurl="http://globallives.wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.globallives"; update wikia set name="old.guildwars",statsurl="http://old.guildwars.wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.guildwars"; update wikia set name="half-life",statsurl="http://half-life.wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.half-life"; update wikia set name="lug",statsurl="http://lug.wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.lug"; update wikia set name="nintendo",statsurl="http:// nintendo.wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.nintendo"; update wikia set name="matematica",statsurl="http://matematica.wikia.com/index.php?title=Special:Statistics&action=raw" where name="es.math"; delete from wikia where name="fi.uncyclopedia"; update wikia set name="dvd",statsurl="http://dvd.wikia.com/index.php?title=Special:Statistics&action=raw" where name="geniusent"; update wikia set name="econsultation",statsurl="http://econsultation.wikia.com/index.php?title=Special:Statistics&action=raw" where name="governmentsubmissions"; update wikia set name="neopets",statsurl="http://neopets.wikia.com/index.php?title=Special:Statistics&action=raw" where name="guilds"; update wikia set name="old.guildwars",statsurl="http://old.guildwars.wikia.com/index.php?title=Special:Statistics&action=raw" where name="guildwars";	DUPE! update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="hm"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="novelas"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="aq"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="kingkong"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="liquidlurker"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="rpgnarena"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="shadowrunnpcs"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="threekingdom"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="ttoh"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="u5lazarus"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="warhammerfantasy"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="ru.computers"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="spam"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.knightrider"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.antm"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="encpp"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="wowtw"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="sustainapedia"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="it.tolkien"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="fr.wow"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.ghostintheshell"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.beauty"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="de.aokb"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="Lobpreis"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.sticknerds"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="dt"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.blogging"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="starcraft2"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="en.Karaoke"; update wikia set name="",statsurl="http:// .wikia.com/index.php?title=Special:Statistics&action=raw" where name="sk.Necyklopedia";

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

update schedule

 * EditThis 23.30
 * Wikipedia 0 and 12
 * Wiktionary 0.30 and 12.30
 * Wikibooks 1 and 13
 * S23 1
 * List of Wikiquotes 1.30 and 13.30
 * List of Private Mediawikis 2 and 14
 * Wikinews 3 and 15
 * Wikisource 3.15 and 15.15
 * Wiki-Site 3
 * Wikimedia Specials 3.30 and 15.30
 * updating Code 0 entries 4+10+16+22
 * Wikitravel 4
 * Anarchopedia 4.30
 * Wikia 5
 * Uncyclomedia 5
 * Elwiki 6
 * Qweki 6.45
 * Hyperwave 7
 * Scribblewiki 7
 * Gratis-Wiki 8
 * Wikible 9
 * openSUSE 9.30
 * Mozilla Development Center 10
 * Wik.is 11
 * Gentoo 11.30
 * write timestamp for last update on index page 23.23