Changeset 12211


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

Location:
extensions/GMaps
Files:
2 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( 
  • extensions/GMaps/main.inc.php

    r12204 r12211  
    108108|         |            |     in description 
    109109|         |            | 
    110 |         |            | 
    111 |         |            | 
    112 |         |            | 
     110|         |            | * mantis bug:2034 
     111|         |            |   . Unable to load pictures if there is categories with 
     112|         |            |     the same name 
    113113|         |            | 
    114114|         |            | 
Note: See TracChangeset for help on using the changeset viewer.