From a47c5eab80595b50004f905c261d9db2a2d63908 Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Mon, 18 Apr 2011 13:40:02 +0200
Subject: [PATCH] Fixes autocomplete on countries: only counts countries for
 home addresses (Closes #1470).
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Stéphane Jacob <sj@m4x.org>
---
 ChangeLog           | 1 +
 classes/direnum.php | 1 +
 2 files changed, 2 insertions(+)

diff --git a/ChangeLog b/ChangeLog
index 0516778..915fd92 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -13,6 +13,7 @@ Bug/Wish:
     * Search:
         - #911: Adds search on corps                                       -JAC
         - #990: Adds search on broken redirections                         -JAC
+        - #1470: Fixes autocomplete on countries                           -JAC
 
     * XnetList:
         - #957: Allows xnet list sorting by description and members count  -JAC
diff --git a/classes/direnum.php b/classes/direnum.php
index e45164c..a616061 100644
--- a/classes/direnum.php
+++ b/classes/direnum.php
@@ -600,6 +600,7 @@ class DE_Countries extends DirEnumeration
 
     protected $ac_join   = 'INNER JOIN profile_addresses ON (geoloc_countries.iso_3166_1_a2 = profile_addresses.countryId)';
     protected $ac_unique = 'profile_addresses.pid';
+    protected $ac_where  = 'profile_addresses.type = \'home\'';
 }
 // }}}
 
-- 
2.1.4