| | |
| | | |
| | | |
| | | // 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"; |
| | |
| | | $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"; |
| | |
| | | '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", |
| | |
| | | 'width' => "", |
| | | 'value' => ""); |
| | | |
| | | $liste["item"][] = array( 'field' => "database_name", |
| | | $liste["item"][] = array( 'field' => "database_user", |
| | | 'datatype' => "VARCHAR", |
| | | 'formtype' => "TEXT", |
| | | 'op' => "like", |
| | |
| | | 'width' => "", |
| | | 'value' => ""); |
| | | |
| | | $liste["item"][] = array( 'field' => "database_name", |
| | | 'datatype' => "VARCHAR", |
| | | 'formtype' => "TEXT", |
| | | 'op' => "like", |
| | | 'prefix' => "%", |
| | | 'suffix' => "%", |
| | | 'width' => "", |
| | | 'value' => ""); |
| | | |
| | | ?> |