From 821ec02450f959b88d6c0e40199a696cff216e43 Mon Sep 17 00:00:00 2001 From: Nicolas Iooss Date: Sun, 16 Feb 2014 19:10:43 +0100 Subject: [PATCH] Don't select a postal address for ax_mail when delivery failed --- classes/address.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/classes/address.php b/classes/address.php index 7f26507..0b3ae04 100644 --- a/classes/address.php +++ b/classes/address.php @@ -743,7 +743,8 @@ class Address $ax_mail = XDB::fetchOneAssoc("SELECT pid, jobid, groupid, type, id FROM profile_addresses WHERE pub IN ('public', 'ax') AND FIND_IN_SET('mail', flags) AND pid = {?} - ORDER BY NOT FIND_IN_SET('current', flags), + ORDER BY FIND_IN_SET('deliveryIssue', flags), + NOT FIND_IN_SET('current', flags), FIND_IN_SET('secondary', flags), type = 'job'", $this->pid); -- 2.1.4