imported>mutante mNo edit summary |
imported>mutante |
||
Line 165: | Line 165: | ||
delete from wikia where name="animalcrossing"; |
delete from wikia where name="animalcrossing"; |
||
delete from wikia where name="en.fantasy"; |
delete from wikia where name="en.fantasy"; |
||
delete from wikia where name="oss"; |
delete from wikia where name="oss"; |
||
delete from wikia where name="v2l"; |
delete from wikia where name="v2l"; |
||
delete from wikia where name="dcdatabaseproject.com"; |
delete from wikia where name="dcdatabaseproject.com"; |
||
delete from where name="ukrailways"; |
delete from where name="ukrailways"; |
||
delete from where name="ageofkings"; |
delete from where name="ageofkings"; |
||
delete from where name="assasinscreed"; |
delete from where name="assasinscreed"; |
||
delete from where name="en.anime"; |
delete from where name="en.anime"; |
Revision as of 09:54, 16 February 2008
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
update wikia set name="animalcrossing" where name="animalcrossingds";
update wikia set name="industrialautomation" where name="automation";
update wikia set name="businessowns" where name="business_owns";
update wikia set name="en.dcdatabaseproject.com" where name="dc";
update wikia set name="en.ddr" where name="ddr";
update wikia set name="ja.doraemon" where name="doraemon";
update wikia set name="cancer" where name="en.cancer";
update wikia set name="fantasy" where name="en.fantasy";
update wikia set name="futurama" where name="en.futurama";
update wikia set name="gta" where name="en.gta";
update wikia set name="israel" where name="en.israel";
update wikia set name="tibia" where name="en.tibia";
update wikia set name="memory-alpha.org" where name="eomemoryalpha";
update wikia set name="kultur" where name="Feuilleton";
update wikia set name="pl.mightandmagic" where name="mightandmagic";
update wikia set name="opensource" where name="oss";
update wikia set name="silenthill" where name="silent";
update wikia set name="education" where name="v2l";
update wikia set name="students" where name="wesleyan";
update wikia set name="wikiality.com" where name="wikiality";
update wikia set name="war" where name="ww2";
update wikia set name="memory-alpha.org" where name="memory-alpha.org/de";
update wikia set name="memory-alpha.org" where name="memory-alpha.org/en";
update wikia set name="memory-alpha.org" where name="memory-alpha.org/mu";
update wikia set name="memory-alpha.org" where name="memory-alpha.org/nl";
update wikia set name="en.dcdatabaseproject.com" where name="dcdatabaseproject.com";
update wikia set name="en.marveldatabase.com" where name="www.marveldatabase.com";
update wikia set name="memory-alpha.org" where name="memory-alpha.org/es/";
update wikia set name="en.trains" where name="ukrailways";
update wikia set name="ageofempires" where name="ageofkings";
update wikia set name="talesofpirates" where name="Talesofpirates";
update wikia set name="super-smash-bros" where name="ssb";
update wikia set name="fr.wowwiki.com" where name="WikiWoW France"
update wikia set name="" where name="Tamsui";
update wikia set name="assassinscreed" where name="assasinscreed";
update wikia set name="es.starcraft" where name="es.starcraft2";
update wikia set name="wiki.ffxiclopedia.org" where name="FFXIclopedia";
update wikia set name="anime" where name="en.anime";
update wikia set name="ja.wiki.ffxiclopedia.org" where name="FFXIclopedia (ja)";
get rid of dupes
delete from wikia where name="animalcrossing";
delete from wikia where name="en.fantasy";
delete from wikia where name="oss";
delete from wikia where name="v2l";
delete from wikia where name="dcdatabaseproject.com";
delete from where name="ukrailways";
delete from where name="ageofkings";
delete from where name="assasinscreed";
delete from where name="en.anime";