×
Create a new article
Write your page title here:
We currently have 3,189 articles on s23. Type your article name above or create one of the articles listed here!



    s23
    3,189Articles

    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[edit]

    [1]

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

    Dump from DB[edit]

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

    Run PHP cmd-line script on it[edit]

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

    Results[edit]

    Wikia wikis where name not like statsurl[edit]

    'name' 'subdomain'[edit]

    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

    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[edit]

    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";


    -- DONE

    Cookies help us deliver our services. By using our services, you agree to our use of cookies.
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.