X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fnewsletter.send.php;h=1d56351d52059686835742c646fc122500ea21f5;hb=3424387cde6c635ff16c3b5459c4caa88bb76e2e;hp=15b335908314fc830e9f6928c97a74aabad84093;hpb=50a40a33a496131e817df875607ea5542d096a64;p=platal.git diff --git a/bin/newsletter.send.php b/bin/newsletter.send.php index 15b3359..1d56351 100755 --- a/bin/newsletter.send.php +++ b/bin/newsletter.send.php @@ -1,7 +1,7 @@ -#!/usr/bin/php4 -q +#!/usr/bin/php5 -q setSent(); - -while(true) { - $res = $globals->xdb->iterRow( - "SELECT ni.user_id, a.alias, - u.prenom, IF(u.nom_usage='', u.nom, u.nom_usage), - FIND_IN_SET('femme', u.flags), - q.core_mail_fmt AS pref - FROM newsletter_ins AS ni - INNER JOIN auth_user_md5 AS u USING(user_id) - INNER JOIN auth_user_quick AS q ON(q.user_id = u.user_id) - INNER JOIN aliases AS a ON(u.user_id=a.id AND FIND_IN_SET('bestalias',a.flags)) - WHERE ni.last<{?} - LIMIT 60", $id); - if (!$res->total()) { exit; } - - $sent = Array(); - while (list($uid, $bestalias, $prenom, $nom, $sexe, $fmt) = $res->next()) { - $sent[] = "user_id='$uid'"; - $nl->sendTo($prenom, $nom, $bestalias, $sexe, $fmt=='html'); - } - $globals->xdb->execute('UPDATE newsletter_ins SET last={?} WHERE '.implode(' OR ', $sent), $id); - sleep(60); -} +$nl = NewsLetter::forGroup(NewsLetter::GROUP_XORG); +$issue = $nl->getIssue($id); +$issue->sendToAll(); +// vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8: ?>