aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
diff options
context:
space:
mode:
authorJustin Clarke Casey2008-09-29 15:22:48 +0000
committerJustin Clarke Casey2008-09-29 15:22:48 +0000
commit4daaac662ff5e952cf13ac093688f56045821250 (patch)
tree466f08a3acbb7514659f4fa2a267fbe75c56ab16 /OpenSim/Data/MSSQL/MSSQLInventoryData.cs
parent* reactor: move inventory archive classes into separate Inventory/Archiver di... (diff)
downloadopensim-SC_OLD-4daaac662ff5e952cf13ac093688f56045821250.zip
opensim-SC_OLD-4daaac662ff5e952cf13ac093688f56045821250.tar.gz
opensim-SC_OLD-4daaac662ff5e952cf13ac093688f56045821250.tar.bz2
opensim-SC_OLD-4daaac662ff5e952cf13ac093688f56045821250.tar.xz
* 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
Diffstat (limited to 'OpenSim/Data/MSSQL/MSSQLInventoryData.cs')
-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}