# phpMyAdmin SQL Dump # version 2.5.3 # http://www.phpmyadmin.net # # Host: localhost # Generation Time: Dec 06, 2006 at 09:07 AM # Server version: 3.23.58 # PHP Version: 4.3.4 # # Database : `vbderasa2` # # -------------------------------------------------------- # # Table structure for table `access` # CREATE TABLE `access` ( `userid` int(10) unsigned NOT NULL default '0', `forumid` smallint(5) unsigned NOT NULL default '0', `accessmask` smallint(5) unsigned NOT NULL default '0', UNIQUE KEY `userid` (`userid`,`forumid`) ) TYPE=MyISAM; # # Dumping data for table `access` # # -------------------------------------------------------- # # Table structure for table `adminlog` # CREATE TABLE `adminlog` ( `adminlogid` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `dateline` int(10) unsigned NOT NULL default '0', `script` varchar(20) NOT NULL default '', `action` varchar(20) NOT NULL default '', `extrainfo` varchar(200) NOT NULL default '', `ipaddress` varchar(15) NOT NULL default '', PRIMARY KEY (`adminlogid`) ) TYPE=MyISAM AUTO_INCREMENT=37 ; # # Dumping data for table `adminlog` # INSERT INTO `adminlog` VALUES (1, 1, 1062825654, 'index.php', '', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (2, 1, 1062825663, 'options.php', '', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (3, 1, 1062825915, 'options.php', 'dooptions', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (4, 1, 1062975953, 'index.php', '', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (5, 1, 1062976272, 'user.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (6, 1, 1063144758, 'index.php', '', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (7, 1, 1063144765, 'style.php', 'modify', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (8, 1, 1063144768, 'style.php', 'styles', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (9, 1, 1063144783, 'style.php', 'dostyles', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (10, 1, 1063144857, 'style.php', 'dostyles', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (11, 1, 1063144931, 'style.php', 'dostyles', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (12, 1, 1063144949, 'forum.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (13, 1, 1063144987, 'forum.php', 'insert', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (14, 1, 1063145004, 'forum.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (15, 1, 1063145028, 'forum.php', 'insert', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (16, 1, 1065301317, 'index.php', '', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (17, 1, 1065301334, 'user.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (18, 1, 1065301368, 'profilefield.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (19, 1, 1065301378, 'usergroup.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (20, 1, 1065301419, 'user.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (21, 1, 1065301474, 'user.php', 'insert', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (22, 1, 1065301489, 'user.php', 'find', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (23, 1, 1065301568, 'thread.php', 'prune', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (24, 1, 1065301608, 'user.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (25, 1, 1065301633, 'user.php', 'insert', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (26, 1, 1065301667, 'usertitle.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (27, 1, 1065301676, 'usergroup.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (28, 1, 1065301689, 'avatar.php', 'add', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (29, 1, 1066865330, 'index.php', '', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (30, 1, 1066865345, 'forum.php', 'modify', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (31, 1, 1066865529, 'index.php', '', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (32, 1, 1066865549, 'forum.php', 'modify', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (33, 1, 1066865618, 'index.php', '', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (34, 1, 1066865635, 'adminlog.php', 'choose', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (35, 1, 1066865687, 'options.php', '', '', '193.188.97.152'); INSERT INTO `adminlog` VALUES (36, 1, 1066865902, 'index.php', '', '', '193.188.97.152'); # -------------------------------------------------------- # # Table structure for table `adminutil` # CREATE TABLE `adminutil` ( `title` varchar(10) NOT NULL default '', `text` mediumtext NOT NULL, PRIMARY KEY (`title`) ) TYPE=MyISAM; # # Dumping data for table `adminutil` # INSERT INTO `adminutil` VALUES ('ids', ''); # -------------------------------------------------------- # # Table structure for table `announcement` # CREATE TABLE `announcement` ( `announcementid` smallint(5) unsigned NOT NULL auto_increment, `title` varchar(250) NOT NULL default '', `userid` int(10) unsigned NOT NULL default '0', `startdate` int(10) unsigned NOT NULL default '0', `enddate` int(10) unsigned NOT NULL default '0', `pagetext` mediumtext NOT NULL, `forumid` smallint(6) NOT NULL default '0', PRIMARY KEY (`announcementid`), KEY `forumid` (`forumid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `announcement` # # -------------------------------------------------------- # # Table structure for table `attachment` # CREATE TABLE `attachment` ( `attachmentid` smallint(5) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `dateline` int(10) unsigned NOT NULL default '0', `filename` varchar(100) NOT NULL default '', `filedata` mediumtext NOT NULL, `visible` smallint(5) unsigned NOT NULL default '0', `counter` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`attachmentid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `attachment` # # -------------------------------------------------------- # # Table structure for table `avatar` # CREATE TABLE `avatar` ( `avatarid` smallint(5) unsigned NOT NULL auto_increment, `title` char(100) NOT NULL default '', `minimumposts` smallint(6) NOT NULL default '0', `avatarpath` char(100) NOT NULL default '', PRIMARY KEY (`avatarid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `avatar` # # -------------------------------------------------------- # # Table structure for table `bbcode` # CREATE TABLE `bbcode` ( `bbcodeid` smallint(5) unsigned NOT NULL auto_increment, `bbcodetag` varchar(200) NOT NULL default '', `bbcodereplacement` varchar(200) NOT NULL default '', `bbcodeexample` varchar(200) NOT NULL default '', `bbcodeexplanation` mediumtext NOT NULL, `twoparams` smallint(6) NOT NULL default '0', PRIMARY KEY (`bbcodeid`) ) TYPE=MyISAM AUTO_INCREMENT=10 ; # # Dumping data for table `bbcode` # INSERT INTO `bbcode` VALUES (1, 'b', '\\4', '[b]Bold[/b]', 'The [b] tag allows you to write text bold', 0); INSERT INTO `bbcode` VALUES (2, 'i', '\\4', '[i]Italics[/i]', 'The [i] tag allows you to write text in italics', 0); INSERT INTO `bbcode` VALUES (3, 'email', '\\4', '[email]support@vbulletin.com[/email]', 'The [email] tag allows you to include email addresses.', 0); INSERT INTO `bbcode` VALUES (4, 'email', '\\7', '[email=support@vbulletin.com]vBulletin Support[/email]', 'This email tag allows you to include your own text in an email field.', 1); INSERT INTO `bbcode` VALUES (5, 'size', '\\7', '[size=+1]Size 1[/size]', 'The [size] tag allows you to control the size of the font.', 1); INSERT INTO `bbcode` VALUES (6, 'quote', '
quote:
\\4
', '[quote]This is a quote[/quote]', 'The quote tag is used to denote a quote from another post', 0); INSERT INTO `bbcode` VALUES (7, 'u', '\\4', '[u]Underline[/u]', 'The [u] tag allows you to underline text.', 0); INSERT INTO `bbcode` VALUES (8, 'color', '\\7', '[color=red]Red![/color]', 'The [color] tag allows you to specify the font color.', 1); INSERT INTO `bbcode` VALUES (9, 'font', '\\7', '[font=courier]Test[/font]', 'You can change the font of your text.', 1); # -------------------------------------------------------- # # Table structure for table `calendar_events` # CREATE TABLE `calendar_events` ( `eventid` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `event` mediumtext NOT NULL, `eventdate` date NOT NULL default '0000-00-00', `public` smallint(5) unsigned NOT NULL default '0', `subject` varchar(254) NOT NULL default '', `allowsmilies` smallint(6) NOT NULL default '1', PRIMARY KEY (`eventid`), KEY `userid` (`userid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `calendar_events` # # -------------------------------------------------------- # # Table structure for table `customavatar` # CREATE TABLE `customavatar` ( `userid` int(10) unsigned NOT NULL default '0', `avatardata` mediumtext NOT NULL, `dateline` int(10) unsigned NOT NULL default '0', `filename` varchar(100) NOT NULL default '', PRIMARY KEY (`userid`) ) TYPE=MyISAM; # # Dumping data for table `customavatar` # # -------------------------------------------------------- # # Table structure for table `forum` # CREATE TABLE `forum` ( `forumid` smallint(5) unsigned NOT NULL auto_increment, `styleid` smallint(5) unsigned NOT NULL default '0', `title` char(100) NOT NULL default '', `description` char(250) NOT NULL default '', `active` smallint(6) NOT NULL default '0', `displayorder` smallint(6) NOT NULL default '0', `replycount` int(10) unsigned NOT NULL default '0', `lastpost` int(11) NOT NULL default '0', `lastposter` char(50) NOT NULL default '', `threadcount` mediumint(8) unsigned NOT NULL default '0', `allowposting` tinyint(4) NOT NULL default '0', `cancontainthreads` smallint(6) NOT NULL default '0', `daysprune` smallint(5) unsigned NOT NULL default '0', `newpostemail` char(250) NOT NULL default '', `newthreademail` char(250) NOT NULL default '', `moderatenew` smallint(6) NOT NULL default '0', `moderateattach` smallint(6) NOT NULL default '0', `allowbbcode` smallint(6) NOT NULL default '0', `allowimages` smallint(6) NOT NULL default '0', `allowhtml` smallint(6) NOT NULL default '0', `allowsmilies` smallint(6) NOT NULL default '0', `allowicons` smallint(6) NOT NULL default '0', `parentid` smallint(6) NOT NULL default '0', `parentlist` char(250) NOT NULL default '', `allowratings` smallint(6) NOT NULL default '0', `countposts` smallint(6) NOT NULL default '1', `styleoverride` smallint(5) NOT NULL default '0', PRIMARY KEY (`forumid`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; # # Dumping data for table `forum` # INSERT INTO `forum` VALUES (1, 0, 'Main Category', 'Main Category Description', 1, 1, 0, 0, '', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, -1, '1,-1', 0, 1, 0); INSERT INTO `forum` VALUES (2, 0, 'Main Forum', 'Main Forum Description', 1, 1, 0, 0, '', 0, 1, 1, 30, '', '', 0, 0, 1, 0, 0, 1, 1, 1, '2,1,-1', 1, 1, 0); INSERT INTO `forum` VALUES (3, 1, 'القسم العربي', 'وصف القسم العربي', 1, 2, 0, 0, '', 0, 1, 0, 30, '', '', 0, 0, 1, 0, 0, 1, 1, -1, '3,-1', 1, 1, 0); INSERT INTO `forum` VALUES (4, 1, 'المنتدى العام', 'وصف المنتدى العام', 1, 1, 0, 0, '', 0, 1, 1, 30, '', '', 0, 0, 1, 1, 0, 1, 1, 3, '4,3,-1', 1, 1, 0); # -------------------------------------------------------- # # Table structure for table `forumpermission` # CREATE TABLE `forumpermission` ( `forumpermissionid` smallint(5) unsigned NOT NULL auto_increment, `forumid` smallint(5) unsigned NOT NULL default '0', `usergroupid` smallint(5) unsigned NOT NULL default '0', `canview` smallint(6) NOT NULL default '0', `cansearch` smallint(6) NOT NULL default '0', `canemail` smallint(6) NOT NULL default '0', `canpostnew` smallint(6) NOT NULL default '0', `canmove` smallint(6) NOT NULL default '0', `canopenclose` smallint(6) NOT NULL default '0', `candeletethread` smallint(6) NOT NULL default '0', `canreplyown` smallint(6) NOT NULL default '0', `canreplyothers` smallint(6) NOT NULL default '0', `canviewothers` smallint(6) NOT NULL default '0', `caneditpost` smallint(6) NOT NULL default '0', `candeletepost` smallint(6) NOT NULL default '0', `canpostattachment` smallint(6) NOT NULL default '0', `canpostpoll` smallint(6) NOT NULL default '0', `canvote` smallint(6) NOT NULL default '0', `cangetattachment` smallint(6) NOT NULL default '1', PRIMARY KEY (`forumpermissionid`), KEY `ugid_fid` (`usergroupid`,`forumid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `forumpermission` # # -------------------------------------------------------- # # Table structure for table `icon` # CREATE TABLE `icon` ( `iconid` smallint(5) unsigned NOT NULL auto_increment, `title` char(100) NOT NULL default '', `iconpath` char(100) NOT NULL default '', PRIMARY KEY (`iconid`) ) TYPE=MyISAM AUTO_INCREMENT=15 ; # # Dumping data for table `icon` # INSERT INTO `icon` VALUES (1, 'Post', 'images/icons/icon1.gif'); INSERT INTO `icon` VALUES (2, 'Arrow', 'images/icons/icon2.gif'); INSERT INTO `icon` VALUES (3, 'Lightbulb', 'images/icons/icon3.gif'); INSERT INTO `icon` VALUES (4, 'Exclamation', 'images/icons/icon4.gif'); INSERT INTO `icon` VALUES (5, 'Question', 'images/icons/icon5.gif'); INSERT INTO `icon` VALUES (6, 'Cool', 'images/icons/icon6.gif'); INSERT INTO `icon` VALUES (7, 'Smile', 'images/icons/icon7.gif'); INSERT INTO `icon` VALUES (8, 'Angry', 'images/icons/icon8.gif'); INSERT INTO `icon` VALUES (9, 'Unhappy', 'images/icons/icon9.gif'); INSERT INTO `icon` VALUES (10, 'Talking', 'images/icons/icon10.gif'); INSERT INTO `icon` VALUES (11, 'Red face', 'images/icons/icon11.gif'); INSERT INTO `icon` VALUES (12, 'Wink', 'images/icons/icon12.gif'); INSERT INTO `icon` VALUES (13, 'Thumbs down', 'images/icons/icon13.gif'); INSERT INTO `icon` VALUES (14, 'Thumbs up', 'images/icons/icon14.gif'); # -------------------------------------------------------- # # Table structure for table `moderator` # CREATE TABLE `moderator` ( `moderatorid` smallint(5) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `forumid` smallint(6) NOT NULL default '0', `newthreademail` smallint(6) NOT NULL default '0', `newpostemail` smallint(6) NOT NULL default '0', `caneditposts` smallint(6) NOT NULL default '0', `candeleteposts` smallint(6) NOT NULL default '0', `canviewips` smallint(6) NOT NULL default '0', `canmanagethreads` smallint(6) NOT NULL default '0', `canopenclose` smallint(6) NOT NULL default '0', `caneditthreads` smallint(6) NOT NULL default '0', `caneditstyles` smallint(6) NOT NULL default '0', `canbanusers` smallint(6) NOT NULL default '0', `canviewprofile` smallint(6) NOT NULL default '0', `canannounce` smallint(6) NOT NULL default '0', `canmassmove` smallint(6) NOT NULL default '0', `canmassprune` smallint(6) NOT NULL default '0', `canmoderateposts` smallint(6) NOT NULL default '0', `canmoderateattachments` smallint(6) NOT NULL default '0', PRIMARY KEY (`moderatorid`), KEY `userid` (`userid`,`forumid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `moderator` # # -------------------------------------------------------- # # Table structure for table `poll` # CREATE TABLE `poll` ( `pollid` int(10) unsigned NOT NULL auto_increment, `question` varchar(100) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `options` text NOT NULL, `votes` text NOT NULL, `active` smallint(6) NOT NULL default '1', `numberoptions` smallint(5) unsigned NOT NULL default '0', `timeout` smallint(5) unsigned NOT NULL default '0', `multiple` smallint(5) unsigned NOT NULL default '0', `voters` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`pollid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `poll` # # -------------------------------------------------------- # # Table structure for table `pollvote` # CREATE TABLE `pollvote` ( `pollvoteid` int(10) unsigned NOT NULL auto_increment, `pollid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `votedate` int(10) unsigned NOT NULL default '0', `voteoption` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`pollvoteid`), KEY `userid` (`userid`,`pollid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `pollvote` # # -------------------------------------------------------- # # Table structure for table `post` # CREATE TABLE `post` ( `postid` int(10) unsigned NOT NULL auto_increment, `threadid` int(10) unsigned NOT NULL default '0', `username` varchar(50) NOT NULL default '', `userid` int(10) unsigned NOT NULL default '0', `title` varchar(100) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `attachmentid` smallint(5) unsigned NOT NULL default '0', `pagetext` mediumtext NOT NULL, `allowsmilie` smallint(6) NOT NULL default '0', `showsignature` smallint(6) NOT NULL default '0', `ipaddress` varchar(16) NOT NULL default '', `iconid` smallint(5) unsigned NOT NULL default '0', `visible` smallint(6) NOT NULL default '0', `edituserid` int(10) unsigned NOT NULL default '0', `editdate` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`postid`), KEY `iconid` (`iconid`), KEY `userid` (`userid`), KEY `threadid` (`threadid`,`userid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `post` # # -------------------------------------------------------- # # Table structure for table `privatemessage` # CREATE TABLE `privatemessage` ( `privatemessageid` int(10) unsigned NOT NULL auto_increment, `folderid` smallint(6) NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `touserid` int(10) unsigned NOT NULL default '0', `fromuserid` int(10) unsigned NOT NULL default '0', `title` varchar(250) NOT NULL default '', `message` mediumtext NOT NULL, `dateline` int(10) unsigned NOT NULL default '0', `showsignature` smallint(6) NOT NULL default '0', `iconid` smallint(5) unsigned NOT NULL default '0', `messageread` smallint(6) NOT NULL default '0', `readtime` int(10) unsigned NOT NULL default '0', `receipt` smallint(6) unsigned NOT NULL default '0', `deleteprompt` smallint(6) unsigned NOT NULL default '0', `multiplerecipients` smallint(6) unsigned NOT NULL default '0', PRIMARY KEY (`privatemessageid`), KEY `userid` (`userid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `privatemessage` # # -------------------------------------------------------- # # Table structure for table `profilefield` # CREATE TABLE `profilefield` ( `profilefieldid` smallint(5) unsigned NOT NULL auto_increment, `title` char(50) NOT NULL default '', `description` char(250) NOT NULL default '', `required` smallint(6) NOT NULL default '0', `hidden` smallint(6) NOT NULL default '0', `maxlength` smallint(6) NOT NULL default '250', `size` smallint(6) NOT NULL default '25', `displayorder` smallint(6) NOT NULL default '0', `editable` smallint(6) NOT NULL default '1', PRIMARY KEY (`profilefieldid`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; # # Dumping data for table `profilefield` # INSERT INTO `profilefield` VALUES (1, 'Biography', 'A few details about yourself', 0, 0, 250, 25, 1, 1); INSERT INTO `profilefield` VALUES (2, 'Location', 'Where you live', 0, 0, 250, 25, 2, 1); INSERT INTO `profilefield` VALUES (3, 'Interests', 'Your hobbies, etc', 0, 0, 250, 25, 3, 1); INSERT INTO `profilefield` VALUES (4, 'Occupation', 'Your job', 0, 0, 250, 25, 4, 1); # -------------------------------------------------------- # # Table structure for table `regimage` # CREATE TABLE `regimage` ( `regimagehash` char(32) NOT NULL default '', `imagestamp` char(6) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', KEY `regimagehash` (`regimagehash`,`dateline`) ) TYPE=MyISAM; # # Dumping data for table `regimage` # # -------------------------------------------------------- # # Table structure for table `replacement` # CREATE TABLE `replacement` ( `replacementid` smallint(5) unsigned NOT NULL auto_increment, `replacementsetid` smallint(6) NOT NULL default '0', `findword` text NOT NULL, `replaceword` text NOT NULL, PRIMARY KEY (`replacementid`), KEY `replacementsetid` (`replacementsetid`) ) TYPE=MyISAM AUTO_INCREMENT=45 ; # # Dumping data for table `replacement` # INSERT INTO `replacement` VALUES (1, -1, '', ''); INSERT INTO `replacement` VALUES (26, -1, '{tableinnerborderwidth}', '1'); INSERT INTO `replacement` VALUES (27, -1, '{timecolor}', '#666686'); INSERT INTO `replacement` VALUES (28, -1, '{tableouterborderwidth}', '0'); INSERT INTO `replacement` VALUES (29, -1, '', ''); INSERT INTO `replacement` VALUES (30, -1, '{contenttablewidth}', '100%'); INSERT INTO `replacement` VALUES (31, -1, '{secondaltcolor}', '#DFDFDF'); INSERT INTO `replacement` VALUES (32, -1, '{imagesfolder}', 'images'); INSERT INTO `replacement` VALUES (33, -1, '{tablewidth}', '100%'); INSERT INTO `replacement` VALUES (34, -1, '{linkcolor}', '#000020'); INSERT INTO `replacement` VALUES (35, -1, '', ''); INSERT INTO `replacement` VALUES (37, -1, '', ''); INSERT INTO `replacement` VALUES (38, -1, '{tableheadbgcolor}', '#8080A6'); INSERT INTO `replacement` VALUES (39, -1, '{textareacols_NS6}', '40'); INSERT INTO `replacement` VALUES (40, -1, '{textareacols_IE}', '70'); INSERT INTO `replacement` VALUES (41, -1, '', ''); INSERT INTO `replacement` VALUES (42, -1, '{htmldoctype}', ''); INSERT INTO `replacement` VALUES (43, -1, '{textareacols_NS4}', '50'); INSERT INTO `replacement` VALUES (44, 1, '', ''); # -------------------------------------------------------- # # Table structure for table `replacementset` # CREATE TABLE `replacementset` ( `replacementsetid` smallint(5) unsigned NOT NULL auto_increment, `title` char(250) NOT NULL default '', PRIMARY KEY (`replacementsetid`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; # # Dumping data for table `replacementset` # INSERT INTO `replacementset` VALUES (1, 'Default'); # -------------------------------------------------------- # # Table structure for table `search` # CREATE TABLE `search` ( `searchid` int(10) unsigned NOT NULL auto_increment, `query` mediumtext NOT NULL, `postids` mediumtext NOT NULL, `dateline` int(10) unsigned NOT NULL default '0', `querystring` varchar(200) NOT NULL default '', `showposts` smallint(6) NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `ipaddress` varchar(20) NOT NULL default '', PRIMARY KEY (`searchid`), KEY `querystring` (`querystring`), KEY `userid` (`userid`) ) TYPE=MyISAM AUTO_INCREMENT=16 ; # # Dumping data for table `search` # INSERT INTO `search` VALUES (14, '1=1 AND thread.lastpost>=1087207530 AND thread.open<>10', '', 1087293930, '', 0, 0, '65.54.164.119'); INSERT INTO `search` VALUES (13, '1=1 AND post.userid=\'3\'', '', 1087153496, '', 1, 0, '65.54.164.119'); INSERT INTO `search` VALUES (15, '1=1 AND thread.lastpost>=1087648885 AND thread.open<>10', '', 1087735285, '', 0, 0, '65.54.164.119'); INSERT INTO `search` VALUES (6, '1=1 AND thread.lastpost>=1086692724 AND thread.open<>10', '', 1086779124, '', 0, 0, '65.54.164.119'); INSERT INTO `search` VALUES (7, '1=1 AND post.userid=\'3\'', '', 1086785416, '', 1, 0, '65.54.164.119'); INSERT INTO `search` VALUES (8, '1=1 AND post.userid=\'1\'', '', 1086786227, '', 1, 0, '65.54.164.119'); INSERT INTO `search` VALUES (9, '1=1 AND thread.lastpost>=1086800295 AND thread.open<>10', '', 1086886695, '', 0, 0, '65.54.164.119'); INSERT INTO `search` VALUES (10, '1=1 AND post.userid=\'3\'', '', 1086895141, '', 1, 0, '65.54.164.119'); INSERT INTO `search` VALUES (11, '1=1 AND thread.lastpost>=1086960282 AND thread.open<>10', '', 1087046682, '', 0, 0, '65.54.164.119'); INSERT INTO `search` VALUES (12, '1=1 AND post.userid=\'3\'', '', 1087057864, '', 1, 0, '65.54.164.119'); # -------------------------------------------------------- # # Table structure for table `searchindex` # CREATE TABLE `searchindex` ( `wordid` int(10) unsigned NOT NULL default '0', `postid` int(10) unsigned NOT NULL default '0', `intitle` smallint(5) unsigned NOT NULL default '0', UNIQUE KEY `wordid` (`wordid`,`postid`) ) TYPE=MyISAM; # # Dumping data for table `searchindex` # # -------------------------------------------------------- # # Table structure for table `session` # CREATE TABLE `session` ( `sessionhash` char(32) NOT NULL default '', `userid` int(10) unsigned NOT NULL default '0', `host` char(50) NOT NULL default '', `useragent` char(100) NOT NULL default '', `lastactivity` int(10) unsigned NOT NULL default '0', `location` char(255) NOT NULL default '', `styleid` smallint(5) unsigned NOT NULL default '0', `althash` char(32) NOT NULL default '', PRIMARY KEY (`sessionhash`) ) TYPE=HEAP; # # Dumping data for table `session` # # -------------------------------------------------------- # # Table structure for table `setting` # CREATE TABLE `setting` ( `settingid` smallint(5) unsigned NOT NULL auto_increment, `settinggroupid` smallint(5) unsigned NOT NULL default '0', `title` varchar(100) NOT NULL default '', `varname` varchar(100) NOT NULL default '', `value` mediumtext NOT NULL, `description` mediumtext NOT NULL, `optioncode` mediumtext NOT NULL, `displayorder` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`settingid`) ) TYPE=MyISAM AUTO_INCREMENT=173 ; # # Dumping data for table `setting` # INSERT INTO `setting` VALUES (1, 1, 'Bulletin Board Active', 'bbactive', '1', 'From time to time, you may want to turn your bulletin board off to the public while you perform maintenance, update versions, etc. When you turn your BB off, visitors will receive a message that states that the bulletin board is temporarily unavailable. Administrators will still be able to see the board

