SELECT m.uid, m.sender, 0
FROM register_marketing AS m
WHERE m.hash
- ON DUPLICATE KEY sender = VALUES(sender), success = VALUES(success)',
+ ON DUPLICATE KEY UPDATE sender = VALUES(sender), success = VALUES(success)',
$subState->s('hash'));
}
}
$r = XDB::query('SELECT id FROM groups WHERE diminutif = {?}', $yearpromo);
if ($r->numRows()) {
$asso_id = $r->fetchOneCell();
- XDB::execute('INSERT INTO group_members (uid, asso_id)
- VALUES ({?}, {?})',
+ XDB::execute('INSERT IGNORE INTO group_members (uid, asso_id)
+ VALUES ({?}, {?})',
$uid, $asso_id);
- $mmlist = new MMList($uid, S::v('password'));
+ $mmlist = new MMList($user);
$mmlist->subscribe("promo" . S::v('promo'));
}
break;