* Extended tmw_accounts table with columns for lastlogin and registration date. Modified account-server to fill the new columns on registration and login. Recreation of database needed!

* Added createIndex function to create indexes on tables.

1 files changed, 13 insertions, 0 deletions

diff --git a/src/account-server/accounthandler.cpp b/src/account-server/accounthandler.cpp
index 649aa267..56c03b31 100644
--- a/src/account-server/accounthandler.cpp
+++ b/src/account-server/accounthandler.cpp
@@ -207,6 +207,13 @@ static void handleLoginMessage(AccountClient &computer, MessageIn &msg)
         return;
     }
 
+    // set lastLogin date of the account
+    time_t login;
+    time(&login);
+    acc->setLastLogin(login);
+    storage->updateLastLogin(acc);
+
+
     // Associate account with connection
     computer.setAccount(acc);
     computer.status = CLIENT_CONNECTED;
@@ -330,6 +337,12 @@ static void handleRegisterMessage(AccountClient &computer, MessageIn &msg)
         acc->setEmail(sha256(email));
         acc->setLevel(AL_NORMAL);
 
+        // set the date and time of the account registration, and the last login
+        time_t regdate;
+        time(&regdate);
+        acc->setRegistrationDate(regdate);
+        acc->setLastLogin(regdate);
+
         storage->addAccount(acc);
         reply.writeByte(ERRMSG_OK);