Wikistats/ToDo/Wikia-check

Check Wikia Wikistats database for entries where "name" field is different from the subdomain name used in "statsurl".

Add Interwiki prefix

[1]

.. so we can use Wikia:Test to link to Wikia wiki "test".

Dump from DB

mysql> select id,name,statsurl from wikia into outfile 'wikia-checklist.txt';

Run PHP cmd-line script on it

<HighlightSyntax> <?php $lines=file("/home/mutante/wikia-checklist.txt");

echo "== Wikia wikis where name not like statsurl == \n== 'name' 'subdomain' ==\n"; foreach ($lines as $line_num => $line) {

$pieces=explode("\t",$line); $name=$pieces[1]; $url=$pieces[2];

$url_name=explode("http://",$url); $url_name=explode(".wikia",$url_name[1]); $url_name=explode("/",$url_name[0]); $url_name=$url_name[0];

if ($name!=$url_name) { echo "# $name != $url_name \n"; }

} ?> </HighlightSyntax>

'name' 'subdomain'

1. animalcrossingds != animalcrossing
2. automation != industrialautomation
3. business_owns != businessowns
4. dc != en.dcdatabaseproject.com
5. ddr != en.ddr
6. doraemon != ja.doraemon
7. en.cancer != cancer
8. en.fantasy != fantasy
9. en.futurama != futurama
10. en.gta != gta
11. en.israel != israel
12. en.tibia != tibia
13. eomemoryalpha != memory-alpha.org
14. Feuilleton != kultur
15. mightandmagic != pl.mightandmagic
16. oss != opensource
17. silent != silenthill
18. v2l != education
19. wesleyan != students
20. wikiality != wikiality.com
21. ww2 != war
22. memory-alpha.org/de != memory-alpha.org
23. memory-alpha.org/en != memory-alpha.org
24. memory-alpha.org/mu != memory-alpha.org
25. memory-alpha.org/nl != memory-alpha.org
26. dcdatabaseproject.com != en.dcdatabaseproject.com
27. www.marveldatabase.com != en.marveldatabase.com
28. memory-alpha.org/es/ != memory-alpha.org
29. ukrailways != en.trains
30. ageofkings != ageofempires
31. Talesofpirates != talesofpirates
32. ssb != super-smash-bros
33. WikiWoW France != fr.wowwiki.com
34. Tamsui != Wikia:
35. assasinscreed != assassinscreed
36. es.starcraft2 != es.starcraft
37. FFXIclopedia != wiki.ffxiclopedia.org
38. en.anime != anime
39. FFXIclopedia (ja) != ja.wiki.ffxiclopedia.org