From ba7d92fad7b3ac0cfe4a6733339aa474991315a2 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Thu, 22 Oct 2009 22:56:21 -0700 Subject: NEW FEATURE: use gravatars as icons for players use icons at the table and on the user page (for last players logged in). --- include/db.php | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'include/db.php') diff --git a/include/db.php b/include/db.php index cc40f67..882a1ad 100644 --- a/include/db.php +++ b/include/db.php @@ -470,6 +470,17 @@ function DB_get_names_of_last_logins($N) return $names; } +function DB_get_emails_of_last_logins($N) +{ + $emails = array(); + + $result = DB_query("SELECT email FROM User ORDER BY last_login DESC LIMIT $N"); + while($r = DB_fetch_array($result)) + $emails[] = $r[0]; + + return $emails; +} + function DB_get_names_of_new_logins($N) { $names = array(); -- cgit v1.2.3-18-g5258