From dc19c4eb8c75b5ec02d2d5337b7fb63c8b61688e Mon Sep 17 00:00:00 2001
From: Till Brehm <tbrehm@ispconfig.org>
Date: Sun, 16 Feb 2014 06:27:35 -0500
Subject: [PATCH] Fixed: FS#3093 - PHPMyAdmin URL field does not accept uri symbols '?', '&' and '='

---
 interface/lib/classes/remoting.inc.php |   67 +++++++++++++++++++++++++++++----
 1 files changed, 59 insertions(+), 8 deletions(-)

diff --git a/interface/lib/classes/remoting.inc.php b/interface/lib/classes/remoting.inc.php
index ccb70e7..af0e9f9 100644
--- a/interface/lib/classes/remoting.inc.php
+++ b/interface/lib/classes/remoting.inc.php
@@ -126,8 +126,11 @@
 		$session_id = $app->db->quote($session_id);
 
 		$sql = "DELETE FROM remote_session WHERE remote_session = '$session_id'";
-		$app->db->query($sql);
-		return $app->db->affectedRows() == 1;
+		if($app->db->query($sql) != false) {
+			return true;
+		} else {
+			return false;
+		}
 	}
 
 
@@ -136,20 +139,54 @@
 	 @param int session id
 	 @param int server id
 	 @param string  section of the config field in the server table. Could be 'web', 'dns', 'mail', 'dns', 'cron', etc
-	 @author Julio Montoya <gugli100@gmail.com> BeezNest 2010
+	 @author Julio Montoya <gugli100@gmail.com> BeezNest 2010, extended by M. Cramer <m.cramer@pixcept.de> 2014
 	 */
 
 
-	public function server_get($session_id, $server_id, $section ='') {
+	public function server_get($session_id, $server_id = null, $section ='') {
 		global $app;
 		if(!$this->checkPerm($session_id, 'server_get')) {
 			$this->server->fault('permission_denied', 'You do not have the permissions to access this function.');
 			return false;
 		}
-		if (!empty($session_id) && !empty($server_id)) {
-			$app->uses('remoting_lib , getconf');
-			$section_config =  $app->getconf->get_server_config($server_id, $section);
-			return $section_config;
+		if (!empty($session_id)) {
+			if(!empty($server_id)) {
+				$app->uses('remoting_lib , getconf');
+				$section_config =  $app->getconf->get_server_config($server_id, $section);
+				return $section_config;
+			} else {
+				$servers = array();
+				$sql = "SELECT server_id FROM server WHERE 1";
+				$all = $app->db->queryAllRecords($sql);
+				foreach($all as $s) {
+					$servers[$s['server_id']] = $app->getconf->get_server_config($s['server_id'], $section);
+				}
+				unset($all);
+				unset($s);
+				return $servers;
+			}
+		} else {
+			return false;
+		}
+	}
+	
+	/**
+	    Gets a list of all servers
+	    @param int session_id
+	    @param int server_name
+	    @author Marius Cramer <m.cramer@pixcept.de> 2014
+    */
+	public function server_get_all($session_id)
+    {
+        global $app;
+		if(!$this->checkPerm($session_id, 'server_get')) {
+        	$this->server->fault('permission_denied', 'You do not have the permissions to access this function.');
+            return false;
+		}
+		if (!empty($session_id)) {
+			$sql = "SELECT server_id, server_name FROM server WHERE 1";
+			$servers = $app->db->queryAllRecords($sql);
+			return $servers;
 		} else {
 			return false;
 		}
@@ -294,6 +331,20 @@
 		return $all;
 	}
 
+	//* Get server ips
+	public function server_ip_get($session_id, $primary_id)
+	{
+		global $app;
+
+		if(!$this->checkPerm($session_id, 'server_ip_get')) {
+			$this->server->fault('permission_denied', 'You do not have the permissions to access this function.');
+			return false;
+		}
+		$app->uses('remoting_lib');
+		$app->remoting_lib->loadFormDef('../admin/form/server_ip.tform.php');
+		return $app->remoting_lib->getDataRecord($primary_id);
+	}
+	
 	//* Add a IP address record
 	public function server_ip_add($session_id, $client_id, $params)
 	{

--
Gitblit v1.9.1