Thanks John
This is a discussion on Puss in Boots Room within the Habbo Releases forums, part of the Habbo Hotel category; PHP Code: INSERT INTO ` navigator_publics ` (` id `, ` ordernum `, ` bannertype `, ` caption `, ` image `, ` image_type `, ` room_id `, ` ...

PHP Code:INSERT INTO `navigator_publics` (`id`, `ordernum`, `bannertype`, `caption`, `image`, `image_type`, `room_id`, `category_id`, `category_parent_id`) VALUES
(459802, 102, '0', 'Puss in Boots', 'navi/navigator_pib.gif', 'external', 459802, 0, -1);
PHP Code:INSERT INTO `items` (`id`, `user_id`, `room_id`, `base_item`, `extra_data`, `x`, `y`, `z`, `rot`, `wall_pos`) VALUES
(249702, USERID, 459802, 8263, 'imageUrl=http://hotel.zonhotel.net/r63/c_images/room_backgrounds/br_pib_01.png offsetX=-600 offsetY=600 offsetZ=9950 state=0', 1, 3, 0, 0, '');
PHP Code:INSERT INTO `room_models` (`id`, `door_x`, `door_y`, `door_z`, `door_dir`, `heightmap`, `public_items`, `club_only`) VALUES
('model_pib', 0, 14, 0, 2, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxxxxx\r\nx000000000000000000xxxxxxxxxx\r\nx000000000000000000xxxxxxxxxx\r\nx000000000000000000xxxxxxxxxx\r\nx000000000000000000xxxxxxxxxx\r\nx000000000000000000xxxxxxxxxx\r\nx000000000000000000xxxxxxxxxx\r\nx000000000000000000xxxxxxxxxx\r\nx000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', '', '1');
And dont forget images:PHP Code: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`, `allow_hidewall`, `wallthick`, `floorthick`, `achievement`) VALUES
(459802, 'private', 'Puss in Boots', 'John', '', 0, 'open', 1, 25, 'model_pib', '', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', 0, 0, 0);
http://images.habbo.com/c_images/DEV.../br_pib_01.png
and ill put up navigator image in a mo.
Once inserted room_model and room, do :update_navigator and :unload, then restart server.
Thanks John
Another great release i will add this when i get back home. Thanks! +1
Can't find items why?
I don't know i haven't items in my db... can you give me it? "the sql for items"
you dont have items?
No I've got a german CMS&EMU (The Retro in desc.)
You would have items on a database.
What emulator?
Is it me, or are the Coords incorrect, ROFL!