diff options
author | Teravus Ovares | 2008-09-06 07:52:41 +0000 |
---|---|---|
committer | Teravus Ovares | 2008-09-06 07:52:41 +0000 |
commit | 7d89e122930be39e84a6d174548fa2d12ac0484a (patch) | |
tree | e5aa5752f988a9aba2a969f49e5e208985eda80c /OpenSim/Data/SQLite | |
parent | * minor: speculatively try a change to bamboo.build to see if this generates ... (diff) | |
download | opensim-SC-7d89e122930be39e84a6d174548fa2d12ac0484a.zip opensim-SC-7d89e122930be39e84a6d174548fa2d12ac0484a.tar.gz opensim-SC-7d89e122930be39e84a6d174548fa2d12ac0484a.tar.bz2 opensim-SC-7d89e122930be39e84a6d174548fa2d12ac0484a.tar.xz |
* This is the fabled LibOMV update with all of the libOMV types from JHurliman
* This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle.
* This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big!
* Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
Diffstat (limited to 'OpenSim/Data/SQLite')
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteAssetData.cs | 10 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteEstateData.cs | 26 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteGridData.cs | 12 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteInventoryStore.cs | 54 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteManager.cs | 6 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteRegionData.cs | 128 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteUserData.cs | 90 |
7 files changed, 163 insertions, 163 deletions
diff --git a/OpenSim/Data/SQLite/SQLiteAssetData.cs b/OpenSim/Data/SQLite/SQLiteAssetData.cs index 220cebf..8b14f09 100644 --- a/OpenSim/Data/SQLite/SQLiteAssetData.cs +++ b/OpenSim/Data/SQLite/SQLiteAssetData.cs | |||
@@ -28,7 +28,7 @@ | |||
28 | using System; | 28 | using System; |
29 | using System.Data; | 29 | using System.Data; |
30 | using System.Reflection; | 30 | using System.Reflection; |
31 | using libsecondlife; | 31 | using OpenMetaverse; |
32 | using log4net; | 32 | using log4net; |
33 | using Mono.Data.SqliteClient; | 33 | using Mono.Data.SqliteClient; |
34 | using OpenSim.Framework; | 34 | using OpenSim.Framework; |
@@ -87,7 +87,7 @@ namespace OpenSim.Data.SQLite | |||
87 | /// </summary> | 87 | /// </summary> |
88 | /// <param name="uuid">UUID of ... ?</param> | 88 | /// <param name="uuid">UUID of ... ?</param> |
89 | /// <returns>Asset base</returns> | 89 | /// <returns>Asset base</returns> |
90 | override public AssetBase FetchAsset(LLUUID uuid) | 90 | override public AssetBase FetchAsset(UUID uuid) |
91 | { | 91 | { |
92 | lock (this) | 92 | lock (this) |
93 | { | 93 | { |
@@ -190,7 +190,7 @@ namespace OpenSim.Data.SQLite | |||
190 | /// </summary> | 190 | /// </summary> |
191 | /// <param name="uuid">The asset UUID</param> | 191 | /// <param name="uuid">The asset UUID</param> |
192 | /// <returns>True if exist, or false.</returns> | 192 | /// <returns>True if exist, or false.</returns> |
193 | override public bool ExistsAsset(LLUUID uuid) | 193 | override public bool ExistsAsset(UUID uuid) |
194 | { | 194 | { |
195 | lock (this) { | 195 | lock (this) { |
196 | using (SqliteCommand cmd = new SqliteCommand(SelectAssetSQL, m_conn)) | 196 | using (SqliteCommand cmd = new SqliteCommand(SelectAssetSQL, m_conn)) |
@@ -217,7 +217,7 @@ namespace OpenSim.Data.SQLite | |||
217 | /// Delete an asset from database | 217 | /// Delete an asset from database |
218 | /// </summary> | 218 | /// </summary> |
219 | /// <param name="uuid"></param> | 219 | /// <param name="uuid"></param> |
220 | public void DeleteAsset(LLUUID uuid) | 220 | public void DeleteAsset(UUID uuid) |
221 | { | 221 | { |
222 | using (SqliteCommand cmd = new SqliteCommand(DeleteAssetSQL, m_conn)) | 222 | using (SqliteCommand cmd = new SqliteCommand(DeleteAssetSQL, m_conn)) |
223 | { | 223 | { |
@@ -239,7 +239,7 @@ namespace OpenSim.Data.SQLite | |||
239 | // back out. Not enough time to figure it out yet. | 239 | // back out. Not enough time to figure it out yet. |
240 | AssetBase asset = new AssetBase(); | 240 | AssetBase asset = new AssetBase(); |
241 | 241 | ||
242 | asset.FullID = new LLUUID((String) row["UUID"]); | 242 | asset.FullID = new UUID((String) row["UUID"]); |
243 | asset.Name = (String) row["Name"]; | 243 | asset.Name = (String) row["Name"]; |
244 | asset.Description = (String) row["Description"]; | 244 | asset.Description = (String) row["Description"]; |
245 | asset.Type = Convert.ToSByte(row["Type"]); | 245 | asset.Type = Convert.ToSByte(row["Type"]); |
diff --git a/OpenSim/Data/SQLite/SQLiteEstateData.cs b/OpenSim/Data/SQLite/SQLiteEstateData.cs index ffe7644..1245caa 100644 --- a/OpenSim/Data/SQLite/SQLiteEstateData.cs +++ b/OpenSim/Data/SQLite/SQLiteEstateData.cs | |||
@@ -31,7 +31,7 @@ using System.Data; | |||
31 | using System.IO; | 31 | using System.IO; |
32 | using System.Reflection; | 32 | using System.Reflection; |
33 | using System.Threading; | 33 | using System.Threading; |
34 | using libsecondlife; | 34 | using OpenMetaverse; |
35 | using Mono.Data.SqliteClient; | 35 | using Mono.Data.SqliteClient; |
36 | using log4net; | 36 | using log4net; |
37 | using OpenSim.Framework; | 37 | using OpenSim.Framework; |
@@ -83,7 +83,7 @@ namespace OpenSim.Data.SQLite | |||
83 | get { return new List<string>(m_FieldMap.Keys).ToArray(); } | 83 | get { return new List<string>(m_FieldMap.Keys).ToArray(); } |
84 | } | 84 | } |
85 | 85 | ||
86 | public EstateSettings LoadEstateSettings(LLUUID regionID) | 86 | public EstateSettings LoadEstateSettings(UUID regionID) |
87 | { | 87 | { |
88 | EstateSettings es = new EstateSettings(); | 88 | EstateSettings es = new EstateSettings(); |
89 | es.OnSave += StoreEstateSettings; | 89 | es.OnSave += StoreEstateSettings; |
@@ -109,11 +109,11 @@ namespace OpenSim.Data.SQLite | |||
109 | else | 109 | else |
110 | m_FieldMap[name].SetValue(es, false); | 110 | m_FieldMap[name].SetValue(es, false); |
111 | } | 111 | } |
112 | else if (m_FieldMap[name].GetValue(es) is libsecondlife.LLUUID) | 112 | else if(m_FieldMap[name].GetValue(es) is OpenMetaverse.UUID) |
113 | { | 113 | { |
114 | LLUUID uuid = LLUUID.Zero; | 114 | UUID uuid = UUID.Zero; |
115 | 115 | ||
116 | LLUUID.TryParse(r[name].ToString(), out uuid); | 116 | UUID.TryParse(r[name].ToString(), out uuid); |
117 | m_FieldMap[name].SetValue(es, uuid); | 117 | m_FieldMap[name].SetValue(es, uuid); |
118 | } | 118 | } |
119 | else | 119 | else |
@@ -258,8 +258,8 @@ namespace OpenSim.Data.SQLite | |||
258 | { | 258 | { |
259 | EstateBan eb = new EstateBan(); | 259 | EstateBan eb = new EstateBan(); |
260 | 260 | ||
261 | LLUUID uuid = new LLUUID(); | 261 | UUID uuid = new UUID(); |
262 | LLUUID.TryParse(r["bannedUUID"].ToString(), out uuid); | 262 | UUID.TryParse(r["bannedUUID"].ToString(), out uuid); |
263 | 263 | ||
264 | eb.bannedUUID = uuid; | 264 | eb.bannedUUID = uuid; |
265 | eb.bannedIP = "0.0.0.0"; | 265 | eb.bannedIP = "0.0.0.0"; |
@@ -292,7 +292,7 @@ namespace OpenSim.Data.SQLite | |||
292 | } | 292 | } |
293 | } | 293 | } |
294 | 294 | ||
295 | void SaveUUIDList(uint EstateID, string table, LLUUID[] data) | 295 | void SaveUUIDList(uint EstateID, string table, UUID[] data) |
296 | { | 296 | { |
297 | SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand(); | 297 | SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand(); |
298 | 298 | ||
@@ -305,7 +305,7 @@ namespace OpenSim.Data.SQLite | |||
305 | 305 | ||
306 | cmd.CommandText = "insert into "+table+" (EstateID, uuid) values ( :EstateID, :uuid )"; | 306 | cmd.CommandText = "insert into "+table+" (EstateID, uuid) values ( :EstateID, :uuid )"; |
307 | 307 | ||
308 | foreach (LLUUID uuid in data) | 308 | foreach (UUID uuid in data) |
309 | { | 309 | { |
310 | cmd.Parameters.Add(":EstateID", EstateID.ToString()); | 310 | cmd.Parameters.Add(":EstateID", EstateID.ToString()); |
311 | cmd.Parameters.Add(":uuid", uuid.ToString()); | 311 | cmd.Parameters.Add(":uuid", uuid.ToString()); |
@@ -315,9 +315,9 @@ namespace OpenSim.Data.SQLite | |||
315 | } | 315 | } |
316 | } | 316 | } |
317 | 317 | ||
318 | LLUUID[] LoadUUIDList(uint EstateID, string table) | 318 | UUID[] LoadUUIDList(uint EstateID, string table) |
319 | { | 319 | { |
320 | List<LLUUID> uuids = new List<LLUUID>(); | 320 | List<UUID> uuids = new List<UUID>(); |
321 | 321 | ||
322 | SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand(); | 322 | SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand(); |
323 | 323 | ||
@@ -330,8 +330,8 @@ namespace OpenSim.Data.SQLite | |||
330 | { | 330 | { |
331 | // EstateBan eb = new EstateBan(); | 331 | // EstateBan eb = new EstateBan(); |
332 | 332 | ||
333 | LLUUID uuid = new LLUUID(); | 333 | UUID uuid = new UUID(); |
334 | LLUUID.TryParse(r["uuid"].ToString(), out uuid); | 334 | UUID.TryParse(r["uuid"].ToString(), out uuid); |
335 | 335 | ||
336 | uuids.Add(uuid); | 336 | uuids.Add(uuid); |
337 | } | 337 | } |
diff --git a/OpenSim/Data/SQLite/SQLiteGridData.cs b/OpenSim/Data/SQLite/SQLiteGridData.cs index 8c4574e..f715c0e 100644 --- a/OpenSim/Data/SQLite/SQLiteGridData.cs +++ b/OpenSim/Data/SQLite/SQLiteGridData.cs | |||
@@ -31,7 +31,7 @@ using System.Data; | |||
31 | using System.Reflection; | 31 | using System.Reflection; |
32 | using System.Security.Cryptography; | 32 | using System.Security.Cryptography; |
33 | using System.Text; | 33 | using System.Text; |
34 | using libsecondlife; | 34 | using OpenMetaverse; |
35 | using log4net; | 35 | using log4net; |
36 | using OpenSim.Framework; | 36 | using OpenSim.Framework; |
37 | 37 | ||
@@ -162,7 +162,7 @@ namespace OpenSim.Data.SQLite | |||
162 | /// </summary> | 162 | /// </summary> |
163 | /// <param name="uuid">The region UUID</param> | 163 | /// <param name="uuid">The region UUID</param> |
164 | /// <returns>The sim profile</returns> | 164 | /// <returns>The sim profile</returns> |
165 | override public RegionProfileData GetProfileByLLUUID(LLUUID uuid) | 165 | override public RegionProfileData GetProfileByUUID(UUID uuid) |
166 | { | 166 | { |
167 | Dictionary<string, string> param = new Dictionary<string, string>(); | 167 | Dictionary<string, string> param = new Dictionary<string, string>(); |
168 | param["uuid"] = uuid.ToString(); | 168 | param["uuid"] = uuid.ToString(); |
@@ -181,7 +181,7 @@ namespace OpenSim.Data.SQLite | |||
181 | /// Returns a list of avatar and UUIDs that match the query | 181 | /// Returns a list of avatar and UUIDs that match the query |
182 | /// </summary> | 182 | /// </summary> |
183 | /// <remarks>do nothing yet</remarks> | 183 | /// <remarks>do nothing yet</remarks> |
184 | public List<AvatarPickerAvatar> GeneratePickerResults(LLUUID queryID, string query) | 184 | public List<AvatarPickerAvatar> GeneratePickerResults(UUID queryID, string query) |
185 | { | 185 | { |
186 | //Do nothing yet | 186 | //Do nothing yet |
187 | List<AvatarPickerAvatar> returnlist = new List<AvatarPickerAvatar>(); | 187 | List<AvatarPickerAvatar> returnlist = new List<AvatarPickerAvatar>(); |
@@ -217,14 +217,14 @@ namespace OpenSim.Data.SQLite | |||
217 | /// <param name="handle">The attempted regionHandle of the challenger</param> | 217 | /// <param name="handle">The attempted regionHandle of the challenger</param> |
218 | /// <param name="authkey">The secret</param> | 218 | /// <param name="authkey">The secret</param> |
219 | /// <returns>Whether the secret and regionhandle match the database entry for UUID</returns> | 219 | /// <returns>Whether the secret and regionhandle match the database entry for UUID</returns> |
220 | override public bool AuthenticateSim(LLUUID uuid, ulong handle, string authkey) | 220 | override public bool AuthenticateSim(UUID uuid, ulong handle, string authkey) |
221 | { | 221 | { |
222 | bool throwHissyFit = false; // Should be true by 1.0 | 222 | bool throwHissyFit = false; // Should be true by 1.0 |
223 | 223 | ||
224 | if (throwHissyFit) | 224 | if (throwHissyFit) |
225 | throw new Exception("CRYPTOWEAK AUTHENTICATE: Refusing to authenticate due to replay potential."); | 225 | throw new Exception("CRYPTOWEAK AUTHENTICATE: Refusing to authenticate due to replay potential."); |
226 | 226 | ||
227 | RegionProfileData data = GetProfileByLLUUID(uuid); | 227 | RegionProfileData data = GetProfileByUUID(uuid); |
228 | 228 | ||
229 | return (handle == data.regionHandle && authkey == data.regionSecret); | 229 | return (handle == data.regionHandle && authkey == data.regionSecret); |
230 | } | 230 | } |
@@ -238,7 +238,7 @@ namespace OpenSim.Data.SQLite | |||
238 | /// <param name="authhash"></param> | 238 | /// <param name="authhash"></param> |
239 | /// <param name="challenge"></param> | 239 | /// <param name="challenge"></param> |
240 | /// <returns></returns> | 240 | /// <returns></returns> |
241 | public bool AuthenticateSim(LLUUID uuid, ulong handle, string authhash, string challenge) | 241 | public bool AuthenticateSim(UUID uuid, ulong handle, string authhash, string challenge) |
242 | { | 242 | { |
243 | // SHA512Managed HashProvider = new SHA512Managed(); | 243 | // SHA512Managed HashProvider = new SHA512Managed(); |
244 | // Encoding TextProvider = new UTF8Encoding(); | 244 | // Encoding TextProvider = new UTF8Encoding(); |
diff --git a/OpenSim/Data/SQLite/SQLiteInventoryStore.cs b/OpenSim/Data/SQLite/SQLiteInventoryStore.cs index 4c35ac2..ca7e612 100644 --- a/OpenSim/Data/SQLite/SQLiteInventoryStore.cs +++ b/OpenSim/Data/SQLite/SQLiteInventoryStore.cs | |||
@@ -29,7 +29,7 @@ using System; | |||
29 | using System.Collections.Generic; | 29 | using System.Collections.Generic; |
30 | using System.Data; | 30 | using System.Data; |
31 | using System.Reflection; | 31 | using System.Reflection; |
32 | using libsecondlife; | 32 | using OpenMetaverse; |
33 | using log4net; | 33 | using log4net; |
34 | using Mono.Data.SqliteClient; | 34 | using Mono.Data.SqliteClient; |
35 | using OpenSim.Framework; | 35 | using OpenSim.Framework; |
@@ -109,13 +109,13 @@ namespace OpenSim.Data.SQLite | |||
109 | public InventoryItemBase buildItem(DataRow row) | 109 | public InventoryItemBase buildItem(DataRow row) |
110 | { | 110 | { |
111 | InventoryItemBase item = new InventoryItemBase(); | 111 | InventoryItemBase item = new InventoryItemBase(); |
112 | item.ID = new LLUUID((string) row["UUID"]); | 112 | item.ID = new UUID((string) row["UUID"]); |
113 | item.AssetID = new LLUUID((string) row["assetID"]); | 113 | item.AssetID = new UUID((string) row["assetID"]); |
114 | item.AssetType = Convert.ToInt32(row["assetType"]); | 114 | item.AssetType = Convert.ToInt32(row["assetType"]); |
115 | item.InvType = Convert.ToInt32(row["invType"]); | 115 | item.InvType = Convert.ToInt32(row["invType"]); |
116 | item.Folder = new LLUUID((string) row["parentFolderID"]); | 116 | item.Folder = new UUID((string) row["parentFolderID"]); |
117 | item.Owner = new LLUUID((string) row["avatarID"]); | 117 | item.Owner = new UUID((string) row["avatarID"]); |
118 | item.Creator = new LLUUID((string) row["creatorsID"]); | 118 | item.Creator = new UUID((string) row["creatorsID"]); |
119 | item.Name = (string) row["inventoryName"]; | 119 | item.Name = (string) row["inventoryName"]; |
120 | item.Description = (string) row["inventoryDescription"]; | 120 | item.Description = (string) row["inventoryDescription"]; |
121 | 121 | ||
@@ -135,7 +135,7 @@ namespace OpenSim.Data.SQLite | |||
135 | item.CreationDate = Convert.ToInt32(row["creationDate"]); | 135 | item.CreationDate = Convert.ToInt32(row["creationDate"]); |
136 | 136 | ||
137 | if (!Convert.IsDBNull(row["groupID"])) | 137 | if (!Convert.IsDBNull(row["groupID"])) |
138 | item.GroupID = new LLUUID((string)row["groupID"]); | 138 | item.GroupID = new UUID((string)row["groupID"]); |
139 | 139 | ||
140 | if (!Convert.IsDBNull(row["groupOwned"])) | 140 | if (!Convert.IsDBNull(row["groupOwned"])) |
141 | item.GroupOwned = Convert.ToBoolean(row["groupOwned"]); | 141 | item.GroupOwned = Convert.ToBoolean(row["groupOwned"]); |
@@ -317,7 +317,7 @@ namespace OpenSim.Data.SQLite | |||
317 | /// </summary> | 317 | /// </summary> |
318 | /// <param name="folderID">The UUID of the target folder</param> | 318 | /// <param name="folderID">The UUID of the target folder</param> |
319 | /// <returns>A List of InventoryItemBase items</returns> | 319 | /// <returns>A List of InventoryItemBase items</returns> |
320 | public List<InventoryItemBase> getInventoryInFolder(LLUUID folderID) | 320 | public List<InventoryItemBase> getInventoryInFolder(UUID folderID) |
321 | { | 321 | { |
322 | lock (ds) | 322 | lock (ds) |
323 | { | 323 | { |
@@ -339,20 +339,20 @@ namespace OpenSim.Data.SQLite | |||
339 | /// </summary> | 339 | /// </summary> |
340 | /// <param name="user">The user whos inventory is to be searched</param> | 340 | /// <param name="user">The user whos inventory is to be searched</param> |
341 | /// <returns>A list of folder objects</returns> | 341 | /// <returns>A list of folder objects</returns> |
342 | public List<InventoryFolderBase> getUserRootFolders(LLUUID user) | 342 | public List<InventoryFolderBase> getUserRootFolders(UUID user) |
343 | { | 343 | { |
344 | return new List<InventoryFolderBase>(); | 344 | return new List<InventoryFolderBase>(); |
345 | } | 345 | } |
346 | 346 | ||
347 | // see InventoryItemBase.getUserRootFolder | 347 | // see InventoryItemBase.getUserRootFolder |
348 | public InventoryFolderBase getUserRootFolder(LLUUID user) | 348 | public InventoryFolderBase getUserRootFolder(UUID user) |
349 | { | 349 | { |
350 | lock (ds) | 350 | lock (ds) |
351 | { | 351 | { |
352 | List<InventoryFolderBase> folders = new List<InventoryFolderBase>(); | 352 | List<InventoryFolderBase> folders = new List<InventoryFolderBase>(); |
353 | DataTable inventoryFolderTable = ds.Tables["inventoryfolders"]; | 353 | DataTable inventoryFolderTable = ds.Tables["inventoryfolders"]; |
354 | string selectExp = "agentID = '" + Util.ToRawUuidString(user) + "' AND parentID = '" + | 354 | string selectExp = "agentID = '" + Util.ToRawUuidString(user) + "' AND parentID = '" + |
355 | Util.ToRawUuidString(LLUUID.Zero) + "'"; | 355 | Util.ToRawUuidString(UUID.Zero) + "'"; |
356 | DataRow[] rows = inventoryFolderTable.Select(selectExp); | 356 | DataRow[] rows = inventoryFolderTable.Select(selectExp); |
357 | foreach (DataRow row in rows) | 357 | foreach (DataRow row in rows) |
358 | { | 358 | { |
@@ -378,7 +378,7 @@ namespace OpenSim.Data.SQLite | |||
378 | /// </summary> | 378 | /// </summary> |
379 | /// <param name="folders">list where folders will be appended</param> | 379 | /// <param name="folders">list where folders will be appended</param> |
380 | /// <param name="parentID">ID of parent</param> | 380 | /// <param name="parentID">ID of parent</param> |
381 | protected void getInventoryFolders(ref List<InventoryFolderBase> folders, LLUUID parentID) | 381 | protected void getInventoryFolders(ref List<InventoryFolderBase> folders, UUID parentID) |
382 | { | 382 | { |
383 | lock (ds) | 383 | lock (ds) |
384 | { | 384 | { |
@@ -398,7 +398,7 @@ namespace OpenSim.Data.SQLite | |||
398 | /// </summary> | 398 | /// </summary> |
399 | /// <param name="parentID">The folder to get subfolders for</param> | 399 | /// <param name="parentID">The folder to get subfolders for</param> |
400 | /// <returns>A list of inventory folders</returns> | 400 | /// <returns>A list of inventory folders</returns> |
401 | public List<InventoryFolderBase> getInventoryFolders(LLUUID parentID) | 401 | public List<InventoryFolderBase> getInventoryFolders(UUID parentID) |
402 | { | 402 | { |
403 | List<InventoryFolderBase> folders = new List<InventoryFolderBase>(); | 403 | List<InventoryFolderBase> folders = new List<InventoryFolderBase>(); |
404 | getInventoryFolders(ref folders, Util.ToRawUuidString(parentID)); | 404 | getInventoryFolders(ref folders, Util.ToRawUuidString(parentID)); |
@@ -410,7 +410,7 @@ namespace OpenSim.Data.SQLite | |||
410 | /// </summary> | 410 | /// </summary> |
411 | /// <param name="parentID"></param> | 411 | /// <param name="parentID"></param> |
412 | /// <returns></returns> | 412 | /// <returns></returns> |
413 | public List<InventoryFolderBase> getFolderHierarchy(LLUUID parentID) | 413 | public List<InventoryFolderBase> getFolderHierarchy(UUID parentID) |
414 | { | 414 | { |
415 | /* Note: There are subtle changes between this implementation of getFolderHierarchy and the previous one | 415 | /* Note: There are subtle changes between this implementation of getFolderHierarchy and the previous one |
416 | * - We will only need to hit the database twice instead of n times. | 416 | * - We will only need to hit the database twice instead of n times. |
@@ -441,7 +441,7 @@ namespace OpenSim.Data.SQLite | |||
441 | if (parentRow.GetLength(0) >= 1) // No result means parent folder does not exist | 441 | if (parentRow.GetLength(0) >= 1) // No result means parent folder does not exist |
442 | { | 442 | { |
443 | parentFolder = buildFolder(parentRow[0]); | 443 | parentFolder = buildFolder(parentRow[0]); |
444 | LLUUID agentID = parentFolder.Owner; | 444 | UUID agentID = parentFolder.Owner; |
445 | selectExp = "agentID = '" + Util.ToRawUuidString(agentID) + "'"; | 445 | selectExp = "agentID = '" + Util.ToRawUuidString(agentID) + "'"; |
446 | folderRows = inventoryFolderTable.Select(selectExp); | 446 | folderRows = inventoryFolderTable.Select(selectExp); |
447 | } | 447 | } |
@@ -451,7 +451,7 @@ namespace OpenSim.Data.SQLite | |||
451 | /* if we're querying the root folder, just return an unordered list of all folders in the user's | 451 | /* if we're querying the root folder, just return an unordered list of all folders in the user's |
452 | * inventory | 452 | * inventory |
453 | */ | 453 | */ |
454 | if (parentFolder.ParentID == LLUUID.Zero) | 454 | if (parentFolder.ParentID == UUID.Zero) |
455 | { | 455 | { |
456 | foreach (DataRow row in folderRows) | 456 | foreach (DataRow row in folderRows) |
457 | { | 457 | { |
@@ -470,13 +470,13 @@ namespace OpenSim.Data.SQLite | |||
470 | { // Querying a non-root folder | 470 | { // Querying a non-root folder |
471 | 471 | ||
472 | // Build a hash table of all user's inventory folders, indexed by each folder's parent ID | 472 | // Build a hash table of all user's inventory folders, indexed by each folder's parent ID |
473 | Dictionary<LLUUID, List<InventoryFolderBase>> hashtable = | 473 | Dictionary<UUID, List<InventoryFolderBase>> hashtable = |
474 | new Dictionary<LLUUID, List<InventoryFolderBase>>(folderRows.GetLength(0)); | 474 | new Dictionary<UUID, List<InventoryFolderBase>>(folderRows.GetLength(0)); |
475 | 475 | ||
476 | foreach (DataRow row in folderRows) | 476 | foreach (DataRow row in folderRows) |
477 | { | 477 | { |
478 | InventoryFolderBase curFolder = buildFolder(row); | 478 | InventoryFolderBase curFolder = buildFolder(row); |
479 | if (curFolder.ParentID != LLUUID.Zero) // Discard root of tree - not needed | 479 | if (curFolder.ParentID != UUID.Zero) // Discard root of tree - not needed |
480 | { | 480 | { |
481 | if (hashtable.ContainsKey(curFolder.ParentID)) | 481 | if (hashtable.ContainsKey(curFolder.ParentID)) |
482 | { | 482 | { |
@@ -514,7 +514,7 @@ namespace OpenSim.Data.SQLite | |||
514 | /// </summary> | 514 | /// </summary> |
515 | /// <param name="item">The UUID of the item to be returned</param> | 515 | /// <param name="item">The UUID of the item to be returned</param> |
516 | /// <returns>A class containing item information</returns> | 516 | /// <returns>A class containing item information</returns> |
517 | public InventoryItemBase getInventoryItem(LLUUID item) | 517 | public InventoryItemBase getInventoryItem(UUID item) |
518 | { | 518 | { |
519 | lock (ds) | 519 | lock (ds) |
520 | { | 520 | { |
@@ -535,7 +535,7 @@ namespace OpenSim.Data.SQLite | |||
535 | /// </summary> | 535 | /// </summary> |
536 | /// <param name="folder">The UUID of the folder to be returned</param> | 536 | /// <param name="folder">The UUID of the folder to be returned</param> |
537 | /// <returns>A class containing folder information</returns> | 537 | /// <returns>A class containing folder information</returns> |
538 | public InventoryFolderBase getInventoryFolder(LLUUID folder) | 538 | public InventoryFolderBase getInventoryFolder(UUID folder) |
539 | { | 539 | { |
540 | // TODO: Deep voodoo here. If you enable this code then | 540 | // TODO: Deep voodoo here. If you enable this code then |
541 | // multi region breaks. No idea why, but I figured it was | 541 | // multi region breaks. No idea why, but I figured it was |
@@ -578,7 +578,7 @@ namespace OpenSim.Data.SQLite | |||
578 | /// Delete an inventory item | 578 | /// Delete an inventory item |
579 | /// </summary> | 579 | /// </summary> |
580 | /// <param name="item">The item UUID</param> | 580 | /// <param name="item">The item UUID</param> |
581 | public void deleteInventoryItem(LLUUID itemID) | 581 | public void deleteInventoryItem(UUID itemID) |
582 | { | 582 | { |
583 | lock (ds) | 583 | lock (ds) |
584 | { | 584 | { |
@@ -599,7 +599,7 @@ namespace OpenSim.Data.SQLite | |||
599 | /// </summary> | 599 | /// </summary> |
600 | /// <param name="folderId">id of the folder, whose item content should be deleted</param> | 600 | /// <param name="folderId">id of the folder, whose item content should be deleted</param> |
601 | /// <todo>this is horribly inefficient, but I don't want to ruin the overall structure of this implementation</todo> | 601 | /// <todo>this is horribly inefficient, but I don't want to ruin the overall structure of this implementation</todo> |
602 | private void deleteItemsInFolder(LLUUID folderId) | 602 | private void deleteItemsInFolder(UUID folderId) |
603 | { | 603 | { |
604 | List<InventoryItemBase> items = getInventoryInFolder(Util.ToRawUuidString(folderId)); | 604 | List<InventoryItemBase> items = getInventoryInFolder(Util.ToRawUuidString(folderId)); |
605 | 605 | ||
@@ -641,7 +641,7 @@ namespace OpenSim.Data.SQLite | |||
641 | /// This will clean-up any child folders and child items as well | 641 | /// This will clean-up any child folders and child items as well |
642 | /// </remarks> | 642 | /// </remarks> |
643 | /// <param name="folderID">the folder UUID</param> | 643 | /// <param name="folderID">the folder UUID</param> |
644 | public void deleteInventoryFolder(LLUUID folderID) | 644 | public void deleteInventoryFolder(UUID folderID) |
645 | { | 645 | { |
646 | lock (ds) | 646 | lock (ds) |
647 | { | 647 | { |
@@ -791,10 +791,10 @@ namespace OpenSim.Data.SQLite | |||
791 | private static InventoryFolderBase buildFolder(DataRow row) | 791 | private static InventoryFolderBase buildFolder(DataRow row) |
792 | { | 792 | { |
793 | InventoryFolderBase folder = new InventoryFolderBase(); | 793 | InventoryFolderBase folder = new InventoryFolderBase(); |
794 | folder.ID = new LLUUID((string) row["UUID"]); | 794 | folder.ID = new UUID((string) row["UUID"]); |
795 | folder.Name = (string) row["name"]; | 795 | folder.Name = (string) row["name"]; |
796 | folder.Owner = new LLUUID((string) row["agentID"]); | 796 | folder.Owner = new UUID((string) row["agentID"]); |
797 | folder.ParentID = new LLUUID((string) row["parentID"]); | 797 | folder.ParentID = new UUID((string) row["parentID"]); |
798 | folder.Type = Convert.ToInt16(row["type"]); | 798 | folder.Type = Convert.ToInt16(row["type"]); |
799 | folder.Version = Convert.ToUInt16(row["version"]); | 799 | folder.Version = Convert.ToUInt16(row["version"]); |
800 | return folder; | 800 | return folder; |
diff --git a/OpenSim/Data/SQLite/SQLiteManager.cs b/OpenSim/Data/SQLite/SQLiteManager.cs index 46c40e5..4a7e910 100644 --- a/OpenSim/Data/SQLite/SQLiteManager.cs +++ b/OpenSim/Data/SQLite/SQLiteManager.cs | |||
@@ -30,7 +30,7 @@ using System.Collections.Generic; | |||
30 | using System.Data; | 30 | using System.Data; |
31 | using System.Data.SQLite; | 31 | using System.Data.SQLite; |
32 | using System.Reflection; | 32 | using System.Reflection; |
33 | using libsecondlife; | 33 | using OpenMetaverse; |
34 | using log4net; | 34 | using log4net; |
35 | 35 | ||
36 | namespace OpenSim.Data.SQLite | 36 | namespace OpenSim.Data.SQLite |
@@ -118,7 +118,7 @@ namespace OpenSim.Data.SQLite | |||
118 | // Region Main | 118 | // Region Main |
119 | retval.regionHandle = (ulong) reader["regionHandle"]; | 119 | retval.regionHandle = (ulong) reader["regionHandle"]; |
120 | retval.regionName = (string) reader["regionName"]; | 120 | retval.regionName = (string) reader["regionName"]; |
121 | retval.UUID = new LLUUID((string) reader["uuid"]); | 121 | retval.UUID = new UUID((string) reader["uuid"]); |
122 | 122 | ||
123 | // Secrets | 123 | // Secrets |
124 | retval.regionRecvKey = (string) reader["regionRecvKey"]; | 124 | retval.regionRecvKey = (string) reader["regionRecvKey"]; |
@@ -182,7 +182,7 @@ namespace OpenSim.Data.SQLite | |||
182 | 182 | ||
183 | parameters["regionHandle"] = profile.regionHandle.ToString(); | 183 | parameters["regionHandle"] = profile.regionHandle.ToString(); |
184 | parameters["regionName"] = profile.regionName; | 184 | parameters["regionName"] = profile.regionName; |
185 | parameters["uuid"] = profile.UUID.ToString(); | 185 | parameters["uuid"] = profile.ToString(); |
186 | parameters["regionRecvKey"] = profile.regionRecvKey; | 186 | parameters["regionRecvKey"] = profile.regionRecvKey; |
187 | parameters["regionSendKey"] = profile.regionSendKey; | 187 | parameters["regionSendKey"] = profile.regionSendKey; |
188 | parameters["regionDataURI"] = profile.regionDataURI; | 188 | parameters["regionDataURI"] = profile.regionDataURI; |
diff --git a/OpenSim/Data/SQLite/SQLiteRegionData.cs b/OpenSim/Data/SQLite/SQLiteRegionData.cs index dd88751..bb441f6 100644 --- a/OpenSim/Data/SQLite/SQLiteRegionData.cs +++ b/OpenSim/Data/SQLite/SQLiteRegionData.cs | |||
@@ -31,7 +31,7 @@ using System.Data; | |||
31 | using System.IO; | 31 | using System.IO; |
32 | using System.Reflection; | 32 | using System.Reflection; |
33 | using System.Threading; | 33 | using System.Threading; |
34 | using libsecondlife; | 34 | using OpenMetaverse; |
35 | using log4net; | 35 | using log4net; |
36 | using Mono.Data.SqliteClient; | 36 | using Mono.Data.SqliteClient; |
37 | using OpenSim.Framework; | 37 | using OpenSim.Framework; |
@@ -190,7 +190,7 @@ namespace OpenSim.Data.SQLite | |||
190 | { | 190 | { |
191 | } | 191 | } |
192 | 192 | ||
193 | public RegionSettings LoadRegionSettings(LLUUID regionUUID) | 193 | public RegionSettings LoadRegionSettings(UUID regionUUID) |
194 | { | 194 | { |
195 | return null; | 195 | return null; |
196 | } | 196 | } |
@@ -200,15 +200,15 @@ namespace OpenSim.Data.SQLite | |||
200 | /// </summary> | 200 | /// </summary> |
201 | /// <param name="obj">the object</param> | 201 | /// <param name="obj">the object</param> |
202 | /// <param name="regionUUID">the region UUID</param> | 202 | /// <param name="regionUUID">the region UUID</param> |
203 | public void StoreObject(SceneObjectGroup obj, LLUUID regionUUID) | 203 | public void StoreObject(SceneObjectGroup obj, UUID regionUUID) |
204 | { | 204 | { |
205 | lock (ds) | 205 | lock (ds) |
206 | { | 206 | { |
207 | foreach (SceneObjectPart prim in obj.Children.Values) | 207 | foreach (SceneObjectPart prim in obj.Children.Values) |
208 | { | 208 | { |
209 | if ((prim.GetEffectiveObjectFlags() & (uint)LLObject.ObjectFlags.Physics) == 0 | 209 | if ((prim.GetEffectiveObjectFlags() & (uint)PrimFlags.Physics) == 0 |
210 | && (prim.GetEffectiveObjectFlags() & (uint)LLObject.ObjectFlags.Temporary) == 0 | 210 | && (prim.GetEffectiveObjectFlags() & (uint)PrimFlags.Temporary) == 0 |
211 | && (prim.GetEffectiveObjectFlags() & (uint)LLObject.ObjectFlags.TemporaryOnRez) == 0) | 211 | && (prim.GetEffectiveObjectFlags() & (uint)PrimFlags.TemporaryOnRez) == 0) |
212 | { | 212 | { |
213 | //m_log.Info("[REGION DB]: Adding obj: " + obj.UUID + " to region: " + regionUUID); | 213 | //m_log.Info("[REGION DB]: Adding obj: " + obj.UUID + " to region: " + regionUUID); |
214 | addPrim(prim, Util.ToRawUuidString(obj.UUID), Util.ToRawUuidString(regionUUID)); | 214 | addPrim(prim, Util.ToRawUuidString(obj.UUID), Util.ToRawUuidString(regionUUID)); |
@@ -235,9 +235,9 @@ namespace OpenSim.Data.SQLite | |||
235 | /// </summary> | 235 | /// </summary> |
236 | /// <param name="obj">the object</param> | 236 | /// <param name="obj">the object</param> |
237 | /// <param name="regionUUID">the region UUID</param> | 237 | /// <param name="regionUUID">the region UUID</param> |
238 | public void RemoveObject(LLUUID obj, LLUUID regionUUID) | 238 | public void RemoveObject(UUID obj, UUID regionUUID) |
239 | { | 239 | { |
240 | m_log.InfoFormat("[REGION DB]: Removing obj: {0} from region: {1}", obj.UUID, regionUUID); | 240 | m_log.InfoFormat("[REGION DB]: Removing obj: {0} from region: {1}", obj.Guid, regionUUID); |
241 | 241 | ||
242 | DataTable prims = ds.Tables["prims"]; | 242 | DataTable prims = ds.Tables["prims"]; |
243 | DataTable shapes = ds.Tables["primshapes"]; | 243 | DataTable shapes = ds.Tables["primshapes"]; |
@@ -249,7 +249,7 @@ namespace OpenSim.Data.SQLite | |||
249 | foreach (DataRow row in primRows) | 249 | foreach (DataRow row in primRows) |
250 | { | 250 | { |
251 | // Remove shape rows | 251 | // Remove shape rows |
252 | LLUUID uuid = new LLUUID((string) row["UUID"]); | 252 | UUID uuid = new UUID((string) row["UUID"]); |
253 | DataRow shapeRow = shapes.Rows.Find(Util.ToRawUuidString(uuid)); | 253 | DataRow shapeRow = shapes.Rows.Find(Util.ToRawUuidString(uuid)); |
254 | if (shapeRow != null) | 254 | if (shapeRow != null) |
255 | { | 255 | { |
@@ -271,7 +271,7 @@ namespace OpenSim.Data.SQLite | |||
271 | /// The caller must acquire the necessrary synchronization locks and commit or rollback changes. | 271 | /// The caller must acquire the necessrary synchronization locks and commit or rollback changes. |
272 | /// </summary> | 272 | /// </summary> |
273 | /// <param name="uuid">The item UUID</param> | 273 | /// <param name="uuid">The item UUID</param> |
274 | private void RemoveItems(LLUUID uuid) | 274 | private void RemoveItems(UUID uuid) |
275 | { | 275 | { |
276 | DataTable items = ds.Tables["primitems"]; | 276 | DataTable items = ds.Tables["primitems"]; |
277 | 277 | ||
@@ -289,9 +289,9 @@ namespace OpenSim.Data.SQLite | |||
289 | /// </summary> | 289 | /// </summary> |
290 | /// <param name="regionUUID">The region UUID</param> | 290 | /// <param name="regionUUID">The region UUID</param> |
291 | /// <returns>List of loaded groups</returns> | 291 | /// <returns>List of loaded groups</returns> |
292 | public List<SceneObjectGroup> LoadObjects(LLUUID regionUUID) | 292 | public List<SceneObjectGroup> LoadObjects(UUID regionUUID) |
293 | { | 293 | { |
294 | Dictionary<LLUUID, SceneObjectGroup> createdObjects = new Dictionary<LLUUID, SceneObjectGroup>(); | 294 | Dictionary<UUID, SceneObjectGroup> createdObjects = new Dictionary<UUID, SceneObjectGroup>(); |
295 | 295 | ||
296 | List<SceneObjectGroup> retvals = new List<SceneObjectGroup>(); | 296 | List<SceneObjectGroup> retvals = new List<SceneObjectGroup>(); |
297 | 297 | ||
@@ -350,7 +350,7 @@ namespace OpenSim.Data.SQLite | |||
350 | "[REGION DB]: No shape found for prim in storage, so setting default box shape"); | 350 | "[REGION DB]: No shape found for prim in storage, so setting default box shape"); |
351 | prim.Shape = PrimitiveBaseShape.Default; | 351 | prim.Shape = PrimitiveBaseShape.Default; |
352 | } | 352 | } |
353 | createdObjects[new LLUUID(objID)].AddPart(prim); | 353 | createdObjects[new UUID(objID)].AddPart(prim); |
354 | } | 354 | } |
355 | 355 | ||
356 | LoadItems(prim); | 356 | LoadItems(prim); |
@@ -379,7 +379,7 @@ namespace OpenSim.Data.SQLite | |||
379 | 379 | ||
380 | DataTable dbItems = ds.Tables["primitems"]; | 380 | DataTable dbItems = ds.Tables["primitems"]; |
381 | 381 | ||
382 | String sql = String.Format("primID = '{0}'", prim.UUID.ToString()); | 382 | String sql = String.Format("primID = '{0}'", prim.ToString()); |
383 | DataRow[] dbItemRows = dbItems.Select(sql); | 383 | DataRow[] dbItemRows = dbItems.Select(sql); |
384 | 384 | ||
385 | IList<TaskInventoryItem> inventory = new List<TaskInventoryItem>(); | 385 | IList<TaskInventoryItem> inventory = new List<TaskInventoryItem>(); |
@@ -407,7 +407,7 @@ namespace OpenSim.Data.SQLite | |||
407 | /// </summary> | 407 | /// </summary> |
408 | /// <param name="ter">terrain heightfield</param> | 408 | /// <param name="ter">terrain heightfield</param> |
409 | /// <param name="regionID">region UUID</param> | 409 | /// <param name="regionID">region UUID</param> |
410 | public void StoreTerrain(double[,] ter, LLUUID regionID) | 410 | public void StoreTerrain(double[,] ter, UUID regionID) |
411 | { | 411 | { |
412 | lock (ds) | 412 | lock (ds) |
413 | { | 413 | { |
@@ -451,7 +451,7 @@ namespace OpenSim.Data.SQLite | |||
451 | /// </summary> | 451 | /// </summary> |
452 | /// <param name="regionID">the region UUID</param> | 452 | /// <param name="regionID">the region UUID</param> |
453 | /// <returns>Heightfield data</returns> | 453 | /// <returns>Heightfield data</returns> |
454 | public double[,] LoadTerrain(LLUUID regionID) | 454 | public double[,] LoadTerrain(UUID regionID) |
455 | { | 455 | { |
456 | lock (ds) | 456 | lock (ds) |
457 | { | 457 | { |
@@ -499,7 +499,7 @@ namespace OpenSim.Data.SQLite | |||
499 | /// | 499 | /// |
500 | /// </summary> | 500 | /// </summary> |
501 | /// <param name="globalID"></param> | 501 | /// <param name="globalID"></param> |
502 | public void RemoveLandObject(LLUUID globalID) | 502 | public void RemoveLandObject(UUID globalID) |
503 | { | 503 | { |
504 | lock (ds) | 504 | lock (ds) |
505 | { | 505 | { |
@@ -563,7 +563,7 @@ namespace OpenSim.Data.SQLite | |||
563 | /// </summary> | 563 | /// </summary> |
564 | /// <param name="regionUUID"></param> | 564 | /// <param name="regionUUID"></param> |
565 | /// <returns></returns> | 565 | /// <returns></returns> |
566 | public List<LandData> LoadLandObjects(LLUUID regionUUID) | 566 | public List<LandData> LoadLandObjects(UUID regionUUID) |
567 | { | 567 | { |
568 | List<LandData> landDataForRegion = new List<LandData>(); | 568 | List<LandData> landDataForRegion = new List<LandData>(); |
569 | lock (ds) | 569 | lock (ds) |
@@ -821,12 +821,12 @@ namespace OpenSim.Data.SQLite | |||
821 | createCol(land, "IsGroupOwned", typeof (Boolean)); | 821 | createCol(land, "IsGroupOwned", typeof (Boolean)); |
822 | createCol(land, "Area", typeof (Int32)); | 822 | createCol(land, "Area", typeof (Int32)); |
823 | createCol(land, "AuctionID", typeof (Int32)); //Unemplemented | 823 | createCol(land, "AuctionID", typeof (Int32)); //Unemplemented |
824 | createCol(land, "Category", typeof (Int32)); //Enum libsecondlife.Parcel.ParcelCategory | 824 | createCol(land, "Category", typeof (Int32)); //Enum OpenMetaverse.Parcel.ParcelCategory |
825 | createCol(land, "ClaimDate", typeof (Int32)); | 825 | createCol(land, "ClaimDate", typeof (Int32)); |
826 | createCol(land, "ClaimPrice", typeof (Int32)); | 826 | createCol(land, "ClaimPrice", typeof (Int32)); |
827 | createCol(land, "GroupUUID", typeof (string)); | 827 | createCol(land, "GroupUUID", typeof (string)); |
828 | createCol(land, "SalePrice", typeof (Int32)); | 828 | createCol(land, "SalePrice", typeof (Int32)); |
829 | createCol(land, "LandStatus", typeof (Int32)); //Enum. libsecondlife.Parcel.ParcelStatus | 829 | createCol(land, "LandStatus", typeof (Int32)); //Enum. OpenMetaverse.Parcel.ParcelStatus |
830 | createCol(land, "LandFlags", typeof (UInt32)); | 830 | createCol(land, "LandFlags", typeof (UInt32)); |
831 | createCol(land, "LandingType", typeof (Byte)); | 831 | createCol(land, "LandingType", typeof (Byte)); |
832 | createCol(land, "MediaAutoScale", typeof (Byte)); | 832 | createCol(land, "MediaAutoScale", typeof (Byte)); |
@@ -882,7 +882,7 @@ namespace OpenSim.Data.SQLite | |||
882 | // interesting has to be done to actually get these values | 882 | // interesting has to be done to actually get these values |
883 | // back out. Not enough time to figure it out yet. | 883 | // back out. Not enough time to figure it out yet. |
884 | SceneObjectPart prim = new SceneObjectPart(); | 884 | SceneObjectPart prim = new SceneObjectPart(); |
885 | prim.UUID = new LLUUID((String) row["UUID"]); | 885 | prim.UUID = new UUID((String) row["UUID"]); |
886 | // explicit conversion of integers is required, which sort | 886 | // explicit conversion of integers is required, which sort |
887 | // of sucks. No idea if there is a shortcut here or not. | 887 | // of sucks. No idea if there is a shortcut here or not. |
888 | prim.ParentID = Convert.ToUInt32(row["ParentID"]); | 888 | prim.ParentID = Convert.ToUInt32(row["ParentID"]); |
@@ -895,43 +895,43 @@ namespace OpenSim.Data.SQLite | |||
895 | prim.TouchName = (String) row["TouchName"]; | 895 | prim.TouchName = (String) row["TouchName"]; |
896 | // permissions | 896 | // permissions |
897 | prim.ObjectFlags = Convert.ToUInt32(row["ObjectFlags"]); | 897 | prim.ObjectFlags = Convert.ToUInt32(row["ObjectFlags"]); |
898 | prim.CreatorID = new LLUUID((String) row["CreatorID"]); | 898 | prim.CreatorID = new UUID((String) row["CreatorID"]); |
899 | prim.OwnerID = new LLUUID((String) row["OwnerID"]); | 899 | prim.OwnerID = new UUID((String) row["OwnerID"]); |
900 | prim.GroupID = new LLUUID((String) row["GroupID"]); | 900 | prim.GroupID = new UUID((String) row["GroupID"]); |
901 | prim.LastOwnerID = new LLUUID((String) row["LastOwnerID"]); | 901 | prim.LastOwnerID = new UUID((String) row["LastOwnerID"]); |
902 | prim.OwnerMask = Convert.ToUInt32(row["OwnerMask"]); | 902 | prim.OwnerMask = Convert.ToUInt32(row["OwnerMask"]); |
903 | prim.NextOwnerMask = Convert.ToUInt32(row["NextOwnerMask"]); | 903 | prim.NextOwnerMask = Convert.ToUInt32(row["NextOwnerMask"]); |
904 | prim.GroupMask = Convert.ToUInt32(row["GroupMask"]); | 904 | prim.GroupMask = Convert.ToUInt32(row["GroupMask"]); |
905 | prim.EveryoneMask = Convert.ToUInt32(row["EveryoneMask"]); | 905 | prim.EveryoneMask = Convert.ToUInt32(row["EveryoneMask"]); |
906 | prim.BaseMask = Convert.ToUInt32(row["BaseMask"]); | 906 | prim.BaseMask = Convert.ToUInt32(row["BaseMask"]); |
907 | // vectors | 907 | // vectors |
908 | prim.OffsetPosition = new LLVector3( | 908 | prim.OffsetPosition = new Vector3( |
909 | Convert.ToSingle(row["PositionX"]), | 909 | Convert.ToSingle(row["PositionX"]), |
910 | Convert.ToSingle(row["PositionY"]), | 910 | Convert.ToSingle(row["PositionY"]), |
911 | Convert.ToSingle(row["PositionZ"]) | 911 | Convert.ToSingle(row["PositionZ"]) |
912 | ); | 912 | ); |
913 | prim.GroupPosition = new LLVector3( | 913 | prim.GroupPosition = new Vector3( |
914 | Convert.ToSingle(row["GroupPositionX"]), | 914 | Convert.ToSingle(row["GroupPositionX"]), |
915 | Convert.ToSingle(row["GroupPositionY"]), | 915 | Convert.ToSingle(row["GroupPositionY"]), |
916 | Convert.ToSingle(row["GroupPositionZ"]) | 916 | Convert.ToSingle(row["GroupPositionZ"]) |
917 | ); | 917 | ); |
918 | prim.Velocity = new LLVector3( | 918 | prim.Velocity = new Vector3( |
919 | Convert.ToSingle(row["VelocityX"]), | 919 | Convert.ToSingle(row["VelocityX"]), |
920 | Convert.ToSingle(row["VelocityY"]), | 920 | Convert.ToSingle(row["VelocityY"]), |
921 | Convert.ToSingle(row["VelocityZ"]) | 921 | Convert.ToSingle(row["VelocityZ"]) |
922 | ); | 922 | ); |
923 | prim.AngularVelocity = new LLVector3( | 923 | prim.AngularVelocity = new Vector3( |
924 | Convert.ToSingle(row["AngularVelocityX"]), | 924 | Convert.ToSingle(row["AngularVelocityX"]), |
925 | Convert.ToSingle(row["AngularVelocityY"]), | 925 | Convert.ToSingle(row["AngularVelocityY"]), |
926 | Convert.ToSingle(row["AngularVelocityZ"]) | 926 | Convert.ToSingle(row["AngularVelocityZ"]) |
927 | ); | 927 | ); |
928 | prim.Acceleration = new LLVector3( | 928 | prim.Acceleration = new Vector3( |
929 | Convert.ToSingle(row["AccelerationX"]), | 929 | Convert.ToSingle(row["AccelerationX"]), |
930 | Convert.ToSingle(row["AccelerationY"]), | 930 | Convert.ToSingle(row["AccelerationY"]), |
931 | Convert.ToSingle(row["AccelerationZ"]) | 931 | Convert.ToSingle(row["AccelerationZ"]) |
932 | ); | 932 | ); |
933 | // quaternions | 933 | // quaternions |
934 | prim.RotationOffset = new LLQuaternion( | 934 | prim.RotationOffset = new Quaternion( |
935 | Convert.ToSingle(row["RotationX"]), | 935 | Convert.ToSingle(row["RotationX"]), |
936 | Convert.ToSingle(row["RotationY"]), | 936 | Convert.ToSingle(row["RotationY"]), |
937 | Convert.ToSingle(row["RotationZ"]), | 937 | Convert.ToSingle(row["RotationZ"]), |
@@ -940,11 +940,11 @@ namespace OpenSim.Data.SQLite | |||
940 | 940 | ||
941 | try | 941 | try |
942 | { | 942 | { |
943 | prim.SitTargetPositionLL = new LLVector3( | 943 | prim.SitTargetPositionLL = new Vector3( |
944 | Convert.ToSingle(row["SitTargetOffsetX"]), | 944 | Convert.ToSingle(row["SitTargetOffsetX"]), |
945 | Convert.ToSingle(row["SitTargetOffsetY"]), | 945 | Convert.ToSingle(row["SitTargetOffsetY"]), |
946 | Convert.ToSingle(row["SitTargetOffsetZ"])); | 946 | Convert.ToSingle(row["SitTargetOffsetZ"])); |
947 | prim.SitTargetOrientationLL = new LLQuaternion( | 947 | prim.SitTargetOrientationLL = new Quaternion( |
948 | Convert.ToSingle( | 948 | Convert.ToSingle( |
949 | row["SitTargetOrientX"]), | 949 | row["SitTargetOrientX"]), |
950 | Convert.ToSingle( | 950 | Convert.ToSingle( |
@@ -993,10 +993,10 @@ namespace OpenSim.Data.SQLite | |||
993 | { | 993 | { |
994 | TaskInventoryItem taskItem = new TaskInventoryItem(); | 994 | TaskInventoryItem taskItem = new TaskInventoryItem(); |
995 | 995 | ||
996 | taskItem.ItemID = new LLUUID((String)row["itemID"]); | 996 | taskItem.ItemID = new UUID((String)row["itemID"]); |
997 | taskItem.ParentPartID = new LLUUID((String)row["primID"]); | 997 | taskItem.ParentPartID = new UUID((String)row["primID"]); |
998 | taskItem.AssetID = new LLUUID((String)row["assetID"]); | 998 | taskItem.AssetID = new UUID((String)row["assetID"]); |
999 | taskItem.ParentID = new LLUUID((String)row["parentFolderID"]); | 999 | taskItem.ParentID = new UUID((String)row["parentFolderID"]); |
1000 | 1000 | ||
1001 | taskItem.InvType = Convert.ToInt32(row["invType"]); | 1001 | taskItem.InvType = Convert.ToInt32(row["invType"]); |
1002 | taskItem.Type = Convert.ToInt32(row["assetType"]); | 1002 | taskItem.Type = Convert.ToInt32(row["assetType"]); |
@@ -1004,10 +1004,10 @@ namespace OpenSim.Data.SQLite | |||
1004 | taskItem.Name = (String)row["name"]; | 1004 | taskItem.Name = (String)row["name"]; |
1005 | taskItem.Description = (String)row["description"]; | 1005 | taskItem.Description = (String)row["description"]; |
1006 | taskItem.CreationDate = Convert.ToUInt32(row["creationDate"]); | 1006 | taskItem.CreationDate = Convert.ToUInt32(row["creationDate"]); |
1007 | taskItem.CreatorID = new LLUUID((String)row["creatorID"]); | 1007 | taskItem.CreatorID = new UUID((String)row["creatorID"]); |
1008 | taskItem.OwnerID = new LLUUID((String)row["ownerID"]); | 1008 | taskItem.OwnerID = new UUID((String)row["ownerID"]); |
1009 | taskItem.LastOwnerID = new LLUUID((String)row["lastOwnerID"]); | 1009 | taskItem.LastOwnerID = new UUID((String)row["lastOwnerID"]); |
1010 | taskItem.GroupID = new LLUUID((String)row["groupID"]); | 1010 | taskItem.GroupID = new UUID((String)row["groupID"]); |
1011 | 1011 | ||
1012 | taskItem.NextPermissions = Convert.ToUInt32(row["nextPermissions"]); | 1012 | taskItem.NextPermissions = Convert.ToUInt32(row["nextPermissions"]); |
1013 | taskItem.CurrentPermissions = Convert.ToUInt32(row["currentPermissions"]); | 1013 | taskItem.CurrentPermissions = Convert.ToUInt32(row["currentPermissions"]); |
@@ -1028,7 +1028,7 @@ namespace OpenSim.Data.SQLite | |||
1028 | { | 1028 | { |
1029 | LandData newData = new LandData(); | 1029 | LandData newData = new LandData(); |
1030 | 1030 | ||
1031 | newData.GlobalID = new LLUUID((String) row["UUID"]); | 1031 | newData.GlobalID = new UUID((String) row["UUID"]); |
1032 | newData.LocalID = Convert.ToInt32(row["LocalLandID"]); | 1032 | newData.LocalID = Convert.ToInt32(row["LocalLandID"]); |
1033 | 1033 | ||
1034 | // Bitmap is a byte[512] | 1034 | // Bitmap is a byte[512] |
@@ -1041,17 +1041,17 @@ namespace OpenSim.Data.SQLite | |||
1041 | newData.Area = Convert.ToInt32(row["Area"]); | 1041 | newData.Area = Convert.ToInt32(row["Area"]); |
1042 | newData.AuctionID = Convert.ToUInt32(row["AuctionID"]); //Unemplemented | 1042 | newData.AuctionID = Convert.ToUInt32(row["AuctionID"]); //Unemplemented |
1043 | newData.Category = (Parcel.ParcelCategory) Convert.ToInt32(row["Category"]); | 1043 | newData.Category = (Parcel.ParcelCategory) Convert.ToInt32(row["Category"]); |
1044 | //Enum libsecondlife.Parcel.ParcelCategory | 1044 | //Enum OpenMetaverse.Parcel.ParcelCategory |
1045 | newData.ClaimDate = Convert.ToInt32(row["ClaimDate"]); | 1045 | newData.ClaimDate = Convert.ToInt32(row["ClaimDate"]); |
1046 | newData.ClaimPrice = Convert.ToInt32(row["ClaimPrice"]); | 1046 | newData.ClaimPrice = Convert.ToInt32(row["ClaimPrice"]); |
1047 | newData.GroupID = new LLUUID((String) row["GroupUUID"]); | 1047 | newData.GroupID = new UUID((String) row["GroupUUID"]); |
1048 | newData.SalePrice = Convert.ToInt32(row["SalePrice"]); | 1048 | newData.SalePrice = Convert.ToInt32(row["SalePrice"]); |
1049 | newData.Status = (Parcel.ParcelStatus) Convert.ToInt32(row["LandStatus"]); | 1049 | newData.Status = (Parcel.ParcelStatus) Convert.ToInt32(row["LandStatus"]); |
1050 | //Enum. libsecondlife.Parcel.ParcelStatus | 1050 | //Enum. OpenMetaverse.Parcel.ParcelStatus |
1051 | newData.Flags = Convert.ToUInt32(row["LandFlags"]); | 1051 | newData.Flags = Convert.ToUInt32(row["LandFlags"]); |
1052 | newData.LandingType = (Byte) row["LandingType"]; | 1052 | newData.LandingType = (Byte) row["LandingType"]; |
1053 | newData.MediaAutoScale = (Byte) row["MediaAutoScale"]; | 1053 | newData.MediaAutoScale = (Byte) row["MediaAutoScale"]; |
1054 | newData.MediaID = new LLUUID((String) row["MediaTextureUUID"]); | 1054 | newData.MediaID = new UUID((String) row["MediaTextureUUID"]); |
1055 | newData.MediaURL = (String) row["MediaURL"]; | 1055 | newData.MediaURL = (String) row["MediaURL"]; |
1056 | newData.MusicURL = (String) row["MusicURL"]; | 1056 | newData.MusicURL = (String) row["MusicURL"]; |
1057 | newData.PassHours = Convert.ToSingle(row["PassHours"]); | 1057 | newData.PassHours = Convert.ToSingle(row["PassHours"]); |
@@ -1061,25 +1061,25 @@ namespace OpenSim.Data.SQLite | |||
1061 | { | 1061 | { |
1062 | 1062 | ||
1063 | newData.UserLocation = | 1063 | newData.UserLocation = |
1064 | new LLVector3(Convert.ToSingle(row["UserLocationX"]), Convert.ToSingle(row["UserLocationY"]), | 1064 | new Vector3(Convert.ToSingle(row["UserLocationX"]), Convert.ToSingle(row["UserLocationY"]), |
1065 | Convert.ToSingle(row["UserLocationZ"])); | 1065 | Convert.ToSingle(row["UserLocationZ"])); |
1066 | newData.UserLookAt = | 1066 | newData.UserLookAt = |
1067 | new LLVector3(Convert.ToSingle(row["UserLookAtX"]), Convert.ToSingle(row["UserLookAtY"]), | 1067 | new Vector3(Convert.ToSingle(row["UserLookAtX"]), Convert.ToSingle(row["UserLookAtY"]), |
1068 | Convert.ToSingle(row["UserLookAtZ"])); | 1068 | Convert.ToSingle(row["UserLookAtZ"])); |
1069 | 1069 | ||
1070 | } | 1070 | } |
1071 | catch (InvalidCastException) | 1071 | catch (InvalidCastException) |
1072 | { | 1072 | { |
1073 | m_log.ErrorFormat("[PARCEL]: unable to get parcel telehub settings for {1}", newData.Name); | 1073 | m_log.ErrorFormat("[PARCEL]: unable to get parcel telehub settings for {1}", newData.Name); |
1074 | newData.UserLocation = LLVector3.Zero; | 1074 | newData.UserLocation = Vector3.Zero; |
1075 | newData.UserLookAt = LLVector3.Zero; | 1075 | newData.UserLookAt = Vector3.Zero; |
1076 | } | 1076 | } |
1077 | newData.ParcelAccessList = new List<ParcelManager.ParcelAccessEntry>(); | 1077 | newData.ParcelAccessList = new List<ParcelManager.ParcelAccessEntry>(); |
1078 | LLUUID authBuyerID = LLUUID.Zero; | 1078 | UUID authBuyerID = UUID.Zero; |
1079 | 1079 | ||
1080 | try | 1080 | try |
1081 | { | 1081 | { |
1082 | Helpers.TryParse((string)row["AuthbuyerID"], out authBuyerID); | 1082 | UUID.TryParse((string)row["AuthbuyerID"], out authBuyerID); |
1083 | } | 1083 | } |
1084 | catch (InvalidCastException) | 1084 | catch (InvalidCastException) |
1085 | { | 1085 | { |
@@ -1120,7 +1120,7 @@ namespace OpenSim.Data.SQLite | |||
1120 | private static ParcelManager.ParcelAccessEntry buildLandAccessData(DataRow row) | 1120 | private static ParcelManager.ParcelAccessEntry buildLandAccessData(DataRow row) |
1121 | { | 1121 | { |
1122 | ParcelManager.ParcelAccessEntry entry = new ParcelManager.ParcelAccessEntry(); | 1122 | ParcelManager.ParcelAccessEntry entry = new ParcelManager.ParcelAccessEntry(); |
1123 | entry.AgentID = new LLUUID((string) row["AccessUUID"]); | 1123 | entry.AgentID = new UUID((string) row["AccessUUID"]); |
1124 | entry.Flags = (ParcelManager.AccessList) row["Flags"]; | 1124 | entry.Flags = (ParcelManager.AccessList) row["Flags"]; |
1125 | entry.Time = new DateTime(); | 1125 | entry.Time = new DateTime(); |
1126 | return entry; | 1126 | return entry; |
@@ -1144,7 +1144,7 @@ namespace OpenSim.Data.SQLite | |||
1144 | return str.ToArray(); | 1144 | return str.ToArray(); |
1145 | } | 1145 | } |
1146 | 1146 | ||
1147 | // private void fillTerrainRow(DataRow row, LLUUID regionUUID, int rev, double[,] val) | 1147 | // private void fillTerrainRow(DataRow row, UUID regionUUID, int rev, double[,] val) |
1148 | // { | 1148 | // { |
1149 | // row["RegionUUID"] = regionUUID; | 1149 | // row["RegionUUID"] = regionUUID; |
1150 | // row["Revision"] = rev; | 1150 | // row["Revision"] = rev; |
@@ -1167,7 +1167,7 @@ namespace OpenSim.Data.SQLite | |||
1167 | /// <param name="prim"></param> | 1167 | /// <param name="prim"></param> |
1168 | /// <param name="sceneGroupID"></param> | 1168 | /// <param name="sceneGroupID"></param> |
1169 | /// <param name="regionUUID"></param> | 1169 | /// <param name="regionUUID"></param> |
1170 | private static void fillPrimRow(DataRow row, SceneObjectPart prim, LLUUID sceneGroupID, LLUUID regionUUID) | 1170 | private static void fillPrimRow(DataRow row, SceneObjectPart prim, UUID sceneGroupID, UUID regionUUID) |
1171 | { | 1171 | { |
1172 | row["UUID"] = Util.ToRawUuidString(prim.UUID); | 1172 | row["UUID"] = Util.ToRawUuidString(prim.UUID); |
1173 | row["RegionUUID"] = Util.ToRawUuidString(regionUUID); | 1173 | row["RegionUUID"] = Util.ToRawUuidString(regionUUID); |
@@ -1215,12 +1215,12 @@ namespace OpenSim.Data.SQLite | |||
1215 | row["RotationW"] = prim.RotationOffset.W; | 1215 | row["RotationW"] = prim.RotationOffset.W; |
1216 | 1216 | ||
1217 | // Sit target | 1217 | // Sit target |
1218 | LLVector3 sitTargetPos = prim.SitTargetPositionLL; | 1218 | Vector3 sitTargetPos = prim.SitTargetPositionLL; |
1219 | row["SitTargetOffsetX"] = sitTargetPos.X; | 1219 | row["SitTargetOffsetX"] = sitTargetPos.X; |
1220 | row["SitTargetOffsetY"] = sitTargetPos.Y; | 1220 | row["SitTargetOffsetY"] = sitTargetPos.Y; |
1221 | row["SitTargetOffsetZ"] = sitTargetPos.Z; | 1221 | row["SitTargetOffsetZ"] = sitTargetPos.Z; |
1222 | 1222 | ||
1223 | LLQuaternion sitTargetOrient = prim.SitTargetOrientationLL; | 1223 | Quaternion sitTargetOrient = prim.SitTargetOrientationLL; |
1224 | row["SitTargetOrientW"] = sitTargetOrient.W; | 1224 | row["SitTargetOrientW"] = sitTargetOrient.W; |
1225 | row["SitTargetOrientX"] = sitTargetOrient.X; | 1225 | row["SitTargetOrientX"] = sitTargetOrient.X; |
1226 | row["SitTargetOrientY"] = sitTargetOrient.Y; | 1226 | row["SitTargetOrientY"] = sitTargetOrient.Y; |
@@ -1263,7 +1263,7 @@ namespace OpenSim.Data.SQLite | |||
1263 | /// <param name="row"></param> | 1263 | /// <param name="row"></param> |
1264 | /// <param name="land"></param> | 1264 | /// <param name="land"></param> |
1265 | /// <param name="regionUUID"></param> | 1265 | /// <param name="regionUUID"></param> |
1266 | private static void fillLandRow(DataRow row, LandData land, LLUUID regionUUID) | 1266 | private static void fillLandRow(DataRow row, LandData land, UUID regionUUID) |
1267 | { | 1267 | { |
1268 | row["UUID"] = Util.ToRawUuidString(land.GlobalID); | 1268 | row["UUID"] = Util.ToRawUuidString(land.GlobalID); |
1269 | row["RegionUUID"] = Util.ToRawUuidString(regionUUID); | 1269 | row["RegionUUID"] = Util.ToRawUuidString(regionUUID); |
@@ -1278,12 +1278,12 @@ namespace OpenSim.Data.SQLite | |||
1278 | row["IsGroupOwned"] = land.IsGroupOwned; | 1278 | row["IsGroupOwned"] = land.IsGroupOwned; |
1279 | row["Area"] = land.Area; | 1279 | row["Area"] = land.Area; |
1280 | row["AuctionID"] = land.AuctionID; //Unemplemented | 1280 | row["AuctionID"] = land.AuctionID; //Unemplemented |
1281 | row["Category"] = land.Category; //Enum libsecondlife.Parcel.ParcelCategory | 1281 | row["Category"] = land.Category; //Enum OpenMetaverse.Parcel.ParcelCategory |
1282 | row["ClaimDate"] = land.ClaimDate; | 1282 | row["ClaimDate"] = land.ClaimDate; |
1283 | row["ClaimPrice"] = land.ClaimPrice; | 1283 | row["ClaimPrice"] = land.ClaimPrice; |
1284 | row["GroupUUID"] = Util.ToRawUuidString(land.GroupID); | 1284 | row["GroupUUID"] = Util.ToRawUuidString(land.GroupID); |
1285 | row["SalePrice"] = land.SalePrice; | 1285 | row["SalePrice"] = land.SalePrice; |
1286 | row["LandStatus"] = land.Status; //Enum. libsecondlife.Parcel.ParcelStatus | 1286 | row["LandStatus"] = land.Status; //Enum. OpenMetaverse.Parcel.ParcelStatus |
1287 | row["LandFlags"] = land.Flags; | 1287 | row["LandFlags"] = land.Flags; |
1288 | row["LandingType"] = land.LandingType; | 1288 | row["LandingType"] = land.LandingType; |
1289 | row["MediaAutoScale"] = land.MediaAutoScale; | 1289 | row["MediaAutoScale"] = land.MediaAutoScale; |
@@ -1308,7 +1308,7 @@ namespace OpenSim.Data.SQLite | |||
1308 | /// <param name="row"></param> | 1308 | /// <param name="row"></param> |
1309 | /// <param name="entry"></param> | 1309 | /// <param name="entry"></param> |
1310 | /// <param name="parcelID"></param> | 1310 | /// <param name="parcelID"></param> |
1311 | private static void fillLandAccessRow(DataRow row, ParcelManager.ParcelAccessEntry entry, LLUUID parcelID) | 1311 | private static void fillLandAccessRow(DataRow row, ParcelManager.ParcelAccessEntry entry, UUID parcelID) |
1312 | { | 1312 | { |
1313 | row["LandUUID"] = Util.ToRawUuidString(parcelID); | 1313 | row["LandUUID"] = Util.ToRawUuidString(parcelID); |
1314 | row["AccessUUID"] = Util.ToRawUuidString(entry.AgentID); | 1314 | row["AccessUUID"] = Util.ToRawUuidString(entry.AgentID); |
@@ -1323,7 +1323,7 @@ namespace OpenSim.Data.SQLite | |||
1323 | private PrimitiveBaseShape buildShape(DataRow row) | 1323 | private PrimitiveBaseShape buildShape(DataRow row) |
1324 | { | 1324 | { |
1325 | PrimitiveBaseShape s = new PrimitiveBaseShape(); | 1325 | PrimitiveBaseShape s = new PrimitiveBaseShape(); |
1326 | s.Scale = new LLVector3( | 1326 | s.Scale = new Vector3( |
1327 | Convert.ToSingle(row["ScaleX"]), | 1327 | Convert.ToSingle(row["ScaleX"]), |
1328 | Convert.ToSingle(row["ScaleY"]), | 1328 | Convert.ToSingle(row["ScaleY"]), |
1329 | Convert.ToSingle(row["ScaleZ"]) | 1329 | Convert.ToSingle(row["ScaleZ"]) |
@@ -1418,7 +1418,7 @@ namespace OpenSim.Data.SQLite | |||
1418 | /// <param name="prim"></param> | 1418 | /// <param name="prim"></param> |
1419 | /// <param name="sceneGroupID"></param> | 1419 | /// <param name="sceneGroupID"></param> |
1420 | /// <param name="regionUUID"></param> | 1420 | /// <param name="regionUUID"></param> |
1421 | private void addPrim(SceneObjectPart prim, LLUUID sceneGroupID, LLUUID regionUUID) | 1421 | private void addPrim(SceneObjectPart prim, UUID sceneGroupID, UUID regionUUID) |
1422 | { | 1422 | { |
1423 | DataTable prims = ds.Tables["prims"]; | 1423 | DataTable prims = ds.Tables["prims"]; |
1424 | DataTable shapes = ds.Tables["primshapes"]; | 1424 | DataTable shapes = ds.Tables["primshapes"]; |
@@ -1453,7 +1453,7 @@ namespace OpenSim.Data.SQLite | |||
1453 | /// </summary> | 1453 | /// </summary> |
1454 | /// <param name="primID"></param> | 1454 | /// <param name="primID"></param> |
1455 | /// <param name="items"></param> | 1455 | /// <param name="items"></param> |
1456 | public void StorePrimInventory(LLUUID primID, ICollection<TaskInventoryItem> items) | 1456 | public void StorePrimInventory(UUID primID, ICollection<TaskInventoryItem> items) |
1457 | { | 1457 | { |
1458 | m_log.InfoFormat("[REGION DB]: Entered StorePrimInventory with prim ID {0}", primID); | 1458 | m_log.InfoFormat("[REGION DB]: Entered StorePrimInventory with prim ID {0}", primID); |
1459 | 1459 | ||
diff --git a/OpenSim/Data/SQLite/SQLiteUserData.cs b/OpenSim/Data/SQLite/SQLiteUserData.cs index ae3cb72..7f1fd62 100644 --- a/OpenSim/Data/SQLite/SQLiteUserData.cs +++ b/OpenSim/Data/SQLite/SQLiteUserData.cs | |||
@@ -29,7 +29,7 @@ using System; | |||
29 | using System.Collections.Generic; | 29 | using System.Collections.Generic; |
30 | using System.Data; | 30 | using System.Data; |
31 | using System.Reflection; | 31 | using System.Reflection; |
32 | using libsecondlife; | 32 | using OpenMetaverse; |
33 | using log4net; | 33 | using log4net; |
34 | using Mono.Data.SqliteClient; | 34 | using Mono.Data.SqliteClient; |
35 | using OpenSim.Framework; | 35 | using OpenSim.Framework; |
@@ -59,7 +59,7 @@ namespace OpenSim.Data.SQLite | |||
59 | private const string AvatarPickerAndSQL = "select * from users where username like :username and surname like :surname"; | 59 | private const string AvatarPickerAndSQL = "select * from users where username like :username and surname like :surname"; |
60 | private const string AvatarPickerOrSQL = "select * from users where username like :username or surname like :surname"; | 60 | private const string AvatarPickerOrSQL = "select * from users where username like :username or surname like :surname"; |
61 | 61 | ||
62 | private Dictionary<LLUUID, AvatarAppearance> aplist = new Dictionary<LLUUID, AvatarAppearance>(); | 62 | private Dictionary<UUID, AvatarAppearance> aplist = new Dictionary<UUID, AvatarAppearance>(); |
63 | private DataSet ds; | 63 | private DataSet ds; |
64 | private SqliteDataAdapter da; | 64 | private SqliteDataAdapter da; |
65 | private SqliteDataAdapter daf; | 65 | private SqliteDataAdapter daf; |
@@ -124,7 +124,7 @@ namespace OpenSim.Data.SQLite | |||
124 | /// </summary> | 124 | /// </summary> |
125 | /// <param name="uuid">User UUID</param> | 125 | /// <param name="uuid">User UUID</param> |
126 | /// <returns>user profile data</returns> | 126 | /// <returns>user profile data</returns> |
127 | override public UserProfileData GetUserByUUID(LLUUID uuid) | 127 | override public UserProfileData GetUserByUUID(UUID uuid) |
128 | { | 128 | { |
129 | lock (ds) | 129 | lock (ds) |
130 | { | 130 | { |
@@ -184,21 +184,21 @@ namespace OpenSim.Data.SQLite | |||
184 | /// <param name="friendlistowner">UUID of the friendlist owner</param> | 184 | /// <param name="friendlistowner">UUID of the friendlist owner</param> |
185 | /// <param name="friend">UUID of the friend to add</param> | 185 | /// <param name="friend">UUID of the friend to add</param> |
186 | /// <param name="perms">permission flag</param> | 186 | /// <param name="perms">permission flag</param> |
187 | override public void AddNewUserFriend(LLUUID friendlistowner, LLUUID friend, uint perms) | 187 | override public void AddNewUserFriend(UUID friendlistowner, UUID friend, uint perms) |
188 | { | 188 | { |
189 | string InsertFriends = "insert into userfriends(ownerID, friendID, friendPerms) values(:ownerID, :friendID, :perms)"; | 189 | string InsertFriends = "insert into userfriends(ownerID, friendID, friendPerms) values(:ownerID, :friendID, :perms)"; |
190 | 190 | ||
191 | using (SqliteCommand cmd = new SqliteCommand(InsertFriends, g_conn)) | 191 | using (SqliteCommand cmd = new SqliteCommand(InsertFriends, g_conn)) |
192 | { | 192 | { |
193 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friendlistowner.UUID.ToString())); | 193 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friendlistowner.ToString())); |
194 | cmd.Parameters.Add(new SqliteParameter(":friendID", friend.UUID.ToString())); | 194 | cmd.Parameters.Add(new SqliteParameter(":friendID", friend.ToString())); |
195 | cmd.Parameters.Add(new SqliteParameter(":perms", perms)); | 195 | cmd.Parameters.Add(new SqliteParameter(":perms", perms)); |
196 | cmd.ExecuteNonQuery(); | 196 | cmd.ExecuteNonQuery(); |
197 | } | 197 | } |
198 | using (SqliteCommand cmd = new SqliteCommand(InsertFriends, g_conn)) | 198 | using (SqliteCommand cmd = new SqliteCommand(InsertFriends, g_conn)) |
199 | { | 199 | { |
200 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friend.UUID.ToString())); | 200 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friend.ToString())); |
201 | cmd.Parameters.Add(new SqliteParameter(":friendID", friendlistowner.UUID.ToString())); | 201 | cmd.Parameters.Add(new SqliteParameter(":friendID", friendlistowner.ToString())); |
202 | cmd.Parameters.Add(new SqliteParameter(":perms", perms)); | 202 | cmd.Parameters.Add(new SqliteParameter(":perms", perms)); |
203 | cmd.ExecuteNonQuery(); | 203 | cmd.ExecuteNonQuery(); |
204 | } | 204 | } |
@@ -209,13 +209,13 @@ namespace OpenSim.Data.SQLite | |||
209 | /// </summary> | 209 | /// </summary> |
210 | /// <param name="friendlistowner">UUID of the friendlist owner</param> | 210 | /// <param name="friendlistowner">UUID of the friendlist owner</param> |
211 | /// <param name="friend">UUID of the friend to remove</param> | 211 | /// <param name="friend">UUID of the friend to remove</param> |
212 | override public void RemoveUserFriend(LLUUID friendlistowner, LLUUID friend) | 212 | override public void RemoveUserFriend(UUID friendlistowner, UUID friend) |
213 | { | 213 | { |
214 | string DeletePerms = "delete from friendlist where (ownerID=:ownerID and friendID=:friendID) or (ownerID=:friendID and friendID=:ownerID)"; | 214 | string DeletePerms = "delete from friendlist where (ownerID=:ownerID and friendID=:friendID) or (ownerID=:friendID and friendID=:ownerID)"; |
215 | using (SqliteCommand cmd = new SqliteCommand(DeletePerms, g_conn)) | 215 | using (SqliteCommand cmd = new SqliteCommand(DeletePerms, g_conn)) |
216 | { | 216 | { |
217 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friendlistowner.UUID.ToString())); | 217 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friendlistowner.ToString())); |
218 | cmd.Parameters.Add(new SqliteParameter(":friendID", friend.UUID.ToString())); | 218 | cmd.Parameters.Add(new SqliteParameter(":friendID", friend.ToString())); |
219 | cmd.ExecuteNonQuery(); | 219 | cmd.ExecuteNonQuery(); |
220 | } | 220 | } |
221 | } | 221 | } |
@@ -226,14 +226,14 @@ namespace OpenSim.Data.SQLite | |||
226 | /// <param name="friendlistowner">UUID of the friendlist owner</param> | 226 | /// <param name="friendlistowner">UUID of the friendlist owner</param> |
227 | /// <param name="friend">UUID of the friend to modify</param> | 227 | /// <param name="friend">UUID of the friend to modify</param> |
228 | /// <param name="perms">updated permission flag</param> | 228 | /// <param name="perms">updated permission flag</param> |
229 | override public void UpdateUserFriendPerms(LLUUID friendlistowner, LLUUID friend, uint perms) | 229 | override public void UpdateUserFriendPerms(UUID friendlistowner, UUID friend, uint perms) |
230 | { | 230 | { |
231 | string UpdatePerms = "update friendlist set perms=:perms where ownerID=:ownerID and friendID=:friendID"; | 231 | string UpdatePerms = "update friendlist set perms=:perms where ownerID=:ownerID and friendID=:friendID"; |
232 | using (SqliteCommand cmd = new SqliteCommand(UpdatePerms, g_conn)) | 232 | using (SqliteCommand cmd = new SqliteCommand(UpdatePerms, g_conn)) |
233 | { | 233 | { |
234 | cmd.Parameters.Add(new SqliteParameter(":perms", perms)); | 234 | cmd.Parameters.Add(new SqliteParameter(":perms", perms)); |
235 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friendlistowner.UUID.ToString())); | 235 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friendlistowner.ToString())); |
236 | cmd.Parameters.Add(new SqliteParameter(":friendID", friend.UUID.ToString())); | 236 | cmd.Parameters.Add(new SqliteParameter(":friendID", friend.ToString())); |
237 | cmd.ExecuteNonQuery(); | 237 | cmd.ExecuteNonQuery(); |
238 | } | 238 | } |
239 | } | 239 | } |
@@ -243,13 +243,13 @@ namespace OpenSim.Data.SQLite | |||
243 | /// </summary> | 243 | /// </summary> |
244 | /// <param name="friendlistowner">UUID of the friendlist owner</param> | 244 | /// <param name="friendlistowner">UUID of the friendlist owner</param> |
245 | /// <returns>The friendlist list</returns> | 245 | /// <returns>The friendlist list</returns> |
246 | override public List<FriendListItem> GetUserFriendList(LLUUID friendlistowner) | 246 | override public List<FriendListItem> GetUserFriendList(UUID friendlistowner) |
247 | { | 247 | { |
248 | List<FriendListItem> returnlist = new List<FriendListItem>(); | 248 | List<FriendListItem> returnlist = new List<FriendListItem>(); |
249 | 249 | ||
250 | using (SqliteCommand cmd = new SqliteCommand(SelectFriendsByUUID, g_conn)) | 250 | using (SqliteCommand cmd = new SqliteCommand(SelectFriendsByUUID, g_conn)) |
251 | { | 251 | { |
252 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friendlistowner.UUID.ToString())); | 252 | cmd.Parameters.Add(new SqliteParameter(":ownerID", friendlistowner.ToString())); |
253 | 253 | ||
254 | try | 254 | try |
255 | { | 255 | { |
@@ -259,7 +259,7 @@ namespace OpenSim.Data.SQLite | |||
259 | { | 259 | { |
260 | FriendListItem user = new FriendListItem(); | 260 | FriendListItem user = new FriendListItem(); |
261 | user.FriendListOwner = friendlistowner; | 261 | user.FriendListOwner = friendlistowner; |
262 | user.Friend = new LLUUID((string)reader[0]); | 262 | user.Friend = new UUID((string)reader[0]); |
263 | user.FriendPerms = Convert.ToUInt32(reader[1]); | 263 | user.FriendPerms = Convert.ToUInt32(reader[1]); |
264 | user.FriendListOwnerPerms = Convert.ToUInt32(reader[2]); | 264 | user.FriendListOwnerPerms = Convert.ToUInt32(reader[2]); |
265 | returnlist.Add(user); | 265 | returnlist.Add(user); |
@@ -288,7 +288,7 @@ namespace OpenSim.Data.SQLite | |||
288 | /// <param name="regionuuid">UUID of the region</param> | 288 | /// <param name="regionuuid">UUID of the region</param> |
289 | /// <param name="regionhandle">region handle</param> | 289 | /// <param name="regionhandle">region handle</param> |
290 | /// <remarks>DO NOTHING</remarks> | 290 | /// <remarks>DO NOTHING</remarks> |
291 | override public void UpdateUserCurrentRegion(LLUUID avatarid, LLUUID regionuuid, ulong regionhandle) | 291 | override public void UpdateUserCurrentRegion(UUID avatarid, UUID regionuuid, ulong regionhandle) |
292 | { | 292 | { |
293 | //m_log.Info("[USER DB]: Stub UpdateUserCUrrentRegion called"); | 293 | //m_log.Info("[USER DB]: Stub UpdateUserCUrrentRegion called"); |
294 | } | 294 | } |
@@ -299,7 +299,7 @@ namespace OpenSim.Data.SQLite | |||
299 | /// <param name="queryID"></param> | 299 | /// <param name="queryID"></param> |
300 | /// <param name="query"></param> | 300 | /// <param name="query"></param> |
301 | /// <returns></returns> | 301 | /// <returns></returns> |
302 | override public List<AvatarPickerAvatar> GeneratePickerResults(LLUUID queryID, string query) | 302 | override public List<AvatarPickerAvatar> GeneratePickerResults(UUID queryID, string query) |
303 | { | 303 | { |
304 | List<AvatarPickerAvatar> returnlist = new List<AvatarPickerAvatar>(); | 304 | List<AvatarPickerAvatar> returnlist = new List<AvatarPickerAvatar>(); |
305 | string[] querysplit; | 305 | string[] querysplit; |
@@ -316,7 +316,7 @@ namespace OpenSim.Data.SQLite | |||
316 | while (reader.Read()) | 316 | while (reader.Read()) |
317 | { | 317 | { |
318 | AvatarPickerAvatar user = new AvatarPickerAvatar(); | 318 | AvatarPickerAvatar user = new AvatarPickerAvatar(); |
319 | user.AvatarID = new LLUUID((string) reader["UUID"]); | 319 | user.AvatarID = new UUID((string) reader["UUID"]); |
320 | user.firstName = (string) reader["username"]; | 320 | user.firstName = (string) reader["username"]; |
321 | user.lastName = (string) reader["surname"]; | 321 | user.lastName = (string) reader["surname"]; |
322 | returnlist.Add(user); | 322 | returnlist.Add(user); |
@@ -337,7 +337,7 @@ namespace OpenSim.Data.SQLite | |||
337 | while (reader.Read()) | 337 | while (reader.Read()) |
338 | { | 338 | { |
339 | AvatarPickerAvatar user = new AvatarPickerAvatar(); | 339 | AvatarPickerAvatar user = new AvatarPickerAvatar(); |
340 | user.AvatarID = new LLUUID((string) reader["UUID"]); | 340 | user.AvatarID = new UUID((string) reader["UUID"]); |
341 | user.firstName = (string) reader["username"]; | 341 | user.firstName = (string) reader["username"]; |
342 | user.lastName = (string) reader["surname"]; | 342 | user.lastName = (string) reader["surname"]; |
343 | returnlist.Add(user); | 343 | returnlist.Add(user); |
@@ -354,7 +354,7 @@ namespace OpenSim.Data.SQLite | |||
354 | /// </summary> | 354 | /// </summary> |
355 | /// <param name="uuid">The user's account ID</param> | 355 | /// <param name="uuid">The user's account ID</param> |
356 | /// <returns>A matching user profile</returns> | 356 | /// <returns>A matching user profile</returns> |
357 | override public UserAgentData GetAgentByUUID(LLUUID uuid) | 357 | override public UserAgentData GetAgentByUUID(UUID uuid) |
358 | { | 358 | { |
359 | try | 359 | try |
360 | { | 360 | { |
@@ -399,7 +399,7 @@ namespace OpenSim.Data.SQLite | |||
399 | /// </summary> | 399 | /// </summary> |
400 | /// <param name="AgentID">UUID of the user</param> | 400 | /// <param name="AgentID">UUID of the user</param> |
401 | /// <param name="WebLoginKey">UUID of the weblogin</param> | 401 | /// <param name="WebLoginKey">UUID of the weblogin</param> |
402 | override public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey) | 402 | override public void StoreWebLoginKey(UUID AgentID, UUID WebLoginKey) |
403 | { | 403 | { |
404 | DataTable users = ds.Tables["users"]; | 404 | DataTable users = ds.Tables["users"]; |
405 | lock (ds) | 405 | lock (ds) |
@@ -520,7 +520,7 @@ namespace OpenSim.Data.SQLite | |||
520 | /// <param name="to">End account</param> | 520 | /// <param name="to">End account</param> |
521 | /// <param name="amount">The amount to move</param> | 521 | /// <param name="amount">The amount to move</param> |
522 | /// <returns>Success?</returns> | 522 | /// <returns>Success?</returns> |
523 | override public bool MoneyTransferRequest(LLUUID from, LLUUID to, uint amount) | 523 | override public bool MoneyTransferRequest(UUID from, UUID to, uint amount) |
524 | { | 524 | { |
525 | return true; | 525 | return true; |
526 | } | 526 | } |
@@ -533,7 +533,7 @@ namespace OpenSim.Data.SQLite | |||
533 | /// <param name="to">Receivers account</param> | 533 | /// <param name="to">Receivers account</param> |
534 | /// <param name="item">Inventory item</param> | 534 | /// <param name="item">Inventory item</param> |
535 | /// <returns>Success?</returns> | 535 | /// <returns>Success?</returns> |
536 | override public bool InventoryTransferRequest(LLUUID from, LLUUID to, LLUUID item) | 536 | override public bool InventoryTransferRequest(UUID from, UUID to, UUID item) |
537 | { | 537 | { |
538 | return true; | 538 | return true; |
539 | } | 539 | } |
@@ -545,7 +545,7 @@ namespace OpenSim.Data.SQLite | |||
545 | /// </summary> | 545 | /// </summary> |
546 | /// <param name="user">The user UUID</param> | 546 | /// <param name="user">The user UUID</param> |
547 | /// <returns>Avatar Appearence</returns> | 547 | /// <returns>Avatar Appearence</returns> |
548 | override public AvatarAppearance GetUserAppearance(LLUUID user) | 548 | override public AvatarAppearance GetUserAppearance(UUID user) |
549 | { | 549 | { |
550 | AvatarAppearance aa = null; | 550 | AvatarAppearance aa = null; |
551 | try { | 551 | try { |
@@ -562,7 +562,7 @@ namespace OpenSim.Data.SQLite | |||
562 | /// </summary> | 562 | /// </summary> |
563 | /// <param name="user">the user UUID</param> | 563 | /// <param name="user">the user UUID</param> |
564 | /// <param name="appearance">appearence</param> | 564 | /// <param name="appearance">appearence</param> |
565 | override public void UpdateUserAppearance(LLUUID user, AvatarAppearance appearance) | 565 | override public void UpdateUserAppearance(UUID user, AvatarAppearance appearance) |
566 | { | 566 | { |
567 | appearance.Owner = user; | 567 | appearance.Owner = user; |
568 | aplist[user] = appearance; | 568 | aplist[user] = appearance; |
@@ -707,8 +707,8 @@ namespace OpenSim.Data.SQLite | |||
707 | private static UserProfileData buildUserProfile(DataRow row) | 707 | private static UserProfileData buildUserProfile(DataRow row) |
708 | { | 708 | { |
709 | UserProfileData user = new UserProfileData(); | 709 | UserProfileData user = new UserProfileData(); |
710 | LLUUID tmp; | 710 | UUID tmp; |
711 | LLUUID.TryParse((String)row["UUID"], out tmp); | 711 | UUID.TryParse((String)row["UUID"], out tmp); |
712 | user.ID = tmp; | 712 | user.ID = tmp; |
713 | user.FirstName = (String) row["username"]; | 713 | user.FirstName = (String) row["username"]; |
714 | user.SurName = (String) row["surname"]; | 714 | user.SurName = (String) row["surname"]; |
@@ -717,39 +717,39 @@ namespace OpenSim.Data.SQLite | |||
717 | 717 | ||
718 | user.HomeRegionX = Convert.ToUInt32(row["homeRegionX"]); | 718 | user.HomeRegionX = Convert.ToUInt32(row["homeRegionX"]); |
719 | user.HomeRegionY = Convert.ToUInt32(row["homeRegionY"]); | 719 | user.HomeRegionY = Convert.ToUInt32(row["homeRegionY"]); |
720 | user.HomeLocation = new LLVector3( | 720 | user.HomeLocation = new Vector3( |
721 | Convert.ToSingle(row["homeLocationX"]), | 721 | Convert.ToSingle(row["homeLocationX"]), |
722 | Convert.ToSingle(row["homeLocationY"]), | 722 | Convert.ToSingle(row["homeLocationY"]), |
723 | Convert.ToSingle(row["homeLocationZ"]) | 723 | Convert.ToSingle(row["homeLocationZ"]) |
724 | ); | 724 | ); |
725 | user.HomeLookAt = new LLVector3( | 725 | user.HomeLookAt = new Vector3( |
726 | Convert.ToSingle(row["homeLookAtX"]), | 726 | Convert.ToSingle(row["homeLookAtX"]), |
727 | Convert.ToSingle(row["homeLookAtY"]), | 727 | Convert.ToSingle(row["homeLookAtY"]), |
728 | Convert.ToSingle(row["homeLookAtZ"]) | 728 | Convert.ToSingle(row["homeLookAtZ"]) |
729 | ); | 729 | ); |
730 | 730 | ||
731 | LLUUID regionID = LLUUID.Zero; | 731 | UUID regionID = UUID.Zero; |
732 | LLUUID.TryParse(row["homeRegionID"].ToString(), out regionID); // it's ok if it doesn't work; just use LLUUID.Zero | 732 | UUID.TryParse(row["homeRegionID"].ToString(), out regionID); // it's ok if it doesn't work; just use UUID.Zero |
733 | user.HomeRegionID = regionID; | 733 | user.HomeRegionID = regionID; |
734 | 734 | ||
735 | user.Created = Convert.ToInt32(row["created"]); | 735 | user.Created = Convert.ToInt32(row["created"]); |
736 | user.LastLogin = Convert.ToInt32(row["lastLogin"]); | 736 | user.LastLogin = Convert.ToInt32(row["lastLogin"]); |
737 | user.RootInventoryFolderID = new LLUUID((String) row["rootInventoryFolderID"]); | 737 | user.RootInventoryFolderID = new UUID((String) row["rootInventoryFolderID"]); |
738 | user.UserInventoryURI = (String) row["userInventoryURI"]; | 738 | user.UserInventoryURI = (String) row["userInventoryURI"]; |
739 | user.UserAssetURI = (String) row["userAssetURI"]; | 739 | user.UserAssetURI = (String) row["userAssetURI"]; |
740 | user.CanDoMask = Convert.ToUInt32(row["profileCanDoMask"]); | 740 | user.CanDoMask = Convert.ToUInt32(row["profileCanDoMask"]); |
741 | user.WantDoMask = Convert.ToUInt32(row["profileWantDoMask"]); | 741 | user.WantDoMask = Convert.ToUInt32(row["profileWantDoMask"]); |
742 | user.AboutText = (String) row["profileAboutText"]; | 742 | user.AboutText = (String) row["profileAboutText"]; |
743 | user.FirstLifeAboutText = (String) row["profileFirstText"]; | 743 | user.FirstLifeAboutText = (String) row["profileFirstText"]; |
744 | LLUUID.TryParse((String)row["profileImage"], out tmp); | 744 | UUID.TryParse((String)row["profileImage"], out tmp); |
745 | user.Image = tmp; | 745 | user.Image = tmp; |
746 | LLUUID.TryParse((String)row["profileFirstImage"], out tmp); | 746 | UUID.TryParse((String)row["profileFirstImage"], out tmp); |
747 | user.FirstLifeImage = tmp; | 747 | user.FirstLifeImage = tmp; |
748 | user.WebLoginKey = new LLUUID((String) row["webLoginKey"]); | 748 | user.WebLoginKey = new UUID((String) row["webLoginKey"]); |
749 | user.UserFlags = Convert.ToInt32(row["userFlags"]); | 749 | user.UserFlags = Convert.ToInt32(row["userFlags"]); |
750 | user.GodLevel = Convert.ToInt32(row["godLevel"]); | 750 | user.GodLevel = Convert.ToInt32(row["godLevel"]); |
751 | user.CustomType = row["customType"].ToString(); | 751 | user.CustomType = row["customType"].ToString(); |
752 | user.Partner = new LLUUID((String) row["partner"]); | 752 | user.Partner = new UUID((String) row["partner"]); |
753 | 753 | ||
754 | return user; | 754 | return user; |
755 | } | 755 | } |
@@ -814,18 +814,18 @@ namespace OpenSim.Data.SQLite | |||
814 | { | 814 | { |
815 | UserAgentData ua = new UserAgentData(); | 815 | UserAgentData ua = new UserAgentData(); |
816 | 816 | ||
817 | ua.ProfileID = new LLUUID((String) row["UUID"]); | 817 | ua.ProfileID = new UUID((String) row["UUID"]); |
818 | ua.AgentIP = (String) row["agentIP"]; | 818 | ua.AgentIP = (String) row["agentIP"]; |
819 | ua.AgentPort = Convert.ToUInt32(row["agentPort"]); | 819 | ua.AgentPort = Convert.ToUInt32(row["agentPort"]); |
820 | ua.AgentOnline = Convert.ToBoolean(row["agentOnline"]); | 820 | ua.AgentOnline = Convert.ToBoolean(row["agentOnline"]); |
821 | ua.SessionID = new LLUUID((String) row["sessionID"]); | 821 | ua.SessionID = new UUID((String) row["sessionID"]); |
822 | ua.SecureSessionID = new LLUUID((String) row["secureSessionID"]); | 822 | ua.SecureSessionID = new UUID((String) row["secureSessionID"]); |
823 | ua.InitialRegion = new LLUUID((String) row["regionID"]); | 823 | ua.InitialRegion = new UUID((String) row["regionID"]); |
824 | ua.LoginTime = Convert.ToInt32(row["loginTime"]); | 824 | ua.LoginTime = Convert.ToInt32(row["loginTime"]); |
825 | ua.LogoutTime = Convert.ToInt32(row["logoutTime"]); | 825 | ua.LogoutTime = Convert.ToInt32(row["logoutTime"]); |
826 | ua.Region = new LLUUID((String) row["currentRegion"]); | 826 | ua.Region = new UUID((String) row["currentRegion"]); |
827 | ua.Handle = Convert.ToUInt64(row["currentHandle"]); | 827 | ua.Handle = Convert.ToUInt64(row["currentHandle"]); |
828 | ua.Position = new LLVector3( | 828 | ua.Position = new Vector3( |
829 | Convert.ToSingle(row["currentPosX"]), | 829 | Convert.ToSingle(row["currentPosX"]), |
830 | Convert.ToSingle(row["currentPosY"]), | 830 | Convert.ToSingle(row["currentPosY"]), |
831 | Convert.ToSingle(row["currentPosZ"]) | 831 | Convert.ToSingle(row["currentPosZ"]) |
@@ -906,7 +906,7 @@ namespace OpenSim.Data.SQLite | |||
906 | 906 | ||
907 | } | 907 | } |
908 | 908 | ||
909 | override public void ResetAttachments(LLUUID userID) | 909 | override public void ResetAttachments(UUID userID) |
910 | { | 910 | { |
911 | } | 911 | } |
912 | } | 912 | } |