Changeset 12211


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

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.