From 0f3b665784e53644c5c20a477344b70af2016550 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Thu, 7 Jul 2011 11:08:08 +0200 Subject: [PATCH] Improves display in weekly registration summary email. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- bin/cron/registrations.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bin/cron/registrations.php b/bin/cron/registrations.php index a2c22dc..1866b89 100755 --- a/bin/cron/registrations.php +++ b/bin/cron/registrations.php @@ -5,7 +5,7 @@ require 'connect.db.inc.php'; $message = ''; -$res = XDB::iterRow("SELECT a.registration_date, a.hruid, s.email, GROUP_CONCAT(r.redirect SEPARATOR ', ') +$res = XDB::iterRow("SELECT DATE(a.registration_date), a.hruid, GROUP_CONCAT(DISTINCT r.redirect SEPARATOR ', ') FROM accounts AS a INNER JOIN account_profiles AS ap ON (ap.uid = a.uid AND FIND_IN_SET('owner', ap.perms)) INNER JOIN profile_display AS pd ON (ap.pid = pd.pid) -- 2.1.4