diff options
author | Mic Bowman | 2011-04-04 20:04:01 -0700 |
---|---|---|
committer | Mic Bowman | 2011-04-04 20:04:01 -0700 |
commit | d5e0674213dc9ca8fb038d2305e1ff5873b6363d (patch) | |
tree | c101a124fe3b81d4236a5f80589593d6afcb9a23 /OpenSim/Data/SQLiteLegacy | |
parent | Updates NullStorage plugin. (diff) | |
parent | Make the "All Estates" option work from the client (this makes chosen changes... (diff) | |
download | opensim-SC_OLD-d5e0674213dc9ca8fb038d2305e1ff5873b6363d.zip opensim-SC_OLD-d5e0674213dc9ca8fb038d2305e1ff5873b6363d.tar.gz opensim-SC_OLD-d5e0674213dc9ca8fb038d2305e1ff5873b6363d.tar.bz2 opensim-SC_OLD-d5e0674213dc9ca8fb038d2305e1ff5873b6363d.tar.xz |
Merge branch 'master' of ssh://opensimulator.org/var/git/opensim
Diffstat (limited to 'OpenSim/Data/SQLiteLegacy')
-rw-r--r-- | OpenSim/Data/SQLiteLegacy/SQLiteEstateData.cs | 24 |
1 files changed, 23 insertions, 1 deletions
diff --git a/OpenSim/Data/SQLiteLegacy/SQLiteEstateData.cs b/OpenSim/Data/SQLiteLegacy/SQLiteEstateData.cs index ad28c00..4dd225f 100644 --- a/OpenSim/Data/SQLiteLegacy/SQLiteEstateData.cs +++ b/OpenSim/Data/SQLiteLegacy/SQLiteEstateData.cs | |||
@@ -401,7 +401,29 @@ namespace OpenSim.Data.SQLiteLegacy | |||
401 | 401 | ||
402 | return result; | 402 | return result; |
403 | } | 403 | } |
404 | 404 | ||
405 | public List<int> GetEstatesByOwner(UUID ownerID) | ||
406 | { | ||
407 | List<int> result = new List<int>(); | ||
408 | |||
409 | string sql = "select EstateID from estate_settings where estate_settings.EstateOwner = :EstateOwner"; | ||
410 | |||
411 | SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand(); | ||
412 | |||
413 | cmd.CommandText = sql; | ||
414 | cmd.Parameters.Add(":EstateOwner", ownerID); | ||
415 | |||
416 | IDataReader r = cmd.ExecuteReader(); | ||
417 | |||
418 | while (r.Read()) | ||
419 | { | ||
420 | result.Add(Convert.ToInt32(r["EstateID"])); | ||
421 | } | ||
422 | r.Close(); | ||
423 | |||
424 | return result; | ||
425 | } | ||
426 | |||
405 | public bool LinkRegion(UUID regionID, int estateID) | 427 | public bool LinkRegion(UUID regionID, int estateID) |
406 | { | 428 | { |
407 | SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand(); | 429 | SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand(); |