diff options
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]; |