Ignore:
Timestamp:
09/24/11 09:51:32 (8 years ago)
Author:
grum
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/GMaps/gmaps_ajax.php

    r10915 r12211  
    11971197      $sql="SELECT DISTINCT pgc.latitude, pgc.longitude, pgc.imageId, 
    11981198                   GROUP_CONCAT(DISTINCT pic.category_id ORDER BY pic.category_id SEPARATOR ';') AS imageCatsId, 
    1199                    GROUP_CONCAT(DISTINCT pct.name ORDER BY pct.id SEPARATOR ';') AS imageCatsNames, 
     1199                   GROUP_CONCAT(DISTINCT CONCAT(LPAD(pct.id,6,'0'), '-', pct.name) ORDER BY pct.id SEPARATOR ';') AS imageCatsNames, 
    12001200                   GROUP_CONCAT(DISTINCT IF(pct.permalink IS NULL, CONCAT('*', pct.id), pct.permalink) ORDER BY pct.id SEPARATOR ';') AS imageCatsPLink, 
    12011201                   pit.name AS imageName, 
     
    12641264            foreach($tmpCatsId as $key => $id) 
    12651265            { 
     1266              $tmpCatsNames[$key]=substr($tmpCatsNames[$key],7); 
     1267 
    12661268              $tmpCatsUrl[]=make_picture_url( 
    12671269                array( 
Note: See TracChangeset for help on using the changeset viewer.