private void DoDisplayNPCInfos(NpcTemplate _npc) { rtb.Clear(); rtb.SetBold(); if (_npc.subname != String.Empty) rtb.AppendFormatLine(@"{0} <{1}>", _npc.name, _npc.subname); else rtb.AppendFormatLine(@"{0}", _npc.name); rtb.SetDefaultStyle(); rtb.AppendLine(""); rtb.AppendFormatLine(@"Difficulty Entries: #1{0} #2{1} #3{2}", _npc.difficultyEntry1, _npc.difficultyEntry2, _npc.difficultyEntry3); }
internal static void DoSeekNPCUsingQuery(string _query) { OpenConnexion(); if (!Connected) throw new Exception("Could not connect to the database"); _didFind = false; _command = new MySqlCommand(_query, _conn); using (var reader = _command.ExecuteReader()) { while (reader.Read()) { _didFind = true; _npc = new NpcTemplate { Entry = reader[0].ToUInt32(), difficultyEntry1 = reader[1].ToUInt32(), difficultyEntry2 = reader[2].ToUInt32(), difficultyEntry3 = reader[3].ToUInt32(), killCredit1 = reader[4].ToUInt32(), killCredit2 = reader[5].ToUInt32(), modelID1 = reader[6].ToUInt32(), modelID2 = reader[7].ToUInt32(), modelID3 = reader[8].ToUInt32(), modelID4 = reader[9].ToUInt32(), name = reader[10].ToString(), subname = reader[11].ToString(), iconName = reader[12].ToString(), gossipMenuId = reader[13].ToUInt32(), minLevel = reader[14].ToUInt32(), maxLevel = reader[15].ToUInt32(), expansion = reader[16].ToUInt32(), factionA = reader[17].ToUInt32(), factionH = reader[18].ToUInt32(), npcFlag = reader[19].ToUInt32(), speedWalk = reader[20].ToFloat(), speedRun = reader[21].ToFloat(), scale = reader[22].ToFloat(), rank = reader[23].ToUInt32(), minDmg = reader[24].ToUInt32(), maxDmg = reader[25].ToUInt32(), dmgSchool = reader[26].ToUInt32(), attackPower = reader[27].ToUInt32(), dmgMultiplier = reader[28].ToFloat(), baseAttackTime = reader[29].ToUInt32(), rangeAttackTime = reader[30].ToUInt32(), unitClass = reader[31].ToUInt32(), unitFlags = reader[32].ToUInt32(), dynamicFlags = reader[33].ToUInt32(), family = reader[34].ToUInt32(), trainerType = reader[35].ToUInt32(), trainerSpell = reader[36].ToUInt32(), trainerClass = reader[37].ToUInt32(), trainerRace = reader[38].ToUInt32(), minRangeDmg = reader[39].ToUInt32(), maxRangeDmg = reader[40].ToUInt32(), rangedAttackPower= reader[41].ToUInt32(), type = reader[42].ToUInt32(), typeFlags = reader[43].ToUInt32(), lootID = reader[44].ToUInt32(), pickPocketLoot = reader[45].ToUInt32(), skinLoot = reader[46].ToUInt32(), resistance1 = reader[47].ToUInt32(), resistance2 = reader[48].ToUInt32(), resistance3 = reader[49].ToUInt32(), resistance4 = reader[50].ToUInt32(), resistance5 = reader[51].ToUInt32(), resistance6 = reader[52].ToUInt32(), spell1 = reader[53].ToUInt32(), spell2 = reader[54].ToUInt32(), spell3 = reader[55].ToUInt32(), spell4 = reader[56].ToUInt32(), spell5 = reader[57].ToUInt32(), spell6 = reader[58].ToUInt32(), spell7 = reader[59].ToUInt32(), spell8 = reader[60].ToUInt32(), PetSpellDataId = reader[61].ToUInt32(), VehicleID = reader[62].ToUInt32(), minGold = reader[63].ToUInt32(), maxGold = reader[64].ToUInt32(), AIName = reader[65].ToString(), movementType = reader[66].ToUInt32(), inhabitType = reader[67].ToUInt32(), healthMod = reader[68].ToUInt32(), manaMod = reader[69].ToUInt32(), armorMod = reader[70].ToUInt32(), racialLeader = reader[71].ToUInt32(), QuestItem1 = reader[72].ToUInt32(), QuestItem2 = reader[73].ToUInt32(), QuestItem3 = reader[74].ToUInt32(), QuestItem4 = reader[75].ToUInt32(), QuestItem5 = reader[76].ToUInt32(), QuestItem6 = reader[77].ToUInt32(), movementID = reader[78].ToUInt32(), regenHealth = reader[79].ToUInt32(), equipmentID = reader[80].ToUInt32(), MechanicImmuneMask = reader[81].ToUInt32(), flagsExtra = reader[82].ToUInt32(), ScriptName = reader[83].ToString(), }; } } }