\r\n

Use this as a master switch for your board. You can set options for individual user groups in the User Permissions area.', 'yesno', 1); INSERT INTO `setting` VALUES (2, 1, 'Reason for turning board off', 'bbclosedreason', 'This board is closed at the moment. Please call back later.', 'The text that is presented when the BB is closed.

\r\n

Note: you, as an administrator, will be able to see the forums as usual, even when you have turned them off to the public.', 'textarea', 2); INSERT INTO `setting` VALUES (3, 2, 'URL', 'bburl', 'http://www.derasa.com/en/forum', 'URL (with no final "/") of the BB. Do not include "/index.php" on the end! Your URL should look something like this: http://www.example.com/forum', '', 3); INSERT INTO `setting` VALUES (4, 2, 'Board Title', 'bbtitle', 'derasa.com', 'Title of board. Appears in the title of every page', '', 1); INSERT INTO `setting` VALUES (5, 2, 'Homepage Name', 'hometitle', 'derasa.com', 'Name of your homepage. Appears at the bottom of every page.', '', 2); INSERT INTO `setting` VALUES (6, 2, 'URL of homepage', 'homeurl', 'http://www.derasa.com/', 'URL of your home page. Appears at the bottom of every page.', '', 4); INSERT INTO `setting` VALUES (7, 2, 'Copyright Text', 'copyrighttext', '', 'Copyright text to insert the footer of the page.', '', 5); INSERT INTO `setting` VALUES (8, 2, 'URL of Privacy Statement', 'privacyurl', '', 'Enter the URL of your privacy statement, if one exists.', '', 6); INSERT INTO `setting` VALUES (9, 2, 'GD Version', 'gdversion', '1', 'Version of GD installed on your server. If GD is enabled, you can find the version listed in your phpinfo().', '', 100); INSERT INTO `setting` VALUES (10, 3, 'Contact Us Link', 'contactuslink', 'mailto:info@derasa.com', 'Link for contacting the site. Can just be mailto:webmaster@whereever.com or your own form. Appears at the bottom of every page.', '', 1); INSERT INTO `setting` VALUES (11, 3, 'Webmaster\'s email', 'webmasteremail', 'info@derasa.com', 'Email address of the webmaster.', '', 2); INSERT INTO `setting` VALUES (12, 3, 'Company Name', 'companyname', '', 'The name of your company. Required for COPPA.', '', 6); INSERT INTO `setting` VALUES (13, 3, 'Address', 'address', '', 'Address of your company. This is required for COPPA forms to be posted to.', '', 5); INSERT INTO `setting` VALUES (14, 3, 'Fax Number', 'faxnumber', '', 'Enter the fax number for your company here. COPPA forms will be faxed to it.\r\n

