From c8895f9bb4f7576f935e682d3c50632cae340925 Mon Sep 17 00:00:00 2001 From: PanFritz Date: Tue, 7 Jul 2015 18:52:43 +0200 Subject: Fixed mysql command missing '?' --- loginsecurity.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'loginsecurity.py') diff --git a/loginsecurity.py b/loginsecurity.py index 01134b2..6f8a028 100644 --- a/loginsecurity.py +++ b/loginsecurity.py @@ -114,6 +114,8 @@ def change_pass(uuid, pw): conn = zxJDBC.connect(mysql_database, mysql_user, mysql_pass, "com.mysql.jdbc.Driver") curs = conn.cursor() curs.execute("UPDATE secret SET 'pass' = ? WHERE 'uuid' = ?", (pw,), (uuid,)) + curs.close() + conn.close() def get_pass(uuid): conn = zxJDBC.connect(mysql_database, mysql_user, mysql_pass, "com.mysql.jdbc.Driver") @@ -127,7 +129,7 @@ def get_pass(uuid): def create_pass(uuid, pw): conn = zxJDBC.connect(mysql_database, mysql_user, mysql_pass, "com.mysql.jdbc.Driver") curs = conn.cursor() - curs.execute("INSERT INTO secret VALUES (?)", (uuid,pw,)) + curs.execute("INSERT INTO secret VALUES (?,?)", (uuid,pw,)) curs.close() conn.close() -- cgit v1.2.3