Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for b_banemails
-- ----------------------------
DROP TABLE IF EXISTS `b_banemails`;
CREATE TABLE `b_banemails` (
`emailid` bigint(20) NOT NULL auto_increment,
`email` varchar(255) NOT NULL default '',
PRIMARY KEY (`emailid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for b_banip
-- ----------------------------
DROP TABLE IF EXISTS `b_banip`;
CREATE TABLE `b_banip` (
`ipid` bigint(20) NOT NULL auto_increment,
`ip` varchar(255) NOT NULL default '',
PRIMARY KEY (`ipid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for b_categories
-- ----------------------------
DROP TABLE IF EXISTS `b_categories`;
CREATE TABLE `b_categories` (
`categoryid` bigint(20) NOT NULL auto_increment,
`categoryname` varchar(255) NOT NULL default '',
`catsort` bigint(20) NOT NULL default '0',
PRIMARY KEY (`categoryid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for b_comments
-- ----------------------------
DROP TABLE IF EXISTS `b_comments`;
CREATE TABLE `b_comments` (
`id` bigint(20) NOT NULL auto_increment,
`poster` varchar(255) collate latin1_general_ci NOT NULL,
`content` text collate latin1_general_ci NOT NULL,
`newsid` int(11) NOT NULL,
`timepost` varchar(100) collate latin1_general_ci NOT NULL,
`datepost` varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for b_forums
-- ----------------------------
DROP TABLE IF EXISTS `b_forums`;
CREATE TABLE `b_forums` (
`ID` bigint(20) NOT NULL auto_increment,
`parentID` bigint(20) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`description` tinytext NOT NULL,
`numtopics` bigint(20) NOT NULL default '0',
`numposts` bigint(20) NOT NULL default '0',
`lastpost` varchar(255) NOT NULL default '',
`sort` bigint(20) NOT NULL default '0',
`ficon` bigint(20) NOT NULL default '0',
`lastpostuser` varchar(255) NOT NULL default '',
`permission_min` int(11) NOT NULL default '0',
`permission_post` int(11) NOT NULL default '0',
`permission_reply` int(11) NOT NULL default '0',
`lastposttime` bigint(20) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for b_friends
-- ----------------------------
DROP TABLE IF EXISTS `b_friends`;
CREATE TABLE `b_friends` (
`id` bigint(21) NOT NULL auto_increment,
`userid` bigint(21) NOT NULL,
`link1` tinytext collate latin1_general_ci NOT NULL,
`link2` tinytext collate latin1_general_ci NOT NULL,
`link3` tinytext collate latin1_general_ci NOT NULL,
`link4` tinytext collate latin1_general_ci NOT NULL,
`link5` tinytext collate latin1_general_ci NOT NULL,
`ip` tinytext collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=77 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for b_games
-- ----------------------------
DROP TABLE IF EXISTS `b_games`;
CREATE TABLE `b_games` (
`id` int(22) NOT NULL auto_increment,
`username` varchar(44) collate latin1_general_ci NOT NULL default 'Guest',
`roulette1` int(12) NOT NULL default '0',
`roulette2` int(12) NOT NULL default '0',
`roulette3` int(12) NOT NULL default '0',
`roulette4` int(12) NOT NULL default '0',
`roulette5` int(12) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for b_news
-- ----------------------------
DROP TABLE IF EXISTS `b_news`;
CREATE TABLE `b_news` (
`id` bigint(20) NOT NULL auto_increment,
`title` varchar(255) collate latin1_general_ci NOT NULL,
`content` longtext collate latin1_general_ci NOT NULL,
`iconid` int(11) NOT NULL,
`timepost` varchar(100) collate latin1_general_ci NOT NULL,
`datepost` varchar(100) collate latin1_general_ci NOT NULL,
`author` varchar(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for b_pms
-- ----------------------------
DROP TABLE IF EXISTS `b_pms`;
CREATE TABLE `b_pms` (
`pmID` bigint(20) NOT NULL auto_increment,
`sender` bigint(20) NOT NULL default '0',
`receiver` bigint(20) NOT NULL default '0',
`therealtime` bigint(20) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`message` mediumtext NOT NULL,
`hasread` int(11) NOT NULL default '0',
`vartime` varchar(255) NOT NULL default '',
PRIMARY KEY (`pmID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for b_posts
-- ----------------------------
DROP TABLE IF EXISTS `b_posts`;
CREATE TABLE `b_posts` (
`ID` bigint(21) NOT NULL auto_increment,
`title` varchar(60) NOT NULL default '',
`author` bigint(20) NOT NULL default '0',
`telapsed` bigint(21) NOT NULL default '0',
`timepost` varchar(100) NOT NULL default '',
`numreplies` int(10) NOT NULL default '0',
`post` longtext NOT NULL,
`threadparent` bigint(21) NOT NULL default '0',
`lastpost` varchar(255) NOT NULL default '',
`postforum` bigint(20) NOT NULL default '0',
`views` bigint(20) NOT NULL default '0',
`nosmilies` int(11) NOT NULL default '0',
`value` int(11) NOT NULL default '0',
`ipaddress` varchar(255) NOT NULL default '',
`locked` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for b_ranks
-- ----------------------------
DROP TABLE IF EXISTS `b_ranks`;
CREATE TABLE `b_ranks` (
`rankID` bigint(20) NOT NULL auto_increment,
`rankname` varchar(255) NOT NULL default '',
`postsneeded` bigint(20) NOT NULL default '0',
PRIMARY KEY (`rankID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for b_shop
-- ----------------------------
DROP TABLE IF EXISTS `b_shop`;
CREATE TABLE `b_shop` (
`id` int(11) NOT NULL auto_increment,
`sep` varchar(3) collate latin1_general_ci NOT NULL default '0',
`name` text collate latin1_general_ci NOT NULL,
`itemid` varchar(20) collate latin1_general_ci NOT NULL,
`color` tinytext collate latin1_general_ci NOT NULL,
`cat` varchar(20) collate latin1_general_ci NOT NULL default '0',
`sort` varchar(10) collate latin1_general_ci NOT NULL default '0',
`cost` varchar(11) collate latin1_general_ci NOT NULL default '0',
`charges` varchar(11) collate latin1_general_ci NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for b_templates
-- ----------------------------
DROP TABLE IF EXISTS `b_templates`;
CREATE TABLE `b_templates` (
`templateid` bigint(20) NOT NULL auto_increment,
`templatepath` varchar(255) NOT NULL default '',
PRIMARY KEY (`templateid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for b_users
-- ----------------------------
DROP TABLE IF EXISTS `b_users`;
CREATE TABLE `b_users` (
`userID` bigint(21) NOT NULL auto_increment,
`username` varchar(60) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`status` int(20) NOT NULL default '0',
`posts` bigint(20) NOT NULL default '0',
`email` varchar(255) NOT NULL default '',
`validated` int(11) NOT NULL default '0',
`keynode` bigint(21) NOT NULL default '0',
`sig` tinytext NOT NULL default '',
`banned` varchar(255) NOT NULL default 'No',
`rank` varchar(255) NOT NULL default '0',
`usepm` int(11) NOT NULL default '1',
`AIM` varchar(50) NOT NULL default '',
`ICQ` varchar(50) NOT NULL default '',
`location` varchar(255) NOT NULL default '',
`showprofile` smallint(6) NOT NULL default '1',
`lastposttime` bigint(20) NOT NULL default '0',
`tsgone` bigint(20) NOT NULL default '0',
`oldtime` bigint(20) NOT NULL default '0',
`avatar` varchar(255) NOT NULL default '',
`photo` varchar(255) NOT NULL default '',
`rating` bigint(255) NOT NULL default '0',
`totalvotes` bigint(20) NOT NULL default '0',
`votedfor` longtext NOT NULL default '',
`rps` int(11) NOT NULL default '1',
`friend` int(11) NOT NULL default '3',
`lasttime` bigint(20) NOT NULL default '0',
`templateclass` bigint(20) NOT NULL default '1',
`charid` bigint(20) NOT NULL default '0',
`honours` bigint(255) NOT NULL default '0',
`points` bigint(255) NOT NULL default '0',
`ranktitle` varchar(255) NOT NULL default 'No Rank',
`ranknum` int(11) NOT NULL default '0',
`buff` bigint(255) NOT NULL default '0',
`money` bigint(255) NOT NULL default '0',
`pprof1` varchar(100) NOT NULL default 'Verdana, Arial, Helvetica, sans-serif',
`pprof2` varchar(150) NOT NULL default '#cccccc',
PRIMARY KEY (`userID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for b_vote
-- ----------------------------
DROP TABLE IF EXISTS `b_vote`;
CREATE TABLE `b_vote` (
`id` bigint(21) NOT NULL auto_increment,
`userid` bigint(21) NOT NULL,
`siteid` bigint(21) NOT NULL,
`timevoted` bigint(21) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for guestsonline
-- ----------------------------
DROP TABLE IF EXISTS `guestsonline`;
CREATE TABLE `guestsonline` (
`guestid` bigint(20) NOT NULL auto_increment,
`guestip` varchar(255) NOT NULL default '',
`time` bigint(20) NOT NULL default '0',
PRIMARY KEY (`guestid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `b_banemails` VALUES ('3', 'bugmenot.com');
INSERT INTO `b_categories` VALUES ('6', 'General & Introductions', '2');
INSERT INTO `b_categories` VALUES ('5', 'Announcements', '1');
INSERT INTO `b_categories` VALUES ('7', 'Applications', '4');
INSERT INTO `b_categories` VALUES ('8', 'Realm Chat', '3');
INSERT INTO `b_forums` VALUES ('13', '6', 'General Chat', 'Anything related to World of Warcraft and our server.', '0', '0', '', '1', '5', '', '-1', '-1', '-1', '0');
INSERT INTO `b_forums` VALUES ('14', '6', 'Greetings & Goodbyes', 'If you are new, this is a great place to introduce yourself to the community! If you\'re leaving the community say goodbye to all your wowtastic friends!', '0', '0', '', '2', '45', '', '-1', '-1', '-1', '0');
INSERT INTO `b_forums` VALUES ('10', '5', 'Site Announcements', 'Check for major updates on our website/forums here.', '15', '21', 'Wed Aug 13, 2008 21:07:14', '1', '28', 'Axe', '-1', '1', '1', '1218658035');
INSERT INTO `b_forums` VALUES ('11', '5', 'Server Announcements', 'Check for major announcements for our servers here.', '0', '0', '', '2', '28', '', '-1', '1', '-1', '0');
INSERT INTO `b_forums` VALUES ('12', '5', 'Rules & Regulations', 'This is where you\'ll find the Rules / Regulations for both the forums and the server. Make sure you read this first!', '0', '0', '', '3', '20', '', '-1', '1', '-1', '0');
INSERT INTO `b_forums` VALUES ('15', '6', 'Suggestions & Comments', 'Give us your opinion or suggestion on how we can improve this WoW Server!', '0', '0', '', '3', '41', '', '-1', '-1', '-1', '0');
INSERT INTO `b_forums` VALUES ('16', '8', 'General Chat', 'Discuss about happenings inside WoW realm.', '0', '0', '', '4', '59', '', '-1', '-1', '-1', '0');
INSERT INTO `b_forums` VALUES ('17', '7', 'GM Applications', 'Do you have what it takes to be a GM? Apply here!', '0', '0', '', '1', '47', '', '-1', '-1', '-1', '0');
INSERT INTO `b_forums` VALUES ('18', '7', 'Community Helper Applications', 'If you have special skills or talents please apply here if you\'d like to help the this Community.', '0', '0', '', '2', '54', '', '-1', '-1', '-1', '0');
INSERT INTO `b_news` VALUES ('19', 'A New Server Opened', 'Success your new Web WoW CMS by AXE has been successfully installed. Congrats :-)\r\n\r\nBy default community board have some categories and forums already created, so it will be easier for new admins to create new server. Admin can modify/delete forums etc. thru Admin Panel.\r\n\r\nThis is first \"news\" so you will wish to delete it, you can do it by going to Admin Panel and then clicking on \"Edit News\" link on the left.\r\n\r\nThere is main multiple main page layouts available for example:\r\n<img src=\"documentation/layouts.gif\" />\r\n<a href=\'home2.php\'>Check second one here</a>\r\nYou can setup layout by renaming file from home2.php to home.php', '5', '2008813151929', 'Aug-13-2008', 'Axe (creator)');
INSERT INTO `b_shop` VALUES ('10', '0', 'Jump-a-tron 4000 Key', '27808', '2', '1', '1', '10', '0');
INSERT INTO `b_templates` VALUES ('1', 'default');
INSERT INTO `b_users` VALUES ('1', 'Guest', '', '0', '0', '', '0', '0', '', 'no', '0', '1', '', '', '', '1', '0', '0', '0', '', '', '0', '0', '', '1', '0', '0', '1', '0', '0', '0', 'No Rank', '0', '0', '0', 'Verdana, Arial, Helvetica, sans-serif', '#cccccc');
INSERT INTO `guestsonline` VALUES ('2', '127.0.0.1', '1218637186');