aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/MSSQL/MSSQLInventoryData.cs30
1 files changed, 26 insertions, 4 deletions
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
611 } 611 }
612 } 612 }
613 613
614 /// <summary>
615 /// Returns all activated gesture-items in the inventory of the specified avatar.
616 /// </summary>
617 /// <param name="avatarID">The <see cref="UUID"/> of the avatar</param>
618 /// <returns>
619 /// The list of gestures (<see cref="InventoryItemBase"/>s)
620 /// </returns>
621 public List<InventoryItemBase> fetchActiveGestures(UUID avatarID)
622 {
623 using (AutoClosingSqlCommand command = database.Query("SELECT * FROM inventoryitems WHERE avatarId = @uuid AND assetType = @assetType and flags = 1"))
624 {
625 command.Parameters.Add(database.CreateParameter("uuid", avatarID));
626 command.Parameters.Add(database.CreateParameter("assetType", (int)AssetType.Gesture));
627
628 using (IDataReader reader = command.ExecuteReader())
629 {
630 List<InventoryItemBase> gestureList = new List<InventoryItemBase>();
631 while (reader.Read())
632 {
633 gestureList.Add(readInventoryItem(reader));
634 }
635 return gestureList;
636 }
637 }
638 }
639
614 #endregion 640 #endregion
615 641
616 #region Private methods 642 #region Private methods
@@ -799,10 +825,6 @@ namespace OpenSim.Data.MSSQL
799 } 825 }
800 } 826 }
801 827
802 public List<InventoryItemBase> fetchActiveGestures (UUID avatarID)
803 {
804 return null;
805 }
806 #endregion 828 #endregion
807 } 829 }
808} 830}