void ItemAvatarUnEquip(byte fromSlot, byte toSlot)
{
#region Avatar unequiped
try
{
GetFreeSlot();
Global.slotItem toItem = GetItem((uint)Character.Information.CharacterID, toSlot, 0);
int avatarid = 0;
int dbID = 0;
if (toItem.ID != 0) toSlot = GetFreeSlot();
if (toSlot <= 12) return;
MsSQL ms = new MsSQL("SELECT * FROM char_items WHERE itemnumber='avatar" + fromSlot + "' AND owner='" + Character.Information.CharacterID + "' AND inAvatar='1'");
using (System.Data.SqlClient.SqlDataReader reader = ms.Read())
{
while (reader.Read())
{
avatarid = reader.GetInt32(2);
dbID = reader.GetInt32(0);
}
}
ms.Close();
client.Send(Packet.MoveItem(35, fromSlot, toSlot, 1,0,"MOVE_INSIDE_INVENTORY"));
Send(Packet.MoveItemUnequipEffect(Character.Information.UniqueID, fromSlot, avatarid));
string nonquery = "UPDATE char_items SET itemnumber='item" + toSlot + "',slot='" + toSlot + "',inAvatar='0' WHERE owner='" + Character.Information.CharacterID + "' AND itemnumber='avatar" + fromSlot + "' AND id='" + dbID + "'";
MsSQL.InsertData(nonquery);
}
catch (Exception ex)
{
Console.WriteLine("Avatar unequiped error {0}", ex);
Systems.Debugger.Write(ex);
}
#endregion
}