From 74f15b5b543bd46ae8ff22b424f2675d08ce3838 Mon Sep 17 00:00:00 2001
From: ulrich <undisclosed>
Date: Fri, 09 Mar 2018 18:37:15 +0000
Subject: [PATCH] Abspielen via PiRC auf den Server verlagert
---
web/WEB-INF/sql.properties | 19 +++++++++++++++++--
1 files changed, 17 insertions(+), 2 deletions(-)
diff --git a/web/WEB-INF/sql.properties b/web/WEB-INF/sql.properties
index 714aacc..3fc254c 100644
--- a/web/WEB-INF/sql.properties
+++ b/web/WEB-INF/sql.properties
@@ -23,12 +23,27 @@
app.keytable
where key_name = ?
</entry>
- <entry key="getSender">
+ <entry key="getSenderList">
select * from
app.sender
</entry>
- <entry key="getAbspieler">
+ <entry key="getSender">
+ select * from
+ app.sender
+ where sender_id = ?
+ </entry>
+ <entry key="getAbspielerList">
select * from
app.abspieler
</entry>
+ <entry key="getAbspieler">
+ select * from
+ app.abspieler
+ where abs_id = ?
+ </entry>
+ <entry key="unselectAbspieler">
+ update app.abspieler
+ set abs_zustand = ?
+ where abs_zustand = ?
+ </entry>
</properties>
--
Gitblit v1.9.3