public void Login(string username, string password, string token) { try { var req = $"SELECT * FROM users WHERE username = '******' AND password = '******' AND token = '{token}'"; var responseCode = DatabaseProvider.CreateRequest(ConnectionProv.DbaseProvider, req); FormsManaging.TextGenerator(responseCode.Length.ToString()); using (var ms = new MemoryStream(responseCode)) { using (var reader = new BinaryReader(ms)) { var first = reader.ReadByte(); switch (first) { case 0: FormsManaging.TextGenerator("There are some troubles so user can't login"); break; case 1: FormsManaging.TextGenerator($"{username} logged in!"); ConnectionProv.Players.Add(new Player(new PlayerAccountInfo(username, token), new PlayerMultiplayerInfo())); break; } } } } catch (NullReferenceException ex) { FormsManaging.TextGenerator(ex.ToString()); } }
public void CreateAccount(string username, string email, string password) { try { var req = $"INSERT INTO users (username, password, email, regTime, token) VALUES ({username}, {password}, {email}" + $", {DateTime.Now.ToString("s")}, {Guid.NewGuid().ToString()})";//INSERT.InsertRequest("users", Items.GetRegisterList(), Items.SetRegisterList(data)); DatabaseProvider.CreateRequest(ConnectionProv.DbaseProvider, req); } catch (Exception ex) { FormsManaging.TextGenerator(ex.ToString()); } }
public void LogOut(string token) { ConnectionProv.Players.Remove(ConnectionProv.Players.FirstOrDefault(x => x.AccountInfo.Token == token)); DatabaseProvider.CreateRequest(ConnectionProv.DbaseProvider, $"update users set token = '0' where token = '{token}'"); }