From fe9aea258ff4142e718b4916ccefeeedef229768 Mon Sep 17 00:00:00 2001
From: Homer Horwitz
Date: Wed, 24 Sep 2008 21:12:21 +0000
Subject: Add persistence of active gestures. This needs an UGAIM update to
 work. Active gestures are sent as part of the login-response. Added
 fetchActiveGestures to SQLite and MySQL; added an empty one for MSSQL and
 NHibernate. Using the empty ones won't cause errors, but doesn't provide
 persistence either, of course.

---
 OpenSim/Data/MySQL/MySQLInventoryData.cs | 36 ++++++++++++++++++++++++++++++++
 1 file changed, 36 insertions(+)

(limited to 'OpenSim/Data/MySQL')

diff --git a/OpenSim/Data/MySQL/MySQLInventoryData.cs b/OpenSim/Data/MySQL/MySQLInventoryData.cs
index 50d3cc7..68885e1 100644
--- a/OpenSim/Data/MySQL/MySQLInventoryData.cs
+++ b/OpenSim/Data/MySQL/MySQLInventoryData.cs
@@ -795,5 +795,41 @@ namespace OpenSim.Data.MySQL
             deleteOneFolder(folderID);
             deleteItemsInFolder(folderID);
         }
+        
+        public List<InventoryItemBase> fetchActiveGestures(UUID avatarID)
+        {
+            MySqlDataReader result = null;
+            MySqlCommand sqlCmd = null;
+            lock (database)
+            {
+                try
+                {
+                    database.CheckConnection();
+                    sqlCmd = new MySqlCommand(
+                        "SELECT * FROM inventoryitems WHERE avatarId = ?uuid AND assetType = ?type and flags = 1",
+                        database.Connection);
+                    sqlCmd.Parameters.AddWithValue("?uuid", avatarID.ToString());
+                    sqlCmd.Parameters.AddWithValue("?type", (int)AssetType.Gesture);
+                    result = sqlCmd.ExecuteReader();
+
+                    List<InventoryItemBase> list = new List<InventoryItemBase>();
+                    while (result.Read())
+                        list.Add(readInventoryItem(result));
+
+                    return list;
+                }
+                catch (Exception e)
+                {
+                    database.Reconnect();
+                    m_log.Error(e.ToString());
+                    return null;
+                }
+                finally
+                {
+                    if(result != null) result.Close();
+                    if(sqlCmd != null) sqlCmd.Dispose();
+                }
+            }
+        }
     }
 }
-- 
cgit v1.1