\r\n

You may wish to check out http://www.efax.com/', '', 4); INSERT INTO `setting` VALUES (15, 4, 'Allow vB IMG code in signatures?', 'allowbbimagecode', '0', '', 'yesno', 1); INSERT INTO `setting` VALUES (16, 4, 'Allow vB code in signatures?', 'allowbbcode', '0', '', 'yesno', 2); INSERT INTO `setting` VALUES (17, 4, 'Allow smilies in signatures?', 'allowsmilies', '0', '', 'yesno', 3); INSERT INTO `setting` VALUES (18, 4, 'Allow HTML in signatures?', 'allowhtml', '0', '', 'yesno', 4); INSERT INTO `setting` VALUES (19, 4, 'Maximum images per post/signature', 'maximages', '10', 'Maximum number of images to allow in posts / signatures. Set this to 0 to have no effect.', '', 5); INSERT INTO `setting` VALUES (20, 4, 'Clickable Smilies per Row', 'smcolumns', '3', 'When a user has enabled the clickable vbcode/smilies how many smilies do you want to show per row?', '', 6); INSERT INTO `setting` VALUES (21, 4, 'Clickable Smilies Total', 'smtotal', '15', 'When a user has enabled the clickable vbcode/smilies how many smilies do you want to display on the screen before the user is prompted to click for more.', '', 7); INSERT INTO `setting` VALUES (22, 4, 'Allow Dynamic URL for [img] tags?', 'allowdynimg', '0', 'If this is set to \'no\', the [img] tag will not be displayed if the path to the image contains dynamic characters such as ? and &. This can prevent malicious use of the tag.', 'yesno', 8); INSERT INTO `setting` VALUES (23, 4, 'Allow vBcode Buttons & Clickable Smilies?', 'allowvbcodebuttons', '1', 'This global switch allows you to completely disable vBcode buttons and clickable smilies.', 'yesno', 9); INSERT INTO `setting` VALUES (24, 5, 'Show Locked forums?', 'showlocks', '1', 'Do you wish to have the new post indicators shown on the index page (on.gif and off.gif) be shown with locks to guests & other members who have no access to post?', 'yesno', 6); INSERT INTO `setting` VALUES (25, 5, 'Depth of Forums', 'forumhomedepth', '2', 'Depth to show forums on home page. Do not go too large on this value for performance reasons.', '', 7); INSERT INTO `setting` VALUES (26, 5, 'Hide private forum', 'hideprivateforums', '1', 'Select \'yes\' here to hide private forums from users who are not allowed to access them. Users who do have permission to access them will have to log in before they can see these forums too. This option applies to the forum home page, and the Jump To... box.', 'yesno', 5); INSERT INTO `setting` VALUES (27, 5, 'Display logged in users on home page', 'displayloggedin', '1', 'Display logged in and active members on the home page? This option displays those users that have been active in the last {your cookie timeout} seconds on the home page.', 'yesno', 4); INSERT INTO `setting` VALUES (28, 5, 'Show forum descriptions on the homepage.', 'showforumdescription', '1', '', 'yesno', 0); INSERT INTO `setting` VALUES (29, 5, 'Show today\'s birthdays on the homepage?', 'showbirthdays', '0', '', 'yesno', 1); INSERT INTO `setting` VALUES (30, 5, 'Highlight Admin', 'highlightadmin', '1', 'Enabling this will show Admin names in Bold and Italics and Moderators\' names in Bold on the logged in users and Who\'s Online.', 'yesno', 4); INSERT INTO `setting` VALUES (31, 6, 'Display email addresses', 'displayemails', '0', 'Allow public viewing of email addresses.', 'yesno', 1); INSERT INTO `setting` VALUES (32, 6, 'Use email form?', 'secureemail', '0', 'If "display email addresses" is set to yes, then how should then email address be displayed? If this is set to yes, then an online form must be filled in to send a user an email, thus hiding the destination email address. If secureemail is set to no, then the user is just given the email address.', 'yesno', 2); INSERT INTO `setting` VALUES (33, 6, 'Allow signatures', 'allowsignatures', '0', 'Allow registered users to have signatures. Don\'t forget to update these templates: newtopic newreply editpost modifyprofile register', 'yesno', 3); INSERT INTO `setting` VALUES (34, 6, 'Notify about new members', 'newuseremail', '', 'Email address to receive email when a new user signs up. Leave blank for no email.', '', 4); INSERT INTO `setting` VALUES (35, 6, 'Require unique email addresses', 'requireuniqueemail', '1', 'The default option is to require unique email addresses for each registered user. This means that no two users can have the same email address. You can disable this requirement by checking the "Unique Email Not Required" box.', 'yesno', 5); INSERT INTO `setting` VALUES (36, 6, 'Illegal user names', 'illegalusernames', '', 'Enter names in here that you do not want people to register. If any of the names here are included within the username, the user will told that there is an error. Separate names by spaces.', '', 6); INSERT INTO `setting` VALUES (37, 6, 'Allow new user registrations', 'allowregistration', '0', 'If you would like to temporarily (or permanently) prevent anyone new from registering, you can do so. The REGISTER button will still be seen throughout the BB, but anyone attempting to register will be told that you are not accepting new registrations at this time.', 'yesno', 7); INSERT INTO `setting` VALUES (38, 6, 'Allow multiple registrations per user', 'allowmultiregs', '0', 'Normally, vBulletin will stop users signing up for multiple names by checking for a cookie on the user\'s machine. If one exists, then the user may not sign up for additional names. If you wish to allow your users to sign up for multiple names, then select yes for this option, and they will not be blocked from registering additional usernames.', 'yesno', 8); INSERT INTO `setting` VALUES (39, 6, 'Verify Email address in registration', 'verifyemail', '1', 'The password is emailed to the new member after they submit their registration to confirm their identity and email address. If account is not activated, they will remain in the "users awaiting activation" usergroup.', 'yesno', 9); INSERT INTO `setting` VALUES (40, 6, 'Moderate New Members', 'moderatenewmembers', '0', 'Allows you to validate new members before they are classified as registered members and are allowed to post.', 'yesno', 10); INSERT INTO `setting` VALUES (41, 6, 'Use COPPA Registration system', 'usecoppa', '1', 'Use the COPPA registration system. This complies with the COPPA laws and requires children under the age of 13 to get parental consent before they can post. For more info about this law, see here:
\r\nhttp://www.ftc.gov/opa/1999/10/childfinal.htm', 'yesno', 11); INSERT INTO `setting` VALUES (42, 6, 'Timeout for Cookie', 'cookietimeout', '900', 'This is the time in seconds that a user must remain inactive before the unread posts are reset to read.', '', 12); INSERT INTO `setting` VALUES (43, 6, 'Allow Users To Change Styles', 'allowchangestyles', '0', 'This allows users to set their preferred style set on registration or when editing their option. Setting this to "no" disables that option and will force them to use whatever style has been specified.', 'yesno', 13); INSERT INTO `setting` VALUES (44, 6, 'Enable Access Masks?', 'enableaccess', '0', 'Access masks are a simple way to manage forum permissions, however they add additional queries on most pages. If you don\'t use it, it is recommended that you disable it.', 'yesno', 14); INSERT INTO `setting` VALUES (45, 6, 'Referrer', 'usereferrer', '0', 'Enable the referrer system? If yes than a user that visits your forum through a link that contains "referrerid=XXX" will give referral credit to the owner of the referrerid when they register (where XXX is the userid of the referrer).', 'yesno', 15); INSERT INTO `setting` VALUES (46, 6, 'Minimum Username Length', 'minuserlength', '3', 'Enter the minimum length a user can register with.', '', 15); INSERT INTO `setting` VALUES (47, 6, 'Maximum Username Length', 'maxuserlength', '15', 'Enter the maximum length a user can register with.', '', 16); INSERT INTO `setting` VALUES (48, 6, 'Allow Ignore Moderators', 'ignoremods', '0', 'Allow users to add Moderators and admins to their ignore list?', 'yesno', 17); INSERT INTO `setting` VALUES (49, 6, 'Image Verification', 'regimagecheck', '1', 'If enabled, this option will display a random image to new users at registration time. The user will have to copy the contents of the image in order to verify that an automated system is not processing registrations. Requires GD to be enabled on your server.', 'yesno', 10); INSERT INTO `setting` VALUES (50, 7, 'Enable members list', 'enablememberlist', '1', 'Enable the member list addon? This allows users to view a list of registered users and (optionally) search through it. ', 'yesno', 1); INSERT INTO `setting` VALUES (51, 7, 'Allow advanced searches', 'usememberlistadvsearch', '1', 'Allow the use of the advanced search tool for the member list.', 'yesno', 2); INSERT INTO `setting` VALUES (52, 7, 'Members per page', 'memberlistperpage', '30', 'The number of records per page that will be shown by default in the members list.', '', 3); INSERT INTO `setting` VALUES (53, 7, 'Number of top posters to show', 'memberlisttopposters', '10', 'On the \'Display top x posters\' , this option allows you to specify a value for x.', '', 4); INSERT INTO `setting` VALUES (54, 7, 'Restrict Listing', 'memberAllGood', '1', 'Select Yes to hide members from appearing on the member\'s list who are Awaiting Confirmation, Awaiting Coppa, and in the Not Registered/Not Logged in usergroups.', 'yesno', 5); INSERT INTO `setting` VALUES (55, 8, 'Order of posts within a thread', 'postorder', '0', 'The standard (recommended) way to display threads is chronologically from original topic to the latest reply. You can reverse this, if you prefer, to have threads displayed in reverse, from latest post to oldest post.', 'Newest first Oldest first ', 1); INSERT INTO `setting` VALUES (56, 8, 'Maximum number of posts to display on a thread page before splitting over multiple pages', 'maxposts', '15', '', '', 2); INSERT INTO `setting` VALUES (57, 8, 'User Settable Maximum Posts per Page', 'usermaxposts', '5,10,20,30,40', 'If you would like to allow the user to set their own maximum posts per thread then give the options seperated by commas. Leave the field blank to force them to use the MAXPOSTS setting above this option.\r\n\r\nex. 10,20,30,40', '', 3); INSERT INTO `setting` VALUES (58, 8, 'Pages to show in nav bar', 'pagenavpages', '3', 'In the list of links of pages in the current thread (or current forum), this option selects how many pages either side of the current page are shown. Set this to 0 to display all pages.', '', 4); INSERT INTO `setting` VALUES (59, 8, 'Number of characters before wrapping', 'wordwrap', '50', 'If you want posts to automatically insert spaces into long words to make them wrap after a certain number of characters, set the number of characters in the box above. If you do not want this to occur, enter 0.', '', 5); INSERT INTO `setting` VALUES (60, 8, 'Maximum Characters per post', 'postmaxchars', '10000', 'The maximum number of characters that you want to allow per post. Set this to 0 to disable it.', '', 7); INSERT INTO `setting` VALUES (61, 8, 'Show default icon', 'showdeficon', '1', 'Show a default icon if a user doesn\'t choose a message icon or is unable to choose one based on forum settings? {imagesfolder}/icons/icon1.gif will be used.', 'yesno', 8); INSERT INTO `setting` VALUES (62, 8, 'Stop \'Shouting\' in titles', 'stopshouting', '1', 'Prevent your users \'shouting\' in their thread titles by changing all-uppercase titles to capitalization only on the first letters of some words. Disable this for some international boards with different character sets, as this may cause problems.', 'yesno', 9); INSERT INTO `setting` VALUES (63, 9, 'Threads per Page', 'maxthreads', '25', 'The number of threads to display on a forum page before splitting it over multiple pages.', '', 1); INSERT INTO `setting` VALUES (64, 9, 'Use \'hot\' icons', 'usehotthreads', '1', 'Hot icons indicate topics with a lot of activity. The icons are animated to show a folder on fire. ', 'yesno', 2); INSERT INTO `setting` VALUES (65, 9, 'Number of views to qualify as a hot thread', 'hotnumberviews', '150', '', '', 3); INSERT INTO `setting` VALUES (66, 9, 'Number of posts to qualify as a hot thread', 'hotnumberposts', '15', '', '', 4); INSERT INTO `setting` VALUES (67, 9, 'Use \'dot\' icons?', 'showdots', '1', 'When this feature is enabled, a logged in user will see a "dot" (or whatever graphic you choose) on the folder icons (hot folders, new folders, etc) next to the threads that they have participated in.', 'yesno', 5); INSERT INTO `setting` VALUES (68, 9, 'Link to individual pages of a multipage thread on the forum listing?', 'linktopages', '1', '', 'yesno', 6); INSERT INTO `setting` VALUES (69, 9, 'Maximum links to individual pages', 'maxmultipage', '5', 'When linking to multiple pages in the forum display, this allows you to set the cut off point on which long posts stop adding more page numbers and are replaced by \'more...\'', '', 7); INSERT INTO `setting` VALUES (70, 9, 'Showing Votes', 'showvotes', '2', 'How many votes will a thread need before the votes are displayed?', '', 8); INSERT INTO `setting` VALUES (71, 9, 'Change Votes?', 'votechange', '0', 'Allow users to change their thread rating votes?', 'yesno', 9); INSERT INTO `setting` VALUES (72, 9, 'Prefix for moved threads', 'movedthreadprefix', 'Moved: ', 'The text with which to prefix a thread that has been moved to another forum. (You may use HTML)', '', 10); INSERT INTO `setting` VALUES (73, 9, 'Prefix for Sticky threads', 'stickythreadprefix', 'Sticky: ', 'Prefix to append to the beginning of thread titles that have been set to "Sticky". These threads always appear at the top of the thread list. (You may use HTML)', '', 11); INSERT INTO `setting` VALUES (74, 9, 'Prefix for Polls', 'pollthreadprefix', 'Poll: ', 'Prefix to append to the beginning of Poll thread titles. (You may use HTML)', '', 12); INSERT INTO `setting` VALUES (75, 9, 'Use Forumjump?', 'useforumjump', '1', 'Do you want to use the Forumjump drop-down menu on your pages? If your mysql server is optimized and you still are having problems you can try disabling this option to save queries.', 'yesno', 12); INSERT INTO `setting` VALUES (76, 9, 'Depth of Forums', 'forumdisplaydepth', '2', 'Depth of forums to show on forum display when displaying subforums. Do not go too large on this value for performance reasons.', '', 13); INSERT INTO `setting` VALUES (77, 9, 'Show users browsing forums?', 'showforumusers', '1', 'Enabling this options will show the current users browsing a particular forum on forumdisplay.php while adding one query. Should not affect performance.', 'yesno', 14); INSERT INTO `setting` VALUES (78, 10, 'Enable searches?', 'enablesearches', '1', 'Allow searching for posts within the BB. This is quite a server intensive process so you may want to disable it.

