Puss in Boots Room

[Spheral]

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);

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, '');

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');

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);

And dont forget images:

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

and ill put up navigator image in a mo.

Once inserted room_model and room, do :update_navigator and :unload, then restart server.

 

[Poizone2]

Thanks John

 

[Danny]

Another great release i will add this when i get back home. Thanks! +1

 

[Firedima]

Can't find items why?

 

[Spheral]

Can't find items why?

Do you have the ads_background furni?

Did you change USERID?

 

[Firedima]

I don't know i haven't items in my db... can you give me it? "the sql for items"

 

[Spheral]

you dont have items?

 

[Firedima]

No I've got a german CMS&EMU (The Retro in desc.)

 

[Squard]

Nice, thanks.

 

[Spheral]

You would have items on a database.
What emulator?

 

[Firedima]

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

 

[NoBrain]

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

Don't make me laugh...

 

[Firedima]

Don't make me laugh...

I'm so sorry...

 

[Pookie]

Great, thanks.

 

[Liam]

Is it me, or are the Coords incorrect, ROFL!

 

[Firedima]

Is it me, or are the Coords incorrect, ROFL!

Sry I can't speak englisch well, what do you mean with Coords?

 

[Spheral]

Nope, they work perfectly for me

 

[Alphaisadi62]

Thanks for posting this lewl -0-

 

[Bifi2000]

Hmm zoomed out its fucked up ..

 

[PoyzenCookie]

This looks promising .. ima test it later when my tech gets on - I don't wanna fook something up that I can't reverse "exoh"