From a41e99223e1dfe707afd0fa8004bcb6f267f0f04 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Sat, 11 Sep 2010 21:10:54 +0200 Subject: Core/DBLayer: * Rename QueryResult class to ResultSet * Rename QueryResult_AutoPtr to QueryResult * Declare ACE refcounted auto pointer for PreparedResultSet class --HG-- branch : trunk --- src/server/shared/Database/Implementation/LoginDatabase.cpp | 2 ++ src/server/shared/Database/Implementation/LoginDatabase.h | 2 ++ 2 files changed, 4 insertions(+) (limited to 'src/server/shared/Database/Implementation') diff --git a/src/server/shared/Database/Implementation/LoginDatabase.cpp b/src/server/shared/Database/Implementation/LoginDatabase.cpp index 46930436496..1f6c5ec126b 100644 --- a/src/server/shared/Database/Implementation/LoginDatabase.cpp +++ b/src/server/shared/Database/Implementation/LoginDatabase.cpp @@ -30,8 +30,10 @@ bool LoginDatabaseConnection::Open(const std::string& infoString) LOAD YOUR PREPARED STATEMENTS HERE ################################## */ + PrepareStatement(LOGIN_GET_REALMLIST, "SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE color <> 3 ORDER BY name"); PrepareStatement(LOGIN_SET_VS, "UPDATE account SET v = ?, s = ? WHERE username = ?"); PrepareStatement(LOGIN_SET_LOGONPROOF, "UPDATE account SET sessionkey = ?, last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0 WHERE username = ?"); + PrepareStatement(LOGIN_GET_LOGONCHALLENGE, "SELECT a.sha_pass_hash,a.id,a.locked,a.last_ip,aa.gmlevel,a.v,a.s FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.username = ?"); return true; } diff --git a/src/server/shared/Database/Implementation/LoginDatabase.h b/src/server/shared/Database/Implementation/LoginDatabase.h index a3cac75b5a0..2dde12014d0 100644 --- a/src/server/shared/Database/Implementation/LoginDatabase.h +++ b/src/server/shared/Database/Implementation/LoginDatabase.h @@ -43,8 +43,10 @@ enum LoginDatabaseStatements name for a suiting suffix. */ + LOGIN_GET_REALMLIST, LOGIN_SET_VS, LOGIN_SET_LOGONPROOF, + LOGIN_GET_LOGONCHALLENGE, MAX_LOGINDATABASE_STATEMENTS, }; -- cgit v1.2.3