From dd925069d7ffca64f28017ec62e8ebe5abba5d32 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sat, 8 Mar 2014 22:23:39 -0800 Subject: Only show new players from the last 45 days should be enough to get them playing in new games. --- include/db.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'include/db.php') diff --git a/include/db.php b/include/db.php index 33f0fff..2ea2ac0 100644 --- a/include/db.php +++ b/include/db.php @@ -507,7 +507,9 @@ function DB_get_names_of_new_logins($N) { $names = array(); - $result = DB_query("SELECT fullname FROM User ORDER BY create_date DESC, id DESC LIMIT $N"); + $result = DB_query("SELECT fullname FROM User". + " WHERE create_date >=(NOW() - interval 45 day)". + " ORDER BY create_date DESC, id DESC LIMIT $N"); while($r = DB_fetch_array($result)) $names[] = $r[0]; -- cgit v1.2.3-18-g5258