Newer
Older
tbrehm
committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
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
<?php
//* Title of the form
$form["title"] = "Support Message";
//* Description of the form (optional)
$form["description"] = "";
//* Name of the form. The name shall not contain spaces or foreign characters
$form["name"] = "support_message";
//* The file that is used to call the form in the browser
$form["action"] = "support_message_edit.php";
//* The name of the database table that shall be used to store the data
$form["db_table"] = "support_message";
//* The name of the database table index field, this field must be a numeric auto increment column
$form["db_table_idx"] = "support_message_id";
//* Shall changes to this table be stored in the database history (sys_datalog) table.
//* This should be set to "yes" for all tables that store configuration information.
$form["db_history"] = "no"; // yes / no
//* The name of the tab that is shown when the form is opened
$form["tab_default"] = "message";
//* The name of the default list file of this form
$form["list_default"] = "support_message_list.php";
//* Use the internal authentication system for this table. This should
//* be set to yes in most cases
$form["auth"] = 'yes'; // yes / no
//* Authentocation presets. The defaults below does not need to be changed in most cases.
$form["auth_preset"]["userid"] = 0; // 0 = id of the user, > 0 id must match with id of current user
$form["auth_preset"]["groupid"] = 0; // 0 = default groupid of the user, > 0 id must match with groupid of current user
$form["auth_preset"]["perm_user"] = 'riud'; //r = read, i = insert, u = update, d = delete
$form["auth_preset"]["perm_group"] = 'riud'; //r = read, i = insert, u = update, d = delete
$form["auth_preset"]["perm_other"] = ''; //r = read, i = insert, u = update, d = delete
//* Begin of the form definition of the first tab. The name of the tab is called "message". We refer
//* to this name in the $form["tab_default"] setting above.
$form["tabs"]['message'] = array (
'title' => "Message", // Title of the Tab
'width' => 100, // Tab width
'template' => "templates/support_message_edit.htm", // Template file name
'fields' => array (
##################################
# Begin Datatable fields
##################################
'recipient_id' => array (
'datatype' => 'INTEGER',
'formtype' => 'SELECT',
'default' => '',
'datasource' => array ( 'type' => 'SQL',
'querystring' => 'SELECT userid,username FROM sys_user WHERE {AUTHSQL} ORDER BY username',
'keyfield' => 'userid',
'valuefield' => 'username'
),
'validators' => array ( 0 => array ( 'type' => 'ISINT',
'errmsg'=> 'recipient_id_is_not_integer'),
),
'value' => ''
),
'sender_id' => array (
'datatype' => 'INTEGER',
'formtype' => 'SELECT',
'default' => '',
'datasource' => array ( 'type' => 'SQL',
'querystring' => 'SELECT userid,username FROM sys_user WHERE {AUTHSQL} ORDER BY username',
'keyfield' => 'userid',
'valuefield' => 'username'
),
'validators' => array ( 0 => array ( 'type' => 'ISINT',
'errmsg'=> 'recipient_id_is_not_integer'),
),
'value' => ''
),
'subject' => array (
'datatype' => 'VARCHAR',
'formtype' => 'TEXT',
'validators' => array ( 0 => array ( 'type' => 'NOTEMPTY',
'errmsg'=> 'subject_is_empty'),
),
'default' => '',
'value' => '',
'width' => '30',
'maxlength' => '255'
),
'message' => array (
'datatype' => 'VARCHAR',
'formtype' => 'TEXTAREA',
'validators' => array ( 0 => array ( 'type' => 'NOTEMPTY',
'errmsg'=> 'message_is_empty'),
),
'default' => '',
'value' => '',
'cols' => '30',
'rows' => '10',
'maxlength' => '255'
),
'tstamp' => array (
'datatype' => 'INTEGER',
'formtype' => 'TEXT',
'default' => time(),
'value' => '',
'width' => '30',
'maxlength' => '30'
),
##################################
# ENDE Datatable fields
##################################
)
);
?>