public static Interfaces.IConquerItem GetSingleItem(uint UID)
{
Interfaces.IConquerItem item = new Network.GamePackets.ConquerItem(true);
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("items").Where("UID", UID);
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
if (r.Read())
{
item.ID = r.ReadUInt32("ID");
item.UID = r.ReadUInt32("UID");
item.Durability = r.ReadUInt16("Durability");
item.MaximDurability = r.ReadUInt16("MaximDurability");
item.Position = r.ReadUInt16("Position");
item.SocketProgress = r.ReadUInt32("SocketProgress");
item.PlusProgress = r.ReadUInt32("PlusProgress");
item.SocketOne = (Game.Enums.Gem)r.ReadByte("SocketOne");
item.SocketTwo = (Game.Enums.Gem)r.ReadByte("SocketTwo");
item.Effect = (Game.Enums.ItemEffect)r.ReadByte("Effect");
item.Mode = Game.Enums.ItemMode.Default;
item.Plus = r.ReadByte("Plus");
item.Bless = r.ReadByte("Bless");
item.Bound = r.ReadBoolean("Bound");
item.Enchant = r.ReadByte("Enchant");
item.Lock = r.ReadByte("Locked");
item.UnlockEnd = DateTime.FromBinary(r.ReadInt64("UnlockEnd"));
item.Suspicious = r.ReadBoolean("Suspicious");
item.SuspiciousStart = DateTime.FromBinary(r.ReadInt64("SuspiciousStart"));
item.Color = (Game.Enums.Color)r.ReadByte("Color");
item.Warehouse = r.ReadUInt16("Warehouse");
if (item.Lock == 2)
if (DateTime.Now >= item.UnlockEnd)
item.Lock = 0;
}
r.Close();
//r.Close();
r.Dispose();
return item;
}