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