\r\n

To disable searching of all forums, delete the option from the searchintro template. ', 'yesno', 1); INSERT INTO `setting` VALUES (79, 10, 'Number of posts per page', 'searchperpage', '25', 'Number of successful search items to display per page.', '', 2); INSERT INTO `setting` VALUES (80, 10, 'Floodcheck - Minimum time between searches', 'searchfloodtime', '0', 'The minimum time (in seconds) that must expire before the user can search again. Set this to 0 to disable it.', '', 3); INSERT INTO `setting` VALUES (81, 10, 'Minimum Word Length', 'minsearchlength', '4', 'Enter the minimum word length that the search engine is to index. The smaller this number is, the larger your search index, and conversely your database is going to be.', '', 4); INSERT INTO `setting` VALUES (82, 10, 'Maximum Word Length', 'maxsearchlength', '20', 'Enter the maximum word length that the search engine is to index. The larger this number is, the larger your search index, and conversely your database is going to be.', '', 5); INSERT INTO `setting` VALUES (83, 10, 'Allow Wild Cards?', 'allowwildcards', '1', 'Allow users to use a star (*) in searches to match partial words?', 'yesno', 6); INSERT INTO `setting` VALUES (84, 11, 'Enable Email features?', 'enableemail', '0', 'Enable email sending features: send to friend and email notification for posters and moderators. Don\'t forget to remove those links from the forumdisplay, newreply, newtopic, & editpost templates

