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); }