X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fuserset.inc.php;h=8dc2794bb3c9919ac8e7fbc8f92e325d7680f35b;hb=e5858f67fe357e76fae0b08c481bc8d49f4a20a8;hp=62b5a02e151d823f869fdfe0e654ea628d1e5336;hpb=d89a495539357b3ad30f7b891bd23d1805355a52;p=platal.git

diff --git a/include/userset.inc.php b/include/userset.inc.php
index 62b5a02..8dc2794 100644
--- a/include/userset.inc.php
+++ b/include/userset.inc.php
@@ -425,17 +425,19 @@ class AddressesView implements PlView
     {
         $pids = $this->set->getIds(new PlLimit());
         $visibility = Visibility::defaultForRead(Visibility::VIEW_AX);
-        pl_cached_content_headers('text/x-csv', 1);
+        pl_cached_content_headers('text/x-csv', 'utf-8', 1, 'adresses.csv');
 
         $csv = fopen('php://output', 'w');
         fputcsv($csv, array('adresses'), ';');
-        $res = XDB::query('SELECT  pd.public_name, pa.postalText
-                             FROM  profile_addresses AS pa
-                       INNER JOIN  profile_display   AS pd ON (pd.pid = pa.pid)
-                            WHERE  pa.type = \'home\' AND pa.pub IN (\'public\', \'ax\') AND FIND_IN_SET(\'mail\', pa.flags) AND pa.pid IN {?}
-                         GROUP BY  pa.pid', $pids);
-        foreach ($res->fetchAllAssoc() as $item) {
-            fputcsv($csv, $item, ';');
+        if (!empty($pids)) {
+            $res = XDB::query('SELECT  pd.public_name, pa.postalText
+                                 FROM  profile_addresses AS pa
+                           INNER JOIN  profile_display   AS pd ON (pd.pid = pa.pid)
+                                WHERE  pa.type = \'home\' AND pa.pub IN (\'public\', \'ax\') AND FIND_IN_SET(\'mail\', pa.flags) AND pa.pid IN {?}
+                             GROUP BY  pa.pid', $pids);
+            foreach ($res->fetchAllAssoc() as $item) {
+                fputcsv($csv, $item, ';');
+            }
         }
         fclose($csv);
         exit();