You can turn off the \'Send to Friend\' feature for invidual user groups in the User Permissions area.', 'yesno', 1); INSERT INTO `setting` VALUES (85, 12, 'Time Zone Offset', 'timeoffset', '+3', 'Time (in hours) that the server is offset from GMT. Please select the most appropriate option.', '', 1); INSERT INTO `setting` VALUES (86, 12, 'Format of dates', 'dateformat', 'm-d-Y', 'Format that the date is presented in on the pages.

\r\n

See: http://www.php.net/manual/function.date.php3

\r\n

Examples:
\r\nUS Format (e.g., 04-25-98) - m-d-y
\r\nExpanded US Format (e.g., April 25th, 1998) - F jS, Y
\r\nEuropean Format (e.g., 25-04-98) - d-m-Y
\r\nExpanded European Format (e.g., 25th April 1998) - jS F Y', '', 3); INSERT INTO `setting` VALUES (87, 12, 'Format of times', 'timeformat', 'h:i A', 'Format that the time is presented in on the pages.

\r\n

See: http://www.php.net/manual/function.date.php3

\r\n

Examples:
\r\nUse AM/PM Time Format (eg, 11:15 PM) - h:i A
\r\nUser 24-Hour Format Time (eg, 23:15) - H:i', '', 4); INSERT INTO `setting` VALUES (88, 12, 'Format for registration date', 'registereddateformat', 'M Y', 'This is used to format dates shown with users\' posts. In the left hand column of a thread display, under the username and title, there is some text showing when the user registered.

\r\n

See: http://www.php.net/manual/function.date.php3', '', 5); INSERT INTO `setting` VALUES (89, 12, 'Birthday Format', 'calformat1', 'F j, Y', 'Format of date shown in profile when user gives their birthyear.', '', 6); INSERT INTO `setting` VALUES (90, 12, 'Birthday Format #2', 'calformat2', 'F j', 'Format of user\'s birthday shown on profile when the user does specify their birth year. DO NOT put in a code for the year.', '', 7); INSERT INTO `setting` VALUES (91, 13, 'Enable censor?', 'enablecensor', '0', 'You may have certain words censored on your BB. Words you choose to censor will be replaced by asterisks. All subjects and messages will be affected. \r\n', 'yesno', 1); INSERT INTO `setting` VALUES (92, 13, 'Words to censor', 'censorwords', '', 'Type all words you want censored in the field below. Do not use commas to separate words, just use spaces. For example, type "dog cat boy", rather than "dog, cat, boy." If you type "dog", all words containing the string "dog" would be censored (dogma, for instance, would appear as "***ma"). To censor more accurately, you can require that censors occur only for exact words. You can do this by placing a censor word in curly braces, as in {dog}. Signifying "dog" in the curly braces would mean that dogma would appear as dogma, but dog would appear as "***". Thus your censor list may appear as: cat {dog} {barn} barn
Do not use quotation marks and make sure you use curly braces, not parentheses, when specifying exact words.
This field can contain a maximum 250 characters.', '', 2); INSERT INTO `setting` VALUES (93, 13, 'Character to use to replace censored words:', 'censorchar', '*', '', '', 3); INSERT INTO `setting` VALUES (94, 14, 'Show the \'Edited by xxx on yyy\' when a post is edited?', 'showeditedby', '1', '', 'yesno', 1); INSERT INTO `setting` VALUES (95, 14, 'Show \'edited by\' for admins?', 'showeditedbyadmin', '1', 'If you want the [edited by xxx] message to appear when an admin edits a message, select yes here. This message will appear automatically for all moderators and other users, but using this option you can optionally turn it off.', 'yesno', 2); INSERT INTO `setting` VALUES (96, 14, 'Time to wait before starting to display \'edited by...\'', 'noeditedbytime', '2', 'Time limit (in minutes) to allow user to edit the post without the [edited by xxx] message appearing at the bottom of the post.', '', 3); INSERT INTO `setting` VALUES (97, 14, 'Time limit on editing of posts', 'edittimelimit', '10', 'Time limit (in minutes) to impose on editing of messages. After this time limit only moderators will be able edit or delete the message. 1 day is 1440 minutes. Set this to 0 if you do not want it to be active.', '', 4); INSERT INTO `setting` VALUES (98, 14, 'Time limit on editing of thread title', 'editthreadtitlelimit', '5', 'Specify the time-limit (in minutes) within which the thread-title may be edited by the thread starter.', '', 5); INSERT INTO `setting` VALUES (99, 15, 'Log IP addresses?', 'logip', '1', 'For security reasons, you may wish to display the IP number of the person posting a message. The default is OFF. You may log the IP to file only- in which case the IP number is not viewable on the bulletin board, but is logged, or you may have the IP numbers logged and displayed publicly on the bulletin board.', 'Do not log IP Display but require administrator or moderator Display publicly ', 1); INSERT INTO `setting` VALUES (100, 16, 'Enable checking for post flooding?', 'enablefloodcheck', '1', 'You may prevent your users from flooding your board with posts by activating this feature. By enabling floodcheck, you disallow users from posting within a given time span of their last post. In other words, if you set a floodcheck time span of 60 seconds, a user may not post a note within 60 seconds of his last post. Administrators and moderators are exempt from floodcheck.', 'yesno', 1); INSERT INTO `setting` VALUES (101, 16, 'Minimum time between posts', 'floodchecktime', '30', 'Set the amount of time in seconds used by flood check to prevent post flooding. Recommended: 60. Type the number of seconds only.', '', 2); INSERT INTO `setting` VALUES (102, 17, 'Enable Banning Options?', 'enablebanning', '0', 'Banning allows you to stop certain IP addresses and email addresses from registering and posting to the board. ', 'yesno', 1); INSERT INTO `setting` VALUES (103, 17, 'IPs to ban:', 'banip', '', 'IP Number Ban Lists: You may ban any IP numbers from registering and posting. Type in the complete IP number (as in 243.21.31.7), or use a partial IP number (as in 243.21.31). The BB will do matches from the beginning of each IP number that you enter. Thus, If you enter a partial IP of 243.21.31, someone attempting to register who has an IP number of 243.21.31.5 will not be able to register. Similarly, if you have an IP ban on 243.21, someone registering who has an IP of 243.21.3.44 will not be able to register. Thus, be careful when you add IPs to your ban list and be as specific as possible. As with the email ban list, put a space between each IP number. The IP Ban prevents anyone with matching IP number from registering and posting.', 'textarea', 2); INSERT INTO `setting` VALUES (104, 17, 'Email addresses to ban', 'banemail', '', 'Email Ban Lists: You may ban certain email addresses from registering on your forums. To ban a specific email, type the full email address (as in, waldo@whereiswaldo.com). To ban all email addresses from certain domains, such as hotmail, simply type the domain name (as in hotmail.com)- that will prevent anyone using a hotmail address from registering. Put a space between each banned email.', 'textarea', 3); INSERT INTO `setting` VALUES (105, 17, 'Allow user to keep banned email', 'allowkeepbannedemail', '1', 'If you ban an email address and a user already uses that address, a problem will occur. Using this option, you can specify whether the user will have to enter a new email address in their profile when they next modify their email address, or whether the user can just keep the email address which you have banned.', 'yesno', 4); INSERT INTO `setting` VALUES (106, 18, 'Text for \'on\'', 'ontext', 'ON', 'Text that means on. This is used to keep the code language independent. It is used with the vB code / HTML code On / Off settings for postings.', '', 1); INSERT INTO `setting` VALUES (107, 18, 'Text for \'off\'', 'offtext', 'OFF', 'Text that means off. This is used to keep the code language independent. It is used with the vB code / HTML code On / Off settings for postings.', '', 2); INSERT INTO `setting` VALUES (108, 19, 'Enable Private Messaging?', 'enablepms', '0', 'Enabling this will add some performance overhead on the main index and it may not be a feature you wish to have at all.', 'yesno', 1); INSERT INTO `setting` VALUES (109, 19, 'Allow vB IMG code in private messages?', 'privallowbbimagecode', '1', '', 'yesno', 2); INSERT INTO `setting` VALUES (110, 19, 'Allow vB code in private messages?', 'privallowbbcode', '1', '', 'yesno', 3); INSERT INTO `setting` VALUES (111, 19, 'Allow smilies in private messages?', 'privallowsmilies', '1', '', 'yesno', 4); INSERT INTO `setting` VALUES (112, 19, 'Allow HTML in private messages?', 'privallowhtml', '0', '', 'yesno', 5); INSERT INTO `setting` VALUES (113, 19, 'Allow message icons', 'privallowicons', '1', 'Allow the use of the standard message icons for private messages.', 'yesno', 6); INSERT INTO `setting` VALUES (114, 19, 'Maximum saved messages', 'pmquota', '70', 'Maximum number of saved messages a user can have. 0 means unlimited', '', 7); INSERT INTO `setting` VALUES (115, 19, 'Inbox name', 'inboxname', 'Inbox', 'The name of the inbox folder.', '', 8); INSERT INTO `setting` VALUES (116, 19, 'Sent Items Name', 'sentitemsname', 'Sent Items', 'The name of the Sent Items folder.', '', 9); INSERT INTO `setting` VALUES (117, 19, 'IM Support - Check for new PMs', 'checknewpm', '1', 'Selecting yes for this option will cause the system to check the PM database every time a user loads a page, and will display a visible prompt for it.', 'yesno', 10); INSERT INTO `setting` VALUES (118, 19, 'Floodcheck - Minimum time between messages', 'pmfloodtime', '60', 'Private Message Flood Checking. Select the minimum time that must pass before a user can send another private message. This is to prevent a single user \'spamming\' by sending lots of messages very quickly. Set this to 0 to disable the option.', '', 11); INSERT INTO `setting` VALUES (119, 19, 'Maximum characters per private message', 'pmmaxchars', '1000', 'Maximum characters to allow in a private message. Set this to 0 for no limit.', '', 12); INSERT INTO `setting` VALUES (120, 19, 'Word to denote cancelled message', 'pmcancelledword', 'Cancelled:', 'This is the word that will prefix the title of \'cancelled\' messages in the message tracking section. (You may use HTML)', '', 13); INSERT INTO `setting` VALUES (121, 19, 'Delete \'cancelled\' messages?', 'pmcancelkill', '0', 'When users \'cancel\' messages in the message tracking area, would you like to remove the message completely? WARNING: Selecting \'yes\' could confuse users who have been notified by email about the message.', 'yesno', 17); INSERT INTO `setting` VALUES (122, 20, 'Add Standard headers', 'addheaders', '0', 'This option does not work with some combinations of web server, so is off by default. However, some IIS setups may need it turned on.

\r\n\r\n

It will send the 200 OK HTTP headers if turned on.', 'yesno', 1); INSERT INTO `setting` VALUES (123, 20, 'Add No-cache headers', 'nocacheheaders', '0', 'Selecting yes will cause vBulletin to add no-cache HTTP headers. These are very effective, so adding them may cause server load to increase due to increase page requests.', 'yesno', 2); INSERT INTO `setting` VALUES (124, 20, 'GZIP Output', 'gzipoutput', '1', 'Selecting yes will enable vBulletin to gzip the output of pages, thus reducing bandwidth requirements. This will be only used on clients that support it, and are HTTP 1.1 compliant. There will be a performance overhead. This feature requires PHP 4.0.1 or greater, and the ZLIB library.', 'yesno', 3); INSERT INTO `setting` VALUES (125, 20, 'GZIP compression level', 'gziplevel', '9', 'Set the level of GZIP compression that will take place on the output. 0=none; 9=max.', '', 4); INSERT INTO `setting` VALUES (126, 20, 'Cookie Domain', 'cookiedomain', '', 'The domain on which you want the cookie to have effect. If you want this to affect all of yourhost.com rather than just forums.yourhost.com, enter .yourhost.com here (note the 2 dots!!!). Can be left blank.', '', 5); INSERT INTO `setting` VALUES (127, 20, 'Path to save cookies', 'cookiepath', '/', 'The path that the cookie is saved to. If you run more than one board on the same domain, it will be necessary to set this to the individual directories of the forums. Otherwise, just leave it as / .', '', 6); INSERT INTO `setting` VALUES (128, 21, 'Template version number', 'templateversion', '2.3.2', 'Don\'t touch!', '', 0); INSERT INTO `setting` VALUES (129, 22, 'Spell Check Language', 'spellchecklang', 'en', 'The language used for the spell checking features, provided by Spellchecker.net. If you do not want to use these features, you should remove them from the template.', '', 1); INSERT INTO `setting` VALUES (130, 23, 'Add template name in comments', 'addtemplatename', '0', 'Add the template name at the beginning and end of every template rendered. This is useful for debugging and analyzing the HTML code, but turn it off to save bandwidth when running in a production environment.', 'yesno', 1); INSERT INTO `setting` VALUES (131, 24, 'Simultaneous sessions limit', 'sessionlimit', '0', 'Set this to the maximum number of simultaneous sessions that you want to be active at any one time. If this number is exceeded, new users are turned away until the server is less busy. Set this to 0 to disable this option.', '', 1); INSERT INTO `setting` VALUES (132, 24, '*NIX Load Limit', 'loadlimit', '0', 'vBulletin can read the overall load of the server on certain *nix setups (including Linux). This allows vBulletin to determine the load on the server and processor, and to turn away further users if the load becomes too high. If you do not want to use this option, set it to 0. A typical level would be 5.00 for a reasonable warning level.', '', 2); INSERT INTO `setting` VALUES (133, 25, 'Maximum Options', 'maxpolloptions', '10', 'Maximum number of options a user can select for the poll. Set this to 0 to allow infinitely many options.', '', 1); INSERT INTO `setting` VALUES (134, 25, 'Update last post time', 'updatelastpost', '0', 'Update the last post time for the thread (thus returning it to the top of a forum) when a vote is placed.', 'yesno', 2); INSERT INTO `setting` VALUES (135, 26, 'Enable Avatars', 'avatarenabled', '0', 'Use this option to enable/disable the overall use of avatars.

Avatars are small images displayed under usernames in thread display and user info pages.', 'yesno', 1); INSERT INTO `setting` VALUES (136, 26, 'Minimum custom posts', 'avatarcustomposts', '0', 'Minimum number of posts that a user required before they can specify a custom avatar for use.', '', 2); INSERT INTO `setting` VALUES (137, 26, 'Allow uploads', 'avatarallowupload', '0', 'Allow user to upload their own custom avatar if they have enough posts?', 'yesno', 3); INSERT INTO `setting` VALUES (138, 26, 'Allow website uploads', 'avatarallowwebsite', '0', 'Allow user to upload their own custom avatar from another website if they have enough posts?', 'yesno', 4); INSERT INTO `setting` VALUES (139, 26, 'Maximum Dimensions', 'avatarmaxdimension', '50', 'Maximum width and height (in pixels) that the custom avatar image can be.', '', 5); INSERT INTO `setting` VALUES (140, 26, 'Maximum File Size', 'avatarmaxsize', '20000', 'The maximum file size (in bytes) that an avatar can be.\r\n\r\n1 KB = 1024 bytes\r\n1 MB = 1048576 bytes', '', 6); INSERT INTO `setting` VALUES (141, 26, 'Display Height', 'numavatarshigh', '5', 'How many rows of avatars do you wish to display to the user when selecting an avatar?', '', 7); INSERT INTO `setting` VALUES (142, 26, 'Display Width', 'numavatarswide', '5', 'How many columns of avatars do you wish to display to the user when selecting an avatar?', '', 8); INSERT INTO `setting` VALUES (143, 27, 'Maximum File Size', 'maxattachsize', '204800', 'Specify the maximum size in bytes that an upload may be. Set this value to 0 to enable any sized uploads.\n\n1 KB = 1024 bytes\n1 MB = 1048576 bytes', '', 1); INSERT INTO `setting` VALUES (144, 27, 'Valid Extensions', 'attachextensions', 'gif jpg png txt zip bmp jpeg', 'Valid extensions that uploads may have. Separate each item with a space.\n\nFor each extension, you should have a file in the /images/attach/ folder called xxx.gif where xxx is the extension of the file. This allows you to have an icon for each file type.', '', 2); INSERT INTO `setting` VALUES (145, 27, 'View Images', 'viewattachedimages', '1', 'Do you wish to display attached images in the threads? Select no to just generate a link to download the image.', 'yesno', 3); INSERT INTO `setting` VALUES (146, 27, 'Maximum Image Width', 'maxattachwidth', '0', 'Set this to the maximum width attached images (jpg and gif) may have. Set it to 0 to not limit the width.', '', 4); INSERT INTO `setting` VALUES (147, 27, 'Maximum Image Height', 'maxattachheight', '0', 'Set this to the maximum height attached images (jpg and gif) may have. Set it to 0 to not limit the height.', '', 5); INSERT INTO `setting` VALUES (148, 27, 'Allow Duplicate Images', 'allowduplicates', '1', 'Setting this to NO will cause the post to refer to the previous existence of the attachment instead of adding another copy of it to the database. It only checks for attachments posted by the user that is making the post.', 'yesno', 6); INSERT INTO `setting` VALUES (149, 28, 'Enable Titles', 'ctEnable', '0', 'Enable Custom User titles?', 'yesno', 1); INSERT INTO `setting` VALUES (150, 28, 'Maximum Chars', 'ctMaxChars', '25', 'Maximum length users will be allowed to set their custom title to.', '', 2); INSERT INTO `setting` VALUES (151, 28, 'Number of Posts', 'ctPosts', '10', 'Number of posts a user must have before they can use custom titles.', '', 3); INSERT INTO `setting` VALUES (152, 28, 'Number of Days', 'ctDays', '10', 'Number of days a user must be registered before they can use custom titles.', '', 4); INSERT INTO `setting` VALUES (153, 28, 'Allow Mods/Admins to Change titles', 'ctAdmin', '1', 'Allow Admins/Mods to change titles whether or not they have enough posts or have been registered long enough? User titles must be enabled.', 'yesno', 5); INSERT INTO `setting` VALUES (154, 28, 'Boolean', 'ctEitherOr', '1', 'Do you want a user to have to have the number of posts you specified above AND be registered the number of days you specified above? If you select NO then if a user satisfies EITHER criteria than they can use custom titles. For Ex a User has been registered for 1 year but only has 20 posts. If you specified 100 posts and 1 year then they could use titles if you select NO.', 'yesno', 6); INSERT INTO `setting` VALUES (155, 28, 'Censored Words', 'ctCensorWords', 'admin forum moderator vbulletin leader', 'Type all words you want censored in the field below. Do not use commas to separate words, just use spaces. For example, type "dog cat boy", rather than "dog, cat, boy." If you type "dog", all words containing the string "dog" would be censored (dogma, for instance, would appear as "***ma"). To censor more accurately, you can require that censors occur only for exact words. You can do this by placing a censor word in curly braces, as in {dog}. Signifying "dog" in the curly braces would mean that dogma would appear as dogma, but dog would appear as "***". Thus your censor list may appear as: cat {dog} {barn} barn
\r\nDo not use quotation marks and make sure you use curly braces, not parentheses, when specifying exact words.', '', 7); INSERT INTO `setting` VALUES (156, 28, 'Exempt Mod from Censor', 'ctCensorMod', '1', 'Do you want to exempt mods from the censor words? You will want to set this to yes if you censor anything that is part of a moderator\'s title like "moderator" as they have custom titles by default and will get censored.', 'yesno', 8); INSERT INTO `setting` VALUES (157, 29, 'Enable Calendar', 'calendarenabled', '1', 'Disable/enable the calendar', 'yesno', 1); INSERT INTO `setting` VALUES (158, 29, 'Birthdays', 'calbirthday', '0', 'Use birthdays?', 'yesno', 2); INSERT INTO `setting` VALUES (159, 29, 'Individual Birthdays', 'calshowbirthdays', '0', 'Show the individual birthdays for each user on the calendar? Set this to NO to just show a link if a particular day has birthdays on it.', 'yesno', 3); INSERT INTO `setting` VALUES (160, 29, 'html', 'calallowhtml', '0', 'Allow HTML to be used in the calendar events?', 'yesno', 4); INSERT INTO `setting` VALUES (161, 29, 'bbimagecode', 'calbbimagecode', '1', 'Allow [IMG] code to be used in calendar events?', 'yesno', 5); INSERT INTO `setting` VALUES (162, 29, 'smilies', 'calallowsmilies', '1', 'Allow smilies to be used in calendar events?', 'yesno', 6); INSERT INTO `setting` VALUES (163, 29, 'bbcode', 'calallowbbcode', '1', 'Allow VB code to be used in calendar events?', 'yesno', 7); INSERT INTO `setting` VALUES (164, 29, 'title length', 'caltitlelength', '50', 'Length to cut off titles when displayed on the main calendar. 0 disables cut-off.', '', 8); INSERT INTO `setting` VALUES (165, 29, 'Starting Day', 'calStart', '7', 'Pick the day that you would like the weeks on your calendar to start with. Users can also change this in their profile to match their locale\'s customs.', '', 9); INSERT INTO `setting` VALUES (166, 30, 'Upload In Safe Mode?', 'safeupload', '0', 'If your server runs PHP with SAFE MODE Restrictions, set this to yes.', 'yesno', 1); INSERT INTO `setting` VALUES (167, 30, 'Safe Mode Temp Directory', 'tmppath', '/tmp', 'If your server is running in safe_mode, you\'ll need to specify a directory that is CHMOD to 777 that will act as a temporary directory for uploads. All files are removed from this directory after database insertion.
Note: Do NOT include the trailing slash ("/") after the directory name.', '', 2); INSERT INTO `setting` VALUES (168, 30, 'Allow Image Size Checking Failure?', 'allowimgsizefailure', '0', 'On some servers, calls to getimagesize() to check image dimensions may fail for currently unknown reasons. If you are affected by this, you will want to set this option to "yes", otherwise you will not be able to upload images (avatars or attachments). However, users may be able to get around your image dimension limits!', 'yesno', 3); INSERT INTO `setting` VALUES (169, 31, 'Enable Who\'s Online', 'WOLenable', '1', 'Selecting NO will disable Who\'s Online for everyone.', 'yesno', 1); INSERT INTO `setting` VALUES (170, 31, 'Enable Guests', 'WOLguests', '1', 'Display Guest activity on Who\'s Online?', 'yesno', 2); INSERT INTO `setting` VALUES (171, 31, 'Resolve IPs', 'WOLresolve', '0', 'Resolve IP addresses for those who have access to view them? This can slow down the Display of Who\'s Online.', 'yesno', 3); INSERT INTO `setting` VALUES (172, 31, 'Refresh', 'WOLrefresh', '60', 'Time period in seconds to refresh the Who\'s Online display. 0 disables refresh.', '', 4); # -------------------------------------------------------- # # Table structure for table `settinggroup` # CREATE TABLE `settinggroup` ( `settinggroupid` smallint(5) unsigned NOT NULL auto_increment, `title` char(100) NOT NULL default '', `displayorder` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`settinggroupid`) ) TYPE=MyISAM AUTO_INCREMENT=32 ; # # Dumping data for table `settinggroup` # INSERT INTO `settinggroup` VALUES (1, 'Turn Your vBulletin on and off', 1); INSERT INTO `settinggroup` VALUES (2, 'General Settings', 2); INSERT INTO `settinggroup` VALUES (3, 'Contact Details', 3); INSERT INTO `settinggroup` VALUES (4, 'Posting Code allowances (vB code / HTML / etc)', 4); INSERT INTO `settinggroup` VALUES (5, 'Forums Home Page Options', 5); INSERT INTO `settinggroup` VALUES (6, 'User and registration options', 6); INSERT INTO `settinggroup` VALUES (7, 'Memberlist options', 7); INSERT INTO `settinggroup` VALUES (8, 'Thread display options', 8); INSERT INTO `settinggroup` VALUES (9, 'Forum Display Options', 9); INSERT INTO `settinggroup` VALUES (10, 'Search Options', 10); INSERT INTO `settinggroup` VALUES (11, 'Email Options', 11); INSERT INTO `settinggroup` VALUES (12, 'Date / Time options', 12); INSERT INTO `settinggroup` VALUES (14, 'Edit Options', 14); INSERT INTO `settinggroup` VALUES (15, 'IP Logging Options', 15); INSERT INTO `settinggroup` VALUES (16, 'Floodcheck Options', 16); INSERT INTO `settinggroup` VALUES (17, 'Banning Options', 17); INSERT INTO `settinggroup` VALUES (18, 'Language Options', 18); INSERT INTO `settinggroup` VALUES (19, 'Private Messaging Options', 19); INSERT INTO `settinggroup` VALUES (13, 'Censorship Options', 13); INSERT INTO `settinggroup` VALUES (20, 'HTTP Headers and output', 20); INSERT INTO `settinggroup` VALUES (21, 'Version Info', 0); INSERT INTO `settinggroup` VALUES (22, 'Spell Check', 21); INSERT INTO `settinggroup` VALUES (23, 'Templates', 22); INSERT INTO `settinggroup` VALUES (24, 'Load limiting options', 24); INSERT INTO `settinggroup` VALUES (25, 'Polls', 25); INSERT INTO `settinggroup` VALUES (26, 'Avatars', 26); INSERT INTO `settinggroup` VALUES (27, 'Attachments', 27); INSERT INTO `settinggroup` VALUES (28, 'Custom User Titles', 28); INSERT INTO `settinggroup` VALUES (29, 'Calendar', 29); INSERT INTO `settinggroup` VALUES (30, 'Upload Options', 30); INSERT INTO `settinggroup` VALUES (31, 'Who\'s Online', 31); # -------------------------------------------------------- # # Table structure for table `smilie` # CREATE TABLE `smilie` ( `smilieid` smallint(5) unsigned NOT NULL auto_increment, `title` char(100) NOT NULL default '', `smilietext` char(10) NOT NULL default '', `smiliepath` char(100) NOT NULL default '', PRIMARY KEY (`smilieid`) ) TYPE=MyISAM AUTO_INCREMENT=12 ; # # Dumping data for table `smilie` # INSERT INTO `smilie` VALUES (1, 'smile', ':)', 'images/smilies/smile.gif'); INSERT INTO `smilie` VALUES (2, 'frown', ':(', 'images/smilies/frown.gif'); INSERT INTO `smilie` VALUES (3, 'embarrasment', ':o', 'images/smilies/redface.gif'); INSERT INTO `smilie` VALUES (4, 'big grin', ':D', 'images/smilies/biggrin.gif'); INSERT INTO `smilie` VALUES (5, 'wink', ';)', 'images/smilies/wink.gif'); INSERT INTO `smilie` VALUES (6, 'stick out tongue', ':p', 'images/smilies/tongue.gif'); INSERT INTO `smilie` VALUES (7, 'cool', ':cool:', 'images/smilies/cool.gif'); INSERT INTO `smilie` VALUES (8, 'roll eyes (sarcastic)', ':rolleyes:', 'images/smilies/rolleyes.gif'); INSERT INTO `smilie` VALUES (9, 'mad', ':mad:', 'images/smilies/mad.gif'); INSERT INTO `smilie` VALUES (10, 'eek!', ':eek:', 'images/smilies/eek.gif'); INSERT INTO `smilie` VALUES (11, 'confused', ':confused:', 'images/smilies/confused.gif'); # -------------------------------------------------------- # # Table structure for table `style` # CREATE TABLE `style` ( `styleid` smallint(5) unsigned NOT NULL auto_increment, `replacementsetid` smallint(5) unsigned NOT NULL default '0', `templatesetid` smallint(5) unsigned NOT NULL default '0', `title` char(250) NOT NULL default '', `userselect` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`styleid`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; # # Dumping data for table `style` # INSERT INTO `style` VALUES (1, 1, 1, 'Default', 1); # -------------------------------------------------------- # # Table structure for table `subscribeforum` # CREATE TABLE `subscribeforum` ( `subscribeforumid` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `forumid` smallint(5) unsigned NOT NULL default '0', `emailupdate` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`subscribeforumid`), KEY `userid` (`userid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `subscribeforum` # # -------------------------------------------------------- # # Table structure for table `subscribethread` # CREATE TABLE `subscribethread` ( `subscribethreadid` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `threadid` int(10) unsigned NOT NULL default '0', `emailupdate` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`subscribethreadid`), KEY `threadid` (`threadid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `subscribethread` # # -------------------------------------------------------- # # Table structure for table `template` # CREATE TABLE `template` ( `templateid` smallint(5) unsigned NOT NULL auto_increment, `templatesetid` smallint(6) NOT NULL default '0', `title` varchar(100) NOT NULL default '', `template` mediumtext NOT NULL, PRIMARY KEY (`templateid`), KEY `title` (`title`(30),`templatesetid`) ) TYPE=MyISAM AUTO_INCREMENT=488 ; # # Dumping data for table `template` # INSERT INTO `template` VALUES (1, -1, 'activateform', '{htmldoctype}\n\n$bbtitle - Activate registration\n$headinclude\n\n\n$header\n\n
\n\n

