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 |
---|---|---|---|---|
735 | array | no | $ops Returned array from zzform() with information about the record and the HTML output back to the calling script Relations: zzform() | Show |
790 | boolean | no | $ops['critical_error'] true: better exit script with 503 Service Unavailable, false: everything ok | Show |
806 | array | no | $ops['error_mail'] Relations: $zz_conf['int']['error'] | Show |
729 | array | no | $ops['error'] Internal variable, outputs errors if they are good for zzform_multi() | Show |
957 | boolean | no | $ops['file_upload'] signals if there was a file upload or not, useful for extra_action | Show |
663 | array | no | $ops['headers'] HTTP headers | Show |
823 | array | no | $ops['meta'] Meta tags, written by zzform (if a table is made public, to avoid indexing of search results, order by-tables and edit forms) | Show |
665 | string | no | $ops['mode'] INTERNAL: what to prepare (GET): add | edit | delete | show | Show |
784 | array | no | $ops['not_validated'] Relations: $ops['planned'] | Show |
664 | string: HTML | no | $ops['output'] HTML output of zzform() Relations: $zz_conf['show_output'] | Show |
667 | array | no | $ops['planned'] | Show |
702 | array | no | $ops['record_diff'] shows information after database operation about status of each field in a record:
- `same`: field has not changed
- `diff`: field has changed
- `insert`: record was inserted (no old record)
- `delete`: record was deleted (no new record)
Relations: $ops['record_new']; $ops['record_old'] | Show |
669 | array | no | $ops['record_new'] Record as it was posted after validation of input the way it will be saved in database Relations: $ops['record_old'] | Show |
670 | array | no | $ops['record_old'] In some cases, old record will be queried, it can be found here. It does not have exactly the same fields as `record_new` but a few more, depending on SQL query for this record. The old record won't be saved in case $zz_conf['get_old_record'] is false or there's no upload field or no write_once field. Relations: $ops['record_new'] | Show |
697 | string | no | $ops['result'] gives result of operation if at all: `successful_insert`, `successful_update`, `successful_delete` Relations: $zz_conf['redirect'] | Show |
668 | array | no | $ops['return'] interface: for each database operation this array returns numerically indexed information about the database operation: 'table' = name of database table; 'id_field_name': field name of field with PRIMARY KEY, 'id_value': ID of record, 'action': database action, one of 'insert', 'update', 'delete' | Show |
241 | string: HTML | no | $ops['title'] Relations: $zz['title']; OUTPUT | Show |
726 | string: HTML | no | $zz_conf['title_separator'] Separator for output of selection, q and page in page title | Show |
936 | integer | no | $ops['total_rows'] number of rows that match the list query | Show |
930 | string | no | $ops['url'] correct URL of form script, invalid filters etc. removed Relations: $zz_conf['int']['url'] | Show |
627 | array | yes | $page Relations: zzbrick | Show |
631 | array | no | $page['extra'] User defined values, whatever you want. Access from template to these variables might go via extra_blubb = bla, but just if the variable is not an array (then we'll return `1`) | Show |
630 | array | no | $page['head'] Relations: brick_head_format() | Show |
629 | array | no | $page['link'] May be used for page links, e. g. navigational aides. Content of this element may be put inside HTML head element starting `<LINK REL="">` or somewhere else on page (or both). Will be added to $page['head'] automatically Relations: $page['head']; brick_head_format() | Show |
632 | array | no | $page['meta'] $page['meta'][n]['name'] = ...
$page['meta'][n]['content'] = ... Relations: $page['head']; brick_head_format() | Show |
628 | string | no | $page['style'] defines style of page, might be used to include different page heads or footers, separate css files and so on | Show |
6 | array | yes | $zz Description of database table and fields | Show |
353 | string | no | $zz['access'] allows to restrict access to main record, like $zz['fields'][n]['access'] to subtables
* add_only: only allow to add record, do not show anything else (add new record-link, list table, ...)
* edit_only: only allow to edit record, do not show anything else (add new record-link, list table, ...)
* show: only view records
* show_edit_add (no deletion possible)
* show_and_add (no deletion and editing possible, but adding new records)
* show_and_delete
* add_then_edit: only allow to add a new record, then to reedit this record if it already exists (only works with GET['where']...)
* edit_details_only: do not edit main record, allow only detail records to be edited, no deletion and adding possible
* edit_details_and_add: do not edit main record, allow only detail records to be edited, adding possible (works only in combination with conditions)
* none: only show list, no possibility to do anything with the records
* all: allows to do everything
* search_but_no_list: shows search form but no list (search form normally is tied to list), no editing allowed Relations: $zz['fields'][n]['access'] | Show |
954 | boolean | no | $zz['add_from_source_id'] Allows to add from source_id even if the access to that ID is restricted by a $zz['where'] or $_GET['where'] | Show |
751 | array | no | $zz['conditional_fields'] | Show |
752 | array | no | $zz['conditional_fields'][n] | Show |
759 | array | no | $zz['conditional_fields'][n]['fi Relations: $zz['fields'][n] | Show |
758 | string | no | $zz['conditional_fields'][n]['ma | Show |
754 | boolean | no | $zz['conditional_fields'][n]['re | Show |
757 | string: SQL | no | $zz['conditional_fields'][n]['sq | Show |
756 | string | no | $zz['conditional_fields'][n]['ta | Show |
753 | integer | no | $zz['conditional_fields'][n]['te | Show |
755 | string | no | $zz['conditional_fields'][n]['ti | Show |
204 | array | no | $zz['conditions'] Numerical indexed array of conditions | Show |
798 | boolean | no | $zz['conditions'][n]['add']['alw | Show |
207 | string: field | no | $zz['conditions'][n]['add']['key Relations: $zz['conditions'][n]['add']['sql']; $zz_conf['add'] | Show |
206 | string: SQL | no | $zz['conditions'][n]['add']['sql Relations: $zz['conditions'][n]['add']['key_field_name']; $zz_conf['add'] | Show |
910 | boolean | no | $zz['conditions'][n]['add']['whe 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_ | Show |
943 | integer | no | $zz['conditions'][n]['subrecord' | 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_de 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_ta | Show |
866 | boolean | no | $zz['fields'][n]['always_check_s | Show |
409 | string | no | $zz['fields'][n]['auto_value'] increment | ... // 1 will be added and inserted in 'default' Relations: number | Show |
430 | array | no | $zz['fields'][n]['calculation_fi Relations: calculated | Show |
431 | string | no | $zz['fields'][n]['calculation'] hours | sum (only supported modes) Relations: calculated | Show |
919 | string | no | $zz['fields'][n]['character_set' | Show |
199 | string: HTML | no | $zz['fields'][n]['class_add'] class name that will be shown if a subrecord will be added Relations: subtable | Show |
176 | string: HTML | no | $zz['fields'][n]['class'] class="" (some classes will be added by zzform, e. g. idrow, ...) | Show |
411 | integer | no | $zz['fields'][n]['cols'] number of cols in textarea Relations: memo | Show |
870 | string | no | $zz['fields'][n]['concat_0'] strings to format fields from sql query; sprintf will be used on these to insert the field value Relations: $zz['fields'][n]['sql']; select; $zz['fields'][n]['concat_fields'] | Show |
869 | string | no | $zz['fields'][n]['concat_fields' Relations: $zz['fields'][n]['sql']; select | Show |
357 | array | no | $zz['fields'][n]['conf_identifie | Show |
358 | string | no | $zz['fields'][n]['conf_identifie | Show |
902 | array | no | $zz['fields'][n]['conf_identifie | Show |
1001 | string | no | $zz['fields'][n]['conf_identifie | Show |
829 | string: function | no | $zz['fields'][n]['conf_identifie | Show |
360 | string | no | $zz['fields'][n]['conf_identifie | Show |
359 | string | no | $zz['fields'][n]['conf_identifie | Show |
963 | string: function | no | $zz['fields'][n]['conf_identifie Relations: $zz['fields'][n]['conf_identifier']['function'] | Show |
962 | string: function | no | $zz['fields'][n]['conf_identifie | Show |
828 | array | no | $zz['fields'][n]['conf_identifie Relations: $zz['fields'][n]['fields'] | Show |
827 | array | no | $zz['fields'][n]['conf_identifie Relations: $zz['fields'][n]['fields'] | Show |
361 | boolean | no | $zz['fields'][n]['conf_identifie | Show |
880 | integer | no | $zz['fields'][n]['conf_identifie | Show |
470 | string | no | $zz['fields'][n]['conf_identifie | Show |
891 | array | no | $zz['fields'][n]['conf_identifie Relations: identifier | Show |
362 | boolean | no | $zz['fields'][n]['conf_identifie | Show |
469 | boolean | no | $zz['fields'][n]['conf_identifie | Show |
468 | integer | no | $zz['fields'][n]['conf_identifie | Show |
972 | string: SQL | no | $zz['fields'][n]['conf_identifie Relations: $zz['fields'][n]['conf_identifier']['where'] | Show |
363 | string: SQL | no | $zz['fields'][n]['conf_identifie | Show |
860 | integer | no | $zz['fields'][n]['decrease_level Relations: $zz['list']['hierarchy']['display_in'] | Show |
466 | boolean | no | $zz['fields'][n]['def_val_ignore Relations: subtable | Show |
278 | mixed | no | $zz['fields'][n]['default_image' | Show |
639 | boolean | no | $zz['fields'][n]['default_select Relations: select | Show |
432 | variable | no | $zz['fields'][n]['default'] default value for field, normally string; for subrecords displayed as 'set' it may be an array as well | Show |
1008 | string: field | no | $zz['fields'][n]['dependent_on_a | Show |
1009 | string: field | no | $zz['fields'][n]['dependent_on_a Relations: $zz['fields'][n]['dependent_on_add_field'] | Show |
428 | integer | no | $zz['fields'][n]['detail_key_ind | Show |
426 | integer | no | $zz['fields'][n]['detail_value'] copies value from other field | Show |
649 | array | no | $zz['fields'][n]['disabled_ids'] IDs that will be shown as 'disabled' in Dropdown or checkbox list Relations: select | Show |
1000 | array | no | $zz['fields'][n]['disabled'] List of IDs for radio buttons that are disabled for some reason | Show |
889 | string | no | $zz['fields'][n]['display_empty' Relations: display | Show |
182 | string: field | no | $zz['fields'][n]['display_field' Relations: select; write_once; display | Show |
830 | array | no | $zz['fields'][n]['display_title' Relations: display | Show |
401 | string | no | $zz['fields'][n]['display_value' Relations: write_once; display | Show |
716 | boolean | no | $zz['fields'][n]['dont_check_on_ | Show |
966 | boolean | no | $zz['fields'][n]['dont_copy'] do not copy contents of this field if copying a record Relations: $zz_conf['copy'] | Show |
500 | boolean | no | $zz['fields'][n]['dont_delete_re Relations: subtable | Show |
748 | boolean | no | $zz['fields'][n]['dont_mark_sear | Show |
970 | boolean | no | $zz['fields'][n]['dont_require_o Relations: password_change | Show |
424 | boolean | no | $zz['fields'][n]['dont_show_file | Show |
191 | boolean | no | $zz['fields'][n]['dont_show_imag | Show |
995 | boolean | no | $zz['fields'][n]['dont_show_miss Relations: $zz['fields'][n]['dont_show_missing'] | Show |
710 | boolean | no | $zz['fields'][n]['dont_show_miss | Show |
849 | boolean | no | $zz['fields'][n]['dont_sort'] if set to true, no ordering in this column is allowed; 'id'-columns are set to true by default, if you'd like to order by id, you have to set them to false explicitly | Show |
938 | boolean | no | $zz['fields'][n]['dont_trim'] if set to true, 'text' fields won't be trimmed Relations: text | Show |
996 | boolean | no | $zz['fields'][n]['enum_textinput Relations: select; $zz['fields'][n]['enum'] | Show |
397 | array | no | $zz['fields'][n]['enum_title'] Optional. In case you don't like your ENUM values, you can set an array with different values that will be shown instead the values in the database. Good for translations. Relations: select; $zz['fields'][n]['enum'] | Show |
396 | array | no | $zz['fields'][n]['enum'] list for enum, default value with 'default' should be set as well Relations: $zz['fields'][n]['show_values_as_list']; select; $zz['fields'][n]['enum']; $zz['fields'][n]['default'] | Show |
844 | array | no | $zz['fields'][n]['enum_abbr'] List of abbreviations for enum, in list view, abbreviation will be shown in form view and displayed as abbr-element in list view Relations: select | Show |
969 | string: HTML | no | $zz['fields'][n]['error_msg'] Show individual error message if validation failed instead of generic message | Show |
388 | boolean | no | $zz['fields'][n]['exclude_from_s | Show |
474 | string: HTML | no | $zz['fields'][n]['explanation_to Relations: $zz['fields'][n]['explanation'] | Show |
475 | string: HTML | no | $zz['fields'][n]['explanation'] explanation how to fill in values in this field, will only be shown in edit or insert mode | Show |
643 | boolean | no | $zz['fields'][n]['export_no_html | Show |
786 | boolean | no | $zz['fields'][n]['export'] Exclude field from export | Show |
685 | string | no | $zz['fields'][n]['f_field_name'] INTERNAL USE ONLY Relations: $zz['fields'][n]['field_name'] | Show |
408 | integer | no | $zz['fields'][n]['factor'] factor for avoiding doubles as database fields Relations: number | Show |
11 | string: field | yes | $zz['fields'][n]['field_name'] Database field name; required, if field value shall be shown or changed in the output. Not all fields of a table have to be defined, the undefined fields will be ignored by the script. Relations: $zz['fields'][n] | Show |
994 | integer | no | $zz['fields'][n]['field_sequence | Show |
621 | array | no | $zz['fields'][n]['fielddefs'] In combination with 'values', 'fielddefs' allows to change some $zz['fields']-settings for individual detail records where values are preset.
The first numerical index of the field definition corresponds to the numerical index of the corresponding value, the second index corresponds to the field index that shall be changed. Relations: subtable; $zz['fields'][n]['values'] | Show |
364 | array | no | $zz['fields'][n]['fields'] List of fields which are used to create an identifier (`$zz['fields'][n]['type'] = 'identifier'`). If field_name of identifier-field is part of the array, the identifier won't be changed later on (write_once). Corresponding values of ID fields may be used writing `field_id[value]`. The fields are used in the same order as in the array.
vars which will be passed to function or identifier, might be in form like "select_id[field_name_from_selec | Show |
172 | string: field | no | $zz['fields'][n]['fields'][n]['d | Show |
847 | boolean | no | $zz['fields'][n]['for_action_ign Relations: $zz['fields'][n]['def_val_ignore'] | Show |
429 | string: field | no | $zz['fields'][n]['foreign_key_fi Relations: subtable | Show |
198 | string | no | $zz['fields'][n]['form_display'] - vertical (default vertical view as in standard form)
- horizontal: shows detail records in list view
- set: show detail records like set with radio buttons; works only with a detail table just with detail_table_id, foreign_key of main table and some other ID.
- inline: only works with 1 subrecord, show subfields as if they're part of the main record Relations: select; subtable | Show |
35 | string: function | no | $zz['fields'][n]['format'] Formats in form view text content of field with this markup language (e. g. Markdown), function of the same name must lie inside zzform-folder Relations: text; memo | Show |
976 | integer | no | $zz['fields'][n]['formatting_spa | Show |
399 | string: function | no | $zz['fields'][n]['function'] function which will be called to change input value
`function($vars, $field_name);`
$vars = POST vars of fields defined in an array in $zz['fields'][n]['fields']
$fie Relations: hidden | Show |
810 | string | no | $zz['fields'][n]['geo_display_be Relations: number | Show |
811 | string | no | $zz['fields'][n]['geo_format'] output of coordinate, possible values are dec, dms, deg, dm Relations: number | Show |
928 | string | no | $zz['fields'][n]['geocode_defaul Relations: $zz['fields'][n]['geocode'] | Show |
982 | array | no | $zz['fields'][n]['geocode_ignore Relations: $zz['fields'][n]['geocode'] | Show |
989 | boolean | no | $zz['fields'][n]['geocode_ignore Relations: $zz['fields'][n]['geocode'] | Show |
924 | string: SQL | no | $zz['fields'][n]['geocode_sql'] SQL query to replace ID value for geocoding with real content Relations: $zz['fields'][n]['geocode'] | Show |
923 | string | no | $zz['fields'][n]['geocode'] Mark fields for geocoding: 'postal_code', 'country', 'street', 'street_number', 'locality', 'latitude', 'longitude', 'state', 'place' 'place' is somewhat special. It adds a possibility to add the name of the place or venue if the full address is not known. In case 'place' + the rest of the address yields no results, a second query without 'place' is started | Show |
978 | mixed | no | $zz['fields'][n]['group_dependen Relations: $zz['fields'][n]['group_in_list'] | Show |
523 | boolean | no | $zz['fields'][n]['group_in_list' Relations: LIST | Show |
546 | string: field | no | $zz['fields'][n]['group'] allows to group records select via HTML optgroup-element Relations: select | Show |
964 | boolean | no | $zz['fields'][n]['hide_auto_add_ | Show |
746 | boolean | no | $zz['fields'][n]['hide_format_in Relations: $zz['fields'][n]['format']; $zz['fields'][n]['title_desc'] | Show |
781 | boolean | no | $zz['fields'][n]['hide_in_form_a Relations: $zz['fields'][n]['hide_in_form'] | Show |
180 | boolean | no | $zz['fields'][n]['hide_in_form'] hides field in form view, but not in list view. | Show |
959 | boolean | no | $zz['fields'][n]['hide_in_list_i Relations: $zz['fields'][n]['hide_in_list'] | Show |
179 | boolean | no | $zz['fields'][n]['hide_in_list'] field will not be shown in list view | Show |
422 | boolean | no | $zz['fields'][n]['hide_novalue'] = false: as a default, the choice of no value for a radio button set will be hidden. By setting this value to false, it will be shown. Relations: select | Show |
750 | boolean | no | $zz['fields'][n]['hide_zeros'] values 0 will be converted to '' (unit, prefix, suffix etc. will not be shown) | Show |
614 | string: field | no | $zz['fields'][n]['id_field_name' Relations: $zz['fields'][n]['sql']; select | Show |
185 | array | no | $zz['fields'][n]['if'][n] Field definitions which will be set if a certain condition n is met. For some conditions, shortcuts exist: - 'multi': if script is called via zzform_multi() - 'where': if field has id value which is defined by WHERE condition ($zz['where'], $_GET['where']) - 'add': if a record is added - 'delete': if a record is deleted - 'edit': if a record is edited - 'upload: if something is uploaded | Show |
192 | array | no | $zz['fields'][n]['image'] what has to be done with uploaded image. keys as follows. | Show |
450 | string: function | no | $zz['fields'][n]['image'][n]['ac | Show |
449 | integer | no | $zz['fields'][n]['image'][n]['au | Show |
448 | array | no | $zz['fields'][n]['image'][n]['au | Show |
447 | string: function | no | $zz['fields'][n]['image'][n]['au | Show |
937 | string | no | $zz['fields'][n]['image'][n]['co | Show |
442 | string: field | no | $zz['fields'][n]['image'][n]['fi | Show |
441 | integer | no | $zz['fields'][n]['image'][n]['he | Show |
451 | boolean | no | $zz['fields'][n]['image'][n]['ig | Show |
457 | array | no | $zz['fields'][n]['image'][n]['in | Show |
454 | integer | no | $zz['fields'][n]['image'][n]['ma | Show |
452 | integer | no | $zz['fields'][n]['image'][n]['ma | Show |
455 | integer | no | $zz['fields'][n]['image'][n]['mi | Show |
453 | integer | no | $zz['fields'][n]['image'][n]['mi | Show |
999 | boolean | no | $zz['fields'][n]['image'][n]['no | Show |
458 | boolean | no | $zz['fields'][n]['image'][n]['op | Show |
961 | string | no | $zz['fields'][n]['image'][n]['op Relations: $zz['fields'][n]['image'][n]['options'] | Show |
545 | string: SQL | no | $zz['fields'][n]['image'][n]['op Relations: $zz['fields'][n]['image'][n]['options'] | Show |
446 | array | no | $zz['fields'][n]['image'][n]['op Relations: option | Show |
444 | array: path | no | $zz['fields'][n]['image'][n]['pa | Show |
944 | array | no | $zz['fields'][n]['image'][n]['re | Show |
443 | boolean | no | $zz['fields'][n]['image'][n]['re | Show |
456 | boolean | no | $zz['fields'][n]['image'][n]['sh | Show |
193 | string: field | no | $zz['fields'][n]['image'][n]['so | Show |
195 | string: SQL | no | $zz['fields'][n]['image'][n]['so Relations: $zz['fields'][n]['image'][n]['source_file'] | Show |
194 | array: path | no | $zz['fields'][n]['image'][n]['so | Show |
445 | integer | no | $zz['fields'][n]['image'][n]['so | Show |
439 | string | no | $zz['fields'][n]['image'][n]['ti | Show |
196 | array | no | $zz['fields'][n]['image'][n]['up Relations: $zz['fields'][n]['image'][n]['update_from_source_value'] | Show |
197 | array | no | $zz['fields'][n]['image'][n]['up Relations: $zz['fields'][n]['image'][n]['update_from_source_field_name'] | Show |
440 | integer | no | $zz['fields'][n]['image'][n]['wi | Show |
956 | boolean | no | $zz['fields'][n]['import_id_valu Relations: id | Show |
392 | boolean | no | $zz['fields'][n]['in_sql_query'] INTERNAL variable only | Show |
459 | boolean | no | $zz['fields'][n]['inherit_format Relations: $zz['fields'][n]['format'] | Show |
707 | boolean | no | $zz['fields'][n]['input_only'] field is for input only (e. g. if value will be used for different fields, or parts of it); something entered in this field won't be saved | Show |
868 | string | no | $zz['fields'][n]['js'] Adds JavaScript to 'explanation', e. g. 'select/deselect' adds JS for acitvating/deactivating all checkboxes Relations: $zz['fields'][n]['explanation'] | Show |
418 | string: field | no | $zz['fields'][n]['key_field_name Relations: select; foreign_key | Show |
842 | string | no | $zz['fields'][n]['kml'] item name in KML export, 'title', latitude' and 'longitude' (or alternatively 'point') must be set when KML export is active. 'altitude' is optional. 'description' will be put below all fields with title=> value in tabular format; 'style' will be used as ID for style element for this record | Show |
186 | array: path | no | $zz['fields'][n]['link'] Link in list view to record. May be array, then it works with field, mode and string (field1, field2, mode1, ...) see also: path. If root is set, link will be looked for in filesystem. if not existent, returns false (no link) Relations: $zz['fields'][n]['path'] | Show |
568 | string: HTML | no | $zz['fields'][n]['link_attribute | Show |
615 | boolean | no | $zz['fields'][n]['link_referer'] adds current URL as referer to a link to create the possibility for a backlink on the linked page | Show |
433 | string: HTML | no | $zz['fields'][n]['link_target'] HTML target-attribute for link (`target="value"`) | Show |
434 | array: path | no | $zz['fields'][n]['link_title'] HTML title-attribute for link in list to record. May be array, then it works with field and string (field1, field2, string1, ...) see also: path Relations: $zz['fields'][n]['path'] | Show |
471 | string | no | $zz['fields'][n]['list_abbr'] name of field whose value will be displayed in <abbr title=""> behind displayed value | Show |
894 | string: HTML | no | $zz['fields'][n]['list_append_if Relations: $zz['fields'][n]['list_append_next'] | Show |
895 | string: HTML | no | $zz['fields'][n]['list_append_if Relations: $zz['fields'][n]['list_append_next'] | Show |
477 | boolean | no | $zz['fields'][n]['list_append_ne | Show |
822 | boolean | no | $zz['fields'][n]['list_append_sh Relations: $zz['fields'][n]['list_append_next'] | Show |
855 | string: HTML | no | $zz['fields'][n]['list_concat_fi | Show |
425 | string: function | no | $zz['fields'][n]['list_format'] function which will be used to format text for display, e. g. markdown | textile, in list part; might be array if you want to use several functions Relations: $zz['fields'][n]['format']; text; memo | Show |
906 | string: function | no | $zz['fields'][n]['list_function' Relations: list_function | Show |
977 | boolean | no | $zz['fields'][n]['list_no_link'] zzform list: if 'list_no_link' is set to true, no link for list view will be generated (e. g. for fields of type URL) | Show |
991 | string: HTML | no | $zz['fields'][n]['list_prefix_ap Relations: $zz['fields'][n]['list_prefix']; $zz['fields'][n]['list_suffix_append'] | Show |
356 | string: HTML | no | $zz['fields'][n]['list_prefix'] prefix in front of the field value in list view Relations: $zz['fields'][n]['list_suffix'] | Show |
992 | string: HTML | no | $zz['fields'][n]['list_suffix_ap Relations: $zz['fields'][n]['list_suffix']; $zz['fields'][n]['list_prefix_append'] | Show |
355 | string: HTML | no | $zz['fields'][n]['list_suffix'] suffix behind the field value in list view Relations: $zz['fields'][n]['list_prefix'] | Show |
967 | string: HTML | no | $zz['fields'][n]['list_unit'] displays a unit behind a number, won't display if value = NULL, list mode Relations: number; $zz['fields'][n]['unit'] | Show |
1007 | array | no | $zz['fields'][n]['mark_scope'] marks content in this field (most likely a field with 'display_field' set) if a search is done over one of the fields in the list of fields | Show |
190 | integer | no | $zz['fields'][n]['max_records'] Relations: subtable | Show |
940 | string: SQL | no | $zz['fields'][n]['max_records_sq Relations: subtable | Show |
460 | integer | no | $zz['fields'][n]['maxlength'] maxlength, if not set will be taken from database | Show |
953 | boolean | no | $zz['fields'][n]['merge_equal'] Records will only be merged if values in this field are equal Relations: $zz_conf['merge'] | Show |
952 | boolean | no | $zz['fields'][n]['merge_ignore'] Field will be ignored for comparison of main records while merging Relations: $zz_conf['merge'] | Show |
714 | integer | no | $zz['fields'][n]['min_records_re Relations: $zz['fields'][n]['min_records']; subtable | Show |
189 | integer | no | $zz['fields'][n]['min_records'] Relations: subtable | Show |
939 | string: SQL | no | $zz['fields'][n]['min_records_sq Relations: subtable | Show |
650 | string | no | $zz['fields'][n]['msg_no_subtabl | Show |
911 | boolean | no | $zz['fields'][n]['multiple_edit' Relations: $zz[list']['select_multiple_records'] | Show |
436 | boolean | no | $zz['fields'][n]['null_string'] Field value might be 0 or '', won't be set to NULL => output = '' Relations: $zz['fields'][n]['null'] | Show |
435 | boolean | no | $zz['fields'][n]['null'] Field value might be 0 or '', won't be set to NULL => output = 0 Relations: $zz['fields'][n]['null_string'] | Show |
398 | string | no | $zz['fields'][n]['number_type'] - 'longitude' | 'latitude', for entering geo information
- 'currency' for money
- 'bytes' for bytes, for displaying MB, GB, TB etc.
- 'number' for numbers, formatted with thousands_separator and decimal_point Relations: number | Show |
427 | array | no | $zz['fields'][n]['options'] Together with enum-array; values from enum-array will have to be set as pairs. E. g. enum-value proportional will be an array in options, first is key which will be added to image, second is corresponding value: ['options'] = array('proportional' => array('key' => 'value')); existing keys will be overwritten | Show |
617 | string | no | $zz['fields'][n]['order'] different field name for ORDER BY, e. g. if a table name is needed in case of ambiguous field names or for mixed alpha-numerical strings without preceding zeros | Show |
648 | string | no | $zz['fields'][n]['path_json_base Relations: image; $zz['fields'][n]['path_json_request'] | Show |
647 | array: path | no | $zz['fields'][n]['path_json_requ Relations: image | Show |
421 | string: SQL | no | $zz['fields'][n]['path_sql'] only if this sql query is needed for constructing the extension of a file path; sql-query which will be used if this field's display_value is set as fieldxx in path to get a correct extension for file conversions Relations: select | Show |
184 | array | no | $zz['fields'][n]['path'] values: - `root` DOCUMENT_ROOT or path to directory, will be used as a prefix to check whether file_exists or not - `webroot` alternative for DOCUMENT_ROOT on URL basis of the webserver - `fieldXX` will add corresponding field value, - `stringXX` will add string value, (string1 will be weblink to file, parallel to root) - `webstringXX` same as string, but applied only to web path, not to file path - `modeXX`: functions that will be applied to all field_values - last `stringXX` or `fieldXX`: this must consist of the fileextension only (with or without .) e. g. array('field1' => 'fieldname_bla', 'string1' => '/', 'field2' => 'fieldname_blubb') etc. - as an alternative, `extension` can be used instead of fieldXX - `x_field[2]XX` = similar to field, but for 2x image - `x_field[1.5]XX` = similar to field, but for 1.5x image - `x_extension[2]XX` = similar to extension, but for 2x image - `x_webfield[2]XX` = similar to webfield, but for 2x image | Show |
709 | string: function | no | $zz['fields'][n]['post_validatio Relations: $zz['fields'][n]['detail_value'] | Show |
464 | string: HTML | no | $zz['fields'][n]['prefix'] adds prefix-string to form view Relations: $zz['fields'][n]['suffix'] | Show |
616 | integer | no | $zz['fields'][n]['read_options'] Index of field on which options depend Relations: option; $zz['fields'][n]['options'] | Show |
200 | boolean | no | $zz['fields'][n]['records_depend | Show |
986 | boolean | no | $zz['fields'][n]['remove_local_h | Show |
741 | array | no | $zz['fields'][n]['replace_values | Show |
618 | boolean | no | $zz['fields'][n]['required'] field requires an input (same behaviour as NOT NULL, but allow flexible table definition) | Show |
412 | integer | no | $zz['fields'][n]['rows_max'] max number of rows in textarea (textarea might expand if text is edited to approximately the numbers of rows needed to display all text without scroll bar) Relations: memo | Show |
202 | integer | no | $zz['fields'][n]['rows'] number of rows in textarea, will be expanded if a record is edited to approximately the needed length Relations: memo | Show |
802 | string: SQL | no | $zz['fields'][n]['search_between | Show |
619 | string: SQL | no | $zz['fields'][n]['search'] if a field does not appear without an alias or appears ambiguous in the SQL query for 'list' view, here you can define the exact field name or field combination that will be used for search | Show |
929 | mixed | no | $zz['fields'][n]['separator_befo Relations: $zz['fields'][n]['separator'] | Show |
465 | mixed | no | $zz['fields'][n]['separator'] - true: will put a separation behind this field, to improve form layout. - column_begin, column, column_end: put form in two columns - text bla blubb: will put bla blubb below `<hr>`-Separator | Show |
779 | string: filename | no | $zz['fields'][n]['set_folder'] path of folder, files in this folder will be presented for selection (no subfolders), names of chosen files will be saved in database. Relations: select | Show |
780 | boolean | no | $zz['fields'][n]['set_show_all_v Relations: select; $zz['fields'][n]['set_folder'] | Show |
640 | string: SQL | no | $zz['fields'][n]['set_sql'] similar to set, lets you get comma separated values from an SQL query that will be treated similar as a mysql SET field Relations: select | Show |
638 | array | no | $zz['fields'][n]['set_title'] similar to enum_title
in combination with set_sql: if = true, uses second field from sql-query as set_title Relations: select; $zz['fields'][n]['set'] | Show |
395 | array | no | $zz['fields'][n]['set'] array for set Relations: $zz['fields'][n]['show_values_as_list']; select | Show |
782 | boolean | no | $zz['fields'][n]['show_hierarchy Relations: $zz['fields'][n]['show_hierarchy'] | Show |
416 | integer | no | $zz['fields'][n]['show_hierarchy Relations: select; $zz['fields'][n]['show_hierarchy'] | Show |
419 | boolean | no | $zz['fields'][n]['show_hierarchy Relations: select; $zz['fields'][n]['show_hierarchy'] | Show |
417 | string: field | no | $zz['fields'][n]['show_hierarchy Relations: select | Show |
386 | boolean | no | $zz['fields'][n]['show_id'] Normally, id fields get class record_id {display: none;}, show_id stops zzform from doing that Relations: id | Show |
178 | boolean | no | $zz['fields'][n]['show_title'] display record: show field title in TH (mainly for subtables, for aesthetic reasons) | Show |
298 | boolean | no | $zz['fields'][n]['show_values_as Relations: select; $zz['fields'][n]['set']; $zz['fields'][n]['enum'] | Show |
423 | integer | no | $zz['fields'][n]['size_select_to Relations: select | Show |
405 | integer | no | $zz['fields'][n]['size'] Maximum length of characters that may be entered in input field, size of input field, standard for number 16, for time 8 and for all other fields 32 (or maxlength if smaller) | Show |
872 | array | no | $zz['fields'][n]['sql_character_ Relations: $zz['fields'][n]['sql']; select | Show |
896 | array | no | $zz['fields'][n]['sql_fieldnames Relations: select | Show |
415 | array | no | $zz['fields'][n]['sql_ignore'] doesn't display fields of sql query in form view. this is useful if you need the fields for an identifier field; array, fields won't display in form view. Relations: $zz['fields'][n]['sql']; select | Show |
467 | boolean | no | $zz['fields'][n]['sql_index_only Relations: select | Show |
787 | string: SQL | no | $zz['fields'][n]['sql_not_unique | Show |
404 | string: SQL | no | $zz['fields'][n]['sql_password_c Relations: password_change | Show |
873 | array | no | $zz['fields'][n]['sql_table'] Table names of fields in SQL query if not included in this query (to get correct character set for reselect) Relations: $zz['fields'][n]['sql']; select | Show |
958 | array | no | $zz['fields'][n]['sql_translate' Relations: $zz['sql'] | Show |
623 | boolean | no | $zz['fields'][n]['sql_where_with | Show |
1002 | boolean | no | $zz['fields'][n]['sql_where_with | Show |
413 | array | no | $zz['fields'][n]['sql_where'] adds where to sql-string, rather complicated ... :-)
$zz['fields'][4]['sql_whe Relations: select | Show |
414 | boolean | no | $zz['fields'][n]['sql_without_id Relations: select | Show |
181 | string: SQL | no | $zz['fields'][n]['sql'] SQL-Query for select, first field is key field which will not be displayed but entered into database field Relations: select | Show |
946 | string: SQL | no | $zz['fields'][n]['sqlcount'] query which has to have something like `COUNT(record_id) AS record_id` in it to provide a faster alternative to querying several records up to max_select for counting all records available for a select field Relations: $zz['fields'][n]['sql']; $zz_conf['max_select'] | Show |
201 | string: SQL | no | $zz['fields'][n]['sqlorder'] | Show |
299 | array | no | $zz['fields'][n]['subselect'] Displays records of detail tables in list view, allows to search through these detail tables as well. Key 'sql' is required, rest is optional. | Show |
302 | string: HTML | no | $zz['fields'][n]['subselect']['c | Show |
301 | string: HTML | no | $zz['fields'][n]['subselect']['c | Show |
997 | boolean | no | $zz['fields'][n]['subselect']['c Relations: $zz['fields'][n]['subselect']['prefix'] | Show |
883 | string: HTML | no | $zz['fields'][n]['subselect']['f | Show |
884 | string: HTML | no | $zz['fields'][n]['subselect']['f | Show |
879 | array: path | no | $zz['fields'][n]['subselect']['l | Show |
300 | string: HTML | no | $zz['fields'][n]['subselect']['p | Show |
882 | boolean | no | $zz['fields'][n]['subselect']['s | Show |
973 | array | no | $zz['fields'][n]['subselect']['s Relations: $zz['fields'][n]['subselect']['sql'] | Show |
438 | string: SQL | no | $zz['fields'][n]['subselect']['s | Show |
303 | string: HTML | no | $zz['fields'][n]['subselect']['s | Show |
788 | string: field | no | $zz['fields'][n]['subselect']['t | Show |
909 | string: function | no | $zz['fields'][n]['subselect']['l Relations: $zz['fields'][n]['subselect']['list_format'] | Show |
171 | string: function | no | $zz['fields'][n]['subselect']['l Relations: $zz['fields'][n]['list_format'] | Show |
461 | string: HTML | no | $zz['fields'][n]['suffix'] adds suffix-string to form view | Show |
462 | string: function | no | $zz['fields'][n]['suffix_functio | Show |
463 | array | no | $zz['fields'][n]['suffix_functio | Show |
188 | string: field | no | $zz['fields'][n]['table_name'] Alias if more subtables are included (used for search only, AFAIK) Relations: subtable | Show |
854 | string: field | no | $zz['fields'][n]['text_field'] similar to display_field, this key must be set to a field name from the SQL query which contains the textual representation of the corresponding spatial field Relations: geo_point | Show |
922 | string | no | $zz['fields'][n]['text_none_sele Relations: select; $zz['fields'][n]['hide_novalue']; $zz_conf['text'] | Show |
620 | boolean | no | $zz['fields'][n]['tick_to_save'] Displays checkbox for each detail record, if checked, record will be saved (insert, update), if not, removed (delete, or if it does not exist, ignored) Relations: subtable | Show |
955 | string | no | $zz['fields'][n]['time_format'] allows to format a time with date() Relations: time | Show |
476 | boolean | no | $zz['fields'][n]['title_append'] title for several records which will be in one line | Show |
817 | string: HTML | no | $zz['fields'][n]['title_button'] string; title for subtables add/remove buttons | Show |
479 | string: HTML | no | $zz['fields'][n]['title_desc'] description, will always be shown below title in form, values in format will be added automatically (cf. explanation) Relations: $zz['fields'][n]['format']; $zz['fields'][n]['explanation'] | Show |
13 | string: HTML | no | $zz['fields'][n]['title'] Title of database field, will be shown in form and table Optional, value will be generated from 'field_name' if not set (first letter uppercase, ending `_id` will be deleted) | Show |
998 | string | no | $zz['fields'][n]['title_export_p | Show |
478 | string: HTML | no | $zz['fields'][n]['title_tab'] title in table display (optional, default = 'title'), e. g. for abbreviations to save place | Show |
289 | boolean | no | $zz['fields'][n]['translate_fiel | Show |
774 | array | no | $zz['fields'][n]['translation'] gives the possibility to set individual variables for translation subtables, e. g. 'hide_in_list' | Show |
971 | boolean | no | $zz['fields'][n]['trim'] if set to true, 'memo' fields will be trimmed Relations: memo | Show |
183 | string | no | $zz['fields'][n]['type_detail'] type of field, used for option and predefined to set real type of field but still remain special functionality Relations: $zz['fields'][n]['type'] | Show |
177 | string | no | $zz['fields'][n]['type'] Here, the type of the field can be definfed. For a list of field types, see zz_fieldtypes Relations: zz_fieldtypes | Show |
684 | boolean | no | $zz['fields'][n]['unique'] if field value is unique, it can be used for where-clauses and will show only one record in display mode, without add new record | Show |
407 | string: HTML | no | $zz['fields'][n]['unit'] displays a unit behind a number, won't display if value = NULL Relations: number | Show |
960 | boolean | no | $zz['fields'][n]['update_on_deta Relations: timestamp | Show |
885 | string | no | $zz['fields'][n]['upload_default Relations: $zz['fields'][n]['default'] | Show |
569 | integer | no | $zz['fields'][n]['upload_field'] For hidden or other fields (which ... ?), says which field is the upload field from which a certain value, defined in 'upload_value', shall be taken Relations: hidden | Show |
813 | string: function | no | $zz['fields'][n]['upload_func'] string; name of a function to format upload values (the only way to handle arrays) Relations: $zz['fields'][n]['upload_field'] | Show |
571 | string: SQL | no | $zz['fields'][n]['upload_sql'] SQL query to use with upload value, e. g. if you get a string but need an ID value. Relations: hidden; $zz['fields'][n]['upload_field'] | Show |
570 | mixed | no | $zz['fields'][n]['upload_value'] Value which will be written to database and taken from uploaded file. Possible values
* basics:
- filetype: filetype of original file
- title: modified filename (without ending, underscores replaced with space, ucfirst() etc.)
- filename: filename without extension and web compatible
* images:
- width: width of original image
- height: height of original image
- modified[width]
- modified[height]
* from $_FILES
- name: original filename of uploaded file
- type
- tmp_name
- error
- size: filesize
* more
- type_ext: mimetype + extension, e. g. application/octet-stream/dwg
- exif[DateTimeOriginal]
- ext: file extension
- sha1_source_file
- modified[filetype]
- exif[YResolution]
- modified[exif][YResolution]
- exif[YResolution]
- modified[exif][YResolution]
- upload[size]
- modified[size]
- md5
- md5_source_file
- sha1
- sha1_source_file
- increment_on_change (adds 1 to a version no. if file changed)
- exif[DateTime]
- exif[FileName]
- exif[FileSize]
- ...
Good combinations of values are (in case first value is not set, second will be tried):
- array('exif[COMPUTED][Width]', 'upload[width]')
- array('exif[COMPUTED][Height]', 'upload[height]')
- array('channels', 'exif[SamplesPerPixel]')
- array('bits', 'exif[BitsPerSample][0]')
Relations: hidden; $zz['fields'][n]['upload_field'] | Show |
848 | boolean | no | $zz['fields'][n]['use_as_label'] In combination with e. g. tick_for_save, this field's value will be enclosed in a label for the checkbox Relations: subtable; $zz['fields'][n]['tick_to_save'] | Show |
636 | array | no | $zz['fields'][n]['validate'] | Show |
637 | array | no | $zz['fields'][n]['validate']['fo | Show |
175 | string | no | $zz['fields'][n]['value'] Value for field, may not be overwritten Relations: hidden | Show |
622 | array | no | $zz['fields'][n]['values'] Sets values for detail records. Lets you ask e. g. for a level of knowledge for a predefined set of languages | Show |
975 | string: function | no | $zz['fields'][n][format_0'] function to format fields from sql query Relations: $zz['fields'][n]['sql']; select | Show |
331 | array | no | $zz['filter'] Filter for records to be shown | Show |
348 | string | no | $zz_conf['filter_position'] position of filter, top, bottom or both Relations: OUTPUT | Show |
332 | array | no | $zz['filter'][n] | Show |
567 | mixed | no | $zz['filter'][n]['default_select | Show |
892 | integer | no | $zz['filter'][n]['depends_on'] Make a filter dependent on the selection of another filter (e. g. for categories and subcategories), using the other filters' where field = value if filter is selected to narrow the results of this filter | Show |
573 | string: field | no | $zz['filter'][n]['field_name'] If set, filter value will be used as a default value for this field. | Show |
804 | boolean | no | $zz['filter'][n]['hide_all_link' | Show |
334 | string | no | $zz['filter'][n]['identifier'] Identifier for filter, will be used in URL. If not set, will be created from 'title'. Relations: $zz['filter'][n]['title'] | Show |
893 | boolean | no | $zz['filter'][n]['ignore_invalid | Show |
979 | string | no | $zz['filter'][n]['like'] allows to change LIKE "%...%" to something different | Show |
337 | array | no | $zz['filter'][n]['selection'] Possible filters, always pairs of record_id and filter title; values starting with »!« will be compared against with !=, »\« escapes possible !-signs | Show |
968 | string: SQL | no | $zz['filter'][n]['sql_join'] SQL JOIN to add for filter to $zz['sql'] Relations: $zz['sql'] | Show |
785 | string: SQL | no | $zz['filter'][n]['sql'] SQL query that should return two fields, set of record_id and title that will be used for `$zz['filter'][n]['selection']` Relations: $zz['filter'][n]['selection'] | Show |
333 | string: HTML | no | $zz['filter'][n]['title'] | Show |
335 | string | no | $zz['filter'][n]['type'] * show_hierarchy * list * where (== list, with the only difference that you must not change the field with the where-value anymore, similar to a 'where' in the URL) | Show |
988 | array | no | $zz['filter'][n]['where_if'] 'where_if' allows to set a WHERE query individually for each selection | Show |
336 | string: SQL | no | $zz['filter'][n]['where'] If type == 'list', this is the required part for the WHERE condition without the equal sign. Might be, even without 'selection', an array for multiple WHERE-conditions connected with OR filter=NULL and filter=!NULL will be translated to the correct SQL query form | Show |
265 | array: path | no | $zz['folder'][] array with root, string, field, mode for a folder that must be renamed/deleted after changing the record Relations: ACTION | Show |
933 | string: HTML | no | $zz['geo_map_html'] if set, zzbrick/forms module will include a javascript map (e. g. OpenLayers) to display the records via a KML export on this map; a map template and a JavaScript-library is required Relations: $zz_conf['export']; brick_forms() | Show |
934 | string | no | $zz['geo_map_template'] template for $zz['geo_map_html'] Relations: $zz_conf['export']; brick_forms(); $zz['geo_map_html'] | Show |
974 | boolean | no | $zz['list']['hide_columns_if_emp Relations: LIST; $zz['fields'][n]['hide_in_list_if_empty'] | Show |
266 | array | no | $zz['list']['hierarchy'] display table in a hierarchical view.
Caution:
- these variables might need a lot of memory when handling bigger amounts of records because all record ids have to be saved to memory
- in combination with a WHERE-Condition (`&where[field]=32`), some records might be missing in a branch of a tree because the WHERE-Condition might exclude these records. For the top level, the missing records will be shown read-only Relations: GLOBAL | Show |
268 | string: field | no | $zz['list']['hierarchy']['displa Relations: LIST | Show |
945 | boolean | no | $zz['list']['hierarchy']['hide_t | Show |
912 | integer | no | $zz['list']['hierarchy']['id'] ID of top record in hierarchy if just a subtree shall be displayed Relations: LIST | Show |
267 | string: field | no | $zz['list']['hierarchy']['mother Relations: LIST | Show |
539 | boolean | no | $zz['list']['tfoot'] shows table foot, e. g. for sums of individual values Relations: LIST | Show |
920 | array | no | $zz['set_redirect'] List of redirects that will be added to the database redirects table if an identifier is updated or a record with an identifier is deleted. Might be list of strings (old and new pattern is equal), list of arrays (old and new patterns differ); field_name may be set optionally if more than one identifier is in the field list. Relations: $zz['extra_action']; identifier | Show |
8 | string: SQL | yes | $zz['sql'] SQL statement for list display and to get field values for form display | Show |
9 | string: SQL | no | $zz['sqlorder'] SQL statement, part must begin with ' ORDER BY', to sort database table | Show |
947 | string: SQL | no | $zz['sqlcount'] separate SQL query for counting records if main query is too heavy Relations: $zz['sql'] | Show |
985 | string: SQL | no | $zz['sqlextra'] if SQL query is too complex, additional values can be read via 'sqlextra' queries | Show |
941 | string: SQL | no | $zz['sqlrecord'] SQL query which will be used only for record view, not for list view Relations: $zz['sql'] | Show |
7 | string: field | yes | $zz['table'] Name of database table (might include database name as well, e. g. Database.Table) | Show |
216 | string: HTML | no | $zz['title'] optional: h1-heading to be used for form instead of $zz['table'] Relations: OUTPUT | Show |
238 | string: HTML | no | $zz['explanation'] Textblock after heading Relations: $zz_conf['footer_text']; OUTPUT | Show |
917 | variable | no | $zz['subtitle'][field]['concat'] Array or string; if more than one field is used for subtitle, this string or these strings will be used instead of the default space for concatenating the fields. If an array is used and the number of elements is smaller than the number of spaces to fill, the last value will be repeated. Relations: OUTPUT | Show |
240 | array | no | $zz['subtitle'][field]['enum'] field = $where_id, without tablename;
= $zz['fields'][n]['enum'] where n is the index of the field corresponding to the key Relations: $zz['fields'][n]['enum']; OUTPUT | Show |
987 | variable | no | $zz['subtitle'][field]['format'] Array or string; format all (string) or one (array) value with a formatting function Relations: OUTPUT | Show |
327 | string | no | $zz['subtitle'][field]['link'] heading link provides a link back from the filter text directly below the heading ('var', 'sql') to the main page which triggers the filter (displaying the corresponding record) Relations: $zz['subtitle'][field]['sql']; $zz['subtitle'][field]['var']; OUTPUT | Show |
789 | boolean | no | $zz['subtitle'][field]['link_no_ | Show |
916 | string: HTML | no | $zz['subtitle'][field]['prefix'] Prefix, added to value if there is one | Show |
217 | string: SQL | no | $zz['subtitle'][field]['sql'] [$where_id, without tablename]['sql'] = $zz['fields'][n]['sql'] where n is the index of the field corresponding to the key Relations: OUTPUT | Show |
915 | string: HTML | no | $zz['subtitle'][field]['suffix'] Suffix, added to value if there is one | Show |
914 | boolean | no | $zz['subtitle'][field]['value'] if true, value of field will be displayed for subtitle | Show |
218 | array | no | $zz['subtitle'][field]['var'] ['heading_sub'][$where_id, without tablename]['var'] = array() field from heading_sql-query which shall be used for better display of H2 and TITLE blabla:<br>var1 var2 var3
Relations: OUTPUT | Show |
918 | array | no | $zz['unique'] Describes UNIQUE key for detail tables. For updates via zzform_multi() which do not know the record ID of the detail table this can be used to avoid getting this ID first. | Show |
821 | array | no | $zz['where'] WHERE condition for record, like via URL where[some_id]=10 | Show |
538 | boolean | no | $zz[list']['select_multiple_reco Relations: LIST | Show |
5 | array | yes | $zz_conf Main configuration variables. To be set in table scripts or central configuration file. Most variables will have a reasonable default. | Show |
237 | string | no | $zz_conf['access'] deprecated, use $zz['access'] instead Relations: $zz['access']; FORM; LIST | Show |
243 | string: filename | no | $zz_conf['action_dir'] Directory where included scripts from $zz['extra_action'] reside Relations: $zz['extra_action']; ACTION | Show |
236 | mixed | no | $zz_conf['add'] Add or do not add data.
Can be an array to allow adding of records whith specific values already set. Format:
- `type`: Title, as in Add new ...
- `field_name`: field_name for which value will already be set when adding a new record
- `value`: value to field_name which will be set
- `title`: title-attribute to explain add link further
- `explanation`: (optional) will be written behind the link Relations: FORM; LIST | Show |
346 | boolean | no | $zz_conf['add_link'] add new record link will be shown (true) or not (false); normally this needs not to be set, because it's the same as $zz_conf['add'] Relations: LIST; OUTPUT | Show |
775 | boolean | no | $zz_conf['always_show_empty_deta Relations: subtable | Show |
284 | array | no | $zz_conf['breadcrumbs'] Relations: OUTPUT; brick_forms() | Show |
783 | boolean | no | $zz_conf['cancel_link'] shows/hides cancel link | Show |
874 | boolean | no | $zz_conf['character_set_db_multi Relations: $zz_conf['character_set'] | Show |
45 | string | no | $zz_conf['character_set'] Character encoding which is used to serve pages, convert text to filenames and more. Relations: GLOBAL | Show |
795 | boolean | no | $zz_conf['check_referential_inte Relations: $zz_conf['relations_table'] | Show |
776 | boolean | no | $zz_conf['copy'] allows to copy a record (add new record with the data of the old record as a basis) | Show |
250 | resource | no | $zz_conf['db_connection'] resource of MySQL connection (open connection will be used, therefore this value can be set to true as well) Relations: GLOBAL | Show |
876 | string: SQL | yes | $zz_conf['db_name_local'] local (development) database name for website Relations: $zz_setting['local_access']; $zz_conf['db_name'] | Show |
251 | string | yes | $zz_conf['db_name'] database name Relations: GLOBAL | Show |
287 | boolean | no | $zz_conf['debug_time'] Logs the processing time that was used by certain functions into the zzform error handling Relations: debug.inc.php; OUTPUT | Show |
91 | boolean | no | $zz_conf['debug'] Turns debugging in zzform on or off; debugging mode, shows several debugging outputs directly in the html output Relations: debug.inc.php; OUTPUT | Show |
903 | string | no | $zz_conf['decimal_point'] Decimal point for numbers, depending on language | Show |
826 | array | no | $zz_conf['default_language_for'] for not existing language files, use a different default than 'en' Relations: $zz_conf['language'] | Show |
213 | boolean | no | $zz_conf['delete'] delete records possible or not Relations: FORM; LIST | Show |
219 | array | no | $zz_conf['details'] Creates a column "details" next to the column "action"; links to detail records with foreign key. A link will be constructed from each values but you can influence that with 'details_url' and 'details_base' Relations: FORM; LIST | Show |
231 | array | no | $zz_conf['details_base'] array, corresponding to details, does not make use of details as first part of details_url but this field instead Relations: FORM; LIST | Show |
233 | boolean | no | $zz_conf['details_referer'] add referer to details link Relations: FORM; LIST | Show |
800 | array | no | $zz_conf['details_sql'] | Show |
232 | string: HTML | no | $zz_conf['details_target'] target window for details link Relations: FORM; LIST | Show |
220 | array: path | no | $zz_conf['details_url'] what url to follow for detail records, may be array e. g. array('field1' => 'fieldname_bla', 'string1' => '/', 'field2' => 'fieldname_blubb') etc. Relations: FORM; LIST | Show |
516 | string: filename | no | $zz_conf['dir_custom'] Directory for customized scripts, i. e. db.inc.php, translation scripts Relations: GLOBAL | Show |
517 | string: filename | no | $zz_conf['dir_inc'] Directory for zzform include scripts Relations: GLOBAL | Show |
115 | string: filename | no | $zz_conf['dir'] Directory in which zzform resides in Relations: $zz_setting['inc']; zzform_multi(); GLOBAL | Show |
285 | boolean | no | $zz_conf['dont_show_title_as_bre Relations: $zz_conf['breadcrumbs']; brick_forms(); GLOBAL | Show |
851 | boolean | no | $zz_conf['dont_show_total_record | Show |
248 | string | no | $zz_conf['error_handling'] what to do with errors, possible values: `output` | `mail` | `save_mail` | `mail_summary` Relations: GLOBAL | Show |
528 | string: filename | no | $zz_conf['error_log']['error'] path to error_log, default from php.ini Relations: GLOBAL | Show |
529 | string: filename | no | $zz_conf['error_log']['notice'] path to error_log for E_USER_NOTICE, default from php.ini Relations: GLOBAL | Show |
530 | string: filename | no | $zz_conf['error_log']['warning'] path to error_log for E_USER_WARNING, default from php.ini Relations: GLOBAL | Show |
246 | string | no | $zz_conf['error_mail_from'] mailaddress where errrors come from Relations: GLOBAL | Show |
279 | mixed | no | $zz_conf['error_mail_level'] When to mail an error to the admin. Relations: GLOBAL | Show |
245 | string | no | $zz_conf['error_mail_to'] E-Mail address where errors go to. Multiple addresses must be separated by a comma Relations: GLOBAL | Show |
531 | integer | no | $zz_conf['log_errors_max_len'] Relations: GLOBAL | Show |
532 | boolean | no | $zz_conf['log_errors'] Relations: GLOBAL | Show |
760 | boolean | no | $zz_conf['error_log_post'] Logs $_POST variables on error Relations: $zz_conf['log_errors'] | Show |
814 | string | no | $zz_conf['error_mail_parameters' Relations: $zz_conf['error_mail_from'] | Show |
1005 | string | no | $zz_conf['export_csv_delimiter'] delimiter between columns of CSV export | Show |
1004 | string | no | $zz_conf['export_csv_enclosure'] character that encloses strings in CSV export | Show |
1003 | boolean | no | $zz_conf['export_csv_no_head'] do not export titles as first line in CSV | Show |
1006 | array | no | $zz_conf['export_csv_replace'] list of characters that should be replaced when exporting to CSV | Show |
252 | mixed | no | $zz_conf['export'] if sql result might be exported (link for export will appear at the end of the page) Relations: export.inc.php; OUTPUT | Show |
897 | array | no | $zz_conf['footer_record'] | Show |
900 | string: HTML | no | $zz_conf['footer_record']['delet | Show |
898 | string: HTML | no | $zz_conf['footer_record']['inser | Show |
899 | string: HTML | no | $zz_conf['footer_record']['updat | Show |
239 | string: HTML | no | $zz_conf['footer_text'] Textblock at the end of div id zzform Relations: $zz['explanation']; OUTPUT | Show |
116 | string: filename | no | $zz_conf['form_scripts'] where form scripts reside Relations: zzbrick_tables/; $zz_setting['inc']; GLOBAL | Show |
269 | string | no | $zz_conf['format']['markdown'][' Relations: FORM | Show |
725 | boolean | no | $zz_conf['generate_output'] allows to not call some functions which are only needed to generate HTML output in case this is not needed | Show |
808 | array | no | $zz_conf['geo'] settings of the geo-module | Show |
809 | integer | no | $zz_conf['geo']['rounding'] rounding of geographical coordinates | Show |
812 | string: HTML | no | $zz_conf['geo']['spacer'] Symbol that separates degrees, minutes, seconds and hemisphere in degree display | Show |
925 | function | no | $zz_conf['geocoding_function'] Function to use for geocoding an address; gets array $address as input, utf8 encoded data,
* string 'country'
* string 'locality'
* string 'postal_code' (optional)
* string 'street_name' (optional)
* string 'street_number' (optional)
should return Array
* double 'longitude'
* double 'latitude'
* string 'postal_code'
if not set, function from zzwrap library will be used Relations: geo.inc.php | Show |
778 | string: HTML | no | $zz_conf['group_html_table'] Relations: $zz['fields'][n]['group_in_list'] | Show |
600 | string: function | no | $zz_conf['hash_password'] Name of PHP function to encrypt fields of type 'password' or 'password_change'; possible values are `md5`, `sha1`, `phpass` Relations: password; password_change | Show |
838 | integer | no | $zz_conf['hash_cost_log2'] if `phpass` is used as hash function, this is the number of iterations how often a hash function will be used | Show |
839 | boolean | no | $zz_conf['hash_portable'] if `phpass` is used as password hash function, this value indicates whether the hash should be portable to older versions | Show |
837 | string: filename | no | $zz_conf['hash_script'] filename of script with hash function if it's not a standard php function Relations: $zz_conf['hash_password'] | Show |
881 | string: HTML | no | $zz_conf['heading_prefix'] Sets a prefix for each table, e. g. a hierarchical path (breadcrumb) for the heading (string will be prepended with a space) Relations: $zz['title'] | Show |
862 | boolean | no | $zz_conf['html_autofocus'] set HTML attribute autofocus to first input field/first input field in added subrecord | Show |
214 | array | no | $zz_conf['if'] Relations: FORM; LIST | Show |
921 | array | no | $zz_conf['import_file_order_by_e Relations: zzform_multi() | Show |
117 | string: field | yes | $zz_conf['language'] Language code ISO 639-1
Language of zzform. English is the default language. For each language, you have to provide a file `$zz_conf['dir_inc']/text-[iso language code].inc.php` Relations: GLOBAL | Show |
843 | integer | no | $zz_conf['limit_all_max'] Maximum count of records which should be displayed on one page (if there are more records, 'all'-Link will be hidden) Relations: $zz_conf['limit'] | Show |
226 | integer | no | $zz_conf['limit'] display only limited amount of records per page, add links to browse through all records on several pages; false: show all records no matter how many Relations: LIST | Show |
728 | string | no | $zz_conf['limit_display'] display links to pages with page numbers or entries (begin-end of no. of records) | Show |
227 | integer | no | $zz_conf['limit_show_range'] range in which links to records around current selection will be shown Relations: LIST | Show |
221 | string | no | $zz_conf['list_display'] format of list display, defaults to `table`, other possibilities include `ul` Relations: LIST | Show |
256 | boolean | no | $zz_conf['logging'] logging of INSERT UPDATE DELETE enabled? Relations: ACTION | Show |
257 | boolean | no | $zz_conf['logging_id'] logging of record_id enabled? Relations: ACTION | Show |
258 | string: field | no | $zz_conf['logging_table'] table where logging will be written into Relations: ACTION | Show |
791 | string | no | $zz_conf['mail_subject_prefix'] Prefix, will be prepended to all mail subjects | Show |
534 | integer | no | $zz_conf['max_detail_records'] max 20 detail records, might be expanded later on Relations: FORM | Show |
259 | integer | no | $zz_conf['max_select_val_len'] maximum length of values in select Relations: FORM; LIST | Show |
260 | integer | no | $zz_conf['max_select'] configures the maximum entries in a select-dialog, if there are more entries, an empty input field will be provided Relations: FORM | Show |
949 | boolean | no | $zz_conf['merge'] If true, allows to merge existing records | Show |
535 | integer | no | $zz_conf['min_detail_records'] min 0 detail records, might be expanded later on Relations: FORM | Show |
951 | boolean | no | $zz_conf['multi_delete'] If true, allows to delete multiple records at once | Show |
950 | boolean | no | $zz_conf['multi_edit'] If true, allows to edit multiple records at once | Show |
536 | boolean | no | $zz_conf['multi'] signals zzform that script will be rerun several times, so certain initialization steps need only to be completed once Relations: GLOBAL | Show |
740 | string | no | $zz_conf['nice_tablename'][TAB] | Show |
852 | boolean | no | $zz_conf['no_add_above'] Relations: $zz_conf['add'] | Show |
907 | boolean | no | $zz_conf['no_ok'] Show/hide OK button below form | Show |
816 | string | no | $zz_conf['password_salt'] salt for password generation Relations: $zz_conf['hash_password'] | Show |
797 | string: filename | no | $zz_conf['pdflib_path'] string; path to pdf library Relations: $zz_conf['export'] | Show |
12 | string: SQL | no | $zz_conf['prefix'] Prefix for all table names in a database [default ''], table_prefix like zz_ (will be removed in error output) Relations: GLOBAL | Show |
247 | string: HTML | no | $zz_conf['project'] project name, used sparely Relations: GLOBAL | Show |
771 | boolean | no | $zz_conf['redirect_on_change'] Redirect after successful database operation or not (to avoid POST again after update) | Show |
861 | boolean | no | $zz_conf['redirect_to_referer_ze | Show |
261 | array | no | $zz_conf['redirect'] Relations: GLOBAL | Show |
264 | string | no | $zz_conf['redirect']['successful Relations: GLOBAL | Show |
263 | string | no | $zz_conf['redirect']['successful Relations: GLOBAL | Show |
262 | string | no | $zz_conf['redirect']['successful Relations: GLOBAL | Show |
234 | string | no | $zz_conf['referer'] referer which links back to previous page Relations: GLOBAL | Show |
51 | string: field | yes | $zz_conf['relations_table'] Table for relations for relational integrity Relations: GLOBAL | Show |
104 | string: filename | no | $zz_conf['root'] root directory of website Relations: GLOBAL | Show |
223 | mixed | no | $zz_conf['search'] Search records possible or not:
\ as first string in search query will be removed (escapes reserved symbols)
> greater than ... (should be used with scope set)
< lesser than ... (should be used with scope set)
[nothing] LIKE %...%
(true or bottom: below list, top = above list, both = below and above list)
Relations: OUTPUT | Show |
845 | boolean | no | $zz_conf['search_form_always'] normally, search form will not be shown if there are less records than will be shown on a page. if set to true, search form will be shown even if there are less records than set to limit | Show |
121 | boolean | no | $zz_conf['show_list_while_edit'] Relations: LIST | Show |
228 | boolean | no | $zz_conf['show_list'] display list of records in database Relations: LIST | Show |
229 | boolean | no | $zz_conf['show_output'] ECHO output or keep it in $zz['output'] for later use (e. g. zzform_all will use this) Relations: zzform_all(); OUTPUT | Show |
717 | string | no | $zz_conf['sync_concat_unique'] concat string for unique fields, might be changed if neccessary if ambiguous to unique IDs with strings | Show |
818 | array | no | $zz_conf['text'] extra (translated) text | Show |
819 | array | no | $zz_conf['text'][lang] text in this language (lang, two-letter ISO code); if -- is used as language code, all text will be replaced by this text or its translation | Show |
904 | string | no | $zz_conf['thousands_separator'] Thousands separator for numbers, depending on language | Show |
512 | boolean | no | $zz_conf['translations_of_fields Relations: translations.inc.php | Show |
514 | string: filename | no | $zz_conf['translations_script'] Relations: $zz_conf['translations_of_fields']; translations.inc.php | Show |
513 | string | no | $zz_conf['translations_table'] Relations: $zz_conf['translations_of_fields']; translations.inc.php | Show |
965 | boolean | no | $zz_conf['upload_imagick_options Relations: $zz_conf UPLOAD | Show |
230 | array | no | $zz_conf['url_self'] own url or target url Relations: GLOBAL | Show |
244 | string | no | $zz_conf['user'] user name, used for logging and errors Relations: ACTION | Show |
825 | boolean | no | $zz_conf['valid_request'] if access = add_only or edit_only and record was saved successfully, valid_request shows whether combination of zzaction and hash is correct | Show |
224 | boolean | no | $zz_conf['view'] view records, this will only be enabled if edit records is turned off Relations: FORM; LIST | Show |
519 | container | no | $zz_conf INTERNAL | Show |
766 | array | no | $zz_conf['int'] Internal variables, will be unset after exitting zzform() | Show |
736 | array | no | $zz_conf['int']['allowed_params' | Show |
871 | string | no | $zz_conf['int']['character_set_d | Show |
612 | string | no | $zz_conf['int']['db_current'] Database that was selected before zzform() started and will be selected again after finishing Relations: $zz_conf['db_name'] | Show |
613 | string | no | $zz_conf['int']['db_main'] main database normally is the same db that zzform() uses for its operations, but if you use several databases, this is the one which is the main db, i. e. the one that will be used if no other database name is specified Relations: $zz_conf['db_name'] | Show |
805 | array | no | $zz_conf['int']['error'] saved mail errors from zz_error() Relations: $zz_conf['error_handling'] | Show |
796 | string: function | no | $zz_conf['int']['export_script'] string; name of custom export function/script Relations: $zz_conf['export'] | Show |
524 | integer | no | $zz_conf['int']['group_field_no' | Show |
792 | boolean | no | $zz_conf['int']['hash_id'] true: hashed ID will sent as 'zzhash' to check if id is allowed in URL ($zz_conf['access'] = 'edit_only' or 'add_only') Relations: $zz_conf['access']; $zz_conf['int']['hash'] | Show |
793 | string | no | $zz_conf['int']['hash'] | Show |
887 | array | no | $zz_conf['int']['invalid_filters | Show |
543 | string | no | $zz_conf['int']['referer_esc'] = $zz_conf['referer'], & escaped to & | Show |
794 | string | no | $zz_conf['int']['secret_key'] secret key, made out of ID and hash for table definition, to check, whether access for an add_only or edit_only or add_then_edit-record should be granted Relations: $zz_var['id']['value']; $zz_conf['int']['hash'] | Show |
801 | boolean | no | $zz_conf['int']['text_included'] true: Translated text is already included, false: it's not included | Show |
540 | integer | no | $zz_conf['int']['this_limit'] internal value, current range which records are shown | Show |
767 | array | no | $zz_conf['int']['url'] URL of script | Show |
510 | string | no | $zz_conf['int']['url']['?&'] ? or & | Show |
770 | string | no | $zz_conf['int']['url']['base'] base url, i. e. scheme and hostname | Show |
769 | string | no | $zz_conf['int']['url']['full'] | Show |
542 | string | no | $zz_conf['int']['url']['qs_zzfor | Show |
541 | string | no | $zz_conf['int']['url']['qs'] Relations: $zz_conf['url_self'] | Show |
768 | string | no | $zz_conf['int']['url']['self'] own URL for form action Relations: $zz_conf['url_self'] | Show |
520 | array | no | $zz_conf['modules'] Loaded zzform modules | Show |
544 | integer | no | $zz_conf['zzform_calls'] check, how many times simultaneously zzform has been called (more than once looks like an error) | Show |
730 | boolean | no | $zz_conf['zzform_init'] signals whether zz_initalize() has been run completely or not | Show |
489 | container | no | $zz_conf UPLOAD $zz_conf-variables for upload module | Show |
19 | boolean | no | $zz_conf['backup'] Do a backup of old files? Relations: upload.inc.php; ACTION | Show |
270 | string: filename | no | $zz_conf['backup_dir'] directory where old files shall be backed up to Relations: upload.inc.php; ACTION | Show |
277 | array | no | $zz_conf['exif_supported'] filetypes that support exif. Relations: upload.inc.php; ACTION | Show |
275 | array | no | $zz_conf['file_types'] Known filetypes, array with array for each file_type ('filetype', 'ext_old', 'ext', 'mime', 'desc') Relations: upload.inc.php; ACTION | Show |
271 | string | no | $zz_conf['graphics_library'] graphics library used for image manipulation (imagemagick is default, gd is also possible, others are currently not supported) Relations: upload.inc.php; GLOBAL | Show |
273 | array | no | $zz_conf['imagemagick_paths'] paths where zzform looks for imagemagick binary Relations: upload.inc.php; GLOBAL | Show |
274 | array | no | $zz_conf['image_types'] Image filetypes, supported by PHP, should only be changed if PHP supports more. Relations: upload.inc.php; GLOBAL | Show |
747 | string: filename | no | $zz_conf['imagemagick_path_unche Relations: $zz_conf['imagemagick_paths'] | Show |
276 | array | no | $zz_conf['mime_types_rewritten'] array('unwanted_mimetype' => 'wanted_mimetype') e. g. for image/pjpeg = image/jpeg Relations: upload.inc.php; GLOBAL | Show |
222 | string: filename | no | $zz_conf['tmp_dir'] Directory; temporary folder for file uploads, should only be set if it has to be different from PHP temp dir Relations: upload.inc.php; GLOBAL | Show |
644 | boolean | no | $zz_conf['upload_copy_for_rename | Show |
597 | array | no | $zz_conf['upload_destination_fil Relations: upload.inc.php; $zz['fields'][n]['image'][n]['input_filetypes'] | Show |
820 | array | no | $zz_conf['upload_filetype_map'] Assigns different file extensions to a common filetype | Show |
927 | array | no | $zz_conf['upload_imagick_options Relations: $zz_conf['upload_imagick_options'] | Show |
713 | string | no | $zz_conf['upload_imagick_options | Show |
595 | array | no | $zz_conf['upload_iptc_fields'] Assignment of IPTC field indexes to readable field names Relations: upload.inc.php | Show |
926 | string: filename | no | $zz_conf['upload_log'] If set, will log all upload related exec functions into this file. | Show |
272 | integer | no | $zz_conf['upload_MAX_FILE_SIZE'] in bytes Relations: upload.inc.php; GLOBAL | Show |
624 | array | no | $zz_conf['upload_multipage_image Relations: upload.inc.php | Show |
850 | array | no | $zz_conf['upload_no_thumbnails'] List of filetypes where no thumbnails will be generated | Show |
942 | array | no | $zz_conf['upload_remap_type_if_e | Show |
609 | array | no | $zz_conf['upload_tools'] External tools used for uploads | Show |
990 | string: filename | no | $zz_conf['upload_tools']['exifto Relations: $zz_conf['upload_tools']['exiftools'] | Show |
610 | boolean | no | $zz_conf['upload_tools']['exifto | Show |
807 | string | no | $zz_conf['upload_tools']['filein Relations: $zz_conf['upload_tools']['fileinfo'] | Show |
594 | boolean | no | $zz_conf['upload_tools']['filein Relations: upload.inc.php | Show |
599 | boolean | no | $zz_conf['upload_tools']['ghosts Relations: upload.inc.php | Show |
351 | boolean | no | $zz_conf['upload_tools']['identi Relations: upload.inc.php; $zz_conf['graphics_library']; GLOBAL | Show |
596 | array | no | $zz_conf['webimages_by_extension Relations: upload.inc.php | Show |
501 | array | no | $zz_error | Show |
505 | integer | no | $zz_error[]['level'] | Show |
503 | string | no | $zz_error[]['msg_dev'] | Show |
502 | string | no | $zz_error[]['msg'] | Show |
507 | integer | no | $zz_error[]['mysql_errno'] | Show |
506 | string | no | $zz_error[]['mysql'] mysql error message | Show |
504 | string: SQL | no | $zz_error[]['query'] | Show |
81 | array | yes | $zz_page Defines elements to build webpage | Show |
90 | string: HTML | no | $zz_page['breadcrumb_separator'] String that concatenates the breadcrumb elements Relations: wrap_htmlout_breadcrumbs() | Show |
706 | mixed | no | $zz_page['custom'] custom variables, may be set by programmer | Show |
626 | array | auto | $zz_page['db'] Relations: zzwrap.php | Show |
86 | string | no | $zz_page['deep'] Relative path to root URL (for webpages that shall also work locally) Relations: $zz_page['url']['full']['path'] | Show |
890 | integer | no | $zz_page['error_code'] variable will be set internally, shows current error code to avoid loops Relations: wrap_quit() | Show |
824 | string: HTML | no | $zz_page['error_html'] | Show |
83 | string: filename | no | $zz_page['foot'] PHP include that outputs the page foot Relations: zzwrap.php; zzform_all() | Show |
82 | string: filename | no | $zz_page['head'] PHP include that outputs the page head Relations: zzwrap.php; zzform_all() | Show |
130 | string: HTML | no | $zz_page['id'] String, may be inserted by page head in body id=''. | Show |
772 | string: HTML | no | $zz_page['template_pagetitle_hom | Show |
773 | string: HTML | no | $zz_page['template_pagetitle'] see _home Relations: $zz_page['template_pagetitle_home'] | Show |
122 | array | no | $zz_page['url_placeholders'] Relations: wrap_look_for_page() | Show |
84 | array | auto | $zz_page['url'] URL of page Relations: zzwrap.php; auth.inc.php; cms_login(); wrap_check_https(); wrap_look_for_page(); wrap_quit() | Show |
85 | array | auto | $zz_page['url']['full'] Relations: $zz_setting['host_base'] | Show |
129 | string | auto | $zz_page['url']['full']['host'] | Show |
87 | string | auto | $zz_page['url']['full']['path'] | Show |
625 | string | auto | $zz_page['url']['full']['query'] | Show |
128 | string | auto | $zz_page['url']['full']['scheme' | Show |
92 | array | no | $zz_setting | Show |
935 | string | no | $zz_setting['*)maps_api_key'] API key for a map service to be used in a template Relations: $zz['geo_map_template'] | Show |
799 | array | no | $zz_setting['auth_urls'] list of URLs which are only accessible after authentication (string will be matched to URL case insensitive, all URLs starting with the string are affected) | Show |
166 | string | no | $zz_setting['base'] Base url to be prepended before 'root'. Later while processing the website this variable may contain language specific url parts. Ends with no slash! Will be prepended for:
- breadcrumb links
- link elements in page head template
- etc. Relations: page.inc.php; wrap_htmlout_breadcrumbs(); wrap_get_menu_navigation(); wrap_get_menu_webpages(); wrap_check_canonical() | Show |
863 | mixed | no | $zz_setting['brick_default_table | Show |
611 | array | no | $zz_setting['brick_formatting_fu Relations: zzbrick | Show |
749 | integer | no | $zz_setting['brick_import_error_ | Show |
705 | array | no | $zz_setting['brick_json_source_u Relations: zzbrick | Show |
290 | boolean | no | $zz_setting['brick_page_template | Show |
608 | boolean | no | $zz_setting['brick_request_cms'] Relations: zzbrick | Show |
704 | array | no | $zz_setting['brick_request_short Relations: zzbrick | Show |
703 | array | no | $zz_setting['brick_types_transla Relations: zzbrick | Show |
878 | integer | no | $zz_setting['cache_age'] maximum allowed age of cache file to use without requery; -1 means cache is always considered as fresh Relations: $zz_setting['cache'] | Show |
993 | string: filename | no | $zz_setting['cache_dir'] path to caching folder Relations: $zz_setting['cache'] | Show |
877 | boolean | no | $zz_setting['cache'] true: caching; false: no caching Relations: $zz_setting['cache_dir'] | Show |
745 | mixed | no | $zz_setting['change_password_url Relations: $zz_sql['login']; $zz_sql['domain'] | Show |
153 | boolean | no | $zz_setting['check_redirects'] whether to use the redirection table or not | Show |
94 | string: filename | no | $zz_setting['core'] Directory for core CMS scripts Relations: $zz_setting['inc'] | Show |
832 | string: filename | yes | $zz_setting['custom_wrap_dir'] Relations: $zz_setting['custom'] | Show |
831 | string: filename | no | $zz_setting['custom_wrap_sql_dir | Show |
297 | string: filename | no | $zz_setting['custom_wrap_templat | Show |
833 | string: filename | yes | $zz_setting['custom'] Relations: $zz_setting['inc'] | Show |
888 | string | no | $zz_setting['date_format'] sets date format for wrap_dates(), e. g. 'dates-de' | Show |
95 | string: filename | no | $zz_setting['db_inc'] Script that establishes datbase connection Relations: db.inc.php; $zz_setting['custom_wrap_sql_dir'] | Show |
875 | array | no | $zz_setting['db_password_files'] List of password files. Files starting with / will be treated as absolute, other files will be seen as extension to custom/zzwrap_sql/pwd{file}.inc. | Show |
913 | string | no | $zz_setting['error_prefix'] string that will be added as a prefix to the error message (in case a script will output several error messages with the same prefix, this can be a time-saver). | Show |
901 | boolean | no | $zz_setting['errors_not_logged_n | Show |
980 | array | no | $zz_setting['ext_libraries'] external libraries that are always included, e. g. for formatting | Show |
981 | array | no | $zz_setting['geocoder'] Define which geocoding functions to use. Currently implemented are: - Nominatim - Google Maps The order of the functions defines which results to prefer in case there is more than one results. The first geocoder precedes the others. | Show |
103 | string | no | $zz_setting['homepage_url'] Link to homepage | Show |
102 | string | no | $zz_setting['host_base'] Homepage URL, e. g. http://www.example.org Relations: $zz_setting['hostname']; $zz_setting['protocol'] | Show |
97 | string | no | $zz_setting['hostname'] hostname; hostname of server, e. g. www.example.com; default $_SERVER['HTTP_HOST'] | Show |
633 | array | no | $zz_setting['html_link_types'] HTML Link types, to separate valid from invalid link keys Relations: brick_head_format() | Show |
281 | array | no | $zz_setting['https_urls'] list of URLs that will be matched against the current URL, if they start with one of the URLs defined in this array (case insensitive), this URL will be only accessible via HTTPS Relations: $zz_setting['https'] | Show |
100 | boolean | no | $zz_setting['https'] default: if HTTPS-Connection and HTTPS allowed true, else false Relations: $zz_setting['no_https'] | Show |
282 | boolean | no | $zz_setting['ignore_scheme'] Relations: $zz_setting['https'] | Show |
93 | string: filename | yes | $zz_setting['inc'] PHP include directory for zzproject Relations: _inc/; $zz_conf['root'] | Show |
865 | string: filename | no | $zz_setting['kml_default_dot'] Default dot for KML export Relations: $zz_setting['kml_styles'] | Show |
864 | array | no | $zz_setting['kml_styles'] KML styles for the styles-section in KML export | Show |
88 | string: HTML | no | $zz_setting['lang'] page language, html lang attribute Relations: $zz_conf['language'] | Show |
984 | boolean | no | $zz_setting['language_not_in_nav | Show |
642 | array | no | $zz_setting['languages_allowed'] Language parts that are allowed and will be recognized in URLs | Show |
98 | boolean | no | $zz_setting['local_access'] Access via local network; default if hostname ending in .local true else false; Relations: $zz_setting['hostname'] | Show |
286 | string: filename | no | $zz_setting['local_pwd'] If a local development system is used under the address example.local, this password file is used | Show |
547 | boolean | no | $zz_setting['log_missing_text'] Logs untranslated text into logfile; %s-placeholder required for language | Show |
744 | mixed | no | $zz_setting['login_entryurl'] string or array; URL of webpage where you can login. If it's an array, URL may be set specfically to 'domain' | Show |
742 | string: function | no | $zz_setting['login_fields_format | Show |
120 | array | no | $zz_setting['login_fields_output | Show |
841 | array | no | $zz_setting['mail_summary'] Log lines for mail, sent in one mail instead of several mails Relations: $zz_conf['error_handling'] | Show |
165 | string | no | $zz_setting['main_menu'] Name of main menu Relations: page.inc.php; wrap_htmlout_menu() | Show |
162 | string | no | $zz_setting['menu_display_submen Relations: page.inc.php; wrap_htmlout_menu() | Show |
164 | string: HTML | no | $zz_setting['menu_mark_active_cl Relations: page.inc.php; wrap_htmlout_menu() | Show |
163 | string: HTML | no | $zz_setting['menu_mark_active_op Relations: page.inc.php; wrap_htmlout_menu() | Show |
155 | string | no | $zz_setting['menu'] Database source of menu (type of table) Relations: wrap_get_menu() | Show |
99 | boolean | no | $zz_setting['no_https'] HTTPS connections allowed; default true, if local access false
check if https is wanted or not
local connections are never made via https
Relations: $zz_setting['local_access'] | Show |
101 | string | no | $zz_setting['protocol'] 'http', 'https'; depending on connection Relations: $zz_setting['https'] | Show |
886 | string | no | $zz_setting['session_menu'] Name of menu that will be added to main menu if someone is logged in Relations: $zz_setting['main_menu'] | Show |
840 | string | no | $zz_setting['start_process'] Time information in a custom format, used by wrap_error_summary() if $zz_conf['error_handling'] = 'mail_summary' Relations: $zz_conf['error_handling'] | Show |
859 | string: filename | no | $zz_setting['sync_lists_dir'] filename where sync textfiles reside | Show |
858 | integer | no | $zz_setting['sync_page_refresh'] seconds until page will do a refresh after loading | Show |
857 | integer | no | $zz_setting['sync_records_per_ru | Show |
283 | boolean | no | $zz_setting['translate_page_titl | Show |
846 | string: filename | no | $zz_setting['wrap_template_dir'] Directory for default templates Relations: $zz_setting['custom_wrap_template_dir'] | Show |
634 | boolean | no | $zz_setting['xml_close_empty_tag Relations: brick_head_format() | Show |
118 | array | yes | $zz_sql Relations: zzwrap | Show |
711 | container | no | $zz_sql field names for zzwrap important field names of some database tables | Show |
561 | string: field | yes | $zz_sql['author_id'] Relations: sql-core.inc.php | Show |
556 | string: field | yes | $zz_sql['content'] Relations: sql-core.inc.php | Show |
558 | string: field | yes | $zz_sql['ending'] Relations: sql-core.inc.php | Show |
559 | string: field | yes | $zz_sql['identifier'] Relations: sql-core.inc.php | Show |
560 | string: field | yes | $zz_sql['lastupdate'] Relations: sql-core.inc.php | Show |
555 | string: field | yes | $zz_sql['page_id'] Relations: sql-core.inc.php | Show |
552 | string: field | no | $zz_sql['redirects_new_fieldname Relations: sql-core.inc.php; $zz_setting['check_redirects']; wrap_quit() | Show |
551 | string: field | no | $zz_sql['redirects_old_fieldname Relations: sql-core.inc.php; $zz_setting['check_redirects']; wrap_quit() | Show |
557 | string: field | yes | $zz_sql['title'] Relations: sql-core.inc.php | Show |
562 | string: SQL | no | $zz_sql['authors'] person_id = ID, person = name of author Relations: sql-page.inc.php | Show |
119 | string: SQL | no | $zz_sql['breadcrumbs'] Relations: wrap_get_breadcrumbs() | Show |
743 | string | no | $zz_sql['domain'] Name of domain, e. g. if there's more than one login area on a webpage or if there are different independent webpage parts that share something but not everything. This is a means to distinguish them. | Show |
549 | string: SQL | yes | $zz_sql['is_public'] Relations: sql-core.inc.php; wrap_look_for_page() | Show |
641 | string: SQL | no | $zz_sql['language'] | Show |
565 | string: SQL | no | $zz_sql['last_click'] Relations: auth.inc.php; sql-auth.inc.php | Show |
566 | string | no | $zz_sql['login_extra']['settings Relations: sql-auth.inc.php | Show |
867 | string: SQL | no | $zz_sql['login_settings'] If set, reads settings from database, indexed by SESSION['login_id'] | Show |
564 | string: SQL | no | $zz_sql['login'] SQL query for login procedure, password must be first field in list Relations: sql-auth.inc.php | Show |
563 | string: SQL | no | $zz_sql['logout'] Relations: sql-auth.inc.php | Show |
160 | string: SQL | no | $zz_sql['menu_level2'] expects: page_id, title, (id_title), mother_page_id, url (function_url), menu Relations: sql-page.inc.php; wrap_get_menu_webpages() | Show |
646 | string | no | $zz_sql['menu_table'] Name of table where to get menu entries from; for translation Relations: sql-page.inc.php; $zz_sql['menu'] | Show |
159 | string: SQL | no | $zz_sql['menu'] expects: nav_id, title, main_nav_id, url
optional parameters: id_title, rest is free;
expects: page_id, title, (id_title), mother_page_id, url, menu Relations: sql-page.inc.php; wrap_get_menu_navigation(); wrap_get_menu_webpages() | Show |
548 | string: SQL | yes | $zz_sql['pages'] Relations: sql-core.inc.php; wrap_look_for_page() | Show |
553 | string: SQL | no | $zz_sql['redirects_*'] Relations: sql-core.inc.php; $zz_setting['check_redirects']; wrap_quit() | Show |
550 | string: SQL | no | $zz_sql['redirects'] Relations: sql-core.inc.php; $zz_setting['check_redirects']; wrap_quit() | Show |
607 | array | no | $zz_sql['translation_matrix_brea Relations: sql-page.inc.php | Show |
606 | string | no | $zz_sql['translation_matrix_page Relations: sql-core.inc.php | Show |
490 | array | no | $zz_tab INTERNAL variable, for development only | Show |
491 | array | no | $zz_tab[0] main table | Show |
493 | array | no | $zz_tab[0][0] main table | Show |
708 | array | no | $zz_tab[0][0]['extra'] Generated by function in $field['post_validation'], 'extra' contains extra variables for a detail table created by this function. These variables can be accessed via 'detail_value' Relations: $zz['fields'][n]['detail_value']; $zz['fields'][n]['post_validation'] | Show |
492 | array | no | $zz_tab[tab] subtable, tab = 1...n | Show |
498 | integer | no | $zz_tab[tab]['max_records'] max. subrecords | Show |
499 | integer | no | $zz_tab[tab]['min_records'] min. subrecords | Show |
496 | integer | no | $zz_tab[tab]['no'] Field definition in `$zz['fields'][n]` | Show |
497 | integer | no | $zz_tab[tab]['records'] number of subrecords | Show |
738 | array | no | $zz_tab[tab]['subtable_deleted'] List of deleted records, id_values | Show |
495 | string | no | $zz_tab[tab]['table'] Database table of main or subtable | Show |
700 | array | no | $zz_tab[tab]['upload_fields'][0] | Show |
494 | array | no | $zz_tab[tab][0] subtable, first detail record | Show |
687 | array | no | $zz_tab[tab][rec] subrecord in table where tab is number of table (0 = main record, 1 ...n = subtables) and rec is number of record (tab = 0, rec = 0: main record, tab = 1...n, rec = 0...n = subrecords) | Show |
691 | string | no | $zz_tab[tab][rec]['action'] action for this record | Show |
689 | array | no | $zz_tab[tab][rec]['fields'] field definitions of this table; $zz['fields'] for main record or $zz['fields'][n]['fields'] for subtables | Show |
694 | array | no | $zz_tab[tab][rec]['id'] variables regarding current record_id Relations: $zz_var['id'] | Show |
695 | string | no | $zz_tab[tab][rec]['id']['field_n Relations: $zz_var['id']['field_name'] | Show |
696 | integer | no | $zz_tab[tab][rec]['id']['value'] value of PRIMARY KEY Relations: $zz_var['id']['value'] | Show |
698 | array | no | $zz_tab[tab][rec]['images'] uploaded files go here | Show |
699 | array | no | $zz_tab[tab][rec]['old_record'] update, delete together with file upload or renaming a folder:
save old record before update or delete in this array
Relations: $ops['record_old'] | Show |
688 | array | no | $zz_tab[tab][rec]['POST'] record as posted | Show |
692 | array | no | $zz_tab[tab][rec]['record'] record as it's displayed for user | Show |
693 | string | no | $zz_tab[tab][rec]['table_name'] Alias if there's more than one subtable of the same name; defaults to `table` | Show |
690 | boolean | no | $zz_tab[tab][rec]['validation'] shows if record is validated or not | Show |
508 | array | no | $zz_var INTERNAL variable, for development only | Show |
686 | string | no | $zz_var['action'] INTERNAL: what to do (POST): insert | update | delete | review | Show |
660 | string: HTML | no | $zz_var['class_add'] | Show |
511 | string | no | $zz_var['extraGET'] extra GET values | Show |
931 | array | no | $zz_var['filters'] filters set, = tested and corrected values of $_GET['filter'] Relations: $zz['filter'] | Show |
671 | string: HTML | no | $zz_var['formhead'] H2 heading in front of form element | Show |
659 | boolean | no | $zz_var['horizontal_table_head'] | Show |
651 | array | no | $zz_var['id'] | Show |
653 | string | no | $zz_var['id']['field_name'] | Show |
777 | integer | no | $zz_var['id']['source_value'] add in combination with source_id | Show |
652 | integer | no | $zz_var['id']['value'] | Show |
739 | array | no | $zz_var['integrity'] List with keys 'text' and 'fields'; if there are values, it means that the test for referential integrity were not passed and so deletion of a record is impossible | Show |
731 | boolean | no | $zz_var['record_action'] | Show |
733 | array | no | $zz_var['save_old_record'] | Show |
666 | array | no | $zz_var['subtables'] | Show |
657 | array | no | $zz_var['unique_fields'] | Show |
732 | boolean | no | $zz_var['upload_form'] false: no upload, true: upload possible | Show |
656 | array | no | $zz_var['where_condition'] | Show |
655 | boolean | no | $zz_var['where_with_unique_id'] | Show |
509 | array | no | $zz_var['where'] | Show |
661 | array | no | $zz_var['write_once'] | Show |
654 | array | no | $zz_var['zz_fields'] | Show |
131 | folder | yes | WEBSERVER_DIRECTORY Directory below DOCUMENT_ROOT, so we can put included files below DOCUMENT_ROOT. Not neccessary, the CMS will also work if all files are inside DOCUMENT_ROOT. This is for easier security only. | Show |
2 | folder | no | _backup/ Folder for backup of files which were deleted or overwritten while performing database operations. Files will not be deleted automatically - a cron job might do this. Relations: $zz_conf['backup'] | Show |
20 | folder | no | delete/ Deleted files during SQL delete operation. Folder will be created automatically. Old filename and timestamp of operation will be preserved. Relations: $zz_conf['backup'] | Show |
21 | folder | no | update/ Overwritten files during SQL update operation. Folder will be created automatically. Old filename and timestamp of operation will be preserved. Relations: $zz_conf['backup'] | Show |
3 | folder | yes | _inc/ Holds all scripts for the CMS which need to be included. Folder might be put below DOCUMENT_ROOT, chmod set to 700. | Show |
24 | file | yes | config.inc.php Main configuration file | Show |
169 | folder | no | custom/ Customized data | Show |
135 | folder | no | zzbrick_forms/ zzform scripts with parameter go here Relations: zzform; zzbrick | Show |
338 | folder | no | zzbrick_page/ scripts for page template Relations: zzbrick | Show |
339 | file | no | [page].inc.php page_*()-functions, will return $text for $parameter | Show |
836 | folder | no | zzbrick_request_get/ | Show |
22 | folder | yes | zzbrick_request/ Modules which will be included by the CMS depending on request with zzbrick. Relations: zzbrick | Show |
73 | file | no | [request].inc.php Local CMS data, read out data and output $page-array | Show |
340 | folder | no | zzbrick_rights/ Relations: zzbrick | Show |
65 | folder | yes | zzbrick_tables/ Scripts for table definitions, show, add, edit or delete records Relations: zzform; zzbrick | Show |
66 | file | no | logging.php Table definition: logging of database operations | Show |
67 | file | no | relations.php Table definition: relations table for relational integrity of database | Show |
29 | folder | no | zzform/ Additional scripts that will be called during database operations. Additional translated text for the corresponding website only. Relations: zzform | Show |
57 | file | no | db.inc.php Database connection to be used, if this file does not exist, established connection will be used. | Show |
56 | file | no | tablename-after-update.inc.php Script to be executed after succesful UPDATE query. 'tablename' can be chosen freely, does not have to correspond with real tablename. Other keywords are after/before (means after or before query), update/insert/delete for each SQL operations as required. | Show |
55 | file | no | text-en.inc.php Additional translated text Relations: text-en.inc.php | Show |
170 | folder | yes | zzwrap_sql/ Relations: zzwrap | Show |
61 | file | yes | db.inc.php Establishes database connection, password file may be included for different needs with different users. Normally includes pwd.inc.php | Show |
62 | file | yes | pwd.inc.php Provides connection information for mySQL database (host, password, user, db_name) | Show |
71 | file | yes | sql-auth.inc.php Local authentication SQL statements Relations: auth.inc.php | Show |
78 | file | no | sql-core.inc.php Core SQL queries, DB-Tables 'webpages' and 'redirects' | Show |
79 | file | no | sql-page.inc.php Page SQL queries, e. g. for breadcrumbs Relations: page.inc.php | Show |
58 | folder | yes | zzwrap/ Miscellaneous files. Relations: zzwrap | Show |
77 | file | no | _functions.inc.php Common functions which will be included from every page | Show |
64 | file | yes | html-foot.inc.php Footer of HTML page, as required Relations: $zz_page['foot'] | Show |
63 | file | yes | html-head.inc.php Head of HTML page, as required Relations: $zz_page['head'] | Show |
72 | file | no | local-*.inc.php Local CMS module modifications | Show |
136 | file | no | start.inc.php Functions that will always be included before other files are included | Show |
326 | file | no | usergroups.inc.php Register groups in $_SESSION Relations: wrap_register_usergroups() | Show |
168 | folder | yes | library/ Files that must not be customized, libraries | Show |
80 | folder | no | fpdf/ FPDF scripts for PDF production | Show |
33 | file | no | markdown-extra.php Markdown Extra | Show |
27 | file | no | markdown.php Markdown language | Show |
34 | file | no | textile.php Textile language | Show |
137 | folder | yes | zzbrick/ Relations: zzbrick | Show |
139 | file | no | comment.inc.php Comment blocks, won't be displayed | Show |
140 | file | no | forms.inc.php Includes zzform scripts via brick_format() | Show |
141 | file | no | ipfilter.inc.php shows content only if client is in preset IP range | Show |
142 | file | no | position.inc.php Sets position of text block in a predefined matrix | Show |
143 | file | no | redirect.inc.php Redirects to another URL | Show |
144 | file | no | request.inc.php Outputs database queries in a formatted way, with URL parameters | Show |
145 | file | no | rights.inc.php Depending on the result of a custom function, access to the following content is allowed or forbidden (e. g. will be shown or not) | Show |
138 | file | yes | zzbrick.php brick_format() formats textblocks | Show |
28 | folder | yes | zzform/ Scripts for database operation (INSERT, DELETE, UPDATE, SELECT records, im- and export of information, media management) Relations: zzform | Show |
39 | file | yes | action.inc.php Functions for database operations: INSERT, UPDATE, DELETE | Show |
36 | file | no | compatibility.inc.php Required for old zzform installations, to ensure backward compatibility | Show |
288 | file | no | debug.inc.php Debug functions for zzform | Show |
42 | file | no | export.inc.php Export module for zzform, exports database records to other formats, e. g. CSV, PDF, ... | Show |
43 | file | no | filetypes.txt Upload module: List of known filetypes Relations: upload.inc.php | Show |
44 | file | no | forcefilename-iso-8859-1.inc.php Function forceFilename() to reformat strings to be used as filenames (type identifier, file upload). [iso-8859-1] might be replaced with other encodings as [utf-8], [iso-8859-2] etc. Relations: $zz_conf['character_set'] | Show |
46 | file | no | forcefilename-iso-8859-2.inc.php Relations: forcefilename-iso-8859-1.inc.php | Show |
47 | file | no | forcefilename-utf-8.inc.php | Show |
38 | file | yes | functions.inc.php Miscellaneous functions for zzform scripts | Show |
48 | file | no | geo.inc.php Geo module: Handling of geographic coordinates (input, output, transformation DMS - DD and vice versa) | Show |
49 | file | no | image-imagemagick.inc.php Upload module: Image manipulation with imageMagick Relations: upload.inc.php | Show |
50 | file | yes | integrity.inc.php Functions for checking for relational integrity of mysql-databases uses table _relations, similar to the PHPMyAdmin table of relations Relations: $zz_conf['relations_table'] | Show |
40 | file | yes | list.inc.php Functions to display list view of several records, as ul, table or for export | Show |
52 | file | yes | numbers.inc.php Number/Date Functions, will be used from CMS output as well. Relations: zzwrap.php | Show |
37 | file | yes | record.inc.php Functions to display a record in form view, part of zzform | Show |
32 | file | no | text-de.inc.php German language file | Show |
31 | file | yes | text-en.inc.php English language file. Further language files might be included with translation and corresponding ISO language code ending, e. g. text-de.inc.php for German language. | Show |
515 | file | no | translations.inc.php Translations module | Show |
53 | file | no | upload.inc.php Module upload | Show |
54 | file | yes | validate.inc.php Functions that validate user input against a set of rules, depending on field type Relations: validation.inc.php | Show |
41 | file | yes | validation.inc.php General zzform specific validation function | Show |
30 | file | yes | zzform.php Main zzform script, includes other scripts if required. Functions zzform() and zzform_all() | Show |
74 | folder | yes | zzwrap/ Core CMS files which build the basic page structure. Relations: zzwrap | Show |
68 | file | yes | auth.inc.php Activation of authentication; Authentication check, will be called every click (in restricted areas only); Login and logout procedures, checks which pages are protected and require login | Show |
69 | file | yes | core.inc.php Core CMS functions: looks for page in database; quit cms; redirects; format text and - if requested - replace placeholders with database content | Show |
304 | file | yes | default-http-error.template.txt HTML template for HTTP error messages, part of page to be included in page template. [%%% brick syntax] | Show |
305 | file | no | default-text-de.inc.php Default translations for German | Show |
76 | file | yes | defaults.inc.php Default variables | Show |
132 | file | yes | errorhandling.inc.php Functions that do the error handling | Show |
306 | file | yes | http-errors.txt List of HTTP errors (HTTP-Code, HTTP-Header, Description) | Show |
133 | file | no | language.inc.php Language functions, setting and including language and language files | Show |
70 | file | yes | page.inc.php Get page details (menus, breadcrumbs, authors). | Show |
23 | file | yes | zzwrap.php Starts CMS output. Includes CMS modules, authentication, extensions, misc functions; reads page contents from database and performs necessary actions, reads breadcrumbs, authors, last update etc. Glues together head, output and foot. | Show |
295 | folder | no | templates/ Relations: zzwrap | Show |
296 | file | no | page.template.txt page template in zzbrick-notation | Show |
1 | folder | yes | DOCUMENT_ROOT | Show |
4 | folder | no | _behaviour/ suggested for JavaScript files and other, not a must-have | Show |
834 | folder | no | zzform/ | Show |
350 | file | no | zzform-foot.js JS for hierarchical selects in Safari | Show |
14 | folder | yes | _layout/ CSS files, CSS graphics and sprites, logos etc. | Show |
835 | folder | yes | zzform/ | Show |
17 | file | no | zzform-colours.css Colour definitions for zzform.css - might be adjusted individually. Should be included in main css for site. | Show |
16 | file | no | zzform-print.css Print stylesheet for zzform database scripts | Show |
15 | file | yes | zzform.css CSS file for zzform database editing scripts, touches only HTML inside <div id="zzform"> (#zzform). Should be linked from in html-head.inc.php for all database operations. | Show |
107 | folder | yes | _scripts/ | Show |
113 | file | yes | main.php Main CMS script that starts CMS; setting where root and include directories reside must be localized here if non-standard Relations: zzwrap.php | Show |
18 | file | yes | .htaccess Apache .htaccess file. Redirects selected URLs to CMS. This may go as well into the httpd.conf | Show |
487 | container | no | zz_constants | Show |
488 | constant | no | ZZ_UPLOAD_INI_MAXFILESIZE | Show |
365 | container | no | zz_fieldtypes Allowed values for `$zz['field'][n]['type']` Relations: $zz['fields'][n]['type'] | Show |
387 | value | no | calculated Relations: $zz['fields'][n]['calculation_fields']; $zz['fields'][n]['calculation'] | Show |
373 | value | no | date | Show |
406 | value | no | datetime MySQL DATETIME field, will be checked if valid | Show |
380 | value | no | detail_key inserts in field id_field from different detail_record Relations: $zz['fields'][n]['detail_key_index'] | Show |
400 | value | no | display field for display only, not editable Relations: $zz['fields'][n]['display_field'] | Show |
403 | value | no | foreign foreign ... (not in use currently) -> add_foreign ?? | Show |
378 | value | no | foreign_key Field is foreign_key (only possible for subtables), must be set once for each subtable (unless it's a translation subtable) Relations: subtable | Show |
853 | value | no | geo_point SQL POINT field with latitude and longitude as binary Relations: $zz['fields'][n]['geo_format']; $zz['fields'][n]['text_field']; $zz['fields'][n]['list_concat_fields'] | Show |
389 | value | no | hidden hidden field Relations: $zz['fields'][n]['value']; $zz['fields'][n]['function'] | Show |
370 | value | yes | id unique ID field of record Relations: $zz['fields'][n]['show_id'] | Show |
368 | value | no | identifier textual identifier for a record, unique, will be put together from 'fields' Relations: $zz['fields'][n]['conf_identifier']; $zz['fields'][n]['fields'] | Show |
393 | value | no | image displays an image Relations: $zz['fields'][n]['path']; $zz['fields'][n]['default_image'] | Show |
908 | value | no | ip Stores IPv4 and IPv6 addresses in a VARBINARY(16) field | Show |
382 | value | no | ipv4 | Show |
905 | value | no | list_function display field; list_function will be called for display with parameters $field, $value and $line | Show |
385 | value | no | mail email address, will be checked for validity and hyperlinked in list | Show |
715 | value | no | mail+name Validates input of e. g. "Master X" <x@example.org> and allows input of multiple e-mail addresses, separated by comma or semicolon Relations: mail | Show |
372 | value | no | memo Will show textarea (multiple lines) Relations: $zz['fields'][n]['format']; $zz['fields'][n]['rows']; $zz['fields'][n]['cols']; $zz['fields'][n]['rows_max']; $zz['fields'][n]['list_format'] | Show |
367 | value | no | number Number, will be checked for validity. Basic calculation is allowed, e. g. `4+5` will save `9` into the database (+, -, \, *). Decimal commas are replaced (if unambiguous) with dots
Relations: $zz['fields'][n]['number_type']; $zz['fields'][n]['unit']; $zz['fields'][n]['factor']; $zz['fields'][n]['auto_value'] | Show |
381 | value | no | option field to choose an option, won't be saved to database Relations: $zz['fields'][n]['type_detail']; $zz['fields'][n]['options'] | Show |
390 | value | no | password password input, will be saved as hash Relations: $zz_conf['hash_password'] | Show |
391 | value | no | password_change change a password (enter old, enter new twice, md5 encoded) Relations: password; $zz['fields'][n]['sql_password_check'] | Show |
377 | value | no | predefined INTERNAL USE only Relations: $zz['fields'][n]['type_detail'] | Show |
369 | value | no | select Lets user select a value from different data sources: foreign database table, ENUM or SET values. Relations: $zz['fields'][n]['sql']; $zz['fields'][n]['display_field']; $zz['fields'][n]['show_values_as_list']; $zz['fields'][n]['set']; $zz['fields'][n]['enum']; $zz['fields'][n]['sql_where']; $zz['fields'][n]['sql_without_id']; $zz['fields'][n]['sql_ignore']; $zz['fields'][n]['show_hierarchy_subtree']; $zz['fields'][n]['show_hierarchy']; $zz['fields'][n]['key_field_name']; $zz['fields'][n]['show_hierarchy_use_top_value_instead_NULL']; $zz['fields'][n]['add_details']; $zz['fields'][n]['path_sql']; $zz['fields'][n]['hide_novalue']; $zz['fields'][n]['size_select_too_long'] | Show |
376 | value | no | subtable subrecord with foreign key which can be edited together with main record.
when linking tables (subtables, details), special care has to be taken that the key field names are alike
Relations: $zz['fields'][n]['table_name']; $zz['fields'][n]['form_display']; $zz['fields'][n]['class_add']; $zz['fields'][n]['records_depend_on_upload']; foreign_key; $zz['fields'][n]['foreign_key_field_name'] | Show |
366 | value | no | text standard input, one line text field, maxlength from VARCHAR-value if applicable, else size=32 Relations: $zz['fields'][n]['format']; $zz['fields'][n]['subselect']['list_format']; $zz['fields'][n]['size'] | Show |
374 | value | no | time time, will be checked for validity | Show |
371 | value | no | timestamp MySQL timestamp, supports both `20040412120436` and `2004-04-12 12:04:36` formats.
- value may be set via `'value'`, if not, current time will be used
Relations: $zz['fields'][n]['value'] | Show |
379 | value | no | translation_key | Show |
394 | value | no | unix_timestamp Unix timestamp, will be converted to readable date and back Relations: $zz['fields'][n]['value'] | Show |
375 | value | no | upload_image File upload. Each file that shall be uploaded has to get a distinctive field_name in the 'image'-section! Relations: $zz['fields'][n]['path']; $zz['fields'][n]['dont_show_image']; $zz['fields'][n]['image'] | Show |
384 | value | no | url URL, will be checked for validity (absolute URLs only, `http://` as well as beginning with `/`). If something starting with `www.` is entered, `http://` will be prepended. Displayed as hyperlink in list. | Show |
383 | value | no | write_once Relations: $zz['fields'][n]['type_detail'] | Show |
480 | container | no | zz_states | Show |
481 | value | no | ACTION Modification of a record (`INSERT`, `UPDATE`, `DELETE`) | Show |
482 | value | no | FORM HTML form output of a single record | Show |
486 | value | no | GLOBAL Globally used | Show |
483 | value | no | LIST HTML list output (`table`, `ul`) of all records | Show |
484 | value | no | OUTPUT HTML page output | Show |
329 | project | no | zzbrick | Show |
349 | function | yes | brick_format() Relations: zzbrick.php | Show |
485 | function | no | brick_forms() includes zzform forms | Show |
635 | function | no | brick_head_format() Formats values in $page that should go into the HTML head section | Show |
328 | project | no | zzform Functions namespace: zz_* - all zzform functions | Show |
584 | project | yes | zzform core | Show |
124 | function | no | zzform_all() Relations: zzform.php | Show |
125 | function | no | zzform_multi() Relations: zzform.php | Show |
123 | function | yes | zzform() Main function for form scripts Relations: zzform.php | Show |
583 | project | no | zzform upload module Function namespaces: zz_upload_* - Upload module zz_image_* - Upload module: Image manipulation via function zz_imagick_* - Upload module: ImageMagick functions zz_gd_* - Upload module: GD functions | Show |
587 | function | no | zz_upload_action() writes/deletes files after successful sql insert/update Relations: upload.inc.php | Show |
588 | function | no | zz_upload_sqlval() Relations: upload.inc.php | Show |
586 | function | no | zz_upload_check() validates file input (upload errors, requirements) Relations: upload.inc.php | Show |
592 | function | no | zz_upload_checkdir() creates new directory and upper dirs as well Relations: upload.inc.php | Show |
589 | function | no | zz_upload_cleanup() cleanup after files have been moved or deleted Relations: upload.inc.php | Show |
593 | function | no | zz_upload_get_typelist() reads filetypes from txt-file Relations: upload.inc.php | Show |
574 | function | no | zz_upload_get() writes arrays upload_fields, images, i. e. checks which fields offer uploads, collects and writes information about files Relations: upload.inc.php | Show |
576 | function | no | zz_upload_check_files() checks files, puts information to 'image' array Relations: upload.inc.php | Show |
581 | function | no | zz_upload_filecheck() gets filetype from list Relations: upload.inc.php | Show |
577 | function | no | zz_upload_fileinfo() read information (filesize, exif etc.) Relations: upload.inc.php | Show |
579 | function | no | zz_upload_make_name() converts filename to better filename Relations: upload.inc.php | Show |
578 | function | no | zz_upload_make_title() converts filename to title Relations: upload.inc.php | Show |
580 | function | no | zz_upload_mimecheck() checks whether supposed mimetype was already checked for Relations: upload.inc.php | Show |
575 | function | no | zz_upload_get_fields() checks which fields allow upload Relations: upload.inc.php | Show |
590 | function | no | zz_upload_path() creates unique name for file (?) Relations: upload.inc.php | Show |
582 | function | no | zz_upload_prepare() prepares files for upload (resize, rotate etc.) Relations: upload.inc.php | Show |
585 | function | no | zz_upload_extension() gets file extension Relations: upload.inc.php | Show |
591 | function | no | zz_upload_reformat_field() removes "" from validated field, if neccessary Relations: upload.inc.php | Show |
330 | project | no | zzwrap | Show |
309 | function | no | cms_login() Relations: auth.inc.php | Show |
310 | function | no | cms_login_ldap() Relations: auth.inc.php | Show |
311 | function | no | cms_login_redirect() Relations: auth.inc.php | Show |
312 | function | no | cms_logout() Relations: auth.inc.php | Show |
324 | function | no | wrap_access_rights() customized | Show |
316 | function | yes | wrap_check_canonical() Make canonical URLs (trailing slash, .html etc.) Relations: core.inc.php | Show |
317 | function | yes | wrap_check_https() checks if a request must definitely be either https or http and redirects if request uses other scheme Relations: core.inc.php | Show |
315 | function | no | wrap_content_replace() customized, allows replacement of parts of the final HTML, e. g. with regular expressions (link targets ...) | Show |
167 | function | yes | wrap_db_fetch() Fetches records from database and returns array Relations: core.inc.php; page.inc.php | Show |
307 | function | no | wrap_get_authors() gets authors from database Relations: page.inc.php | Show |
148 | function | no | wrap_get_breadcrumbs() gets breadcrumbs from database Relations: page.inc.php | Show |
152 | function | no | wrap_get_breadcrumbs_recursive() recursively gets breadcrumbs from database Relations: page.inc.php | Show |
150 | function | no | wrap_get_media() customized function to get media content (documents as well as images), linked to page or other items. parameters: 1. ID or Array of IDs (required) 2. type (e. g. table name) (optional, defaults to page) 3. base_url (optional, defaults to false) | Show |
146 | function | no | wrap_get_menu() gets menu from database Relations: page.inc.php | Show |
154 | function | no | wrap_get_menu_navigation() gets menu from separate navigation table Relations: page.inc.php | Show |
156 | function | no | wrap_get_menu_webpages() gets menu from webpages table Relations: page.inc.php | Show |
313 | function | no | wrap_menu_session() customized | Show |
157 | function | no | wrap_translate_menu() customized | Show |
158 | function | no | wrap_menu_*() customized: submenus with placeholders | Show |
149 | function | no | wrap_htmlout_breadcrumbs() outputs breadcrumbs in HTML Relations: page.inc.php; wrap_get_breadcrumbs() | Show |
151 | function | no | wrap_htmlout_media() | Show |
147 | function | no | wrap_htmlout_menu() outputs menu in HTML Relations: wrap_get_menu() | Show |
308 | function | no | wrap_htmlout_page() outputs webpage from %%%-template in HTML Relations: page.inc.php | Show |
319 | function | yes | wrap_look_for_page() Tests whether URL is in database (or a part of it ending with *, or a part of it with placeholders) Relations: core.inc.php | Show |
323 | function | no | wrap_magic_quotes_strip() customized | Show |
314 | function | no | wrap_matrix() customized | Show |
322 | function | no | wrap_page_*() customized | Show |
604 | function | no | wrap_prepare_url() user defined, do some URL manipulation before handing over the URL to zzwrap | Show |
321 | function | yes | wrap_quit() Stops execution of script, check for redirects to other pages, includes http error pages Relations: core.inc.php | Show |
320 | function | yes | wrap_read_url() builds URL from REQUEST Relations: core.inc.php | Show |
325 | function | no | wrap_register_usergroups() customized, register (additional) groups in $_SESSION Relations: usergroups.inc.php | Show |
602 | function | no | wrap_rights('preview') Page preview allowed? (unpublished content) - can be set in config (e. g. if SERVER_NAME == testserver) but will be checked later on if secret_key is set and preview so far is false | Show |
318 | function | no | wrap_test_secret_key() Test, whether URL contains a correct secret key to allow page previews Relations: core.inc.php | Show |
134 | function | yes | wrap_text() Translates text Relations: language.inc.php | Show |
916 records total