CREATE TABLE IF NOT EXISTS `cms_homes_group_linker` (
  `userid` int(11) NOT NULL,
  `groupid` int(11) NOT NULL,
  `active` varchar(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `cms_homes_group_linker`
--

INSERT INTO `cms_homes_group_linker` (`userid`, `groupid`, `active`) VALUES
(7, 2, '0'),
(52, 3, '1'),
(92, 9, '1'),
(41, 11, '0'),
(122, 14, '1'),
(83, 6, '1'),
(246, 19, '1'),
(297, 116, '1'),
(312, 47, '1'),
(315, 28, '1'),
(189, 31, '0'),
(275, 33, '1'),
(241, 34, '0'),
(50, 11, '1'),
(267, 38, '1'),
(90, 40, '1'),
(383, 42, '1'),
(104, 106, '1'),
(285, 49, '0'),
(396, 53, '1'),
(474, 59, '0'),
(446, 62, '1'),
(493, 99, '1'),
(485, 61, '0'),
(164, 67, '1'),
(541, 73, '0'),
(536, 75, '0'),
(527, 77, '1'),
(54, 82, '1'),
(548, 86, '1'),
(582, 105, '1'),
(679, 90, '0'),
(683, 92, '0'),
(116, 15, '1'),
(40, 45, '1'),
(684, 96, '1'),
(648, 95, '0'),
(401, 48, '1'),
(845, 107, '1'),
(835, 108, '0'),
(856, 112, '1'),
(976, 120, '1'),
(929, 122, '1'),
(1000, 124, '1'),
(81, 125, '1'),
(51, 127, '1'),
(960, 118, '1'),
(1058, 138, '1'),
(1022, 130, '1'),
(387, 131, '1'),
(720, 119, '1'),
(1074, 132, '1'),
(127, 137, '1'),
(769, 139, '1');

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

--
-- Structure de la table `cms_homes_inventory`
--

CREATE TABLE IF NOT EXISTS `cms_homes_inventory` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `type` varchar(1) NOT NULL,
  `subtype` varchar(1) NOT NULL,
  `data` text NOT NULL,
  `amount` varchar(3) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5228 ;

--
-- Contenu de la table `cms_homes_inventory`
--

INSERT INTO `cms_homes_inventory` (`id`, `userid`, `type`, `subtype`, `data`, `amount`) VALUES
(3741, 41, '3', '0', 'stickienote', '1'),
(3713, 52, '1', '0', 'edito_logo', '1'),
(3714, 52, '1', '0', 'nl_coinguy_animated', '1'),
(3715, 41, '4', '0', 'bg_metal2', '1'),
(3710, 41, '4', '0', 'alhambragroup', '1'),
(3712, 52, '1', '0', 'it_toilet', '1'),
(3722, 108, '1', '1', 'genie_fire_head', '1'),
(3723, 108, '1', '1', 'olym_spartan', '1'),
(3724, 108, '4', '0', 'bg_pattern_bricks', '1'),
(3721, 108, '1', '0', 'anim_oeil', '1'),
(3725, 50, '1', '0', 'dudesons', '1'),
(3730, 50, '1', '0', 'promofthedead_sticker_zombie', '1'),
(3727, 50, '1', '0', 'bird_suit', '1'),
(3731, 108, '4', '0', 'xmas_bgpattern_starsky', '1'),
(3845, 249, '1', '0', 'sticker_peach', '1'),
(3844, 249, '1', '0', 'sticker_mario', '1'),
(3742, 41, '4', '0', 'bg_tonga', '1'),
(3752, 41, '1', '0', 'letrai', '1'),
(3751, 41, '1', '0', 'r', '2'),
(4456, 627, '1', '0', 'bling_underscore', '2'),
(3749, 41, '1', '0', 't', '1'),
(3758, 125, '1', '0', 'adparty', '1'),
(3757, 54, '3', '0', 'stickienote', '8'),
(3756, 54, '4', '0', 'bg_tonga', '1'),
(3759, 125, '1', '0', 'val_sticker_rosewire_vert', '1'),
(3760, 125, '1', '0', 'val_sticker_storm-costume', '1'),
(3761, 125, '1', '0', 'soccer_dude_3', '1'),
(3762, 125, '1', '0', 'blinghearts', '1'),
(3763, 83, '1', '0', 'kfp_sticker_06', '1'),
(3764, 92, '3', '0', 'stickienote', '3'),
(3765, 149, '1', '0', 'kfp_sticker_07', '1'),
(4452, 603, '3', '0', 'stickienote', '4'),
(3781, 92, '4', '0', 'guidesgroup_bg', '1'),
(3804, 104, '4', '0', 'random_habbos', '1'),
(3803, 91, '4', '0', 'backtoschool_wallpaper', '1'),
(3802, 165, '4', '0', 'bg_habboween', '1'),
(3798, 185, '4', '0', 'habboguide', '1'),
(3794, 41, '4', '0', 'yearbook_wallpaper', '1'),
(3812, 41, '1', '1', 'd', '1'),
(3810, 41, '1', '1', 'a', '1'),
(3811, 41, '1', '1', 'e', '1'),
(3814, 50, '1', '1', 'easter_bunnymoped', '1'),
(3838, 50, '4', '0', 'au_rocktheschools_bg', '1'),
(3837, 104, '3', '0', 'stickienote', '5'),
(3818, 50, '1', '0', 'uk_habbo_x_sticker', '1'),
(3819, 240, '1', '0', 'bling_d', '1'),
(3820, 240, '1', '0', 'bling_a', '1'),
(3821, 240, '1', '0', 'bling_r', '1'),
(3822, 240, '1', '0', 'bling_k', '1'),
(3823, 240, '1', '0', 'bling_star', '2'),
(3824, 240, '1', '0', 'money_stash', '1'),
(3825, 240, '1', '0', 'money_v', '1'),
(3826, 240, '1', '0', 'money_o', '1'),
(3827, 240, '1', '0', 'cny_dragon_head_r', '1'),
(3828, 240, '1', '0', 'cny_dragon_head_l', '1'),
(3829, 240, '1', '0', 'cny_dragon_body_r', '2'),
(3830, 240, '1', '0', 'cny_dragon_body_l', '2'),
(3831, 240, '1', '0', 'ogopogo1', '1'),
(3832, 240, '1', '0', 'darkknight_batman_suit', '1'),
(3833, 240, '1', '0', 'darkknight_logo', '1'),
(3834, 240, '1', '0', 'pro_eco', '1'),
(3835, 240, '1', '0', 'kir_bam_sticker', '1'),
(3836, 240, '1', '0', 'gothic_scienceplatform', '1'),
(3843, 249, '1', '0', 'samsung3', '1'),
(3846, 246, '4', '0', 'bg_broken_glass', '1'),
(4018, 346, '1', '0', 'battle1', '1'),
(3848, 246, '1', '0', 'july408_boom_3', '1'),
(3849, 246, '1', '0', 'july408_boom_4', '1'),
(3850, 246, '1', '0', 'july0408_boom_1', '1'),
(4016, 346, '1', '0', 'kir_stamp4', '1'),
(3853, 246, '1', '0', 'highlighter_mark1', '1'),
(3888, 241, '4', '0', 'bg_broken_glass', '1'),
(3855, 246, '1', '0', 'val_skull360around_anim', '1'),
(3856, 246, '1', '0', 'val_sticker_rosewire_corner', '4'),
(4017, 346, '1', '0', 'streaker', '1'),
(3858, 246, '1', '0', 'skeletor_001', '1'),
(3901, 127, '4', '0', 'bg_vip', '1'),
(3860, 246, '1', '0', 'bobbacurse', '1'),
(3997, 91, '3', '0', 'stickienote', '4'),
(3862, 246, '1', '0', 'sticker_coffee_stain', '1'),
(3863, 246, '1', '0', 'elegant_bling', '2'),
(3864, 246, '1', '0', 'butterfly_01', '2'),
(3865, 246, '1', '0', 'sticker_flower_big_yellow', '1'),
(3866, 246, '1', '0', 'sticker_flower_pink', '2'),
(3867, 246, '1', '0', 'patsday_shamrock', '1'),
(3868, 246, '1', '0', 'summer_cloud3', '3'),
(3869, 246, '1', '0', 'summer_cloud2', '2'),
(3870, 246, '3', '0', 'stickienote', '25'),
(4015, 346, '1', '0', 'sticker_cape', '1'),
(3886, 246, '1', '0', 'bling_c', '1'),
(3994, 281, '4', '0', 'vale_skull_bg', '1'),
(3995, 281, '3', '0', 'stickienote', '4'),
(3996, 346, '1', '0', 'bling_c', '1'),
(4961, 297, '3', '0', 'stickienote', '3'),
(3999, 346, '3', '0', 'stickienote', '5'),
(3998, 346, '4', '0', 'yearbook_wallpaper', '1'),
(3913, 275, '4', '0', 'wallpaper_bonsai', '1'),
(3981, 248, '1', '0', 'o', '1'),
(3982, 248, '1', '0', 'sticker_cape', '1'),
(3983, 248, '1', '0', 'val_skull360around_anim', '1'),
(3984, 248, '1', '0', 'patsday_claddagh', '1'),
(3973, 297, '4', '0', '27835_getitcard_bg', '1'),
(3947, 293, '4', '0', 'val_bgpattern_skull', '1'),
(4783, 215, '1', '0', 'jarppi_guest', '1'),
(3980, 248, '1', '0', 'asterisco1', '1'),
(4289, 485, '4', '0', 'bg_broken_glass', '1'),
(3985, 189, '1', '0', 'bling_a', '2'),
(3986, 189, '1', '0', 'bling_u', '1'),
(3976, 297, '4', '0', 'bg_battle_ball2', '1'),
(3975, 297, '4', '0', 'bg_27372_spi_jap_petit_03', '1'),
(4777, 195, '1', '0', 'val_sticker_rosewire_vert', '3'),
(3945, 118, '4', '0', 'bg_pattern_space', '1'),
(3987, 189, '1', '0', 'bling_r', '1'),
(3988, 189, '1', '0', 'bling_line', '1'),
(3989, 189, '1', '0', 'bling_star', '1'),
(3990, 189, '1', '0', 'bling_t', '2'),
(3991, 189, '1', '0', 'bling_o', '2'),
(3992, 189, '1', '0', 'bling_i', '1'),
(3993, 189, '1', '0', 'bling_n', '1'),
(4012, 275, '4', '0', '26_habbo_background_fi', '1'),
(4014, 346, '1', '0', 'scubacapsule_anim', '1'),
(4013, 346, '1', '0', 'bootsitjalapaset_red', '1'),
(4011, 346, '1', '0', 'sticker_effect_bam', '1'),
(4019, 346, '1', '0', 'battle3', '1'),
(4020, 346, '1', '0', 'clothesline', '1'),
(4021, 346, '1', '0', 'juice', '1'),
(4022, 346, '1', '0', 'nl_coinguy_animated', '1'),
(4023, 346, '4', '0', 'penelope', '1'),
(4068, 104, '4', '0', 'yearbook_wallpaper', '1'),
(4038, 241, '1', '1', 'tiki_skulltiki_r', '1'),
(4039, 241, '1', '1', 'tiki_skulltiki_l', '1'),
(4080, 404, '4', '0', 'bg_comic_sisters', '1'),
(4084, 285, '4', '0', 'bg_hotel', '1'),
(4082, 404, '4', '0', 'hannamontanawp', '1'),
(4067, 337, '4', '0', 'es_calendarbg', '1'),
(4058, 118, '3', '0', 'stickienote', '10'),
(4059, 241, '3', '0', 'stickienote', '4'),
(4066, 337, '4', '0', 'bg_27372_spi_jap_petit_03', '1'),
(4064, 337, '4', '0', '27419_appart732_scene', '1'),
(4065, 337, '4', '0', 'allhabbos_group', '1'),
(4314, 382, '1', '0', 'kir_winner_10', '1'),
(4077, 104, '4', '0', 'allhabbos_group', '1'),
(4081, 404, '4', '0', 'alhambragroup', '1'),
(4682, 285, '4', '0', 'xmas_bgpattern_starsky', '1'),
(4355, 305, '1', '0', 'extreme_dudesons', '1'),
(4099, 344, '1', '0', 'july408_boom_3', '1'),
(4100, 344, '1', '0', 'ogopogo1', '1'),
(4112, 82, '1', '0', 'money_stash', '1'),
(4105, 344, '1', '0', 'sticker_bonsai_ninjama', '1'),
(4106, 344, '1', '0', 'val_sticker_voodoo_suit', '1'),
(4107, 344, '1', '0', 'val_sticker_storm-costume', '1'),
(4108, 344, '1', '0', 'anim_elvis', '1'),
(4113, 82, '1', '0', 'fwrk_yellow', '1'),
(4116, 91, '1', '0', 'sticker_bonsai_ninjama', '1'),
(4356, 305, '4', '0', 'au_rocktheschools_bg', '1'),
(4139, 443, '1', '0', 'g', '1'),
(4306, 164, '1', '1', 'nl_wanted_costume', '1'),
(4300, 164, '1', '1', 'gothic_scienceplatform', '1'),
(4134, 164, '1', '0', 'inked_antisquidm', '1'),
(4135, 164, '1', '0', 'val_sticker_stewardess', '1'),
(4301, 164, '1', '1', 'val_sticker_malecaptain', '1'),
(4302, 164, '3', '0', 'stickienote', '3'),
(4140, 443, '1', '0', 'letrai', '1'),
(4141, 443, '1', '0', 'a', '2'),
(4142, 443, '1', '0', 'd', '1'),
(4143, 446, '4', '0', 'hannamontanawp', '1'),
(4176, 467, '3', '0', 'stickienote', '5'),
(4702, 474, '1', '1', 'summer_cloud2', '2'),
(4159, 469, '4', '0', 'themepark_bg_01', '1'),
(4160, 469, '1', '0', 'anim_appart_732', '1'),
(4161, 285, '4', '0', 'val_bgpattern_love', '1'),
(4793, 215, '1', '0', 'soccer_dude_2', '1'),
(4792, 215, '1', '0', 'sticker_arrow_up', '1'),
(4732, 297, '4', '0', 'bg_videogamesgroup', '1'),
(4791, 215, '1', '0', 'sticker_chips', '1'),
(4168, 467, '1', '0', 'icecube_big', '1'),
(4230, 485, '1', '0', 'val_sticker_stewardess', '1'),
(4174, 467, '4', '0', 'au_rocktheschools_bg', '1'),
(4175, 467, '4', '0', 'expert_backround', '1'),
(4177, 467, '1', '0', 'bling_c', '1'),
(4178, 467, '1', '0', 'bling_a', '1'),
(4179, 467, '1', '0', 'bling_r', '1'),
(4180, 467, '1', '0', 'bling_m', '1'),
(4181, 467, '1', '0', 'bling_e', '1'),
(4182, 467, '1', '0', 'bling_n', '1'),
(4183, 467, '1', '0', 'bling_exclamation', '1'),
(4291, 485, '1', '0', 'sticker_pointing_hand_1', '1'),
(4228, 485, '1', '0', 'inked_antisquidf', '1'),
(4434, 474, '4', '0', 'val_bgpattern_love', '1'),
(4191, 457, '4', '0', 'bg_bg_infobus_white', '1'),
(4290, 485, '4', '0', 'bg_hotel', '1'),
(4264, 473, '1', '0', 'darkknight_logo', '1'),
(4222, 485, '1', '0', 'july408_boom_2', '2'),
(4293, 312, '4', '0', 'vale_skull_bg', '1'),
(4281, 66, '1', '0', 'ca_hockeygoalie2', '1'),
(4268, 473, '1', '0', 'highlighter_mark6', '1'),
(4217, 480, '4', '0', 'hc_bg_pillow', '1'),
(4276, 473, '1', '0', 'nl_coinguy_animated', '1'),
(4275, 473, '1', '0', 'lamp_2', '1'),
(4267, 473, '1', '0', 'highlighter_1', '1'),
(4266, 473, '1', '0', 'sticker_effect_bam', '1'),
(4262, 473, '1', '0', 'fwrk_yellow', '1'),
(4233, 446, '1', '1', 'veronicas', '1'),
(4270, 473, '1', '0', 'sticker_bonsai_ninjama', '1'),
(4235, 485, '1', '0', 'val_sticker_bartender2', '1'),
(4236, 446, '1', '1', 'jared', '1'),
(4274, 473, '1', '0', 'hw_inmate', '1'),
(4269, 473, '1', '0', 'anim_hockey', '1'),
(4261, 473, '1', '0', 'fwrk_blue', '1'),
(4288, 485, '4', '0', 'alhambragroup', '1'),
(4242, 485, '1', '0', 'nl_coinguy_animated', '1'),
(4272, 473, '1', '0', 'guard2', '1'),
(4271, 473, '1', '0', 'bear', '1'),
(4252, 485, '4', '0', 'bg_bubble', '1'),
(4248, 485, '1', '0', 'beachbunny_bunny_suit', '1'),
(4273, 473, '1', '0', 'hw_bouncers', '1'),
(4250, 485, '4', '0', 'bg_dark_floors', '1'),
(4251, 485, '3', '0', 'stickienote', '9'),
(4292, 485, '1', '0', 'elegant_bling', '1'),
(4284, 92, '4', '0', 'themepark_bg_01', '1'),
(4285, 92, '1', '1', 'bg_groupinfo', '4'),
(4286, 92, '1', '1', 'anim_brasero', '11'),
(4287, 66, '4', '0', '27419_appart732_scene', '1'),
(4295, 164, '4', '0', 'bg_battle_ball2', '1'),
(4296, 164, '4', '0', 'bg_lido_flat', '1'),
(4297, 164, '4', '0', 'bg_tonga', '1'),
(4298, 164, '4', '0', 'hc_bg_machine', '1'),
(4299, 164, '4', '0', 'random_habbos', '1'),
(4311, 164, '1', '0', 'darkknight_jokerface', '1'),
(4315, 382, '1', '0', 'val_sticker_bartender', '1'),
(4348, 536, '3', '0', 'stickienote', '2'),
(4334, 541, '4', '0', 'alhambragroup', '1'),
(4840, 484, '4', '0', 'bg_rain', '1'),
(4323, 382, '4', '0', 'hc_bg_pillow', '1'),
(4357, 484, '1', '0', 'beachbunny_beachball_bouncing', '1'),
(4354, 397, '4', '0', '27835_getitcard_bg', '1'),
(4841, 484, '3', '0', 'stickienote', '4'),
(5014, 981, '1', '0', 'trax_latin', '1'),
(4360, 484, '1', '0', 'olym_jandelee', '1'),
(4361, 484, '1', '0', 'cn_teleskull', '1'),
(4846, 187, '4', '0', 'bg_hotel', '1'),
(4847, 187, '3', '0', 'stickienote', '5'),
(4364, 592, '4', '0', 'bg_vip', '1'),
(4490, 474, '4', '0', 'bg_pattern_bobbaskulls1', '1'),
(4451, 603, '4', '0', 'fantasticfour', '1'),
(4378, 546, '4', '0', 'fantastic4', '1'),
(4497, 582, '3', '0', 'stickienote', '12'),
(4377, 546, '4', '0', 'bg_grass', '1'),
(4477, 474, '3', '0', 'stickienote', '3'),
(4390, 546, '1', '1', 'bling_line', '1'),
(4496, 582, '4', '0', 'bg_tonga', '1'),
(4396, 546, '4', '0', 'bg_solid_black', '1'),
(4394, 546, '1', '1', 'deal_goth_border_ver', '1'),
(4395, 546, '3', '0', 'stickienote', '5'),
(4476, 474, '1', '1', 'sticker_maquillage', '1'),
(4453, 603, '4', '0', 'wallpaper_earthday', '1'),
(4455, 548, '4', '0', 'bg_27372_spi_jap_petit_03', '1'),
(4428, 41, '1', '1', 'm', '1'),
(4427, 41, '1', '1', 'o', '2'),
(4457, 627, '1', '0', 'bling_k', '1'),
(4458, 627, '1', '0', 'bling_e', '1'),
(4459, 627, '1', '0', 'bling_r', '1'),
(4460, 627, '1', '0', 'bling_g', '1'),
(4461, 627, '1', '0', 'july0408_boom_1', '2'),
(4462, 627, '1', '0', 'ogopogo1', '1'),
(4463, 401, '1', '0', 'val_sticker_stewardess2', '1'),
(4464, 401, '1', '0', 'val_sticker_bartender2', '1'),
(4465, 401, '1', '0', 'val_sticker_crew', '1'),
(4466, 401, '1', '0', 'val_sticker_bartender', '1'),
(4467, 401, '1', '0', 'valcaptain', '1'),
(4468, 401, '1', '0', 'traxgoldrecord', '1'),
(4651, 541, '4', '0', 'allhabbos_group', '1'),
(4470, 401, '1', '0', 'beachbunny_bmovieposter', '1'),
(4492, 474, '1', '1', 'gf_hotornot_blue', '1'),
(4491, 474, '1', '1', 'fiesta_minifalda_2', '1'),
(4487, 127, '1', '1', 'it_habbohome', '1'),
(4498, 582, '4', '0', 'bg_infobus_yellow', '1'),
(4506, 679, '4', '0', 'bg_bg_infobus_white', '1'),
(4654, 541, '1', '0', 'hw_mega_afro', '1'),
(4510, 683, '4', '0', '27368_kaatissakki_tausta', '1'),
(4509, 655, '4', '0', 'au_rocktheschools_bg_v2', '1'),
(4655, 541, '1', '0', 'july0408_boom_1', '1'),
(4515, 683, '1', '1', 'jigoku_shojo_1', '1'),
(4649, 474, '4', '0', 'bg_grass', '1'),
(4672, 513, '4', '0', 'penelope', '1'),
(4653, 541, '1', '0', 'sticker_moonpig', '1'),
(4644, 474, '1', '1', 'highlighter_2', '1'),
(4643, 474, '1', '1', 'fwrk_pink', '1'),
(4642, 474, '1', '1', 'jp_5years', '1'),
(4641, 474, '1', '1', 'fwrk_blue', '1'),
(4640, 401, '4', '0', 'nl_green_bg', '1'),
(4652, 541, '1', '0', 'habbo_x_home_sticker', '1'),
(4531, 575, '1', '0', 'sticker_effect_woosh', '1'),
(4676, 513, '1', '0', 'wood_m', '1'),
(4533, 575, '1', '0', 'sticker_cape', '1'),
(4671, 474, '1', '1', 'diamond_reward', '1'),
(4536, 575, '1', '0', 'highlighter_mark3', '1'),
(4674, 513, '4', '0', 'top_gamers_bg', '1'),
(4538, 575, '1', '0', 'lovebed', '1'),
(4665, 73, '1', '0', 'bear', '1'),
(4541, 575, '1', '0', 'val_cupido_anim', '1'),
(4675, 513, '1', '0', 'bonbon_mouse_146x146', '1'),
(4591, 575, '1', '1', 'valentine_welcome_sticker', '1'),
(4663, 499, '1', '0', 'sticker_caballoons', '1'),
(4660, 499, '1', '0', 'fwrk_yellow', '1'),
(4547, 575, '1', '0', 'cn_teleskull', '1'),
(4661, 499, '1', '0', 'newyear_2007_anim', '1'),
(4550, 575, '1', '0', 'burger', '1'),
(4658, 499, '1', '0', 'uk_pixel_maze_sticker', '1'),
(4552, 575, '1', '0', 'clothesline', '1'),
(4554, 575, '1', '0', 'juice', '1'),
(4555, 575, '1', '0', 'plaster', '1'),
(4650, 474, '4', '0', 'bg_solid_black', '1'),
(4558, 575, '1', '0', 'sticker_flames', '2'),
(4559, 575, '1', '0', 'sticker_hole', '1'),
(4560, 575, '1', '0', 'sticker_romantic', '1'),
(4561, 575, '1', '0', 'nl_coinguy_animated', '1'),
(4659, 499, '1', '0', 'fwrk_blue', '1'),
(4563, 575, '1', '0', 'sticker_peach', '1'),
(4564, 575, '1', '0', 'finger_push', '1'),
(4662, 499, '1', '0', 'hc_hat', '1'),
(4566, 575, '1', '0', 'football', '1'),
(4567, 575, '1', '0', 'blingblingstars', '1'),
(4568, 575, '1', '0', 'blinghearts', '1'),
(4625, 683, '4', '0', 'bg_colour_01', '1'),
(4593, 684, '1', '0', 'bigdaddyv', '1'),
(4595, 648, '1', '0', 'teensbear', '1'),
(4596, 648, '1', '0', 'globalw_sticker', '1'),
(4574, 575, '1', '0', 'easter_carrot_rocket', '1'),
(4673, 513, '4', '0', '27419_appart732_scene', '1'),
(4576, 575, '1', '0', 'sticker_flower1', '1'),
(4577, 575, '1', '0', 'patsday_claddagh', '1'),
(4725, 749, '1', '1', 'hc_hat', '1'),
(4657, 499, '1', '0', 'money_stash', '1'),
(4656, 541, '1', '0', 'july408_boom_3', '1'),
(4594, 684, '1', '1', 'elegant_bling', '1'),
(4582, 575, '1', '0', 'beachbunny_beachball_bouncing', '1'),
(4583, 575, '1', '0', 'summer_cloud3', '1'),
(4584, 575, '1', '0', 'summer_cloud2', '1'),
(4585, 575, '1', '0', 'summer_cloud1', '1'),
(4586, 575, '1', '0', 'summer_kite', '1'),
(4785, 215, '1', '0', 'hw_drummer_boy', '1'),
(4776, 195, '1', '0', 'val_sticker_rosewire_corner', '3'),
(4589, 575, '4', '0', 'skulls_wallpaper', '1'),
(4590, 575, '3', '0', 'stickienote', '5'),
(4677, 513, '1', '0', 'wood_i', '1'),
(4681, 285, '3', '0', 'stickienote', '4'),
(4680, 474, '1', '1', 'sticker_croco', '1'),
(4806, 836, '3', '0', 'stickienote', '4'),
(4782, 215, '1', '0', 'fi_posti_box', '1'),
(4742, 749, '1', '0', 'diner_hotrod', '1'),
(4790, 215, '1', '0', 'lamp_3', '1'),
(4708, 536, '4', '0', 'alhambragroup', '1'),
(4787, 215, '1', '0', 'hw_actionstar', '1'),
(4788, 215, '1', '0', 'hw_kenny_shock', '1'),
(4762, 582, '4', '0', 'bg_infobus_blue', '1'),
(4916, 297, '1', '1', 'spiderwick_goblin_anim_l', '1'),
(4737, 749, '4', '0', 'bg_broken_glass', '1'),
(4709, 536, '1', '0', 'alhambralogo', '1'),
(4786, 215, '1', '0', 'hw_bassplayer_boy', '1'),
(4784, 215, '1', '0', 'jukka_guest2', '1'),
(4794, 215, '1', '0', 'football', '1'),
(4795, 215, '1', '0', 'nl_football_guest', '1'),
(4796, 215, '1', '0', 'patsday_potogold', '1'),
(4797, 215, '1', '0', 'habbo_island', '1'),
(4798, 215, '1', '0', 'summer_skateboard', '1'),
(4799, 215, '1', '0', 'summer_kite', '1'),
(4800, 215, '1', '0', 'cena', '1'),
(4801, 215, '1', '0', 'batista', '1'),
(4802, 215, '1', '0', 'reymysterio', '1'),
(4803, 215, '4', '0', '27835_getitcard_bg', '1'),
(4804, 215, '4', '0', 'allhabbos_group', '1'),
(4917, 925, '4', '0', 'hw_val_bgpattern_love', '1'),
(4839, 835, '4', '0', 'bg_pattern_hearts', '1'),
(4854, 848, '4', '0', 'bg_vip', '1'),
(4850, 856, '3', '0', 'stickienote', '5'),
(4826, 104, '4', '0', 'top_gamers_bg_64', '1'),
(4827, 104, '4', '0', 'jp_valentine', '1'),
(5011, 981, '1', '0', 'leafs1', '2'),
(5077, 81, '4', '0', 'vale_rose_bg', '1'),
(5012, 981, '1', '0', 'leafs2', '2'),
(5009, 981, '1', '0', 'bling_star', '1'),
(5081, 81, '1', '0', 'nigirisushi', '1'),
(5080, 81, '1', '0', 'sticker_bonsai_ninjama', '1'),
(5008, 981, '1', '0', 'bling_a', '1'),
(4994, 929, '1', '0', 'olym_inari', '1'),
(5007, 981, '1', '0', 'bling_i', '1'),
(5083, 81, '1', '0', 'sticker_bonsai_samuraifa', '1'),
(4992, 929, '4', '0', 'bg_bg_infobus_white', '1'),
(5082, 81, '1', '0', 'kitune_fighting', '1'),
(5075, 81, '3', '0', 'stickienote', '4'),
(4901, 943, '4', '0', '27835_getitcard_bg', '1'),
(4900, 943, '1', '0', 'soccer_dude_2', '1'),
(4899, 943, '1', '0', 'cheshirecat', '1'),
(4897, 943, '1', '0', 'dudesons', '1'),
(4898, 943, '1', '0', 'genie_fire_head', '1'),
(5038, 981, '1', '0', 'val_sticker_croco', '1'),
(4962, 973, '1', '0', 'cn_teleskull', '1'),
(4963, 973, '4', '0', 'bg_battle_ball2', '1'),
(4922, 297, '1', '1', 'tiki_skulltiki_r', '1'),
(4923, 297, '1', '1', 'bling_s', '2'),
(4924, 297, '1', '1', 'bling_e', '3'),
(4998, 929, '3', '0', 'stickienote', '3'),
(4926, 297, '1', '1', 'bling_t', '1'),
(5078, 81, '1', '1', 'bling_dot', '1'),
(4928, 297, '1', '1', 'bling_p', '1'),
(4929, 297, '1', '1', 'bling_r', '2'),
(4930, 297, '1', '1', 'bling_i', '1'),
(4931, 297, '1', '1', 'bling_c', '2'),
(4932, 297, '1', '1', 'tiki_volcano', '1'),
(4959, 297, '1', '1', 'deal_goth_border_hor', '1'),
(5015, 981, '1', '0', 'july408_boom_2', '1'),
(4937, 297, '1', '1', 'bling_n', '1'),
(4938, 297, '1', '1', 'hw_moh_logo', '1'),
(4939, 297, '1', '1', 'bling_a', '2'),
(5079, 81, '1', '0', 'sticker_bonsai_ninjafa', '1'),
(5026, 981, '1', '0', 'genie_fire_head', '1'),
(4986, 929, '1', '0', 'val_sticker_stewardess2', '1'),
(4945, 297, '1', '1', 'sticker_pointing_hand_1', '1'),
(4946, 297, '1', '1', 'needle_1', '1'),
(4948, 297, '1', '1', 'needle_2', '1'),
(5028, 981, '1', '0', 'hw_hairspray', '1'),
(5010, 981, '1', '0', 'money_stash', '1'),
(5016, 981, '1', '0', 'july408_boom_3', '1'),
(5017, 981, '1', '0', 'july408_boom_4', '1'),
(5018, 981, '1', '0', 'july0408_boom_1', '1'),
(5019, 981, '1', '0', 'newyear_sparkler', '1'),
(5020, 981, '1', '0', 'cny_kungfu_girl', '1'),
(5029, 981, '1', '0', 'hw_val_sticker_love-costume', '1'),
(5022, 981, '1', '0', 'diner_gaspump_red', '1'),
(5023, 981, '1', '0', 'diner_hotrod', '1'),
(5024, 981, '1', '0', 'sticker_effect_burp', '1'),
(5025, 981, '1', '0', 'hat_clown2', '1'),
(5027, 981, '1', '0', 'hw_bouncers', '1'),
(5033, 981, '1', '0', 'anim_elvis', '1'),
(5031, 981, '1', '0', 'hw_shades', '1'),
(5032, 981, '1', '0', 'hw_speedobunny', '1'),
(5034, 981, '1', '0', 'lovebed', '1'),
(5035, 981, '1', '0', 'val_lovedice', '1'),
(5036, 981, '1', '0', 'sticker_heartbeat', '1'),
(5037, 981, '1', '0', 'val_sticker_cupid_arrow', '1'),
(5048, 769, '4', '0', 'val_bgpattern_love', '1'),
(5040, 769, '1', '0', 'bling_l', '1'),
(5041, 981, '1', '0', 'val_sticker_rosewire_corner', '1'),
(5047, 769, '1', '1', 'bling_e', '1'),
(5049, 769, '4', '0', 'bg_rain', '1'),
(5072, 81, '1', '1', 'bling_l', '1'),
(5051, 981, '4', '0', 'bg_hotel', '1'),
(5076, 81, '4', '0', 'top_gamers_bg_64', '1'),
(5084, 81, '1', '0', 'sticker_bonsai_samuraima', '1'),
(5061, 769, '1', '1', 'val_sticker_rosewire_horis', '1'),
(5058, 769, '3', '0', 'stickienote', '4'),
(5073, 81, '1', '1', 'bling_u', '1'),
(5071, 81, '1', '1', 'bling_b', '1'),
(5074, 81, '4', '0', '27419_appart732_scene', '1'),
(5085, 81, '1', '0', 'sticker_heartbeat', '1'),
(5086, 81, '4', '0', 'expert_backround', '1'),
(5099, 855, '1', '1', 'nl_downtown_costume', '1'),
(5104, 769, '1', '1', 'bling_star', '1'),
(5226, 769, '1', '1', 'bling_o', '1'),
(5227, 769, '1', '1', 'bling_b', '1'),
(5097, 855, '4', '0', 'au_rocktheschools_bg', '1'),
(5098, 855, '4', '0', 'bg_vip', '1'),
(5106, 51, '4', '0', 'makeover', '1'),
(5107, 999, '1', '0', 'money_stash', '1'),
(5108, 999, '1', '0', 'addogs', '1'),
(5109, 999, '1', '0', 'trax_electro', '1'),
(5110, 999, '1', '0', 'tiki_volcano', '1'),
(5112, 1049, '1', '0', 'trax_heavy', '1'),
(5113, 1049, '1', '0', 'trax_rock', '1'),
(5114, 1049, '1', '0', 'hw_bassplayer_boy', '1'),
(5115, 1049, '1', '0', 'hw_keyboards1', '1'),
(5116, 1049, '1', '0', 'hw_bassplayer_girl', '1'),
(5117, 1049, '1', '0', 'habbo_x_home_sticker', '1'),
(5134, 1022, '1', '0', 'bling_o', '1'),
(5132, 1022, '1', '0', 'bling_i', '2'),
(5133, 1022, '1', '0', 'bling_u', '1'),
(5130, 1022, '1', '0', 'undertaker', '1'),
(5131, 1022, '1', '0', 'bling_l', '1'),
(5123, 401, '1', '1', 'uk_habbo_x_sticker', '1'),
(5139, 1022, '4', '0', 'bg_vip', '1'),
(5129, 1058, '3', '0', 'stickienote', '17'),
(5127, 401, '3', '0', 'stickienote', '4'),
(5128, 1058, '4', '0', 'vale_skull_bg', '1'),
(5136, 1022, '1', '0', 'cny_kunfu_dude', '1'),
(5154, 387, '3', '0', 'stickienote', '4'),
(5174, 720, '1', '0', 'pro_eco', '1'),
(5150, 387, '4', '0', 'bg_tonga', '1'),
(5173, 720, '1', '0', 'july408_boom_2', '1'),
(5172, 720, '1', '0', 'july408_auntsamantha', '1'),
(5186, 720, '1', '1', 'limo_windowpiece', '2'),
(5170, 720, '1', '0', 'gothic_draculacape', '1'),
(5179, 720, '4', '0', 'bg_vip', '1'),
(5175, 720, '1', '0', 'val_sticker_stewardess2', '1'),
(5176, 720, '1', '0', 'hw_bartender_costume', '1'),
(5180, 720, '3', '0', 'stickienote', '5'),
(5178, 720, '1', '0', 'diamond_reward', '2'),
(5185, 720, '1', '1', 'limo_front', '1'),
(5183, 720, '1', '0', 'limo_doorpiece', '1'),
(5184, 720, '1', '0', 'limo_back', '1'),
(5191, 931, '4', '0', 'bg_bonsai', '1'),
(5192, 1058, '4', '0', 'summer_bg', '1'),
(5193, 1058, '1', '0', 'patsday_kissme', '1'),
(5194, 1058, '1', '0', 'patsday_shamrock', '1'),
(5201, 1087, '1', '1', 'a', '1'),
(5217, 1087, '1', '0', 'diamond_reward', '1'),
(5208, 1087, '4', '0', 'bg_broken_glass', '1'),
(5220, 1087, '1', '0', 'elegant_bling', '1'),
(5224, 769, '1', '0', 'val_cupido_anim', '1');

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

--
-- Structure de la table `cms_homes_stickers`
--

CREATE TABLE IF NOT EXISTS `cms_homes_stickers` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `x` varchar(6) NOT NULL default '1' COMMENT 'left',
  `y` varchar(6) NOT NULL default '1' COMMENT 'top',
  `z` varchar(6) NOT NULL default '1' COMMENT 'z-index',
  `data` text NOT NULL,
  `type` varchar(1) NOT NULL default '1',
  `subtype` varchar(1) NOT NULL default '0' COMMENT 'Widget Type (if widget)',
  `skin` text NOT NULL,
  `groupid` int(11) NOT NULL default '-1',
  `var` int(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5934 ;

--
-- Contenu de la table `cms_homes_stickers`
--


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

--
-- Structure de la table `cms_minimail`
--

CREATE TABLE IF NOT EXISTS `cms_minimail` (
  `senderid` int(11) NOT NULL,
  `to_id` int(11) default NULL,
  `subject` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL,
  `message` text NOT NULL,
  `read_mail` enum('0','1') NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  `deleted` int(10) default '0',
  `conversationid` int(10) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1174 ;

--
-- Contenu de la table `cms_minimail`
--


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

--
-- Structure de la table `cms_news`
--

CREATE TABLE IF NOT EXISTS `cms_news` (
  `num` int(4) NOT NULL auto_increment,
  `title` text collate latin1_general_ci NOT NULL,
  `category` text collate latin1_general_ci NOT NULL,
  `topstory` varchar(100) collate latin1_general_ci NOT NULL,
  `short_story` text collate latin1_general_ci NOT NULL,
  `story` longtext collate latin1_general_ci NOT NULL,
  `date` date NOT NULL,
  `author` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`num`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS' AUTO_INCREMENT=38 ;

--
-- Contenu de la table `cms_news`
--

INSERT INTO `cms_news` (`num`, `title`, `category`, `topstory`, `short_story`, `story`, `date`, `author`) VALUES
(37, 'Ritorna', 'HoloCMS', 'http://images.habbohotel.es/c_images/Top_Story_Images/ts_indios.gif', 'return', 'Ragazzi Siamo di nuovo online sempre noi HabboBoss Hotel con nuovo server + potente :D', '2009-03-01', 'Hotelfico');

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

--
-- Structure de la table `cms_noobgifts`
--

CREATE TABLE IF NOT EXISTS `cms_noobgifts` (
  `id` int(20) NOT NULL auto_increment,
  `userid` int(30) NOT NULL,
  `gift` int(2) NOT NULL,
  `read` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `cms_noobgifts`
--


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

--
-- Structure de la table `cms_recommended`
--

CREATE TABLE IF NOT EXISTS `cms_recommended` (
  `id` int(10) NOT NULL auto_increment,
  `rec_id` int(10) default NULL,
  `type` varchar(10) default 'group',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Contenu de la table `cms_recommended`
--


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

--
-- Structure de la table `cms_system`
--

CREATE TABLE IF NOT EXISTS `cms_system` (
  `sitename` varchar(30) collate latin1_general_ci NOT NULL,
  `shortname` varchar(30) collate latin1_general_ci NOT NULL,
  `site_closed` enum('0','1') collate latin1_general_ci NOT NULL COMMENT 'Maintenance Mode',
  `enable_sso` enum('0','1') collate latin1_general_ci NOT NULL,
  `language` varchar(2) collate latin1_general_ci NOT NULL,
  `ip` varchar(50) collate latin1_general_ci NOT NULL,
  `port` varchar(5) collate latin1_general_ci NOT NULL,
  `texts` varchar(250) collate latin1_general_ci NOT NULL,
  `variables` varchar(250) collate latin1_general_ci NOT NULL,
  `dcr` varchar(250) collate latin1_general_ci NOT NULL,
  `reload_url` varchar(250) collate latin1_general_ci NOT NULL,
  `localhost` enum('0','1') collate latin1_general_ci NOT NULL COMMENT 'Local server?',
  `start_credits` int(11) NOT NULL default '0',
  `admin_notes` text collate latin1_general_ci NOT NULL,
  `loader` int(1) NOT NULL default '1',
  `analytics` text collate latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';

--
-- Contenu de la table `cms_system`
--

INSERT INTO `cms_system` (`sitename`, `shortname`, `site_closed`, `enable_sso`, `language`, `ip`, `port`, `texts`, `variables`, `dcr`, `reload_url`, `localhost`, `start_credits`, `admin_notes`, `loader`, `analytics`) VALUES
('HabboWeeks', 'Habbo', '0', '1', 'en', '127.0.0.1', '21', 'http://www.habbohotel.fr/gamedata/external?id=external_texts', 'http://espacedcr.power-heberg.com/V26/external_variables.txt', 'http://espacedcr.power-heberg.com/V26/habbo.dcr', 'http://5.182.46.219/client.php', '1', 50000, '..!', 0, '');

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

--
-- Structure de la table `cms_tags`
--

CREATE TABLE IF NOT EXISTS `cms_tags` (
  `id` int(255) NOT NULL auto_increment,
  `ownerid` int(11) NOT NULL default '0',
  `tag` varchar(25) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS' AUTO_INCREMENT=758 ;

--
-- Contenu de la table `cms_tags`
--


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

--
-- Structure de la table `cms_transactions`
--

CREATE TABLE IF NOT EXISTS `cms_transactions` (
  `id` int(11) NOT NULL auto_increment,
  `date` varchar(20) NOT NULL,
  `amount` varchar(10) NOT NULL,
  `descr` text NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;

--
-- Contenu de la table `cms_transactions`
--

INSERT INTO `cms_transactions` (`id`, `date`, `amount`, `descr`, `userid`) VALUES
(1, '19-02-2009 14:14:02', '5000', 'Welcome to tuo hotel!', 1),
(2, '19-02-2009 14:15:29', '-20', 'Club subscription (1 month(s))', 1),
(3, '22-02-2009 09:57:56', '5000', 'Welcome to HabboBoss!', 2),
(4, '01-03-2009 19:43:05', '50000', 'Welcome to HabboBoss!', 3),
(5, '01-03-2009 19:44:42', '50000', 'Welcome to HabboBoss!', 4),
(6, '01-03-2009 19:45:44', '50000', 'Welcome to HabboBoss!', 5),
(7, '01-03-2009 19:47:13', '-80', 'Club subscription (6 month(s))', 5),
(8, '01-03-2009 19:51:14', '50000', 'Welcome to HabboBoss!', 6),
(9, '01-03-2009 19:52:03', '50000', 'Welcome to HabboBoss!', 7),
(10, '01-03-2009 19:52:48', '50000', 'Welcome to HabboBoss!', 8),
(11, '01-03-2009 19:54:07', '-80', 'Club subscription (6 month(s))', 8),
(12, '01-03-2009 19:56:05', '25', 'Collectable Purchase', 7),
(13, '02-03-2009 14:53:51', '50000', 'Welcome to HabboBoss!', 9),
(14, '02-03-2009 14:57:25', '50000', 'Welcome to HabboBoss!', 10),
(15, '02-03-2009 14:58:12', '-80', 'Club subscription (6 month(s))', 10),
(16, '02-03-2009 15:00:30', '50000', 'Welcome to HabboBoss!', 11),
(17, '02-03-2009 15:03:22', '-20', 'Club subscription (1 month(s))', 11),
(18, '02-03-2009 15:04:47', '50000', 'Welcome to HabboBoss!', 12),
(19, '02-03-2009 15:15:41', '50000', 'Welcome to HabboBoss!', 13),
(20, '02-03-2009 15:16:27', '50000', 'Welcome to HabboBoss!', 14),
(21, '02-03-2009 15:17:47', '50000', 'Welcome to HabboBoss!', 15),
(22, '02-03-2009 15:18:19', '50000', 'Welcome to HabboBoss!', 16),
(23, '02-03-2009 15:19:09', '-80', 'Club subscription (6 month(s))', 14),
(24, '02-03-2009 15:19:15', '-20', 'Club subscription (1 month(s))', 15),
(25, '02-03-2009 15:19:46', '50000', 'Welcome to HabboBoss!', 17),
(26, '02-03-2009 15:19:49', '50000', 'Welcome to HabboBoss!', 18),
(27, '02-03-2009 15:20:36', '-20', 'Club subscription (1 month(s))', 16),
(28, '02-03-2009 15:26:50', '25', 'Collectable Purchase', 16),
(29, '02-03-2009 15:30:24', '-80', 'Club subscription (6 month(s))', 12),
(30, '02-03-2009 15:33:09', '50000', 'Welcome to HabboBoss!', 19),
(31, '02-03-2009 15:34:25', '50000', 'Welcome to HabboBoss!', 20),
(32, '02-03-2009 15:34:38', '-80', 'Club subscription (6 month(s))', 19),
(33, '02-03-2009 15:35:11', '50000', 'Welcome to HabboBoss!', 21),
(34, '02-03-2009 15:41:26', '-80', 'Club subscription (6 month(s))', 21),
(35, '02-03-2009 15:47:51', '50000', 'Welcome to HabboBoss!', 22),
(36, '02-03-2009 15:51:26', '50000', 'Welcome to HabboBoss!', 23),
(37, '02-03-2009 15:53:26', '50000', 'Welcome to HabboBoss!', 24),
(38, '02-03-2009 15:54:28', '-80', 'Club subscription (6 month(s))', 22),
(39, '02-03-2009 15:56:05', '-50', 'Club subscription (3 month(s))', 24),
(40, '02-03-2009 15:56:31', '50000', 'Welcome to HabboBoss!', 25),
(41, '02-03-2009 15:57:10', '-20', 'Club subscription (1 month(s))', 18),
(42, '02-03-2009 16:07:21', '50000', 'Welcome to HabboBoss!', 26),
(43, '02-03-2009 16:27:36', '50000', 'Welcome to HabboBoss!', 27),
(44, '02-03-2009 16:32:05', '50000', 'Welcome to HabboBoss!', 28),
(45, '02-03-2009 16:49:14', '50000', 'Welcome to HabboBoss!', 29),
(46, '02-03-2009 16:53:17', '-20', 'Club subscription (1 month(s))', 29),
(47, '02-03-2009 16:55:04', '50000', 'Welcome to HabboBoss!', 30),
(48, '02-03-2009 16:56:05', '-20', 'Club subscription (1 month(s))', 20),
(49, '02-03-2009 16:57:17', '25', 'Collectable Purchase', 20),
(50, '02-03-2009 17:02:44', '50000', 'Welcome to HabboBoss!', 31),
(51, '02-03-2009 17:03:20', '-20', 'Club subscription (1 month(s))', 28),
(52, '02-03-2009 17:18:04', '50000', 'Welcome to HabboBoss!', 32),
(53, '02-03-2009 17:50:56', '50000', 'Welcome to HabboBoss!', 33),
(54, '05-03-2009 20:58:55', '50000', 'Welcome to HabboBoss!', 34),
(55, '05-03-2009 21:43:27', '50000', 'Welcome to HabboBoss!', 35),
(56, '05-03-2009 21:44:49', '-80', 'Club subscription (6 month(s))', 35),
(57, '11/10/2009 17:09:38', '50000', 'Welcome to HabboBoss!', 22);

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

--
-- Structure de la table `cms_wardrobe`
--

CREATE TABLE IF NOT EXISTS `cms_wardrobe` (
  `userid` int(11) NOT NULL,
  `slotid` varchar(1) NOT NULL,
  `figure` text NOT NULL,
  `gender` varchar(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `cms_wardrobe`
--

INSERT INTO `cms_wardrobe` (`userid`, `slotid`, `figure`, `gender`) VALUES
(1, '1', 'hr-678-59.hd-180-8.ch-235-110.lg-275-110.sh-295-110.he-1609-96.wa-2005-.ha-1012-110.ca-1804-96', 'M'),
(19, '1', 'hr-831-35.hd-180-3.ch-886-92.lg-285-82.sh-906-64.ca-1816-.wa-2003-', 'M');

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

--
-- Structure de la table `events`
--

CREATE TABLE IF NOT EXISTS `events` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `description` varchar(100) default NULL,
  `userid` int(10) default NULL,
  `roomid` int(10) default NULL,
  `category` int(10) default NULL,
  `date` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Contenu de la table `events`
--


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

--
-- Structure de la table `furniture`
--

CREATE TABLE IF NOT EXISTS `furniture` (
  `id` int(10) NOT NULL auto_increment COMMENT 'The ID of this item',
  `tid` int(10) NOT NULL COMMENT 'The template ID of this item',
  `ownerid` int(10) NOT NULL COMMENT 'The ID of the user that owns this item',
  `roomid` int(10) NOT NULL COMMENT 'The room ID the item is in. If it''s 0, then it''s in the hand of OWNERID, if it''s -1, then it''s in a present and not opened yet, if it''s -2, then it''s in the Recycler',
  `x` smallint(6) NOT NULL COMMENT 'The X of the item in a room',
  `y` smallint(6) NOT NULL COMMENT 'The Y of the item in a room',
  `z` smallint(6) NOT NULL COMMENT 'The Z [rotation] of the item in a room',
  `h` double(4,2) NOT NULL default '0.00' COMMENT 'The H [height, double] of the item in a room',
  `var` text collate latin1_general_ci COMMENT 'The variable of the item, specifying it''s turned on/off etc, :S',
  `wallpos` varchar(200) collate latin1_general_ci default NULL COMMENT 'Wallitems only. The location on the wall where the item is',
  `teleportid` int(10) default NULL COMMENT 'Teleporters only. The ID of the teleporter that links to this one',
  `soundmachine_soundset` int(2) default NULL,
  `soundmachine_machineid` int(10) default NULL,
  `soundmachine_slot` int(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=477 ;

--
-- Contenu de la table `furniture`
--

INSERT INTO `furniture` (`id`, `tid`, `ownerid`, `roomid`, `x`, `y`, `z`, `h`, `var`, `wallpos`, `teleportid`, `soundmachine_soundset`, `soundmachine_machineid`, `soundmachine_slot`) VALUES
(436, 24200, 1, 148, 10, 6, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(435, 24200, 1, 148, 10, 5, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(428, 1002, 1, 148, 0, 0, 0, 0.00, '2,1,2,#0053F7,77', ':w=7,0 l=3,87 r', NULL, NULL, NULL, NULL),
(434, 24200, 1, 148, 10, 4, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(433, 13603, 1, 148, 4, 6, 0, 0.00, '3', NULL, NULL, NULL, NULL, NULL),
(430, 13590, 1, 148, 7, 12, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(431, 13602, 1, 148, 7, 4, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(432, 13603, 1, 148, 4, 4, 0, 0.00, '3', NULL, NULL, NULL, NULL, NULL),
(437, 30003, 22, 175, 4, 4, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(438, 30002, 22, 175, 0, 0, 0, 0.00, NULL, ':w=10,0 l=29,73 r', NULL, NULL, NULL, NULL),
(439, 30004, 22, 175, 8, 3, 2, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(440, 3005, 22, 175, 11, 1, 2, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(441, 30001, 22, 175, 11, 2, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(442, 3009, 22, 175, 11, 4, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(443, 13598, 22, 175, 9, 1, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(444, 13602, 22, 175, 4, 11, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(445, 13602, 22, 175, 6, 11, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(446, 24000, 22, 175, 5, 9, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(447, 19000, 22, 175, 5, 13, 0, 1.00, NULL, NULL, NULL, NULL, NULL, NULL),
(448, 248830, 22, 175, 7, 1, 4, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(449, 538, 22, 175, 9, 5, 2, 0.00, NULL, NULL, 450, NULL, NULL, NULL),
(450, 538, 22, 0, 0, 0, 0, 0.00, NULL, NULL, 449, NULL, NULL, NULL),
(452, 2030, 22, 175, 10, 8, 0, 0.00, '2', NULL, NULL, NULL, NULL, NULL),
(453, 2029, 22, 175, 10, 6, 0, 0.00, '2', NULL, NULL, NULL, NULL, NULL),
(454, 2028, 22, 0, 0, 0, 0, 0.00, '2', NULL, NULL, NULL, NULL, NULL),
(455, 26000, 22, 0, 0, 0, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(456, 26001, 22, 175, 9, 13, 4, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(457, 26003, 22, 175, 4, 7, 4, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(458, 13585, 22, 175, 0, 0, 0, 0.00, NULL, ':w=3,8 l=0,70 l', NULL, NULL, NULL, NULL),
(474, 2028, 22, 175, 10, 7, 0, 0.00, '2', NULL, NULL, NULL, NULL, NULL),
(473, 1002, 22, 175, 0, 0, 0, 0.00, '1,1,1,#000000,155', ':w=10,0 l=5,47 r', NULL, NULL, NULL, NULL),
(459, 1002, 22, 175, 0, 0, 0, 0.00, '1,1,1,#000000,155', ':w=3,3 l=20,52 l', NULL, NULL, NULL, NULL),
(460, 1814, 22, 175, 5, 10, 0, 0.00, '1', NULL, NULL, NULL, NULL, NULL),
(461, 1871, 22, 175, 4, 1, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(462, 1868, 22, 0, 0, 0, 0, 0.00, 'FALSE', NULL, 463, NULL, NULL, NULL),
(463, 1868, 22, 0, 0, 0, 0, 0.00, 'FALSE', NULL, 462, NULL, NULL, NULL),
(464, 1874, 22, 175, 5, 2, 2, 0.00, '2', NULL, NULL, NULL, NULL, NULL),
(465, 190005, 22, 0, 0, 0, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(466, 190008, 22, 175, 0, 0, 0, 0.00, NULL, ':w=5,0 l=3,67 r', NULL, NULL, NULL, NULL),
(467, 238831, 22, 0, 0, 0, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(468, 24300, 22, 0, 0, 0, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(469, 1244, 22, 0, 0, 0, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(470, 190010, 22, 0, 0, 0, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(471, 538, 22, 177, 10, 2, 0, 0.00, NULL, NULL, 472, NULL, NULL, NULL),
(472, 538, 22, 177, 10, 1, 0, 0.00, NULL, NULL, 471, NULL, NULL, NULL),
(475, 1360, 22, 177, 11, 1, 2, 0.00, NULL, NULL, NULL, NULL, NULL, NULL),
(476, 1334, 22, 177, 11, 2, 0, 0.00, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Structure de la table `furniture_moodlight`
--

CREATE TABLE IF NOT EXISTS `furniture_moodlight` (
  `id` int(11) NOT NULL,
  `roomid` int(11) NOT NULL,
  `preset_cur` int(1) NOT NULL default '0',
  `preset_1` varchar(75) collate latin1_general_ci default NULL,
  `preset_2` varchar(75) collate latin1_general_ci default NULL,
  `preset_3` varchar(75) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`id`,`roomid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `furniture_moodlight`
--

INSERT INTO `furniture_moodlight` (`id`, `roomid`, `preset_cur`, `preset_1`, `preset_2`, `preset_3`) VALUES
(428, 148, 1, '2, #0053F7, 77', '1,#000000,155', '1,#000000,155'),
(459, 175, 1, '1,#000000,155', '1,#000000,155', '1,#000000,155'),
(473, 175, 1, '1,#000000,155', '1,#000000,155', '1,#000000,155');

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

--
-- Structure de la table `furniture_presents`
--

CREATE TABLE IF NOT EXISTS `furniture_presents` (
  `id` int(10) NOT NULL,
  `itemid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `furniture_presents`
--


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

--
-- Structure de la table `furniture_stickies`
--

CREATE TABLE IF NOT EXISTS `furniture_stickies` (
  `id` int(10) NOT NULL,
  `text` text collate latin1_general_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `furniture_stickies`
--

INSERT INTO `furniture_stickies` (`id`, `text`) VALUES
(355, ' aula matematica\r');

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

--
-- Structure de la table `games_lobbies`
--

CREATE TABLE IF NOT EXISTS `games_lobbies` (
  `id` int(10) NOT NULL,
  `type` enum('bb') collate latin1_general_ci NOT NULL default 'bb',
  `rank` varchar(50) collate latin1_general_ci NOT NULL,
  `bb_allowedpowerups` text collate latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `games_lobbies`
--

INSERT INTO `games_lobbies` (`id`, `type`, `rank`, `bb_allowedpowerups`) VALUES
(113, 'bb', 'Beginner', '1,2,3,4,5,6,7,8'),
(114, 'bb', 'Amateur', '1,2,3,4,5,6,7,8'),
(115, 'bb', 'Intermediate', '1,2,3,4,5,6,7,8'),
(116, 'bb', 'Expert', '1,2,3,4,5,6,7,8'),
(117, 'bb', '1337', '1,2,3,4,5,6,7,8'),
(118, '', 'Beginner', '1,2,3,4,5,6,7,8'),
(119, '', 'Amateur', '1,2,3,4,5,6,7,8'),
(120, '', 'Intermediate', '1,2,3,4,5,6,7,8'),
(121, '', 'Intermediate', '1,2,3,4,5,6,7,8'),
(122, '', '1337', '1,2,3,4,5,6,7,8');

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

--
-- Structure de la table `games_maps`
--

CREATE TABLE IF NOT EXISTS `games_maps` (
  `type` enum('ss','bb') collate latin1_general_ci NOT NULL,
  `id` enum('6','5','4','3','2','1') collate latin1_general_ci NOT NULL default '1',
  `heightmap` text collate latin1_general_ci NOT NULL,
  `bb_tilemap` text collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `games_maps`
--

INSERT INTO `games_maps` (`type`, `id`, `heightmap`, `bb_tilemap`) VALUES
('bb', '5', 'xxxx000000000000000xxxx\rxxxx000000000000000xxxx\rxxxx000000000000000xxxx\rxxxx000000000000000xxxx\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\r00000000000000000000000\rxxxx000000000000000xxxx\rxxxx000000000000000xxxx\rxxxx000000000000000xxxx\rxxxx000000000000000xxxx\r', '00001111111111111110000\r00001111111111111110000\r00001111111111111110000\r00001111111111111110000\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r11111111111111111111111\r00001111111111111110000\r00001111111111111110000\r00001111111111111110000\r00001111111111111110000\r'),
('bb', '3', '0000000x000x0000xxxxxxxxxxxxxxxxx\r0xx00x0x0x0000000111000xxxxxxxxxx\r0xx00x0x0x00000001110000xxxxxxxxx\r0000xx000xxx0000xxxxxx000xxxxxxxx\r000xxxxxxxxxxxxxxxxxxxx000xxxxxxx\r0xxxxxxxxxxxxxxxxxxxxxxx000xxxxxx\r0000xxxxxxxxxxxxxxxxxxxxx000xxxxx\rxxx0xxx111111111111111xxx0x0xxxxx\r0000xxx111111111111111xxx0x0x0xxx\r0xxxxxx111111111111111xxx0x0x0xxx\r000xxxx1111111111111111000x00000x\rx00xxxx1111111111111111000x0x0xxx\r0000xxx111112222211111xxxxxxx0000\r0000xxx111112222211111xxx000xxxx0\r0000xxx111112222211111xxx000000x0\r0000xxx111112222211111xxx000xx0x0\rx00xxxx111112222211111xxxxxxx0000\rx11xxxx11111111111111110000000xxx\rx11xxxx11111111111111110000000xxx\rx11xxxx111111111111111xxx0xxxxxxx\rx00xxxx111111111111111xxx000xxxxx\rx00xxxx111111111111111xxxxxxxxxxx\rx000xxxxxx11xxxxx11xxxxxxxxxxxxxx\rxx000xxxxx00xxxxx00xxxxxxxxxxxxxx\rxxx000xxxx00xxxxx00xxxxxxxxxxxxxx\rxxxx00000000x000x0000xxxxxxxxxxxx\rxxxxx00xxxxxx000x00x0xxxxxxxxxxxx\rxxxxxx000000x000x00x0xxxxxxxxxxxx\rxxxxxxxxxx0xxx0xx00xxxxxxxxxxxxxx\rxxxxxxxx00000x0x000xxxxxxxxxxxxxx\rxxxxxxxxxx0x0x000xxxxxxxxxxxxxxxx\rxxxxxxxxxx0x0xxx0xxxxxxxxxxxxxxxx\rxxxxxxxxxxxx00000xxxxxxxxxxxxxxxx\r', '111100000000111100000000000000000\r100100000000111100000000000000000\r100100000000111100000000000000000\r111100000000111100000000000000000\r000000000000000000000000000000000\r000000000000000000000000000000000\r000000000000000000000000000000000\r000000011111110111111100000000000\r000000011111110111111100000000000\r000000011111110111111100000000000\r000000011111110111111100000000000\r000000011110000000111100000000000\r111100011110000000111100000000000\r111100011110011100111100011100000\r111100000000011100000000011100000\r111100011110011100111100011100000\r000000011110000000111100000000000\r000000011110000000111100000000000\r000000011111110111111100000000000\r000000011111110111111100000000000\r000000011111110111111100000000000\r000000011111110111111100000000000\r000000000000000000000000000000000\r000000000000000000000000000000000\r000000000000000000000000000000000\r000000000000011100000000000000000\r000000000000011100000000000000000\r000000000000011100000000000000000\r000000000000000000000000000000000\r000000000000000000000000000000000\r000000000000000000000000000000000\r000000000000000000000000000000000\r000000000000000000000000000000000\r'),
('bb', '1', 'xxxxxxxxxxxxx444444xxxxxxxxx\rxxxxxxxxxxxxx444444xxxxxxxxx\rxxxxxxxxxxxxx444444xxxxxxxxx\rxxx22222222xx444444xxxxxxxxx\rxxx22222222xx444444xxxxxxxxx\rxxx22222222xx333333xxxxxxxxx\rxxx22222222xx222222xxxxxxxxx\rxxx222222222222222222xxxxxxx\rxxx222222222222222222xxxxxxx\rxxx2222222222222222222100000\rxxx2222222222222222222100000\rxxxxxxx222222222222222100000\rxxxxxxx222222222222222100000\r4444432222222222222222100000\r4444432222222222222222100000\r444443222222222222222xxxxxxx\r444443222222222222222xxxxxxx\r4444432222222222222222222xxx\r4444432222222222222222222xxx\rxxxxxxx222222222222222222xxx\rxxxxxxx222222222222222222xxx\rxxxxxxxxx222222xx22222222xxx\rxxxxxxxxx111111xx22222222xxx\rxxxxxxxxx000000xx22222222xxx\rxxxxxxxxx000000xx22222222xxx\rxxxxxxxxx000000xxxxxxxxxxxxx\rxxxxxxxxx000000xxxxxxxxxxxxx\rxxxxxxxxx000000xxxxxxxxxxxxx\r', '0000000000000111111000000000\r0000000000000111111000000000\r0000000000000111111000000000\r0001111111100111111000000000\r0001111111100000000000000000\r0001111111100000000000000000\r0001111111100000000000000000\r0001111111111111111110000000\r0001111111111111111110000000\r0001111111111111111110001111\r0001111111111111111110001111\r0000000111111111111110001111\r0000000111111111111110001111\r1111000111111111111110001111\r1111000111111111111110001111\r1111000111111111111110000000\r1111000111111111111110000000\r1111000111111111111111110000\r1111000111111111111111110000\r0000000111111111111111111000\r0000000111111111111111111000\r0000000000000000011111111000\r0000000000000000011111111000\r0000000000000000011111111000\r0000000001111110011111111000\r0000000001111110000000000000\r0000000001111110000000000000\r0000000001111110000000000000\r'),
('bb', '2', 'xxxxxxx00000000xxx00000000xxxxxxx\rxxxxxxx00000000xxx00000000xxxxxxx\rxxxxxxx00000000xxx00000000xxxxxxx\rxxxxxxx0000000000000000000xxxxxxx\rxxxxxxx0000000000000000000xxxxxxx\rxxxxxxx0000000000000000000xxxxxxx\rxxxxxxx00000000xxx00000000xxxxxxx\r2222xxx00000000xxx00000000xxx2222\r2222xxx00000000xxx00000000xxx2222\r222221000000000xxx000000000122222\r222221000000000xxx000000000122222\r2222xxx00000000xxx00000000xxx2222\r2222xxx00000000xxx00000000xxx2222\rxxxxxxx00000000xxx00000000xxxxxxx\rxxxxxxx0000000000000000000xxxxxxx\rxxxxxxx0000000000000000000xxxxxxx\rxxxxxxx0000000000000000000xxxxxxx\rxxxxxxx00000000xxx00000000xxxxxxx\rxxxxxxx00000000xxx00000000xxxxxxx\rxxxxxxx00000000xxx00000000xxxxxxx\r', '000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r111100011111111000111111110001111\r111100011111111000111111110001111\r111100011111111000111111110001111\r111100011111111000111111110001111\r111100011111111000111111110001111\r111100011111111000111111110001111\r000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r000000011111111000111111110000000\r'),
('bb', '4', 'xxxxxxx222222222222222xxxxxxxx\rxxxxxxx222222222222222xxxxxxxx\rxxxxxxx222222222222222xxxxxxxx\rxxxxxxx222222222222222xxxxxxxx\rxxxxxxx222222222222222xxxxxxxx\r00012222222222222222222211111x\r00012222222222222222222211111x\r00012222222222222222222211111x\r00012222222222222222222211111x\r00xxxxx222222222222222xxx1111x\r000xxxx222222222222222xxx0000x\r0000xxx222222222222222x0000000\r0000xxx22222222222222210000000\r0000xxx22222222222222210000000\r0000xxx222222222222222x0000000\r0000xxx222222222222222xxxxxxxx\r00000xx222222222222222xxxxxxxx\r000000xxxx11xx11xx11xxxxxxxxxx\rx0000000000000000000000xxxxxxx\rxx000000000000000000000xxxxxxx\rxxx00000000000000000000xxxxxxx\rxxxx0000000000000000000xxxxxxx\r', '000000011111111111111100000000\r000000011111111111111100000000\r000000011111111111111100000000\r000000011111111111111100000000\r000000011111111111111100000000\r000000011111111111111100011110\r000000011111111111111100011110\r000000011111111111111100011110\r000000011111111111111100011110\r110000011111111111111100000000\r111000011111111111111100000000\r111100011111111111111101111111\r111100011111111111111101111111\r111100011111111111111101111111\r111100011111111111111101111111\r111100011111111111111100000000\r111110011111111111111100000000\r111111000000000000000000000000\r011111111111111111111110000000\r001111111111111111111110000000\r000111111111111111111110000000\r000011111111111111111110000000\r');

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

--
-- Structure de la table `games_maps_playerspawns`
--

CREATE TABLE IF NOT EXISTS `games_maps_playerspawns` (
  `type` enum('ss','bb') collate latin1_general_ci NOT NULL default 'bb',
  `mapid` enum('6','5','4','3','2','1') collate latin1_general_ci NOT NULL,
  `teamid` enum('3','2','1','0') collate latin1_general_ci NOT NULL,
  `x` int(11) NOT NULL,
  `y` int(11) NOT NULL,
  `z` enum('9','8','7','6','5','4','3','2','1','0') collate latin1_general_ci NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `games_maps_playerspawns`
--

INSERT INTO `games_maps_playerspawns` (`type`, `mapid`, `teamid`, `x`, `y`, `z`) VALUES
('bb', '5', '0', 22, 11, '6'),
('bb', '5', '1', 0, 11, '2'),
('bb', '5', '2', 11, 22, '0'),
('bb', '5', '3', 11, 0, '4'),
('bb', '1', '0', 0, 15, '2'),
('bb', '1', '1', 27, 12, '6'),
('bb', '1', '2', 12, 27, '0'),
('bb', '1', '3', 15, 0, '4'),
('bb', '2', '0', 0, 9, '2'),
('bb', '2', '1', 32, 10, '6'),
('bb', '2', '2', 14, 9, '6'),
('bb', '2', '3', 18, 9, '2'),
('bb', '4', '3', 21, 8, '6'),
('bb', '4', '2', 7, 8, '2'),
('bb', '4', '1', 14, 0, '4'),
('bb', '4', '0', 14, 16, '0'),
('bb', '3', '0', 21, 14, '6'),
('bb', '3', '1', 7, 14, '2'),
('bb', '3', '2', 14, 21, '0'),
('bb', '3', '3', 14, 7, '4');

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

--
-- Structure de la table `games_ranks`
--

CREATE TABLE IF NOT EXISTS `games_ranks` (
  `id` int(5) NOT NULL auto_increment,
  `type` enum('ss','bb') collate latin1_general_ci NOT NULL default 'bb',
  `title` varchar(50) collate latin1_general_ci NOT NULL,
  `minpoints` int(10) NOT NULL,
  `maxpoints` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=11 ;

--
-- Contenu de la table `games_ranks`
--

INSERT INTO `games_ranks` (`id`, `type`, `title`, `minpoints`, `maxpoints`) VALUES
(1, 'bb', 'Beginner', 0, 10000),
(2, 'bb', 'Amateur', 10001, 100000),
(3, 'bb', 'Intermediate', 100001, 500000),
(4, 'bb', 'Expert', 500001, 10000000),
(5, 'bb', '1337', 10000001, 0),
(6, 'ss', 'Beginner', 0, 10000),
(7, 'ss', 'Amateur', 10001, 100000),
(8, 'ss', 'Intermediate', 100001, 500000),
(9, 'ss', 'Expert', 500001, 10000000),
(10, 'ss', '1337', 10000001, 0);

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

--
-- Structure de la table `groups_details`
--

CREATE TABLE IF NOT EXISTS `groups_details` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(45) collate latin1_general_ci NOT NULL,
  `description` varchar(200) collate latin1_general_ci NOT NULL,
  `ownerid` int(10) NOT NULL,
  `roomid` int(10) NOT NULL,
  `created` varchar(50) collate latin1_general_ci NOT NULL,
  `badge` text collate latin1_general_ci NOT NULL,
  `type` int(1) NOT NULL default '0',
  `recommended` int(1) NOT NULL default '0',
  `views` int(15) NOT NULL,
  `pane` smallint(1) NOT NULL default '0',
  `topics` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Contenu de la table `groups_details`
--


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

--
-- Structure de la table `groups_memberships`
--

CREATE TABLE IF NOT EXISTS `groups_memberships` (
  `userid` int(10) NOT NULL,
  `groupid` int(10) NOT NULL,
  `member_rank` enum('3','2','1') collate latin1_general_ci NOT NULL default '3',
  `is_current` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  `is_pending` enum('0','1') collate latin1_general_ci NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `groups_memberships`
--


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

--
-- Structure de la table `messenger_friendrequests`
--

CREATE TABLE IF NOT EXISTS `messenger_friendrequests` (
  `userid_from` int(10) NOT NULL default '0',
  `userid_to` int(10) NOT NULL default '0',
  `requestid` int(10) NOT NULL default '0',
  PRIMARY KEY  (`userid_from`,`userid_to`,`requestid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `messenger_friendrequests`
--

INSERT INTO `messenger_friendrequests` (`userid_from`, `userid_to`, `requestid`) VALUES
(1, 11, 1),
(19, 8, 1);

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

--
-- Structure de la table `messenger_friendships`
--

CREATE TABLE IF NOT EXISTS `messenger_friendships` (
  `userid` bigint(20) NOT NULL,
  `friendid` bigint(20) NOT NULL,
  KEY `index extreme` (`userid`),
  KEY `extreme the 2nd` (`friendid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `messenger_friendships`
--

INSERT INTO `messenger_friendships` (`userid`, `friendid`) VALUES
(2, 1),
(7, 1),
(7, 5),
(8, 7),
(10, 12),
(12, 1),
(16, 1),
(19, 1);

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

--
-- Structure de la table `messenger_messages`
--

CREATE TABLE IF NOT EXISTS `messenger_messages` (
  `userid` int(15) NOT NULL,
  `friendid` int(15) NOT NULL,
  `messageid` int(11) NOT NULL,
  `sent_on` text collate latin1_general_ci NOT NULL,
  `message` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`userid`,`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `messenger_messages`
--


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

--
-- Structure de la table `pets`
--

CREATE TABLE IF NOT EXISTS `pets` (
  `name` varchar(5) character set latin1 collate latin1_general_ci NOT NULL,
  `age` int(3) NOT NULL,
  `sex` int(1) NOT NULL default '0',
  `colour` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default ' '
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `pets`
--


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

--
-- Structure de la table `poll`
--

CREATE TABLE IF NOT EXISTS `poll` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `rid` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `thanks` varchar(255) NOT NULL,
  PRIMARY KEY  (`pid`),
  UNIQUE KEY `pid` (`pid`,`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `poll`
--


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

--
-- Structure de la table `poll_answers`
--

CREATE TABLE IF NOT EXISTS `poll_answers` (
  `aid` int(11) NOT NULL,
  `qid` int(11) NOT NULL,
  `answer` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `poll_answers`
--


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

--
-- Structure de la table `poll_questions`
--

CREATE TABLE IF NOT EXISTS `poll_questions` (
  `qid` int(10) unsigned NOT NULL auto_increment,
  `pid` int(11) NOT NULL,
  `question` varchar(255) NOT NULL,
  `type` enum('1','2','3') NOT NULL,
  `min` int(11) NOT NULL,
  `max` int(11) NOT NULL,
  UNIQUE KEY `qid` (`qid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `poll_questions`
--


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

--
-- Structure de la table `poll_results`
--

CREATE TABLE IF NOT EXISTS `poll_results` (
  `pid` int(11) NOT NULL,
  `qid` int(11) NOT NULL,
  `aid` int(11) NOT NULL,
  `answers` varchar(255) NOT NULL,
  `uid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `poll_results`
--


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

--
-- Structure de la table `ranks`
--

CREATE TABLE IF NOT EXISTS `ranks` (
  `rankid` int(1) NOT NULL,
  `rankname` varchar(15) collate latin1_general_ci default NULL,
  `ignoreFilter` int(1) NOT NULL,
  `receiveCFH` int(1) NOT NULL,
  `enterAllRooms` int(1) NOT NULL,
  `seeAllOwners` int(1) NOT NULL,
  `adminCatalogue` int(1) NOT NULL,
  `staffFloor` int(1) NOT NULL,
  `rightsEverywhere` int(4) NOT NULL,
  PRIMARY KEY  (`rankid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `ranks`
--


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

--
-- Structure de la table `rank_fuserights`
--

CREATE TABLE IF NOT EXISTS `rank_fuserights` (
  `id` int(3) NOT NULL auto_increment,
  `minrank` int(1) NOT NULL,
  `fuseright` varchar(100) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`,`fuseright`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=51 ;

--
-- Contenu de la table `rank_fuserights`
--

INSERT INTO `rank_fuserights` (`id`, `minrank`, `fuseright`) VALUES
(1, 1, 'default'),
(2, 1, 'fuse_login'),
(3, 1, 'fuse_buy_credits'),
(4, 1, 'fuse_trade'),
(5, 1, 'fuse_room_queue_default'),
(6, 2, 'fuse_extended_buddylist'),
(7, 2, 'fuse_habbo_chooser'),
(8, 2, 'fuse_furni_chooser'),
(9, 2, 'fuse_room_queue_club'),
(10, 2, 'fuse_priority_access'),
(11, 2, 'fuse_use_special_room_layouts'),
(12, 2, 'fuse_use_club_dance'),
(13, 3, 'fuse_enter_full_rooms'),
(14, 4, 'fuse_enter_locked_rooms'),
(16, 4, 'fuse_kick'),
(17, 4, 'fuse_mute'),
(18, 5, 'fuse_ban'),
(19, 5, 'fuse_room_mute'),
(20, 5, 'fuse_room_kick'),
(21, 5, 'fuse_receive_calls_for_help'),
(22, 5, 'fuse_remove_stickies'),
(23, 6, 'fuse_mod'),
(24, 6, 'fuse_superban'),
(25, 6, 'fuse_pick_up_any_furni'),
(26, 6, 'fuse_ignore_room_owner'),
(27, 6, 'fuse_any_room_controller'),
(28, 3, 'fuse_room_alert'),
(29, 6, 'fuse_moderator_access'),
(30, 7, 'fuse_administrator_access'),
(31, 7, 'fuse_see_flat_ids'),
(50, 6, 'fuse_credits');

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

--
-- Structure de la table `rarevalue`
--

CREATE TABLE IF NOT EXISTS `rarevalue` (
  `id` int(15) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default 'Empty slot',
  `img` varchar(64) NOT NULL default 'noimg',
  `value` decimal(15,2) NOT NULL default '1.00',
  `valuestate` varchar(1) NOT NULL default '0' COMMENT '0 = no change, 1 = value increase, 2 = value decrease',
  `releasestate` varchar(1) NOT NULL default '0' COMMENT '0 = new, 1 = released',
  `category` varchar(1) NOT NULL,
  `last_update` varchar(64) NOT NULL default '2008-06-28',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=221 ;

--
-- Contenu de la table `rarevalue`
--

INSERT INTO `rarevalue` (`id`, `name`, `img`, `value`, `valuestate`, `releasestate`, `category`, `last_update`) VALUES
(1, 'Throne', 'throne', 62.00, '1', '1', '1', '?'),
(2, 'Club Sofa', 'clubsofa', 1.00, '0', '1', '1', '28-06-2008?20:00'),
(3, 'Petal Patch', 'petalpatch', 3.00, '1', '1', '1', '?'),
(36, 'Green BirdBath', 'BirdBath_green', 3.50, '0', '1', '1', '?'),
(218, 'Traffic Light', 'Trafficlights', 0.50, '0', '1', '1', '?'),
(38, 'AloeVera', 'aloevera', 4.50, '0', '1', '1', '?'),
(39, 'Blue Amber', 'Amber_blue', 2.00, '0', '1', '1', '?'),
(40, 'Red Amber', 'amber_red', 2.00, '0', '1', '1', '?'),
(41, 'Gold Amber', 'Amber_yellow', 4.00, '0', '1', '1', '?'),
(42, 'Blue Bear ', 'Bear_Blue', 0.50, '0', '1', '1', '?'),
(43, 'Green Bear Rug', 'Bear_Green', 0.50, '0', '1', '1', '?'),
(44, 'Yellow Bear Rug', 'Bear_Yellow', 0.50, '0', '1', '1', '?'),
(45, 'Blue BirdBath', 'Birdbath_Blue', 82.00, '0', '1', '1', '?'),
(46, 'Silver BirdBath', 'BirdBath_Grey', 12.00, '0', '1', '1', '?'),
(47, 'Red BirdBath', 'BirdBath_Red', 82.00, '0', '1', '1', '?'),
(48, 'Blue Hyacith', 'Bluehyacinth', 0.10, '0', '1', '2', '?'),
(49, 'Bulrush', 'Bullrushes', 0.50, '0', '1', '1', '?'),
(50, 'Habboween Cauldron', 'Cauldron', 0.90, '0', '1', '3', '?'),
(51, 'Chains', 'Chains', 0.10, '0', '1', '3', '?'),
(52, 'Cola Machine', 'ColaMachine', 1.00, '0', '1', '1', '?'),
(53, 'Creepy Crypt', 'Crypt', 0.50, '0', '1', '3', '?'),
(54, 'Dead Duck', 'DeadDuck', 0.10, '0', '1', '3', '?'),
(55, 'Dead Duck 2', 'DeadDuck2', 0.10, '0', '1', '3', '?'),
(56, 'Dead Duck 3', 'DeadDuck3', 0.10, '0', '1', '3', '?'),
(57, 'Disco Sign', 'Disco', 0.50, '0', '1', '1', '?'),
(58, 'DJ Decks', 'DJDecks', 3.20, '0', '1', '1', '?'),
(59, 'Serpent Of Doom', 'Dragon_Black', 1.50, '0', '1', '1', '?'),
(60, 'Bronze Dragon', 'Dragon_Bronze', 36.00, '0', '1', '1', '?'),
(61, 'Elf Dragon', 'Dragon_Elf', 1.00, '0', '1', '1', '?'),
(62, 'Red Dragon', 'Dragon_Fire', 1.00, '0', '1', '1', '?'),
(63, 'Gold Dragon', 'Dragon_Gold', 372.00, '0', '1', '1', '?'),
(64, 'Jade Dragon', 'Dragon_Jade', 1.20, '0', '1', '1', '?'),
(65, 'Purple Dragon', 'Dragon_Purple', 288.00, '0', '1', '1', '?'),
(66, 'Sea Dragon', 'Dragon_sea', 1.00, '0', '1', '1', '?'),
(67, 'Silver Dragon', 'Dragon_Silver', 90.00, '0', '1', '1', '?'),
(68, 'Sky Dragon', 'Dragon_sky', 226.00, '0', '1', '1', '?'),
(69, 'Dragon Egg', 'Dragonegg', 104.00, '0', '1', '1', '?'),
(70, 'Blue Fan', 'Fan_blue', 3.50, '0', '1', '1', '?'),
(71, 'Brown Fan', 'Fan_Brown', 40.00, '0', '1', '1', '?'),
(72, 'HC Bookcase', 'hc_bookcase', 0.50, '2', '1', '4', '?'),
(73, 'HC Butler', 'hc_butler', 5.00, '0', '1', '4', '?'),
(74, 'HC Carpet', 'hc_carpet', 0.50, '0', '1', '4', '?'),
(75, 'Antique Drapery', 'hc_curtain', 0.25, '0', '1', '4', '?'),
(76, 'Dice Master', 'hc_dicem', 0.50, '0', '1', '4', '?'),
(77, 'Heavy Duty Fireplace', 'hc_fireplace', 0.80, '0', '1', '4', '?'),
(78, 'Pink Fan', 'fan_fuchsia', 2.50, '0', '1', '1', '?'),
(79, 'HC Grammophon', 'hc_grammophon', 0.50, '0', '1', '4', '?'),
(80, 'Ochre Fan', 'Fan_Ochre', 1.00, '0', '1', '1', '?'),
(81, 'Imperial Teleporters', 'hc_imps', 1.00, '0', '1', '4', '?'),
(82, 'Victorian Street Light', 'hc_lamp', 0.50, '0', '1', '4', '?'),
(83, 'Purple Fan', 'Fan_purple', 1.00, '0', '1', '1', '?'),
(84, 'Weird Science Machine', 'hc_machine', 1.00, '0', '1', '4', '?'),
(85, 'Majestic Chair', 'hc_maj', 2.00, '0', '1', '4', '?'),
(86, 'Super Love Fan', 'Fan_Superlove', 0.50, '0', '1', '1', '?'),
(87, 'HC Mega TV Set', 'hc_megatv', 0.15, '0', '1', '4', '?'),
(88, 'Mocha Master', 'hc_mocha', 0.20, '0', '1', '4', '?'),
(89, 'Nordic Table', 'hc_nordic', 0.50, '0', '1', '4', '?'),
(90, 'HC Oil Lamp', 'hc_oillamp', 0.50, '0', '1', '4', '?'),
(91, 'Aqua Fan', 'Fan_turquoise', 1.00, '0', '1', '1', '?'),
(92, 'Festive Fan', 'Fan_xmas', 0.90, '0', '1', '2', '?'),
(93, 'HC Roller 5 Pack', 'hc_roller', 0.80, '0', '1', '4', '?'),
(94, 'Yellow Fan', 'Fan_Yellow', 40.00, '0', '1', '1', '?'),
(95, 'Study Desk', 'hc_study', 0.50, '0', '1', '4', '?'),
(96, 'HC Drinks Trolley', 'hc_trolley', 0.50, '0', '1', '4', '?'),
(97, 'Throne Sofa', 'hc_tsofa', 1.00, '0', '1', '4', '?'),
(98, 'Tub Master', 'hc_tubm', 0.20, '0', '1', '4', '?'),
(99, 'HC Retro Wall Lamp', 'hc_walllamp', 0.30, '0', '1', '4', '?'),
(100, 'Broken Gingerbread House', 'GingerBreadhouse', 0.40, '0', '1', '2', '?'),
(101, 'HC Xray Divider', 'hc_xray', 0.50, '0', '1', '4', '?'),
(102, 'Gingerbread House', 'GingerBreadHouse2', 0.10, '0', '1', '2', '?'),
(103, 'Grave', 'Grave', 0.50, '0', '1', '3', '?'),
(104, 'Holo Boy', 'HoloBoy', 2.00, '0', '1', '1', '?'),
(105, 'Holo Girl', 'HoloGirl', 1.50, '0', '1', '1', '?'),
(106, 'Peppermint Ice Cream machine', 'IceMaker_Aqua', 1.00, '0', '1', '1', '?'),
(107, 'Blue Berry Ice Cream Machine', 'IceMaker_blue', 72.00, '0', '1', '1', '?'),
(108, 'Chocolate Ice Cream Maker', 'icemaker_Choco', 134.00, '0', '1', '1', '?'),
(109, 'BlackCurrent Ice Cream Machine', 'IceMaker_fuchsia', 132.00, '0', '1', '1', '?'),
(110, 'Vanilla Ice Cream Machine', 'Icemaker_gold', 1.00, '0', '1', '1', '?'),
(111, 'Pistachio Ice Cream Maker', 'IceMaker_Green', 1.80, '0', '1', '1', '?'),
(112, 'Toffee Ice Cream Maker', 'IceMaker_ochre', 1.00, '0', '1', '1', '?'),
(113, 'Strawberry Ice Cream Maker', 'IceMaker_pink', 30.00, '0', '1', '1', '?'),
(114, 'Purple Ice Cream Maker', 'IceMaker_purple', 132.00, '0', '1', '1', '?'),
(115, 'Cherry Ice Cream Maker', 'IceMaker_Red', 102.00, '0', '1', '1', '?'),
(116, 'White Inflatable Chair', 'InflatableChair', 0.30, '0', '1', '1', '?'),
(117, 'InfoBus', 'InfoBus', 124.00, '0', '1', '1', '?'),
(118, 'Black Laser Gate', 'LaserGate_Black', 1.50, '0', '1', '1', '?'),
(119, 'Blue Laser Gate', 'LaserGate_Blue', 1.50, '0', '1', '1', '?'),
(120, 'Jade Laser Gate', 'Lasergate_Blue', 2.50, '0', '1', '1', '?'),
(121, 'Pink Laser Gate', 'Lasergate_Pink', 5.00, '0', '1', '1', '?'),
(122, 'Purple Laser Gate', 'LaserGate_Purple', 1.00, '0', '1', '1', '?'),
(123, 'Red Laser Gate', 'Lasergate_Red', 6.00, '0', '1', '1', '?'),
(124, 'Turquoise Laser Gate', 'LaserGate_turquoise', 3.50, '0', '1', '1', '?'),
(125, 'Violet Laser Gate', 'LaserGate_Violet', 1.50, '0', '1', '1', '?'),
(126, 'White Laser Gate', 'LaserGate_White', 2.50, '0', '1', '1', '?'),
(127, 'Yellow Laser Gate', 'LaserGate_Yellow', 4.00, '0', '1', '1', '?'),
(128, 'Aqua Marquee', 'marquee_aqua', 0.80, '0', '1', '1', '?'),
(129, 'Blue Marquee', 'marquee_blue', 0.80, '0', '1', '1', '?'),
(130, 'Graphite Marquee', 'marquee_graphite', 1.00, '0', '1', '1', '?'),
(131, 'Holiday Romance', 'LoveScreen', 2.00, '0', '1', '1', '?'),
(132, 'Green Marquee', 'marquee_green', 0.80, '0', '1', '1', '?'),
(133, 'Pink Marquee', 'marquee_pink', 1.00, '0', '1', '1', '?'),
(134, 'Purple Marquee', 'marquee_purple', 1.00, '0', '1', '1', '?'),
(135, 'Red Marquee', 'marquee_red', 1.00, '0', '1', '1', '?'),
(136, 'UltraMarine Marquee', 'marquee_ultramarine', 0.80, '0', '1', '1', '?'),
(137, 'Maze Shruberry  Gate', 'Maze_Gate', 0.30, '0', '1', '1', '?'),
(138, 'Yellow Marquee', 'marquee_yellow', 0.80, '0', '1', '1', '?'),
(139, 'Maze Shruberry', 'Maze_Plant', 0.30, '0', '1', '1', '?'),
(140, 'Aqua Monolith', 'monolith_aqua', 1.00, '0', '1', '1', '?'),
(141, 'Moon Rug', 'MoonRug', 1.25, '0', '1', '1', '?'),
(142, 'Black Monolith', 'monolith_black', 2.00, '0', '1', '1', '?'),
(143, 'Blue Spaceship Door', 'monolith_blue', 48.00, '0', '1', '1', '?'),
(144, 'Emerald Spaceship Door', 'monolith_jade', 1.00, '0', '1', '1', '?'),
(145, 'Pink Monolith', 'monolith_purple', 50.00, '0', '1', '1', '?'),
(146, 'Mummy', 'Mummy', 0.20, '0', '1', '3', '?'),
(147, 'Red Monolith', 'monolith_red', 1.00, '0', '1', '1', '?'),
(148, 'Bronze Nelly', 'Nelly_Bronze', 9.00, '0', '1', '1', '?'),
(149, 'Sky Monolith', 'monolith_sky', 2.00, '0', '1', '1', '?'),
(150, 'Violet Monolith', 'monolith_violet', 15.00, '0', '1', '1', '?'),
(151, 'Gold Nelly', 'Nelly_Gold', 92.00, '0', '1', '1', '?'),
(152, 'White Monolith', 'monolith_white', 28.00, '0', '1', '1', '?'),
(153, 'Silver Nelly', 'Nelly_Silver', 8.50, '0', '1', '1', '?'),
(154, 'Yellow Spaceship Door', 'monolith_yellow', 138.00, '0', '1', '1', '?'),
(155, 'Old Christmas Tree', 'oldxmastree', 0.70, '0', '1', '2', '?'),
(156, 'Oriental Screen', 'OrientalScreen', 0.70, '0', '1', '1', '?'),
(157, 'RoseWood Screen', 'OrientalScreen_rose', 0.70, '0', '1', '1', '?'),
(158, 'Green Parasol', 'parasol_green', 1.00, '0', '1', '1', '?'),
(159, 'Yellow Parasol', 'parasol_yellow', 1.00, '0', '1', '1', '?'),
(160, 'Atlantean Pillar', 'Pillar_Atlantean', 0.70, '0', '1', '1', '?'),
(161, 'Orange Parasol', 'parasol_orange', 5.00, '0', '1', '1', '?'),
(162, 'Purple Parasol', 'parasol_purple', 1.00, '0', '1', '1', '?'),
(163, 'Greek Pillar', 'Pillar_Greek', 0.50, '0', '1', '1', '?'),
(164, 'Terracotta Pillar', 'Pillar_Terracotta', 0.70, '0', '1', '1', '?'),
(165, 'Black Leather Pillow', 'pillow_black', 124.00, '0', '1', '1', '?'),
(166, 'Blue Pillow', 'pillow_blue', 72.00, '0', '1', '1', '?'),
(167, 'Gold Feather Pillow', 'pillow_gold', 1.00, '0', '1', '1', '?'),
(168, 'Green Wooly Pillow', 'pillow_green', 5.50, '0', '1', '1', '?'),
(169, 'Navy Cord Pillow', 'pillow_navy', 77.00, '0', '1', '1', '?'),
(170, 'Poinsetta', 'Poinsetta', 0.10, '0', '1', '2', '?'),
(171, 'Pink Fluffy Pillow', 'pillow_pink', 35.00, '0', '1', '1', '?'),
(172, 'Bronze Trophy', 'Prize_Bronze', 25.00, '0', '1', '1', '?'),
(173, 'Bonnies Purple Pillow', 'pillow_purple', 1.00, '0', '1', '1', '?'),
(176, 'Gold Trophy', 'Prize_Gold', 25.00, '0', '1', '1', '?'),
(175, 'Red Silk Pillow', 'pillow_red', 1.00, '0', '1', '1', '?'),
(177, 'Silver Trophy', 'Prize_Silver', 25.00, '0', '1', '1', '?'),
(178, 'Turquoise Pillow', 'pillow_turquoise', 87.00, '0', '1', '1', '?'),
(179, 'Pumpkin', 'Pumpkin', 0.10, '0', '1', '3', '?'),
(180, 'Pink Hyacinth', 'RedHyacinth', 0.10, '0', '1', '2', '?'),
(181, 'Road Barrier', 'Roadbarrier', 0.50, '0', '1', '1', '?'),
(182, 'Aqua Roller', 'Roller_Aqua', 0.50, '0', '1', '1', '?'),
(183, 'White Roller', 'Roller_White', 0.50, '0', '1', '1', '?'),
(184, 'White Lace Pillow', 'pillow_white', 1.50, '0', '1', '1', '?'),
(185, 'Samovar', 'Samovar', 1.30, '0', '1', '1', '?'),
(186, 'Jamacian Sand Patch', 'Sandrug', 1.00, '0', '1', '1', '?'),
(187, 'Aqua Screen', 'Screen_Aqua', 1.00, '0', '1', '1', '?'),
(188, 'Aqua Smoke Machine', 'smokem_aqua', 16.00, '0', '1', '1', '?'),
(189, 'Blue Screen', 'Screen_Blue', 0.50, '0', '1', '1', '?'),
(190, 'Blue Smoke Machine', 'smokem_blue', 124.00, '0', '1', '1', '?'),
(191, 'Jade Smoke Machine', 'smokem_jade', 82.00, '0', '1', '1', '?'),
(192, 'Gold Screen', 'Screen_Gold', 3.50, '0', '1', '1', '?'),
(193, 'Black Smoke Machine', 'smokem_black', 0.90, '0', '1', '1', '?'),
(194, 'Gray Screen', 'Screen_Gray', 1.50, '0', '1', '1', '?'),
(195, 'Pink Smoke Machine', 'smokem_pink', 67.00, '0', '1', '1', '?'),
(196, 'Purple Smoke Machine', 'smokem_purple', 82.00, '0', '1', '1', '?'),
(197, 'Green Screen', 'Screen_Green', 1.10, '0', '1', '1', '?'),
(198, 'Red Smoke Machine', 'smokem_red', 0.80, '0', '1', '1', '?'),
(199, 'Night Blue Screen', 'Screen_NightBlue', 1.00, '0', '1', '1', '?'),
(200, 'Purple Smoke Machine', 'smokem_purple', 92.00, '0', '1', '1', '?'),
(201, 'Pink Screen', 'Screen_Pink', 0.90, '0', '1', '1', '?'),
(202, 'White Smoke Machine', 'smokem_white', 144.00, '0', '1', '1', '?'),
(203, 'Yellow Smoke Machine', 'smokem_yellow', 124.00, '0', '1', '1', '?'),
(204, 'Purple Screen', 'Screen_Purple', 1.20, '0', '1', '1', '?'),
(205, 'White Screen', 'Screen_White', 2.10, '0', '1', '1', '?'),
(206, 'Skeleton', 'Skeleton', 0.10, '0', '1', '3', '?'),
(207, 'Skull Candle', 'SkullCandle', 0.10, '0', '1', '3', '?'),
(208, 'Sleeping Bag', 'SleepingBag', 0.30, '0', '1', '1', '?'),
(209, 'Christmas Tree 3', 'xmastree3', 0.10, '0', '1', '2', '?'),
(210, 'Christmas Tree 2', 'xmastree2', 0.10, '0', '1', '2', '?'),
(211, 'Snow Globe', 'SnowGlobe', 0.80, '0', '1', '2', '?'),
(212, 'Snow Rug', 'SnowRug', 1.00, '0', '1', '2', '?'),
(213, 'Christmas Tree 1', 'xmastree1', 0.10, '0', '1', '2', '?'),
(214, 'Lapland Greetings', 'xmasscreen', 1.00, '0', '1', '2', '?'),
(215, 'Solarium', 'Solarium', 1.00, '0', '1', '1', '?'),
(216, 'Christmas Duck', 'xmasduck', 0.10, '0', '1', '2', '?'),
(217, 'Speakers Corner', 'SpeakersCorner', 0.50, '0', '1', '1', '?'),
(219, 'Unholy Ground', 'unholyground', 1.50, '0', '1', '3', '?'),
(220, 'Typewriter', 'typo', 33.00, '0', '1', '1', '?');

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

--
-- Structure de la table `roombots`
--

CREATE TABLE IF NOT EXISTS `roombots` (
  `id` int(10) NOT NULL auto_increment,
  `roomid` int(10) NOT NULL,
  `name` varchar(50) collate latin1_general_ci NOT NULL,
  `mission` varchar(100) collate latin1_general_ci default NULL,
  `figure` text collate latin1_general_ci NOT NULL,
  `x` int(5) NOT NULL,
  `y` int(5) NOT NULL,
  `z` int(1) NOT NULL,
  `freeroam` enum('1','0') collate latin1_general_ci NOT NULL default '0',
  `message_noshouting` varchar(200) collate latin1_general_ci NOT NULL default 'Shouting is not neccessary.',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

--
-- Contenu de la table `roombots`
--

INSERT INTO `roombots` (`id`, `roomid`, `name`, `mission`, `figure`, `x`, `y`, `z`, `freeroam`, `message_noshouting`) VALUES
(1, 176, 'Espace', 'ciao', '1', 10, 9, 0, '', 'Shouting is not neccessary.'),
(2, 175, 'lol', ':o', '1', 10, 9, 0, '', 'Shouting is not neccessary.'),
(3, 177, 'cc', ':o', '1', 10, 9, 0, '', 'Shouting is not neccessary.');

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

--
-- Structure de la table `roombots_coords`
--

CREATE TABLE IF NOT EXISTS `roombots_coords` (
  `id` int(10) NOT NULL,
  `x` int(5) NOT NULL,
  `y` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `roombots_coords`
--


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

--
-- Structure de la table `roombots_texts`
--

CREATE TABLE IF NOT EXISTS `roombots_texts` (
  `id` int(10) NOT NULL,
  `type` enum('shout','say') collate latin1_general_ci NOT NULL,
  `text` varchar(255) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `roombots_texts`
--

INSERT INTO `roombots_texts` (`id`, `type`, `text`) VALUES
(1, 'say', 'Miao!'),
(1, 'say', 'ZZzzz!'),
(2, 'say', 'Miao!'),
(2, 'say', 'ZZzzz!'),
(3, 'say', 'Miao!'),
(3, 'say', 'ZZzzz!');

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

--
-- Structure de la table `roombots_texts_triggers`
--

CREATE TABLE IF NOT EXISTS `roombots_texts_triggers` (
  `id` int(10) NOT NULL,
  `words` text collate latin1_general_ci NOT NULL,
  `replies` text collate latin1_general_ci NOT NULL,
  `serve_replies` text collate latin1_general_ci NOT NULL,
  `serve_item` varchar(20) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `roombots_texts_triggers`
--

INSERT INTO `roombots_texts_triggers` (`id`, `words`, `replies`, `serve_replies`, `serve_item`) VALUES
(1, 'Espace', 'Miao!', '', ''),
(2, 'lol', 'Miao!', '', ''),
(3, 'cc', 'Miao!', '', '');

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

--
-- Structure de la table `room_ads`
--

CREATE TABLE IF NOT EXISTS `room_ads` (
  `roomid` int(10) NOT NULL,
  `img` text collate latin1_general_ci NOT NULL,
  `uri` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`roomid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `room_ads`
--


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

--
-- Structure de la table `room_bans`
--

CREATE TABLE IF NOT EXISTS `room_bans` (
  `roomid` int(10) NOT NULL,
  `userid` int(10) NOT NULL,
  `ban_expire` varchar(50) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `room_bans`
--


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

--
-- Structure de la table `room_categories`
--

CREATE TABLE IF NOT EXISTS `room_categories` (
  `id` int(3) NOT NULL default '0',
  `parent` int(3) NOT NULL default '0',
  `type` int(1) NOT NULL default '1',
  `name` varchar(100) collate latin1_general_ci NOT NULL default 'Non-named category',
  `access_rank_min` int(2) NOT NULL,
  `access_rank_hideforlower` enum('0','1') collate latin1_general_ci NOT NULL,
  `trading` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `room_categories`
--

INSERT INTO `room_categories` (`id`, `parent`, `type`, `name`, `access_rank_min`, `access_rank_hideforlower`, `trading`) VALUES
(25, 4, 2, 'Competizioni e Giochi dello Staff', 7, '0', '1'),
(23, 11, 0, 'Snowstorm', 1, '0', '0'),
(22, 11, 0, 'Battleball', 1, '0', '0'),
(21, 23, 0, 'Snowstorm per superesperti', 1, '0', '0'),
(20, 23, 0, 'Snowstorm per esperti', 1, '0', '0'),
(19, 23, 0, 'Snowstorm per intermedi', 1, '0', '0'),
(18, 23, 0, 'Snowstorm per principianti', 1, '0', '0'),
(17, 23, 0, 'Snowstorm per noob', 1, '0', '0'),
(16, 22, 0, 'Battleball per superesperti', 1, '1', '0'),
(15, 22, 0, 'BattleBall per esperti', 1, '1', '0'),
(14, 22, 0, 'BattleBall per intermedi', 1, '1', '0'),
(13, 22, 0, 'BattleBall per principianti', 1, '1', '0'),
(12, 22, 0, 'Battleball per noob', 1, '1', '0'),
(11, 3, 0, 'Battleball & Snowstorm', 1, '1', '0'),
(10, 4, 2, 'Stanze dei MOD', 6, '0', '1'),
(9, 7, 0, 'Club & Bar', 1, '0', '0'),
(8, 5, 0, 'Parco e InfoBus', 1, '0', '0'),
(7, 3, 0, 'Intrattenimento', 1, '0', '0'),
(5, 3, 0, 'Spazi Esterni', 1, '0', '0'),
(6, 4, 2, 'Stanze Staff e Riunioni', 7, '0', '1'),
(4, 0, 2, 'Stanze normali', 1, '0', '0'),
(3, 0, 0, 'Spazi Pubblici', 1, '0', '0'),
(0, 1, 2, 'No category', 1, '0', '0'),
(26, 4, 2, 'Centro Aiuti', 1, '0', '0'),
(27, 4, 2, 'Discoteche e Musica', 1, '0', '1'),
(28, 4, 2, 'Ristoranti e Bar', 1, '0', '0'),
(29, 4, 2, 'Luoghi di informazione', 1, '0', '0'),
(30, 4, 2, 'Stanze Natalizie', 1, '', '0'),
(31, 4, 2, 'Stanze normali', 0, '', '0'),
(24, 4, 2, 'Labirinto Competition', 6, '', '0'),
(32, 4, 2, 'Scambio, Vendo, Compro', 2, '', '1'),
(33, 4, 2, 'Giochi e Labirinti', 2, '', '0');

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

--
-- Structure de la table `room_modeldata`
--

CREATE TABLE IF NOT EXISTS `room_modeldata` (
  `model` varchar(100) collate latin1_general_ci NOT NULL,
  `roomomatic_subscr_only` int(1) NOT NULL default '0',
  `door_x` int(3) NOT NULL,
  `door_y` int(3) NOT NULL,
  `door_h` int(3) NOT NULL,
  `door_z` int(1) NOT NULL,
  `heightmap` text collate latin1_general_ci NOT NULL,
  `publicroom_items` text collate latin1_general_ci NOT NULL,
  `swimmingpool` enum('1','0') collate latin1_general_ci NOT NULL,
  `specialcast_emitter` varchar(15) collate latin1_general_ci default NULL,
  `specialcast_interval` int(10) default NULL,
  `specialcast_rnd_min` int(10) default NULL,
  `specialcast_rnd_max` int(10) default NULL,
  PRIMARY KEY  (`model`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `room_modeldata`
--

INSERT INTO `room_modeldata` (`model`, `roomomatic_subscr_only`, `door_x`, `door_y`, `door_h`, `door_z`, `heightmap`, `publicroom_items`, `swimmingpool`, `specialcast_emitter`, `specialcast_interval`, `specialcast_rnd_min`, `specialcast_rnd_max`) VALUES
('terace', 0, 9, 17, 0, 0, 'xxxxxx21000000000xxxxxxxx\r\nxxxxxx3xxx000xx000xxxxxxx\r\nxxxxxx4xxx000xxx000xxxxxx\r\nxxxxxx44xx000x00x000xxxxx\r\nxxxxxx44xx0000xx00000xxxx\r\nxxxxxx44xx000000000000xxx\r\nxxxxxx44xx0000000000000xx\r\nxxxxxxx4xxxxxxx00000000xx\r\nxxxxxxx4xxxxxxx0000000xxx\r\nxxxxxx444432222xxx00xxxxx\r\nxxxxxx444432222x0000000xx\r\nxxxxxx444432222x0000000xx\r\nxxxxxx44400x222x0000000xx\r\nxxxxxx444000x11x0000000xx\r\nxxxxxx444000000x0000000xx\r\nxxxxxx444000000x0000000xx\r\nxxxxxx440000000000000000x\r\nxxxxxx4400000000000000000\r\nx8876x444000000x000000000\r\nx8xx6x444000000x000000000\r\nx9xx6x444000000x000000000\r\n999x65444000000x000000000\r\n999xxx444xxxxxxxxxx000000\r\n999xxx444xxxxxxxxxxx00000\r\n999xxx333xxxxxxxxxxxx0000\r\n999xxx222222222222222x000\r\nxxxxxx222222222222222xx00\r\nxxxxxx222222222222222xxx0\r\nxxxxxx222222222222222xxxx\r\nxxxxxxx22222222222222xxxx\r\nxxxxxxxx2222222222222xxxx', 'a1611 sun_chair 16 11 0 2\r\na2011 sun_chair 20 11 0 2\r\na1612 sun_chair 16 12 0 2\r\na2012 sun_chair 20 12 0 2\r\nb1013 blusun_chair 10 13 0 4\r\na1613 sun_chair 16 13 0 2\r\na2013 sun_chair 20 13 0 2\r\nc1014 sun_table 10 14 0 0\r\na2014 sun_chair 20 14 0 2\r\nb1015 blusun_chair 10 15 0 0\r\na118 sun_chair 1 18 8 2\r\na418 sun_chair 4 18 6 2\r\nb1118 blusun_chair 11 18 0 4\r\nb1019 blusun_chair 10 19 0 2\r\nc1119 sun_table 11 19 0 0\r\nb1219 blusun_chair 12 19 0 6\r\na1819 sun_chair 18 19 0 2\r\na2219 sun_chair 22 19 0 2\r\nb1120 blusun_chair 11 20 0 0\r\na1820 sun_chair 18 20 0 2\r\na2220 sun_chair 22 20 0 2\r\na421 sun_chair 4 21 6 2\r\na621 sun_chair 6 21 4 2\r\na1821 sun_chair 18 21 0 2\r\na2221 sun_chair 22 21 0 2\r\nb222 blusun_chair 2 22 9 4\r\na2222 sun_chair 22 22 0 2\r\nb123 blusun_chair 1 23 9 2\r\nd223 sun_table2 2 23 9 0\r\nb224 blusun_chair 2 24 9 0\r\na1125 sun_chair 11 25 2 4\r\na1225 sun_chair 12 25 2 4\r\na1325 sun_chair 13 25 2 4\r\nc1425 sun_table 14 25 2 0\r\na1525 sun_chair 15 25 2 4\r\na1625 sun_chair 16 25 2 4\r\na1725 sun_chair 17 25 2 4\r\na1329 sun_chair 13 29 2 2\r\na1529 sun_chair 15 29 2 2\r\na1729 sun_chair 17 29 2 2\r\na1330 sun_chair 13 30 2 2\r\na1530 sun_chair 15 30 2 2\r\na1730 sun_chair 17 30 2 2', '0', '0', 1, NULL, NULL),
('rumble', 0, 1, 5, 7, 0, 'xxxxxxxx77xxxxxxxxxxxxxxxx\r\nxxxxxxxx77xxxxxxxxxxxxxxxx\r\nxxxxxx77777x77xxxxxxxxxxxx\r\nxxx77777777777xxx44xxxxxxx\r\n77777777777777xx444444444x\r\n777777777777777xx44444444x\r\nxxx777777777777xx44444444x\r\nxxxx7777777777xxx44444444x\r\n7777777777777777744448444x\r\n7777777777777x4x744448444x\r\n777777777777x444444448444x\r\n7777777777774444444448444x\r\n7777777777774444444448444x\r\n777777777777x444444448444x\r\n7777777777777x44444448444x\r\nxxx777777777777x444448444x\r\nxxx7777777777777444448444x\r\nxxx7777777777777444448444x\r\nxxx777777777777x444448444x\r\nxxx77777777777x4444444444x\r\nxxxx777777777444444444444x\r\nxxxxxxxxxxxxxxxxxxxxxxxxxx', 'A43 mntdwchair 4 3 7 4\r\nA53 mntdwchair 5 3 7 4\r\nM28 barmask 2 8 7 0\r\ns78 mntdwsofa2 7 8 7 2\r\nt88 mntdwtable2 8 8 7 0\r\ns98 mntdwsofa2 9 8 7 6\r\ny218 paalu5 21 8 8 0\r\nM29 barmask 2 9 7 0\r\nS79 mntdwsofa1 7 9 7 2\r\nT89 mntdwtable1 8 9 7 0\r\nS99 mntdwsofa1 9 9 7 6\r\ny219 paalu5 21 9 8 0\r\nM210 barmask 2 10 7 0\r\ny2110 paalu5 21 10 8 0\r\nM211 barmask 2 11 7 0\r\ny2111 paalu5 21 11 8 0\r\nM212 barmask 2 12 7 0\r\ns712 mntdwsofa2 7 12 7 4\r\nS812 mntdwsofa1 8 12 7 4\r\ne2112 paalu3 21 12 8 0\r\nM213 barmask 2 13 7 0\r\nt713 mntdwtable2 7 13 7 2\r\nT813 mntdwtable1 8 13 7 2\r\ne2113 paalu3 21 13 8 0\r\nM214 barmask 2 14 7 0\r\ns714 mntdwsofa2 7 14 7 0\r\nS814 mntdwsofa1 8 14 7 0\r\ne2114 paalu3 21 14 8 0\r\nM215 barmask 2 15 100000 0\r\nq2115 paalu1 21 15 8 0\r\nM216 barmask 2 16 100000 0\r\ns1216 mntdwsofa2 12 16 7 4\r\nS1316 mntdwsofa1 13 16 7 4\r\nq2116 paalu1 21 16 8 0\r\nA317 mntdwchair 3 17 7 2\r\ns617 mntdwsofa2 6 17 7 2\r\nt717 mntdwtable2 7 17 7 0\r\ns817 mntdwsofa2 8 17 7 6\r\nt1217 mntdwtable2 12 17 7 2\r\nT1317 mntdwtable1 13 17 7 2\r\nq2117 paalu1 21 17 8 0\r\nA318 mntdwchair 3 18 7 2\r\nS618 mntdwsofa1 6 18 7 2\r\nT718 mntdwtable1 7 18 7 0\r\nS818 mntdwsofa1 8 18 7 6\r\ns1218 mntdwsofa2 12 18 7 0\r\nS1318 mntdwsofa1 13 18 7 0\r\nq2118 paalu1 21 18 8 0', '0', '0', 1, NULL, NULL),
('square_1', 0, 17, 26, 0, 0, 'xxxxxxxxx222xx222222xxx222xxxxxx\r\nxxxxxxxxx222xx2222222xx222xxxxxx\r\nxxxxxxxxx22222222222222222xxxxxx\r\nxxxxxxxxx22222222222222222xxxxxx\r\nxxxxxxxxx22222222222222222xxxxxx\r\nxxxxxxxxx22222x22222x22222xxxxxx\r\nxxxxxxxxx11111x22222x11111xxxxxx\r\n0000000xx00000x22222x00000xxxxxx\r\n0000000xx00000000000000000xxxxxx\r\n000000000000000000000000000xx00x\r\n000000000000xxx00000xxx00000000x\r\n000000000000xxx00000xxx00000000x\r\n000000000000xxx00000xxx000000000\r\n00000000000000000000000000000000\r\nx0000000000000000000000000000000\r\nxxx00000000000000000000000000000\r\nxxxxx000000000000000000000000000\r\nxxxxx000000000000000000000000000\r\nxxxxx000000000000000000000000xxx\r\nxxxxxx00000000000000000000000xxx\r\nxxxxxxx000000000000000000000xxxx\r\nxxxxxxxxxx00000000000000000xxxxx\r\nxxxxxxxxxx0000000000000000xxxxxx\r\nxxxxxxxxxx000000000000000xxxxxxx\r\nxxxxxxxxxxxxx00000000000xxxxxxxx\r\nxxxxxxxxxxxxxx000000000xxxxxxxxx\r\nxxxxxxxxxxxxxxxx000xxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxx000xxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxx000xxxxxxxxxxxxx', 'd155 gate_table1 15 5 2 2\r\nd195 gate_table1 19 5 2 6\r\ne156 gate_table2 15 6 2 2\r\ne196 gate_table2 19 6 2 6\r\nd27 gate_table1 2 7 0 4\r\ne37 gate_table2 3 7 0 4\r\nf47 gate_table3 4 7 0 4\r\nf157 gate_table3 15 7 2 2\r\nf197 gate_table3 19 7 2 6\r\nd210 gate_table1 2 10 0 0\r\ne310 gate_table2 3 10 0 0\r\nf410 gate_table3 4 10 0 0\r\nd211 gate_table1 2 11 0 4\r\ne311 gate_table2 3 11 0 4\r\nf411 gate_table3 4 11 0 4\r\nb2913 gate_drumchair 29 13 0 4\r\nb3013 gate_drumchair 30 13 0 4\r\nd214 gate_table1 2 14 0 0\r\ne314 gate_table2 3 14 0 0\r\nf414 gate_table3 4 14 0 0\r\nb1214 gate_drumchair 12 14 0 4\r\nb1714 gate_drumchair 17 14 0 4\r\nb2214 gate_drumchair 22 14 0 4\r\nh815 gate_lantern 8 15 0 0\r\nb1115 gate_drumchair 11 15 0 2\r\nc1215 gate_table 12 15 0 0\r\nb1315 gate_drumchair 13 15 0 6\r\nb1615 gate_drumchair 16 15 0 2\r\nc1715 gate_table 17 15 0 0\r\nb1815 gate_drumchair 18 15 0 6\r\nb2115 gate_drumchair 21 15 0 2\r\nc2215 gate_table 22 15 0 0\r\nb2315 gate_drumchair 23 15 0 6\r\nh2615 gate_lantern 26 15 0 0\r\nb1216 gate_drumchair 12 16 0 0\r\nb1716 gate_drumchair 17 16 0 0\r\nb2216 gate_drumchair 22 16 0 0\r\nb2917 gate_drumchair 29 17 0 0\r\nb3017 gate_drumchair 30 17 0 0\r\ni1018 gate_rockchair1 10 18 0 2\r\ni1418 gate_rockchair1 14 18 0 6\r\na2018 gate_trashcan 20 18 0 0\r\nk2118 gate_rockchair3 21 18 0 4\r\nj2218 gate_rockchair2 22 18 0 4\r\ni2318 gate_rockchair1 23 18 0 4\r\nj1019 gate_rockchair2 10 19 0 2\r\nk1419 gate_rockchair3 14 19 0 6\r\nj2019 gate_rockchair2 20 19 0 2\r\nk1020 gate_rockchair3 10 20 0 2\r\nj1420 gate_rockchair2 14 20 0 6\r\nk2020 gate_rockchair3 20 20 0 2\r\ni1021 gate_rockchair1 10 21 0 2\r\ni2021 gate_rockchair1 20 21 0 2\r\ng1022 gate_talltree 10 22 0 0\r\ng1023 gate_talltree 10 23 0 0', '0', '0', 1, NULL, NULL),
('square_2', 0, 17, 23, 0, 0, 'xxxxxxxxxxx111111111111xxxxxxxxxxxx\r\nxxxxxxxxxx11111111111111xxxxxxxxxxx\r\nxxxxxxxxxx11111111111111xxxxxxxxxxx\r\nxxxxxxxxxx11xxxx11xxxx11xxxxxxxxxxx\r\nxxxxxxxxxx00xxxx00xxxx00xxxxxxxxxxx\r\nxxxxxxx0000000000000000000xxxxxxxxx\r\nxxxxxx000000000000000000000xxxxxxxx\r\nxxxxx0000000000000000000x000xxxxxxx\r\nxxxx00000000000000000000xx000xxxxxx\r\nxxxx00000000000000000000xxx000xxxxx\r\nxxxx00000000000000000000xxxx00xxxxx\r\n000000000000000000000000000000xxxxx\r\n0000000000000000000000000000000xxxx\r\n000000000000000000000000000000xxxxx\r\n000000000000000000000000000000xxxxx\r\n000000000000000000000000000000xxxxx\r\nxx00000000000000000000000000000000x\r\nxxx000xxxx00000000000000xxxx0000000\r\nxxx0000xxx00000000000000xxx00000000\r\nxxxx0000xx00000000000000xx000000000\r\nxxxxx0000x00000000000000x00000000xx\r\nxxxxxx00000000000000000000000xxxxxx\r\nxxxxxxx00000x000000000000000x0xxxxx\r\nxxxxxxxx0000xxx0000xxx000000xxxxxxx\r\nxxxxxxxxx000xxx0000xxx000000xxxxxxx\r\nxxxxxxxxxxxxxxx0000xxx000000xxxxxxx\r\nxxxxxxxxxxxxxxxx000xxx000000xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx00000xxxxxxxx', 'd120 gate_table1 12 0 1 4\r\ne130 gate_table2 13 0 1 4\r\nf140 gate_table3 14 0 1 4\r\nd160 gate_table1 16 0 1 4\r\nf170 gate_table3 17 0 1 4\r\nd190 gate_table1 19 0 1 4\r\ne200 gate_table2 20 0 1 4\r\nf210 gate_table3 21 0 1 4\r\ng97 gate_talltree 9 7 0 0\r\nb148 gate_drumchair 14 8 0 4\r\nb198 gate_drumchair 19 8 0 4\r\ng99 gate_talltree 9 9 0 0\r\nb139 gate_drumchair 13 9 0 2\r\nc149 gate_table 14 9 0 0\r\nb159 gate_drumchair 15 9 0 6\r\nb189 gate_drumchair 18 9 0 2\r\nc199 gate_table 19 9 0 0\r\nb209 gate_drumchair 20 9 0 6\r\ng610 gate_talltree 6 10 0 0\r\ng810 gate_talltree 8 10 0 0\r\nb1410 gate_drumchair 14 10 0 0\r\nb1910 gate_drumchair 19 10 0 0\r\nk611 gate_rockchair3 6 11 0 2\r\nj811 gate_rockchair2 8 11 0 6\r\nb112 gate_drumchair 1 12 0 4\r\nb212 gate_drumchair 2 12 0 4\r\ni612 gate_rockchair1 6 12 0 2\r\ng2712 gate_talltree 27 12 0 0\r\ng3012 gate_talltree 30 12 0 0\r\nb114 gate_drumchair 1 14 0 0\r\nb214 gate_drumchair 2 14 0 0\r\ni615 gate_rockchair1 6 15 0 2\r\na2715 gate_trashcan 27 15 0 0\r\nj616 gate_rockchair2 6 16 0 2\r\nk816 gate_rockchair3 8 16 0 6\r\nd3116 gate_table1 31 16 0 4\r\nf3216 gate_table3 32 16 0 4\r\nb1417 gate_drumchair 14 17 0 4\r\nb1917 gate_drumchair 19 17 0 4\r\nb1318 gate_drumchair 13 18 0 2\r\nc1418 gate_table 14 18 0 0\r\nb1518 gate_drumchair 15 18 0 6\r\nb1818 gate_drumchair 18 18 0 2\r\nc1918 gate_table 19 18 0 0\r\nb2018 gate_drumchair 20 18 0 6\r\nb1419 gate_drumchair 14 19 0 0\r\nb1919 gate_drumchair 19 19 0 0\r\nd3119 gate_table1 31 19 0 0\r\nf3219 gate_table3 32 19 0 0\r\nh2922 gate_lantern 29 22 0 0\r\na823 gate_trashcan 8 23 0 0\r\nd2324 gate_table1 23 24 0 2\r\nd2624 gate_table1 26 24 0 6\r\nf2325 gate_table3 23 25 0 2\r\nf2625 gate_table3 26 25 0 6', '', '0', 1, NULL, NULL),
('den', 0, 3, 22, 0, 0, '00000000xxxxxxxx\r\n0000000000000000\r\n0000000000000000\r\n000000000000xx00\r\n0000000000000000\r\n0000000000000000\r\n0000000000000000\r\nx000000000000000\r\n0000000000000000\r\n0000000000000000\r\n0000000000000000\r\n0000000000000000\r\nx000000000000000\r\nx000000000000000\r\nx000000000000000\r\nx000000000000000\r\nx000000000000000\r\nx000000000000000\r\nx000000000000000\r\nx000000000000000\r\nxxx00xxxxxxxxxxx\r\nxxx00xxxxxxxxxxx\r\nxxx00xxxxxxxxxxx', 'l70 crs_lamptable 7 0 0 0\r\ng141 tvtable 14 1 0 2\r\nt02 crs_trash 0 2 0 0\r\ns22 crs_sofag_start 2 2 0 4\r\nm32 crs_sofag_mid 3 2 0 4\r\nm42 crs_sofag_mid 4 2 0 4\r\nS52 crs_sofag_end 5 2 0 4\r\nR124 crs_roundwoodtable 12 4 0 2 2\r\nW154 crs_woodchair 15 4 0 6\r\nW105 crs_woodchair 10 5 0 2\r\nW156 crs_woodchair 15 6 0 6\r\nW77 crs_woodchair 7 7 0 4\r\nW138 crs_woodchair 13 8 0 4\r\nW158 crs_woodchair 15 8 0 4\r\nW59 crs_woodchair 5 9 0 2\r\nF010 crs_fridge 0 10 0 0\r\nV710 ctable2 7 10 0 2\r\nY1310 crs_woodtable_end 13 10 0 1 2\r\ny1410 crs_woodtable_start 14 10 0 2 2\r\nW511 crs_woodchair 5 11 0 2\r\nB112 crs_box 1 12 0 2\r\nB113 crs_box 1 13 0 2\r\nv713 ctable1 7 13 0 2\r\nW1313 crs_woodchair 13 13 0 0\r\nW1513 crs_woodchair 15 13 0 0\r\nB115 crs_box 1 15 0 2\r\nP117 crs_boxopen 1 17 0 2\r\ni1517 crs_stomp 15 17 0 0\r\nB118 crs_box 1 18 0 2\r\ni1518 crs_stomp 15 18 0 0\r\nb119 crs_boxtwo 1 19 0 2', '0', '0', 1, NULL, NULL),
('gardens', 0, 2, 15, 0, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0xxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx00xxxxxxxxxxxx\r\nxxxxxxxxxxxxx0x00xxxxxxxxxxx0x000xxxxxxxxxxx\r\nxxxxxxxxxxxx0000000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxx000000000000000000000000xxxxxxxxx\r\nxxxxxxxxxxx0000000000000000000000000xxxxxxxx\r\nxxxxxxxxxxx00000000000000000000000000xxxxxxx\r\nxxxxxxxx000000000000000000000000000000xxxxxx\r\nxxxxxxx00000000000000000000000000000000xxxxx\r\nxxxxxxx000000000000000000000000000000000xxxx\r\nxxxxxxx0000000000000000000000000000000000xxx\r\nxxxxxxxxx000000000000000000000000000000000xx\r\n00000000000000000000xx00000000000000000000xx\r\n0000000000000000000xxxx00000000000xxxxxxx0xx\r\n0000000000000000000xxxx00000000000x00000xxxx\r\nxxxxx00x0000000000xxxxx0xxxxxx0000x0000000xx\r\nxxxxx0000000000000xxxxx0xx000x0000x000000xxx\r\nxxxxx0000000000000xxxxx0x000000000x00000xxxx\r\nxxxxx000000x0000000xxxx0x000000000xxx00xxxxx\r\nxxxxxxxx000x0000000xxx00xxx000000x0000xxxxxx\r\nxxxxxxxx000x000000xxxx0x0000000000000xxxxxxx\r\nxxxxxxxx000x000000011100000000000000xxxxxxxx\r\nxxxxxxxx000x00000001110000000000000xxxxxxxxx\r\nxxxxxxxxx00x0000000111x00000000x00xxxxxxxxxx\r\nxxxxxxxxxx0x0000000xxx0000000xxxxxxxxxxxxxxx\r\nxxxxxxxxxxxx000000xxxx0000000xxxxxxxxxxxxxxx\r\nxxxxxxxxxxxx000000xxx00xxxxx00xxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxx0xxx0xx000x00xxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxx0xxx0x000000xxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxx0xxx0x00000xxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxx0xxxxx00xxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxx0xxxxx0xxxxxxxxxxxxxxxxxxxx', 'L89 bench2 8 9 0 4\r\nK99 bench 9 9 0 4\r\nL711 bench2 7 11 0 2\r\nK712 bench 7 12 0 2\r\nL3516 bench2 35 16 0 2\r\nL3716 bench2 37 16 0 4\r\nK3816 bench 38 16 0 4\r\nK3517 bench 35 17 0 2\r\nL2718 bench2 27 18 0 4\r\nK2818 bench 28 18 0 4\r\nL3518 bench2 35 18 0 2\r\nL2519 bench2 25 19 0 2\r\nK3519 bench 35 19 0 2\r\nK2520 bench 25 20 0 2\r\nL2529 bench2 25 29 0 4\r\nK2629 bench 26 29 0 4\r\nL2330 bench2 23 30 0 2\r\nK2331 bench 23 31 0 2', '0', '0', 1, NULL, NULL),
('cinema', 0, 20, 27, 1, 0, 'xxxxxxx1xx11111111xxxxxx\r\nxxx1111111111111111xxxxx\r\nxxx111xxxx1111111111xxxx\r\nxxxx2xxxxxxxxxxxxxxxxxxx\r\nxx3x3x333311xxxxxxxxxx11\r\nxx3333333311111111111111\r\nxx3333333311111111111111\r\nxx3333333311111111122111\r\nxx3333333311x22222222111\r\nxx3333333311x22222222111\r\nxx3333333311xxxxxxxxx111\r\nxx3333333311111111111111\r\nxx3333333311111111111111\r\nxx3333333311111111111111\r\nxx3333333311111xxxx11111\r\nxx3333333311111xxxx11111\r\nxx3333333311111xxxx11111\r\nxx3333333311111xxxx11111\r\nxx3333333311111xxxx11111\r\nxx3333333311111xxxx11111\r\nxx3333333311111xxxx11111\r\n333333332111111xxxx11111\r\n333333332111111111111111\r\n333333332111111111111111\r\n333333332111111111111111\r\nxx3333332111111111111111\r\nxxxxxxxxxxxxxxxxxxx11111\r\nxxxxxxxxxxxxxxxxxxx11111\r\nxxxxxxxxxxxxxxxxxxx11111', 'C24 orange 2 4 3 0\r\nA74 loungey_chair 7 4 3 2\r\nV84 loungey_tablebigb 8 4 3 0\r\nA94 loungey_chair 9 4 3 6\r\nA25 loungey_chair 2 5 3 4\r\nA75 loungey_chair 7 5 3 2\r\nU85 loungey_tablebiga 8 5 3 0\r\nA95 loungey_chair 9 5 3 6\r\nB26 loungey_table 2 6 3 0\r\nA27 loungey_chair 2 7 3 0\r\nh137 theater_chair 13 7 1 0\r\nh147 theater_chair 14 7 1 0\r\nh157 theater_chair 15 7 1 0\r\nh167 theater_chair 16 7 1 0\r\nh177 theater_chair 17 7 1 0\r\nh187 theater_chair 18 7 1 0\r\nz217 stair 21 7 1 0\r\nL98 lightpole 9 8 3 0\r\nq138 pomomaski 13 8 2 2\r\nq148 pomomaski 14 8 2 0\r\nq158 pomomaski 15 8 2 0\r\nq168 pomomaski 16 8 2 0\r\nq178 pomomaski 17 8 2 0\r\nq188 pomomaski 18 8 2 0\r\nq198 pomomaski 19 8 2 1\r\nz218 stair 21 8 1 0\r\nC29 orange 2 9 3 0\r\nh139 theater_chair 13 9 2 0\r\nh149 theater_chair 14 9 2 0\r\nh159 theater_chair 15 9 2 0\r\nh169 theater_chair 16 9 2 0\r\nh179 theater_chair 17 9 2 0\r\nh189 theater_chair 18 9 2 0\r\nh199 theater_chair 19 9 2 0\r\nh209 theater_chair 20 9 2 0\r\nz219 stair 21 9 1 0\r\nA210 loungey_chair 2 10 3 4\r\nA910 loungey_chair 9 10 3 4\r\nB211 loungey_table 2 11 3 0\r\nB911 loungey_table 9 11 3 0\r\nA212 loungey_chair 2 12 3 0\r\nA912 loungey_chair 9 12 3 0\r\nd1712 cubicb_chair 17 12 1 6\r\nc1912 cubico_chair 19 12 1 2\r\nd1513 cubicb_chair 15 13 1 2\r\nL1913 lightpole 19 13 1 0\r\nd2013 cubicb_chair 20 13 1 6\r\nL914 lightpole 9 14 3 0\r\nA215 loungey_chair 2 15 3 4\r\nd1415 cubicb_chair 14 15 1 4\r\nc1915 cubico_chair 19 15 1 4\r\nB216 loungey_table 2 16 3 0\r\nA716 loungey_chair 7 16 3 2\r\nB816 loungey_table 8 16 3 2\r\nA916 loungey_chair 9 16 3 6\r\nd1316 cubicb_chair 13 16 1 2\r\nd1416 cubicb_chair 14 16 1 6\r\nC1916 orange 19 16 1 0\r\nA217 loungey_chair 2 17 3 0\r\nA717 loungey_chair 7 17 3 2\r\nB817 loungey_table 8 17 3 2\r\nA917 loungey_chair 9 17 3 6\r\nd1917 cubicb_chair 19 17 1 2\r\nC218 orange 2 18 3 0\r\nd1418 cubicb_chair 14 18 1 4\r\nK219 bardesque 2 19 3 0\r\nK220 bardesque 2 20 3 1\r\nb320 bar_chair 3 20 3 6\r\nL920 lightpole 9 20 3 0\r\nd1420 cubicb_chair 14 20 1 0\r\nd1920 cubicb_chair 19 20 1 2\r\nc2020 cubico_chair 20 20 1 6\r\nK221 bardesque 2 21 3 1\r\nb321 bar_chair 3 21 3 6\r\nd1921 cubicb_chair 19 21 1 0\r\nK222 bardesque 2 22 3 1\r\nb322 bar_chair 3 22 3 6\r\nL1622 lightpole 16 22 1 0\r\nc1822 cubico_chair 18 22 1 0\r\nK223 bardesque 2 23 3 1\r\nb323 bar_chair 3 23 3 6\r\nK224 bardesque 2 24 3 1\r\nb324 bar_chair 3 24 3 6\r\nK225 bardesque 2 25 3 2', '0', '0', 1, NULL, NULL),
('cafe', 0, 30, 40, 0, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000000xxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxx00000xx00000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx00000000xxx0000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx00000000xxxx000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx0000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx00000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000xxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000xxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000xxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'd3221 chairup4 32 21 0 3\r\nf3321 chairup6 33 21 0 4\r\nf3421 chairup6 34 21 0 4\r\nf3521 chairup6 35 21 0 4\r\nf3621 chairup6 36 21 0 4\r\ng3721 chairup7 37 21 0 4\r\nb3222 chairup2 32 22 0 2\r\ne2523 chairup5 25 23 0 4\r\nf2623 chairup6 26 23 0 4\r\nf2723 chairup6 27 23 0 4\r\nf2823 chairup6 28 23 0 4\r\ng2923 chairup7 29 23 0 4\r\na3223 chairup1 32 23 0 2\r\nA2424 counter5 24 24 0 7\r\nr2524 table2 25 24 0 7\r\nq2624 table1 26 24 0 7\r\np2425 counter3 24 25 0 7\r\nz2426 counter4 24 26 0 7\r\np2427 counter3 24 27 0 7\r\np2428 counter3 24 28 0 7\r\ny2928 palms4 29 28 0 7\r\np2429 counter3 24 29 0 7\r\nx2929 palms3 29 29 0 7\r\np2430 counter3 24 30 0 7\r\nw2930 palms2 29 30 0 7\r\nn2231 counter1 22 31 0 7\r\nn2331 counter1 23 31 0 7\r\no2431 counter2 24 31 0 7\r\nv2931 palms1 29 31 0 7\r\ne3031 chairup5 30 31 0 4\r\nf3131 chairup6 31 31 0 4\r\nf3231 chairup6 32 31 0 4\r\nf3331 chairup6 33 31 0 4\r\nf3431 chairup6 34 31 0 4\r\nf3531 chairup6 35 31 0 4\r\nf3631 chairup6 36 31 0 4\r\nj3731 chairright3 37 31 0 5\r\nc2132 chairup3 21 32 0 2\r\nt2232 table4 22 32 0 7\r\nr3032 table2 30 32 0 7\r\nq3132 table1 31 32 0 7\r\nr3332 table2 33 32 0 7\r\nq3432 table1 34 32 0 7\r\ni3732 chairright2 37 32 0 6\r\nb2133 chairup2 21 33 0 2\r\ns2233 table3 22 33 0 7\r\ni3733 chairright2 37 33 0 6\r\nb2134 chairup2 21 34 0 2\r\nt3634 table4 36 34 0 7\r\ni3734 chairright2 37 34 0 6\r\nb2135 chairup2 21 35 0 2\r\nr2435 table2 24 35 0 7\r\nq2535 table1 25 35 0 7\r\nr2735 table2 27 35 0 7\r\nq2835 table1 28 35 0 7\r\nu3335 palm 33 35 0 7\r\ns3635 table3 36 35 0 7\r\ni3735 chairright2 37 35 0 6\r\nm2136 chairleft3 21 36 0 1\r\nl2236 chairleft2 22 36 0 0\r\nl2336 chairleft2 23 36 0 0\r\nl2436 chairleft2 24 36 0 0\r\nl2536 chairleft2 25 36 0 0\r\nl2636 chairleft2 26 36 0 0\r\nl2736 chairleft2 27 36 0 0\r\nk2836 chairleft1 28 36 0 0\r\ni3736 chairright2 37 36 0 6\r\nt3637 table4 36 37 0 7\r\ni3737 chairright2 37 37 0 6\r\ns3638 table3 36 38 0 7\r\nh3738 chairright1 37 38 0 6', '0', '0', 1, NULL, NULL),
('cafe_gold0', 0, 9, 29, 0, 0, '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', 'c53 gold_chair 5 3 1 2 2\r\nt63 gold_table_small1 6 3 1 6 1\r\nc73 gold_chair 7 3 1 6 2\r\n5103 gold_bardesk5 10 3 1 0 1\r\n4113 gold_bardesk4 11 3 1 0 1\r\n3123 gold_bardesk3 12 3 1 0 1\r\n2133 gold_bardesk2 13 3 1 0 1\r\n1143 gold_bardesk1 14 3 1 0 1\r\nc54 gold_chair 5 4 1 2 2\r\ny64 gold_table_small2 6 4 1 6 1\r\nc74 gold_chair 7 4 1 6 2\r\nc05 gold_chair 0 5 1 2 2\r\nt15 gold_table_small1 1 5 1 6 1\r\nc25 gold_chair 2 5 1 6 2\r\nc06 gold_chair 0 6 1 2 2\r\ny16 gold_table_small2 1 6 1 6 1\r\nc26 gold_chair 2 6 1 6 2\r\nc56 gold_chair 5 6 1 2 2\r\nt66 gold_table_small1 6 6 1 6 1\r\nc76 gold_chair 7 6 1 6 2\r\nc57 gold_chair 5 7 1 2 2\r\ny67 gold_table_small2 6 7 1 6 1\r\nc77 gold_chair 7 7 1 6 2\r\nc08 gold_chair 0 8 1 2 2\r\nt18 gold_table_small1 1 8 1 6 1\r\nc28 gold_chair 2 8 1 6 2\r\nc198 gold_chair 19 8 1 4 2\r\nc208 gold_chair 20 8 1 4 2\r\nc09 gold_chair 0 9 1 2 2\r\ny19 gold_table_small2 1 9 1 6 1\r\nc29 gold_chair 2 9 1 6 2\r\nc149 gold_chair 14 9 1 4 2\r\nc159 gold_chair 15 9 1 4 2\r\nt1910 gold_table_small1 19 10 1 0 1\r\ny2010 gold_table_small2 20 10 1 0 1\r\nt1411 gold_table_small1 14 11 1 0 1\r\ny1511 gold_table_small2 15 11 1 0 1\r\np012 gold_plant 0 12 1 0 2\r\nc112 gold_chair 1 12 1 0 2\r\nc212 gold_chair 2 12 1 0 2\r\nc312 gold_chair 3 12 1 0 2\r\nc1912 gold_chair 19 12 1 0 2\r\nc2012 gold_chair 20 12 1 0 2\r\np013 gold_plant 0 13 1 0 1\r\nc113 gold_chair 1 13 1 4 2\r\nc213 gold_chair 2 13 1 4 2\r\nc313 gold_chair 3 13 1 4 2\r\nc1413 gold_chair 14 13 1 0 2\r\nc1513 gold_chair 15 13 1 0 2\r\nc014 gold_chair 0 14 1 2 2\r\nc1414 gold_chair 14 14 1 4 2\r\nc1514 gold_chair 15 14 1 4 2\r\nc015 gold_chair 0 15 1 2 2\r\nt215 gold_table_small1 2 15 1 0 1\r\ny315 gold_table_small2 3 15 1 0 1\r\nc016 gold_chair 0 16 1 2 2\r\nt1416 gold_table_small1 14 16 1 0 1\r\ny1516 gold_table_small2 15 16 1 0 1\r\np017 gold_plant 0 17 1 0 1\r\nc117 gold_chair 1 17 1 0 2\r\nc217 gold_chair 2 17 1 0 2\r\nc317 gold_chair 3 17 1 0 2\r\np018 gold_plant 0 18 1 0 1\r\nc118 gold_chair 1 18 1 4 2\r\nc218 gold_chair 2 18 1 4 2\r\nc318 gold_chair 3 18 1 4 2\r\nc1418 gold_chair 14 18 1 0 2\r\nc1518 gold_chair 15 18 1 0 2\r\nc019 gold_chair 0 19 1 2 2\r\nc020 gold_chair 0 20 1 2 2\r\nt220 gold_table_small1 2 20 1 0 1\r\ny320 gold_table_small2 3 20 1 0 1\r\nc021 gold_chair 0 21 1 2 2\r\np022 gold_plant 0 22 1 0 1\r\nc122 gold_chair 1 22 1 0 2\r\nc222 gold_chair 2 22 1 0 2\r\nc322 gold_chair 3 22 1 0 2\r\np023 gold_plant 0 23 1 0 1\r\nc123 gold_chair 1 23 1 4 2\r\nc223 gold_chair 2 23 1 4 2\r\nc323 gold_chair 3 23 1 4 2\r\nc024 gold_chair 0 24 1 2 2\r\nc025 gold_chair 0 25 1 2 2\r\nt225 gold_table_small1 2 25 1 0 1\r\ny325 gold_table_small2 3 25 1 0 1\r\nc026 gold_chair 0 26 1 2 2\r\nc127 gold_chair 1 27 1 0 2\r\nc227 gold_chair 2 27 1 0 2\r\nc327 gold_chair 3 27 1 0 2', '1', '0', 1, NULL, NULL),
('snowwar_lobby_1', 0, 41, 36, 1, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx11111xx1xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx11111xx1111xxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxx111111xxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxx111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxx1111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxx111111111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxx1111x1111111111xxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'a3118 sw_barrellchair 31 18 1 6 2\r\na3119 sw_barrellchair 31 19 1 6 2\r\na3020 sw_barrellchair 30 20 1 0 2\r\na3720 sw_barrellchair 37 20 1 0 2\r\na3920 sw_barrellchair 39 20 1 0 2\r\na4120 sw_barrellchair 41 20 1 0 2\r\nd3024 sw_chair1 30 24 1 4 2\r\nc3124 sw_chair2 31 24 1 4 2\r\nc3224 sw_chair2 32 24 1 4 2\r\nc3324 sw_chair2 33 24 1 4 2\r\nb3424 sw_chair3 34 24 1 4 2\r\ni3025 sw_table1 30 25 1 0 1\r\nh3125 sw_table2 31 25 1 0 1\r\ng3225 sw_table3 32 25 1 0 1\r\nf3325 sw_table4 33 25 1 0 1\r\ne3425 sw_table5 34 25 1 0 1\r\nd3026 sw_chair1 30 26 1 0 2\r\nc3126 sw_chair2 31 26 1 0 2\r\nc3226 sw_chair2 32 26 1 0 2\r\nc3326 sw_chair2 33 26 1 0 2\r\nb3426 sw_chair3 34 26 1 0 2\r\nd3029 sw_chair1 30 29 1 4 2\r\nc3129 sw_chair2 31 29 1 4 2\r\nc3229 sw_chair2 32 29 1 4 2\r\nc3329 sw_chair2 33 29 1 4 2\r\nb3429 sw_chair3 34 29 1 4 2\r\ni3030 sw_table1 30 30 1 0 1\r\nh3130 sw_table2 31 30 1 0 1\r\ng3230 sw_table3 32 30 1 0 1\r\nf3330 sw_table4 33 30 1 0 1\r\ne3430 sw_table5 34 30 1 0 1\r\nd3031 sw_chair1 30 31 1 0 2\r\nc3131 sw_chair2 31 31 1 0 2\r\nc3231 sw_chair2 32 31 1 0 2\r\nc3331 sw_chair2 33 31 1 0 2\r\nb3431 sw_chair3 34 31 1 0 2\r\nx2732 invisichair 27 32 1 2 2\r\nx2733 invisichair 27 33 1 2 2\r\nx2734 invisichair 27 34 1 2 2\r\nx2836 invisichair 28 36 1 0 2\r\nx2936 invisichair 29 36 1 0 2\r\nx3036 invisichair 30 36 1 0 2\r\nx3136 invisichair 31 36 1 0 2', '0', NULL, NULL, NULL, NULL),
('park_b', 0, 11, 2, 0, 6, '0000x0000000\r0000xx000000\r000000000000\r00000000000x\r000000000000\r00x0000x0000\r', 'C00 cornerchair2 0 0 0 4 2\r\nB10 cornerchair1 1 0 0 4 2\r\nA20 chair1 2 0 0 4 2\r\nA30 chair1 3 0 0 4 2\r\nH50 table1 5 0 0 4 1\r\nE60 chair1line 6 0 0 4 2\r\nA70 chair1 7 0 0 4 2\r\nF80 chair1frontend 8 0 0 4 2\r\nJ100 hububar 10 0 0 4 1\r\nB01 cornerchair1 0 1 0 2 2\r\nA02 chair1 0 2 0 2 2\r\nA03 chair1 0 3 0 2 2\r\nA04 chair1 0 4 0 2 2\r\nF05 chair1frontend 0 5 0 2 2\r\nI35 table2 3 5 0 4 1\r\nD55 modchair 5 5 0 0 2\r\nI85 table2 8 5 0 4 1', '', 'sf', 5000, 1, 6),
('pool_b', 0, 9, 21, 7, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx7xxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx777xxxxxxxxxxx\rxxxxxxxxxxxxxxxxxx8888888x7xxx77777xxxxxxxxxx\rxxxxxxxxxxxxxxxxxx8888888x7xxx777777xxxxxxxxx\rxxxxxxxxxxxxxxxx88xxxxx77x7x777777777xxxxxxxx\rxxxxxxxxxxxxxxxx88x7777777777777777777xxxxxxx\rxxxxxxxxxxxxxxxx88x77777777777777777777xxxxxx\rxxxxxxxxxxxxxx9988x77777777777777777777xxxxxx\rxxxxxxxxxxxxxx9988x7777777777777777777x00xxxx\rxxxxxxxxxxxxxx9988x777777777777777777x0000xxx\rxxxxxxxxxxxxxx9988x7777777x0000000000000000xx\rxxxxxxxxxxxxxx9988x777777x000000000000000000x\r7777777777xxxx9988777777x0x0000000000000000xx\rx7777777777xxx998877777x000x00000000000000xxx\rxx7777777777xx99887777x00000x000000000000xxxx\rxxx7777777777x9988777x0000000x0000000000xxxxx\rxxxx777777777x777777x00000000x000000000xxxxxx\rxxxxx777777777777777000000000x00000000xxxxxxx\rxxxxxx77777777777777000000000x0000000xxxxxxxx\rxxxxxxx777777x7777770000000000xxxx00xxxxxxxxx\rxxxxxxxx77777777777xx0000000000000xxxxxxxxxxx\rxxxxxxxxx777777110000x000000000000xxxxxxxxxxx\rxxxxxxxxxx7x77x1100000x0000000000xxxxxxxxxxxx\rxxxxxxxxxxx777x11000000x00000000xxxxxxxxxxxxx\rxxxxxxxxxxxx771110000000x000000xxxxxxxxxxxxxx\rxxxxxxxxxxxxx111100000000x0000xxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx11100000000x000xxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx1100000000x00xxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxx110000000x0xxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx110000000xxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxx1100000xxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxx11000xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxx110xxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxx1xxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'u332 umbrella2 33 2 7 0 1\r\nb183 pool_2sofa2 18 3 8 4 2\r\nB193 pool_2sofa1 19 3 8 4 2\r\nb203 pool_2sofa2 20 3 8 4 2\r\nB213 pool_2sofa1 21 3 8 4 2\r\nb223 pool_2sofa2 22 3 8 4 2\r\nB233 pool_2sofa1 23 3 8 4 2\r\nc333 pool_chair2 33 3 7 4 2\r\nc324 pool_chair2 32 4 7 2 2\r\nt334 pool_table2 33 4 7 0 1\r\nc344 pool_chair2 34 4 7 6 2\r\nb165 pool_2sofa2 16 5 8 2 2\r\nc335 pool_chair2 33 5 7 0 2\r\nB166 pool_2sofa1 16 6 8 2 2\r\nb167 pool_2sofa2 16 7 8 2 2\r\nc357 pool_chair2 35 7 7 4 2\r\nf148 flower1 14 8 9 0 1\r\nB168 pool_2sofa1 16 8 8 2 2\r\nu338 umbrella2 33 8 7 0 1\r\nc348 pool_chair2 34 8 7 2 2\r\nt358 pool_table2 35 8 7 0 1\r\nc368 pool_chair2 36 8 7 6 2\r\nb149 pool_2sofa2 14 9 9 2 2\r\nb169 pool_2sofa2 16 9 8 2 2\r\nc359 pool_chair2 35 9 7 0 2\r\nB1410 pool_2sofa1 14 10 9 2 2\r\nB1610 pool_2sofa1 16 10 8 2 2\r\nb1411 pool_2sofa2 14 11 9 2 2\r\nb1611 pool_2sofa2 16 11 8 2 2\r\nB1412 pool_2sofa1 14 12 9 2 2\r\nB1612 pool_2sofa1 16 12 8 2 2\r\nR313 flower2b 3 13 7 2 1\r\nr413 flower2a 4 13 7 2 1\r\nb1413 pool_2sofa2 14 13 9 2 2\r\nb1613 pool_2sofa2 16 13 8 2 2\r\nB1414 pool_2sofa1 14 14 9 2 2\r\nB1614 pool_2sofa1 16 14 8 2 2', '1', 'cam1', 4500, 1, 4),
('bb_lobby_1', 0, 14, 19, 0, 0, 'xxx2222222222222222x\r\nxxx2222222222222222x\r\nxxx2222222222222222x\r\nxxx2222222222222222x\r\nxxx11111111111111111\r\n11x11111111111111111\r\n11x11111111111111111\r\n11x11111111111111111\r\nx1x11111111111111111\r\nxxx11111111111111111\r\nxxx11111111111111111\r\nxxx11111111111111111\r\nxxx11111111111111111\r\nxxx11111111111111111\r\nxxxxxxxxx00000000000\r\nxxxxxxxxx00000000000\r\nxxxxxxxxx00000000000\r\nxxxxxxxxx00000000000\r\nxxxxxxxxx00000000000\r\nxxxxxxxxx00000000000\r\nxxxxxxxxxxxxx000xxxx\r\nxxxxxxxxxxxxx000xxxx\r\nxxxxxxxxxxxxx000xxxx', 'n30 bb_crossrd 3 0 2 2 1\r\nb40 bb_bench1 4 0 2 4 2\r\nc50 bb_bench2 5 0 2 4 2\r\nh80 bb_plant1 8 0 2 0 1\r\nd90 bb_sofa1 9 0 2 4 2\r\ne100 bb_sofa2 10 0 2 4 2\r\nh110 bb_plant1 11 0 2 0 1\r\nd120 bb_sofa1 12 0 2 4 2\r\ne130 bb_sofa2 13 0 2 4 2\r\nh140 bb_plant1 14 0 2 0 1\r\nb160 bb_bench1 16 0 2 4 2\r\nc170 bb_bench2 17 0 2 4 2\r\nk180 bb_corner1out 18 0 2 0 1\r\nb31 bb_bench1 3 1 2 2 2\r\no181 bb_wallend1in 18 1 2 2 1\r\nc32 bb_bench2 3 2 2 2 2\r\no182 bb_wallend1in 18 2 2 2 1\r\nj33 bb_plant3 3 3 2 0 1\r\nt73 bb_special 7 3 2 6 1\r\no83 bb_wallend1in 8 3 2 6 1\r\no93 bb_wallend1in 9 3 2 6 1\r\no103 bb_wallend1in 10 3 2 6 1\r\no113 bb_wallend1in 11 3 2 6 1\r\nn123 bb_crossrd 12 3 2 2 1\r\nn163 bb_crossrd 16 3 2 0 1\r\no173 bb_wallend1in 17 3 2 6 1\r\nn183 bb_crossrd 18 3 2 2 1\r\np34 bb_wallend2in 3 4 1 4 1\r\no74 bb_wallend1in 7 4 1 4 1\r\nb84 bb_bench1 8 4 1 4 2\r\nc94 bb_bench2 9 4 1 4 2\r\nb104 bb_bench1 10 4 1 4 2\r\nc114 bb_bench2 11 4 1 4 2\r\np124 bb_wallend2in 12 4 1 4 1\r\no164 bb_wallend1in 16 4 1 4 1\r\nb174 bb_bench1 17 4 1 4 2\r\nc184 bb_bench2 18 4 1 4 2\r\nm194 bb_wallendout 19 4 1 4 1\r\na75 bb_stool 7 5 1 2 2\r\na125 bb_stool 12 5 1 6 2\r\nb195 bb_bench1 19 5 1 6 2\r\na36 bb_stool 3 6 1 6 2\r\nc196 bb_bench2 19 6 1 6 2\r\nf97 bb_chair 9 7 1 4 2\r\nf107 bb_chair 10 7 1 4 2\r\nb177 bb_bench1 17 7 1 0 2\r\nc187 bb_bench2 18 7 1 0 2\r\nm197 bb_wallendout 19 7 1 0 1\r\na38 bb_stool 3 8 1 6 2\r\nu178 bb_extra 17 8 1 4 1\r\nu188 bb_extra 18 8 1 2 1\r\nn198 bb_crossrd 19 8 1 6 1\r\na39 bb_stool 3 9 1 6 2\r\nf99 bb_chair 9 9 1 0 2\r\nf109 bb_chair 10 9 1 0 2\r\nb179 bb_bench1 17 9 1 4 2\r\nc189 bb_bench2 18 9 1 4 2\r\nm199 bb_wallendout 19 9 1 4 1\r\nb1910 bb_bench1 19 10 1 6 2\r\na711 bb_stool 7 11 1 2 2\r\na1211 bb_stool 12 11 1 6 2\r\nc1911 bb_bench2 19 11 1 6 2\r\no712 bb_wallend1in 7 12 1 0 1\r\nb812 bb_bench1 8 12 1 0 2\r\nc912 bb_bench2 9 12 1 0 2\r\nb1012 bb_bench1 10 12 1 0 2\r\nc1112 bb_bench2 11 12 1 0 2\r\np1212 bb_wallend2in 12 12 1 0 1\r\nb1712 bb_bench1 17 12 1 0 2\r\nc1812 bb_bench2 18 12 1 0 2\r\nm1912 bb_wallendout 19 12 1 0 1\r\nk713 bb_corner1out 7 13 1 4 1\r\nl813 bb_wallout 8 13 1 6 1\r\nl913 bb_wallout 9 13 1 6 1\r\nl1013 bb_wallout 10 13 1 6 1\r\nl1113 bb_wallout 11 13 1 6 1\r\nt1213 bb_special 12 13 1 2 1\r\nm1613 bb_wallendout 16 13 1 6 1\r\nl1713 bb_wallout 17 13 1 6 1\r\nl1813 bb_wallout 18 13 1 6 1\r\nk1913 bb_corner1out 19 13 1 2 1\r\ng914 bb_plant0 9 14 0 6 1\r\nd1014 bb_sofa1 10 14 0 4 2\r\ne1114 bb_sofa2 11 14 0 4 2\r\ni1214 bb_plant2 12 14 0 0 1\r\ni1614 bb_plant2 16 14 0 6 1\r\nd1714 bb_sofa1 17 14 0 4 2\r\ne1814 bb_sofa2 18 14 0 4 2\r\ng1914 bb_plant0 19 14 0 0 1\r\nd915 bb_sofa1 9 15 0 2 2\r\nd1915 bb_sofa1 19 15 0 6 2\r\ne916 bb_sofa2 9 16 0 2 2\r\ne1916 bb_sofa2 19 16 0 6 2\r\nd917 bb_sofa1 9 17 0 2 2\r\nd1917 bb_sofa1 19 17 0 6 2\r\ne918 bb_sofa2 9 18 0 2 2\r\ne1918 bb_sofa2 19 18 0 6 2\r\ng919 bb_plant0 9 19 0 4 1\r\nd1019 bb_sofa1 10 19 0 0 2\r\ne1119 bb_sofa2 11 19 0 0 2\r\nj1219 bb_plant3 12 19 0 2 1\r\nj1619 bb_plant3 16 19 0 4 1\r\nd1719 bb_sofa1 17 19 0 0 2\r\ne1819 bb_sofa2 18 19 0 0 2\r\ng1919 bb_plant0 19 19 0 2 1', '0', NULL, NULL, NULL, NULL),
('park_a', 0, 2, 15, 0, 6, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0xxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx00xxxxxxxxxxxx\rxxxxxxxxxxxxx0x00xxxxxxxxxxx0x000xxxxxxxxxxx\rxxxxxxxxxxxx0000000000000000000000xxxxxxxxxx\rxxxxxxxxxxx000000000000000000000000xxxxxxxxx\rxxxxxxxxxxx0000000000000000000000000xxxxxxxx\rxxxxxxxxxxx00000000000000000000000000xxxxxxx\rxxxxxxxx000000000000000000000000000000xxxxxx\rxxxxxxx00000000000000000000000000000000xxxxx\rxxxxxxx000000000000000000000000000000000xxxx\rxxxxxxx0000000000000000000000000000000000xxx\rxxxxxxxxx000000000000000000000000000000000xx\r00000000000000000000xx00000000000000000000xx\r0000000000000000000xxxx00000000000xxxxxxx0xx\r0000000000000000000xxxx00000000000x00000xxxx\rxxxxx00x0000000000xxxxx0xxxxxx0000x0000000xx\rxxxxx0000000000000xxxxx0xx000x0000x000000xxx\rxxxxx0000000000000xxxxx0x000000000x00000xxxx\rxxxxx000000x0000000xxxx0x000000000xxx00xxxxx\rxxxxxxxx000x0000000xxx00xxx000000x0000xxxxxx\rxxxxxxxx000x000000xxxx0x0000000000000xxxxxxx\rxxxxxxxx000x000000011100000000000000xxxxxxxx\rxxxxxxxx000x00000001110000000000000xxxxxxxxx\rxxxxxxxxx00x0000000111x00000000x00xxxxxxxxxx\rxxxxxxxxxx0x0000000xxx0000000xxxxxxxxxxxxxxx\rxxxxxxxxxxxx000000xxxx0000000xxxxxxxxxxxxxxx\rxxxxxxxxxxxx000000xxx00xxxxx00xxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxx0xx000x00xxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxx0x000000xxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxx0x00000xxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxxxx00xxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxxxx0xxxxxxxxxxxxxxxxxxxx\r', 'L89 bench2 8 9 0 4 2\r\nK99 bench 9 9 0 4 2\r\nL711 bench2 7 11 0 2 2\r\nK712 bench 7 12 0 2 2\r\nL3516 bench2 35 16 0 2 2\r\nL3716 bench2 37 16 0 4 2\r\nK3816 bench 38 16 0 4 2\r\nK3517 bench 35 17 0 2 2\r\nL2718 bench2 27 18 0 4 2\r\nK2818 bench 28 18 0 4 2\r\nL3518 bench2 35 18 0 2 2\r\nL2519 bench2 25 19 0 2 2\r\nK3519 bench 35 19 0 2 2\r\nK2520 bench 25 20 0 2 2\r\nL2529 bench2 25 29 0 4 2\r\nK2629 bench 26 29 0 4 2\r\nL2330 bench2 23 30 0 2 2\r\nK2331 bench 23 31 0 2 2', '', 'sf', 5000, 1, 6),
('md_a', 0, 1, 5, 7, 2, 'xxxxxxxx77xxxxxxxxxxxxxxxx\rxxxxxxxx77xxxxxxxxxxxxxxxx\rxxxxxx77777x77xxxxxxxxxxxx\rxxx77777777777xxx44xxxxxxx\r77777777777777xx444444444x\r777777777777777xx44444444x\rxxx777777777777xx44444444x\rxxxx7777777777xxx44444444x\r7777777777777777744448444x\r7777777777777x4x744448444x\r777777777777x444444448444x\r7777777777774444444448444x\r7777777777774444444448444x\r777777777777x444444448444x\r7777777777777x44444448444x\rxxx777777777777x444448444x\rxxx7777777777777444448444x\rxxx7777777777777444448444x\rxxx777777777777x444448444x\rxxx77777777777x4444444444x\rxxxx777777777444444444444x\rxxxxxxxxxxxxxxxxxxxxxxxxxx\r', 'A43 mntdwchair 4 3 7 4 2\r\nA53 mntdwchair 5 3 7 4 2\r\nM28 barmask 2 8 7 0 1\r\ns78 mntdwsofa2 7 8 7 2 2\r\nt88 mntdwtable2 8 8 7 0 2\r\ns98 mntdwsofa2 9 8 7 6 2\r\ny218 paalu5 21 8 8 0 1\r\nM29 barmask 2 9 7 0 1\r\nS79 mntdwsofa1 7 9 7 2 2\r\nT89 mntdwtable1 8 9 7 0 2\r\nS99 mntdwsofa1 9 9 7 6 2\r\ny219 paalu5 21 9 8 0 1\r\nM210 barmask 2 10 7 0 1\r\ny2110 paalu5 21 10 8 0 1\r\nM211 barmask 2 11 7 0 1\r\ny2111 paalu5 21 11 8 0 1\r\nM212 barmask 2 12 7 0 1\r\ns712 mntdwsofa2 7 12 7 4 2\r\nS812 mntdwsofa1 8 12 7 4 2\r\ne2112 paalu3 21 12 8 0 1\r\nM213 barmask 2 13 7 0 1\r\nt713 mntdwtable2 7 13 7 2 1\r\nT813 mntdwtable1 8 13 7 2 1\r\ne2113 paalu3 21 13 8 0 1\r\nM214 barmask 2 14 7 0 1\r\ns714 mntdwsofa2 7 14 7 0 2\r\nS814 mntdwsofa1 8 14 7 0 2\r\ne2114 paalu3 21 14 8 0 1\r\nM215 barmask 2 15 100000 0 1\r\nq2115 paalu1 21 15 8 0 1\r\nM216 barmask 2 16 100000 0 1\r\ns1216 mntdwsofa2 12 16 7 4 2\r\nS1316 mntdwsofa1 13 16 7 4 2\r\nq2116 paalu1 21 16 8 0 1\r\nA317 mntdwchair 3 17 7 2 2\r\ns617 mntdwsofa2 6 17 7 2 2\r\nt717 mntdwtable2 7 17 7 0 1\r\ns817 mntdwsofa2 8 17 7 6 2\r\nt1217 mntdwtable2 12 17 7 2 1\r\nT1317 mntdwtable1 13 17 7 2 1\r\nq2117 paalu1 21 17 8 0 1\r\nA318 mntdwchair 3 18 7 2 2\r\nS618 mntdwsofa1 6 18 7 2 2\r\nT718 mntdwtable1 7 18 7 0 1\r\nS818 mntdwsofa1 8 18 7 6 2\r\ns1218 mntdwsofa2 12 18 7 0 2\r\nS1318 mntdwsofa1 13 18 7 0 2\r\nq2118 paalu1 21 18 8 0 1', '1', 'cam1', 4500, 1, 4),
('picnic', 0, 16, 5, 2, 4, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxx22222xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r22xxxxxxxxxxxxx22xxxxxxxxxxxxxxxxxxxxx\r2222222222222222222x222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222xxx222222222222222222222222\r2222222222xx33x22222222222222222222222\r222222222xx3333x2222222222222222222222\r222222222x333333x222222222222222222222\r222222222x333333x222222222222222222222\r2222222222x3332x2222222222222222222222\r22222222222x33x22222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222x22222xxxx22222222222222222222\r22222222222222xxxx22222222222222222222\r22222222222222xxx222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r22222222222222222222222222222222222222\r', 'h107 hedge7 10 7 2 4 1\r\nh117 hedge7 11 7 2 4 1\r\nh127 hedge7 12 7 2 4 1\r\nh137 hedge7 13 7 2 4 1\r\ny147 hedge8 14 7 2 4 1\r\ns187 hedge2 18 7 2 4 1\r\nh197 hedge7 19 7 2 4 1\r\nh207 hedge7 20 7 2 4 1\r\nh217 hedge7 21 7 2 4 1\r\nz148 hedge9 14 8 2 4 1\r\nz188 hedge9 18 8 2 4 1\r\nv39 hedge5 3 9 2 4 1\r\nz310 hedge9 3 10 2 4 1\r\nc1211 picnic_dummychair1 12 11 3 4 2\r\nc1311 picnic_dummychair1 13 11 3 4 2\r\nc1411 picnic_dummychair1 14 11 100000 4 2\r\nc1013 picnic_dummychair1 10 13 3 2 2\r\nc1513 picnic_dummychair1 15 13 3 6 2\r\nb2113 picnic_ground 21 13 2 4 2\r\nb714 picnic_ground 7 14 2 4 2\r\nc1014 picnic_dummychair1 10 14 3 2 2\r\nc1514 picnic_dummychair1 15 14 3 6 2\r\nb1915 picnic_ground 19 15 2 2 2\r\nb2315 picnic_ground 23 15 2 6 2\r\nb516 picnic_ground 5 16 2 2 2\r\nb916 picnic_ground 9 16 2 6 2\r\nL2016 picnic_cloth1 20 16 2 2 1\r\nL617 picnic_cloth1 6 17 2 2 1\r\nb2117 picnic_ground 21 17 2 0 2\r\nb718 picnic_ground 7 18 2 0 2\r\na019 picnic_redbench2 0 19 2 2 2\r\nA020 picnic_redbench1 0 20 2 2 2\r\nw1120 hedge6 11 20 2 4 1\r\nh1220 hedge7 12 20 2 4 1\r\nh1320 hedge7 13 20 2 4 1\r\nt1420 hedge3 14 20 2 4 1\r\nu1720 hedge4 17 20 2 4 1\r\nh1820 hedge7 18 20 2 4 1\r\nh1920 hedge7 19 20 2 4 1\r\ny2020 hedge8 20 20 2 4 1\r\nv1121 hedge5 11 21 2 4 1\r\nM1221 picnic_bench1 12 21 2 4 2\r\nN1321 picnic_bench2 13 21 2 4 2\r\nO1421 picnic_bench3 14 21 2 4 2\r\nM1721 picnic_bench1 17 21 2 4 2\r\nN1821 picnic_bench2 18 21 2 4 2\r\nO1921 picnic_bench3 19 21 2 4 2\r\nv2021 hedge5 20 21 2 4 1\r\na022 picnic_redbench2 0 22 2 2 2\r\nv1122 hedge5 11 22 2 4 1\r\nv2022 hedge5 20 22 2 4 1\r\nb2522 picnic_ground 25 22 2 4 1\r\nA023 picnic_redbench1 0 23 2 2 2\r\nv1123 hedge5 11 23 2 4 1\r\nM1223 picnic_bench1 12 23 2 2 2\r\nM1923 picnic_bench1 19 23 2 6 2\r\nv2023 hedge5 20 23 2 4 1\r\nc624 picnic_dummychair1 6 24 2 4 2\r\nd724 picnic_dummychair4 7 24 2 4 2\r\ne824 picnic_dummychair6 8 24 2 4 2\r\nv1124 hedge5 11 24 2 4 1\r\nN1224 picnic_bench2 12 24 2 2 2\r\nN1924 picnic_bench2 19 24 2 6 2\r\nv2024 hedge5 20 24 2 4 1\r\nb2324 picnic_ground 23 24 2 2 2\r\nb2724 picnic_ground 27 24 2 6 2\r\nK525 picnic_stump 5 25 2 2 2\r\nv1125 hedge5 11 25 2 4 1\r\nN1225 picnic_bench2 12 25 2 2 2\r\nN1925 picnic_bench2 19 25 2 6 2\r\nv2025 hedge5 20 25 2 4 1\r\nG2425 picnic_cloth2 24 25 2 2 1\r\nK726 picnic_stump 7 26 2 0 2\r\nv1126 hedge5 11 26 2 4 1\r\nO1226 picnic_bench3 12 26 2 2 2\r\nH1426 picnic_fireplace1 14 26 2 0 1\r\nI1626 picnic_fireplace2 16 26 2 2 1\r\nO1926 picnic_bench3 19 26 2 6 2\r\nv2026 hedge5 20 26 2 4 1\r\nb2526 picnic_ground 25 26 2 0 1\r\nz1127 hedge9 11 27 2 4 1\r\nQ1227 picnic_lemonade 12 27 2 4 1\r\nz2027 hedge9 20 27 2 4 1\r\nE829 picnic_firewood2 8 29 2 0 1\r\na030 picnic_redbench2 0 30 2 2 2\r\nD830 picnic_firewood1 8 30 2 0 1\r\nA031 picnic_redbench1 0 31 2 2 2\r\nD831 picnic_firewood1 8 31 2 0 1\r\nM1231 picnic_bench1 12 31 2 4 2\r\nN1331 picnic_bench2 13 31 2 4 2\r\nO1431 picnic_bench3 14 31 2 4 2\r\nM1831 picnic_bench1 18 31 2 4 2\r\nN1931 picnic_bench2 19 31 2 4 2\r\nO2031 picnic_bench3 20 31 2 4 2\r\nf2731 picnic_carrot 27 31 2 0 1\r\nf2831 picnic_carrot 28 31 2 0 1\r\nf2931 picnic_carrot 29 31 2 0 1\r\nf3031 picnic_carrot 30 31 2 0 1\r\nf3131 picnic_carrot 31 31 2 0 1\r\nD832 picnic_firewood1 8 32 2 0 1\r\nF1232 picnic_table2 12 32 2 2 1\r\nP1432 picnic_table 14 32 2 2 1\r\nF1832 picnic_table2 18 32 2 2 1\r\nP2032 picnic_table 20 32 2 2 1\r\nr333 hedge1 3 33 2 4 1\r\nD833 picnic_firewood1 8 33 2 0 1\r\nM1233 picnic_bench1 12 33 2 0 2\r\nN1333 picnic_bench2 13 33 2 0 2\r\nO1433 picnic_bench3 14 33 2 0 2\r\nM1833 picnic_bench1 18 33 2 0 2\r\nN1933 picnic_bench2 19 33 2 0 2\r\nO2033 picnic_bench3 20 33 2 0 2\r\ng2733 picnic_cabbage 27 33 2 0 1\r\ng2833 picnic_cabbage 28 33 2 0 1\r\ng2933 picnic_cabbage 29 33 2 0 1\r\nv334 hedge5 3 34 2 4 1\r\nD834 picnic_firewood1 8 34 2 0 1\r\nv335 hedge5 3 35 2 4 1\r\nD835 picnic_firewood1 8 35 2 0 1\r\nv336 hedge5 3 36 2 4 1\r\nD836 picnic_firewood1 8 36 2 0 1\r\nD837 picnic_firewood1 8 37 2 0 1\r\nM1237 picnic_bench1 12 37 2 4 2\r\nN1337 picnic_bench2 13 37 2 4 2\r\nO1437 picnic_bench3 14 37 2 4 2\r\nM1837 picnic_bench1 18 37 2 4 2\r\nN1937 picnic_bench2 19 37 2 4 2\r\nO2037 picnic_bench3 20 37 2 4 2\r\nD838 picnic_firewood1 8 38 2 0 1\r\nF1238 picnic_table2 12 38 2 2 1\r\nP1438 picnic_table 14 38 2 2 1\r\nF1838 picnic_table2 18 38 2 2 1\r\nP2038 picnic_table 20 38 2 2 1\r\nJ839 picnic_firewood3 8 39 2 0 1\r\nM1239 picnic_bench1 12 39 2 0 2\r\nN1339 picnic_bench2 13 39 2 0 2\r\nO1439 picnic_bench3 14 39 2 0 2\r\nM1839 picnic_bench1 18 39 2 0 2\r\nN1939 picnic_bench2 19 39 2 0 2\r\nO2039 picnic_bench3 20 39 2 0 2', '', 'sf', 5000, 1, 6);
INSERT INTO `room_modeldata` (`model`, `roomomatic_subscr_only`, `door_x`, `door_y`, `door_h`, `door_z`, `heightmap`, `publicroom_items`, `swimmingpool`, `specialcast_emitter`, `specialcast_interval`, `specialcast_rnd_min`, `specialcast_rnd_max`) VALUES
('pub_a', 0, 15, 25, 0, 6, 'xxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxx2222222211111xxx\rxxxxxxxxx2222222211111xxx\rxxxxxxxxx2222222211111xxx\rxxxxxxxxx2222222211111xxx\rxxxxxxxxx2222222222111xxx\rxxxxxxxxx2222222222111xxx\rxxxxxxxxx2222222222000xxx\rxxxxxxxxx2222222222000xxx\rxxxxxxxxx2222222222000xxx\rxxxxxxxxx2222222222000xxx\rx333333332222222222000xxx\rx333333332222222222000xxx\rx333333332222222222000xxx\rx333333332222222222000xxx\rx333333332222222222000xxx\rx333332222222222222000xxx\rx333332222222222222000xxx\rx333332222222222222000xxx\rx333332222222222222000xxx\rx333333332222222222000xxx\rxxxxx31111112222222000xxx\rxxxxx31111111000000000xxx\rxxxxx31111111000000000xxx\rxxxxx31111111000000000xxx\rxxxxx31111111000000000xxx\rxxxxxxxxxxxxxxx00xxxxxxxx\rxxxxxxxxxxxxxxx00xxxxxxxx\rxxxxxxxxxxxxxxx00xxxxxxxx\rxxxxxxxxxxxxxxx00xxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxx\r', 'S191 pub_sofa2 19 1 1 4 1\r\ns201 pub_sofa 20 1 1 4 2\r\ns211 pub_sofa 21 1 1 4 2\r\nq112 bardesk1 11 2 2 0 1\r\nc122 pub_chair 12 2 2 6 2\r\nQ113 bardesk2 11 3 2 0 1\r\nq114 bardesk1 11 4 2 0 1\r\nc124 pub_chair 12 4 2 6 2\r\nQ115 bardesk2 11 5 2 0 1\r\nf185 pub_fence 18 5 2 1 1\r\nq116 bardesk1 11 6 2 0 1\r\nc126 pub_chair 12 6 2 6 2\r\nf186 pub_fence 18 6 2 0 1\r\nQ117 bardesk2 11 7 2 0 1\r\nf187 pub_fence 18 7 2 0 1\r\nq118 bardesk1 11 8 2 0 1\r\nc128 pub_chair 12 8 2 6 2\r\nf188 pub_fence 18 8 2 0 1\r\nw109 bardesk4 10 9 2 0 1\r\nW119 bardesk3 11 9 2 0 1\r\nf189 pub_fence 18 9 2 0 1\r\nf1810 pub_fence 18 10 2 0 1\r\nC211 pub_chair2 2 11 3 4 2\r\nC311 pub_chair2 3 11 3 4 2\r\nC511 pub_chair2 5 11 3 4 2\r\nC611 pub_chair2 6 11 3 4 2\r\nf811 pub_fence 8 11 3 1 1\r\nf1811 pub_fence 18 11 2 0 1\r\nf812 pub_fence 8 12 3 0 1\r\nf1812 pub_fence 18 12 2 0 1\r\nf813 pub_fence 8 13 3 0 1\r\nC913 pub_chair2 9 13 2 2 2\r\nk1413 pub_chair3 14 13 2 2 2\r\nT1513 pub_table2 15 13 2 1 1\r\nk1613 pub_chair3 16 13 2 6 2\r\nf1813 pub_fence 18 13 2 0 1\r\nf814 pub_fence 8 14 3 2 1\r\nC914 pub_chair2 9 14 2 2 2\r\nk1414 pub_chair3 14 14 2 2 2\r\nT1514 pub_table2 15 14 2 2 1\r\nk1614 pub_chair3 16 14 2 6 2\r\nf1814 pub_fence 18 14 2 0 1\r\nt115 pub_table 1 15 3 0 1\r\nf515 pub_fence 5 15 3 1 1\r\nf1815 pub_fence 18 15 2 0 1\r\nS116 pub_sofa2 1 16 3 2 2\r\nf516 pub_fence 5 16 3 0 1\r\nf1816 pub_fence 18 16 2 0 1\r\ns117 pub_sofa 1 17 3 2 2\r\nf517 pub_fence 5 17 3 0 1\r\nk1317 pub_chair3 13 17 2 4 2\r\nk1417 pub_chair3 14 17 2 4 2\r\nk1517 pub_chair3 15 17 2 4 2\r\nk1617 pub_chair3 16 17 2 4 2\r\nf1817 pub_fence 18 17 2 0 1\r\ns118 pub_sofa 1 18 3 2 2\r\nf518 pub_fence 5 18 3 0 1\r\nT1318 pub_table2 13 18 2 5 1\r\nT1418 pub_table2 14 18 2 6 1\r\nT1518 pub_table2 15 18 2 6 1\r\nT1618 pub_table2 16 18 2 4 1\r\nf1818 pub_fence 18 18 2 0 1\r\ns219 pub_sofa 2 19 3 0 2\r\nS319 pub_sofa2 3 19 3 0 2\r\nf519 pub_fence 5 19 3 0 1\r\nk1319 pub_chair3 13 19 2 0 2\r\nk1419 pub_chair3 14 19 2 0 2\r\nk1519 pub_chair3 15 19 2 0 2\r\nk1619 pub_chair3 16 19 2 0 2\r\nf1819 pub_fence 18 19 2 0 1\r\nf120 pub_fence 1 20 3 5 1\r\nf220 pub_fence 2 20 3 6 1\r\nf320 pub_fence 3 20 3 6 1\r\nf420 pub_fence 4 20 3 6 1\r\nf520 pub_fence 5 20 3 3 1\r\nf1820 pub_fence 18 20 2 0 1\r\nS721 pub_sofa2 7 21 1 4 2\r\ns821 pub_sofa 8 21 1 4 2\r\nf1221 pub_fence 12 21 2 5 1\r\nf1321 pub_fence 13 21 2 6 1\r\nf1421 pub_fence 14 21 2 6 1\r\nf1521 pub_fence 15 21 2 6 1\r\nf1621 pub_fence 16 21 2 6 1\r\nf1721 pub_fence 17 21 2 6 1\r\nf1821 pub_fence 18 21 2 3 1\r\nS622 pub_sofa2 6 22 1 2 2\r\nt1522 pub_table 15 22 0 0 1\r\nC1622 pub_chair2 16 22 0 4 2\r\nC1722 pub_chair2 17 22 0 4 2\r\ns623 pub_sofa 6 23 1 2 2\r\nT823 pub_table2 8 23 1 1 1\r\ns624 pub_sofa 6 24 1 2 2\r\nT824 pub_table2 8 24 1 0 1\r\ns625 pub_sofa 6 25 1 2 2\r\nT825 pub_table2 8 25 1 2 1', '', 'sf', 5000, 1, 6),
('pool_a', 0, 2, 25, 7, 2, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx7xxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx777xxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx7777777xxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx77777777xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx77777777xxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx777777777xxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7xxx777777xxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7x777777777xxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7xxx77777777xxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7x777777777x7xxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7xxx7777777777xxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx777777777777xxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx77777777777x2111xxxxxxxxxxxx\rxxxxxxxxxxxxxxx7777777777x221111xxxxxxxxxxx\rxxxxxxxxx7777777777777777x2211111xxxxxxxxxx\rxxxxxxxxx7777777777777777x22211111xxxxxxxxx\rxxxxxxxxx7777777777777777x222211111xxxxxxxx\rxxxxxx77777777777777777777x222211111xxxxxxx\rxxxxxx7777777xx777777777777x222211111xxxxxx\rxxxxxx7777777xx77777777777772222111111xxxxx\rxxxxxx777777777777777777777x22221111111xxxx\rxx7777777777777777777777x322222211111111xxx\r77777777777777777777777x33222222111111111xx\r7777777777777777777777x333222222211111111xx\rxx7777777777777777777x333322222222111111xxx\rxx7777777777777777777333332222222221111xxxx\rxx777xxx777777777777733333222222222211xxxxx\rxx777x7x77777777777773333322222222222xxxxxx\rxx777x7x7777777777777x33332222222222xxxxxxx\rxxx77x7x7777777777777xx333222222222xxxxxxxx\rxxxx77777777777777777xxx3222222222xxxxxxxxx\rxxxxx777777777777777777xx22222222xxxxxxxxxx\rxxxxxx777777777777777777x2222222xxxxxxxxxxx\rxxxxxxx777777777777777777222222xxxxxxxxxxxx\rxxxxxxxx7777777777777777722222xxxxxxxxxxxxx\rxxxxxxxxx77777777777777772222xxxxxxxxxxxxxx\rxxxxxxxxxx777777777777777222xxxxxxxxxxxxxxx\rxxxxxxxxxxx77777777777777x2xxxxxxxxxxxxxxxx\rxxxxxxxxxxxx77777777777777xxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxx777777777777xxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx7777777777xxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx77777777xxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxx777777xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx7777xxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxx77xxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r', 'u184 umbrella2 18 4 7 0 1\r\nb185 pool_2sofa2 18 5 7 2 2\r\nB186 pool_2sofa1 18 6 7 2 2\r\nu720 umbrella2 7 20 7 0 1\r\nc820 pool_chair2 8 20 7 4 2\r\nu2420 umbrella2 24 20 7 0 1\r\nc2520 pool_chair2 25 20 7 4 2\r\nc721 pool_chair2 7 21 7 2 2\r\nt821 pool_table2 8 21 7 0 2\r\nc921 pool_chair2 9 21 7 6 2\r\nc2421 pool_chair2 24 21 7 2 2\r\nt2521 pool_table2 25 21 7 0 1\r\nc822 pool_chair2 8 22 7 0 2\r\nR228 flower2b 2 28 7 0 1\r\nr229 flower2a 2 29 7 0 1\r\nL632 box 6 32 7 0 1\r\nf1333 flower1 13 33 7 0 1\r\ny1034 pool_chairy 10 34 7 4 2\r\n8835 umbrellay 8 35 7 0 1\r\ny935 pool_chairy 9 35 7 2 2 2\r\nQ1035 pool_tabley 10 35 7 0 1\r\ny1135 pool_chairy 11 35 7 6 2\r\n91535 umbrellap 15 35 7 0 1\r\n72135 umbrellao 21 35 7 0 1\r\ny1036 pool_chairy 10 36 7 0 2\r\nP1536 pool_chairp 15 36 7 4 2\r\no2136 pool_chairo 21 36 7 4 2\r\no2236 pool_chairo 22 36 7 4 2\r\nP1437 pool_chairp 14 37 7 2 2\r\nZ1537 pool_tablep 15 37 7 0 1\r\nP1637 pool_chairp 16 37 7 6 2\r\nK2137 pool_tabo 21 37 7 6 1\r\nk2237 pool_tabo2 22 37 7 6 1\r\nP1438 pool_chairp 14 38 7 2 2\r\nz1538 pool_tablep2 15 38 7 0 1\r\nP1638 pool_chairp 16 38 7 6 2\r\no2138 pool_chairo 21 38 7 0 2\r\no2238 pool_chairo 22 38 7 0 2\r\nP1539 pool_chairp 15 39 7 0 2\r\ng2041 pool_chairg 20 41 7 4 2\r\ng2141 pool_chairg 21 41 7 4 2\r\nW2042 pool_tablg 20 42 7 6 1\r\nw2142 pool_tablg2 21 42 7 6 1\r\nG1943 umbrellag 19 43 7 0 1\r\ng2043 pool_chairg 20 43 7 0 2\r\ng2143 pool_chairg 21 43 7 0 2', '1', 'sf', 5000, 1, 6),
('sunset_cafe', 0, 34, 40, 0, 4, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000000xxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxx00000xx00000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx00000000xxx0000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx00000000xxxx000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxx0000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx00000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000xxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000xxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0000xxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\n', 'd3221 chairup4 32 21 0 3 2\r\nf3321 chairup6 33 21 0 4 2\r\nf3421 chairup6 34 21 0 4 2\r\nf3521 chairup6 35 21 0 4 2\r\nf3621 chairup6 36 21 0 4 2\r\ng3721 chairup7 37 21 0 4 2\r\nb3222 chairup2 32 22 0 2 2\r\ne2523 chairup5 25 23 0 4 2\r\nf2623 chairup6 26 23 0 4 2\r\nf2723 chairup6 27 23 0 4 2\r\nf2823 chairup6 28 23 0 4 2\r\ng2923 chairup7 29 23 0 4 2\r\na3223 chairup1 32 23 0 2 2\r\nA2424 counter5 24 24 0 7 1\r\nr2524 table2 25 24 0 7 1\r\nq2624 table1 26 24 0 7 1\r\np2425 counter3 24 25 0 7 1\r\nz2426 counter4 24 26 0 7 1\r\np2427 counter3 24 27 0 7 1\r\np2428 counter3 24 28 0 7 1\r\ny2928 palms4 29 28 0 7 1\r\np2429 counter3 24 29 0 7 1\r\nx2929 palms3 29 29 0 7 1\r\np2430 counter3 24 30 0 7 1\r\nw2930 palms2 29 30 0 7 1\r\nn2231 counter1 22 31 0 7 1\r\nn2331 counter1 23 31 0 7 1\r\no2431 counter2 24 31 0 7 1\r\nv2931 palms1 29 31 0 7 1\r\ne3031 chairup5 30 31 0 4 2\r\nf3131 chairup6 31 31 0 4 2\r\nf3231 chairup6 32 31 0 4 2\r\nf3331 chairup6 33 31 0 4 2\r\nf3431 chairup6 34 31 0 4 2\r\nf3531 chairup6 35 31 0 4 2\r\nf3631 chairup6 36 31 0 4 2\r\nj3731 chairright3 37 31 0 5 2\r\nc2132 chairup3 21 32 0 2 2\r\nt2232 table4 22 32 0 7 1\r\nr3032 table2 30 32 0 7 1\r\nq3132 table1 31 32 0 7 1\r\nr3332 table2 33 32 0 7 1\r\nq3432 table1 34 32 0 7 1\r\ni3732 chairright2 37 32 0 6 2\r\nb2133 chairup2 21 33 0 2 2\r\ns2233 table3 22 33 0 7 1\r\ni3733 chairright2 37 33 0 6 2\r\nb2134 chairup2 21 34 0 2 2\r\nt3634 table4 36 34 0 7 1\r\ni3734 chairright2 37 34 0 6 2\r\nb2135 chairup2 21 35 0 2 2\r\nr2435 table2 24 35 0 7 1\r\nq2535 table1 25 35 0 7 1\r\nr2735 table2 27 35 0 7 1\r\nq2835 table1 28 35 0 7 1\r\nu3335 palm 33 35 0 7 1\r\ns3635 table3 36 35 0 7 1\r\ni3735 chairright2 37 35 0 6 2\r\nm2136 chairleft3 21 36 0 1 2\r\nl2236 chairleft2 22 36 0 0 2\r\nl2336 chairleft2 23 36 0 0 2\r\nl2436 chairleft2 24 36 0 0 2\r\nl2536 chairleft2 25 36 0 0 2\r\nl2636 chairleft2 26 36 0 0 2\r\nl2736 chairleft2 27 36 0 0 2\r\nk2836 chairleft1 28 36 0 0 2\r\ni3736 chairright2 37 36 0 6 2\r\nt3637 table4 36 37 0 7 1\r\ni3737 chairright2 37 37 0 6 2\r\ns3638 table3 36 38 0 7 1\r\nh3738 chairright1 37 38 0 6 2', '', 'sf', 5000, 1, 6),
('floatinggarden', 0, 2, 21, 5, 0, 'xxxxxxxxxxxxxxxx333333xxxxxxxxx\rxxxxxxxxxxxxxxxx3xxxx3xxxxxxxxx\rxxxxxxxxxxxxxxxx3xxxx3xxxxxxxxx\rxxxxxxxxxxxxxxxx3xxxx3xxxxxxxxx\rxxxxxxxxxxxxxxx223xxx33xxxxxxxx\rxxxxxxxxxxxxxxx11xxx33333xxxxxx\rxxxxxxxxxxxxxxxx11xx3333333xxxx\rxxxxxxxxxxxxxxxx11xx33333333xxx\rxxxxxxxxxxxxxxxxx11xxxxxxxx3xxx\rxxxxxxxxxxxxxxxxxx11xxxx3333xxx\rxxxxxxxxxxxxxxxxxxx1xxxx33333xx\rxxxxxxxxxxxxxxxxxxx1xxx3333333x\r555xxxxxxxxxxx1111111x333333333\r555xxxxxxxxxxx21111111xxxxxx333\r555xxxxxxxxxxx22111111111xxxxxx\r555xxxxxxxxxxx222xxxxxxx111xxxx\r555xxxxxxxxxxx22xxxxxxxxxx1xxxx\r555xxxxxxxxxxx23333333333x111xx\r555xxxxxxxx33333333333333x111xx\r555xxxxxxxx333333x3333333x111xx\r555xxxxxxxx33333333333333x111xx\r555xxxxxxxx33x33333333333x111xx\r555xxxxxxxx33x33x33333333x111xx\r555xxxxxxxx33x33x33333333x111xx\r5554333333333x333x3333333x111xx\rx554333333xxxx33xxxxxxxxxx111xx\rxxxxxxxxx3xxxx333221111111111xx\rxxxxxxxxx3xxxx333221111111111xx\rxxxxxxxxx33333333xx1111x11x11xx\rxxxxxxxxx33333333111xxx11xxxxxx\rxxxxxxxxxxxxxx33311xxxx11xxxxxx\rxxxxxxxxxxxxxx33311xxxx11xxxxxx\rxxxxxxxxxxxxxx333x1xxxx11xxxxxx\rxxxxxxxxxxxxxx333x1xx111111xxxx\rxxxxxxxxxxxxxx33311xx111111xxxx\rxxxxxxxxxx333333311xx111111xxxx\rxxxxxxxxxxx33333311xx111111xxxx\rxxxxxxxxxxxxxxxx111xxxxxxxxxxxx\rxxxxxxxxxxxxxxx111xxxxxxxxxxxxx\r', 'a249 float_dummychair 24 9 3 4 2\r\na259 float_dummychair 25 9 3 4 2\r\nb2813 float_dummychair2 28 13 3 4 2\r\nb2913 float_dummychair2 29 13 3 4 2\r\ne1717 floatbench2 17 17 3 2 2\r\ne1917 floatbench2 19 17 3 6 2\r\ne2117 floatbench2 21 17 3 2 2\r\ne2317 floatbench2 23 17 3 6 2\r\ne2717 floatbench2 27 17 1 4 2\r\nd2817 floatbench1 28 17 1 4 2\r\nd1718 floatbench1 17 18 3 2 2\r\nd1918 floatbench1 19 18 3 6 2\r\nd2118 floatbench1 21 18 3 2 2\r\nd2318 floatbench1 23 18 3 6 2\r\ne2719 floatbench2 27 19 1 0 2\r\nd2819 floatbench1 28 19 1 0 2\r\ne1723 floatbench2 17 23 3 2 2\r\ne1923 floatbench2 19 23 3 6 2\r\ne2123 floatbench2 21 23 3 2 2\r\ne2323 floatbench2 23 23 3 6 2\r\ne2723 floatbench2 27 23 1 4 2\r\nd2823 floatbench1 28 23 1 4 2\r\nd1724 floatbench1 17 24 100000 2 2\r\nd1924 floatbench1 19 24 3 6 2\r\nd2124 floatbench1 21 24 3 2 2\r\nd2324 floatbench1 23 24 3 6 2\r\ne2725 floatbench2 27 25 1 0 2\r\nd2825 floatbench1 28 25 1 0 2\r\na1729 float_dummychair 17 29 1 2 2\r\na1730 float_dummychair 17 30 1 2 2\r\na1731 float_dummychair 17 31 1 2 2\r\na2133 float_dummychair 21 33 1 2 2\r\na2633 float_dummychair 26 33 1 6 2\r\na2134 float_dummychair 21 34 1 2 2\r\na2634 float_dummychair 26 34 1 6 2\r\na1735 float_dummychair 17 35 1 2 2\r\na2135 float_dummychair 21 35 1 2 2\r\na2635 float_dummychair 26 35 1 6 2\r\na1736 float_dummychair 17 36 1 2 2\r\na2136 float_dummychair 21 36 1 2 2\r\na2636 float_dummychair 26 36 1 6 2\r\na1537 float_dummychair 15 37 100000 4 2\r\na1637 float_dummychair 16 37 1 4 2', '', 'sf', 5000, 1, 6),
('library', 0, 20, 3, 1, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxx11111xx1xx1x111111x\rxxxxxxxxxxxx111111xx1xx11111111x\rxx111xxxxxxx111111xx1xx11111111x\rxx111xxxxxxx1111111111111111111x\rxx111xxxxxxx1111111111111111111x\rxx111xxxxxxx1111111111111111111x\rxx111xxxxxxx1111111111111xxxxxxx\rxx111xxxxxx11111111111111111111x\rxx111xxxxxx11111111111111111111x\rxx111xxxxxx11111111111111111111x\rxx111xxxxxx11111111111111xxxxxxx\rxx111xxxxxxxx111111111111111111x\rxx111xx11111x111111111111111111x\rxx111xx11111x111111111111111111x\rxx111xxxxx11x11111111x111xxxxxxx\rxx111xxxxxxxx11111111xx11111111x\rxx111xxx1111111111111xxx1111111x\rxx111xxx1111111111111xxxx111111x\rxxx111xx1111111111x11xxxx000000x\rxxxxx1111xx1111111x11xxxx000000x\rxxxxxxxxxxxx111111x11xxxx000000x\rxxxxxxxxxxxx11xx11x11xxxx000000x\rxxxxxxxxxxxx11xx11x11xxxx000000x\rxxxxxxxxxxxx11xx11x11xxxx000000x\rxxxxxxxxxxxx11xx11x11xxxx000000x\rxxxxxxxxxxxx11xx11x11xxxx000000x\rxxxxxxxxxxxx11xx11x111xxx000000x\rxxxxxxxxxxxxxxxxxxxx11xxx000000x\rxxxxxxxxxxxxxxxxxxxx11xxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\rxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\rxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\rxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\rxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\rxxxxxxxxxxxxxxxxxxxx22222xxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r', 'a142 libchair 14 2 1 4 2\r\na162 libchair 16 2 1 4 2\r\na262 libchair 26 2 1 4 2\r\na243 libchair 24 3 1 2 2\r\na124 libchair 12 4 1 2 2\r\na126 libchair 12 6 1 2 2\r\nb1314 libstool 13 14 1 6 2\r\nb1315 libstool 13 15 1 6 2\r\nb1316 libstool 13 16 1 6 2\r\na2827 libchair 28 27 0 4 2\r\na2729 libchair 27 29 0 2 2\r\nb2433 libstool 24 33 2 6 2\r\nb2434 libstool 24 34 2 6 2\r\nb2435 libstool 24 35 2 6 2\r\nb2136 libstool 21 36 2 0 2\r\nb2236 libstool 22 36 2 0 2\r\nb2336 libstool 23 36 2 0 2', '', 'sf', 5000, 1, 6),
('theater', 0, 20, 27, 0, 0, 'XXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXX111111111XXXXXXX\rXXXXXXX11111111100000XX\rXXXX00X11111111100000XX\rXXXX00x11111111100000XX\r4XXX00X11111111100000XX\r4440000XXXXXXXXX00000XX\r444000000000000000000XX\r4XX000000000000000000XX\r4XX0000000000000000000X\r44400000000000000000000\r44400000000000000000000\r44X0000000000000000O000\r44X11111111111111111000\r44X11111111111111111000\r33X11111111111111111000\r22X11111111111111111000\r22X11111111111111111000\r22X11111111111111111000\r22X11111111111111111000\r22X11111111111111111000\r22211111111111111111000\r22211111111111111111000\rXXXXXXXXXXXXXXXXXXXX00X\rXXXXXXXXXXXXXXXXXXXX00X\r', 'm1110 mic 11 10 1 0 1\r\nd211 thchair2 2 11 4 2 2\r\nd212 thchair2 2 12 4 2 2\r\nd215 thchair2 2 15 4 2 2\r\nc615 thchair1 6 15 0 0 2\r\nc715 thchair1 7 15 0 0 2\r\nc815 thchair1 8 15 0 0 2\r\nc915 thchair1 9 15 0 0 2\r\nc1015 thchair1 10 15 0 0 2\r\nc1215 thchair1 12 15 0 0 2\r\nc1315 thchair1 13 15 0 0 2\r\nc1415 thchair1 14 15 0 0 2\r\nc1515 thchair1 15 15 0 0 2\r\nc1615 thchair1 16 15 0 0 2\r\nd216 thchair2 2 16 4 2 2\r\nc620 thchair1 6 20 1 0 2\r\nc720 thchair1 7 20 1 0 2\r\nc820 thchair1 8 20 1 0 2\r\nc920 thchair1 9 20 1 0 2\r\nc1020 thchair1 10 20 1 0 2\r\nc1220 thchair1 12 20 1 0 2\r\nc1320 thchair1 13 20 1 0 2\r\nc1420 thchair1 14 20 1 0 2\r\nc1520 thchair1 15 20 1 0 2\r\nc1620 thchair1 16 20 1 0 2\r\nc623 thchair1 6 23 1 0 2\r\nc723 thchair1 7 23 1 0 2\r\nc823 thchair1 8 23 1 0 2\r\nc923 thchair1 9 23 1 0 2\r\nc1023 thchair1 10 23 1 0 2\r\nc1223 thchair1 12 23 1 0 2\r\nc1323 thchair1 13 23 1 0 2\r\nc1423 thchair1 14 23 1 0 2\r\nc1523 thchair1 15 23 1 0 2\r\nc1623 thchair1 16 23 1 0 2\r\nc626 thchair1 6 26 1 0 2\r\nc726 thchair1 7 26 1 0 2\r\nc826 thchair1 8 26 1 0 2\r\nc926 thchair1 9 26 1 0 2\r\nc1026 thchair1 10 26 1 0 2\r\nc1226 thchair1 12 26 1 0 2\r\nc1326 thchair1 13 26 1 0 2\r\nc1426 thchair1 14 26 1 0 2\r\nc1526 thchair1 15 26 1 0 2\r\nc1626 thchair1 16 26 1 0 2', '', 'sf', 5000, 1, 6),
('m', 0, 0, 15, 1, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('newbie_lobby', 0, 2, 11, 0, 2, 'xxxxxxxxxxxxxxxx000000\rxxxxx0xxxxxxxxxx000000\rxxxxx00000000xxx000000\rxxxxx000000000xx000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\rxxxxx000000000000000xx\rxxxxx000000000000000xx\rx0000000000000000000xx\rx0000000000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxxx0000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxx000000000000xxxxx\rxxxxx000000000000xxxxx\r', 'a160 crl_lamp 16 0 0 0 1\r\ny170 crl_sofa2c 17 0 0 4 2\r\nw180 crl_sofa2b 18 0 0 4 2\r\nv190 crl_sofa2a 19 0 0 4 2\r\na200 crl_lamp 20 0 0 0 1\r\nb161 crl_chair 16 1 0 2 2\r\na72 crl_lamp 7 2 0 0 1\r\na112 crl_lamp 11 2 0 0 1\r\nb162 crl_chair 16 2 0 2 2\r\nc53 crl_pillar 5 3 0 0 1\r\nb73 crl_chair 7 3 0 2 2\r\nu93 crl_table1b 9 3 0 0 1\r\ns113 crl_sofa1c 11 3 0 6 2\r\nb163 crl_chair 16 3 0 2 2\r\nA193 crl_table2b 19 3 0 0 1\r\nz203 crl_table2a 20 3 0 0 1\r\na04 crl_lamp 0 4 0 0 1\r\ny14 crl_sofa2c 1 4 0 4 2\r\nw24 crl_sofa2b 2 4 0 4 2\r\nv34 crl_sofa2a 3 4 0 4 2\r\na44 crl_lamp 4 4 0 0 1\r\nt94 crl_table1a 9 4 0 0 1\r\nr114 crl_sofa1b 11 4 0 6 2\r\nh154 crl_wall2a 15 4 0 0 1\r\na164 crl_lamp 16 4 0 0 1\r\nb05 crl_chair 0 5 0 2 2\r\nb75 crl_chair 7 5 0 2 2\r\nq115 crl_sofa1a 11 5 0 6 2\r\nA26 crl_table2b 2 6 0 0 1\r\nz36 crl_table2a 3 6 0 0 1\r\na116 crl_lamp 11 6 0 0 1\r\nb07 crl_chair 0 7 0 2 2\r\na08 crl_lamp 0 8 0 0 1\r\nD18 crl_sofa3c 1 8 0 0 2\r\nC28 crl_sofa3b 2 8 0 0 2\r\nB38 crl_sofa3a 3 8 0 0 2\r\na48 crl_lamp 4 8 0 0 1\r\no198 crl_barchair2 19 8 0 0 2\r\np208 crl_tablebar 20 8 0 0 1\r\no218 crl_barchair2 21 8 0 0 2\r\nE59 crl_pillar2 5 9 0 0 1\r\nc99 crl_pillar 9 9 0 0 1\r\nP815 crl_desk1a 8 15 0 0 1\r\nO915 crl_deski 9 15 0 0 1\r\nN1015 crl_deskh 10 15 0 0 1\r\nM1016 crl_deskg 10 16 0 0 1\r\nL1017 crl_deskf 10 17 0 0 1\r\nK1018 crl_deske 10 18 0 0 1\r\nK1019 crl_deske 10 19 0 0 1\r\nK1020 crl_deske 10 20 0 0 1\r\nK1021 crl_deske 10 21 0 0 1\r\nK1022 crl_deske 10 22 0 0 1\r\nK1023 crl_deske 10 23 0 0 1\r\nG724 crl_wallb 7 24 0 0 1\r\nK1024 crl_deske 10 24 0 0 1\r\nF725 crl_walla 7 25 0 0 1\r\nH825 crl_desk1b 8 25 0 0 1\r\nI925 crl_desk1c 9 25 0 0 1\r\nJ1025 crl_desk1d 10 25 0 0 1\r\nd1227 crl_lamp2 12 27 0 0 1\r\nf1327 crl_cabinet2 13 27 0 0 1\r\ne1427 crl_cabinet1 14 27 0 0 1\r\nd1527 crl_lamp2 15 27 0 0 1', '', 'sf', 5000, 1, 6),
('n', 0, 0, 16, 0, 0, 'xxxxxxxxxxxxxxxxxxxxx\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx000000xxxxxxxx000000\rx000000x000000x000000\rx000000x000000x000000\rx000000x000000x000000\rx000000x000000x000000\rx000000x000000x000000\rx000000x000000x000000\rx000000xxxxxxxx000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rxxxxxxxxxxxxxxxxxxxxx\r', '', '', '0', 1, NULL, NULL),
('o', 0, 0, 18, 1, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx00000000xxxx\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxxxxxxxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('p', 0, 0, 23, 2, 0, 'xxxxxxxxxxxxxxxxxxx\r\nxxxxxxx222222222222\r\nxxxxxxx222222222222\r\nxxxxxxx222222222222\r\nxxxxxxx222222222222\r\nxxxxxxx222222222222\r\nxxxxxxx222222222222\r\nxxxxxxx22222222xxxx\r\nxxxxxxx11111111xxxx\r\nx222221111111111111\r\nx222221111111111111\r\nx222221111111111111\r\nx222221111111111111\r\nx222221111111111111\r\nx222221111111111111\r\nx222221111111111111\r\nx222221111111111111\r\nx2222xx11111111xxxx\r\nx2222xx00000000xxxx\r\nx2222xx000000000000\r\nx2222xx000000000000\r\nx2222xx000000000000\r\nx2222xx000000000000\r\nx2222xx000000000000\r\nx2222xx000000000000\r\nxxxxxxxxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('r', 0, 11, 4, 3, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxx333333333333333\r\nxxxxxxxxxx333333333333333\r\nxxxxxxxxxx333333333333333\r\nxxxxxxxxxx333333333333333\r\nxxxxxxxxxx333333333333333\r\nxxxxxxxxxx333333333333333\r\nxxxxxxx333333333333333333\r\nxxxxxxx333333333333333333\r\nxxxxxxx333333333333333333\r\nxxxxxxx333333333333333333\r\nxxxxxxx333333333333333333\r\nxxxxxxx333333333333333333\r\nx4444433333xxxxxxxxxxxxxx\r\nx4444433333xxxxxxxxxxxxxx\r\nx44444333333222xx000000xx\r\nx44444333333222xx000000xx\r\nxxx44xxxxxxxx22xx000000xx\r\nxxx33xxxxxxxx11xx000000xx\r\nxxx33322222211110000000xx\r\nxxx33322222211110000000xx\r\nxxxxxxxxxxxxxxxxx000000xx\r\nxxxxxxxxxxxxxxxxx000000xx\r\nxxxxxxxxxxxxxxxxx000000xx\r\nxxxxxxxxxxxxxxxxx000000xx\r\nxxxxxxxxxxxxxxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('k', 0, 0, 13, 0, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxx00000000\r\nxxxxxxxxxxxxxxxxx00000000\r\nxxxxxxxxxxxxxxxxx00000000\r\nxxxxxxxxxxxxxxxxx00000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nx000000000000000000000000\r\nx000000000000000000000000\r\nx000000000000000000000000\r\nx000000000000000000000000\r\nx000000000000000000000000\r\nx000000000000000000000000\r\nx000000000000000000000000\r\nx000000000000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxx0000000000000000\r\nxxxxxxxxxxxxxxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('l', 0, 0, 16, 0, 0, 'xxxxxxxxxxxxxxxxxxxxx\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rxxxxxxxxxxxxxxxxxxxxx\r', '', '', '0', 1, NULL, NULL),
('q', 0, 10, 4, 2, 0, 'xxxxxxxxxxxxxxxxxxxrnxxxxxxxxxx22222222rnxxxxxxxxxx22222222rnxxxxxxxxxx22222222rnxxxxxxxxx222222222rnxxxxxxxxxx22222222rnxxxxxxxxxx22222222rn222222222222222222rn222222222222222222rn222222222222222222rn222222222222222222rn222222222222222222rn222222222222222222rn2222xxxxxxxxxxxxxxrn2222xxxxxxxxxxxxxxrn2222211111xx000000rn222221111110000000rn222221111110000000rn2222211111xx000000rnx22xxx1111xxxxxxxxrnx11xxx1111xxxxxxxxrn1111xx1111xx000000rn1111xx111110000000rn1111xx111110000000rn1111xx1111xx000000rnxxxxxxxxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('e', 0, 1, 5, 0, 0, 'xxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\r', '', '', '0', 1, NULL, NULL),
('f', 0, 2, 5, 0, 0, 'xxxxxxxxxxxx\rxxxxxxx0000x\rxxxxxxx0000x\rxxx00000000x\rxxx00000000x\rxxx00000000x\rxxx00000000x\rx0000000000x\rx0000000000x\rx0000000000x\rx0000000000x\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\r', '', '', '0', 1, NULL, NULL),
('g', 0, 1, 7, 1, 0, 'xxxxxxxxxxxxx\rxxxxxxxxxxxxx\rxxxxxxx00000x\rxxxxxxx00000x\rxxxxxxx00000x\rxx1111000000x\rxx1111000000x\rxx1111000000x\rxx1111000000x\rxx1111000000x\rxxxxxxx00000x\rxxxxxxx00000x\rxxxxxxx00000x\rxxxxxxxxxxxxx\rxxxxxxxxxxxxx\rxxxxxxxxxxxxx\rxxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('h', 0, 4, 4, 1, 0, 'xxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxx111111x\rxxxxx111111x\rxxxxx111111x\rxxxxx111111x\rxxxxx111111x\rxxxxx000000x\rxxxxx000000x\rxxx00000000x\rxxx00000000x\rxxx00000000x\rxxx00000000x\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('i', 0, 0, 10, 0, 0, 'xxxxxxxxxxxxxxxxx\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rxxxxxxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('j', 0, 0, 10, 0, 0, 'xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxx\r', '', '', '0', 1, NULL, NULL),
('a', 0, 3, 5, 0, 0, 'xxxxxxxxxxxx\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxxxxxxxxxx\rxxxxxxxxxxxx\r', '', '', '0', 1, NULL, NULL),
('b', 0, 0, 5, 0, 0, 'xxxxxxxxxxxx\rxxxxx0000000\rxxxxx0000000\rxxxxx0000000\rxxxxx0000000\rx00000000000\rx00000000000\rx00000000000\rx00000000000\rx00000000000\rx00000000000\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\r', '', '', '0', 1, NULL, NULL),
('c', 0, 4, 7, 0, 0, 'xxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx', '', '', '0', 1, NULL, NULL),
('d', 0, 4, 7, 0, 0, 'xxxxxxxxxxxx\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxxxxxxxxx\r', '', '', '0', 1, NULL, NULL),
('s', 0, 0, 3, 0, 2, 'xxxxxxxxx\r\n000000xx\r\n000000xx\r\n0000A0xx\r\n000000xx\r\n000000xx\r\n000A00xx\r\n000000xx\r\nxxxxxxxx', '', '1', NULL, NULL, NULL, NULL);

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

--
-- Structure de la table `room_modeldata_triggers`
--

CREATE TABLE IF NOT EXISTS `room_modeldata_triggers` (
  `id` int(5) NOT NULL auto_increment,
  `model` varchar(100) collate latin1_general_ci NOT NULL,
  `object` varchar(100) collate latin1_general_ci NOT NULL,
  `x` int(5) NOT NULL default '0',
  `y` int(5) NOT NULL default '0',
  `stepx` int(5) NOT NULL,
  `stepy` int(5) NOT NULL,
  `goalx` int(5) NOT NULL,
  `goaly` int(5) NOT NULL,
  `roomid` int(10) NOT NULL default '0',
  `state` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=64 ;

--
-- Contenu de la table `room_modeldata_triggers`
--

INSERT INTO `room_modeldata_triggers` (`id`, `model`, `object`, `x`, `y`, `stepx`, `stepy`, `goalx`, `goaly`, `roomid`, `state`) VALUES
(1, 'pool_a', 'curtains1', 17, 11, 0, 0, 19, 11, 0, '0'),
(2, 'pool_a', 'curtains2', 17, 9, 0, 0, 19, 9, 0, '0'),
(5, 'md_a', 'curtains1', 8, 0, 0, 0, 8, 2, 0, '0'),
(6, 'md_a', 'curtains2', 9, 0, 0, 0, 9, 2, 0, '0'),
(3, 'pool_a', 'Splash0 enter', 20, 28, 21, 28, 22, 28, 0, '0'),
(4, 'pool_a', 'Splash0 exit', 21, 28, 20, 28, 19, 28, 0, '0'),
(7, 'md_a', 'Splash0 enter', 11, 11, 12, 12, 13, 12, 0, '0'),
(8, 'md_a', 'Splash0 exit', 12, 12, 11, 11, 10, 11, 0, '0'),
(9, 'pool_b', 'door', 0, 0, 0, 0, 0, 0, 0, '0'),
(13, 'pool_b', 'split_land', 6, 19, 0, 0, 0, 0, 0, '0'),
(16, 'pool_a', 'split_land', 20, 4, 0, 0, 0, 0, 0, '0'),
(12, 'pool_a', 'split_swim', 38, 22, 0, 0, 0, 0, 0, '0'),
(17, 'pool_a', 'split_land', 21, 5, 0, 0, 0, 0, 0, '0'),
(10, 'pool_a', 'split_land', 24, 8, 0, 0, 0, 0, 0, '0'),
(14, 'pool_b', 'split_land', 9, 22, 0, 0, 0, 0, 0, '0'),
(15, 'pool_a', 'split_land', 19, 3, 0, 0, 0, 0, 0, '0'),
(18, 'pool_a', 'split_land', 22, 6, 0, 0, 0, 0, 0, '0'),
(19, 'pool_a', 'split_land', 23, 7, 0, 0, 0, 0, 0, '0'),
(20, 'pool_a', 'split_land', 24, 8, 0, 0, 0, 0, 0, '0'),
(21, 'pool_a', 'split_land', 25, 9, 0, 0, 0, 0, 0, '0'),
(22, 'pool_a', 'split_land', 26, 10, 0, 0, 0, 0, 0, '0'),
(23, 'pool_a', 'split_land', 27, 11, 0, 0, 0, 0, 0, '0'),
(24, 'pool_a', 'split_land', 28, 12, 0, 0, 0, 0, 0, '0'),
(25, 'pool_a', 'split_swim', 30, 14, 0, 0, 0, 0, 0, '0'),
(26, 'pool_a', 'split_swim', 31, 15, 0, 0, 0, 0, 0, '0'),
(27, 'pool_a', 'split_swim', 32, 16, 0, 0, 0, 0, 0, '0'),
(28, 'pool_a', 'split_swim', 33, 17, 0, 0, 0, 0, 0, '0'),
(29, 'pool_a', 'split_swim', 34, 18, 0, 0, 0, 0, 0, '0'),
(30, 'pool_a', 'split_swim', 35, 19, 0, 0, 0, 0, 0, '0'),
(31, 'pool_a', 'split_swim', 36, 20, 0, 0, 0, 0, 0, '0'),
(32, 'pool_a', 'split_swim', 37, 21, 0, 0, 0, 0, 0, '0'),
(33, 'pool_a', 'split_swim', 38, 22, 0, 0, 0, 0, 0, '0'),
(34, 'pool_b', 'split_land', 0, 13, 0, 0, 0, 0, 0, '0'),
(35, 'pool_b', 'split_land', 1, 14, 0, 0, 0, 0, 0, '0'),
(36, 'pool_b', 'split_land', 2, 15, 0, 0, 0, 0, 0, '0'),
(37, 'pool_b', 'split_land', 3, 16, 0, 0, 0, 0, 0, '0'),
(38, 'pool_b', 'split_land', 4, 17, 0, 0, 0, 0, 0, '0'),
(39, 'pool_b', 'split_land', 5, 18, 0, 0, 0, 0, 0, '0'),
(40, 'pool_b', 'split_land', 6, 19, 0, 0, 0, 0, 0, '0'),
(41, 'pool_b', 'split_land', 7, 20, 0, 0, 0, 0, 0, '0'),
(42, 'pool_b', 'split_land', 8, 21, 0, 0, 0, 0, 0, '0'),
(43, 'pool_b', 'split_land', 9, 22, 0, 0, 0, 0, 0, '0'),
(44, 'pool_b', 'split_land', 10, 23, 0, 0, 0, 0, 0, '0'),
(45, 'pool_b', 'split_land', 11, 24, 0, 0, 0, 0, 0, '0'),
(46, 'pool_b', 'split_land', 12, 25, 0, 0, 0, 0, 0, '0'),
(47, 'pool_b', 'split_swim', 13, 26, 0, 0, 0, 0, 0, '0'),
(48, 'pool_b', 'split_swim', 14, 27, 0, 0, 0, 0, 0, '0'),
(49, 'pool_b', 'split_swim', 15, 28, 0, 0, 0, 0, 0, '0'),
(50, 'pool_b', 'split_swim', 16, 29, 0, 0, 0, 0, 0, '0'),
(51, 'pool_b', 'split_swim', 17, 30, 0, 0, 0, 0, 0, '0'),
(52, 'pool_b', 'split_swim', 18, 31, 0, 0, 0, 0, 0, '0'),
(53, 'pool_b', 'split_swim', 19, 32, 0, 0, 0, 0, 0, '0'),
(54, 'pool_b', 'split_swim', 20, 33, 0, 0, 0, 0, 0, '0'),
(55, 'pool_b', 'split_swim', 21, 34, 0, 0, 0, 0, 0, '0'),
(56, 'pool_b', 'Splash0 enter', 17, 21, 17, 22, 17, 23, 17, '0'),
(57, 'pool_b', 'Splash0 exit', 17, 22, 17, 21, 17, 20, 17, '0'),
(58, 'pool_b', 'Splash0 enter', 19, 19, 20, 19, 21, 19, 22, '0'),
(59, 'pool_b', 'Splash0 exit', 20, 19, 19, 19, 18, 19, 17, '0'),
(60, 'pool_b', 'Splash0 enter', 31, 10, 31, 11, 31, 12, 31, '0'),
(61, 'pool_b', 'Splash0 exit', 31, 11, 31, 10, 31, 9, 31, '0');

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

--
-- Structure de la table `room_rights`
--

CREATE TABLE IF NOT EXISTS `room_rights` (
  `roomid` int(11) NOT NULL,
  `userid` int(10) NOT NULL,
  KEY `index` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `room_rights`
--

INSERT INTO `room_rights` (`roomid`, `userid`) VALUES
(155, 38),
(158, 52),
(221, 44),
(232, 91),
(223, 47),
(300, 401),
(1610, 401),
(307, 36),
(307, 71),
(307, 148),
(346, 80),
(343, 148),
(355, 159),
(367, 117),
(388, 167),
(260, 39),
(260, 156),
(375, 193),
(375, 189),
(317, 189),
(376, 189),
(449, 117),
(455, 117),
(459, 164),
(474, 92),
(490, 206),
(376, 215),
(387, 215),
(376, 122),
(213, 122),
(376, 216),
(445, 92),
(555, 92),
(558, 92),
(581, 117),
(590, 117),
(558, 185),
(624, 104),
(630, 189),
(851, 382),
(554, 50),
(260, 241),
(665, 206),
(554, 36),
(677, 241),
(677, 247),
(679, 247),
(445, 122),
(445, 265),
(689, 245),
(697, 275),
(649, 122),
(782, 288),
(262, 303),
(764, 245),
(445, 200),
(445, 243),
(763, 241),
(819, 285),
(831, 241),
(851, 91),
(851, 189),
(346, 189),
(166, 241),
(913, 236),
(346, 241),
(859, 318),
(931, 241),
(673, 275),
(851, 50),
(937, 241),
(471, 236),
(770, 241),
(942, 330),
(810, 189),
(931, 364),
(931, 81),
(816, 189),
(967, 364),
(971, 371),
(931, 382),
(931, 371),
(955, 382),
(955, 371),
(270, 233),
(1017, 330),
(1019, 330),
(1021, 330),
(1042, 248),
(351, 91),
(1060, 344),
(1058, 248),
(1058, 405),
(1066, 401),
(346, 382),
(828, 382),
(827, 382),
(673, 382),
(656, 382),
(624, 382),
(622, 382),
(1086, 86),
(1102, 401),
(1134, 101),
(1142, 91),
(1159, 423),
(421, 344),
(1160, 396),
(1185, 99),
(1185, 104),
(1212, 248),
(1213, 55),
(435, 382),
(1249, 453),
(1137, 449),
(1305, 101),
(1336, 488),
(1351, 495),
(1212, 502),
(1364, 438),
(1364, 495),
(1402, 438),
(1425, 349),
(1437, 525),
(1456, 55),
(1471, 502),
(1501, 484),
(750, 248),
(750, 402),
(750, 536),
(1504, 265),
(1502, 265),
(1485, 265),
(1058, 583),
(1376, 397),
(601, 401),
(1571, 603),
(1664, 618),
(1661, 620),
(1331, 92),
(1700, 92),
(1567, 285),
(1571, 344),
(1712, 578),
(456, 578),
(1571, 402),
(733, 91),
(235, 66),
(244, 91),
(245, 66),
(730, 91),
(1207, 66),
(1791, 66),
(1792, 91),
(1798, 657),
(1797, 117),
(1798, 92),
(1823, 297),
(1826, 644),
(1829, 676),
(1837, 599),
(1846, 599),
(1850, 344),
(1867, 344),
(1867, 248),
(1882, 592),
(1845, 410),
(2693, 297),
(1571, 528),
(1917, 248),
(1917, 691),
(1571, 285),
(1944, 709),
(1960, 712),
(1961, 712),
(1977, 528),
(1977, 382),
(1978, 716),
(1978, 382),
(1938, 474),
(1729, 722),
(1571, 713),
(2023, 648),
(1995, 744),
(1503, 716),
(2675, 948),
(2615, 1014),
(1431, 750),
(2089, 401),
(2089, 104),
(2017, 749),
(2141, 575),
(2160, 402),
(2172, 402),
(300, 191),
(300, 597),
(2180, 769),
(2187, 769),
(2414, 875),
(2196, 402),
(2222, 236),
(2375, 806),
(2401, 806),
(2403, 870),
(2406, 720),
(2424, 875),
(2384, 870),
(2381, 869),
(2476, 835),
(2424, 1062),
(2325, 769),
(2500, 909),
(2514, 919),
(2528, 36),
(2439, 1058),
(2522, 769),
(1661, 944),
(2528, 942),
(2561, 919),
(2578, 104),
(2725, 948),
(2528, 982),
(2622, 769),
(2634, 769),
(2653, 185),
(2675, 66),
(2681, 66),
(2713, 938),
(2729, 634),
(2615, 950),
(2733, 634),
(2744, 938),
(2832, 919),
(2836, 188),
(2836, 720),
(2847, 1067),
(2615, 769);

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

--
-- Structure de la table `room_votes`
--

CREATE TABLE IF NOT EXISTS `room_votes` (
  `roomid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `vote` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `room_votes`
--

INSERT INTO `room_votes` (`roomid`, `userid`, `vote`) VALUES
(148, 1, 1),
(161, 10, 1),
(148, 16, 1),
(163, 16, 1),
(164, 20, 1),
(171, 20, 1);

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

--
-- Structure de la table `soundmachine_playlists`
--

CREATE TABLE IF NOT EXISTS `soundmachine_playlists` (
  `machineid` int(10) NOT NULL,
  `songid` int(10) NOT NULL,
  `pos` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `soundmachine_playlists`
--


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

--
-- Structure de la table `soundmachine_songs`
--

CREATE TABLE IF NOT EXISTS `soundmachine_songs` (
  `id` int(10) NOT NULL auto_increment,
  `userid` int(10) NOT NULL,
  `title` varchar(100) collate latin1_general_ci NOT NULL,
  `machineid` int(10) NOT NULL,
  `length` int(3) NOT NULL,
  `data` text collate latin1_general_ci NOT NULL,
  `burnt` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Contenu de la table `soundmachine_songs`
--


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

--
-- Structure de la table `system`
--

CREATE TABLE IF NOT EXISTS `system` (
  `onlinecount` int(3) NOT NULL default '0',
  `onlinecount_peak` int(10) NOT NULL,
  `connections_accepted` int(10) NOT NULL,
  `activerooms` int(10) NOT NULL,
  `activerooms_peak` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `system`
--

INSERT INTO `system` (`onlinecount`, `onlinecount_peak`, `connections_accepted`, `activerooms`, `activerooms_peak`) VALUES
(1, 1, 1, 1, 1);

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

--
-- Structure de la table `system_chatlog`
--

CREATE TABLE IF NOT EXISTS `system_chatlog` (
  `username` varchar(15) collate latin1_general_ci NOT NULL,
  `roomid` int(10) NOT NULL,
  `mtime` time NOT NULL default '00:00:00',
  `message` varchar(200) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `system_chatlog`
--

INSERT INTO `system_chatlog` (`username`, `roomid`, `mtime`, `message`) VALUES
('Hotelfico', 148, '22:00:15', ':trasforma gatto'),
('Hotelfico', 148, '22:00:22', ':trasforma gatto'),
('Hotelfico', 148, '22:00:24', ':chiudi'),
('Hotelfico', 148, '22:00:28', ':comand'),
('Hotelfico', 148, '22:00:30', ':comandi'),
('Hotelfico', 148, '18:18:27', ':puliscimano'),
('Hotelfico', 148, '18:30:46', ':pulisciman'),
('Hotelfico', 148, '18:30:49', ':puliscimano'),
('Hotelfico', 148, '18:32:52', ':puliscimano'),
('Hotelfico', 148, '18:45:39', ':puliscimano'),
('Hotelfico', 148, '18:46:23', ':puliscimano'),
('Hotelfico', 148, '19:06:14', ':offline 5'),
('Hotelfico', 148, '19:06:25', ':offline'),
('Hotelfico', 148, '19:06:31', ':offline 5000'),
('Hotelfico', 148, '19:10:11', ':ha ciao'),
('Hotelfico', 148, '19:10:37', ':sendme'),
('Hotelfico', 148, '19:10:51', ':sendme 14; 13'),
('Hotelfico', 148, '19:10:57', ':sendme 13'),
('Hotelfico', 148, '19:11:02', ':sendme 13, 45'),
('Hotelfico', 148, '19:11:09', ':sendme 13 14'),
('Hotelfico', 148, '19:12:33', ':chiudi 4'),
('Hotelfico', 148, '19:12:42', ':chiudi 99999999999999999999999999999999999999999999999'),
('Hotelfico', 148, '19:13:14', ':chiudi 540'),
('Hotelfico', 148, '19:18:52', ':puliscimano'),
('Hotelfico', 148, '19:18:55', ':catalogo'),
('Hotelfico', 148, '19:19:10', ':refresh'),
('Hotelfico', 148, '19:19:19', ':refresh catalogo'),
('Hotelfico', 148, '19:25:37', ':ui asd'),
('Hotelfico', 148, '20:28:26', ':puliscimano'),
('Hotelfico', 148, '20:56:58', ':puliscimano'),
('Hotelfico', 148, '20:57:05', ':chiudi 0,1'),
('Hotelfico', 107, '21:08:22', ':tuffo'),
('Dario9494', 148, '21:57:41', ':comandi'),
('Dario9494', 148, '21:57:53', ':creatore'),
('Hotelfico', 107, '13:18:28', ':costume'),
('Hotelfico', 107, '13:18:37', ':tuffo'),
('Hotelfico', 107, '13:20:38', ':tuffo'),
('Espace', 175, '19:43:21', ':commands'),
('Espace', 175, '19:43:39', ':hotelalert cc'),
('Espace', 175, '19:43:52', ':ha Message des coke staffs'),
('Espace', 175, '20:01:47', ':transforma gatto'),
('Espace', 175, '20:01:50', ':gatto'),
('Espace', 175, '20:01:52', ':commands'),
('Espace', 175, '20:02:03', ':refresh'),
('Espace', 175, '20:02:09', ':refresh '),
('Espace', 175, '20:02:15', ':refresh'),
('Espace', 175, '20:02:23', ':refresh strings'),
('Espace', 175, '20:02:30', ':hotelalert cc'),
('Espace', 175, '20:02:54', ':lol'),
('Espace', 175, '20:03:01', ':ha  cc cc cc'),
('Espace', 175, '20:03:09', ':refresh '),
('Espace', 175, '20:15:00', ':refresh catalogue'),
('Espace', 175, '20:15:16', ':refresh catalogue'),
('Espace', 107, '19:02:19', ':commands'),
('Espace', 107, '19:02:35', ':coins espace 3'),
('Espace', 107, '19:02:46', ':credits 3'),
('Espace', 107, '19:02:50', ':coins 3'),
('Espace', 107, '19:02:55', ':cmds'),
('Espace', 107, '19:02:58', ':commands'),
('Espace', 107, '19:03:09', ':alert Espace cc'),
('Espace', 107, '19:03:17', ':ha bonjour'),
('Espace', 107, '19:04:00', ':achat gatto cc'),
('Espace', 175, '19:59:25', 'A'),
('Espace', 175, '19:59:26', 'A'),
('Espace', 175, '19:59:27', 'A'),
('Espace', 175, '19:59:28', 'A'),
('Espace', 175, '19:59:29', 'A'),
('Espace', 175, '19:59:30', 'A'),
('Espace', 175, '19:59:31', 'A'),
('Espace', 175, '19:59:32', 'A'),
('Espace', 175, '19:59:33', 'A'),
('Espace', 175, '19:59:34', 'A'),
('Espace', 175, '19:59:35', 'A'),
('Espace', 175, '19:59:37', 'A'),
('Espace', 112, '20:04:05', 'l''infobus on!'),
('Espace', 112, '20:08:50', ':commands'),
('Espace', 112, '20:08:57', ':teleport on'),
('Espace', 112, '20:09:30', ':warp 1 1'),
('Espace', 112, '20:09:33', ':warp 3 3'),
('Espace', 112, '20:09:38', ':warp 8 7'),
('Espace', 112, '20:09:44', ':warp 8 '),
('Espace', 112, '20:09:53', ':warp 9 9'),
('Espace', 112, '20:09:59', ':warp 3 3'),
('Espace', 112, '20:10:05', ':warp 5 5'),
('Espace', 112, '20:10:15', ':warp 7 5'),
('Espace', 112, '20:10:24', 'warp 7 7'),
('Espace', 112, '20:10:30', ':warp 7 7'),
('Espace', 112, '20:10:45', ':info espace'),
('Espace', 112, '20:10:55', ':find Espace'),
('Espace', 112, '20:11:03', ':roomshutup fuck'),
('Espace', 112, '20:11:11', 'bon alors fermÃ© lÃ '),
('Espace', 115, '20:26:46', ':commands'),
('Espace', 115, '20:26:52', ':whosonline'),
('Espace', 115, '20:27:00', ':hotelalert cc'),
('Espace', 115, '20:27:03', ':ha cc'),
('Espace', 175, '01:03:05', ':commands'),
('Espace', 175, '01:31:26', ':commands'),
('Espace', 175, '01:31:40', ':achete chat Espace'),
('Espace', 175, '01:31:50', ':acheter chat espace'),
('Espace', 175, '01:32:41', ':acheter chat espac'),
('Espace', 175, '13:23:39', ':achete chat lol'),
('Espace', 175, '13:25:12', ':commands'),
('Espace', 175, '13:25:37', ':achete croco lol'),
('Espace', 176, '13:26:27', ':achete chat coucou'),
('Espace', 176, '13:31:35', ':achete chat Espace'),
('Espace', 176, '13:31:47', 'il es mortr'),
('Espace', 176, '13:31:47', 'aa'),
('Espace', 176, '13:31:48', 'a'),
('Espace', 176, '13:31:48', 'aa'),
('Espace', 176, '13:31:48', 'a'),
('Espace', 176, '15:43:16', 'saute'),
('Espace', 176, '15:43:23', 'assis'),
('Espace', 176, '15:43:45', 'Espace'),
('Espace', 176, '15:43:48', 'cc'),
('Espace', 176, '15:43:51', 'cc'),
('Espace', 175, '15:44:42', ':achete gatto lol'),
('Espace', 175, '15:45:03', ':achete gatto lol'),
('Espace', 177, '15:46:46', ':achete crocoddilo'),
('Espace', 177, '15:46:50', ':achete gatto cc'),
('Espace', 175, '15:58:57', ':commands'),
('Espace', 175, '15:59:12', ':hotelalert Ã©Ã©Ã©Ã©Ã©Ã©'),
('Espace', 175, '15:59:21', ':ha ccc'),
('Espace', 109, '16:04:44', ':swim'),
('Espace', 109, '16:04:46', ':commands'),
('Espace', 109, '16:04:49', ':teleport on'),
('Espace', 109, '16:04:59', ':teleport off'),
('Espace', 177, '17:10:48', ':commands'),
('Espace', 177, '17:10:54', ':refresh'),
('Espace', 177, '17:11:05', ':refresh fusez'),
('Espace', 177, '17:26:03', ':refresh catalogue'),
('Espace', 177, '17:29:48', ':refresh catalogue'),
('Espace', 177, '17:58:19', ':refresh catalogue');

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

--
-- Structure de la table `system_config`
--

CREATE TABLE IF NOT EXISTS `system_config` (
  `id` int(10) NOT NULL auto_increment,
  `skey` varchar(100) collate latin1_general_ci NOT NULL,
  `sval` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=38 ;

--
-- Contenu de la table `system_config`
--

INSERT INTO `system_config` (`id`, `skey`, `sval`) VALUES
(1, 'server_game_port', '147'),
(2, 'server_game_maxconnections', '4000'),
(4, 'server_mus_port', '148'),
(5, 'server_mus_maxconnections', '50000'),
(6, 'server_mus_host', '127.0.0.1'),
(3, 'server_game_backlog', '25000'),
(7, 'server_mus_backlog', '5000'),
(8, 'lang', 'en'),
(9, 'welcomemessage_enable', '1'),
(10, 'wordfilter_enable', '1'),
(11, 'wordfilter_censor', 'bobba'),
(12, 'chatanims_enable', '1'),
(13, 'trading_enable', '1'),
(14, 'recycler_enable', '1'),
(15, 'recycler_minownertime', '43200'),
(16, 'recycler_session_length', '60'),
(17, 'recycler_session_expirelength', '10080'),
(18, 'rooms_loadadvertisement_img', 'http://ads.habbohotel.co.uk/max/adview.php?zoneid=325&n=hhuk'),
(19, 'rooms_loadadvertisement_uri', 'http://www.habboboss.tk/'),
(20, 'statuses_wave_duration', '1500'),
(21, 'statuses_carryitem_sipamount', '10'),
(22, 'statuses_carryitem_sipinterval', '9000'),
(23, 'statuses_carryitem_sipduration', '1000'),
(24, 'rooms_roomban_duration', '15'),
(25, 'items_stacking_maxstackheight', '20'),
(28, 'navigator_roomsearch_maxresults', '30'),
(27, 'navigator_createroom_maxrooms', '50'),
(26, 'events_categorycount', '11'),
(29, 'navigator_opencategory_maxresults', '30'),
(30, 'navigator_favourites_maxrooms', '30'),
(31, 'events_deadevents_removeinterval', '120'),
(32, 'soundmachine_burntodisk_disktid', '1355'),
(35, 'game_bb_gamelength_seconds', '180'),
(34, 'game_scorewindow_restartgame_seconds', '1200'),
(33, 'game_countdown_seconds', '10'),
(36, 'spectator_bar_enabled', '1'),
(37, '', '');

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

--
-- Structure de la table `system_fuserights`
--

CREATE TABLE IF NOT EXISTS `system_fuserights` (
  `id` int(3) NOT NULL auto_increment,
  `minrank` int(1) NOT NULL,
  `fuseright` varchar(100) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`,`fuseright`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=42 ;

--
-- Contenu de la table `system_fuserights`
--

INSERT INTO `system_fuserights` (`id`, `minrank`, `fuseright`) VALUES
(1, 1, 'default'),
(2, 1, 'fuse_login'),
(3, 1, 'fuse_buy_credits'),
(4, 1, 'fuse_trade'),
(5, 1, 'fuse_room_queue_default'),
(6, 2, 'fuse_extended_buddylist'),
(7, 2, 'fuse_habbo_chooser'),
(8, 2, 'fuse_furni_chooser'),
(9, 2, 'fuse_room_queue_club'),
(10, 3, 'fuse_priority_access'),
(11, 2, 'fuse_use_special_room_layouts'),
(12, 2, 'fuse_use_club_dance'),
(13, 3, 'fuse_enter_full_rooms'),
(14, 4, 'fuse_enter_locked_rooms'),
(16, 5, 'fuse_kick'),
(17, 4, 'fuse_mute'),
(18, 5, 'fuse_ban'),
(19, 5, 'fuse_room_mute'),
(20, 5, 'fuse_room_kick'),
(21, 5, 'fuse_receive_calls_for_help'),
(22, 5, 'fuse_remove_stickies'),
(23, 6, 'fuse_mod'),
(24, 6, 'fuse_superban'),
(25, 6, 'fuse_pick_up_any_furni'),
(26, 6, 'fuse_ignore_room_owner'),
(27, 6, 'fuse_any_room_controller'),
(28, 4, 'fuse_room_alert'),
(29, 6, 'fuse_moderator_access'),
(30, 7, 'fuse_administrator_access'),
(31, 7, 'fuse_see_flat_ids'),
(35, 5, 'fuse_chat_log'),
(33, 6, 'fuse_performance_panel'),
(34, 4, 'fuse_alert'),
(36, 5, 'fuse_see_all_roomowners'),
(37, 6, 'fuse_hotelalert'),
(38, 6, 'fuse_teleport'),
(39, 7, 'fuse_guide'),
(40, 7, 'fuse_freeze'),
(41, 6, 'fuse_chat_log');

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

--
-- Structure de la table `system_recycler`
--

CREATE TABLE IF NOT EXISTS `system_recycler` (
  `rclr_cost` int(5) NOT NULL,
  `rclr_reward` int(10) NOT NULL,
  PRIMARY KEY  (`rclr_cost`,`rclr_reward`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `system_recycler`
--


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

--
-- Structure de la table `system_stafflog`
--

CREATE TABLE IF NOT EXISTS `system_stafflog` (
  `id` int(5) NOT NULL auto_increment,
  `action` varchar(12) collate latin1_general_ci NOT NULL,
  `message` text collate latin1_general_ci,
  `note` text collate latin1_general_ci,
  `userid` int(11) NOT NULL,
  `targetid` int(11) default NULL,
  `timestamp` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=96 ;

--
-- Contenu de la table `system_stafflog`
--

INSERT INTO `system_stafflog` (`id`, `action`, `message`, `note`, `userid`, `targetid`, `timestamp`) VALUES
(1, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '19-02-2009 14:14:29'),
(2, 'Housekeeping', 'Updated Server Settings (Configurazioni generali)', 'server.php', 1, 0, '19-02-2009 14:14:39'),
(3, 'Housekeeping', 'Updated CMS Settings (General Configuration)', 'cms_config.php', 1, 0, '19-02-2009 14:14:52'),
(4, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '19-02-2009 14:15:08'),
(5, 'Housekeeping', 'Gave user ADM badge', 'badgetool.php', 1, 1, '19-02-2009 14:17:25'),
(6, 'Housekeeping', 'Gave user HC2 badge', 'badgetool.php', 1, 1, '19-02-2009 14:17:29'),
(7, 'Housekeeping', 'Gave user HC3 badge', 'badgetool.php', 1, 1, '19-02-2009 14:17:32'),
(8, 'Housekeeping', 'Gave user HC4 badge', 'badgetool.php', 1, 1, '19-02-2009 14:17:36'),
(9, 'Housekeeping', 'Gave user HC5 badge', 'badgetool.php', 1, 1, '19-02-2009 14:17:39'),
(10, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '21-02-2009 15:13:48'),
(11, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '21-02-2009 15:14:07'),
(12, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '22-02-2009 09:55:15'),
(13, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '22-02-2009 09:55:45'),
(14, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '23-02-2009 09:47:48'),
(15, 'Housekeeping', 'Gave user ADM badge', 'badgetool.php', 1, 1, '23-02-2009 09:47:54'),
(16, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '23-02-2009 12:21:26'),
(17, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:21:45'),
(18, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:23:25'),
(19, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:23:40'),
(20, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:24:00'),
(21, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:25:13'),
(22, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:25:36'),
(23, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:26:45'),
(24, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:27:01'),
(25, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:27:22'),
(26, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:28:50'),
(27, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:29:31'),
(28, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:30:05'),
(29, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:30:21'),
(30, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:30:36'),
(31, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:30:46'),
(32, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '23-02-2009 12:31:04'),
(33, 'halert', 'xD', '', 1, 0, '23/02/2009 16.11.34'),
(34, 'halert', 'xasfadas', '', 1, 0, '23/02/2009 16.12.37'),
(35, 'halert', '', '', 1, 0, '23/02/2009 16.14.57'),
(36, 'halert', 'asdasdasd', '', 1, 0, '23/02/2009 16.15.03'),
(37, 'halert', 'asd', '', 1, 0, '23/02/2009 16.15.19'),
(38, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '01-03-2009 19:25:45'),
(39, 'Housekeeping', 'Updated CMS Settings (General Configuration)', 'cms_config.php', 1, 0, '01-03-2009 19:25:56'),
(40, 'Housekeeping', 'Updated Server Settings (Welcome Message Options)', 'welcomemsg.php', 1, 0, '01-03-2009 19:26:38'),
(41, 'Housekeeping', 'Updated CMS Settings (General Configuration)', 'cms_config.php', 1, 0, '01-03-2009 19:30:31'),
(42, 'halert', 'tutti da me Hotelfico', '', 1, 0, '01/03/2009 19.48.02'),
(43, 'halert', 'tutti da me Hotelfico', '', 1, 0, '01/03/2009 19.55.16'),
(44, 'halert', 'mi spoglio', '', 1, 0, '01/03/2009 19.55.21'),
(45, 'Housekeeping', 'Edited user', 'edituser.php', 1, 1, '01-03-2009 19:55:34'),
(46, 'halert', 'tutti da me', '', 1, 0, '01/03/2009 20.03.05'),
(47, 'halert', 'David495 puzza', '', 1, 0, '01/03/2009 20.04.16'),
(48, 'halert', 'scherzo', '', 1, 0, '01/03/2009 20.04.20'),
(49, 'Housekeeping', 'Gave user HC2 badge', 'badgetool.php', 1, 5, '01-03-2009 20:08:12'),
(50, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '02-03-2009 14:56:56'),
(51, 'halert', 'riavvio 2 secondi il server rientrate', '', 1, 0, '02/03/2009 15.00.37'),
(52, 'halert', 'scusate ÃƒÂ¨ caduta la mia connessione', '', 1, 0, '02/03/2009 15.31.17'),
(53, 'halert', 'mi assento per un po dall''hotel continuate', '', 1, 0, '02/03/2009 15.54.03'),
(54, 'halert', 'a chiamare gente voi a presto by Hotelfico', '', 1, 0, '02/03/2009 15.54.12'),
(55, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '03-03-2009 15:02:41'),
(56, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '03-03-2009 15:02:59'),
(57, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '03-03-2009 15:04:22'),
(58, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '03-03-2009 15:18:08'),
(59, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '04-03-2009 16:15:30'),
(60, 'Housekeeping', 'Updated CMS Settings (Turn your site on/off)', 'maintenance.php', 1, 0, '04-03-2009 16:20:02'),
(61, 'Housekeeping', 'Updated CMS Settings (Turn your site on/off)', 'maintenance.php', 1, 0, '04-03-2009 16:20:10'),
(62, 'Housekeeping', 'Updated CMS Settings (Turn your site on/off)', 'maintenance.php', 1, 0, '04-03-2009 16:22:11'),
(63, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '04-03-2009 16:59:15'),
(64, 'Housekeeping', 'Updated CMS Settings (General Configuration)', 'cms_config.php', 1, 0, '04-03-2009 17:00:50'),
(65, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '04-03-2009 17:17:34'),
(66, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '04-03-2009 21:13:41'),
(67, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '04-03-2009 21:14:04'),
(68, 'Housekeeping', 'Edited user', 'edituser.php', 1, 2, '04-03-2009 21:15:30'),
(69, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '05-03-2009 18:16:19'),
(70, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '11/10/2009 19:49:00'),
(71, 'Housekeeping', 'Updated CMS Settings (General Configuration)', 'cms_config.php', 1, 0, '11/10/2009 19:49:13'),
(72, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '11/10/2009 19:50:58'),
(73, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '11/10/2009 19:52:07'),
(74, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '11/10/2009 19:58:07'),
(75, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '11/10/2009 19:58:14'),
(76, 'Housekeeping', 'Updated Server Settings (General Configuration)', 'server.php', 1, 0, '11/10/2009 19:59:57'),
(77, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '14/10/2009 16:12:47'),
(78, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '14/10/2009 16:13:44'),
(79, 'Housekeeping', 'Updated Server Settings (General Configuration)', 'server.php', 1, 0, '14/10/2009 16:27:30'),
(80, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '14/10/2009 16:27:45'),
(81, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '14/10/2009 16:41:35'),
(82, 'Housekeeping', 'Changed user rank to 7', 'ranktool.php', 1, 22, '14/10/2009 16:41:51'),
(83, 'Housekeeping', 'Espace authenticated from 127.0.0.1', 'login.php', 22, 0, '21/10/2009 18:58:45'),
(84, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 22, 0, '21/10/2009 18:59:16'),
(85, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 22, 0, '21/10/2009 19:00:21'),
(86, 'Housekeeping', 'Espace authenticated from 127.0.0.1', 'login.php', 22, 0, '23/10/2009 18:59:07'),
(87, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 22, 0, '23/10/2009 18:59:35'),
(88, 'halert', 'cc', '', 22, 0, '23/10/2009 20:27:03'),
(89, 'Housekeeping', 'Espace authenticated from 127.0.0.1', 'login.php', 22, 0, '24/10/2009 00:41:56'),
(90, 'Housekeeping', 'Hotelfico authenticated from 127.0.0.1', 'login.php', 1, 0, '25/10/2009 00:45:13'),
(91, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '25/10/2009 00:46:28'),
(92, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '25/10/2009 00:49:01'),
(93, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 1, 0, '25/10/2009 00:52:15'),
(94, 'Housekeeping', 'Espace authenticated from 127.0.0.1', 'login.php', 22, 0, '25/10/2009 13:27:43'),
(95, 'Housekeeping', 'Updated CMS Settings (Loader Configuration)', 'loader.php', 22, 0, '25/10/2009 13:28:06');

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

--
-- Structure de la table `system_strings`
--

CREATE TABLE IF NOT EXISTS `system_strings` (
  `id` int(5) NOT NULL auto_increment,
  `stringid` varchar(100) collate latin1_general_ci NOT NULL default 'null',
  `var_en` text collate latin1_general_ci,
  `var_de` text collate latin1_general_ci,
  `var_nl` text collate latin1_general_ci,
  PRIMARY KEY  (`id`,`stringid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=49 ;

--
-- Contenu de la table `system_strings`
--

INSERT INTO `system_strings` (`id`, `stringid`, `var_en`, `var_de`, `var_nl`) VALUES
(1, 'console_onhotelview', 'Vue aérienne', 'auf Hotelansicht', 'In hoteloverzicht'),
(2, 'modtool_accesserror', 'Tu n''a pas acces a cette tool.', NULL, ''),
(3, 'modtool_actionfail', 'Commande échouée!', NULL, 'Command mislukt'),
(4, 'modtool_rankerror', 'Tu n''a pas les droits nesséssaires pour faire ceçi sur cette utilisateur.', NULL, 'You do not have the rights for this action on this user!'),
(5, 'modtool_usernotfound', 'L''utilisateur n''existe pas...', NULL, 'Probably the user is offline or does not exist.'),
(6, 'room_rightsreset', 'Le propriétaire à redémarrer tout les droits de l''appart. Merci de revenir dans l''appart.', NULL, 'The roomowner has reset all the roomrights.<br>Please re-enter the room.'),
(7, 'trading_disabled', 'Désolé, le troc est désactivé', NULL, 'Sorry, de hotel staff heeft ruilen uitgezet'),
(8, 'trading_nottradeable', 'Désolé , tu ne peux pas echanger ce mobi', NULL, 'Sorry, je kan dit niet ruilen'),
(9, 'welcomemessage_text', 'Bienvenue sur Habbo Weeks!', NULL, 'Koop nog geen landscape (error) (console werkt buggy) KIjk op het nieuws voor de album'),
(10, 'console_inpublicroom', 'In Public Room', NULL, 'In openbare ruimte'),
(11, 'room_stafflocked', 'Désolé, seuls les staffs sont autorisés a rentré ici.', NULL, 'Sorry, but only Staff is allowed to enter this room.'),
(12, 'room_full', 'Désolé, tu ne peux pas accedez a ce lieu complet.\r\n\r\nDevient VIP Pour rentré dans les lieux complets!', NULL, 'Sorry, but this publicroom is full.'),
(13, 'room_infobus_closed', 'L''infobus est fermé pour le moment.', NULL, 'Sorry, but the Infobus is closed at the moment.'),
(14, 'scommand_hotelalert', 'Messages des staffs:', NULL, 'Bericht van het beheer van het Hotel:'),
(15, 'scommand_failed', 'Commande non reussie. Merci de verifier si cet commande existe ou si l''utilisateur affecter existe ou n''est pas hors ligne.', NULL, 'Unable to process speech command.\r\nCheck your parameters and/or make sure that the target user is in room. (if any)'),
(16, 'scommand_success', 'Commande éffectuée avec succes!', NULL, 'Verwerkte het bevel van de toespraak, uitgevoerde actie.'),
(17, 'scommand_muted', 'Tu ne peux plus parler pour la raison suivante:', '', 'U bent gedempt om de volgende reden:'),
(18, 'scommand_unmuted', 'Tu peux de nouveau parler.', '', 'U bent unmuted geweest.'),
(19, 'scommand_rankalert', 'Message d''un staff a ses collegue:', NULL, 'Bericht van een staffmember met zelfde rang:'),
(20, 'banreport_header', 'Ban pour', NULL, 'Ban rapport voor'),
(21, 'common_userrank', 'Rank', NULL, 'Rang'),
(22, 'common_ip', 'IP', NULL, 'Ip adres'),
(23, 'banreport_banner', 'Banni par', NULL, 'Verbannen bij'),
(24, 'banreport_posted', 'Date du ban', NULL, 'Datum van ban lengte'),
(25, 'banreport_expires', 'Date d''expiration', NULL, 'De datum van verbod verloopt'),
(29, 'banreport_affectedusernames', 'Personnes affectés par ce ban', NULL, 'Deze mensen zijn ook verbannen'),
(26, 'banreport_reason', 'Raison', NULL, 'Reden'),
(27, 'banreport_ipbanflag', 'IP non bannie', NULL, 'IP ban applied'),
(28, 'banreport_staffnote', 'Note du staff', NULL, 'Staff bericht van banner'),
(29, 'userinfo_header', 'Virtual user information', NULL, 'Gebruiksinfomatie'),
(30, 'userinfo_accesserror', 'Sorry, but you haven''t got access to this user''s details.\r\n- It can be possible that the user doesn''t exist\r\n- It can be possible that the user has got a higher rank than you', NULL, 'Sorry, but you haven''t got access to this user''s details.\r\n- It can be possible that the user doesn''t exist\r\n- It can be possible that the user has got a higher rank than you'),
(31, 'common_usernotfound', 'L''utente non esiste', NULL, 'Deze gebruiker is niet gevonden'),
(32, 'common_userid', 'User ID', NULL, 'GebruikersID'),
(33, 'common_username', 'Username', NULL, 'Gebruikersnaam'),
(34, 'common_usermission', 'Missione', NULL, 'Missie'),
(35, 'common_email', 'Indirizzo Email', NULL, 'Emailadres'),
(36, 'common_credits', 'Credits', NULL, 'Credits'),
(37, 'common_tickets', 'Biglietti', NULL, 'Tickets'),
(38, 'common_birth', 'Data di compleanno', NULL, 'Geboortedatum'),
(39, 'common_hbirth', 'Registered at', NULL, 'Registeerd bij'),
(40, 'common_online', 'Online', NULL, 'Online'),
(41, 'common_yes', 'Si', NULL, 'Ja'),
(42, 'common_no', 'No', NULL, 'Nee'),
(43, 'common_location', 'Location', NULL, 'Locatie'),
(44, 'common_owner', 'Owner', NULL, 'Eigenaar'),
(45, 'common_room', 'Room', NULL, 'Kamer'),
(46, 'common_hotelview', 'Hotel View', NULL, 'Hotel overzicht'),
(47, 'common_lastaccess', 'Ultimo Accesso', NULL, 'Laaste inlog'),
(48, 'cfh_picked_up', 'Picked up', NULL, 'Opgepakt');

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

--
-- Structure de la table `userlock`
--

CREATE TABLE IF NOT EXISTS `userlock` (
  `ipaddress` varchar(20) NOT NULL,
  `regcount` tinyint(5) default NULL,
  PRIMARY KEY  (`ipaddress`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `users_badges`
--

CREATE TABLE IF NOT EXISTS `users_badges` (
  `userid` int(15) NOT NULL,
  `badgeid` varchar(20) collate latin1_general_ci NOT NULL default '',
  `iscurrent` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  `slotid` varchar(255) collate latin1_general_ci NOT NULL default '0',
  `badge` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`userid`,`badgeid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `users_badges`
--

INSERT INTO `users_badges` (`userid`, `badgeid`, `iscurrent`, `slotid`, `badge`) VALUES
(1, 'HC1', '1', '0', NULL),
(1, 'ADM', '1', '1', 'ADM'),
(1, 'HC2', '1', '2', 'HC2'),
(1, 'HC3', '1', '3', 'HC3'),
(1, 'HC4', '1', '4', 'HC4'),
(1, 'HC5', '1', '5', 'HC5'),
(5, 'HC1', '1', '0', NULL),
(8, 'HC1', '1', '0', NULL),
(5, 'HC2', '1', '0', 'HC2'),
(10, 'HC1', '1', '0', NULL),
(11, 'HC1', '1', '0', NULL),
(14, 'HC1', '1', '0', NULL),
(15, 'HC1', '1', '0', NULL),
(16, 'HC1', '1', '0', NULL),
(12, 'HC1', '1', '0', NULL),
(19, 'HC1', '1', '0', NULL),
(21, 'HC1', '1', '0', NULL),
(22, 'HC1', '1', '1', NULL),
(24, 'HC1', '1', '0', NULL),
(18, 'HC1', '1', '0', NULL),
(29, 'HC1', '1', '0', NULL),
(20, 'HC1', '1', '0', NULL),
(28, 'HC1', '1', '0', NULL),
(35, 'HC1', '1', '1', NULL),
(22, '', '0', '0', NULL),
(22, 'ACH_RoomEntry2', '1', '2', NULL);

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

--
-- Structure de la table `users_badgescur`
--

CREATE TABLE IF NOT EXISTS `users_badgescur` (
  `userid` int(15) NOT NULL,
  `badge1` varchar(5) character set latin1 collate latin1_general_ci NOT NULL,
  `badge2` varchar(5) character set latin1 collate latin1_general_ci NOT NULL,
  `badge3` varchar(5) character set latin1 collate latin1_general_ci NOT NULL,
  `badge4` varchar(5) character set latin1 collate latin1_general_ci NOT NULL,
  `badge5` varchar(5) character set latin1 collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `users_badgescur`
--

INSERT INTO `users_badgescur` (`userid`, `badge1`, `badge2`, `badge3`, `badge4`, `badge5`) VALUES
(1, 'HC1', 'HC2', 'HC3', 'HC4', 'HC5'),
(2, '', '', '', '', '');

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

--
-- Structure de la table `users_bans`
--

CREATE TABLE IF NOT EXISTS `users_bans` (
  `userid` varchar(30) collate latin1_general_ci NOT NULL default '',
  `ipaddress` varchar(100) collate latin1_general_ci default NULL,
  `date_expire` varchar(50) collate latin1_general_ci default NULL,
  `descr` text collate latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `users_bans`
--


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

--
-- Structure de la table `users_club`
--

CREATE TABLE IF NOT EXISTS `users_club` (
  `userid` bigint(6) NOT NULL,
  `months_expired` int(4) default NULL,
  `months_left` int(4) default NULL,
  `date_monthstarted` varchar(25) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `users_club`
--

INSERT INTO `users_club` (`userid`, `months_expired`, `months_left`, `date_monthstarted`) VALUES
(5, 0, 6, '01-03-2009'),
(8, 0, 6, '01-03-2009'),
(10, 0, 6, '02-03-2009'),
(11, 0, 1, '02-03-2009'),
(14, 0, 6, '02-03-2009'),
(15, 0, 1, '02-03-2009'),
(16, 0, 1, '02-03-2009'),
(12, 0, 6, '02-03-2009'),
(19, 0, 6, '02-03-2009'),
(21, 0, 6, '02-03-2009'),
(24, 0, 3, '02-03-2009'),
(18, 0, 1, '02-03-2009'),
(29, 0, 1, '02-03-2009'),
(20, 0, 1, '02-03-2009'),
(28, 0, 1, '02-03-2009'),
(35, 0, 6, '05-03-2009');

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

--
-- Structure de la table `users_favouriterooms`
--

CREATE TABLE IF NOT EXISTS `users_favouriterooms` (
  `userid` int(10) NOT NULL,
  `roomid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `users_favouriterooms`
--


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

--
-- Structure de la table `users_favourites`
--

CREATE TABLE IF NOT EXISTS `users_favourites` (
  `userid` int(10) NOT NULL,
  `roomid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `users_favourites`
--

INSERT INTO `users_favourites` (`userid`, `roomid`) VALUES
(1, 169);

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

--
-- Structure de la table `users_fuserights`
--

CREATE TABLE IF NOT EXISTS `users_fuserights` (
  `userid` int(15) NOT NULL,
  `fuseright` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `users_fuserights`
--


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

--
-- Structure de la table `users_recycler`
--

CREATE TABLE IF NOT EXISTS `users_recycler` (
  `userid` int(10) NOT NULL,
  `session_started` varchar(100) collate latin1_general_ci NOT NULL,
  `session_reward` int(10) NOT NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `users_recycler`
--


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

--
-- Structure de la table `user_ignores`
--

CREATE TABLE IF NOT EXISTS `user_ignores` (
  `userid` int(10) NOT NULL,
  `targetid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `user_ignores`
--


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

--
-- Structure de la table `vouchers`
--

CREATE TABLE IF NOT EXISTS `vouchers` (
  `voucher` varchar(20) collate latin1_general_ci NOT NULL,
  `type` enum('item','credits') collate latin1_general_ci NOT NULL default 'credits',
  `credits` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`voucher`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `vouchers`
--


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

--
-- Structure de la table `wordfilter`
--

CREATE TABLE IF NOT EXISTS `wordfilter` (
  `word` varchar(100) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `wordfilter`
--

INSERT INTO `wordfilter` (`word`) VALUES
('bocchino'),
('cazzo'),
('ciuccia'),
('coglione'),
('dio'),
('fanculo'),
('figa'),
('forum'),
('frocio'),
('gay'),
('habbo'),
('hotmail'),
('http'),
('madonna'),
('merda'),
('mignotta'),
('msn'),
('pompino'),
('puttana'),
('script'),
('suca'),
('troia'),
('vaffanculo');
