Changeset 12211 for extensions/GMaps/gmaps_ajax.php

Timestamp:

Sep 24, 2011, 9:51:32 AM (13 years ago)

Author:

grum

Message:

fix bugs
bug:2034 - Unable to load pictures if there is categories with the same name

File:

• extensions/GMaps/gmaps_ajax.php (modified) (2 diffs)

extensions/GMaps/gmaps_ajax.php

@@ -1197 +1197 @@
       $sql="SELECT DISTINCT pgc.latitude, pgc.longitude, pgc.imageId,
                    GROUP_CONCAT(DISTINCT pic.category_id ORDER BY pic.category_id SEPARATOR ';') AS imageCatsId,
-                   GROUP_CONCAT(DISTINCT pct.name ORDER BY pct.id SEPARATOR ';') AS imageCatsNames,
+                   GROUP_CONCAT(DISTINCT CONCAT(LPAD(pct.id,6,'0'), '-', pct.name) ORDER BY pct.id SEPARATOR ';') AS imageCatsNames,
                    GROUP_CONCAT(DISTINCT IF(pct.permalink IS NULL, CONCAT('*', pct.id), pct.permalink) ORDER BY pct.id SEPARATOR ';') AS imageCatsPLink,
                    pit.name AS imageName,
@@ -1264 +1264 @@
             foreach($tmpCatsId as $key => $id)
             {
+              $tmpCatsNames[$key]=substr($tmpCatsNames[$key],7);
+
               $tmpCatsUrl[]=make_picture_url(
                 array(