diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLInventoryData.cs | 2 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/MySQLXInventoryData.cs | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/MySQLInventoryData.cs b/OpenSim/Data/MySQL/MySQLInventoryData.cs index 2dca3eb..9d70acb 100644 --- a/OpenSim/Data/MySQL/MySQLInventoryData.cs +++ b/OpenSim/Data/MySQL/MySQLInventoryData.cs | |||
@@ -867,7 +867,7 @@ namespace OpenSim.Data.MySQL | |||
867 | dbcon.Open(); | 867 | dbcon.Open(); |
868 | 868 | ||
869 | using (MySqlCommand sqlCmd = new MySqlCommand( | 869 | using (MySqlCommand sqlCmd = new MySqlCommand( |
870 | "SELECT * FROM inventoryitems WHERE avatarId = ?uuid AND assetType = ?type and flags = 1", dbcon)) | 870 | "SELECT * FROM inventoryitems WHERE avatarId = ?uuid AND assetType = ?type and flags & 1", dbcon)) |
871 | { | 871 | { |
872 | sqlCmd.Parameters.AddWithValue("?uuid", avatarID.ToString()); | 872 | sqlCmd.Parameters.AddWithValue("?uuid", avatarID.ToString()); |
873 | sqlCmd.Parameters.AddWithValue("?type", (int)AssetType.Gesture); | 873 | sqlCmd.Parameters.AddWithValue("?type", (int)AssetType.Gesture); |
diff --git a/OpenSim/Data/MySQL/MySQLXInventoryData.cs b/OpenSim/Data/MySQL/MySQLXInventoryData.cs index 3c73095..287c4dd 100644 --- a/OpenSim/Data/MySQL/MySQLXInventoryData.cs +++ b/OpenSim/Data/MySQL/MySQLXInventoryData.cs | |||
@@ -130,7 +130,7 @@ namespace OpenSim.Data.MySQL | |||
130 | { | 130 | { |
131 | using (MySqlCommand cmd = new MySqlCommand()) | 131 | using (MySqlCommand cmd = new MySqlCommand()) |
132 | { | 132 | { |
133 | cmd.CommandText = String.Format("select * from inventoryitems where avatarId = ?uuid and assetType = ?type and flags = 1", m_Realm); | 133 | cmd.CommandText = String.Format("select * from inventoryitems where avatarId = ?uuid and assetType = ?type and flags & 1", m_Realm); |
134 | 134 | ||
135 | cmd.Parameters.AddWithValue("?uuid", principalID.ToString()); | 135 | cmd.Parameters.AddWithValue("?uuid", principalID.ToString()); |
136 | cmd.Parameters.AddWithValue("?type", (int)AssetType.Gesture); | 136 | cmd.Parameters.AddWithValue("?type", (int)AssetType.Gesture); |