From 9ff5d6906470c573accfae1648fea450c7fa15d8 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Fri, 7 Aug 2009 01:32:12 +0200 Subject: [PATCH] Prevents mysql error when adding the same email for a second time to an alias. --- modules/xnetlists.php | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/modules/xnetlists.php b/modules/xnetlists.php index 036452e..12a2cde 100644 --- a/modules/xnetlists.php +++ b/modules/xnetlists.php @@ -272,20 +272,20 @@ class XnetListsModule extends ListsModule if (list($alias, $blias) = $res->fetchOneRow()) { $alias = empty($blias) ? $alias : $blias; XDB::query( - "INSERT INTO x4dat.virtual_redirect (vid,redirect) - SELECT vid, {?} - FROM x4dat.virtual - WHERE alias={?}", "$alias@m4x.org", $lfull); + "INSERT IGNORE INTO x4dat.virtual_redirect (vid,redirect) + SELECT vid, {?} + FROM x4dat.virtual + WHERE alias={?}", "$alias@m4x.org", $lfull); $page->trigSuccess("$alias@m4x.org ajouté"); } else { $page->trigError("$mbox@{$globals->mail->domain} n'existe pas."); } } else { XDB::query( - "INSERT INTO x4dat.virtual_redirect (vid,redirect) - SELECT vid,{?} - FROM x4dat.virtual - WHERE alias={?}", "$mbox@$dom", $lfull); + "INSERT IGNORE INTO x4dat.virtual_redirect (vid,redirect) + SELECT vid,{?} + FROM x4dat.virtual + WHERE alias={?}", "$mbox@$dom", $lfull); $page->trigSuccess("$mbox@$dom ajouté"); } } -- 2.1.4