\n\n\n\n
\n\n\n \n\n\n \n \n\n\n \n \n\n
Activate Your Account
User Name:
Activation code:
\n
\n\n\n\n \n\n
\n\n
\n\n$footer\n\n\n\n'); INSERT INTO `template` VALUES (2, -1, 'activate_requestemail', '{htmldoctype}\n\n\n$bbtitle - Retrieve activation code\n$headinclude\n\n\n$header\n\n
\n\n
\n\n\n
\n\n\n \n\n\n \n\n\n \n\n
Activation Code Request Form
To request for your activation code to be sent to you by email, please enter your registered email address in the box below then submit the form.
Your Email Address:    \n
\n
\n\n
\n\n\n\n \n\n
\n \n \n \n
\n\n
\n\n$footer\n\n\n'); INSERT INTO `template` VALUES (3, -1, 'aim', '   Send an AIM message to $userinfo[username]'); INSERT INTO `template` VALUES (4, -1, 'aimmessage', '{htmldoctype}\n\nAIM Message\n$headinclude\n\n\n\n\n
\nSend a message to
$aim
\n\n\n\n \n\n
Download AIM 3.0AIM Remote
Send me an Instant Message
Add me to Your Buddy List
Join my Chat Room
Close This Window
\n
\n\n\n\n\n'); INSERT INTO `template` VALUES (5, -1, 'announcebit', '\n \n $firstnewname\n $post[username]
\n \n $post[usertitle]
\n $post[avatar]
\n
\n Registered: $post[joindate]
\n Posts: $post[posts]\n
\n \n \n $post[title] ($post[startdate] until $post[enddate])\n
\n $message\n
\n \n\n\n \n $onlinestatus $post[profile] $post[useremail] $post[pmlink] $post[homepage]\n \n Add $post[username] to your buddy list\n \n\n'); INSERT INTO `template` VALUES (6, -1, 'announcement', '{htmldoctype}\n\n\n$bbtitle - $foruminfo[title] Announcements\n$headinclude\n\n\n\n$header\n\n\n\n \n \n\n
\n $bbtitle - powered by vBulletin version $templateversion\n $bbtitle\n > $foruminfo[title]\n > AnnouncementsCurrent Announcements: $announcecount
\n\n
\n\n
\n\n\n \n \n\n$announcebits\n\n \n\n
Author 
$timezone 
\n
\n\n
\n\n\n\n \n\n
$forumjump
\n\n$footer\n\n\n'); INSERT INTO `template` VALUES (7, -1, 'avatar', '$avatar[title]\n$avatar[title]'); INSERT INTO `template` VALUES (8, -1, 'avatarbit', '

