[R63B][HELP] Public Rooms

[MrWaterfield]

Hi There, i followed @Nippy 's R63B tutorial and was wondering if anyone could help me with getting public rooms to work.

Regards,
MrWaterfield

 

[Wickd]

Open up your database and search for navigator_publicsand and fill it in.

 

[MrWaterfield]

can you give me sql?

 

[Wickd]

can you give me sql?

Alright just run these two queries

INSERT INTO `rooms` VALUES ('20', 'public', 'Netcafe', '', 'If you are a nerd or a geek then this is your place to be!', '0', 'open', '0', '50', 'netcafe', 'hh_room_netcafe', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('21', 'public', 'Star Lounge', '', 'Where all the stars meet!', '0', 'open', '0', '50', 'star_lounge', 'hh_room_starlounge', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('33', 'public', 'The Pub', '', 'Its very dark and dusy down here, but you can enjoy a few drinks with some pals!', '0', 'open', '0', '50', 'pub_a', 'hh_room_pub', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('32', 'public', 'Pizza', '', 'The best pizza in town!', '0', 'open', '0', '50', 'pizza', 'hh_room_pizza', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('30', 'public', 'Rooftop', '', 'Make sure you bring your sun lotion!', '0', 'open', '0', '50', 'rooftop', 'hh_room_rooftop', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('31', 'public', 'Park', '', 'A peaceful place to rest', '0', 'open', '0', '50', 'park_a', 'hh_room_park', '0', '', '1', '0', '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('13', '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', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('14', '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', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('15', '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', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('16', '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', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('17', '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', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('18', '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', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');
INSERT INTO `rooms` VALUES ('19', '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', '0', '0', '0', '0', '0', '0', '0', '0', '14', '0');

And the second one

NSERT INTO `navigator_publics` VALUES ('31', '9', '0', 'Park', '', 'officialrooms_defaults/hh_room_park.png', 'internal', '31', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('30', '10', '0', 'Rooftop', '', 'officialrooms_defaults/hh_room_rooftop.png', 'internal', '30', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('33', '12', '0', 'The Pub', '', 'officialrooms_defaults/hh_room_pub.png', 'internal', '33', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('21', '13', '0', 'Star Lounge', '', 'officialrooms_defaults/hh_room_starlounge.png', 'internal', '21', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('20', '14', '0', 'Netcafe', '', 'officialrooms_defaults/hh_room_netcafe.png', 'internal', '20', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('1', '1', '0', 'Hotel Reception', '', 'officialrooms_defaults/hh_room_nlobby.png', 'internal', '13', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('2', '3', '0', 'Theater', '', 'officialrooms_defaults/hh_room_theater.png', 'internal', '14', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('3', '8', '0', 'The Orient', '', 'officialrooms_defaults/hh_room_orient.png', 'internal', '15', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('4', '6', '0', 'Picnic Area', '', 'officialrooms_defaults/hh_room_picnic.png', 'internal', '16', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('32', '11', '0', 'Pizza', '', 'officialrooms_defaults/hh_room_pizza.png', 'internal', '32', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('5', '5', '0', 'Tea Room', '', 'officialrooms_defaults/hh_room_tearoom.png', 'internal', '17', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('6', '7', '0', 'Dusty Lounge', '', 'officialrooms_defaults/hh_room_dustylounge.png', 'internal', '18', '0', '-1', '1', '1', '1', '');
INSERT INTO `navigator_publics` VALUES ('7', '4', '0', 'Uber Cinema', '', 'officialrooms_defaults/hh_room_cinema.png', 'internal', '19', '0', '-1', '1', '1', '1', '');

 

[MrWaterfield]

That worked just now the images for rooms don't load and when you click on them it says loading.. and stays like it. o have the images in c_images double checked.