[ADDON] Public Rooms and Categories

Alpha Ducky · Oct 30, 2008

These are the public room and room categories I'm using. ^_^ Have fun.

For some odd reason, I RaGEZONE would ***** out some numbers and commas.
So I gathered everything and added them to a file.

PLZ COPY AND PASTE THE SQL INTO PHPMYADMIN. DON'T IMPORT THEM.

DOWNLOAD:

To view the content, you need to sign in or register

Virus Scan:

Alpha Ducky - [ADDON] Public Rooms and Categories - RaGEZONE Forums

RUSH · Oct 30, 2008

Re: [REL] Public Rooms and Categories [REL]

Thanks alot i needed these!!

off topic: 1st post

Alpha Ducky · Oct 30, 2008

Re: [REL] Public Rooms and Categories [REL]

RUSH said:
Thanks alot i needed these!!

off topic: 1st post

^_^ glad I could help out.

Unk · Oct 30, 2008

Re: [REL] Public Rooms and Categories [REL]

Nice, this is helpful. Thanks.

Unk

yifan_lu · Oct 30, 2008

Re: [REL] Public Rooms and Categories [REL]

What about the room_modeldata?

Alpha Ducky · Oct 30, 2008

Re: [REL] Public Rooms and Categories [REL]

yifan_lu said:
What about the room_modeldata?

True

added to first post.

DJRemix123 · Oct 30, 2008

Re: [REL] Public Rooms and Categories [REL]

Thanks for this Ricky! Will be a great help for them people wanting like all catagories. and I think all pubs

BobbaLodge · Oct 30, 2008

Re: [REL] Public Rooms and Categories [REL]

Nice, But Most Of Them Will Not Work Without An DESC. From Your External Texts.

Alpha Ducky · Oct 30, 2008

Re: [REL] Public Rooms and Categories [REL]

-.- yes I do. descriptions needs to be fixed. Can't change them because my database got deleted be some jealous ass wipe. To bad they are to stupid to figure out I have a backup.

I'll fix the rooms later today. I got school.

Dragonkeepercom · Oct 30, 2008

Re: [REL] Public Rooms and Categories [REL]

You need the updated database for Vista4Life, but that reconfigured database is really screwed up. I completely messed up my database

allard100 · Nov 1, 2008

Re: [REL] Public Rooms and Categories [REL]

And have the rooms lagg??

iLost. · Nov 9, 2008

Re: [REL] Public Rooms and Categories [REL]

Hey, i need help. Look, i copy the codes in to a .sql file. When im gonna upload it to localhost i got this error:

PHP:

 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 ('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\rxxxxxxx[...]

MySQL Said:
#1062 - Duplicate entry 'a' for key 1

Whats wrong?

werpo · Nov 9, 2008

Re: [REL] Public Rooms and Categories [REL]

Code:

requ

Purru · Nov 9, 2008

good aport. A lot of people need this

ladot1001 · Nov 10, 2008

its gowing rong to my.

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

tidesj · Nov 10, 2008

ladot1001 said:
its gowing rong to my.

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

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

iLost. · Nov 11, 2008

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:

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 · Nov 11, 2008

Thanks ricky I needed these cause I HATE the current rooms

Bluntman · Nov 11, 2008

Cheers Ricky! Needed em!

iLost. · Nov 15, 2008

OMFG! Why none help me?!

[ADDON] Public Rooms and Categories

8-bit Bitch Slapper

Newbie Spellweaver

8-bit Bitch Slapper

Skilled Illusionist

Skilled Illusionist

8-bit Bitch Slapper

Junior Spellweaver

Junior Spellweaver

8-bit Bitch Slapper

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Junior Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Newbie Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners