From 7d6ec3d7c30e64d37dedd4ace570a97c1fd2149b Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Tue, 22 Jun 2010 06:20:03 -0400
Subject: [PATCH] Implemented: FS#479 - Which domains belong to which Client

---
 interface/web/sites/list/database.list.php |   22 +++++++++++++++++++++-
 1 files changed, 21 insertions(+), 1 deletions(-)

diff --git a/interface/web/sites/list/database.list.php b/interface/web/sites/list/database.list.php
index 2fce763..68b4b96 100644
--- a/interface/web/sites/list/database.list.php
+++ b/interface/web/sites/list/database.list.php
@@ -13,7 +13,11 @@
 
 
 // Name of the list
-$liste["name"] 				= "database";
+if($_SESSION['s']['user']['typ'] == 'admin') {
+	$liste["name"] 				= "database_admin";
+} else {
+	$liste["name"] 				= "database";
+}
 
 // Database table
 $liste["table"] 			= "web_database";
@@ -66,6 +70,22 @@
 							'width'		=> "",
 							'value'		=> array('y' => "Yes",'n' => "No"));
 
+if($_SESSION['s']['user']['typ'] == 'admin') {
+$liste["item"][] = array(	'field'		=> "sys_groupid",
+							'datatype'	=> "INTEGER",
+							'formtype'	=> "SELECT",
+							'op'		=> "=",
+							'prefix'	=> "",
+							'suffix'	=> "",
+							'datasource'	=> array ( 	'type'	=> 'SQL',
+														'querystring' => 'SELECT groupid, name FROM sys_group WHERE groupid != 1 ORDER BY name',
+														'keyfield'=> 'groupid',
+														'valuefield'=> 'name'
+									 				  ),
+							'width'		=> "",
+							'value'		=> "");
+}
+
 $liste["item"][] = array(	'field'		=> "server_id",
 							'datatype'	=> "VARCHAR",
 							'formtype'	=> "SELECT",

--
Gitblit v1.9.1