]> git.cworth.org Git - turbot-web/commitdiff
Convert all files from DOS to Unix text file format
authorCarl Worth <cworth@cworth.org>
Wed, 12 Jan 2022 07:54:46 +0000 (23:54 -0800)
committerCarl Worth <cworth@cworth.org>
Wed, 12 Jan 2022 07:54:46 +0000 (23:54 -0800)
Since otherwise I'm going to be strufflign when editing these files.

html_generator.py
individual.css
overview.css
sorttable.js

index 1ba3ac5bcf985dea3fe027ff11b0b92b23488a89..7d18e0a5738a111e9bd4acda97cccbb88d7d8338 100644 (file)
-# -*- coding: utf-8 -*-\r
-"""\r
-Created on Thu Jan  6 23:35:23 2022\r
-\r
-@author: Avram Gottschlich\r
-"""\r
-"""\r
-I copied several functions from your code; \r
-if it's easier to refer to them rather than copying them that's absolutely fine\r
-\r
-This rewrites the html each time it is called\r
-If it's easy to call the puzzle/round functions each time they're updated,\r
-that would be great\r
-\r
-Requires sorttable.js, which should be included\r
-"""\r
-from turbot.channel import channel_url\r
-from boto3.dynamodb.conditions import Key\r
-\r
-website = "https://halibut.cworth.org/"\r
-#change this if we're using AWS or some other subdomain instead\r
-\r
-def find_hunt_for_hunt_id(turb, hunt_id):\r
-    """Given a hunt ID find the database item for that hunt\r
-\r
-    Returns None if hunt ID is not found, otherwise a\r
-    dictionary with all fields from the hunt's row in the table,\r
-    (channel_id, active, hunt_id, name, url, sheet_url, etc.).\r
-    """\r
-    response = turb.table.get_item(\r
-        Key={\r
-            'hunt_id': hunt_id,\r
-            'SK': 'hunt-{}'.format(hunt_id)\r
-            })\r
-\r
-    if 'Item' in response:\r
-        return response['Item']\r
-    else:\r
-        return None\r
-\r
-def hunt_puzzles_for_hunt_id(turb, hunt_id):\r
-    """Return all puzzles that belong to the given hunt_id"""\r
-\r
-    response = turb.table.query(\r
-        KeyConditionExpression=(\r
-            Key('hunt_id').eq(hunt_id) &\r
-            Key('SK').begins_with('puzzle-')\r
-            )\r
-        )\r
-\r
-    return response['Items']\r
-\r
-def elink(lin, text):\r
-    #shortcutting function for creating html links\r
-    #opens in a new tab for external links\r
-    return '<a href="{}" target="_blank" rel="noreferrer noopener">{}</a>'.format(lin, text)\r
-\r
-def link(lin, text):\r
-    #internal links, doesn't open new tab\r
-    return '<a href="{}">{}</a>'.format(lin, text)\r
-\r
-def hunt_info(turb, hunt):\r
-    """\r
-    Retrieves list of rounds, puzzles for the given hunt    \r
-    """\r
-    name = hunt["name"]\r
-    hunt_id = hunt["hunt_id"]\r
-    channel_id = hunt["channel_id"]\r
-    \r
-    puzzles = hunt_puzzles_for_hunt_id(turb, hunt_id)\r
-    \r
-    rounds = set()\r
-    for puzzle in puzzles:\r
-        if "rounds" not in puzzle:\r
-            continue\r
-        for rnd in puzzle["rounds"]:\r
-            rounds.add(rnd)\r
-    rounds = list(rounds)\r
-    rounds.sort()\r
-    \r
-    return puzzles, rounds\r
-\r
-def round_stat(rnd, puzzles):\r
-    #Counts puzzles, solved, list of puzzles for a given round\r
-    puzzle_count = 0\r
-    solved_count = 0\r
-    solved_puzzles = []\r
-    unsolved_puzzles = []\r
-    metas = []\r
-    meta_solved = 0\r
-    for puzzle in puzzles:\r
-        if "rounds" not in puzzle:\r
-            continue        \r
-        if rnd in puzzle["rounds"]:\r
-            if puzzle['type'] == 'meta':\r
-                metas.append(puzzle)\r
-                if puzzle['status'] == 'solved':\r
-                    meta_solved += 1\r
-            else:\r
-                puzzle_count += 1\r
-                if puzzle['status'] == 'solved':\r
-                    solved_count += 1\r
-                    solved_puzzles.append(puzzle)\r
-                else:\r
-                    unsolved_puzzles.append(puzzle)\r
-    solved_puzzles = sorted(solved_puzzles, key = lambda i: i['name'])\r
-    unsolved_puzzles = sorted(unsolved_puzzles, key = lambda i: i['name'])\r
-    rnd_puzzles = metas + unsolved_puzzles + solved_puzzles\r
-    return puzzle_count, solved_count, rnd_puzzles, meta_solved, len(metas)\r
-            \r
-   \r
-    \r
-def overview(puzzles, rounds):\r
-    #big board, main page. saves as index.html\r
-    start = ['<!DOCTYPE html>\n',\r
-     '<html>\n',\r
-     '<head>\n',\r
-     '  <meta charset="utf-8">\n',\r
-     '  <meta name="viewport" content="width=device-width, initial-scale=1">\n',\r
-     '\n',\r
-     '  <link rel="stylesheet" href="overview.css">\n',\r
-     '  <script type="text/javascript">\n',\r
-     '    // Hide all elements with class="containerTab", except for the one that matches the clickable grid column\n',\r
-     '    function openTab(tabName) {\n',\r
-     '      var i, x;\n',\r
-     '      x = document.getElementsByClassName("containerTab");\n',\r
-     '      for (i = 0; i < x.length; i++) {\n',\r
-     '        x[i].style.display = "none";\n',\r
-     '      }\n',\r
-     '      document.getElementById(tabName).style.display = "block";\n',\r
-     '    }\n',\r
-     '  </script>\n',\r
-     '\n',\r
-     '  <title>Hunt Overview</title>\n',\r
-     '  <script src="sorttable.js"></script>\n'\r
-     '</head>\n',\r
-     '    <div class="sidenav">\n'\r
-     '      <a href="index.html">Hunt Overview</a>'\r
-     '      <a href="all.html">All Puzzles</a>\n'\r
-     '      <a href="unsolved.html">Unsolved</a>\n'\r
-     '      <a href="solved.html">Solved</a>\n'\r
-     '    </div>\n'\r
-     '<body>\n',]\r
-    columns = ['  <div class="row">\n']\r
-    expanding = []\r
-    i = 1\r
-    for rnd in rounds:\r
-        puzzle_count, solved_count, rnd_puzzles, meta_solved, metas = round_stat(rnd, puzzles)\r
-        if metas == meta_solved and metas > 0:\r
-            status = 'solved'\r
-        else:\r
-            status = 'unsolved'\r
-        columns += ['    <div class="column {}" onclick="openTab(\'b{}\');">\n'.format(status, i),\r
-        '      <p>{}</p>\n'.format(rnd),\r
-        '      <p>Puzzles: {}/{}</p>\n'.format(solved_count, puzzle_count),\r
-        '      <p>Metas: {}/{}</p>\n'.format(meta_solved, metas),\r
-        '    </div>\n']\r
-        \r
-        expanding += [\r
-        '  <div id="b{}" class="containerTab {}" style="display:none;">\n'.format(i, status),\r
-        '    <span onclick="this.parentElement.style.display=\'none\'" class="closebtn">x</span>\n',\r
-        '    <h2>{}</h2>\n'.format(link(website + "_".join(rnd.split()) + "_round.html", rnd)),\r
-        '    <table class="sortable">\n',\r
-        '      <tr>\n',\r
-        '        <th><u>Puzzle</u></th>\n',\r
-        '        <th><u>Answer</u></th>\n',\r
-        '      </tr>\n',]\r
-\r
-        for puzzle in rnd_puzzles:\r
-            if puzzle['type'] == 'meta':\r
-                meta = ' [META]'\r
-            else:\r
-                meta = ''\r
-            if puzzle['status'] == 'solved':\r
-                expanding += ['      <tr class=\'solved\';>\n',\r
-                '        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + ".html", puzzle['name']+meta)),\r
-                '        <td>{}</td>\n'.format(puzzle['solution']),\r
-                '      </tr>\n']\r
-            else:\r
-                expanding += ['      <tr class=\'unsolved\';>\n',\r
-                '        <td><b>{}</b></td>\n'.format(link(website + "_".join(puzzle['name'].split()) + ".html", puzzle['name']+meta)),\r
-                '        <td></td>\n',\r
-                '      </tr>\n']\r
-        expanding.append('    </table>\n')\r
-        expanding.append('  </div>\n')\r
-        i += 1\r
-    columns.append('  </div>\n')\r
-    end = ['</body>\n', '</html>\n']\r
-    html = start + expanding + columns + end\r
-    file = "index.html"\r
-    f = open(file, "w")\r
-    for line in html:\r
-        f.write(line)\r
-    f.close()\r
-    return None\r
-\r
-def round_overview(rnd, puzzles):\r
-    #inputs: round name, puzzles\r
-    #round overview page\r
-    #saves as (round name)_round.html, in case meta/round share names.\r
-    #underscores replace spaces for links.\r
-    rnd_puzzles, meta_solved, metas = round_stat(rnd, puzzles)[2:]\r
-    if meta_solved == metas and metas > 0:\r
-        status = 'solved'\r
-    else:\r
-        status = 'unsolved'\r
-    start = ['<html>\n',\r
-     '    <head>\n',\r
-     '        <link rel="stylesheet" href="individual.css">\n',\r
-     '        <title>Mystery Hunt 2022</title>\n',\r
-     '        <script src="sorttable.js"></script>\n',\r
-     '    </head>\n',\r
-     '    <body class="{}">\n'.format(status),\r
-     '        <h1><b>{}</b></h1>\n'.format(rnd),\r
-     '        <p>{}</p>\n'.format(link(website + "index.html", 'Hunt Overview')),\r
-     '        <div>\n',\r
-     '            <table class="center sortable">\n',\r
-     '                <thead>\n',\r
-     '                    <tr>\n',\r
-     '                        <th>Puzzle Title/Slack</th>\n',\r
-     '                        <th>Puzzle Link</th>\n',\r
-     '                        <th>Sheet</th>\n',\r
-     '                        <th>Overview</th>\n',\r
-     '                        <th>Answer</th>\n',\r
-     #'                        <th>Extra Links</th>\n',\r
-     '                        <th>Tags</th>\n',\r
-     '                    </tr>\n',\r
-     '                </thead>\n',\r
-     '                <tbody>\n']\r
-    puzzle_list = []\r
-    for puzzle in rnd_puzzles:\r
-        if puzzle['type'] == 'meta':\r
-            meta = ' [META]'\r
-        else:\r
-            meta = ''\r
-        slack_url = channel_url(puzzle['channel_id'])\r
-        \r
-        if puzzle['status'] == 'solved':\r
-            puzzle_list += [ '                    <tr>\n',\r
-             '                        <td>{}</td>\n'.format(elink(slack_url, puzzle['name']+meta)),\r
-             '                        <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),\r
-             '                        <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),\r
-             '                        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + '.html', 'Overview')),\r
-             '                        <td>{}</td>\n'.format(puzzle['solution']),\r
-            # '                        <td></td>\n',\r
-             '                        <td>{}</td>\n'.format("".join(puzzle['tags'])),\r
-             '                    </tr>\n']\r
-        else:\r
-            puzzle_list += [ '                    <tr>\n',\r
-             '                        <td><b>{}</b></td>\n'.format(elink(slack_url, puzzle['name']+meta)),\r
-             '                        <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),\r
-             '                        <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),\r
-             '                        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + '.html', 'Overview')),\r
-             '                        <td></td>\n',\r
-            # '                        <td></td>\n',\r
-             '                        <td>{}</td>\n'.format(" ".join(puzzle['tags'])),\r
-             '                    </tr>\n']\r
-    end = ['                </tbody>\n',\r
-    '            </table>\n',\r
-    '        </div>\n',\r
-    '    </body>\n',\r
-    '</html>\n']\r
-    html = start + puzzle_list + end\r
-    file = "{}_round.html".format('_'.join(rnd.split()))\r
-    f = open(file, "w")\r
-    for line in html:\r
-        f.write(line)\r
-    f.close()\r
-    return None\r
-\r
-def puzzle_overview(puzzle):\r
-    #overview page for individual puzzles. saves as (name of puzzle).html,\r
-    #with underscores rather than spaces\r
-    name = puzzle['name']\r
-    if puzzle['type'] == 'meta':\r
-        meta = ' [META]'\r
-    else:\r
-        meta = ''\r
-    slack_url = channel_url(puzzle['channel_id'])\r
-    round_url = [link(website + "_".join(rnd.split()) + "_round.html", rnd) for rnd in puzzle['rounds']]\r
-    if puzzle['status'] == 'solved':\r
-        solution = puzzle['solution']\r
-        status = 'solved'\r
-    else:\r
-        solution = ""\r
-        status = 'unsolved'\r
-    html = ['<!DOCTYPE html>\n',\r
-     '<html>\n',\r
-     '<head>\n',\r
-     '    <meta charset="utf-8">\n',\r
-     '    <meta name="viewport" content="width=device-width, initial-scale=1">\n',\r
-     '    <link rel="stylesheet" href="individual.css">\n',\r
-     '    <title>{}</title>\n'.format(name+meta),\r
-     '    <p>{}</p>'.format(link(website + 'index.html', 'Hunt Overview')),\r
-     '\n',\r
-     '</head>\n',\r
-     '<body class="{}">\n'.format(status),\r
-     '    <h1>{}</h1>\n'.format(name+meta),\r
-     '    <div>\n',\r
-     '        <table class="center">\n',\r
-     '            <tr>\n',\r
-     '                <td>{}</td>\n'.format(elink(slack_url, 'Channel')), #slack channel\r
-     '                <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),\r
-     '                <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),\r
-     '                <td>Additional Resources</td>\n',\r
-     '            </tr>\n',\r
-     '        </table>\n',\r
-     '        <table class="center">\n',\r
-     '            <tr>\n',\r
-     '                <td>Round(s): {}</td>\n'.format(" ".join(round_url)), #round page on our site\r
-     '                <td>Tags: {}</td>\n'.format(" ".join(puzzle['tags'])), #add tags\r
-     '            </tr>\n',\r
-     '            <tr>\n',\r
-     '                <td>Answer: {}</td>\n'.format(solution),\r
-     '                <td>State: {}</td>\n'.format(puzzle['status']),\r
-     '            </tr>\n',\r
-     '        </table>\n',\r
-     '    </div>\n',\r
-     '\n',\r
-     '</body>\n',\r
-     '</html>\n']\r
-    underscored = "_".join(name.split())\r
-    file = "{}.html".format(underscored)\r
-    f = open(file, "w")\r
-    for line in html:\r
-        f.write(line)\r
-    return None\r
-\r
-def puzzle_lists(puzzles, filt):\r
-    #filt is one of "All", "Solved", "Unsolved" and spits out the appropriate list of puzzles\r
-    #generates pages for all puzzles, solved puzzles, unsolved puzzles\r
-    #saves as all/solved/unsolved.html, has a sidebar to link to each other and to the big board\r
-    solved_puzzles = [puzzle for puzzle in puzzles if puzzle['status'] == 'solved']\r
-    unsolved_puzzles = [puzzle for puzzle in puzzles if puzzle['status'] != 'solved']\r
-    start = ['<html>\n',\r
-     '    <head>\n',\r
-     '        <link rel="stylesheet" href="overview.css">\n',\r
-     '        <title>Mystery Hunt 2022</title>\n',\r
-     '        <script src="sorttable.js"></script>\n',\r
-     '    </head>\n',\r
-     '    <div class="sidenav">\n'\r
-     '      <a href="index.html">Hunt Overview</a>'\r
-     '      <a href="all.html">All Puzzles</a>\n'\r
-     '      <a href="unsolved.html">Unsolved</a>\n'\r
-     '      <a href="solved.html">Solved</a>\n'\r
-     '    </div>\n'\r
-     '    <body>\n',\r
-     '        <h1><b>{}</b></h1>\n'.format('{} Puzzles').format(filt),\r
-     '        <p>{}</p>\n'.format(link(website + "index.html", 'Hunt Overview')),\r
-     '        <div>\n',\r
-     '            <table class="center sortable">\n',\r
-     '                <thead>\n',\r
-     '                    <tr>\n',\r
-     '                        <th>Puzzle Title/Slack</th>\n',\r
-     '                        <th>Puzzle Link</th>\n',\r
-     '                        <th>Sheet</th>\n',\r
-     '                        <th>Overview</th>\n',\r
-     '                        <th>Answer</th>\n',\r
-     '                        <th>Round(s)</th>\n',\r
-     '                        <th>Tags</th>\n',\r
-     '                    </tr>\n',\r
-     '                </thead>\n',\r
-     '                <tbody>\n']\r
-    solved_code = []\r
-    unsolved_code = []\r
-    for puzzle in solved_puzzles:\r
-        if puzzle['type'] == 'meta':\r
-            meta = ' [META]'\r
-        else:\r
-            meta = ''\r
-        slack_url = channel_url(puzzle['channel_id'])\r
-        round_url = link(website + "_".join(rnd.split()) + "_round.html", puzzle['rounds'][0])\r
-        #assuming one round per puzzle for now\r
-        \r
-        solved_code += ['                    <tr>\n',\r
-         '                        <td>{}</td>\n'.format(elink(slack_url, puzzle['name']+meta)),\r
-         '                        <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),\r
-         '                        <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),\r
-         '                        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + '.html', 'Overview')),\r
-         '                        <td>{}</td>\n'.format(puzzle['solution']),\r
-         '                        <td>{}</td>\n'.format(round_url),\r
-         '                        <td>{}</td>\n'.format("".join(puzzle['tags'])),\r
-         '                    </tr>\n']\r
-    for puzzle in unsolved_puzzles:\r
-        if puzzle['type'] == 'meta':\r
-            meta = ' [META]'\r
-        else:\r
-            meta = ''\r
-        slack_url = channel_url(puzzle['channel_id'])\r
-        round_url = link(website + "_".join(rnd.split()) + "_round.html", puzzle['rounds'][0])\r
-        #assuming one round per puzzle for now\r
-        \r
-        unsolved_code += ['                    <tr>\n',\r
-         '                        <td>{}</td>\n'.format(elink(slack_url, puzzle['name']+meta)),\r
-         '                        <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),\r
-         '                        <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),\r
-         '                        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + '.html', 'Overview')),\r
-         '                        <td></td>\n',\r
-         '                        <td>{}</td>\n'.format(round_url),\r
-         '                        <td>{}</td>\n'.format("".join(puzzle['tags'])),\r
-         '                    </tr>\n']\r
-    end = ['                </tbody>\n',\r
-    '            </table>\n',\r
-    '        </div>\n',\r
-    '    </body>\n',\r
-    '</html>\n']\r
-    if filt == "All":\r
-        file1 = 'all.html'\r
-        f = open(file1, "w")\r
-        for line in start + unsolved_code + solved_code + end:\r
-            f.write(line)\r
-        f.close()\r
-    elif filt == "Solved":\r
-        file2 = 'solved.html'\r
-        f = open(file2, 'w')\r
-        for line in start + solved_code + end:\r
-            f.write(line)\r
-        f.close()\r
-    elif filt == "Unsolved":\r
-        file3 = 'unsolved.html'\r
-        f = open(file3, 'w')\r
-        for line in start + unsolved_code + end:\r
-            f.write(line)\r
-        f.close()\r
-    return None\r
-\r
-\r
-\r
-puzzles, rounds = hunt_info(turb, hunt)\r
-#I am not sure where these come from\r
-overview(puzzles, rounds)\r
-for rnd in rounds:\r
-    round_overview(rnd, puzzles)\r
-for puzzle in puzzles:\r
-    puzzle_overview(puzzle)\r
-puzzle_lists(puzzles, "All")\r
-puzzle_lists(puzzles, "Solved")\r
-puzzle_lists(puzzles, "Unsolved")
\ No newline at end of file
+# -*- coding: utf-8 -*-
+"""
+Created on Thu Jan  6 23:35:23 2022
+
+@author: Avram Gottschlich
+"""
+"""
+I copied several functions from your code; 
+if it's easier to refer to them rather than copying them that's absolutely fine
+
+This rewrites the html each time it is called
+If it's easy to call the puzzle/round functions each time they're updated,
+that would be great
+
+Requires sorttable.js, which should be included
+"""
+from turbot.channel import channel_url
+from boto3.dynamodb.conditions import Key
+
+website = "https://halibut.cworth.org/"
+#change this if we're using AWS or some other subdomain instead
+
+def find_hunt_for_hunt_id(turb, hunt_id):
+    """Given a hunt ID find the database item for that hunt
+
+    Returns None if hunt ID is not found, otherwise a
+    dictionary with all fields from the hunt's row in the table,
+    (channel_id, active, hunt_id, name, url, sheet_url, etc.).
+    """
+    response = turb.table.get_item(
+        Key={
+            'hunt_id': hunt_id,
+            'SK': 'hunt-{}'.format(hunt_id)
+            })
+
+    if 'Item' in response:
+        return response['Item']
+    else:
+        return None
+
+def hunt_puzzles_for_hunt_id(turb, hunt_id):
+    """Return all puzzles that belong to the given hunt_id"""
+
+    response = turb.table.query(
+        KeyConditionExpression=(
+            Key('hunt_id').eq(hunt_id) &
+            Key('SK').begins_with('puzzle-')
+            )
+        )
+
+    return response['Items']
+
+def elink(lin, text):
+    #shortcutting function for creating html links
+    #opens in a new tab for external links
+    return '<a href="{}" target="_blank" rel="noreferrer noopener">{}</a>'.format(lin, text)
+
+def link(lin, text):
+    #internal links, doesn't open new tab
+    return '<a href="{}">{}</a>'.format(lin, text)
+
+def hunt_info(turb, hunt):
+    """
+    Retrieves list of rounds, puzzles for the given hunt    
+    """
+    name = hunt["name"]
+    hunt_id = hunt["hunt_id"]
+    channel_id = hunt["channel_id"]
+    
+    puzzles = hunt_puzzles_for_hunt_id(turb, hunt_id)
+    
+    rounds = set()
+    for puzzle in puzzles:
+        if "rounds" not in puzzle:
+            continue
+        for rnd in puzzle["rounds"]:
+            rounds.add(rnd)
+    rounds = list(rounds)
+    rounds.sort()
+    
+    return puzzles, rounds
+
+def round_stat(rnd, puzzles):
+    #Counts puzzles, solved, list of puzzles for a given round
+    puzzle_count = 0
+    solved_count = 0
+    solved_puzzles = []
+    unsolved_puzzles = []
+    metas = []
+    meta_solved = 0
+    for puzzle in puzzles:
+        if "rounds" not in puzzle:
+            continue        
+        if rnd in puzzle["rounds"]:
+            if puzzle['type'] == 'meta':
+                metas.append(puzzle)
+                if puzzle['status'] == 'solved':
+                    meta_solved += 1
+            else:
+                puzzle_count += 1
+                if puzzle['status'] == 'solved':
+                    solved_count += 1
+                    solved_puzzles.append(puzzle)
+                else:
+                    unsolved_puzzles.append(puzzle)
+    solved_puzzles = sorted(solved_puzzles, key = lambda i: i['name'])
+    unsolved_puzzles = sorted(unsolved_puzzles, key = lambda i: i['name'])
+    rnd_puzzles = metas + unsolved_puzzles + solved_puzzles
+    return puzzle_count, solved_count, rnd_puzzles, meta_solved, len(metas)
+            
+   
+    
+def overview(puzzles, rounds):
+    #big board, main page. saves as index.html
+    start = ['<!DOCTYPE html>\n',
+     '<html>\n',
+     '<head>\n',
+     '  <meta charset="utf-8">\n',
+     '  <meta name="viewport" content="width=device-width, initial-scale=1">\n',
+     '\n',
+     '  <link rel="stylesheet" href="overview.css">\n',
+     '  <script type="text/javascript">\n',
+     '    // Hide all elements with class="containerTab", except for the one that matches the clickable grid column\n',
+     '    function openTab(tabName) {\n',
+     '      var i, x;\n',
+     '      x = document.getElementsByClassName("containerTab");\n',
+     '      for (i = 0; i < x.length; i++) {\n',
+     '        x[i].style.display = "none";\n',
+     '      }\n',
+     '      document.getElementById(tabName).style.display = "block";\n',
+     '    }\n',
+     '  </script>\n',
+     '\n',
+     '  <title>Hunt Overview</title>\n',
+     '  <script src="sorttable.js"></script>\n'
+     '</head>\n',
+     '    <div class="sidenav">\n'
+     '      <a href="index.html">Hunt Overview</a>'
+     '      <a href="all.html">All Puzzles</a>\n'
+     '      <a href="unsolved.html">Unsolved</a>\n'
+     '      <a href="solved.html">Solved</a>\n'
+     '    </div>\n'
+     '<body>\n',]
+    columns = ['  <div class="row">\n']
+    expanding = []
+    i = 1
+    for rnd in rounds:
+        puzzle_count, solved_count, rnd_puzzles, meta_solved, metas = round_stat(rnd, puzzles)
+        if metas == meta_solved and metas > 0:
+            status = 'solved'
+        else:
+            status = 'unsolved'
+        columns += ['    <div class="column {}" onclick="openTab(\'b{}\');">\n'.format(status, i),
+        '      <p>{}</p>\n'.format(rnd),
+        '      <p>Puzzles: {}/{}</p>\n'.format(solved_count, puzzle_count),
+        '      <p>Metas: {}/{}</p>\n'.format(meta_solved, metas),
+        '    </div>\n']
+        
+        expanding += [
+        '  <div id="b{}" class="containerTab {}" style="display:none;">\n'.format(i, status),
+        '    <span onclick="this.parentElement.style.display=\'none\'" class="closebtn">x</span>\n',
+        '    <h2>{}</h2>\n'.format(link(website + "_".join(rnd.split()) + "_round.html", rnd)),
+        '    <table class="sortable">\n',
+        '      <tr>\n',
+        '        <th><u>Puzzle</u></th>\n',
+        '        <th><u>Answer</u></th>\n',
+        '      </tr>\n',]
+
+        for puzzle in rnd_puzzles:
+            if puzzle['type'] == 'meta':
+                meta = ' [META]'
+            else:
+                meta = ''
+            if puzzle['status'] == 'solved':
+                expanding += ['      <tr class=\'solved\';>\n',
+                '        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + ".html", puzzle['name']+meta)),
+                '        <td>{}</td>\n'.format(puzzle['solution']),
+                '      </tr>\n']
+            else:
+                expanding += ['      <tr class=\'unsolved\';>\n',
+                '        <td><b>{}</b></td>\n'.format(link(website + "_".join(puzzle['name'].split()) + ".html", puzzle['name']+meta)),
+                '        <td></td>\n',
+                '      </tr>\n']
+        expanding.append('    </table>\n')
+        expanding.append('  </div>\n')
+        i += 1
+    columns.append('  </div>\n')
+    end = ['</body>\n', '</html>\n']
+    html = start + expanding + columns + end
+    file = "index.html"
+    f = open(file, "w")
+    for line in html:
+        f.write(line)
+    f.close()
+    return None
+
+def round_overview(rnd, puzzles):
+    #inputs: round name, puzzles
+    #round overview page
+    #saves as (round name)_round.html, in case meta/round share names.
+    #underscores replace spaces for links.
+    rnd_puzzles, meta_solved, metas = round_stat(rnd, puzzles)[2:]
+    if meta_solved == metas and metas > 0:
+        status = 'solved'
+    else:
+        status = 'unsolved'
+    start = ['<html>\n',
+     '    <head>\n',
+     '        <link rel="stylesheet" href="individual.css">\n',
+     '        <title>Mystery Hunt 2022</title>\n',
+     '        <script src="sorttable.js"></script>\n',
+     '    </head>\n',
+     '    <body class="{}">\n'.format(status),
+     '        <h1><b>{}</b></h1>\n'.format(rnd),
+     '        <p>{}</p>\n'.format(link(website + "index.html", 'Hunt Overview')),
+     '        <div>\n',
+     '            <table class="center sortable">\n',
+     '                <thead>\n',
+     '                    <tr>\n',
+     '                        <th>Puzzle Title/Slack</th>\n',
+     '                        <th>Puzzle Link</th>\n',
+     '                        <th>Sheet</th>\n',
+     '                        <th>Overview</th>\n',
+     '                        <th>Answer</th>\n',
+     #'                        <th>Extra Links</th>\n',
+     '                        <th>Tags</th>\n',
+     '                    </tr>\n',
+     '                </thead>\n',
+     '                <tbody>\n']
+    puzzle_list = []
+    for puzzle in rnd_puzzles:
+        if puzzle['type'] == 'meta':
+            meta = ' [META]'
+        else:
+            meta = ''
+        slack_url = channel_url(puzzle['channel_id'])
+        
+        if puzzle['status'] == 'solved':
+            puzzle_list += [ '                    <tr>\n',
+             '                        <td>{}</td>\n'.format(elink(slack_url, puzzle['name']+meta)),
+             '                        <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),
+             '                        <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),
+             '                        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + '.html', 'Overview')),
+             '                        <td>{}</td>\n'.format(puzzle['solution']),
+            # '                        <td></td>\n',
+             '                        <td>{}</td>\n'.format("".join(puzzle['tags'])),
+             '                    </tr>\n']
+        else:
+            puzzle_list += [ '                    <tr>\n',
+             '                        <td><b>{}</b></td>\n'.format(elink(slack_url, puzzle['name']+meta)),
+             '                        <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),
+             '                        <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),
+             '                        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + '.html', 'Overview')),
+             '                        <td></td>\n',
+            # '                        <td></td>\n',
+             '                        <td>{}</td>\n'.format(" ".join(puzzle['tags'])),
+             '                    </tr>\n']
+    end = ['                </tbody>\n',
+    '            </table>\n',
+    '        </div>\n',
+    '    </body>\n',
+    '</html>\n']
+    html = start + puzzle_list + end
+    file = "{}_round.html".format('_'.join(rnd.split()))
+    f = open(file, "w")
+    for line in html:
+        f.write(line)
+    f.close()
+    return None
+
+def puzzle_overview(puzzle):
+    #overview page for individual puzzles. saves as (name of puzzle).html,
+    #with underscores rather than spaces
+    name = puzzle['name']
+    if puzzle['type'] == 'meta':
+        meta = ' [META]'
+    else:
+        meta = ''
+    slack_url = channel_url(puzzle['channel_id'])
+    round_url = [link(website + "_".join(rnd.split()) + "_round.html", rnd) for rnd in puzzle['rounds']]
+    if puzzle['status'] == 'solved':
+        solution = puzzle['solution']
+        status = 'solved'
+    else:
+        solution = ""
+        status = 'unsolved'
+    html = ['<!DOCTYPE html>\n',
+     '<html>\n',
+     '<head>\n',
+     '    <meta charset="utf-8">\n',
+     '    <meta name="viewport" content="width=device-width, initial-scale=1">\n',
+     '    <link rel="stylesheet" href="individual.css">\n',
+     '    <title>{}</title>\n'.format(name+meta),
+     '    <p>{}</p>'.format(link(website + 'index.html', 'Hunt Overview')),
+     '\n',
+     '</head>\n',
+     '<body class="{}">\n'.format(status),
+     '    <h1>{}</h1>\n'.format(name+meta),
+     '    <div>\n',
+     '        <table class="center">\n',
+     '            <tr>\n',
+     '                <td>{}</td>\n'.format(elink(slack_url, 'Channel')), #slack channel
+     '                <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),
+     '                <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),
+     '                <td>Additional Resources</td>\n',
+     '            </tr>\n',
+     '        </table>\n',
+     '        <table class="center">\n',
+     '            <tr>\n',
+     '                <td>Round(s): {}</td>\n'.format(" ".join(round_url)), #round page on our site
+     '                <td>Tags: {}</td>\n'.format(" ".join(puzzle['tags'])), #add tags
+     '            </tr>\n',
+     '            <tr>\n',
+     '                <td>Answer: {}</td>\n'.format(solution),
+     '                <td>State: {}</td>\n'.format(puzzle['status']),
+     '            </tr>\n',
+     '        </table>\n',
+     '    </div>\n',
+     '\n',
+     '</body>\n',
+     '</html>\n']
+    underscored = "_".join(name.split())
+    file = "{}.html".format(underscored)
+    f = open(file, "w")
+    for line in html:
+        f.write(line)
+    return None
+
+def puzzle_lists(puzzles, filt):
+    #filt is one of "All", "Solved", "Unsolved" and spits out the appropriate list of puzzles
+    #generates pages for all puzzles, solved puzzles, unsolved puzzles
+    #saves as all/solved/unsolved.html, has a sidebar to link to each other and to the big board
+    solved_puzzles = [puzzle for puzzle in puzzles if puzzle['status'] == 'solved']
+    unsolved_puzzles = [puzzle for puzzle in puzzles if puzzle['status'] != 'solved']
+    start = ['<html>\n',
+     '    <head>\n',
+     '        <link rel="stylesheet" href="overview.css">\n',
+     '        <title>Mystery Hunt 2022</title>\n',
+     '        <script src="sorttable.js"></script>\n',
+     '    </head>\n',
+     '    <div class="sidenav">\n'
+     '      <a href="index.html">Hunt Overview</a>'
+     '      <a href="all.html">All Puzzles</a>\n'
+     '      <a href="unsolved.html">Unsolved</a>\n'
+     '      <a href="solved.html">Solved</a>\n'
+     '    </div>\n'
+     '    <body>\n',
+     '        <h1><b>{}</b></h1>\n'.format('{} Puzzles').format(filt),
+     '        <p>{}</p>\n'.format(link(website + "index.html", 'Hunt Overview')),
+     '        <div>\n',
+     '            <table class="center sortable">\n',
+     '                <thead>\n',
+     '                    <tr>\n',
+     '                        <th>Puzzle Title/Slack</th>\n',
+     '                        <th>Puzzle Link</th>\n',
+     '                        <th>Sheet</th>\n',
+     '                        <th>Overview</th>\n',
+     '                        <th>Answer</th>\n',
+     '                        <th>Round(s)</th>\n',
+     '                        <th>Tags</th>\n',
+     '                    </tr>\n',
+     '                </thead>\n',
+     '                <tbody>\n']
+    solved_code = []
+    unsolved_code = []
+    for puzzle in solved_puzzles:
+        if puzzle['type'] == 'meta':
+            meta = ' [META]'
+        else:
+            meta = ''
+        slack_url = channel_url(puzzle['channel_id'])
+        round_url = link(website + "_".join(rnd.split()) + "_round.html", puzzle['rounds'][0])
+        #assuming one round per puzzle for now
+        
+        solved_code += ['                    <tr>\n',
+         '                        <td>{}</td>\n'.format(elink(slack_url, puzzle['name']+meta)),
+         '                        <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),
+         '                        <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),
+         '                        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + '.html', 'Overview')),
+         '                        <td>{}</td>\n'.format(puzzle['solution']),
+         '                        <td>{}</td>\n'.format(round_url),
+         '                        <td>{}</td>\n'.format("".join(puzzle['tags'])),
+         '                    </tr>\n']
+    for puzzle in unsolved_puzzles:
+        if puzzle['type'] == 'meta':
+            meta = ' [META]'
+        else:
+            meta = ''
+        slack_url = channel_url(puzzle['channel_id'])
+        round_url = link(website + "_".join(rnd.split()) + "_round.html", puzzle['rounds'][0])
+        #assuming one round per puzzle for now
+        
+        unsolved_code += ['                    <tr>\n',
+         '                        <td>{}</td>\n'.format(elink(slack_url, puzzle['name']+meta)),
+         '                        <td>{}</td>\n'.format(elink(puzzle['url'], 'Puzzle')),
+         '                        <td>{}</td>\n'.format(elink(puzzle['sheet_url'], 'Sheet')),
+         '                        <td>{}</td>\n'.format(link(website + "_".join(puzzle['name'].split()) + '.html', 'Overview')),
+         '                        <td></td>\n',
+         '                        <td>{}</td>\n'.format(round_url),
+         '                        <td>{}</td>\n'.format("".join(puzzle['tags'])),
+         '                    </tr>\n']
+    end = ['                </tbody>\n',
+    '            </table>\n',
+    '        </div>\n',
+    '    </body>\n',
+    '</html>\n']
+    if filt == "All":
+        file1 = 'all.html'
+        f = open(file1, "w")
+        for line in start + unsolved_code + solved_code + end:
+            f.write(line)
+        f.close()
+    elif filt == "Solved":
+        file2 = 'solved.html'
+        f = open(file2, 'w')
+        for line in start + solved_code + end:
+            f.write(line)
+        f.close()
+    elif filt == "Unsolved":
+        file3 = 'unsolved.html'
+        f = open(file3, 'w')
+        for line in start + unsolved_code + end:
+            f.write(line)
+        f.close()
+    return None
+
+
+
+puzzles, rounds = hunt_info(turb, hunt)
+#I am not sure where these come from
+overview(puzzles, rounds)
+for rnd in rounds:
+    round_overview(rnd, puzzles)
+for puzzle in puzzles:
+    puzzle_overview(puzzle)
+puzzle_lists(puzzles, "All")
+puzzle_lists(puzzles, "Solved")
+puzzle_lists(puzzles, "Unsolved")
index b52593226d1f86ae158e52255d2bb4a9c3ab6221..f9ef4d2fc9593ddb4d2c495f3704d7d5d323755b 100644 (file)
@@ -1,66 +1,66 @@
-.solved {\r
-    background-color: chartreuse;\r
-}\r
-\r
-.unsolved {\r
-    background-color: orange;\r
-}\r
-\r
-table {\r
-    border-collapse: collapse;\r
-    margin: 30px;\r
-    text-align: center;\r
-    <!--font-size: 200%;-->\r
-\r
-}\r
-\r
-table td {\r
-    border: 1px solid black;\r
-    padding: 20px;\r
-    font-size: 150%;\r
-}\r
-\r
-\r
-h1 {\r
-    text-align: center;\r
-    font-size: 300%;\r
-}\r
-\r
-.center {\r
-    margin-left: auto;\r
-    margin-right: auto;\r
-}\r
-\r
-.row {\r
-    margin-left: -5px;\r
-    margin-right: -5px;\r
-}\r
-\r
-.column{\r
-    float: left;\r
-    width:  50%;\r
-    padding: 5px;\r
-}\r
-\r
-/* Clearfix (clear floats) */\r
-.row::after {\r
-  content: "";\r
-  clear: both;\r
-  display: table;\r
-}\r
-\r
-.grid-container {\r
-    display: grid;\r
-    grid-template-columns: auto auto auto;\r
-    grid-gap: 10px;\r
-    background-color: #2196F3;\r
-    padding: 10px;\r
-}\r
-\r
-.grid-container > div {\r
-    background-color: rgba(255, 255, 255, 0.8);\r
-    text-align: center;\r
-    padding: 20px 0;\r
-    font-size: 30px;\r
-}\r
-\r
+.solved {
+    background-color: chartreuse;
+}
+
+.unsolved {
+    background-color: orange;
+}
+
+table {
+    border-collapse: collapse;
+    margin: 30px;
+    text-align: center;
+    <!--font-size: 200%;-->
+
+}
+
+table td {
+    border: 1px solid black;
+    padding: 20px;
+    font-size: 150%;
+}
+
+
+h1 {
+    text-align: center;
+    font-size: 300%;
+}
+
+.center {
+    margin-left: auto;
+    margin-right: auto;
+}
+
+.row {
+    margin-left: -5px;
+    margin-right: -5px;
+}
+
+.column{
+    float: left;
+    width:  50%;
+    padding: 5px;
+}
+
+/* Clearfix (clear floats) */
+.row::after {
+  content: "";
+  clear: both;
+  display: table;
+}
+
+.grid-container {
+    display: grid;
+    grid-template-columns: auto auto auto;
+    grid-gap: 10px;
+    background-color: #2196F3;
+    padding: 10px;
+}
+
+.grid-container > div {
+    background-color: rgba(255, 255, 255, 0.8);
+    text-align: center;
+    padding: 20px 0;
+    font-size: 30px;
+}
+
index b3061da6d1300230532ee4f183e18e5f36defc97..8426fb2046f4749678faced5cf48782366ec3523 100644 (file)
@@ -1,94 +1,94 @@
-/* The grid: Three equal columns that floats next to each other */\r
-.column {\r
-  float: left;\r
-  width: 15%;\r
-  padding: 25px;\r
-  text-align: center;\r
-  font-size: 20px;\r
-  cursor: pointer;\r
-  color: black;\r
-  border-radius: 25px;\r
-  margin: 25px;\r
-}\r
-\r
-.containerTab {\r
-  padding: 20px;\r
-  color: black;\r
-  border-radius: 25px;\r
-  margin: auto;\r
-  width: 20%;\r
-\r
-\r
-}\r
-\r
-/* Clear floats after the columns */\r
-.row:after {\r
-  content: "";\r
-  display: table;\r
-  clear: both;\r
-}\r
-\r
-/* Closable button inside the image */\r
-.closebtn {\r
-  float: right;\r
-  color: black;\r
-  font-size: 35px;\r
-  cursor: pointer;\r
-}\r
-\r
-table {\r
-  color: black;\r
-  padding: 5px;\r
-}\r
-\r
-th, td {\r
-  padding: 5px;\r
-}\r
-\r
-.solved {\r
-  background-color: chartreuse;\r
-}\r
-\r
-.unsolved {\r
-  background-color: orange;\r
-}\r
-\r
-/* The sidebar menu */\r
-.sidenav {\r
-  height: 100%; /* Full-height: remove this if you want "auto" height */\r
-  width: 160px; /* Set the width of the sidebar */\r
-  position: fixed; /* Fixed Sidebar (stay in place on scroll) */\r
-  z-index: 1; /* Stay on top */\r
-  top: 0; /* Stay at the top */\r
-  left: 0;\r
-  background-color: #111; /* Black */\r
-  overflow-x: hidden; /* Disable horizontal scroll */\r
-  padding-top: 20px;\r
-}\r
-\r
-/* The navigation menu links */\r
-.sidenav a {\r
-  padding: 6px 8px 6px 16px;\r
-  text-decoration: none;\r
-  font-size: 25px;\r
-  color: #818181;\r
-  display: block;\r
-}\r
-\r
-/* When you mouse over the navigation links, change their color */\r
-.sidenav a:hover {\r
-  color: #f1f1f1;\r
-}\r
-\r
-/* Style page content */\r
-body {\r
-  margin-left: 160px; /* Same as the width of the sidebar */\r
-  padding: 0px 10px;\r
-  background-color: #BBB;\r
-}\r
-\r
-/* On smaller screens, where height is less than 450px, change the style of the sidebar (less padding and a smaller font size) */\r
-@media screen and (max-height: 450px) {\r
-  .sidenav {padding-top: 15px;}\r
-  .sidenav a {font-size: 18px;}\r
-}\r
+/* The grid: Three equal columns that floats next to each other */
+.column {
+  float: left;
+  width: 15%;
+  padding: 25px;
+  text-align: center;
+  font-size: 20px;
+  cursor: pointer;
+  color: black;
+  border-radius: 25px;
+  margin: 25px;
+}
+
+.containerTab {
+  padding: 20px;
+  color: black;
+  border-radius: 25px;
+  margin: auto;
+  width: 20%;
+
+
+}
+
+/* Clear floats after the columns */
+.row:after {
+  content: "";
+  display: table;
+  clear: both;
+}
+
+/* Closable button inside the image */
+.closebtn {
+  float: right;
+  color: black;
+  font-size: 35px;
+  cursor: pointer;
+}
+
+table {
+  color: black;
+  padding: 5px;
+}
+
+th, td {
+  padding: 5px;
+}
+
+.solved {
+  background-color: chartreuse;
+}
+
+.unsolved {
+  background-color: orange;
+}
+
+/* The sidebar menu */
+.sidenav {
+  height: 100%; /* Full-height: remove this if you want "auto" height */
+  width: 160px; /* Set the width of the sidebar */
+  position: fixed; /* Fixed Sidebar (stay in place on scroll) */
+  z-index: 1; /* Stay on top */
+  top: 0; /* Stay at the top */
+  left: 0;
+  background-color: #111; /* Black */
+  overflow-x: hidden; /* Disable horizontal scroll */
+  padding-top: 20px;
+}
+
+/* The navigation menu links */
+.sidenav a {
+  padding: 6px 8px 6px 16px;
+  text-decoration: none;
+  font-size: 25px;
+  color: #818181;
+  display: block;
+}
+
+/* When you mouse over the navigation links, change their color */
+.sidenav a:hover {
+  color: #f1f1f1;
+}
+
+/* Style page content */
+body {
+  margin-left: 160px; /* Same as the width of the sidebar */
+  padding: 0px 10px;
+  background-color: #BBB;
+}
+
+/* On smaller screens, where height is less than 450px, change the style of the sidebar (less padding and a smaller font size) */
+@media screen and (max-height: 450px) {
+  .sidenav {padding-top: 15px;}
+  .sidenav a {font-size: 18px;}
+}
index d75609fddd7646cdd9474a1962d6961b83b71e7d..029ebfe413723588d3483ffeab39ce2c7e1b24d5 100644 (file)
-/*\r
-  SortTable\r
-  version 2\r
-  7th April 2007\r
-  Stuart Langridge, http://www.kryogenix.org/code/browser/sorttable/\r
-\r
-  Instructions:\r
-  Download this file\r
-  Add <script src="sorttable.js"></script> to your HTML\r
-  Add class="sortable" to any table you'd like to make sortable\r
-  Click on the headers to sort\r
-\r
-  Thanks to many, many people for contributions and suggestions.\r
-  Licenced as X11: http://www.kryogenix.org/code/browser/licence.html\r
-  This basically means: do what you want with it.\r
-*/\r
-\r
-\r
-var stIsIE = /*@cc_on!@*/false;\r
-\r
-sorttable = {\r
-  init: function() {\r
-    // quit if this function has already been called\r
-    if (arguments.callee.done) return;\r
-    // flag this function so we don't do the same thing twice\r
-    arguments.callee.done = true;\r
-    // kill the timer\r
-    if (_timer) clearInterval(_timer);\r
-\r
-    if (!document.createElement || !document.getElementsByTagName) return;\r
-\r
-    sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/;\r
-\r
-    forEach(document.getElementsByTagName('table'), function(table) {\r
-      if (table.className.search(/\bsortable\b/) != -1) {\r
-        sorttable.makeSortable(table);\r
-      }\r
-    });\r
-\r
-  },\r
-\r
-  makeSortable: function(table) {\r
-    if (table.getElementsByTagName('thead').length == 0) {\r
-      // table doesn't have a tHead. Since it should have, create one and\r
-      // put the first table row in it.\r
-      the = document.createElement('thead');\r
-      the.appendChild(table.rows[0]);\r
-      table.insertBefore(the,table.firstChild);\r
-    }\r
-    // Safari doesn't support table.tHead, sigh\r
-    if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0];\r
-\r
-    if (table.tHead.rows.length != 1) return; // can't cope with two header rows\r
-\r
-    // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as\r
-    // "total" rows, for example). This is B&R, since what you're supposed\r
-    // to do is put them in a tfoot. So, if there are sortbottom rows,\r
-    // for backwards compatibility, move them to tfoot (creating it if needed).\r
-    sortbottomrows = [];\r
-    for (var i=0; i<table.rows.length; i++) {\r
-      if (table.rows[i].className.search(/\bsortbottom\b/) != -1) {\r
-        sortbottomrows[sortbottomrows.length] = table.rows[i];\r
-      }\r
-    }\r
-    if (sortbottomrows) {\r
-      if (table.tFoot == null) {\r
-        // table doesn't have a tfoot. Create one.\r
-        tfo = document.createElement('tfoot');\r
-        table.appendChild(tfo);\r
-      }\r
-      for (var i=0; i<sortbottomrows.length; i++) {\r
-        tfo.appendChild(sortbottomrows[i]);\r
-      }\r
-      delete sortbottomrows;\r
-    }\r
-\r
-    // work through each column and calculate its type\r
-    headrow = table.tHead.rows[0].cells;\r
-    for (var i=0; i<headrow.length; i++) {\r
-      // manually override the type with a sorttable_type attribute\r
-      if (!headrow[i].className.match(/\bsorttable_nosort\b/)) { // skip this col\r
-        mtch = headrow[i].className.match(/\bsorttable_([a-z0-9]+)\b/);\r
-        if (mtch) { override = mtch[1]; }\r
-          if (mtch && typeof sorttable["sort_"+override] == 'function') {\r
-            headrow[i].sorttable_sortfunction = sorttable["sort_"+override];\r
-          } else {\r
-            headrow[i].sorttable_sortfunction = sorttable.guessType(table,i);\r
-          }\r
-          // make it clickable to sort\r
-          headrow[i].sorttable_columnindex = i;\r
-          headrow[i].sorttable_tbody = table.tBodies[0];\r
-          dean_addEvent(headrow[i],"click", sorttable.innerSortFunction = function(e) {\r
-\r
-          if (this.className.search(/\bsorttable_sorted\b/) != -1) {\r
-            // if we're already sorted by this column, just\r
-            // reverse the table, which is quicker\r
-            sorttable.reverse(this.sorttable_tbody);\r
-            this.className = this.className.replace('sorttable_sorted',\r
-                                                    'sorttable_sorted_reverse');\r
-            this.removeChild(document.getElementById('sorttable_sortfwdind'));\r
-            sortrevind = document.createElement('span');\r
-            sortrevind.id = "sorttable_sortrevind";\r
-            sortrevind.innerHTML = stIsIE ? '&nbsp<font face="webdings">5</font>' : '&nbsp;&#x25B4;';\r
-            this.appendChild(sortrevind);\r
-            return;\r
-          }\r
-          if (this.className.search(/\bsorttable_sorted_reverse\b/) != -1) {\r
-            // if we're already sorted by this column in reverse, just\r
-            // re-reverse the table, which is quicker\r
-            sorttable.reverse(this.sorttable_tbody);\r
-            this.className = this.className.replace('sorttable_sorted_reverse',\r
-                                                    'sorttable_sorted');\r
-            this.removeChild(document.getElementById('sorttable_sortrevind'));\r
-            sortfwdind = document.createElement('span');\r
-            sortfwdind.id = "sorttable_sortfwdind";\r
-            sortfwdind.innerHTML = stIsIE ? '&nbsp<font face="webdings">6</font>' : '&nbsp;&#x25BE;';\r
-            this.appendChild(sortfwdind);\r
-            return;\r
-          }\r
-\r
-          // remove sorttable_sorted classes\r
-          theadrow = this.parentNode;\r
-          forEach(theadrow.childNodes, function(cell) {\r
-            if (cell.nodeType == 1) { // an element\r
-              cell.className = cell.className.replace('sorttable_sorted_reverse','');\r
-              cell.className = cell.className.replace('sorttable_sorted','');\r
-            }\r
-          });\r
-          sortfwdind = document.getElementById('sorttable_sortfwdind');\r
-          if (sortfwdind) { sortfwdind.parentNode.removeChild(sortfwdind); }\r
-          sortrevind = document.getElementById('sorttable_sortrevind');\r
-          if (sortrevind) { sortrevind.parentNode.removeChild(sortrevind); }\r
-\r
-          this.className += ' sorttable_sorted';\r
-          sortfwdind = document.createElement('span');\r
-          sortfwdind.id = "sorttable_sortfwdind";\r
-          sortfwdind.innerHTML = stIsIE ? '&nbsp<font face="webdings">6</font>' : '&nbsp;&#x25BE;';\r
-          this.appendChild(sortfwdind);\r
-\r
-            // build an array to sort. This is a Schwartzian transform thing,\r
-            // i.e., we "decorate" each row with the actual sort key,\r
-            // sort based on the sort keys, and then put the rows back in order\r
-            // which is a lot faster because you only do getInnerText once per row\r
-            row_array = [];\r
-            col = this.sorttable_columnindex;\r
-            rows = this.sorttable_tbody.rows;\r
-            for (var j=0; j<rows.length; j++) {\r
-              row_array[row_array.length] = [sorttable.getInnerText(rows[j].cells[col]), rows[j]];\r
-            }\r
-            /* If you want a stable sort, uncomment the following line */\r
-            //sorttable.shaker_sort(row_array, this.sorttable_sortfunction);\r
-            /* and comment out this one */\r
-            row_array.sort(this.sorttable_sortfunction);\r
-\r
-            tb = this.sorttable_tbody;\r
-            for (var j=0; j<row_array.length; j++) {\r
-              tb.appendChild(row_array[j][1]);\r
-            }\r
-\r
-            delete row_array;\r
-          });\r
-        }\r
-    }\r
-  },\r
-\r
-  guessType: function(table, column) {\r
-    // guess the type of a column based on its first non-blank row\r
-    sortfn = sorttable.sort_alpha;\r
-    for (var i=0; i<table.tBodies[0].rows.length; i++) {\r
-      text = sorttable.getInnerText(table.tBodies[0].rows[i].cells[column]);\r
-      if (text != '') {\r
-        if (text.match(/^-?[£$¤]?[\d,.]+%?$/)) {\r
-          return sorttable.sort_numeric;\r
-        }\r
-        // check for a date: dd/mm/yyyy or dd/mm/yy\r
-        // can have / or . or - as separator\r
-        // can be mm/dd as well\r
-        possdate = text.match(sorttable.DATE_RE)\r
-        if (possdate) {\r
-          // looks like a date\r
-          first = parseInt(possdate[1]);\r
-          second = parseInt(possdate[2]);\r
-          if (first > 12) {\r
-            // definitely dd/mm\r
-            return sorttable.sort_ddmm;\r
-          } else if (second > 12) {\r
-            return sorttable.sort_mmdd;\r
-          } else {\r
-            // looks like a date, but we can't tell which, so assume\r
-            // that it's dd/mm (English imperialism!) and keep looking\r
-            sortfn = sorttable.sort_ddmm;\r
-          }\r
-        }\r
-      }\r
-    }\r
-    return sortfn;\r
-  },\r
-\r
-  getInnerText: function(node) {\r
-    // gets the text we want to use for sorting for a cell.\r
-    // strips leading and trailing whitespace.\r
-    // this is *not* a generic getInnerText function; it's special to sorttable.\r
-    // for example, you can override the cell text with a customkey attribute.\r
-    // it also gets .value for <input> fields.\r
-\r
-    if (!node) return "";\r
-\r
-    hasInputs = (typeof node.getElementsByTagName == 'function') &&\r
-                 node.getElementsByTagName('input').length;\r
-\r
-    if (node.getAttribute("sorttable_customkey") != null) {\r
-      return node.getAttribute("sorttable_customkey");\r
-    }\r
-    else if (typeof node.textContent != 'undefined' && !hasInputs) {\r
-      return node.textContent.replace(/^\s+|\s+$/g, '');\r
-    }\r
-    else if (typeof node.innerText != 'undefined' && !hasInputs) {\r
-      return node.innerText.replace(/^\s+|\s+$/g, '');\r
-    }\r
-    else if (typeof node.text != 'undefined' && !hasInputs) {\r
-      return node.text.replace(/^\s+|\s+$/g, '');\r
-    }\r
-    else {\r
-      switch (node.nodeType) {\r
-        case 3:\r
-          if (node.nodeName.toLowerCase() == 'input') {\r
-            return node.value.replace(/^\s+|\s+$/g, '');\r
-          }\r
-        case 4:\r
-          return node.nodeValue.replace(/^\s+|\s+$/g, '');\r
-          break;\r
-        case 1:\r
-        case 11:\r
-          var innerText = '';\r
-          for (var i = 0; i < node.childNodes.length; i++) {\r
-            innerText += sorttable.getInnerText(node.childNodes[i]);\r
-          }\r
-          return innerText.replace(/^\s+|\s+$/g, '');\r
-          break;\r
-        default:\r
-          return '';\r
-      }\r
-    }\r
-  },\r
-\r
-  reverse: function(tbody) {\r
-    // reverse the rows in a tbody\r
-    newrows = [];\r
-    for (var i=0; i<tbody.rows.length; i++) {\r
-      newrows[newrows.length] = tbody.rows[i];\r
-    }\r
-    for (var i=newrows.length-1; i>=0; i--) {\r
-       tbody.appendChild(newrows[i]);\r
-    }\r
-    delete newrows;\r
-  },\r
-\r
-  /* sort functions\r
-     each sort function takes two parameters, a and b\r
-     you are comparing a[0] and b[0] */\r
-  sort_numeric: function(a,b) {\r
-    aa = parseFloat(a[0].replace(/[^0-9.-]/g,''));\r
-    if (isNaN(aa)) aa = 0;\r
-    bb = parseFloat(b[0].replace(/[^0-9.-]/g,''));\r
-    if (isNaN(bb)) bb = 0;\r
-    return aa-bb;\r
-  },\r
-  sort_alpha: function(a,b) {\r
-    if (a[0]==b[0]) return 0;\r
-    if (a[0]<b[0]) return -1;\r
-    return 1;\r
-  },\r
-  sort_ddmm: function(a,b) {\r
-    mtch = a[0].match(sorttable.DATE_RE);\r
-    y = mtch[3]; m = mtch[2]; d = mtch[1];\r
-    if (m.length == 1) m = '0'+m;\r
-    if (d.length == 1) d = '0'+d;\r
-    dt1 = y+m+d;\r
-    mtch = b[0].match(sorttable.DATE_RE);\r
-    y = mtch[3]; m = mtch[2]; d = mtch[1];\r
-    if (m.length == 1) m = '0'+m;\r
-    if (d.length == 1) d = '0'+d;\r
-    dt2 = y+m+d;\r
-    if (dt1==dt2) return 0;\r
-    if (dt1<dt2) return -1;\r
-    return 1;\r
-  },\r
-  sort_mmdd: function(a,b) {\r
-    mtch = a[0].match(sorttable.DATE_RE);\r
-    y = mtch[3]; d = mtch[2]; m = mtch[1];\r
-    if (m.length == 1) m = '0'+m;\r
-    if (d.length == 1) d = '0'+d;\r
-    dt1 = y+m+d;\r
-    mtch = b[0].match(sorttable.DATE_RE);\r
-    y = mtch[3]; d = mtch[2]; m = mtch[1];\r
-    if (m.length == 1) m = '0'+m;\r
-    if (d.length == 1) d = '0'+d;\r
-    dt2 = y+m+d;\r
-    if (dt1==dt2) return 0;\r
-    if (dt1<dt2) return -1;\r
-    return 1;\r
-  },\r
-\r
-  shaker_sort: function(list, comp_func) {\r
-    // A stable sort function to allow multi-level sorting of data\r
-    // see: http://en.wikipedia.org/wiki/Cocktail_sort\r
-    // thanks to Joseph Nahmias\r
-    var b = 0;\r
-    var t = list.length - 1;\r
-    var swap = true;\r
-\r
-    while(swap) {\r
-        swap = false;\r
-        for(var i = b; i < t; ++i) {\r
-            if ( comp_func(list[i], list[i+1]) > 0 ) {\r
-                var q = list[i]; list[i] = list[i+1]; list[i+1] = q;\r
-                swap = true;\r
-            }\r
-        } // for\r
-        t--;\r
-\r
-        if (!swap) break;\r
-\r
-        for(var i = t; i > b; --i) {\r
-            if ( comp_func(list[i], list[i-1]) < 0 ) {\r
-                var q = list[i]; list[i] = list[i-1]; list[i-1] = q;\r
-                swap = true;\r
-            }\r
-        } // for\r
-        b++;\r
-\r
-    } // while(swap)\r
-  }\r
-}\r
-\r
-/* ******************************************************************\r
-   Supporting functions: bundled here to avoid depending on a library\r
-   ****************************************************************** */\r
-\r
-// Dean Edwards/Matthias Miller/John Resig\r
-\r
-/* for Mozilla/Opera9 */\r
-if (document.addEventListener) {\r
-    document.addEventListener("DOMContentLoaded", sorttable.init, false);\r
-}\r
-\r
-/* for Internet Explorer */\r
-/*@cc_on @*/\r
-/*@if (@_win32)\r
-    document.write("<script id=__ie_onload defer src=javascript:void(0)><\/script>");\r
-    var script = document.getElementById("__ie_onload");\r
-    script.onreadystatechange = function() {\r
-        if (this.readyState == "complete") {\r
-            sorttable.init(); // call the onload handler\r
-        }\r
-    };\r
-/*@end @*/\r
-\r
-/* for Safari */\r
-if (/WebKit/i.test(navigator.userAgent)) { // sniff\r
-    var _timer = setInterval(function() {\r
-        if (/loaded|complete/.test(document.readyState)) {\r
-            sorttable.init(); // call the onload handler\r
-        }\r
-    }, 10);\r
-}\r
-\r
-/* for other browsers */\r
-window.onload = sorttable.init;\r
-\r
-// written by Dean Edwards, 2005\r
-// with input from Tino Zijdel, Matthias Miller, Diego Perini\r
-\r
-// http://dean.edwards.name/weblog/2005/10/add-event/\r
-\r
-function dean_addEvent(element, type, handler) {\r
-    if (element.addEventListener) {\r
-        element.addEventListener(type, handler, false);\r
-    } else {\r
-        // assign each event handler a unique ID\r
-        if (!handler.$$guid) handler.$$guid = dean_addEvent.guid++;\r
-        // create a hash table of event types for the element\r
-        if (!element.events) element.events = {};\r
-        // create a hash table of event handlers for each element/event pair\r
-        var handlers = element.events[type];\r
-        if (!handlers) {\r
-            handlers = element.events[type] = {};\r
-            // store the existing event handler (if there is one)\r
-            if (element["on" + type]) {\r
-                handlers[0] = element["on" + type];\r
-            }\r
-        }\r
-        // store the event handler in the hash table\r
-        handlers[handler.$$guid] = handler;\r
-        // assign a global event handler to do all the work\r
-        element["on" + type] = handleEvent;\r
-    }\r
-};\r
-// a counter used to create unique IDs\r
-dean_addEvent.guid = 1;\r
-\r
-function removeEvent(element, type, handler) {\r
-    if (element.removeEventListener) {\r
-        element.removeEventListener(type, handler, false);\r
-    } else {\r
-        // delete the event handler from the hash table\r
-        if (element.events && element.events[type]) {\r
-            delete element.events[type][handler.$$guid];\r
-        }\r
-    }\r
-};\r
-\r
-function handleEvent(event) {\r
-    var returnValue = true;\r
-    // grab the event object (IE uses a global event object)\r
-    event = event || fixEvent(((this.ownerDocument || this.document || this).parentWindow || window).event);\r
-    // get a reference to the hash table of event handlers\r
-    var handlers = this.events[event.type];\r
-    // execute each event handler\r
-    for (var i in handlers) {\r
-        this.$$handleEvent = handlers[i];\r
-        if (this.$$handleEvent(event) === false) {\r
-            returnValue = false;\r
-        }\r
-    }\r
-    return returnValue;\r
-};\r
-\r
-function fixEvent(event) {\r
-    // add W3C standard event methods\r
-    event.preventDefault = fixEvent.preventDefault;\r
-    event.stopPropagation = fixEvent.stopPropagation;\r
-    return event;\r
-};\r
-fixEvent.preventDefault = function() {\r
-    this.returnValue = false;\r
-};\r
-fixEvent.stopPropagation = function() {\r
-  this.cancelBubble = true;\r
-}\r
-\r
-// Dean's forEach: http://dean.edwards.name/base/forEach.js\r
-/*\r
-    forEach, version 1.0\r
-    Copyright 2006, Dean Edwards\r
-    License: http://www.opensource.org/licenses/mit-license.php\r
-*/\r
-\r
-// array-like enumeration\r
-if (!Array.forEach) { // mozilla already supports this\r
-    Array.forEach = function(array, block, context) {\r
-        for (var i = 0; i < array.length; i++) {\r
-            block.call(context, array[i], i, array);\r
-        }\r
-    };\r
-}\r
-\r
-// generic enumeration\r
-Function.prototype.forEach = function(object, block, context) {\r
-    for (var key in object) {\r
-        if (typeof this.prototype[key] == "undefined") {\r
-            block.call(context, object[key], key, object);\r
-        }\r
-    }\r
-};\r
-\r
-// character enumeration\r
-String.forEach = function(string, block, context) {\r
-    Array.forEach(string.split(""), function(chr, index) {\r
-        block.call(context, chr, index, string);\r
-    });\r
-};\r
-\r
-// globally resolve forEach enumeration\r
-var forEach = function(object, block, context) {\r
-    if (object) {\r
-        var resolve = Object; // default\r
-        if (object instanceof Function) {\r
-            // functions have a "length" property\r
-            resolve = Function;\r
-        } else if (object.forEach instanceof Function) {\r
-            // the object implements a custom forEach method so use that\r
-            object.forEach(block, context);\r
-            return;\r
-        } else if (typeof object == "string") {\r
-            // the object is a string\r
-            resolve = String;\r
-        } else if (typeof object.length == "number") {\r
-            // the object is array-like\r
-            resolve = Array;\r
-        }\r
-        resolve.forEach(object, block, context);\r
-    }\r
-};\r
+/*
+  SortTable
+  version 2
+  7th April 2007
+  Stuart Langridge, http://www.kryogenix.org/code/browser/sorttable/
+
+  Instructions:
+  Download this file
+  Add <script src="sorttable.js"></script> to your HTML
+  Add class="sortable" to any table you'd like to make sortable
+  Click on the headers to sort
+
+  Thanks to many, many people for contributions and suggestions.
+  Licenced as X11: http://www.kryogenix.org/code/browser/licence.html
+  This basically means: do what you want with it.
+*/
+
+
+var stIsIE = /*@cc_on!@*/false;
+
+sorttable = {
+  init: function() {
+    // quit if this function has already been called
+    if (arguments.callee.done) return;
+    // flag this function so we don't do the same thing twice
+    arguments.callee.done = true;
+    // kill the timer
+    if (_timer) clearInterval(_timer);
+
+    if (!document.createElement || !document.getElementsByTagName) return;
+
+    sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/;
+
+    forEach(document.getElementsByTagName('table'), function(table) {
+      if (table.className.search(/\bsortable\b/) != -1) {
+        sorttable.makeSortable(table);
+      }
+    });
+
+  },
+
+  makeSortable: function(table) {
+    if (table.getElementsByTagName('thead').length == 0) {
+      // table doesn't have a tHead. Since it should have, create one and
+      // put the first table row in it.
+      the = document.createElement('thead');
+      the.appendChild(table.rows[0]);
+      table.insertBefore(the,table.firstChild);
+    }
+    // Safari doesn't support table.tHead, sigh
+    if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0];
+
+    if (table.tHead.rows.length != 1) return; // can't cope with two header rows
+
+    // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as
+    // "total" rows, for example). This is B&R, since what you're supposed
+    // to do is put them in a tfoot. So, if there are sortbottom rows,
+    // for backwards compatibility, move them to tfoot (creating it if needed).
+    sortbottomrows = [];
+    for (var i=0; i<table.rows.length; i++) {
+      if (table.rows[i].className.search(/\bsortbottom\b/) != -1) {
+        sortbottomrows[sortbottomrows.length] = table.rows[i];
+      }
+    }
+    if (sortbottomrows) {
+      if (table.tFoot == null) {
+        // table doesn't have a tfoot. Create one.
+        tfo = document.createElement('tfoot');
+        table.appendChild(tfo);
+      }
+      for (var i=0; i<sortbottomrows.length; i++) {
+        tfo.appendChild(sortbottomrows[i]);
+      }
+      delete sortbottomrows;
+    }
+
+    // work through each column and calculate its type
+    headrow = table.tHead.rows[0].cells;
+    for (var i=0; i<headrow.length; i++) {
+      // manually override the type with a sorttable_type attribute
+      if (!headrow[i].className.match(/\bsorttable_nosort\b/)) { // skip this col
+        mtch = headrow[i].className.match(/\bsorttable_([a-z0-9]+)\b/);
+        if (mtch) { override = mtch[1]; }
+          if (mtch && typeof sorttable["sort_"+override] == 'function') {
+            headrow[i].sorttable_sortfunction = sorttable["sort_"+override];
+          } else {
+            headrow[i].sorttable_sortfunction = sorttable.guessType(table,i);
+          }
+          // make it clickable to sort
+          headrow[i].sorttable_columnindex = i;
+          headrow[i].sorttable_tbody = table.tBodies[0];
+          dean_addEvent(headrow[i],"click", sorttable.innerSortFunction = function(e) {
+
+          if (this.className.search(/\bsorttable_sorted\b/) != -1) {
+            // if we're already sorted by this column, just
+            // reverse the table, which is quicker
+            sorttable.reverse(this.sorttable_tbody);
+            this.className = this.className.replace('sorttable_sorted',
+                                                    'sorttable_sorted_reverse');
+            this.removeChild(document.getElementById('sorttable_sortfwdind'));
+            sortrevind = document.createElement('span');
+            sortrevind.id = "sorttable_sortrevind";
+            sortrevind.innerHTML = stIsIE ? '&nbsp<font face="webdings">5</font>' : '&nbsp;&#x25B4;';
+            this.appendChild(sortrevind);
+            return;
+          }
+          if (this.className.search(/\bsorttable_sorted_reverse\b/) != -1) {
+            // if we're already sorted by this column in reverse, just
+            // re-reverse the table, which is quicker
+            sorttable.reverse(this.sorttable_tbody);
+            this.className = this.className.replace('sorttable_sorted_reverse',
+                                                    'sorttable_sorted');
+            this.removeChild(document.getElementById('sorttable_sortrevind'));
+            sortfwdind = document.createElement('span');
+            sortfwdind.id = "sorttable_sortfwdind";
+            sortfwdind.innerHTML = stIsIE ? '&nbsp<font face="webdings">6</font>' : '&nbsp;&#x25BE;';
+            this.appendChild(sortfwdind);
+            return;
+          }
+
+          // remove sorttable_sorted classes
+          theadrow = this.parentNode;
+          forEach(theadrow.childNodes, function(cell) {
+            if (cell.nodeType == 1) { // an element
+              cell.className = cell.className.replace('sorttable_sorted_reverse','');
+              cell.className = cell.className.replace('sorttable_sorted','');
+            }
+          });
+          sortfwdind = document.getElementById('sorttable_sortfwdind');
+          if (sortfwdind) { sortfwdind.parentNode.removeChild(sortfwdind); }
+          sortrevind = document.getElementById('sorttable_sortrevind');
+          if (sortrevind) { sortrevind.parentNode.removeChild(sortrevind); }
+
+          this.className += ' sorttable_sorted';
+          sortfwdind = document.createElement('span');
+          sortfwdind.id = "sorttable_sortfwdind";
+          sortfwdind.innerHTML = stIsIE ? '&nbsp<font face="webdings">6</font>' : '&nbsp;&#x25BE;';
+          this.appendChild(sortfwdind);
+
+            // build an array to sort. This is a Schwartzian transform thing,
+            // i.e., we "decorate" each row with the actual sort key,
+            // sort based on the sort keys, and then put the rows back in order
+            // which is a lot faster because you only do getInnerText once per row
+            row_array = [];
+            col = this.sorttable_columnindex;
+            rows = this.sorttable_tbody.rows;
+            for (var j=0; j<rows.length; j++) {
+              row_array[row_array.length] = [sorttable.getInnerText(rows[j].cells[col]), rows[j]];
+            }
+            /* If you want a stable sort, uncomment the following line */
+            //sorttable.shaker_sort(row_array, this.sorttable_sortfunction);
+            /* and comment out this one */
+            row_array.sort(this.sorttable_sortfunction);
+
+            tb = this.sorttable_tbody;
+            for (var j=0; j<row_array.length; j++) {
+              tb.appendChild(row_array[j][1]);
+            }
+
+            delete row_array;
+          });
+        }
+    }
+  },
+
+  guessType: function(table, column) {
+    // guess the type of a column based on its first non-blank row
+    sortfn = sorttable.sort_alpha;
+    for (var i=0; i<table.tBodies[0].rows.length; i++) {
+      text = sorttable.getInnerText(table.tBodies[0].rows[i].cells[column]);
+      if (text != '') {
+        if (text.match(/^-?[£$¤]?[\d,.]+%?$/)) {
+          return sorttable.sort_numeric;
+        }
+        // check for a date: dd/mm/yyyy or dd/mm/yy
+        // can have / or . or - as separator
+        // can be mm/dd as well
+        possdate = text.match(sorttable.DATE_RE)
+        if (possdate) {
+          // looks like a date
+          first = parseInt(possdate[1]);
+          second = parseInt(possdate[2]);
+          if (first > 12) {
+            // definitely dd/mm
+            return sorttable.sort_ddmm;
+          } else if (second > 12) {
+            return sorttable.sort_mmdd;
+          } else {
+            // looks like a date, but we can't tell which, so assume
+            // that it's dd/mm (English imperialism!) and keep looking
+            sortfn = sorttable.sort_ddmm;
+          }
+        }
+      }
+    }
+    return sortfn;
+  },
+
+  getInnerText: function(node) {
+    // gets the text we want to use for sorting for a cell.
+    // strips leading and trailing whitespace.
+    // this is *not* a generic getInnerText function; it's special to sorttable.
+    // for example, you can override the cell text with a customkey attribute.
+    // it also gets .value for <input> fields.
+
+    if (!node) return "";
+
+    hasInputs = (typeof node.getElementsByTagName == 'function') &&
+                 node.getElementsByTagName('input').length;
+
+    if (node.getAttribute("sorttable_customkey") != null) {
+      return node.getAttribute("sorttable_customkey");
+    }
+    else if (typeof node.textContent != 'undefined' && !hasInputs) {
+      return node.textContent.replace(/^\s+|\s+$/g, '');
+    }
+    else if (typeof node.innerText != 'undefined' && !hasInputs) {
+      return node.innerText.replace(/^\s+|\s+$/g, '');
+    }
+    else if (typeof node.text != 'undefined' && !hasInputs) {
+      return node.text.replace(/^\s+|\s+$/g, '');
+    }
+    else {
+      switch (node.nodeType) {
+        case 3:
+          if (node.nodeName.toLowerCase() == 'input') {
+            return node.value.replace(/^\s+|\s+$/g, '');
+          }
+        case 4:
+          return node.nodeValue.replace(/^\s+|\s+$/g, '');
+          break;
+        case 1:
+        case 11:
+          var innerText = '';
+          for (var i = 0; i < node.childNodes.length; i++) {
+            innerText += sorttable.getInnerText(node.childNodes[i]);
+          }
+          return innerText.replace(/^\s+|\s+$/g, '');
+          break;
+        default:
+          return '';
+      }
+    }
+  },
+
+  reverse: function(tbody) {
+    // reverse the rows in a tbody
+    newrows = [];
+    for (var i=0; i<tbody.rows.length; i++) {
+      newrows[newrows.length] = tbody.rows[i];
+    }
+    for (var i=newrows.length-1; i>=0; i--) {
+       tbody.appendChild(newrows[i]);
+    }
+    delete newrows;
+  },
+
+  /* sort functions
+     each sort function takes two parameters, a and b
+     you are comparing a[0] and b[0] */
+  sort_numeric: function(a,b) {
+    aa = parseFloat(a[0].replace(/[^0-9.-]/g,''));
+    if (isNaN(aa)) aa = 0;
+    bb = parseFloat(b[0].replace(/[^0-9.-]/g,''));
+    if (isNaN(bb)) bb = 0;
+    return aa-bb;
+  },
+  sort_alpha: function(a,b) {
+    if (a[0]==b[0]) return 0;
+    if (a[0]<b[0]) return -1;
+    return 1;
+  },
+  sort_ddmm: function(a,b) {
+    mtch = a[0].match(sorttable.DATE_RE);
+    y = mtch[3]; m = mtch[2]; d = mtch[1];
+    if (m.length == 1) m = '0'+m;
+    if (d.length == 1) d = '0'+d;
+    dt1 = y+m+d;
+    mtch = b[0].match(sorttable.DATE_RE);
+    y = mtch[3]; m = mtch[2]; d = mtch[1];
+    if (m.length == 1) m = '0'+m;
+    if (d.length == 1) d = '0'+d;
+    dt2 = y+m+d;
+    if (dt1==dt2) return 0;
+    if (dt1<dt2) return -1;
+    return 1;
+  },
+  sort_mmdd: function(a,b) {
+    mtch = a[0].match(sorttable.DATE_RE);
+    y = mtch[3]; d = mtch[2]; m = mtch[1];
+    if (m.length == 1) m = '0'+m;
+    if (d.length == 1) d = '0'+d;
+    dt1 = y+m+d;
+    mtch = b[0].match(sorttable.DATE_RE);
+    y = mtch[3]; d = mtch[2]; m = mtch[1];
+    if (m.length == 1) m = '0'+m;
+    if (d.length == 1) d = '0'+d;
+    dt2 = y+m+d;
+    if (dt1==dt2) return 0;
+    if (dt1<dt2) return -1;
+    return 1;
+  },
+
+  shaker_sort: function(list, comp_func) {
+    // A stable sort function to allow multi-level sorting of data
+    // see: http://en.wikipedia.org/wiki/Cocktail_sort
+    // thanks to Joseph Nahmias
+    var b = 0;
+    var t = list.length - 1;
+    var swap = true;
+
+    while(swap) {
+        swap = false;
+        for(var i = b; i < t; ++i) {
+            if ( comp_func(list[i], list[i+1]) > 0 ) {
+                var q = list[i]; list[i] = list[i+1]; list[i+1] = q;
+                swap = true;
+            }
+        } // for
+        t--;
+
+        if (!swap) break;
+
+        for(var i = t; i > b; --i) {
+            if ( comp_func(list[i], list[i-1]) < 0 ) {
+                var q = list[i]; list[i] = list[i-1]; list[i-1] = q;
+                swap = true;
+            }
+        } // for
+        b++;
+
+    } // while(swap)
+  }
+}
+
+/* ******************************************************************
+   Supporting functions: bundled here to avoid depending on a library
+   ****************************************************************** */
+
+// Dean Edwards/Matthias Miller/John Resig
+
+/* for Mozilla/Opera9 */
+if (document.addEventListener) {
+    document.addEventListener("DOMContentLoaded", sorttable.init, false);
+}
+
+/* for Internet Explorer */
+/*@cc_on @*/
+/*@if (@_win32)
+    document.write("<script id=__ie_onload defer src=javascript:void(0)><\/script>");
+    var script = document.getElementById("__ie_onload");
+    script.onreadystatechange = function() {
+        if (this.readyState == "complete") {
+            sorttable.init(); // call the onload handler
+        }
+    };
+/*@end @*/
+
+/* for Safari */
+if (/WebKit/i.test(navigator.userAgent)) { // sniff
+    var _timer = setInterval(function() {
+        if (/loaded|complete/.test(document.readyState)) {
+            sorttable.init(); // call the onload handler
+        }
+    }, 10);
+}
+
+/* for other browsers */
+window.onload = sorttable.init;
+
+// written by Dean Edwards, 2005
+// with input from Tino Zijdel, Matthias Miller, Diego Perini
+
+// http://dean.edwards.name/weblog/2005/10/add-event/
+
+function dean_addEvent(element, type, handler) {
+    if (element.addEventListener) {
+        element.addEventListener(type, handler, false);
+    } else {
+        // assign each event handler a unique ID
+        if (!handler.$$guid) handler.$$guid = dean_addEvent.guid++;
+        // create a hash table of event types for the element
+        if (!element.events) element.events = {};
+        // create a hash table of event handlers for each element/event pair
+        var handlers = element.events[type];
+        if (!handlers) {
+            handlers = element.events[type] = {};
+            // store the existing event handler (if there is one)
+            if (element["on" + type]) {
+                handlers[0] = element["on" + type];
+            }
+        }
+        // store the event handler in the hash table
+        handlers[handler.$$guid] = handler;
+        // assign a global event handler to do all the work
+        element["on" + type] = handleEvent;
+    }
+};
+// a counter used to create unique IDs
+dean_addEvent.guid = 1;
+
+function removeEvent(element, type, handler) {
+    if (element.removeEventListener) {
+        element.removeEventListener(type, handler, false);
+    } else {
+        // delete the event handler from the hash table
+        if (element.events && element.events[type]) {
+            delete element.events[type][handler.$$guid];
+        }
+    }
+};
+
+function handleEvent(event) {
+    var returnValue = true;
+    // grab the event object (IE uses a global event object)
+    event = event || fixEvent(((this.ownerDocument || this.document || this).parentWindow || window).event);
+    // get a reference to the hash table of event handlers
+    var handlers = this.events[event.type];
+    // execute each event handler
+    for (var i in handlers) {
+        this.$$handleEvent = handlers[i];
+        if (this.$$handleEvent(event) === false) {
+            returnValue = false;
+        }
+    }
+    return returnValue;
+};
+
+function fixEvent(event) {
+    // add W3C standard event methods
+    event.preventDefault = fixEvent.preventDefault;
+    event.stopPropagation = fixEvent.stopPropagation;
+    return event;
+};
+fixEvent.preventDefault = function() {
+    this.returnValue = false;
+};
+fixEvent.stopPropagation = function() {
+  this.cancelBubble = true;
+}
+
+// Dean's forEach: http://dean.edwards.name/base/forEach.js
+/*
+    forEach, version 1.0
+    Copyright 2006, Dean Edwards
+    License: http://www.opensource.org/licenses/mit-license.php
+*/
+
+// array-like enumeration
+if (!Array.forEach) { // mozilla already supports this
+    Array.forEach = function(array, block, context) {
+        for (var i = 0; i < array.length; i++) {
+            block.call(context, array[i], i, array);
+        }
+    };
+}
+
+// generic enumeration
+Function.prototype.forEach = function(object, block, context) {
+    for (var key in object) {
+        if (typeof this.prototype[key] == "undefined") {
+            block.call(context, object[key], key, object);
+        }
+    }
+};
+
+// character enumeration
+String.forEach = function(string, block, context) {
+    Array.forEach(string.split(""), function(chr, index) {
+        block.call(context, chr, index, string);
+    });
+};
+
+// globally resolve forEach enumeration
+var forEach = function(object, block, context) {
+    if (object) {
+        var resolve = Object; // default
+        if (object instanceof Function) {
+            // functions have a "length" property
+            resolve = Function;
+        } else if (object.forEach instanceof Function) {
+            // the object implements a custom forEach method so use that
+            object.forEach(block, context);
+            return;
+        } else if (typeof object == "string") {
+            // the object is a string
+            resolve = String;
+        } else if (typeof object.length == "number") {
+            // the object is array-like
+            resolve = Array;
+        }
+        resolve.forEach(object, block, context);
+    }
+};