From 776f90ed0a6c1b5b36fd652ee3fee5194630b6cc Mon Sep 17 00:00:00 2001 From: x2003bruneau Date: Thu, 12 Oct 2006 11:04:43 +0000 Subject: [PATCH] Backport git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@975 839d8a87-29fc-0310-9880-83ba4fa771e5 --- bin/cron/checkdb.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/bin/cron/checkdb.php b/bin/cron/checkdb.php index 01fa466..73c63ea 100755 --- a/bin/cron/checkdb.php +++ b/bin/cron/checkdb.php @@ -139,7 +139,8 @@ check("SELECT u.user_id, a.alias FROM auth_user_md5 AS u INNER JOIN aliases AS a ON (u.user_id = a.id AND a.type='a_vie') LEFT JOIN emails AS e ON(u.user_id=e.uid AND FIND_IN_SET('active',e.flags)) - WHERE e.uid IS NULL AND u.deces = 0", + WHERE e.uid IS NULL AND u.deces = 0 + ORDER BY u.promo, u.nom, u.prenom", "donne les inscrits qui n'ont pas d'email actif"); /* donne la liste des homonymes qui ont un alias égal à leur loginbis depuis plus d'un mois */ -- 2.1.4