If you have at least $minposts posts, you can choose these avatars:
\n$avatarlist\n

'); INSERT INTO `template` VALUES (9, -1, 'avatars', '{htmldoctype}\n\n\n$bbtitle - Avatars\n$headinclude\n\n\n$header\n\n
\n\n\n\n \n\n
\n\n

Avatars are small graphical images that you may choose in your profile.\nThey are displayed below your username on all posts that you make.\nYou can select the image that best describes yourself from your profile options.

\n\n

Here\'s the list of currently available avatars:

\n\n$avatarbits\n\n

If you have more than $avatarcustomposts posts, you may also specify your own custom avatar.

\n\n
\n\n$footer\n\n\n'); INSERT INTO `template` VALUES (10, -1, 'bbcode', '{htmldoctype}\n\n\nvB Codes Explained\n$headinclude\n\n\n$header\n\n
\n\n\n\n \n\n
\n\n

What is vB Code?

\n

vB code is a set of tags based on the HTML language that you may already be familiar with. They allow you to add formatting to your messages in the same way as HTML does, but have a simpler syntax and will never break the layout of the pages you are viewing. The ability to use vB Code is set on a forum-by-forum basis by the administrator, so you should check the forum rules when you post a new message.

\n

URL Hyperlinking

\n

If vB Code is enabled in a forum, you can simply type in the full address of the page you are linking to, and the hyperlink will be created automatically. Here are some example links:

\n
    \n
  • http://www.vbulletin.com/forum/
  • \n
  • www.vbulletin.com
  • \n
\n

Notice that if the address begins with www. you do not need to add the http:// part of the address. If the address does not begin with www. you will need to add the http:// section. You may also use https:// and ftp:// links, and these will be converted into links.

\n

If you want to include the vB Code, you may simply surround the address with [url] tags as shown below. (The vB Code tags are shown in red).

\n
\n

[url]www.vbulletin.com/forum/[/url]

\n
\n

You can also include true hyperlinks using the [url] tag. Just use the following format:

\n
\n

