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: `mybb1838`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]adminlog`
--
CREATE TABLE `[[dbprefix]]adminlog` (
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`module` varchar(50) NOT NULL DEFAULT '',
`action` varchar(50) NOT NULL DEFAULT '',
`data` text NOT NULL,
KEY `module` (`module`,`action`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]adminoptions`
--
CREATE TABLE `[[dbprefix]]adminoptions` (
`uid` int(11) NOT NULL DEFAULT '0',
`cpstyle` varchar(50) NOT NULL DEFAULT '',
`cplanguage` varchar(50) NOT NULL DEFAULT '',
`codepress` tinyint(1) NOT NULL DEFAULT '1',
`notes` text NOT NULL,
`permissions` text NOT NULL,
`defaultviews` text NOT NULL,
`loginattempts` smallint(5) unsigned NOT NULL DEFAULT '0',
`loginlockoutexpiry` int(10) unsigned NOT NULL DEFAULT '0',
`authsecret` varchar(16) NOT NULL DEFAULT '',
`recovery_codes` varchar(177) NOT NULL DEFAULT '',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]adminoptions`
--
INSERT INTO `[[dbprefix]]adminoptions` VALUES
(0, '', '', 1, '', 'a:5:{s:6:"config";a:19:{s:3:"tab";s:1:"0";s:8:"settings";s:1:"0";s:7:"banning";s:1:"0";s:14:"profile_fields";s:1:"0";s:7:"smilies";s:1:"0";s:8:"badwords";s:1:"0";s:6:"mycode";s:1:"0";s:9:"languages";s:1:"0";s:10:"post_icons";s:1:"0";s:14:"help_documents";s:1:"0";s:7:"plugins";s:1:"0";s:16:"attachment_types";s:1:"0";s:9:"mod_tools";s:1:"0";s:7:"spiders";s:1:"0";s:9:"calendars";s:1:"0";s:7:"warning";s:1:"0";s:15:"thread_prefixes";s:1:"0";s:9:"questions";s:1:"0";s:14:"report_reasons";s:1:"0";}s:5:"forum";a:5:{s:3:"tab";s:1:"0";s:10:"management";s:1:"0";s:13:"announcements";s:1:"0";s:16:"moderation_queue";s:1:"0";s:11:"attachments";s:1:"0";}s:5:"style";a:3:{s:3:"tab";s:1:"0";s:6:"themes";s:1:"0";s:9:"templates";s:1:"0";}s:5:"tools";a:16:{s:3:"tab";s:1:"0";s:13:"system_health";s:1:"0";s:5:"cache";s:1:"0";s:5:"tasks";s:1:"0";s:8:"backupdb";s:1:"0";s:10:"optimizedb";s:1:"0";s:8:"adminlog";s:1:"0";s:6:"modlog";s:1:"0";s:15:"recount_rebuild";s:1:"0";s:8:"php_info";s:1:"1";s:7:"spamlog";s:1:"0";s:8:"maillogs";s:1:"0";s:10:"mailerrors";s:1:"0";s:10:"warninglog";s:1:"0";s:10:"statistics";s:1:"0";s:17:"file_verification";s:1:"0";}s:4:"user";a:9:{s:3:"tab";s:1:"0";s:5:"users";s:1:"0";s:19:"awaiting_activation";s:1:"0";s:6:"groups";s:1:"0";s:6:"titles";s:1:"0";s:7:"banning";s:1:"0";s:17:"admin_permissions";s:1:"0";s:9:"mass_mail";s:1:"0";s:16:"group_promotions";s:1:"0";}}', 'a:1:{s:4:"user";s:1:"1";}', 0, 0, '', ''),
(-4, '', '', 1, '', 'a:5:{s:6:"config";a:19:{s:3:"tab";s:1:"1";s:8:"settings";s:1:"1";s:7:"banning";s:1:"1";s:14:"profile_fields";s:1:"1";s:7:"smilies";s:1:"1";s:8:"badwords";s:1:"1";s:6:"mycode";s:1:"1";s:9:"languages";s:1:"1";s:10:"post_icons";s:1:"1";s:14:"help_documents";s:1:"1";s:7:"plugins";s:1:"1";s:16:"attachment_types";s:1:"1";s:9:"mod_tools";s:1:"1";s:7:"spiders";s:1:"1";s:9:"calendars";s:1:"1";s:7:"warning";s:1:"1";s:15:"thread_prefixes";s:1:"1";s:9:"questions";s:1:"1";s:14:"report_reasons";s:1:"1";}s:5:"forum";a:5:{s:3:"tab";s:1:"1";s:10:"management";s:1:"1";s:13:"announcements";s:1:"1";s:16:"moderation_queue";s:1:"1";s:11:"attachments";s:1:"1";}s:5:"style";a:3:{s:3:"tab";s:1:"1";s:6:"themes";s:1:"1";s:9:"templates";s:1:"1";}s:5:"tools";a:16:{s:3:"tab";s:1:"1";s:13:"system_health";s:1:"1";s:5:"cache";s:1:"1";s:5:"tasks";s:1:"1";s:8:"backupdb";s:1:"1";s:10:"optimizedb";s:1:"1";s:8:"adminlog";s:1:"1";s:6:"modlog";s:1:"1";s:15:"recount_rebuild";s:1:"1";s:8:"php_info";s:1:"1";s:7:"spamlog";s:1:"1";s:8:"maillogs";s:1:"1";s:10:"mailerrors";s:1:"1";s:10:"warninglog";s:1:"1";s:10:"statistics";s:1:"1";s:17:"file_verification";s:1:"1";}s:4:"user";a:9:{s:3:"tab";s:1:"1";s:5:"users";s:1:"1";s:19:"awaiting_activation";s:1:"1";s:6:"groups";s:1:"1";s:6:"titles";s:1:"1";s:7:"banning";s:1:"1";s:17:"admin_permissions";s:1:"1";s:9:"mass_mail";s:1:"1";s:16:"group_promotions";s:1:"1";}}', 'a:1:{s:4:"user";s:1:"1";}', 0, 0, '', ''),
(1, '', '', 1, '', 'a:5:{s:6:"config";a:19:{s:3:"tab";s:1:"1";s:8:"settings";s:1:"1";s:7:"banning";s:1:"1";s:14:"profile_fields";s:1:"1";s:7:"smilies";s:1:"1";s:8:"badwords";s:1:"1";s:6:"mycode";s:1:"1";s:9:"languages";s:1:"1";s:10:"post_icons";s:1:"1";s:14:"help_documents";s:1:"1";s:7:"plugins";s:1:"1";s:16:"attachment_types";s:1:"1";s:9:"mod_tools";s:1:"1";s:7:"spiders";s:1:"1";s:9:"calendars";s:1:"1";s:7:"warning";s:1:"1";s:15:"thread_prefixes";s:1:"1";s:9:"questions";s:1:"1";s:14:"report_reasons";s:1:"1";}s:5:"forum";a:5:{s:3:"tab";s:1:"1";s:10:"management";s:1:"1";s:13:"announcements";s:1:"1";s:16:"moderation_queue";s:1:"1";s:11:"attachments";s:1:"1";}s:5:"style";a:3:{s:3:"tab";s:1:"1";s:6:"themes";s:1:"1";s:9:"templates";s:1:"1";}s:5:"tools";a:16:{s:3:"tab";s:1:"1";s:13:"system_health";s:1:"1";s:5:"cache";s:1:"1";s:5:"tasks";s:1:"1";s:8:"backupdb";s:1:"1";s:10:"optimizedb";s:1:"1";s:15:"recount_rebuild";s:1:"1";s:8:"php_info";s:1:"1";s:8:"adminlog";s:1:"1";s:6:"modlog";s:1:"1";s:7:"spamlog";s:1:"1";s:8:"maillogs";s:1:"1";s:10:"mailerrors";s:1:"1";s:10:"warninglog";s:1:"1";s:10:"statistics";s:1:"1";s:17:"file_verification";s:1:"1";}s:4:"user";a:9:{s:3:"tab";s:1:"1";s:5:"users";s:1:"1";s:19:"awaiting_activation";s:1:"1";s:6:"groups";s:1:"1";s:6:"titles";s:1:"1";s:7:"banning";s:1:"1";s:17:"admin_permissions";s:1:"1";s:9:"mass_mail";s:1:"1";s:16:"group_promotions";s:1:"1";}}', 'a:1:{s:4:"user";s:1:"1";}', 0, 0, '', '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]adminsessions`
--
CREATE TABLE `[[dbprefix]]adminsessions` (
`sid` varchar(32) NOT NULL DEFAULT '',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`loginkey` varchar(50) NOT NULL DEFAULT '',
`ip` varbinary(16) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`lastactive` int(10) unsigned NOT NULL DEFAULT '0',
`data` text NOT NULL,
`useragent` varchar(200) NOT NULL DEFAULT '',
`authenticated` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]adminviews`
--
CREATE TABLE `[[dbprefix]]adminviews` (
`vid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT '',
`type` varchar(6) NOT NULL DEFAULT '',
`visibility` tinyint(1) NOT NULL DEFAULT '0',
`fields` text NOT NULL,
`conditions` text NOT NULL,
`custom_profile_fields` text NOT NULL,
`sortby` varchar(20) NOT NULL DEFAULT '',
`sortorder` varchar(4) NOT NULL DEFAULT '',
`perpage` smallint(4) unsigned NOT NULL DEFAULT '0',
`view_type` varchar(6) NOT NULL DEFAULT '',
PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]adminviews`
--
INSERT INTO `[[dbprefix]]adminviews` VALUES
(1, 0, 'All Users', 'user', 2, 'a:7:{i:0;s:6:"avatar";i:1;s:8:"username";i:2;s:5:"email";i:3;s:7:"regdate";i:4;s:10:"lastactive";i:5;s:7:"postnum";i:6;s:8:"controls";}', 'a:0:{}', 'a:0:{}', 'username', 'asc', 20, 'card');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]announcements`
--
CREATE TABLE `[[dbprefix]]announcements` (
`aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fid` int(11) NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`subject` varchar(120) NOT NULL DEFAULT '',
`message` text NOT NULL,
`startdate` int(10) unsigned NOT NULL DEFAULT '0',
`enddate` int(10) unsigned NOT NULL DEFAULT '0',
`allowhtml` tinyint(1) NOT NULL DEFAULT '0',
`allowmycode` tinyint(1) NOT NULL DEFAULT '0',
`allowsmilies` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`aid`),
KEY `fid` (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attachments`
--
CREATE TABLE `[[dbprefix]]attachments` (
`aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`posthash` varchar(50) NOT NULL DEFAULT '',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`filename` varchar(255) NOT NULL DEFAULT '',
`filetype` varchar(120) NOT NULL DEFAULT '',
`filesize` int(10) unsigned NOT NULL DEFAULT '0',
`attachname` varchar(255) NOT NULL DEFAULT '',
`downloads` int(10) unsigned NOT NULL DEFAULT '0',
`dateuploaded` int(10) unsigned NOT NULL DEFAULT '0',
`visible` tinyint(1) NOT NULL DEFAULT '0',
`thumbnail` varchar(120) NOT NULL DEFAULT '',
PRIMARY KEY (`aid`),
KEY `pid` (`pid`,`visible`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attachtypes`
--
CREATE TABLE `[[dbprefix]]attachtypes` (
`atid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(120) NOT NULL DEFAULT '',
`mimetype` varchar(120) NOT NULL DEFAULT '',
`extension` varchar(10) NOT NULL DEFAULT '',
`maxsize` int(15) unsigned NOT NULL DEFAULT '0',
`icon` varchar(100) NOT NULL DEFAULT '',
`enabled` tinyint(1) NOT NULL DEFAULT '1',
`forcedownload` tinyint(1) NOT NULL DEFAULT '0',
`groups` text NOT NULL,
`forums` text NOT NULL,
`avatarfile` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`atid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
--
-- Dumping data for table `[[dbprefix]]attachtypes`
--
INSERT INTO `[[dbprefix]]attachtypes` VALUES
(1, 'ZIP File', 'application/zip', 'zip', 1024, 'images/attachtypes/zip.png', 1, 0, '-1', '-1', 0),
(2, 'JPG Image', 'image/jpeg', 'jpg', 500, 'images/attachtypes/image.png', 1, 0, '-1', '-1', 1),
(3, 'Text Document', 'text/plain', 'txt', 200, 'images/attachtypes/txt.png', 1, 0, '-1', '-1', 0),
(4, 'GIF Image', 'image/gif', 'gif', 500, 'images/attachtypes/image.png', 1, 0, '-1', '-1', 1),
(5, 'Adobe Photoshop File', 'application/x-photoshop', 'psd', 1024, 'images/attachtypes/psd.png', 1, 0, '-1', '-1', 0),
(6, 'PHP File', 'application/x-httpd-php', 'php', 500, 'images/attachtypes/php.png', 1, 0, '-1', '-1', 0),
(7, 'PNG Image', 'image/png', 'png', 500, 'images/attachtypes/image.png', 1, 0, '-1', '-1', 1),
(8, 'Microsoft Word Document', 'application/msword', 'doc', 1024, 'images/attachtypes/doc.png', 1, 0, '-1', '-1', 0),
(9, 'HTM File', 'text/html', 'htm', 100, 'images/attachtypes/html.png', 1, 0, '-1', '-1', 0),
(10, 'HTML File', 'text/html', 'html', 100, 'images/attachtypes/html.png', 1, 0, '-1', '-1', 0),
(11, 'JPEG Image', 'image/jpeg', 'jpeg', 500, 'images/attachtypes/image.png', 1, 0, '-1', '-1', 1),
(12, 'GZIP Compressed File', 'application/x-gzip', 'gz', 1024, 'images/attachtypes/tar.png', 1, 0, '-1', '-1', 0),
(13, 'TAR Compressed File', 'application/x-tar', 'tar', 1024, 'images/attachtypes/tar.png', 1, 0, '-1', '-1', 0),
(14, 'CSS Stylesheet', 'text/css', 'css', 100, 'images/attachtypes/css.png', 1, 0, '-1', '-1', 0),
(15, 'Adobe Acrobat PDF', 'application/pdf', 'pdf', 2048, 'images/attachtypes/pdf.png', 1, 0, '-1', '-1', 0),
(16, 'Bitmap Image', 'image/bmp', 'bmp', 500, 'images/attachtypes/image.png', 1, 0, '-1', '-1', 0),
(17, 'Microsoft Word 2007 Document', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'docx', 1024, 'images/attachtypes/doc.png', 1, 0, '-1', '-1', 0),
(18, 'Microsoft Excel Document', 'application/vnd.ms-excel', 'xls', 1024, 'images/attachtypes/xls.png', 1, 0, '-1', '-1', 0),
(19, 'Microsoft Excel 2007 Document', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'xlsx', 1024, 'images/attachtypes/xls.png', 1, 0, '-1', '-1', 0),
(20, 'Microsoft PowerPoint Document', 'application/vnd.ms-powerpoint', 'ppt', 1024, 'images/attachtypes/ppt.png', 1, 0, '-1', '-1', 0),
(21, 'Microsoft PowerPoint 2007 Document', 'application/vnd.openxmlformats-officedocument.presentationml.presentation', 'pptx', 1024, 'images/attachtypes/ppt.png', 1, 0, '-1', '-1', 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]awaitingactivation`
--
CREATE TABLE `[[dbprefix]]awaitingactivation` (
`aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`code` varchar(100) NOT NULL DEFAULT '',
`type` char(1) NOT NULL DEFAULT '',
`validated` tinyint(1) NOT NULL DEFAULT '0',
`misc` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]badwords`
--
CREATE TABLE `[[dbprefix]]badwords` (
`bid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`badword` varchar(100) NOT NULL DEFAULT '',
`regex` tinyint(1) NOT NULL DEFAULT '0',
`replacement` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]banfilters`
--
CREATE TABLE `[[dbprefix]]banfilters` (
`fid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`filter` varchar(200) NOT NULL DEFAULT '',
`type` tinyint(1) NOT NULL DEFAULT '0',
`lastuse` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`fid`),
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]banned`
--
CREATE TABLE `[[dbprefix]]banned` (
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`gid` int(10) unsigned NOT NULL DEFAULT '0',
`oldgroup` int(10) unsigned NOT NULL DEFAULT '0',
`oldadditionalgroups` text NOT NULL,
`olddisplaygroup` int(10) unsigned NOT NULL DEFAULT '0',
`admin` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`bantime` varchar(50) NOT NULL DEFAULT '',
`lifted` int(10) unsigned NOT NULL DEFAULT '0',
`reason` varchar(255) NOT NULL DEFAULT '',
KEY `uid` (`uid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]buddyrequests`
--
CREATE TABLE `[[dbprefix]]buddyrequests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`touid` int(10) unsigned NOT NULL DEFAULT '0',
`date` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `touid` (`touid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]calendarpermissions`
--
CREATE TABLE `[[dbprefix]]calendarpermissions` (
`cid` int(10) unsigned NOT NULL DEFAULT '0',
`gid` int(10) unsigned NOT NULL DEFAULT '0',
`canviewcalendar` tinyint(1) NOT NULL DEFAULT '0',
`canaddevents` tinyint(1) NOT NULL DEFAULT '0',
`canbypasseventmod` tinyint(1) NOT NULL DEFAULT '0',
`canmoderateevents` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]calendars`
--
CREATE TABLE `[[dbprefix]]calendars` (
`cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
`startofweek` tinyint(1) NOT NULL DEFAULT '0',
`showbirthdays` tinyint(1) NOT NULL DEFAULT '0',
`eventlimit` smallint(3) unsigned NOT NULL DEFAULT '0',
`moderation` tinyint(1) NOT NULL DEFAULT '0',
`allowhtml` tinyint(1) NOT NULL DEFAULT '0',
`allowmycode` tinyint(1) NOT NULL DEFAULT '0',
`allowimgcode` tinyint(1) NOT NULL DEFAULT '0',
`allowvideocode` tinyint(1) NOT NULL DEFAULT '0',
`allowsmilies` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]calendars`
--
INSERT INTO `[[dbprefix]]calendars` VALUES
(1, 'Default Calendar', 1, 0, 1, 4, 0, 0, 1, 1, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]captcha`
--
CREATE TABLE `[[dbprefix]]captcha` (
`imagehash` varchar(32) NOT NULL DEFAULT '',
`imagestring` varchar(8) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`used` tinyint(1) NOT NULL DEFAULT '0',
KEY `imagehash` (`imagehash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]datacache`
--
CREATE TABLE `[[dbprefix]]datacache` (
`title` varchar(50) NOT NULL DEFAULT '',
`cache` mediumtext NOT NULL,
PRIMARY KEY (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]datacache`
--
INSERT INTO `[[dbprefix]]datacache` VALUES
('default_theme', 'a:4:{s:4:"name";s:7:"Default";s:3:"tid";s:1:"2";s:10:"properties";s:1039:"a:9:{s:11:"templateset";i:1;s:9:"inherited";a:6:{s:6:"imgdir";i:1;s:4:"logo";i:1;s:10:"tablespace";i:1;s:11:"borderwidth";i:1;s:11:"editortheme";i:1;s:9:"disporder";i:1;}s:6:"imgdir";s:6:"images";s:4:"logo";s:15:"images/logo.png";s:10:"tablespace";s:1:"5";s:11:"borderwidth";s:1:"0";s:11:"editortheme";s:8:"mybb.css";s:9:"disporder";a:17:{s:10:"global.css";i:1;s:10:"usercp.css";i:2;s:9:"modcp.css";i:3;s:16:"star_ratings.css";i:4;s:14:"showthread.css";i:5;s:17:"thread_status.css";i:6;s:8:"css3.css";i:7;s:15:"color_black.css";i:8;s:14:"color_calm.css";i:9;s:14:"color_dawn.css";i:10;s:15:"color_earth.css";i:11;s:15:"color_flame.css";i:12;s:14:"color_leaf.css";i:13;s:15:"color_night.css";i:14;s:13:"color_sun.css";i:15;s:18:"color_twilight.css";i:16;s:15:"color_water.css";i:17;}s:6:"colors";a:10:{s:5:"black";s:5:"Black";s:4:"calm";s:4:"Calm";s:4:"dawn";s:4:"Dawn";s:5:"earth";s:5:"Earth";s:5:"flame";s:5:"Flame";s:4:"leaf";s:4:"Leaf";s:5:"night";s:5:"Night";s:3:"sun";s:3:"Sun";s:8:"twilight";s:8:"Twilight";s:5:"water";s:5:"Water";}}";s:11:"stylesheets";s:2385:"a:18:{s:6:"global";a:1:{s:6:"global";a:2:{i:0;s:30:"cache/themes/theme1/global.css";i:1;s:28:"cache/themes/theme1/css3.css";}}s:9:"inherited";a:7:{s:13:"global_global";a:2:{s:30:"cache/themes/theme1/global.css";i:1;s:28:"cache/themes/theme1/css3.css";i:1;}s:17:"usercp.php_global";a:2:{s:30:"cache/themes/theme1/usercp.css";i:1;s:37:"cache/themes/theme1/thread_status.css";i:1;}s:18:"private.php_global";a:1:{s:30:"cache/themes/theme1/usercp.css";i:1;}s:16:"modcp.php_global";a:1:{s:29:"cache/themes/theme1/modcp.css";i:1;}s:23:"forumdisplay.php_global";a:2:{s:36:"cache/themes/theme1/star_ratings.css";i:1;s:37:"cache/themes/theme1/thread_status.css";i:1;}s:21:"showthread.php_global";a:2:{s:36:"cache/themes/theme1/star_ratings.css";i:1;s:34:"cache/themes/theme1/showthread.css";i:1;}s:17:"search.php_global";a:1:{s:37:"cache/themes/theme1/thread_status.css";i:1;}}s:10:"usercp.php";a:1:{s:6:"global";a:2:{i:0;s:30:"cache/themes/theme1/usercp.css";i:1;s:37:"cache/themes/theme1/thread_status.css";}}s:11:"private.php";a:1:{s:6:"global";a:1:{i:0;s:30:"cache/themes/theme1/usercp.css";}}s:9:"modcp.php";a:1:{s:6:"global";a:1:{i:0;s:29:"cache/themes/theme1/modcp.css";}}s:16:"forumdisplay.php";a:1:{s:6:"global";a:2:{i:0;s:36:"cache/themes/theme1/star_ratings.css";i:1;s:37:"cache/themes/theme1/thread_status.css";}}s:14:"showthread.php";a:1:{s:6:"global";a:2:{i:0;s:36:"cache/themes/theme1/star_ratings.css";i:1;s:34:"cache/themes/theme1/showthread.css";}}s:10:"search.php";a:1:{s:6:"global";a:1:{i:0;s:37:"cache/themes/theme1/thread_status.css";}}s:5:"black";a:1:{s:6:"global";a:1:{i:0;s:35:"cache/themes/theme2/color_black.css";}}s:4:"calm";a:1:{s:6:"global";a:1:{i:0;s:34:"cache/themes/theme2/color_calm.css";}}s:4:"dawn";a:1:{s:6:"global";a:1:{i:0;s:34:"cache/themes/theme2/color_dawn.css";}}s:5:"earth";a:1:{s:6:"global";a:1:{i:0;s:35:"cache/themes/theme2/color_earth.css";}}s:5:"flame";a:1:{s:6:"global";a:1:{i:0;s:35:"cache/themes/theme2/color_flame.css";}}s:4:"leaf";a:1:{s:6:"global";a:1:{i:0;s:34:"cache/themes/theme2/color_leaf.css";}}s:5:"night";a:1:{s:6:"global";a:1:{i:0;s:35:"cache/themes/theme2/color_night.css";}}s:3:"sun";a:1:{s:6:"global";a:1:{i:0;s:33:"cache/themes/theme2/color_sun.css";}}s:8:"twilight";a:1:{s:6:"global";a:1:{i:0;s:38:"cache/themes/theme2/color_twilight.css";}}s:5:"water";a:1:{s:6:"global";a:1:{i:0;s:35:"cache/themes/theme2/color_water.css";}}}";}'),
('version', 'a:2:{s:7:"version";s:6:"1.8.38";s:12:"version_code";i:1838;}'),
('attachtypes', 'a:21:{s:3:"zip";a:11:{s:4:"atid";s:1:"1";s:4:"name";s:8:"ZIP File";s:8:"mimetype";s:15:"application/zip";s:9:"extension";s:3:"zip";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/zip.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"jpg";a:11:{s:4:"atid";s:1:"2";s:4:"name";s:9:"JPG Image";s:8:"mimetype";s:10:"image/jpeg";s:9:"extension";s:3:"jpg";s:7:"maxsize";s:3:"500";s:4:"icon";s:28:"images/attachtypes/image.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"1";}s:3:"txt";a:11:{s:4:"atid";s:1:"3";s:4:"name";s:13:"Text Document";s:8:"mimetype";s:10:"text/plain";s:9:"extension";s:3:"txt";s:7:"maxsize";s:3:"200";s:4:"icon";s:26:"images/attachtypes/txt.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"gif";a:11:{s:4:"atid";s:1:"4";s:4:"name";s:9:"GIF Image";s:8:"mimetype";s:9:"image/gif";s:9:"extension";s:3:"gif";s:7:"maxsize";s:3:"500";s:4:"icon";s:28:"images/attachtypes/image.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"1";}s:3:"psd";a:11:{s:4:"atid";s:1:"5";s:4:"name";s:20:"Adobe Photoshop File";s:8:"mimetype";s:23:"application/x-photoshop";s:9:"extension";s:3:"psd";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/psd.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"php";a:11:{s:4:"atid";s:1:"6";s:4:"name";s:8:"PHP File";s:8:"mimetype";s:23:"application/x-httpd-php";s:9:"extension";s:3:"php";s:7:"maxsize";s:3:"500";s:4:"icon";s:26:"images/attachtypes/php.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"png";a:11:{s:4:"atid";s:1:"7";s:4:"name";s:9:"PNG Image";s:8:"mimetype";s:9:"image/png";s:9:"extension";s:3:"png";s:7:"maxsize";s:3:"500";s:4:"icon";s:28:"images/attachtypes/image.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"1";}s:3:"doc";a:11:{s:4:"atid";s:1:"8";s:4:"name";s:23:"Microsoft Word Document";s:8:"mimetype";s:18:"application/msword";s:9:"extension";s:3:"doc";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/doc.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"htm";a:11:{s:4:"atid";s:1:"9";s:4:"name";s:8:"HTM File";s:8:"mimetype";s:9:"text/html";s:9:"extension";s:3:"htm";s:7:"maxsize";s:3:"100";s:4:"icon";s:27:"images/attachtypes/html.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:4:"html";a:11:{s:4:"atid";s:2:"10";s:4:"name";s:9:"HTML File";s:8:"mimetype";s:9:"text/html";s:9:"extension";s:4:"html";s:7:"maxsize";s:3:"100";s:4:"icon";s:27:"images/attachtypes/html.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:4:"jpeg";a:11:{s:4:"atid";s:2:"11";s:4:"name";s:10:"JPEG Image";s:8:"mimetype";s:10:"image/jpeg";s:9:"extension";s:4:"jpeg";s:7:"maxsize";s:3:"500";s:4:"icon";s:28:"images/attachtypes/image.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"1";}s:2:"gz";a:11:{s:4:"atid";s:2:"12";s:4:"name";s:20:"GZIP Compressed File";s:8:"mimetype";s:18:"application/x-gzip";s:9:"extension";s:2:"gz";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/tar.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"tar";a:11:{s:4:"atid";s:2:"13";s:4:"name";s:19:"TAR Compressed File";s:8:"mimetype";s:17:"application/x-tar";s:9:"extension";s:3:"tar";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/tar.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"css";a:11:{s:4:"atid";s:2:"14";s:4:"name";s:14:"CSS Stylesheet";s:8:"mimetype";s:8:"text/css";s:9:"extension";s:3:"css";s:7:"maxsize";s:3:"100";s:4:"icon";s:26:"images/attachtypes/css.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"pdf";a:11:{s:4:"atid";s:2:"15";s:4:"name";s:17:"Adobe Acrobat PDF";s:8:"mimetype";s:15:"application/pdf";s:9:"extension";s:3:"pdf";s:7:"maxsize";s:4:"2048";s:4:"icon";s:26:"images/attachtypes/pdf.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"bmp";a:11:{s:4:"atid";s:2:"16";s:4:"name";s:12:"Bitmap Image";s:8:"mimetype";s:9:"image/bmp";s:9:"extension";s:3:"bmp";s:7:"maxsize";s:3:"500";s:4:"icon";s:28:"images/attachtypes/image.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:4:"docx";a:11:{s:4:"atid";s:2:"17";s:4:"name";s:28:"Microsoft Word 2007 Document";s:8:"mimetype";s:71:"application/vnd.openxmlformats-officedocument.wordprocessingml.document";s:9:"extension";s:4:"docx";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/doc.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"xls";a:11:{s:4:"atid";s:2:"18";s:4:"name";s:24:"Microsoft Excel Document";s:8:"mimetype";s:24:"application/vnd.ms-excel";s:9:"extension";s:3:"xls";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/xls.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:4:"xlsx";a:11:{s:4:"atid";s:2:"19";s:4:"name";s:29:"Microsoft Excel 2007 Document";s:8:"mimetype";s:65:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";s:9:"extension";s:4:"xlsx";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/xls.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:3:"ppt";a:11:{s:4:"atid";s:2:"20";s:4:"name";s:29:"Microsoft PowerPoint Document";s:8:"mimetype";s:29:"application/vnd.ms-powerpoint";s:9:"extension";s:3:"ppt";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/ppt.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}s:4:"pptx";a:11:{s:4:"atid";s:2:"21";s:4:"name";s:34:"Microsoft PowerPoint 2007 Document";s:8:"mimetype";s:73:"application/vnd.openxmlformats-officedocument.presentationml.presentation";s:9:"extension";s:4:"pptx";s:7:"maxsize";s:4:"1024";s:4:"icon";s:26:"images/attachtypes/ppt.png";s:7:"enabled";s:1:"1";s:13:"forcedownload";s:1:"0";s:6:"groups";s:2:"-1";s:6:"forums";s:2:"-1";s:10:"avatarfile";s:1:"0";}}'),
('smilies', 'a:24:{i:1;a:6:{s:3:"sid";s:1:"1";s:4:"name";s:5:"Smile";s:4:"find";s:2:":)";s:5:"image";s:24:"images/smilies/smile.png";s:9:"disporder";s:1:"1";s:13:"showclickable";s:1:"1";}i:2;a:6:{s:3:"sid";s:1:"2";s:4:"name";s:4:"Wink";s:4:"find";s:2:";)";s:5:"image";s:23:"images/smilies/wink.png";s:9:"disporder";s:1:"2";s:13:"showclickable";s:1:"1";}i:3;a:6:{s:3:"sid";s:1:"3";s:4:"name";s:4:"Cool";s:4:"find";s:6:":cool:";s:5:"image";s:23:"images/smilies/cool.png";s:9:"disporder";s:1:"3";s:13:"showclickable";s:1:"1";}i:4;a:6:{s:3:"sid";s:1:"4";s:4:"name";s:8:"Big Grin";s:4:"find";s:2:":D";s:5:"image";s:26:"images/smilies/biggrin.png";s:9:"disporder";s:1:"4";s:13:"showclickable";s:1:"1";}i:5;a:6:{s:3:"sid";s:1:"5";s:4:"name";s:6:"Tongue";s:4:"find";s:2:":P";s:5:"image";s:25:"images/smilies/tongue.png";s:9:"disporder";s:1:"5";s:13:"showclickable";s:1:"1";}i:6;a:6:{s:3:"sid";s:1:"6";s:4:"name";s:8:"Rolleyes";s:4:"find";s:10:":rolleyes:";s:5:"image";s:27:"images/smilies/rolleyes.png";s:9:"disporder";s:1:"6";s:13:"showclickable";s:1:"1";}i:7;a:6:{s:3:"sid";s:1:"7";s:4:"name";s:3:"Shy";s:4:"find";s:5:":shy:";s:5:"image";s:22:"images/smilies/shy.png";s:9:"disporder";s:1:"7";s:13:"showclickable";s:1:"1";}i:8;a:6:{s:3:"sid";s:1:"8";s:4:"name";s:3:"Sad";s:4:"find";s:2:":(";s:5:"image";s:22:"images/smilies/sad.png";s:9:"disporder";s:1:"8";s:13:"showclickable";s:1:"1";}i:9;a:6:{s:3:"sid";s:1:"9";s:4:"name";s:2:"At";s:4:"find";s:4:":at:";s:5:"image";s:21:"images/smilies/at.png";s:9:"disporder";s:1:"9";s:13:"showclickable";s:1:"1";}i:10;a:6:{s:3:"sid";s:2:"10";s:4:"name";s:5:"Angel";s:4:"find";s:7:":angel:";s:5:"image";s:24:"images/smilies/angel.png";s:9:"disporder";s:2:"10";s:13:"showclickable";s:1:"1";}i:11;a:6:{s:3:"sid";s:2:"11";s:4:"name";s:5:"Angry";s:4:"find";s:2:":@";s:5:"image";s:24:"images/smilies/angry.png";s:9:"disporder";s:2:"11";s:13:"showclickable";s:1:"1";}i:12;a:6:{s:3:"sid";s:2:"12";s:4:"name";s:5:"Blush";s:4:"find";s:7:":blush:";s:5:"image";s:24:"images/smilies/blush.png";s:9:"disporder";s:2:"12";s:13:"showclickable";s:1:"1";}i:13;a:6:{s:3:"sid";s:2:"13";s:4:"name";s:8:"Confused";s:4:"find";s:2:":s";s:5:"image";s:27:"images/smilies/confused.png";s:9:"disporder";s:2:"13";s:13:"showclickable";s:1:"1";}i:14;a:6:{s:3:"sid";s:2:"14";s:4:"name";s:5:"Dodgy";s:4:"find";s:7:":dodgy:";s:5:"image";s:24:"images/smilies/dodgy.png";s:9:"disporder";s:2:"14";s:13:"showclickable";s:1:"1";}i:15;a:6:{s:3:"sid";s:2:"15";s:4:"name";s:11:"Exclamation";s:4:"find";s:13:":exclamation:";s:5:"image";s:30:"images/smilies/exclamation.png";s:9:"disporder";s:2:"15";s:13:"showclickable";s:1:"1";}i:16;a:6:{s:3:"sid";s:2:"16";s:4:"name";s:5:"Heart";s:4:"find";s:7:":heart:";s:5:"image";s:24:"images/smilies/heart.png";s:9:"disporder";s:2:"16";s:13:"showclickable";s:1:"1";}i:17;a:6:{s:3:"sid";s:2:"17";s:4:"name";s:3:"Huh";s:4:"find";s:5:":huh:";s:5:"image";s:22:"images/smilies/huh.png";s:9:"disporder";s:2:"17";s:13:"showclickable";s:1:"1";}i:18;a:6:{s:3:"sid";s:2:"18";s:4:"name";s:4:"Idea";s:4:"find";s:6:":idea:";s:5:"image";s:28:"images/smilies/lightbulb.png";s:9:"disporder";s:2:"18";s:13:"showclickable";s:1:"1";}i:19;a:6:{s:3:"sid";s:2:"19";s:4:"name";s:6:"Sleepy";s:4:"find";s:8:":sleepy:";s:5:"image";s:25:"images/smilies/sleepy.png";s:9:"disporder";s:2:"19";s:13:"showclickable";s:1:"1";}i:20;a:6:{s:3:"sid";s:2:"20";s:4:"name";s:9:"Undecided";s:4:"find";s:3:":-/";s:5:"image";s:28:"images/smilies/undecided.png";s:9:"disporder";s:2:"20";s:13:"showclickable";s:1:"1";}i:21;a:6:{s:3:"sid";s:2:"21";s:4:"name";s:3:"Cry";s:4:"find";s:5:":cry:";s:5:"image";s:22:"images/smilies/cry.png";s:9:"disporder";s:2:"21";s:13:"showclickable";s:1:"1";}i:22;a:6:{s:3:"sid";s:2:"22";s:4:"name";s:4:"Sick";s:4:"find";s:6:":sick:";s:5:"image";s:23:"images/smilies/sick.png";s:9:"disporder";s:2:"22";s:13:"showclickable";s:1:"1";}i:23;a:6:{s:3:"sid";s:2:"23";s:4:"name";s:5:"Arrow";s:4:"find";s:7:":arrow:";s:5:"image";s:24:"images/smilies/arrow.png";s:9:"disporder";s:2:"23";s:13:"showclickable";s:1:"1";}i:24;a:6:{s:3:"sid";s:2:"24";s:4:"name";s:2:"My";s:4:"find";s:4:":my:";s:5:"image";s:21:"images/smilies/my.png";s:9:"disporder";s:2:"24";s:13:"showclickable";s:1:"1";}}'),
('badwords', 'a:0:{}'),
('usergroups', 'a:7:{i:1;a:91:{s:3:"gid";s:1:"1";s:4:"type";s:1:"1";s:5:"title";s:6:"Guests";s:11:"description";s:77:"The default group that all visitors are assigned to unless they''re logged in.";s:9:"namestyle";s:10:"{username}";s:9:"usertitle";s:12:"Unregistered";s:5:"stars";s:1:"0";s:9:"starimage";s:0:"";s:5:"image";s:0:"";s:9:"disporder";s:1:"0";s:13:"isbannedgroup";s:1:"0";s:7:"canview";s:1:"1";s:14:"canviewthreads";s:1:"1";s:15:"canviewprofiles";s:1:"1";s:16:"candlattachments";s:1:"0";s:18:"canviewboardclosed";s:1:"0";s:14:"canpostthreads";s:1:"0";s:13:"canpostreplys";s:1:"0";s:18:"canpostattachments";s:1:"0";s:14:"canratethreads";s:1:"0";s:8:"modposts";s:1:"0";s:10:"modthreads";s:1:"0";s:14:"mod_edit_posts";s:1:"0";s:14:"modattachments";s:1:"0";s:12:"caneditposts";s:1:"0";s:14:"candeleteposts";s:1:"0";s:16:"candeletethreads";s:1:"0";s:18:"caneditattachments";s:1:"0";s:21:"canviewdeletionnotice";s:1:"0";s:12:"canpostpolls";s:1:"0";s:12:"canvotepolls";s:1:"0";s:12:"canundovotes";s:1:"0";s:9:"canusepms";s:1:"0";s:10:"cansendpms";s:1:"0";s:11:"cantrackpms";s:1:"0";s:17:"candenypmreceipts";s:1:"0";s:7:"pmquota";s:1:"0";s:15:"maxpmrecipients";s:1:"5";s:12:"cansendemail";s:1:"0";s:20:"cansendemailoverride";s:1:"0";s:9:"maxemails";s:1:"5";s:14:"emailfloodtime";s:1:"5";s:17:"canviewmemberlist";s:1:"1";s:15:"canviewcalendar";s:1:"1";s:12:"canaddevents";s:1:"0";s:17:"canbypasseventmod";s:1:"0";s:17:"canmoderateevents";s:1:"0";s:13:"canviewonline";s:1:"1";s:15:"canviewwolinvis";s:1:"0";s:16:"canviewonlineips";s:1:"0";s:5:"cancp";s:1:"0";s:10:"issupermod";s:1:"0";s:9:"cansearch";s:1:"1";s:9:"canusercp";s:1:"0";s:16:"canuploadavatars";s:1:"0";s:14:"canratemembers";s:1:"0";s:13:"canchangename";s:1:"0";s:13:"canbereported";s:1:"0";s:14:"canbeinvisible";s:1:"1";s:16:"canchangewebsite";s:1:"0";s:13:"showforumteam";s:1:"0";s:19:"usereputationsystem";s:1:"0";s:18:"cangivereputations";s:1:"0";s:20:"candeletereputations";s:1:"0";s:15:"reputationpower";s:1:"0";s:17:"maxreputationsday";s:1:"0";s:21:"maxreputationsperuser";s:1:"0";s:23:"maxreputationsperthread";s:1:"0";s:15:"candisplaygroup";s:1:"1";s:11:"attachquota";s:1:"0";s:14:"cancustomtitle";s:1:"0";s:12:"canwarnusers";s:1:"0";s:18:"canreceivewarnings";s:1:"0";s:14:"maxwarningsday";s:1:"0";s:8:"canmodcp";s:1:"0";s:18:"showinbirthdaylist";s:1:"0";s:13:"canoverridepm";s:1:"0";s:9:"canusesig";s:1:"0";s:15:"canusesigxposts";s:1:"0";s:11:"signofollow";s:1:"0";s:13:"edittimelimit";s:1:"0";s:8:"maxposts";s:1:"0";s:14:"showmemberlist";s:1:"0";s:17:"canmanageannounce";s:1:"0";s:17:"canmanagemodqueue";s:1:"0";s:24:"canmanagereportedcontent";s:1:"0";s:14:"canviewmodlogs";s:1:"0";s:15:"caneditprofiles";s:1:"0";s:11:"canbanusers";s:1:"0";s:15:"canviewwarnlogs";s:1:"0";s:14:"canuseipsearch";s:1:"0";}i:2;a:91:{s:3:"gid";s:1:"2";s:4:"type";s:1:"1";s:5:"title";s:10:"Registered";s:11:"description";s:66:"After registration, all users are placed in this group by default.";s:9:"namestyle";s:10:"{username}";s:9:"usertitle";s:0:"";s:5:"stars";s:1:"0";s:9:"starimage";s:15:"images/star.png";s:5:"image";s:0:"";s:9:"disporder";s:1:"0";s:13:"isbannedgroup";s:1:"0";s:7:"canview";s:1:"1";s:14:"canviewthreads";s:1:"1";s:15:"canviewprofiles";s:1:"1";s:16:"candlattachments";s:1:"1";s:18:"canviewboardclosed";s:1:"0";s:14:"canpostthreads";s:1:"1";s:13:"canpostreplys";s:1:"1";s:18:"canpostattachments";s:1:"1";s:14:"canratethreads";s:1:"1";s:8:"modposts";s:1:"0";s:10:"modthreads";s:1:"0";s:14:"mod_edit_posts";s:1:"0";s:14:"modattachments";s:1:"0";s:12:"caneditposts";s:1:"1";s:14:"candeleteposts";s:1:"1";s:16:"candeletethreads";s:1:"1";s:18:"caneditattachments";s:1:"1";s:21:"canviewdeletionnotice";s:1:"1";s:12:"canpostpolls";s:1:"1";s:12:"canvotepolls";s:1:"1";s:12:"canundovotes";s:1:"0";s:9:"canusepms";s:1:"1";s:10:"cansendpms";s:1:"1";s:11:"cantrackpms";s:1:"1";s:17:"candenypmreceipts";s:1:"1";s:7:"pmquota";s:3:"200";s:15:"maxpmrecipients";s:1:"5";s:12:"cansendemail";s:1:"1";s:20:"cansendemailoverride";s:1:"0";s:9:"maxemails";s:1:"5";s:14:"emailfloodtime";s:1:"5";s:17:"canviewmemberlist";s:1:"1";s:15:"canviewcalendar";s:1:"1";s:12:"canaddevents";s:1:"1";s:17:"canbypasseventmod";s:1:"0";s:17:"canmoderateevents";s:1:"0";s:13:"canviewonline";s:1:"1";s:15:"canviewwolinvis";s:1:"0";s:16:"canviewonlineips";s:1:"0";s:5:"cancp";s:1:"0";s:10:"issupermod";s:1:"0";s:9:"cansearch";s:1:"1";s:9:"canusercp";s:1:"1";s:16:"canuploadavatars";s:1:"1";s:14:"canratemembers";s:1:"1";s:13:"canchangename";s:1:"0";s:13:"canbereported";s:1:"1";s:14:"canbeinvisible";s:1:"1";s:16:"canchangewebsite";s:1:"1";s:13:"showforumteam";s:1:"0";s:19:"usereputationsystem";s:1:"1";s:18:"cangivereputations";s:1:"1";s:20:"candeletereputations";s:1:"1";s:15:"reputationpower";s:1:"1";s:17:"maxreputationsday";s:1:"5";s:21:"maxreputationsperuser";s:1:"0";s:23:"maxreputationsperthread";s:1:"0";s:15:"candisplaygroup";s:1:"1";s:11:"attachquota";s:1:"0";s:14:"cancustomtitle";s:1:"1";s:12:"canwarnusers";s:1:"0";s:18:"canreceivewarnings";s:1:"1";s:14:"maxwarningsday";s:1:"0";s:8:"canmodcp";s:1:"0";s:18:"showinbirthdaylist";s:1:"1";s:13:"canoverridepm";s:1:"0";s:9:"canusesig";s:1:"1";s:15:"canusesigxposts";s:1:"0";s:11:"signofollow";s:1:"0";s:13:"edittimelimit";s:1:"0";s:8:"maxposts";s:1:"0";s:14:"showmemberlist";s:1:"1";s:17:"canmanageannounce";s:1:"0";s:17:"canmanagemodqueue";s:1:"0";s:24:"canmanagereportedcontent";s:1:"0";s:14:"canviewmodlogs";s:1:"0";s:15:"caneditprofiles";s:1:"0";s:11:"canbanusers";s:1:"0";s:15:"canviewwarnlogs";s:1:"0";s:14:"canuseipsearch";s:1:"0";}i:3;a:91:{s:3:"gid";s:1:"3";s:4:"type";s:1:"1";s:5:"title";s:16:"Super Moderators";s:11:"description";s:35:"These users can moderate any forum.";s:9:"namestyle";s:64:"{username}";s:9:"usertitle";s:15:"Super Moderator";s:5:"stars";s:1:"6";s:9:"starimage";s:15:"images/star.png";s:5:"image";s:0:"";s:9:"disporder";s:1:"0";s:13:"isbannedgroup";s:1:"0";s:7:"canview";s:1:"1";s:14:"canviewthreads";s:1:"1";s:15:"canviewprofiles";s:1:"1";s:16:"candlattachments";s:1:"1";s:18:"canviewboardclosed";s:1:"0";s:14:"canpostthreads";s:1:"1";s:13:"canpostreplys";s:1:"1";s:18:"canpostattachments";s:1:"1";s:14:"canratethreads";s:1:"1";s:8:"modposts";s:1:"0";s:10:"modthreads";s:1:"0";s:14:"mod_edit_posts";s:1:"0";s:14:"modattachments";s:1:"0";s:12:"caneditposts";s:1:"1";s:14:"candeleteposts";s:1:"1";s:16:"candeletethreads";s:1:"1";s:18:"caneditattachments";s:1:"1";s:21:"canviewdeletionnotice";s:1:"1";s:12:"canpostpolls";s:1:"1";s:12:"canvotepolls";s:1:"1";s:12:"canundovotes";s:1:"1";s:9:"canusepms";s:1:"1";s:10:"cansendpms";s:1:"1";s:11:"cantrackpms";s:1:"1";s:17:"candenypmreceipts";s:1:"1";s:7:"pmquota";s:3:"250";s:15:"maxpmrecipients";s:1:"5";s:12:"cansendemail";s:1:"1";s:20:"cansendemailoverride";s:1:"0";s:9:"maxemails";s:2:"10";s:14:"emailfloodtime";s:1:"5";s:17:"canviewmemberlist";s:1:"1";s:15:"canviewcalendar";s:1:"1";s:12:"canaddevents";s:1:"1";s:17:"canbypasseventmod";s:1:"1";s:17:"canmoderateevents";s:1:"1";s:13:"canviewonline";s:1:"1";s:15:"canviewwolinvis";s:1:"1";s:16:"canviewonlineips";s:1:"1";s:5:"cancp";s:1:"0";s:10:"issupermod";s:1:"1";s:9:"cansearch";s:1:"1";s:9:"canusercp";s:1:"1";s:16:"canuploadavatars";s:1:"1";s:14:"canratemembers";s:1:"1";s:13:"canchangename";s:1:"1";s:13:"canbereported";s:1:"0";s:14:"canbeinvisible";s:1:"1";s:16:"canchangewebsite";s:1:"1";s:13:"showforumteam";s:1:"1";s:19:"usereputationsystem";s:1:"1";s:18:"cangivereputations";s:1:"1";s:20:"candeletereputations";s:1:"1";s:15:"reputationpower";s:1:"1";s:17:"maxreputationsday";s:2:"10";s:21:"maxreputationsperuser";s:1:"0";s:23:"maxreputationsperthread";s:1:"0";s:15:"candisplaygroup";s:1:"1";s:11:"attachquota";s:1:"0";s:14:"cancustomtitle";s:1:"1";s:12:"canwarnusers";s:1:"1";s:18:"canreceivewarnings";s:1:"1";s:14:"maxwarningsday";s:1:"3";s:8:"canmodcp";s:1:"1";s:18:"showinbirthdaylist";s:1:"1";s:13:"canoverridepm";s:1:"0";s:9:"canusesig";s:1:"1";s:15:"canusesigxposts";s:1:"0";s:11:"signofollow";s:1:"0";s:13:"edittimelimit";s:1:"0";s:8:"maxposts";s:1:"0";s:14:"showmemberlist";s:1:"1";s:17:"canmanageannounce";s:1:"1";s:17:"canmanagemodqueue";s:1:"1";s:24:"canmanagereportedcontent";s:1:"1";s:14:"canviewmodlogs";s:1:"1";s:15:"caneditprofiles";s:1:"1";s:11:"canbanusers";s:1:"1";s:15:"canviewwarnlogs";s:1:"1";s:14:"canuseipsearch";s:1:"1";}i:4;a:91:{s:3:"gid";s:1:"4";s:4:"type";s:1:"1";s:5:"title";s:14:"Administrators";s:11:"description";s:39:"The group all administrators belong to.";s:9:"namestyle";s:71:"{username}";s:9:"usertitle";s:13:"Administrator";s:5:"stars";s:1:"7";s:9:"starimage";s:15:"images/star.png";s:5:"image";s:0:"";s:9:"disporder";s:1:"0";s:13:"isbannedgroup";s:1:"0";s:7:"canview";s:1:"1";s:14:"canviewthreads";s:1:"1";s:15:"canviewprofiles";s:1:"1";s:16:"candlattachments";s:1:"1";s:18:"canviewboardclosed";s:1:"1";s:14:"canpostthreads";s:1:"1";s:13:"canpostreplys";s:1:"1";s:18:"canpostattachments";s:1:"1";s:14:"canratethreads";s:1:"1";s:8:"modposts";s:1:"0";s:10:"modthreads";s:1:"0";s:14:"mod_edit_posts";s:1:"0";s:14:"modattachments";s:1:"0";s:12:"caneditposts";s:1:"1";s:14:"candeleteposts";s:1:"1";s:16:"candeletethreads";s:1:"1";s:18:"caneditattachments";s:1:"1";s:21:"canviewdeletionnotice";s:1:"1";s:12:"canpostpolls";s:1:"1";s:12:"canvotepolls";s:1:"1";s:12:"canundovotes";s:1:"1";s:9:"canusepms";s:1:"1";s:10:"cansendpms";s:1:"1";s:11:"cantrackpms";s:1:"1";s:17:"candenypmreceipts";s:1:"1";s:7:"pmquota";s:1:"0";s:15:"maxpmrecipients";s:1:"0";s:12:"cansendemail";s:1:"1";s:20:"cansendemailoverride";s:1:"0";s:9:"maxemails";s:1:"0";s:14:"emailfloodtime";s:1:"0";s:17:"canviewmemberlist";s:1:"1";s:15:"canviewcalendar";s:1:"1";s:12:"canaddevents";s:1:"1";s:17:"canbypasseventmod";s:1:"1";s:17:"canmoderateevents";s:1:"1";s:13:"canviewonline";s:1:"1";s:15:"canviewwolinvis";s:1:"1";s:16:"canviewonlineips";s:1:"1";s:5:"cancp";s:1:"1";s:10:"issupermod";s:1:"1";s:9:"cansearch";s:1:"1";s:9:"canusercp";s:1:"1";s:16:"canuploadavatars";s:1:"1";s:14:"canratemembers";s:1:"1";s:13:"canchangename";s:1:"1";s:13:"canbereported";s:1:"0";s:14:"canbeinvisible";s:1:"1";s:16:"canchangewebsite";s:1:"1";s:13:"showforumteam";s:1:"1";s:19:"usereputationsystem";s:1:"1";s:18:"cangivereputations";s:1:"1";s:20:"candeletereputations";s:1:"1";s:15:"reputationpower";s:1:"2";s:17:"maxreputationsday";s:1:"0";s:21:"maxreputationsperuser";s:1:"0";s:23:"maxreputationsperthread";s:1:"0";s:15:"candisplaygroup";s:1:"1";s:11:"attachquota";s:1:"0";s:14:"cancustomtitle";s:1:"1";s:12:"canwarnusers";s:1:"1";s:18:"canreceivewarnings";s:1:"1";s:14:"maxwarningsday";s:1:"0";s:8:"canmodcp";s:1:"1";s:18:"showinbirthdaylist";s:1:"1";s:13:"canoverridepm";s:1:"0";s:9:"canusesig";s:1:"1";s:15:"canusesigxposts";s:1:"0";s:11:"signofollow";s:1:"0";s:13:"edittimelimit";s:1:"0";s:8:"maxposts";s:1:"0";s:14:"showmemberlist";s:1:"1";s:17:"canmanageannounce";s:1:"1";s:17:"canmanagemodqueue";s:1:"1";s:24:"canmanagereportedcontent";s:1:"1";s:14:"canviewmodlogs";s:1:"1";s:15:"caneditprofiles";s:1:"1";s:11:"canbanusers";s:1:"1";s:15:"canviewwarnlogs";s:1:"1";s:14:"canuseipsearch";s:1:"1";}i:5;a:91:{s:3:"gid";s:1:"5";s:4:"type";s:1:"1";s:5:"title";s:19:"Awaiting Activation";s:11:"description";s:84:"Users that have not activated their account by email or manually been activated yet.";s:9:"namestyle";s:10:"{username}";s:9:"usertitle";s:21:"Account not Activated";s:5:"stars";s:1:"0";s:9:"starimage";s:15:"images/star.png";s:5:"image";s:0:"";s:9:"disporder";s:1:"0";s:13:"isbannedgroup";s:1:"0";s:7:"canview";s:1:"1";s:14:"canviewthreads";s:1:"1";s:15:"canviewprofiles";s:1:"1";s:16:"candlattachments";s:1:"0";s:18:"canviewboardclosed";s:1:"0";s:14:"canpostthreads";s:1:"0";s:13:"canpostreplys";s:1:"0";s:18:"canpostattachments";s:1:"0";s:14:"canratethreads";s:1:"0";s:8:"modposts";s:1:"0";s:10:"modthreads";s:1:"0";s:14:"mod_edit_posts";s:1:"0";s:14:"modattachments";s:1:"0";s:12:"caneditposts";s:1:"0";s:14:"candeleteposts";s:1:"0";s:16:"candeletethreads";s:1:"0";s:18:"caneditattachments";s:1:"0";s:21:"canviewdeletionnotice";s:1:"0";s:12:"canpostpolls";s:1:"0";s:12:"canvotepolls";s:1:"0";s:12:"canundovotes";s:1:"0";s:9:"canusepms";s:1:"0";s:10:"cansendpms";s:1:"0";s:11:"cantrackpms";s:1:"0";s:17:"candenypmreceipts";s:1:"0";s:7:"pmquota";s:2:"20";s:15:"maxpmrecipients";s:1:"5";s:12:"cansendemail";s:1:"0";s:20:"cansendemailoverride";s:1:"0";s:9:"maxemails";s:1:"5";s:14:"emailfloodtime";s:1:"5";s:17:"canviewmemberlist";s:1:"1";s:15:"canviewcalendar";s:1:"1";s:12:"canaddevents";s:1:"0";s:17:"canbypasseventmod";s:1:"0";s:17:"canmoderateevents";s:1:"0";s:13:"canviewonline";s:1:"1";s:15:"canviewwolinvis";s:1:"0";s:16:"canviewonlineips";s:1:"0";s:5:"cancp";s:1:"0";s:10:"issupermod";s:1:"0";s:9:"cansearch";s:1:"1";s:9:"canusercp";s:1:"1";s:16:"canuploadavatars";s:1:"0";s:14:"canratemembers";s:1:"0";s:13:"canchangename";s:1:"0";s:13:"canbereported";s:1:"1";s:14:"canbeinvisible";s:1:"1";s:16:"canchangewebsite";s:1:"0";s:13:"showforumteam";s:1:"0";s:19:"usereputationsystem";s:1:"0";s:18:"cangivereputations";s:1:"0";s:20:"candeletereputations";s:1:"0";s:15:"reputationpower";s:1:"0";s:17:"maxreputationsday";s:1:"0";s:21:"maxreputationsperuser";s:1:"0";s:23:"maxreputationsperthread";s:1:"0";s:15:"candisplaygroup";s:1:"1";s:11:"attachquota";s:1:"0";s:14:"cancustomtitle";s:1:"0";s:12:"canwarnusers";s:1:"0";s:18:"canreceivewarnings";s:1:"0";s:14:"maxwarningsday";s:1:"0";s:8:"canmodcp";s:1:"0";s:18:"showinbirthdaylist";s:1:"1";s:13:"canoverridepm";s:1:"0";s:9:"canusesig";s:1:"0";s:15:"canusesigxposts";s:1:"0";s:11:"signofollow";s:1:"0";s:13:"edittimelimit";s:1:"0";s:8:"maxposts";s:1:"0";s:14:"showmemberlist";s:1:"1";s:17:"canmanageannounce";s:1:"0";s:17:"canmanagemodqueue";s:1:"0";s:24:"canmanagereportedcontent";s:1:"0";s:14:"canviewmodlogs";s:1:"0";s:15:"caneditprofiles";s:1:"0";s:11:"canbanusers";s:1:"0";s:15:"canviewwarnlogs";s:1:"0";s:14:"canuseipsearch";s:1:"0";}i:6;a:91:{s:3:"gid";s:1:"6";s:4:"type";s:1:"1";s:5:"title";s:10:"Moderators";s:11:"description";s:37:"These users moderate specific forums.";s:9:"namestyle";s:64:"{username}";s:9:"usertitle";s:9:"Moderator";s:5:"stars";s:1:"5";s:9:"starimage";s:15:"images/star.png";s:5:"image";s:0:"";s:9:"disporder";s:1:"0";s:13:"isbannedgroup";s:1:"0";s:7:"canview";s:1:"1";s:14:"canviewthreads";s:1:"1";s:15:"canviewprofiles";s:1:"1";s:16:"candlattachments";s:1:"1";s:18:"canviewboardclosed";s:1:"0";s:14:"canpostthreads";s:1:"1";s:13:"canpostreplys";s:1:"1";s:18:"canpostattachments";s:1:"1";s:14:"canratethreads";s:1:"1";s:8:"modposts";s:1:"0";s:10:"modthreads";s:1:"0";s:14:"mod_edit_posts";s:1:"0";s:14:"modattachments";s:1:"0";s:12:"caneditposts";s:1:"1";s:14:"candeleteposts";s:1:"1";s:16:"candeletethreads";s:1:"1";s:18:"caneditattachments";s:1:"1";s:21:"canviewdeletionnotice";s:1:"1";s:12:"canpostpolls";s:1:"1";s:12:"canvotepolls";s:1:"1";s:12:"canundovotes";s:1:"0";s:9:"canusepms";s:1:"1";s:10:"cansendpms";s:1:"1";s:11:"cantrackpms";s:1:"1";s:17:"candenypmreceipts";s:1:"1";s:7:"pmquota";s:3:"250";s:15:"maxpmrecipients";s:1:"5";s:12:"cansendemail";s:1:"1";s:20:"cansendemailoverride";s:1:"0";s:9:"maxemails";s:1:"5";s:14:"emailfloodtime";s:1:"5";s:17:"canviewmemberlist";s:1:"1";s:15:"canviewcalendar";s:1:"1";s:12:"canaddevents";s:1:"0";s:17:"canbypasseventmod";s:1:"0";s:17:"canmoderateevents";s:1:"0";s:13:"canviewonline";s:1:"1";s:15:"canviewwolinvis";s:1:"0";s:16:"canviewonlineips";s:1:"0";s:5:"cancp";s:1:"0";s:10:"issupermod";s:1:"0";s:9:"cansearch";s:1:"1";s:9:"canusercp";s:1:"1";s:16:"canuploadavatars";s:1:"1";s:14:"canratemembers";s:1:"1";s:13:"canchangename";s:1:"1";s:13:"canbereported";s:1:"0";s:14:"canbeinvisible";s:1:"1";s:16:"canchangewebsite";s:1:"1";s:13:"showforumteam";s:1:"1";s:19:"usereputationsystem";s:1:"1";s:18:"cangivereputations";s:1:"1";s:20:"candeletereputations";s:1:"1";s:15:"reputationpower";s:1:"1";s:17:"maxreputationsday";s:2:"10";s:21:"maxreputationsperuser";s:1:"0";s:23:"maxreputationsperthread";s:1:"0";s:15:"candisplaygroup";s:1:"1";s:11:"attachquota";s:1:"0";s:14:"cancustomtitle";s:1:"1";s:12:"canwarnusers";s:1:"1";s:18:"canreceivewarnings";s:1:"1";s:14:"maxwarningsday";s:1:"3";s:8:"canmodcp";s:1:"1";s:18:"showinbirthdaylist";s:1:"1";s:13:"canoverridepm";s:1:"0";s:9:"canusesig";s:1:"1";s:15:"canusesigxposts";s:1:"0";s:11:"signofollow";s:1:"0";s:13:"edittimelimit";s:1:"0";s:8:"maxposts";s:1:"0";s:14:"showmemberlist";s:1:"1";s:17:"canmanageannounce";s:1:"1";s:17:"canmanagemodqueue";s:1:"1";s:24:"canmanagereportedcontent";s:1:"1";s:14:"canviewmodlogs";s:1:"1";s:15:"caneditprofiles";s:1:"1";s:11:"canbanusers";s:1:"1";s:15:"canviewwarnlogs";s:1:"1";s:14:"canuseipsearch";s:1:"1";}i:7;a:91:{s:3:"gid";s:1:"7";s:4:"type";s:1:"1";s:5:"title";s:6:"Banned";s:11:"description";s:69:"The default user group to which members that are banned are moved to.";s:9:"namestyle";s:17:"{username}";s:9:"usertitle";s:6:"Banned";s:5:"stars";s:1:"0";s:9:"starimage";s:15:"images/star.png";s:5:"image";s:0:"";s:9:"disporder";s:1:"0";s:13:"isbannedgroup";s:1:"1";s:7:"canview";s:1:"0";s:14:"canviewthreads";s:1:"0";s:15:"canviewprofiles";s:1:"0";s:16:"candlattachments";s:1:"0";s:18:"canviewboardclosed";s:1:"0";s:14:"canpostthreads";s:1:"0";s:13:"canpostreplys";s:1:"0";s:18:"canpostattachments";s:1:"0";s:14:"canratethreads";s:1:"0";s:8:"modposts";s:1:"0";s:10:"modthreads";s:1:"0";s:14:"mod_edit_posts";s:1:"0";s:14:"modattachments";s:1:"0";s:12:"caneditposts";s:1:"0";s:14:"candeleteposts";s:1:"0";s:16:"candeletethreads";s:1:"0";s:18:"caneditattachments";s:1:"0";s:21:"canviewdeletionnotice";s:1:"0";s:12:"canpostpolls";s:1:"0";s:12:"canvotepolls";s:1:"0";s:12:"canundovotes";s:1:"0";s:9:"canusepms";s:1:"1";s:10:"cansendpms";s:1:"0";s:11:"cantrackpms";s:1:"0";s:17:"candenypmreceipts";s:1:"0";s:7:"pmquota";s:1:"0";s:15:"maxpmrecipients";s:1:"0";s:12:"cansendemail";s:1:"0";s:20:"cansendemailoverride";s:1:"0";s:9:"maxemails";s:1:"5";s:14:"emailfloodtime";s:1:"5";s:17:"canviewmemberlist";s:1:"0";s:15:"canviewcalendar";s:1:"0";s:12:"canaddevents";s:1:"0";s:17:"canbypasseventmod";s:1:"0";s:17:"canmoderateevents";s:1:"0";s:13:"canviewonline";s:1:"0";s:15:"canviewwolinvis";s:1:"0";s:16:"canviewonlineips";s:1:"0";s:5:"cancp";s:1:"0";s:10:"issupermod";s:1:"0";s:9:"cansearch";s:1:"0";s:9:"canusercp";s:1:"0";s:16:"canuploadavatars";s:1:"0";s:14:"canratemembers";s:1:"0";s:13:"canchangename";s:1:"0";s:13:"canbereported";s:1:"0";s:14:"canbeinvisible";s:1:"1";s:16:"canchangewebsite";s:1:"0";s:13:"showforumteam";s:1:"0";s:19:"usereputationsystem";s:1:"0";s:18:"cangivereputations";s:1:"0";s:20:"candeletereputations";s:1:"0";s:15:"reputationpower";s:1:"0";s:17:"maxreputationsday";s:1:"0";s:21:"maxreputationsperuser";s:1:"0";s:23:"maxreputationsperthread";s:1:"0";s:15:"candisplaygroup";s:1:"1";s:11:"attachquota";s:1:"0";s:14:"cancustomtitle";s:1:"0";s:12:"canwarnusers";s:1:"0";s:18:"canreceivewarnings";s:1:"0";s:14:"maxwarningsday";s:1:"0";s:8:"canmodcp";s:1:"0";s:18:"showinbirthdaylist";s:1:"0";s:13:"canoverridepm";s:1:"0";s:9:"canusesig";s:1:"0";s:15:"canusesigxposts";s:1:"0";s:11:"signofollow";s:1:"0";s:13:"edittimelimit";s:1:"0";s:8:"maxposts";s:1:"0";s:14:"showmemberlist";s:1:"1";s:17:"canmanageannounce";s:1:"0";s:17:"canmanagemodqueue";s:1:"0";s:24:"canmanagereportedcontent";s:1:"0";s:14:"canviewmodlogs";s:1:"0";s:15:"caneditprofiles";s:1:"0";s:11:"canbanusers";s:1:"0";s:15:"canviewwarnlogs";s:1:"0";s:14:"canuseipsearch";s:1:"0";}}'),
('stats', 'a:9:{s:10:"numthreads";s:1:"0";s:20:"numunapprovedthreads";s:1:"0";s:8:"numposts";s:1:"0";s:18:"numunapprovedposts";s:1:"0";s:8:"numusers";s:1:"1";s:15:"numdeletedposts";s:1:"0";s:17:"numdeletedthreads";s:1:"0";s:7:"lastuid";s:1:"1";s:12:"lastusername";[[scr_admin_username]]}'),
('statistics', 'a:4:{s:4:"time";i:[[timestamp]];s:12:"top_referrer";a:0:{}s:10:"top_poster";a:0:{}s:7:"posters";s:1:"0";}'),
('forums', 'a:2:{i:1;a:30:{s:3:"fid";s:1:"1";s:4:"name";s:11:"My Category";s:11:"description";s:0:"";s:6:"linkto";s:0:"";s:4:"type";s:1:"c";s:3:"pid";s:1:"0";s:10:"parentlist";s:1:"1";s:9:"disporder";s:1:"1";s:6:"active";s:1:"1";s:4:"open";s:1:"1";s:9:"allowhtml";s:1:"0";s:11:"allowmycode";s:1:"1";s:12:"allowsmilies";s:1:"1";s:12:"allowimgcode";s:1:"1";s:14:"allowvideocode";s:1:"1";s:11:"allowpicons";s:1:"1";s:13:"allowtratings";s:1:"1";s:13:"usepostcounts";s:1:"1";s:15:"usethreadcounts";s:1:"1";s:13:"requireprefix";s:1:"0";s:8:"password";s:0:"";s:10:"showinjump";s:1:"1";s:5:"style";s:1:"0";s:13:"overridestyle";s:1:"0";s:9:"rulestype";s:1:"0";s:10:"rulestitle";s:0:"";s:5:"rules";s:0:"";s:14:"defaultdatecut";s:1:"0";s:13:"defaultsortby";s:0:"";s:16:"defaultsortorder";s:0:"";}i:2;a:30:{s:3:"fid";s:1:"2";s:4:"name";s:8:"My Forum";s:11:"description";s:0:"";s:6:"linkto";s:0:"";s:4:"type";s:1:"f";s:3:"pid";s:1:"1";s:10:"parentlist";s:3:"1,2";s:9:"disporder";s:1:"1";s:6:"active";s:1:"1";s:4:"open";s:1:"1";s:9:"allowhtml";s:1:"0";s:11:"allowmycode";s:1:"1";s:12:"allowsmilies";s:1:"1";s:12:"allowimgcode";s:1:"1";s:14:"allowvideocode";s:1:"1";s:11:"allowpicons";s:1:"1";s:13:"allowtratings";s:1:"1";s:13:"usepostcounts";s:1:"1";s:15:"usethreadcounts";s:1:"1";s:13:"requireprefix";s:1:"0";s:8:"password";s:0:"";s:10:"showinjump";s:1:"1";s:5:"style";s:1:"0";s:13:"overridestyle";s:1:"0";s:9:"rulestype";s:1:"0";s:10:"rulestitle";s:0:"";s:5:"rules";s:0:"";s:14:"defaultdatecut";s:1:"0";s:13:"defaultsortby";s:0:"";s:16:"defaultsortorder";s:0:"";}}'),
('moderators', 'a:3:{i:0;i:0;i:1;a:0:{}i:2;a:0:{}}'),
('usertitles', 'a:5:{i:0;a:5:{s:4:"utid";s:1:"5";s:5:"posts";s:3:"750";s:5:"title";s:13:"Posting Freak";s:5:"stars";s:1:"5";s:9:"starimage";s:0:"";}i:1;a:5:{s:4:"utid";s:1:"4";s:5:"posts";s:3:"250";s:5:"title";s:13:"Senior Member";s:5:"stars";s:1:"4";s:9:"starimage";s:0:"";}i:2;a:5:{s:4:"utid";s:1:"3";s:5:"posts";s:2:"50";s:5:"title";s:6:"Member";s:5:"stars";s:1:"3";s:9:"starimage";s:0:"";}i:3;a:5:{s:4:"utid";s:1:"2";s:5:"posts";s:1:"1";s:5:"title";s:13:"Junior Member";s:5:"stars";s:1:"2";s:9:"starimage";s:0:"";}i:4;a:5:{s:4:"utid";s:1:"1";s:5:"posts";s:1:"0";s:5:"title";s:6:"Newbie";s:5:"stars";s:1:"1";s:9:"starimage";s:0:"";}}'),
('reportedcontent', 'a:3:{s:6:"unread";s:1:"0";s:5:"total";s:1:"0";s:12:"lastdateline";N;}'),
('awaitingactivation', 'a:2:{s:5:"users";i:0;s:4:"time";i:[[timestamp]];}'),
('mycode', 'a:0:{}'),
('profilefields', 'a:3:{i:0;a:20:{s:3:"fid";s:1:"1";s:4:"name";s:8:"Location";s:11:"description";s:31:"Where in the world do you live?";s:9:"disporder";s:1:"1";s:4:"type";s:4:"text";s:5:"regex";s:0:"";s:6:"length";s:1:"0";s:9:"maxlength";s:3:"255";s:8:"required";s:1:"0";s:12:"registration";s:1:"0";s:7:"profile";s:1:"1";s:7:"postbit";s:1:"0";s:10:"viewableby";s:2:"-1";s:10:"editableby";s:2:"-1";s:7:"postnum";s:1:"0";s:9:"allowhtml";s:1:"0";s:11:"allowmycode";s:1:"0";s:12:"allowsmilies";s:1:"0";s:12:"allowimgcode";s:1:"0";s:14:"allowvideocode";s:1:"0";}i:1;a:20:{s:3:"fid";s:1:"2";s:4:"name";s:3:"Bio";s:11:"description";s:62:"Enter a few short details about yourself, your life story etc.";s:9:"disporder";s:1:"2";s:4:"type";s:8:"textarea";s:5:"regex";s:0:"";s:6:"length";s:1:"0";s:9:"maxlength";s:1:"0";s:8:"required";s:1:"0";s:12:"registration";s:1:"0";s:7:"profile";s:1:"1";s:7:"postbit";s:1:"0";s:10:"viewableby";s:2:"-1";s:10:"editableby";s:2:"-1";s:7:"postnum";s:1:"0";s:9:"allowhtml";s:1:"0";s:11:"allowmycode";s:1:"0";s:12:"allowsmilies";s:1:"0";s:12:"allowimgcode";s:1:"0";s:14:"allowvideocode";s:1:"0";}i:2;a:20:{s:3:"fid";s:1:"3";s:4:"name";s:6:"Gender";s:11:"description";s:46:"Please select your gender from the list below.";s:9:"disporder";s:1:"3";s:4:"type";s:36:"select\nUndisclosed\nMale\nFemale\nOther";s:5:"regex";s:0:"";s:6:"length";s:1:"0";s:9:"maxlength";s:1:"0";s:8:"required";s:1:"0";s:12:"registration";s:1:"0";s:7:"profile";s:1:"1";s:7:"postbit";s:1:"0";s:10:"viewableby";s:2:"-1";s:10:"editableby";s:2:"-1";s:7:"postnum";s:1:"0";s:9:"allowhtml";s:1:"0";s:11:"allowmycode";s:1:"0";s:12:"allowsmilies";s:1:"0";s:12:"allowimgcode";s:1:"0";s:14:"allowvideocode";s:1:"0";}}'),
('posticons', 'a:20:{i:1;a:3:{s:3:"iid";s:1:"1";s:4:"name";s:3:"Bug";s:4:"path";s:20:"images/icons/bug.png";}i:2;a:3:{s:3:"iid";s:1:"2";s:4:"name";s:11:"Exclamation";s:4:"path";s:28:"images/icons/exclamation.png";}i:3;a:3:{s:3:"iid";s:1:"3";s:4:"name";s:8:"Question";s:4:"path";s:25:"images/icons/question.png";}i:4;a:3:{s:3:"iid";s:1:"4";s:4:"name";s:5:"Smile";s:4:"path";s:22:"images/icons/smile.png";}i:5;a:3:{s:3:"iid";s:1:"5";s:4:"name";s:3:"Sad";s:4:"path";s:20:"images/icons/sad.png";}i:6;a:3:{s:3:"iid";s:1:"6";s:4:"name";s:4:"Wink";s:4:"path";s:21:"images/icons/wink.png";}i:7;a:3:{s:3:"iid";s:1:"7";s:4:"name";s:8:"Big Grin";s:4:"path";s:24:"images/icons/biggrin.png";}i:8;a:3:{s:3:"iid";s:1:"8";s:4:"name";s:6:"Tongue";s:4:"path";s:23:"images/icons/tongue.png";}i:9;a:3:{s:3:"iid";s:1:"9";s:4:"name";s:5:"Brick";s:4:"path";s:22:"images/icons/brick.png";}i:10;a:3:{s:3:"iid";s:2:"10";s:4:"name";s:5:"Heart";s:4:"path";s:22:"images/icons/heart.png";}i:11;a:3:{s:3:"iid";s:2:"11";s:4:"name";s:11:"Information";s:4:"path";s:28:"images/icons/information.png";}i:12;a:3:{s:3:"iid";s:2:"12";s:4:"name";s:9:"Lightbulb";s:4:"path";s:26:"images/icons/lightbulb.png";}i:13;a:3:{s:3:"iid";s:2:"13";s:4:"name";s:5:"Music";s:4:"path";s:22:"images/icons/music.png";}i:14;a:3:{s:3:"iid";s:2:"14";s:4:"name";s:5:"Photo";s:4:"path";s:22:"images/icons/photo.png";}i:15;a:3:{s:3:"iid";s:2:"15";s:4:"name";s:7:"Rainbow";s:4:"path";s:24:"images/icons/rainbow.png";}i:16;a:3:{s:3:"iid";s:2:"16";s:4:"name";s:7:"Shocked";s:4:"path";s:24:"images/icons/shocked.png";}i:17;a:3:{s:3:"iid";s:2:"17";s:4:"name";s:4:"Star";s:4:"path";s:21:"images/icons/star.png";}i:18;a:3:{s:3:"iid";s:2:"18";s:4:"name";s:11:"Thumbs Down";s:4:"path";s:27:"images/icons/thumbsdown.png";}i:19;a:3:{s:3:"iid";s:2:"19";s:4:"name";s:9:"Thumbs Up";s:4:"path";s:25:"images/icons/thumbsup.png";}i:20;a:3:{s:3:"iid";s:2:"20";s:4:"name";s:5:"Video";s:4:"path";s:22:"images/icons/video.png";}}'),
('spiders', 'a:15:{i:7;a:4:{s:3:"sid";s:1:"7";s:4:"name";s:8:"Facebook";s:9:"useragent";s:19:"facebookexternalhit";s:9:"usergroup";s:1:"0";}i:13;a:4:{s:3:"sid";s:2:"13";s:4:"name";s:7:"Pingdom";s:9:"useragent";s:15:"Pingdom.com_bot";s:9:"usergroup";s:1:"0";}i:9;a:4:{s:3:"sid";s:1:"9";s:4:"name";s:16:"Internet Archive";s:9:"useragent";s:15:"archive.org_bot";s:9:"usergroup";s:1:"0";}i:15;a:4:{s:3:"sid";s:2:"15";s:4:"name";s:11:"UptimeRobot";s:9:"useragent";s:11:"UptimeRobot";s:9:"usergroup";s:1:"0";}i:14;a:4:{s:3:"sid";s:2:"14";s:4:"name";s:10:"DuckDuckGo";s:9:"useragent";s:11:"DuckDuckBot";s:9:"usergroup";s:1:"0";}i:3;a:4:{s:3:"sid";s:1:"3";s:4:"name";s:14:"Alexa Internet";s:9:"useragent";s:11:"ia_archiver";s:9:"usergroup";s:1:"0";}i:5;a:4:{s:3:"sid";s:1:"5";s:4:"name";s:5:"Baidu";s:9:"useragent";s:11:"Baiduspider";s:9:"usergroup";s:1:"0";}i:10;a:4:{s:3:"sid";s:2:"10";s:4:"name";s:7:"Discord";s:9:"useragent";s:10:"Discordbot";s:9:"usergroup";s:1:"0";}i:8;a:4:{s:3:"sid";s:1:"8";s:4:"name";s:7:"Twitter";s:9:"useragent";s:10:"Twitterbot";s:9:"usergroup";s:1:"0";}i:6;a:4:{s:3:"sid";s:1:"6";s:4:"name";s:6:"Yandex";s:9:"useragent";s:9:"YandexBot";s:9:"usergroup";s:1:"0";}i:12;a:4:{s:3:"sid";s:2:"12";s:4:"name";s:9:"CheckHost";s:9:"useragent";s:9:"CheckHost";s:9:"usergroup";s:1:"0";}i:1;a:4:{s:3:"sid";s:1:"1";s:4:"name";s:6:"Google";s:9:"useragent";s:9:"Googlebot";s:9:"usergroup";s:1:"0";}i:11;a:4:{s:3:"sid";s:2:"11";s:4:"name";s:8:"Applebot";s:9:"useragent";s:8:"Applebot";s:9:"usergroup";s:1:"0";}i:2;a:4:{s:3:"sid";s:1:"2";s:4:"name";s:4:"Bing";s:9:"useragent";s:7:"bingbot";s:9:"usergroup";s:1:"0";}i:4;a:4:{s:3:"sid";s:1:"4";s:4:"name";s:7:"Ask.com";s:9:"useragent";s:5:"Teoma";s:9:"usergroup";s:1:"0";}}'),
('bannedips', 'a:0:{}'),
('bannedemails', 'a:0:{}'),
('birthdays', 'a:0:{}'),
('groupleaders', 'a:0:{}'),
('threadprefixes', 'a:0:{}'),
('forumsdisplay', 'a:0:{}'),
('plugins', 'a:0:{}'),
('mostonline', 'a:2:{s:8:"numusers";i:0;s:4:"time";i:0;}'),
('internal_settings', 'a:1:{s:14:"encryption_key";s:32:"[[enc_key]]";}'),
('reportreasons', 'a:3:{s:4:"post";a:5:{i:0;a:3:{s:3:"rid";s:1:"2";s:5:"title";s:26:"";s:5:"extra";s:1:"0";}i:1;a:3:{s:3:"rid";s:1:"3";s:5:"title";s:24:"";s:5:"extra";s:1:"0";}i:2;a:3:{s:3:"rid";s:1:"4";s:5:"title";s:25:"";s:5:"extra";s:1:"0";}i:3;a:3:{s:3:"rid";s:1:"5";s:5:"title";s:26:"";s:5:"extra";s:1:"0";}i:4;a:3:{s:3:"rid";s:1:"1";s:5:"title";s:26:"";s:5:"extra";s:1:"1";}}s:7:"profile";a:4:{i:0;a:3:{s:3:"rid";s:1:"2";s:5:"title";s:26:"";s:5:"extra";s:1:"0";}i:1;a:3:{s:3:"rid";s:1:"3";s:5:"title";s:24:"";s:5:"extra";s:1:"0";}i:2;a:3:{s:3:"rid";s:1:"4";s:5:"title";s:25:"";s:5:"extra";s:1:"0";}i:3;a:3:{s:3:"rid";s:1:"1";s:5:"title";s:26:"";s:5:"extra";s:1:"1";}}s:10:"reputation";a:4:{i:0;a:3:{s:3:"rid";s:1:"2";s:5:"title";s:26:"";s:5:"extra";s:1:"0";}i:1;a:3:{s:3:"rid";s:1:"3";s:5:"title";s:24:"";s:5:"extra";s:1:"0";}i:2;a:3:{s:3:"rid";s:1:"4";s:5:"title";s:25:"";s:5:"extra";s:1:"0";}i:3;a:3:{s:3:"rid";s:1:"1";s:5:"title";s:26:"";s:5:"extra";s:1:"1";}}}'),
('version_history', 'a:59:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"4";i:4;s:1:"5";i:5;s:1:"6";i:6;s:1:"7";i:7;s:1:"8";i:8;s:1:"9";i:9;s:2:"10";i:10;s:2:"11";i:11;s:2:"12";i:12;s:2:"13";i:13;s:2:"14";i:14;s:2:"15";i:15;s:2:"16";i:16;s:2:"17";i:17;s:2:"18";i:18;s:2:"19";i:19;s:2:"20";i:20;s:2:"21";i:21;s:2:"22";i:22;s:2:"23";i:23;s:2:"24";i:24;s:2:"25";i:25;s:2:"26";i:26;s:2:"27";i:27;s:2:"28";i:28;s:2:"29";i:29;s:2:"30";i:30;s:2:"31";i:31;s:2:"32";i:32;s:2:"33";i:33;s:2:"34";i:34;s:2:"35";i:35;s:2:"36";i:36;s:2:"37";i:37;s:2:"38";i:38;s:2:"39";i:39;s:2:"40";i:40;s:2:"41";i:41;s:2:"42";i:42;s:2:"43";i:43;s:2:"44";i:44;s:2:"45";i:45;s:2:"46";i:46;s:2:"47";i:47;s:2:"48";i:48;s:2:"49";i:49;s:2:"50";i:50;s:2:"51";i:51;s:2:"52";i:52;s:2:"53";i:53;s:2:"54";i:54;s:2:"55";i:55;s:2:"56";i:56;s:2:"57";i:57;s:2:"58";i:58;s:2:"59";}'),
('update_check', 'a:1:{s:8:"dateline";i:[[timestamp]];}'),
('tasks', 'a:1:{s:7:"nextrun";s:10:"[[timestamp]]";}');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]delayedmoderation`
--
CREATE TABLE `[[dbprefix]]delayedmoderation` (
`did` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(30) NOT NULL DEFAULT '',
`delaydateline` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`fid` smallint(5) unsigned NOT NULL DEFAULT '0',
`tids` text NOT NULL,
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`inputs` text NOT NULL,
PRIMARY KEY (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]events`
--
CREATE TABLE `[[dbprefix]]events` (
`eid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cid` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(120) NOT NULL DEFAULT '',
`description` text NOT NULL,
`visible` tinyint(1) NOT NULL DEFAULT '0',
`private` tinyint(1) NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`starttime` int(10) unsigned NOT NULL DEFAULT '0',
`endtime` int(10) unsigned NOT NULL DEFAULT '0',
`timezone` varchar(5) NOT NULL DEFAULT '',
`ignoretimezone` tinyint(1) NOT NULL DEFAULT '0',
`usingtime` tinyint(1) NOT NULL DEFAULT '0',
`repeats` text NOT NULL,
PRIMARY KEY (`eid`),
KEY `cid` (`cid`),
KEY `daterange` (`starttime`,`endtime`),
KEY `private` (`private`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]forumpermissions`
--
CREATE TABLE `[[dbprefix]]forumpermissions` (
`pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fid` int(10) unsigned NOT NULL DEFAULT '0',
`gid` int(10) unsigned NOT NULL DEFAULT '0',
`canview` tinyint(1) NOT NULL DEFAULT '0',
`canviewthreads` tinyint(1) NOT NULL DEFAULT '0',
`canonlyviewownthreads` tinyint(1) NOT NULL DEFAULT '0',
`candlattachments` tinyint(1) NOT NULL DEFAULT '0',
`canpostthreads` tinyint(1) NOT NULL DEFAULT '0',
`canpostreplys` tinyint(1) NOT NULL DEFAULT '0',
`canonlyreplyownthreads` tinyint(1) NOT NULL DEFAULT '0',
`canpostattachments` tinyint(1) NOT NULL DEFAULT '0',
`canratethreads` tinyint(1) NOT NULL DEFAULT '0',
`caneditposts` tinyint(1) NOT NULL DEFAULT '0',
`candeleteposts` tinyint(1) NOT NULL DEFAULT '0',
`candeletethreads` tinyint(1) NOT NULL DEFAULT '0',
`caneditattachments` tinyint(1) NOT NULL DEFAULT '0',
`canviewdeletionnotice` tinyint(1) NOT NULL DEFAULT '0',
`modposts` tinyint(1) NOT NULL DEFAULT '0',
`modthreads` tinyint(1) NOT NULL DEFAULT '0',
`mod_edit_posts` tinyint(1) NOT NULL DEFAULT '0',
`modattachments` tinyint(1) NOT NULL DEFAULT '0',
`canpostpolls` tinyint(1) NOT NULL DEFAULT '0',
`canvotepolls` tinyint(1) NOT NULL DEFAULT '0',
`cansearch` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`pid`),
KEY `fid` (`fid`,`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]forums`
--
CREATE TABLE `[[dbprefix]]forums` (
`fid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(120) NOT NULL DEFAULT '',
`description` text NOT NULL,
`linkto` varchar(180) NOT NULL DEFAULT '',
`type` char(1) NOT NULL DEFAULT '',
`pid` smallint(5) unsigned NOT NULL DEFAULT '0',
`parentlist` text NOT NULL,
`disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
`active` tinyint(1) NOT NULL DEFAULT '0',
`open` tinyint(1) NOT NULL DEFAULT '0',
`threads` int(10) unsigned NOT NULL DEFAULT '0',
`posts` int(10) unsigned NOT NULL DEFAULT '0',
`lastpost` int(10) unsigned NOT NULL DEFAULT '0',
`lastposter` varchar(120) NOT NULL DEFAULT '',
`lastposteruid` int(10) unsigned NOT NULL DEFAULT '0',
`lastposttid` int(10) unsigned NOT NULL DEFAULT '0',
`lastpostsubject` varchar(120) NOT NULL DEFAULT '',
`allowhtml` tinyint(1) NOT NULL DEFAULT '0',
`allowmycode` tinyint(1) NOT NULL DEFAULT '0',
`allowsmilies` tinyint(1) NOT NULL DEFAULT '0',
`allowimgcode` tinyint(1) NOT NULL DEFAULT '0',
`allowvideocode` tinyint(1) NOT NULL DEFAULT '0',
`allowpicons` tinyint(1) NOT NULL DEFAULT '0',
`allowtratings` tinyint(1) NOT NULL DEFAULT '0',
`usepostcounts` tinyint(1) NOT NULL DEFAULT '0',
`usethreadcounts` tinyint(1) NOT NULL DEFAULT '0',
`requireprefix` tinyint(1) NOT NULL DEFAULT '0',
`password` varchar(50) NOT NULL DEFAULT '',
`showinjump` tinyint(1) NOT NULL DEFAULT '0',
`style` smallint(5) unsigned NOT NULL DEFAULT '0',
`overridestyle` tinyint(1) NOT NULL DEFAULT '0',
`rulestype` tinyint(1) NOT NULL DEFAULT '0',
`rulestitle` varchar(200) NOT NULL DEFAULT '',
`rules` text NOT NULL,
`unapprovedthreads` int(10) unsigned NOT NULL DEFAULT '0',
`unapprovedposts` int(10) unsigned NOT NULL DEFAULT '0',
`deletedthreads` int(10) unsigned NOT NULL DEFAULT '0',
`deletedposts` int(10) unsigned NOT NULL DEFAULT '0',
`defaultdatecut` smallint(4) unsigned NOT NULL DEFAULT '0',
`defaultsortby` varchar(10) NOT NULL DEFAULT '',
`defaultsortorder` varchar(4) NOT NULL DEFAULT '',
PRIMARY KEY (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]forums`
--
INSERT INTO `[[dbprefix]]forums` VALUES
(1, 'My Category', '', '', 'c', 0, '1', 1, 1, 1, 0, 0, 0, '0', 0, 0, '', 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, '', 1, 0, 0, 0, '', '', 0, 0, 0, 0, 0, '', ''),
(2, 'My Forum', '', '', 'f', 1, '1,2', 1, 1, 1, 0, 0, 0, '0', 0, 0, '', 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, '', 1, 0, 0, 0, '', '', 0, 0, 0, 0, 0, '', '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]forumsread`
--
CREATE TABLE `[[dbprefix]]forumsread` (
`fid` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `fid` (`fid`,`uid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]forumsubscriptions`
--
CREATE TABLE `[[dbprefix]]forumsubscriptions` (
`fsid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fid` smallint(5) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`fsid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]groupleaders`
--
CREATE TABLE `[[dbprefix]]groupleaders` (
`lid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`gid` smallint(5) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`canmanagemembers` tinyint(1) NOT NULL DEFAULT '0',
`canmanagerequests` tinyint(1) NOT NULL DEFAULT '0',
`caninvitemembers` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]helpdocs`
--
CREATE TABLE `[[dbprefix]]helpdocs` (
`hid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`sid` smallint(5) unsigned NOT NULL DEFAULT '0',
`name` varchar(120) NOT NULL DEFAULT '',
`description` text NOT NULL,
`document` text NOT NULL,
`usetranslation` tinyint(1) NOT NULL DEFAULT '0',
`enabled` tinyint(1) NOT NULL DEFAULT '0',
`disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `[[dbprefix]]helpdocs`
--
INSERT INTO `[[dbprefix]]helpdocs` VALUES
(1, 1, 'User Registration', 'Perks and privileges to user registration.', 'Some parts of this forum may require you to be logged in and registered. Registration is free and takes a few minutes to complete. \r\n \r\nYou are encouraged to register; once you register you will be able to post messages, set your own preferences, and maintain a profile. \r\n \r\nSome of the features that generally require registration are subscriptions, changing of styles, accessing of your Personal Pad (simple notepad) and emailing forum members.', 1, 1, 1),
(2, 1, 'Updating Profile', 'Changing your data currently on record.', 'At some point during your stay, you may decide you need to update some information such as your instant messenger information, your password, or perhaps you need to change your email address. You may change any of this information from your user control panel. To access this control panel, simply click on the link in the upper right hand corner of most any page entitled "user cp". From there, simply choose "Edit Profile" and change or update any desired items, then proceed to click the submit button located at the bottom of the page for changes to take effect.', 1, 1, 2),
(3, 1, 'Use of Cookies on myBB', 'myBB uses cookies to store certain information about your registration.', 'myBulletinBoard makes use of cookies to store your login information if you are registered, and your last visit if you are not. \r\n \r\nCookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. \r\n \r\nCookies on this forum also track the specific topics you have read and when you last read them. \r\n \r\nTo clear all cookies set by this forum, you can click here.', 1, 1, 3),
(4, 1, 'Logging In and Out', 'How to login and log out.', 'When you login, you set a cookie on your machine so that you can browse the forums without having to enter in your username and password each time. Logging out clears that cookie to ensure nobody else can browse the forum as you. \r\n \r\nTo login, simply click the login link at the top right hand corner of the forum. To log out, click the log out link in the same place. In the event you cannot log out, clearing cookies on your machine will take the same effect.', 1, 1, 4),
(5, 2, 'Posting a New Topic', 'Starting a new thread in a forum.', 'When you go to a forum you are interested in and you wish to create a new topic (or thread), simply choose the button at the top and bottom of the forums entitled "New topic". Please take note that you may not have permission to post a new topic in every forum as your administrator may have restricted posting in that forum to staff or archived the forum entirely.', 1, 1, 1),
(6, 2, 'Posting a Reply', 'Replying to a topic within a forum.', 'During the course of your visit, you may encounter a thread to which you would like to make a reply. To do so, simply click the "Post reply" button at the bottom or top of the thread. Please take note that your administrator may have restricted posting to certain individuals in that particular forum. \r\n \r\nAdditionally, a moderator of a forum may have closed a thread meaning that users cannot reply to it. There is no way for a user to open such a thread without the help of a moderator or administrator.', 1, 1, 2),
(7, 2, 'MyCode', 'Learn how to use MyCode to enhance your posts.', 'You can use MyCode, a simplified version of HTML, in your posts to create certain effects.\r\n
\r\n[b]This text is bold[/b] \r\n This text is bold\r\n
\r\n[i]This text is italicized[/i] \r\n This text is italicized\r\n
\r\n[u]This text is underlined[/u] \r\n This text is underlined\r\n
You can make an ordered list by using [list=1] for a numbered, and [list=a] for an alphabetical list.', 1, 1, 3);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]helpsections`
--
CREATE TABLE `[[dbprefix]]helpsections` (
`sid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(120) NOT NULL DEFAULT '',
`description` text NOT NULL,
`usetranslation` tinyint(1) NOT NULL DEFAULT '0',
`enabled` tinyint(1) NOT NULL DEFAULT '0',
`disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]helpsections`
--
INSERT INTO `[[dbprefix]]helpsections` VALUES
(1, 'User Maintenance', 'Basic instructions for maintaining a forum account.', 1, 1, 1),
(2, 'Posting', 'Posting, replying, and basic usage of forum.', 1, 1, 2);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]icons`
--
CREATE TABLE `[[dbprefix]]icons` (
`iid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(120) NOT NULL DEFAULT '',
`path` varchar(220) NOT NULL DEFAULT '',
PRIMARY KEY (`iid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
--
-- Dumping data for table `[[dbprefix]]icons`
--
INSERT INTO `[[dbprefix]]icons` VALUES
(1, 'Bug', 'images/icons/bug.png'),
(2, 'Exclamation', 'images/icons/exclamation.png'),
(3, 'Question', 'images/icons/question.png'),
(4, 'Smile', 'images/icons/smile.png'),
(5, 'Sad', 'images/icons/sad.png'),
(6, 'Wink', 'images/icons/wink.png'),
(7, 'Big Grin', 'images/icons/biggrin.png'),
(8, 'Tongue', 'images/icons/tongue.png'),
(9, 'Brick', 'images/icons/brick.png'),
(10, 'Heart', 'images/icons/heart.png'),
(11, 'Information', 'images/icons/information.png'),
(12, 'Lightbulb', 'images/icons/lightbulb.png'),
(13, 'Music', 'images/icons/music.png'),
(14, 'Photo', 'images/icons/photo.png'),
(15, 'Rainbow', 'images/icons/rainbow.png'),
(16, 'Shocked', 'images/icons/shocked.png'),
(17, 'Star', 'images/icons/star.png'),
(18, 'Thumbs Down', 'images/icons/thumbsdown.png'),
(19, 'Thumbs Up', 'images/icons/thumbsup.png'),
(20, 'Video', 'images/icons/video.png');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]joinrequests`
--
CREATE TABLE `[[dbprefix]]joinrequests` (
`rid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`gid` smallint(5) unsigned NOT NULL DEFAULT '0',
`reason` varchar(250) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`invite` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]mailerrors`
--
CREATE TABLE `[[dbprefix]]mailerrors` (
`eid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`subject` varchar(200) NOT NULL DEFAULT '',
`message` text NOT NULL,
`toaddress` varchar(150) NOT NULL DEFAULT '',
`fromaddress` varchar(150) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`error` text NOT NULL,
`smtperror` varchar(200) NOT NULL DEFAULT '',
`smtpcode` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`eid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]maillogs`
--
CREATE TABLE `[[dbprefix]]maillogs` (
`mid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`subject` varchar(200) NOT NULL DEFAULT '',
`message` text NOT NULL,
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`fromuid` int(10) unsigned NOT NULL DEFAULT '0',
`fromemail` varchar(200) NOT NULL DEFAULT '',
`touid` int(10) unsigned NOT NULL DEFAULT '0',
`toemail` varchar(200) NOT NULL DEFAULT '',
`tid` int(10) unsigned NOT NULL DEFAULT '0',
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
`type` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]mailqueue`
--
CREATE TABLE `[[dbprefix]]mailqueue` (
`mid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mailto` varchar(200) NOT NULL,
`mailfrom` varchar(200) NOT NULL,
`subject` varchar(200) NOT NULL,
`message` text NOT NULL,
`headers` text NOT NULL,
PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]massemails`
--
CREATE TABLE `[[dbprefix]]massemails` (
`mid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`subject` varchar(200) NOT NULL DEFAULT '',
`message` text NOT NULL,
`htmlmessage` text NOT NULL,
`type` tinyint(1) NOT NULL DEFAULT '0',
`format` tinyint(1) NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`senddate` int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`sentcount` int(10) unsigned NOT NULL DEFAULT '0',
`totalcount` int(10) unsigned NOT NULL DEFAULT '0',
`conditions` text NOT NULL,
`perpage` smallint(4) unsigned NOT NULL DEFAULT '50',
PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]moderatorlog`
--
CREATE TABLE `[[dbprefix]]moderatorlog` (
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`fid` smallint(5) unsigned NOT NULL DEFAULT '0',
`tid` int(10) unsigned NOT NULL DEFAULT '0',
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`action` text NOT NULL,
`data` text NOT NULL,
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
KEY `uid` (`uid`),
KEY `fid` (`fid`),
KEY `tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]moderators`
--
CREATE TABLE `[[dbprefix]]moderators` (
`mid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`fid` smallint(5) unsigned NOT NULL DEFAULT '0',
`id` int(10) unsigned NOT NULL DEFAULT '0',
`isgroup` tinyint(1) unsigned NOT NULL DEFAULT '0',
`caneditposts` tinyint(1) NOT NULL DEFAULT '0',
`cansoftdeleteposts` tinyint(1) NOT NULL DEFAULT '0',
`canrestoreposts` tinyint(1) NOT NULL DEFAULT '0',
`candeleteposts` tinyint(1) NOT NULL DEFAULT '0',
`cansoftdeletethreads` tinyint(1) NOT NULL DEFAULT '0',
`canrestorethreads` tinyint(1) NOT NULL DEFAULT '0',
`candeletethreads` tinyint(1) NOT NULL DEFAULT '0',
`canviewips` tinyint(1) NOT NULL DEFAULT '0',
`canviewunapprove` tinyint(1) NOT NULL DEFAULT '0',
`canviewdeleted` tinyint(1) NOT NULL DEFAULT '0',
`canopenclosethreads` tinyint(1) NOT NULL DEFAULT '0',
`canstickunstickthreads` tinyint(1) NOT NULL DEFAULT '0',
`canapproveunapprovethreads` tinyint(1) NOT NULL DEFAULT '0',
`canapproveunapproveposts` tinyint(1) NOT NULL DEFAULT '0',
`canapproveunapproveattachs` tinyint(1) NOT NULL DEFAULT '0',
`canmanagethreads` tinyint(1) NOT NULL DEFAULT '0',
`canmanagepolls` tinyint(1) NOT NULL DEFAULT '0',
`canpostclosedthreads` tinyint(1) NOT NULL DEFAULT '0',
`canmovetononmodforum` tinyint(1) NOT NULL DEFAULT '0',
`canusecustomtools` tinyint(1) NOT NULL DEFAULT '0',
`canmanageannouncements` tinyint(1) NOT NULL DEFAULT '0',
`canmanagereportedposts` tinyint(1) NOT NULL DEFAULT '0',
`canviewmodlog` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`mid`),
KEY `uid` (`id`,`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]modtools`
--
CREATE TABLE `[[dbprefix]]modtools` (
`tid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`description` text NOT NULL,
`forums` text NOT NULL,
`groups` text NOT NULL,
`type` char(1) NOT NULL DEFAULT '',
`postoptions` text NOT NULL,
`threadoptions` text NOT NULL,
PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]mycode`
--
CREATE TABLE `[[dbprefix]]mycode` (
`cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL DEFAULT '',
`description` text NOT NULL,
`regex` text NOT NULL,
`replacement` text NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '0',
`parseorder` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]polls`
--
CREATE TABLE `[[dbprefix]]polls` (
`pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tid` int(10) unsigned NOT NULL DEFAULT '0',
`question` varchar(200) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`options` text NOT NULL,
`votes` text NOT NULL,
`numoptions` smallint(5) unsigned NOT NULL DEFAULT '0',
`numvotes` int(10) unsigned NOT NULL DEFAULT '0',
`timeout` int(10) unsigned NOT NULL DEFAULT '0',
`closed` tinyint(1) NOT NULL DEFAULT '0',
`multiple` tinyint(1) NOT NULL DEFAULT '0',
`public` tinyint(1) NOT NULL DEFAULT '0',
`maxoptions` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`pid`),
KEY `tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]pollvotes`
--
CREATE TABLE `[[dbprefix]]pollvotes` (
`vid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`voteoption` smallint(5) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
PRIMARY KEY (`vid`),
KEY `pid` (`pid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]posts`
--
CREATE TABLE `[[dbprefix]]posts` (
`pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tid` int(10) unsigned NOT NULL DEFAULT '0',
`replyto` int(10) unsigned NOT NULL DEFAULT '0',
`fid` smallint(5) unsigned NOT NULL DEFAULT '0',
`subject` varchar(120) NOT NULL DEFAULT '',
`icon` smallint(5) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`username` varchar(80) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`message` text NOT NULL,
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
`includesig` tinyint(1) NOT NULL DEFAULT '0',
`smilieoff` tinyint(1) NOT NULL DEFAULT '0',
`edituid` int(10) unsigned NOT NULL DEFAULT '0',
`edittime` int(10) unsigned NOT NULL DEFAULT '0',
`editreason` varchar(150) NOT NULL DEFAULT '',
`visible` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`pid`),
KEY `tid` (`tid`,`uid`),
KEY `uid` (`uid`),
KEY `visible` (`visible`),
KEY `dateline` (`dateline`),
KEY `ipaddress` (`ipaddress`),
KEY `tiddate` (`tid`,`dateline`),
FULLTEXT KEY `message` (`message`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]privatemessages`
--
CREATE TABLE `[[dbprefix]]privatemessages` (
`pmid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`toid` int(10) unsigned NOT NULL DEFAULT '0',
`fromid` int(10) unsigned NOT NULL DEFAULT '0',
`recipients` text NOT NULL,
`folder` smallint(5) unsigned NOT NULL DEFAULT '1',
`subject` varchar(120) NOT NULL DEFAULT '',
`icon` smallint(5) unsigned NOT NULL DEFAULT '0',
`message` text NOT NULL,
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`deletetime` int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`statustime` int(10) unsigned NOT NULL DEFAULT '0',
`includesig` tinyint(1) NOT NULL DEFAULT '0',
`smilieoff` tinyint(1) NOT NULL DEFAULT '0',
`receipt` tinyint(1) NOT NULL DEFAULT '0',
`readtime` int(10) unsigned NOT NULL DEFAULT '0',
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
PRIMARY KEY (`pmid`),
KEY `uid` (`uid`,`folder`),
KEY `toid` (`toid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]profilefields`
--
CREATE TABLE `[[dbprefix]]profilefields` (
`fid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`description` text NOT NULL,
`disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
`type` text NOT NULL,
`regex` text NOT NULL,
`length` smallint(5) unsigned NOT NULL DEFAULT '0',
`maxlength` smallint(5) unsigned NOT NULL DEFAULT '0',
`required` tinyint(1) NOT NULL DEFAULT '0',
`registration` tinyint(1) NOT NULL DEFAULT '0',
`profile` tinyint(1) NOT NULL DEFAULT '0',
`postbit` tinyint(1) NOT NULL DEFAULT '0',
`viewableby` text NOT NULL,
`editableby` text NOT NULL,
`postnum` smallint(5) unsigned NOT NULL DEFAULT '0',
`allowhtml` tinyint(1) NOT NULL DEFAULT '0',
`allowmycode` tinyint(1) NOT NULL DEFAULT '0',
`allowsmilies` tinyint(1) NOT NULL DEFAULT '0',
`allowimgcode` tinyint(1) NOT NULL DEFAULT '0',
`allowvideocode` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]profilefields`
--
INSERT INTO `[[dbprefix]]profilefields` VALUES
(1, 'Location', 'Where in the world do you live?', 1, 'text', '', 0, 255, 0, 0, 1, 0, '-1', '-1', 0, 0, 0, 0, 0, 0),
(2, 'Bio', 'Enter a few short details about yourself, your life story etc.', 2, 'textarea', '', 0, 0, 0, 0, 1, 0, '-1', '-1', 0, 0, 0, 0, 0, 0),
(3, 'Gender', 'Please select your gender from the list below.', 3, 'select\nUndisclosed\nMale\nFemale\nOther', '', 0, 0, 0, 0, 1, 0, '-1', '-1', 0, 0, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]promotionlogs`
--
CREATE TABLE `[[dbprefix]]promotionlogs` (
`plid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`oldusergroup` varchar(200) NOT NULL DEFAULT '0',
`newusergroup` smallint(6) NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`type` varchar(9) NOT NULL DEFAULT 'primary',
PRIMARY KEY (`plid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]promotions`
--
CREATE TABLE `[[dbprefix]]promotions` (
`pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(120) NOT NULL DEFAULT '',
`description` text NOT NULL,
`enabled` tinyint(1) NOT NULL DEFAULT '1',
`logging` tinyint(1) NOT NULL DEFAULT '0',
`posts` int(10) unsigned NOT NULL DEFAULT '0',
`posttype` char(2) NOT NULL DEFAULT '',
`threads` int(10) unsigned NOT NULL DEFAULT '0',
`threadtype` char(2) NOT NULL DEFAULT '',
`registered` int(10) unsigned NOT NULL DEFAULT '0',
`registeredtype` varchar(20) NOT NULL DEFAULT '',
`online` int(10) unsigned NOT NULL DEFAULT '0',
`onlinetype` varchar(20) NOT NULL DEFAULT '',
`reputations` int(11) NOT NULL DEFAULT '0',
`reputationtype` char(2) NOT NULL DEFAULT '',
`referrals` int(10) unsigned NOT NULL DEFAULT '0',
`referralstype` char(2) NOT NULL DEFAULT '',
`warnings` int(10) unsigned NOT NULL DEFAULT '0',
`warningstype` char(2) NOT NULL DEFAULT '',
`requirements` varchar(200) NOT NULL DEFAULT '',
`originalusergroup` varchar(120) NOT NULL DEFAULT '0',
`newusergroup` smallint(5) unsigned NOT NULL DEFAULT '0',
`usergrouptype` varchar(120) NOT NULL DEFAULT '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]questions`
--
CREATE TABLE `[[dbprefix]]questions` (
`qid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`question` varchar(200) NOT NULL DEFAULT '',
`answer` varchar(150) NOT NULL DEFAULT '',
`shown` int(10) unsigned NOT NULL DEFAULT '0',
`correct` int(10) unsigned NOT NULL DEFAULT '0',
`incorrect` int(10) unsigned NOT NULL DEFAULT '0',
`active` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`qid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]questions`
--
INSERT INTO `[[dbprefix]]questions` VALUES
(1, 'What does 2 + 2 equal?', '4\nFour', 0, 0, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]questionsessions`
--
CREATE TABLE `[[dbprefix]]questionsessions` (
`sid` varchar(32) NOT NULL DEFAULT '',
`qid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]reportedcontent`
--
CREATE TABLE `[[dbprefix]]reportedcontent` (
`rid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` int(10) unsigned NOT NULL DEFAULT '0',
`id2` int(10) unsigned NOT NULL DEFAULT '0',
`id3` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`reportstatus` tinyint(1) NOT NULL DEFAULT '0',
`reasonid` smallint(5) unsigned NOT NULL DEFAULT '0',
`reason` varchar(250) NOT NULL DEFAULT '',
`type` varchar(50) NOT NULL DEFAULT '',
`reports` int(10) unsigned NOT NULL DEFAULT '0',
`reporters` text NOT NULL,
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`lastreport` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`rid`),
KEY `reportstatus` (`reportstatus`),
KEY `lastreport` (`lastreport`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]reportreasons`
--
CREATE TABLE `[[dbprefix]]reportreasons` (
`rid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(250) NOT NULL DEFAULT '',
`appliesto` varchar(250) NOT NULL DEFAULT '',
`extra` tinyint(1) NOT NULL DEFAULT '0',
`disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `[[dbprefix]]reportreasons`
--
INSERT INTO `[[dbprefix]]reportreasons` VALUES
(1, '', 'all', 1, 99),
(2, '', 'all', 0, 1),
(3, '', 'all', 0, 2),
(4, '', 'all', 0, 3),
(5, '', 'post', 0, 4);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]reputation`
--
CREATE TABLE `[[dbprefix]]reputation` (
`rid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`adduid` int(10) unsigned NOT NULL DEFAULT '0',
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`reputation` smallint(6) NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`comments` text NOT NULL,
PRIMARY KEY (`rid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]searchlog`
--
CREATE TABLE `[[dbprefix]]searchlog` (
`sid` varchar(32) NOT NULL DEFAULT '',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
`threads` longtext NOT NULL,
`posts` longtext NOT NULL,
`resulttype` varchar(10) NOT NULL DEFAULT '',
`querycache` text NOT NULL,
`keywords` text NOT NULL,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]sessions`
--
CREATE TABLE `[[dbprefix]]sessions` (
`sid` varchar(32) NOT NULL DEFAULT '',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`ip` varbinary(16) NOT NULL DEFAULT '',
`time` int(10) unsigned NOT NULL DEFAULT '0',
`location` varchar(150) NOT NULL DEFAULT '',
`useragent` varchar(200) NOT NULL DEFAULT '',
`anonymous` tinyint(1) NOT NULL DEFAULT '0',
`nopermission` tinyint(1) NOT NULL DEFAULT '0',
`location1` int(10) unsigned NOT NULL DEFAULT '0',
`location2` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`sid`),
KEY `location` (`location1`,`location2`),
KEY `time` (`time`),
KEY `uid` (`uid`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]settinggroups`
--
CREATE TABLE `[[dbprefix]]settinggroups` (
`gid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`title` varchar(220) NOT NULL DEFAULT '',
`description` text NOT NULL,
`disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
`isdefault` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `[[dbprefix]]settinggroups`
--
INSERT INTO `[[dbprefix]]settinggroups` VALUES
(1, 'onlineoffline', 'Board Online / Offline', 'These settings allow you to globally turn your forums online or offline, and allow you to specify a reason for turning them off.', 1, 1),
(2, 'details', 'Site Details', 'This section contains various settings such as your board name and url, as well as your website name and url.', 2, 1),
(3, 'general', 'General Configuration', 'This section allows you to manage the general aspects of your board.', 3, 1),
(4, 'server', 'Server and Optimization Options', 'These options allow you to set various server and optimization preferences allowing you to reduce the load on your server, and gain better performance on your board.', 4, 1),
(5, 'datetime', 'Date and Time Formats', 'Here you can specify the different date and time formats used to display dates and times on the forums.', 5, 1),
(6, 'forumhome', 'Forum Home Options', 'This section allows you to manage the various settings used on the forum home (index.php) of your boards such as enabling and disabling different features.', 6, 1),
(7, 'forumdisplay', 'Forum Display Options', 'This section allows you to manage the various settings used on the forum display (forumdisplay.php) of your boards such as enabling and disabling different features.', 7, 1),
(8, 'showthread', 'Show Thread Options', 'This section allows you to manage the various settings used on the thread display page (showthread.php) of your boards such as enabling and disabling different features.', 8, 1),
(9, 'member', 'Login and Registration Options', 'Here you can control various settings with relation to user account registration and login management.', 9, 1),
(10, 'profile', 'Profile Options', 'The options here control the various settings of user profiles around the forums.', 10, 1),
(11, 'posting', 'Posting', 'These options control the various elements in relation to posting messages on the forums.', 11, 1),
(12, 'attachments', 'Attachments', 'Various options related to the attachment system can be managed and set here.', 12, 1),
(13, 'memberlist', 'Member List', 'This section allows you to control various aspects of the board member listing (memberlist.php), such as how many members to show per page, and which features to enable or disable.', 13, 1),
(14, 'reputation', 'Reputation', 'The reputation system allows your users to rate others and leave a comment on the user. This section has settings to disable and change other aspects of the reputation page (reputation.php).', 14, 1),
(15, 'warning', 'Warning System Settings', 'The warning system allows forum staff to warn users for rule violations. Here you can manage the settings that control the warning system (warnings.php).', 15, 1),
(16, 'privatemessaging', 'Private Messaging', 'Various options with relation to the MyBB Private Messaging system (private.php) can be managed and set here.', 16, 1),
(17, 'calendar', 'Calendar', 'The board calendar allows the public and private listing of events and members'' birthdays. This section allows you to control and manage the settings for the Calendar (calendar.php).', 17, 1),
(18, 'whosonline', 'Who''s Online', 'Various settings regarding the Who is Online functionality (online.php).', 18, 1),
(19, 'userpruning', 'User Pruning', 'User Pruning allows you to remove users from your forum meeting certain criteria. Here you can configure that criteria.', 19, 1),
(20, 'portal', 'Portal Settings', 'The portal page compiles several different pieces of information about your forum, including latest posts, who''s online, forum stats, announcements, and more. This section has settings to control the aspects of the portal page (portal.php).', 20, 1),
(21, 'search', 'Search System', 'The various settings in this group allow you to make changes to the built in search mechanism for threads, posts and help documents in MyBB.', 21, 1),
(22, 'clickablecode', 'Clickable Smilies and BB Code', 'This section allows you to change how the clickable smilies inserter appears and control the default MyCodes.', 22, 1),
(23, 'cpprefs', 'Control Panel Preferences (Global)', 'This section allows you to set the global preferences for the Admin Control Panel.', 23, 1),
(24, 'mailsettings', 'Mail Settings', 'This section allows you to control various aspects of the MyBB mail system, such as sending with PHP mail or with a off server SMTP server.', 24, 1),
(25, 'contactsettings', 'Contact Settings', 'The various options to change the behaviour of the contact page (contact.php).', 25, 1),
(26, 'purgespammer', 'Purge Spammer', 'This section allows you to change the settings of the Purge Spammer feature.', 26, 1),
(27, 'stopforumspam', 'Stop Forum Spam', 'This section allows you to change the settings used for the integration with StopForumSpam.com', 27, 1),
(28, 'contactdetails', 'Contact Details', 'This section allows you to change the settings of the contact fields feature.', 28, 1),
(29, 'statspage', 'Statistics Page', 'This section allows you to change the settings of the statistics page.', 28, 1),
(30, 'forumteam', 'Forum Team', 'This section allows you to control various aspects of the forum team listing (showteam.php), such as aspects to consider while listing team members, and which features to enable or disable.', 29, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]settings`
--
CREATE TABLE `[[dbprefix]]settings` (
`sid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(120) NOT NULL DEFAULT '',
`title` varchar(120) NOT NULL DEFAULT '',
`description` text NOT NULL,
`optionscode` text NOT NULL,
`value` text NOT NULL,
`disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
`gid` smallint(5) unsigned NOT NULL DEFAULT '0',
`isdefault` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`sid`),
KEY `gid` (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=299 ;
--
-- Dumping data for table `[[dbprefix]]settings`
--
INSERT INTO `[[dbprefix]]settings` VALUES
(1, 'boardclosed', 'Board Closed', 'If you need to close your forums to make some changes or perform an upgrade, this is the global switch. Viewers will not be able to view your forums, however, they will see a message with the reason you specify below. Administrators will still be able to view the forums.', 'yesno', '0', 1, 1, 1),
(2, 'boardclosed_reason', 'Board Closed Reason', 'If your forum is closed, you can set a message here that your visitors will be able to see when they visit your forums. You can leave this empty to use the language files.', 'textarea', 'These forums are currently closed for maintenance. Please check back later.', 2, 1, 1),
(3, 'bbname', 'Board Name', 'The name of your community. We recommend that it is not over 75 characters.', 'text', '[[bbname]]', 1, 2, 1),
(4, 'bburl', 'Board URL', 'The url to your forums. Include the http://. Do NOT include a trailing slash.', 'text', '[[softurl]]', 2, 2, 1),
(5, 'homename', 'Homepage Name', 'The name of your homepage. This will appear in the footer with a link to it.', 'text', '[[site_name]]', 3, 2, 1),
(6, 'homeurl', 'Homepage URL', 'The full URL of your homepage. This will be linked to in the footer along with its name.', 'text', '[[protocol]]://[[domhost]]/', 4, 2, 1),
(7, 'adminemail', 'Admin Email', 'The administrator''s email address. This will be used for outgoing emails sent via the forums.', 'text', '[[board_email]]', 5, 2, 1),
(8, 'returnemail', 'Return Email', 'The email address for incoming replies to outgoing emails sent via the forums and is useful for no-reply accounts. Leave blank to use the admin email address instead.', 'text', '', 6, 2, 1),
(9, 'contactemail', 'Contact Email', 'The email address that messages sent via the contact form (contact.php) will be sent to. Leave blank to use the admin email address instead.', 'text', '', 7, 2, 1),
(10, 'contactlink', 'Contact Us Link', 'This will be used for the Contact Us link on the bottom of all the forum pages. Can either be an email address (using mailto:email@website.com) or a hyperlink.', 'text', 'contact.php', 8, 2, 1),
(11, 'cookiedomain', 'Cookie Domain', 'The domain which cookies should be set to. This can remain blank. It should also start with a . so it covers all subdomains.', 'text', '.[[domhost]]', 9, 2, 1),
(12, 'cookiepath', 'Cookie Path', 'The path which cookies are set to. We recommend setting this to the full directory path to your forums with a trailing slash.', 'text', '[[relativeurl]]/', 10, 2, 1),
(13, 'cookieprefix', 'Cookie Prefix', 'A prefix to append to all cookies set by MyBB. This is useful if you wish to install multiple copies of MyBB on the one domain or have other software installed which conflicts with the names of the cookies in MyBB. If not specified, no prefix will be used.', 'text', '', 11, 2, 1),
(14, 'cookiesamesiteflag', 'SameSite Cookie Flag', 'Authentication cookies will carry the SameSite flag to prevent CSRF attacks. Keep this disabled if you expect cross-origin POST requests.', 'yesno', '1', 12, 2, 1),
(15, 'cookiesecureflag', 'Secure Cookie Flag', 'Cookies can be set with the Secure flag to prevent them from being sent over unencrypted connections. You should enable this setting only if your forum works correctly under HTTPS.', 'yesno', '0', 13, 2, 1),
(16, 'showvernum', 'Show Version Numbers', 'Allows you to turn off the public display of version numbers in MyBB.', 'onoff', '0', 14, 2, 1),
(17, 'mailingaddress', 'Mailing Address', 'If you have a mailing address, enter it here. This is shown on the COPPA compliance form.', 'textarea', '', 15, 2, 1),
(18, 'faxno', 'Contact Fax No', 'If you have a fax number, enter it here. This is shown on the COPPA compliance form.', 'text', '', 16, 2, 1),
(19, 'bblanguage', 'Default Language', 'The default language that MyBB should use for guests and for users without a selected language in their user control panel.', 'language', '[[language]]', 1, 3, 1),
(20, 'captchaimage', 'CAPTCHA Images for Registration & Posting', 'To help prevent automated registrations and postings, you can choose a type of image verification for the user to complete. Please see the MyBB Docs for more information on CAPTCHAs.', 'select\n0=No CAPTCHA\n1=MyBB Default CAPTCHA\n4=NoCAPTCHA reCAPTCHA\n5=reCAPTCHA invisible\n6=hCaptcha\n7=hCaptcha invisible\n8=reCAPTCHA v3', '1', 2, 3, 1),
(21, 'recaptchapublickey', 'reCAPTCHA Public Key', 'Your reCAPTCHA public key.', 'text', '', 3, 3, 1),
(22, 'recaptchaprivatekey', 'reCAPTCHA Private Key', 'Your reCAPTCHA private key.', 'text', '', 4, 3, 1),
(23, 'recaptchascore', 'reCAPTCHA v3 Score', 'Set the user rejection score for reCAPTCHA v3. 1.0 is very likely a genuine user, 0.0 is very likely a bot', 'numeric\nmin=0\nmax=1\nstep=0.01', '0.5', 5, 3, 1),
(24, 'hcaptchapublickey', 'hCaptcha Public Key', 'Your hCaptcha public key.', 'text', '', 6, 3, 1),
(25, 'hcaptchaprivatekey', 'hCaptcha Private Key', 'Your hCaptcha private key.', 'text', '', 7, 3, 1),
(26, 'hcaptchatheme', 'hCaptcha Theme', 'Set the color of the hCaptcha Widget.', 'select\nlight=Light\ndark=Dark', 'light', 8, 3, 1),
(27, 'hcaptchasize', 'hCaptcha Size', 'Set the size of the hCaptcha Widget.', 'select\nnormal=Normal\ncompact=Compact', 'normal', 9, 3, 1),
(28, 'reportmethod', 'Reported Content Notification Method', 'Please select from the list how you would like moderators to be notified when content is reported. Note: Moderators are only notified for posts in forums they moderate or all content if they are a super moderator.', 'radio\ndb=Shown in the Mod CP only\npms=Sent as Private Messages and shown in the Mod CP\nemail=Sent via Email and shown in the Mod CP', 'db', 10, 3, 1),
(29, 'decpoint', 'Decimal Point', 'The decimal point you use in your region.', 'text', '.', 11, 3, 1),
(30, 'thousandssep', 'Thousands Numeric Separator', 'The punctuation you want to use. For example, a setting of '','' with the number 1200 will give you 1,200.', 'text', ',', 12, 3, 1),
(31, 'showlanguageselect', 'Show Language Selector in Footer', 'Set to No if you do not want to show the language selection area in the footer of all pages in the board. If you only have one language installed this setting will be ignored.', 'yesno', '1', 13, 3, 1),
(32, 'showthemeselect', 'Show Theme Selector in Footer', 'Set to No if you do not want to show the theme selection area in the footer of all pages in the board.', 'yesno', '1', 14, 3, 1),
(33, 'maxmultipagelinks', 'Maximum Page Links in Pagination', 'Here you can set the number of next and previous page links to show in the pagination for threads or forums with more than one page of results. Set to 0 to disable the limitation.', 'numeric\nmin=0', '5', 15, 3, 1),
(34, 'jumptopagemultipage', 'Show Jump To Page form in Pagination', 'Do you want to show a "jump to page" form in pagination if number of pages exceeds "Maximum Page Links in Pagination"?', 'yesno', '1', 16, 3, 1),
(35, 'no_plugins', 'Disable All Plugins', 'Setting this to Yes will disable all plugins without deactivating or uninstalling them. This is equivalent of manually defining NO_PLUGINS at the top of ./inc/init.php.', 'yesno', '0', 17, 3, 1),
(36, 'deleteinvites', 'Expire Old Group Invites', 'The number of days until any pending invites to user groups expire. Set to 0 to disable.', 'numeric\nmin=0', '180', 18, 3, 1),
(37, 'redirects', 'Friendly Redirection Pages', 'This will enable friendly redirection pages instead of bumping the user directly to the page.', 'onoff', '1', 19, 3, 1),
(38, 'enableforumjump', 'Enable Forum Jump Menu?', 'The forum jump menu is shown on the forum and thread view pages. It can add significant load to your forums if you have a large amount of forums. Set to ''No'' to disable it.', 'yesno', '1', 20, 3, 1),
(39, 'seourls', 'Enable search engine friendly URLs?', 'Search engine friendly URLs change the MyBB links to shorter URLs which search engines prefer and are easier to type. showthread.php?tid=1 becomes thread-1.html. Once this setting is enabled you need to make sure you have the MyBB .htaccess in your MyBB root directory (or the equivalent for your web server). Automatic detection may not work on all servers. Please see the MyBB Docs for assistance.', 'select\nauto=Automatic Detection\nyes=Enabled\nno=Disabled', 'auto', 1, 4, 1),
(40, 'seourls_archive', 'Enable search engine friendly URLs in Archive?', 'Search engine friendly URLs can be used in the archive. Once this setting is enabled ensure the archive still works as expected.', 'yesno', '0', 2, 4, 1),
(41, 'gzipoutput', 'Use GZip Page Compression?', 'Do you want to compress pages in GZip format when they are sent to the browser? This means quicker downloads for your visitors, and less traffic usage for you.', 'yesno', '0', 3, 4, 1),
(42, 'gziplevel', 'GZip Page Compression Level', 'Set the level for GZip Page Compression from 0-9. (0=no compression, 9=maximum compression). A level of 4 is recommended for most installations.', 'numeric\nmin=0\nmax=9', '4', 4, 4, 1),
(43, 'nocacheheaders', 'Send No Cache Headers', 'With this option you can enforce dynamic pages to be re-validated by browsers and not cached by proxies.', 'yesno', '1', 5, 4, 1),
(44, 'load', '*NIX Load Limiting', 'Limit the maximum server load before MyBB rejects people. 0 for none. Recommended limit is 5.0.', 'text', '0', 6, 4, 1),
(45, 'tplhtmlcomments', 'Output template start/end comments?', 'This will enable or disable the output of template start/end comments in the HTML.', 'yesno', '1', 7, 4, 1),
(46, 'use_xmlhttprequest', 'Enable XMLHttp request features?', 'This will enable or disable the XMLHttp request features.', 'yesno', '1', 8, 4, 1),
(47, 'extraadmininfo', 'Advanced Stats / Debug information', 'Shows Server load, generation time, memory usage, etc on the bottom of all pages in the root folder. Please note that only administrators see this information.', 'yesno', '1', 9, 4, 1),
(48, 'uploadspath', 'Uploads Path', 'The path used for all board uploads. It must be chmod 777 (on *nix servers). If it is a relative path then it is taken to be relative to the MyBB root directory. Default value: "./uploads" (relative path).', 'text', './uploads', 10, 4, 1),
(49, 'useerrorhandling', 'Use Error Handling', 'If you do not wish to use the integrated error handling for MyBB, you may turn this option off. However, it is recommended that it stay on.', 'onoff', '1', 11, 4, 1),
(50, 'errorlogmedium', 'Error Logging Medium', 'The type of the error handling to use.', 'select\nnone=Neither\nlog=Log errors\nemail=Email errors\nboth=Log and email errors\n', 'none', 12, 4, 1),
(51, 'errortypemedium', 'Error Type Medium', 'The type of errors to show with detailed information. It is recommended you hide errors and warnings on a production forum and log them instead.', 'select\nwarning=Warnings\nerror=Errors\nboth=Warnings and Errors\nnone=Hide Errors and Warnings\n', 'none', 13, 4, 1),
(52, 'errorloglocation', 'Error Logging Location', 'The location of the log to send errors to, if specified.', 'text', './error.log', 14, 4, 1),
(53, 'ip_forwarded_check', 'Scrutinize User''s IP address?', 'Do you want to check a user''s IP address for HTTP_X_FORWARDED_FOR or HTTP_X_REAL_IP headers? If you''re unsure, set this to No.', 'yesno', '0', 15, 4, 1),
(54, 'minifycss', 'Minify Stylesheets?', 'Do you want to minify stylesheets? Choosing Yes can save bandwidth and overall provide faster page loads.', 'yesno', '0', 16, 4, 1),
(55, 'usecdn', 'Use a CDN?', 'You can utilise a CDN (Content Delivery Network) to offload the loading of static files such as Stylesheets, JavaScript and Images. Do you wish to enable this functionality?', 'yesno', '0', 17, 4, 1),
(56, 'cdnurl', 'URL to use for static files', 'If you have enabled the CDN option above, please enter the base URL to serve static content from. This should be a valid URL without a trailing slash.', 'text', '', 18, 4, 1),
(57, 'cdnpath', 'Path to store static files', 'If you have enabled the CDN option above, please optionally enter a full path to store static files. This is only useful for "Push" type CDNs or local sub-domain setups. This path should not have a trailing slash.', 'text', '', 19, 4, 1),
(58, 'dateformat', 'Date Format', 'The format of the dates used on the forum. This format uses the PHP date() function. We recommend not changing this unless you know what you''re doing.', 'text', 'm-d-Y', 1, 5, 1),
(59, 'timeformat', 'Time Format', 'The format of the times used on the forum. This format uses PHP''s date() function. We recommend not changing this unless you know what you''re doing.', 'text', 'h:i A', 2, 5, 1),
(60, 'datetimesep', 'Date/Time Separator', 'Where MyBB joins date and time formats this setting is used to separate them (typically a space or comma).', 'text', ', ', 3, 5, 1),
(61, 'regdateformat', 'Registered Date Format', 'The format used on showthread where it shows when the user registered.', 'text', 'M Y', 4, 5, 1),
(62, 'timezoneoffset', 'Default Timezone Offset', 'Here you can set the default timezone offset for guests and members using the default offset.', 'php\n', '0', 5, 5, 1),
(63, 'dstcorrection', 'Day Light Savings Time', 'If times are an hour out above and your timezone is selected correctly, enable day light savings time correction.', 'yesno', '0', 6, 5, 1),
(64, 'showdescriptions', 'Show Forum Descriptions?', 'This option will allow you to turn off showing the descriptions for forums.', 'yesno', '1', 1, 6, 1),
(65, 'subforumsindex', 'Subforums to show on Index listing', 'The number of subforums that you wish to show inside forums on the index and forumdisplay pages. Set to 0 to not show the subforum list', 'numeric\nmin=0', '2', 2, 6, 1),
(66, 'subforumsstatusicons', 'Show Subforum Status Icons?', 'Show icons indicating whether or not a subforum contains new posts or not? This won''t have any effect unless you enabled subforums display on the index.', 'yesno', '1', 3, 6, 1),
(67, 'hideprivateforums', 'Hide Private Forums?', 'You can hide private forums by turning this option on. This option also hides forums on the forum jump and all subforums.', 'yesno', '1', 4, 6, 1),
(68, 'modlist', 'Forums'' Moderator Listing', 'Here you can turn on or off the listing of moderators for each forum on index.php and forumdisplay.php', 'onoff', '1', 5, 6, 1),
(69, 'showbirthdays', 'Show Today''s Birthdays?', 'Do you want to show today''s birthdays on the forum homepage?', 'yesno', '1', 6, 6, 1),
(70, 'showbirthdayspostlimit', 'Only Show Birthdays with x Posts', 'You can choose to only display users with at least the following amount of posts. A setting of 0 will show all users who have a birthday today.', 'numeric\nmin=0', '0', 7, 6, 1),
(71, 'showwol', 'Show Who''s Online?', 'Display the currently active users on the forum home page.', 'yesno', '1', 8, 6, 1),
(72, 'showindexstats', 'Show Small Stats Section', 'Do you want to show the total number of threads, posts, members, and the last member on the forum home?', 'yesno', '1', 9, 6, 1),
(73, 'showforumviewing', 'Show x viewing forum', 'Displays the currently active users viewing each forum.', 'yesno', '0', 10, 6, 1),
(74, 'threadsperpage', 'Threads Per Page', 'The number of threads to display per page on the forum display.', 'numeric\nmin=1', '20', 1, 7, 1),
(75, 'hottopic', 'Replies For Hot Topic', 'The number of replies that is needed for a topic to be considered ''hot''.', 'numeric\nmin=0', '20', 2, 7, 1),
(76, 'hottopicviews', 'Views For Hot Topic', 'The number of views a thread can have before it is considered ''hot''.', 'numeric\nmin=0', '150', 3, 7, 1),
(77, 'usertppoptions', 'User Selectable Threads Per Page', 'If you would like to allow users to select how many threads per page are shown in a forum, enter the options they should be able to select separated with commas. If this is left blank they will not be able to choose how many threads are shown per page.', 'text', '10,15,20,25,30,40,50', 4, 7, 1),
(78, 'dotfolders', 'Use ''dot'' Icons', 'Do you want to show dots on the thread indicators of threads users have participated in.', 'yesno', '1', 5, 7, 1),
(79, 'allowthreadratings', 'Use Thread Ratings?', 'Allow users to rate threads?', 'yesno', '1', 6, 7, 1),
(80, 'browsingthisforum', 'Users Browsing this Forum', 'Here you can turn off the ''users browsing this forum'' feature.', 'onoff', '1', 7, 7, 1),
(81, 'announcementlimit', 'Announcements Limit', 'The number of forum announcements to show in the thread listing on the forum display pages. Set to 0 to disable announcements altogether.', 'numeric\nmin=0', '2', 8, 7, 1),
(82, 'readparentforums', 'Attempt to Mark Parent Forums as Read', 'When set to Yes, this setting will attempt to mark the parent forums of a sub-forum as read if there are no more unread posts. Please note that this setting can lead to a decrease in performance and multiple database queries and therefore must be treated as experimental. See the MyBB Docs for more information regarding this change.', 'yesno', '0', 9, 7, 1),
(83, 'postlayout', 'Post Layout', 'Allows you to switch between the classic and new horizontal layout modes. Classic mode shows the author information to the left of the post, horizontal shows the author information above the post.', 'radio\nhorizontal=Display posts using the horizontal post layout\nclassic=Display posts using the classic layout', 'horizontal', 1, 8, 1),
(84, 'postsperpage', 'Posts Per Page:', 'The number of posts to display per page. We recommend its not higher than 20 for people with slower connections.', 'numeric\nmin=0', '10', 2, 8, 1),
(85, 'userpppoptions', 'User Selectable Posts Per Page', 'If you would like to allow users to select how many posts are shown per page in a thread, enter the options they should be able to select separated with commas. If this is left blank they will not be able to choose how many posts are shown per page.', 'text', '5,10,15,20,25,30,40,50', 3, 8, 1),
(86, 'postmaxavatarsize', 'Maximum Avatar Dimensions in Posts', 'The maximum dimensions for avatars when being displayed in a post (width and height separated by ''x'' or ''|'') . If an avatar is too large, it will automatically be scaled down.', 'text', '55x55', 4, 8, 1),
(87, 'threadreadcut', 'Read Threads in Database (Days)', 'The number of days that you wish to keep thread read information in the database. For large boards, we do not recommend a high number as the board will become slower. Set to 0 to disable.', 'numeric\nmin=0', '7', 5, 8, 1),
(88, 'threadusenetstyle', 'Usenet Style Thread View', 'Selecting Yes will cause posts to look similar to how posts look in USENET. No will cause posts to look the modern way.', 'yesno', '0', 6, 8, 1),
(89, 'quickreply', 'Show Quick Reply Form', 'Allows you to set whether or not the quick reply form will be shown at the bottom of threads.', 'onoff', '1', 7, 8, 1),
(90, 'multiquote', 'Show Multi-quote Buttons', 'The multi-quote button allows users to select a series of posts then click Reply and have those posts quoted in their message.', 'onoff', '1', 8, 8, 1),
(91, 'showsimilarthreads', 'Show ''Similar Threads'' Table', 'The Similar Threads table shows threads that are relevant to the thread being read. You can set the relevancy below.', 'yesno', '0', 9, 8, 1),
(92, 'similarityrating', 'Similar Threads Relevancy Rating', 'This allows you to limit similar threads to ones more relevant (0 being not relevant). This number should not be over 10 and should not be set low (<5) for large forums. Does not apply to PgSQL databases.', 'numeric\nmin=0', '1', 10, 8, 1),
(93, 'similarlimit', 'Similar Threads Limit', 'Here you can change the total amount of similar threads to be shown in the similar threads table. It is recommended that it is not over 15 for 56k users.', 'numeric\nmin=0', '10', 11, 8, 1),
(94, 'showforumpagesbreadcrumb', 'Show Forum Multipage Dropdown', 'If the forum has more than 1 page of threads, do you want to display a dropdown pagination menu in the breadcrumbs?', 'yesno', '1', 12, 8, 1),
(95, 'browsingthisthread', 'Users Browsing this Thread', 'Here you can turn off the ''users browsing this thread'' feature.', 'yesno', '1', 13, 8, 1),
(96, 'delayedthreadviews', 'Delayed Thread View Updates', 'If this setting is enabled, the number of thread views for threads will be updated in the background by the task schedule system. If not enabled, thread view counters are incremented instantly.', 'onoff', '0', 14, 8, 1),
(97, 'threadviews_countspiders', 'Increment Thread View Count on Spider Visits?', 'Here you can include views by spiders in the thread view counter.', 'yesno', '0', 15, 8, 1),
(98, 'threadviews_countguests', 'Increment Thread View Count on Guest Visits?', 'Here you can include views by guests in the thread view counter.', 'yesno', '1', 16, 8, 1),
(99, 'threadviews_countthreadauthor', 'Increment Thread View Count on Thread Author Visits?', 'Here you can include views by the thread author in the thread view counter.', 'yesno', '1', 17, 8, 1),
(100, 'disableregs', 'Disable Registrations', 'Allows you to turn off the capability for users to register with one click.', 'yesno', '0', 1, 9, 1),
(101, 'regtype', 'Registration Method', 'Please select the method of registration to use when users register.', 'select\ninstant=Instant Activation\nverify=Send Email Verification\nrandompass=Send Random Password\nadmin=Administrator Activation\nboth=Email Verification & Administrator Activation', 'verify', 2, 9, 1),
(102, 'awactialert', 'Awaiting Activation Notification', 'Do you want to show a notification to administrators about accounts awaiting activation?', 'yesno', '1', 3, 9, 1),
(103, 'forcelogin', 'Force Users to Login', 'Setting this to Yes will force guests to login or register in order to access the board.', 'yesno', '0', 4, 9, 1),
(104, 'minnamelength', 'Minimum Username Length', 'The minimum number of characters a username can be when a user registers.', 'numeric\nmin=1', '3', 5, 9, 1),
(105, 'maxnamelength', 'Maximum Username Length', 'The maximum number of characters a username can be when a user registers.', 'numeric\nmin=1', '30', 6, 9, 1),
(106, 'minpasswordlength', 'Minimum Password Length', 'The minimum number of characters a password should contain.', 'numeric\nmin=1', '6', 7, 9, 1),
(107, 'maxpasswordlength', 'Maximum Password Length', 'The maximum number of characters a password should contain.', 'numeric\nmin=1', '30', 8, 9, 1),
(108, 'requirecomplexpasswords', 'Require a complex password?', 'Do you want users to use complex passwords? Complex passwords require an upper case letter, lower case letter and a number.', 'yesno', '0', 9, 9, 1),
(109, 'betweenregstime', 'Time Between Registrations', 'The amount of time (in hours) to disallow registrations for users who have already registered an account under the same IP address. Set to 0 to disable.', 'numeric\nmin=0', '24', 10, 9, 1),
(110, 'maxregsbetweentime', 'Maximum Registrations Per IP Address', 'This option allows you to set the maximum amount of times a certain user can register within the timeframe specified above.', 'numeric\nmin=0', '2', 11, 9, 1),
(111, 'allowmultipleemails', 'Allow emails to be registered multiple times?', 'Select Yes if you wish to allow users to sign up with the same email more than once otherwise select No.', 'yesno', '0', 12, 9, 1),
(112, 'emailkeep', 'Users Keep Email', 'If a current user has an email already registered in your banned list, should they be allowed to keep it?', 'yesno', '0', 13, 9, 1),
(113, 'hiddencaptchaimage', 'Display a hidden CAPTCHA', 'Do you want to display a hidden CAPTCHA field when a user registers? This may prevent spambots from registering on your forum.', 'yesno', '0', 14, 9, 1),
(114, 'hiddencaptchaimagefield', 'Hidden CAPTCHA field', 'You can choose a name for your hidden CAPTCHA field below.', 'text', 'email3', 15, 9, 1),
(115, 'usereferrals', 'Use Referrals System', 'Do you want to use the user referrals system on these forums?', 'yesno', '1', 16, 9, 1),
(116, 'referralsperpage', 'Referrals Per Page', 'The number of members to show per page on the referral list.', 'numeric', '20', 17, 9, 1),
(117, 'coppa', 'COPPA Compliance', 'If you wish to enable COPPA support on your forums, please select the registration allowance below.', 'select\nenabled=Enabled\ndeny=Deny users under the age of 13\ndisabled=Disable this feature', 'disabled', 18, 9, 1),
(118, 'username_method', 'Allowed Login Methods', 'The login methods you wish to allow for the username field. Username only, Email only, or allow both.\n To allow email as a valid login method, no users are allowed to share email addresses.', 'select\n0=Username Only\n1=Email Only\n2=Both Username and Email', '0', 19, 9, 1),
(119, 'failedcaptchalogincount', 'Number of failed logins before verification required', 'The number of times to allow someone to attempt to login before required to enter a CAPTCHA verification. Set to 0 to disable', 'numeric\nmin=0', '3', 20, 9, 1),
(120, 'failedlogincount', 'Number of times to allow failed logins', 'The number of times to allow someone to attempt to login. Set to 0 to disable.', 'numeric\nmin=0', '10', 21, 9, 1),
(121, 'failedlogintime', 'Time between failed logins', 'The amount of time (in minutes) before someone can try to login again, after they have failed to login the first time. Used if value above is not 0.', 'numeric\nmin=0', '15', 22, 9, 1),
(122, 'failedlogintext', 'Display number of failed logins', 'Do you wish to display a line of text telling the user how many more login attempts they have?', 'yesno', '1', 23, 9, 1),
(123, 'regtime', 'Minimum Registration Time', 'The minimum time in seconds a user must take to fill out the registration form. Used to prevent automated bot signups. Setting this to 0 to disables the function.', 'numeric\nmin=0', '15', 24, 9, 1),
(124, 'securityquestion', 'Show Security Question', 'Do you wish to show a question that users must answer when registering?', 'yesno', '1', 25, 9, 1),
(125, 'sigmycode', 'Allow MyCode in Signatures', 'Do you want to allow MyCode to be used in users'' signatures?', 'yesno', '1', 1, 10, 1),
(126, 'sigcountmycode', 'MyCode affects signature length', 'Do you want MyCode to be counted as part of the limit when users use MyCode in their signature?', 'yesno', '1', 2, 10, 1),
(127, 'sigsmilies', 'Allow Smilies in Signatures', 'Do you want to allow smilies to be used in users'' signatures?', 'yesno', '1', 3, 10, 1),
(128, 'sightml', 'Allow HTML in Signatures', 'Do you want to allow HTML to be used in users'' signatures?', 'yesno', '0', 4, 10, 1),
(129, 'sigimgcode', 'Allow [img] Code in Signatures', 'Do you want to allow [img] code to be used in users'' signatures?', 'yesno', '1', 5, 10, 1),
(130, 'maxsigimages', 'Maximum Number of Images per Signature', 'Enter the maximum number of images (including smilies) a user can put in their signature. Set to 0 to disable images in signatures altogether.', 'numeric\nmin=0', '2', 6, 10, 1),
(131, 'siglength', 'Length limit in Signatures', 'The maximum number of characters a user can place in a signature. Set to 0 to disable the limitation.', 'numeric\nmin=0', '255', 7, 10, 1),
(132, 'hidesignatures', 'Hide Signatures To Groups', 'Select the usergroups you wish to hide signatures from.', 'groupselect', '', 8, 10, 1),
(133, 'hidewebsite', 'Hide Websites To Groups', 'Select the usergroups you wish to hide websites from.', 'groupselect', '', 9, 10, 1),
(134, 'useravatar', 'Default User Avatar', 'If the user does not set a custom avatar this image will be used instead. If you want to use a different image for different themes, please use {theme} to represent the image directory of each theme.', 'text', 'images/default_avatar.png', 10, 10, 1),
(135, 'useravatardims', 'Default Avatar Dimensions', 'The dimensions of the default avatar; width and height separated by ''x'' or ''|'' (e.g. 40|40 or 40x40).', 'text', '100|100', 11, 10, 1),
(136, 'useravatarrating', 'Gravatar Rating', 'Allows you to set the maximum rating for Gravatars if a user chooses to use one. If a user avatar is higher than this rating a default avatar will be used. The ratings are:\n\n
\n
G: suitable for display on all websites with any audience type
\n
PG: may contain rude gestures, provocatively dressed individuals, the lesser swear words or mild violence
\n
R: may contain such things as harsh profanity, intense violence, nudity or hard drug use
\n
X: may contain hardcore sexual imagery or extremely disturbing violence
\n
', 'select\ng=G\npg=PG\nr=R\nx=X', 'g', 12, 10, 1),
(137, 'maxavatardims', 'Maximum Avatar Dimensions', 'The maximum dimensions that an avatar can be, width and height separated by ''x'' or ''|''. If this is left blank then there will be no dimension restriction.', 'text', '100x100', 13, 10, 1),
(138, 'avatarsize', 'Max Uploaded Avatar Size', 'Maximum file size (in kilobytes) of uploaded avatars. Set to 0 to disable the limitation.', 'numeric\nmin=0', '25', 14, 10, 1),
(139, 'avatarresizing', 'Avatar Resizing Mode', 'If you wish to automatically resize all large avatars, provide users the option of resizing their avatar, or not resize avatars at all you can change this setting.', 'select\nauto=Automatically resize large avatars\nuser=Give users the choice of resizing large avatars\ndisabled=Disable this feature', 'auto', 15, 10, 1),
(140, 'avataruploadpath', 'Avatar Upload Path', 'This is the path where custom avatars will be uploaded to. This directory must be chmod 777 (writable) for uploads to work.', 'text', './uploads/avatars', 16, 10, 1),
(141, 'allowremoteavatars', 'Allow Remote Avatars', 'Whether to allow the usage of avatars from remote servers. Having this enabled can expose your server''s IP address.', 'yesno', '1', 17, 10, 1),
(142, 'customtitlemaxlength', 'Custom User Title Maximum Length', 'Maximum length a user can enter for the custom user title. Cannot be over 250 characters.', 'numeric\nmin=1\nmax=250', '40', 18, 10, 1),
(143, 'allowaway', 'Allow Away Statuses?', 'Should users be allowed to set their status to ''Away'' with a custom reason & return date?', 'yesno', '1', 19, 10, 1),
(144, 'allowbuddyonly', 'Allow Buddy-Only Messaging?', 'Allow users to send private messages only to people on their buddy list?', 'yesno', '0', 20, 10, 1),
(145, 'minmessagelength', 'Minimum Message Length', 'The minimum number of characters to post.', 'numeric\nmin=1', '5', 1, 11, 1),
(146, 'maxmessagelength', 'Maximum Message Length', 'The maximum number of characters (bytes) to allow in a message. Set 0 to allow maximum length permitted as per your database.\n Tip: MySQL users (max: 65535) can change message field type manually from TEXT to MEDIUMTEXT (16777215) or LONGTEXT (4294967295) to obtain enhanced limit.', 'numeric\nmin=0', '65535', 2, 11, 1),
(147, 'mycodemessagelength', 'MyCode Affects Minimum Message Length?', 'Do you want MyCode to be counted as part of the minimum limit when users use MyCode in messages?', 'yesno', '1', 3, 11, 1),
(148, 'postfloodcheck', 'Post Flood Checking', 'Set to on if you want to enable flood checking for posts. Specify the time between posts below.', 'onoff', '1', 4, 11, 1),
(149, 'postfloodsecs', 'Post Flood Time', 'Set the time (in seconds) users have to wait between posting, to be in effect; the option above must be on.', 'numeric\nmin=1', '60', 5, 11, 1),
(150, 'postmergemins', 'Post Merge Time', 'With this enabled, posts posted within x minutes by the same author right after each other, will be merged. Set the time limit (in minutes) to merge posts. Set to 0 to disable this feature. Default: 60', 'numeric\nmin=0', '60', 6, 11, 1),
(151, 'postmergefignore', 'Merge Forums to Ignore', 'Forums to exclude from the auto merge feature. Leave blank to disable.', 'forumselect', '', 7, 11, 1),
(152, 'postmergeuignore', 'Merge User Groups to Ignore', 'Select the usergroups which should be excluded from the merge feature.', 'groupselect', '4', 8, 11, 1),
(153, 'postmergesep', 'Merge Separator', 'The Separator to be used when merging two message Default: ''[hr]''', 'text', '[hr]', 9, 11, 1),
(154, 'logip', 'Show Posting IP Addresses', 'Do you wish to show ip addresses of users who post, and who you want to show ip addresses to?', 'radio\nno=Do not show IP\nhide=Show to Admins & Mods\nshow=Show to all Users', 'hide', 10, 11, 1),
(155, 'showeditedby', 'Show ''edited by'' Messages', 'Once a post is edited by a regular user, do you want to show the edited by message?', 'yesno', '1', 11, 11, 1),
(156, 'showeditedbyadmin', 'Show ''edited by'' Message for Administrators and Moderators', 'Do you want to show edited by messages for posts created by administrators and moderators?', 'yesno', '1', 12, 11, 1),
(157, 'maxpostimages', 'Maximum Images per Post', 'Enter the maximum number of images (including smilies) a user can put in their post. Set to 0 to disable this.', 'numeric\nmin=0', '10', 13, 11, 1),
(158, 'maxpostvideos', 'Maximum Videos per Post', 'Enter the maximum number of videos a user can put in their post. Set to 0 to disable this.', 'numeric\nmin=0', '1', 14, 11, 1),
(159, 'subscribeexcerpt', 'Amount of Characters for Subscription Previews', 'How many characters of the post do you want to send with the email notification of a new reply?', 'numeric\nmin=0', '100', 15, 11, 1),
(160, 'maxquotedepth', 'Maximum Nested Quote Tags', 'The maximum depth level for quote tags. When quote-replying to a post, all nested quotes which exceed this threshold are automatically removed. Note that this value is only enforced when quote-replying - it is still possible to manually enter quotes to exceed this limit, and this setting will not affect posts already submitted. Set to 0 to disable the limit.', 'numeric\nmin=0', '5', 16, 11, 1),
(161, 'polloptionlimit', 'Maximum Poll Option Length', 'The maximum length that each poll option can be. Set to 0 to disable.', 'numeric\nmin=0', '250', 17, 11, 1),
(162, 'maxpolloptions', 'Maximum Number of Poll Options', 'The maximum number of options for polls that users can post. Set to 0 to disable the limitation.', 'numeric\nmin=0', '10', 18, 11, 1),
(163, 'polltimelimit', 'Poll Time Limit', 'The number of hours until regular users cannot add a poll to their own threads (if they have the permission). Enter 0 for no limit.', 'numeric\nmin=0', '12', 19, 11, 1),
(164, 'threadreview', 'Show Thread Review', 'Show recent posts when creating a new reply?', 'yesno', '1', 20, 11, 1),
(165, 'alloweditreason', 'Allow Edit Reason', 'Do you want to allow users the ability to add an optional reason why they''ve edited their post?', 'yesno', '1', 21, 11, 1),
(166, 'soft_delete', 'Enable Soft Delete for Users', 'If enabled, posts and threads deleted by users will be hidden and can be restored by moderators. Otherwise, these posts and threads will be deleted permanently.', 'yesno', '1', 22, 11, 1),
(167, 'announcementshtml', 'Allow HTML in Announcements', 'Allow moderators to enable HTML parsing in announcements?', 'yesno', '0', 23, 11, 1),
(168, 'showownunapproved', 'Access Own Unapproved Threads / Posts', 'Allow general users to access their own unapproved threads and posts.', 'yesno', '0', 24, 11, 1),
(169, 'enableattachments', 'Enable Attachment Functionality', 'If you wish to disable attachments on your board, set this option to No.', 'yesno', '1', 1, 12, 1),
(170, 'maxattachments', 'Maximum Attachments Per Post', 'The maximum number of attachments a user is allowed to upload per post. Set to 0 to disable.', 'numeric\nmin=0', '5', 2, 12, 1),
(171, 'attachthumbnails', 'Show Attached Thumbnails in Posts', 'How do you want images to be shown in posts?', 'radio\nyes=Thumbnail\nno=Full Size Image\ndownload=As Download Link', 'yes', 3, 12, 1),
(172, 'attachthumbh', 'Attached Thumbnail Maximum Height', 'Enter the height that attached thumbnails should be generated at.', 'numeric\nmin=1', '96', 4, 12, 1),
(173, 'attachthumbw', 'Attached Thumbnail Maximum Width', 'Enter the width that attached thumbnails should be generated at.', 'numeric\nmin=1', '96', 5, 12, 1),
(174, 'enablememberlist', 'Enable Member List Functionality', 'If you wish to disable the member list on your board, set this option to No.', 'yesno', '1', 1, 13, 1),
(175, 'membersperpage', 'Members Per Page', 'The number of members to show per page on the member list.', 'numeric\nmin=1', '20', 2, 13, 1),
(176, 'default_memberlist_sortby', 'Default Sort Field', 'Select the field that you want members to be sorted by default.', 'select\nregdate=Registration Date\npostnum=Post Count\nusername=Username\nlastvisit=Last Visit', 'regdate', 3, 13, 1),
(177, 'default_memberlist_order', 'Default Sort Order', 'Select the order that you want members to be sorted by default. Ascending: A-Z / beginning-end Descending: Z-A / end-beginning', 'select\nascending=Ascending\ndescending=Descending', 'ascending', 4, 13, 1),
(178, 'memberlistmaxavatarsize', 'Maximum Display Avatar Dimensions', 'The maximum dimensions for avatars when being displayed in the member list, width & height separated by ''x'' or ''|''. If an avatar is too large, it will automatically be scaled down.', 'text', '70x70', 5, 13, 1),
(179, 'enablereputation', 'Enable Reputation Functionality', 'If you wish to disable the reputation system on your board, set this option to No.', 'yesno', '1', 1, 14, 1),
(180, 'posrep', 'Allow Positive Reputation', 'Allow users to give others positive reputation?', 'yesno', '1', 2, 14, 1),
(181, 'negrep', 'Allow Negative Reputation', 'Allow users to give others negative reputation?', 'yesno', '1', 3, 14, 1),
(182, 'neurep', 'Allow Neutral Reputation', 'Allow users to give others neutral reputation?', 'yesno', '1', 4, 14, 1),
(183, 'multirep', 'Allow Multiple Reputation', 'Can users give multiple reputations to the same user? Note: Does not effect "Post" reputation', 'yesno', '1', 5, 14, 1),
(184, 'postrep', 'Allow Post Reputations', 'Enable reputation to be linked to posts?', 'yesno', '1', 6, 14, 1),
(185, 'repsperpage', 'Reputation Comments Per Page', 'Here you can enter the number of reputation comments to show per page on the reputation system.', 'numeric\nmin=1', '15', 7, 14, 1),
(186, 'maxreplength', 'Maximum Reputation Length', 'The maximum number of characters a reputation can be.', 'numeric\nmin=1', '300', 8, 14, 1),
(187, 'minreplength', 'Minimum Reputation Length', 'The minimum number of characters a reputation can be.', 'numeric\nmin=1', '10', 9, 14, 1),
(188, 'enablewarningsystem', 'Enable Warning System?', 'Set to No to completely disable the warning system.', 'yesno', '1', 1, 15, 1),
(189, 'allowcustomwarnings', 'Allow Custom Warning Types?', 'Allow a custom reason and amount of points to be specified by those with permissions to warn users.', 'yesno', '1', 2, 15, 1),
(190, 'canviewownwarning', 'Can Users View Own Warnings?', 'Set to Yes to allow users to view recent warnings in their User CP and show their warning level to them in their profile.', 'yesno', '1', 3, 15, 1),
(191, 'allowanonwarningpms', 'Allow Anonymous Warning PMs', 'Allow moderators to send anonymous warning PMs.', 'yesno', '1', 4, 15, 1),
(192, 'maxwarningpoints', 'Maximum Warning Points', 'The maximum warning points that can be given to a user before it is considered a warning level of 100%.', 'numeric\nmin=1', '10', 5, 15, 1),
(193, 'enablepms', 'Enable Private Messaging Functionality', 'If you wish to disable the private messaging system on your board, set this option to No.', 'yesno', '1', 1, 16, 1),
(194, 'pmquickreply', 'Show Quick Reply Form', 'Allows you to set whether or not the quick reply form will be shown at the bottom of PMs.', 'yesno', '1', 2, 16, 1),
(195, 'pmsallowhtml', 'Allow HTML', 'Selecting Yes will allow HTML to be used in private messages.', 'yesno', '0', 3, 16, 1),
(196, 'pmsallowmycode', 'Allow MyCode', 'Selecting Yes will allow MyCode to be used in private messages.', 'yesno', '1', 4, 16, 1),
(197, 'pmsallowsmilies', 'Allow Smilies', 'Selecting Yes will allow Smilies to be used in private messages.', 'yesno', '1', 5, 16, 1),
(198, 'pmsallowimgcode', 'Allow [img] Code', 'Selecting Yes will allow [img] Code to be used in private messages.', 'yesno', '1', 6, 16, 1),
(199, 'pmsallowvideocode', 'Allow [video] Code', 'Selecting Yes will allow [video] Code to be used in private messages.', 'yesno', '1', 7, 16, 1),
(200, 'pmfloodsecs', 'Private Message Flood Time', 'Set the time (in seconds) users have to wait between sending messages, to be in effect. Set to 0 to disable.', 'numeric\nmin=0', '60', 8, 16, 1),
(201, 'showpmip', 'Show Private Message IP Addresses', 'Do you wish to show IP addresses of users who send private messages, and who you want to show IP addresses to?', 'radio\nno=Do not show IP\nhide=Show to Admins & Mods\nshow=Show to all Users', 'hide', 9, 16, 1),
(202, 'maxpmquotedepth', 'Maximum PM Nested Quote Tags', 'The maximum depth level for quote tags. When quote-replying to a PM, all nested quotes which exceed this threshold are automatically removed. Note that this value is only enforced when quote-replying - it is still possible to manually enter quotes to exceed this limit, and this setting will not affect PMs already sent. Set to 0 to disable the limit.', 'numeric\nmin=0', '5', 10, 16, 1),
(203, 'enablecalendar', 'Enable Calendar Functionality', 'If you wish to disable the calendar on your board, set this option to No.', 'yesno', '1', 1, 17, 1),
(204, 'wolcutoffmins', 'Cut-off Time (mins)', 'The number of minutes before a user is marked offline. Recommended: 15.', 'numeric\nmin=1', '15', 1, 18, 1),
(205, 'refreshwol', 'Refresh Who''s online page Time (mins)', 'The number of minutes before the "Who''s online" page refreshes. 0 is disabled.', 'numeric\nmin=0', '1', 2, 18, 1),
(206, 'wolorder', 'Who''s Online Order', 'List the online users by username or last activity. Note: This setting only takes effect on the portal and index pages.', 'select\nusername=Order By Username (ASC)\nactivity=Order By Last Activity (DESC)', 'username', 3, 18, 1),
(207, 'wolusersperpage', 'Users Per Page', 'The number of users displayed per page. Set to 0 to use the default.', 'numeric\nmin=0', '20', 4, 18, 1),
(208, 'woldisplayspiders', 'Who''s Online Displays Spiders?', 'Display spiders in the online list. Note: This setting only takes effect on the portal and index pages.', 'yesno', '1', 5, 18, 1),
(209, 'enablepruning', 'Enable user pruning?', 'Set to on to prune users by the specified criteria below.', 'onoff', '0', 1, 19, 1),
(210, 'enableprunebyposts', 'Prune user by post count?', 'Set to on to prune users by their number of posts.', 'onoff', '0', 2, 19, 1),
(211, 'prunepostcount', 'Post count to prune by', 'Set to prune users less then a specified number of posts.', 'numeric\nmin=0', '0', 3, 19, 1);
INSERT INTO `[[dbprefix]]settings` VALUES
(212, 'prunepostcountall', 'Count all posts?', 'If set to Yes, posts from forums which don''t increase users'' post count will also be considered while pruning.', 'yesno', '0', 4, 19, 1),
(213, 'dayspruneregistered', 'Days registered before pruning by post count', 'Set to prune users whom have been registered for at least the given amount of days.', 'numeric\nmin=0', '90', 5, 19, 1),
(214, 'pruneunactived', 'Prune unactivated users?', 'Set to on to prune users whom are unactived.', 'onoff', '0', 6, 19, 1),
(215, 'dayspruneunactivated', 'Days registered before pruning unactivated users', 'Set to prune users whom have been unactived for at least the given amount of days.', 'numeric\nmin=0', '90', 7, 19, 1),
(216, 'prunethreads', 'Prune User Posts/Threads', 'For the users that are going to be removed, do you want to remove all of their posts/threads?', 'yesno', '0', 8, 19, 1),
(217, 'portal', 'Enable Portal', 'If you wish to disable the portal on your board, set this option to No.', 'yesno', '1', 1, 20, 1),
(218, 'portal_announcementsfid', 'Forums to pull announcements from', 'Please select the forums you wish to pull the announcements from.', 'forumselect', '-1', 2, 20, 1),
(219, 'portal_numannouncements', 'Number of announcements to show', 'Please enter the number of announcements to show per page on the main page.', 'numeric\nmin=1', '10', 3, 20, 1),
(220, 'portal_showwelcome', 'Show the Welcome box', 'Do you want to show the welcome box to visitors / users.', 'yesno', '1', 4, 20, 1),
(221, 'portal_showpms', 'Show the number of PMs to users', 'Do you want to show the number of private messages the current user has in their pm system.', 'yesno', '1', 5, 20, 1),
(222, 'portal_showstats', 'Show forum statistics', 'Do you want to show the total number of posts, threads, members and the last registered member on the portal page?', 'yesno', '1', 6, 20, 1),
(223, 'portal_showwol', 'Show Who''s Online', 'Do you want to show the ''Who''s online'' information to users when they visit the portal page?', 'yesno', '1', 7, 20, 1),
(224, 'portal_showsearch', 'Show Search Box', 'Do you want to show the search box, allowing users to quickly search the forums on the portal?', 'yesno', '1', 8, 20, 1),
(225, 'portal_showdiscussions', 'Show Latest Discussions', 'Do you wish to show the current forum discussions on the portal page?', 'yesno', '1', 9, 20, 1),
(226, 'portal_showdiscussionsnum', 'Number of latest discussions to show', 'Please enter the number of current forum discussions to show on the portal page.', 'numeric\nmin=1', '10', 10, 20, 1),
(227, 'portal_excludediscussion', 'Forums to exclude latest discussions from', 'Please select the forums you wish to exclude from the current forum discussions box.', 'forumselect', '', 11, 20, 1),
(228, 'searchtype', 'Search Type', 'Please select the type of search system you wish to use. You can either chose between "Standard", or "Full Text" (depending on your database). Fulltext searching is more powerful than the standard MyBB searching and quicker too.', 'php\n', 'standard', 1, 21, 1),
(229, 'searchfloodtime', 'Search Flood Time (seconds)', 'Enter the time in seconds for the minimum allowed interval for searching. This prevents users from overloading your server by constantly performing searches. Set to 0 to disable.', 'numeric\nmin=0', '30', 2, 21, 1),
(230, 'minsearchword', 'Minimum Search Word Length', 'Enter the minimum number of characters an individual word in a search query can be. Set to 0 to disable (and accept the hard limit default of 3 for standard searching and 4 for MySQL fulltext searching). If you use MySQL fulltext searching and set this lower than the MySQL setting - MySQL will override it.', 'numeric\nmin=0', '0', 3, 21, 1),
(231, 'searchhardlimit', 'Hard Limit for Maximum Search Results', 'Enter the maximum amount of results to be processed. Set to 0 to disable. On larger boards (more than 1 million posts) this should be set to No more than 1000.', 'numeric\nmin=0', '0', 4, 21, 1),
(232, 'helpsearch', 'Enable Help Documents Search', 'If enabled it will allow users to search through the help documents.', 'yesno', '1', 5, 21, 1),
(233, 'bbcodeinserter', 'Clickable MyCode Editor', 'Set this option to On to show the clickable code buttons editor on posting pages. Switching this off will also disable the Smilies Inserter.', 'onoff', '1', 1, 22, 1),
(234, 'partialmode', 'Clickable MyCode Editor in Partial Mode', 'Editor will be in partial mode if this option is set to Yes. Several MyCodes, such as [quote] and [img], will be inserted into it as plain text tags.', 'yesno', '0', 2, 22, 1),
(235, 'smilieinserter', 'Clickable Smilies Inserter', 'Clickable smilies will appear on the posting pages if this option is set to ''on''.', 'onoff', '1', 3, 22, 1),
(236, 'smilieinsertertot', 'No. of Smilies to show', 'Enter the total number of smilies to show on the clickable smilie inserter.', 'numeric\nmin=1', '20', 4, 22, 1),
(237, 'smilieinsertercols', 'No. of Smilie Cols to Show', 'Enter the number of columns you wish to show on the clickable smilie inserter.', 'numeric\nmin=1', '4', 5, 22, 1),
(238, 'allowbasicmycode', 'Allow Basic MyCodes', 'Setting this to Yes allows users to use the basic MyCodes, such as Bold, Italic, Underline, Strike-through and HR.', 'yesno', '1', 6, 22, 1),
(239, 'allowcolormycode', 'Allow Color MyCode', 'Setting this to Yes allows users to use the Color MyCode.', 'yesno', '1', 7, 22, 1),
(240, 'allowsizemycode', 'Allow Size MyCode', 'Setting this to Yes allows users to use the Size MyCode', 'yesno', '1', 8, 22, 1),
(241, 'allowfontmycode', 'Allow Font MyCode', 'Setting this to Yes allows users to use the Font MyCode.', 'yesno', '1', 9, 22, 1),
(242, 'allowlinkmycode', 'Allow Link MyCode', 'Setting this to Yes allows users to use the URL MyCode.', 'yesno', '1', 10, 22, 1),
(243, 'allowautourl', 'Automatically Parse URLs Into Links', 'Setting this to Yes will parse URLs as links.', 'yesno', '1', 11, 22, 1),
(244, 'allowemailmycode', 'Allow Email MyCode', 'Setting this to Yes allows users to use the Email MyCode.', 'yesno', '1', 12, 22, 1),
(245, 'allowalignmycode', 'Allow Alignment MyCode', 'Setting this to Yes allows users to use the Align MyCode.', 'yesno', '1', 13, 22, 1),
(246, 'allowlistmycode', 'Allow List MyCode', 'Setting this to Yes allows users to use the List MyCode.', 'yesno', '1', 14, 22, 1),
(247, 'allowcodemycode', 'Allow Code MyCodes', 'Setting this to Yes allows users to use the Code and PHP MyCodes.', 'yesno', '1', 15, 22, 1),
(248, 'allowsymbolmycode', 'Allow Symbol MyCodes', 'Setting this to Yes allows users to use the (tm), (c) and (r) MyCodes.', 'yesno', '1', 16, 22, 1),
(249, 'allowmemycode', 'Allow Me MyCodes', 'Setting this to Yes allows users to use the /me and /slap MyCodes.', 'yesno', '1', 17, 22, 1),
(250, 'guestimages', 'Parse [img] MyCode To Guests', 'Setting this to Yes will parse posted images to guests. If No, a link will be shown instead.', 'yesno', '1', 18, 22, 1),
(251, 'guestvideos', 'Parse [video] MyCode To Guests', 'Setting this to Yes will parse posted videos to guests. If No, a link will be shown instead.', 'yesno', '1', 19, 22, 1),
(252, 'cplanguage', 'Control Panel Language', 'The language of the control panel.', 'adminlanguage', 'english', 1, 23, 1),
(253, 'cpstyle', 'Control Panel Style', 'The Default style that the control panel will use. Styles are inside the styles folder. A folder name inside that folder becomes the style title and style.css inside the style title folder is the css style file.', 'cpstyle', '', 2, 23, 1),
(254, 'maxloginattempts', 'Max Number of Login Attempts', 'The max number of attempts to login before being locked out. Set to 0 to disable.', 'numeric\nmin=0', '5', 3, 23, 1),
(255, 'loginattemptstimeout', 'Login Attempts Timeout', 'If the person trying to login reaches the max number of attempts, how long should they have to wait before being able to login again (in minutes)? Set to 0 to disable.', 'numeric\nmin=0', '15', 4, 23, 1),
(256, 'mail_handler', 'Mail handler', 'The medium through which MyBB will send outgoing emails.', 'select\nmail=PHP mail\nsmtp=SMTP mail', 'mail', 1, 24, 1),
(257, 'smtp_host', 'SMTP hostname', 'The hostname of the SMTP server through which mail should be sent. Only required if SMTP Mail is selected as the Mail Handler.', 'text', '', 2, 24, 1),
(258, 'smtp_port', 'SMTP port', 'The port number of the SMTP server through which mail should be sent. Only required if SMTP Mail is selected as the Mail Handler.', 'text', '', 3, 24, 1),
(259, 'smtp_user', 'SMTP username', 'The username used to authenticate with the SMTP server. Only required if SMTP Mail is selected as the Mail Handler, and the SMTP server requires authentication.', 'text', '', 4, 24, 1),
(260, 'smtp_pass', 'SMTP password', 'The corresponding password used to authenticate with the SMTP server. Only required if SMTP Mail is selected as the Mail Handler, and the SMTP server requires authentication.', 'passwordbox', '', 5, 24, 1),
(261, 'secure_smtp', 'SMTP Encryption Mode', 'Select the encryption required to communicate with the SMTP server. Only required if SMTP Mail is selected as the Mail Handler.', 'select\n0=No encryption\n1=SSL encryption\n2=TLS encryption', '0', 6, 24, 1),
(262, 'mail_parameters', 'Additional Parameters for PHP''s mail()', 'Not supported. Additional parameters can be set in the Configuration File instead.', 'text', '', 7, 24, 1),
(263, 'mail_logging', 'Mail Logging', 'This setting allows you to set how to log outgoing emails sent via the ''Send Thread to a Friend'' feature. In some countries it is illegal to log all content.', 'select\n0=Disable email logging\n1=Log emails without content\n2=Log everything', '2', 8, 24, 1),
(264, 'mail_message_id', 'Add message ID in mail headers', 'Disabling this option on some shared hosts resolves issues with forum emails being marked as spam.', 'yesno', '1', 9, 24, 1),
(265, 'mail_queue_limit', 'Messages to send from the mail queue', 'The number of messages to send from the mail queue every time the Send Mail Queue task is ran.', 'numeric\nmin=1', '10', 10, 24, 1),
(266, 'contact', 'Enable Contact Page', 'Setting this to Yes will allow access to the contact page.', 'yesno', '1', 1, 25, 1),
(267, 'contact_guests', 'Disable Contact Page to Guests', 'Setting this to Yes will disallow access to the contact page for guests.', 'yesno', '0', 2, 25, 1),
(268, 'contact_badwords', 'Enable Word Filter on Contact Page', 'Setting this to Yes will will send the subject and message fields through the word filter before sending.', 'yesno', '1', 3, 25, 1),
(269, 'contact_maxsubjectlength', 'Maximum Subject Length on Contact Page', 'The maximum number of characters (bytes) to allow in the subject. A setting of 0 allows an unlimited length.', 'numeric\nmin=0', '85', 4, 25, 1),
(270, 'contact_minmessagelength', 'Minimum Message Length on Contact Page', 'The minimum number of characters in order to send the message. A value of 0 disables this setting.', 'numeric\nmin=0', '5', 5, 25, 1),
(271, 'contact_maxmessagelength', 'Maximum Message Length on Contact Page', 'The maximum number of characters (bytes) to allow in the message. A setting of 0 allows an unlimited length.', 'numeric\nmin=0', '65535', 6, 25, 1),
(272, 'purgespammergroups', 'Allowed Usergroups', 'Select the usergroups which should be allowed to use Purge Spammer.', 'groupselect', '3,4,6', 1, 26, 1),
(273, 'purgespammerpostlimit', 'Post Limit', 'This setting stops this tool being used on users who have more than a certain amount of posts, to prevent it being used on active members. Setting the value to 0 will disable the post check, however this is not recommended.', 'numeric\nmin=0', '10', 2, 26, 1),
(274, 'purgespammerbandelete', 'Ban or Delete Spammers', 'Do you want to ban or delete spammers with this tool?', 'radio\nban=Ban (Permanent)\ndelete=Delete', 'ban', 3, 26, 1),
(275, 'purgespammerbangroup', 'Ban Usergroup', 'Choose the usergroup to put users into when they get purged. Defaults to the fundamental Banned usergroup.', 'groupselectsingle', '7', 4, 26, 1),
(276, 'purgespammerbanreason', 'Ban Reason', 'The reason which is used to ban the spammer.', 'text', 'Spam', 5, 26, 1),
(277, 'purgespammerapikey', 'Stop Forum Spam API Key', 'In order to be able to submit information on a spammer to the Stop Forum Spam database, you need an API key. You can get one of these here. When you have your key, paste it into the box below.', 'text', '', 6, 26, 1),
(278, 'purgespammerbanip', 'Add banned IP filter', 'Do you want to ban the spammer''s IP using this tool? If other users are issued the same banned IP, they will not be able to use the forums.', 'yesno', '1', 7, 26, 1),
(279, 'enablestopforumspam_on_register', 'Check Registrations Against StopForumSpam.com?', '\n Do you wish to check all new registrations against the StopForumSpam.com database?', 'yesno', '0', 1, 27, 1),
(280, 'stopforumspam_on_contact', 'Check Guest Contact Submissions Against StopForumSpam?', '\n Should guest email and IP addresses be checked against StopForumSpam when using the contact page?', 'yesno', '0', 2, 27, 1),
(281, 'stopforumspam_on_newreply', 'Check Guest Replies Against StopForumSpam?', '\n Should guest usernames and IP addresses be checked against StopForumSpam when creating new replies?', 'yesno', '0', 3, 27, 1),
(282, 'stopforumspam_on_newthread', 'Check Guest Threads Against StopForumSpam?', '\n Should guest usernames and IP addresses be checked against StopForumSpam when creating new threads?', 'yesno', '0', 4, 27, 1),
(283, 'stopforumspam_min_weighting_before_spam', 'Minimum stop forum spam weighting?', '\n The minimum weighting received from StopForumSpam before deciding a user is a spammer. Should be a number between 0 and 100.', 'text', '50.00', 5, 27, 1),
(284, 'stopforumspam_check_usernames', 'Check usernames?', '\n Should the user usernames be checked against the StopForumSpam database?', 'yesno', '0', 6, 27, 1),
(285, 'stopforumspam_check_emails', 'Check email addresses?', '\n Should the user email addresses be checked against the StopForumSpam database?', 'yesno', '1', 7, 27, 1),
(286, 'stopforumspam_check_ips', 'Check IP addresses?', '\n Should the user IP addresses be checked against the StopForumSpam database?', 'yesno', '1', 8, 27, 1),
(287, 'stopforumspam_block_on_error', 'Block on StopForumSpam error?', '\n If there is an error retrieving information from the StopForumSpam API, should the user be blocked?', 'yesno', '0', 9, 27, 1),
(288, 'stopforumspam_log_blocks', 'Log StopForumSpam blocks?', '\n Should every StopForumSpam block be logged?', 'yesno', '0', 10, 27, 1),
(289, 'allowicqfield', 'Allow ICQ Number Field To Usergroups', 'Select the usergroups which should be allowed to use the ICQ Number contact field.', 'groupselect', '-1', 1, 28, 1),
(290, 'allowskypefield', 'Allow Skype ID Field To Usergroups', 'Select the usergroups which should be allowed to use the Skype ID contact field.', 'groupselect', '-1', 2, 28, 1),
(291, 'allowgooglefield', 'Allow Google Hangouts ID Field To Usergroups', 'Select the usergroups which should be allowed to use the Google Hangouts ID contact field.', 'groupselect', '-1', 3, 28, 1),
(292, 'statsenabled', 'Enable Statistics Pages', 'If you wish to disable the statistics page on your board, set this option to No.', 'yesno', '1', 1, 29, 1),
(293, 'statscachetime', 'Statistics Cache Time', 'Insert the interval of time to refresh the statistics page cache (in hours). Set to 0 to disable caching.', 'numeric\nmin=0', '0', 2, 29, 1),
(294, 'statslimit', 'Stats Limit', 'The number of threads to show on the stats page for most replies and most views. Set to 0 to disable.', 'numeric\nmin=0', '15', 3, 29, 1),
(295, 'statstopreferrer', 'Show Top Referrer on Statistics Page', 'Do you want to show the top referrer on the stats.php page? This adds an additional query.', 'yesno', '1', 4, 29, 1),
(296, 'enableshowteam', 'Enable Forum Team Listing Functionality', 'If you wish to disable the forum team listing on your board, set this option to No.', 'yesno', '1', 1, 30, 1),
(297, 'showaddlgroups', 'Show Additional Groups', 'Whether the team list will populate considering additional groups as well.', 'yesno', '1', 2, 30, 1),
(298, 'showgroupleaders', 'Show Group Leaders', 'Include group leaders to show up in the team list.', 'yesno', '1', 3, 30, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]smilies`
--
CREATE TABLE `[[dbprefix]]smilies` (
`sid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(120) NOT NULL DEFAULT '',
`find` text NOT NULL,
`image` varchar(220) NOT NULL DEFAULT '',
`disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
`showclickable` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
--
-- Dumping data for table `[[dbprefix]]smilies`
--
INSERT INTO `[[dbprefix]]smilies` VALUES
(1, 'Smile', ':)', 'images/smilies/smile.png', 1, 1),
(2, 'Wink', ';)', 'images/smilies/wink.png', 2, 1),
(3, 'Cool', ':cool:', 'images/smilies/cool.png', 3, 1),
(4, 'Big Grin', ':D', 'images/smilies/biggrin.png', 4, 1),
(5, 'Tongue', ':P', 'images/smilies/tongue.png', 5, 1),
(6, 'Rolleyes', ':rolleyes:', 'images/smilies/rolleyes.png', 6, 1),
(7, 'Shy', ':shy:', 'images/smilies/shy.png', 7, 1),
(8, 'Sad', ':(', 'images/smilies/sad.png', 8, 1),
(9, 'At', ':at:', 'images/smilies/at.png', 9, 1),
(10, 'Angel', ':angel:', 'images/smilies/angel.png', 10, 1),
(11, 'Angry', ':@', 'images/smilies/angry.png', 11, 1),
(12, 'Blush', ':blush:', 'images/smilies/blush.png', 12, 1),
(13, 'Confused', ':s', 'images/smilies/confused.png', 13, 1),
(14, 'Dodgy', ':dodgy:', 'images/smilies/dodgy.png', 14, 1),
(15, 'Exclamation', ':exclamation:', 'images/smilies/exclamation.png', 15, 1),
(16, 'Heart', ':heart:', 'images/smilies/heart.png', 16, 1),
(17, 'Huh', ':huh:', 'images/smilies/huh.png', 17, 1),
(18, 'Idea', ':idea:', 'images/smilies/lightbulb.png', 18, 1),
(19, 'Sleepy', ':sleepy:', 'images/smilies/sleepy.png', 19, 1),
(20, 'Undecided', ':-/', 'images/smilies/undecided.png', 20, 1),
(21, 'Cry', ':cry:', 'images/smilies/cry.png', 21, 1),
(22, 'Sick', ':sick:', 'images/smilies/sick.png', 22, 1),
(23, 'Arrow', ':arrow:', 'images/smilies/arrow.png', 23, 1),
(24, 'My', ':my:', 'images/smilies/my.png', 24, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]spamlog`
--
CREATE TABLE `[[dbprefix]]spamlog` (
`sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(120) NOT NULL DEFAULT '',
`email` varchar(220) NOT NULL DEFAULT '',
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`data` text NOT NULL,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]spiders`
--
CREATE TABLE `[[dbprefix]]spiders` (
`sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`theme` smallint(5) unsigned NOT NULL DEFAULT '0',
`language` varchar(20) NOT NULL DEFAULT '',
`usergroup` smallint(5) unsigned NOT NULL DEFAULT '0',
`useragent` varchar(200) NOT NULL DEFAULT '',
`lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `[[dbprefix]]spiders`
--
INSERT INTO `[[dbprefix]]spiders` VALUES
(1, 'Google', 0, '', 0, 'Googlebot', 0),
(2, 'Bing', 0, '', 0, 'bingbot', 0),
(3, 'Alexa Internet', 0, '', 0, 'ia_archiver', 0),
(4, 'Ask.com', 0, '', 0, 'Teoma', 0),
(5, 'Baidu', 0, '', 0, 'Baiduspider', 0),
(6, 'Yandex', 0, '', 0, 'YandexBot', 0),
(7, 'Facebook', 0, '', 0, 'facebookexternalhit', 0),
(8, 'Twitter', 0, '', 0, 'Twitterbot', 0),
(9, 'Internet Archive', 0, '', 0, 'archive.org_bot', 0),
(10, 'Discord', 0, '', 0, 'Discordbot', 0),
(11, 'Applebot', 0, '', 0, 'Applebot', 0),
(12, 'CheckHost', 0, '', 0, 'CheckHost', 0),
(13, 'Pingdom', 0, '', 0, 'Pingdom.com_bot', 0),
(14, 'DuckDuckGo', 0, '', 0, 'DuckDuckBot', 0),
(15, 'UptimeRobot', 0, '', 0, 'UptimeRobot', 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]stats`
--
CREATE TABLE `[[dbprefix]]stats` (
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`numusers` int(10) unsigned NOT NULL DEFAULT '0',
`numthreads` int(10) unsigned NOT NULL DEFAULT '0',
`numposts` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]stats`
--
INSERT INTO `[[dbprefix]]stats` VALUES
([[timestamp]], 1, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]tasklog`
--
CREATE TABLE `[[dbprefix]]tasklog` (
`lid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`data` text NOT NULL,
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]tasks`
--
CREATE TABLE `[[dbprefix]]tasks` (
`tid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(120) NOT NULL DEFAULT '',
`description` text NOT NULL,
`file` varchar(30) NOT NULL DEFAULT '',
`minute` varchar(200) NOT NULL DEFAULT '',
`hour` varchar(200) NOT NULL DEFAULT '',
`day` varchar(100) NOT NULL DEFAULT '',
`month` varchar(30) NOT NULL DEFAULT '',
`weekday` varchar(15) NOT NULL DEFAULT '',
`nextrun` int(10) unsigned NOT NULL DEFAULT '0',
`lastrun` int(10) unsigned NOT NULL DEFAULT '0',
`enabled` tinyint(1) NOT NULL DEFAULT '1',
`logging` tinyint(1) NOT NULL DEFAULT '0',
`locked` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `[[dbprefix]]tasks`
--
INSERT INTO `[[dbprefix]]tasks` VALUES
(1, 'Hourly Cleanup', 'Cleans out old searches, captcha images, registration questions and expires redirects.', 'hourlycleanup', '0', '*', '*', '*', '*', [[timestamp]], 0, 1, 1, 0),
(2, 'Daily Cleanup', 'Cleans out old sessions and read threads.', 'dailycleanup', '0', '0', '*', '*', '*', [[timestamp_nextday]], 0, 1, 1, 0),
(3, 'Half-hourly User Cleanup', 'Automatically expires bans, warnings and posting suspension and moderation times for users.', 'usercleanup', '30,59', '*', '*', '*', '*', [[timestamp]], 0, 1, 1, 0),
(4, 'Weekly Backup', 'Automatically backups your MyBB tables to your backups directory.', 'backupdb', '0', '0', '*', '*', '0', [[timestamp_nextday]], 0, 0, 1, 0),
(5, 'Promotion System', 'Automatically runs the promotion system every 20 minutes.', 'promotions', '5,25,45', '*', '*', '*', '*', [[timestamp]], 0, 1, 1, 0),
(6, 'Thread Views', 'Automatically updates thread views every 15 minutes. This task will automatically be enabled or disabled when changing the ''Delayed Thread Views'' setting.', 'threadviews', '10,25,40,55', '*', '*', '*', '*', [[timestamp]], 0, 0, 1, 0),
(7, 'Tables Check', 'Automatically runs a table check and attempts to repair any crashed tables.', 'checktables', '0', '*', '*', '*', '*', [[timestamp]], 0, 0, 1, 0),
(8, 'Log Pruning', 'Automatically cleans up old MyBB log files (administrator, moderator, task, promotion, and mail logs.)', 'logcleanup', '21', '5', '*', '*', '*', [[timestamp_nextday]], 0, 1, 1, 0),
(9, 'Mass Mail', 'Automatically sends any queued mass mailings every 15 minutes.', 'massmail', '10,25,40,55', '*', '*', '*', '*', [[timestamp]], 0, 1, 1, 0),
(10, 'User Pruning', 'Automatically prunes users based on criteria set in the settings every day.', 'userpruning', '0', '2', '*', '*', '*', [[timestamp_nextday]], 0, 1, 1, 0),
(11, 'Delayed Moderation', 'Automatically performs delayed moderation actions every 24 hours.', 'delayedmoderation', '0', '0', '*', '*', '*', [[timestamp_nextday]], 0, 1, 1, 0),
(12, 'Version Check', 'Automatically checks for news and new versions of MyBB every day.', 'versioncheck', '0', '21', '*', '*', '3', [[timestamp]], 0, 1, 1, 0),
(13, 'Stylesheet Re-Cache', 'Re-caches all stylesheets to the filesystem, including minifying the styles.', 'recachestylesheets', '0', '0', '1', '0', '0', 1736035200, 0, 0, 1, 0),
(14, 'Send Mail Queue', 'Sends the mail queue every minute.', 'sendmailqueue', '*', '*', '*', '*', '*', [[timestamp]], 0, 1, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]templategroups`
--
CREATE TABLE `[[dbprefix]]templategroups` (
`gid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`prefix` varchar(50) NOT NULL DEFAULT '',
`title` varchar(100) NOT NULL DEFAULT '',
`isdefault` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
--
-- Dumping data for table `[[dbprefix]]templategroups`
--
INSERT INTO `[[dbprefix]]templategroups` VALUES
(1, 'calendar', '', 1),
(2, 'editpost', '', 1),
(3, 'forumbit', '', 1),
(4, 'forumjump', '', 1),
(5, 'forumdisplay', '', 1),
(6, 'index', '', 1),
(7, 'error', '', 1),
(8, 'memberlist', '', 1),
(9, 'multipage', '', 1),
(10, 'private', '', 1),
(11, 'portal', '', 1),
(12, 'postbit', '', 1),
(13, 'posticons', '', 1),
(14, 'showthread', '', 1),
(15, 'usercp', '', 1),
(16, 'online', '', 1),
(17, 'moderation', '', 1),
(18, 'nav', '', 1),
(19, 'search', '', 1),
(20, 'showteam', '', 1),
(21, 'reputation', '', 1),
(22, 'newthread', '', 1),
(23, 'newreply', '', 1),
(24, 'member', '', 1),
(25, 'warnings', '', 1),
(26, 'global', '', 1),
(27, 'header', '', 1),
(28, 'managegroup', '', 1),
(29, 'misc', '', 1),
(30, 'modcp', '', 1),
(31, 'announcement', '', 1),
(32, 'polls', '', 1),
(33, 'post', '', 1),
(34, 'printthread', '', 1),
(35, 'report', '', 1),
(36, 'smilieinsert', '', 1),
(37, 'stats', '', 1),
(38, 'xmlhttp', '', 1),
(39, 'footer', '', 1),
(40, 'video', '', 1),
(41, 'sendthread', '', 1),
(42, 'mycode', '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]templates`
--
CREATE TABLE `[[dbprefix]]templates` (
`tid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(120) NOT NULL DEFAULT '',
`template` text NOT NULL,
`sid` smallint(6) NOT NULL DEFAULT '0',
`version` varchar(20) NOT NULL DEFAULT '0',
`status` varchar(10) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`tid`),
KEY `sid` (`sid`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=975 ;
--
-- Dumping data for table `[[dbprefix]]templates`
--
INSERT INTO `[[dbprefix]]templates` VALUES
(1, 'announcement', '\n\n{$lang->forum_announcement}\n{$headerinclude}\n\n\n\n{$header}\n