fixed typo on doc siteOk, I'll get it started here.. We need a list anyway for the docs site (jot them down and I'll create a page - even if they are listed elsewhere, list them here and i'll document them)
Table Structure for <PREFIX>_system_settings: (in no particular order)
site_name, site_start, server_offset_time, server_protocol, manager_language, etomite_charset, error_page, site_status, site_unavailable_message, track_visitors, resolve_hostnames, top_howmany, default_template, publish_default, cache_default, search_default, friendly_urls, friendly_url_prefix, friendly_url_suffix, friendly_alias_urls, use_udperms, use_uvperms, access_denied_message, udperms_allowroot, use_captcha, captcha_words, signupemail_message, emailsender, emailsubject, number_of_logs, number_of_messages, show_doc_data_preview, use_editor, strict_editor, strip_base_href, cm_plugin, to_plugin, xp_Stylist, xp_Stylist_path, im_plugin, im_plugin_base_dir, im_plugin_base_url, fm_plugin, fm_plugin_base_url, fm_plugin_document_url, fm_path, fm_exclude, fm_upload_files, tiny_css_path, tiny_css_selectors, strip_image_paths, filemanager_path, upload_files, manager_layout, submit, settings_version, friendly_url_prefix, emailsubject
[(site_name)] Returns the Site Name
[(site_start)] Returns the Site Start ID (e.g. [~
[(site_start)]~] returns the friendly url href)
[(server_offset_time)][(server_protocol)][(manager_language)][(etomite_charset)][(error_page)] Returns the ID of the Error Page
[(site_status)] Returns 1 or 0, depending if the Site is Online or Offline
[(site_unavailable_message)][(track_visitors)][(resolve_hostnames)][(top_howmany)][(default_template)][(publish_default)][(cache_default)][(search_default)][(friendly_urls)][(friendly_url_prefix)][(friendly_url_suffix)][(friendly_alias_urls)][(use_udperms)][(use_uvperms)][(access_denied_message)][(udperms_allowroot)][(use_captcha)][(captcha_words)][(signupemail_message)][(emailsender)][(emailsubject)][(number_of_logs)][(number_of_messages)][(show_doc_data_preview)][(use_editor)][(strict_editor)][(strip_base_href)][(cm_plugin)][(to_plugin)][(xp_Stylist)][(xp_Stylist_path)][(im_plugin)][(im_plugin_base_dir)][(im_plugin_base_url)][(fm_plugin)][(fm_plugin_base_url)][(fm_plugin_document_url)][(fm_path)] [(fm_exclude)][(fm_upload_files)][(tiny_css_path)][(tiny_css_selectors)][(strip_image_paths)][(filemanager_path)][(upload_files)][(manager_layout)][(submit)][(settings_version)][(friendly_url_prefix)] Returns the Friendly URL prefix
[(emailsubject)] Returns the EMail Subject for Manager Login Details
[(www_base_path)] Returns the base path
MySQL: [^qt^], [^q^] request(s), PHP: [^p^], total: [^t^], document retrieved from [^s^]
Would Return something like this: MySQL: 0.0087 s, 2 request(s), PHP: 0.0371 s, total: 0.0458 s, document retrieved from database
[^q^] $queries run
[^qt^] $queryTime for page
[^p^] $phpTime taken
[^t^] $totalTime taken
[^s^] $source (ie database or cache)
Tabe Structure for <PREFIX>_site_content: (in no particular order)
contentType, pagetitle, longtitle, description, alias, published, pub_date, unpub_date, parent, isfolder, content, richtext, template, menuindex, searchable, cacheable, createdby, createdon, editedby, editedon, deleted, deletedon, deletedby, authenticate
[*id*] Returns the ID of the current page
[*longtitle*] Returns the long title of the current page
[*pagetitle*] Returns the page title of the current page
[*description*] Returns the description of the current page
[*content*] Returns the content of the current page
[*contentType*] Currently Document or Reference (web link), but could be expanded in future releases
[*alias*] The documents Alias name
[*published*] Whether the document is published or unpublished
[*pub_date*] A unix timestamp which determines when to publish a document when set
[*unpub_date*] A unix timestamp which determines when to unpublish a document when set
[*parent*] The current documents parent in the document tree
[*isfolder*] Whether this document is also a parent folder which can have child documents
[*richtext*] Whether or not to use a WYSIWYG editor for maintaining this document
[*template*] The page template to use when rendering this document
[*menuindex*] This index is used for ordering within the document tree as a sub-sort of the documents parent
[*searchable*] Whether this document should be included in site searches, based on snippet logic
[*cacheable*] Whether this document should be cached
[*createdby*] The internalKey id of the user who created this document
[*createdon*] Unix timestamp representing when this document was originally created
[*editedby*] The internalKey id of the user who last edited this document
[*editedon*] Unix timestamp representing when this document was last edited
[*deleted*] Whether this document is flagged to be purged from the database
[*deletedon*] Unix timestamp representing when this document was flagged as deleted
[*deletedby*] The internalKey id of the user who flagged as deleted
[*authenticate*] Whether or not user authentication of this document should be performed by the parser or via snippet logic
Some of the options provide either 1 or 0, which need to be interpreted by snippets to do what you need.
