×
Create a new article
Write your page title here:
We currently have 3184 articles on s23. Type your article name above or click on one of the titles below and start writing!



s23
3184Articles

Wikistats/ToDo/Wikia-check

< Wikistats‎ | ToDo
Revision as of 09:42, 16 February 2008 by imported>mutante (→‎Run PHP cmd-line script on it)

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

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

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

} ?> </HighlightSyntax>

Results

Wikia wikis where name not like statsurl

'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
Cookies help us deliver our services. By using our services, you agree to our use of cookies.