- XDB::execute('REPLACE INTO groupex.evenements
- SET eid={?}, asso_id={?}, organisateur_uid={?}, intitule={?},
- paiement_id = {?}, descriptif = {?}, debut = {?},
- fin = {?}, show_participants = {?}, short_name = {?},
- deadline_inscription = {?}, noinvite = {?},
- accept_nonmembre = {?}',
- $evt['eid'], $evt['asso_id'], $evt['organisateur_uid'],
- $evt['intitule'], $evt['paiement_id'], $evt['descriptif'],
- $evt['debut'], $evt['fin'], $evt['show_participants'],
- $evt['short_name'], $evt['deadline_inscription'],
- $evt['noinvite'], $evt['accept_nonmembre']);
+ XDB::execute('INSERT INTO group_events (eid, asso_id, uid, intitule, paiement_id,
+ descriptif, debut, fin, show_participants,
+ short_name, deadline_inscription, noinvite,
+ accept_nonmembre)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})
+ ON DUPLICATE KEY UPDATE asso_id = VALUES(asso_id), uid = VALUES(uid), intitule = VALUES(intitule),
+ paiement_id = VALUES(paiement_id), descriptif = VALUES(descriptif), debut = VALUES(debut),
+ fin = VALUES(fin), show_participants = VALUES(show_participants), short_name = VALUES(short_name),
+ deadline_inscription = VALUES(deadline_inscription), noinvite = VALUES(noinvite)',
+ $evt['eid'], $evt['asso_id'], $evt['uid'],
+ $evt['intitule'], $evt['paiement_id'], $evt['descriptif'],
+ $evt['debut'], $evt['fin'], $evt['show_participants'],
+ $evt['short_name'], $evt['deadline_inscription'],
+ $evt['noinvite'], $evt['accept_nonmembre']);