Edit Page

'', // tags not striped off (default:=''

'')\r\n ''custom_placeholder'' => false, // false:= none (default), array(''MY_VAR_1'' => ''%TAG%#'', ... ''MY_VAR_N'' => ''#regex_N#'' ...)\r\n ''sort_by'' => 1, // 1:=position (default), 2:=posted_when, 3:=published_when, 4:=random order, 5:=number of comments\r\n ''sort_order'' => 1, // 1:=descending (default), 2:=ascending\r\n ''is_not_older_than'' => 0, // alias for not_older_than (CKE problem, see issue #78)\r\n ''not_older_than'' => 0, // 0:=disabled (default), 0-999 (only show news `published_when` date <=x days; 12 hours:=0.5)\r\n ''lang_id'' => ''AUTO'', // language file to load and lang_id used if $lang_filer = true (default:= auto, examples: AUTO, DE, EN)\r\n ''lang_filter'' => false, // flag to enable language filter (default:= false, show only news from a news page, which language fits $lang_id)\r\n ''skip'' => null, // filter by tags (blacklist)\r\n ''tags'' => null, // filter by tags (whitelist)\r\n ''view'' => null, // use CSS from view (default, faq)\r\n ''aslist'' => false, // only titles (

)\r\n ''groups_on_tags'' => 1\r\n);\r\n\r\n// update options with user defined values\r\nforeach($options as $key => $value) {\r\n // remove options not defined via [[displayNewsItems?supported_option=VALUE]]\r\n if (! isset(${$key})) {\r\n unset($options[$key]);\r\n continue;\r\n }\r\n\r\n // update options with user defined values (will be sanitized in getImageNewsItems later on)\r\n if ($key == ''group_id'') {\r\n $options[$key] = explode('','', ${$key});\r\n } else {\r\n if (in_array($key, array(''allowed_tags''))) {\r\n // deal with fact that Droplets don''t yet support urldecode by itself\r\n ${$key} = str_replace(array(''<'', ''%3C'', ''>'', ''%3E''), array(''<'', ''<'', ''>'', ''>''), ${$key});\r\n }\r\n if (in_array($key, array(''strip_tags'', ''lang_filter''))) {\r\n // deal with boolean types (''false'', ''true'' are both True if converted to Boolean)\r\n ${$key} = str_replace(array(''false'', ''true''), array(''0'', ''1''), strtolower(${$key}));\r\n }\r\n // strip leading and trailing single and double quotes\r\n $options[$key] = trim(${$key}, ''"\\'''');\r\n }\r\n}\r\n\r\n$output = mod_nwi_get_news_items($options);\r\nreturn $output;\r\n\r\n', '', [[timestamp]], 0, 1, 0, 0, 0, ''); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_jsadmin` -- CREATE TABLE `[[dbprefix]]mod_jsadmin` ( `id` int(11) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `value` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM 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(3) 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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_miniform` -- CREATE TABLE `[[dbprefix]]mod_miniform` ( `section_id` int(11) NOT NULL DEFAULT '0', `email` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `emailfrom` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `confirm_user` int(11) NOT NULL DEFAULT '0', `confirm_subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `template` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'form', `successpage` int(11) NOT NULL DEFAULT '0', `use_ajax` int(11) NOT NULL DEFAULT '1', `use_recaptcha` int(11) NOT NULL DEFAULT '0', `recaptcha_key` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `recaptcha_secret` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `remote_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `remote_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `disable_tls` int(11) NOT NULL DEFAULT '0', `no_store` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`section_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_miniform_data` -- CREATE TABLE `[[dbprefix]]mod_miniform_data` ( `message_id` int(11) NOT NULL AUTO_INCREMENT, `section_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `data` mediumtext COLLATE utf8_unicode_ci NOT NULL, `guid` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `session_data` mediumtext COLLATE utf8_unicode_ci NOT NULL, `submitted_when` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`message_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_news_img_groups` -- CREATE TABLE `[[dbprefix]]mod_news_img_groups` ( `group_id` int(11) NOT NULL AUTO_INCREMENT, `section_id` int(11) NOT NULL DEFAULT '0', `active` int(11) NOT NULL DEFAULT '0', `position` int(11) NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]mod_news_img_groups` -- INSERT INTO `[[dbprefix]]mod_news_img_groups` VALUES (1, 0, 0, 0, ''); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_news_img_img` -- CREATE TABLE `[[dbprefix]]mod_news_img_img` ( `id` int(11) NOT NULL AUTO_INCREMENT, `picname` varchar(255) NOT NULL DEFAULT '', `picdesc` varchar(255) NOT NULL DEFAULT '', `post_id` int(11) NOT NULL DEFAULT '0', `position` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_news_img_posts` -- CREATE TABLE `[[dbprefix]]mod_news_img_posts` ( `post_id` int(11) NOT NULL AUTO_INCREMENT, `section_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(255) NOT NULL DEFAULT '', `link` text NOT NULL, `image` varchar(256) NOT NULL DEFAULT '', `content_short` text NOT NULL, `content_long` text NOT NULL, `content_block2` text NOT NULL, `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', PRIMARY KEY (`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]mod_news_img_posts` -- INSERT INTO `[[dbprefix]]mod_news_img_posts` VALUES (1, 0, 0, 0, 0, '', '', '', '', '', '', 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_news_img_posts_img` -- CREATE TABLE `[[dbprefix]]mod_news_img_posts_img` ( `post_id` int(11) NOT NULL, `pic_id` int(11) NOT NULL, `position` int(11) NOT NULL, UNIQUE KEY `post_id_pic_id` (`post_id`,`pic_id`), KEY `FK_[[dbprefix]]mod_news_img_posts_img_[[dbprefix]]mod_news_img_img` (`pic_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_news_img_settings` -- CREATE TABLE `[[dbprefix]]mod_news_img_settings` ( `section_id` int(11) NOT NULL DEFAULT '0', `header` text NOT NULL, `post_loop` text NOT NULL, `view_order` int(11) NOT NULL DEFAULT '0', `footer` text NOT NULL, `block2` text NOT NULL, `posts_per_page` int(11) NOT NULL DEFAULT '0', `post_header` text NOT NULL, `post_content` text NOT NULL, `image_loop` text NOT NULL, `post_footer` text NOT NULL, `resize_preview` varchar(50) DEFAULT NULL, `crop_preview` char(1) NOT NULL DEFAULT 'N', `gallery` text NOT NULL, `imgthumbsize` varchar(50) DEFAULT NULL, `imgmaxwidth` varchar(50) DEFAULT NULL, `imgmaxheight` varchar(50) DEFAULT NULL, `imgmaxsize` varchar(50) DEFAULT NULL, `use_second_block` char(1) NOT NULL DEFAULT 'N', `view` varchar(50) NOT NULL DEFAULT 'default', `mode` varchar(50) DEFAULT 'default', `show_settings_only_admins` char(1) NOT NULL DEFAULT 'N', PRIMARY KEY (`section_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]mod_news_img_settings` -- INSERT INTO `[[dbprefix]]mod_news_img_settings` VALUES (0, '', '', 0, '', '', 0, '', '', '', '', NULL, 'N', '', NULL, NULL, NULL, NULL, 'N', 'default', 'default', 'N'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_news_img_tags` -- CREATE TABLE `[[dbprefix]]mod_news_img_tags` ( `tag_id` int(11) NOT NULL AUTO_INCREMENT, `tag` varchar(255) NOT NULL, `tag_color` varchar(7) DEFAULT NULL, PRIMARY KEY (`tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_news_img_tags_posts` -- CREATE TABLE `[[dbprefix]]mod_news_img_tags_posts` ( `post_id` int(11) NOT NULL, `tag_id` int(11) NOT NULL, UNIQUE KEY `post_id_tag_id` (`post_id`,`tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_news_img_tags_sections` -- CREATE TABLE `[[dbprefix]]mod_news_img_tags_sections` ( `section_id` int(11) unsigned NOT NULL DEFAULT '0', `tag_id` int(11) unsigned NOT NULL, UNIQUE KEY `section_id_tag_id` (`section_id`,`tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_outputfilter_dashboard` -- CREATE TABLE `[[dbprefix]]mod_outputfilter_dashboard` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userfunc` tinyint(4) NOT NULL DEFAULT '0', `position` int(11) NOT NULL DEFAULT '0', `active` tinyint(4) NOT NULL DEFAULT '1', `allowedit` tinyint(4) NOT NULL DEFAULT '0', `allowedittarget` tinyint(4) NOT NULL DEFAULT '0', `name` varchar(249) NOT NULL, `func` text NOT NULL, `type` varchar(255) NOT NULL, `file` varchar(255) NOT NULL, `csspath` varchar(255) NOT NULL, `funcname` varchar(255) NOT NULL, `configurl` varchar(255) NOT NULL, `plugin` varchar(255) NOT NULL, `helppath` text NOT NULL, `modules` text NOT NULL, `desc` longtext NOT NULL, `pages` text NOT NULL, `pages_parent` text NOT NULL, `additional_values` longtext NOT NULL, `additional_fields` text NOT NULL, `additional_fields_languages` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `type` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; -- -- Dumping data for table `[[dbprefix]]mod_outputfilter_dashboard` -- INSERT INTO `[[dbprefix]]mod_outputfilter_dashboard` VALUES (1, 0, 0, 1, 1, 1, 'Colorbox', '', '6page_first', '{OPF:PLUGIN_PATH}/filter.php', '', 'opff_jq_colorbox', '', 'opf_jq_colorbox', 'a:2:{s:2:"EN";s:29:"{OPF:PLUGIN_URL}/help/EN.html";s:2:"DE";s:29:"{OPF:PLUGIN_URL}/help/DE.html";}', 'a:0:{}', 'a:2:{s:2:"EN";s:220:"Use class=colorbox, iframe, youtube, cslide, cfade or csingle as additional CSS class to open a link in a modal window. 5 different styles available via filter config. See http://www.jacklmoore.com/colorbox/ for details.";s:2:"DE";s:255:"Verwende class=colorbox, iframe, youtube, cslide, cfade or csingle als zusätzliche CSS-Klasse, um einen Link in einem Overlay zu öffnen. 5 verschiedene Styles per Filterkonfiguration auswählbar. Besuche http://www.jacklmoore.com/colorbox/ für Details.";}', 'a:1:{i:0;s:3:"all";}', 'a:1:{i:0;s:3:"all";}', 'a:2:{s:6:"places";s:4:"body";s:9:"cb_design";s:1:"1";}', 'a:2:{i:0;a:6:{s:4:"text";s:17:"Write js files to";s:8:"variable";s:6:"places";s:4:"type";s:6:"select";s:4:"name";s:5:"where";s:7:"checked";s:4:"body";s:5:"value";a:2:{s:4:"head";s:4:"Head";s:4:"body";s:4:"Body";}}i:1;a:6:{s:4:"text";s:21:"ColorBox Design Theme";s:8:"variable";s:9:"cb_design";s:4:"type";s:6:"select";s:4:"name";s:6:"design";s:7:"checked";s:1:"1";s:5:"value";a:6:{i:1;s:1:"1";i:2;s:1:"2";i:3;s:1:"3";i:4;s:1:"4";i:5;s:1:"5";s:6:"custom";s:6:"custom";}}}', 's:0:"";'), (2, 0, 0, 1, 0, 1, 'Cache Control', '', '8page_last', '{OPF:PLUGIN_PATH}/filter.php', '', 'opff_cachecontrol', '', 'cachecontrol', 'a:0:{}', 'a:0:{}', 'a:2:{s:2:"EN";s:182:"Prevent Browsers from delivering outdated files (css, js) from its cache by adding the timestamp of the files to their URLs as a parameter.\nMake sure that this filter is called last!";s:2:"DE";s:220:"Verhindert, dass Browser veraltete CSS- oder JS-Dateien aus ihrem Cache ausliefern, indem der Datei-Timestamp an deren URLs als Parameter angefügt wird.\nAchten Sie darauf, dass dieser Filter als letzter aufgerufen wird!";}', 'a:1:{i:0;s:3:"all";}', 'a:3:{i:0;s:3:"all";i:1;s:7:"backend";i:2;s:1:"0";}', 's:0:"";', 's:0:"";', 's:0:"";'), (3, 0, 0, 1, 0, 1, 'Droplets Injector', '', '7page', '{SYSVAR:WB_PATH}/modules/droplets/opf_filter_droplets.php', '', 'opff_droplets', '', '', 'a:1:{s:2:"EN";s:71:"(link){SYSVAR:ADMIN_URL}/admintools/tool.php?tool=droplets&do=show_help";}', 'a:0:{}', 'a:2:{s:2:"EN";s:162:"This filter is working in conjunction with the Droplets AdminTool to inject Droplets PHP code at places where Droplet calls are located. (See HELP for more info).";s:2:"DE";s:182:"Dieser Filter arbeitet mit dem Droplets AdminTool zusammen, indem er den PHP-Code aus Droplets an Stellen einzufügt wo Droplet-Aufrufe platziert sind. (Siehe HILFE für mehr Infos).";}', 'a:1:{i:0;s:3:"all";}', 'a:3:{i:0;s:3:"all";i:1;s:8:" backend";i:2;s:2:" 0";}', 's:0:"";', 's:0:"";', 's:0:"";'), (4, 0, 0, 1, 0, 1, 'Remove System PH', '', '9page_final', '{SYSVAR:WB_PATH}/modules/mod_opf_remove_system_ph/filter.php', '', 'opff_mod_opf_remove_system_ph', '', '', 'a:0:{}', 'a:0:{}', 'a:2:{s:2:"EN";s:109:"remove system placeholder markers (HTML comments as hooks) from the sourcecode of the finally generated page.";s:2:"DE";s:107:"Entfernt die System-Platzhalter (HTML-Kommentare als Hooks) aus dem Quellcode der fertig generierten Seite.";}', 'a:1:{i:0;s:3:"all";}', 'a:3:{i:0;s:3:"all";i:1;s:7:"backend";i:2;s:1:"0";}', 's:0:"";', 's:0:"";', 's:0:"";'), (5, 0, 1, 1, 0, 1, 'Internal Link Replacer', '', '7page', '{SYSVAR:WB_PATH}/modules/mod_opf_wblink/filter.php', '', 'opff_mod_opf_wblink', '', '', 'a:0:{}', 'a:0:{}', 'a:2:{s:2:"EN";s:148:"When this filter is active, internal links can be set with the shortcode [wblinkXX] as URL (i.e. [wblink12] = URL of the page with the page-ID 12).";s:2:"DE";s:151:"Ist dieser Filter aktiviert, können Adressen von internen Seiten als [wblinkXX] angegeben werden (z.B. [wblink12] = URL der seite mit der Page-ID 12).";}', 'a:1:{i:0;s:3:"all";}', 'a:2:{i:0;s:3:"all";i:1;s:1:"0";}', 's:0:"";', 's:0:"";', 's:0:"";'), (6, 0, 2, 1, 0, 1, 'Replace Contents', '', '8page_last', '{SYSVAR:WB_PATH}/modules/mod_opf_replace_stuff/filter.php', '', 'opff_mod_opf_replace_stuff', '', '', 'a:0:{}', 'a:0:{}', 'a:2:{s:2:"EN";s:140:"This filter is needed to replace content or code. See https://help.wbce.org/pages/de/module-programmieren/platzhalter-hooks.php for details.";s:2:"DE";s:132:"Ersetzt entsprechend markierten Code. Siehe https://help.wbce.org/pages/de/module-programmieren/platzhalter-hooks.php für Details.";}', 'a:1:{i:0;s:3:"all";}', 'a:3:{i:0;s:3:"all";i:1;s:7:"backend";i:2;s:1:"0";}', 's:0:"";', 's:0:"";', 's:0:"";'), (7, 0, 2, 1, 0, 1, 'E-Mail Masking', '', '7page', '{SYSVAR:WB_PATH}/modules/mod_opf_email/filter.php', '', 'opff_mod_opf_email', '[[softurl]]/admin/admintools/tool.php?tool=mod_opf_email', '', 'a:0:{}', 'a:0:{}', 'a:2:{s:2:"EN";s:155:"Hides e-mail addresses from spambots by masking them with JavaScript and replacing . and @ by (dot) and (at). Can be configured via backend (see cog icon).";s:2:"DE";s:208:"Versteckt E-Mail-Adressen vor Spambots, indem diese mit Javascript maskiert werden und die Zeichen . und @ durch (dot) und (at) ersetzt werden. Kann über das Backend konfiguriert werden (siehe Zahnrad-Icon).";}', 'a:1:{i:0;s:3:"all";}', 'a:2:{i:0;s:3:"all";i:1;s:1:"0";}', 's:0:"";', 's:0:"";', 's:0:"";'), (8, 0, 1, 1, 0, 1, 'Move Contents', '', '8page_last', '{SYSVAR:WB_PATH}/modules/mod_opf_move_stuff/filter.php', '', 'opff_mod_opf_move_stuff', '', '', 'a:0:{}', 'a:0:{}', 'a:2:{s:2:"EN";s:154:"This filter is needed to move content or code to defined hooks. See https://help.wbce.org/pages/de/module-programmieren/platzhalter-hooks.php for details.";s:2:"DE";s:145:"Verschiebt Code an die dafür vorgesehenen Stellen. Siehe https://help.wbce.org/pages/de/module-programmieren/platzhalter-hooks.php für Details.";}', 'a:1:{i:0;s:3:"all";}', 'a:3:{i:0;s:3:"all";i:1;s:7:"backend";i:2;s:1:"0";}', 's:0:"";', 's:0:"";', 's:0:"";'), (9, 0, 1, 1, 0, 1, 'Auto Placeholder', '', '6page_first', '{SYSVAR:WB_PATH}/modules/mod_opf_auto_placeholder/filter.php', '', 'opff_mod_opf_auto_placeholder', '', '', 'a:0:{}', 'a:0:{}', 'a:2:{s:2:"EN";s:189:"This filter adds placeholders (hooks) which can be used for code replacements or inserts. See https://help.wbce.org/pages/de/module-programmieren/platzhalter-hooks.php for more information.";s:2:"DE";s:221:"Dieser Filter fügt Platzhalter (Hooks) ein, die für Code-Ersetzungen oder -Ergänzungen genutzt werden können. Siehe https://help.wbce.org/pages/de/module-programmieren/platzhalter-hooks.php für weitere Informationen.";}', 'a:1:{i:0;s:3:"all";}', 'a:3:{i:0;s:3:"all";i:1;s:7:"backend";i:2;s:1:"0";}', 's:0:"";', 's:0:"";', 's:0:"";'), (10, 0, 3, 1, 0, 1, 'Class Insert Helper', '', '8page_last', '{SYSVAR:WB_PATH}/modules/mod_opf_insert/filter.php', '', 'opff_mod_opf_insert', '', '', 'a:0:{}', 'a:0:{}', 'a:2:{s:2:"EN";s:117:"This filter works in conjunction with Class Insert. Detail instructions will follow in a later iteration of WBCE CMS.";s:2:"DE";s:135:"Dieser Filter arbeitet mit der Klasse Insert zusammen. Detailierte Beschreibungen folgen in einer der nächsten Versionen von WBCE CMS.";}', 'a:1:{i:0;s:3:"all";}', 'a:3:{i:0;s:3:"all";i:1;s:7:"backend";i:2;s:1:"0";}', 's:0:"";', 's:0:"";', 's:0:"";'), (11, 0, 3, 1, 0, 1, 'CSS to head', '', '7page', '{SYSVAR:WB_PATH}/modules/mod_opf_csstohead/filter.php', '', 'opff_mod_opf_csstohead', '', '', 'a:0:{}', 'a:0:{}', 'a:2:{s:2:"EN";s:60:"moves css definitions from the body of a page into the head.";s:2:"DE";s:72:"Verschiebt CSS-Definitionen und -Links vom body in den head einer Seite.";}', 'a:1:{i:0;s:3:"all";}', 'a:2:{i:0;s:3:"all";i:1;s:1:"0";}', 's:0:"";', 's:0:"";', 's:0:"";'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_page_seo_tool` -- CREATE TABLE `[[dbprefix]]mod_page_seo_tool` ( `settings_json` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]mod_page_seo_tool` -- INSERT INTO `[[dbprefix]]mod_page_seo_tool` VALUES ('{"iTitleCount":{"use":true,"optimum":50,"minimum":30},"iDescriptionCount":{"use":true,"optimum":150,"minimum":90},"keywordsConfig":{"use":true,"wordReplace":"keywords"},"rewriteUrl":{"use":false,"dbString":""},"bUseRemainingChars":true}'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_sitemap` -- CREATE TABLE `[[dbprefix]]mod_sitemap` ( `section_id` int(11) NOT NULL DEFAULT '0', `page_id` int(11) NOT NULL DEFAULT '0', `header` text NOT NULL, `sitemaploop` text NOT NULL, `footer` text NOT NULL, `level_header` text NOT NULL, `level_footer` text NOT NULL, `static` int(11) NOT NULL DEFAULT '0', `startatroot` int(11) NOT NULL DEFAULT '0', `depth` int(11) NOT NULL DEFAULT '0', `show_hidden` int(11) NOT NULL DEFAULT '0', `show_settings` int(1) NOT NULL DEFAULT '1', `menus` varchar(30) NOT NULL DEFAULT '0', `layout` varchar(128) NOT NULL DEFAULT '0', PRIMARY KEY (`section_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_browser` -- CREATE TABLE `[[dbprefix]]mod_wbstats_browser` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` varchar(8) NOT NULL DEFAULT '', `agent` varchar(200) NOT NULL DEFAULT '', `browser` varchar(50) NOT NULL DEFAULT '', `version` varchar(50) NOT NULL DEFAULT '', `os` varchar(100) NOT NULL DEFAULT '', `view` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `browser_version` (`browser`,`version`), KEY `os` (`os`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_cfg` -- CREATE TABLE `[[dbprefix]]mod_wbstats_cfg` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(50) NOT NULL DEFAULT 'none', `name` varchar(50) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_day` -- CREATE TABLE `[[dbprefix]]mod_wbstats_day` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` varchar(8) NOT NULL DEFAULT '', `user` int(10) NOT NULL DEFAULT '0', `view` int(10) NOT NULL DEFAULT '0', `bots` int(10) NOT NULL DEFAULT '0', `suspected` int(10) NOT NULL DEFAULT '0', `refspam` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `day` (`day`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_hist` -- CREATE TABLE `[[dbprefix]]mod_wbstats_hist` ( `id` int(11) NOT NULL AUTO_INCREMENT, `timestamp` int(11) NOT NULL DEFAULT '0', `ip` varchar(50) NOT NULL DEFAULT '', `session` varchar(64) NOT NULL DEFAULT '', `page` varchar(255) NOT NULL DEFAULT '', `status` varchar(10) NOT NULL DEFAULT '', PRIMARY KEY USING BTREE (`id`), KEY `ip` (`ip`,`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_ips` -- CREATE TABLE `[[dbprefix]]mod_wbstats_ips` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(50) DEFAULT NULL, `session` varchar(64) NOT NULL DEFAULT '', `time` int(20) NOT NULL DEFAULT '0', `online` int(20) NOT NULL DEFAULT '0', `page` varchar(255) NOT NULL DEFAULT '', `last_page` varchar(512) NOT NULL DEFAULT '', `last_status` varchar(10) NOT NULL DEFAULT '', `pages` int(11) NOT NULL DEFAULT '0', `loggedin` int(1) NOT NULL DEFAULT '0', `location` varchar(64) NOT NULL DEFAULT '', `country` varchar(64) NOT NULL DEFAULT '', `browser` varchar(32) NOT NULL DEFAULT '', `os` varchar(32) NOT NULL DEFAULT '', `language` varchar(32) NOT NULL DEFAULT '', `referer` varchar(64) NOT NULL DEFAULT '', `ua` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `time` (`time`), KEY `online` (`online`), KEY `ip` (`ip`,`online`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_keywords` -- CREATE TABLE `[[dbprefix]]mod_wbstats_keywords` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` varchar(8) NOT NULL DEFAULT '', `keyword` varchar(255) NOT NULL DEFAULT '', `view` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_lang` -- CREATE TABLE `[[dbprefix]]mod_wbstats_lang` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` varchar(8) NOT NULL DEFAULT '', `language` varchar(2) NOT NULL DEFAULT '', `view` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_loc` -- CREATE TABLE `[[dbprefix]]mod_wbstats_loc` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(50) NOT NULL DEFAULT '', `location` varchar(128) NOT NULL DEFAULT '', `city` varchar(64) NOT NULL DEFAULT '', `country` varchar(64) NOT NULL DEFAULT '', `country_code` varchar(64) NOT NULL DEFAULT '', `timezone` varchar(64) NOT NULL DEFAULT '', `latitude` varchar(12) NOT NULL DEFAULT '', `longitude` varchar(12) NOT NULL DEFAULT '', `timestamp` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `ip` (`ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_pages` -- CREATE TABLE `[[dbprefix]]mod_wbstats_pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` varchar(8) NOT NULL DEFAULT '', `page` varchar(255) NOT NULL DEFAULT '', `view` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_ref` -- CREATE TABLE `[[dbprefix]]mod_wbstats_ref` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` varchar(8) NOT NULL DEFAULT '', `referer` varchar(255) NOT NULL DEFAULT '', `view` int(10) NOT NULL DEFAULT '0', `spam` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_shop` -- CREATE TABLE `[[dbprefix]]mod_wbstats_shop` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `shoptype` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `invoice_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `timestamp` int(11) NOT NULL DEFAULT '0', `order_total` decimal(12,2) NOT NULL DEFAULT '0.00', `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `payment_method` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `order_data` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci, PRIMARY KEY USING BTREE (`id`), KEY `order_id` USING BTREE (`order_id`), KEY `timestamp` USING BTREE (`timestamp`), KEY `ip` USING BTREE (`ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]mod_wbstats_utm` -- CREATE TABLE `[[dbprefix]]mod_wbstats_utm` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(50) NOT NULL DEFAULT '', `session` varchar(64) NOT NULL DEFAULT '', `page` varchar(255) NOT NULL DEFAULT '', `source` varchar(128) NOT NULL DEFAULT '', `medium` varchar(128) NOT NULL DEFAULT '', `campaign` varchar(128) NOT NULL DEFAULT '', `term` varchar(128) NOT NULL DEFAULT '', `content` varchar(128) NOT NULL DEFAULT '', `referer` varchar(255) NOT NULL DEFAULT '', `timestamp` int(11) NOT NULL DEFAULT '0', `pagecount` int(11) NOT NULL DEFAULT '0', `day` varchar(8) NOT NULL DEFAULT '', PRIMARY KEY USING BTREE (`id`), KEY `campaign` USING BTREE (`campaign`), KEY `day` USING BTREE (`day`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 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` text COLLATE utf8_unicode_ci NOT NULL, `height` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`section_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_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 utf8_unicode_ci NOT NULL, `text` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`section_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_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 COLLATE utf8_unicode_ci NOT NULL, `target` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `menu_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` text COLLATE utf8_unicode_ci NOT NULL, `keywords` text COLLATE utf8_unicode_ci NOT NULL, `page_trail` text COLLATE utf8_unicode_ci NOT NULL, `template` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `visibility` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `visibility_backup` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `position` int(11) NOT NULL DEFAULT '0', `menu` int(11) NOT NULL DEFAULT '0', `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `searching` int(11) NOT NULL DEFAULT '0', `admin_groups` text COLLATE utf8_unicode_ci NOT NULL, `admin_users` text COLLATE utf8_unicode_ci NOT NULL, `viewing_groups` text COLLATE utf8_unicode_ci NOT NULL, `viewing_users` text COLLATE utf8_unicode_ci NOT NULL, `modified_when` int(11) NOT NULL DEFAULT '0', `modified_by` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`page_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` text COLLATE utf8_unicode_ci NOT NULL, `extra` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`search_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ; -- -- Dumping data for table `[[dbprefix]]search` -- INSERT INTO `[[dbprefix]]search` VALUES (1, 'header', '
\n\n\n  
\n[TEXT_ALL_WORDS]  \n[TEXT_ANY_WORDS]  \n[TEXT_EXACT_MATCH]\n\n
\n\n

