-- http://www.phpmyadmin.net
--


--
-- Database: `multiuserserverdb`
--

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

--
-- Table structure for table `badges`
--

CREATE TABLE `badges` (
  `Name` text NOT NULL,
  `HabboID` bigint(20) NOT NULL,
  `ID` bigint(20) NOT NULL auto_increment,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `badges`
--

INSERT INTO `badges` (`Name`, `HabboID`, `ID`) VALUES
('VA1', 1, 2);

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

--
-- Table structure for table `bans`
--

CREATE TABLE `bans` (
  `ID` int(11) NOT NULL auto_increment,
  `IP` text NOT NULL COMMENT 'IP address Of Ban',
  `Expire` text NOT NULL COMMENT 'Date/Time ban expires',
  `Reason` text NOT NULL COMMENT 'Reason for ban',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `bans`
--


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

--
-- Table structure for table `catalogue`
--

CREATE TABLE `catalogue` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` text NOT NULL,
  `Level` int(11) NOT NULL,
  `Other` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `catalogue`
--

INSERT INTO `catalogue` (`ID`, `Name`, `Level`, `Other`) VALUES
(1, 'Frontpage', 1, 'l:ctlg_frontpage2\r\ns:Need some Funky Furni for your Habbo room?\r\nh:Need some Furni for your Habbo room?  Well, youre in the right place!  This Catalogue is packed FULL of funky Furni, just click the tabs on the right to browse.<br><br>We regularly add and remove Furni, so check back regularly for new items.<br><br>\r\ng:catal_fp_header\r\nw:Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur?\r\nt1:You need Habbo Credits to buy Furni for your room, click the Purse at the bottom of your screen for more information about Credits.\r\ne:catal_fp_pic4,catal_fp_pic5,'),
(2, 'Staff Page', 8, 'l:ctlg_layout2\r\nw:Item Header\r\ng:catalog_rares_headline1\r\nh:Heading\r\ne:ctlg_norare_char1,\r\ns:2:Saying'),
(3, 'Spaces', 1, 'l:ctlg_spaces\r\nt1:Wall\r\nt2:Floor\r\nt3:Pattern\r\nt4:Colour\r\ng:catalog_spaces_headline1\r\nt5:Pattern\r\nt6:Colour\r\nh:Are your walls looking a little grey?  What you need is a splash of paint and this is the place to get it!  <br>A splash of colour on the walls and a nice carpet can make all the difference. Use our virtual room below to test out the combinations before you buy. \r\nt7:Preview\r\ne:\r\n'),
(4, 'Posters', 1, 'l:ctlg_layout2\r\ns:2: Brighten up your walls!\r\nw:Click on the item you want for more information.\r\ng:catalog_gallery_headline1\r\nh:Adorn your walls with wondrous works of art, posters, plaques and wall hangings. We have items to suit all tastes, from kitsch to cool, traditional to modern.\r\ne:catalog_posters_teaser1,'),
(6, 'Mood Light', 1, 'l:ctlg_productpage1\r\ns:\r\nh:Get a little bit personal with this new Mood light\r\ng:catalog_rares_headline1\r\nt1:Oh my god!\r\nw:\r\ne:'),
(7, 'The Bank', 1, 'l:ctlg_layout2\r\ng:catalog_bank_headline1\r\nw:Click on an item to see more details\r\ns:Refundable goods!\r\nh:The Habbo Exchange is where you can convert your Habbo Credits into a tradable currency. You can use this tradable currency to exchange Habbo Credits for Furni!\r\ne:catalog_bank_teaser,'),
(8, 'Recycler', 1, 'l:ctlg_recycler\r\ng:catalog_recycler_headline1\r\ne:'),
(9, 'Random', 1, 'l:ctlg_layout2\r\nw:Item Header');

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

--
-- Table structure for table `cataloguedeals`
--

CREATE TABLE `cataloguedeals` (
  `Deal` text NOT NULL,
  `ItemSprite` text NOT NULL,
  `Amount` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cataloguedeals`
--

INSERT INTO `cataloguedeals` (`Deal`, `ItemSprite`, `Amount`) VALUES
('deal1', 'rare_daffodil_rug', 28),
('deal1', 'throne', 1),
('deal1', 'roomdimmer', 1),
('deal_test', 'throne', 2),
('deal_test', 'rare_daffodil_rug', 28),
('deal_test', 'roomdimmer', 1);

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

--
-- Table structure for table `catalogueitems`
--

CREATE TABLE `catalogueitems` (
  `ID` int(11) NOT NULL auto_increment,
  `Sprite` text NOT NULL,
  `Description` text NOT NULL,
  `Price` int(11) NOT NULL,
  `Page` text NOT NULL,
  `ShowName` text NOT NULL,
  `Type` int(11) NOT NULL default '1' COMMENT '1 = Furniture 2 = Poster 3 = Deal',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;

--
-- Dumping data for table `catalogueitems`
--

INSERT INTO `catalogueitems` (`ID`, `Sprite`, `Description`, `Price`, `Page`, `ShowName`, `Type`) VALUES
(1, 'throne', 'Very Important? Pfft.', 10, 'Staff Page', 'Throne', 1),
(2, 'poster 18', 'Aint it pretty?', 5, 'Staff Page', 'Butterfly Poster', 2),
(14, 'floor', 'Floor', 2, 'Spaces', 'floor', 2),
(9, 'md_rug', 'Rugtastic', 1, 'Staff Page', 'Bubble Rug', 1),
(5, 'poster 14', 'A cunning painting', 3, 'Posters', 'Fox Poster', 2),
(8, 'roomdimmer', 'Moody..', 4, 'Mood Light', 'Mood Light', 2),
(10, 'md_can', 'Its a can!', 3, 'Posters', 'Bubblejuice Can', 2),
(11, 'md_logo_wall', 'Yay!', 2, 'Posters', 'Awesomeness', 2),
(12, 'divider_arm2', 'Lodge Divider', 1, 'Staff Page', 'Lodge Divider', 1),
(13, 'scifiport*3', 'Loverly', 2, 'Staff Page', 'Jade Laser Gate', 1),
(56, 'CF_1_coin_bronze', 'Worth 1 Credit', 1, 'The Bank', 'Bronze Coin', 1),
(55, 'divider_arm1', 'Cornertastic', 1, 'Random', 'Lodge Corner', 1),
(54, 'divider_arm3', 'Doortastic', 2, 'Random', 'Lodge Door', 1),
(23, 'wallpaper 1', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(24, 'wallpaper 2', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(25, 'wallpaper 3', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(26, 'wallpaper 4', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(27, 'wallpaper 5', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(28, 'wallpaper 6', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(29, 'wallpaper 7', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(30, 'wallpaper 8', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(31, 'wallpaper 9', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(32, 'wallpaper 10', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(33, 'wallpaper 11', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(34, 'wallpaper 12', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(35, 'wallpaper 13', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(36, 'wallpaper 14', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(37, 'wallpaper 15', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(38, 'wallpaper 16', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(39, 'wallpaper 17', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(40, 'wallpaper 18', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(41, 'wallpaper 19', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(42, 'wallpaper 20', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(43, 'wallpaper 21', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(44, 'wallpaper 22', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(45, 'wallpaper 23', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(46, 'wallpaper 24', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(47, 'wallpaper 25', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(48, 'wallpaper 26', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(49, 'wallpaper 27', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(50, 'wallpaper 28', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(51, 'wallpaper 29', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(52, 'wallpaper 30', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(53, 'wallpaper 31', 'wallpaper', 2, 'Spaces', 'wallpaper', 2),
(57, 'CF_5_coin_silver', 'Worth 5 Credits', 5, 'The Bank', 'Silver Coin', 1),
(59, 'CF_10_coin_gold', 'Worth 10 Credits', 10, 'The Bank', 'Gold Coin', 1),
(61, 'CF_20_moneybag', 'Worth 20 Credits', 20, 'The Bank', 'Money Sack', 1),
(62, 'CF_50_goldbar', 'Worth 50 Credits', 50, 'The Bank', 'Gold Bar', 1),
(64, 'deal1', 'Because lets face it - Its all leet.', 2, 'Staff Page', 'Leet Pack', 3),
(65, 'doorD', 'Teleport in style', 1, 'Staff Page', 'Imperial Teleporter', 4),
(66, 'deal_test', 'Sexy Stuff', 5, 'Random', 'The Deal of a Lifetime', 3),
(67, 'divider_arm2', 'Lodge', 1, 'Random', 'Lodge Divider Name', 1);

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

--
-- Table structure for table `chatlogs`
--

CREATE TABLE `chatlogs` (
  `RoomID` int(11) NOT NULL,
  `Value` text NOT NULL,
  `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `chatlogs`
--

INSERT INTO `chatlogs` (`RoomID`, `Value`, `LastUpdated`) VALUES
(6, '<strong><FONT COLOR="#3E3725"><strong>Jeax</strong></font> Shouted: lol</strong></br><strong><FONT COLOR="#3E3725"><strong>Jeax</strong></font> Shouted: LOL</strong></br><strong><FONT COLOR="#3E3725"><strong>Jeax</strong></font> Shouted: OMG LOOOOOOOOOL :)</strong></br><strong><FONT COLOR="#3E3725"><strong>Jeax</strong></font> Shouted: :)</strong></br><strong><FONT COLOR="#3E3725"><strong>Jeax</strong></font> Shouted: :ban Jeax 3000 LOL SOZ</strong></br><strong><FONT COLOR="#64C641"><strong>Myrax</strong></font> Shouted: Hi ^^</strong></br><strong><FONT COLOR="#3E3725"><strong>Jeax</strong></font> Shouted: Don''t click yourself</strong></br>', '2008-03-17 16:10:47');

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

--
-- Table structure for table `consolemsgs`
--

CREATE TABLE `consolemsgs` (
  `ID` int(11) NOT NULL auto_increment,
  `toid` int(11) NOT NULL,
  `fromid` int(11) NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `consolemsgs`
--


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

--
-- Table structure for table `friendrequests`
--

CREATE TABLE `friendrequests` (
  `ID` int(11) NOT NULL auto_increment,
  `habboid` int(11) NOT NULL,
  `requesterid` int(11) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `friendrequests`
--


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

--
-- Table structure for table `friendslist`
--

CREATE TABLE `friendslist` (
  `habboid` int(11) NOT NULL,
  `friendid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `friendslist`
--


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

--
-- Table structure for table `furniture`
--

CREATE TABLE `furniture` (
  `ID` int(11) NOT NULL auto_increment,
  `sprite` text NOT NULL,
  `roomid` int(11) NOT NULL,
  `ownerid` int(11) NOT NULL,
  `x` tinyint(4) NOT NULL,
  `y` tinyint(4) NOT NULL,
  `height` tinyint(4) NOT NULL,
  `pathfindvalue` int(11) NOT NULL default '-1',
  `rotation` int(11) NOT NULL,
  `status` text NOT NULL,
  `teleportID` int(11) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=361 ;

--
-- Dumping data for table `furniture`
--

INSERT INTO `furniture` (`ID`, `sprite`, `roomid`, `ownerid`, `x`, `y`, `height`, `pathfindvalue`, `rotation`, `status`, `teleportID`) VALUES
(5, 'md_limukaappi', 6, 1, 10, 4, 0, -1, 4, 'TRUE', 0),
(7, 'md_limukaappi', 6, 1, 11, 1, 0, -1, 4, 'TRUE', 0),
(18, 'throne', 6, 1, 10, 1, 0, 1, 4, '', 0),
(35, 'throne', 6, 1, 5, 1, 0, 1, 4, '', 0),
(37, 'throne', 6, 1, 9, 1, 0, 1, 4, '', 0),
(39, 'md_rug', 6, 1, 6, 7, 0, 0, 0, '', 0),
(43, 'throne', 6, 1, 7, 1, 0, 1, 4, '', 0),
(44, 'throne', 6, 1, 6, 1, 0, 1, 4, '', 0),
(45, 'throne', 6, 1, 4, 2, 0, 1, 2, '', 0),
(46, 'throne', 6, 1, 8, 1, 0, 1, 4, '', 0),
(50, 'divider_arm3', 6, 1, 11, 4, 0, -1, 0, 'C', 0),
(52, 'scifiport*3', 6, 1, 4, 5, 0, 0, 6, 'O', 0),
(53, 'throne', 6, 1, 4, 3, 0, 1, 2, '', 0),
(67, 'divider_arm2', 6, 1, 6, 4, 0, -1, 0, '', 0),
(59, 'divider_arm3', 6, 1, 5, 4, 0, -1, 0, 'C', 0),
(64, 'divider_arm2', 6, 1, 8, 4, 0, -1, 0, '', 0),
(70, 'divider_arm1', 6, 1, 4, 4, 0, -1, 0, '', 0),
(71, 'divider_arm1', 16, 1, 6, 3, 0, -1, 0, '', 0),
(75, 'CF_50_goldbar', 6, 1, 4, 12, 0, -1, 0, '20', 0),
(76, 'CF_50_goldbar', 6, 1, 4, 13, 0, -1, 0, '20', 0),
(77, 'CF_20_moneybag', 6, 1, 4, 11, 0, -1, 0, '20', 0),
(78, 'CF_10_coin_gold', 6, 1, 4, 10, 0, -1, 0, '10', 0),
(79, 'CF_5_coin_silver', 6, 1, 4, 9, 0, -1, 0, '5', 0),
(80, 'CF_1_coin_bronze', 6, 1, 4, 9, 0, -1, 0, '1', 0),
(173, 'doorD', 16, 1, 5, 4, 0, -1, 2, 'FALSE', 174),
(174, 'doorD', 6, 1, 4, 1, 0, -1, 2, 'FALSE', 173);

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

--
-- Table structure for table `furniturestatic`
--

CREATE TABLE `furniturestatic` (
  `sprite` text NOT NULL,
  `colour` text NOT NULL,
  `DefaultStatus` text NOT NULL,
  `length` int(11) NOT NULL,
  `width` int(11) NOT NULL,
  `pathfindvalue` int(11) NOT NULL default '-1',
  `stackable` int(11) NOT NULL COMMENT '1 For Stackable',
  `stackheight` double NOT NULL,
  `isRecyclable` tinyint(1) NOT NULL default '1' COMMENT '1 if it is'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `furniturestatic`
--

INSERT INTO `furniturestatic` (`sprite`, `colour`, `DefaultStatus`, `length`, `width`, `pathfindvalue`, `stackable`, `stackheight`, `isRecyclable`) VALUES
('throne', '0,0,0', '', 1, 1, 1, 0, 0, 1),
('noob_chair*5', '#FFFFFF,#F6C0C0,#F6C0C0,#FFFFFF,#F6C0C0,#F6C0C0', '', 1, 1, 1, 0, 0, 0),
('club_sofa', '', '', 2, 1, 1, 0, 0, 1),
('noob_rug*1', 'FC9C45,#F4EC360', '', 2, 3, 0, 0, 0, 0),
('md_limukaappi', '', '', 1, 1, -1, 0, 0, 1),
('md_rug', '0,0,0,0', '', 4, 4, 0, 0, 0, 1),
('divider_arm3', '0,0,0', 'C', 1, 1, -1, 0, 0, 1),
('scifiport*3', '#ffffff,#55CD01,#ffffff,#ffffff,#ffffff,#55CD01', 'C', 1, 1, -1, 0, 0, 1),
('divider_arm2', '0,0,0', '', 2, 1, -1, 0, 0, 1),
('divider_arm1', '0,0,0', '', 1, 1, -1, 0, 0, 1),
('CF_1_coin_bronze', '0,0,0', '1', 1, 1, -1, 1, 0.3, 0),
('CF_5_coin_silver', '0,0,0', '5', 1, 1, -1, 1, 0.3, 0),
('CF_10_coin_gold', '0,0,0', '10', 1, 1, -1, 1, 0.3, 0),
('CF_20_moneybag', '0,0,0', '20', 1, 1, -1, 1, 1, 0),
('CF_50_goldbar', '0,0,0', '50', 1, 1, -1, 1, 0.5, 0),
('rare_daffodil_rug', '0,0,0', '', 2, 2, 0, 0, 0, 1),
('petfood3', '0,0,0', '', 0, 0, 0, 0, 0, 0),
('doorD', '0,0,0', '', 1, 1, -1, 0, 0, 0);

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

--
-- Table structure for table `fuserights`
--

CREATE TABLE `fuserights` (
  `ID` mediumint(9) NOT NULL auto_increment,
  `level` tinyint(2) NOT NULL,
  `right` text NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `fuserights`
--

INSERT INTO `fuserights` (`ID`, `level`, `right`) VALUES
(1, 5, 'jase_alert'),
(12, 6, 'jase_roomalert'),
(3, 2, 'fuse_use_special_room_layouts'),
(4, 2, 'fuse_furni_chooser'),
(5, 7, 'fuse_see_flat_ids'),
(6, 5, 'fuse_ignore_room_owner'),
(7, 1, 'fuse_performance_panel'),
(8, 2, 'fuse_use_club_dance'),
(9, 5, 'jase_kick'),
(10, 6, 'jase_ban'),
(11, 5, 'housekeeping_hobba_newbietools'),
(13, 5, 'fuse_kick'),
(14, 5, 'fuse_enter_locked_rooms');

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

--
-- Table structure for table `habbobans`
--

CREATE TABLE `habbobans` (
  `HabboID` bigint(20) NOT NULL,
  `Expire` text NOT NULL,
  `Reason` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `habbobans`
--

INSERT INTO `habbobans` (`HabboID`, `Expire`, `Reason`) VALUES
(132, '21/03/2008 02:47:46', 'Lol'),
(133, '21/03/2008 04:01:56', 'sfsdff');

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `ID` int(11) NOT NULL auto_increment,
  `sprite` text NOT NULL,
  `x` int(11) NOT NULL,
  `y` int(11) NOT NULL,
  `z` int(11) NOT NULL,
  `pathfindvalue` int(11) NOT NULL default '-1',
  `roomid` int(11) NOT NULL,
  `rotation` int(11) NOT NULL,
  `variable` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=245 ;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`ID`, `sprite`, `x`, `y`, `z`, `pathfindvalue`, `roomid`, `rotation`, `variable`) VALUES
(1, 'crl_lamp', 16, 0, 0, -1, 1, 0, ''),
(2, 'crl_sofa2c', 17, 0, 0, 1, 1, 4, ''),
(3, 'crl_sofa2b', 18, 0, 0, 1, 1, 4, ''),
(4, 'crl_sofa2a', 19, 0, 0, 1, 1, 4, ''),
(5, 'crl_desk1a', 8, 15, 0, -1, 1, 0, ''),
(6, 'crl_deski', 9, 15, 0, -1, 1, 0, ''),
(7, 'crl_deskh', 10, 15, 0, -1, 1, 0, ''),
(8, 'crl_deskg', 10, 16, 0, -1, 1, 0, ''),
(9, 'crl_deskf', 10, 17, 0, -1, 1, 0, ''),
(10, 'crl_deskf', 10, 17, 0, -1, 1, 0, ''),
(11, 'crl_deske', 10, 18, 0, -1, 1, 0, ''),
(12, 'crl_deske', 10, 19, 0, -1, 1, 0, ''),
(13, 'crl_deske', 10, 19, 0, -1, 1, 0, ''),
(14, 'crl_deske', 10, 20, 0, -1, 1, 0, ''),
(15, 'crl_deske', 10, 21, 0, -1, 1, 0, ''),
(16, 'crl_deske', 10, 22, 0, -1, 1, 0, ''),
(17, 'crl_deske', 10, 23, 0, -1, 1, 0, ''),
(18, 'crl_deske', 10, 24, 0, -1, 1, 0, ''),
(19, 'crl_wallb', 7, 24, 0, -1, 1, 0, ''),
(20, 'crl_walla', 7, 25, 0, -1, 1, 0, ''),
(21, 'crl_desk1b', 8, 25, 0, -1, 1, 0, ''),
(22, 'crl_desk1c', 9, 25, 0, -1, 1, 0, ''),
(23, 'crl_desk1d', 10, 25, 0, -1, 1, 0, ''),
(24, 'crl_cabinet2', 13, 27, 0, -1, 1, 0, ''),
(25, 'crl_cabinet1', 14, 27, 0, -1, 1, 0, ''),
(26, 'crl_chair', 9, 20, 0, 1, 1, 2, ''),
(27, 'crl_lamp', 16, 0, 0, -1, 1, 0, ''),
(29, 'crl_lamp', 20, 0, 0, -1, 1, 0, ''),
(30, 'crl_lamp', 7, 2, 0, -1, 1, 0, ''),
(31, 'crl_lamp', 11, 2, 0, -1, 1, 0, ''),
(32, 'crl_pillar', 5, 3, 0, -1, 1, 0, ''),
(33, 'crl_table1b', 9, 3, 0, -1, 1, 0, ''),
(34, 'crl_table2a', 20, 3, 0, -1, 1, 0, ''),
(35, 'crl_lamp', 0, 4, 0, -1, 1, 0, ''),
(36, 'crl_lamp', 4, 4, 0, -1, 1, 0, ''),
(37, 'crl_table1a', 9, 4, 0, -1, 1, 0, ''),
(38, 'crl_table2b', 2, 6, 0, -1, 1, 0, ''),
(39, 'crl_table2a', 3, 6, 0, -1, 1, 0, ''),
(40, 'crl_lamp', 11, 6, 0, -1, 1, 0, ''),
(41, 'crl_lamp', 0, 8, 0, -1, 1, 0, ''),
(42, 'crl_lamp', 4, 8, 0, -1, 1, 0, ''),
(43, 'crl_pillar2', 5, 9, 0, -1, 1, 0, ''),
(44, 'crl_pillar', 9, 9, 0, -1, 1, 0, ''),
(45, 'crl_lamp2', 15, 27, 0, -1, 1, 0, ''),
(46, 'crl_sofa2c', 17, 0, 0, 1, 1, 0, ''),
(47, 'crl_sofa2b', 18, 0, 0, 1, 1, 0, ''),
(48, 'crl_sofa2a', 19, 0, 0, 1, 1, 0, ''),
(49, 'crl_chair', 16, 1, 0, 1, 1, 0, ''),
(50, 'crl_chair', 16, 2, 0, 1, 1, 0, ''),
(51, 'crl_chair', 7, 3, 0, 1, 1, 0, ''),
(52, 'crl_sofa1c', 11, 3, 0, 1, 1, 0, ''),
(53, 'crl_chair', 16, 3, 0, 1, 1, 0, ''),
(54, 'crl_sofa2c', 1, 4, 0, 1, 1, 0, ''),
(55, 'crl_sofa2b', 2, 4, 0, -1, 1, 0, ''),
(56, 'crl_sofa2a', 3, 4, 0, 1, 1, 0, ''),
(57, 'crl_sofa1b', 11, 4, 0, 1, 1, 0, ''),
(58, 'crl_chair', 0, 5, 0, 1, 1, 0, ''),
(59, 'crl_chair', 7, 5, 0, 1, 1, 0, ''),
(60, 'crl_sofa1a', 11, 5, 0, -1, 1, 0, ''),
(61, 'crl_lamp', 11, 6, 0, -1, 1, 0, ''),
(62, 'crl_chair', 0, 7, 0, 1, 1, 0, ''),
(63, 'crl_sofa3c', 1, 8, 0, 1, 1, 0, ''),
(64, 'crl_sofa3b', 2, 8, 0, 1, 1, 0, ''),
(65, 'crl_sofa3a', 3, 8, 0, 1, 1, 0, ''),
(66, 'crl_barchair2', 19, 8, 0, -1, 1, 0, ''),
(67, 'crl_barchair2', 21, 8, 0, 1, 1, 0, ''),
(0, 'crl_wall2a', 15, 4, 0, -1, 1, 0, ''),
(216, 'gold_chair', 2, 17, 1, 1, 23, 0, ''),
(215, 'gold_chair', 1, 17, 1, 1, 23, 0, ''),
(214, 'gold_plant', 0, 17, 1, -1, 23, 0, ''),
(213, 'gold_table_small2', 15, 16, 1, -1, 23, 0, ''),
(212, 'gold_table_small1', 14, 16, 1, -1, 23, 0, ''),
(211, 'gold_chair', 0, 16, 1, 1, 23, 2, ''),
(210, 'gold_table_small2', 3, 15, 1, -1, 23, 0, ''),
(209, 'gold_table_small1', 2, 15, 1, -1, 23, 0, ''),
(208, 'gold_chair', 0, 15, 1, 1, 23, 2, ''),
(207, 'gold_chair', 15, 14, 1, 1, 23, 4, ''),
(206, 'gold_chair', 14, 14, 1, 1, 23, 4, ''),
(205, 'gold_chair', 0, 14, 1, 1, 23, 2, ''),
(204, 'gold_chair', 15, 13, 1, 1, 23, 0, ''),
(203, 'gold_chair', 14, 13, 1, 1, 23, 0, ''),
(202, 'gold_chair', 3, 13, 1, 1, 23, 4, ''),
(201, 'gold_chair', 2, 13, 1, 1, 23, 4, ''),
(200, 'gold_chair', 1, 13, 1, 1, 23, 4, ''),
(199, 'gold_plant', 0, 13, 1, -1, 23, 0, ''),
(198, 'gold_chair', 20, 12, 1, 1, 23, 0, ''),
(197, 'gold_chair', 19, 12, 1, 1, 23, 0, ''),
(196, 'gold_chair', 3, 12, 1, 1, 23, 0, ''),
(195, 'gold_chair', 2, 12, 1, 1, 23, 0, ''),
(194, 'gold_chair', 1, 12, 1, 1, 23, 0, ''),
(193, 'gold_plant', 0, 12, 1, -1, 23, 0, ''),
(192, 'gold_table_small2', 15, 11, 1, -1, 23, 0, ''),
(191, 'gold_table_small1', 14, 11, 1, -1, 23, 0, ''),
(190, 'gold_table_small2', 20, 10, 1, -1, 23, 0, ''),
(189, 'gold_table_small1', 19, 10, 1, -1, 23, 0, ''),
(188, 'gold_chair', 15, 9, 1, 1, 23, 4, ''),
(187, 'gold_chair', 14, 9, 1, 1, 23, 4, ''),
(186, 'gold_chair', 2, 9, 1, 1, 23, 6, ''),
(185, 'gold_table_small2', 1, 9, 1, -1, 23, 6, ''),
(184, 'gold_chair', 0, 9, 1, 1, 23, 2, ''),
(183, 'gold_chair', 20, 8, 1, 1, 23, 4, ''),
(182, 'gold_chair', 19, 8, 1, 1, 23, 4, ''),
(181, 'gold_chair', 2, 8, 1, 1, 23, 6, ''),
(180, 'gold_table_small1', 1, 8, 1, -1, 23, 6, ''),
(179, 'gold_chair', 0, 8, 1, 1, 23, 2, ''),
(178, 'gold_chair', 7, 7, 1, 1, 23, 6, ''),
(177, 'gold_table_small2', 6, 7, 1, -1, 23, 6, ''),
(176, 'gold_chair', 5, 7, 1, 1, 23, 2, ''),
(175, 'gold_chair', 7, 6, 1, 1, 23, 6, ''),
(174, 'gold_table_small1', 6, 6, 1, -1, 23, 6, ''),
(173, 'gold_chair', 5, 6, 1, 1, 23, 2, ''),
(172, 'gold_chair', 2, 6, 1, 1, 23, 6, ''),
(171, 'gold_table_small2', 1, 6, 1, -1, 23, 6, ''),
(170, 'gold_chair', 0, 6, 1, 1, 23, 2, ''),
(169, 'gold_chair', 2, 5, 1, 1, 23, 6, ''),
(168, 'gold_table_small1', 1, 5, 1, -1, 23, 6, ''),
(167, 'gold_chair', 0, 5, 1, 1, 23, 2, ''),
(166, 'gold_chair', 7, 4, 1, 1, 23, 6, ''),
(165, 'gold_table_small2', 6, 4, 1, -1, 23, 6, ''),
(164, 'gold_chair', 5, 4, 1, 1, 23, 2, ''),
(163, 'gold_bardesk1', 14, 3, 1, -1, 23, 0, ''),
(162, 'gold_bardesk2', 13, 3, 1, -1, 23, 0, ''),
(161, 'gold_bardesk3', 12, 3, 1, -1, 23, 0, ''),
(160, 'gold_bardesk4', 11, 3, 1, -1, 23, 0, ''),
(159, 'gold_bardesk5', 10, 3, 1, -1, 23, 0, ''),
(158, 'gold_chair', 7, 3, 1, 1, 23, 6, ''),
(157, 'gold_table_small1', 6, 3, 1, -1, 23, 6, ''),
(156, 'gold_chair', 5, 3, 1, 1, 23, 2, ''),
(217, 'gold_chair', 3, 17, 1, 1, 23, 0, ''),
(218, 'gold_plant', 0, 18, 1, -1, 23, 0, ''),
(219, 'gold_chair', 1, 18, 1, 1, 23, 4, ''),
(220, 'gold_chair', 2, 18, 1, 1, 23, 4, ''),
(221, 'gold_chair', 3, 18, 1, 1, 23, 4, ''),
(222, 'gold_chair', 14, 18, 1, 1, 23, 0, ''),
(223, 'gold_chair', 15, 18, 1, 1, 23, 0, ''),
(224, 'gold_chair', 0, 19, 1, 1, 23, 2, ''),
(225, 'gold_chair', 0, 20, 1, 1, 23, 2, ''),
(226, 'gold_table_small1', 2, 20, 1, -1, 23, 0, ''),
(227, 'gold_table_small2', 3, 20, 1, -1, 23, 0, ''),
(228, 'gold_chair', 0, 21, 1, 1, 23, 2, ''),
(229, 'gold_plant', 0, 22, 1, -1, 23, 0, ''),
(230, 'gold_chair', 1, 22, 1, 1, 23, 0, ''),
(231, 'gold_chair', 2, 22, 1, 1, 23, 0, ''),
(232, 'gold_chair', 3, 22, 1, 1, 23, 0, ''),
(233, 'gold_plant', 0, 23, 1, -1, 23, 0, ''),
(234, 'gold_chair', 1, 23, 1, 1, 23, 4, ''),
(235, 'gold_chair', 2, 23, 1, 1, 23, 4, ''),
(236, 'gold_chair', 3, 23, 1, 1, 23, 4, ''),
(237, 'gold_chair', 0, 24, 1, 1, 23, 2, ''),
(238, 'gold_chair', 0, 25, 1, 1, 23, 2, ''),
(239, 'gold_table_small1', 2, 25, 1, -1, 23, 0, ''),
(240, 'gold_table_small2', 3, 25, 1, -1, 23, 0, ''),
(241, 'gold_chair', 0, 26, 1, 1, 23, 2, ''),
(242, 'gold_chair', 1, 27, 1, 1, 23, 0, ''),
(243, 'gold_chair', 2, 27, 1, 1, 23, 0, ''),
(244, 'gold_chair', 3, 27, 1, 1, 23, 0, '');

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

--
-- Table structure for table `levelbadges`
--

CREATE TABLE `levelbadges` (
  `ID` tinyint(11) NOT NULL auto_increment,
  `Badge` text NOT NULL,
  `Level` tinyint(2) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `levelbadges`
--

INSERT INTO `levelbadges` (`ID`, `Badge`, `Level`) VALUES
(1, 'ADM', 7),
(2, 'HBA', 6),
(3, 'NWB', 5),
(4, 'XXX', 4),
(5, 'HC2', 3),
(6, 'HC1', 2);

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

--
-- Table structure for table `moderationlogs`
--

CREATE TABLE `moderationlogs` (
  `ID` bigint(20) NOT NULL auto_increment,
  `Type` text NOT NULL,
  `ModID` bigint(20) NOT NULL,
  `HabboID/Username` text NOT NULL,
  `Value` text NOT NULL,
  `Comments` text NOT NULL,
  `Added` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `moderationlogs`
--

INSERT INTO `moderationlogs` (`ID`, `Type`, `ModID`, `HabboID/Username`, `Value`, `Comments`, `Added`) VALUES
(1, 'Alert', 1, 'Jeax', ' Test', '', '2008-03-05 13:54:42'),
(2, 'Alert', 1, 'Jeax', ' LOL', '', '2008-03-17 14:55:04'),
(3, 'Alert', 1, 'Jeax', ' wheee', '', '2008-03-17 14:55:09'),
(4, 'Alert', 1, '84', ' Your level was updated from 1 to `8` - please Reload', '', '2008-03-18 01:35:08'),
(5, 'HotelAlert', 1, '', '', '', '2008-03-18 01:35:44'),
(6, 'HotelAlert', 1, '', 'Roflwaffle that coffle 4 shoffle', '', '2008-03-18 01:35:57'),
(7, 'Ban', 1, '-1', '0 || Whatever Reason here |', '', '2008-03-18 01:37:59'),
(8, 'Ban', 84, '-1', '0 || asshole', '', '2008-03-18 01:40:43'),
(9, 'HotelAlert', 1, '', '-Goes to bed-', '', '2008-03-18 03:38:34'),
(10, 'Alert', 1, '1', ' lolz', '', '2008-03-18 16:24:53'),
(11, 'HotelAlert', 1, '', 'o/', '', '2008-03-19 19:14:45'),
(12, 'HotelAlert', 1, '', 'o/', '', '2008-03-19 19:15:55'),
(13, 'HotelAlert', 1, '', 'Server was paused for a second - Obv.', '', '2008-03-19 22:38:16'),
(14, 'HotelAlert', 1, '', 'Search Jeax', '', '2008-03-19 23:02:28'),
(15, 'HotelAlert', 1, '', ':disco Time(Seconds) & :disco stop', '', '2008-03-19 23:14:57'),
(16, 'HotelAlert', 1, '', 'Hello :o', '', '2008-03-19 23:33:07'),
(17, 'HotelAlert', 1, '', 'Development mode - Enabled.', '', '2008-03-19 23:51:31'),
(18, 'Alert', 1, '85', ' ?', '', '2008-03-20 02:38:41'),
(19, 'RoomAlert', 85, '', 'x wat', '', '2008-03-20 02:38:48'),
(20, 'Alert', 1, '1', ' Lol', '', '2008-03-20 02:39:14'),
(21, 'RoomAlert', 85, '', 'LOL FROGGER WHAT IS GOING ON HERE', '', '2008-03-20 02:39:20'),
(22, 'HotelAlert', 1, '', 'LOL', '', '2008-03-20 02:39:24'),
(23, 'RoomAlert', 1, '', '\r\r\r', '', '2008-03-20 02:39:29'),
(24, 'RoomAlert', 85, '', '\r\r\r\r\r\r\r\r\r\r\r\r\r\r\r\r\r\r\r\r\r\rhey', '', '2008-03-20 02:39:47'),
(25, 'RoomAlert', 1, '', 'x01B!LOL', '', '2008-03-20 02:40:00'),
(26, 'RoomAlert', 1, '', 'x01 LOL', '', '2008-03-20 02:40:08'),
(27, 'RoomAlert', 1, '', '/x01B!LOL', '', '2008-03-20 02:40:29'),
(28, 'RoomAlert', 85, '', '	hi', '', '2008-03-20 02:40:45'),
(29, 'Ban', 1, '-1', '2 || Lol', '', '2008-03-21 00:47:46'),
(30, 'HotelAlert', 1, '', '', '', '2008-03-21 03:00:29');

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

--
-- Table structure for table `posters`
--

CREATE TABLE `posters` (
  `ID` int(11) NOT NULL auto_increment,
  `sprite` text NOT NULL,
  `width` text NOT NULL,
  `length` text NOT NULL,
  `rotation` text NOT NULL,
  `custom` text NOT NULL,
  `roomid` int(11) NOT NULL,
  `ownerid` int(11) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=116 ;

--
-- Dumping data for table `posters`
--

INSERT INTO `posters` (`ID`, `sprite`, `width`, `length`, `rotation`, `custom`, `roomid`, `ownerid`) VALUES
(1, 'roomdimmer', '3,12', '2,51', 'l', '2', 0, 1),
(3, 'roomdimmer', '10,0', '3,67', 'r', '', 29, 83),
(9, 'poster', '3,8', '31,44', 'l', '14', 54, 1),
(8, 'roomdimmer', '11,0', '2,54', 'r', '0', 31, 1),
(10, 'roomdimmer', '3,8', '11,80', 'l', '0', 33, 88),
(11, 'roomdimmer', '3,8', '0,92', 'l', '0', 34, 89),
(12, 'poster', '3,4', '43,53', 'l', '14', 34, 89),
(13, 'roomdimmer', '', '', '', '0', 0, 89),
(14, 'roomdimmer', '10,0', '25,66', 'r', '0', 35, 91),
(15, 'poster', '10,0', '28,66', 'r', '14', 35, 91),
(16, 'poster', '3,4', '45,41', 'l', '14', 33, 88),
(17, 'roomdimmer', '', '', '', '0', 0, 88),
(18, 'poster', '3,11', '59,52', 'l', '18', 35, 1),
(19, 'poster', '3,2', '29,59', 'l', '14', 35, 91),
(20, 'poster', '3,8', '50,47', 'l', '14', 35, 91),
(21, 'poster', '10,0', '35,53', 'r', '18', 6, 1),
(22, 'md_can', '3,2', '6,82', 'l', '2', 6, 1),
(23, 'md_can', '3,8', '14,78', 'l', '2', 6, 1),
(24, 'roomdimmer', '3,4', '18,36', 'l', '0', 0, 93),
(25, 'md_logo_wall', '3,10', '18,62', 'l', '0', 0, 93),
(26, 'md_can', '', '', '', '0', 0, 93),
(27, 'md_logo_wall', '3,5', '10,52', 'l', '2', 6, 1),
(28, 'roomdimmer', '3,8', '18,53', 'l', '0', 37, 94),
(29, 'roomdimmer', '3,8', '16,62', 'l', '0', 39, 95),
(30, 'roomdimmer', '3,3', '27,49', 'l', '0', 40, 96),
(31, 'md_can', '3,11', '15,60', 'l', '0', 39, 95),
(32, 'md_logo_wall', '3,3', '20,74', 'l', '0', 39, 95),
(33, 'md_logo_wall', '', '', '', '0', 0, 95),
(34, 'md_can', '', '', '', '0', 0, 95),
(35, 'md_can', '3,7', '23,52', 'l', '0', 40, 96),
(36, 'roomdimmer', '0,9', '30,40', 'l', '0', 41, 98),
(37, 'roomdimmer', '3,3', '19,68', 'l', '0', 42, 1),
(38, 'roomdimmer', '3,8', '10,58', 'l', '0', 43, 99),
(39, 'md_can', '3,8', '22,61', 'l', '0', 42, 97),
(40, 'md_can', '3,10', '4,88', 'l', '0', 43, 99),
(41, 'md_logo_wall', '9,0', '23,76', 'r', '0', 43, 99),
(42, 'poster', '4,0', '30,51', 'r', '18', 6, 1),
(43, 'roomdimmer', '3,9', '12,62', 'l', '0', 44, 101),
(44, 'md_can', '', '', '', '0', 0, 101),
(45, 'md_logo_wall', '', '', '', '0', 0, 101),
(46, 'roomdimmer', '3,9', '5,58', 'l', '0', 48, 104),
(47, 'poster', '3,12', '50,54', 'l', '14', 42, 97),
(48, 'roomdimmer', '', '', '', '0', 0, 97),
(49, 'roomdimmer', '3,9', '0,84', 'l', '0', 49, 106),
(50, 'md_logo_wall', '3,5', '8,72', 'l', '0', 49, 106),
(51, 'roomdimmer', '3,3', '21,48', 'l', '0', 54, 1),
(52, 'roomdimmer', '3,3', '24,71', 'l', '0', 50, 107),
(53, 'roomdimmer', '3,3', '16,53', 'l', '0', 51, 108),
(54, 'poster', '3,11', '34,48', 'l', '18', 6, 1),
(77, 'md_can', '3,12', '1,81', 'l', '2', 52, 119),
(76, 'roomdimmer', '3,2', '20,67', 'l', '0', 52, 119),
(72, 'md_logo_wall', '', '', '', '0', 0, 85),
(83, 'roomdimmer', '3,12', '0,57', 'l', '2', 6, 1),
(84, 'roomdimmer', '3,12', '2,57', 'l', '0', 55, 1),
(85, 'roomdimmer', '3,2', '18,77', 'l', '0', 56, 136),
(86, 'roomdimmer', '', '', '', '0', 0, 1),
(87, 'roomdimmer', '10,0', '27,71', 'r', '0', 57, 139),
(90, 'md_logo_wall', '3,9', '4,79', 'l', '2', 57, 139),
(91, 'md_can', '3,2', '9,69', 'l', '2', 57, 139),
(92, 'roomdimmer', '3,8', '25,52', 'l', '0', 0, 128),
(93, 'roomdimmer', '3,7', '19,63', 'l', '0', 58, 128),
(94, 'md_can', '3,12', '26,56', 'l', '0', 58, 128),
(95, 'md_logo_wall', '3,3', '25,57', 'l', '0', 58, 128),
(96, 'roomdimmer', '10,0', '31,87', 'r', '0', 60, 143),
(99, 'roomdimmer', '10,0', '23,70', 'r', '0', 61, 144),
(100, 'md_can', '3,2', '16,68', 'l', '2', 61, 144),
(101, 'md_logo_wall', '3,9', '0,83', 'l', '2', 61, 144),
(102, 'md_logo_wall', '3,3', '28,58', 'l', '2', 60, 143),
(103, 'md_can', '3,10', '14,67', 'l', '2', 60, 143),
(106, 'roomdimmer', '', '', '', '0', 0, 143),
(107, 'roomdimmer', '3,9', '28,50', 'l', '0', 0, 145),
(108, 'md_can', '10,0', '22,62', 'r', '2', 62, 145),
(109, 'md_logo_wall', '7,0', '18,73', 'r', '2', 62, 145),
(110, 'roomdimmer', '3,12', '8,55', 'l', '0', 62, 145),
(111, 'roomdimmer', '', '', '', '0', 0, 126),
(112, 'roomdimmer', '10,0', '12,74', 'r', '0', 63, 146),
(113, 'roomdimmer', '3,3', '17,68', 'l', '0', 64, 126),
(114, 'roomdimmer', '3,3', '16,56', 'l', '0', 65, 127),
(115, 'roomdimmer', '3,7', '15,47', 'l', '0', 67, 149);

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

--
-- Table structure for table `presents`
--

CREATE TABLE `presents` (
  `ID` int(11) NOT NULL,
  `ItemSprite` int(11) NOT NULL,
  `Type` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `presents`
--


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

--
-- Table structure for table `privroomstatics`
--

CREATE TABLE `privroomstatics` (
  `Model` text NOT NULL,
  `Heightmap` text NOT NULL,
  `x` int(11) NOT NULL,
  `y` int(11) NOT NULL,
  `z` double NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `privroomstatics`
--

INSERT INTO `privroomstatics` (`Model`, `Heightmap`, `x`, `y`, `z`) VALUES
('model_a', 'xxxxxxxxxxxx\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx', 3, 5, 0),
('newbie_lobby', 'xxxxxxxxxxxxxxxx000000\r\nxxxxx0xxxxxxxxxx000000\r\nxxxxx00000000xxx000000\r\nxxxxx000000000xx000000\r\n0000000000000000000000\r\n0000000000000000000000\r\n0000000000000000000000\r\n0000000000000000000000\r\n0000000000000000000000\r\nxxxxx000000000000000xx\r\nxxxxx000000000000000xx\r\nx0000000000000000000xx\r\nx0000000000000000xxxxx\r\nxxxxxx00000000000xxxxx\r\nxxxxxxx0000000000xxxxx\r\nxxxxxxxx000000000xxxxx\r\nxxxxxxxx000000000xxxxx\r\nxxxxxxxx000000000xxxxx\r\nxxxxxxxx000000000xxxxx\r\nxxxxxxxx000000000xxxxx\r\nxxxxxxxx000000000xxxxx\r\nxxxxxx00000000000xxxxx\r\nxxxxxx00000000000xxxxx\r\nxxxxxx00000000000xxxxx\r\nxxxxxx00000000000xxxxx\r\nxxxxxx00000000000xxxxx\r\nxxxxx000000000000xxxxx\r\nxxxxx000000000000xxxxx', 2, 11, 0),
('library', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxx11111xx1xx1x111111x\r\nxxxxxxxxxxxx111111xx1xx11111111x\r\nxx111xxxxxxx111111xx1xx11111111x\r\nxx111xxxxxxx1111111111111111111x\r\nxx111xxxxxxx1111111111111111111x\r\nxx111xxxxxxx1111111111111111111x\r\nxx111xxxxxxx1111111111111xxxxxxx\r\nxx111xxxxxx11111111111111111111x\r\nxx111xxxxxx11111111111111111111x\r\nxx111xxxxxx11111111111111111111x\r\nxx111xxxxxx11111111111111xxxxxxx\r\nxx111xxxxxxxx111111111111111111x\r\nxx111xx11111x111111111111111111x\r\nxx111xx11111x111111111111111111x\r\nxx111xxxxx11x11111111x111xxxxxxx\r\nxx111xxxxxxxx11111111xx11111111x\r\nxx111xxx1111111111111xxx1111111x\r\nxx111xxx1111111111111xxxx111111x\r\nxxx111xx1111111111x11xxxx000000x\r\nxxxxx1111xx1111111x11xxxx000000x\r\nxxxxxxxxxxxx111111x11xxxx000000x\r\nxxxxxxxxxxxx11xx11x11xxxx000000x\r\nxxxxxxxxxxxx11xx11x11xxxx000000x\r\nxxxxxxxxxxxx11xx11x11xxxx000000x\r\nxxxxxxxxxxxx11xx11x11xxxx000000x\r\nxxxxxxxxxxxx11xx11x11xxxx000000x\r\nxxxxxxxxxxxx11xx11x111xxx000000x\r\nxxxxxxxxxxxxxxxxxxxx11xxx000000x\r\nxxxxxxxxxxxxxxxxxxxx11xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 20, 3, 1),
('cafe_gold0', 'xxxxxxxxxx1111xxxxxxx\r\nxxxxxxxxxx11111xxxxxx\r\nxxxxxxxxxx111111xxxxx\r\nxx111111111111111xxxx\r\nx11111111111111111xxx\r\n1111111111111111111xx\r\n11111111111111111111x\r\n111111111111111111111\r\n111111111111111111111\r\n1111111111111x1111111\r\n1111111000000x1111111\r\n1111111000000x1111111\r\n1111111000000x1111111\r\n1111111000000x1111111\r\n1111111000000x1111111\r\n1111111000000x1111111\r\n1111111000000x1111111\r\n1111111000000x1111111\r\n1111111000000x1111111\r\n1111111000000xxx00000\r\n111111100000000000000\r\n111111100000000000000\r\n111111100000000000000\r\n111111100000000xxxxx0\r\n11111110000000xxxxxx0\r\n11111110000000xxxxxx0\r\n11111110000000xxxxxxx\r\nx1111110000000xxxxxxx\r\nxxxxxxxx0000000000xxx\r\nxxxxxxxx000xxxxxxxxxx\r\nxxxxxxxx000xxxxxxxxxx\r\nxxxxxxxx000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx', 9, 29, 0),
('theater', 'XXXXXXXXXXXXXXXXXXXXXXX\r\nXXXXXXXXXXXXXXXXXXXXXXX\r\nXXXXXXXXXXXXXXXXXXXXXXX\r\nXXXXXXXXXXXXXXXXXXXXXXX\r\nXXXXXXXXXXXXXXXXXXXXXXX\r\nXXXXXXXXXXXXXXXXXXXXXXX\r\nXXXXXXX111111111XXXXXXX\r\nXXXXXXX11111111100000XX\r\nXXXX00X11111111100000XX\r\nXXXX00x11111111100000XX\r\n4XXX00X11111111100000XX\r\n4440000XXXXXXXXX00000XX\r\n444000000000000000000XX\r\n4XX000000000000000000XX\r\n4XX0000000000000000000X\r\n44400000000000000000000\r\n44400000000000000000000\r\n44X00000000000000007000\r\n44X11111111111111111000\r\n44X11111111111111111000\r\n33X11111111111111111000\r\n22X11111111111111111000\r\n22X11111111111111111000\r\n22X11111111111111111000\r\n22X11111111111111111000\r\n22X11111111111111111000\r\n22211111111111111111000\r\n22211111111111111111000\r\nXXXXXXXXXXXXXXXXXXXX00X\r\nXXXXXXXXXXXXXXXXXXXX00X', 20, 27, 0),
('model_b', 'xxxxxxxxxxxx\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxx00000000\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx', 0, 5, 0),
('model_c', 'xxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx', 4, 7, 0),
('model_d', 'xxxxxxxxxxxx\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxx000000x\r\nxxxxxxxxxxxx', 4, 7, 0),
('model_e', 'xxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxx0000000000\r\nxx0000000000\r\nxx0000000000\r\nxx0000000000\r\nxx0000000000\r\nxx0000000000\r\nxx0000000000\r\nxx0000000000\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx', 1, 5, 0),
('model_f', 'xxxxxxxxxxxx\r\nxxxxxxx0000x\r\nxxxxxxx0000x\r\nxxx00000000x\r\nxxx00000000x\r\nxxx00000000x\r\nxxx00000000x\r\nx0000000000x\r\nx0000000000x\r\nx0000000000x\r\nx0000000000x\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx', 2, 5, 0);

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

--
-- Table structure for table `rights`
--

CREATE TABLE `rights` (
  `ID` int(11) NOT NULL auto_increment,
  `RoomID` int(11) NOT NULL,
  `UserID` int(11) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `rights`
--

INSERT INTO `rights` (`ID`, `RoomID`, `UserID`) VALUES
(1, 6, 83),
(2, 6, 84),
(20, 51, 107),
(16, 6, 91),
(7, 6, 89),
(8, 6, 92),
(9, 6, 89),
(15, 6, 91),
(11, 6, 93),
(14, 6, 93),
(17, 6, 93),
(18, 6, 91),
(19, 40, 95);

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

--
-- Table structure for table `roomcatagory`
--

CREATE TABLE `roomcatagory` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` text NOT NULL COMMENT 'Name of the catagory',
  `Level` tinyint(2) NOT NULL default '1',
  `ParentID` int(11) NOT NULL default '0' COMMENT 'ID of the Parent Catagory',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `roomcatagory`
--

INSERT INTO `roomcatagory` (`ID`, `Name`, `Level`, `ParentID`) VALUES
(3, 'Public Rooms', 0, 0),
(4, 'Private Rooms', 0, 0),
(5, 'Test Catagory', 0, 3),
(0, 'No Catagory', 1, 0),
(7, 'Leet Rooms', 1, 0),
(8, 'Test Catagory #2', 0, 5);

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

--
-- Table structure for table `roomdimmer`
--

CREATE TABLE `roomdimmer` (
  `ItemID` int(11) NOT NULL,
  `On` int(11) NOT NULL default '1',
  `Preset` int(11) NOT NULL default '1',
  `Preset1BG` int(11) NOT NULL default '1',
  `Preset2BG` int(11) NOT NULL default '1',
  `Preset3BG` int(11) NOT NULL default '1',
  `Preset1Hex` text NOT NULL,
  `Preset2Hex` text NOT NULL,
  `Preset3Hex` text NOT NULL,
  `Preset1Alpha` int(11) NOT NULL default '77',
  `Preset2Alpha` int(11) NOT NULL default '77',
  `Preset3Alpha` int(11) NOT NULL default '77'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roomdimmer`
--

INSERT INTO `roomdimmer` (`ItemID`, `On`, `Preset`, `Preset1BG`, `Preset2BG`, `Preset3BG`, `Preset1Hex`, `Preset2Hex`, `Preset3Hex`, `Preset1Alpha`, `Preset2Alpha`, `Preset3Alpha`) VALUES
(1, 2, 1, 2, 2, 1, '#000000', '#0053F7', '#E759DE', 199, 148, 255),
(3, 2, 1, 1, 1, 1, '#000000', '#74F5F5', '#EA4532', 255, 77, 77),
(8, 2, 2, 1, 2, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(10, 2, 2, 1, 2, 1, '#000000', '#EA4532', '#0053F7', 77, 77, 77),
(11, 2, 1, 2, 1, 1, '#82F349', '#EA4532', '#000000', 77, 77, 157),
(13, 1, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(14, 2, 2, 1, 1, 1, '#000000', '#EA4532', '#000000', 77, 77, 77),
(17, 1, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(24, 2, 1, 1, 1, 1, '#000000', '#EA4532', '#E759DE', 77, 77, 77),
(28, 2, 1, 1, 1, 1, '#000000', '#EA4532', '#E759DE', 153, 77, 77),
(29, 2, 3, 1, 1, 2, '#EA4532', '#EA4532', '#E759DE', 198, 208, 77),
(30, 2, 3, 1, 1, 1, '#82F349', '#EA4532', '#F2F851', 153, 153, 153),
(36, 2, 2, 1, 1, 2, '#0053F7', '#0053F7', '#E759DE', 202, 218, 77),
(37, 2, 2, 1, 1, 1, '#0053F7', '#000000', '#0053F7', 77, 153, 77),
(38, 2, 3, 1, 2, 1, '#000000', '#EA4532', '#74F5F5', 91, 77, 255),
(43, 2, 3, 2, 2, 1, '#0053F7', '#000000', '#000000', 77, 77, 77),
(46, 2, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(48, 1, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(49, 2, 1, 1, 1, 1, '#000000', '#EA4532', '#E759DE', 176, 77, 77),
(51, 1, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(52, 1, 3, 1, 1, 2, '#F2F851', '#EA4532', '#0053F7', 77, 77, 77),
(53, 2, 1, 1, 1, 1, '#FF0000', '#EA4532', '#E759DE', 185, 77, 77),
(76, 1, 2, 1, 1, 2, '#F2F851', '#000000', '#E759DE', 77, 77, 77),
(83, 2, 3, 2, 1, 2, '#000000', '#EA4532', '#E759DE', 77, 77, 77),
(84, 2, 1, 2, 1, 1, '#82F349', '#EA4532', '#E759DE', 77, 77, 77),
(85, 2, 1, 2, 1, 1, '#000000', '#EA4532', '#E759DE', 153, 77, 77),
(86, 1, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(87, 2, 1, 2, 1, 1, '#0053F7', '#EA4532', '#E759DE', 143, 77, 77),
(92, 2, 1, 1, 1, 1, '#000000', '#EA4532', '#E759DE', 77, 77, 77),
(93, 2, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(96, 2, 3, 1, 1, 1, '#EA4532', '#74F5F5', '#0053F7', 77, 153, 77),
(99, 2, 1, 2, 1, 1, '#0053F7', '#74F5F5', '#E759DE', 77, 77, 77),
(106, 1, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(107, 2, 1, 1, 1, 1, '#EA4532', '#EA4532', '#E759DE', 77, 77, 77),
(110, 2, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(111, 1, 1, 1, 1, 1, '#F2F851', '#EA4532', '#E759DE', 77, 77, 77),
(112, 2, 1, 2, 1, 1, '#74F5F5', '#EA4532', '#E759DE', 77, 77, 77),
(113, 2, 1, 2, 1, 1, '#000000', '#EA4532', '#E759DE', 175, 77, 77),
(114, 2, 2, 1, 1, 1, '#82F349', '#EA4532', '#E759DE', 159, 77, 77),
(115, 2, 1, 1, 1, 1, '#0053F7', '#EA4532', '#E759DE', 77, 77, 77);

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `ID` int(11) NOT NULL auto_increment COMMENT 'Room ID (Unique)',
  `ownerID` int(11) NOT NULL,
  `Name` text NOT NULL COMMENT 'Name of room',
  `CatagoryID` int(11) NOT NULL COMMENT 'the ID of the Catagory the room is in',
  `Description` text NOT NULL COMMENT 'Description of the room',
  `CCT` text NOT NULL,
  `AccessLevel` tinyint(1) NOT NULL default '0' COMMENT 'Access flag for room',
  `Part` tinyint(1) NOT NULL default '0' COMMENT 'The room Part',
  `userlimit` int(11) NOT NULL default '25',
  `model` text NOT NULL,
  `wallpaper` int(11) NOT NULL default '100',
  `floor` int(11) NOT NULL default '100',
  `showowner` tinyint(4) NOT NULL default '1' COMMENT '1 if username should be shown',
  `password` text NOT NULL,
  `allsuperusers` tinyint(1) NOT NULL COMMENT '1 If all users have rights',
  KEY `ID_2` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`ID`, `ownerID`, `Name`, `CatagoryID`, `Description`, `CCT`, `AccessLevel`, `Part`, `userlimit`, `model`, `wallpaper`, `floor`, `showowner`, `password`, `allsuperusers`) VALUES
(20, 0, 'Theatredrome', 3, 'theatredrome', 'hh_room_theater', 0, 0, 25, 'theater', 0, 0, 1, '', 0),
(1, 0, 'Welcome Lounge', 3, 'welcome_lounge', 'hh_room_nlobby', 0, 0, 3, 'newbie_lobby', 0, 0, 1, '', 0),
(6, 1, 'Club Bubble Juice', 4, 'A nice & bubbly atmosphere', '', 0, 0, 25, 'model_a', 2302, 110, 1, '', 0),
(54, 1, 'Deals', 0, '', '', 1, 0, 25, 'model_a', 100, 100, 1, '', 0),
(55, 1, 'lol', 0, '', '', 0, 0, 25, 'model_a', 408, 110, 1, '', 0),
(16, 1, 'Who owns me? ', 7, 'Hello World!', '', 0, 0, 10, 'model_a', 100, 100, 0, '', 0),
(23, 0, 'Cafe Gold', 3, 'cafe_gold', 'hh_room_gold', 0, 0, 10, 'cafe_gold0', 0, 0, 1, '', 0),
(28, 0, 'Welcome Lounge', 5, 'welcome_lounge', 'hh_room_nlobby', 0, 0, 3, 'newbie_lobby', 0, 0, 1, '', 0),
(30, 1, 'Small Room', 0, '', '', 1, 0, 10, 'model_c', 100, 100, 1, '', 0),
(31, 1, 'Pass room', 0, '', '', 2, 0, 25, 'model_a', 100, 100, 1, 'lol', 0);

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

--
-- Table structure for table `static`
--

CREATE TABLE `static` (
  `name` text NOT NULL,
  `value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `static`
--

INSERT INTO `static` (`name`, `value`) VALUES
('Maximum_Connections', '200'),
('Maximum_Delay_between_Packets', '1'),
('Server_Port', '1337'),
('UPDATE_MYSQL_USERCOUNT', '1'),
('Online_Users', '1');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `ID` int(11) NOT NULL auto_increment,
  `Username` varchar(24) NOT NULL,
  `Password` text NOT NULL COMMENT 'MD5 Checksum of our password',
  `Figure` text NOT NULL,
  `Mission` text NOT NULL,
  `Sex` text NOT NULL,
  `level` tinyint(4) NOT NULL default '1' COMMENT 'the users Access Level',
  `credits` int(11) NOT NULL,
  `SSOTicket` text NOT NULL,
  `CurrentBadge` int(11) NOT NULL,
  `badgestatus` tinyint(4) NOT NULL,
  `hcmonths` int(20) NOT NULL,
  `HCDateBought` text NOT NULL,
  `hcpmonths` int(20) NOT NULL,
  `consoletext` text NOT NULL,
  `lastlogin` text NOT NULL,
  `HKSession` text NOT NULL,
  UNIQUE KEY `ID` (`ID`),
  UNIQUE KEY `Username` (`Username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=154 ;

--
-- Dumping data for table `users`
--

