[Mapbender-commits] r7806 - in trunk/mapbender/http: classes php

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2011-05-10 05:48:41 -0700 (Tue, 10 May 2011)
New Revision: 7806

Modified:
   trunk/mapbender/http/classes/class_metadata_new.php
   trunk/mapbender/http/php/mod_dataISOMetadata.php
Log:
Bugfix

Modified: trunk/mapbender/http/classes/class_metadata_new.php
===================================================================
--- trunk/mapbender/http/classes/class_metadata_new.php	2011-05-10 12:45:57 UTC (rev 7805)
+++ trunk/mapbender/http/classes/class_metadata_new.php	2011-05-10 12:48:41 UTC (rev 7806)
@@ -257,7 +257,7 @@
 				$this->databaseIdColumnName = 'wmc_serial_id';
 				$this->databaseTableName = 'wmc';
 				//the following is needed to give a special filter to the custom cat table!
-				$this->whereStrCatExtension = " AND custom_category.custom_category_hidden != 1";
+				$this->whereStrCatExtension = " AND custom_category.custom_category_hidden = 0";
 
 				switch ($this->orderBy) {
 					case "rank":

Modified: trunk/mapbender/http/php/mod_dataISOMetadata.php
===================================================================
--- trunk/mapbender/http/php/mod_dataISOMetadata.php	2011-05-10 12:45:57 UTC (rev 7805)
+++ trunk/mapbender/http/php/mod_dataISOMetadata.php	2011-05-10 12:48:41 UTC (rev 7806)
@@ -568,7 +568,7 @@
 	//pull special keywords from custom categories:
 	$e = new mb_exception("layer: ".$layerId);	
 
-	$sql = "SELECT custom_category.custom_category_key FROM custom_category, layer_custom_category WHERE layer_custom_category.fkey_layer_id = $1 AND layer_custom_category.fkey_custom_category_id =  custom_category.custom_category_id AND (custom_category_hidden <> 1 OR custom_category_hidden ISNULL)";
+	$sql = "SELECT custom_category.custom_category_key FROM custom_category, layer_custom_category WHERE layer_custom_category.fkey_layer_id = $1 AND layer_custom_category.fkey_custom_category_id =  custom_category.custom_category_id AND custom_category_hidden = 0";
 	$v = array((integer)$layerId);
 	$t = array('i');
 	$res = db_prep_query($sql,$v,$t);