Page:
SYSTEM SQL system_api
Pages
ApiIndex
DEPRECATED
ERROR
INFO
JsonResult
LIB lib
LIB lib_controll
LIB lib_css
LIB lib_js
LIB lib_jscss
LIB lib_php
LIB lib_system
LIB lib_textillate
SYSTEM API api
SYSTEM API api_default
SYSTEM API api_default_interface
SYSTEM API api_login
SYSTEM API api_system
SYSTEM API verify
SYSTEM CACHE cache
SYSTEM CACHE cache_css
SYSTEM CACHE cache_filemask
SYSTEM CACHE cache_js
SYSTEM CACHE cache_scss
SYSTEM CONFIG config
SYSTEM CONFIG config_ids
SYSTEM CRON cron
SYSTEM CRON cron_cache_delete
SYSTEM CRON cron_log2sqlite
SYSTEM CRON cronjob
SYSTEM CRON cronstatus
SYSTEM CRON crontime
SYSTEM DB Connection
SYSTEM DB ConnectionAMQP
SYSTEM DB ConnectionAbstr
SYSTEM DB ConnectionMYS
SYSTEM DB ConnectionPG
SYSTEM DB ConnectionSQLite
SYSTEM DB DBInfo
SYSTEM DB DBInfoAMQP
SYSTEM DB DBInfoMYS
SYSTEM DB DBInfoPG
SYSTEM DB DBInfoSQLite
SYSTEM DB QI
SYSTEM DB QP
SYSTEM DB QQ
SYSTEM DB Result
SYSTEM DB ResultAMQP
SYSTEM DB ResultMysqli
SYSTEM DB ResultMysqliPrepare
SYSTEM DB ResultPostgres
SYSTEM DB ResultSQLite
SYSTEM DOCU docu
SYSTEM DOCU docu_package
SYSTEM DOCU docu_system
SYSTEM FILES files
SYSTEM HEADER
SYSTEM HTML html
SYSTEM LOG AbstractResult
SYSTEM LOG COUNTER
SYSTEM LOG CRON
SYSTEM LOG DEPRECATED
SYSTEM LOG ERROR
SYSTEM LOG ERROR_EXCEPTION
SYSTEM LOG INFO
SYSTEM LOG JsonResult
SYSTEM LOG SHUTDOWN_EXCEPTION
SYSTEM LOG SYSTEM_ERROR_EXCEPTION
SYSTEM LOG SYSTEM_EXCEPTION
SYSTEM LOG TODO
SYSTEM LOG TranslatableError
SYSTEM LOG WARNING
SYSTEM LOG error_handler
SYSTEM LOG error_handler_dbwriter
SYSTEM LOG error_handler_jsonoutput
SYSTEM LOG log
SYSTEM PAGE DefaultPage
SYSTEM PAGE Page
SYSTEM PAGE ParensParser
SYSTEM PAGE State
SYSTEM PAGE replace
SYSTEM PAGE text
SYSTEM PATH
SYSTEM PLIB
SYSTEM PROOT
SYSTEM PSAI
SYSTEM PSQL
SYSTEM PSYSTEM
SYSTEM SAI SaiModule
SYSTEM SAI default_page
SYSTEM SAI sai
SYSTEM SAI saigui
SYSTEM SAI saimod_sys_api
SYSTEM SAI saimod_sys_cache
SYSTEM SAI saimod_sys_config
SYSTEM SAI saimod_sys_cron
SYSTEM SAI saimod_sys_docu
SYSTEM SAI saimod_sys_files
SYSTEM SAI saimod_sys_git
SYSTEM SAI saimod_sys_langswitcher
SYSTEM SAI saimod_sys_log
SYSTEM SAI saimod_sys_login
SYSTEM SAI saimod_sys_mod
SYSTEM SAI saimod_sys_page
SYSTEM SAI saimod_sys_security
SYSTEM SAI saimod_sys_text
SYSTEM SAI saimod_sys_todo
SYSTEM SAI saistart_sys_sai
SYSTEM SAI todo_stats
SYSTEM SAI todo_stats_assign
SYSTEM SAI todo_stats_data
SYSTEM SAI todo_stats_gen
SYSTEM SAI todo_stats_report
SYSTEM SAI todo_stats_user
SYSTEM SECURITY RIGHTS
SYSTEM SECURITY Security
SYSTEM SECURITY User
SYSTEM SQL DATA_DEFAULT
SYSTEM SQL DATA_SYSTEM_API
SYSTEM SQL DATA_SYSTEM_CRON
SYSTEM SQL DATA_SYSTEM_PAGE
SYSTEM SQL DATA_SYSTEM_RIGHTS
SYSTEM SQL DATA_SYSTEM_TEXT
SYSTEM SQL SCHEMA_SYSTEM
SYSTEM SQL SYS_API_TREE
SYSTEM SQL SYS_CACHE_CHECK
SYSTEM SQL SYS_CACHE_DELETE
SYSTEM SQL SYS_CACHE_DELETE_ALL
SYSTEM SQL SYS_CACHE_PUT
SYSTEM SQL SYS_CRON_GET
SYSTEM SQL SYS_CRON_LAST_VISIT
SYSTEM SQL SYS_CRON_LIST
SYSTEM SQL SYS_CRON_UPD
SYSTEM SQL SYS_LOCALE_SET_LOCALE
SYSTEM SQL SYS_LOG_DEL
SYSTEM SQL SYS_LOG_INSERT
SYSTEM SQL SYS_LOG_MONTH
SYSTEM SQL SYS_LOG_OLDEST
SYSTEM SQL SYS_PAGE_GROUP
SYSTEM SQL SYS_SAIMOD_API_ADD
SYSTEM SQL SYS_SAIMOD_API_DEL
SYSTEM SQL SYS_SAIMOD_API_GET
SYSTEM SQL SYS_SAIMOD_API_GROUPS
SYSTEM SQL SYS_SAIMOD_API_SINGLE_SELECT
SYSTEM SQL SYS_SAIMOD_CACHE
SYSTEM SQL SYS_SAIMOD_CACHE_CLEAR
SYSTEM SQL SYS_SAIMOD_CACHE_COUNT
SYSTEM SQL SYS_SAIMOD_CRON
SYSTEM SQL SYS_SAIMOD_CRON_ADD
SYSTEM SQL SYS_SAIMOD_CRON_CHANGE
SYSTEM SQL SYS_SAIMOD_CRON_DEL
SYSTEM SQL SYS_SAIMOD_CRON_SINGLE_SELECT
SYSTEM SQL SYS_SAIMOD_LOG_ANALYTICS
SYSTEM SQL SYS_SAIMOD_LOG_BASIC_QUERYTIME
SYSTEM SQL SYS_SAIMOD_LOG_BASIC_SUCCESS
SYSTEM SQL SYS_SAIMOD_LOG_BASIC_VISITOR
SYSTEM SQL SYS_SAIMOD_LOG_CLASS_BASIC
SYSTEM SQL SYS_SAIMOD_LOG_CLASS_OTHER
SYSTEM SQL SYS_SAIMOD_LOG_CLASS_SYSTEM
SYSTEM SQL SYS_SAIMOD_LOG_ERROR
SYSTEM SQL SYS_SAIMOD_LOG_FILTER
SYSTEM SQL SYS_SAIMOD_LOG_FILTERS
SYSTEM SQL SYS_SAIMOD_LOG_FILTER_COUNT
SYSTEM SQL SYS_SAIMOD_LOG_TRUNCATE
SYSTEM SQL SYS_SAIMOD_LOG_UNIQUE_BASIC
SYSTEM SQL SYS_SAIMOD_LOG_UNIQUE_EXCEPTION
SYSTEM SQL SYS_SAIMOD_LOG_UNIQUE_REFERER
SYSTEM SQL SYS_SAIMOD_LOG_UNIQUE_REQUEST
SYSTEM SQL SYS_SAIMOD_PAGE_ADD
SYSTEM SQL SYS_SAIMOD_PAGE_DEL
SYSTEM SQL SYS_SAIMOD_PAGE_GET
SYSTEM SQL SYS_SAIMOD_PAGE_GROUPS
SYSTEM SQL SYS_SAIMOD_PAGE_SINGLE_SELECT
SYSTEM SQL SYS_SAIMOD_SECURITY_DELETE_USER
SYSTEM SQL SYS_SAIMOD_SECURITY_DELETE_USER_RIGHTS
SYSTEM SQL SYS_SAIMOD_SECURITY_RENAME_USER
SYSTEM SQL SYS_SAIMOD_SECURITY_RIGHTS
SYSTEM SQL SYS_SAIMOD_SECURITY_RIGHT_CHECK
SYSTEM SQL SYS_SAIMOD_SECURITY_RIGHT_DELETE
SYSTEM SQL SYS_SAIMOD_SECURITY_RIGHT_INSERT
SYSTEM SQL SYS_SAIMOD_SECURITY_USER
SYSTEM SQL SYS_SAIMOD_SECURITY_USERS
SYSTEM SQL SYS_SAIMOD_SECURITY_USERS_FILTER
SYSTEM SQL SYS_SAIMOD_SECURITY_USER_COUNT
SYSTEM SQL SYS_SAIMOD_SECURITY_USER_COUNT_FILTER
SYSTEM SQL SYS_SAIMOD_SECURITY_USER_LOG
SYSTEM SQL SYS_SAIMOD_SECURITY_USER_LOG_COUNT
SYSTEM SQL SYS_SAIMOD_SECURITY_USER_RIGHTS
SYSTEM SQL SYS_SAIMOD_SECURITY_USER_RIGHT_CHECK
SYSTEM SQL SYS_SAIMOD_SECURITY_USER_RIGHT_DELETE
SYSTEM SQL SYS_SAIMOD_SECURITY_USER_RIGHT_INSERT
SYSTEM SQL SYS_SAIMOD_TEXT_COUNT
SYSTEM SQL SYS_SAIMOD_TEXT_COUNT_FILTER
SYSTEM SQL SYS_SAIMOD_TEXT_COUNT_NOTAG
SYSTEM SQL SYS_SAIMOD_TEXT_COUNT_NOTAG_FILTER
SYSTEM SQL SYS_SAIMOD_TEXT_COUNT_TAG
SYSTEM SQL SYS_SAIMOD_TEXT_COUNT_TAG_FILTER
SYSTEM SQL SYS_SAIMOD_TEXT_TAGS
SYSTEM SQL SYS_SAIMOD_TEXT_TEXT
SYSTEM SQL SYS_SAIMOD_TEXT_TEXT_FILTER
SYSTEM SQL SYS_SAIMOD_TEXT_TEXT_NOTAG
SYSTEM SQL SYS_SAIMOD_TEXT_TEXT_NOTAG_FILTER
SYSTEM SQL SYS_SAIMOD_TEXT_TEXT_TAG
SYSTEM SQL SYS_SAIMOD_TEXT_TEXT_TAG_FILTER
SYSTEM SQL SYS_SAIMOD_TODO_ASSIGN
SYSTEM SQL SYS_SAIMOD_TODO_ASSIGNEES
SYSTEM SQL SYS_SAIMOD_TODO_CLOSE
SYSTEM SQL SYS_SAIMOD_TODO_CLOSE_ALL
SYSTEM SQL SYS_SAIMOD_TODO_COUNT
SYSTEM SQL SYS_SAIMOD_TODO_COUNT_FREE
SYSTEM SQL SYS_SAIMOD_TODO_COUNT_MINE
SYSTEM SQL SYS_SAIMOD_TODO_COUNT_OTHERS
SYSTEM SQL SYS_SAIMOD_TODO_COUNT_TYPE
SYSTEM SQL SYS_SAIMOD_TODO_DEASSIGN
SYSTEM SQL SYS_SAIMOD_TODO_EDIT
SYSTEM SQL SYS_SAIMOD_TODO_EXCEPTION_INSERT
SYSTEM SQL SYS_SAIMOD_TODO_LIST
SYSTEM SQL SYS_SAIMOD_TODO_LIST_FREE
SYSTEM SQL SYS_SAIMOD_TODO_LIST_MINE
SYSTEM SQL SYS_SAIMOD_TODO_LIST_OTHERS
SYSTEM SQL SYS_SAIMOD_TODO_LIST_TYPE
SYSTEM SQL SYS_SAIMOD_TODO_OPEN
SYSTEM SQL SYS_SAIMOD_TODO_PRIORITY
SYSTEM SQL SYS_SAIMOD_TODO_STATS_ASSIGNED
SYSTEM SQL SYS_SAIMOD_TODO_STATS_CLOSED
SYSTEM SQL SYS_SAIMOD_TODO_STATS_COUNT_DOTO_GEN
SYSTEM SQL SYS_SAIMOD_TODO_STATS_COUNT_DOTO_REPORT
SYSTEM SQL SYS_SAIMOD_TODO_STATS_COUNT_DOTO_USER
SYSTEM SQL SYS_SAIMOD_TODO_STATS_COUNT_TODO_GEN
SYSTEM SQL SYS_SAIMOD_TODO_STATS_COUNT_TODO_NOT_ASSIGNED
SYSTEM SQL SYS_SAIMOD_TODO_STATS_COUNT_TODO_REPORT
SYSTEM SQL SYS_SAIMOD_TODO_STATS_COUNT_TODO_USER
SYSTEM SQL SYS_SAIMOD_TODO_STATS_USERS
SYSTEM SQL SYS_SAIMOD_TODO_TODO
SYSTEM SQL SYS_SECURITY_AVAILABLE
SYSTEM SQL SYS_SECURITY_AVAILABLE_EMAIL
SYSTEM SQL SYS_SECURITY_CHANGE_EMAIL
SYSTEM SQL SYS_SECURITY_CHECK
SYSTEM SQL SYS_SECURITY_CONFIRM_EMAIL
SYSTEM SQL SYS_SECURITY_CREATE
SYSTEM SQL SYS_SECURITY_LOGIN_MD5
SYSTEM SQL SYS_SECURITY_LOGIN_SHA1
SYSTEM SQL SYS_SECURITY_LOGIN_USER_SHA1
SYSTEM SQL SYS_SECURITY_RESET_PASSWORD
SYSTEM SQL SYS_SECURITY_UPDATE_LASTACTIVE
SYSTEM SQL SYS_SECURITY_UPDATE_PW
SYSTEM SQL SYS_SECURITY_USER_INFO
SYSTEM SQL SYS_SECURITY_USER_SESSIONID
SYSTEM SQL SYS_TEXT_DELETE
SYSTEM SQL SYS_TEXT_DELETE_TAGS
SYSTEM SQL SYS_TEXT_GET_ID
SYSTEM SQL SYS_TEXT_GET_ID_ADV
SYSTEM SQL SYS_TEXT_GET_ID_COUNT
SYSTEM SQL SYS_TEXT_GET_ID_TAGS
SYSTEM SQL SYS_TEXT_GET_LATEST
SYSTEM SQL SYS_TEXT_GET_TAG
SYSTEM SQL SYS_TEXT_GET_TAGS
SYSTEM SQL SYS_TEXT_GET_TAG_ADV
SYSTEM SQL SYS_TEXT_RENAME
SYSTEM SQL SYS_TEXT_RENAME_TAGS
SYSTEM SQL SYS_TEXT_SAVE
SYSTEM SQL SYS_TEXT_SAVE_TAG
SYSTEM SQL SYS_TEXT_SEARCH_TAG
SYSTEM SQL SYS_TOKEN_CONFIRM
SYSTEM SQL SYS_TOKEN_GET
SYSTEM SQL SYS_TOKEN_INSERT
SYSTEM SQL setup
SYSTEM SQL system_api
SYSTEM SQL system_cron
SYSTEM SQL system_log
SYSTEM SQL system_page
SYSTEM SQL system_text
SYSTEM SQL system_todo
SYSTEM SQL system_todo_assign
SYSTEM SQL system_user
SYSTEM SQL system_user_to_rights
SYSTEM TOKEN token
SYSTEM TOKEN token_change_email
SYSTEM TOKEN token_confirm_email
SYSTEM TOKEN token_handler
SYSTEM TOKEN token_reset_password
SYSTEM autoload
SYSTEM locale
SYSTEM system
SYSTEM time
TODO
WARNING
Clone
3
SYSTEM SQL system_api
Ulf Gebhardt edited this page 2024-11-21 02:50:59 +01:00
Table of Contents
SYSTEM\SQL\system_api
- Class name:system_api
- Namespace:SYSTEM\SQLConstants
###NAME_PGconst NAME_PG = 'system.api' ###NAME_MYSconst NAME_MYS = 'system_api' ###FIELD_IDconst FIELD_ID = 'ID' ###FIELD_GROUPconst FIELD_GROUP = 'group' ###FIELD_TYPEconst FIELD_TYPE = 'type' ###FIELD_PARENTIDconst FIELD_PARENTID = 'parentID' ###FIELD_PARENTVALUEconst FIELD_PARENTVALUE = 'parentValue' ###FIELD_NAMEconst FIELD_NAME = 'name' ###FIELD_VERIFYconst FIELD_VERIFY = 'verify' ###VALUE_TYPE_COMMANDconst VALUE_TYPE_COMMAND = 0 ###VALUE_TYPE_COMMAND_FLAGconst VALUE_TYPE_COMMAND_FLAG = 1 ###VALUE_TYPE_PARAMconst VALUE_TYPE_PARAM = 2 ###VALUE_TYPE_PARAM_OPTconst VALUE_TYPE_PARAM_OPT = 3 ###VALUE_TYPE_STATICconst VALUE_TYPE_STATIC = 4