From a85224e362b8556e57559a388ada77605577c2b7 Mon Sep 17 00:00:00 2001
From: x2003bruneau <x2003bruneau@839d8a87-29fc-0310-9880-83ba4fa771e5>
Date: Mon, 16 Apr 2007 19:50:51 +0000
Subject: [PATCH] Hide unused nationalities

git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@1708 839d8a87-29fc-0310-9880-83ba4fa771e5
---
 modules/search.php | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/modules/search.php b/modules/search.php
index 5a64865..832786d 100644
--- a/modules/search.php
+++ b/modules/search.php
@@ -363,7 +363,8 @@ class SearchModule extends PLModule
             $db = '`groupesx_def`';
             break;
           case 'nationalite':
-            $db = '`geoloc_pays`';
+            $db = '`geoloc_pays` INNER JOIN 
+                   `auth_user_md5` ON (`geoloc_pays`.`a2` = `auth_user_md5`.`nationalite`)';
             $field = 'IF(`nat`=\'\', `pays`, `nat`)';
             $id = '`a2`';
             break;
@@ -400,6 +401,7 @@ class SearchModule extends PLModule
         $page->assign('list', XDB::iterator('SELECT  '.$field.' AS field,
                                                      '.$id.' AS id
                                                FROM  '.$db.$where.'
+                                           GROUP BY  '.$field.'
                                            ORDER BY  '.$field));
     }
 }
-- 
2.1.4