Page MenuHomePhabricator

Make a stats table for 85 W3C wikis
Closed, ResolvedPublic

Details

Reference
bz41023

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 12:48 AM
bzimport set Reference to bz41023.
RobiH created this task.Oct 14 2012, 7:48 PM

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?

Dzahn added a comment.Oct 15 2012, 5:06 PM

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.

Dzahn added a comment.Dec 9 2013, 10:17 PM

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?

RobiH added a comment.Dec 9 2013, 10:47 PM

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

Dzahn added a comment.EditedAug 21 2014, 2:39 AM
<?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

Dzahn added a comment.Aug 28 2014, 2:12 AM

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

Dzahn added a comment.Aug 28 2014, 2:43 AM

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