public static Equip LoadEquip(DataRow row)
{
var uniqueId = GetDataTypes.GetUlong(row["ID"]);
var owner = GetDataTypes.GetUint(row["Owner"]);
var equipId = GetDataTypes.GetUshort(row["EquipID"]);
var slot = GetDataTypes.GetSByte(row["Slot"]);
var upgrade = GetDataTypes.GetByte(row["Upgrades"]);
var strByte = GetDataTypes.GetUshort(row["iSTR"]);
var endByte = GetDataTypes.GetUshort(row["iEND"]);
var dexByte = GetDataTypes.GetUshort(row["iDEX"]);
var sprByte = GetDataTypes.GetUshort(row["iSPR"]);
var intByte = GetDataTypes.GetUshort(row["iINT"]);
var equip = new Equip(owner, equipId, slot)
{
UniqueId = uniqueId,
Upgrades = upgrade,
Str = strByte,
End = endByte,
Dex = dexByte,
Spr = sprByte,
Int = intByte
};
return(equip);
}
public static ActiveSkillInfo Load(DataRow row)
{
ActiveSkillInfo inf = new ActiveSkillInfo
{
ID = GetDataTypes.GetUshort(row["ID"]),
Name = (string)row["InxName"],
Step = GetDataTypes.GetByte(row["Step"]),
Required = (string)row["DemandSk"],
SP = GetDataTypes.GetUshort(row["SP"]),
HP = GetDataTypes.GetUshort(row["HP"]),
Range = GetDataTypes.GetUshort(row["Range"]),
CoolTime = GetDataTypes.GetUint(row["DlyTime"]),
CastTime = GetDataTypes.GetUint(row["CastTime"]),
DemandType = GetDataTypes.GetByte(row["DemandType"]),
MaxTargets = GetDataTypes.GetByte(row["TargetNumber"]),
};
uint maxdamage = GetDataTypes.GetUint(row["MaxWC"]);
if (maxdamage == 0)
{
inf.IsMagic = true;
inf.MinDamage = GetDataTypes.GetUshort(row["MinMA"]);
inf.MaxDamage = GetDataTypes.GetUshort(row["MaxMA"]);
}
else
{
inf.MaxDamage = maxdamage;
inf.MinDamage = GetDataTypes.GetUint(row["MinWC"]);
}
return(inf);
}
/// <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 MasterRewardItem(DataRow row)
{
ItemID = GetDataTypes.GetUshort(row["ItemID"]);
Level = GetDataTypes.GetByte(row["Level"]);
Job = (Job)GetDataTypes.GetByte(row["Job"]);
Count = GetDataTypes.GetByte(row["Count"]);
}
public MasterRewardItem(DataRow row)
{
this.ItemID = GetDataTypes.GetUshort(row["ItemID"]);
this.Level = GetDataTypes.GetByte(row["Level"]);
this.Job = (FiestaLib.Job)GetDataTypes.GetByte(row["Job"]);
this.Count = GetDataTypes.GetByte(row["Count"]);
}
private void Load()
{
//members
DataTable MemberData = null;
using (var DBClient = Program.DatabaseManager.GetClient())
{
MemberData = DBClient.ReadDataTable("SELECT * FROM GuildMembers WHERE GuildID = " + ID + "");
}
foreach (DataRow row in MemberData.Rows)
{
//get character
WorldCharacter character;
if (!CharacterManager.Instance.GetCharacterByID(Convert.ToInt32(row["CharID"]), out character))
{
continue;
}
var member = new GuildMember(this,
character,
(GuildRank)GetDataTypes.GetByte(row["Rank"]),
GetDataTypes.GetUshort(row["Korp"]));
Members.Add(member);
}
//academy
Academy = new GuildAcademy(this);
}
public static Equip LoadEquip(DataRow row)
{
ulong uniqueID = GetDataTypes.GetUlong(row["ID"]);
uint owner = GetDataTypes.GetUint(row["Owner"]);
ushort equipID = GetDataTypes.GetUshort(row["EquipID"]);
sbyte slot = GetDataTypes.GetSByte(row["Slot"]);
byte upgrade = GetDataTypes.GetByte(row["Upgrades"]);
ushort strByte = GetDataTypes.GetUshort(row["iSTR"]);
ushort endByte = GetDataTypes.GetUshort(row["iEND"]);
ushort dexByte = GetDataTypes.GetUshort(row["iDEX"]);
ushort sprByte = GetDataTypes.GetUshort(row["iSPR"]);
ushort intByte = GetDataTypes.GetUshort(row["iINT"]);
Equip equip = new Equip(owner, equipID, slot)
{
UniqueID = uniqueID,
Upgrades = upgrade,
Str = strByte,
End = endByte,
Dex = dexByte,
Spr = sprByte,
Int = intByte
};
return(equip);
}
public static MobInfoServer Load(DataRow row)
{
var info = new MobInfoServer
{
ID = GetDataTypes.GetUint(row["ID"]),
InxName = (string)row["InxName"],
Visible = GetDataTypes.GetByte(row["Visible"]),
AC = GetDataTypes.GetUshort(row["AC"]),
TB = GetDataTypes.GetUshort(row["TB"]),
MR = GetDataTypes.GetUshort(row["MR"]),
MB = GetDataTypes.GetUshort(row["MB"]),
EnemyDetectType = GetDataTypes.GetUint(row["EnemyDetectType"]),
MobKillInx = GetDataTypes.GetUint(row["MobKillInx"]),
MonExp = GetDataTypes.GetUint(row["MonEXP"]),
ExpRange = GetDataTypes.GetUshort(row["EXPRange"]),
DetectCha = GetDataTypes.GetUshort(row["DetectCha"]),
ResetInterval = GetDataTypes.GetByte(row["ResetInterval"]),
CutInterval = GetDataTypes.GetUshort(row["CutInterval"]),
CutNonAT = GetDataTypes.GetUint(row["CutNonAT"]),
FollowCha = GetDataTypes.GetUint(row["FollowCha"]),
PceHPRcvDly = GetDataTypes.GetUshort(row["PceHPRcvDly"]),
PceHPRcv = GetDataTypes.GetUshort(row["PceHPRcv"]),
AtkHPRcvDly = GetDataTypes.GetUshort(row["AtkHPRcvDly"]),
AtkHPRcv = GetDataTypes.GetUshort(row["AtkHPRcv"]),
Str = GetDataTypes.GetUshort(row["Str"]),
Dex = GetDataTypes.GetUshort(row["Dex"]),
Con = GetDataTypes.GetUshort(row["Con"]),
Int = GetDataTypes.GetUshort(row["Int"]),
Men = GetDataTypes.GetUshort(row["Men"]),
MobRaceType = GetDataTypes.GetUint(row["MobRaceType"]),
Rank = GetDataTypes.GetByte(row["Rank"]),
FamilyArea = GetDataTypes.GetUint(row["FamilyArea"]),
FamilyRescArea = GetDataTypes.GetUint(row["FamilyRescArea"]),
FamilyRescCount = GetDataTypes.GetByte(row["FamilyRescCount"]),
BloodingResi = GetDataTypes.GetUshort(row["BloodingResi"]),
StunResi = GetDataTypes.GetUshort(row["StunResi"]),
MoveSpeedResi = GetDataTypes.GetUshort(row["MoveSpeedResi"]),
FearResi = GetDataTypes.GetUshort(row["FearResi"]),
ResIndex = (string)row["ResIndex"],
KQKillPoint = GetDataTypes.GetUshort(row["KQKillPoint"]),
Return2Regen = GetDataTypes.GetByte(row["Return2Regen"]),
IsRoaming = GetDataTypes.GetByte(row["IsRoaming"]),
RoamingNumber = GetDataTypes.GetByte(row["RoamingNumber"]),
RoamingDistance = GetDataTypes.GetUshort(row["RoamingDistance"]),
MaxSP = GetDataTypes.GetUshort(row["MaxSP"]),
BroadAtDead = GetDataTypes.GetByte(row["BroadAtDead"]),
TurnSpeed = GetDataTypes.GetUshort(row["TurnSpeed"]),
WalkChase = GetDataTypes.GetUshort(row["WalkChase"]),
AllCanLoot = GetDataTypes.GetByte(row["AllCanLoot"]),
DmgByHealMin = GetDataTypes.GetUshort(row["DmgByHealMin"]),
DmgByHealMax = GetDataTypes.GetUshort(row["DmgByHealMax"])
};
return(info);
}
public static RewardItem LoadFromDatabase(System.Data.DataRow row)
{
RewardItem ppItem = new RewardItem
{
Slot = GetDataTypes.GetSByte(row["Slot"]),
ID = GetDataTypes.GetUshort(row["ItemID"]),
CharID = GetDataTypes.GetInt(row["CharID"]),
PageID = GetDataTypes.GetByte(row["PageID"])
};
return(ppItem);
}
public static PremiumItem LoadFromDatabase(DataRow row)
{
var ppItem = new PremiumItem
{
UniqueID = GetDataTypes.GetInt(row["UniqueID"]),
Slot = GetDataTypes.GetByte(row["PageID"]),
ShopID = GetDataTypes.GetInt(row["ShopID"]),
CharID = GetDataTypes.GetInt(row["CharID"]),
PageID = GetDataTypes.GetByte(row["PageID"])
};
return(ppItem);
}
public static MapInfo Load(DataRow row)
{
var info = new MapInfo
{
ID = GetDataTypes.GetUshort(row["ID"]),
ShortName = (string)row["MapName"],
FullName = (string)row["Name"],
RegenX = GetDataTypes.GetInt(row["RegenX"]),
RegenY = GetDataTypes.GetInt(row["RegenY"]),
Kingdom = GetDataTypes.GetByte(row["KingdomMap"]),
ViewRange = GetDataTypes.GetUshort(row["Sight"])
};
return(info);
}
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 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);
}