



--
-- 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;

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

--
-- 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);

--
-- 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]]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 ;

