SwiftEmu Room Bug!

[Brad]

Hey when ever people enter there rooms with furni in the client stays black?


here is the packetlog

Error in packet [2807] BODY: [0][0]?[0][0]????:
TokenID: 0System.IndexOutOfRangeException: Cannot find column 8.
  at System.Data.DataColumnCollection.get_Item(Int32 index)
  at System.Data.DataRow.get_Item(Int32 columnIndex)
  at Butterfly.HabboHotel.Rooms.RoomItemHandling.LoadFurniture() in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\HabboHotel\Rooms\RoomItemHandling.cs:line 241
  at Butterfly.HabboHotel.Rooms.Room.Initialize(UInt32 Id, String Name, String Description, String Type, String Owner, Int32 OwnerId, Int32 Category, Int32 State, Int32 UsersMax, String ModelName, String CCTs, Int32 Score, List`1 pTags, Boolean AllowPets, Boolean AllowPetsEating, Boolean AllowWalkthrough, Boolean Hidewall, RoomIcon Icon, String Password, String Wallpaper, String Floor, String Landscape, RoomData RoomData, Boolean RightOverride, Int32 walltickness, Int32 floorthickness, Int32 groupid) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\HabboHotel\Rooms\Room.cs:line 665
  at Butterfly.HabboHotel.Rooms.Room.InitializeFromRoomData(RoomData Data) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\HabboHotel\Rooms\Room.cs:line 687
  at Butterfly.HabboHotel.Rooms.Room..ctor(RoomData Data) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\HabboHotel\Rooms\Room.cs:line 109
  at Butterfly.HabboHotel.Rooms.RoomManager.LoadRoom(UInt32 Id) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\HabboHotel\Rooms\RoomManager.cs:line 297
  at Butterfly.Messages.GameClientMessageHandler.PrepareRoomForUser(UInt32 Id, String Password) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\Messages\GameClientMessageHandler.cs:line 5823
  at Butterfly.Messages.GameClientMessageHandler.enterOnRoom() in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\Messages\GameClientMessageHandler.cs:line 2091
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.enterOnRoom(GameClientMessageHandler handler) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 270
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 19
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\Messages\GameClientMessageHandler.cs:line 3455
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136

Fixed All You Have to Do is Run These Queries

DROP PROCEDURE IF EXISTS `getroomitems`;
DELIMITER ;;
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, items.placedBy
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 ;

DROP PROCEDURE IF EXISTS `getuseritems`;
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 ;