public string GetUserShowname(string login)
{
var dt = new DataTable();
ExecuteCommandReturnable(_cHolder.GetCommand(SQLiteCommandsHolder.Commands.GetUserNameByLogin), dt, ("@u", login));
if (dt.Rows.Count < 1)
{
return(null);
}
return(dt.Rows[0].ItemArray[0].ToString());
}
//public bool IsUserAdmin(string username)
//{
// DataTable dt2 = new DataTable();
// ExecuteCommandReturnable(_cHolder.GetCommand(SQLiteCommandsHolder.Commands.GetAuthorLevelByName), dt2, ("@u", username));
// string level = dt2.Rows[0].ItemArray[0].ToString();
// return level == "su";
//}
public string GetPasswordHash(string name)
{
var dt = new DataTable();
ExecuteCommandReturnable(_cHolder.GetCommand(SQLiteCommandsHolder.Commands.CheckUser), dt, ("@u", name));
if (dt.Rows.Count < 1)
{
return(null);
}
var hasheddb = dt.Rows[0].ItemArray[0].ToString();
return(hasheddb);
}
