Submissions sorted by number of interested attendees

Below is a sorted (by number of interested attendees) list of all pages in Category:Wikimania submissions as of 13:58, 21 May 2011 (UTC). This list was calculated generated by MADe (recalculated by Blahma) using a slightly adapted version of the code originally written by User:He!ko (and patched by User:Waldir) for Wikimania 2010.

Rank

rank / (number of interested attendees) / link to submission

Script to update the page

Any Mac or Linux user should be able to update this page by saving the below script as allsubs.py and running it by typing

python allsubs.py > sorted_submissions.txt

in a command line.

Windows users should first install Python and add the python installation folder to the Path system variable (instructions | video), in order to be able to run the command above from the DOS command line.

source code: (remember to replace USERNAME, YEAR and PASSWORD below by your own credentials for this wiki)

#!/usr/bin/env python
import urllib
import json
import re

api_url = "http://wikimaniaYEAR.wikimedia.org/w/api.php"

def dump_cat(name):
    # login
    url = api_url + "?action=login&lgname=USERNAME&lgpassword=PASSWORD"
    urllib.urlopen(url)
    # fetch members
    url = api_url + '?action=query&format=json&list=categorymembers' + \
                    '&cmlimit=500&cmnamespace=0&cmtitle=' + name
    res = json.loads(urllib.urlopen(url).read())
    members = res['query']['categorymembers']
    
    submissions = []
    for i,p in enumerate(members):
        url = api_url +  '?action=query&format=json&prop=revisions&titles=%s&rvprop=content'\
              % urllib.quote(p['title'].encode('utf8'))
        res = json.loads(urllib.urlopen(url).read())
        num = len( re.findall('YEAR \(UTC\)', repr(res)) )
        assert not '-1' in res['query']['pages']
        submissions.append((num, p['title']))
    submissions.sort()
    submissions.reverse()

    for c, n in submissions:
        print '# (%d) [[%s]]' % (c, re.sub("(Submissions/)(.+)","\\1\\2|\\2",n.encode('utf8')))

if __name__ == '__main__':
    dump_cat('Category:Wikimania submissions')