database.list.php 3.6 KB
Newer Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<?php

/*
	Datatypes:
	- INTEGER
	- DOUBLE
	- CURRENCY
	- VARCHAR
	- TEXT
	- DATE
*/



// Name of the list
16
17
18
19
20
if($_SESSION['s']['user']['typ'] == 'admin') {
	$liste["name"] 				= "database_admin";
} else {
	$liste["name"] 				= "database";
}
21
22
23
24
25
26
27
28
29
30
31

// Database table
$liste["table"] 			= "web_database";

// Index index field of the database table
$liste["table_idx"]			= "database_id";

// Search Field Prefix
$liste["search_prefix"] 	= "search_";

// Records per page
latham's avatar
latham committed
32
$liste["records_per_page"] 	= "15";
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61

// Script File of the list
$liste["file"]				= "database_list.php";

// Script file of the edit form
$liste["edit_file"]			= "database_edit.php";

// Script File of the delete script
$liste["delete_file"]		= "database_del.php";

// Paging Template
$liste["paging_tpl"]		= "templates/paging.tpl.htm";

// Enable auth
$liste["auth"]				= "yes";


/*****************************************************
* Suchfelder
*****************************************************/


$liste["item"][] = array(	'field'		=> "active",
							'datatype'	=> "VARCHAR",
							'formtype'	=> "SELECT",
							'op'		=> "=",
							'prefix'	=> "",
							'suffix'	=> "",
							'width'		=> "",
redray's avatar
redray committed
62
							'value'		=> array('y' => "<div id=\"ir-Yes\" class=\"swap\"><span>Yes</span></div>",'n' => "<div class=\"swap\" id=\"ir-No\"><span>No</span></div>"));
63
64
65
66
67
68
69
70

$liste["item"][] = array(	'field'		=> "remote_access",
							'datatype'	=> "VARCHAR",
							'formtype'	=> "SELECT",
							'op'		=> "=",
							'prefix'	=> "",
							'suffix'	=> "",
							'width'		=> "",
cfoe's avatar
cfoe committed
71
							'value'		=> array('y' => "<div id=\"ir-Yes\" class=\"swap\"><span>Yes</span></div>",'n' => "<div class=\"swap\" id=\"ir-No\"><span>No</span></div>"));
72

73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
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
$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'		=> "");

103
104
105
106
107
108
109
110
111
112
113
$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'
									 				  ),
114
115
116
							'width'		=> "",
							'value'		=> "");

117
118
119
120
121
122
123
124
$liste["item"][] = array(    'field'        => "database_name",
                            'datatype'    => "VARCHAR",
                            'formtype'    => "TEXT",
                            'op'        => "like",
                            'prefix'    => "%",
                            'suffix'    => "%",
                            'width'        => "",
                            'value'        => "");
125
126

?>