Marius Cramer
2013-10-14 d9bcf68e395d6156645a7974b1a992aa6e6c00aa
interface/web/sites/list/database.list.php
@@ -29,7 +29,7 @@
$liste["search_prefix"]    = "search_";
// Records per page
$liste["records_per_page"]    = 15;
$liste["records_per_page"]    = "15";
// Script File of the list
$liste["file"]            = "database_list.php";
@@ -68,7 +68,7 @@
                     'prefix'   => "",
                     'suffix'   => "",
                     'width'      => "",
                     'value'      => array('y' => "Yes",'n' => "No"));
                     'value'      => array('y' => "<div id=\"ir-Yes\" class=\"swap\"><span>Yes</span></div>",'n' => "<div class=\"swap\" id=\"ir-No\"><span>No</span></div>"));
if($_SESSION['s']['user']['typ'] == 'admin') {
$liste["item"][] = array(   'field'      => "sys_groupid",
@@ -99,13 +99,35 @@
                                          ),
                     'width'      => "",
                     'value'      => "");
$liste["item"][] = array(   'field'      => "database_user",
$liste["item"][] = array(   'field'      => "parent_domain_id",
                     'datatype'   => "VARCHAR",
                     'formtype'   => "TEXT",
                     'op'      => "like",
                     'prefix'   => "%",
                     'suffix'   => "%",
                            'filters'   => array( 0 => array( 'event' => 'SHOW',
                                                              'type' => 'IDNTOUTF8')
                                                ),
                     'formtype'   => "SELECT",
                     'op'      => "=",
                     'prefix'   => "",
                     'suffix'   => "",
                     'datasource'   => array (    'type'   => 'SQL',
                              'querystring' => "SELECT domain_id,domain FROM web_domain WHERE type = 'vhost' AND {AUTHSQL} ORDER BY domain",
                              'keyfield'=> 'domain_id',
                              'valuefield'=> 'domain'
                            ),
                     'width'      => "",
                     'value'      => "");
$liste["item"][] = array(   'field'      => "database_user_id",
                     'datatype'   => "INTEGER",
                     'formtype'   => "SELECT",
                     'op'      => "=",
                     'prefix'   => "",
                     'suffix'   => "",
                     'datasource'   => array (    'type'   => 'SQL',
                                          'querystring' => 'SELECT database_user_id, database_user FROM web_database_user WHERE {AUTHSQL} ORDER BY database_user',
                                          'keyfield'=> 'database_user_id',
                                          'valuefield'=> 'database_user'
                                          ),
                     'width'      => "",
                     'value'      => "");