3 require('connect.db.inc.php');
6 // ---------------------------------------
9 "SELECT a.alias, u.promo, email
10 FROM auth_user_md5 AS u
11 LEFT JOIN aliases AS a ON( u.user_id=a.id AND a.type='a_vie' )
12 LEFT JOIN emails AS e ON( e.uid = u.user_id AND NOT FIND_IN_SET('filter',e.flags) )
13 WHERE u.date_ins > {?}
15 ORDER BY promo", date("Ymd000000", strtotime ("last Monday")));
16 if ($a = $res->total()) {
17 $MESSAGE.="$a INSCRIPTIONS CONFIRMEES:\n";
18 while (list($usern,$promo,$mail) = $res->next()) {
19 $MESSAGE.="X$promo, $usern, $mail\n";
23 // ---------------------------------------
26 "SELECT u.hruid, r.email, r.date
27 FROM register_pending AS r
28 LEFT JOIN auth_user_md5 AS u ON (u.user_id = r.uid)
29 WHERE r.hash != 'INSCRIT'
31 if ($b = $res->total()) {
32 $MESSAGE.="\n$b INSCRIPTIONS NON CONFIRMEES:\n";
33 while (list($usern, $mail, $quand) = $res->next()) {
34 $MESSAGE.="$quand, $usern,\n $mail\n";
38 // ---------------------------------------
40 $res = XDB
::query('SELECT COUNT(DISTINCT uid), COUNT(*) FROM register_marketing');
41 list($a, $b) = $res->fetchOneRow();
42 $MESSAGE .= "\nINSCRIPTIONS SOLICITÉES :\n";
43 $MESSAGE .= " $a utilisateurs\n $b adresses email\n";
45 // ---------------------------------------
49 $mailer = new PlMailer();
50 $mailer->setSubject("$a confirmées, $b en attente et $c sollicitées");
51 $mailer->setFrom($globals->register
->notif
);
52 $mailer->addTo($globals->register
->notif
);
53 $mailer->setTxtBody($MESSAGE);
55 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: