public bool LogIn(string user, string pass) { MySqlDataReader res = _DBAdmin.ExecuteQuery( _DBAdmin.CreateQuery(DBQueries.LOG_IN_REQUEST, user, pass)); if (res.HasRows) { res.Close(); return(false); } else { res.Close(); MySqlDataReader res2 = _DBAdmin.ExecuteQuery( _DBAdmin.CreateQuery(DBQueries.GET_CONNECTION_STATE, user)); DataTable dat2 = new DataTable(); dat2.Load(res2); var state = ((string)dat2.Rows[0]["connectedState"]); res2.Close(); return(state != "C"); } }
public void Register() { MySqlDataReader res2 = _DBAdmin.ExecuteQuery(_DBAdmin.CreateQuery(DBQueries.CHECK_USERNAME, userField.text)); if (!res2.HasRows) { res2.Close(); MySqlDataReader res3 = _DBAdmin.ExecuteQuery(_DBAdmin.CreateQuery(DBQueries.REGISTER_REQUEST, userField.text, passField.text)); res3.Close(); print("New User Created."); } else { res2.Close(); print("Username already taken."); } }
public void AddFriend(string user1, string user2) { MySqlDataReader res = _DBAdmin.ExecuteQuery( _DBAdmin.CreateQuery(DBQueries.ADD_FRIEND, user1, user2)); res.Close(); }