From 15fd11de4fa68a0dac154918f8b2b5812915c623 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Wed, 7 Jan 2009 17:14:48 +0100 Subject: [PATCH] Fixes duplicated key when adding a new membre in .net. --- modules/xnetgrp.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/modules/xnetgrp.php b/modules/xnetgrp.php index bfdea5e..43db133 100644 --- a/modules/xnetgrp.php +++ b/modules/xnetgrp.php @@ -812,8 +812,8 @@ class XnetGrpModule extends PLModule $market->add(); } } - XDB::execute('INSERT INTO groupex.membres (uid, asso_id, origine, email) - VALUES ({?}, {?}, "X", {?})', + XDB::execute('REPLACE INTO groupex.membres (uid, asso_id, origine, email) + VALUES ({?}, {?}, "X", {?})', $uid, $globals->asso('id'), $email); $this->removeSubscriptionRequest($uid); pl_redirect("member/$email"); @@ -822,9 +822,9 @@ class XnetGrpModule extends PLModule } else { $res = XDB::query('SELECT MAX(uid)+1 FROM groupex.membres'); $uid = max(intval($res->fetchOneCell()), 50001); - XDB::execute('INSERT INTO groupex.membres (uid,asso_id,origine,email) - VALUES({?},{?},"ext",{?})', $uid, - $globals->asso('id'), $email); + XDB::execute('REPLACE INTO groupex.membres (uid, asso_id, origine, email) + VALUES ({?}, {?}, "ext", {?})', + $uid, $globals->asso('id'), $email); pl_redirect("member/$email"); } } else { -- 2.1.4