Could someone explain to me why we have a separate table for each group of wikis instead of just having one big table with one column identifying the group that the wiki belongs to?

You want it, you got it:
http://wikistats.wmflabs.org/largest_html.php?sort=good_desc&th=0&lines=53382

Ah, yeah, i am currently working on that largest_html stuff, like the legend and colors and move everything color rated to css. It is from the old server but i am overhauling it..then add it to git.

.

Related URL: https://gerrit.wikimedia.org/r/61157 (Gerrit Change I710fbf184ef5ef84d9c2f5bca2b115e0660f5b8f)

(In reply to comment #5)

Related URL: https://gerrit.wikimedia.org/r/61157 (Gerrit Change
I710fbf184ef5ef84d9c2f5bca2b115e0660f5b8f)

Whoops, this is unrelated, sorry about that.

Robert, could you provide a current raw list of those wiki names? the google link doesn't appear to return 85 wikis anymore, or does it?

http://www.w3.org/community/groups/
159 Groups. Each one of these groups has its own wiki (Left Navigation bar).

<?php
# returns an array with the names of all current W3C wikis
function get_w3c_wikis() {

        $listurl="http://www.w3.org/community/groups/";
        $buffer=file_get_contents($listurl);
        $pattern = '/a id="(.*)"/';
        preg_match_all($pattern, $buffer, $matches);
        return($matches[1]);
}

#print_r(get_w3c_wikis());

# output the list as SQL for importing
foreach (get_w3c_wikis() as &$wiki) {
        print "INSERT into w3cwikis (prefix) values ('$wiki'); \n";
}
?>

<-- imported current list of wiki names into db with that

178 of them as of today

https://gerrit.wikimedia.org/r/#/c/155680/

Robih, check here:

http://wikistats.wmflabs.org/display.php?t=w3c

yea, still misses the Version column and outgoing links are broken, but wanted to let you know about progress

it also needed https://gerrit.wikimedia.org/r/#/c/156745/1

links in table: https://gerrit.wikimedia.org/r/#/c/156746/

cron for updates: https://gerrit.wikimedia.org/r/156747

the version update thing is all horrible and not in the repo yet.. argg.. but resolved nevertheless.

http://wikistats.wmflabs.org/display.php?t=w3c