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

Timestamp:

Oct 9, 2010, 12:28:05 AM (14 years ago)

Author:

grum

Message:

KML files manager implemented + fixe some small bugs + forgotten file for the search page

File:

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

extensions/GMaps/gmaps_root.class.inc.php

@@ -76 +76 @@
       $this->section_name=$this->getPluginNameFiles();
 
-      $this->setTablesList(array('maps', 'category_maps', 'cache'));
+      $this->setTablesList(array('maps', 'category_maps', 'cache', 'kmlfiles'));
       $this->css = new GPCCss(dirname($this->getFileLocation()).'/'.$this->getPluginNameFiles().".css");
     }
@@ -203 +203 @@
        */
       $sql="SELECT DISTINCT pgcm.id, pgcm.categoryId,
-              pgcm.imgSort, pgcm.applySubCat, pgcm.kmlFileUrl,
+              pgcm.imgSort, pgcm.applySubCat, pgcm.kmlFileUrl, pgcm.kmlFileId, pgkf.file AS kmlFileUrlId,
               pgcm.icon, pgcm.title,
               pgmm.displayType, pgmm.sizeMode,
@@ -210 +210 @@
               pgmm.navigationControl, pgmm.style,
               IF(pgcm.categoryId=0, 0, pct.global_rank) AS priorityRank
-            FROM (".$this->tables['category_maps']." pgcm
-              LEFT JOIN ".$this->tables['maps']." pgmm ON pgcm.mapId = pgmm.id)
-              LEFT JOIN ".CATEGORIES_TABLE." pct ON (FIND_IN_SET(pgcm.categoryId, pct.uppercats)!=0 OR pgcm.categoryId=0)
+            FROM ((".$this->tables['category_maps']." pgcm
+                  LEFT JOIN ".$this->tables['maps']." pgmm ON pgcm.mapId = pgmm.id)
+                  LEFT JOIN ".CATEGORIES_TABLE." pct ON (FIND_IN_SET(pgcm.categoryId, pct.uppercats)!=0 OR pgcm.categoryId=0))
+                  LEFT JOIN ".$this->tables['kmlfiles']." pgkf ON  pgkf.id = pgcm.kmlFileId
             WHERE $where ";
       if($category!=0)
@@ -237 +238 @@
         while($row=pwg_db_fetch_assoc($result))
         {
+          // if an kml file id is given, apply the url of the file (needs to give the complete URI for google)
+          if($row['kmlFileId']>0 and $row['kmlFileUrlId']!='') $row['kmlFileUrl']=dirname($_SERVER['SCRIPT_URI']).'/plugins/GMaps/kml/'.$row['kmlFileUrlId'];
+
           if($row['displayType']!='MP')
           {