php

File Content: `e107.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: `e107233`
--

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

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

CREATE TABLE `[[dbprefix]]admin_log` (
  `dblog_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dblog_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `dblog_microtime` int(10) unsigned NOT NULL DEFAULT '0',
  `dblog_type` tinyint(3) NOT NULL DEFAULT '0',
  `dblog_eventcode` varchar(10) NOT NULL DEFAULT '',
  `dblog_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `dblog_ip` varchar(45) NOT NULL DEFAULT '',
  `dblog_title` varchar(255) NOT NULL DEFAULT '',
  `dblog_remarks` text NOT NULL,
  PRIMARY KEY (`dblog_id`),
  KEY `dblog_datestamp` (`dblog_datestamp`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

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

CREATE TABLE `[[dbprefix]]audit_log` (
  `dblog_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dblog_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `dblog_microtime` int(10) unsigned NOT NULL DEFAULT '0',
  `dblog_eventcode` varchar(10) NOT NULL DEFAULT '',
  `dblog_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `dblog_user_name` varchar(100) NOT NULL DEFAULT '',
  `dblog_ip` varchar(45) NOT NULL DEFAULT '',
  `dblog_title` varchar(255) NOT NULL DEFAULT '',
  `dblog_remarks` text NOT NULL,
  PRIMARY KEY (`dblog_id`),
  KEY `dblog_datestamp` (`dblog_datestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]banlist` (
  `banlist_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `banlist_ip` varchar(100) NOT NULL DEFAULT '',
  `banlist_bantype` tinyint(3) NOT NULL DEFAULT '0',
  `banlist_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `banlist_banexpires` int(10) unsigned NOT NULL DEFAULT '0',
  `banlist_admin` smallint(5) unsigned NOT NULL DEFAULT '0',
  `banlist_reason` tinytext NOT NULL,
  `banlist_notes` tinytext NOT NULL,
  PRIMARY KEY (`banlist_id`),
  KEY `banlist_ip` (`banlist_ip`),
  KEY `banlist_datestamp` (`banlist_datestamp`),
  KEY `banlist_banexpires` (`banlist_banexpires`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]comments` (
  `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `comment_pid` int(10) unsigned NOT NULL DEFAULT '0',
  `comment_item_id` int(10) unsigned NOT NULL DEFAULT '0',
  `comment_subject` varchar(100) NOT NULL DEFAULT '',
  `comment_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `comment_author_name` varchar(100) NOT NULL DEFAULT '',
  `comment_author_email` varchar(200) NOT NULL DEFAULT '',
  `comment_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `comment_comment` text NOT NULL,
  `comment_blocked` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `comment_ip` varchar(45) NOT NULL DEFAULT '',
  `comment_type` varchar(20) NOT NULL DEFAULT '0',
  `comment_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `comment_share` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_id`),
  KEY `comment_blocked` (`comment_blocked`),
  KEY `comment_author_id` (`comment_author_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]core` (
  `e107_name` varchar(100) NOT NULL DEFAULT '',
  `e107_value` text NOT NULL,
  PRIMARY KEY (`e107_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `[[dbprefix]]core` VALUES
