summaryrefslogtreecommitdiff
path: root/playoff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2017-02-22 14:40:52 +0100
committeremkael <emkael@tlen.pl>2017-02-22 14:40:52 +0100
commitef06b88555ee46c9dd199f83dce731d8a7b039a6 (patch)
tree2ac61237d635ff5e3eb2f2d5c71449ed537d804e /playoff
parentf118c0f3704fa07a33543ee2aa018f16ac993b5a (diff)
Fetching prefixes for match links
Diffstat (limited to 'playoff')
-rw-r--r--playoff/sql.py4
-rw-r--r--playoff/template.py10
2 files changed, 11 insertions, 3 deletions
diff --git a/playoff/sql.py b/playoff/sql.py
index 0bd2df7..d5c28cd 100644
--- a/playoff/sql.py
+++ b/playoff/sql.py
@@ -21,3 +21,7 @@ JOIN #db#.scores sc2
JOIN #db#.admin
WHERE sc1.tabl = %s AND sc1.rnd = %s
'''
+
+PREFIX = '''
+SELECT shortname FROM #db#.admin
+'''
diff --git a/playoff/template.py b/playoff/template.py
index 5fe855c..65a846b 100644
--- a/playoff/template.py
+++ b/playoff/template.py
@@ -12,8 +12,12 @@ MATCH_TABLE = '''
MATCH_TEAM_ROW = '''
<tr>
-<td class="bd1">&nbsp;<a onmouseover="Tip('%s')" onmouseout="UnTip()">%s</a>&nbsp;</td>
-<td class="bdc">&nbsp;%.1f&nbsp;</td>
+<td class="bd1">&nbsp;<a href="%s" onmouseover="Tip('%s')" onmouseout="UnTip()">%s</a>&nbsp;</td>
+<td class="bdc">
+<a href="%s" target="_top">
+&nbsp;%.1f&nbsp;
+</a>
+</td>
</tr>
'''
@@ -54,7 +58,7 @@ MATCH_BOX = '''
LEADERBOARD = '''
<table border="0" cellspacing="0">
<tr>
-<td class="bdnl12" colspan="2" align="center"><b>KLASYFIKACJA KOŃCOWA</b></td>
+<td class="bdnl12" colspan="2" align="center"><b>&nbsp;KLASYFIKACJA KOŃCOWA&nbsp;</b></td>
</tr>
<tr>
<td class="e" colspan="2">&nbsp;</td>