diff options
| author | PanFritz <redstonenoobpan@gmail.com> | 2015-07-07 18:52:43 +0200 |
|---|---|---|
| committer | PanFritz <redstonenoobpan@gmail.com> | 2015-07-07 18:52:43 +0200 |
| commit | c8895f9bb4f7576f935e682d3c50632cae340925 (patch) | |
| tree | cd54e9b0f77441380f5d8b59cff873098369c107 /loginsecurity.py | |
| parent | b65c2228f7e6fd15d2c365a6f3b288ceb89fcf53 (diff) | |
Fixed mysql command missing '?'
Diffstat (limited to 'loginsecurity.py')
| -rw-r--r-- | loginsecurity.py | 4 |
1 files changed, 3 insertions, 1 deletions
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() |