/// <summary>
/// Needs serious fixing in the reader, as it throws invalid casts (files all use uint, but f**k those)
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static ItemInfo Load(DataRow row)
{
var itemInfo = new ItemInfo
{
ItemID = GetDataTypes.GetUshort(row["id"]),
Slot = (ItemSlot)GetDataTypes.GetByte(row["equip"]),
InxName = (string)row["inxname"],
MaxLot = GetDataTypes.GetInt(row["maxlot"]),
AttackSpeed = GetDataTypes.GetUshort(row["atkspeed"]),
Level = GetDataTypes.GetByte(row["demandlv"]),
Type = (ItemType)GetDataTypes.GetByte(row["type"]),
Class = (ItemClass)GetDataTypes.GetByte(row["class"]),
UpgradeLimit = GetDataTypes.GetByte(row["uplimit"]),
Jobs = UnpackWhoEquip(GetDataTypes.GetUint(row["whoequip"])),
TwoHand = GetDataTypes.GetBool(row["TwoHand"]),
MinMagic = GetDataTypes.GetUshort(row["minma"]),
MaxMagic = GetDataTypes.GetUshort(row["maxma"]),
MinMelee = GetDataTypes.GetUshort(row["minwc"]),
MaxMelee = GetDataTypes.GetUshort(row["maxwc"]),
WeaponDef = GetDataTypes.GetUshort(row["ac"]),
MagicDef = GetDataTypes.GetUshort(row["mr"]),
UpSucRation = GetDataTypes.GetUshort(row["UpSucRatio"]),
UpResource = GetDataTypes.GetUshort(row["UpResource"]),
SellPrice = GetDataTypes.GetUint(row["SellPrice"]),
BuyPrice = GetDataTypes.GetUint(row["BuyPrice"])
};
itemInfo.Stats = new ItemStats();
return(itemInfo);
}
public static Item LoadItem(DataRow Row)
{
ulong id = GetDataTypes.GetUlong(Row["ID"]);
uint owner = GetDataTypes.GetUint(Row["Owner"]);
sbyte slot = GetDataTypes.GetSByte(Row["Slot"]);
ushort equipID = GetDataTypes.GetUshort(Row["ItemID"]);
ushort amount = GetDataTypes.GetUshort(Row["Amount"]);
Item item = new Item(id, owner, equipID, slot, amount)
{
Slot = slot,
IsEquipped = GetDataTypes.GetBool(Row["Equipt"]),
};
return(item);
}
public static MasterMember LoadFromDatabase(DataRow row)
{
MasterMember Member = new MasterMember
{
pMemberName = row["MemberName"].ToString(),
CharID = GetDataTypes.GetInt(row["CharID"]),
Level = GetDataTypes.GetByte(row["Level"]),
IsMaster = GetDataTypes.GetBool(row["isMaster"]),
MasterID = GetDataTypes.GetInt(row["MasterID"]),
RegisterDate = DateTime.ParseExact(row["RegisterDate"].ToString(), "dd.MM.yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture),
};
Member.pMember = ClientManager.Instance.GetClientByCharname(Member.pMemberName);
Member.IsOnline = ClientManager.Instance.IsOnline(Member.pMemberName);
return(Member);
}
public static Item LoadItem(DataRow Row)
{
var id = GetDataTypes.GetUlong(Row["ID"]);
var owner = GetDataTypes.GetUint(Row["Owner"]);
var slot = GetDataTypes.GetSByte(Row["Slot"]);
var equipID = GetDataTypes.GetUshort(Row["ItemID"]);
var amount = GetDataTypes.GetUshort(Row["Amount"]);
var item = new Item(id, owner, equipID, slot, amount)
{
Slot = slot,
IsEquipped = GetDataTypes.GetBool(Row["Equipt"])
};
return(item);
}
public static Mount LoadMount(DataRow Data)
{
var Mouninf = new Mount
{
MinLevel = GetDataTypes.GetByte(Data["Level"]),
ItemID = GetDataTypes.GetUshort(Data["ItemID"]),
TickSpeed = GetDataTypes.GetInt(Data["Tickspeed"]),
Handle = GetDataTypes.GetUshort(Data["Handle"]),
Food = GetDataTypes.GetUshort(Data["Food"]),
speed = GetDataTypes.GetUshort(Data["Speed"]),
CastTime = GetDataTypes.GetInt(Data["CastTime"]),
Cooldown = GetDataTypes.GetUshort(Data["Cooldown"]),
permanent = GetDataTypes.GetBool(Data["permanent"])
};
return(Mouninf);
}
public static MobInfo Load(DataRow row)
{
var inf = new MobInfo
{
Name = (string)row["InxName"],
ID = GetDataTypes.GetUshort(row["ID"]),
Level = GetDataTypes.GetByte(row["Level"]),
MaxHP = GetDataTypes.GetUint(row["MaxHP"]),
RunSpeed = GetDataTypes.GetUshort(row["RunSpeed"]),
IsNpc = GetDataTypes.GetBool(row["IsNPC"]),
Size = GetDataTypes.GetUshort(row["Size"]),
Type = GetDataTypes.GetByte(row["Type"]),
IsAggro = GetDataTypes.GetBool(row["IsPlayerSide"]),
Drops = new List <DropInfo>()
};
return(inf);
}