diff options
| author | Arun Persaud <arun@nubati.net> | 2014-03-08 22:23:39 -0800 |
|---|---|---|
| committer | Arun Persaud <arun@nubati.net> | 2014-03-08 22:26:07 -0800 |
| commit | dd925069d7ffca64f28017ec62e8ebe5abba5d32 (patch) | |
| tree | e9d412981dce667d4fd9d33ecb0978b4942792ff /include/db.php | |
| parent | 72bdb543759b5ffbdf5c2cc71294ad4f1f2996b2 (diff) | |
| download | e-DoKo-dd925069d7ffca64f28017ec62e8ebe5abba5d32.tar.gz e-DoKo-dd925069d7ffca64f28017ec62e8ebe5abba5d32.tar.bz2 e-DoKo-dd925069d7ffca64f28017ec62e8ebe5abba5d32.zip | |
Only show new players from the last 45 days
should be enough to get them playing in new games.
Diffstat (limited to 'include/db.php')
| -rw-r--r-- | include/db.php | 4 |
1 files changed, 3 insertions, 1 deletions
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]; |