[Mapbender-commits] r10192 - trunk/mapbender/http/php

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2019-08-01 02:32:44 -0700 (Thu, 01 Aug 2019)
New Revision: 10192

Modified:
   trunk/mapbender/http/php/mod_linkedDataProxy.php
Log:
Fix for open data filter

Modified: trunk/mapbender/http/php/mod_linkedDataProxy.php
===================================================================
--- trunk/mapbender/http/php/mod_linkedDataProxy.php	2019-08-01 09:27:09 UTC (rev 10191)
+++ trunk/mapbender/http/php/mod_linkedDataProxy.php	2019-08-01 09:32:44 UTC (rev 10192)
@@ -267,9 +267,9 @@
 		//list all public available wfs which are classified as opendata!
 		$openWfs = new stdClass();
 		$openWfs->list = array();
-		//$sql = "SELECT * FROM (SELECT wfs_id, wfs_version, wfs_abstract, wfs_title, wfs_owsproxy, fkey_termsofuse_id FROM wfs INNER JOIN wfs_termsofuse ON wfs_id = fkey_wfs_id) AS wfs_tou INNER JOIN termsofuse ON fkey_termsofuse_id = termsofuse_id WHERE isopen = 1";
+		$sql = "SELECT * FROM (SELECT wfs_id, wfs_version, wfs_abstract, wfs_title, wfs_owsproxy, fkey_termsofuse_id FROM wfs INNER JOIN wfs_termsofuse ON wfs_id = fkey_wfs_id) AS wfs_tou INNER JOIN termsofuse ON fkey_termsofuse_id = termsofuse_id WHERE isopen = 1";
 		//all wfs - without open filter!
-		$sql = "SELECT wfs_id, wfs_abstract, wfs_version, wfs_title, wfs_owsproxy FROM wfs";
+		//$sql = "SELECT wfs_id, wfs_abstract, wfs_version, wfs_title, wfs_owsproxy FROM wfs";
 		$v = array();
 		$t = array();
 		$res = db_prep_query($sql, $v, $t);