FEATURE: display names of new players and last logged in players

instead of showing all registered players, just display the above.

Signed-off-by: Arun Persaud <arun@nubati.net>

diff --git a/create_database.sql b/create_database.sql
index 396862dd191102b28b01f362ac3a7946672de3d5..e863f538bfc051d546bdcab2cac403c703e758bd 100644 (file)
--- a/create_database.sql
+++ b/create_database.sql
@@ -269,6 +269,7 @@ CREATE TABLE `User` (
   `password` varchar(32) default NULL,
   `timezone` varchar(64) default 'Europe/London',
   `last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
   `password` varchar(32) default NULL,
   `timezone` varchar(64) default 'Europe/London',
   `last_login` timestamp NOT NULL default '0000-00-00 00:00:00',

+  `create_date` timestamp NOT NULL default '0000-00-00 00:00:00',

   UNIQUE KEY `id` (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
   UNIQUE KEY `id` (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 

diff --git a/db.php b/db.php
index 39ab45c5c3b563aec2f7cf7d6c336522ee1cee11..7b95ae719fed25c02b7f3e8b2eab6b7833605046 100644 (file)
--- a/db.php
+++ b/db.php
@@ -578,6 +578,28 @@ function DB_get_all_names()
   return $names;
 }
 
   return $names;
 }
 

+function DB_get_names_of_last_logins($N)
+{
+  $names  = array();
+
+  $result = mysql_query("SELECT fullname FROM User ORDER BY last_login DESC LIMIT $N");
+  while($r = mysql_fetch_array($result,MYSQL_NUM))
+    $names[] = $r[0];
+
+  return $names;
+}
+
+function DB_get_names_of_new_logins($N)
+{
+  $names  = array();
+
+  $result = mysql_query("SELECT fullname FROM User ORDER BY create_date DESC, id DESC LIMIT $N");
+  while($r = mysql_fetch_array($result,MYSQL_NUM))
+    $names[] = $r[0];
+
+  return $names;
+}
+

 function DB_update_game_timestamp($gameid)
 {
   mysql_query("UPDATE Game SET mod_date = CURRENT_TIMESTAMP WHERE id=".DB_quote_smart($gameid));
 function DB_update_game_timestamp($gameid)
 {
   mysql_query("UPDATE Game SET mod_date = CURRENT_TIMESTAMP WHERE id=".DB_quote_smart($gameid));

diff --git a/index.php b/index.php
index 4b5ca5cb25f3e22b3aaed4092bd52ec3f031dd48..c3988b5b0ae4f1c9435bccebf7fe6b17a5ed8dff 100644 (file)
--- a/index.php
+++ b/index.php
@@ -2248,10 +2248,18 @@ else if( myisset("email","password") || isset($_SESSION["name"]) )
                     }
                 }
               echo "</td></tr>\n</table>\n";
                     }
                 }
               echo "</td></tr>\n</table>\n";

-              $names = DB_get_all_names();
-              echo "<h4>Registered players:</h4>\n<p>\n";
-              echo implode(", ",$names)."\n";
-              echo "</p>\n</div>";
+
+              $names = DB_get_names_of_new_logins(5);
+              echo "<h4>New Players:</h4>\n<p>\n";
+              echo implode(", ",$names).",...\n";
+              echo "</p>\n";
+
+              $names = DB_get_names_of_last_logins(5);
+              echo "<h4>Players last logged in:</h4>\n<p>\n";
+              echo implode(", ",$names).",...\n";
+              echo "</p>\n";
+              
+              echo "</div>\n";

             }
         }
        else
             }
         }
        else