From s23
Jump to navigation Jump to search

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) {

  1. echo "# $name != $url_name \n";

echo "update wikia set name=\"$url_name\" where name=\"$name\"; \n"; }

} ?> </HighlightSyntax>


Wikia wikis where name not like statsurl

'name' 'subdomain'

  1. animalcrossingds != animalcrossing
  2. automation != industrialautomation
  3. business_owns != businessowns
  4. dc !=
  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 !=
  14. Feuilleton != kultur
  15. mightandmagic != pl.mightandmagic
  16. oss != opensource
  17. silent != silenthill
  18. v2l != education
  19. wesleyan != students
  20. wikiality !=
  21. ww2 != war
  22. !=
  23. !=
  24. !=
  25. !=
  26. !=
  27. !=
  28. !=
  29. ukrailways != en.trains
  30. ageofkings != ageofempires
  31. Talesofpirates != talesofpirates
  32. ssb != super-smash-bros
  33. WikiWoW France !=
  34. Tamsui != Wikia:
  35. assasinscreed != assassinscreed
  36. es.starcraft2 != es.starcraft
  37. FFXIclopedia !=
  38. en.anime != anime
  39. FFXIclopedia (ja) !=

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="" 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="" 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="" where name="wikiality";

update wikia set name="war" where name="ww2";

update wikia set name="" where name="";

update wikia set name="" where name="";

update wikia set name="" where name="";

update wikia set name="" where name="";

update wikia set name="" where name="";

update wikia set name="" where name="";

update wikia set name="" where name="";

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="" 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="" where name="FFXIclopedia";

update wikia set name="anime" where name="en.anime";

update wikia set name="" 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="";

delete from where name="ukrailways";

delete from where name="ageofkings";

delete from where name="assasinscreed";

delete from where name="en.anime";