From ca9cf2359f2f0e86a543aae34eb7bfee06938ef5 Mon Sep 17 00:00:00 2001 From: Thomas Minvielle Date: Tue, 24 Dec 2013 18:32:05 +0100 Subject: [PATCH] Removes the dead from the lost admin page. --- modules/email.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/modules/email.php b/modules/email.php index 09d840a..772c121 100644 --- a/modules/email.php +++ b/modules/email.php @@ -791,7 +791,8 @@ class EmailModule extends PLModule AND er.type != \'imap\' AND er.type != \'homonym\') LEFT JOIN account_profiles AS ap ON (ap.uid = a.uid AND FIND_IN_SET(\'owner\', ap.perms)) LEFT JOIN profile_display AS pd ON (ap.pid = pd.pid) - WHERE a.state = \'active\' AND er.redirect IS NULL AND FIND_IN_SET(\'mail\', at.perms) + LEFT JOIN profiles AS p ON (ap.pid = p.pid) + WHERE a.state = \'active\' AND er.redirect IS NULL AND FIND_IN_SET(\'mail\', at.perms) AND p.deathdate IS NULL GROUP BY a.uid ORDER BY pd.promo, a.hruid')); } -- 2.1.4