public static Models.AccountModel GetAccountFromSQL(string username)
{
lock (DatabaseManager.Locker)
{
Models.AccountModel account = null;
var reader = DatabaseManager.Provider.ExecuteReader("SELECT * FROM accounts WHERE username='" + username + "'");
if (reader.Read())
{
account = new Models.AccountModel()
{
ID = reader.GetInt32("Id"),
Username = reader.GetString("Username"),
Password = reader.GetString("Password"),
Pseudo = reader.GetString("Pseudo"),
AdminLevel = reader.GetInt32("AdminLevel"),
Points = reader.GetInt32("Points"),
Vip = reader.GetInt32("Vip"),
};
}
reader.Close();
return account;
}
}