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