- XDB::execute("INSERT INTO virtual SET type = 'evt', alias = {?}",
- $new.'-participants@'.$globals->xnet->evts_domain);
-
- $lastid = XDB::insertId();
- XDB::execute('INSERT IGNORE INTO virtual_redirect (
- SELECT {?} AS vid, IF(al.alias IS NULL, a.email, CONCAT(al.alias, {?})) AS redirect
- FROM groupex.evenements_participants AS ep
- LEFT JOIN accounts AS a ON (ep.uid = a.uid)
- LEFT JOIN aliases AS al ON (al.id = a.uid AND al.type = \'a_vie\')
- WHERE ep.eid = {?} AND ep.nb > 0
- GROUP BY ep.uid)',
- $lastid, '@'.$globals->mail->domain, $eid);
-
- XDB::execute("INSERT INTO virtual SET type = 'evt', alias = {?}",
- $new.'-absents@'.$globals->xnet->evts_domain);
-
- $lastid = XDB::insertId();
+ foreach (array('-participants@', '-paye@', '-participants-non-paye@') as $v) {
+ XDB::execute("INSERT IGNORE INTO virtual_redirect (
+ SELECT {?} AS vid, IF(al.alias IS NULL, a.email, CONCAT(al.alias, {?})) AS redirect
+ FROM group_event_participants AS ep
+ LEFT JOIN #x4dat#.accounts AS a ON (ep.uid = a.uid)
+ LEFT JOIN #x4dat#.aliases AS al ON (al.id = a.uid AND al.type = 'a_vie')
+ WHERE ep.eid = {?} AND " . $where[$v] . "
+ GROUP BY ep.uid)",
+ $lastid[$v], '@' . $globals->mail->domain, $eid);
+ }