public Storage LoadStorage(Player player, StorageType type)
{
string SQL = "SELECT * FROM `inventory` WHERE "
+ "`playerid` = ?pid AND `storagetype` = ?type";
MySqlCommand cmd = new MySqlCommand(SQL, InventoryDAOConnection);
cmd.Parameters.AddWithValue("?pid", player.Id);
cmd.Parameters.AddWithValue("?type", type.ToString());
MySqlDataReader LoadStorageReader = cmd.ExecuteReader();
var storage = new Storage { StorageType = StorageType.Inventory };
if (LoadStorageReader.HasRows)
{
while (LoadStorageReader.Read())
{
if (LoadStorageReader.GetInt32(2) != 20000000)
{
StorageItem item = new StorageItem()
{
ItemId = LoadStorageReader.GetInt32(2),
Amount = LoadStorageReader.GetInt32(3),
Color = LoadStorageReader.GetInt32(4),
};
storage.Items.Add(LoadStorageReader.GetInt32(5), item);
}
else
{
storage.Money = LoadStorageReader.GetInt32(3);
}
}
}
LoadStorageReader.Close();
return storage;
}
public void SaveStorage(Player player, Storage storage)
{
string cmdString = "DELETE FROM inventory WHERE PlayerId=?pid";
MySqlCommand command = new MySqlCommand(cmdString, InventoryDAOConnection);
command.Parameters.AddWithValue("?pid", player.Id);
command.ExecuteNonQuery();
storage.Items.Add(999, storage.MoneyToItem); // add temporary save money item
if (storage.Items.Count > 0)
{
foreach (var item in storage.Items)
AddItem(player, storage.StorageType, item);
}
storage.Items.Remove(999); // remove temporary save money item
}
public List<int> GetFreeSlots(Storage storage)
{
var freeSlots = new List<int>();
for (int i = (storage.StorageType == StorageType.Inventory ? 20 : 0);
i <= storage.Size + (storage.StorageType == StorageType.Inventory ? 19 : 0);
i++)
if (!storage.Items.ContainsKey(i))
freeSlots.Add(i);
return freeSlots;
}
public Storage LoadAccountStorage(GameAccount gameAccount)
{
string SQL = "SELECT * FROM `inventory` WHERE "
+ "`accountname` = ?accountname AND `storagetype` = ?type";
MySqlCommand cmd = new MySqlCommand(SQL, InventoryDAOConnection);
cmd.Parameters.AddWithValue("?accountname", gameAccount.Username);
cmd.Parameters.AddWithValue("?type", StorageType.AccountWarehouse.ToString());
MySqlDataReader LoadAccountStorageReader = cmd.ExecuteReader();
var storage = new Storage { StorageType = StorageType.AccountWarehouse };
if (LoadAccountStorageReader.HasRows)
{
while (LoadAccountStorageReader.Read())
{
StorageItem item = new StorageItem()
{
ItemId = LoadAccountStorageReader.GetInt32(2),
Amount = LoadAccountStorageReader.GetInt32(3),
Color = LoadAccountStorageReader.GetInt32(4),
};
storage.Items.Add(LoadAccountStorageReader.GetInt32(5), item);
}
}
LoadAccountStorageReader.Close();
return storage;
}
public StorageItem GetItemBySlot(Storage storage, int slot)
{
lock (storage.ItemsLock)
{
if (!storage.Items.ContainsKey(slot))
return null;
return storage.Items[slot];
}
}
public bool PlaceItemToOtherStorage(Player player, Player second, Storage from, int fromSlot, Storage to, int toSlot, int count)
{
if (to.IsFull())
return false;
if (count < 0)
return false;
if (!(player.Controller is DefaultController) || !(second.Controller is DefaultController))
return false;
if(player == second)
{
StorageItem item = null;
if(to.StorageType == StorageType.CharacterWarehouse)
{
if(toSlot == -1)
toSlot = to.GetFreeSlot(player.PlayerCurrentBankSection * 72);
if(toSlot == 0 && to.Items.ContainsKey(toSlot))
toSlot = to.GetFreeSlot(player.PlayerCurrentBankSection * 72);
if (toSlot == to.LastIdRanged(player.PlayerCurrentBankSection * 72, (player.PlayerCurrentBankSection + 1) * 72 - 1))
toSlot = to.GetFreeSlot(player.PlayerCurrentBankSection * 72);
}
else
if ((toSlot == 0 && to.Items.ContainsKey(toSlot)) || toSlot == -1)
toSlot = to.GetFreeSlot();
if (to.Items.ContainsKey(toSlot))
{
if (!PlaceItemToOtherStorage(player, player, to, toSlot, player.Inventory, player.Inventory.GetFreeSlot(), to.Items[toSlot].Amount))
return false;
}
lock (from.ItemsLock)
{
if(from.Items.ContainsKey(fromSlot))
{
item = from.Items[fromSlot];
if(item.Amount < count)
return false;
if (item.Amount == count)
from.Items.Remove(fromSlot);
else
{
from.Items[fromSlot].Amount -= count;
item = new StorageItem { ItemId = item.ItemId, Amount = count };
}
}
}
if (item == null)
return false;
if (!AddItem(player, to, item.ItemId, count, toSlot))
AddItem(player, from, item.ItemId, count, fromSlot);
}
return false;
}
public bool ContainsItem(Storage storage, int itemId, long counter)
{
lock (storage.ItemsLock)
{
for (int i = (storage.StorageType == StorageType.Inventory ? 20 : 0);
i <= storage.Size + (storage.StorageType == StorageType.Inventory ? 19 : 0);
i++)
if (storage.Items.ContainsKey(i))
{
if (storage.Items[i].ItemId == itemId && storage.Items[i].Amount >= counter)
return true;
}
}
return false;
}
public bool AddItem(Player player, Storage storage, StorageItem item)
{
lock (storage.ItemsLock)
{
int maxStack = ItemTemplate.Factory(item.ItemId).MaxStack;
int canStacked = 0;
if (maxStack > 1)
{
for (int i = 20; i < 20 + storage.Size; i++)
{
if (!storage.Items.ContainsKey(i)) continue;
if (storage.Items[i].ItemId == item.ItemId)
{
canStacked += maxStack - storage.Items[i].Amount;
if (canStacked >= item.Amount)
break;
}
}
}
if (canStacked < item.Amount && GetFreeSlots(storage).Count < 1)
return false;
if (canStacked > 0)
{
for (int i = 20; i < 20 + storage.Size; i++)
{
if (!storage.Items.ContainsKey(i)) continue;
if (storage.Items[i].ItemId == item.ItemId)
{
int put = maxStack - storage.Items[i].Amount;
if (item.Amount < put)
put = item.Amount;
storage.Items[i].Amount += put;
item.Amount -= put;
if (item.Amount <= 0)
break;
}
}
}
if (item.Amount > 0)
storage.Items.Add(storage.GetFreeSlot(), item);
ShowPlayerStorage(player, storage.StorageType);
return true;
}
}
public bool AddMoneys(Player player, Storage storage, long counter)
{
if (counter < 0)
return false;
storage.Money += counter;
ShowPlayerStorage(player, storage.StorageType);
return true;
}
public bool RemoveMoney(Player player, Storage storage, long counter)
{
if (counter < 0)
return false;
if (storage.Money - counter >= 0)
storage.Money -= counter;
else
{
player.Inventory.Money = 0;
Logger.WriteLine(LogState.Warn,"InventorService: Player {0} moneys can't be less than 0");
ShowPlayerStorage(player, storage.StorageType);
return false;
}
ShowPlayerStorage(player, storage.StorageType);
return true;
}
public void ReplaceItem(Player player, Storage storage, int @from, int to, bool isForDress = false, bool showStorage = true)
{
lock (storage.ItemsLock)
{
if (!storage.Items.ContainsKey(@from))
return;
if (from < 20 && GetFreeSlots(storage).Count == 0)
return;
StorageItem item = storage.Items[@from];
if (isForDress && storage.StorageType == StorageType.Inventory)
{
if (to == 0)
to = GetDressSlot(item.ItemId);
if (to == 0)
return;
}
if (to != 0 && to < 20 && storage.StorageType == StorageType.Inventory)
{
if (!CanDress(player, item, true))
return;
switch (GetDressSlot(item.ItemId))
{
case 6:
if (to != 6 && to != 7)
return;
break;
case 8:
if (to != 8 && to != 9)
return;
break;
default:
if (to != GetDressSlot(item.ItemId))
return;
break;
}
}
storage.Items.Remove(@from);
if (storage.Items.ContainsKey(to))
{
StorageItem item2 = storage.Items[to];
storage.Items.Remove(to);
storage.Items.Add(@from, item2);
}
if (to == 0)
to = storage.GetFreeSlot();
storage.Items.Add(to, item);
if (@from <= 20 || to <= 20)
Communication.Logic.CreatureLogic.UpdateCreatureStats(player);
}
if (showStorage)
{
ShowPlayerStorage(player, storage.StorageType);
if(@from <= 20 || to <= 20)
new SpCharacterThings(player).Send(player.Connection);
}
}
public bool RemoveItemById(Player player, Storage storage, int itemId, int counter)
{
//todo rework
for (int i = 20; i <= player.Inventory.Size + 19; i++)
if (player.Inventory.Items.ContainsKey(i))
{
if (player.Inventory.Items[i].ItemId == itemId)
{
if (player.Inventory.Items[i].Amount <= counter)
player.Inventory.Items.Remove(i);
else
player.Inventory.Items[i].Amount -= counter;
ShowPlayerStorage(player, storage.StorageType);
return true;
}
}
return false;
}
public bool RemoveItem(Player player, Storage storage, int slot, int counter)
{
if (counter < 0)
return false;
slot += 20;
lock (storage.ItemsLock)
{
if (!storage.Items.ContainsKey(slot) || storage.Items[slot].Amount < counter)
return false;
if (storage.Items[slot].Amount == counter)
storage.Items.Remove(slot);
else if (storage.Items[slot].Amount > counter)
storage.Items[slot].Amount -= counter;
ShowPlayerStorage(player, storage.StorageType, false);
}
return true;
}
private void CheckLock(Storage storage)
{
if (!storage.Locked)
return;
storage.Locked = false;
SystemMessages.TradeHasChangedPleaseCheckItAgain.Send(storage.Equals(Storage1) ? Player1 : Player2);
}
public StorageItem GetItemById(Storage storage, int id)
{
lock (storage.ItemsLock)
{
for (int i = (storage.StorageType == StorageType.Inventory ? 20 : 0);
i <= storage.Size + (storage.StorageType == StorageType.Inventory ? 19 : 0);
i++)
if (storage.Items.ContainsKey(i))
{
if (storage.Items[i].ItemId == id)
return storage.Items[i];
}
}
return null;
}
public override void Release()
{
ObservedCreature = null;
Inventory.Release();
Inventory = null;
PlayerData = null;
try
{
Visible.Stop();
Visible.Release();
}
// ReSharper disable EmptyGeneralCatchClause
catch
// ReSharper restore EmptyGeneralCatchClause
{
//Already stoped
}
Visible = null;
Skills = null;
Quests = null;
if (CurrentDialog != null)
CurrentDialog.Release();
if (Pet != null)
Pet.Release();
Pet = null;
MarkedCreatures = null;
TeleportLoadMapEvent = null;
try
{
SystemWindowsTimer.Stop();
SystemWindowsTimer.Dispose();
}
// ReSharper disable EmptyGeneralCatchClause
catch
// ReSharper restore EmptyGeneralCatchClause
{
}
SystemWindowsTimer = null;
BlockersInChat = null;
Friends = null;
base.Release();
}
public bool AddItem(Player player, Storage storage, int itemId, int count, int slot = -1)
{
if (count < 0)
return false;
if (slot > (storage.StorageType == StorageType.Inventory ? storage.Size + 20 : storage.Size))
return false;
if ((storage.StorageType == StorageType.Inventory && slot < 20 && slot != -1))
return false;
if (slot < -1)
return false;
lock (storage.ItemsLock)
{
int stackSize = ItemTemplate.Factory(itemId).MaxStack;
if (stackSize == 1 && storage.IsFull())
{
SystemMessages.InventoryIsFull.Send(player);
return false;
}
if (stackSize == 1)
{
if (slot == -1)
storage.Items.Add(storage.GetFreeSlot(), new StorageItem {ItemId = itemId, Amount = count});
else if (storage.Items.ContainsKey(slot))
{
SystemMessages.YouCantPutItemInInventory(ItemTemplate.Factory(itemId).Name).Send(player);
return false;
}
else
storage.Items.Add(slot, new StorageItem {ItemId = itemId, Amount = count});
}
else
{
if (slot != -1)
{
// Certain slot + Stackable
if (storage.Items.ContainsKey(slot))
{
SystemMessages.YouCantPutItemInInventory(ItemTemplate.Factory(itemId).Name).Send(player);
return false;
}
storage.Items.Add(slot, new StorageItem { ItemId = itemId, Amount = count });
}
else
{
#region Any slot + Stackable
Dictionary<int, StorageItem> itemsById = storage.GetItemsById(itemId);
int canBeAdded =
itemsById.Values.Where(storageItem => storageItem.Amount < stackSize).Sum(
storageItem => stackSize - storageItem.Amount);
if (canBeAdded >= count)
{
foreach (var storageItem in itemsById.Values)
{
int added = Math.Min(stackSize - storageItem.Amount, count);
storageItem.Amount += added;
count -= added;
if (count == 0)
break;
}
}
else
{
if (storage.IsFull() || count > GetFreeSlots(storage).Count*stackSize)
{
SystemMessages.InventoryIsFull.Send(player);
return false;
}
foreach (var storageItem in itemsById.Values)
{
int added = Math.Min(stackSize - storageItem.Amount, count);
storageItem.Amount += added;
count -= added;
}
while (count > 0)
{
int added = Math.Min(stackSize, count);
StorageItem item = new StorageItem {ItemId = itemId, Amount = added};
storage.Items.Add(storage.GetFreeSlot(), item);
count -= added;
}
}
#endregion
}
}
ShowPlayerStorage(player, storage.StorageType);
return true;
}
}