Technical Documentation

IDCategoryReq.Element Action
378valuenoforeign_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
853valuenogeo_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
389valuenohidden hidden field

Relations: $zz['fields'][n]['value']; $zz['fields'][n]['function']

Show
370valueyesid unique ID field of record

Relations: $zz['fields'][n]['show_id']

Show
368valuenoidentifier textual identifier for a record, unique, will be put together from 'fields'

Relations: $zz['fields'][n]['conf_identifier']; $zz['fields'][n]['fields']

Show
393valuenoimage displays an image

Relations: $zz['fields'][n]['path']; $zz['fields'][n]['default_image']

Show
908valuenoip Stores IPv4 and IPv6 addresses in a VARBINARY(16) fieldShow
382valuenoipv4 Show
905valuenolist_function display field; list_function will be called for display with parameters $field, $value and $lineShow
385valuenomail email address, will be checked for validity and hyperlinked in listShow
715valuenomail+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
372valuenomemo 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
367valuenonumber 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
381valuenooption field to choose an option, won't be saved to database

Relations: $zz['fields'][n]['type_detail']; $zz['fields'][n]['options']

Show
390valuenopassword password input, will be saved as hash

Relations: $zz_conf['hash_password']

Show
391valuenopassword_change change a password (enter old, enter new twice, md5 encoded)

Relations: password; $zz['fields'][n]['sql_password_check']

Show
377valuenopredefined INTERNAL USE only

Relations: $zz['fields'][n]['type_detail']

Show
369valuenoselect 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
376valuenosubtable 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
366valuenotext 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

916 records total

in