public static void LoadUsablesItems() { var sqlText = "SELECT * FROM items_usables"; var sqlCommand = new MySqlCommand(sqlText, Program.DBHelper.Use()); var sqlReader = sqlCommand.ExecuteReader(); while (sqlReader.Read()) { var item = new Models.Items.ItemUsableModel() { Base = sqlReader.GetInt16("ID"), Args = sqlReader.GetString("Args"), }; if (sqlReader.GetInt16("MustDelete") == 1) { item.MustDelete = true; } else { item.MustDelete = false; } item.AttributeItem(); UsablesList.Add(item); } sqlReader.Close(); Utilities.Loggers.Status.Write(string.Format("Loaded '{0}' items usables from the database !", UsablesList.Count)); }
public static void LoadUsablesItems() { lock (DatabaseHandler.ConnectionLocker) { var sqlText = "SELECT * FROM datas_items_usables"; var sqlCommand = new MySqlCommand(sqlText, DatabaseHandler.Connection); var sqlReader = sqlCommand.ExecuteReader(); while (sqlReader.Read()) { var item = new Models.Items.ItemUsableModel(); item.Base = sqlReader.GetInt16("ID"); item.Args = sqlReader.GetString("Args"); if (sqlReader.GetInt16("MustDelete") == 1) item.MustDelete = true; else item.MustDelete = false; item.AttributeItem(); lock(UsablesList) UsablesList.Add(item); } sqlReader.Close(); } Utilities.Loggers.StatusLogger.Write(string.Format("Loaded @'{0}' items usables@ from the database !", UsablesList.Count)); }