Check Wikia Wikistats database for entries where "name" field is different from the subdomain name used in "statsurl".
Add Interwiki prefix
.. 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 "update wikia set name=\"$url_name\" where name=\"$name\"; \n"; }
} ?> </HighlightSyntax>
Results
Wikia wikis where name not like statsurl
'name' 'subdomain'
- animalcrossingds != animalcrossing
- automation != industrialautomation
- business_owns != businessowns
- dc != en.dcdatabaseproject.com
- ddr != en.ddr
- doraemon != ja.doraemon
- en.cancer != cancer
- en.fantasy != fantasy
- en.futurama != futurama
- en.gta != gta
- en.israel != israel
- en.tibia != tibia
- eomemoryalpha != memory-alpha.org
- Feuilleton != kultur
- mightandmagic != pl.mightandmagic
- oss != opensource
- silent != silenthill
- v2l != education
- wesleyan != students
- wikiality != wikiality.com
- ww2 != war
- memory-alpha.org/de != memory-alpha.org
- memory-alpha.org/en != memory-alpha.org
- memory-alpha.org/mu != memory-alpha.org
- memory-alpha.org/nl != memory-alpha.org
- dcdatabaseproject.com != en.dcdatabaseproject.com
- www.marveldatabase.com != en.marveldatabase.com
- memory-alpha.org/es/ != memory-alpha.org
- ukrailways != en.trains
- ageofkings != ageofempires
- Talesofpirates != talesofpirates
- ssb != super-smash-bros
- WikiWoW France != fr.wowwiki.com
- Tamsui != Wikia:
- assasinscreed != assassinscreed
- es.starcraft2 != es.starcraft
- FFXIclopedia != wiki.ffxiclopedia.org
- en.anime != anime
- FFXIclopedia (ja) != ja.wiki.ffxiclopedia.org