Beiträge von tomek793

DROP TABLE IF EXISTS `navigator_flatcats`;
CREATE TABLE `navigator_flatcats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`caption` varchar(100) NOT NULL,
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`min_rank` int(11) NOT NULL DEFAULT '1',
`cantrade` enum('0','1') NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;


INSERT INTO `navigator_flatcats` VALUES ('15', 'No Category', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('1', 'Phoenix Staff Rooms', '1', '4', '1');
INSERT INTO `navigator_flatcats` VALUES ('2', 'Competition Category', '0', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('3', 'unused competition category', '0', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('4', 'Themed & RPG Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('5', 'Restaurant, Bar & Night Club Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('6', 'Club & Group Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('7', 'Chat, Chill & Discussion Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('8', 'Maze & Theme Park Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('9', 'Trading & Shopping Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('10', 'Gaming & Race Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('11', 'Hair Salons & Modelling Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('12', 'Help Centre, Guide & Service Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('13', 'School, Daycare & Adoption Rooms', '1', '1', '1');
INSERT INTO `navigator_flatcats` VALUES ('14', 'All Other Rooms', '1', '1', '1');


DROP TABLE IF EXISTS `navigator_publics`;
CREATE TABLE `navigator_publics` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ordernum` int(11) NOT NULL DEFAULT '1',
`bannertype` enum('0','1') NOT NULL COMMENT '0 = big, 1 = normal',
`caption` varchar(100) NOT NULL,
`image` text NOT NULL,
`image_type` enum('internal','external') NOT NULL DEFAULT 'internal',
`room_id` int(10) unsigned NOT NULL,
`category` enum('0','1') NOT NULL DEFAULT '0',
`category_parent_id` int(11) NOT NULL DEFAULT '-1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;


INSERT INTO `navigator_publics` VALUES ('1', '1', '1', 'Hotel Reception', 'newbie_lobby', 'internal', '1', '0', '0');
INSERT INTO `navigator_publics` VALUES ('2', '3', '1', 'Theatredrome', 'theatredrome_xmas', 'internal', '2', '0', '0');
INSERT INTO `navigator_publics` VALUES ('3', '8', '1', 'The Orient', '', 'internal', '3', '0', '0');
INSERT INTO `navigator_publics` VALUES ('4', '6', '1', 'Picnic Area', 'picnic', 'internal', '4', '0', '0');
INSERT INTO `navigator_publics` VALUES ('5', '5', '1', 'Tea Room', 'tearoom', 'internal', '5', '0', '0');
INSERT INTO `navigator_publics` VALUES ('6', '7', '1', 'Dusty Lounge', 'dusty_lounge', 'internal', '6', '0', '0');
INSERT INTO `navigator_publics` VALUES ('7', '4', '1', 'Uber Cinema', 'habbo_cinema', 'internal', '7', '0', '0');


DROP TABLE IF EXISTS `rooms`;
CREATE TABLE `rooms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`roomtype` enum('public','private') NOT NULL DEFAULT 'private',
`caption` varchar(100) NOT NULL DEFAULT 'Room',
`owner` varchar(75) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`category` int(11) NOT NULL DEFAULT '0',
`state` enum('open','locked','password') NOT NULL DEFAULT 'open',
`users_now` int(11) NOT NULL DEFAULT '0',
`users_max` int(11) NOT NULL DEFAULT '25',
`model_name` varchar(50) NOT NULL,
`public_ccts` varchar(50) NOT NULL DEFAULT '',
`score` int(11) NOT NULL DEFAULT '0',
`tags` varchar(100) NOT NULL DEFAULT '',
`icon_bg` int(11) NOT NULL DEFAULT '1',
`icon_fg` int(11) NOT NULL DEFAULT '0',
`icon_items` varchar(50) NOT NULL DEFAULT '',
`password` varchar(30) NOT NULL DEFAULT '',
`wallpaper` varchar(10) NOT NULL DEFAULT '0.0',
`floor` varchar(10) NOT NULL DEFAULT '0.0',
`landscape` varchar(10) NOT NULL DEFAULT '0.0',
`allow_pets` enum('0','1') NOT NULL DEFAULT '1',
`allow_pets_eat` enum('0','1') NOT NULL DEFAULT '0',
`allow_walkthrough` enum('0','1') NOT NULL DEFAULT '0',
`allow_hidewall` enum('0','1') NOT NULL DEFAULT '0',
`wallthick` int(1) NOT NULL DEFAULT '0',
`floorthick` int(1) NOT NULL DEFAULT '0',
`achievement` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;


INSERT INTO `rooms` VALUES ('1', 'public', 'Welcome Lobby', '', 'Where we give you a warm welcome to the hotel!', '0', 'open', '0', '50', 'newbie_lobby', 'hh_room_nlobby', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `rooms` VALUES ('2', 'public', 'Theatredrome', '', 'For mass assemblies and gatherings.', '0', 'open', '0', '50', 'theater', 'hh_room_theater', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `rooms` VALUES ('3', 'public', 'Club Orient', '', 'Come and relax, dance under the lights or chill out with a cup of tea in this oriental styled club.', '0', 'open', '0', '30', 'orient', 'hh_room_orient', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `rooms` VALUES ('4', 'public', 'Picnic Area', '', 'Enjoy the ever-lasting summer sun with a fresh picnic, even in winter!', '0', 'open', '0', '50', 'picnic', 'hh_room_picnic', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `rooms` VALUES ('5', 'public', 'Tea Room', '', 'Have a relaxing cup of fruit, herbal or even everyday tea in this Chinese themed tea house.', '0', 'open', '0', '30', 'tearoom', 'hh_room_tearoom', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `rooms` VALUES ('6', 'public', 'Dusty Lounge', '', 'Origninally where the hotel air conditioning emptied its filters, this dusty, old void is now a beautifully decorated lounge!', '0', 'open', '0', '30', 'dusty_lounge', 'hh_room_dustylounge', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `rooms` VALUES ('7', 'public', 'Cinema', '', 'Watch or perform, the choice is yours!', '0', 'open', '0', '50', 'cinema_a', 'hh_room_cinema', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0');