EQEmuLoginServer - Creates account upon login

[pfyon]

This might be useful for small servers for just friends. When someone logs in and the username does not already exist in the DB, it will create a new user with username/password given (and email address nobody@localhost).

Tested on Ubuntu 10.04 with rev 1620. The revision numbers in the diff are because I was comitting against my own svn.

Index: Client.cpp
===================================================================
--- Client.cpp  (revision 60)
+++ Client.cpp  (working copy)
@@ -225,11 +225,29 @@
        _HeapDeleteCharBuffer(e_buffer);
 #endif

-       bool result;
+       bool result = false;
        if(server.db->GetLoginDataFromAccountName(e_user, d_pass_hash, d_account_id) == false)
        {
                log->Log(log_client_error, "Error logging in, user %s does not exist in the database.", e_user.c_str());
-               result = false;
+               if(server.db->CreateLoginAccount(e_user.c_str(), e_hash.c_str()))
+               {
+                       //Made the account properly
+                       if(server.db->GetLoginDataFromAccountName(e_user, d_pass_hash, d_account_id) == false)
+                       {
+                               //Somehow did not authenticate properly
+                               log->Log(log_client_error, "Error logging in, user %s does not exist in the database.", e_user.c_str());
+                               result = false;
+                       } else
+                       {
+                               if(d_pass_hash.compare(e_hash) == 0)
+                               {
+                                       result = true;
+                               } else
+                               {
+                                       result = false;
+                               }
+                       }
+               }
        }
        else
        {

Index: DatabaseMySQL.h
===================================================================
--- DatabaseMySQL.h     (revision 56)
+++ DatabaseMySQL.h     (working copy)
@@ -88,6 +88,11 @@
         * Creates new world registration for unregistered servers and returns new id
         */
        virtual bool CreateWorldRegistration(string long_name, string short_name, unsigned int &id);
+
+       /**
+        * Creates a new login account in the player accounts table
+        */
+       virtual bool CreateLoginAccount(string name, string password);
 protected:
        string user, pass, host, port, name;
        MYSQL *db;

Index: DatabaseMySQL.cpp
===================================================================
--- DatabaseMySQL.cpp   (revision 56)
+++ DatabaseMySQL.cpp   (working copy)
@@ -97,6 +97,36 @@
        return false;
 }

+bool DatabaseMySQL::CreateLoginAccount(string name, string password)
+{
+       if(!db)
+       {
+               return false;
+       }
+
+       MYSQL_RES *res;
+       MYSQL_ROW row;
+       char escaped_name[101];
+       char escaped_password[101];
+       unsigned long length;
+       length = mysql_real_escape_string(db, escaped_name, name.substr(0, 50).c_str(), name.substr(0, 100).length());
+       escaped_name[length+1] = 0;
+       length = mysql_real_escape_string(db, escaped_password, password.substr(0, 50).c_str(), password.substr(0, 100).length());
+       escaped_password[length+1] = 0;
+
+       stringstream query(stringstream::in | stringstream::out);
+       query << "INSERT INTO " << server.options.GetAccountTable() << " (AccountName, AccountPassword, AccountCreateDate, AccountEmail)";
+       query << "VALUES ('" << escaped_name << "', '" << escaped_password << "', now(), 'nobody@localhost')";
+
+       if(mysql_query(db, query.str().c_str()) != 0)
+       {
+               log->Log(log_database, "Error creating login account: %s", query.str().c_str());
+               return false;
+       }
+
+       return true;
+}
+
 bool DatabaseMySQL::GetWorldRegistration(string long_name, string short_name, unsigned int &id, string &desc, unsigned int &list_id,
                unsigned int &trusted, string &list_desc, string &account, string &password)
 {

Index: Database.h
===================================================================
--- Database.h  (revision 56)
+++ Database.h  (working copy)
@@ -73,6 +73,11 @@
         * Creates new world registration for unregistered servers and returns new id
         */
        virtual bool CreateWorldRegistration(string long_name, string short_name, unsigned int &id) { return false; }
+
+       /**
+        * Creates a new login account in the player accounts table
+        */
+       virtual bool CreateLoginAccount(string name, string password) { return false;}
 protected:
        string user, pass, host, port, name;
 };

[Swiftsong_Lorekeeper]

That is a pretty cool tool. I'm new to running my own server so I was curious, if you have time, that you could explain what to do with these :p I would like to install and be able to not have to worry about manually inputting account information.