PlusR2 - Navigator Public Rooms

Hello,

I'm currently using the Plus R2 Emu and I'm trying to add Public Rooms.

I've entered the correct information into 'naviagator_publics' with the room_id, and when you enter the hotel the Navigator does display the button. However, when you click on it, it says 'Loading...." and doesn't go anywhere. No image comes up either, just shows the text.

Wondering if there is a fix for the Public Rooms/Featured Rooms for the Plus R2 Emu?

If you could help me out, that would be great!

Regards,
Disallows

Bumpp in hope for answers!

Go through the comments in Sir Jamal's post about the plus emu r2. There is a fix in there somewhere

Quote:

---

Originally Posted by Konquer

Go through the comments in Sir Jamal's post about the plus emu r2. There is a fix in there somewhere

---

Thank you. Just went through 40 pages and finally found it! Working well, too.

Appreciate the help!

No problem mate :D

Maybe posy the fix on here that you used just in case some others want to see how you fixed?

Quote:

---

Originally Posted by Kristophers

Maybe posy the fix on here that you used just in case some others want to see how you fixed?

---

People should read throught the post where fixes are posted first..

post the fix?

Quote:

---

Originally Posted by GrateZ4

post the fix?

---

It has to do with the Type number (1-4) in navigator_publics.

Quote:

---

Originally Posted by ProducerMark

It has to do with the Type number (1-4) in navigator_publics.

---

does this one work? cause for me i'm getting dc

Quote:

---

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,
`description` 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_id` int(11) NOT NULL DEFAULT '-1',
`category_parent_id` int(11) NOT NULL DEFAULT '-1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`recommended` enum('0','1') NOT NULL DEFAULT '0',
`typeofdata` int(255) NOT NULL DEFAULT '1',
`tag` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;


-- ----------------------------
-- Records of navigator_publics
-- ----------------------------
INSERT INTO `navigator_publics` VALUES ('1', '1', '1', 'Reception Lounge', 'Håll en trevlig pratstund? Eller kanske en trevlig pratstund med Frank!', 'officialrooms_defaults/hh_room_nlobby.png', 'internal', '1', '-1', '-1', '1', '1', '2', '0');

---

You will get an exception if you do not have at least 1 public room where it says recommended = 1

Quote:

---

Originally Posted by ProducerMark

You will get an exception if you do not have at least 1 public room where it says recommended = 1

---

If i add a public room run the sql and update_navigator and press hotel i get dc from the hotel but when i have nothing in navigator_publics and i click hotel it just get's white

When you get a dc, what does it say in your log files?

Quote:

---

Originally Posted by ProducerMark

When you get a dc, what does it say in your log files?

---

http://gyazo.com/33ad522912309d54178f2a4a43ac241d

Change typeofdata to 3 (= private room, cant check for the public room number until tomorrow), category_parent_id to 1 and make sure your room_id exists in the rooms table. (These values works for me)

Quote:

---

Originally Posted by GrateZ4

http://gyazo.com/33ad522912309d54178f2a4a43ac241d

---

What does publicitem.cs on line 138 say?

Quote:

---

Originally Posted by ProducerMark

Change typeofdata to 3 (= private room, cant check for the public room number until tomorrow), category_parent_id to 1 and make sure your room_id exists in the rooms table. (These values works for me)

---

Can't thank you enough, typeofdata should be 3, that was the prob!

Good to hear it worked ;)