Thank you, StrawberryFride, for a patch that adds offline inventory

functionality to the MSSQL module.
Fixes Mantis #3370

1 files changed, 15 insertions, 2 deletions

diff --git a/OpenSim/Data/MSSQL/MSSQLInventoryData.cs b/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
index 1349f29..fe8287d 100644
--- a/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
@@ -445,6 +445,19 @@ namespace OpenSim.Data.MSSQL
                 }
             }
 
+            sql = "UPDATE inventoryfolders SET version = version + 1 WHERE folderID = @folderID";
+            using (AutoClosingSqlCommand command = database.Query(sql))
+            {
+                command.Parameters.Add(database.CreateParameter("folderID", item.Folder.ToString()));
+                try
+                {
+                    command.ExecuteNonQuery();
+                }
+                catch (Exception e)
+                {
+                    m_log.Error("[INVENTORY DB] Error updating inventory folder for new item :" + e.Message);
+                }
+            }
         }
 
         /// <summary>
@@ -532,12 +545,12 @@ namespace OpenSim.Data.MSSQL
 
         public InventoryItemBase queryInventoryItem(UUID itemID)
         {
-            return null;
+            return getInventoryItem(itemID);
         }
 
         public InventoryFolderBase queryInventoryFolder(UUID folderID)
         {
-            return null;
+            return getInventoryFolder(folderID);
         }
 
         /// <summary>