public List <ClassLevelStatistic> GetClassLevelStats()
{
string query = "SELECT * FROM creature_template_classlevelstats";
List <ClassLevelStatistic> classlvlstats = new List <ClassLevelStatistic>();
if (OpenConnection())
{
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
ClassLevelStatistic cls = new ClassLevelStatistic()
{
Class = dataReader["Class"].ToString(),
Level = dataReader["Level"].ToString(),
BaseHealthExp0 = dataReader["BaseHealthExp0"].ToString(),
BaseHealthExp1 = dataReader["BaseHealthExp1"].ToString(),
BaseDamageExp0 = dataReader["BaseDamageExp0"].ToString(),
BaseDamageExp1 = dataReader["BaseDamageExp1"].ToString(),
BaseMana = dataReader["BaseMana"].ToString(),
BaseMeleeAttackPower = dataReader["BaseMeleeAttackPower"].ToString(),
BaseRangedAttackPower = dataReader["BaseRangedAttackPower"].ToString(),
BaseArmor = dataReader["BaseArmor"].ToString(),
};
classlvlstats.Add(cls);
}
dataReader.Close();
CloseConnection();
}
return(classlvlstats);
}
private void updateClassLevelStats()
{
ClassLevelStatistic result = basestats.FirstOrDefault(a => a.Level == activeCreature.MinLevel && a.Class == activeCreature.UnitClass);
if (result != null)
{
activeClassLevelStats = result;
txtBaseDamageExp0.Text = activeClassLevelStats.BaseDamageExp0;
txtBaseDamageExp1.Text = activeClassLevelStats.BaseDamageExp1;
txtBaseHealthExp0.Text = activeClassLevelStats.BaseHealthExp0;
txtBaseHealthExp1.Text = activeClassLevelStats.BaseHealthExp1;
txtBaseArmor.Text = activeClassLevelStats.BaseArmor;
txtBaseMana.Text = activeClassLevelStats.BaseMana;
txtBaseRangeAP.Text = activeClassLevelStats.BaseRangedAttackPower;
txtBaseMeleeAP.Text = activeClassLevelStats.BaseMeleeAttackPower;
}
}
