From 60f60de8aefeebd1de0bf6c940558902226d7747 Mon Sep 17 00:00:00 2001
From: Guillaume Melquiond <guillaume.melquiond@gmail.com>
Date: Fri, 31 Aug 2007 10:02:36 +0000
Subject: Plugged several account leaks on error. Prevented banned players from
 logging in.

---
 src/account-server/dalstorage.cpp | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'src/account-server/dalstorage.cpp')

diff --git a/src/account-server/dalstorage.cpp b/src/account-server/dalstorage.cpp
index 31606e8..70b1cdf 100644
--- a/src/account-server/dalstorage.cpp
+++ b/src/account-server/dalstorage.cpp
@@ -429,6 +429,26 @@ DALStorage::getEmailList()
 }
 #endif
 
+bool DALStorage::doesUserNameExist(std::string const &name)
+{
+    try {
+        std::ostringstream sql;
+        sql << "select count(username) from " << ACCOUNTS_TBL_NAME
+            << " where username = \"" << name << "\";";
+        dal::RecordSet const &accountInfo = mDb->execSql(sql.str());
+
+        std::istringstream ssStream(accountInfo(0, 0));
+        unsigned int iReturn = 1;
+        ssStream >> iReturn;
+        return iReturn != 0;
+    } catch (std::exception const &e) {
+        // TODO: throw an exception.
+        LOG_ERROR("(DALStorage::doesUserNameExist) SQL query failure: " << e.what());
+    }
+
+    return true;
+}
+
 /**
  * Tells if the email address already exists
  * @return true if the email address exists.
-- 
cgit