diff options
-rw-r--r-- | OpenSim/Data/PGSQL/PGSQLEstateData.cs | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Data/PGSQL/PGSQLEstateData.cs b/OpenSim/Data/PGSQL/PGSQLEstateData.cs index 5ad0eaa..b5ca235 100644 --- a/OpenSim/Data/PGSQL/PGSQLEstateData.cs +++ b/OpenSim/Data/PGSQL/PGSQLEstateData.cs | |||
@@ -107,8 +107,8 @@ namespace OpenSim.Data.PGSQL | |||
107 | { | 107 | { |
108 | EstateSettings es = new EstateSettings(); | 108 | EstateSettings es = new EstateSettings(); |
109 | 109 | ||
110 | string sql = "select estate_settings.\"" + String.Join("\",estate_settings.\"", FieldList) + | 110 | string sql = "select estate_settings.\"" + String.Join("\",estate_settings.\"", FieldList) + |
111 | "\" from estate_map left join estate_settings on estate_map.\"EstateID\" = estate_settings.\"EstateID\" " + | 111 | "\" from estate_map left join estate_settings on estate_map.\"EstateID\" = estate_settings.\"EstateID\" " + |
112 | " where estate_settings.\"EstateID\" is not null and \"RegionID\" = :RegionID"; | 112 | " where estate_settings.\"EstateID\" is not null and \"RegionID\" = :RegionID"; |
113 | 113 | ||
114 | bool insertEstate = false; | 114 | bool insertEstate = false; |
@@ -500,7 +500,7 @@ namespace OpenSim.Data.PGSQL | |||
500 | public List<int> GetEstatesByOwner(UUID ownerID) | 500 | public List<int> GetEstatesByOwner(UUID ownerID) |
501 | { | 501 | { |
502 | List<int> result = new List<int>(); | 502 | List<int> result = new List<int>(); |
503 | string sql = "select \"estateID\" from estate_settings where \"EstateOwner\" = :EstateOwner"; | 503 | string sql = "select \"EstateID\" from estate_settings where \"EstateOwner\" = :EstateOwner"; |
504 | using (NpgsqlConnection conn = new NpgsqlConnection(m_connectionString)) | 504 | using (NpgsqlConnection conn = new NpgsqlConnection(m_connectionString)) |
505 | { | 505 | { |
506 | conn.Open(); | 506 | conn.Open(); |