('SitePrefs', 'array (\n  ''admin_alerts_ok'' => ''1'',\n  ''admin_alerts_uniquemenu'' => ''0'',\n  ''admin_separate_plugins'' => ''0'',\n  ''admin_collapse_sidebar'' => ''0'',\n  ''admin_navbar_labels'' => ''0'',\n  ''admin_helptip'' => ''1'',\n  ''admincode'' => ''0'',\n  ''admincss'' => ''css/modern-dark.css'',\n  ''adminlanguage'' => '''',\n  ''adminpwordchange'' => ''0'',\n  ''adminstyle'' => ''flexpanel'',\n  ''admintheme'' => ''bootstrap3'',\n  ''allowCommentEdit'' => ''0'',\n  ''allowEmailLogin'' => ''2'',\n  ''anon_post'' => ''0'',\n  ''antiflood1'' => ''1'',\n  ''antiflood_timeout'' => ''10'',\n  ''auth_method'' => '''',\n  ''autoban'' => ''1'',\n  ''autologinpostsignup'' => ''1'',\n  ''ban_date_format'' => ''%H:%M %d-%m-%y'',\n  ''ban_max_online_access'' => ''100,200'',\n  ''ban_retrigger'' => ''0'',\n  ''cachestatus'' => '''',\n  ''check_updates'' => ''1'',\n  ''comments_disabled'' => ''0'',\n  ''comments_emoticons'' => ''0'',\n  ''comments_engine'' => ''e107'',\n  ''comments_icon'' => ''0'',\n  ''comments_moderate'' => ''247'',\n  ''comments_sort'' => ''desc'',\n  ''compress_output'' => ''0'',\n  ''contact_info'' => \n  array (\n    ''organization'' => ''My Company Inc.'',\n    ''address'' => ''312 Address St.\nLas Vegas, NV,\nUSA'',\n    ''phone1'' => ''+1-555-555-5555'',\n    ''phone2'' => ''+1-444-444-4444'',\n    ''phone3'' => '''',\n    ''fax'' => '''',\n    ''email1'' => '''',\n    ''email2'' => '''',\n    ''coordinates'' => '''',\n    ''hours'' => '''',\n    ''message'' => '''',\n  ),\n  ''contact_emailcopy'' => ''0'',\n  ''contact_visibility'' => ''253'',\n  ''contact_filter'' => '''',\n  ''cookie_name'' => ''soft_cookie'',\n  ''core-infopanel-default'' => \n  array (\n    0 => ''e-administrator'',\n    1 => ''e-cpage'',\n    2 => ''e-filemanager'',\n    3 => ''e-frontpage'',\n    4 => ''e-image'',\n    5 => ''e-mailout'',\n    6 => ''e-menus'',\n    7 => ''e-meta'',\n    8 => ''e-newspost'',\n    9 => ''e-plugin'',\n    10 => ''e-prefs'',\n    11 => ''e-links'',\n    12 => ''e-theme'',\n    13 => ''e-userclass2'',\n    14 => ''e-users'',\n    15 => ''e-wmessage'',\n  ),\n  ''db_updates'' => \n  array (\n  ),\n  ''developer'' => ''0'',\n  ''disable_emailcheck'' => ''0'',\n  ''disallowMultiLogin'' => ''0'',\n  ''display_memory_usage'' => ''0'',\n  ''displayname_class'' => ''255'',\n  ''displayname_maxlength'' => ''20'',\n  ''displayrendertime'' => ''0'',\n  ''displaysql'' => ''0'',\n  ''displaythemeinfo'' => ''1'',\n  ''e_admin_list'' => \n  array (\n    ''social'' => ''social'',\n  ),\n  ''e_comment_list'' => \n  array (\n    ''social'' => ''social'',\n  ),\n  ''e_event_list'' => \n  array (\n    ''news'' => ''news'',\n    ''social'' => ''social'',\n  ),\n  ''e_featurebox_list'' => \n  array (\n    ''news'' => ''news'',\n  ),\n  ''e_footer_list'' => \n  array (\n    ''tinymce4'' => ''tinymce4'',\n  ),\n  ''e_header_list'' => \n  array (\n    ''gallery'' => ''gallery'',\n    ''hero'' => ''hero'',\n    ''news'' => ''news'',\n    ''tagcloud'' => ''tagcloud'',\n    ''tinymce4'' => ''tinymce4'',\n  ),\n  ''e_jslib_cdn'' => ''1'',\n  ''e_jslib_cdn_provider'' => ''jsdelivr'',\n  ''e_jslib_browser_cache'' => [[timestamp]],\n  ''e_jslib_nobcache'' => ''1'',\n  ''e_jslib_nocache'' => ''1'',\n  ''e_jslib_gzip'' => ''1'',\n  ''e_jslib_nocombine'' => ''1'',\n  ''e_jslib_core'' => \n  array (\n    ''prototype'' => ''none'',\n    ''jquery'' => ''all'',\n  ),\n  ''e_jslib_plugin'' => \n  array (\n  ),\n  ''e_jslib_theme'' => \n  array (\n  ),\n  ''e_meta_list'' => \n  array (\n    ''rss_menu'' => ''rss_menu'',\n  ),\n  ''e_module_list'' => \n  array (\n    ''social'' => ''social'',\n  ),\n  ''e_related_list'' => \n  array (\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n  ),\n  ''e_rss_list'' => \n  array (\n    ''news'' => ''news'',\n  ),\n  ''e_search_list'' => \n  array (\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n    ''user'' => ''user'',\n  ),\n  ''e_shortcode_list'' => \n  array (\n    ''gallery'' => ''gallery'',\n    ''hero'' => ''hero'',\n    ''page'' => ''page'',\n    ''signin'' => ''signin'',\n    ''siteinfo'' => ''siteinfo'',\n    ''social'' => ''social'',\n  ),\n  ''shortcode_list'' => \n  array (\n  ),\n  ''e_sitelink_list'' => \n  array (\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n  ),\n  ''e_sql_list'' => \n  array (\n    ''hero'' => ''hero_sql'',\n    ''rss_menu'' => ''rss_sql'',\n  ),\n  ''e_url_list'' => \n  array (\n    ''contact'' => ''contact'',\n    ''gallery'' => ''gallery'',\n    ''news'' => ''news'',\n    ''rss_menu'' => ''rss_menu'',\n  ),\n  ''e_user_list'' => \n  array (\n    ''user'' => ''user'',\n  ),\n  ''email_text'' => '''',\n  ''email_item_class'' => ''253'',\n  ''emotepack'' => ''default'',\n  ''enable_rdns'' => ''0'',\n  ''enable_rdns_on_ban'' => ''0'',\n  ''failed_login_limit'' => ''10'',\n  ''filter_script'' => ''1'',\n  ''flood_hits'' => ''100'',\n  ''flood_time'' => ''30'',\n  ''flood_timeout'' => ''5'',\n  ''forumdate'' => ''%a %b %d %Y, %I:%M%p'',\n  ''fpwcode'' => ''0'',\n  ''frontpage'' => \n  array (\n    0 => ''index.php'',\n  ),\n  ''frontpage_force'' => \n  array (\n    0 => '''',\n  ),\n  ''gdpr_privacypolicy'' => '''',\n  ''gdpr_termsandconditions'' => '''',\n  ''html_abuse'' => ''1'',\n  ''im_height'' => ''80'',\n  ''im_path'' => ''/usr/X11R6/bin/'',\n  ''im_width'' => ''80'',\n  ''image_post'' => ''1'',\n  ''image_post_class'' => ''0'',\n  ''image_preload'' => ''0'',\n  ''img_import_resize'' => ''1200x800'',\n  ''inline_editing'' => ''255'',\n  ''inputdate'' => ''%A, %d %b, %Y'',\n  ''inputtime'' => ''%I:%M %p'',\n  ''install_date'' => [[timestamp]],\n  ''lan_global_list'' => \n  array (\n    ''gallery'' => ''gallery'',\n    ''hero'' => ''hero'',\n    ''navigation'' => ''navigation'',\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n    ''rss_menu'' => ''rss_menu'',\n    ''social'' => ''social'',\n    ''user'' => ''user'',\n    ''tagcloud'' => ''tagcloud'',\n  ),\n  ''link_replace'' => ''0'',\n  ''link_text'' => '''',\n  ''linkpage_screentip'' => ''0'',\n  ''links_new_window'' => ''1'',\n  ''log_page_accesses'' => ''0'',\n  ''log_refertype'' => ''1'',\n  ''logcode'' => ''0'',\n  ''loginname_maxlength'' => ''30'',\n  ''longdate'' => ''%A %d %B %Y - %H:%M:%S'',\n  ''mail_pause'' => ''3'',\n  ''mail_bounce'' => ''none'',\n  ''mail_pausetime'' => ''4'',\n  ''mail_sendstyle'' => ''texthtml'',\n  ''mail_workpertick'' => ''5'',\n  ''mailer'' => ''php'',\n  ''bulkmailer'' => ''smtp'',\n  ''main_wordwrap'' => '''',\n  ''maintainance_flag'' => ''0'',\n  ''make_clickable'' => ''0'',\n  ''memberlist_access'' => ''253'',\n  ''membersonly_enabled'' => ''0'',\n  ''membersonly_exceptions'' => \n  array (\n    0 => '''',\n  ),\n  ''menu_wordwrap'' => ''0'',\n  ''menuconfig_list'' => \n  array (\n    ''login_menu'' => \n    array (\n      ''name'' => ''Login'',\n      ''link'' => ''login_menu/config.php'',\n    ),\n    ''news'' => \n    array (\n      ''name'' => ''Newsmonths'',\n      ''link'' => ''blogcalendar_menu/config.php'',\n    ),\n  ),\n  ''membersonly_redirect'' => ''login'',\n  ''meta_tag'' => '''',\n  ''multilanguage'' => ''0'',\n  ''nbr_cols'' => ''1'',\n  ''nested_comments'' => ''1'',\n  ''news_cats'' => ''0'',\n  ''news_default_template'' => ''list'',\n  ''news_editauthor'' => ''254'',\n  ''news_list_limit'' => ''10'',\n  ''news_list_templates'' => \n  array (\n    0 => ''0'',\n  ),\n  ''news_newdateheader'' => ''0'',\n  ''news_pagination'' => ''record'',\n  ''newsposts'' => ''10'',\n  ''newsposts_archive'' => ''0'',\n  ''newsposts_archive_title'' => '''',\n  ''noLanguageSubs'' => ''0'',\n  ''null'' => '''',\n  ''old_np'' => ''0'',\n  ''pageCookieExpire'' => ''84600'',\n  ''passwordEncoding'' => 3,\n  ''password_CHAP'' => ''0'',\n  ''plug_installed'' => \n  array (\n    ''news'' => ''1.0'',\n    ''page'' => ''1.0'',\n    ''siteinfo'' => ''1.0'',\n    ''social'' => ''1.0'',\n    ''tinymce4'' => ''1.0'',\n    ''rss_menu'' => ''1.3'',\n    ''contact'' => ''1.0'',\n    ''user'' => ''1.0'',\n    ''navigation'' => ''1.0'',\n    ''signin'' => ''1.0'',\n    ''gallery'' => ''1.1'',\n    ''hero'' => ''1.0'',\n    ''tagcloud'' => ''1.3'',\n  ),\n  ''post_html'' => ''254'',\n  ''post_script'' => ''255'',\n  ''predefinedLoginName'' => '''',\n  ''profanity_filter'' => ''0'',\n  ''profanity_replace'' => ''[censored]'',\n  ''profanity_words'' => '''',\n  ''redirectsiteurl'' => ''0'',\n  ''replyto_email'' => ''[[admin_email]]'',\n  ''replyto_name'' => ''[[admin_realname]]'',\n  ''resize_method'' => ''gd2'',\n  ''resize_dimensions'' => \n  array (\n    ''news-image'' => \n    array (\n      ''w'' => ''300'',\n      ''h'' => ''300'',\n    ),\n    ''news-bbcode'' => \n    array (\n      ''w'' => ''300'',\n      ''h'' => ''300'',\n    ),\n    ''page-bbcode'' => \n    array (\n      ''w'' => ''300'',\n      ''h'' => ''300'',\n    ),\n  ),\n  ''search_highlight'' => ''1'',\n  ''search_restrict'' => ''0'',\n  ''session_lifetime'' => ''86400'',\n  ''session_save_method'' => ''db'',\n  ''shortdate'' => ''%d %b %Y'',\n  ''signcode'' => ''0'',\n  ''signup_disallow_text'' => '''',\n  ''signup_maxip'' => ''3'',\n  ''signup_option_class'' => ''0'',\n  ''signup_option_customtitle'' => ''0'',\n  ''signup_option_email_confirm'' => ''0'',\n  ''signup_option_hideemail'' => ''0'',\n  ''signup_option_image'' => ''0'',\n  ''signup_option_password'' => ''2'',\n  ''signup_option_realname'' => ''0'',\n  ''signup_option_signature'' => ''0'',\n  ''signup_pass_len'' => ''6'',\n  ''signup_text'' => '''',\n  ''signup_text_after'' => '''',\n  ''siteadmin'' => ''[[admin_realname]]'',\n  ''siteadminemail'' => ''[[admin_email]]'',\n  ''sitebutton'' => ''{e_IMAGE}button.png'',\n  ''sitecontacts'' => ''sitecontactinfo'',\n  ''sitedescription'' => '''',\n  ''sitedisclaimer'' => '''',\n  ''sitelang_init'' => ''English'',\n  ''sitelanguage'' => ''English'',\n  ''sitelogo'' => '''',\n  ''sitename'' => ''[[site_name]]'',\n  ''sitetag'' => ''e107 Website System'',\n  ''sitetheme'' => ''bootstrap5'',\n  ''sitetheme_custompages'' => \n  array (\n    ''home'' => \n    array (\n      0 => ''FRONTPAGE'',\n    ),\n    ''full'' => \n    array (\n      0 => ''forum/'',\n      1 => ''download/'',\n    ),\n    ''splash'' => \n    array (\n      0 => ''login'',\n      1 => ''fpw'',\n      2 => ''signup'',\n    ),\n    ''bare'' => \n    array (\n    ),\n  ),\n  ''sitetheme_deflayout'' => ''sidebar_right'',\n  ''sitetheme_layouts'' => \n  array (\n    ''home'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Home Page'',\n      ),\n      ''custompages'' => ''FRONTPAGE'',\n    ),\n    ''full'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Full Page'',\n      ),\n      ''custompages'' => ''forum/ download/'',\n    ),\n    ''sidebar_left'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Sidebar (left)'',\n      ),\n      ''@value'' => '''',\n    ),\n    ''sidebar_right'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Sidebar (right)'',\n        ''default'' => ''true'',\n      ),\n      ''@value'' => '''',\n    ),\n    ''splash'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Splash Page'',\n      ),\n      ''custompages'' => ''login fpw signup'',\n    ),\n    ''bare'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Bare Page'',\n      ),\n      ''custompages'' => '''',\n    ),\n  ),\n  ''sitetheme_pref'' => '''',\n  ''siteurl'' => ''[[relativeurl]]/'',\n  ''smiley_activate'' => ''1'',\n  ''smtp_server'' => '''',\n  ''smtp_username'' => '''',\n  ''smtp_password'' => '''',\n  ''smtp_options'' => '''',\n  ''smtp_port'' => ''25'',\n  ''social_login_active'' => ''0'',\n  ''social_login'' => ''array()'',\n  ''ssl_enabled'' => ''0'',\n  ''subnews_attach'' => ''253'',\n  ''subnews_class'' => ''253'',\n  ''subnews_htmlarea'' => ''0'',\n  ''subnews_resize'' => '''',\n  ''themecss'' => ''https://cdnjs.cloudflare.com/ajax/libs/bootswatch/5.2.3/quartz/bootstrap.min.css'',\n  ''thumbnail_quality'' => ''75'',\n  ''timezone'' => ''UTC'',\n  ''track_online'' => ''1'',\n  ''ue_upgrade'' => ''1'',\n  ''upload_class'' => ''255'',\n  ''upload_enabled'' => ''0'',\n  ''upload_maxfilesize'' => ''2M'',\n  ''url_aliases'' => \n  array (\n  ),\n  ''url_config'' => \n  array (\n    ''index'' => ''core'',\n    ''news'' => ''core'',\n    ''page'' => ''core'',\n    ''search'' => ''core'',\n    ''system'' => ''core'',\n    ''user'' => ''core'',\n    ''gallery'' => ''plugin'',\n  ),\n  ''url_profiles'' => \n  array (\n  ),\n  ''url_disable_pathinfo'' => ''1'',\n  ''url_error_redirect'' => ''0'',\n  ''url_locations'' => \n  array (\n    ''index'' => \n    array (\n      0 => ''core'',\n    ),\n    ''news'' => \n    array (\n      0 => ''core'',\n      1 => ''core/sef_full'',\n      2 => ''core/sef_noid'',\n      3 => ''core/sef'',\n    ),\n    ''page'' => \n    array (\n      0 => ''core'',\n      1 => ''core/sef_chapters'',\n      2 => ''core/sef_noid'',\n      3 => ''core/sef'',\n    ),\n    ''search'' => \n    array (\n      0 => ''core'',\n      1 => ''core/rewrite'',\n    ),\n    ''system'' => \n    array (\n      0 => ''core'',\n      1 => ''core/rewrite'',\n    ),\n    ''user'' => \n    array (\n      0 => ''core'',\n      1 => ''core/rewrite'',\n    ),\n    ''gallery'' => \n    array (\n      0 => ''plugin'',\n      1 => ''plugin/rewrite'',\n    ),\n  ),\n  ''url_main_module'' => ''page'',\n  ''url_modules'' => \n  array (\n    ''core'' => \n    array (\n      0 => ''index'',\n      1 => ''news'',\n      2 => ''page'',\n      3 => ''search'',\n      4 => ''system'',\n      5 => ''user'',\n    ),\n    ''plugin'' => \n    array (\n      0 => ''gallery'',\n    ),\n    ''override'' => \n    array (\n    ),\n  ),\n  ''url_sef_translate'' => ''dashl'',\n  ''useGeshi'' => ''0'',\n  ''use_coppa'' => ''1'',\n  ''user_new_period'' => ''3'',\n  ''user_reg'' => ''1'',\n  ''user_reg_secureveri'' => ''1'',\n  ''user_reg_veri'' => ''1'',\n  ''user_tracking'' => ''session'',\n  ''version'' => ''2.2.0'',\n  ''wm_enclose'' => ''1'',\n  ''wmessage_sc'' => ''0'',\n  ''wysiwyg'' => ''1'',\n  ''wysiwyg_list'' => \n  array (\n    ''tinymce4'' => ''TinyMce4'',\n  ),\n  ''xup_enabled'' => ''1'',\n  ''xurl'' => \n  array (\n    ''facebook'' => ''#'',\n    ''twitter'' => ''#'',\n    ''youtube'' => ''#'',\n    ''google'' => ''#'',\n    ''linkedin'' => '''',\n    ''github'' => '''',\n    ''flickr'' => '''',\n    ''instagram'' => '''',\n    ''pinterest'' => '''',\n    ''vimeo'' => '''',\n  ),\n  ''xmlfeed_languagepacks'' => ''https://www.e107.org/themeupdate.php'',\n  ''xmlfeed_security'' => ''https://www.e107.org/themeupdate.php'',\n  ''avatar_upload'' => ''0'',\n  ''photo_upload'' => ''0'',\n  ''profile_rate'' => ''0'',\n  ''profile_comments'' => ''0'',\n  ''force_userupdate'' => ''0'',\n  ''del_unv'' => ''0'',\n  ''del_accu'' => ''1'',\n  ''signature_access'' => ''253'',\n  ''bbcode_list'' => \n  array (\n  ),\n  ''shortcode_legacy_list'' => \n  array (\n  ),\n  ''e_menu_list'' => \n  array (\n    ''navigation'' => ''navigation'',\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n    ''social'' => ''social'',\n    ''tagcloud'' => ''tagcloud'',\n  ),\n  ''e_frontpage_list'' => \n  array (\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n  ),\n  ''e_gsitemap_list'' => \n  array (\n    ''news'' => ''news'',\n  ),\n  ''e_dashboard_list'' => \n  array (\n    ''user'' => ''user'',\n  ),\n  ''e_mailout_list'' => \n  array (\n    ''user'' => ''user'',\n  ),\n  ''e_library_list'' => \n  array (\n    ''gallery'' => ''gallery'',\n  ),\n  ''sitetheme_glyphicons'' => \n  array (\n  ),\n  ''sitetheme_version'' => ''1.1'',\n)'),
('emote_', 'array (\n  ''alien!png'' => ''!alien'',\n  ''amazed!png'' => ''!amazed'',\n  ''angry!png'' => ''!grr !angry'',\n  ''biglaugh!png'' => ''!lol'',\n  ''cheesey!png'' => '':D :oD :-D'',\n  ''confused!png'' => '':? :o? :-?'',\n  ''cry!png'' => ''&| &-| &o| :(( !cry'',\n  ''dead!png'' => ''x) xo) x-) x( xo( x-('',\n  ''dodge!png'' => ''!dodge'',\n  ''frown!png'' => '':( :o( :-('',\n  ''gah!png'' => '':@ :o@ :o@'',\n  ''grin!png'' => '':D :oD :-D'',\n  ''heart!png'' => ''!heart'',\n  ''idea!png'' => '':! :o! :-!'',\n  ''ill!png'' => ''!ill'',\n  ''mad!png'' => ''~:( ~:o( ~:-('',\n  ''mistrust!png'' => ''!mistrust'',\n  ''neutral!png'' => '':| :o| :-|'',\n  ''question!png'' => ''?!'',\n  ''rolleyes!png'' => ''B) Bo) B-)'',\n  ''sad!png'' => ''!sad'',\n  ''shades!png'' => ''8) 8o) 8-)'',\n  ''shy!png'' => ''!shy'',\n  ''smile!png'' => '':) :o) :-)'',\n  ''special!png'' => ''%-6'',\n  ''suprised!png'' => '':O :oO :-O'',\n  ''tongue!png'' => '':p :op :-p :P :oP :-P'',\n  ''wink!png'' => '';) ;o) ;-)'',\n)'),
('menu_pref', 'array (\n  ''clock_caption'' => ''Date / Time'',\n  ''comment_caption'' => ''Latest Comments'',\n  ''comment_characters'' => ''50'',\n  ''comment_display'' => ''10'',\n  ''comment_postfix'' => ''[more ...]'',\n  ''comment_title'' => ''0'',\n  ''update_menu'' => ''Update menu Settings'',\n)'),
('search_prefs', 'array (\n  ''comments_handlers'' => \n  array (\n    ''news'' => \n    array (\n      ''id'' => 0,\n      ''dir'' => ''core'',\n      ''class'' => ''0'',\n    ),\n    ''download'' => \n    array (\n      ''id'' => 2,\n      ''dir'' => ''core'',\n      ''class'' => ''0'',\n    ),\n  ),\n  ''core_handlers'' => \n  array (\n    ''comments'' => \n    array (\n      ''class'' => ''0'',\n      ''pre_title'' => ''1'',\n      ''pre_title_alt'' => '''',\n      ''chars'' => ''150'',\n      ''results'' => ''10'',\n      ''order'' => ''2'',\n    ),\n    ''users'' => \n    array (\n      ''class'' => ''0'',\n      ''pre_title'' => ''1'',\n      ''pre_title_alt'' => '''',\n      ''chars'' => ''150'',\n      ''results'' => ''10'',\n      ''order'' => ''3'',\n    ),\n  ),\n  ''google'' => ''0'',\n  ''multisearch'' => ''1'',\n  ''mysql_sort'' => ''1'',\n  ''php_limit'' => '''',\n  ''relevance'' => ''0'',\n  ''selector'' => ''2'',\n  ''time_restrict'' => ''0'',\n  ''time_secs'' => ''60'',\n  ''user_select'' => ''1'',\n)'),
('notify_prefs', 'array (\n  ''event'' => \n  array (\n    ''login'' => \n    array (\n      ''class'' => ''255'',\n      ''email'' => '''',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''logout'' => \n    array (\n      ''class'' => ''255'',\n      ''email'' => '''',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''user_signup_submitted'' => \n    array (\n      ''class'' => ''255'',\n      ''email'' => '''',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''user_signup_activated'' => \n    array (\n      ''class'' => ''255'',\n      ''email'' => '''',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''user_ban_flood'' => \n    array (\n      ''class'' => ''255'',\n      ''email'' => '''',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''user_news_submit'' => \n    array (\n      ''class'' => ''255'',\n      ''email'' => '''',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''admin_news_created'' => \n    array (\n      ''class'' => ''255'',\n      ''email'' => '''',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''admin_news_updated'' => \n    array (\n      ''class'' => ''255'',\n      ''email'' => '''',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''admin_news_deleted'' => \n    array (\n      ''class'' => ''255'',\n      ''email'' => '''',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''user_xup_login'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''user_xup_signup'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''user_ban_failed_login'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''user_profile_display'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''admin_password_update'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''admin_user_created'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''admin_user_activated'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''admin_news_notify'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''maildone'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n    ''user_file_upload'' => \n    array (\n      ''class'' => ''255'',\n      ''include'' => '''',\n      ''legacy'' => ''0'',\n    ),\n  ),\n)'),
('SitePrefs_Backup', 'array (\n  ''admin_alerts_ok'' => ''1'',\n  ''admin_alerts_uniquemenu'' => ''0'',\n  ''admin_separate_plugins'' => ''0'',\n  ''admin_collapse_sidebar'' => ''0'',\n  ''admin_navbar_labels'' => ''0'',\n  ''admin_helptip'' => ''1'',\n  ''admincode'' => ''0'',\n  ''admincss'' => ''css/modern-light.css'',\n  ''adminlanguage'' => '''',\n  ''adminpwordchange'' => ''0'',\n  ''adminstyle'' => ''flexpanel'',\n  ''admintheme'' => ''bootstrap3'',\n  ''allowCommentEdit'' => ''0'',\n  ''allowEmailLogin'' => ''2'',\n  ''anon_post'' => ''0'',\n  ''antiflood1'' => ''1'',\n  ''antiflood_timeout'' => ''10'',\n  ''auth_method'' => '''',\n  ''autoban'' => ''1'',\n  ''autologinpostsignup'' => ''1'',\n  ''ban_date_format'' => ''%H:%M %d-%m-%y'',\n  ''ban_max_online_access'' => ''100,200'',\n  ''ban_retrigger'' => ''0'',\n  ''cachestatus'' => '''',\n  ''check_updates'' => ''1'',\n  ''comments_disabled'' => ''0'',\n  ''comments_emoticons'' => ''0'',\n  ''comments_engine'' => ''e107'',\n  ''comments_icon'' => ''0'',\n  ''comments_moderate'' => ''247'',\n  ''comments_sort'' => ''desc'',\n  ''compress_output'' => ''0'',\n  ''contact_info'' => \n  array (\n    ''organization'' => ''My Company Inc.'',\n    ''address'' => ''312 Address St.\nLas Vegas, NV,\nUSA'',\n    ''phone1'' => ''+1-555-555-5555'',\n    ''phone2'' => ''+1-444-444-4444'',\n    ''phone3'' => '''',\n    ''fax'' => '''',\n    ''email1'' => '''',\n    ''email2'' => '''',\n    ''coordinates'' => '''',\n    ''hours'' => '''',\n    ''message'' => '''',\n  ),\n  ''contact_emailcopy'' => ''0'',\n  ''contact_visibility'' => ''253'',\n  ''contact_filter'' => '''',\n  ''cookie_name'' => ''e107cookie'',\n  ''core-infopanel-default'' => \n  array (\n    0 => ''e-administrator'',\n    1 => ''e-cpage'',\n    2 => ''e-filemanager'',\n    3 => ''e-frontpage'',\n    4 => ''e-image'',\n    5 => ''e-mailout'',\n    6 => ''e-menus'',\n    7 => ''e-meta'',\n    8 => ''e-newspost'',\n    9 => ''e-plugin'',\n    10 => ''e-prefs'',\n    11 => ''e-links'',\n    12 => ''e-theme'',\n    13 => ''e-userclass2'',\n    14 => ''e-users'',\n    15 => ''e-wmessage'',\n  ),\n  ''db_updates'' => \n  array (\n  ),\n  ''developer'' => ''0'',\n  ''disable_emailcheck'' => ''0'',\n  ''disallowMultiLogin'' => ''0'',\n  ''display_memory_usage'' => ''0'',\n  ''displayname_class'' => ''255'',\n  ''displayname_maxlength'' => ''20'',\n  ''displayrendertime'' => ''0'',\n  ''displaysql'' => ''0'',\n  ''displaythemeinfo'' => ''1'',\n  ''e_admin_list'' => \n  array (\n    ''social'' => ''social'',\n  ),\n  ''e_comment_list'' => \n  array (\n    ''social'' => ''social'',\n  ),\n  ''e_event_list'' => \n  array (\n    ''news'' => ''news'',\n    ''social'' => ''social'',\n  ),\n  ''e_featurebox_list'' => \n  array (\n    ''news'' => ''news'',\n  ),\n  ''e_footer_list'' => \n  array (\n    ''tinymce4'' => ''tinymce4'',\n  ),\n  ''e_header_list'' => \n  array (\n    ''gallery'' => ''gallery'',\n    ''hero'' => ''hero'',\n    ''news'' => ''news'',\n    ''tagcloud'' => ''tagcloud'',\n    ''tinymce4'' => ''tinymce4'',\n  ),\n  ''e_jslib_cdn'' => ''1'',\n  ''e_jslib_cdn_provider'' => ''jsdelivr'',\n  ''e_jslib_browser_cache'' => [[timestamp]],\n  ''e_jslib_nobcache'' => ''1'',\n  ''e_jslib_nocache'' => ''1'',\n  ''e_jslib_gzip'' => ''1'',\n  ''e_jslib_nocombine'' => ''1'',\n  ''e_jslib_core'' => \n  array (\n    ''prototype'' => ''none'',\n    ''jquery'' => ''all'',\n  ),\n  ''e_jslib_plugin'' => \n  array (\n  ),\n  ''e_jslib_theme'' => \n  array (\n  ),\n  ''e_meta_list'' => \n  array (\n    ''rss_menu'' => ''rss_menu'',\n  ),\n  ''e_module_list'' => \n  array (\n    ''social'' => ''social'',\n  ),\n  ''e_related_list'' => \n  array (\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n  ),\n  ''e_rss_list'' => \n  array (\n    ''news'' => ''news'',\n  ),\n  ''e_search_list'' => \n  array (\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n    ''user'' => ''user'',\n  ),\n  ''e_shortcode_list'' => \n  array (\n    ''gallery'' => ''gallery'',\n    ''hero'' => ''hero'',\n    ''page'' => ''page'',\n    ''signin'' => ''signin'',\n    ''siteinfo'' => ''siteinfo'',\n    ''social'' => ''social'',\n  ),\n  ''shortcode_list'' => \n  array (\n  ),\n  ''e_sitelink_list'' => \n  array (\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n  ),\n  ''e_sql_list'' => \n  array (\n    ''hero'' => ''hero_sql'',\n    ''rss_menu'' => ''rss_sql'',\n  ),\n  ''e_url_list'' => \n  array (\n    ''contact'' => ''contact'',\n    ''gallery'' => ''gallery'',\n    ''news'' => ''news'',\n    ''rss_menu'' => ''rss_menu'',\n  ),\n  ''e_user_list'' => \n  array (\n    ''user'' => ''user'',\n  ),\n  ''email_text'' => '''',\n  ''email_item_class'' => ''253'',\n  ''emotepack'' => ''default'',\n  ''enable_rdns'' => ''0'',\n  ''enable_rdns_on_ban'' => ''0'',\n  ''failed_login_limit'' => ''10'',\n  ''filter_script'' => ''1'',\n  ''flood_hits'' => ''100'',\n  ''flood_time'' => ''30'',\n  ''flood_timeout'' => ''5'',\n  ''forumdate'' => ''%a %b %d %Y, %I:%M%p'',\n  ''fpwcode'' => ''0'',\n  ''frontpage'' => \n  array (\n    0 => ''index.php'',\n  ),\n  ''frontpage_force'' => \n  array (\n    0 => '''',\n  ),\n  ''gdpr_privacypolicy'' => '''',\n  ''gdpr_termsandconditions'' => '''',\n  ''html_abuse'' => ''1'',\n  ''im_height'' => ''80'',\n  ''im_path'' => ''/usr/X11R6/bin/'',\n  ''im_width'' => ''80'',\n  ''image_post'' => ''1'',\n  ''image_post_class'' => ''0'',\n  ''image_preload'' => ''0'',\n  ''img_import_resize'' => ''1200x800'',\n  ''inline_editing'' => ''255'',\n  ''inputdate'' => ''%A, %d %b, %Y'',\n  ''inputtime'' => ''%I:%M %p'',\n  ''install_date'' => ''1251664949'',\n  ''lan_global_list'' => \n  array (\n    ''gallery'' => ''gallery'',\n    ''hero'' => ''hero'',\n    ''navigation'' => ''navigation'',\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n    ''rss_menu'' => ''rss_menu'',\n    ''social'' => ''social'',\n    ''user'' => ''user'',\n    ''tagcloud'' => ''tagcloud'',\n  ),\n  ''link_replace'' => ''0'',\n  ''link_text'' => '''',\n  ''linkpage_screentip'' => ''0'',\n  ''links_new_window'' => ''1'',\n  ''log_page_accesses'' => ''0'',\n  ''log_refertype'' => ''1'',\n  ''logcode'' => ''0'',\n  ''loginname_maxlength'' => ''30'',\n  ''longdate'' => ''%A %d %B %Y - %H:%M:%S'',\n  ''mail_pause'' => ''3'',\n  ''mail_bounce'' => ''none'',\n  ''mail_pausetime'' => ''4'',\n  ''mail_sendstyle'' => ''texthtml'',\n  ''mail_workpertick'' => ''5'',\n  ''mailer'' => ''php'',\n  ''bulkmailer'' => ''smtp'',\n  ''main_wordwrap'' => '''',\n  ''maintainance_flag'' => ''0'',\n  ''make_clickable'' => ''0'',\n  ''memberlist_access'' => ''253'',\n  ''membersonly_enabled'' => ''0'',\n  ''membersonly_exceptions'' => \n  array (\n    0 => '''',\n  ),\n  ''menu_wordwrap'' => ''0'',\n  ''menuconfig_list'' => \n  array (\n    ''login_menu'' => \n    array (\n      ''name'' => ''Login'',\n      ''link'' => ''login_menu/config.php'',\n    ),\n    ''news'' => \n    array (\n      ''name'' => ''Newsmonths'',\n      ''link'' => ''blogcalendar_menu/config.php'',\n    ),\n  ),\n  ''membersonly_redirect'' => ''login'',\n  ''meta_tag'' => '''',\n  ''multilanguage'' => ''0'',\n  ''nbr_cols'' => ''1'',\n  ''nested_comments'' => ''1'',\n  ''news_cats'' => ''0'',\n  ''news_default_template'' => ''list'',\n  ''news_editauthor'' => ''254'',\n  ''news_list_limit'' => ''10'',\n  ''news_list_templates'' => \n  array (\n    0 => ''0'',\n  ),\n  ''news_newdateheader'' => ''0'',\n  ''news_pagination'' => ''record'',\n  ''newsposts'' => ''10'',\n  ''newsposts_archive'' => ''0'',\n  ''newsposts_archive_title'' => '''',\n  ''noLanguageSubs'' => ''0'',\n  ''null'' => '''',\n  ''old_np'' => ''0'',\n  ''pageCookieExpire'' => ''84600'',\n  ''passwordEncoding'' => ''0'',\n  ''password_CHAP'' => ''0'',\n  ''plug_installed'' => \n  array (\n    ''news'' => ''1.0'',\n    ''page'' => ''1.0'',\n    ''siteinfo'' => ''1.0'',\n    ''social'' => ''1.0'',\n    ''tinymce4'' => ''1.0'',\n    ''rss_menu'' => ''1.3'',\n    ''contact'' => ''1.0'',\n    ''user'' => ''1.0'',\n    ''navigation'' => ''1.0'',\n    ''signin'' => ''1.0'',\n    ''gallery'' => ''1.1'',\n    ''hero'' => ''1.0'',\n    ''tagcloud'' => ''1.3'',\n  ),\n  ''post_html'' => ''254'',\n  ''post_script'' => ''255'',\n  ''predefinedLoginName'' => '''',\n  ''profanity_filter'' => ''0'',\n  ''profanity_replace'' => ''[censored]'',\n  ''profanity_words'' => '''',\n  ''redirectsiteurl'' => ''0'',\n  ''replyto_email'' => ''registration@yoursite.com'',\n  ''replyto_name'' => ''e107 Website System'',\n  ''resize_method'' => ''gd2'',\n  ''resize_dimensions'' => \n  array (\n    ''news-image'' => \n    array (\n      ''w'' => ''300'',\n      ''h'' => ''300'',\n    ),\n    ''news-bbcode'' => \n    array (\n      ''w'' => ''300'',\n      ''h'' => ''300'',\n    ),\n    ''page-bbcode'' => \n    array (\n      ''w'' => ''300'',\n      ''h'' => ''300'',\n    ),\n  ),\n  ''search_highlight'' => ''1'',\n  ''search_restrict'' => ''0'',\n  ''session_lifetime'' => ''86400'',\n  ''session_save_method'' => ''db'',\n  ''shortdate'' => ''%d %b %Y'',\n  ''signcode'' => ''0'',\n  ''signup_disallow_text'' => '''',\n  ''signup_maxip'' => ''3'',\n  ''signup_option_class'' => ''0'',\n  ''signup_option_customtitle'' => ''0'',\n  ''signup_option_email_confirm'' => ''0'',\n  ''signup_option_hideemail'' => ''0'',\n  ''signup_option_image'' => ''0'',\n  ''signup_option_password'' => ''2'',\n  ''signup_option_realname'' => ''0'',\n  ''signup_option_signature'' => ''0'',\n  ''signup_pass_len'' => ''6'',\n  ''signup_text'' => '''',\n  ''signup_text_after'' => '''',\n  ''siteadmin'' => ''admin'',\n  ''siteadminemail'' => ''user@yoursite.com'',\n  ''sitebutton'' => ''{e_IMAGE}button.png'',\n  ''sitecontacts'' => ''sitecontactinfo'',\n  ''sitedescription'' => '''',\n  ''sitedisclaimer'' => '''',\n  ''sitelang_init'' => ''English'',\n  ''sitelanguage'' => ''English'',\n  ''sitelogo'' => '''',\n  ''sitename'' => ''My Website'',\n  ''sitetag'' => ''e107 Website System'',\n  ''sitetheme'' => ''bootstrap5'',\n  ''sitetheme_custompages'' => \n  array (\n    ''home'' => \n    array (\n      0 => ''FRONTPAGE'',\n    ),\n    ''full'' => \n    array (\n      0 => ''forum/'',\n      1 => ''download/'',\n    ),\n    ''splash'' => \n    array (\n      0 => ''login'',\n      1 => ''fpw'',\n      2 => ''signup'',\n    ),\n    ''bare'' => \n    array (\n    ),\n  ),\n  ''sitetheme_deflayout'' => ''sidebar_right'',\n  ''sitetheme_layouts'' => \n  array (\n    ''home'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Home Page'',\n      ),\n      ''custompages'' => ''FRONTPAGE'',\n    ),\n    ''full'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Full Page'',\n      ),\n      ''custompages'' => ''forum/ download/'',\n    ),\n    ''sidebar_left'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Sidebar (left)'',\n      ),\n      ''@value'' => '''',\n    ),\n    ''sidebar_right'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Sidebar (right)'',\n        ''default'' => ''true'',\n      ),\n      ''@value'' => '''',\n    ),\n    ''splash'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Splash Page'',\n      ),\n      ''custompages'' => ''login fpw signup'',\n    ),\n    ''bare'' => \n    array (\n      ''@attributes'' => \n      array (\n        ''title'' => ''Bare Page'',\n      ),\n      ''custompages'' => '''',\n    ),\n  ),\n  ''sitetheme_pref'' => '''',\n  ''siteurl'' => ''/'',\n  ''smiley_activate'' => ''1'',\n  ''smtp_server'' => '''',\n  ''smtp_username'' => '''',\n  ''smtp_password'' => '''',\n  ''smtp_options'' => '''',\n  ''smtp_port'' => ''25'',\n  ''social_login_active'' => ''0'',\n  ''social_login'' => ''array()'',\n  ''ssl_enabled'' => ''0'',\n  ''subnews_attach'' => ''253'',\n  ''subnews_class'' => ''253'',\n  ''subnews_htmlarea'' => ''0'',\n  ''subnews_resize'' => '''',\n  ''themecss'' => ''https://cdnjs.cloudflare.com/ajax/libs/bootswatch/5.2.3/quartz/bootstrap.min.css'',\n  ''thumbnail_quality'' => ''75'',\n  ''timezone'' => ''UTC'',\n  ''track_online'' => ''1'',\n  ''ue_upgrade'' => ''1'',\n  ''upload_class'' => ''255'',\n  ''upload_enabled'' => ''0'',\n  ''upload_maxfilesize'' => ''2M'',\n  ''url_aliases'' => \n  array (\n  ),\n  ''url_config'' => \n  array (\n    ''index'' => ''core'',\n    ''news'' => ''core'',\n    ''page'' => ''core'',\n    ''search'' => ''core'',\n    ''system'' => ''core'',\n    ''user'' => ''core'',\n  ),\n  ''url_profiles'' => \n  array (\n  ),\n  ''url_disable_pathinfo'' => ''1'',\n  ''url_error_redirect'' => ''0'',\n  ''url_locations'' => \n  array (\n    ''index'' => \n    array (\n      0 => ''core'',\n    ),\n    ''news'' => \n    array (\n      0 => ''core'',\n      1 => ''core/sef_full'',\n      2 => ''core/sef_noid'',\n      3 => ''core/sef'',\n    ),\n    ''page'' => \n    array (\n      0 => ''core'',\n      1 => ''core/sef_chapters'',\n      2 => ''core/sef_noid'',\n      3 => ''core/sef'',\n    ),\n    ''search'' => \n    array (\n      0 => ''core'',\n      1 => ''core/rewrite'',\n    ),\n    ''system'' => \n    array (\n      0 => ''core'',\n      1 => ''core/rewrite'',\n    ),\n    ''user'' => \n    array (\n      0 => ''core'',\n      1 => ''core/rewrite'',\n    ),\n  ),\n  ''url_main_module'' => ''page'',\n  ''url_modules'' => \n  array (\n    ''core'' => \n    array (\n      0 => ''index'',\n      1 => ''news'',\n      2 => ''page'',\n      3 => ''search'',\n      4 => ''system'',\n      5 => ''user'',\n    ),\n    ''plugin'' => \n    array (\n      0 => ''gallery'',\n    ),\n    ''override'' => \n    array (\n    ),\n  ),\n  ''url_sef_translate'' => ''dashl'',\n  ''useGeshi'' => ''0'',\n  ''use_coppa'' => ''1'',\n  ''user_new_period'' => ''3'',\n  ''user_reg'' => ''1'',\n  ''user_reg_secureveri'' => ''1'',\n  ''user_reg_veri'' => ''1'',\n  ''user_tracking'' => ''session'',\n  ''version'' => ''2.2.0'',\n  ''wm_enclose'' => ''1'',\n  ''wmessage_sc'' => ''0'',\n  ''wysiwyg'' => ''1'',\n  ''wysiwyg_list'' => \n  array (\n    ''tinymce4'' => ''TinyMce4'',\n  ),\n  ''xup_enabled'' => ''1'',\n  ''xurl'' => \n  array (\n    ''facebook'' => ''#'',\n    ''twitter'' => ''#'',\n    ''youtube'' => ''#'',\n    ''google'' => ''#'',\n    ''linkedin'' => '''',\n    ''github'' => '''',\n    ''flickr'' => '''',\n    ''instagram'' => '''',\n    ''pinterest'' => '''',\n    ''vimeo'' => '''',\n  ),\n  ''xmlfeed_languagepacks'' => ''https://www.e107.org/themeupdate.php'',\n  ''xmlfeed_security'' => ''https://www.e107.org/themeupdate.php'',\n  ''avatar_upload'' => ''0'',\n  ''photo_upload'' => ''0'',\n  ''profile_rate'' => ''0'',\n  ''profile_comments'' => ''0'',\n  ''force_userupdate'' => ''0'',\n  ''del_unv'' => ''0'',\n  ''del_accu'' => ''1'',\n  ''signature_access'' => ''253'',\n  ''bbcode_list'' => \n  array (\n  ),\n  ''shortcode_legacy_list'' => \n  array (\n  ),\n  ''e_menu_list'' => \n  array (\n    ''navigation'' => ''navigation'',\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n    ''social'' => ''social'',\n    ''tagcloud'' => ''tagcloud'',\n  ),\n  ''e_frontpage_list'' => \n  array (\n    ''news'' => ''news'',\n    ''page'' => ''page'',\n  ),\n  ''e_gsitemap_list'' => \n  array (\n    ''news'' => ''news'',\n  ),\n  ''e_dashboard_list'' => \n  array (\n    ''user'' => ''user'',\n  ),\n  ''e_mailout_list'' => \n  array (\n    ''user'' => ''user'',\n  ),\n  ''e_library_list'' => \n  array (\n    ''gallery'' => ''gallery'',\n  ),\n  ''sitetheme_glyphicons'' => \n  array (\n  ),\n  ''sitetheme_version'' => ''1.1'',\n)'),
('plugin_gallery', 'array (\n  ''popup_w'' => ''800'',\n  ''popup_h'' => ''800'',\n  ''slideshow_category'' => ''1'',\n  ''slideshow_duration'' => ''1000'',\n  ''slideshow_auto'' => ''1'',\n  ''slideshow_freq'' => ''4000'',\n  ''slideshow_effect'' => ''scrollHorz'',\n  ''perpage'' => ''12'',\n  ''orderby'' => ''media_id DESC'',\n  ''pp_global'' => ''0'',\n  ''pp_hook'' => ''data-gal'',\n  ''pp_animation_speed'' => ''fast'',\n  ''pp_slideshow'' => ''5000'',\n  ''pp_autoplay_slideshow'' => ''0'',\n  ''pp_opacity'' => ''0.80'',\n  ''pp_show_title'' => ''1'',\n  ''pp_allow_resize'' => ''1'',\n  ''pp_default_width'' => ''500'',\n  ''pp_default_height'' => ''344'',\n  ''pp_counter_separator_label'' => ''/'',\n  ''pp_theme'' => ''pp_default'',\n  ''pp_horizontal_padding'' => ''20'',\n  ''pp_hideflash'' => ''0'',\n  ''pp_wmode'' => ''opaque'',\n  ''pp_autoplay'' => ''1'',\n  ''pp_modal'' => ''0'',\n  ''pp_deeplinking'' => ''0'',\n  ''pp_overlay_gallery'' => ''0'',\n  ''pp_keyboard_shortcuts'' => ''1'',\n  ''pp_ie6_fallback'' => ''1'',\n)'),
('plugin_hero', 'array (\n  ''visibility'' => ''0'',\n  ''icon_pack'' => ''fontawesome'',\n  ''slide_interval'' => ''7000'',\n)'),
('plugin_tinymce4', 'array (\n  ''paste_as_text'' => ''0'',\n  ''browser_spellcheck'' => ''1'',\n  ''visualblocks'' => ''1'',\n  ''code_highlight_class'' => ''prettyprint linenums'',\n)'),
('theme_bootstrap5', 'array (\n  ''cardmenu_look'' => ''1'',\n  ''login_iframe'' => '''',\n)'),
('history_prefs', 'array (\n  ''most_members_online'' => 0,\n  ''most_guests_online'' => 1,\n  ''most_online_datestamp'' => [[timestamp]],\n)');

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

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