[url=http://www.vbulletin.com/forum/]Click here to visit the vBulletin forums[/url]

\n
\n

This will produce a hyperlink like this: Click here to visit the vBulletin forums.

\n

Note that once again, you need not include the http:// if the address begins www.

\n

Email Links

\n

To add a link to an email address, you can simply include the email address in your message like this:

\n
\n

myname@domain.com

\n
\n

Note that there must be a blank space, such as a space or a carriage return before the beginning of the address.

\n

You can also use vB Code tags to specify an email address, like this:

\n
\n

[email]myname@domain.com[/email]

\n
\n

You can also add a true email hyperlink using the following format:

\n
\n

[email=myname@domain.com]Click here to email me[/email]

\n
\n

This will produce a hyperlink like this: Click here to email me.

\n

Bold, Underlined and Italic Text

\n

You can make text bold, underlined or italicized by simply surrounding your text with tags as shown below:

\n
    \n
  • [b]some text[/b] produces some text
  • \n
  • [u]some text[/u] produces some text
  • \n
  • [i]some text[/i] produces some text
  • \n
\n

Using Different Colors, Sizes and Fonts

\n

You can alter the size, color and font of text using the following tags:

\n
    \n
  • [color=blue]some text[/color] produces some text (colored blue)
  • \n
  • [size=4]some text[/size] produces some text (size 4 text)
  • \n
  • [font=courier]some text[/font] produces some text (using courier font)
  • \n
\n

You can also combine all the various text formatting tags. This example uses bold, underlined, purple text:

\n
\n

[color=purple][u][b]Wow there\'s lots of formatting here![/b][/u][/color]

\n
\n

This example produces this:

\n
\n

Wow there\'s lots of formatting here!

\n
\n

Bullets and Lists

\n

You can create bulleted or ordered lists in the following way:

\n

Unordered, bulleted list:

\n

[list]
\n [*]first bulleted item
\n [*]second bulleted item
\n [/list]

\n

This produces:

\n
    \n
  • first bulleted item
  • \n
  • second bulleted item
  • \n
\n

Note that you must remember to close the list with the [/list] tag.

\n

If you would like to create a list ordered numerically or alphabetically, this is just as easy. You simply need to add a little extra code to your [list] and [/list] tags. The extra code looks like =1 (for a numbered list) or =A (for a list from A to Z). Here are some examples:

\n\n \n \n \n \n
\n

[list=1]
\n [*]this is the first numbered item
\n [*]this is the second numbered item
\n [/list=1]

\n

This produces:

\n
    \n
  1. this is the first numbered item
  2. \n
  3. this is the second numbered item
  4. \n
\n
\n

[list=A]
\n [*]this is the first alphabetically ordered item
\n [*]this is the second alphabetically ordered item
\n [/list=A]

\n

This produces:

\n
    \n
  1. this is the first alphabetically ordered item
  2. \n
  3. this is the second alphabetically ordered item
  4. \n
\n
\n

Adding Images

\n

To include a picture or graphic within the body of your message, you can simply surround the address of the image as shown here:

\n
\n

[img]$bburl/{titleimage}[/img]

\n
\n

Note that the http:// part of the image URL is required for the [img] code.

\n

You can even create a thumbnail-type hyperlink by surrounding your [img] code with a [url] code like this:

\n
\n

[url=$bburl/{titleimage}][img]$bburl/{imagesfolder}/vb_bullet.gif[/img][/url]

\n
\n

This produces a link like this: 0.

\n

Quoting Other Messages

\n

To quote something that has already been posted, simply cut-and-paste the text you want to quote, and enclose it as follows:

\n
\n

[quote]No. Try not.
\n Do or do not, there is no try.[/quote]

\n
\n

The [quote] tags will automatically indent the enclosed text.

\n

The Code and PHP Tags

\n

If you want to post some programming source code, or perhaps some ASCII art, which would require a non-proportional font, you can use the [code] tag to achieve this. For example:

\n
\n

[code]
\n <script language="Javascript">
\n <!--
\n alert("Hello world!");
\n //-->
\n </script>
\n [/code]

\n
\n

In the example above, the text enclosed in the [code] tags would be automatically indented, and the spacing would be preserved like this:

\n
\n
<script language="Javascript">\n<!--\nalert("Hello world!");\n//-->\n</script>
\n
\n

A special case is for code written in the PHP language. If you are posting PHP code, you can enclose the source code in [php] tags, and the script will automatically have syntax highlighting applied:

\n
\n

[php]
\n $myvar = "Hello World!";
\n for ($i=0; $i<10; $i++) {
\n echo $myvar."\\n";
\n }
\n [/php]

\n
\n

This would produce:

\n
\n
$myvar "Hello World!";\nfor ($i=0$i<10$i++) {\n	echo $myvar."\\n";\n}
\n
\n

Incorrect vB Code Usage:\n

\n
    \n
  • [url] www.vbulletin.com [/url] - don\'t put spaces between the bracketed code and the text you are applying the code to.
  • \n
  • [email]myname@domain.com[email] - the end brackets must include a forward slash ([/email])
  • \n
\n
\n\n
\n\n$footer\n\n\n'); INSERT INTO `template` VALUES (11, -1, 'calendar', '{htmldoctype}\n\n\n$bbtitle - Calendar $monthtext\n$headinclude\n\n\n$header\n\n\n\n \n \n\n
$navbar$addpub $addpriv
\n\n
\n\n
\n\n\n \n\n$calendar_daynames\n\n$calendarbits\n\n
$bbtitle Calendar
\n
\n\n
\n\n
\n\n\n\n \n \n \n\n\n
$addpub $addpriv\n \n $gobutton\n \n \n $premonth\n |\n $nextmonth\n \n
\n
\n\n$footer\n\n\n'); INSERT INTO `template` VALUES (12, -1, 'calendarbit', '$daylink
$userbdays$userevents'); INSERT INTO `template` VALUES (13, -1, 'calendarbit_bg', ''); INSERT INTO `template` VALUES (14, -1, 'calendarbit_today', '$daylink
\n $userbdays$userevents'); INSERT INTO `template` VALUES (15, -1, 'calendar_birthday', '$bd_user\'s birthday $age
'); INSERT INTO `template` VALUES (16, -1, 'calendar_convert', '
\nConvert this event to Public/Private'); INSERT INTO `template` VALUES (17, -1, 'calendar_daybits', '\n\n \n\n
Edit this event
\n\n
\n\n\n \n \n\n\n \n \n\n \n \n\n
Type:$type Event $postedby
Subject:$subject\n
Event Information:$eventinfo
\n
'); INSERT INTO `template` VALUES (18, -1, 'calendar_daylink', '$day'); INSERT INTO `template` VALUES (19, -1, 'calendar_daynames_friday', '\n Friday\n Saturday\n Sunday\n Monday\n Tuesday\n Wednesday\n Thursday\n\n'); INSERT INTO `template` VALUES (20, -1, 'calendar_daynames_monday', '\n Monday\n Tuesday\n Wednesday\n Thursday\n Friday\n Saturday\n Sunday\n\n'); INSERT INTO `template` VALUES (21, -1, 'calendar_daynames_saturday', '\n Saturday\n Sunday\n Monday\n Tuesday\n Wednesday\n Thursday\n Friday\n\n'); INSERT INTO `template` VALUES (22, -1, 'calendar_daynames_sunday', '\n Sunday\n Monday\n Tuesday\n Wednesday\n Thursday\n Friday\n Saturday\n\n'); INSERT INTO `template` VALUES (23, -1, 'calendar_daynames_thursday', '\n Thursday\n Friday\n Saturday\n Sunday\n Monday\n Tuesday\n Wednesday\n'); INSERT INTO `template` VALUES (24, -1, 'calendar_daynames_tuesday', '\n Tuesday\n Wednesday\n Thursday\n Friday\n Saturday\n Sunday\n Monday\n\n'); INSERT INTO `template` VALUES (25, -1, 'calendar_daynames_wednesday', '\n Wednesday\n Thursday\n Friday\n Saturday\n Sunday\n Monday\n Tuesday\n\n'); INSERT INTO `template` VALUES (26, -1, 'calendar_deleteevent', '\n Delete?\n To delete this event, check this box.\n'); INSERT INTO `template` VALUES (27, -1, 'calendar_enterevent', '{htmldoctype}\n\n\n$bbtitle - Enter new Events\n$headinclude\n\n\n$header\n\n\n\n \n\n
$navbar
\n\n
\n\n\n
\n\n\n \n\n$deleteevent\n$logincode\n\n \n \n\n\n \n \n\n$vbcode_buttons\n\n \n \n\n\n \n \n\n
New Event
Date:\n \n \n \n \n \n \n \n \n \n \n \n
MonthDayYear
\n
Subject:

Event Information:

$vbcode_smilies
\n \n \n \n \n
\n
Options\n \n Automatically parse URLs: automatically adds [url] and [/url] around internet addresses.\n $disablesmiliesoption\n $convert\n
\n
\n\n
\n\n\n\n \n\n
\n Posts: HTML Code is $htmlcodeon.\n Smilies are $smilieson.\n vB Code is $bbcodeon. [IMG] code is $imgcodeon.\n

\n    \n \n \n \n \n \n
\n\n
\n\n$footer\n \n\n'); INSERT INTO `template` VALUES (28, -1, 'calendar_getbirthdays', '
\n\n
\n\n\n \n \n\n
Birthdays$userbdays
\n
'); INSERT INTO `template` VALUES (29, -1, 'calendar_getday', '{htmldoctype}\n\n\n$bbtitle - Day Info\n$headinclude\n\n\n$header\n\n\n\n\n \n\n
$navbar
\n\n\n$birthdays\n$caldaybits\n\n$footer\n\n\n'); INSERT INTO `template` VALUES (30, -1, 'calendar_hasbirthday', '
  • Birthdays\n ($bdaycount)
  • '); INSERT INTO `template` VALUES (31, -1, 'calendar_postedby', '(posted by $user)'); INSERT INTO `template` VALUES (32, -1, 'calendar_privateevent', '
  • $eventsubject
  • '); INSERT INTO `template` VALUES (33, -1, 'calendar_privateeventbutton', 'Add Private Event'); INSERT INTO `template` VALUES (34, -1, 'calendar_publicevent', '
  • $eventsubject
  • '); INSERT INTO `template` VALUES (35, -1, 'calendar_publiceventbutton', 'Add Public Event'); INSERT INTO `template` VALUES (36, -1, 'calendar_showbirthdays', '$bd_user $age'); INSERT INTO `template` VALUES (37, -1, 'coppaform', '{htmldoctype}\n\n\nPermission to Participate at $bbtitle\n\n\n\n\n\n\n \n \n\n
    $toplinks
    \n\n
    Permission to Participate at $bbtitle
    \n\n\n

    Instructions for a Parent or Guardian

    \n \n

    Please print out this page, sign it and fax it to:
    \n $companyname at $faxnumber

    \n \n

    or mail it to :
    \n $address

    \n \n

    If approval is not received in 7 days the information will be deleted.

    \n
    \n\n\n\n \n\n\n \n \n\n\n \n \n\n\n \n\n\n \n\n\n \n \n\n\n \n \n\n\n \n \n\n\n \n \n\n\n \n \n\n\n \n \n\n\n \n\n\n \n \n\n\n \n \n\n\n \n \n\n\n \n \n\n\n \n \n\n\n \n \n\n\n \n\n

    Required Information

    User Name:$bbuserinfo[username] 
    Email:$bbuserinfo[email] 

    Optional Information

    To make changes to the profile information below, please visit this page and enter the username and password:
    \n $bburl/member.php?action=editprofile
    Homepage:$bbuserinfo[homepage] 
    Signature:$bbuserinfo[signature] 
    Privacy Mode:
    \n Selecting \'yes\' hides email, ICQ number, AIM ID in profile and also hides you in \'Logged In Users\' list.
    $bbuserinfo[showemail] 
    ICQ Number:$bbuserinfo[icq] 
    AOL Instant Messenger Handle:$bbuserinfo[aim] 
    Yahoo Messenger Handle:$bbuserinfo[yahoo] 

    Please sign the form below and send it to us.

    \n

    I have reviewed the information my child has supplied and I have read the Privacy Policy ($privacyurl) for the web site. I understand that the profile information may be changed by a using a password. I understand that I may ask for this registration profile be removed entirely.

    Parent/Guardian Full Name: 
    Signature: 
    Relation to Child: 

    Telephone:

     
    Email Address:$bbuserinfo[parentemail] 
    Date: 

    Please contact $webmasteremail with any questions

    \n\n\n'); INSERT INTO `template` VALUES (38, -1, 'editpoll', '{htmldoctype}\n\n\n$bbtitle - Edit this poll\n$headinclude\n\n\n$header\n\n\n\n \n\n
    $navbar\n

    Forum Rules:
    $forumrules

    \n\n
    \n\n
    \n\n\n\n\n \n\n\n \n\n\n$logincode\n\n\n \n \n\n\n \n \n\n\n \n \n\n
    Edit Poll
    Close? To close this poll, check this box.
    \n Note: Closing this poll makes it impossible to vote. It however does not stop people from replying to the thread
    Question:
    Poll to edit:\n


    \n See Forum Rules (above) for
    \n more information about what
    \n codes you are allowed to use
    \n in your polls.

    \n
    \n \n $pollbits\n \n \n \n \n \n \n \n \n \n \n \n
    Additional Fields:
    Additional Option 1:
    Additional Option 2:
    \n
    Time out: days after $pollinfo[postdate]
    \n
    \n\n
    \n\n\n\n \n\n
    \n \n \n \n \n
    \n\n\n\n$footer\n\n\n'); INSERT INTO `template` VALUES (39, -1, 'editpost', '{htmldoctype}\n\n\n$bbtitle - Edit this post\n$headinclude\n\n