X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fdb.php;h=2ea2ac0a1dca2b7aa7c6f10e6a16c272b6f9588f;hp=33f0fff2dd291040bce2126e8ab65da6d52460b7;hb=a4cdb155b19c40d9b85a06d8aae0c6b291f439fc;hpb=742ba18eaf36386d2d0e0936975b3f2545afc59e

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