From dd925069d7ffca64f28017ec62e8ebe5abba5d32 Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Sat, 8 Mar 2014 22:23:39 -0800
Subject: [PATCH] Only show new players from the last 45 days

should be enough to get them playing in new games.
---
 include/db.php   |  4 +++-
 include/user.php | 11 +++++++----
 2 files changed, 10 insertions(+), 5 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];
 
diff --git a/include/user.php b/include/user.php
index 764c694..7acf726 100644
--- a/include/user.php
+++ b/include/user.php
@@ -314,11 +314,14 @@ else
 	if($count<10)
 	  echo '<p class="newbiehint">'._('You can start new games using the link in the top right corner!')."</p>\n";
 
-	/* display last 5 users that have signed up to e-DoKo */
+	/* display last 5 users that have signed up to e-DoKo within the 45 days */
 	$names = DB_get_names_of_new_logins(5);
-	echo '<h4>'._('New Players').":</h4>\n<p>\n";
-	echo implode(", ",$names).",...\n";
-	echo "</p>\n";
+        if ($names)
+	  {
+	    echo '<h4>'._('New Player(s)').":</h4>\n<p>\n";
+	    echo implode(", ",$names).",...\n";
+	    echo "</p>\n";
+	  };
 
 	/* display last 5 users that logged on */
 	echo '<h4>'._('Players last logged in').":</h4>\n<p>\n";
-- 
2.25.1