From 6762fb4bd2b02048a5657b0f2c68b279fdd48176 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sat, 25 Feb 2017 18:44:50 +0100
Subject: Towel support

---
 playoff/sql.py | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'playoff/sql.py')

diff --git a/playoff/sql.py b/playoff/sql.py
index d5c28cd..69cd423 100644
--- a/playoff/sql.py
+++ b/playoff/sql.py
@@ -22,6 +22,13 @@ JOIN #db#.admin
 WHERE sc1.tabl = %s AND sc1.rnd = %s
 '''
 
+TOWEL_COUNT = '''
+SELECT #db#.admin.boardspersegment * SUM(#db#.segments.towel)
+FROM #db#.segments
+JOIN #db#.admin
+WHERE #db#.segments.tabl = %s AND #db#.segments.rnd = %s
+'''
+
 PREFIX = '''
 SELECT shortname FROM #db#.admin
 '''
-- 
cgit v1.2.3