Newer
Older
tbrehm
committed
<?php
/*
Datatypes:
- INTEGER
- DOUBLE
- CURRENCY
- VARCHAR
- TEXT
- DATE
*/
// Name of the list
if($_SESSION['s']['user']['typ'] == 'admin') {
$liste["name"] = "database_admin";
tbrehm
committed
// Database table
$liste["table"] = "web_database";
tbrehm
committed
// Index index field of the database table
$liste["table_idx"] = "database_id";
tbrehm
committed
// Search Field Prefix
$liste["search_prefix"] = "search_";
tbrehm
committed
// Records per page
$liste["records_per_page"] = "15";
tbrehm
committed
// Script File of the list
$liste["file"] = "database_list.php";
tbrehm
committed
// Script file of the edit form
$liste["edit_file"] = "database_edit.php";
tbrehm
committed
// Script File of the delete script
$liste["delete_file"] = "database_del.php";
tbrehm
committed
// Paging Template
$liste["paging_tpl"] = "templates/paging.tpl.htm";
tbrehm
committed
// Enable auth
tbrehm
committed
/*****************************************************
* Suchfelder
*****************************************************/
$liste["item"][] = array( 'field' => "active",
'datatype' => "VARCHAR",
'formtype' => "SELECT",
'op' => "=",
'prefix' => "",
'suffix' => "",
'width' => "",
'value' => array('y' => "<div id=\"ir-Yes\" class=\"swap\"><span>Yes</span></div>", 'n' => "<div class=\"swap\" id=\"ir-No\"><span>No</span></div>"));
$liste["item"][] = array( 'field' => "remote_access",
'datatype' => "VARCHAR",
'formtype' => "SELECT",
'op' => "=",
'prefix' => "",
'suffix' => "",
'width' => "",
'value' => array('y' => "<div id=\"ir-Yes\" class=\"swap\"><span>Yes</span></div>", 'n' => "<div class=\"swap\" id=\"ir-No\"><span>No</span></div>"));
tbrehm
committed
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' => "");
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
$liste["item"][] = array( 'field' => "server_id",
'datatype' => "VARCHAR",
'formtype' => "SELECT",
'op' => "like",
'prefix' => "%",
'suffix' => "%",
'datasource' => array ( 'type' => 'SQL',
'querystring' => 'SELECT server_id,server_name FROM server WHERE {AUTHSQL} AND db_server = 1 ORDER BY server_name',
'keyfield'=> 'server_id',
'valuefield'=> 'server_name'
),
'width' => "",
'value' => "");
$liste["item"][] = array( 'field' => "parent_domain_id",
'datatype' => "VARCHAR",
'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' => "");
tbrehm
committed
$liste["item"][] = array( 'field' => "database_name",