-$nl->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);
-}