public static void LoadSpellsToLearn()
{
lock (DatabaseProvider.Locker)
{
var sqlText = "SELECT * FROM spells_learn";
var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection);
var sqlReader = sqlCommand.ExecuteReader();
while (sqlReader.Read())
{
var spell = new Entities.Models.Spells.SpellToLearnModel()
{
Race = sqlReader.GetInt16("Classe"),
Level = sqlReader.GetInt16("Level"),
SpellID = sqlReader.GetInt16("SpellId"),
Pos = sqlReader.GetInt16("Position"),
};
SpellsToLearnList.Add(spell);
}
sqlReader.Close();
}
Utilities.Loggers.Status.Write(string.Format("Loaded '{0}' spells to learn from the database !", SpellsToLearnList.Count));
}
public static void LoadSpellsToLearn()
{
var sqlText = "SELECT * FROM spells_learn";
var sqlCommand = new MySqlCommand(sqlText, Program.DBHelper.Use());
var sqlReader = sqlCommand.ExecuteReader();
while (sqlReader.Read())
{
var spell = new Entities.Models.Spells.SpellToLearnModel()
{
Race = sqlReader.GetInt16("Classe"),
Level = sqlReader.GetInt16("Level"),
SpellID = sqlReader.GetInt16("SpellId"),
Pos = sqlReader.GetInt16("Position"),
};
SpellsToLearnList.Add(spell);
}
sqlReader.Close();
Utilities.Loggers.Status.Write(string.Format("Loaded '{0}' spells to learn from the database !", SpellsToLearnList.Count));
}