Colocando espaços publicos em V50

por **DarkCode** Dom Mar 06, 2011 12:08 pm

Código:: -- -- Estrutura da tabela `rooms` CREATE TABLE IF NOT EXISTS `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` text NOT NULL, `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` text NOT NULL, `score` int(11) NOT NULL DEFAULT '0', `tags` text NOT NULL, `icon_bg` int(11) NOT NULL DEFAULT '1', `icon_fg` int(11) NOT NULL DEFAULT '0', `icon_items` text NOT NULL, `password` text NOT NULL, `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', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5554 ; -- -- Extraindo dados da tabela `rooms` -- INSERT INTO `rooms` (`id`, `roomtype`, `caption`, `owner`, `description`, `category`, `state`, `users_now`, `users_max`, `model_name`, `public_ccts`, `score`, `tags`, `icon_bg`, `icon_fg`, `icon_items`, `password`, `wallpaper`, `floor`, `landscape`, `allow_pets`, `allow_pets_eat`, `allow_walkthrough`) VALUES (1, 'public', 'Hotel Reception', '', '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'), (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'), (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'), (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'), (5, 'public', 'Tea Room', '', 'Have a relaxing cup of fruit, herbal or even everyday tea in this Chinese themed tea house.\r\n', 0, 'open', 0, 30, 'tearoom', 'hh_room_tearoom', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'), (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'), (8, 'public', 'Buttsechs Bus', '', 'Buttsechs on tour!', 0, 'open', 0, 50, 'park_b', 'hh_room_park_hpv,hh_room_park_hpv2', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'), (7, 'public', 'Heb Cinema', '', 'No escurinho do Cinema...', 0, 'open', 0, 50, 'cinema_a', 'hh_room_cinema', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;