All furniture gone in room problem!

[Kopperud]

Hello everyone, I have a strange problem and wondering if anyone might be able to answer! Problems is that when people make a room and make furniture there, and when I restart the emulator that is bcstorm. And when they then log in again after I restart the emulator, all the furniture in the room is gone, this happens for all users on the hotel!

EUMLATOR I USE IS BCSTORM BECAUSE I HAVE R63B HOTEL

 

[KyleVonnie]

Which BcStorm do you use, leenster's or leion's edit?

 

[Kopperud]

I use leon edition, that is fixed by leon!

 

[sim0n]

Try writing shutdown in the emu or :shutdown in the client. This should save all shits

 

[KyleVonnie]

Try to run these SQL in your database. Be sure to make a backup before, just in case.

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, items.rareid, items.group_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
;;
DELIMITER ;

CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN `userid` INT(10) UNSIGNED)
BEGIN
SELECT items_users.item_id, items.base_id, items_extradata.data, items.rareid, items.group_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 ;

 

[Kopperud]

Ok, thank you! Going to try it, will give you feedback

 

[KyleVonnie]

Ok, thank you! Going to try it, will give you feedback

Okay be sure to make a backup first. I found this SQL on another forum so I haven't tested it myself.

 

[Kopperud]

The sql code worked, but if you use :shutdown, it will work ass well!

 

[sim0n]

The sql code worked, but if you use :shutdown, it will work ass well!

Fagzone got a thread on how to add some code to not have to write shutdown... Maybe that was the SQL lol