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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2019-08-07 02:58:45 -0700 (Wed, 07 Aug 2019)
New Revision: 10199

Modified:
   trunk/mapbender/http/php/mod_linkedDataProxy.php
Log:
Fix - opendata filter

Modified: trunk/mapbender/http/php/mod_linkedDataProxy.php
===================================================================
--- trunk/mapbender/http/php/mod_linkedDataProxy.php	2019-08-07 09:55:21 UTC (rev 10198)
+++ trunk/mapbender/http/php/mod_linkedDataProxy.php	2019-08-07 09:58:45 UTC (rev 10199)
@@ -224,9 +224,9 @@
 if (!isset($wfsid) || $wfsid == "") {
     //list all public available wfs which are classified as opendata!
     $returnObject->service = array();
-    //$sql = "SELECT * FROM (SELECT wfs_id, wfs_version, wfs_abstract, wfs_title, wfs_owsproxy, fkey_termsofuse_id, wfs_getcapabilities, providername, fees 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, wfs_getcapabilities, providername, fees 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, wfs_getcapabilities, providername, fees FROM wfs";
+    //$sql = "SELECT wfs_id, wfs_abstract, wfs_version, wfs_title, wfs_owsproxy, wfs_getcapabilities, providername, fees FROM wfs";
     $v = array();
     $t = array();
     $res = db_prep_query($sql, $v, $t);