[Mapbender-commits] r9868 - trunk/mapbender/http/classes

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2018-02-16 03:57:11 -0800 (Fri, 16 Feb 2018)
New Revision: 9868

Modified:
   trunk/mapbender/http/classes/class_syncCkan.php
Log:


Modified: trunk/mapbender/http/classes/class_syncCkan.php
===================================================================
--- trunk/mapbender/http/classes/class_syncCkan.php	2018-02-16 11:42:52 UTC (rev 9867)
+++ trunk/mapbender/http/classes/class_syncCkan.php	2018-02-16 11:57:11 UTC (rev 9868)
@@ -1170,22 +1170,22 @@
 	//get responsible organisation information
 	if ((!isset($row['responsible_party_name']) || $row['responsible_party_name'] == '') || (!isset($row['responsible_party_email']) || $row['responsible_party_email'] == '')) {
 		//get info from mb_group_table
-		$sql = "SELECT mb_group_name, mb_group_email FROM mb_group WHERE mb_group_id = $1";
+		$sqlGroup = "SELECT mb_group_name, mb_group_email FROM mb_group WHERE mb_group_id = $1";
 		$groupId = $row['resp_party_id'];
-		$v = array($groupId);
-		$t = array('i');
-		$res = db_prep_query($sql, $v, $t);
-		if ($res) {
-	    		$row = db_fetch_assoc($res);
+		$vGroup = array($groupId);
+		$tGroup = array('i');
+		$resGroup = db_prep_query($sqlGroup, $vGroup, $tGroup);
+		if ($resGroup) {
+	    		$rowGroup = db_fetch_assoc($resGroup);
 		} else {
 	    		$e = new mb_exception("classes/class_syncCkan.php: No group found for id: ".$groupId);
 	    	return false;
 		}
-		$respPartyName = $row['mb_group_name'];
-		$respPartyEmail = $row['mb_group_email'];
+		$respPartyName = $rowGroup['mb_group_name'];
+		$respPartyEmail = $rowGroup['mb_group_email'];
 	}  else {
-		$respPartyName = $row['responsible_party_name'];
-		$respPartyEmail = $row['responsible_party_email'];
+		$respPartyName = $rowGroup['responsible_party_name'];
+		$respPartyEmail = $rowGroup['responsible_party_email'];
 	}
 	//title
 	$metadataId = $row['metadata_id'];