Classes, interfaces and traits
DATA_DEFAULT¶
DATA_SYSTEM_TEXT Class provided by System to install the Page Defaults e.g meta tags to the Database(includes Tags)
« More »
DATA_SYSTEM_API¶
DATA_SYSTEM_API Class provided by System to install the System apis to the Database
« More »
DATA_SYSTEM_CRON¶
DATA_SYSTEM_CRON Class provided by System to install the System crons to the Database
« More »
DATA_SYSTEM_PAGE¶
DATA_SYSTEM_PAGE Class provided by System to install the System pages to the Database
« More »
DATA_SYSTEM_RIGHTS¶
DATA_SYSTEM_RIGHTS Class provided by System to install the System rights to the Database
« More »
DATA_SYSTEM_TEXT¶
DATA_SYSTEM_TEXT Class provided by System to install the System texts to the Database(includes Tags)
« More »
SCHEMA_SYSTEM¶
SCHEMA_SYSTEM Class provided by System to install the Database Schema for system
« More »
setup¶
Setup Class provided by System to execute QIs defining sql files to be setup on the database
« More »
SYS_API_TREE¶
QQ to get System Api Tree by group
« More »
SYS_CACHE_CHECK¶
QQ to check if cache entry exists
« More »
SYS_CACHE_DELETE¶
QQ to delete cache entry
« More »
SYS_CACHE_DELETE_ALL¶
QQ to delete all cache entries
« More »
SYS_CACHE_PUT¶
QQ to write data into the cache
« More »
SYS_CRON_GET¶
QQ to get a specific cron entry
« More »
SYS_CRON_LAST_VISIT¶
QQ to find the cronjob which had ben run the most reacent
« More »
SYS_CRON_LIST¶
QQ to get all Cronjobs from Database
« More »
SYS_CRON_UPD¶
QQ to update a cronjobs status and lastrun
« More »
SYS_LOCALE_SET_LOCALE¶
QQ to set a users language setting
« More »
SYS_LOG_DEL¶
QQ to delete a log entry by id
« More »
SYS_LOG_INSERT¶
QQ to insert a new log entry
« More »
SYS_LOG_MONTH¶
QQ to find all long entries for this month, limited by 10000
« More »
SYS_LOG_OLDEST¶
QQ to find the month of the oldest log entry
« More »
SYS_PAGE_GROUP¶
QQ to get all State Data for given group and statename
« More »
SYS_SAIMOD_API_ADD¶
QQ to add a system_api entry
« More »
SYS_SAIMOD_API_DEL¶
QQ to delete a system_api entry
« More »
SYS_SAIMOD_API_GET¶
QQ to get all system_api entrys
« More »
SYS_SAIMOD_API_GROUPS¶
QQ to get amount of api entrys of system_api by group
« More »
SYS_SAIMOD_API_SINGLE_SELECT¶
QQ to get a system_api entry
« More »
SYS_SAIMOD_CACHE¶
QQ to get all system_cache entrys
« More »
SYS_SAIMOD_CACHE_CLEAR¶
QQ to delete all system_cache entrys
« More »
SYS_SAIMOD_CACHE_COUNT¶
QQ to count all system_cache entrys
« More »
SYS_SAIMOD_CRON¶
QQ to get all system_cron entrys
« More »
SYS_SAIMOD_CRON_ADD¶
QQ to add a system_cron entry
« More »
SYS_SAIMOD_CRON_CHANGE¶
QQ to update a system_cron entry
« More »
SYS_SAIMOD_CRON_DEL¶
QQ to delete a system_cron entry
« More »
SYS_SAIMOD_CRON_SINGLE_SELECT¶
QQ to get a system_cron entry
« More »
SYS_SAIMOD_LOG_ANALYTICS¶
QQ to get analytics data from system_log
« More »
SYS_SAIMOD_LOG_BASIC_QUERYTIME¶
QQ to get analytics data from system_log - basic querytime
« More »
SYS_SAIMOD_LOG_BASIC_SUCCESS¶
QQ to get analytics data from system_log - basic success
« More »
SYS_SAIMOD_LOG_BASIC_VISITOR¶
QQ to get analytics data from system_log - basic visitor
« More »
SYS_SAIMOD_LOG_CLASS_BASIC¶
QQ to get analytics data from system_log - class basic
« More »
SYS_SAIMOD_LOG_CLASS_OTHER¶
QQ to get analytics data from system_log - class other
« More »
SYS_SAIMOD_LOG_CLASS_SYSTEM¶
QQ to get analytics data from system_log - class system
« More »
SYS_SAIMOD_LOG_ERROR¶
QQ to get data for a system_log entry
« More »
SYS_SAIMOD_LOG_FILTER¶
QQ to filter data from system_log
« More »
SYS_SAIMOD_LOG_FILTER_COUNT¶
QQ to count filtered data from system_log
« More »
SYS_SAIMOD_LOG_FILTERS¶
QQ to find all classfilters from system_log
« More »
SYS_SAIMOD_LOG_TRUNCATE¶
QQ to truncate data from system_log
« More »
SYS_SAIMOD_LOG_UNIQUE_BASIC¶
QQ to get analytics data from system_log - unique basic
« More »
SYS_SAIMOD_LOG_UNIQUE_EXCEPTION¶
QQ to get analytics data from system_log - unique exception
« More »
SYS_SAIMOD_LOG_UNIQUE_REFERER¶
QQ to get analytics data from system_log - unique referer
« More »
SYS_SAIMOD_LOG_UNIQUE_REQUEST¶
QQ to get analytics data from system_log - unique request
« More »
SYS_SAIMOD_PAGE_ADD¶
QQ to add a system_page entry
« More »
SYS_SAIMOD_PAGE_DEL¶
QQ to delete a system_page entry
« More »
SYS_SAIMOD_PAGE_GET¶
QQ to get all system_page entrys
« More »
SYS_SAIMOD_PAGE_GROUPS¶
QQ to count groups of all system_page entrys
« More »
SYS_SAIMOD_PAGE_SINGLE_SELECT¶
QQ to get a system_page entry
« More »
SYS_SAIMOD_SECURITY_DELETE_USER¶
QQ to delete a system_user entry
« More »
SYS_SAIMOD_SECURITY_DELETE_USER_RIGHTS¶
QQ to delete all system_user_to_rights entrys of a user
« More »
SYS_SAIMOD_SECURITY_RENAME_USER¶
QQ to rename a system_user entry
« More »
SYS_SAIMOD_SECURITY_RIGHT_CHECK¶
QQ to check the existance of a system_rights entry
« More »
SYS_SAIMOD_SECURITY_RIGHT_DELETE¶
QQ to delete a system_rights entry
« More »
SYS_SAIMOD_SECURITY_RIGHT_INSERT¶
QQ to cinsert a system_rights entry
« More »
SYS_SAIMOD_SECURITY_RIGHTS¶
QQ to get all system_rights entrys
« More »
SYS_SAIMOD_SECURITY_USER¶
QQ to get a system_user entry
« More »
SYS_SAIMOD_SECURITY_USER_COUNT¶
QQ to count all system_user entrys
« More »
SYS_SAIMOD_SECURITY_USER_COUNT_FILTER¶
QQ to get all system_user entrys with certain right
« More »
SYS_SAIMOD_SECURITY_USER_LOG¶
QQ to get all system_log entrys for a user
« More »
SYS_SAIMOD_SECURITY_USER_LOG_COUNT¶
QQ to count all system_log entrys of a user
« More »
SYS_SAIMOD_SECURITY_USER_RIGHT_CHECK¶
QQ to check a system_user_to_rights entry for existance
« More »
SYS_SAIMOD_SECURITY_USER_RIGHT_DELETE¶
QQ to delete a system_user_to_rights entry
« More »
SYS_SAIMOD_SECURITY_USER_RIGHT_INSERT¶
QQ to insert a system_user_to_rights entry
« More »
SYS_SAIMOD_SECURITY_USER_RIGHTS¶
QQ to get all system_rights entrys of a user
« More »
SYS_SAIMOD_SECURITY_USERS¶
QQ to get all system_user entrys with filter
« More »
SYS_SAIMOD_SECURITY_USERS_FILTER¶
QQ to get all system_user entrys with filter
« More »
SYS_SAIMOD_TEXT_COUNT¶
QQ to count all system_text entrys with filter
« More »
SYS_SAIMOD_TEXT_COUNT_FILTER¶
QQ to count all system_text entrys with filter and language
« More »
SYS_SAIMOD_TEXT_COUNT_NOTAG¶
QQ to count all system_text entrys with no tag
« More »
SYS_SAIMOD_TEXT_COUNT_NOTAG_FILTER¶
QQ to count all system_text entrys with no tag + filter
« More »
SYS_SAIMOD_TEXT_COUNT_TAG¶
QQ to count all system_text_tag entrys of a tag with filter
« More »
SYS_SAIMOD_TEXT_COUNT_TAG_FILTER¶
QQ to count all system_text_tag entrys of a tag with filter and language
« More »
SYS_SAIMOD_TEXT_TAGS¶
QQ to get all system_text_tag entrys
« More »
SYS_SAIMOD_TEXT_TEXT¶
QQ to get all system_text entry with filter
« More »
SYS_SAIMOD_TEXT_TEXT_FILTER¶
QQ to get all system_text entrys with filter by tag + language
« More »
SYS_SAIMOD_TEXT_TEXT_NOTAG¶
QQ to get all system_text entrys with filter and no tag
« More »
SYS_SAIMOD_TEXT_TEXT_NOTAG_FILTER¶
QQ to get all system_text entrys with filter + language and no tags
« More »
SYS_SAIMOD_TEXT_TEXT_TAG¶
QQ to get all system_text entry with filter and tag
« More »
SYS_SAIMOD_TEXT_TEXT_TAG_FILTER¶
QQ to get all system_text entrys with filter, language and tag
« More »
SYS_SAIMOD_TODO_ASSIGN¶
QQ to assgin a system_todo entry to a user
« More »
SYS_SAIMOD_TODO_ASSIGNEES¶
QQ to get all system_todo_assign entrys for a todo
« More »
SYS_SAIMOD_TODO_CLOSE¶
QQ to close a system_todo entry
« More »
SYS_SAIMOD_TODO_CLOSE_ALL¶
QQ to close all generated system_todo entrys
« More »
SYS_SAIMOD_TODO_COUNT¶
QQ to count all system_todo entrys with filter
« More »
SYS_SAIMOD_TODO_COUNT_FREE¶
QQ to count all free system_todo entrys
« More »
SYS_SAIMOD_TODO_COUNT_MINE¶
QQ to count all system_todo entrys of the user
« More »
SYS_SAIMOD_TODO_COUNT_OTHERS¶
QQ to count all system_todo entrys of other users
« More »
SYS_SAIMOD_TODO_COUNT_TYPE¶
QQ to count all system_todo entrys by type
« More »
SYS_SAIMOD_TODO_DEASSIGN¶
QQ to deassgin a system_todo entry from a user
« More »
SYS_SAIMOD_TODO_EDIT¶
QQ to update a system_todo entry
« More »
SYS_SAIMOD_TODO_EXCEPTION_INSERT¶
QQ to log a execption to system_todo
« More »
SYS_SAIMOD_TODO_LIST¶
QQ to get all system_todo entrys
« More »
SYS_SAIMOD_TODO_LIST_FREE¶
QQ to get all free system_todo entrys
« More »
SYS_SAIMOD_TODO_LIST_MINE¶
QQ to get all system_todo entrys of the user
« More »
SYS_SAIMOD_TODO_LIST_OTHERS¶
QQ to get all system_todo entrys of other users
« More »
SYS_SAIMOD_TODO_LIST_TYPE¶
QQ to get all system_todo entrys by type
« More »
SYS_SAIMOD_TODO_OPEN¶
QQ to open a system_todo entry
« More »
SYS_SAIMOD_TODO_PRIORITY¶
QQ to set the priority of a system_todo entry
« More »
SYS_SAIMOD_TODO_STATS_ASSIGNED¶
QQ to get analytics of all assigned system_todo entrys
« More »
SYS_SAIMOD_TODO_STATS_CLOSED¶
QQ to get analytics of all closed system_todo entrys
« More »
SYS_SAIMOD_TODO_STATS_COUNT_DOTO_GEN¶
QQ to get count of all closed generated system_todo entrys
« More »
SYS_SAIMOD_TODO_STATS_COUNT_DOTO_REPORT¶
QQ to get count of all closed report system_todo entrys
« More »
SYS_SAIMOD_TODO_STATS_COUNT_DOTO_USER¶
QQ to get count of all closed user system_todo entrys
« More »
SYS_SAIMOD_TODO_STATS_COUNT_TODO_GEN¶
QQ to get count of all open generated system_todo entrys
« More »
SYS_SAIMOD_TODO_STATS_COUNT_TODO_NOT_ASSIGNED¶
QQ to get count of all open not assigned system_todo entrys
« More »
SYS_SAIMOD_TODO_STATS_COUNT_TODO_REPORT¶
QQ to get count of all open report system_todo entrys
« More »
SYS_SAIMOD_TODO_STATS_COUNT_TODO_USER¶
QQ to get count of all open user system_todo entrys
« More »
SYS_SAIMOD_TODO_STATS_USERS¶
QQ to get analytics of users system_todo entrys
« More »
SYS_SAIMOD_TODO_TODO¶
QQ to get all system_todo entrys
« More »
SYS_SECURITY_AVAILABLE¶
QQ to check for usernames availibility
« More »
SYS_SECURITY_AVAILABLE_EMAIL¶
QQ to check for username || email combination availibility
« More »
SYS_SECURITY_CHANGE_EMAIL¶
QQ to get change Email of an account
« More »
SYS_SECURITY_CHECK¶
QQ to check for users rights
« More »
SYS_SECURITY_CONFIRM_EMAIL¶
QQ to get confirm Email of an account
« More »
SYS_SECURITY_CREATE¶
QQ to create a new user
« More »
SYS_SECURITY_LOGIN_USER_SHA1¶
QQ to check for emails creadentials (login)
« More »
SYS_SECURITY_RESET_PASSWORD¶
QQ to reset Password of an account
« More »
SYS_SECURITY_UPDATE_LASTACTIVE¶
QQ to update users last active timestamp
« More »
SYS_SECURITY_UPDATE_PW¶
QQ to change a user password
« More »
SYS_SECURITY_USER_INFO¶
QQ to get a usernames infos
« More »
SYS_SECURITY_USER_SESSIONID¶
QQ to reset Password of an account
« More »
SYS_TEXT_DELETE¶
QQ to delete a text by id and language
« More »
SYS_TEXT_DELETE_TAGS¶
QQ to delete tags of a certain text
« More »
SYS_TEXT_GET_ID¶
QQ to get a text by id and language
« More »
SYS_TEXT_GET_ID_ADV¶
QQ to get advanced result for a text by id and language
« More »
SYS_TEXT_GET_ID_COUNT¶
QQ to get amount of texts by id
« More »
SYS_TEXT_GET_ID_TAGS¶
QQ to get tags of text by id
« More »
SYS_TEXT_GET_LATEST¶
QQ to get latest texts by tag and limit
« More »
SYS_TEXT_GET_TAG¶
QQ to get texts by tag and language
« More »
SYS_TEXT_GET_TAG_ADV¶
QQ to get text and tags including usernames by tag and language
« More »
SYS_TEXT_GET_TAGS¶
QQ to get tags by textid and limit
« More »
SYS_TEXT_RENAME¶
QQ to rename a text
« More »
SYS_TEXT_RENAME_TAGS¶
QQ to rename tags-text-id of a text
« More »
SYS_TEXT_SAVE¶
QQ to save a text
« More »
SYS_TEXT_SAVE_TAG¶
QQ to save a tag for a text
« More »
SYS_TEXT_SEARCH_TAG¶
QQ to search for texts with tag and given searchstring
« More »
SYS_TOKEN_CONFIRM¶
QQ to confirm a token and make it invalid
« More »
SYS_TOKEN_INSERT¶
QQ to insert a token
« More »
system_api¶
system_api Class provided by System to describe system_api table
« More »
system_cron¶
system_cron Class provided by System to describe system_cron table
« More »
system_log¶
system_log Class provided by System to describe system_log table
« More »
system_page¶
system_page Class provided by System to describe system_page table
« More »
system_text¶
system_text Class provided by System to describe system_text table
« More »
system_todo¶
system_todo Class provided by System to describe system_todo table
« More »
system_todo_assign¶
system_todo_assign Class provided by System to describe system_todo_assign table
« More »
system_user¶
system_user Class provided by System to describe system_user table
« More »
system_user_to_rights¶
system_user_to_rights Class provided by System to describe system_user_to_rights table
« More »