-$res = XDB::iterRow(
- "SELECT a.alias, u.promo, email
- FROM auth_user_md5 AS u
- LEFT JOIN aliases AS a ON( u.user_id=a.id AND a.type='a_vie' )
- LEFT JOIN emails AS e ON( e.uid = u.user_id AND NOT FIND_IN_SET('filter',e.flags) )
- WHERE u.date_ins > {?}
- GROUP BY alias
- ORDER BY promo", date("Ymd000000", strtotime ("last Monday")));
-if ($a = $res->total()) {
- $MESSAGE.="$a INSCRIPTIONS CONFIRMEES:\n";
- while (list($usern,$promo,$mail) = $res->next()) {
- $MESSAGE.="X$promo, $usern, $mail\n";
+$res = XDB::iterRow("SELECT al.alias, pd.promo, e.email //a.alias, u.promo, email
+ FROM accounts AS a
+ INNER JOIN account_profile AS ap ON (ap.uid = a.uid AND FIND_IN_SET('owner', ap.perms))
+ INNER JOIN profile_display AS pd ON (ap.pid = pd.pid)
+ LEFT JOIN aliases AS al ON (a.uid =a.uid AND al.type = 'a_vie')
+ LEFT JOIN emails AS e ON (a.uid = e.uid AND NOT FIND_IN_SET('filter', e.flags))
+ WHERE a.registration_date > {?}
+ GROUP BY al.alias
+ ORDER BY pd.promo",
+ date("Ymd000000", strtotime('last Monday')));
+if ($count = $res->total()) {
+ $message .= "$count INSCRIPTIONS CONFIRMÉES :\n";
+ while (list($forlife, $promo, $email) = $res->next()) {
+ $message .= "$promo, $forlife, $email\n";