[BCSTORM] Furnitrure Fix [BC]

[Flare]

well this is simple and easy. run this in your database.

Spoiler:

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(
IN roomid int(10) unsigned
)
BEGIN
SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data
FROM items_rooms
JOIN items ON (items.item_id = items_rooms.item_id)
LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
WHERE items_rooms.room_id = roomid;
END$$


CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(
IN userid int(10) unsigned
)
BEGIN
SELECT items_users.item_id, items.base_id, items_extradata.data
FROM items_users
JOIN items ON (items.item_id = items_users.item_id)
LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
WHERE items_users.user_id = userid;
END$$


DELIMITER ;

thanks,

[MentaL]

[Ddos Attack]

What exactly does it fix with the furniture?

[Flare]

when you place it , it wont pick your furniture up, etc.

[Ddos Attack]

when you place it , it wont pick your furniture up, etc.

Awesome, I'll add it soon, thanks :)

[rafa95123]

This already come with database bro. '-'

[Moogly]

In some cases though these procedures aren't setup correctly, or they just don't work, sometimes you need to reset them. In any case whenever furniture "disappears" after you reload the hotel, this is usually the culprit, and if it's not pray you figure it out.

[The General]

In some cases though these procedures aren't setup correctly, or they just don't work, sometimes you need to reset them. In any case whenever furniture "disappears" after you reload the hotel, this is usually the culprit, and if it's not pray you figure it out.

Thats what he said.

[Habp]

Gives me that error

[astroqwerty101]

Gives me that error

Yeah same error, how do you fix this problem :S

[Qbus]

Maybe a fix for the 2 post above this post :p -> http://forum.ragezone.com/f353/bcstr...hoenix-906600/

Post says:

clear items table