You are here: The Zugzwang Project > Technical Documentation

Technical Documentation

Selection Teilbaum:: $ops; $page; $zz; $zz_conf; $zz_conf INTERNAL; $zz_conf UPLOAD; $zz_error; $zz_page; $zz_setting; $zz_sql; $zz_tab; $zz_var; WEBSERVER_DIRECTORY; zz_constants; zz_fieldtypes; zz_states; zzbrick; zzform; zzwrap; – all –

ID	Category	Req.	Element	Action
207	string: field	no	$zz['conditions'][n]['add']['key_field_name'] To make clear if a condition is true or not while adding a record. Key field name; the corresponding value from $zz_conf['add'] will be used for the SQL query in 'sql'. Relations: $zz['conditions'][n]['add']['sql']; $zz_conf['add']	Show
206	string: SQL	no	$zz['conditions'][n]['add']['sql'] To make clear if a condition is true or not while adding a record. SQL query ending with `WHERE key_field_name = ` where value of 'key_field_name' will be added. Together with the 'where' or 'having'-condition, if this SQL query returns more than 0 lines, the condition is considered as true. If no line is returned, the condition is considered as false. Relations: $zz['conditions'][n]['add']['key_field_name']; $zz_conf['add']	Show
910	boolean	no	$zz['conditions'][n]['add']['where'] if set to true, WHERE restrictions will be checked by this condition ($zz['conditions'][n]['where'] must be set) Relations: $zz['conditions'][n]['where']	Show
212	string: field	no	$zz['conditions'][n]['field_name']	Show
815	string: function	no	$zz['conditions'][n]['function'] use function which has to return a list of allowed IDs (ID => true)	Show
211	string: SQL	no	$zz['conditions'][n]['having']	Show
203	string	no	$zz['conditions'][n]['scope'] * record: with 'having' or 'where'; add['sql'], add['key_field_name'] * query: with 'sql' and 'key_field_name' * value: with 'sql' and 'field_name' * access: with 'function' and custom fields * upload (thought of, not yet implemented) * where: with 'field_name', triggers if a WHERE is set in the query for this field_name (shortcut in fields definition possible) * multi: if script is called via zzform_multi() * subrecord: with subrecord and where * noid: if an ID is so far not set (add before insert) * editing: checks where and POST value for a given field_name and if the adjoining query returns true, the condition is met (useful for adding/changing records, where a condition depends on a field value)	Show
208	string: SQL	no	$zz['conditions'][n]['sql']	Show
209	string: field	no	$zz['conditions'][n]['key_field_name']	Show
943	integer	no	$zz['conditions'][n]['subrecord'] index of subrecord in table definition this condition can be applied to	Show
205	string: SQL	no	$zz['conditions'][n]['where']	Show
948	boolean	no	$zz['dont_show_h1'] if set to true, h1 will not be shown	Show
235	array: path	no	$zz['dynamic_referer'] referer which links back to previous page, overwrites $zz_conf['referer'] and must be array with field1, string1 etc. Relations: $zz['fields'][n]['path']; $zz_conf['referer']	Show
242	string	no	$zz['extra_action'] action to be performed after or before insert, update, delete array values: `before_update`, `before_insert`, `before_delete`, `after_update`, `after_insert`, `after_delete`, `upload` value: file to be included without ending ".inc.php"; alternatively this might also be the name of an existing function if you do insert/update/delete queries, you might want to add them to the logging table with zz_log_sql($sql, $user, $record_id); ($sql being the query, $user the username) Relations: ACTION	Show
10	array	yes	$zz['fields'][n] Description of all table fields which shall be shown to edit a record or in list display (array). 'n' is a number and may be chosen freely (no order required). First field definition must be PRIMARY_KEY For the display order in form and list view, the order in the code is important, not the order of the numbers	Show
354	string	no	$zz['fields'][n]['access'] access on record basis `show`: makes a subrecord not editable, just viewable Relations: $zz['access']	Show
983	boolean	no	$zz['fields'][n]['add_details_destination'] paste input of main form to this field if a detail record is added via 'add_details' Relations: $zz['fields'][n]['add_details']	Show
420	string	no	$zz['fields'][n]['add_details'] add detail records in different table, attention: current input will not be saved. Field gets ID #zz_add_details_x_y_z where x is table no [0...n], y is for subtable no [0 if main table, else 0...n] z is field number in zz-array Relations: select	Show
437	string: HTML	no	$zz['fields'][n]['add_details_target'] HTML: target attribute for add_details link (target="")	Show
866	boolean	no	$zz['fields'][n]['always_check_select'] always perform check select, even if select/option-elements are sent with the form	Show

916 records total