BCStorm Errors (Video)

Detox

Member
Jul 24, 2010
365
24


Souce I've edit

RoomItemHandling.cs
Code:
 {
                if (adapter.dbType == DatabaseType.MySQL)
                {
                    adapter.setQuery("SELECT * , COALESCE(`items_groups`.`group_id`, 0) AS group_id FROM `items` LEFT OUTER JOIN `items_groups` ON `items_id` = `items_groups`.`id` WHERE items_room_id=@roomid LIMIT 2000");
                    adapter.addParameter("roomid", this.room.RoomId);

                    Data = adapter.getTable();

                    if (Data.Rows.Count == 2000)
                    {
                        GameClient Client = ButterflyEnvironment.GetGame().GetClientManager().GetClientByUserID((uint)room.OwnerId);
                        if (Client != null)
                            Client.SendNotif("Your room has more than 2000 items in it. The current limit of items per room is 2000.\n" +
                                "To view the rest, pick some of these items up!");
                    }

UserDataFactory.cs
Code:
if (adapter.dbType == DatabaseType.MySQL)
                {
                    adapter.setQuery("SELECT items.* , COALESCE(items_groups.group_id, 0) AS group_id FROM items LEFT OUTER JOIN items_groups ON items_id = items_groups.id WHERE room_id='' AND user_id=" + num + " LIMIT 8000");
             
                }
I took the source out of PlusEMU and Edit into my own since PlusEMU is based off Butterfly... I'm avoiding trying to use getusersitems MySQL stuff (Routine)
 

Users who are viewing this thread

Top