public static User Get(ulong ulUserID)
{
using (WriteSuspender wSus = new WriteSuspender())
using (ReadSuspender rSus = new ReadSuspender())
{
return(SQL.Singleton.Connection.Query <User>(
$"SELECT * FROM Users WHERE {PRIMARY_KEY} = {(long)ulUserID}").FirstOrDefault());
}
}
public User(ulong id)
{
using (WriteSuspender wSus = new WriteSuspender())
{
UserID = id;
Level = Notifications = 1;
Warnings = Messages = XP = XPBoost = Money = Quests = DailyCount = 0;
JoinedDate = DateTime.Now.ToString("d. MM. yyyy");
Daily = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss");
Reroll = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
AssignQuests();
}
}
public static Inventory Get(ulong ulUserID)
{
using (WriteSuspender wSus = new WriteSuspender())
using (ReadSuspender rSus = new ReadSuspender())
return(SQL.Singleton.GetValue <Inventory>(TABLE_NAME, "*", PRIMARY_KEY, (long)ulUserID));
}