From ef06b88555ee46c9dd199f83dce731d8a7b039a6 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Wed, 22 Feb 2017 14:40:52 +0100
Subject: Fetching prefixes for match links

---
 playoff/sql.py      |  4 ++++
 playoff/template.py | 10 +++++++---
 2 files changed, 11 insertions(+), 3 deletions(-)

(limited to 'playoff')

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>
-- 
cgit v1.2.3