public static void CreateNew(string name, string password)
{
SqlBase.Instance("LogonSettings").Execute(
string.Format(
"INSERT INTO `accounts` (`login`, `password`, `banned`, `flags`) VALUES ('{0}', '{1}', '0', '44')",
name, password));
}
public static DataTable QueryAccountInfo(string accountName)
{
DataTable query = null;
try
{
query =
SqlBase.Instance("LogonSettings").Query(string.Format("SELECT * FROM `accounts` WHERE `login` = '{0}'", accountName));
if (query.Rows.Count > 0)
{
return(query);
}
return(null);
}
catch (Exception e)
{
Logging.WriteException(e);
return(null);
}
}