---

', ''), (2, 'footer', '', ''), (3, 'results_header', '[TEXT_RESULTS_FOR] ''[SEARCH_STRING]'':\n

', ''), (4, 'results_loop', '

[TITLE]

\n

[DESCRIPTION]

\n[EXCERPT]

', ''), (5, 'results_footer', '

', ''), (6, 'no_results', '

[TEXT_NO_RESULTS]

', ''), (7, 'module_order', 'wysiwyg,news_img', ''), (8, 'max_excerpt', '15', ''), (9, 'time_limit', '0', ''), (10, 'cfg_enable_old_search', 'false', ''), (11, 'cfg_search_keywords', 'true', ''), (12, 'cfg_search_description', 'true', ''), (13, 'cfg_show_description', 'true', ''), (14, 'cfg_enable_flush', 'false', ''), (15, 'template', '', ''), (16, 'module', 'news_img', 'a:6:{s:7:"page_id";s:7:"page_id";s:5:"title";s:10:"page_title";s:4:"link";s:4:"link";s:11:"description";s:11:"description";s:13:"modified_when";s:13:"modified_when";s:11:"modified_by";s:11:"modified_by";}'), (17, 'query_start', 'SELECT [TP]pages.page_id, [TP]pages.page_title, [TP]pages.link, [TP]pages.description, [TP]pages.modified_when, [TP]pages.modified_by FROM [TP]mod_news_img_posts, [TP]mod_news_img_groups, [TP]mod_news_img_settings, [TP]pages WHERE ', 'news_img'), (18, 'query_body', '\n [TP]pages.page_id = [TP]mod_news_img_posts.page_id AND [TP]mod_news_img_posts.title LIKE ''%[STRING]%''\n OR [TP]pages.page_id = [TP]mod_news_img_posts.page_id AND [TP]mod_news_img_posts.content_short LIKE ''%[STRING]%''\n OR [TP]pages.page_id = [TP]mod_news_img_posts.page_id AND [TP]mod_news_img_posts.content_long LIKE ''%[STRING]%''\n OR [TP]pages.page_id = [TP]mod_news_img_posts.page_id AND [TP]mod_news_img_posts.content_block2 LIKE ''%[STRING]%''\n OR [TP]pages.page_id = [TP]mod_news_img_settings.page_id AND [TP]mod_news_img_settings.header LIKE ''%[STRING]%''\n OR [TP]pages.page_id = [TP]mod_news_img_settings.page_id AND [TP]mod_news_img_settings.footer LIKE ''%[STRING]%''\n OR [TP]pages.page_id = [TP]mod_news_img_settings.page_id AND [TP]mod_news_img_settings.post_header LIKE ''%[STRING]%''\n OR [TP]pages.page_id = [TP]mod_news_img_settings.page_id AND [TP]mod_news_img_settings.post_footer LIKE ''%[STRING]%''', 'news_img'), (19, 'query_end', '', 'news_img'); -- -------------------------------------------------------- -- -- 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(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `block` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `publ_start` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `publ_end` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `namesection` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`section_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]settings` -- CREATE TABLE `[[dbprefix]]settings` ( `setting_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`setting_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=104 ; -- -- Dumping data for table `[[dbprefix]]settings` -- INSERT INTO `[[dbprefix]]settings` VALUES (1, 'website_description', ''), (2, 'website_keywords', ''), (3, 'website_header', ''), (4, 'website_footer', ''), (5, 'wysiwyg_style', 'font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;'), (6, 'er_level', 'E0'), (7, 'sec_anchor', 'wbce_'), (8, 'default_date_format', 'd.m.Y'), (9, 'default_time_format', 'H:i'), (10, 'redirect_timer', '500'), (11, 'home_folders', 'true'), (12, 'warn_page_leave', '1'), (13, 'default_template', 'wbcezon'), (14, 'default_theme', 'wbce_flat_theme'), (15, 'default_charset', 'utf-8'), (16, 'multiple_menus', 'true'), (17, 'page_level_limit', '4'), (18, 'intro_page', 'false'), (19, 'page_trash', 'inline'), (20, 'homepage_redirection', 'false'), (21, 'page_languages', 'false'), (22, 'wysiwyg_editor', 'ckeditor'), (23, 'manage_sections', 'true'), (24, 'section_blocks', 'true'), (25, 'smart_login', 'true'), (26, 'frontend_login', 'false'), (27, 'frontend_signup', 'false'), (28, 'search', 'public'), (29, 'page_extension', '.php'), (30, 'page_spacer', '-'), (31, 'pages_directory', '/pages'), (32, 'rename_files_on_upload', 'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js,lnk,inc,tpl'), (33, 'media_directory', '/media'), (34, 'wbmailer_routine', 'phpmail'), (35, 'wbmailer_default_sendername', 'WBCE CMS Mailer'), (36, 'wbmailer_smtp_host', ''), (37, 'wbmailer_smtp_auth', ''), (38, 'wbmailer_smtp_username', ''), (39, 'wbmailer_smtp_password', ''), (40, 'wbmailer_smtp_secure', ''), (41, 'wbmailer_smtp_port', ''), (42, 'fingerprint_with_ip_octets', '2'), (43, 'mediasettings', ''), (44, 'wbce_version', '1.6.8'), (45, 'wbce_tag', '1.6.8'), (46, 'wb_version', '2.8.3'), (47, 'wb_revision', '1641'), (48, 'wb_sp', 'SP4'), (49, 'website_title', '[[site_name]]'), (50, 'default_language', '[[language]]'), (51, 'app_name', '[[app_name]]'), (52, 'default_timezone', '-14400'), (53, 'operating_system', 'linux'), (54, 'string_file_mode', '[[file_mode]]'), (55, 'string_dir_mode', '[[dir_mode]]'), (56, 'server_email', '[[admin_email]]'), (57, 'opf_colorbox', '1'), (58, 'opf_colorbox_be', 'bfalseb'), (59, 'opf_cache_control', '1'), (60, 'opf_droplets', '1'), (61, 'opf_auto_placeholder', '1'), (62, 'opf_move_stuff', '1'), (63, 'opf_replace_stuff', '1'), (64, 'opf_css_to_head', '1'), (65, 'opf_wblink', '1'), (66, 'opf_short_url', '0'), (67, 'opf_sys_rel', '0'), (68, 'opf_remove_system_ph', '1'), (69, 'opf_droplets_be', '1'), (70, 'opf_auto_placeholder_be', '1'), (71, 'opf_move_stuff_be', '1'), (72, 'opf_replace_stuff_be', '1'), (73, 'opf_css_to_head_be', '0'), (74, 'opf_remove_system_ph_be', '1'), (75, 'opf_droplets_injector', '1'), (76, 'wb_maintainance_mode', 'bfalseb'), (77, 'opf_internal_link_replacer', '1'), (78, 'opf_replace_contents', '1'), (79, 'cmc_cfg', 'a:3:{s:5:"theme";s:8:"wbce-day";s:4:"font";s:6:"Proggy";s:9:"font_size";s:2:"14";}'), (80, 'opf_email_filter', '1'), (81, 'opf_mailto_filter', '1'), (82, 'opf_js_mailto', '1'), (83, 'opf_at_replacement', '(at)'), (84, 'opf_dot_replacement', '(dot)'), (85, 'opf_email', '1'), (86, 'opf_email_masking', '1'), (87, 'enabled_captcha', 'btrueb'), (88, 'enabled_asp', 'btrueb'), (89, 'captcha_type', 'calc_text'), (90, 'asp_session_min_age', '20'), (91, 'asp_view_min_age', '10'), (92, 'asp_input_min_age', '5'), (93, 'ct_text', ''), (94, 'opf_move_contents', '1'), (95, 'wb_secform_secret', '5609bnefg93jmgi99igjefg'), (96, 'wb_secform_secrettime', '86400'), (97, 'wb_secform_timeout', '7200'), (98, 'wb_session_timeout', '7200'), (99, 'wb_secform_tokenname', 'formtoken'), (100, 'wb_secform_usefp', 'bfalseb'), (101, 'opf_insert', '1'), (102, 'opf_insert_be', '1'), (103, 'opf_class_insert_helper', '1'); -- -------------------------------------------------------- -- -- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `display_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'DE', `email` text COLLATE utf8_unicode_ci NOT NULL, `signup_checksum` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `active` int(11) NOT NULL DEFAULT '0', `gdpr_check` int(1) NOT NULL DEFAULT '0', `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `remember_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `last_reset` int(11) NOT NULL DEFAULT '0', `timezone` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `date_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `time_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `home_folder` text COLLATE utf8_unicode_ci NOT NULL, `login_when` int(11) NOT NULL DEFAULT '0', `login_ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `signup_timestamp` int(11) NOT NULL DEFAULT '0', `signup_timeout` int(11) NOT NULL DEFAULT '0', `signup_confirmcode` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]users` -- INSERT INTO `[[dbprefix]]users` VALUES (1, 1, '1', '[[admin_username]]', '[[admin_realname]]', '[[language]]', '[[admin_email]]', '[[regtime]]', 1, 0, '[[admin_pass]]', '', 0, '-14400', '', '', '', 0, '', [[timestamp]], 0, 'install-script'); -- -- Constraints for dumped tables -- -- -- Constraints for table `[[dbprefix]]mod_news_img_posts_img` -- ALTER TABLE `[[dbprefix]]mod_news_img_posts_img` ADD CONSTRAINT `FK_[[dbprefix]]mod_news_img_posts_img_[[dbprefix]]mod_news_img_img` FOREIGN KEY (`pic_id`) REFERENCES `[[dbprefix]]mod_news_img_img` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `FK_[[dbprefix]]mod_news_img_posts_img_[[dbprefix]]mod_news_img_posts` FOREIGN KEY (`post_id`) REFERENCES `[[dbprefix]]mod_news_img_posts` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE; /*!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 */;