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


-- 
-- Database: `jeax_server`
-- 

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

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

CREATE TABLE `badges` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` text NOT NULL,
  `ownerid` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

INSERT INTO `badges` VALUES (1, 'HC1', 15);
INSERT INTO `badges` VALUES (2, 'HC1', 14);
INSERT INTO `badges` VALUES (3, 'ADM', 15);

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

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

CREATE TABLE `bans` (
  `datemade` text NOT NULL,
  `length` bigint(20) NOT NULL,
  `userid` bigint(20) NOT NULL,
  `reason` text NOT NULL,
  `givenbyid` bigint(20) NOT NULL,
  `shockwave` text NOT NULL,
  `ip` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `bans` VALUES ('19 July 2007 10:59:55', 2, 14, 'HACKIN MA HOTEL', 15, '', '');

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

-- 
-- Table structure for table `cataloguepages`
-- 

CREATE TABLE `cataloguepages` (
  `level` tinyint(4) NOT NULL default '1',
  `id` bigint(20) NOT NULL auto_increment,
  `idname` text NOT NULL,
  `showname` text NOT NULL,
  `rest` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `cataloguepages`
-- 

INSERT INTO `cataloguepages` VALUES (1, 3, 'Spaces', 'Spaces', '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:It''s not just the furniture in your room that expresses your personality - a splash of colour on the walls or a sassy patterned carpet can make all the difference. Use our virtual room below to test out the combinations before you buy. Select the colour and design you like and click ''Buy''.\r\nt7:Preview\r\ne:\r\np:wallpaper	Wallpaper	3		i	wallpaper 1			wallpaper 1	\r\np:floor	Floor	2		i	floor			floor	\r\np:wallpaper	Wallpaper	3		i	wallpaper 2			wallpaper 2	\r\np:wallpaper	Wallpaper	3		i	wallpaper 3			wallpaper 3	\r\np:wallpaper	Wallpaper	3		i	wallpaper 4			wallpaper 4	\r\np:wallpaper	Wallpaper	3		i	wallpaper 5			wallpaper 5	\r\np:wallpaper	Wallpaper	3		i	wallpaper 6			wallpaper 6	\r\np:wallpaper	Wallpaper	3		i	wallpaper 7			wallpaper 7	\r\np:wallpaper	Wallpaper	3		i	wallpaper 8			wallpaper 8	\r\np:wallpaper	Wallpaper	3		i	wallpaper 9			wallpaper 9	\r\np:wallpaper	Wallpaper	3		i	wallpaper 10			wallpaper 10	\r\np:wallpaper	Wallpaper	5		i	wallpaper 11			wallpaper 11	\r\np:wallpaper	Wallpaper	5		i	wallpaper 12			wallpaper 12	\r\np:wallpaper	Wallpaper	5		i	wallpaper 13			wallpaper 13	\r\np:wallpaper	Wallpaper	5		i	wallpaper 14			wallpaper 14	\r\np:wallpaper	Wallpaper	5		i	wallpaper 15			wallpaper 15	\r\np:wallpaper	Wallpaper	5		i	wallpaper 16			wallpaper 16	\r\np:wallpaper	Wallpaper	5		i	wallpaper 17			wallpaper 17	\r\np:wallpaper	Wallpaper	5		i	wallpaper 18			wallpaper 18	\r\np:wallpape\r\nr	Wallpaper	5		i	wallpaper 19			wallpaper 19	\r\np:wallpaper	Wallpaper	5		i	wallpaper 20			wallpaper 20	\r\np:wallpaper	Wallpaper	5		i	wallpaper 21			wallpaper 21	\r\np:wallpaper	Wallpaper	5		i	wallpaper 22			wallpaper 22	\r\np:wallpaper	Wallpaper	5		i	wallpaper 23			wallpaper 23	\r\np:wallpaper	Wallpaper	5		i	wallpaper 24			wallpaper 24	\r\np:wallpaper	Wallpaper	5		i	wallpaper 25			wallpaper 25	\r\np:wallpaper	Wallpaper	5		i	wallpaper 26			wallpaper 26	\r\np:wallpaper	Wallpaper	5		i	wallpaper 27			wallpaper 27	\r\np:wallpaper	Wallpaper	5		i	wallpaper 28			wallpaper 28	\r\np:wallpaper	Wallpaper	5		i	wallpaper 29			wallpaper 29	\r\np:wallpaper	Wallpaper	5		i	wallpaper 30			wallpaper 30	\r\np:Gothic Wallpaper	The dark side of Habbo	5		i	wallpaper 31			wallpaper 31	');
INSERT INTO `cataloguepages` VALUES (1, 1, 'Frontpage', 'Frontpage', 'l:ctlg_frontpage2\r\ns:1: <br>Home sweet home!\r\nh:Welcome to the Hotel Catalogue. It''s packed full of fab things for your room - there''s something for everyone! Browse the ranges by clicking the tabs on the right.<br><br>Some ranges are seasonal, so check back regularly for new items.\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:How do I buy stuff? You''ll need Habbo Credits to buy things from the Catalogue - check your Habbo Purse for more info.\r\ne:catal_fp_pic4,catal_fp_pic5,');
INSERT INTO `cataloguepages` VALUES (1, 4, 'Lodge', 'Lodge', 'l:ctlg_layout2\r\ns:2:Got wood? ;-)\r\nw:Click on an item to see more details\r\ng:catalog_lodge_headline1\r\nh:For that ski-lodge effect - especially good by an open fire. The Lodge Collection is for Habbos who have a no-frills attitude to home furnishing and those who appreciate the beauty of wood, if y''know what i mean!\r\ne:catalog_lodge_teaser1');
INSERT INTO `cataloguepages` VALUES (8, 5, 'staff', 'Staff Page', 'l:ctlg_layout2\r\nw:Click on an item to see more details\r\ng:catalog_rares_headline1\r\nh:Yay, rares!! :D\r\ne:ctlg_norare_char1,\r\ns:2:Secret rares page for the win! LOL');

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

-- 
-- Table structure for table `consolemessages`
-- 

CREATE TABLE `consolemessages` (
  `toid` bigint(20) NOT NULL,
  `froid` bigint(20) NOT NULL,
  `message` text NOT NULL,
  `sent` text NOT NULL,
  `id` bigint(20) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- 
-- Dumping data for table `consolemessages`
-- 


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

-- 
-- Table structure for table `favrooms`
-- 

CREATE TABLE `favrooms` (
  `habboid` bigint(20) NOT NULL,
  `ispub` tinyint(4) NOT NULL,
  `roomid` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `favrooms`
-- 

INSERT INTO `favrooms` VALUES (15, 0, 123);
INSERT INTO `favrooms` VALUES (15, 0, 124);

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

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

CREATE TABLE `friendrequests` (
  `userid` bigint(20) NOT NULL,
  `requesterid` bigint(20) NOT NULL,
  `frid` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

CREATE TABLE `friendslist` (
  `userid` bigint(20) NOT NULL,
  `friendid` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `friendslist` VALUES (14, 15);
INSERT INTO `friendslist` VALUES (15, 14);
INSERT INTO `friendslist` VALUES (16, 15);
INSERT INTO `friendslist` VALUES (15, 16);

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

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

CREATE TABLE `furniture` (
  `id` bigint(20) NOT NULL auto_increment,
  `sprite` text NOT NULL,
  `ownerid` bigint(20) NOT NULL,
  `roomid` bigint(20) NOT NULL,
  `x` int(11) NOT NULL,
  `y` int(11) NOT NULL,
  `elevation` double NOT NULL,
  `inhand` smallint(6) NOT NULL,
  `length` smallint(6) NOT NULL default '1',
  `width` smallint(6) NOT NULL default '1',
  `rotation` text NOT NULL,
  `colour` text NOT NULL,
  `variable` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=283 ;

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

INSERT INTO `furniture` VALUES (2, 'crl_lamp', 0, 1, 16, 0, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (3, 'crl_sofa2c', 0, 1, 17, 0, 0, 0, 0, 0, '4', '', '');
INSERT INTO `furniture` VALUES (4, 'crl_sofa2b', 0, 1, 18, 0, 0, 0, 0, 0, '4', '', '');
INSERT INTO `furniture` VALUES (5, 'crl_sofa2a', 0, 1, 19, 0, 0, 0, 0, 0, '4', '', '');
INSERT INTO `furniture` VALUES (6, 'crl_lamp', 0, 1, 20, 0, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (7, 'crl_chair', 0, 1, 16, 1, 0, 0, 0, 0, '2', '', '');
INSERT INTO `furniture` VALUES (8, 'crl_lamp', 0, 1, 7, 2, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (9, 'crl_lamp', 0, 1, 11, 2, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (10, 'crl_chair', 0, 1, 16, 2, 0, 0, 0, 0, '2', '', '');
INSERT INTO `furniture` VALUES (11, 'crl_pillar', 0, 1, 5, 3, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (12, 'crl_chair', 0, 1, 7, 3, 0, 0, 0, 0, '2', '', '');
INSERT INTO `furniture` VALUES (13, 'crl_table1b', 0, 1, 9, 3, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (14, 'crl_sofa1c', 0, 1, 11, 3, 0, 0, 0, 0, '6', '', '');
INSERT INTO `furniture` VALUES (15, 'crl_chair', 0, 1, 16, 3, 0, 0, 0, 0, '2', '', '');
INSERT INTO `furniture` VALUES (16, 'crl_table2b', 0, 1, 19, 3, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (17, 'crl_table2a', 0, 1, 20, 3, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (18, 'crl_lamp', 0, 1, 0, 4, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (19, 'crl_sofa2c', 0, 1, 1, 4, 0, 0, 0, 0, '4', '', '');
INSERT INTO `furniture` VALUES (20, 'crl_sofa2b', 0, 1, 2, 4, 0, 0, 0, 0, '4', '', '');
INSERT INTO `furniture` VALUES (21, 'crl_sofa2a', 0, 1, 3, 4, 0, 0, 0, 0, '4', '', '');
INSERT INTO `furniture` VALUES (22, 'crl_lamp', 0, 1, 4, 4, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (23, 'crl_table1a', 0, 1, 9, 4, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (24, 'crl_sofa1b', 0, 1, 11, 4, 0, 0, 0, 0, '6', '', '');
INSERT INTO `furniture` VALUES (25, 'crl_wall2a', 0, 1, 15, 4, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (26, 'crl_lamp', 0, 1, 16, 4, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (27, 'crl_chair', 0, 1, 0, 5, 0, 0, 0, 0, '2', '', '');
INSERT INTO `furniture` VALUES (28, 'crl_chair', 0, 1, 7, 5, 0, 0, 0, 0, '2', '', '');
INSERT INTO `furniture` VALUES (29, 'crl_sofa1a', 0, 1, 11, 5, 0, 0, 0, 0, '6', '', '');
INSERT INTO `furniture` VALUES (30, 'crl_table2b', 0, 1, 2, 6, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (31, 'crl_table2a', 0, 1, 3, 6, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (32, 'crl_lamp', 0, 1, 11, 6, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (33, 'crl_chair', 0, 1, 0, 7, 0, 0, 0, 0, '2', '', '');
INSERT INTO `furniture` VALUES (34, 'crl_lamp', 0, 1, 0, 8, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (35, 'crl_sofa3c', 0, 1, 1, 8, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (36, 'crl_sofa3b', 0, 1, 2, 8, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (37, 'crl_sofa3a', 0, 1, 3, 8, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (38, 'crl_lamp', 0, 1, 4, 8, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (39, 'crl_barchair2', 0, 1, 19, 8, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (40, 'crl_tablebar', 0, 1, 20, 8, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (41, 'crl_barchair2', 0, 1, 21, 8, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (42, 'crl_pillar2', 0, 1, 5, 9, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (43, 'crl_pillar', 0, 1, 9, 9, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (44, 'crl_desk1a', 0, 1, 8, 15, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (45, 'crl_deski', 0, 1, 9, 15, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (46, 'crl_deskh', 0, 1, 10, 15, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (47, 'crl_deskg', 0, 1, 10, 16, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (48, 'crl_deskf', 0, 1, 10, 17, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (49, 'crl_deske', 0, 1, 10, 18, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (50, 'crl_deske', 0, 1, 10, 19, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (51, 'crl_deske', 0, 1, 10, 20, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (52, 'crl_deske', 0, 1, 10, 21, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (53, 'crl_deske', 0, 1, 10, 22, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (54, 'crl_deske', 0, 1, 10, 23, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (55, 'crl_wallb', 0, 1, 7, 24, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (56, 'crl_deske', 0, 1, 10, 24, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (57, 'crl_walla', 0, 1, 7, 25, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (58, 'crl_desk1b', 0, 1, 8, 25, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (59, 'crl_desk1c', 0, 1, 9, 25, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (60, 'crl_desk1d', 0, 1, 10, 25, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (61, 'crl_lamp2', 0, 1, 12, 27, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (62, 'crl_cabinet2', 0, 1, 13, 27, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (63, 'crl_cabinet1', 0, 1, 14, 27, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (64, 'crl_lamp2', 0, 1, 15, 27, 0, 0, 0, 0, '0', '', '');
INSERT INTO `furniture` VALUES (0, 'small_chair_armas', 15, 123, 11, 12, 0, 0, 1, 1, '4', '', '');
INSERT INTO `furniture` VALUES (67, 'small_chair_armas', 15, 0, 9, 6, 0, 1, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (68, 'small_chair_armas', 15, 0, 10, 5, 0, 1, 1, 1, '6', '0,0,0', '');
INSERT INTO `furniture` VALUES (69, 'small_chair_armas', 15, 0, 8, 8, 0, 1, 1, 1, '6', '0,0,0', '');
INSERT INTO `furniture` VALUES (70, 'small_chair_armas', 15, 123, 10, 13, 0, 0, 1, 1, '2', '0,0,0', '');
INSERT INTO `furniture` VALUES (71, 'small_chair_armas', 15, 0, 7, 7, 0, 1, 1, 1, '4', '0,0,0', '');
INSERT INTO `furniture` VALUES (72, 'small_chair_armas', 15, 0, 9, 9, 0, 1, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (73, 'small_chair_armas', 15, 0, 9, 4, 0, 1, 1, 1, '2', '0,0,0', '');
INSERT INTO `furniture` VALUES (74, 'rclr_sofa', 15, 123, 5, 1, 0, 0, 1, 2, '4', '', '');
INSERT INTO `furniture` VALUES (75, 'plant_small_cactus', 15, 123, 4, 11, 0, 0, 1, 1, '0', '', '');
INSERT INTO `furniture` VALUES (76, 'small_chair_armas', 15, 0, 6, 8, 0, 1, 1, 1, '2', '0,0,0', '');
INSERT INTO `furniture` VALUES (85, 'rare_daffodil_rug', 15, 123, 6, 10, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (86, 'rare_daffodil_rug', 15, 123, 4, 5, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (87, 'rare_daffodil_rug', 15, 123, 6, 6, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (88, 'rare_daffodil_rug', 15, 123, 8, 3, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (89, 'rare_daffodil_rug', 15, 123, 10, 5, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (90, 'rare_daffodil_rug', 15, 123, 10, 3, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (91, 'rare_daffodil_rug', 15, 123, 8, 5, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (92, 'rare_daffodil_rug', 15, 123, 6, 4, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (93, 'rare_daffodil_rug', 15, 123, 4, 3, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (94, 'rare_daffodil_rug', 15, 123, 10, 1, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (95, 'rare_daffodil_rug', 15, 123, 8, 1, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (96, 'rare_daffodil_rug', 15, 123, 6, 1, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (97, 'rare_daffodil_rug', 15, 123, 10, 10, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (98, 'rare_daffodil_rug', 15, 123, 6, 8, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (99, 'rare_daffodil_rug', 15, 123, 4, 11, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (100, 'rare_daffodil_rug', 15, 123, 4, 9, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (101, 'rare_daffodil_rug', 15, 123, 10, 8, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (102, 'rare_daffodil_rug', 15, 123, 8, 10, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (103, 'rare_daffodil_rug', 15, 123, 10, 7, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (104, 'rare_daffodil_rug', 15, 123, 8, 7, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (105, 'rare_daffodil_rug', 15, 123, 6, 3, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (106, 'rare_daffodil_rug', 15, 123, 8, 8, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (107, 'rare_daffodil_rug', 15, 123, 4, 12, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (108, 'rare_daffodil_rug', 15, 123, 6, 12, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (109, 'rare_daffodil_rug', 15, 123, 8, 12, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (110, 'rare_daffodil_rug', 15, 123, 10, 12, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (111, 'rare_daffodil_rug', 15, 123, 4, 1, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (112, 'rare_daffodil_rug', 15, 127, 5, 5, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (113, 'rare_daffodil_rug', 15, 123, 4, 7, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (157, 'rare_daffodil_rug', 15, 127, 9, 9, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (156, 'rare_daffodil_rug', 15, 127, 9, 7, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (151, 'rare_daffodil_rug', 15, 127, 8, 5, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (152, 'rare_daffodil_rug', 15, 127, 5, 9, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (153, 'rare_daffodil_rug', 15, 127, 7, 9, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (154, 'rare_daffodil_rug', 15, 127, 5, 7, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (155, 'rare_daffodil_rug', 15, 127, 9, 5, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (158, 'rare_daffodil_rug', 15, 127, 7, 7, 0, 0, 2, 2, '0', '', '');
INSERT INTO `furniture` VALUES (203, 'throne', 15, 123, 11, 2, 0, 0, 1, 1, '6', '0', '');
INSERT INTO `furniture` VALUES (201, 'rclr_sofa', 15, 123, 9, 1, 0, 0, 1, 2, '4', '0', '');
INSERT INTO `furniture` VALUES (199, 'plant_small_cactus', 15, 123, 9, 8, 0, 0, 1, 1, '0', '', '');
INSERT INTO `furniture` VALUES (202, 'throne', 15, 123, 4, 2, 0, 0, 1, 1, '2', '0', '');
INSERT INTO `furniture` VALUES (198, 'throne', 15, 123, 8, 1, 0, 0, 1, 1, '4', '0', '');
INSERT INTO `furniture` VALUES (196, 'throne', 15, 123, 4, 3, 0, 0, 1, 1, '2', '0', '');
INSERT INTO `furniture` VALUES (197, 'throne', 15, 123, 11, 3, 0, 0, 1, 1, '6', '0', '');
INSERT INTO `furniture` VALUES (195, 'divider_arm3', 15, 123, 4, 5, 0, 0, 1, 1, '2', '0', 'O');
INSERT INTO `furniture` VALUES (204, 'divider_arm1', 15, 123, 11, 4, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (205, 'divider_arm1', 15, 123, 4, 4, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (206, 'divider_arm1', 15, 123, 4, 1, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (207, 'divider_arm1', 15, 123, 11, 1, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (208, 'small_table_armas', 15, 123, 11, 13, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (194, 'throne', 15, 123, 7, 1, 0, 0, 1, 1, '4', '', '');
INSERT INTO `furniture` VALUES (209, 'divider_arm1', 15, 123, 4, 6, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (247, 'rare_dragonlamp*0', 15, 123, 11, 5, 0, 0, 1, 1, '2', '#ffffff,#fa2d00,#fa2d00,0,0,0,0', '1');
INSERT INTO `furniture` VALUES (212, 'libchair', 0, 3, 14, 2, 1, 0, 1, 1, '4', '', '');
INSERT INTO `furniture` VALUES (213, 'libchair', 0, 3, 16, 2, 1, 0, 1, 1, '4', '', '');
INSERT INTO `furniture` VALUES (214, 'libchair', 0, 3, 26, 2, 1, 0, 1, 1, '4', '', '');
INSERT INTO `furniture` VALUES (215, 'libchair', 0, 3, 24, 3, 1, 0, 1, 1, '2', '', '');
INSERT INTO `furniture` VALUES (216, 'libchair', 0, 3, 12, 4, 1, 0, 1, 1, '2', '', '');
INSERT INTO `furniture` VALUES (217, 'libchair', 0, 3, 12, 6, 1, 0, 1, 1, '2', '', '');
INSERT INTO `furniture` VALUES (218, 'libstool', 0, 3, 13, 14, 1, 0, 1, 1, '6', '', '');
INSERT INTO `furniture` VALUES (219, 'libstool', 0, 3, 13, 15, 1, 0, 1, 1, '6', '', '');
INSERT INTO `furniture` VALUES (220, 'libstool', 0, 3, 13, 16, 1, 0, 1, 1, '6', '', '');
INSERT INTO `furniture` VALUES (221, 'libchair', 0, 3, 28, 27, 0, 0, 1, 1, '4', '', '');
INSERT INTO `furniture` VALUES (222, 'libchair', 0, 3, 27, 29, 0, 0, 1, 1, '2', '', '');
INSERT INTO `furniture` VALUES (223, 'libstool', 0, 3, 24, 33, 2, 0, 1, 1, '6', '', '');
INSERT INTO `furniture` VALUES (224, 'libstool', 0, 3, 24, 34, 2, 0, 1, 1, '6', '', '');
INSERT INTO `furniture` VALUES (225, 'libstool', 0, 3, 24, 35, 2, 0, 1, 1, '6', '', '');
INSERT INTO `furniture` VALUES (226, 'libstool', 0, 3, 21, 36, 2, 0, 1, 1, '0', '', '');
INSERT INTO `furniture` VALUES (227, 'libstool', 0, 3, 22, 36, 2, 0, 1, 1, '0', '', '');
INSERT INTO `furniture` VALUES (228, 'libstool', 0, 3, 23, 36, 2, 0, 1, 1, '0', '', '');
INSERT INTO `furniture` VALUES (229, 'divider_arm3', 14, 126, 4, 5, 0, 0, 1, 1, '2', '0', 'C');
INSERT INTO `furniture` VALUES (230, 'divider_arm1', 14, 126, 7, 7, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (231, 'divider_arm1', 14, 126, 6, 2, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (232, 'divider_arm1', 14, 126, 7, 3, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (233, 'divider_arm1', 14, 126, 5, 6, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (234, 'divider_arm1', 14, 126, 5, 4, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (235, 'divider_arm1', 14, 126, 6, 8, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (236, 'divider_arm1', 14, 126, 7, 5, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (237, 'divider_arm1', 14, 126, 5, 2, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (238, 'divider_arm1', 14, 126, 5, 3, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (239, 'divider_arm1', 14, 126, 4, 4, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (240, 'divider_arm1', 14, 126, 5, 7, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (241, 'divider_arm1', 14, 126, 5, 8, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (242, 'divider_arm1', 14, 126, 4, 6, 0, 0, 1, 1, '0', '0', '');
INSERT INTO `furniture` VALUES (246, 'rare_dragonlamp*1', 15, 123, 4, 7, 0, 0, 1, 1, '2', '#ffffff,#23238E,#23238E,0,0,0,0', '2');
INSERT INTO `furniture` VALUES (244, 'rare_dragonlamp*0', 15, 127, 10, 5, 0, 0, 1, 1, '4', '#ffffff,#fa2d00,#fa2d00,0,0,0,0', '2');
INSERT INTO `furniture` VALUES (245, 'rare_dragonlamp*1', 15, 127, 6, 5, 0, 0, 1, 1, '4', '#ffffff,#23238E,#23238E,0,0,0,0', '2');
INSERT INTO `furniture` VALUES (248, 'divider_arm3', 15, 0, 7, 3, 0, 1, 1, 1, '0', '0,0,00,0,0', 'C');
INSERT INTO `furniture` VALUES (249, 'divider_arm3', 15, 0, 10, 10, 0, 1, 1, 1, '0', '0,0,0', 'C');
INSERT INTO `furniture` VALUES (250, 'divider_arm3', 15, 0, 0, 0, 0, 1, 1, 1, '0', '0,0,0', 'C');
INSERT INTO `furniture` VALUES (251, 'divider_arm3', 15, 0, 0, 0, 0, 1, 1, 1, '0', '0,0,0', 'C');
INSERT INTO `furniture` VALUES (252, 'habbocomputer*1', 15, 127, 8, 6, 1, 0, 1, 1, '4', '0,0,0', '');
INSERT INTO `furniture` VALUES (253, 'habbocomputer', 15, 0, 7, 10, 0, 1, 1, 1, '4', '0,0,0', '');
INSERT INTO `furniture` VALUES (254, 'small_table_armas', 15, 127, 9, 7, 0, 0, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (255, 'small_table_armas', 15, 0, 4, 10, 0, 1, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (256, 'small_table_armas', 15, 0, 4, 9, 0, 1, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (257, 'small_table_armas', 15, 0, 4, 8, 0, 1, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (258, 'small_table_armas', 15, 0, 5, 10, 0, 1, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (259, 'small_table_armas', 15, 0, 5, 8, 0, 1, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (260, 'throne', 15, 0, 6, 9, 0, 1, 1, 1, '6', '0,0,0', '');
INSERT INTO `furniture` VALUES (261, 'GlassFloor', 15, 0, 11, 13, 0, 1, 1, 1, '2', '110,0,0', '');
INSERT INTO `furniture` VALUES (262, 'divider_arm3', 15, 127, 5, 7, 0, 0, 1, 1, '2', '0,0,0', 'C');
INSERT INTO `furniture` VALUES (263, 'divider_arm1', 15, 0, 10, 7, 0, 1, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (264, 'divider_arm1', 15, 127, 5, 10, 0, 0, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (265, 'divider_arm3', 15, 0, 0, 0, 0, 1, 1, 1, '0', '0,0,0', 'C');
INSERT INTO `furniture` VALUES (266, 'divider_arm2', 15, 127, 5, 8, 0, 0, 1, 2, '6', '0,0,0', '');
INSERT INTO `furniture` VALUES (267, 'divider_arm2', 15, 127, 5, 5, 0, 0, 1, 2, '6', '0,0,0', '');
INSERT INTO `furniture` VALUES (268, 'small_table_armas', 15, 127, 8, 5, 0, 0, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (269, 'small_table_armas', 15, 127, 8, 7, 0, 0, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (270, 'small_table_armas', 15, 127, 8, 6, 0, 0, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (271, 'small_table_armas', 15, 127, 9, 5, 0, 0, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (272, 'small_table_armas', 15, 127, 7, 6, 0, 0, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (273, 'small_table_armas', 15, 127, 7, 5, 0, 0, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (274, 'throne', 15, 127, 9, 6, 0, 0, 1, 1, '6', '0,0,0', '');
INSERT INTO `furniture` VALUES (280, 'rare_dragonlamp*0', 15, 0, 6, 5, 0, 1, 1, 1, '2', '#ffffff,#fa2d00,#fa2d00,0,0,0,0', '2');
INSERT INTO `furniture` VALUES (281, 'small_table_armas', 15, 0, 0, 0, 0, 1, 1, 1, '0', '0,0,0', '');
INSERT INTO `furniture` VALUES (282, 'small_table_armas', 15, 127, 7, 7, 0, 0, 1, 1, '0', '0,0,0', '');

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

-- 
-- Table structure for table `furnitureprices`
-- 

CREATE TABLE `furnitureprices` (
  `id` bigint(20) NOT NULL auto_increment,
  `sprite` text NOT NULL,
  `price` bigint(20) NOT NULL,
  `forsale` tinyint(4) NOT NULL,
  `inpage` text NOT NULL,
  `Description` text NOT NULL,
  `shownam` text NOT NULL,
  `colour` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

-- 
-- Dumping data for table `furnitureprices`
-- 

INSERT INTO `furnitureprices` VALUES (1, 'wallpaper', 3, 1, '', '', '', '');
INSERT INTO `furnitureprices` VALUES (2, 'floor', 2, 1, '', '', '', '');
INSERT INTO `furnitureprices` VALUES (3, 'small_table_armas', 2, 1, 'lodge', 'Practical and beautiful', 'Occasional Table', '0,0,0');
INSERT INTO `furnitureprices` VALUES (4, 'small_chair_armas', 1, 1, 'lodge', 'Rustic charm at its best', 'Stool', '0,0,0');
INSERT INTO `furnitureprices` VALUES (5, 'divider_arm3', 6, 1, 'lodge', 'Knock, Knock...', 'Gate (lockable)', '0,0,0');
INSERT INTO `furnitureprices` VALUES (6, 'throne', 1, 0, 'staff', 'Woohoo', 'Throne', '0,0,0');
INSERT INTO `furnitureprices` VALUES (7, 'rare_daffodil_rug', 1, 1, 'staff', 'The green green grass of freedom', 'Petal Patch', '0,0,0');
INSERT INTO `furnitureprices` VALUES (9, 'rclr_sofa', 1, 1, 'staff', '', 'Polar Sofa', '0,0,0');
INSERT INTO `furnitureprices` VALUES (10, 'divider_arm1', 3, 1, 'lodge', 'Good solid wood', 'Corner Plinth', '0,0,0');
INSERT INTO `furnitureprices` VALUES (11, 'rare_dragonlamp*1', 2, 1, 'staff', '', 'Blue Dragon Lamp', '#ffffff,#23238E,#23238E,0,0,0,0');
INSERT INTO `furnitureprices` VALUES (12, 'rare_dragonlamp*0', 1, 1, 'staff', '', 'Red Dragon Lamp', '#ffffff,#fa2d00,#fa2d00,0,0,0,0');
INSERT INTO `furnitureprices` VALUES (13, 'divider_arm3', 1, 1, 'staff', '', 'Lodge Door', '0,0,0');
INSERT INTO `furnitureprices` VALUES (14, 'habbocomputer', 1, 1, 'staff', 'Why not?', 'Computer', '0,0,0');
INSERT INTO `furnitureprices` VALUES (15, 'GlassFloor', 1, 1, 'staff', 'oo, shiney!', 'Glass Floor', '110,0,0');
INSERT INTO `furnitureprices` VALUES (16, 'divider_arm2', 3, 1, 'lodge', '', 'Lodge Bar', '0,0,0');
INSERT INTO `furnitureprices` VALUES (17, 'wallpaper', 2, 1, 'spaces', '', 'Wallpaper', '0,0,0');

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

-- 
-- Table structure for table `furnituretypes`
-- 

CREATE TABLE `furnituretypes` (
  `sprite` text NOT NULL,
  `seat` tinyint(4) NOT NULL,
  `walkable` tinyint(4) NOT NULL,
  `sitstatus` text NOT NULL,
  `length` tinyint(4) NOT NULL default '1',
  `width` tinyint(4) NOT NULL default '1',
  `variable` text NOT NULL,
  `door` smallint(6) NOT NULL,
  `height` double NOT NULL default '1',
  `stackable` smallint(6) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `furnituretypes`
-- 

INSERT INTO `furnituretypes` VALUES ('throne', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_lamp', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_chair', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_pillar', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_table1b', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_sofa1c', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_table2b', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_table2a', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_sofa2c', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_sofa2b', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_sofa2a', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_table1a', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_sofa1b', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_wall2a', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_sofa1a', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_sofa3c', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_sofa3b', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_sofa3a', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_barchair2', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_tablebar', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_pillar2', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_desk1a', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_deski', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_deskh', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_deskg', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_deskf', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_deske', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_wallb', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_walla', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_desk1b', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_desk1c', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_desk1d', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_lamp2', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_cabinet2', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('crl_cabinet1', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('rclr_sofa', 1, 0, 'sit', 1, 2, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('plant_small_cactus', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('divider_arm3', 0, 0, '', 1, 1, 'C', 1, 1, 0);
INSERT INTO `furnituretypes` VALUES ('wallpaper', 0, 0, '', 0, 9, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('floor', 0, 0, '', 0, 9, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('rare_daffodil_rug', 0, 1, '', 2, 2, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('small_table_armas', 0, 0, '', 1, 1, '', 0, 1, 1);
INSERT INTO `furnituretypes` VALUES ('small_chair_armas', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('divider_arm1', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('rare_dragonlamp*1', 0, 0, 'sit', 1, 1, 'ON', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('libchair', 1, 0, 'sit', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('libstool', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('rare_dragonlamp*0', 0, 0, '', 1, 1, '1', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('habbocomputer', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('GlassFloor', 0, 0, '', 1, 1, '', 0, 1, 0);
INSERT INTO `furnituretypes` VALUES ('divider_arm2', 0, 0, '', 1, 2, '', 0, 1, 0);

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

-- 
-- Table structure for table `fuse`
-- 

CREATE TABLE `fuse` (
  `id` bigint(20) NOT NULL auto_increment,
  `code` text NOT NULL,
  `level` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

-- 
-- Dumping data for table `fuse`
-- 

INSERT INTO `fuse` VALUES (1, 'fuse_room_queue_default', 1);
INSERT INTO `fuse` VALUES (2, 'fuse_buy_credits', 1);
INSERT INTO `fuse` VALUES (3, 'fuse_trade', 1);
INSERT INTO `fuse` VALUES (4, 'fuse_login', 1);
INSERT INTO `fuse` VALUES (5, 'default', 1);
INSERT INTO `fuse` VALUES (6, 'fuse_use_special_room_layouts', 2);
INSERT INTO `fuse` VALUES (7, 'fuse_habbo_chooser', 2);
INSERT INTO `fuse` VALUES (8, 'fuse_housekeeping_alert', 8);
INSERT INTO `fuse` VALUES (9, 'fuse_any_room_controller', 8);
INSERT INTO `fuse` VALUES (10, 'fuse_ignore_room_owner', 3);
INSERT INTO `fuse` VALUES (11, 'fuse_pick_up_any_furni', 8);
INSERT INTO `fuse` VALUES (12, 'housekeeping_hobba_newbietools', 5);
INSERT INTO `fuse` VALUES (13, 'fuse_use_club_dance', 2);
INSERT INTO `fuse` VALUES (14, 'fuse_extended_buddylist', 2);
INSERT INTO `fuse` VALUES (15, 'fuse_furni_chooser', 3);
INSERT INTO `fuse` VALUES (16, 'fuse_performance', 1);
INSERT INTO `fuse` VALUES (17, 'fuse_use_special_room_layouts', 2);
INSERT INTO `fuse` VALUES (18, 'housekeeping_kick', 5);
INSERT INTO `fuse` VALUES (19, 'fuse_ban', 5);
INSERT INTO `fuse` VALUES (20, 'fuse_kick', 5);
INSERT INTO `fuse` VALUES (21, 'fuse_kick', 5);

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

-- 
-- Table structure for table `private`
-- 

CREATE TABLE `private` (
  `id` bigint(20) NOT NULL auto_increment,
  `iscat` smallint(6) NOT NULL,
  `incat` bigint(20) NOT NULL,
  `name` text NOT NULL,
  `ownerid` bigint(20) NOT NULL,
  `status` text NOT NULL,
  `curin` int(11) NOT NULL,
  `maxin` int(11) NOT NULL,
  `description` text NOT NULL,
  `password` text NOT NULL,
  `model` text NOT NULL,
  `AEData` text NOT NULL,
  `wallpaper` int(11) NOT NULL default '100',
  `floor` int(11) NOT NULL default '100',
  `heightmap` text NOT NULL,
  `wallitems` text NOT NULL,
  `ispubcat` tinyint(4) NOT NULL,
  `showname` tinyint(4) NOT NULL,
  `allrights` tinyint(4) NOT NULL,
  `door` text NOT NULL,
  `bfdata` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=128 ;

-- 
-- Dumping data for table `private`
-- 

INSERT INTO `private` VALUES (100, 1, 0, 'Leet Rooms', 0, '0', 0, 0, '', '', '', '', 1101, 201, '', '', 9, 0, 0, '', '');
INSERT INTO `private` VALUES (101, 1, 0, 'Nub Rooms', 0, '0', 0, 0, '', '', '', '', 1101, 201, '', '', 1, 0, 0, '', '');
INSERT INTO `private` VALUES (122, 0, 101, 'Passworded Room', 15, 'password', 0, 10, 'Who Owns me?!', '', 'model_a', 'model_a 11559', 201, 111, '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, 0, 0, '3 5 0.0', '');
INSERT INTO `private` VALUES (121, 0, 0, 'Closed Room', 15, 'closed', 0, 25, '', '', 'model_a', 'model_a 11559', 201, 111, '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, 1, 0, '3 5 0.0', '');
INSERT INTO `private` VALUES (120, 0, 0, 'Open Room', 15, 'open', 0, 25, 'Descrption', 'lol', 'model_a', 'model_a 11559', 201, 111, '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, 1, 0, '3 5 0.0', '');
INSERT INTO `private` VALUES (123, 0, 100, 'Woohoo', 15, 'open', 1, 25, ':D|||', '', 'model_a', 'model_a 11559', 2403, 201, '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, 1, 0, '3 5 0.0', '');
INSERT INTO `private` VALUES (125, 0, 100, 'Secret', 14, 'password', 0, 25, 'Yay for jeax!', 'lol', 'model_a', 'model_a 11559', 201, 111, '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, 1, 0, '3 5 0.0', '');
INSERT INTO `private` VALUES (126, 0, 0, ' i hate ali', 14, 'open', 0, 25, '', '', 'model_a', 'model_a 11559lo', 2002, 202, '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, 1, 0, '3 5 0.0', '');
INSERT INTO `private` VALUES (127, 0, 100, 'Teeny weeny room', 15, 'open', 0, 25, 'LOL :D', '', 'model_c', 'model_c 11559', 705, 609, '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', '', 0, 1, 0, '4 7 0.0', '');

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

-- 
-- Table structure for table `privstatic`
-- 

CREATE TABLE `privstatic` (
  `id` bigint(20) NOT NULL auto_increment,
  `model` text NOT NULL,
  `aedata` text NOT NULL,
  `heightmap` text NOT NULL,
  `door` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;

-- 
-- Dumping data for table `privstatic`
-- 

INSERT INTO `privstatic` VALUES (1, 'model_a', 'model_a 11559', '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.0');
INSERT INTO `privstatic` VALUES (2, 'model_b', 'model_b 11559', 'xxxxxxxxxxxx\r\nxxxxx0000000\r\nxxxxx0000000\r\nxxxxx0000000\r\nxxxxx0000000\r\nx00000000000\r\nx00000000000\r\nx00000000000\r\nx00000000000\r\nx00000000000\r\nx00000000000\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx\r\nxxxxxxxxxxxx', '0 5 0.0');
INSERT INTO `privstatic` VALUES (4, 'model_e', 'model_e 11559', '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', '5 9 0.0');
INSERT INTO `privstatic` VALUES (5, 'model_d', 'model_d 11559', '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.0');
INSERT INTO `privstatic` VALUES (6, 'model_e', 'model_e 11559', '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.0');
INSERT INTO `privstatic` VALUES (3, 'model_c', 'model_c 11559', '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.0');

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

-- 
-- Table structure for table `public`
-- 

CREATE TABLE `public` (
  `id` bigint(20) NOT NULL auto_increment,
  `Name` text NOT NULL,
  `CName` text NOT NULL,
  `CCT` text NOT NULL,
  `CurIn` int(11) NOT NULL,
  `MaxIn` int(11) NOT NULL,
  `BFData` text NOT NULL,
  `heightmap` text NOT NULL,
  `door` text NOT NULL,
  `AEData` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `public`
-- 

INSERT INTO `public` VALUES (1, 'Welcome Lounge', 'welcome_lounge', 'hh_room_nlobby', 0, 10, 'http://hotel-ca/client.pub.welcome_lounge.0', '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.0', 'newbie_lobby 11659');
INSERT INTO `public` VALUES (2, 'NetCafé', 'netcafe', 'hh_room_netcafe', 0, 10, 'http://hotel-ca/client.pub.netcafe.0', 'xxxxx1111xxxxxxxxxxx1xxxx\r\nxxxxx1111111111111111xxxx\r\nxxxxx1111111111111111xxxx\r\nxxxxx1111111111111111xxxx\r\nxxxxxxxx0000000000000xxxx\r\n111111100000000000000xxxx\r\n111111100000000000000xxxx\r\n111111100000000000000xxxx\r\nxxxx11100000000000000xxxx\r\nx1xx11100000000000000xxxx\r\nx1xx11100000000000000xxxx\r\nx1xx111000000000000000000\r\nx1xx111000000000000000000\r\nxxxx111000000000000000000\r\nxxxx11100000000000000xxxx\r\nxxxx1110000000xx11111xxxx\r\nxxxxx111110000x111111xxxx\r\nxxxxxx111100001111111xxxx\r\nxxxxxx111100001111111xxxx\r\nxxxxxx111100001111111xxxx\r\nxxxxxx111100001111111xxxx\r\nxxxxxx111100001111111xxxx\r\nxxxxxx111100001111111xxxx\r\nxxxxx1111100001111111xxxx', '22 12 0.0', 'netcafe 11756');
INSERT INTO `public` VALUES (3, 'The Library', 'library', 'hh_room_library', 0, 10, 'http://hotel-uk/client.pub.library.0', '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.0', 'library 15186');

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

-- 
-- Table structure for table `registration`
-- 

CREATE TABLE `registration` (
  `sessticket` text NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `motto` text NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `registration`
-- 

INSERT INTO `registration` VALUES ('lol', 'lollol', 'lol', 'lol', '2007-07-08 19:09:39');

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

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

CREATE TABLE `rights` (
  `roomid` bigint(20) NOT NULL,
  `habboid` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `rights` VALUES (123, 15);

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

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

CREATE TABLE `static` (
  `id` bigint(20) NOT NULL auto_increment,
  `value` text NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

INSERT INTO `static` VALUES (1, 'dcmessage', 'Fack off');

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

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

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL auto_increment,
  `habboname` text NOT NULL,
  `figure` text NOT NULL,
  `sex` text NOT NULL,
  `mission` text NOT NULL,
  `curbadge` text NOT NULL,
  `conmission` text NOT NULL,
  `ssoticket` text NOT NULL,
  `hc` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `passedmonths` int(11) NOT NULL,
  `badgestat` int(11) NOT NULL,
  `credits` bigint(20) NOT NULL,
  `prepaidmonths` bigint(20) NOT NULL,
  `datebought` text NOT NULL,
  `username` text NOT NULL,
  `lastlogin` text NOT NULL,
  `password` text NOT NULL,
  `shockwave` text NOT NULL,
  `ip` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

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

INSERT INTO `users` VALUES (16, 'Noble', '8530319002255042801529510014400', 'M', 'I R NUb', 'HC1', 'Hi', '#', 1, 2, 0, 1, 75, 0, '28/06/2007', 'noble', '28/06/2007 - 23:04:21', 'testpass', '698330748859662007', '70.242.1.243');
INSERT INTO `users` VALUES (15, 'Jeax', '8530419001215042851130005', 'M', 'I am god, hear me roar.', 'ADM', 'Hi', 'local', 1, 9, 0, 1, 999999745, 1, '28/06/2007', 'jeax', '28/06/2007 - 22:59:23', 'irpr0', '#28637705004308062007', '127.0.0.1');
INSERT INTO `users` VALUES (14, 'DisasterPiece', '8530319002255042801529510014400', 'M', 'I R NUb', 'HC1', 'Hi', 'tiket', 1, 0, 0, 0, 0, 0, '28/06/2007', 'disasterpiece', '28/06/2007 - 23:04:21', 'james123', '603181983387182007', '74.14.151.158');

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

-- 
-- Table structure for table `vouchers`
-- 

CREATE TABLE `vouchers` (
  `id` bigint(20) NOT NULL auto_increment,
  `code` text collate latin1_general_ci NOT NULL,
  `value` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `vouchers`
-- 

