Changeset 12213 for extensions/GMaps/gmaps_root.class.inc.php

Timestamp:

Sep 24, 2011, 12:05:07 PM (13 years ago)

Author:

grum

Message:

fix bugs
bug:2042 - Category map is not available if option "apply to subcategories" is not selected

File:

• extensions/GMaps/gmaps_root.class.inc.php (modified) (2 diffs)

extensions/GMaps/gmaps_root.class.inc.php

@@ -235 +235 @@
         if($id!=0)
         {
-          $sql.=" AND pct.id = '$id' ";
+          $sql.=" AND (pgcm.categoryId ='$id' or pct.id!='$id' AND pgcm.applySubCat='y') ";
         }
         else
         {
-          $sql.=" AND pgcm.categoryId = 0 ";
+          $sql.=" AND pgcm.categoryId = 0 AND pgcm.applySubCat='y' ";
         }
-        $sql.=" AND pgcm.applySubCat='y'
-              ORDER BY priorityRank DESC, pgmm.displayType ASC, pgcm.categoryId ASC, pgcm.imgSort ASC;";
+        $sql.=" ORDER BY priorityRank DESC, pgmm.displayType ASC, pgcm.categoryId ASC, pgcm.imgSort ASC;";
       }
       elseif($mode==self::ID_MODE_MAP)
@@ -259 +258 @@
         return(false);
       }
-
       $result=pwg_query($sql);