php

File Content: `baker.sql`

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `baker2139r24`
--

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]addons`
--

CREATE TABLE `[[dbprefix]]addons` (
  `addon_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `directory` varchar(140) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `function` varchar(96) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `version` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `platform` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `license` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`addon_id`),
  UNIQUE KEY `ident_addons` USING BTREE (`function`,`directory`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=38 ;

--
-- Dumping data for table `[[dbprefix]]addons`
--

INSERT INTO `[[dbprefix]]addons` VALUES
(1, 'language', 'BG', 'Български', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(2, 'language', 'CA', 'Català', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(3, 'language', 'CS', 'Čeština', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(4, 'language', 'DA', 'Dansk', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(5, 'language', 'DE', 'Deutsch', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(6, 'language', 'EN', 'English', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(7, 'language', 'ES', 'Español', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(8, 'language', 'ET', 'Eesti', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(9, 'language', 'FI', 'Suomi', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(10, 'language', 'FR', 'Français', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(11, 'language', 'HR', 'Hrvatski', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(12, 'language', 'HU', 'Magyar', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(13, 'language', 'IT', 'Italiano', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(14, 'language', 'LV', 'Latviešu', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(15, 'language', 'NL', 'Nederlands', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(16, 'language', 'NO', 'Norsk', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(17, 'language', 'PL', 'Polski', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(18, 'language', 'PT', 'Português', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(19, 'language', 'RU', 'Русский', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(20, 'language', 'SE', 'Svenska', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(21, 'language', 'SK', 'Slovenčina', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(22, 'language', 'TR', 'Türkçe', '', '', '4.0.3', '2.11.0', 'Jacobi22', 'GNU General Public License'),
(23, 'module', 'WBLingual', 'WebsiteBaker Lingual v2.0.9', 'This snippet switches between different languages', 'snippet', '2.0.9', '2.13.0', 'Luisehahne', 'GNU General Public License'),
(24, 'module', 'captcha_control', 'Captcha Spam-Protect v2.2.3', 'Admin-Tool to control CAPTCHA and ASP', 'tool', '2.2.3', '2.13.0', 'Thomas Hornik (thorn),Luisehahne', 'GNU General Public License'),
(25, 'module', 'ckeditor', 'CKEditor v4.22.1.3', 'includes CKEditor 4.22.1 Standard, CKE allows editing content and can be integrated in frontend and backend modules.', 'wysiwyg', '4.22.1.3', '2.13.0', 'Michael Tenschert, Dietrich Roland Pehlke, erpe, WebBird, Marmot, Luisehahne', '<a href="https://www.gnu.org/licenses/lgpl.html">LGPL</a>'),
(26, 'module', 'code', 'Code v3.1.0', 'This module allows you to execute PHP commands (limit access to users you trust!!)', 'page', '3.1.0', '2.13.0', 'Ryan Djurovich', 'GNU General Public License'),
(27, 'module', 'droplets', 'Droplets v3.4.4', 'This tool allows you to manage your local Droplets.', 'tool', '3.4.4', '2.13.0', 'Ruud and pcwacht, Luisehahne', 'GNU General Public License'),
(28, 'module', 'form', 'Form Modul v3.5.1', 'This module allows you to create customised online forms, such as a feedback form. Thank-you to Rudolph Lartey who help enhance this module, providing code for extra field types, etc.', 'page', '3.5.1 ', '2.13.0', 'Ryan Djurovich & Rudolph Lartey - additions John Maats - PCWacht, dev-team', 'GNU General Public License'),
(29, 'module', 'jsadmin', 'Javascript Admin v2.1.4', 'This module adds Javascript functionality to the Website Baker Admin to improve some of the UI interactions. Uses the YahooUI library.', 'tool', '2.1.4', '2.13.0', 'Stepan Riha, Swen Uth', 'BSD License'),
(30, 'module', 'menu_link', 'Menu Link v3.0.4', 'This module allows you to insert a link into the menu.', 'page', '3.0.4', '2.13.0', 'Ryan Djurovich, thorn, Luisehahne', 'GNU General Public License'),
(31, 'module', 'news', 'News v4.1.3', 'This page type is designed for making a news page.', 'page', '4.1.3', '2.13.0', 'Ryan Djurovich, Rob Smith, Werner v.d.Decken', 'GNU General Public License'),
(32, 'module', 'output_filter', 'Output Filter Frontend v1.4.4', 'This Add-On allows to filter the output directly before it is sent to the browser. Each individual filter can be activated/deactivated by the ACP.', 'tool', '1.4.4', '2.13.0', 'Christian Sommer(doc), Manuela v.d. Decken(DarkViper), Dietmar Wöllbrink(Luisehahne)', 'GNU General Public License'),
(33, 'module', 'show_menu2', 'show_menu2 v4.10.2', 'A code snippet for the Website Baker CMS providing a complete replacement for the built-in menu functions. See <a href="http://code.jellycan.com/show_menu2/" >http://code.jellycan.com/show_menu2/</a> for details or view the <a href="[[softurl]]/modules/show_menu2/README.en.txt" >readme</a> file.', 'snippet', '4.10.2', '2.11.0', 'Brodie Thiesfield', 'GNU General Public License'),
(34, 'module', 'wrapper', 'Wrapper v3.2.2', 'This module allows you to show third party sites inside an inline frame', 'page', '3.2.2', '2.13.0', 'DarkViper, Luisehahne', 'GNU General Public License'),
(35, 'module', 'wysiwyg', 'WYSIWYG v3.1.2', 'This module allows you to edit the contents of a page using a graphical editor', 'page', '3.1.2', '2.13.0', 'Ryan Djurovich', 'GNU General Public License'),
(36, 'template', 'DefaultTemplate', 'WebsiteBaker Default Template v1.2.3', 'Default template for Website Baker. This template is designed with one goal in mind: to completely control layout with CSS', 'template', '1.2.3', '2.13.0', 'WebsiteBaker Project', '<a href="https://www.gnu.org/licenses/gpl.html">GNU General Public License</a>'),
(37, 'template', 'DefaultTheme', 'WebsiteBaker Default Theme v1.5.2', 'Default desktop backend theme for WebsiteBaker 2.13.x', 'theme', '1.5.2', '2.13.3', 'Johannes Tassilo Gruber, WebsiteBaker Project', '<a href="https://www.gnu.org/licenses/gpl.html">GNU General Public License</a>');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]groups`
--

CREATE TABLE `[[dbprefix]]groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `system_permissions` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `module_permissions` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `template_permissions` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`group_id`),
  UNIQUE KEY `ident_groups` USING BTREE (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]groups`
--

INSERT INTO `[[dbprefix]]groups` VALUES
(1, 'Administrators', 'access,addons,admin,admin_basic,admin_advanced,admintools,admintools_view,admintools_advanced,groups,groups_view,groups_add,groups_delete,groups_modify,languages,languages_view,languages_install,languages_uninstall,media,media_view,media_create,media_delete,media_rename,media_upload,media_settings,modules,modules_view,modules_advanced,modules_install,modules_uninstall,modules_settings,pages,pages_view,pages_add,pages_add_l0,pages_delete,pages_intro,pages_modify,pages_settings,preferences,preferences_view,settings,settings_view,settings_basic,settings_advanced,templates,templates_view,templates_install,templates_uninstall,users,users_view,users_add,users_delete,users_modify', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_captcha_control`
--

CREATE TABLE `[[dbprefix]]mod_captcha_control` (
  `captcha_type` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'calc_text',
  `enabled_captcha` int(11) NOT NULL DEFAULT '0',
  `enabled_asp` int(11) NOT NULL DEFAULT '1',
  `asp_session_min_age` int(11) NOT NULL DEFAULT '20',
  `asp_view_min_age` int(11) NOT NULL DEFAULT '10',
  `asp_input_min_age` int(11) NOT NULL DEFAULT '5',
  `ct_text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ct_color` int(11) NOT NULL DEFAULT '1',
  `use_sec_type` int(11) NOT NULL DEFAULT '-1',
  `code_length` int(11) NOT NULL DEFAULT '6',
  `image_width` int(11) NOT NULL DEFAULT '225',
  `image_height` int(11) NOT NULL DEFAULT '85',
  `num_lines` int(11) NOT NULL DEFAULT '3',
  `noise_level` int(11) NOT NULL DEFAULT '5',
  `captcha_expiration` int(11) NOT NULL DEFAULT '1440',
  `image_bg_dir` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'backgrounds/',
  `image_bg_color` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'F2F2F2',
  `ttf_file` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fonts/LLBi_cond.ttf',
  `text_color` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '7D7D7D',
  `line_color` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '7D7D7D',
  `noise_color` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '7D7D7D',
  `signature_color` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '777777',
  `image_signature` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `[[dbprefix]]mod_captcha_control`
--

INSERT INTO `[[dbprefix]]mod_captcha_control` VALUES
('calc_image', 0, 1, 20, 10, 5, '', 1, -1, 6, 225, 85, 3, 5, 1440, 'backgrounds/', 'F2F2F2', 'fonts/LLBi_cond.ttf', '7D7D7D', '7D7D7D', '7D7D7D', '777777', '');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_code`
--

CREATE TABLE `[[dbprefix]]mod_code` (
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_droplets`
--

CREATE TABLE `[[dbprefix]]mod_droplets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `modified_when` int(11) NOT NULL DEFAULT '0',
  `modified_by` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '0',
  `admin_edit` int(11) NOT NULL DEFAULT '0',
  `admin_view` int(11) NOT NULL DEFAULT '0',
  `show_wysiwyg` int(11) NOT NULL DEFAULT '0',
  `comments` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `droplet_name` USING BTREE (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=26 ;

--
-- Dumping data for table `[[dbprefix]]mod_droplets`
--

INSERT INTO `[[dbprefix]]mod_droplets` VALUES
(1, 'EmailFilter', '\nreturn true;\n', 'Emailfiltering on your output - dummy Droplet', [[timestamp]], 1, 1, 0, 0, 0, 'usage:  [[EmailFilter]]\n'),
(2, 'iEditThisPage', '\n//global $wb;\n$oReg     = \\bin\\WbAdaptor::getInstance();\n$database = $oReg->getDatabase();\n$oDb      = $database;\n$oTrans   = $oReg->getTranslate();\n$oApp     = $oReg->getApplication();\n$returnvalue = '''';\nif ($oApp->is_authenticated()) {\n    $is_admin = false;\n    $page_id = ((PAGE_ID == 0) ? $oApp->default_page_id : PAGE_ID);\n    $user_id = $oApp->getUserId();\n    $sql = ''SELECT `admin_users`, `admin_groups` ''\n    . ''FROM `''.$oReg->TablePrefix.''pages` ''\n    . ''WHERE `page_id` = ''.$page_id;\n    if (($rset = $oDb->query($sql)) != null) {\n        if (($rec = $rset->fetchRow(\\MYSQLI_ASSOC)) != null) {\n            $is_admin = ($oApp->ami_group_member($rec[''admin_groups'']) ||\n            ($oApp->is_group_match($user_id, $rec[''admin_users''])) );\n        }\n    }\n    if ($is_admin) {\n        $tpl  = ''<a href="''.$oReg->AcpUrl.''/pages/%1$s.php?page_id=''.$page_id.''"  title="%2$s">''\n        . ''<img src="''.$oReg->ThemeUrl.''/images/%3$s_16.png" alt="%2$s" style="margin: 0 0.325em;"></a>'';\n        $show = ((!isset($show) || $show == '''') ? 7 : (int)$show);\n        $show = ($show > 7 ? 7 : (int)$show);\n        $show = ($show < 2 ? 1 : (int)$show );\n        if ($show & 1) {\n            $returnvalue .= sprintf($tpl, ''modify'', $oTrans->HEADING_MODIFY_PAGE, ''modify'');\n        }\n        $sys_perm = $oApp->get_session(''SYSTEM_PERMISSIONS'');\n        if (@is_array($sys_perm)) {\n            if (($show & 2) && (array_search(''pages_settings'', $sys_perm)!==false)) {\n                $returnvalue .= sprintf($tpl, ''settings'', $oTrans->HEADING_MODIFY_PAGE_SETTINGS, ''edit'');\n            }\n            if (($show & 4) && (array_search(''pages_modify'', $sys_perm)!==false)) {\n                $returnvalue .= sprintf($tpl, ''sections'', $oTrans->HEADING_MANAGE_SECTIONS, ''sections'');\n            }\n        }\n        if ($returnvalue != '''') {\n            $returnvalue  = ''<div class="iEditThisPage">''.$returnvalue.''</div>'';\n        }\n    }\n}\nreturn(($returnvalue == '''') ? true : $returnvalue);\n', 'Puts Edit-Buttons on every page you have rights for. 1=modify page, 2=modify pagesettings, 4=modify sections, or add values to combine buttons.', [[timestamp]], 1, 1, 0, 0, 0, 'Use: [[iEditThisPage?show=7]].\n1=modify page, 2=modify pagesettings, 4=modify sections, or add values to combine buttons.\nYou can format the appearance using CSS-class ''div.iEditThisPage'' in your basic-css file\n@author: Manuela von der Decken\n@changed 2022-04-09\n'),
(3, 'iPageIcon', '\n// @author: Manuela von der Decken, Dietmar Wöllbrink\n// @param int $type: 0=page_icon(default) | 1=menu_icon_0 | 2=menu_icon_1\n// @param string $icon: name of a default image placed in WB_PATH/TEMPLATE/\n// @return: a valid image-URL or empty string\n//\n$oReg    = \\bin\\WbAdaptor::getInstance();\n$database = $oReg->getDatabase();\n$oDb     = $database;\n$oTrans  = $oReg->getTranslate();\n$oApp    = $oReg->getApplication();\n$type = (!isset($type) ? 0 : (intval($type) % 3));\n$icontypes = [\n    0 => ''page_icon'',\n    1 => ''menu_icon_0'',\n    2 => ''menu_icon_1''\n    ];\n$icon_url = '''';\nif (isset($icon) && is_readable($oReg->AppPath.''/templates/''.$oReg->Template.''/''.$icon)) {\n    $icon_url = $oReg->AppUrl.''/templates/''.$oReg->Template.''/''.$icon;\n}\n$tmp_trail = array_reverse($oApp->page_trail);\nforeach ($tmp_trail as $pid) {\n    $sql = ''SELECT `''.$icontypes[$type].''` '';\n    $sql .= ''FROM `''.$oReg->TablePrefix.''pages` '';\n    $sql .= ''WHERE `page_id`=''.(int)$pid;\n    if (($icon = $oDb->get_one($sql)) != false) {\n        $icon = ltrim(str_replace(''\\\\'', ''/'', $icon), ''/'');\n        if (is_file($oReg->AppPath.''/''.$icon)) {\n            $icon_url = $oReg->AppUrl.''/''.$icon;\n            break;\n        }\n    }\n}\nreturn $icon_url;\n', 'search for an image in current page. If no image is present, the image of the parent page is inherited.', [[timestamp]], 1, 1, 0, 0, 0, 'Use: [[iPageIcon?type=1]]\nDisplay the page-icon(0)(default) or menu_icon_0(1) or menu_icon_1(2) if found\n'),
(4, 'iSectionPicker', '\n/*\n * Copyright (C) 2020 Manuela von der Decken <manuela@isteam.de>\n *\n * DO NOT ALTER OR REMOVE COPYRIGHT OR THIS HEADER\n *\n * This program is distributed in the hope that it will be useful,\n * but WITHOUT ANY WARRANTY; without even the implied warranty of\n * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the\n * GNU General Public License 2 for more details.\n *\n * You should have received a copy of the GNU General Public License 2\n * along with this program.  If not, see <https://www.gnu.org/licenses/>.\n */\n/**\n * iSectionPicker\n *\n * @category     Addon\n * @package      Droplet\n * @copyright    Manuela von der Decken <manuela@isteam.de>\n * @author       Manuela von der Decken <manuela@isteam.de>\n * @author       dietmarWöllbrink <dietmar.woellbrink@websitebaker.org>\n * @license      GNU General Public License 2\n * @version      0.0.1 $Rev: 4 $\n * @revision     $Id: iSectionPicker.php 4 2025-08-08 07:53:04Z Uwe $\n * @since        File available since 07.03.2020\n * @deprecated   no / since 0000/00/00\n * @description  xxx\n */\n// import global objects\n    $oReg      = \\bin\\WbAdaptor::getInstance();\n    $oApp = $wb = ($oReg->getApplication() ?? $GLOBALS[''wb'']);\n    $oDb       = $database = $oReg->getDatabase();\n    $sContent  = '''';\n// sanitize argument $sid\n    $iSectionId = \\intval($sid ?? 0);\n// try to load the section and the corresponding page\n    $sql = ''SELECT `s`.*, ''\n//         .        ''`p`.`viewing_groups`, ''\n         .        ''`p`.`visibility`, ''\n         .        ''`p`.`link`, ''\n         .        ''`p`.`page_title`, ''\n         .        ''`p`.`menu_title` ''\n         . ''FROM `''.$oDb->TablePrefix.''sections` `s` ''\n         . ''INNER JOIN `''.$oDb->TablePrefix.''pages` `p` ''\n         .    ''ON `p`.`page_id`=`s`.`page_id` ''\n         . ''WHERE `s`.`section_id` = ''.$iSectionId.'' ''\n         .   ''AND (''.\\time().'' BETWEEN `s`.`publ_start` AND `s`.`publ_end`) ''\n         .   ''AND `active` = 1 ''\n         .   ''AND `p`.`visibility` NOT IN (\\''deleted\\'',\\''none\\'')'';\n    try {\n        $oResultSet = $oDb->query($sql);\n        if (($aRecord = $oResultSet->fetchRow(\\MYSQLI_ASSOC))) {\n            unset($sql);\n// if matching record found\n            $module = $sModuleName = $aRecord[''module''];\n            $section_id  = $aRecord[''section_id''];\n            $page_id     = $aRecord[''page_id''];\n            if (!$oApp->isPageVisible($page_id)) {\n                throw new \\InvalidArgumentException(''no valid visibility'');\n            }\n// include the buffered view.php of the needed module\n            $sFrontendViewFile = $oReg->AppPath.''modules/''.$sModuleName.''/view.php'';\n            if (\\is_readable($sFrontendViewFile)){\n                \\ob_start();\n                require $sFrontendViewFile;\n                $sContent = \\ob_get_clean();\n            } else {\n                throw new \\InvalidArgumentException(\\sprintf(''%s/view.php not found/readable'',$sModuleName));\n            }\n// define path and url to frontend.*\n            $sFrontendPath = $oReg->AppPath.''modules/''.$sModuleName.''/frontend'';\n            $sFrontendUrl  = $oReg->AppUrl.''modules/''.$sModuleName.''/frontend'';\n//check out if conternt already contains a link to frontend.css\n            $sFrontendCss = '''';\n            $sPattern = ''/<link[^>]*?src\\s*=\\s*\\"''.\\preg_quote($sFrontendUrl, ''/'').''css\\".*?\\/>/si'';\n            if (!\\preg_match($sPattern, $sContent)) {\n// if not, then try to find and include frontend.css\n                if (\\is_readable($sFrontendPath.''.css'')) {\n                    $sFrontendCss = ''\n                    <script>\n                        try {\n                            var ModuleCss = "''.$sFrontendUrl.''.css";\n                            var UserCss   = "''.$sFrontendUrl.''User.css";\n                            if (typeof LoadOnFly === "undefined") {\n                                include_file(ModuleCss, "css");\n                                include_file(UserCss, "css");\n                            } else {\n                                LoadOnFly("head", ModuleCss);\n                                LoadOnFly("head", UserCss);\n                            }\n                        } catch(e) {\n                            /* alert("an error has occured: "+e.message) */\n                        }\n                    </script>\n                    '';\n                }\n            }\n//check out if conternt already contains a <script link> to frontend.js\n            $sFrontendJs = '''';\n            $sPattern = ''/<script[^>]*?src\\s*=\\s*\\"''.\\preg_quote($sFrontendUrl, ''/'').''js\\".*?\\/>/si'';\n            if (!\\preg_match($sPattern, $sContent)) {\n// if not, then try to find and include frontend.css\n                if (\\is_readable($sFrontendPath.''js'')) {\n                    $sFrontendJs = ''\n                    <script>\n                        try {\n                            var ModuleJs = "''.$sFrontendUrl.''js";\n                            include_file(ModuleJs, "js");\n                        } catch(e) {\n                            /* alert("an error has occured: "+e.message) */\n                        }\n                    </script>\n                    '';\n                }\n            }\n            $sContent = $sFrontendCss.$sFrontendJs.$sContent;\n        }//end pageisvisible\n    } catch (\\Throwable $ex) {\n        /* place to insert different error/logfile messages */\n        $sErrMessage = ''[''.\\basename(__FILE__, ''.php'').'' :: ''.$ex->getMessage().'']'';\n        $sContent =  (($oReg->Debug ?? false) ? $sErrMessage : true);\n    }\n    return (empty($sContent) ? ''page not visible, no content found'' : $sContent);\n', 'Load the view.php from any other section-module', [[timestamp]], 1, 1, 0, 0, 0, 'Use [[iSectionPicker?sid=123]]\n'),
(5, 'LastModifiedPages', '\n    $oReg = \\bin\\WbAdaptor::getInstance();\n    $oTrans = $oReg->getTranslate();\n    $oApp   = $oReg->getApplication();\n    $iMax = (int)($max ?? 1);\n    $sRetval = nl2br(sprintf($oTrans->TEXT_MODIFIED_PAGE,$iMax));\n    if ($iMax > 1){\n        $sRetval = nl2br(sprintf($oTrans->TEXT_MODIFIED_PAGES,$iMax));\n    }\n    $iNow = time();\n    $sSql = ''\n      SELECT\n      `p`.`page_title`,`p`.`modified_when`,`p`.`modified_by`,`p`.`link`\n      ,`p`.`page_id` ,UNIX_TIMESTAMP() `time_now`,`u`.`display_name`\n      FROM `''.$oReg->TablePrefix.''pages` `p`\n      INNER JOIN `''.$oReg->TablePrefix.''users` `u`\n      ON `u`.`user_id` = `p`.`modified_by`\n      HAVING `p`.`modified_when`<= `time_now`\n      ORDER BY `p`.`modified_when` DESC\n    '';\n    $i = 0;\n    if ($oPages = $oReg->Db->query($sSql)){}\n        while (($aPages=$oPages->fetchRow(MYSQLI_ASSOC))){\n            $sLink = ''<b><i>''.$aPages[''page_title''].''</b></i>'';\n            if ($oApp->page_id != $aPages[''page_id'']) {\n                $sLink = ''<a href="''.$oReg->AppUrl.ltrim($oReg->PagesDir,''/'').$aPages[''link''].$oReg->PageExtension.''">''.$aPages[''page_title''].''</a>'';\n            }\n            $date = \\bin\\helpers\\PreCheck::dateFormatToStrftime($oReg->DateFormat,$aPages[''modified_when'']);\n            $time = \\bin\\helpers\\PreCheck::dateFormatToStrftime($oReg->TimeFormat,$aPages[''modified_when'']);\n            $sRetval .=  nl2br(sprintf(" %s %s %s \\n",$sLink,$date, "".$time));\n            $i++;\n            if ($i  >= $iMax ){break;}\n        }\n    return (empty($sRetval) ? nl2br(sprintf($oTrans->NO_MODIFIED_PAGES)) : $sRetval);\n', 'Displays the last modification time of pages', [[timestamp]], 1, 1, 0, 0, 0, 'Use [[LastModifiedPages?max=5]]\n'),
(6, 'LoginBox', '\n//global $wb;\n$oReg = \\bin\\WbAdaptor::getInstance();\n$database = $oReg->getDatabase();\n$oLang = $oReg->getTranslate();\n$oRequest = $oReg->getRequester();\n$oApp  = $oReg->getApplication();\n$oLang->enableAddon(''templates/''.TEMPLATE);\n$return_value = ''<div class="login-box">''.PHP_EOL;\n$return_admin = '' '';\n// Return a system permission\n$get_permission = function ($name, $type = ''system'')use ($oApp)\n{\n    // Append to permission type\n    $type .= ''_permissions'';\n    // Check if we have a section to check for\n    if ($name == ''start'') {\n        return true;\n    } else {\n        // Set system permissions var\n        $system_permissions = $oApp->get_session(''SYSTEM_PERMISSIONS'');\n        // Set module permissions var\n        $module_permissions = $oApp->get_session(''MODULE_PERMISSIONS'');\n        // Set template permissions var\n        $template_permissions = $oApp->get_session(''TEMPLATE_PERMISSIONS'');\n        // Return true if system perm = 1\n        if (isset($$type) && is_array($$type) && is_numeric(array_search($name, $$type))) {\n            if ($type == ''system_permissions'') {\n                return true;\n            } else {\n                return false;\n            }\n        } else {\n            if ($type == ''system_permissions'') {\n                return false;\n            } else {\n                return true;\n            }\n        }\n    }\n}\n;\n$get_page_permission = function ($page, $action = ''admin'')use ($database, $oApp)\n{\n    if ($action != ''viewing'') {$action = ''admin'';}\n    $action_groups = $action.''_groups'';\n    $action_users  = $action.''_users'';\n    if (is_array($page)) {\n        $groups = $page[$action_groups];\n        $users = $page[$action_users];\n    } else {\n        $sql = ''SELECT ''.$action_groups.'',''.$action_users.'' FROM `''.TABLE_PREFIX.''pages` ''.''WHERE `page_id` = ''.(int)$page.'' '';\n        if ($oResults = $database->query($sql)) {\n            $aResult  = $oResults->fetchRow(\\MYSQLI_ASSOC);\n            $groups   = explode('','', str_replace(''_'', '''', $aResult[$action_groups]));\n            $users    = explode('','', str_replace(''_'', '''', $aResult[$action_users]));\n        }\n    }\n    $in_group = false;\n    foreach ($oApp->get_groups_id() as $cur_gid) {\n        if (in_array($cur_gid, $groups)) {\n            $in_group = true;\n        }\n    }\n    if (!$in_group && !is_numeric(array_search($oApp->getUserId(), $users))) {\n        return false;\n    }\n    return true;\n}\n;\n// Get redirect\n$redirect_url = ((isset($_SESSION[''HTTP_REFERER'']) && $_SESSION[''HTTP_REFERER''] != '''') ? $_SESSION[''HTTP_REFERER''] : WB_URL);\n$redirect_url = (isset($redirect) && ($redirect != '''') ? $redirect : $redirect_url);\nif ((FRONTEND_LOGIN == ''enabled'') && (defined(''VISIBILITY'') && (VISIBILITY != ''private'')) && ($oApp->get_session(''USER_ID'') == '''')) {\n    $return_value .= ''<form action="''.LOGIN_URL.''" method="post" class="login-table">''.PHP_EOL;\n    $return_value .=     ''<input type="hidden" name="redirect" value="''.$redirect_url.''">''.PHP_EOL;\n    $return_value .=     ''<input type="hidden" name="page_id" value="''.$oApp->page_id.''">''.PHP_EOL;\n    $return_value .=     ''<fieldset>''.PHP_EOL;\n    $return_value .=         ''<h3>''.$oLang->TEXT_LOGIN.''</h3>''.PHP_EOL;\n    $return_value .=         ''<label for="username">''.$oLang->TEXT_USERNAME.'':</label>''.PHP_EOL;\n    $return_value .=         ''<p><input type="text" name="username" id="username" ></p>''.PHP_EOL;\n    $return_value .=         ''<label for="password">''.$oLang->TEXT_PASSWORD.'':</label>''.PHP_EOL;\n    $return_value .=         ''<p><input class="input form-control password-field-dr" type="password" name="password" autocomplete="off"/><span toggle=".password-field-dr" class="fa fa-fw fa-eye-slash field-icon toggle-password"></span></p>''.PHP_EOL;\n    $return_value .=         ''<p><input type="submit" id="submit" value="''.$oLang->TEXT_LOGIN.''" class="dbutton"></p>''.PHP_EOL;\n    $return_value .=         ''<ul class="login-advance">''.PHP_EOL;\n    $return_value .=             ''<li class="forgot"><a href="''.FORGOT_URL.''"><span>''.$oLang->TEXT_FORGOT_DETAILS.''</span></a></li>''.PHP_EOL;\n    if (intval(FRONTEND_SIGNUP) > 0) {\n        $return_value .=         ''<li class="sign"><a href="''.SIGNUP_URL.''">''.$oLang->TEXT_SIGNUP.''</a></li>''.PHP_EOL;\n    }\n    $return_value .=         ''</ul>''.PHP_EOL;\n    $return_value .=     ''</fieldset>''.PHP_EOL;\n    $return_value .= ''</form>''.PHP_EOL;\n} elseif ((FRONTEND_LOGIN == ''enabled'') && (is_numeric($oApp->get_session(''USER_ID'')))) {\n    $return_value .= ''<form action="''.LOGOUT_URL.''" method="post" class="login-table">''.PHP_EOL;\n    $return_value .=     ''<input type="hidden" name="redirect" value="''.$redirect_url.''">''.PHP_EOL;\n    $return_value .=     ''<input type="hidden" name="page_id" value="''.$oApp->page_id.''">''.PHP_EOL;\n    $return_value .=     ''<fieldset>''.PHP_EOL;\n    $return_value .=         ''<h3>''.$oLang->TEXT_LOGGED_IN.''</h3>''.PHP_EOL;\n    $return_value .=         ''<label>''.$oLang->TEXT_WELCOME_BACK.'', ''.$oApp->get_display_name().''</label>''.PHP_EOL;\n    $return_value .=         ''<p><input type="submit" name="submit" value="''.$oLang->MENU_LOGOUT.''" class="dbutton"></p>''.PHP_EOL;\n    $return_value .=         ''<ul class="logout-advance">''.PHP_EOL;\n    $return_value .=             ''<li class="preference"><a href="''.PREFERENCES_URL.''" title="''.$oLang->MENU_PREFERENCES.''">''.$oLang->MENU_PREFERENCES.''</a></li>''.PHP_EOL;\n    //  change ot the group that should get special links\n    if ($oApp->ami_group_member(''1'')){\n        $return_value .=         ''<li class="admin"><a href="''.ADMIN_URL.''/index.php" title="''.$oLang->TEXT_ADMINISTRATION.''" class="blank_target">''.$oLang->TEXT_ADMINISTRATION.''</a></li>''.PHP_EOL;\n        //you can add more links for your users like userpage, lastchangedpages or something\n    }\n    //change ot the group that should get special links\n    if ($get_permission(''pages_modify'') && $get_page_permission(PAGE_ID)) {\n        $return_value .=        ''<li class="modify"><a  href="''.ADMIN_URL.''/pages/modify.php?page_id=''.PAGE_ID.''" title="''.$oLang->HEADING_MODIFY_PAGE.''" class="blank_target">''.$oLang->HEADING_MODIFY_PAGE.\n            ''</a></li>''.PHP_EOL;\n    }\n    $return_value .=         ''</ul>''.PHP_EOL;\n    $return_value .=     ''</fieldset>''.PHP_EOL;\n    $return_value .= ''</form>''.PHP_EOL;\n}\n$return_value .= ''</div>''.PHP_EOL;\nreturn $return_value;\n', 'Puts a Login / Logout box on your page.', [[timestamp]], 1, 1, 0, 0, 0, 'Use: [[LoginBox?redirect=url]]\nAbsolute or relative url possible\nRemember to enable frontend login in your website settings!!\n@changed 2022-04-09\n'),
(7, 'Lorem', '\n$lorem = [];\n$lorem[] = "Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut odio. Nam sed est. Nam a risus et est iaculis adipiscing. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer ut justo. In tincidunt viverra nisl. Donec dictum malesuada magna. Curabitur id nibh auctor tellus adipiscing pharetra. Fusce vel justo non orci semper feugiat. Cras eu leo at purus ultrices tristique.<br><br>";\n$lorem[] = "Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.<br><br>";\n$lorem[] = "Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.<br><br>";\n$lorem[] = "Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.<br><br>";\n$lorem[] = "Cras consequat magna ac tellus. Duis sed metus sit amet nunc faucibus blandit. Fusce tempus cursus urna. Sed bibendum, dolor et volutpat nonummy, wisi justo convallis neque, eu feugiat leo ligula nec quam. Nulla in mi. Integer ac mauris vel ligula laoreet tristique. Nunc eget tortor in diam rhoncus vehicula. Nulla quis mi. Fusce porta fringilla mauris. Vestibulum sed dolor. Aliquam tincidunt interdum arcu. Vestibulum eget lacus. Curabitur pellentesque egestas lectus. Duis dolor. Aliquam erat volutpat. Aliquam erat volutpat. Duis egestas rhoncus dui. Sed iaculis, metus et mollis tincidunt, mauris dolor ornare odio, in cursus justo felis sit amet arcu. Aenean sollicitudin. Duis lectus leo, eleifend mollis, consequat ut, venenatis at, ante.<br><br>";\n$lorem[] = "Consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br><br>";\nif (!isset($blocks)){ $blocks=1;}\n$blocks = (int)$blocks - 1;\nif ($blocks <= 0){ $blocks = 0;}\nif ($blocks > 5){ $blocks = 5;}\n$returnvalue = "";\nfor ( $i=0 ; $i<=$blocks ; $i++) {\n    $returnvalue .= $lorem[$i];\n}\nreturn $returnvalue;\n', 'Create Lorum Ipsum text', [[timestamp]], 1, 1, 0, 0, 0, 'Use: [[Lorem?blocks=6]] (max 6 paragraphs)\n'),
(8, 'ModifiedWhen', '\nglobal $database, $wb;\nif (PAGE_ID>0) {\n$query=$database->query("SELECT `modified_when` FROM `".TABLE_PREFIX."pages` WHERE `page_id`=".PAGE_ID);\n$mod_details=$query->fetchRow();\nreturn "This page was last modified on ".date("d/m/Y",$mod_details[0]). " at ".date("H:i",$mod_details[0]).".";\n}\n', 'Displays the last modification time of the current page', [[timestamp]], 1, 1, 0, 0, 0, 'Use [[ModifiedWhen]]\n'),
(9, 'NextPage', '$sInfo = show_menu2(0, SM2_CURR, SM2_START, SM2_ALL|SM2_BUFFER|SM2_SHOWHIDDEN, ''[if(class==menu-current){[level] [sib] [sibCount] [parent]}]'', '''', '''', '''');\n$aInfo = (empty($sInfo) ? [] : explode('' '', $sInfo));\n$nxt = 0;\n$sRetval = '''';\nif (sizeof($aInfo)){\n    list($nLevel, $nSib, $nSibCount, $nParent) = $aInfo;\n    $nxt = $nSib < $nSibCount ? $nSib + 1 : 0;\n}\n// show next\nif ($nxt > 0) {\n    $sRetval = show_menu2(0, SM2_CURR, SM2_START, SM2_ALL|SM2_BUFFER|SM2_SHOWHIDDEN,    "[if(sib==$nxt){&gt;&gt; [a][menu_title]</a>}]", '''', '''', '''');\n}\nreturn $sRetval;\n', 'Create a next link to your page', [[timestamp]], 1, 1, 0, 0, 0, 'Display a link to the next page on the same menu level\n'),
(10, 'Oneliner', '$line = file (dirname(__FILE__)."/example/oneliners.txt");\nshuffle($line);\nreturn $line[0];\n', 'Create a random oneliner on your page', [[timestamp]], 1, 1, 0, 0, 0, 'Use: [[OneLiner]].\nThe file with the oneliner data is located in /modules/droplets/example/oneliners.txt;\n'),
(11, 'ParentPage', '$info = show_menu2(0, SM2_CURR, SM2_START, SM2_ALL|SM2_BUFFER, ''[if(class==menu-current){[level] [sib] [sibCount] [parent]}]'', '''', '''', '''');\nlist($nLevel, $nSib, $nSibCount, $nParent) = explode('' '', $info);\n// show up level\nif ($nLevel > 0) {\n$lev = $nLevel - 1;\nreturn show_menu2(0, SM2_ROOT, SM2_CURR, SM2_CRUMB|SM2_BUFFER, "[if(level==$lev){[a][menu_title]</a>}]", '''', '''', '''');\n}\nelse\nreturn ''(no parent)'';\n', 'Create a parent link to your page', [[timestamp]], 1, 1, 0, 0, 0, 'Display a link to the parent page of the current page\n'),
(12, 'PreviousPage', '$sInfo = show_menu2(0, SM2_CURR, SM2_START, SM2_ALL|SM2_BUFFER|SM2_SHOWHIDDEN, ''[if(class==menu-current){[level] [sib] [sibCount] [parent]}]'', '''', '''', '''');\n$aInfo = (empty($sInfo) ? [] : explode('' '', $sInfo));\n$prv = 0;\n$sRetval = '''';\nif (sizeof($aInfo)){\n    list($nLevel, $nSib, $nSibCount, $nParent) = $aInfo;\n    $prv = $nSib > 1 ? $nSib - 1 : 0;\n}\n// show previous\nif ($prv > 0) {\n    $sRetval = show_menu2(0, SM2_CURR, SM2_START, SM2_ALL|SM2_BUFFER|SM2_SHOWHIDDEN, "[if(sib==$prv){[a][menu_title]</a> &lt;&lt;}]", '''', '''', '''');\n}\nreturn $sRetval;\n', 'Create a previous link to your page', [[timestamp]], 1, 1, 0, 0, 0, 'Display a link to the previous page on the same menu level\n'),
(13, 'RandomImage', '$dir = ((isset($dir) && ($dir != ''''))?$dir:'''');\n$folder = opendir(WB_PATH.MEDIA_DIRECTORY.''/''.$dir.''/.'');\n$names = array();\nwhile ($file = readdir($folder)) {\n    $ext = strtolower(substr($file, -4));\n    if ($ext == ".jpg" || $ext == ".gif" || $ext == ".png") {\n        $names[count($names)] = $file;\n    }\n}\nclosedir($folder);\nshuffle($names);\n$image = $names[0];\n$name = substr($image, 0, -4);\nreturn ''<img src="''.WB_URL.MEDIA_DIRECTORY.''/''.$dir.''/''.$image.''" alt="''.$name.''" width="95%">'';\n', 'Get a random image from a folder in the MEDIA folder.', [[timestamp]], 1, 1, 0, 0, 0, 'Commandline to use: [[RandomImage?dir=subfolder_in_mediafolder]]\n'),
(14, 'SearchBox', '\n$return_value = '''';\nif (SHOW_SEARCH) {\n    $oTrans = Translate::getInstance();\n    if (!isset($msg)){$msg=$oTrans->TEXT_SEARCHING;}\n    $return_value    = ''<div class="form-wrapper cf">'';\n    $return_value   .= ''<form action="''.WB_URL.''/search/index''.PAGE_EXTENSION.''" method="get" name="search" class="searchform" id="search">'';\n    //$return_value .= ''<input style="color:#b3b3b3;" type="text" name="string" size="25" class="textbox" value="''.$msg.''" ''.$j.'' >&nbsp;'';\n    $return_value   .= ''<input type="text" name="string" placeholder="''.$msg.''" value="" required>'';\n    $return_value   .= ''<button type="submit">''.$oTrans->TEXT_SEARCH.''</button>'';\n    $return_value   .= ''</form>'';\n    $return_value   .= ''</div>'';\n}\nreturn $return_value;\n', 'Create a Searchbox on the position', [[timestamp]], 1, 1, 0, 0, 0, 'Usage:  [[Searchbox]]\nOptional parameter "?msg=the search message"\nor in HTML Templates\nOptional parameter "?msg="phptag echo lang variable; "\n'),
(15, 'SectionPicker', '\n    $content       = true;\n    $_sFrontendCss = $_sFrontendJs  = '''';\n    $oReg          = \\bin\\WbAdaptor::getInstance();\n    $wb            = ($oReg->getApplication() ?? $GLOBALS[''wb'']);\n    $oTrans        = $oReg->getTranslate();\n    $database      = $oReg->getDatabase();\n    $section_id    = \\intval($sid ?? 0);\n    if ($section_id > 0) {\n        $sSql = ''SELECT `page_id` FROM `''.$database->TablePrefix.''sections` ''\n              . ''WHERE `section_id` = ''.$section_id;\n        if (! \\is_null($page_id = $database->get_one($sSql))) {\n            $iPageIsVisibile = $wb->isPageVisible($page_id);\n            $sSql = ''SELECT `s`.*''\n                  .     '', `p`.`viewing_groups`''\n                  .     '', `p`.`visibility`''\n                  .     '', `p`.`menu_title`''\n                  .     '', `p`.`link` ''\n                  . ''FROM `''.$database->TablePrefix.''sections` `s`''\n                  . ''INNER JOIN `''.$database->TablePrefix.''pages` `p` ''\n                  .    ''ON `p`.`page_id`=`s`.`page_id` ''\n                  . ''WHERE `s`.`section_id` = ''.$section_id.'' ''\n                  .   ''AND (''.\\time().'' BETWEEN `s`.`publ_start` AND `s`.`publ_end`) ''\n                  .   ''AND `active` = 1 ''\n                  .   ''AND `p`.`visibility` NOT IN (\\''deleted\\'',\\''none\\'')'';\n            if (($oSection = $database->query($sSql))) {\n                while ($aSection = $oSection->fetchRow(\\MYSQLI_ASSOC)) {\n                    $section_id = $aSection[''section_id''];\n                    $module = $aSection[''module''];\n                    \\ob_start();\n                    require ($oReg->AppPath.''modules/''.$module.''/view.php'');\n                    $content = \\ob_get_clean();\n                    $sFrontend = ''modules/''.$module.''/frontend'';\n                    $_sPattern = ''/<link[^>]*?href\\s*=\\s*\\"''\n                               . \\preg_quote($oReg->AppUrl.$sFrontend.''.css'', ''/'')\n                               . ''\\".*?\\/>/si'';\n                    if (! \\preg_match($_sPattern, $content)) {\n                        $sFrontendCssFile = (\\is_readable($oReg->AppPath.$sFrontend.''.css'') ? $oReg->AppUrl.$sFrontend.''.css'':'''');\n                        if ($sFrontendCssFile != ''''){\n                            $_sFrontendCss = ''\n                              <script>\n                                  try {\n                                      var ModuleCss = "''.$sFrontendCssFile.''";\n                                      if (ModuleCss!==""){\n                                          if (typeof LoadOnFly === "undefined"){\n                                              include_file(ModuleCss, "css");\n                                          } else {\n                                              LoadOnFly("head", ModuleCss);\n                                          }\n                                      }\n                                  } catch(e) {\n                                   /* alert("An error has occurred: "+e.message)*/\n                                  }\n                              </script>\n                              '';\n                        }\n                    }\n                    $_sPattern = ''/<script[^>]*?src\\s*=\\s*\\"''\n                               . \\preg_quote($oReg->AppUrl.$sFrontend.''.js'', ''/'')\n                               . ''\\".*?\\/>/si'';\n                    if (! \\preg_match($_sPattern, $content)) {\n                        $sFrontendJsFile  = (\\is_readable($oReg->AppPath.$sFrontend.''.js'') ? $oReg->AppUrl.$sFrontend.''.js'':'''');\n                        if ($sFrontendJsFile!=''''){\n                            $_sFrontendJs = ''\n                              <script>\n                                  try {\n                                      var ModuleJs  = "''.$sFrontendJsFile.''";\n                                      if (ModuleJs!==""){\n                                          include_file(ModuleJs, "js");\n                                      }\n                                  } catch(e) {\n                                   /* alert("An error has occurred: "+e.message)*/\n                                  }\n                              </script>\n                              '';\n                        }\n                    }\n                }  // while\n            }\n        } // page_id\n    } // has section_id\n    if ($content === true || trim($content) == '''') {\n        $content = true;\n    } else {\n        $content = $_sFrontendCss.$_sFrontendJs.$content;\n    }\n    return $content;\n// end of file\n', 'Load the view.php from any other section-module', [[timestamp]], 1, 1, 0, 0, 0, 'Use [[SectionPicker?sid=123]]\nDarkViper, Lusiehahne\n'),
(16, 'ShortUrl', '\nglobal $page_id;\n$oReg = \\bin\\WbAdaptor::getInstance();\nif (is_readable($oReg->AppPath.''short.php'')){\n    $pattern = ''/\\[wblink(.+?)\\]/s'';\n    preg_match_all($pattern,$wb_page_data,$ids);\n    foreach($ids[1] as $page_id) {\n        $pattern = ''/\\[wblink''.$page_id.''\\]/s'';\n        $get_link = $oReg->Db->query("SELECT `link` FROM `".$oReg->TablePrefix."pages` WHERE `page_id` = ".$page_id);\n        $fetch_link = $get_link->fetchRow(MYSQLI_ASSOC);\n        $link = $oReg->App->page_link($fetch_link[''link''],true); // retro modus\n        $wb_page_data = preg_replace($pattern,$link,$wb_page_data);\n    }\n    $linkstart = $oReg->AppUrl.$oReg->PagesDir;\n    $linkend = $oReg->PageExtension;\n    $nwlinkstart = $oReg->AppUrl;\n    $nwlinkend = ''/'';\n    preg_match_all(''~''.$linkstart.''(.*?)\\\\''.$linkend.''~'', $wb_page_data, $links);\n    foreach ($links[1] as $link) {\n        $wb_page_data = str_replace($linkstart.$link.$linkend, $nwlinkstart.$link.$nwlinkend, $wb_page_data);\n    }\n}\nreturn true;\n', 'create short url''s with wblink', [[timestamp]], 1, 1, 0, 0, 0, 'use [[ShortUrl]]\n'),
(17, 'showDateBlock', '\n$oReg = \\bin\\WbAdaptor::getInstance();\n$sSpace = '''';\n$sTitle = ($title ?? '''');\n$sPre   = ($pre ?? '''');\n$sDesc  = ($desc ?? '''');\n$iNow   = time()+$oReg->Timezone;\n$ShowDate  = sprintf(''%s'',\\bin\\helpers\\PreCheck::getStrftime($oReg->DateFormat,$iNow,$oReg->Language)); //\n$ShowTime  = sprintf(''%s'',\\bin\\helpers\\PreCheck::getStrftime($oReg->TimeFormat,$iNow,$oReg->Language)); //\n$TimeZone  = $oReg->Timezone;\n$bPeriod   = preg_match(''/[^0-9:\\-\\/_].*(am|pm|AM|PM)/i'',$ShowTime,$aMatches);\n$sPeriod   = ($bPeriod ? trim($aMatches[0]) : "");\n$sLanguage = strtolower($oReg->Language);\n$content   = "";\n    try {\n    $sContent  = ''<div id="showDate" class="w3-container w3-auto w3-center">''.PHP_EOL;\n    if ($sTitle){$sContent .= ''<h3>''.$sTitle .''</h3>''.PHP_EOL;}\n    $sContent .= ''<h4>''.$sPre.''&nbsp;'';\n    $sContent .= ''<span id="date-stamp" data-lang="''.$sLanguage.''" data-timezone="''.$TimeZone.''">''.$ShowDate.'' </span>'';\n    $sContent .= '' <span id="time-stamp" data-period="''.$sPeriod.''">''.$ShowTime.''</span>''.PHP_EOL;\n    $sContent .= ''</h4>''.PHP_EOL;\n    if ($sDesc){$sContent .= ''<h3>''.$sDesc.''</h3>''.PHP_EOL;}\n    $sContent .= ''</div>''.PHP_EOL;\n    } catch (\\Throwable $ex) {\n        /* place to insert different error/logfile messages */\n        $sContent = ''$scontent = ''.$ex->getMessage();\n    }\n    return $sContent;\n', 'Insert Full Date and Clock', [[timestamp]], 1, 1, 0, 0, 0, 'usage: [[showDateBlock?title=Allgemeine Termine&amp;pre=Heute ist&amp;desc=Terminänderungen bleiben vorbehalten]]\ncan be call without parameters\n'),
(18, 'ShowRandomWysiwyg', 'global $database;\n$content = '' '';\nif (isset($section)) {\n    if( preg_match(''/^[0-9]+(?:\\s*[\\,\\|\\-\\;\\:\\+\\#\\/]\\s*[0-9]+\\s*)*$/'', $section)) {\n        if (is_readable(WB_PATH.''/modules/wysiwyg/view.php'')) {\n            // if valid arguments given and module wysiwyg is installed\n            // split and sanitize arguments\n            $aSections = preg_split(''/[\\s\\,\\|\\-\\;\\:\\+\\#\\/]+/'', $section);\n            $section_id = $aSections[array_rand($aSections)]; // get random element\n            ob_start(); // generate output by wysiwyg module\n            require(WB_PATH.''/modules/wysiwyg/view.php'');\n            $content = ob_get_clean();\n        }\n    }\n}\nreturn $content;\n', 'Randomly display one WYSIWYG section from a given list', [[timestamp]], 1, 1, 0, 0, 0, 'Use [[ShowRandomWysiwyg?section=10,12,15,20]]\npossible Delimiters: [ ,;:|-+#/ ]\n'),
(19, 'ShowRootParent', '\n/*\n * possible return values:\n *  if current page is a real root page = ''own title''\n *  if current page is root page after a language page = ''own title''\n *  all others shows the root page/menu title of the current branch\n *  if page_id = 0, the default_page[$title] is loaded\n *  language pages in root are ignored and show the default_page[$title]\n */\n// process selection\n$title = (($show ?? ''p'') == ''m''  ? ''menue_title'' : ''page_title'');\n$oReg = \\bin\\WbAdaptor::getInstance();\n$oApp = $oReg->getApplication();\n$iCurrPageId = $GLOBALS[''page_id''];\n$sRetval = '''';\nif ($iCurrPageId) { // if current page > 0\n    $aPage = $oApp->getPage($iCurrPageId);\n    if ($aPage) {\n        $aPageTrail = \\explode('','', $aPage[''page_trail'']);\n        if (($oReg->PageLanguages ?? 0)) {\n            \\array_shift($aPageTrail); // remove language level\n        }\n        if (\\count($aPageTrail)) { // if at least one page exists (root or root after language)\n            $iRootPageId = \\array_shift($aPageTrail);\n            $aPage = $oApp->getPage($iRootPageId);\n            if ($aPage) {\n                $sRetval = $aPage[$title];\n            }\n        }\n    }\n}\n// try to load the default page if an error occurred before\nif (!$sRetval) {\n    $iDefaultPageId = ($oApp->default_page_id ?? 0);\n    if ($iDefaultPageId) {\n        $aPage = $oApp->getPage($iDefaultPageId);\n        if ($aPage) {\n            $sRetval = $aPage[$title];\n        }\n    }\n}\nreturn $sRetval;\n', 'Shows the parent page_title or menu_title of a page tree', [[timestamp]], 1, 1, 0, 0, 0, 'Use [[ShowRootParent?show=m]] shows menu_title\nUse [[ShowRootParent]] or [[ShowRootParent?show=p]] shows page_tile\n'),
(20, 'ShowWysiwyg', 'global $database, $section_id, $module;\n$content = '' '';\n$section = isset($section) ? intval($section) : 0;\nif ($section) {\nif (is_readable(WB_PATH.''/modules/wysiwyg/view.php'')) {\n// if valid section is given and module wysiwyg is installed\n$iOldSectionId = intval($section_id); // save old SectionID\n$section_id = $section;\nob_start(); // generate output by regulary wysiwyg module\nrequire(WB_PATH.''/modules/wysiwyg/view.php'');\n$content = ob_get_clean();\n$section_id = $iOldSectionId; // restore old SectionId\n}\n}\nreturn $content;\n', 'Display one defined WYSIWYG section', [[timestamp]], 1, 1, 0, 0, 0, 'Use [[ShowWysiwyg?section=10]]\n'),
(21, 'SiteMapChildRL', '\n$oApp = \\bin\\WbAdaptor::getInstance()->getApplication();\n$content = '''';\nif (isset($start) && !empty($start)) {\n    $iChild = (isset($start) && is_numeric($start) ? $start : 0);\n    if ($iChild > 0){\n        $content = ''''.\n        show_menu2(SM2_ALLMENU,\n                $iChild,\n                SM2_ALL,\n                SM2_ALL|SM2_ALLINFO|SM2_BUFFER,\n                ''<li class="w3-bar-item w3-button><span class="menu-default">''.''[a][page_title]</a></span>'',\n                ''</li>'',\n                ''<ul id="servicelinks" class="w3-bar w3-border w3-light-grey">'');\n    }\n}\nreturn ($content.'''');\n', 'List of pages below current page or page_id. Modified for servicelinks.', [[timestamp]], 1, 1, 0, 0, 0, '[[SiteMapChildRL?start=11]]\n(optional parameter) start=page_id\n@change 20220410\n'),
(22, 'SiteModified', '\n$oDb = \\database::getInstance();\n$oTrans = \\Translate::getInstance();\n$oTrans->enableAddon(''templates/''.TEMPLATE);\n$retVal = '' '';\nif (PAGE_ID > 0) {\n    $sSqlSet = ''SELECT `p`.`modified_when`, `p`.`modified_by`, `u`.`display_name` FROM `''.TABLE_PREFIX.''pages` `p` ''\n    . ''LEFT JOIN `''.TABLE_PREFIX.''users` `u` ON (`u`.`user_id` = `p`.`modified_by`) ''\n    . ''WHERE `p`.`page_id` = ''.PAGE_ID;\n    $oRes = $oDb->query($sSqlSet);\n    $aRes = $oRes->fetchRow(MYSQLI_ASSOC);\n    $sDate = date("d-m-Y H:i", $aRes[''modified_when'']+TIMEZONE);\n    $retVal = sprintf($oTrans->MESSAGE_PAGE_MODIFIED, $sDate, $aRes[''display_name'']);\n}\nreturn is_array($retVal) ? '' '' : $retVal;\n', 'Create information on when your site was last updated.', [[timestamp]], 1, 1, 0, 0, 0, 'Create information on when your site was last updated. Any page update counts.\n'),
(23, 'Text2Image', '//clean up old files..\n$dir = WB_PATH.''/temp/'';\n$dp = opendir($dir) or die (''Could not open ''.$dir);\nwhile ($file = readdir($dp)) {\nif ((preg_match(''/img_/'',$file)) && (filemtime($dir.$file)) <  (strtotime(''-10 minutes''))) {\nunlink($dir.$file);\n}\n}\nclosedir($dp);\n$imgfilename = ''img_''.rand().''_''.time().''.jpg'';\n//create image\n$padding = 0;\n$font = 3;\n$height = imagefontheight($font) + ($padding * 2);\n$width = imagefontwidth($font) * strlen($text) + ($padding * 2);\n$image_handle = imagecreatetruecolor($width, $height);\n$text_color = imagecolorallocate($image_handle, 0, 0, 0);\n$background_color = imagecolorallocate($image_handle, 255, 255, 255);\n$bg_height = imagesy($image_handle);\n$bg_width = imagesx($image_handle);\nimagefilledrectangle($image_handle, 0, 0, $bg_width, $bg_height, $background_color);\nimagestring($image_handle, $font, $padding, $padding, $text, $text_color);\nimagejpeg($image_handle,WB_PATH.''/temp/''.$imgfilename,100);\nimagedestroy($image_handle);\nreturn ''<img src="''.WB_URL.''/temp/''.$imgfilename.''" style="border:0px;margin:0px;padding:0px;vertical-align:middle;">'';\n', 'Create an image from the textparameter', [[timestamp]], 1, 1, 0, 0, 0, 'Use [[text2image?text=The text to create]]\n'),
(24, 'year', '$datum = date("Y");\nreturn "$datum";\n', 'zeigt das aktuelle Jahr an', [[timestamp]], 1, 1, 0, 0, 0, '[[year]] zeigt die Jahrezahl\n'),
(25, 'Zitate', '$line = file (dirname(__FILE__)."/example/oneliners.txt");\nshuffle($line);\nreturn $line[0];\n', 'Create a random oneliner on your page', [[timestamp]], 1, 1, 0, 0, 0, 'Use: [[Zitate]].\nThe file with the oneliner data is located in /modules/droplets/example/oneliners.txt;\n');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_form_fields`
--

CREATE TABLE `[[dbprefix]]mod_form_fields` (
  `field_id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `layout` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `position` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `required` int(11) NOT NULL DEFAULT '0',
  `value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `extra` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `active` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_form_settings`
--

CREATE TABLE `[[dbprefix]]mod_form_settings` (
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `layout` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_to` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `email_from` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_fromname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `success_page` int(11) NOT NULL DEFAULT '-1',
  `success_email_to` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `success_email_from` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `success_email_fromname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `success_email_text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `success_email_subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `stored_submissions` int(11) NOT NULL DEFAULT '80',
  `delete_submissions` int(11) NOT NULL DEFAULT '30',
  `max_submissions` int(11) NOT NULL DEFAULT '1',
  `perpage_submissions` int(11) NOT NULL DEFAULT '10',
  `use_captcha` int(11) NOT NULL DEFAULT '0',
  `subject_email` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `captcha_action` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `divider` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `captcha_style` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `send_confirmmail` int(11) NOT NULL DEFAULT '0',
  `data_protection_link` int(11) NOT NULL DEFAULT '-1',
  `use_data_protection` int(11) NOT NULL DEFAULT '0',
  `use_captcha_auth` int(11) NOT NULL DEFAULT '0',
  `prevent_user_confirmation` int(11) NOT NULL DEFAULT '0',
  `info_dsgvo_in_mail` int(11) NOT NULL DEFAULT '0',
  `title_placeholder` int(11) NOT NULL DEFAULT '1',
  `form_required` int(11) NOT NULL DEFAULT '0',
  `frontend_css` int(11) NOT NULL DEFAULT '0',
  `header` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `field_loop` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `extra` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `footer` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `spam_submissions` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_form_submissions`
--

CREATE TABLE `[[dbprefix]]mod_form_submissions` (
  `submission_id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `submitted_when` int(11) NOT NULL DEFAULT '0',
  `submitted_by` int(11) NOT NULL DEFAULT '0',
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_delete` int(11) NOT NULL DEFAULT '0',
  `form_ip` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`submission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_jsadmin`
--

CREATE TABLE `[[dbprefix]]mod_jsadmin` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `[[dbprefix]]mod_jsadmin`
--

INSERT INTO `[[dbprefix]]mod_jsadmin` VALUES
(1, 'mod_jsadmin_persist_order', 1),
(2, 'mod_jsadmin_ajax_order_pages', 1),
(3, 'mod_jsadmin_ajax_order_sections', 1);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_menu_link`
--

CREATE TABLE `[[dbprefix]]mod_menu_link` (
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `target_page_id` int(11) NOT NULL DEFAULT '0',
  `redirect_type` int(11) NOT NULL DEFAULT '301',
  `anchor` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `extern` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_news_comments`
--

CREATE TABLE `[[dbprefix]]mod_news_comments` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `post_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `commented_when` int(11) NOT NULL DEFAULT '0',
  `commented_by` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_news_groups`
--

CREATE TABLE `[[dbprefix]]mod_news_groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '0',
  `position` int(11) NOT NULL DEFAULT '0',
  `title` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`group_id`),
  UNIQUE KEY `ident_news` USING BTREE (`section_id`,`title`(127))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_news_layouts`
--

CREATE TABLE `[[dbprefix]]mod_news_layouts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layout` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `header` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_loop` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `footer` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_header` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_footer` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `comments_header` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `comments_loop` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `comments_footer` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `comments_page` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ident_layout` USING BTREE (`id`,`layout`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `[[dbprefix]]mod_news_layouts`
--

INSERT INTO `[[dbprefix]]mod_news_layouts` VALUES
(1, 'default_layout', '\n<table class="loop-header">\n    <tbody>', '\n        <tr id="NL[POST_ID]" class="post-top w3-light-gray">\n            <td class="post-title"><a href="[LINK]">[TITLE]</a></td>\n            <td class="post-date">[TEXT_POSTED_BY] [DISPLAY_NAME] [TEXT_ON] [PUBLISHED_DATE] [TEXT_AT] [PUBLISHED_TIME]</td>\n        </tr>\n        <tr>\n            <td class="post-short" colspan="2">[SHORT]\n                <span style="visibility:[SHOW_READ_MORE];">\n                  <a class="readmore" href="[LINK]">[TEXT_READ_MORE]</a>\n                </span>\n           </td>\n        </tr>', '\n    </tbody>\n</table>\n<table class="loop-footer">\n    <tbody>\n        <tr>\n           <td class="page-left">[PREVIOUS_PAGE_LINK]</td>\n           <td class="page-center">[OF]</td>\n           <td class="page-right">[NEXT_PAGE_LINK]</td>\n        </tr>\n    </tbody>\n</table>', '\n<table id="NH[POST_ID]" class="post-header">\n    <tbody>\n        <tr>\n            <td><h3>[TITLE]</h3></td>\n            <td rowspan="3" style="display: [DISPLAY_IMAGE]">[GROUP_IMAGE]</td>\n        </tr>\n        <tr>\n            <td class="public-info"><b>[TEXT_POSTED_BY] [DISPLAY_NAME] [TEXT_ON] [PUBLISHED_DATE]</b></td>\n        </tr>\n        <tr style="display: [DISPLAY_GROUP]">\n            <td class="group-page"><a href="[BACK]">[PAGE_TITLE]</a> &raquo; <a href="[GROUP_BACK]">[GROUP_TITLE]</a></td>\n         </tr>\n    </tbody>\n</table>', '\n<p>[TEXT_LAST_CHANGED]: [MODI_DATE] [TEXT_AT] [MODI_TIME]</p>\n<a href="[BACK]">[TEXT_BACK]</a>', '\n\n<table class="comment-header">\n    <tbody>', '\n        <tr>\n            <td class="comment_title">[TITLE]</td>\n            <td class="comment_info">[TEXT_BY] [DISPLAY_NAME] [TEXT_ON] [DATE] [TEXT_AT] [TIME]</td>\n        </tr>\n        <tr>\n            <td colspan="2" class="comment-text">[COMMENT]</td>\n        </tr>', '\n    </tbody>\n</table>\n<br /><a href="[ADD_COMMENT_URL]">[TEXT_ADD_COMMENT]</a>', '\n<h2>[TEXT_COMMENT]</h2>\n<h3>[POST_TITLE]</h3>'),
(2, 'div_layout', '<div class="news-loop-header">', '\n        <div id="NL[POST_ID]" class="post-top">\n            <div class="post-title"><a href="[LINK]">[TITLE]</a></div>\n            <div class="post-date">[TEXT_POSTED_BY] [DISPLAY_NAME] [TEXT_ON] [PUBLISHED_DATE] [TEXT_AT] [PUBLISHED_TIME]</div>\n        </div>\n        <div>\n            <div class="post-short">[SHORT]\n                <span style="visibility:[SHOW_READ_MORE];">\n                  <a class="readmore" href="[LINK]">[TEXT_READ_MORE]</a>\n                </span>\n           </div>\n        </div>', '\n</div>\n    <div class="w3-display-container news-container news-loop-footer" style="display:[DISPLAY_PREVIOUS_NEXT_LINKS]">\n        <div class="w3-display-left news-third news-left-align">[PREVIOUS_PAGE_LINK]</div>\n        <div class="w3-display-middle news-third news-center">[OF]</div>\n        <div class="w3-display-right news-third news-right-align">[NEXT_PAGE_LINK]</div>\n    </div>', '\n<div id="NH[POST_ID]" class="news-post-header">\n    <div>\n        <div><h3>[TITLE]</h3></div>\n        <div style="display: [DISPLAY_IMAGE]">[GROUP_IMAGE]</div>\n    </div>\n    <div>\n        <div class="public-info">\n            <b>[TEXT_POSTED_BY] [DISPLAY_NAME] [TEXT_ON] [PUBLISHED_DATE]</b>\n        </div>\n    </div>\n    <div style="display: [DISPLAY_GROUP]">\n        <div class="group-page">\n            <a href="[BACK]">[PAGE_TITLE]</a> &raquo; <a href="[GROUP_BACK]">[GROUP_TITLE]</a>\n        </div>\n    </div>\n</div>', '\n<p>[TEXT_LAST_CHANGED]: [MODI_DATE] [TEXT_AT] [MODI_TIME]</p>\n<a href="[BACK]">[TEXT_BACK]</a>', '\n<br><br>\n<h2>[TEXT_COMMENTS]</h2>\n<div class="news-comment-header">', '\n    <div>\n        <div class="news-comment_title">[TITLE] </div>\n        <div class="news-comment_info">[TEXT_BY] [DISPLAY_NAME] [TEXT_ON] [DATE] [TEXT_AT] [TIME]</div>\n    </div>\n    <div>\n        <div class="news-comment-text">[COMMENT]</div>\n    </div>', '\n</div>\n<br><a href="[ADD_COMMENT_URL]">[TEXT_ADD_COMMENT]</a>', '\n<h2>[TEXT_COMMENT]</h2>\n<h3>[POST_TITLE]</h3>'),
(3, 'div_new_layout', '\n<div class="news-loop-header">', '\n        <div id="NL[POST_ID]" class="post-top">\n            <div class="post-title"><a href="[LINK]">[TITLE]</a></div>\n            <div class="post-date">[TEXT_POSTED_BY] [DISPLAY_NAME] [TEXT_ON] [PUBLISHED_DATE] [TEXT_AT] [PUBLISHED_TIME]</div>\n        </div>\n        <div>\n            <div class="post-short">[SHORT]\n                <span style="visibility:[SHOW_READ_MORE];">\n                  <a class="readmore" href="[LINK]">[TEXT_READ_MORE]</a>\n                </span>\n           </div>\n        </div>', '\n</div>\n    <div class="w3-display-container news-container news-loop-footer" style="display:[DISPLAY_PREVIOUS_NEXT_LINKS]">\n        <div class="w3-display-left news-third news-left-align">[PREVIOUS_PAGE_LINK]</div>\n        <div class="w3-display-middle news-third news-center">[OF]</div>\n        <div class="w3-display-right news-third news-right-align">[NEXT_PAGE_LINK]</div>\n    </div>', '\n<div id="NH[POST_ID]" class="news-post-header">\n    <div>\n        <div><h3>[TITLE]</h3></div>\n        <div style="display: [DISPLAY_IMAGE]">[GROUP_IMAGE]</div>\n    </div>\n    <div>\n        <div class="public-info">\n            <b>[TEXT_POSTED_BY] [DISPLAY_NAME] [TEXT_ON] [PUBLISHED_DATE]</b>\n        </div>\n    </div>\n    <div style="display: [DISPLAY_GROUP]">\n        <div class="group-page">\n            <a href="[BACK]">[PAGE_TITLE]</a> &raquo; <a href="[GROUP_BACK]">[GROUP_TITLE]</a>\n        </div>\n    </div>\n</div>', '\n<p>[TEXT_LAST_CHANGED]: [MODI_DATE] [TEXT_AT] [MODI_TIME]</p>\n<a href="[BACK]">[TEXT_BACK]</a>', '\n<br><br>\n<h2>[TEXT_COMMENTS]</h2>\n<div class="news-comment-header">', '\n    <div>\n        <div class="news-comment_title">[TITLE] </div>\n        <div class="news-comment_info">[TEXT_BY] [DISPLAY_NAME] [TEXT_ON] [DATE] [TEXT_AT] [TIME]</div>\n    </div>\n    <div>\n        <div class="news-comment-text">[COMMENT]</div>\n    </div>', '\n</div>\n<br><a href="[ADD_COMMENT_URL]">[TEXT_ADD_COMMENT]</a>', '\n<h2>[TEXT_COMMENT]</h2>\n<h3>[POST_TITLE]</h3>');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_news_posts`
--

CREATE TABLE `[[dbprefix]]mod_news_posts` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `group_id` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '0',
  `position` int(11) NOT NULL DEFAULT '0',
  `title` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `content_short` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_long` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `commenting` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `created_when` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL DEFAULT '0',
  `published_when` int(11) NOT NULL DEFAULT '0',
  `published_until` int(11) NOT NULL DEFAULT '0',
  `posted_when` int(11) NOT NULL DEFAULT '0',
  `posted_by` int(11) NOT NULL DEFAULT '0',
  `modified_when` int(11) NOT NULL DEFAULT '0',
  `modified_by` int(11) NOT NULL DEFAULT '0',
  `moderated` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  UNIQUE KEY `ident_post` USING BTREE (`post_id`,`title`(127))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_news_settings`
--

CREATE TABLE `[[dbprefix]]mod_news_settings` (
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `posts_per_page` int(11) NOT NULL DEFAULT '5',
  `commenting` varchar(14) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
  `resize` int(11) NOT NULL DEFAULT '0',
  `use_captcha` int(11) NOT NULL DEFAULT '1',
  `order` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'DESC',
  `layout_id` int(11) NOT NULL DEFAULT '2',
  `layout` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'div_layout',
  `order_field` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'published_when',
  `data_protection_link` int(11) NOT NULL DEFAULT '-1',
  `use_data_protection` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`section_id`),
  KEY `layout` USING BTREE (`layout_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_output_filter`
--

CREATE TABLE `[[dbprefix]]mod_output_filter` (
  `name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `[[dbprefix]]mod_output_filter`
--

INSERT INTO `[[dbprefix]]mod_output_filter` VALUES
('at_replacement', '[at]'),
('CleanUp', '1'),
('CssToHead', '1'),
('dot_replacement', '[dot]'),
('Droplets', '1'),
('edit_force', '0'),
('Email', '1'),
('email_filter', '0'),
('FilterAbstract', '1'),
('FrontendBodyJs', '1'),
('FrontendCss', '1'),
('FrontendJs', '1'),
('Jquery', '0'),
('JqueryUI', '0'),
('LoadOnFly', '1'),
('mailto_filter', '1'),
('OpF', '0'),
('OutputFilterMode', '0'),
('RegisterModFiles', '1'),
('RelUrl', '0'),
('ReplaceSysvar', '1'),
('ScriptVars', '1'),
('Short_force', '0'),
('ShortUrl', '1'),
('SnippetBodyJs', '1'),
('SnippetCss', '1'),
('SnippetJs', '1'),
('W3Css', '0'),
('W3Css_force', '0'),
('WbLink', '1'),
('WbLinkXXL', '0');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_wrapper`
--

CREATE TABLE `[[dbprefix]]mod_wrapper` (
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `url` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `height` int(11) NOT NULL DEFAULT '400',
  `min_height` int(11) NOT NULL DEFAULT '400',
  `attribute` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mod_wysiwyg`
--

CREATE TABLE `[[dbprefix]]mod_wysiwyg` (
  `section_id` int(11) NOT NULL DEFAULT '0',
  `page_id` int(11) NOT NULL DEFAULT '0',
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]pages`
--

CREATE TABLE `[[dbprefix]]pages` (
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) NOT NULL DEFAULT '0',
  `root_parent` int(11) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '0',
  `link` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `page_trail` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `position` int(11) NOT NULL DEFAULT '0',
  `menu` int(11) NOT NULL DEFAULT '0',
  `language` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `page_code` int(11) NOT NULL DEFAULT '0',
  `visibility` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `target` varchar(14) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `page_title` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `page_icon` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `menu_title` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `menu_icon_0` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `menu_icon_1` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `tooltip` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `template` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `searching` int(11) NOT NULL DEFAULT '0',
  `admin_groups` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `admin_users` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `viewing_groups` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `viewing_users` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `modified_when` int(11) NOT NULL DEFAULT '0',
  `modified_by` int(11) NOT NULL DEFAULT '0',
  `custom01` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `custom02` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]search`
--

CREATE TABLE `[[dbprefix]]search` (
  `search_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `extra` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`search_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `[[dbprefix]]search`
--

INSERT INTO `[[dbprefix]]search` VALUES
(1, 'header', '\n<h1>[TEXT_SEARCH]</h1>\n\n<form id="searchpage" action="[WB_URL]/search/index.php" method="get">\n<table>\n<tr>\n<td>\n<input type="hidden" name="search_path" value="[SEARCH_PATH]" />\n<input type="text" name="string" value="[SEARCH_STRING]" style="width: 100%;" />\n</td>\n<td width="150">\n<input type="submit" value="[TEXT_SEARCH]" style="width: 100%;cursor: pointer;" />\n</td>\n</tr>\n<tr>\n<td colspan="2">\n<input type="radio" name="match" id="match_all" value="all"[ALL_CHECKED] />\n<label for="match_all">[TEXT_ALL_WORDS]</label>\n<input type="radio" name="match" id="match_any" value="any"[ANY_CHECKED] />\n<label for="match_any">[TEXT_ANY_WORDS]</label>\n<input type="radio" name="match" id="match_exact" value="exact"[EXACT_CHECKED] />\n<label for="match_exact">[TEXT_EXACT_MATCH]</label>\n</td>\n</tr>\n</table>\n\n</form>\n\n<hr />\n    ', ''),
(2, 'footer', '', ''),
(3, 'results_header', '[TEXT_RESULTS_FOR] ''<b>[SEARCH_STRING]</b>'':\n<table style="padding-top: 10px;width: 100%;">', ''),
(4, 'results_loop', '<tr style="background-color: #F0F0F0;">\n<td><a href="[LINK]">[TITLE]</a></td>\n<td style="float: right;">[TEXT_LAST_UPDATED_BY] [DISPLAY_NAME] [TEXT_ON] [DATE]</td>\n</tr>\n<tr><td colspan="2" style="text-align: justify; padding-bottom: 5px;">[DESCRIPTION]</td></tr>\n<tr><td colspan="2" style="text-align: justify; padding-bottom: 10px;">[EXCERPT]</td></tr>', ''),
(5, 'results_footer', '</table>', ''),
(6, 'no_results', '<tr><td><p>[TEXT_NO_RESULTS]</p></td></tr>', ''),
(7, 'module_order', 'faqbaker,manual,wysiwyg', ''),
(8, 'max_excerpt', '15', ''),
(9, 'time_limit', '0', ''),
(10, 'cfg_enable_old_search', 'true', ''),
(11, 'cfg_search_keywords', 'true', ''),
(12, 'cfg_search_description', 'true', ''),
(13, 'cfg_show_description', 'true', ''),
(14, 'cfg_enable_flush', 'false', ''),
(15, 'template', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sections`
--

CREATE TABLE `[[dbprefix]]sections` (
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL DEFAULT '0',
  `position` int(11) NOT NULL DEFAULT '0',
  `module` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `block` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `publ_start` int(11) NOT NULL DEFAULT '0',
  `publ_end` int(11) NOT NULL DEFAULT '2147483647' COMMENT 'max ((2^31)-1)',
  `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `anchor` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '1',
  `attribute` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]settings`
--

CREATE TABLE `[[dbprefix]]settings` (
  `name` varchar(160) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`name`),
  UNIQUE KEY `ident_settings` USING BTREE (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `[[dbprefix]]settings`
--

INSERT INTO `[[dbprefix]]settings` VALUES
('app_name', '[[app_name]]'),
('confirmed_registration', 'false'),
('debug', 'false'),
('default_charset', 'utf-8'),
('default_date_format', 'm-d-Y'),
('default_language', '[[language]]'),
('default_template', 'DefaultTemplate'),
('default_theme', 'DefaultTheme'),
('default_time_format', 'g:i|A'),
('default_timezone', '0'),
('dev_infos', 'true'),
('dsgvo_settings', 'a:3:{s:19:"use_data_protection";b:1;s:2:"DE";i:0;s:2:"EN";i:0;}'),
('er_level', '32767'),
('frontend_login', 'false'),
('frontend_signup', 'false'),
('home_folders', 'false'),
('homepage_redirection', 'false'),
('intro_page', 'false'),
('jquery_cdn_link', ''),
('jquery_version', '3.5.1'),
('manage_sections', 'true'),
('media_compress', '85'),
('media_directory', '/media'),
('media_height', '0'),
('media_version', '1.0.0'),
('media_width', '0'),
('mediasettings', 'a:1:{s:6:"global";a:3:{s:10:"admin_only";i:1;s:11:"show_thumbs";i:0;s:9:"resize_up";i:1;}}'),
('multiple_menus', 'true'),
('operating_system', 'linux'),
('page_extension', '.php'),
('page_icon_dir', '/templates/*/title_images'),
('page_languages', 'true'),
('page_level_limit', '4'),
('page_newstyle', 'true'),
('page_oldstyle', 'false'),
('page_spacer', '-'),
('page_trash', 'inline'),
('pages_directory', '/pages'),
('patch_revision', '24'),
('patch_update', '1756711500'),
('redirect_timer', '1000'),
('rename_files_on_upload', 'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js'),
('search', 'public'),
('sec_anchor', 'Sec'),
('sec_token_fingerprint', 'true'),
('sec_token_life_time', '1800'),
('sec_token_netmask4', '24'),
('sec_token_netmask6', '64'),
('section_blocks', 'true'),
('server_email', '[[admin_email]]'),
('sgc_execute', 'false'),
('show_start_datetime', 'false'),
('smart_login', 'true'),
('string_dir_mode', '[[dir_perm]]'),
('string_file_mode', '[[file_perm]]'),
('system_locked', 'false'),
('twig_version', '3'),
('user_login', 'true'),
('warn_page_leave', '1'),
('wb_revision', '24'),
('wb_sp', ''),
('wb_version', '2.13.9'),
('wbmailer_default_sendername', 'WB Mailer'),
('wbmailer_low_security', 'false'),
('wbmailer_routine', 'phpmail'),
('wbmailer_smtp_auth', ''),
('wbmailer_smtp_debug', '0'),
('wbmailer_smtp_host', ''),
('wbmailer_smtp_password', ''),
('wbmailer_smtp_port', '25'),
('wbmailer_smtp_secure', 'TLS'),
('wbmailer_smtp_username', ''),
('website_description', '[[site_desc]]'),
('website_footer', ''),
('website_header', ''),
('website_keywords', ''),
('website_signature', ''),
('website_title', '[[site_name]]'),
('wysiwyg_editor', 'ckeditor'),
('wysiwyg_style', 'font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]users`
--

CREATE TABLE `[[dbprefix]]users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL DEFAULT '0',
  `groups_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `active` int(11) NOT NULL DEFAULT '0',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `confirm_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `confirm_timeout` int(11) NOT NULL DEFAULT '0',
  `remember_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `last_reset` int(11) NOT NULL DEFAULT '0',
  `display_name` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `timezone` int(11) NOT NULL DEFAULT '0',
  `date_format` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `time_format` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `language` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `home_folder` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `login_when` int(11) NOT NULL DEFAULT '0',
  `login_ip` varchar(90) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]users`
--

INSERT INTO `[[dbprefix]]users` VALUES
(1, 1, '1', 1, '[[admin_username]]', '[[admin_pass]]', '', 0, '', 0, 'Administrator', '[[admin_email]]', 0, 'm-d-Y', 'g:i|A', '[[language]]', '', [[timestamp]], '[[userip]]');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
File Content: baker.sql

File Content: `baker.sql`
