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 08:17, 7 July 2010 (UTC)

Note: The list is not necessarily accurate, as the the script used to generate it is a quick hack (see below).

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 and PASSWORD below by your own credentials for this wiki)

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

api_url = "http://wikimania2010.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('\[User:.*?\]', 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')