CREATE TABLE `[[dbprefix]]core_media` (
  `media_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `media_type` varchar(50) NOT NULL DEFAULT '',
  `media_name` varchar(255) NOT NULL DEFAULT '',
  `media_caption` varchar(255) NOT NULL DEFAULT '',
  `media_description` varchar(255) NOT NULL DEFAULT '',
  `media_category` varchar(255) NOT NULL DEFAULT '',
  `media_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `media_author` int(10) unsigned NOT NULL DEFAULT '0',
  `media_url` varchar(255) NOT NULL DEFAULT '',
  `media_size` int(20) unsigned NOT NULL DEFAULT '0',
  `media_dimensions` varchar(25) NOT NULL DEFAULT '',
  `media_userclass` varchar(255) NOT NULL DEFAULT '',
  `media_usedby` text NOT NULL,
  `media_tags` text NOT NULL,
  PRIMARY KEY (`media_id`),
  UNIQUE KEY `media_url` (`media_url`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

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

INSERT INTO `[[dbprefix]]core_media` VALUES
(1, 'image/jpeg', 'butterfly.jpg', 'butterfly.jpg', '', 'gallery_image', [[timestamp]], 1, '{e_PLUGIN}gallery/images/butterfly.jpg', 238490, '1500 x 1000', '0', '', ''),
(2, 'image/jpeg', 'horse.jpg', 'horse.jpg', '', 'gallery_image', [[timestamp]], 1, '{e_PLUGIN}gallery/images/horse.jpg', 335810, '1500 x 1000', '0', '', ''),
(3, 'image/jpeg', 'lake-and-forest.jpg', 'lake-and-forest.jpg', '', 'gallery_image', [[timestamp]], 1, '{e_PLUGIN}gallery/images/lake-and-forest.jpg', 317718, '1000 x 1500', '0', '', ''),
(4, 'image/png', 'gallery_16.png', 'gallery_16.png', '', '_icon_16', [[timestamp]], 1, '{e_PLUGIN}gallery/images/gallery_16.png', 1075, '16 x 16', '0', '', ''),
(5, 'image/png', 'gallery_32.png', 'gallery_32.png', '', '_icon_32', [[timestamp]], 1, '{e_PLUGIN}gallery/images/gallery_32.png', 2770, '32 x 32', '0', '', ''),
(6, 'image/png', 'rss_16.png', 'rss_16.png', '', '_icon_16', [[timestamp]], 1, '{e_PLUGIN}rss_menu/images/rss_16.png', 898, '16 x 16', '0', '', ''),
(7, 'image/png', 'rss_32.png', 'rss_32.png', '', '_icon_32', [[timestamp]], 1, '{e_PLUGIN}rss_menu/images/rss_32.png', 2486, '32 x 32', '0', '', ''),
(8, 'image/png', 'icon_16.png', 'icon_16.png', '', '_icon_16', [[timestamp]], 1, '{e_PLUGIN}social/images/icon_16.png', 1748, '16 x 16', '0', '', ''),
(9, 'image/png', 'icon_32.png', 'icon_32.png', '', '_icon_32', [[timestamp]], 1, '{e_PLUGIN}social/images/icon_32.png', 2446, '32 x 32', '0', '', ''),
(10, 'image/svg+xml', 'fontello.svg', 'fontello.svg', '', '_icon_svg', [[timestamp]], 1, '{e_PLUGIN}social/font/fontello.svg', 25299, '', '0', '', ''),
(11, 'image/png', 'icon_16.png', 'icon_16.png', '', '_icon_16', [[timestamp]], 1, '{e_PLUGIN}tinymce4/images/icon_16.png', 859, '16 x 16', '0', '', ''),
(12, 'image/png', 'icon_32.png', 'icon_32.png', '', '_icon_32', [[timestamp]], 1, '{e_PLUGIN}tinymce4/images/icon_32.png', 2441, '32 x 32', '0', '', ''),
(13, 'image/png', 'icon_16.png', 'icon_16.png', '', '_icon_16', [[timestamp]], 1, '{e_PLUGIN}tagcloud/images/icon_16.png', 736, '16 x 16', '0', '', ''),
(14, 'image/png', 'icon_32.png', 'icon_32.png', '', '_icon_32', [[timestamp]], 1, '{e_PLUGIN}tagcloud/images/icon_32.png', 1497, '32 x 32', '0', '', '');

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

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

CREATE TABLE `[[dbprefix]]core_media_cat` (
  `media_cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `media_cat_owner` varchar(255) NOT NULL DEFAULT '',
  `media_cat_category` varchar(255) NOT NULL DEFAULT '',
  `media_cat_title` text NOT NULL,
  `media_cat_sef` varchar(255) NOT NULL DEFAULT '',
  `media_cat_diz` text NOT NULL,
  `media_cat_class` int(5) DEFAULT '0',
  `media_cat_image` varchar(255) NOT NULL DEFAULT '',
  `media_cat_order` int(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`media_cat_id`),
  UNIQUE KEY `media_cat_category` (`media_cat_category`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

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

INSERT INTO `[[dbprefix]]core_media_cat` VALUES
(1, '_common', '_common_image', '(Common Images)', '', 'Media in this category will be available in all areas of admin.', 253, '', 0),
(2, '_common', '_common_file', '(Common Files)', '', 'Media in this category will be available in all areas of admin.', 253, '', 0),
(3, '_common', '_common_video', '(Common Videos)', '', 'Media in this category will be available in all areas of admin.', 253, '', 0),
(4, '_common', '_common_audio', '(Common Audio)', '', 'Media in this category will be available in all areas of admin.', 253, '', 0),
(5, 'news', 'news', 'News', '', 'Will be available in the news area.', 253, '', 1),
(6, 'page', 'page', 'Custom Pages', '', 'Will be available in the custom pages area of admin.', 253, '', 0),
(7, 'download', 'download_image', 'Download Images', '', '', 253, '', 0),
(8, 'download', 'download_thumb', 'Download Thumbnails', '', '', 253, '', 0),
(9, 'download', 'download_file', 'Download Files', '', '', 253, '', 0),
(10, 'news', 'news_thumb', 'News Thumbnails (Legacy)', '', 'Legacy news thumbnails.', 253, '', 1),
(11, '_icon', '_icon_16', 'Icons 16px', '', 'Available where icons are used in admin.', 253, '', 0),
(12, '_icon', '_icon_32', 'Icons 32px', '', 'Available where icons are used in admin.', 253, '', 0),
(13, '_icon', '_icon_48', 'Icons 48px', '', 'Available where icons are used in admin.', 253, '', 0),
(14, '_icon', '_icon_64', 'Icons 64px', '', 'Available where icons are used in admin.', 253, '', 0),
(15, '_icon', '_icon_svg', 'Icons SVG', '', 'Available where icons are used in admin.', 253, '', 0),
(16, 'gallery', 'gallery_image', 'Gallery 1', 'gallery-1', '', 0, '{e_PLUGIN}gallery/images/butterfly.jpg', 0),
(17, 'hero', 'hero_image', 'Hero Images', '', '', 253, '', 0);

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

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

CREATE TABLE `[[dbprefix]]cron` (
  `cron_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cron_name` varchar(50) NOT NULL,
  `cron_category` varchar(20) NOT NULL,
  `cron_description` varchar(255) NOT NULL,
  `cron_function` varchar(50) NOT NULL,
  `cron_tab` varchar(255) NOT NULL,
  `cron_lastrun` int(13) unsigned NOT NULL,
  `cron_active` int(1) unsigned NOT NULL,
  PRIMARY KEY (`cron_id`),
  UNIQUE KEY `cron_function` (`cron_function`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]dblog` (
  `dblog_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dblog_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `dblog_microtime` int(10) unsigned NOT NULL DEFAULT '0',
  `dblog_type` tinyint(3) NOT NULL DEFAULT '0',
  `dblog_eventcode` varchar(10) NOT NULL DEFAULT '',
  `dblog_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `dblog_user_name` varchar(100) NOT NULL DEFAULT '',
  `dblog_ip` varchar(45) NOT NULL DEFAULT '',
  `dblog_caller` varchar(255) NOT NULL DEFAULT '',
  `dblog_title` varchar(255) NOT NULL DEFAULT '',
  `dblog_remarks` text NOT NULL,
  PRIMARY KEY (`dblog_id`),
  KEY `dblog_datestamp` (`dblog_datestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]generic` (
  `gen_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gen_type` varchar(80) NOT NULL DEFAULT '',
  `gen_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `gen_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `gen_ip` varchar(80) NOT NULL DEFAULT '',
  `gen_intdata` int(10) unsigned NOT NULL DEFAULT '0',
  `gen_chardata` text NOT NULL,
  PRIMARY KEY (`gen_id`),
  KEY `gen_type` (`gen_type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `[[dbprefix]]generic` VALUES
(1, 'wmessage', 1145848343, 1, 'Hello World!', 0, '[html]This is a twitter bootstrap template for a simple marketing or informational website. The only difference is that e107 is managing the content. ie. The text you are reading is the &quot;Welcome Message&quot;. Visit the admin-area to modify.<br><br><a class=&quot;btn btn-primary btn-large &quot; href=&quot;e107_admin/admin.php&quot;>Go to Admin area</a><br>[/html]');

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

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

CREATE TABLE `[[dbprefix]]hero` (
  `hero_id` int(10) NOT NULL AUTO_INCREMENT,
  `hero_title` varchar(255) NOT NULL,
  `hero_description` varchar(255) DEFAULT '',
  `hero_bg` varchar(255) NOT NULL,
  `hero_media` varchar(255) DEFAULT '',
  `hero_bullets` text,
  `hero_button1` text,
  `hero_button2` text,
  `hero_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `hero_class` int(5) DEFAULT '0',
  PRIMARY KEY (`hero_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `[[dbprefix]]hero` VALUES
(1, 'A [powerful] & [free] hero area', '[Easy] to Use', '', 'https://via.placeholder.com/800x350.jpg?text=Image+1', '[\n    {\n        "icon": "fa-sun-o.glyph",\n        "icon_style": "warning",\n        "text": "Add some bullet text",\n        "animation": "fadeInRight",\n        "animation_delay": "15"\n    },\n    {\n        "icon": "fa-font-awesome.glyph",\n        "icon_style": "success",\n        "text": "Select an Icon from FontAwesome or others",\n        "animation": "fadeInRight",\n        "animation_delay": "25"\n    },\n    {\n        "icon": "fa-adjust.glyph",\n        "icon_style": "danger",\n        "text": "Choose a Style from Bootstrap",\n        "animation": "fadeInRight",\n        "animation_delay": "35"\n    },\n    {\n        "icon": "",\n        "icon_style": "",\n        "text": "",\n        "animation": "",\n        "animation_delay": "0"\n    },\n    {\n        "icon": "",\n        "icon_style": "",\n        "text": "",\n        "animation": "",\n        "animation_delay": "0"\n    }\n]', '{\n    "icon": "fa-arrow-circle-o-down",\n    "label": "Button",\n    "url": "",\n    "class": "primary"\n}', '{\n    "icon": "fa-",\n    "label": "",\n    "url": "",\n    "class": ""\n}', 0, 0),
(2, 'Add [emphasized] titles', 'Add a description [here]', '', 'https://via.placeholder.com/800x350.jpg?text=Image+2', '[\n    {\n        "icon": "fa-clock-o.glyph",\n        "icon_style": "info",\n        "text": "Time it how you wish",\n        "animation": "fadeInRight",\n        "animation_delay": "35"\n    },\n    {\n        "icon": "fa-id-badge.glyph",\n        "icon_style": "warning",\n        "text": "Add a Button",\n        "animation": "fadeInRight",\n        "animation_delay": "15"\n    },\n    {\n        "icon": "fa-globe.glyph",\n        "icon_style": "success",\n        "text": "To the URL of your choice",\n        "animation": "fadeInRight",\n        "animation_delay": "20"\n    },\n    {\n        "icon": "fa-.glyph",\n        "icon_style": "",\n        "text": "",\n        "animation": "",\n        "animation_delay": "0"\n    },\n    {\n        "icon": "fa-.glyph",\n        "icon_style": "",\n        "text": "",\n        "animation": "",\n        "animation_delay": "0"\n    }\n]', '{\n    "icon": "fa-link",\n    "label": "Button",\n    "url": "#",\n    "class": "success"\n}', '{\n    "icon": "fa-",\n    "label": "",\n    "url": "",\n    "class": ""\n}', 1, 0),
(3, 'Select your [Animations]', 'Use the admin area to adjust.', '', 'https://via.placeholder.com/800x350.jpg?text=Image+3', '[\n    {\n        "icon": "fa-soccer-ball-o.glyph",\n        "icon_style": "warning",\n        "text": "Bounce In from the Left",\n        "animation": "bounceInLeft",\n        "animation_delay": "15"\n    },\n    {\n        "icon": "fa-arrow-up.glyph",\n        "icon_style": "success",\n        "text": "Zoom In Up",\n        "animation": "zoomInUp",\n        "animation_delay": "42"\n    },\n    {\n        "icon": "fa-anchor.glyph",\n        "icon_style": "danger",\n        "text": "Rotate In Down and Left",\n        "animation": "rotateInDownLeft",\n        "animation_delay": "30"\n    },\n    {\n        "icon": "",\n        "icon_style": "",\n        "text": "",\n        "animation": "",\n        "animation_delay": "0"\n    },\n    {\n        "icon": "",\n        "icon_style": "",\n        "text": "",\n        "animation": "",\n        "animation_delay": "0"\n    }\n]', '{\n    "icon": "fa-",\n    "label": "",\n    "url": "",\n    "class": ""\n}', '{\n    "icon": "fa-",\n    "label": "",\n    "url": "",\n    "class": ""\n}', 2, 0);

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

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

CREATE TABLE `[[dbprefix]]links` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `link_name` varchar(100) NOT NULL DEFAULT '',
  `link_url` varchar(200) NOT NULL DEFAULT '',
  `link_description` text NOT NULL,
  `link_button` varchar(100) NOT NULL DEFAULT '',
  `link_category` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `link_order` int(10) unsigned NOT NULL DEFAULT '0',
  `link_parent` int(10) unsigned NOT NULL DEFAULT '0',
  `link_open` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `link_rel` varchar(200) NOT NULL DEFAULT '',
  `link_class` varchar(255) NOT NULL DEFAULT '0',
  `link_function` varchar(100) NOT NULL DEFAULT '',
  `link_sefurl` varchar(255) NOT NULL,
  `link_owner` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

INSERT INTO `[[dbprefix]]links` VALUES
(1, 'Home', 'index.php', '', '', 1, 1, 0, 0, '', '0', '', '', ''),
(3, 'Submit News', 'submitnews.php', '', '', 2, 10, 0, 0, '', '253', '', '', ''),
(4, 'Contact', 'contact.php', '', '', 1, 7, 0, 0, '', '0', '', 'index', 'contact'),
(5, 'News', 'news.php', '', '', 1, 2, 0, 0, '', '0', '', 'index', 'news'),
(6, 'Content', 'page.php', '', '', 1, 3, 0, 0, '', '0', 'page::pagesFromChapter(2)', '', ''),
(7, 'Privacy', '#privacy-policy', '', '', 3, 11, 0, 0, '', '0', '', '', ''),
(8, 'Contact', 'contact.php', '', '', 3, 13, 0, 0, '', '0', '', 'index', 'contact'),
(9, 'Other', '#', '', '', 3, 14, 0, 0, '', '255', '', '', ''),
(10, 'Other', '#', '', '', 3, 14, 0, 0, '', '255', '', '', ''),
(11, 'Other', '#', '', '', 3, 15, 0, 0, '', '255', '', '', ''),
(2, 'Terms', '#terms-of-use', '', '', 3, 12, 0, 0, '', '0', '', '', '');

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

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

CREATE TABLE `[[dbprefix]]mail_content` (
  `mail_source_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mail_content_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `mail_total_count` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_togo_count` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_sent_count` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_fail_count` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_bounce_count` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_start_send` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_end_send` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_create_date` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_creator` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_create_app` varchar(20) NOT NULL DEFAULT '',
  `mail_e107_priority` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `mail_notify_complete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `mail_last_date` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_title` varchar(100) NOT NULL DEFAULT '',
  `mail_subject` varchar(100) NOT NULL DEFAULT '',
  `mail_body` text,
  `mail_body_templated` text,
  `mail_other` text,
  `mail_media` text,
  PRIMARY KEY (`mail_source_id`),
  KEY `mail_content_status` (`mail_content_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]mail_recipients` (
  `mail_target_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mail_recipient_id` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_recipient_email` varchar(80) NOT NULL DEFAULT '',
  `mail_recipient_name` varchar(80) NOT NULL DEFAULT '',
  `mail_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `mail_detail_id` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_send_date` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_target_info` text,
  PRIMARY KEY (`mail_target_id`),
  KEY `mail_status` (`mail_status`),
  KEY `mail_detail_id` (`mail_detail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]menus` (
  `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(100) NOT NULL DEFAULT '',
  `menu_location` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `menu_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `menu_class` varchar(255) NOT NULL DEFAULT '0',
  `menu_pages` text NOT NULL,
  `menu_path` varchar(100) NOT NULL DEFAULT '',
  `menu_layout` varchar(100) NOT NULL DEFAULT '',
  `menu_parms` text NOT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;

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

INSERT INTO `[[dbprefix]]menus` VALUES
(1, 'login_menu', 1, 1, '0', '', 'login_menu/', '', ''),
(2, 'online_menu', 0, 0, '0', '', 'online/', '', ''),
(3, 'blogcalendar_menu', 0, 0, '0', '', 'blogcalendar_menu/', '', ''),
(5, 'search_menu', 0, 0, '0', '', 'search_menu/', '', ''),
(6, 'counter_menu', 0, 0, '0', '', 'siteinfo/', '', ''),
(7, 'userlanguage_menu', 0, 0, '0', '', 'user/', '', ''),
(8, 'compliance_menu', 0, 0, '0', '', 'siteinfo/', '', ''),
(9, 'other_news_menu', 0, 0, '0', '', 'news/', '', ''),
(10, 'clock_menu', 0, 0, '0', '', 'clock_menu/', '', ''),
(11, 'other_news2_menu', 0, 0, '0', '', 'news/', '', ''),
(12, 'comment_menu', 0, 0, '0', '', 'comment_menu/', '', ''),
(13, 'lastseen_menu', 0, 0, '0', '', 'online/', '', ''),
(14, 'news_months_menu', 0, 2, '0', '', 'news/', '', ''),
(15, 'admin_menu', 0, 0, '0', '', 'admin_menu/', '', ''),
(16, 'news_categories_menu', 0, 0, '0', '', 'news/', '', ''),
(17, 'latestnews_menu', 0, 0, '0', '', 'news/', '', ''),
(18, 'usertheme_menu', 0, 0, '0', '', 'user/', '', ''),
(19, 'powered_by_menu', 0, 0, '0', '', 'siteinfo/', '', ''),
(20, 'sitebutton_menu', 0, 0, '0', '', 'siteinfo/', '', ''),
(21, 'news_carousel_menu', 0, 0, '0', '', 'news/', '', ''),
(22, 'chapter_menu', 0, 0, '0', '', 'page/', '', ''),
(23, 'page_menu', 0, 0, '0', '', 'page/', '', ''),
(24, 'page_navigation_menu', 0, 0, '0', '', 'page/', '', ''),
(25, 'slideshow_menu', 0, 0, '0', '0', 'gallery/', '', ''),
(26, 'hero_menu', 0, 0, '0', '0', 'hero/', '', ''),
(27, 'rss_menu', 0, 0, '0', '0', 'rss_menu/', '', ''),
(28, 'fb_like_menu', 0, 0, '0', '0', 'social/', '', ''),
(29, 'twitter_menu', 0, 0, '0', '0', 'social/', '', ''),
(30, 'xurl_menu', 0, 0, '0', '0', 'social/', '', ''),
(31, 'tagcloud_menu', 0, 0, '0', '0', 'tagcloud/', '', ''),
(32, 'news_grid_menu', 2, 1, '0', '', 'news/', 'home', '{\n    "lastname_74758209201093747": "",\n    "caption": {\n        "English": ""\n    },\n    "category": "",\n    "source": "latest",\n    "layout": "col-lg-4",\n    "count": "4",\n    "feature": "0",\n    "titleLimit": "0",\n    "summaryLimit": "0"\n}'),
(33, 'news_archive_menu', 1, 1, '0', '', 'news/', '', ''),
(34, 'tagcloud_menu', 1, 2, '0', '', 'tagcloud/', '', '');

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

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

CREATE TABLE `[[dbprefix]]news` (
  `news_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `news_title` varchar(255) NOT NULL DEFAULT '',
  `news_sef` varchar(255) NOT NULL DEFAULT '',
  `news_body` longtext NOT NULL,
  `news_extended` longtext NOT NULL,
  `news_meta_title` varchar(255) NOT NULL DEFAULT '',
  `news_meta_keywords` varchar(255) NOT NULL DEFAULT '',
  `news_meta_description` text NOT NULL,
  `news_meta_robots` varchar(255) DEFAULT '',
  `news_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `news_modified` int(10) unsigned NOT NULL DEFAULT '0',
  `news_author` int(10) unsigned NOT NULL DEFAULT '0',
  `news_category` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `news_allow_comments` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `news_start` int(10) unsigned NOT NULL DEFAULT '0',
  `news_end` int(10) unsigned NOT NULL DEFAULT '0',
  `news_class` varchar(255) NOT NULL DEFAULT '0',
  `news_render_type` varchar(20) NOT NULL DEFAULT '0',
  `news_comment_total` int(10) unsigned NOT NULL DEFAULT '0',
  `news_summary` text NOT NULL,
  `news_thumbnail` text NOT NULL,
  `news_sticky` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `news_template` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`news_id`),
  KEY `news_category` (`news_category`),
  KEY `news_start_end` (`news_start`,`news_end`),
  KEY `news_datestamp` (`news_datestamp`),
  KEY `news_sticky` (`news_sticky`),
  KEY `news_render_type` (`news_render_type`),
  KEY `news_class` (`news_class`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `[[dbprefix]]news` VALUES
(1, 'News Item 1', 'item-1', '[html]<p>Lorem ipsum dolor sit amet, no meis semper dicunt est, petentium eloquentiam quo ne. At vero facer eam. Ex nam altera oportere, nisl natum prima id pro. Rebum augue dissentiet eum te, vel veniam eirmod option ea, at eos velit repudiare. Ius sumo dicit adolescens id, an cum efficiantur concludaturque.<br><br>Summo sensibus cum ne, et duo torquatos conceptam. No aeque elitr constituam qui. Nostro corpora nec no, diam verterem tincidunt has et. Altera accumsan urbanitas pro eu, ei assum voluptaria sed. Eam tibique nominavi consequuntur an.<br><br>Ei perfecto delicata usu, quo eius noster blandit te. Eu doctus volumus pri. Meis argumentum an nam, eos odio prima autem an. Te complectitur intellegebat pro, ius id alterum maiestatis. Ea facer accusata sed, ex illum antiopam quo.<br><br>Altera putent pri ad, in phaedrum dissentiunt per. Te eum everti dolores. Ut mea vero autem viderer, mel brute harum senserit id. Minim senserit eloquentiam duo in, sit ei justo graece petentium. Sea id homero oporteat invenire.<br><br>Pri semper dolorum ad. Cu eius repudiare eos. Eum in eleifend necessitatibus. Ne has mutat intellegebat.</p>[/html]', '[html]<p><strong>Lorem ipsum</strong> is a pseudo-Latin text used in web design, typography, layout, and printing in place of English to emphasise design elements over content. It&#039;s also called placeholder (or filler) text. It&#039;s a convenient tool for mock-ups. It helps to outline the visual elements of a document or presentation, eg typography, font, or layout. Lorem ipsum is mostly a part of a Latin text by the classical author and philosopher Cicero. Its words and letters have been changed by addition or removal, so to deliberately render its content nonsensical; it&#039;s not genuine, correct, or comprehensible Latin anymore.</p>\n<p>While <strong>lorem ipsum</strong>&#039;s still resembles classical Latin, it actually has no meaning whatsoever. As Cicero&#039;s text doesn&#039;t contain the letters K, W, or Z, alien to latin, these, and others are often inserted randomly to mimic the  typographic appearence of European languages, as are digraphs not to be found in the original.</p>[/html]', '', 'keyword1,keyword2', 'Description for Facebook and search engines.', '', 1641407400, 1649280924, 1, 1, 0, 0, 0, '0', '0', 0, 'Summo sensibus cum ne, et duo torquatos conceptam. No aeque elitr constituam qui. Nostro corpora nec no, diam verterem tincidunt has et.', '', 0, 'default'),
(2, 'News Item 2', 'item-2', '[html]<p>Lorem ipsum dolor sit amet, no meis semper dicunt est, petentium eloquentiam quo ne. At vero facer eam. Ex nam altera oportere, nisl natum prima id pro. Rebum augue dissentiet eum te, vel veniam eirmod option ea, at eos velit repudiare. Ius sumo dicit adolescens id, an cum efficiantur concludaturque.<br><br>Summo sensibus cum ne, et duo torquatos conceptam. No aeque elitr constituam qui. Nostro corpora nec no, diam verterem tincidunt has et. Altera accumsan urbanitas pro eu, ei assum voluptaria sed. Eam tibique nominavi consequuntur an.<br><br>Ei perfecto delicata usu, quo eius noster blandit te. Eu doctus volumus pri. Meis argumentum an nam, eos odio prima autem an. Te complectitur intellegebat pro, ius id alterum maiestatis. Ea facer accusata sed, ex illum antiopam quo.<br><br>Altera putent pri ad, in phaedrum dissentiunt per. Te eum everti dolores. Ut mea vero autem viderer, mel brute harum senserit id. Minim senserit eloquentiam duo in, sit ei justo graece petentium. Sea id homero oporteat invenire.<br><br>Pri semper dolorum ad. Cu eius repudiare eos. Eum in eleifend necessitatibus. Ne has mutat intellegebat.</p>[/html]', '[html]<p><strong>Lorem ipsum</strong> is a pseudo-Latin text used in web design, typography, layout, and printing in place of English to emphasise design elements over content. It&#039;s also called placeholder (or filler) text. It&#039;s a convenient tool for mock-ups. It helps to outline the visual elements of a document or presentation, eg typography, font, or layout. Lorem ipsum is mostly a part of a Latin text by the classical author and philosopher Cicero. Its words and letters have been changed by addition or removal, so to deliberately render its content nonsensical; it&#039;s not genuine, correct, or comprehensible Latin anymore.</p>\n<p>While <strong>lorem ipsum</strong>&#039;s still resembles classical Latin, it actually has no meaning whatsoever. As Cicero&#039;s text doesn&#039;t contain the letters K, W, or Z, alien to latin, these, and others are often inserted randomly to mimic the  typographic appearence of European languages, as are digraphs not to be found in the original.</p>[/html]', '', 'keyword3', 'Description for Facebook and search engines.', '', 1642298400, 1649280867, 1, 1, 0, 0, 0, '0', '0', 0, 'No aeque elitr constituam qui. Nostro corpora nec no, diam verterem tincidunt has et. Summo sensibus cum ne, et duo torquatos conceptam.', '', 0, 'default'),
(3, 'News Item 3', 'item-3', '[html]<p>Lorem ipsum dolor sit amet, no meis semper dicunt est, petentium eloquentiam quo ne. At vero facer eam. Ex nam altera oportere, nisl natum prima id pro. Rebum augue dissentiet eum te, vel veniam eirmod option ea, at eos velit repudiare. Ius sumo dicit adolescens id, an cum efficiantur concludaturque.<br><br>Summo sensibus cum ne, et duo torquatos conceptam. No aeque elitr constituam qui. Nostro corpora nec no, diam verterem tincidunt has et. Altera accumsan urbanitas pro eu, ei assum voluptaria sed. Eam tibique nominavi consequuntur an.<br><br>Ei perfecto delicata usu, quo eius noster blandit te. Eu doctus volumus pri. Meis argumentum an nam, eos odio prima autem an. Te complectitur intellegebat pro, ius id alterum maiestatis. Ea facer accusata sed, ex illum antiopam quo.<br><br>Altera putent pri ad, in phaedrum dissentiunt per. Te eum everti dolores. Ut mea vero autem viderer, mel brute harum senserit id. Minim senserit eloquentiam duo in, sit ei justo graece petentium. Sea id homero oporteat invenire.<br><br>Pri semper dolorum ad. Cu eius repudiare eos. Eum in eleifend necessitatibus. Ne has mutat intellegebat.</p>[/html]', '[html]<p><strong>Lorem ipsum</strong> is a pseudo-Latin text used in web design, typography, layout, and printing in place of English to emphasise design elements over content. It&#039;s also called placeholder (or filler) text. It&#039;s a convenient tool for mock-ups. It helps to outline the visual elements of a document or presentation, eg typography, font, or layout. Lorem ipsum is mostly a part of a Latin text by the classical author and philosopher Cicero. Its words and letters have been changed by addition or removal, so to deliberately render its content nonsensical; it&#039;s not genuine, correct, or comprehensible Latin anymore.</p>\n<p>While <strong>lorem ipsum</strong>&#039;s still resembles classical Latin, it actually has no meaning whatsoever. As Cicero&#039;s text doesn&#039;t contain the letters K, W, or Z, alien to latin, these, and others are often inserted randomly to mimic the  typographic appearence of European languages, as are digraphs not to be found in the original.</p>[/html]', '', 'keyword2', 'Description for Facebook and search engines.', '', 1643734800, 1649280894, 1, 1, 0, 0, 0, '0', '0', 0, 'Te eum everti dolores. Ut mea vero autem viderer, mel brute harum senserit id. Minim senserit eloquentiam duo in, sit ei justo graece petentium.', '', 0, 'default');

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

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

CREATE TABLE `[[dbprefix]]news_category` (
  `category_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `category_name` varchar(200) NOT NULL DEFAULT '',
  `category_sef` varchar(200) NOT NULL DEFAULT '',
  `category_meta_description` text NOT NULL,
  `category_meta_keywords` varchar(255) NOT NULL DEFAULT '',
  `category_manager` tinyint(3) unsigned NOT NULL DEFAULT '254',
  `category_icon` varchar(250) NOT NULL DEFAULT '',
  `category_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `category_template` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`category_id`),
  KEY `category_order` (`category_order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `[[dbprefix]]news_category` VALUES
(1, 'Misc', 'misc', '', '', 254, 'news_16.png', 0, NULL);

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

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

CREATE TABLE `[[dbprefix]]online` (
  `online_timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `online_flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `online_user_id` varchar(100) NOT NULL DEFAULT '',
  `online_ip` varchar(45) NOT NULL DEFAULT '',
  `online_location` text NOT NULL,
  `online_pagecount` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `online_active` int(10) unsigned NOT NULL DEFAULT '0',
  `online_agent` varchar(255) NOT NULL DEFAULT '',
  `online_language` varchar(2) NOT NULL DEFAULT '',
  KEY `online_ip` (`online_ip`),
  KEY `online_ip_user_id` (`online_ip`,`online_user_id`),
  KEY `online_timestamp` (`online_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE `[[dbprefix]]page` (
  `page_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `page_title` varchar(250) NOT NULL DEFAULT '',
  `page_subtitle` varchar(250) NOT NULL DEFAULT '',
  `page_sef` varchar(250) NOT NULL DEFAULT '',
  `page_chapter` int(10) unsigned NOT NULL DEFAULT '0',
  `page_metatitle` varchar(255) NOT NULL DEFAULT '',
  `page_metakeys` varchar(250) NOT NULL DEFAULT '',
  `page_metadscr` mediumtext,
  `page_metaimage` varchar(250) NOT NULL DEFAULT '',
  `page_metarobots` varchar(250) DEFAULT '',
  `page_text` mediumtext,
  `page_author` int(10) unsigned NOT NULL DEFAULT '0',
  `page_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `page_rating_flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `page_comment_flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `page_password` varchar(50) NOT NULL DEFAULT '',
  `page_class` varchar(250) NOT NULL DEFAULT '0',
  `page_ip_restrict` text,
  `page_template` varchar(50) NOT NULL DEFAULT '',
  `page_order` int(4) unsigned NOT NULL DEFAULT '9999',
  `page_fields` mediumtext,
  `menu_name` varchar(50) DEFAULT '',
  `menu_title` varchar(250) NOT NULL DEFAULT '',
  `menu_text` mediumtext,
  `menu_image` varchar(250) NOT NULL DEFAULT '',
  `menu_icon` varchar(250) NOT NULL DEFAULT '',
  `menu_template` varchar(50) NOT NULL DEFAULT '',
  `menu_class` varchar(250) NOT NULL DEFAULT '0',
  `menu_button_url` varchar(250) NOT NULL DEFAULT '',
  `menu_button_text` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`page_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

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

INSERT INTO `[[dbprefix]]page` VALUES
(1, 'Article 1', '', 'article-1', 2, '', '', '', '', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec libero ipsum; imperdiet at risus non, dictum sagittis odio! Nulla facilisi. Pellentesque adipiscing facilisis pharetra. Morbi imperdiet augue in ligula luctus, et iaculis est porttitor. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. In ultricies vitae nisi ut porttitor. Curabitur lectus tellus, feugiat a elit vel, gravida iaculis dui. Nulla vulputate turpis dui, ac faucibus enim dignissim non. Ut non tellus suscipit, scelerisque orci sed, scelerisque sapien. Aenean convallis sodales nulla in porttitor. In pretium ante sapien, a tempor eros blandit nec.\n\n			Nulla non est nibh? Fusce lacinia quam adipiscing magna posuere dapibus. Sed mollis condimentum rhoncus. Morbi sollicitudin tellus a ligula luctus, ac varius arcu ullamcorper. Mauris in aliquet tellus, nec porttitor dui. Quisque interdum euismod mi sed bibendum. Vivamus non odio quis quam lacinia rhoncus in nec nibh. Integer vitae turpis condimentum, laoreet diam nec viverra fusce.', 1, 1371420000, 1, 1, '', '0', '', 'default', 9999, '', 'jumbotron-menu-1', 'Heading 1', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus auctor egestas condimentum. Suspendisse placerat nunc orci, a ultrices tortor eleifend in. Vestibulum tincidunt fringilla malesuada? Phasellus dolor risus, aliquam eu odio quis, mattis cursus magna. Integer ut blandit purus; vitae posuere ante. Vivamus sapien nisl, pulvinar vel turpis a, malesuada vehicula lorem! Curabitur magna justo; laoreet at congue sit amet, tincidunt sit amet erat. Integer vehicula eros quis odio tincidunt, nec dapibus sem molestie. Cras sed viverra eros. Nulla ut lectus tellus.', '', '', 'button', '0', '', ''),
(2, 'Article 2', '', 'article-2', 2, '', '', '', '', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam a nunc eget nulla rutrum fringilla sed vel nisl. Suspendisse at erat a neque pulvinar sodales. Etiam dictum erat erat. Pellentesque dictum convallis massa, eu varius sapien gravida a. Suspendisse auctor, mi a tempor tincidunt, lorem felis gravida libero, nec mattis eros felis eu neque. Etiam vel sagittis ipsum. Morbi at libero accumsan mauris tincidunt adipiscing sed vitae mauris. Aenean suscipit consectetur dignissim. Aliquam ornare diam vitae libero suscipit eget facilisis nisl ultrices? Curabitur luctus turpis ac lorem iaculis id interdum massa blandit! Curabitur placerat massa at neque accumsan porta. Nulla sed tortor id sapien dapibus auctor at eget mi. Sed ultrices lacinia viverra.Mauris in purus mauris. Nulla facilisi. Suspendisse dui enim, dapibus sed accumsan non, gravida eget nulla. Praesent ullamcorper, est ac viverra congue, nisl lacus imperdiet sem, et laoreet velit mauris sed leo. Donec erat mi, luctus quis suscipit pretium, luctus sed orci. Proin eu ultricies sem. Nam mollis turpis non erat fermentum congue.Nullam adipiscing, purus et varius blandit, arcu nisi pretium urna, a euismod eros eros quis turpis! Aliquam quis mi turpis, in varius neque. Aliquam erat volutpat. Vestibulum venenatis ipsum dapibus ante dictum egestas. Pellentesque eget nisi ligula, id accumsan eros. Aenean vitae felis vitae sapien mattis pellentesque non nec dolor. Nulla facilisi.Quisque in tortor turpis, sed venenatis nunc. Nunc tellus elit, suscipit et accumsan ac, mollis et risus. Phasellus consectetur sapien in felis semper non tempor tortor mollis. Ut id leo vel magna rhoncus aliquet. Nunc eget sollicitudin felis. Vestibulum tempor, justo et congue dignissim, augue ipsum malesuada libero, id suscipit felis mi vitae erat. Etiam suscipit lacinia sapien, ac gravida nisi lobortis non. Suspendisse dictum risus in est egestas egestas. Aenean et nisi sed odio sollicitudin placerat vel ut magna. Nulla facilisi. Proin condimentum ultricies vulputate. Morbi dapibus elit a tellus elementum congue! In vitae aliquet leo. Proin tempus tincidunt magna, sit amet malesuada ipsum ornare sed. Sed lorem augue, aliquam sit amet hendrerit sed; venenatis in massa. Sed iaculis amet.', 1, 1366149600, 0, 0, '', '0', '', 'default', 9999, '', 'jumbotron-menu-2', 'Heading 2', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus auctor egestas condimentum. Suspendisse placerat nunc orci, a ultrices tortor eleifend in. Vestibulum tincidunt fringilla malesuada? Phasellus dolor risus, aliquam eu odio quis, mattis cursus magna. Integer ut blandit purus; vitae posuere ante. Vivamus sapien nisl, pulvinar vel turpis a, malesuada vehicula lorem! Curabitur magna justo; laoreet at congue sit amet, tincidunt sit amet erat. Integer vehicula eros quis odio tincidunt, nec dapibus sem molestie. Cras sed viverra eros. Nulla ut lectus tellus.', '', '', 'button', '0', '', ''),
(3, 'Article 3', '', 'article-3', 2, '', '', '', '', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum porttitor a justo ut tristique. Nam molestie sem at leo lobortis, vel luctus ligula tempus. Sed sagittis rutrum lectus vel suscipit. Sed in ligula vitae massa sagittis adipiscing vitae vel sem. Fusce nec rhoncus purus. Aenean mollis magna tellus; non consequat leo feugiat eu. Donec mauris velit, euismod nec facilisis quis, hendrerit nec lorem. Aliquam et lorem sed enim tempus sodales. Vestibulum ut enim adipiscing ipsum semper eleifend in in dolor. Fusce tempor risus velit, in fringilla tellus faucibus eget. Maecenas aliquet nunc nec nulla auctor, sed tristique est pellentesque. Maecenas tristique blandit dolor, nec egestas ligula aliquam eu.\n\nMorbi porta leo iaculis, hendrerit lorem interdum, porta dui. Integer tempor convallis quam, eget tempus neque blandit sit amet. Quisque dictum libero elit, ut vehicula lectus accumsan a. Nam laoreet vulputate massa vel viverra. Sed tempus blandit sapien, in viverra urna aliquet quis. Aliquam erat volutpat. Nulla accumsan posuere.', 1, 1336600800, 0, 0, '', '0', '', 'default', 9999, '', 'jumbotron-menu-3', 'Heading 3', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus auctor egestas condimentum. Suspendisse placerat nunc orci, a ultrices tortor eleifend in. Vestibulum tincidunt fringilla malesuada? Phasellus dolor risus, aliquam eu odio quis, mattis cursus magna. Integer ut blandit purus; vitae posuere ante. Vivamus sapien nisl, pulvinar vel turpis a, malesuada vehicula lorem! Curabitur magna justo; laoreet at congue sit amet, tincidunt sit amet erat. Integer vehicula eros quis odio tincidunt, nec dapibus sem molestie. Cras sed viverra eros. Nulla ut lectus tellus.', '', '', 'button', '0', '', ''),
(4, 'Article 4', '', 'article-4', 3, '', '', '', '', '', '[html]<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum porttitor a justo ut tristique. Nam molestie sem at leo lobortis, vel luctus ligula tempus. Sed sagittis rutrum lectus vel suscipit. Sed in ligula vitae massa sagittis adipiscing vitae vel sem. Fusce nec rhoncus purus. Aenean mollis magna tellus; non consequat leo feugiat eu. Donec mauris velit, euismod nec facilisis quis, hendrerit nec lorem. Aliquam et lorem sed enim tempus sodales. Vestibulum ut enim adipiscing ipsum semper eleifend in in dolor. Fusce tempor risus velit, in fringilla tellus faucibus eget. Maecenas aliquet nunc nec nulla auctor, sed tristique est pellentesque. Maecenas tristique blandit dolor, nec egestas ligula aliquam eu. Morbi porta leo iaculis, hendrerit lorem interdum, porta dui. Integer tempor convallis quam, eget tempus neque blandit sit amet. Quisque dictum libero elit, ut vehicula lectus accumsan a. Nam laoreet vulputate massa vel viverra. Sed tempus blandit sapien, in viverra urna aliquet quis. Aliquam erat volutpat. Nulla accumsan posuere.</p>[/html]', 1, 1535407200, 0, 0, '', '0', '', 'customfields', 9999, '{\n    "mybbarea": "[html]<p>Some <strong>Rich<\\/strong> <em>Text<\\/em><\\/p>[\\/html]",\n    "myboolean": "0",\n    "mycheckbox": "1",\n    "mycountry": "us",\n    "mydatestamp": "1534978508",\n    "mydropdown": "blue",\n    "myemail": "myemail@somewhere.com",\n    "myfile": "",\n    "myicon": "{e_IMAGE}e107_icon_32.png",\n    "myimage": "{e_PLUGIN}gallery/images/butterfly.jpg",\n    "mylanguage": "en",\n    "mynumber": "16",\n    "myprogressbar": "6\\/10",\n    "mytags": "keyword1,keyword2",\n    "mytext": "Some Text",\n    "myurl": "https:\\/\\/e107.org",\n    "myvideo": "6ZfuNTqbHE8.youtube"\n}', 'jumbotron-menu-4', 'Heading 4', '[html]<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus auctor egestas condimentum. Suspendisse placerat nunc orci, a ultrices tortor eleifend in. Vestibulum tincidunt fringilla malesuada? Phasellus dolor risus, aliquam eu odio quis, mattis cursus magna. Integer ut blandit purus; vitae posuere ante. Vivamus sapien nisl, pulvinar vel turpis a, malesuada vehicula lorem! Curabitur magna justo; laoreet at congue sit amet, tincidunt sit amet erat. Integer vehicula eros quis odio tincidunt, nec dapibus sem molestie. Cras sed viverra eros. Nulla ut lectus tellus.</p>[/html]', '', '', 'button', '0', '', ''),
(5, 'Feature 1', '', 'feature-1', 2, '', '', '', '', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum porttitor a justo ut tristique. Nam molestie sem at leo lobortis, vel luctus ligula tempus. Sed sagittis rutrum lectus vel suscipit. Sed in ligula vitae massa sagittis adipiscing vitae vel sem. Fusce nec rhoncus purus. Aenean mollis magna tellus; non consequat leo feugiat eu. Donec mauris velit, euismod nec facilisis quis, hendrerit nec lorem. Aliquam et lorem sed enim tempus sodales. Vestibulum ut enim adipiscing ipsum semper eleifend in in dolor. Fusce tempor risus velit, in fringilla tellus faucibus eget. Maecenas aliquet nunc nec nulla auctor, sed tristique est pellentesque. Maecenas tristique blandit dolor, nec egestas ligula aliquam eu.\n\nMorbi porta leo iaculis, hendrerit lorem interdum, porta dui. Integer tempor convallis quam, eget tempus neque blandit sit amet. Quisque dictum libero elit, ut vehicula lectus accumsan a. Nam laoreet vulputate massa vel viverra. Sed tempus blandit sapien, in viverra urna aliquet quis. Aliquam erat volutpat. Nulla accumsan posuere.', 1, 1344549600, 0, 0, '', '0', '', 'default', 9999, '', 'feature-menu-1', 'Modern Business Feature Menu 1', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla iaculis odio sit amet mi consequat varius. Nullam fringilla sodales lacus id mollis. Morbi fermentum turpis quis orci scelerisque, non pellentesque dolor sodales. Nullam luctus ut tellus quis ullamcorper! Suspendisse convallis tortor nec semper condimentum. Proin adipiscing adipiscing elit, ut posuere mauris consequat sed. Maecenas ultrices nisi tortor, sed vehicula urna auctor euismod?', '', '', '2-column_1:1_text-left', '0', '', ''),
(6, 'Feature 2', '', 'feature-2', 2, '', '', '', '', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum porttitor a justo ut tristique. Nam molestie sem at leo lobortis, vel luctus ligula tempus. Sed sagittis rutrum lectus vel suscipit. Sed in ligula vitae massa sagittis adipiscing vitae vel sem. Fusce nec rhoncus purus. Aenean mollis magna tellus; non consequat leo feugiat eu. Donec mauris velit, euismod nec facilisis quis, hendrerit nec lorem. Aliquam et lorem sed enim tempus sodales. Vestibulum ut enim adipiscing ipsum semper eleifend in in dolor. Fusce tempor risus velit, in fringilla tellus faucibus eget. Maecenas aliquet nunc nec nulla auctor, sed tristique est pellentesque. Maecenas tristique blandit dolor, nec egestas ligula aliquam eu.\n\nMorbi porta leo iaculis, hendrerit lorem interdum, porta dui. Integer tempor convallis quam, eget tempus neque blandit sit amet. Quisque dictum libero elit, ut vehicula lectus accumsan a. Nam laoreet vulputate massa vel viverra. Sed tempus blandit sapien, in viverra urna aliquet quis. Aliquam erat volutpat. Nulla accumsan posuere.', 1, 1347228000, 0, 0, '', '0', '', 'default', 9999, '', 'feature-menu-2', 'Modern Business Feature Menu 2', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla iaculis odio sit amet mi consequat varius. Nullam fringilla sodales lacus id mollis. Morbi fermentum turpis quis orci scelerisque, non pellentesque dolor sodales. Nullam luctus ut tellus quis ullamcorper! Suspendisse convallis tortor nec semper condimentum. Proin adipiscing adipiscing elit, ut posuere mauris consequat sed. Maecenas ultrices nisi tortor, sed vehicula urna auctor euismod?', '', '', '2-column_1:1_text-right', '0', '', ''),
(7, 'Feature 3', '', 'feature-3', 2, '', '', '', '', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum porttitor a justo ut tristique. Nam molestie sem at leo lobortis, vel luctus ligula tempus. Sed sagittis rutrum lectus vel suscipit. Sed in ligula vitae massa sagittis adipiscing vitae vel sem. Fusce nec rhoncus purus. Aenean mollis magna tellus; non consequat leo feugiat eu. Donec mauris velit, euismod nec facilisis quis, hendrerit nec lorem. Aliquam et lorem sed enim tempus sodales. Vestibulum ut enim adipiscing ipsum semper eleifend in in dolor. Fusce tempor risus velit, in fringilla tellus faucibus eget. Maecenas aliquet nunc nec nulla auctor, sed tristique est pellentesque. Maecenas tristique blandit dolor, nec egestas ligula aliquam eu.\n\nMorbi porta leo iaculis, hendrerit lorem interdum, porta dui. Integer tempor convallis quam, eget tempus neque blandit sit amet. Quisque dictum libero elit, ut vehicula lectus accumsan a. Nam laoreet vulputate massa vel viverra. Sed tempus blandit sapien, in viverra urna aliquet quis. Aliquam erat volutpat. Nulla accumsan posuere.', 1, 1349820000, 0, 0, '', '0', '', 'default', 9999, '', 'feature-menu-3', '&#039;Modern Business&#039; is a ready-to-use, Bootstrap 3 updated, multi-purpose HTML theme!', 'For more templates and more page options that you can integrate into this website template, visit Start Bootstrap!', '', '', '2-column_2:1_text-left', '0', '', ''),
(8, 'Privacy Policy', '', 'privacy-policy', 0, '', '', '', '', '', '[html]<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>[/html]', 1, 1649288049, 0, 0, '', '0', '', 'default', 10000, '', '', '', '', '', '', 'default', '0', '', ''),
(9, 'Terms of Use', '', 'terms-of-use', 0, '', '', '', '', '', '[html]<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n<div class=&quot;page-generator__output js-generator-output&quot; id=&quot;output&quot;>\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis hendrerit dolor magna eget est lorem ipsum. Gravida cum sociis natoque penatibus. Hendrerit gravida rutrum quisque non tellus. Iaculis at erat pellentesque adipiscing commodo elit at imperdiet dui. Neque ornare aenean euismod elementum nisi quis eleifend quam adipiscing. Diam sollicitudin tempor id eu nisl nunc mi ipsum faucibus. Risus commodo viverra maecenas accumsan. Augue ut lectus arcu bibendum at varius vel pharetra vel. Condimentum vitae sapien pellentesque habitant morbi tristique senectus et. Mi in nulla posuere sollicitudin aliquam ultrices sagittis. Facilisis magna etiam tempor orci eu lobortis elementum. Enim diam vulputate ut pharetra sit amet aliquam id diam. Sodales ut etiam sit amet. Proin nibh nisl condimentum id venenatis a. Donec enim diam vulputate ut pharetra sit. Leo vel orci porta non.</p>\n<p>Sed odio morbi quis commodo odio aenean. Nisl condimentum id venenatis a condimentum. Risus commodo viverra maecenas accumsan lacus vel. Ac auctor augue mauris augue neque gravida. At quis risus sed vulputate odio ut. Vitae auctor eu augue ut lectus arcu bibendum at varius. Morbi blandit cursus risus at ultrices mi tempus imperdiet nulla. Libero justo laoreet sit amet cursus sit amet dictum sit. Mollis nunc sed id semper risus in hendrerit gravida. Eget duis at tellus at urna condimentum mattis. Arcu odio ut sem nulla pharetra diam sit. Odio ut enim blandit volutpat maecenas volutpat. Commodo odio aenean sed adipiscing diam donec. Fermentum et sollicitudin ac orci phasellus egestas tellus rutrum. Mattis aliquam faucibus purus in massa tempor.</p>\n<p>Leo vel fringilla est ullamcorper eget nulla facilisi. Tempus quam pellentesque nec nam aliquam. Nullam non nisi est sit amet. Elit ullamcorper dignissim cras tincidunt lobortis feugiat vivamus at. Suscipit tellus mauris a diam maecenas sed enim ut. Vitae sapien pellentesque habitant morbi. Metus aliquam eleifend mi in nulla posuere sollicitudin. Augue interdum velit euismod in pellentesque massa. Eget dolor morbi non arcu risus quis. Aliquam purus sit amet luctus venenatis. Mauris a diam maecenas sed enim ut sem. Dolor sit amet consectetur adipiscing elit duis tristique sollicitudin. Facilisi morbi tempus iaculis urna id volutpat lacus laoreet. Mi bibendum neque egestas congue quisque egestas diam in arcu. Nunc congue nisi vitae suscipit tellus mauris a. Urna nec tincidunt praesent semper feugiat nibh sed. Ultrices in iaculis nunc sed augue lacus viverra vitae congue.</p>\n<p>Morbi tristique senectus et netus et. Aliquet risus feugiat in ante metus dictum at. Nunc aliquet bibendum enim facilisis gravida neque convallis a. Turpis egestas integer eget aliquet nibh praesent tristique magna sit. Vivamus arcu felis bibendum ut. Phasellus egestas tellus rutrum tellus pellentesque eu. Dolor sit amet consectetur adipiscing. Est ullamcorper eget nulla facilisi etiam dignissim diam quis. Posuere morbi leo urna molestie at elementum eu. Penatibus et magnis dis parturient montes nascetur ridiculus mus.</p>\n<p>Gravida rutrum quisque non tellus. Ac felis donec et odio pellentesque diam. Vehicula ipsum a arcu cursus vitae congue mauris rhoncus. Eget mauris pharetra et ultrices neque ornare aenean euismod. Eu non diam phasellus vestibulum lorem. Commodo quis imperdiet massa tincidunt nunc pulvinar sapien et. Lacus vel facilisis volutpat est. Amet consectetur adipiscing elit ut aliquam purus sit amet luctus. Cras ornare arcu dui vivamus arcu felis bibendum ut. Consequat nisl vel pretium lectus quam id leo in vitae.</p>\n</div>[/html]', 1, 1649288155, 0, 0, '', '0', '', 'default', 10001, '', '', '', '', '', '', 'default', '0', '', '');

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

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

CREATE TABLE `[[dbprefix]]page_chapters` (
  `chapter_id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `chapter_parent` int(4) unsigned NOT NULL DEFAULT '0',
  `chapter_name` varchar(200) NOT NULL DEFAULT '',
  `chapter_sef` varchar(200) NOT NULL DEFAULT '',
  `chapter_meta_description` text NOT NULL,
  `chapter_meta_keywords` varchar(255) NOT NULL DEFAULT '',
  `chapter_manager` tinyint(3) unsigned NOT NULL DEFAULT '254',
  `chapter_icon` varchar(250) NOT NULL DEFAULT '',
  `chapter_image` varchar(250) NOT NULL DEFAULT '',
  `chapter_order` int(6) unsigned NOT NULL DEFAULT '0',
  `chapter_template` varchar(50) NOT NULL DEFAULT '',
  `chapter_visibility` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `chapter_fields` mediumtext,
  PRIMARY KEY (`chapter_id`),
  KEY `chapter_order` (`chapter_order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `[[dbprefix]]page_chapters` VALUES
(1, 0, 'General', 'general', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec et tempor odio. Quisque volutpat lorem nec lectus congue suscipit. In hac habitasse platea dictumst. Etiam odio nisi, egestas vitae amet.', '', 254, '', '', 0, '', 0, ''),
(2, 1, 'Chapter 1', 'chapter-1', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nunc ac neque egestas ullamcorper. In convallis semper hendrerit. Etiam non dolor nisl, varius facilisis dui. Nunc egestas massa nunc.', '', 254, '', '', 1, '', 0, ''),
(3, 1, 'Custom Fields', 'customfields', 'Chapter containing custom fields', '', 254, '', '', 2, 'default', 0, '{\n    "__tabs__": {\n        "additional": "Custom Fields"\n    },\n    "mybbarea": {\n        "title": "Rich Text",\n        "type": "bbarea",\n        "writeParms": "",\n        "help": ""\n    },\n    "myboolean": {\n        "title": "Boolean",\n        "type": "boolean",\n        "writeParms": "",\n        "help": ""\n    },\n    "mycheckbox": {\n        "title": "Checkbox",\n        "type": "checkbox",\n        "writeParms": "",\n        "help": ""\n    },\n    "mycountry": {\n        "title": "Country",\n        "type": "country",\n        "writeParms": "",\n        "help": ""\n    },\n    "mydatestamp": {\n        "title": "Date",\n        "type": "datestamp",\n        "writeParms": "{ \\"format\\": \\"yyyy-mm-dd\\" }",\n        "help": ""\n    },\n    "mydropdown": {\n        "title": "Selection",\n        "type": "dropdown",\n        "writeParms": "{ \\"optArray\\": { \\"blue\\": \\"Blue\\", \\"green\\": \\"Green\\", \\"red\\": \\"Red\\" }, \\"default\\": \\"blank\\" }",\n        "help": ""\n    },\n    "myemail": {\n        "title": "Email",\n        "type": "email",\n        "writeParms": "",\n        "help": ""\n    },\n    "myfile": {\n        "title": "File",\n        "type": "file",\n        "writeParms": "",\n        "help": ""\n    },\n    "myicon": {\n        "title": "Icon",\n        "type": "icon",\n        "writeParms": "",\n        "help": ""\n    },\n    "myimage": {\n        "title": "Image",\n        "type": "image",\n        "writeParms": "",\n        "help": ""\n    },\n    "mylanguage": {\n        "title": "Language",\n        "type": "language",\n        "writeParms": "",\n        "help": ""\n    },\n    "mynumber": {\n        "title": "Number",\n        "type": "number",\n        "writeParms": "",\n        "help": ""\n    },\n    "myprogressbar": {\n        "title": "Progress",\n        "type": "progressbar",\n        "writeParms": "",\n        "help": ""\n    },\n    "mytags": {\n        "title": "Tags",\n        "type": "tags",\n        "writeParms": "",\n        "help": ""\n    },\n    "mytext": {\n        "title": "Text",\n        "type": "text",\n        "writeParms": "",\n        "help": ""\n    },\n    "myurl": {\n        "title": "URL",\n        "type": "url",\n        "writeParms": "",\n        "help": ""\n    },\n    "myvideo": {\n        "title": "Video",\n        "type": "video",\n        "writeParms": "",\n        "help": ""\n    }\n}');

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

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

CREATE TABLE `[[dbprefix]]plugin` (
  `plugin_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `plugin_name` varchar(100) NOT NULL DEFAULT '',
  `plugin_version` varchar(10) NOT NULL DEFAULT '',
  `plugin_path` varchar(100) NOT NULL DEFAULT '',
  `plugin_installflag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `plugin_addons` text NOT NULL,
  `plugin_category` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`plugin_id`),
  UNIQUE KEY `plugin_path` (`plugin_path`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;

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

INSERT INTO `[[dbprefix]]plugin` VALUES
(1, 'LAN_PLUGIN_BANNER_NAME', '1.0', 'banner', 0, 'e_menu,e_shortcode,banner_sql', 'content'),
(2, 'LAN_PLUGIN__BLANK_NAME', '2.0', '_blank', 0, 'e_admin,e_cron,e_notify,e_print,e_frontpage,e_menu,e_search,e_shortcode,e_event,e_dashboard,e_header,e_url,e_sitelink,e_parse,e_print,e_related,e_rss,e_user,e_library,_blank_sql', 'misc'),
(3, 'LAN_PLUGIN_CHATBOX_MENU_NAME', '1.0', 'chatbox_menu', 0, 'e_notify,e_list,e_search,e_dashboard,e_header,e_rss,e_user,chatbox_sql', 'content'),
(4, 'Contact', '1.0', 'contact', 1, 'e_url', 'menu'),
(5, 'LAN_PLUGIN_DOWNLOAD_NAME', '1.2', 'download', 0, 'e_cron,e_notify,e_list,e_frontpage,e_search,e_dashboard,e_tagwords,e_url,e_sitelink,e_rss,e_upload,e_gsitemap,download_sql', 'content'),
(6, 'LAN_PLUGIN_FEATUREBOX_NAME', '1.1', 'featurebox', 0, 'e_shortcode,e_header,e_rss,featurebox_sql', 'content'),
(7, 'LAN_PLUGIN_FORUM_NAME', '2.1', 'forum', 0, 'e_notify,e_linkgen,e_list,e_meta,e_emailprint,e_print,e_frontpage,e_menu,e_search,e_event,e_dashboard,e_url,e_print,e_rss,e_user,e_gsitemap,forum_sql', 'content'),
(8, 'LAN_PLUGIN_GALLERY_TITLE', '1.1', 'gallery', 1, 'e_shortcode,e_header,e_url,e_library', 'content'),
(9, 'LAN_PLUGIN_GSITEMAP_NAME', '1.0', 'gsitemap', 0, 'e_cron,e_module,e_event,e_header,e_url,gsitemap_sql', 'misc'),
(10, 'LAN_PLUGIN_HERO_NAME', '1.0', 'hero', 1, 'e_shortcode,e_header,hero_sql', 'content'),
(11, 'LAN_PLUGIN_IMPORT_NAME', '1.0', 'import', 0, '', 'tools'),
(12, 'LAN_PLUGIN_LINKWORDS_NAME', '2.0', 'linkwords', 0, 'e_admin,e_header,e_tohtml,e_parse,linkwords_sql', 'content'),
(13, 'LAN_PLUGIN_LIST_NEW_NAME', '1.0.1', 'list_new', 0, '', 'content'),
(14, 'Navigation', '1.0', 'navigation', 1, 'e_menu', 'menu'),
(15, 'News', '1.0', 'news', 1, 'e_frontpage,e_menu,e_search,e_event,e_header,e_url,e_sitelink,e_featurebox,e_related,e_rss,e_gsitemap', 'menu'),
(16, 'LAN_PLUGIN_NEWSFEEDS_NAME', '2.1', 'newsfeed', 0, 'e_frontpage,e_url,newsfeed_sql', 'content'),
(17, 'Pages', '1.0', 'page', 1, 'e_frontpage,e_menu,e_search,e_shortcode,e_sitelink,e_related', 'menu'),
(18, 'LAN_PLUGIN_PM_NAME', '3.0', 'pm', 0, 'e_cron,e_shortcode,e_url,pm_sql', 'users'),
(19, 'LAN_PLUGIN_POLL_NAME', '2.0', 'poll', 0, 'poll_sql', 'content'),
(20, 'LAN_PLUGIN_RSS_NAME', '1.3', 'rss_menu', 1, 'e_meta,e_url,rss_sql', 'misc'),
(21, 'Signin', '1.0', 'signin', 1, 'e_shortcode', 'menu'),
(22, 'Siteinfo', '1.0', 'siteinfo', 1, 'e_shortcode', 'menu'),
(23, 'LAN_PLUGIN_SOCIAL_NAME', '1.0', 'social', 1, 'e_admin,e_menu,e_shortcode,e_module,e_event,e_comment', 'settings'),
(24, 'LAN_PLUGIN_TAGCLOUD_NAME', '1.3', 'tagcloud', 1, 'e_menu,e_header', 'misc'),
(25, 'TinyMce4', '1.0', 'tinymce4', 1, 'e_header,e_footer', 'misc'),
(26, 'LAN_PLUGIN_USER_NAME', '1.0', 'user', 1, 'e_search,e_dashboard,e_mailout,e_user', 'misc');

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

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

CREATE TABLE `[[dbprefix]]rate` (
  `rate_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rate_table` varchar(100) NOT NULL DEFAULT '',
  `rate_itemid` int(10) unsigned NOT NULL DEFAULT '0',
  `rate_rating` int(10) unsigned NOT NULL DEFAULT '0',
  `rate_votes` int(10) unsigned NOT NULL DEFAULT '0',
  `rate_voters` text NOT NULL,
  `rate_up` int(10) unsigned NOT NULL DEFAULT '0',
  `rate_down` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`rate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]rss` (
  `rss_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rss_name` varchar(255) NOT NULL DEFAULT '',
  `rss_url` text NOT NULL,
  `rss_topicid` varchar(255) NOT NULL DEFAULT '',
  `rss_path` varchar(255) NOT NULL DEFAULT '',
  `rss_text` longtext NOT NULL,
  `rss_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `rss_class` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `rss_limit` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`rss_id`),
  KEY `rss_name` (`rss_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `[[dbprefix]]rss` VALUES
(1, 'News', 'news', '0', '0', 'The rss feed of the news', 1456448477, 0, 10);

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

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

CREATE TABLE `[[dbprefix]]session` (
  `session_id` varchar(250) NOT NULL DEFAULT '',
  `session_expires` int(10) unsigned NOT NULL DEFAULT '0',
  `session_user` int(10) unsigned DEFAULT NULL,
  `session_data` longtext NOT NULL,
  PRIMARY KEY (`session_id`),
  KEY `session_expires` (`session_expires`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE `[[dbprefix]]submitnews` (
  `submitnews_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `submitnews_name` varchar(100) NOT NULL DEFAULT '',
  `submitnews_email` varchar(100) NOT NULL DEFAULT '',
  `submitnews_user` int(10) unsigned NOT NULL DEFAULT '0',
  `submitnews_title` varchar(200) NOT NULL DEFAULT '',
  `submitnews_category` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `submitnews_item` text NOT NULL,
  `submitnews_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `submitnews_ip` varchar(45) NOT NULL DEFAULT '',
  `submitnews_auth` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `submitnews_file` text NOT NULL,
  `submitnews_keywords` varchar(255) NOT NULL DEFAULT '',
  `submitnews_description` text,
  `submitnews_summary` text,
  `submitnews_media` text,
  PRIMARY KEY (`submitnews_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]tmp` (
  `tmp_ip` varchar(45) NOT NULL DEFAULT '',
  `tmp_time` int(10) unsigned NOT NULL DEFAULT '0',
  `tmp_info` text NOT NULL,
  KEY `tmp_ip` (`tmp_ip`),
  KEY `tmp_time` (`tmp_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `[[dbprefix]]upload` (
  `upload_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `upload_poster` varchar(100) NOT NULL DEFAULT '',
  `upload_email` varchar(100) NOT NULL DEFAULT '',
  `upload_website` varchar(100) NOT NULL DEFAULT '',
  `upload_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `upload_name` varchar(100) NOT NULL DEFAULT '',
  `upload_version` varchar(10) NOT NULL DEFAULT '',
  `upload_file` varchar(180) NOT NULL DEFAULT '',
  `upload_ss` varchar(100) NOT NULL DEFAULT '',
  `upload_description` text NOT NULL,
  `upload_demo` varchar(100) NOT NULL DEFAULT '',
  `upload_filesize` int(10) unsigned NOT NULL DEFAULT '0',
  `upload_active` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `upload_category` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `upload_owner` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`upload_id`),
  KEY `upload_active` (`upload_active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]user` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(100) NOT NULL DEFAULT '',
  `user_loginname` varchar(100) NOT NULL DEFAULT '',
  `user_customtitle` varchar(100) NOT NULL DEFAULT '',
  `user_password` varchar(255) NOT NULL DEFAULT '',
  `user_sess` varchar(100) NOT NULL DEFAULT '',
  `user_email` varchar(100) NOT NULL DEFAULT '',
  `user_signature` text NOT NULL,
  `user_image` varchar(255) NOT NULL DEFAULT '',
  `user_hideemail` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `user_join` int(10) unsigned NOT NULL DEFAULT '0',
  `user_lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
  `user_currentvisit` int(10) unsigned NOT NULL DEFAULT '0',
  `user_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `user_chats` int(10) unsigned NOT NULL DEFAULT '0',
  `user_comments` int(10) unsigned NOT NULL DEFAULT '0',
  `user_ip` varchar(45) NOT NULL DEFAULT '',
  `user_ban` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_prefs` text NOT NULL,
  `user_visits` int(10) unsigned NOT NULL DEFAULT '0',
  `user_admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_login` varchar(100) NOT NULL DEFAULT '',
  `user_class` text NOT NULL,
  `user_perms` text NOT NULL,
  `user_realm` text NOT NULL,
  `user_pwchange` int(10) unsigned NOT NULL DEFAULT '0',
  `user_xup` text,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  UNIQUE KEY `user_loginname` (`user_loginname`),
  KEY `join_ban_index` (`user_join`,`user_ban`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `[[dbprefix]]user` VALUES
(1, '[[admin_realname]]', '[[admin_username]]', '', '[[admin_pass]]', '', '[[admin_email]]', '', '', 0, [[timestamp]], 0, 0, 0, 0, 0, '[[clientip]]', 0, '', 0, 1, '', '', '0', '', [[timestamp]], '');

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

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

CREATE TABLE `[[dbprefix]]userclass_classes` (
  `userclass_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `userclass_name` varchar(100) NOT NULL DEFAULT '',
  `userclass_description` varchar(250) NOT NULL DEFAULT '',
  `userclass_editclass` smallint(5) unsigned NOT NULL DEFAULT '0',
  `userclass_parent` smallint(5) unsigned NOT NULL DEFAULT '0',
  `userclass_accum` varchar(250) NOT NULL DEFAULT '',
  `userclass_visibility` smallint(5) NOT NULL DEFAULT '0',
  `userclass_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `userclass_icon` varchar(250) NOT NULL DEFAULT '',
  `userclass_perms` text NOT NULL,
  PRIMARY KEY (`userclass_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `[[dbprefix]]userclass_classes` VALUES
(2, 'CONTACT PEOPLE', 'Example contact person class', 254, 0, '0,2', 0, 0, '', ''),
(3, 'NEWSLETTER', 'Subscribe to Newsletter', 0, 255, '3', 0, 0, '', ''),
(253, 'Members', 'Registered and logged in members', 250, 0, '0,253', 253, 0, '', ''),
(246, 'Search Bots', 'Identified search bots', 250, 0, '0,246', 254, 0, '', ''),
(254, 'Admin', 'Site Administrators', 250, 0, '0,254', 253, 0, '', ''),
(248, 'Forum Moderators', 'Moderators for Forums and other areas', 250, 0, '0,248', 253, 0, '', ''),
(249, 'Admins and Mods', 'Anyone able to administer something, moderate forums etc', 250, 0, '0,249', 253, 0, '', ''),
(1, 'PRIVATEMENU', 'Grants access to private menu items', 254, 0, '0,1', 0, 0, '', ''),
(247, 'New Users', 'Recently joined users', 250, 0, '0,247', 254, 0, '', ''),
(250, 'Main Admin', 'Main site Administrators', 250, 0, '0,250', 253, 0, '', ''),
(0, 'Everyone (public)', 'Fixed class', 250, 0, '0', 0, 0, '', ''),
(252, 'Guests', 'Fixed class', 250, 0, '0,252', 0, 0, '', ''),
(255, 'No One (inactive)', 'Fixed class', 250, 0, '255', 0, 0, '', ''),
(251, 'Read Only', 'Fixed class', 250, 0, '0,251', 0, 0, '', '');

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

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

CREATE TABLE `[[dbprefix]]user_extended` (
  `user_extended_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_hidden_fields` text,
  PRIMARY KEY (`user_extended_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `[[dbprefix]]user_extended` VALUES
(1, NULL);

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

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

CREATE TABLE `[[dbprefix]]user_extended_struct` (
  `user_extended_struct_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_extended_struct_name` varchar(255) NOT NULL DEFAULT '',
  `user_extended_struct_text` varchar(255) NOT NULL DEFAULT '',
  `user_extended_struct_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_extended_struct_parms` varchar(255) NOT NULL DEFAULT '',
  `user_extended_struct_values` text NOT NULL,
  `user_extended_struct_default` varchar(255) NOT NULL DEFAULT '',
  `user_extended_struct_read` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_extended_struct_write` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_extended_struct_required` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_extended_struct_signup` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_extended_struct_applicable` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_extended_struct_order` int(10) unsigned NOT NULL DEFAULT '0',
  `user_extended_struct_parent` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_extended_struct_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

/*!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: e107.sql

File Content: `e107.sql`
