private void LoadBanList(EstateSettings es) { es.ClearBans(); using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) { dbcon.Open(); using (MySqlCommand cmd = dbcon.CreateCommand()) { cmd.CommandText = "select bannedUUID from estateban where EstateID = ?EstateID"; cmd.Parameters.AddWithValue("?EstateID", es.EstateID); using (IDataReader r = cmd.ExecuteReader()) { while (r.Read()) { EstateBan eb = new EstateBan(); UUID uuid = new UUID(); UUID.TryParse(r["bannedUUID"].ToString(), out uuid); eb.BannedUserID = uuid; eb.BannedHostAddress = "0.0.0.0"; eb.BannedHostIPMask = "0.0.0.0"; es.AddBan(eb); } } } } }
private void LoadBanList(EstateSettings es) { es.ClearBans(); string sql = "select \"bannedUUID\" from estateban where \"EstateID\" = :EstateID"; using (NpgsqlConnection conn = new NpgsqlConnection(m_connectionString)) using (NpgsqlCommand cmd = new NpgsqlCommand(sql, conn)) { NpgsqlParameter idParameter = new NpgsqlParameter("EstateID", DbType.Int32); idParameter.Value = es.EstateID; cmd.Parameters.Add(idParameter); conn.Open(); using (NpgsqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { EstateBan eb = new EstateBan(); eb.BannedUserID = new UUID((Guid)reader["bannedUUID"]); //uuid; eb.BannedHostAddress = "0.0.0.0"; eb.BannedHostIPMask = "0.0.0.0"; es.AddBan(eb); } } } }
public void EstateSettingsMundateTests() { EstateSettings es = new EstateSettings(); es.AddBan(null); UUID bannedUserId = UUID.Random(); es.AddBan(new EstateBan() { BannedHostAddress = string.Empty, BannedHostIPMask = string.Empty, BannedHostNameMask = string.Empty, BannedUserID = bannedUserId} ); Assert.IsTrue(es.IsBanned(bannedUserId), "User Should be banned but is not."); Assert.IsFalse(es.IsBanned(UUID.Zero), "User Should not be banned but is."); es.RemoveBan(bannedUserId); Assert.IsFalse(es.IsBanned(bannedUserId), "User Should not be banned but is."); es.AddEstateManager(UUID.Zero); es.AddEstateManager(bannedUserId); Assert.IsTrue(es.IsEstateManagerOrOwner(bannedUserId), "bannedUserId should be EstateManager but isn't."); es.RemoveEstateManager(bannedUserId); Assert.IsFalse(es.IsEstateManagerOrOwner(bannedUserId), "bannedUserID is estateManager but shouldn't be"); Assert.IsFalse(es.HasAccess(bannedUserId), "bannedUserID has access but shouldn't"); es.AddEstateUser(bannedUserId); Assert.IsTrue(es.HasAccess(bannedUserId), "bannedUserID doesn't have access but should"); es.RemoveEstateUser(bannedUserId); es.AddEstateManager(bannedUserId); Assert.IsTrue(es.HasAccess(bannedUserId), "bannedUserID doesn't have access but should"); Assert.That(es.EstateGroups.Length == 0, "No Estate Groups Added.. so the array should be 0 length"); es.AddEstateGroup(bannedUserId); Assert.That(es.EstateGroups.Length == 1, "1 Estate Groups Added.. so the array should be 1 length"); Assert.That(es.EstateGroups[0] == bannedUserId,"User ID should be in EstateGroups"); }
private void LoadBanList(EstateSettings es) { es.ClearBans(); SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand(); cmd.CommandText = "select bannedUUID from estateban where EstateID = :EstateID"; cmd.Parameters.AddWithValue(":EstateID", es.EstateID); IDataReader r = cmd.ExecuteReader(); while (r.Read()) { EstateBan eb = new EstateBan(); UUID uuid = new UUID(); UUID.TryParse(r["bannedUUID"].ToString(), out uuid); eb.BannedUserID = uuid; eb.BannedHostAddress = "0.0.0.0"; eb.BannedHostIPMask = "0.0.0.0"; es.AddBan(eb); } r.Close(); }
private void LoadBanList(EstateSettings es) { es.ClearBans(); string sql = "select bannedUUID from estateban where EstateID = @EstateID"; using (AutoClosingSqlCommand cmd = _Database.Query(sql)) { SqlParameter idParameter = new SqlParameter("@EstateID", SqlDbType.Int); idParameter.Value = es.EstateID; cmd.Parameters.Add(idParameter); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { EstateBan eb = new EstateBan(); eb.BannedUserID = new UUID((Guid)reader["bannedUUID"]); //uuid; eb.BannedHostAddress = "0.0.0.0"; eb.BannedHostIPMask = "0.0.0.0"; es.AddBan(eb); } } } }