public static User Retrieve(string username, string passwordHash)
{
DbConnection dbconn = Database.GetConnection();
DbCommand command = dbconn.CreateTextCommand("SELECT * FROM Users WHERE Username = @user AND PasswordHash = @pwhash");
command.AddParameter("@user", username);
command.AddParameter("@pwhash", passwordHash);
Log.WriteLine("Username: {0}, PasswordHash: {1}", username, passwordHash);
User user = null;
using (DbDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
user = new User();
user.UID = Convert.ToUInt64(reader["UID"]);
user.Name = reader["Username"] as string;
user.PasswordHash = reader["PasswordHash"] as string;
user.Status = (UserStatus)Convert.ToByte(reader["Status"]);
user.CreateIP = reader["CreateIP"] as string;
}
}
return user;
}
public Player(User user)
{
User = user;
Characters = new List<Character>();
}
public static User Retrieve(ulong uid)
{
DbConnection dbconn = Database.GetConnection();
DbCommand command = dbconn.CreateTextCommand("SELECT * FROM Users WHERE UID = @uid");
command.AddParameter("@uid", uid);
User user = null;
using (DbDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
user = new User();
user.UID = Convert.ToUInt64(reader["UID"]);
user.Name = reader["Username"] as string;
user.PasswordHash = reader["PasswordHash"] as string;
user.Status = (UserStatus)Convert.ToByte(reader["Status"]);
user.CreateIP = reader["CreateIP"] as string;
}
}
return user;
}
