- $res = XDB::query('SELECT id
- FROM groupex.asso
- WHERE diminutif = {?}',
- S::v('promo'));
- $asso_id = $res->fetchOneCell();
- XDB::execute('REPLACE INTO groupex.membres (uid, asso_id)
- VALUES ({?}, {?})',
- S::v('uid'), $asso_id);
- $mmlist = new MMList(S::v('uid'), S::v('password'));
- $mmlist->subscribe('promo' . S::v('promo'));
+ XDB::execute('INSERT IGNORE INTO group_members (uid, asso_id)
+ SELECT {?}, id
+ FROM groups
+ WHERE diminutif = {?}',
+ $user->id(), $user->profile()->yearPromo());
+ $mmlist = new MMList($user);
+ $mmlist->subscribe('promo' . $user->profile()->yearPromo());