[ADDON] Public Rooms and Categories

**tidesj** · 11-11-08

Originally Posted by ladot1001

its gowing rong to my.

MySQL retourneerde: Documentatie
#1054 - Unknown column 'NUL' in 'field list'

Change 'NUL' to 'NULL' and it will work ^^

**iLost.** · 12-11-08

I get an error when i upload it!

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MySQL retourneerde: Documentatie
INSERT INTO `rooms` (`id`, `name`, `descriptio' at line 1

I paste this into my localhost.. and do i need to delete the room_modeldata and those things?

PHP Code:


MySQL retourneerde: Documentatie

#1054 - Unknown column 'NULL' in 'field list'



INSERT INTO `rooms` (`id`, `name`, `description`, `owner`, `category`, `model`, `ccts`, `floor`, `wallpaper`, `state`, `password`, `showname`, `superusers`, `visitors_now`, `visitors_max`) VALUES

(101, 'Welcome Lounge 1', 'welcome_lounge', NULL, 5, 'newbie_lobby', 'hh_room_nlobby', 0, 0, 0, NULL, '1', '0', 0, 35),

(103, 'Theatredrome', 'theatredrome', NULL, 7, 'theater', 'hh_room_theater', 0, 0, 0, NULL, '1', '0', 0, 40),

(102, 'Lido I', 'habbo_lido', NULL, 14, 'pool_a', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),

(117, 'The Library of Dreams', 'library', NULL, 10, 'library', 'hh_room_library', 0, 0, 0, NULL, '1', '0', 0, 20),

(105, 'Sunset Cafe', 'sunset_cafe', NULL, 9, 'sunset_cafe', 'hh_room_sunsetcafe', 0, 0, 0, NULL, '1', '0', 0, 25),

(107, 'Lido II', 'habbo_lido_ii', NULL, 14, 'pool_b', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),

(106, 'Dirty Duck Pub', 'the_dirty_duck_pub', NULL, 11, 'pub_a', 'hh_room_pub', 0, 0, 0, NULL, '1', '0', 0, 35),

(108, 'Great Port of Dreams', 'floatinggarden', NULL, 8, 'floatinggarden', 'hh_room_floatinggarden', 0, 0, 0, NULL, '1', '0', 0, 30),

(109, 'Rooftop Rumble Pool I', 'rooftop_rumble', NULL, 15, 'md_a', 'hh_room_terrace,hh_paalu,hh_people_pool,hh_people_paalu', 0, 0, 0, NULL, '1', '0', 0, 25),

(124, 'Dusty Lounge', 'dusty_lounge', NULL, 9, 'dusty_lounge', 'hh_room_dustylounge', 0, 0, 0, NULL, '1', '0', 0, 25),

(120, 'Infobus Park', 'park', NULL, 8, 'park_a', 'hh_room_park_uk,hh_room_park', 0, 0, 0, NULL, '1', '0', 0, 30),

(112, 'The Infobus', 'park', null, 8, 'park_b', 'hh_room_park_general,hh_room_park', 0, 0, 0, null, '1', '0', 0, 15),

(122, 'Sakura Square', 'gate', NULL, 8, 'gate_park', 'hh_room_gate_park', 0, 0, 0, NULL, '1', '0', 0, 25),

(113, 'Welcome Lounge 2', 'welcome_lounge', NULL, 5, 'newbie_lobby', 'hh_room_nlobby', 0, 0, 0, NULL, '1', '0', 0, 35),

(114, 'Olympic Stadium', 'ballroom', NULL, 10, 'ballroom', 'hh_room_ballroom', 0, 0, 0, NULL, '1', '0', 0, 35),

(115, 'The Dudesons Picnic Area', 'picnic_dudesons', NULL, 8, 'picnic', 'hh_room_picnic_dudesons', 0, 0, 0, NULL, '1', '0', 0, 25),

(110, 'Picnic Fields', 'picnic', NUL, 5, 'picnic', 'hh_room_picnic', 0, 0, 0, NULL, '1', '0', 0, 25),

(116, 'Space Cafe', 'space_cafe', NULL, 9, 'space_cafe', 'hh_room_space_cafe', 0, 0, 0, NULL, '1', '0', 0, 25),

(118, 'The Beauty Salon', 'beauty_salon_general', NULL, 10, 'beauty_salon0', 'hh_room_beauty_salon_general', 0, 0, 0, NULL, '1', '0', 0, 25),

(119, 'Sun Terrace', 'sun_terrace', NULL, 8, 'sun_terrace', 'hh_room_sun_terrace', 0, 0, 0, NULL, '1', '0', 0, 25),

(121, 'Zen Garden', 'chill/0', NULL, 8, 'chill', 'hh_room_chill', 0, 0, 0, NULL, '1', '0', 0, 25),

(123, 'Rooftop Rumble Pool II', 'rooftop_rumble2', NULL, 15, 'md_a', 'hh_room_terrace,hh_paalu,hh_people_pool,hh_people_paalu', 0, 0, 0, NULL, '1', '0', 0, 25),

(125, 'The Den', 'the_den', NULL, 9, 'cr_staff', 'hh_room_den', 0, 0, 0, NULL, '1', '0', 0, 25),

(126, 'Halloween Theatredrome', 'theatredrome_halloween', NULL, 7, 'theater', 'hh_room_theater_halloween', 0, 0, 0, '4', '1', '0', 0, 25),

(127, 'Axe Theatredrome', 'theatre_axe', NULL, 7, 'theater', 'hh_room_theater_axe', 0, 0, 0, NULL, '1', '0', 0, 25),

(128, 'Deli Theatredrome', 'theatredeli', NULL, 7, 'theater', 'hh_room_theater_deli', 0, 0, 0, NULL, '1', '0', 0, 25),

(129, 'Easter Theatredrome', 'theatredrome_easter', NULL, 7, 'theater', 'hh_room_theater_easter', 0, 0, 0, NULL, '1', '0', 0, 25),

(131, 'Nouvelle Theatredrome', 'theatrenouvelle', NULL, 7, 'theater', 'hh_room_theater_nouvelle', 0, 0, 0, NULL, '1', '0', 0, 25),

(130, 'Habbowood Theatredrome', 'theatredrome_hbwood', NULL, 7, 'theater', 'hh_room_theater_hbowood', 0, 0, 0, NULL, '1', '0', 0, 25),

(134, 'Christmas Theatredrome', 'theatrexmas', NULL, 7, 'theater', 'hh_room_theater_xmas', 0, 0, 0, NULL, '1', '0', 0, 25),

(132, 'Samsung Theatredrome', 'theatresamsung', NULL, 7, 'theater', 'hh_room_theater_samsung', 0, 0, 0, NULL, '1', '0', 0, 25),

(133, 'Valentine Theatredrome', 'theatrevalentine', NULL, 7, 'theater', 'hh_room_theater_valentine', 0, 0, 0, NULL, '1', '0', 0, 25),

(135, 'Rooftop Cafe - Bottom', 'rooftop', NULL, 9, 'rooftop', 'hh_room_rooftop', 0, 0, 0, NULL, '1', '0', 0, 40),

(216, 'Tour De La Terreur', 'library', NULL, 10, 'library', 'hh_room_library_twr_trr', 0, 0, 0, 'NULL', '1', '0', 0, 20),

(137, 'Tea Rooms', 'tearoom', NULL, 9, 'tearoom', 'hh_room_tearoom', 0, 0, 0, NULL, '1', '0', 0, 25),

(136, 'Rooftop Cafe - Top', 'rooftop_2', NULL, 9, 'rooftop_2', 'hh_room_rooftop', 0, 0, 0, NULL, '1', '0', 0, 25),

(138, 'Cafe Ole', 'cafe_ole', NULL, 9, 'taivas_cafe', 'hh_room_cafe', 0, 0, 0, NULL, '1', '0', 0, 25),

(139, 'Gallery Cafe', 'ericseaterie', NULL, 9, 'cr_cafe', 'hh_room_erics', 0, 0, 0, NULL, '1', '0', 0, 25),

(140, 'Main Lobby', 'mainlobby', NULL, 16, 'lobby_a', 'hh_room_lobby', 0, 0, 0, NULL, '1', '0', 0, 25),

(141, 'Sky Lobby', 'skylobby', NULL, 16, 'floorlobby_c', 'hh_room_floorlobbies', 0, 0, 0, NULL, '1', '0', 0, 25),

(142, 'Lido I (Calippo)', 'habbo_lido', NULL, 14, 'pool_a', 'hh_room_pool_calippo,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),

(143, 'Lido II (Calippo)', 'habbo_lido_ii', NULL, 14, 'pool_b', 'hh_room_pool_calippo,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),

(149, 'Old Skool', 'oldskool', NULL, 10, 'old_skool0', 'hh_room_old_skool', 0, 0, 0, NULL, '1', '0', 0, 25),

(144, 'Median Lobby', 'medianlobby', NULL, 16, 'floorlobby_b', 'hh_room_floorlobbies', 0, 0, 0, NULL, '1', '0', 0, 25),

(145, 'Basement Lobby', 'basementlobby', NULL, 16, 'floorlobby_a', 'hh_room_floorlobbies', 0, 0, 0, NULL, '1', '0', 0, 25),

(147, 'Habbo Cinema', 'habbocinema', NULL, 10, 'cinema_a', 'hh_room_cinema', 0, 0, 0, NULL, '1', '0', 0, 25),

(148, 'Gym', 'sport', NULL, 10, 'sport', 'hh_room_sport', 0, 0, 0, NULL, '1', '0', 0, 25),

(151, 'Chromz Nightclub', 'chromz', NULL, 11, 'malja_bar_a', 'hh_room_disco', 0, 0, 0, NULL, '1', '0', 0, 25),

(150, 'Old Skool - Room 2', 'oldskool', NULL, 10, 'old_skool1', 'hh_room_old_skool', 0, 0, 0, NULL, '1', '0', 0, 25),

(154, 'Dance Floor', 'clubmassiva2', NULL, 19, 'bar_b', 'hh_room_bar', 0, 0, 0, NULL, '1', '0', 0, 25),

(152, 'Chromz Nightclub - Room 2', 'chromz', NULL, 11, 'malja_bar_b', 'hh_room_disco', 0, 0, 0, NULL, '1', '0', 0, 25),

(153, 'Chill Out Room', 'clubmassiva', NULL, 19, 'bar_a', 'hh_room_bar', 0, 0, 0, NULL, '1', '0', 0, 25),

(156, 'Habburgers (Burger King)', 'habburger', NULL, 12, 'habburger', 'hh_room_habburger_king', 0, 0, 0, NULL, '1', '0', 0, 25),

(155, 'Habburgers', 'habburger', NULL, 12, 'habburger', 'hh_room_habburger', 0, 0, 0, NULL, '1', '0', 0, 25),

(157, 'Chill Out Room (Postbank)', 'clubmassiva', NULL, 19, 'bar_a', 'hh_room_bar_postbank', 0, 0, 0, NULL, '1', '0', 0, 25),

(158, 'Dance Floor (Postbank)', 'clubmassiva2', NULL, 19, 'bar_b', 'hh_room_bar_postbank', 0, 0, 0, NULL, '1', '0', 0, 25),

(159, 'Slice Of Life', 'pizza', NULL, 12, 'pizza', 'hh_room_pizza', 0, 0, 0, NULL, '1', '0', 0, 25),

(208, 'Beginner Battleball', 'bb_lobby_beginner_0', NULL, 21, 'bb_lobby_1', 'hh_game_bb,hh_game_bb_room,hh_game_bb_ui,hh_gamesys', 0, 0, 0, 'null', '1', '0', 0, 20),

(209, 'Amateur Battleball', 'bb_lobby_amateur_0', NULL, 21, 'bb_lobby_1', 'hh_game_bb,hh_game_bb_room,hh_game_bb_ui,hh_gamesys', 0, 0, 0, 'null', '1', '0', 0, 20),

(210, 'Intermediate Battleball', 'bb_lobby_intermediate_0', NULL, 21, 'bb_lobby_1', 'hh_game_bb,hh_game_bb_room,hh_game_bb_ui,hh_gamesys', 0, 0, 0, NULL, '1', '0', 0, 25),

(211, 'Expert Battleball', 'bb_lobby_expert_0', NULL, 21, 'bb_lobby_1', 'hh_game_bb,hh_game_bb_room,hh_game_bb_ui,hh_gamesys', 0, 0, 0, NULL, '1', '0', 0, 25),

(212, 'Beginner Snowstorm', 'sw_lobby_beginner_0', NULL, 22, 'snowwar_lobby_1', 'hh_gamesys,hh_game_snowwar,hh_game_snowwar_room,hh_game_snowwar_ui', 0, 0, 0, NULL, '1', '0', 0, 25),

(213, 'Amateur Snowstorm', 'sw_lobby_amateur_0', NULL, 22, 'snowwar_lobby_1', 'hh_gamesys,hh_game_snowwar,hh_game_snowwar_room,hh_game_snowwar_ui', 0, 0, 0, NULL, '1', '0', 0, 25),

(214, 'Intermediate Snowstorm', 'sw_lobby_intermediate_0', NULL, 22, 'snowwar_lobby_1', 'hh_gamesys,hh_game_snowwar,hh_game_snowwar_room,hh_game_snowwar_ui', 0, 0, 0, NULL, '1', '0', 0, 25),

(215, 'Expert Snowstorm', 'sw_lobby_intermediate_0', NULL, 22, 'snowwar_lobby_1', 'hh_gamesys,hh_game_snowwar,hh_game_snowwar_room,hh_game_snowwar_ui', 0, 0, 0, NULL, '1', '0', 0, 25);

**kwabenathebest4** · 12-11-08

Thanks ricky I needed these cause I HATE the current rooms

**Bluntman** · 12-11-08

Cheers Ricky! Needed em!

**iLost.** · 15-11-08

OMFG! Why none help me?!

**Master-122-122** · 22-11-08

error Help me please

Fehler

SQL-Befehl:

INSERT INTO `rooms` (`id`, `name`, `description`, `owner`, `category`, `model`, `ccts`, `floor`, `wallpaper`, `state`, `password`, `showname`, `superusers`, `visitors_now`, `visitors_max`) VALUES (101, 'Welcome Lounge 1', 'welcome_lounge', NULL, 5, 'newbie_lobby', 'hh_room_nlobby', 0, 0, 0, NULL, '1', '0', 0, 35), (103, 'Theatredrome', 'theatredrome', NULL, 7, 'theater', 'hh_room_theater', 0, 0, 0, NULL, '1', '0', 0, 40), (102, 'Lido I', 'habbo_lido', NULL, 14, 'pool_a', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25), (117, 'The Library of Dreams', 'library', NULL, 10, 'library', 'hh_room_library', 0, 0, 0, NULL, '1', '0', 0, 20), (105, 'Sunset Cafe', 'sunset_cafe', NULL, 9, 'sunset_cafe', 'hh_room_sunsetcafe', 0, 0, 0, NULL, '1', '0', 0, 25), (107, 'Lido II', 'habbo_lido_ii', NULL, 14, 'pool_b', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25), (106, 'Dirty Duck Pub', 'the_dirty_duck_pub', NULL, 11, 'pub_a', 'hh_room_pub', 0, 0, 0, NULL, '1', '0', [...]

MySQL meldet: Dokumentation
#1054 - Unknown column 'NUL' in 'field list'

**Andrew** · 22-11-08

does this have working hc rooms?

**Lahmidi** · 22-11-08

Thanks

**ToTRipKiller** · 22-11-08

where should I file the CCT to do Please help me

**VeSa** · 22-11-08

Originally Posted by Master-122-122

error Help me please

Fehler

SQL-Befehl:

INSERT INTO `rooms` (`id`, `name`, `description`, `owner`, `category`, `model`, `ccts`, `floor`, `wallpaper`, `state`, `password`, `showname`, `superusers`, `visitors_now`, `visitors_max`) VALUES (101, 'Welcome Lounge 1', 'welcome_lounge', NULL, 5, 'newbie_lobby', 'hh_room_nlobby', 0, 0, 0, NULL, '1', '0', 0, 35), (103, 'Theatredrome', 'theatredrome', NULL, 7, 'theater', 'hh_room_theater', 0, 0, 0, NULL, '1', '0', 0, 40), (102, 'Lido I', 'habbo_lido', NULL, 14, 'pool_a', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25), (117, 'The Library of Dreams', 'library', NULL, 10, 'library', 'hh_room_library', 0, 0, 0, NULL, '1', '0', 0, 20), (105, 'Sunset Cafe', 'sunset_cafe', NULL, 9, 'sunset_cafe', 'hh_room_sunsetcafe', 0, 0, 0, NULL, '1', '0', 0, 25), (107, 'Lido II', 'habbo_lido_ii', NULL, 14, 'pool_b', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25), (106, 'Dirty Duck Pub', 'the_dirty_duck_pub', NULL, 11, 'pub_a', 'hh_room_pub', 0, 0, 0, NULL, '1', '0', [...]

MySQL meldet: Dokumentation
#1054 - Unknown column 'NUL' in 'field list'

maybe remove the old ones

**imadj** · 22-11-08

Fixxed Public Rooms:

Code:

INSERT INTO `rooms` (`id`, `name`, `description`, `owner`, `category`, `model`, `ccts`, `floor`, `wallpaper`, `state`, `password`, `showname`, `superusers`, `visitors_now`, `visitors_max`) VALUES
(101, 'Welcome Lounge 1', 'welcome_lounge', NULL, 5, 'newbie_lobby', 'hh_room_nlobby', 0, 0, 0, NULL, '1', '0', 0, 35),
(103, 'Theatredrome', 'theatredrome', NULL, 7, 'theater', 'hh_room_theater', 0, 0, 0, NULL, '1', '0', 0, 40),
(102, 'Lido I', 'habbo_lido', NULL, 14, 'pool_a', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),
(117, 'The Library of Dreams', 'library', NULL, 10, 'library', 'hh_room_library', 0, 0, 0, NULL, '1', '0', 0, 20),
(105, 'Sunset Cafe', 'sunset_cafe', NULL, 9, 'sunset_cafe', 'hh_room_sunsetcafe', 0, 0, 0, NULL, '1', '0', 0, 25),
(107, 'Lido II', 'habbo_lido_ii', NULL, 14, 'pool_b', 'hh_room_pool,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),
(106, 'Dirty Duck Pub', 'the_dirty_duck_pub', NULL, 11, 'pub_a', 'hh_room_pub', 0, 0, 0, NULL, '1', '0', 0, 35),
(108, 'Great Port of Dreams', 'floatinggarden', NULL, 8, 'floatinggarden', 'hh_room_floatinggarden', 0, 0, 0, NULL, '1', '0', 0, 30),
(109, 'Rooftop Rumble Pool I', 'rooftop_rumble', NULL, 15, 'md_a', 'hh_room_terrace,hh_paalu,hh_people_pool,hh_people_paalu', 0, 0, 0, NULL, '1', '0', 0, 25),
(124, 'Dusty Lounge', 'dusty_lounge', NULL, 9, 'dusty_lounge', 'hh_room_dustylounge', 0, 0, 0, NULL, '1', '0', 0, 25),
(120, 'Infobus Park', 'park', NULL, 8, 'park_a', 'hh_room_park_uk,hh_room_park', 0, 0, 0, NULL, '1', '0', 0, 30),
(112, 'The Infobus', 'park', null, 8, 'park_b', 'hh_room_park_general,hh_room_park', 0, 0, 0, null, '1', '0', 0, 15),
(122, 'Sakura Square', 'gate', NULL, 8, 'gate_park', 'hh_room_gate_park', 0, 0, 0, NULL, '1', '0', 0, 25),
(113, 'Welcome Lounge 2', 'welcome_lounge', NULL, 5, 'newbie_lobby', 'hh_room_nlobby', 0, 0, 0, NULL, '1', '0', 0, 35),
(114, 'Olympic Stadium', 'ballroom', NULL, 10, 'ballroom', 'hh_room_ballroom', 0, 0, 0, NULL, '1', '0', 0, 35),
(115, 'The Dudesons Picnic Area', 'picnic_dudesons', NULL, 8, 'picnic', 'hh_room_picnic_dudesons', 0, 0, 0, NULL, '1', '0', 0, 25),
(110, 'Picnic Fields', 'picnic', NULL, 5, 'picnic', 'hh_room_picnic', 0, 0, 0, NULL, '1', '0', 0, 25),
(116, 'Space Cafe', 'space_cafe', NULL, 9, 'space_cafe', 'hh_room_space_cafe', 0, 0, 0, NULL, '1', '0', 0, 25),
(118, 'The Beauty Salon', 'beauty_salon_general', NULL, 10, 'beauty_salon0', 'hh_room_beauty_salon_general', 0, 0, 0, NULL, '1', '0', 0, 25),
(119, 'Sun Terrace', 'sun_terrace', NULL, 8, 'sun_terrace', 'hh_room_sun_terrace', 0, 0, 0, NULL, '1', '0', 0, 25),
(121, 'Zen Garden', 'chill/0', NULL, 8, 'chill', 'hh_room_chill', 0, 0, 0, NULL, '1', '0', 0, 25),
(123, 'Rooftop Rumble Pool II', 'rooftop_rumble2', NULL, 15, 'md_a', 'hh_room_terrace,hh_paalu,hh_people_pool,hh_people_paalu', 0, 0, 0, NULL, '1', '0', 0, 25),
(125, 'The Den', 'the_den', NULL, 9, 'cr_staff', 'hh_room_den', 0, 0, 0, NULL, '1', '0', 0, 25),
(126, 'Halloween Theatredrome', 'theatredrome_halloween', NULL, 7, 'theater', 'hh_room_theater_halloween', 0, 0, 0, '4', '1', '0', 0, 25),
(127, 'Axe Theatredrome', 'theatre_axe', NULL, 7, 'theater', 'hh_room_theater_axe', 0, 0, 0, NULL, '1', '0', 0, 25),
(128, 'Deli Theatredrome', 'theatredeli', NULL, 7, 'theater', 'hh_room_theater_deli', 0, 0, 0, NULL, '1', '0', 0, 25),
(129, 'Easter Theatredrome', 'theatredrome_easter', NULL, 7, 'theater', 'hh_room_theater_easter', 0, 0, 0, NULL, '1', '0', 0, 25),
(131, 'Nouvelle Theatredrome', 'theatrenouvelle', NULL, 7, 'theater', 'hh_room_theater_nouvelle', 0, 0, 0, NULL, '1', '0', 0, 25),
(130, 'Habbowood Theatredrome', 'theatredrome_hbwood', NULL, 7, 'theater', 'hh_room_theater_hbowood', 0, 0, 0, NULL, '1', '0', 0, 25),
(134, 'Christmas Theatredrome', 'theatrexmas', NULL, 7, 'theater', 'hh_room_theater_xmas', 0, 0, 0, NULL, '1', '0', 0, 25),
(132, 'Samsung Theatredrome', 'theatresamsung', NULL, 7, 'theater', 'hh_room_theater_samsung', 0, 0, 0, NULL, '1', '0', 0, 25),
(133, 'Valentine Theatredrome', 'theatrevalentine', NULL, 7, 'theater', 'hh_room_theater_valentine', 0, 0, 0, NULL, '1', '0', 0, 25),
(135, 'Rooftop Cafe - Bottom', 'rooftop', NULL, 9, 'rooftop', 'hh_room_rooftop', 0, 0, 0, NULL, '1', '0', 0, 40),
(216, 'Tour De La Terreur', 'library', NULL, 10, 'library', 'hh_room_library_twr_trr', 0, 0, 0, 'NULL', '1', '0', 0, 20),
(137, 'Tea Rooms', 'tearoom', NULL, 9, 'tearoom', 'hh_room_tearoom', 0, 0, 0, NULL, '1', '0', 0, 25),
(136, 'Rooftop Cafe - Top', 'rooftop_2', NULL, 9, 'rooftop_2', 'hh_room_rooftop', 0, 0, 0, NULL, '1', '0', 0, 25),
(138, 'Cafe Ole', 'cafe_ole', NULL, 9, 'taivas_cafe', 'hh_room_cafe', 0, 0, 0, NULL, '1', '0', 0, 25),
(139, 'Gallery Cafe', 'ericseaterie', NULL, 9, 'cr_cafe', 'hh_room_erics', 0, 0, 0, NULL, '1', '0', 0, 25),
(140, 'Main Lobby', 'mainlobby', NULL, 16, 'lobby_a', 'hh_room_lobby', 0, 0, 0, NULL, '1', '0', 0, 25),
(141, 'Sky Lobby', 'skylobby', NULL, 16, 'floorlobby_c', 'hh_room_floorlobbies', 0, 0, 0, NULL, '1', '0', 0, 25),
(142, 'Lido I (Calippo)', 'habbo_lido', NULL, 14, 'pool_a', 'hh_room_pool_calippo,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),
(143, 'Lido II (Calippo)', 'habbo_lido_ii', NULL, 14, 'pool_b', 'hh_room_pool_calippo,hh_people_pool', 0, 0, 0, NULL, '1', '0', 0, 25),
(149, 'Old Skool', 'oldskool', NULL, 10, 'old_skool0', 'hh_room_old_skool', 0, 0, 0, NULL, '1', '0', 0, 25),
(144, 'Median Lobby', 'medianlobby', NULL, 16, 'floorlobby_b', 'hh_room_floorlobbies', 0, 0, 0, NULL, '1', '0', 0, 25),
(145, 'Basement Lobby', 'basementlobby', NULL, 16, 'floorlobby_a', 'hh_room_floorlobbies', 0, 0, 0, NULL, '1', '0', 0, 25),
(147, 'Habbo Cinema', 'habbocinema', NULL, 10, 'cinema_a', 'hh_room_cinema', 0, 0, 0, NULL, '1', '0', 0, 25),
(148, 'Gym', 'sport', NULL, 10, 'sport', 'hh_room_sport', 0, 0, 0, NULL, '1', '0', 0, 25),
(151, 'Chromz Nightclub', 'chromz', NULL, 11, 'malja_bar_a', 'hh_room_disco', 0, 0, 0, NULL, '1', '0', 0, 25),
(150, 'Old Skool - Room 2', 'oldskool', NULL, 10, 'old_skool1', 'hh_room_old_skool', 0, 0, 0, NULL, '1', '0', 0, 25),
(154, 'Dance Floor', 'clubmassiva2', NULL, 19, 'bar_b', 'hh_room_bar', 0, 0, 0, NULL, '1', '0', 0, 25),
(152, 'Chromz Nightclub - Room 2', 'chromz', NULL, 11, 'malja_bar_b', 'hh_room_disco', 0, 0, 0, NULL, '1', '0', 0, 25),
(153, 'Chill Out Room', 'clubmassiva', NULL, 19, 'bar_a', 'hh_room_bar', 0, 0, 0, NULL, '1', '0', 0, 25),
(156, 'Habburgers (Burger King)', 'habburger', NULL, 12, 'habburger', 'hh_room_habburger_king', 0, 0, 0, NULL, '1', '0', 0, 25),
(155, 'Habburgers', 'habburger', NULL, 12, 'habburger', 'hh_room_habburger', 0, 0, 0, NULL, '1', '0', 0, 25),
(157, 'Chill Out Room (Postbank)', 'clubmassiva', NULL, 19, 'bar_a', 'hh_room_bar_postbank', 0, 0, 0, NULL, '1', '0', 0, 25),
(158, 'Dance Floor (Postbank)', 'clubmassiva2', NULL, 19, 'bar_b', 'hh_room_bar_postbank', 0, 0, 0, NULL, '1', '0', 0, 25),
(159, 'Slice Of Life', 'pizza', NULL, 12, 'pizza', 'hh_room_pizza', 0, 0, 0, NULL, '1', '0', 0, 25),
(208, 'Beginner Battleball', 'bb_lobby_beginner_0', NULL, 21, 'bb_lobby_1', 'hh_game_bb,hh_game_bb_room,hh_game_bb_ui,hh_gamesys', 0, 0, 0, 'null', '1', '0', 0, 20),
(209, 'Amateur Battleball', 'bb_lobby_amateur_0', NULL, 21, 'bb_lobby_1', 'hh_game_bb,hh_game_bb_room,hh_game_bb_ui,hh_gamesys', 0, 0, 0, 'null', '1', '0', 0, 20),
(210, 'Intermediate Battleball', 'bb_lobby_intermediate_0', NULL, 21, 'bb_lobby_1', 'hh_game_bb,hh_game_bb_room,hh_game_bb_ui,hh_gamesys', 0, 0, 0, NULL, '1', '0', 0, 25),
(211, 'Expert Battleball', 'bb_lobby_expert_0', NULL, 21, 'bb_lobby_1', 'hh_game_bb,hh_game_bb_room,hh_game_bb_ui,hh_gamesys', 0, 0, 0, NULL, '1', '0', 0, 25),
(212, 'Beginner Snowstorm', 'sw_lobby_beginner_0', NULL, 22, 'snowwar_lobby_1', 'hh_gamesys,hh_game_snowwar,hh_game_snowwar_room,hh_game_snowwar_ui', 0, 0, 0, NULL, '1', '0', 0, 25),
(213, 'Amateur Snowstorm', 'sw_lobby_amateur_0', NULL, 22, 'snowwar_lobby_1', 'hh_gamesys,hh_game_snowwar,hh_game_snowwar_room,hh_game_snowwar_ui', 0, 0, 0, NULL, '1', '0', 0, 25),
(214, 'Intermediate Snowstorm', 'sw_lobby_intermediate_0', NULL, 22, 'snowwar_lobby_1', 'hh_gamesys,hh_game_snowwar,hh_game_snowwar_room,hh_game_snowwar_ui', 0, 0, 0, NULL, '1', '0', 0, 25),
(215, 'Expert Snowstorm', 'sw_lobby_intermediate_0', NULL, 22, 'snowwar_lobby_1', 'hh_gamesys,hh_game_snowwar,hh_game_snowwar_room,hh_game_snowwar_ui', 0, 0, 0, NULL, '1', '0', 0, 25);

**GolemdX** · 22-11-08

Thanks. Still had to do a bit of editing though.

**Retro!** · 23-11-08

thanks,
Nice release bro :)

**Alpha Ducky** · 06-12-08

no problem. glad yall like it ^-^

**Jakeyy** · 08-12-08

One of the most useful sql releases for holo. ;)

[ADDON] Public Rooms and Categories

Thread Tools

Administrative

Search Thread

Rate This Thread

Inline Mod

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

Re: [ADDON] Public Rooms and Categories

vBulletin Message

Errors

The following errors occurred with your submission

Quick Reply

Thread Information

Users Browsing this Thread