public static void LoadSpells()
{
lock (DatabaseProvider.Locker)
{
var sqlText = "SELECT * FROM spells";
var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection);
var sqlReader = sqlCommand.ExecuteReader();
while (sqlReader.Read())
{
var spell = new Entities.Models.Spells.SpellModel()
{
ID = sqlReader.GetInt16("id"),
Sprite = sqlReader.GetInt16("sprite"),
SpriteInfos = sqlReader.GetString("spriteInfos"),
};
for (int i = 1; i <= 6; i++)
spell.ParseLevel(sqlReader.GetString("lvl" + i), i);
SpellsList.Add(spell);
}
sqlReader.Close();
}
Utilities.Loggers.Status.Write(string.Format("Loaded '{0}' spells from the database !", SpellsList.Count));
}
public static void LoadSpells()
{
var sqlText = "SELECT * FROM spells";
var sqlCommand = new MySqlCommand(sqlText, Program.DBHelper.Use());
var sqlReader = sqlCommand.ExecuteReader();
while (sqlReader.Read())
{
var spell = new Entities.Models.Spells.SpellModel()
{
ID = sqlReader.GetInt16("id"),
Sprite = sqlReader.GetInt16("sprite"),
SpriteInfos = sqlReader.GetString("spriteInfos"),
};
for (int i = 1; i <= 6; i++)
{
spell.ParseLevel(sqlReader.GetString("lvl" + i), i);
}
SpellsList.Add(spell);
}
sqlReader.Close();
Utilities.Loggers.Status.Write(string.Format("Loaded '{0}' spells from the database !", SpellsList.Count));
}
