ftimme
2012-05-30 2cb1563f63386b35a69e460051aa9b4a2851d104
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";
@@ -25,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";
@@ -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",
@@ -80,7 +100,7 @@
                     'width'      => "",
                     'value'      => "");
$liste["item"][] = array(   'field'      => "database_name",
$liste["item"][] = array(   'field'      => "database_user",
                     'datatype'   => "VARCHAR",
                     'formtype'   => "TEXT",
                     'op'      => "like",
@@ -89,5 +109,13 @@
                     'width'      => "",
                     'value'      => "");
$liste["item"][] = array(    'field'        => "database_name",
                            'datatype'    => "VARCHAR",
                            'formtype'    => "TEXT",
                            'op'        => "like",
                            'prefix'    => "%",
                            'suffix'    => "%",
                            'width'        => "",
                            'value'        => "");
?>