From 77eeb090ba794485cd0d1865b4d62c97288120e1 Mon Sep 17 00:00:00 2001
From: vogelor <vogelor@ispconfig3>
Date: Wed, 26 May 2010 07:12:55 -0400
Subject: [PATCH] Improvement of the domain - module : The group, the domain belongs to is also listed

---
 interface/web/domain/list/domain.list.php |   17 ++++++++++++++++-
 1 files changed, 16 insertions(+), 1 deletions(-)

diff --git a/interface/web/domain/list/domain.list.php b/interface/web/domain/list/domain.list.php
index bd96add..e9630e3 100644
--- a/interface/web/domain/list/domain.list.php
+++ b/interface/web/domain/list/domain.list.php
@@ -76,9 +76,24 @@
 $liste["item"][] = array(	'field'		=> "domain",
 							'datatype'	=> "VARCHAR",
 							'formtype'	=> "TEXT",
-							'op'		=> "like",
+							'op'		=> "LIKE",
 							'prefix'	=> "%",
 							'suffix'	=> "%",
 							'width'		=> "",
 							'value'		=> "");
+
+$liste["item"][] = array(	'field'		=> "sys_groupid",
+							'datatype'	=> "VARCHAR",
+							'formtype'	=> "SELECT",
+							'op'		=> "=",
+							'prefix'	=> "",
+							'suffix'	=> "",
+							'datasource'	=> array ( 	'type'	=> 'SQL',
+														'querystring' => 'SELECT a.groupid, a.name FROM sys_group a, domain b WHERE (a.groupid = b.sys_groupid) AND ({AUTHSQL-B}) ORDER BY name',
+														'keyfield'=> 'groupid',
+														'valuefield'=> 'name'
+									 				  ),
+							'width'		=> "",
+							'value'		=> "");
+
 ?>
\ No newline at end of file

--
Gitblit v1.9.1