Last modified: 2014-08-28 02:43:24 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T43023, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 41023 - Make a stats table for 85 W3C wikis
Make a stats table for 85 W3C wikis
Status: RESOLVED FIXED
Product: Wikimedia Labs
Classification: Unclassified
wikistats (Other open bugs)
unspecified
All All
: Normal enhancement
: ---
Assigned To: Daniel Zahn
https://encrypted.google.com/#q=site:...
:
Depends on:
Blocks: 36570
  Show dependency treegraph
 
Reported: 2012-10-14 19:48 UTC by Robert Hanke
Modified: 2014-08-28 02:43 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Comment 1 Mark A. Hershberger 2012-10-14 19:59:36 UTC
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?
Comment 2 Robert Hanke 2012-10-14 20:51:24 UTC
You want it, you got it:
http://wikistats.wmflabs.org/largest_html.php?sort=good_desc&th=0&lines=53382
Comment 3 Daniel Zahn 2012-10-15 17:06:00 UTC
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.
Comment 4 Daniel Zahn 2013-04-22 23:51:13 UTC
.
Comment 5 Gerrit Notification Bot 2013-04-26 23:54:09 UTC
Related URL: https://gerrit.wikimedia.org/r/61157 (Gerrit Change I710fbf184ef5ef84d9c2f5bca2b115e0660f5b8f)
Comment 6 Roan Kattouw 2013-04-26 23:54:44 UTC
(In reply to comment #5)
> Related URL: https://gerrit.wikimedia.org/r/61157 (Gerrit Change
> I710fbf184ef5ef84d9c2f5bca2b115e0660f5b8f)

Whoops, this is unrelated, sorry about that.
Comment 7 Daniel Zahn 2013-12-09 22:17:09 UTC
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?
Comment 8 Robert Hanke 2013-12-09 22:47:39 UTC
http://www.w3.org/community/groups/
159 Groups. Each one of these groups has its own wiki (Left Navigation bar).
Comment 9 Daniel Zahn 2014-08-21 02:39:32 UTC
<?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
Comment 10 Daniel Zahn 2014-08-22 02:15:26 UTC
https://gerrit.wikimedia.org/r/#/c/155680/
Comment 11 Daniel Zahn 2014-08-28 02:12:21 UTC
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
Comment 12 Daniel Zahn 2014-08-28 02:43:24 UTC
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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links