diff options
author | Machiavelli <machiaveltman@gmail.com> | 2011-12-31 15:16:38 +0100 |
---|---|---|
committer | Machiavelli <machiaveltman@gmail.com> | 2011-12-31 15:16:38 +0100 |
commit | 81914422e90e9488115bf01db6dce3dc22df24f9 (patch) | |
tree | c2c8909ac1953b2c8b505376e0e40958ea3793a0 /src | |
parent | afc18461d76b74f1e6dfaccebb3689e4ec2c2012 (diff) |
Core/DBLayer: Use column names in prepared statements to prevent avoidable prepare errors
Diffstat (limited to 'src')
-rwxr-xr-x | src/server/shared/Database/Implementation/LoginDatabase.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/server/shared/Database/Implementation/LoginDatabase.cpp b/src/server/shared/Database/Implementation/LoginDatabase.cpp index a42614e6053..c6a36aa88ec 100755 --- a/src/server/shared/Database/Implementation/LoginDatabase.cpp +++ b/src/server/shared/Database/Implementation/LoginDatabase.cpp @@ -61,5 +61,5 @@ void LoginDatabaseConnection::DoPrepareStatements() PREPARE_STATEMENT(LOGIN_DEL_OLD_LOGS, "DELETE FROM logs WHERE (time + ?) < ?", CONNECTION_ASYNC); PREPARE_STATEMENT(LOGIN_DEL_ACCOUNT_ACCESS, "DELETE FROM account_access WHERE id = ?", CONNECTION_ASYNC); PREPARE_STATEMENT(LOGIN_DEL_ACCOUNT_ACCESS_BY_REALM, "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)", CONNECTION_ASYNC); - PREPARE_STATEMENT(LOGIN_INS_ACCOUNT_ACCESS, "INSERT INTO account_access VALUES (?, ?, ?)", CONNECTION_ASYNC); + PREPARE_STATEMENT(LOGIN_INS_ACCOUNT_ACCESS, "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)", CONNECTION_ASYNC); } |