You must be registered for see links
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");
}