[Mapbender-commits] r4349 - branches/mifan_dev/mapbender/http/php

[svn_mapbender at osgeo.org]

Author: mifan
Date: 2009-07-13 23:52:40 -0400 (Mon, 13 Jul 2009)
New Revision: 4349

Modified:
   branches/mifan_dev/mapbender/http/php/mod_loadCatalogCapabilities.php
Log:
show catalogs for a selected gui

Modified: branches/mifan_dev/mapbender/http/php/mod_loadCatalogCapabilities.php
===================================================================
--- branches/mifan_dev/mapbender/http/php/mod_loadCatalogCapabilities.php	2009-07-13 16:54:16 UTC (rev 4348)
+++ branches/mifan_dev/mapbender/http/php/mod_loadCatalogCapabilities.php	2009-07-14 03:52:40 UTC (rev 4349)
@@ -134,26 +134,26 @@
 	
 	//Change to catalog tables: mif
 	if(isset($guiList) && $guiList!=""){
-		$sql = "SELECT DISTINCT wms.wms_title,gui_wms_position from gui_wms JOIN ";
-		$sql .= "gui on gui_wms.fkey_gui_id = gui.gui_id JOIN wms ON gui_wms.fkey_wms_id = wms.wms_id ";
-		$sql .= "and gui_wms.fkey_gui_id = gui.gui_id where gui.gui_name = $1 order by gui_wms_position";
+		$sql = "SELECT DISTINCT cat.cat_title from gui_cat JOIN ";
+		$sql .= "gui on gui_cat.fkey_gui_id = gui.gui_id JOIN cat ON gui_cat.fkey_cat_id = cat.cat_id ";
+		$sql .= "and gui_cat.fkey_gui_id = gui.gui_id where gui.gui_name = $1";
 		$v = array($guiList);
 		$t = array('s');
 		$res = db_prep_query($sql,$v,$t);
 		$count=0;
-		echo"<select size='8' name='wmsList' style='width:200px'>";
+		echo"<select size='8' name='catList' style='width:200px'>";
 	
 		while($row = db_fetch_array($res)){
-			if ($row["wms_title"]!=""){
+			if ($row["cat_title"]!=""){
 				echo "<option value='' ";
-				echo ">".$row["wms_title"]."</option>";
+				echo ">".$row["cat_title"]."</option>";
 			}
 			$count++;
 		}
 	    echo "</select><br><br>";
 	}
 	else{
-		echo"<select size='8' name='wmsList' style='width:200px' on Click='submit()'>";
+		echo"<select size='8' name='catList' style='width:200px' on Click='submit()'>";
 		echo "</select><br><br>";
 	}