Added lastLogin

JonnyD · Jan 16, 2014 · d24614b · d24614b
1 parent 8f14fa1
commit d24614b
Show file tree

Hide file tree

Showing 2 changed files with 4 additions and 3 deletions.
diff --git a/README.md b/README.md
@@ -18,7 +18,7 @@ CREATE TABLE IF NOT EXISTS `event_type` (
 CREATE TABLE IF NOT EXISTS `player` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `username` varchar(32) NOT NULL,
-  `online` tinyint(1) NOT NULL DEFAULT '0',
+  `last_login` timestamp,
   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`),
   UNIQUE KEY `username` (`username`)

diff --git a/skynet.js b/skynet.js
@@ -48,6 +48,7 @@ function bindEvents(bot) {
       function(playerId, eventId, callback) {
         addSession(player.username, playerId, eventId, function(sessionId) {
           console.log("[" + timestamp + "] Started session: " + sessionId + " for " + player.username + " (" + playerId +")");
+		  updateLastLogin(playerId, timestamp);
           callback(null, playerId, sessionId);
         });
       }
@@ -330,8 +331,8 @@ function createPlayer(username, timestamp, callback) {
   });
 }
 
-function updatenOnlineStatus(playerId, isOnline) {
-  connection.query("UPDATE player SET online = " + isOnline + " WHERE id = " + playerId);
+function updateLastLogin(playerId, timestamp) {
+  connection.query("UPDATE player SET last_login = " + timestamp + " WHERE id = " + playerId);
 }
 
 function getTimestamp() {