From 4daaac662ff5e952cf13ac093688f56045821250 Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Mon, 29 Sep 2008 15:22:48 +0000
Subject: * Apply http://opensimulator.org/mantis/view.php?id=2295 * Updated
 MSSQL to reflect resend changes * Added the new columns in prims table. *
 Created a implementation for getting gestures. * Remove configurable table
 names for user. * Thanks Ruud Lathorp

---
 OpenSim/Data/MSSQL/MSSQLInventoryData.cs | 30 ++++++++++++++++++++++++++----
 1 file changed, 26 insertions(+), 4 deletions(-)

(limited to 'OpenSim/Data/MSSQL/MSSQLInventoryData.cs')

diff --git a/OpenSim/Data/MSSQL/MSSQLInventoryData.cs b/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
index 2b9913c..79bab3b 100644
--- a/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
@@ -611,6 +611,32 @@ namespace OpenSim.Data.MSSQL
             }
         }
 
+        /// <summary>
+        /// Returns all activated gesture-items in the inventory of the specified avatar.
+        /// </summary>
+        /// <param name="avatarID">The <see cref="UUID"/> of the avatar</param>
+        /// <returns>
+        /// The list of gestures (<see cref="InventoryItemBase"/>s)
+        /// </returns>
+        public List<InventoryItemBase> fetchActiveGestures(UUID avatarID)
+        {
+            using (AutoClosingSqlCommand command = database.Query("SELECT * FROM inventoryitems WHERE avatarId = @uuid AND assetType = @assetType and flags = 1"))
+            {
+                command.Parameters.Add(database.CreateParameter("uuid", avatarID));
+                command.Parameters.Add(database.CreateParameter("assetType", (int)AssetType.Gesture));
+
+                using (IDataReader reader = command.ExecuteReader())
+                {
+                    List<InventoryItemBase> gestureList = new List<InventoryItemBase>();
+                    while (reader.Read())
+                    {
+                        gestureList.Add(readInventoryItem(reader));
+                    }
+                    return gestureList;
+                }
+            }
+        }
+
         #endregion
 
         #region Private methods
@@ -799,10 +825,6 @@ namespace OpenSim.Data.MSSQL
             }
         }
 
-        public List<InventoryItemBase> fetchActiveGestures (UUID avatarID)
-        {
-            return null;
-        }
         #endregion
     }
 }
-- 
cgit v1.1