[Mapbender-commits] r7613 - trunk/mapbender/http/geoportal

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2011-02-16 04:31:03 -0800 (Wed, 16 Feb 2011)
New Revision: 7613

Modified:
   trunk/mapbender/http/geoportal/mod_initialStartWmc.php
Log:
bugfix

Modified: trunk/mapbender/http/geoportal/mod_initialStartWmc.php
===================================================================
--- trunk/mapbender/http/geoportal/mod_initialStartWmc.php	2011-02-16 07:40:38 UTC (rev 7612)
+++ trunk/mapbender/http/geoportal/mod_initialStartWmc.php	2011-02-16 12:31:03 UTC (rev 7613)
@@ -59,14 +59,23 @@
 if ($languageCode == 'en'){
 	$pathToLoadScript = '/portal/en/maps.html?WMC=';
 }
+/*
 //define sql for selecting informations from database:
+
 $sql = "";
 $sql .= "SELECT search_wmc_view.wmc_serial_id,search_wmc_view.wmc_title,search_wmc_view.wmc_abstract, custom_category.custom_category_code_".$languageCode. ", search_wmc_view.load_count ";
 $sql .= "FROM search_wmc_view INNER JOIN wmc_custom_category ON "; 
 $sql .= "(wmc_custom_category.fkey_wmc_serial_id=search_wmc_view.wmc_serial_id) INNER JOIN custom_category ON ";
 $sql .= "(custom_category.custom_category_id=wmc_custom_category.fkey_custom_category_id) WHERE ";
 $sql .= "custom_category.custom_category_key = 'mbc1' ORDER BY search_wmc_view.load_count DESC LIMIT $1 ";
+*/
+//define sql for selecting informations from database:
+$sql = "";
+$sql .= "SELECT search_wmc_view.wmc_serial_id,search_wmc_view.wmc_title,search_wmc_view.wmc_abstract, search_wmc_view.load_count ";
+$sql .= "FROM search_wmc_view ORDER BY search_wmc_view.load_count DESC LIMIT $1 ";
 
+
+
 $v = array($maxObjects);
 $t = array('i');
 $res = db_prep_query($sql,$v,$t);