Wikistats/ToDo/Wikia-check

Check Wikia Wikistats database for entries where "name" field is different from the subdomain name used in "statsurl".

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

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

<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 "# $name != $url_name \n"; }

} ?> </HighlightSyntax>

Contents