CREATE TABLE `actionlog` ( `id` mediumint(9) NOT NULL auto_increment, `atime` varchar(15) NOT NULL default '', `adesc` mediumtext NOT NULL, PRIMARY KEY (`id`)); CREATE TABLE `announcements` ( `id` smallint(5) unsigned NOT NULL auto_increment, `user` smallint(5) unsigned NOT NULL default '0', `date` int(10) NOT NULL default '0', `ip` varchar(32) default NULL, `title` varchar(250) default NULL, `text` text, `forum` tinyint(3) NOT NULL default '0', `headtext` text, `signtext` text, `edited` text, `headid` mediumint(6) NOT NULL default '0', `signid` mediumint(6) NOT NULL default '0', `tagval` text NOT NULL, PRIMARY KEY (`id`), KEY `forum` (`forum`)); CREATE TABLE `blockedlayouts` ( `user` smallint(5) unsigned NOT NULL default '0', `blockee` smallint(5) unsigned NOT NULL default '0', KEY `user` (`user`)); CREATE TABLE `boardconfig` ( `registration` smallint(1) NOT NULL default '0', `boardurl` varchar(255) NOT NULL default '', `regemail` varchar(100) NOT NULL default '', `lockable` tinyint(3) unsigned NOT NULL default '0', `searchfunction` tinyint(4) NOT NULL default '1', `del_id` smallint(5) unsigned NOT NULL default '0', `sys_id` smallint(5) unsigned NOT NULL default '0'); INSERT INTO `boardconfig` (`boardurl`) VALUES (''); CREATE TABLE `boardconfiginfo` ( `id` smallint(5) unsigned NOT NULL auto_increment, `kname` varchar(40) default NULL, `name` varchar(255) default NULL, `description` mediumtext, PRIMARY KEY (`id`)); INSERT INTO `boardconfiginfo` (`id`, `kname`, `name`, `description`) VALUES (1, 'registration', 'Registration', 'Banned users and IP-banned users won''t be allowed to register under any condition.

If this is 0, registration is enabled for ''everyone'', including guests. If this is 1, registration is enabled for members only. If this is 2, registration is enabled for local mods and above.'); INSERT INTO `boardconfiginfo` (`id`, `kname`, `name`, `description`) VALUES (2, 'boardurl', 'Base Board URL', 'This is the Base url that would load your main index page. Examples:\r\n
http://board.acmlm.org
http://www.anime-us.com/board'); INSERT INTO `boardconfiginfo` (`id`, `kname`, `name`, `description`) VALUES (3, 'regemail', 'Registration Email Address', 'The email address that\r\nwill be used as a sender of any emails having to do with the registration\r\nprocess.'); INSERT INTO `boardconfiginfo` (`id`, `kname`, `name`, `description`) VALUES (4, 'lockable', 'Lockable Threads', 'Allows admins to "lock" a thread, preventing local/full moderators from editing a thread they would otherwise have access to.

0 = Off\r\n1 = On'); INSERT INTO `boardconfiginfo` (`id`, `kname`, `name`, `description`) VALUES (5, 'searchfunction', 'Search Function', 'Controls the searching of the board database.

Value denotes minimum powerlevel required to use the search.'); INSERT INTO `boardconfiginfo` (`id`, `kname`, `name`, `description`) VALUES (6, 'del_id', 'Deleted User', 'Sets the user id for the deleted user.
This should be a special account, not used by other users.

Note: This user is automatically banned.'); INSERT INTO `boardconfiginfo` (`id`, `kname`, `name`, `description`) VALUES (7, 'sys_id', 'System User', 'Sets the user id for the system user.
This should be a special account, not used by other users.

Note: This user is automatically given a powerlevel above "Administrator".'); CREATE TABLE `categories` ( `id` smallint(5) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `minpower` tinyint(4) default '0', PRIMARY KEY (`id`) ); CREATE TABLE `dailystats` ( `date` varchar(8) NOT NULL default '', `users` int(11) NOT NULL default '0', `threads` int(11) NOT NULL default '0', `posts` int(11) NOT NULL default '0', `views` int(11) NOT NULL default '0', PRIMARY KEY (`date`) ); CREATE TABLE `events` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `d` tinyint(2) unsigned NOT NULL default '0', `m` tinyint(2) unsigned NOT NULL default '0', `y` smallint(4) unsigned NOT NULL default '0', `user` mediumint(8) unsigned NOT NULL default '0', `title` varchar(200) NOT NULL default '', `text` text NOT NULL, UNIQUE KEY `id` (`id`) ); CREATE TABLE `favorites` ( `user` bigint(6) NOT NULL default '0', `thread` bigint(9) NOT NULL default '0' ); CREATE TABLE `forummods` ( `forum` smallint(5) NOT NULL default '0', `user` mediumint(8) NOT NULL default '0' ); CREATE TABLE `forumread` ( `user` smallint(5) unsigned NOT NULL default '0', `forum` tinyint(3) unsigned NOT NULL default '0', `readdate` int(11) NOT NULL default '0', KEY `user` (`user`) ); CREATE TABLE `forums` ( `id` smallint(5) unsigned NOT NULL auto_increment, `title` varchar(250) default NULL, `description` text, `catid` smallint(5) unsigned NOT NULL default '0', `minpower` tinyint(2) NOT NULL default '0', `minpowerthread` tinyint(2) NOT NULL default '0', `minpowerreply` tinyint(2) NOT NULL default '0', `numthreads` mediumint(8) unsigned NOT NULL default '0', `numposts` mediumint(8) unsigned NOT NULL default '0', `lastpostdate` int(11) NOT NULL default '0', `lastpostuser` int(11) unsigned NOT NULL default '0', `forder` smallint(5) NOT NULL default '0', PRIMARY KEY (`id`), KEY `catid` (`catid`) ); CREATE TABLE `forumusers` ( `id` int(10) unsigned NOT NULL auto_increment, `forumid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `flag` tinyint(3) unsigned NOT NULL default '0', `timestamp` int(11) NOT NULL default '0', `expire` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `userid` (`userid`), KEY `forumid` (`forumid`) ); CREATE TABLE `guests` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `ip` varchar(32) NOT NULL default '', `date` int(11) NOT NULL default '0', `lasturl` varchar(100) default NULL, `lastforum` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ); CREATE TABLE `hits` ( `num` int(11) NOT NULL default '0', `user` mediumint(8) NOT NULL default '0', `ip` varchar(15) NOT NULL default '', `date` int(11) NOT NULL default '0', KEY `num` (`num`) ); CREATE TABLE `ipbans` ( `ip` varchar(15) NOT NULL default '', `reason` varchar(100) NOT NULL default '', `perm` tinyint(2) unsigned NOT NULL default '0', `date` int(10) unsigned NOT NULL default '0', `banner` smallint(5) unsigned NOT NULL default '1', UNIQUE KEY `ip` (`ip`) ); CREATE TABLE `itemcateg` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `corder` tinyint(4) NOT NULL default '0', `name` varchar(20) NOT NULL default '', `description` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ); CREATE TABLE `items` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `cat` tinyint(3) unsigned NOT NULL default '0', `type` tinyint(4) unsigned NOT NULL default '0', `name` varchar(30) NOT NULL default '', `stype` varchar(9) NOT NULL default '', `sHP` smallint(5) NOT NULL default '100', `sMP` smallint(5) NOT NULL default '100', `sAtk` smallint(5) NOT NULL default '100', `sDef` smallint(5) NOT NULL default '100', `sInt` smallint(5) NOT NULL default '100', `sMDf` smallint(5) NOT NULL default '100', `sDex` smallint(5) NOT NULL default '100', `sLck` smallint(5) NOT NULL default '100', `sSpd` smallint(5) NOT NULL default '100', `coins` mediumint(8) NOT NULL default '100', PRIMARY KEY (`id`), KEY `cat` (`cat`) ); CREATE TABLE `limbousers` ( `id` smallint(5) unsigned NOT NULL auto_increment, `name` varchar(25) NOT NULL default '', `email` varchar(60) NOT NULL default '', `ip` varchar(15) NOT NULL default '', `password` varchar(32) NOT NULL default '', `regdate` int(10) unsigned NOT NULL default '0', `reminded` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ); CREATE TABLE `misc` ( `views` int(11) unsigned NOT NULL default '0', `hotcount` smallint(5) unsigned default '30', `maxpostsday` mediumint(7) unsigned NOT NULL default '0', `maxpostshour` mediumint(6) unsigned NOT NULL default '0', `maxpostsdaydate` int(10) unsigned NOT NULL default '0', `maxpostshourdate` int(10) unsigned NOT NULL default '0', `maxusers` smallint(5) unsigned NOT NULL default '0', `maxusersdate` int(10) unsigned NOT NULL default '0', `maxuserstext` text ); INSERT INTO `misc` (`views`) VALUES (0); CREATE TABLE `pmsgfolders` ( `user` smallint(5) unsigned NOT NULL default '0', `number` tinyint(3) unsigned NOT NULL default '0', `name` varchar(100) NOT NULL default '', KEY `user` (`user`) ); CREATE TABLE `pmsgs` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `userto` smallint(5) unsigned NOT NULL default '0', `userfrom` smallint(5) unsigned NOT NULL default '0', `date` int(10) unsigned NOT NULL default '0', `ip` char(15) NOT NULL default '', `msgread` tinyint(3) unsigned NOT NULL default '0', `headid` smallint(5) unsigned NOT NULL default '0', `signid` smallint(5) unsigned NOT NULL default '0', `folderto` tinyint(3) unsigned NOT NULL default '1', `folderfrom` tinyint(3) unsigned NOT NULL default '2', PRIMARY KEY (`id`), KEY `userto` (`userto`), KEY `userfrom` (`userfrom`), KEY `msgread` (`msgread`) ); CREATE TABLE `pmsgs_text` ( `pid` mediumint(8) unsigned NOT NULL default '0', `title` varchar(255) NOT NULL default '', `headtext` text NOT NULL, `text` mediumtext NOT NULL, `signtext` text NOT NULL, `tagval` text NOT NULL, PRIMARY KEY (`pid`) ); CREATE TABLE `poll` ( `id` int(11) NOT NULL auto_increment, `question` varchar(255) NOT NULL default '', `briefing` text NOT NULL, `closed` tinyint(1) NOT NULL default '0', `doublevote` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ); CREATE TABLE `poll_choices` ( `id` int(11) NOT NULL auto_increment, `poll` int(11) NOT NULL default '0', `choice` varchar(255) NOT NULL default '', `color` varchar(25) NOT NULL default '', PRIMARY KEY (`id`) ); CREATE TABLE `pollvotes` ( `poll` int(11) NOT NULL default '0', `choice` int(11) NOT NULL default '0', `user` int(11) NOT NULL default '0', UNIQUE KEY `choice` (`choice`,`user`) ); CREATE TABLE `postlayouts` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `text` text NOT NULL, UNIQUE KEY `id` (`id`) ); CREATE TABLE `postradar` ( `user` smallint(5) unsigned NOT NULL default '0', `comp` smallint(5) unsigned NOT NULL default '0', UNIQUE KEY `user` (`user`,`comp`) ); CREATE TABLE `posts` ( `id` mediumint(8) NOT NULL auto_increment, `thread` int(10) unsigned NOT NULL default '0', `user` smallint(5) unsigned NOT NULL default '0', `date` int(10) unsigned NOT NULL default '0', `ip` char(15) NOT NULL default '0.0.0.0', `num` mediumint(8) NOT NULL default '0', `headid` mediumint(8) unsigned NOT NULL default '0', `signid` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `thread` (`thread`), KEY `date` (`date`), KEY `user` (`user`), KEY `ip` (`ip`) ); CREATE TABLE `posts_text` ( `pid` mediumint(8) unsigned NOT NULL default '0', `headtext` text, `text` mediumtext, `signtext` text, `tagval` text, `edited` text, PRIMARY KEY (`pid`) ); CREATE TABLE `ranks` ( `rset` tinyint(3) unsigned NOT NULL default '1', `num` mediumint(8) NOT NULL default '0', `text` varchar(255) NOT NULL default '', KEY `count` (`num`) ); CREATE TABLE `ranksets` ( `id` tinyint(3) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ); CREATE TABLE `schemes` ( `id` smallint(5) unsigned NOT NULL default '0', `ord` smallint(5) NOT NULL default '0', `name` varchar(50) default NULL, `file` varchar(200) default NULL, PRIMARY KEY (`id`) ); CREATE TABLE `threads` ( `id` int(10) unsigned NOT NULL auto_increment, `forum` tinyint(3) unsigned NOT NULL default '0', `user` smallint(5) unsigned NOT NULL default '0', `views` smallint(5) unsigned NOT NULL default '0', `closed` tinyint(1) unsigned NOT NULL default '0', `title` varchar(100) default NULL, `icon` varchar(200) default NULL, `replies` smallint(5) unsigned NOT NULL default '0', `lastpostdate` int(10) NOT NULL default '0', `lastposter` smallint(5) unsigned NOT NULL default '0', `sticky` tinyint(1) unsigned NOT NULL default '0', `poll` smallint(5) unsigned NOT NULL default '0', `locked` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `forum` (`forum`), KEY `user` (`user`), KEY `sticky` (`sticky`), KEY `pollid` (`poll`), KEY `lastpostdate` (`lastpostdate`) ); CREATE TABLE `tlayouts` ( `id` smallint(5) unsigned NOT NULL default '0', `ord` smallint(5) NOT NULL default '0', `name` varchar(50) default NULL, `file` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ); CREATE TABLE `userpic` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `categ` smallint(5) unsigned NOT NULL default '0', `url` varchar(250) NOT NULL default '', `name` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), KEY `categ` (`categ`) ); CREATE TABLE `userpiccateg` ( `id` smallint(5) unsigned NOT NULL default '0', `page` smallint(5) unsigned NOT NULL default '0', `name` varchar(200) NOT NULL default '', PRIMARY KEY (`id`) ); CREATE TABLE `userratings` ( `userfrom` smallint(5) unsigned NOT NULL default '0', `userrated` smallint(5) unsigned NOT NULL default '0', `rating` smallint(5) NOT NULL default '0', KEY `userrated` (`userrated`) ); CREATE TABLE `users` ( `id` smallint(5) unsigned NOT NULL auto_increment, `posts` mediumint(9) NOT NULL default '0', `regdate` int(11) NOT NULL default '0', `name` varchar(25) NOT NULL default '', `password` varchar(32) NOT NULL default '', `minipic` varchar(100) default NULL, `maxipic` varchar(255) NOT NULL default '', `picture` varchar(100) default NULL, `postbg` varchar(250) default NULL, `postheader` text , `signature` text , `bio` text , `powerlevel` tinyint(2) NOT NULL default '0', `sex` tinyint(1) unsigned NOT NULL default '2', `title` varchar(255) default NULL, `useranks` tinyint(1) unsigned NOT NULL default '1', `titleoption` tinyint(1) NOT NULL default '1', `realname` varchar(60) default NULL, `location` varchar(200) default NULL, `birthday` int(11) NOT NULL default '0', `email` varchar(60) default NULL, `aim` varchar(30) default NULL, `icq` int(10) unsigned default NULL, `imood` varchar(60) default NULL, `homepageurl` varchar(80) default NULL, `homepagename` varchar(100) default NULL, `lastposttime` int(10) unsigned NOT NULL default '0', `lastactivity` int(10) unsigned NOT NULL default '0', `lastip` varchar(15) default NULL, `lasturl` varchar(100) default NULL, `lastforum` tinyint(3) unsigned NOT NULL default '0', `postsperpage` smallint(4) unsigned NOT NULL default '20', `threadsperpage` smallint(4) unsigned NOT NULL default '50', `timezone` float NOT NULL default '0', `scheme` tinyint(2) unsigned NOT NULL default '0', `layout` tinyint(2) unsigned NOT NULL default '1', `viewsig` tinyint(1) unsigned NOT NULL default '1', `posttool` tinyint(1) unsigned NOT NULL default '1', `signsep` tinyint(3) unsigned NOT NULL default '0', `publicemail` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`id`), KEY `posts` (`posts`), KEY `name` (`name`), KEY `lastforum` (`lastforum`), KEY `lastposttime` (`lastposttime`), KEY `lastactivity` (`lastactivity`) ); CREATE TABLE `users_rpg` ( `uid` smallint(5) unsigned NOT NULL default '0', `spent` int(11) NOT NULL default '0', `eq1` smallint(5) unsigned NOT NULL default '0', `eq2` smallint(5) unsigned NOT NULL default '0', `eq3` smallint(5) unsigned NOT NULL default '0', `eq4` smallint(5) unsigned NOT NULL default '0', `eq5` smallint(5) unsigned NOT NULL default '0', `eq6` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`uid`) ); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 0, 'Non-poster'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1, 'Newcomer'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 20, '
Goomba'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 10, '
Micro-Goomba'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 35, '
Red Goomba'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 50, '
Red Paragoomba'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 65, '
Paragoomba'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 80, '
Shyguy'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 100, '
Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 120, '
Red Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 140, '
Paratroopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 160, '
Red Paratroopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 180, '
Cheep-cheep'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 200, '
Red Cheep-cheep'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 225, '
Ninji'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 250, '
Flurry'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 275, '
Snifit'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 300, '
Porcupo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 325, '
Panser'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 350, '
Mole'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 375, '
Buzzy Beetle'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 400, '
Nipper Plant'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 425, '
Bloober'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 450, '
Buster Beetle'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 475, '
Beezo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 500, '
Bullet Bill'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 525, '
Rex'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 550, '
Lakitu'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 575, '
Spiny'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 600, '
Bob-Omb'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 700, '
Spike'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 675, '
Pokey'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 650, '
Cobrat'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 725, '
Melon Bug'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 750, '
Lantern Ghost'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 775, '
Fuzzy'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 800, '
Bandit'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 830, '
Super Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 860, '
Red Super Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 900, '
Boo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 925, '
Boo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 950, '
Fuzz Ball'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1000, '
Boomerang Brother'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1050, '
Hammer Brother'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1100, '
Fire Brother'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1150, '
Fire Snake'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1200, '
Giant Goomba'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1250, '
Giant Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1300, '
Giant Red Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1350, '
Giant Paratroopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1400, '
Giant Red Paratroopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1450, '
Chuck'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1500, '
Thwomp'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1550, '
Boss Bass'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1600, '
Volcano Lotus'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1650, '
Lava Lotus'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1700, '
Ptooie'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1800, '
Sledge Brother'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 1900, '
Boomboom'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2000, '
Birdo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2100, '
Red Birdo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2200, '
Green Birdo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2300, '
Larry Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2400, '
Morton Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2500, '
Wendy Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2600, '
Iggy Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2700, '
Roy Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2800, '
Lemmy Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 2900, '
Ludwig Von Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3000, '
Triclyde'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3100, '
Magikoopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3200, '
Wart'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3300, '
Baby Bowser'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3400, '
King Bowser Koopa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3500, '
Yoshi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3600, '
Yellow Yoshi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3700, '
Blue Yoshi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3800, '
Red Yoshi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 3900, '
King Yoshi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4000, '
Baby Mario'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4100, '
Luigi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4200, '
Mario'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4300, '
Super Luigi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4400, '
Super Mario'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4500, '
Fire Luigi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4600, '
Fire Mario'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4700, '
Cape Luigi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4800, '
Cape Mario'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 4900, '
Star Luigi'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 5000, '
Star Mario'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 625, '
Dry Bones'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (1, 10000, 'Climbing the ranks again!'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 0, '
Chicken'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 10, '
Hammer'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 25, '
Double hammer'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 50, '
Stone axe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 80, '
Double stone axe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 130, '
Metal axe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 200, '
Double metal axe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 300, '
Silver axe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 450, '
Double silver axe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 600, '
Gold axe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 800, '
Double gold axe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 1000, '
Metal battleaxe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 1454, '
Metal battleaxe +'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 1946, '
Silver battleaxe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 2431, '
Silver battleaxe +'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 3514, '
Gold battleaxe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 5557, '
Gold battleaxe +'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 6624, '
Purple wand'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 8388607, '
Blue wand'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 8388607, '
Red wand'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (3, 8388607, '
Diamond wand'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 0, 'Non-poster'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1, 'Newcomer'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 20, '
Octorok'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 10, '
Mini Octorok'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 35, '
Blue Octorok'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 50, '
Tektite'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 65, '
Red Tektite'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 80, '
Rat'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 100, '
Rope'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 120, '
Keese'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 140, '
Bee'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 160, '
Octoballoon'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 180, '
Leever'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 200, '
Purple Leever'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 220, '
Sand Crab'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 240, '
Bit'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 260, '
Bot'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 300, '
Cukeman'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 325, '
Slime'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 350, '
Hoarder'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 375, '
Crow'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 400, '
Tendoru'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 425, '
Deddorokku'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 450, '
Geldman'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 475, '
Armos'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 500, '
Zora'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 525, '
Popo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 550, '
Hardhat Beetle'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 575, '
Kodondo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 600, '
Surarok'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 700, '
Raven'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 675, '
Chasupa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 650, '
Sukarurope'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 725, '
Ropa'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 750, '
Zirro'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 775, '
Snap Dragon'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 800, '
Like Like'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 830, '
Poe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 860, '
Moblin'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 900, '
Helmasaur'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 925, '
Onoff'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 950, '
Bubble'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1000, '
Stalfos'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1050, '
Red Stalfos'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1100, '
Yellow Stalfos'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1150, '
Torosu'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1200, '
Red Torosu'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1250, '
Darknut'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1300, '
Iron Knuckle'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1350, '
Vire'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1400, '
Rocklops'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1450, '
Beamos'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1500, '
Wallmaster'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1550, '
Gibdo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1600, '
Wizzrobe'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1650, '
Lynel'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1700, '
Ball and Chain Trooper'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1800, '
Hinox'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 1900, '
Master Stalfos'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2000, '
Aquamentus'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2100, '
Dodongo'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2200, '
Gohma'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2300, '
Gleeok'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2400, '
Digdogger'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2500, '
Manhandla'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2600, '
Armos Knight'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2700, '
Moldorm'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2800, '
Arrghus'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 2900, '
Mothula'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3000, '
Blind'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3100, '
Kholdstare'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3200, '
Vitreous'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3300, '
Dark Link'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3400, '
DethI'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3500, '
Agahnim'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3600, '
Ganon'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3700, '
Zelda'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3800, '
Link'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 3900, '
The Adventure of Link'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4000, '
Link''s Awakening'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4100, '
A Link to the Past'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4200, '
Fighter Link'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4300, '
Blue Mail Link'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4400, '
Red Mail Link'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4500, '
Rabbit Link'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4600, '
Magic Hammer'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4700, '
Cane of Byrna'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4800, '
Hero of Time'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 4900, '
Hero of Winds'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 5000, '
Hero of Hyrule'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 625, '
Bazu'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 10000, 'Climbing the ranks again!'); INSERT INTO `ranks` (`rset`, `num`, `text`) VALUES (2, 280, '
Buzz Blob'); INSERT INTO `ranksets` (`id`, `name`) VALUES (0, 'None'); INSERT INTO `ranksets` (`id`, `name`) VALUES (1, 'Mario'); INSERT INTO `ranksets` (`id`, `name`) VALUES (2, 'Zelda (by Fyxe)'); INSERT INTO `ranksets` (`id`, `name`) VALUES (3, 'GunBound'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (0, 1, 'Daily Cycle', 'dailycycle.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (1, 2, 'ROM Hack Domain', 'romhackdomain.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (2, 3, 'Classic', 'classic.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (3, 4, 'Kafuka!', 'kafuka.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (4, 5, 'Purple', 'purple.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (5, 7, 'Bloodlust', 'bloodlust.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (6, 8, 'End of FF', 'endofff.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (7, 6, 'Mario', 'mario.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (8, 9, 'Circuit', 'dig.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (9, 10, 'Megaman', 'megaman.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (10, 11, 'Test 1', 'neon.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (11, 12, 'NES', 'nes.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (12, 13, 'Christmas', 'xmas.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (13, 14, 'FF9 (by Sir Elric)', 'ff9a.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (14, 3, 'Old blue', 'oldblue.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (15, 15, 'Test 2', 'kirby.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (16, 16, 'Daniversary', 'dani.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (17, 18, 'AE torture', 'aesucks.php'); INSERT INTO `schemes` (`id`, `ord`, `name`, `file`) VALUES (18, 17, 'Night (by Luigi)', 'night.php'); INSERT INTO `tlayouts` (`id`, `ord`, `name`, `file`) VALUES (1, 0, 'Regular', 'regular'); INSERT INTO `tlayouts` (`id`, `ord`, `name`, `file`) VALUES (2, 1, 'Regular without number/bar graphics', 'regular'); INSERT INTO `tlayouts` (`id`, `ord`, `name`, `file`) VALUES (3, 2, 'Compact', 'compact'); INSERT INTO `tlayouts` (`id`, `ord`, `name`, `file`) VALUES (4, 4, 'UBB-like', 'ubb'); INSERT INTO `tlayouts` (`id`, `ord`, `name`, `file`) VALUES (5, 3, 'EZBoard-like', 'ezboard'); INSERT INTO `tlayouts` (`id`, `ord`, `name`, `file`) VALUES (6, 5, 'VBB-like', 'vbb'); INSERT INTO `tlayouts` (`id`, `ord`, `name`, `file`) VALUES (7, 6, 'RPG', 'rpg');