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>

1 files changed, 22 insertions, 0 deletions

diff --git a/db.php b/db.php
index 39ab45c..7b95ae7 100644
--- a/db.php
+++ b/db.php
@@ -578,6 +578,28 @@ function DB_get_all_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));