From 28e1534923d7deb34b1677403df462012ac145a3 Mon Sep 17 00:00:00 2001 From: "Pierre Habouzit (MadCoder" Date: Fri, 3 Dec 2004 09:39:58 +0000 Subject: [PATCH] backport git-archimport-id: opensource@polytechnique.org--2005/platal--mainline--0.9--patch-21 --- bin/cron/send_nl.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/bin/cron/send_nl.php b/bin/cron/send_nl.php index e94652e..c90ebcc 100755 --- a/bin/cron/send_nl.php +++ b/bin/cron/send_nl.php @@ -46,10 +46,11 @@ $nl->setSent(); while(true) { $sql = mysql_query("SELECT ni.user_id,ni.pref, a.alias, - u.prenom, IF(u.epouse='', u.nom, u.epouse) + u.prenom, IF(u.epouse='', u.nom, u.epouse), + FIND_IN_SET('femme', u.flags) FROM newsletter_ins AS ni INNER JOIN auth_user_md5 AS u USING(user_id) - INNER JOIN aliases AS a ON(u.user_id=a.id AND FIND_IN_SET('bestalias',a.flags) + INNER JOIN aliases AS a ON(u.user_id=a.id AND FIND_IN_SET('bestalias',a.flags)) WHERE ni.last<$id LIMIT 60"); if(!mysql_num_rows($sql)) exit(0); -- 2.1.4