X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fnewsletter.send.php;h=1d56351d52059686835742c646fc122500ea21f5;hb=3424387cde6c635ff16c3b5459c4caa88bb76e2e;hp=1a185d3cde16d393b7b8267461dea6aafeaf2d1e;hpb=a6dfd11d35371a9fb52883df6a3159bab70c16f6;p=platal.git diff --git a/bin/newsletter.send.php b/bin/newsletter.send.php index 1a185d3..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 = 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)) - LEFT JOIN emails AS e ON(e.uid=u.user_id AND e.flags='active') - WHERE ni.last<{?} AND e.email IS NOT NULL - GROUP BY ni.user_id - 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'); - } - 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: ?>