Ignore:
Timestamp:
Sep 24, 2011, 9:51:32 AM (9 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.