From fc2fadb0033767d7e75ff501af60b6120f982f77 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sat, 1 Mar 2008 19:05:01 -0800 Subject: 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 --- db.php | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) (limited to 'db.php') 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)); -- cgit v1.2.3-18-g5258