#!/usr/bin/python def commify(n): s = str(n) i = 3 while i < len(s): s = s[:-i] + ',' + s[-i:] i += 4 return s def ordinal(n): s = commify(n) if 10 <= n % 100 < 20: return s + 'th' else: return s + {1 : 'st', 2 : 'nd', 3 : 'rd'}.get(n % 10, "th") import os import sys import cgi import urllib import re import cgitb; cgitb.enable() import menu os.environ['PYTHON_EGG_CACHE'] = '/tmp' import MySQLdb try: db = MySQLdb.connect(host='lust',user='rftg',db='rftg') except: print 'Content-type: text/html; charset=utf-8' print print 'The site is down for maintainence.' sys.exit() form = cgi.FieldStorage() user = form.getvalue('user', '') where = '' if user: where = ' AND gid IN (SELECT gid FROM attendance JOIN users USING (uid) WHERE user="' + user + '")' print 'Content-type: text/html; charset=utf-8' print cursor = db.cursor() cursor.execute(""" SELECT gid, description, COUNT(uid), GROUP_CONCAT(user ORDER BY uid SEPARATOR ', '), MAX(results.endvp) FROM games JOIN attendance USING (gid) JOIN users USING (uid) LEFT JOIN results USING (gid, uid) WHERE state='DONE'""" + where + """ GROUP BY gid ORDER BY gid DESC LIMIT 1000""") result = cursor.fetchall() print '' print '' print 'Race for the Galaxy AI' print '' print '' print '' print '' menu.printmenu() print '

' print '

COMPLETED GAMES

' print '' print '

Click on the game ID to see more details.

' print len(result), 'games displayed' print '' print '' print '' print '' print '' print '' print '' print '' print '' print '' alt = False for r in result: if alt: print '' else: print '' if r[4]: print '' else: print '' print '' print '' print '' print '' alt = not alt print '

Game ID	Description	# Players	Players
' print r[0], '	', r[0], '	', r[1], '	', r[2], '	', r[3], '

' print '

' print '' print ''