diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLInventoryData.cs | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/MySQLInventoryData.cs b/OpenSim/Data/MySQL/MySQLInventoryData.cs index 755dbab..efc781d 100644 --- a/OpenSim/Data/MySQL/MySQLInventoryData.cs +++ b/OpenSim/Data/MySQL/MySQLInventoryData.cs | |||
@@ -333,6 +333,7 @@ namespace OpenSim.Data.MySQL | |||
333 | item.InvType = (int) reader["invType"]; | 333 | item.InvType = (int) reader["invType"]; |
334 | item.BasePermissions = (uint) reader["inventoryBasePermissions"]; | 334 | item.BasePermissions = (uint) reader["inventoryBasePermissions"]; |
335 | item.EveryOnePermissions = (uint) reader["inventoryEveryOnePermissions"]; | 335 | item.EveryOnePermissions = (uint) reader["inventoryEveryOnePermissions"]; |
336 | item.GroupPermissions = (uint) reader["inventoryGroupPermissions"]; | ||
336 | item.SalePrice = (int) reader["salePrice"]; | 337 | item.SalePrice = (int) reader["salePrice"]; |
337 | item.SaleType = Convert.ToByte(reader["saleType"]); | 338 | item.SaleType = Convert.ToByte(reader["saleType"]); |
338 | item.CreationDate = (int) reader["creationDate"]; | 339 | item.CreationDate = (int) reader["creationDate"]; |
@@ -455,12 +456,12 @@ namespace OpenSim.Data.MySQL | |||
455 | string sql = | 456 | string sql = |
456 | "REPLACE INTO inventoryitems (inventoryID, assetID, assetType, parentFolderID, avatarID, inventoryName" | 457 | "REPLACE INTO inventoryitems (inventoryID, assetID, assetType, parentFolderID, avatarID, inventoryName" |
457 | + ", inventoryDescription, inventoryNextPermissions, inventoryCurrentPermissions, invType" | 458 | + ", inventoryDescription, inventoryNextPermissions, inventoryCurrentPermissions, invType" |
458 | + ", creatorID, inventoryBasePermissions, inventoryEveryOnePermissions, salePrice, saleType" | 459 | + ", creatorID, inventoryBasePermissions, inventoryEveryOnePermissions, inventoryGroupPermissions, salePrice, saleType" |
459 | + ", creationDate, groupID, groupOwned, flags) VALUES "; | 460 | + ", creationDate, groupID, groupOwned, flags) VALUES "; |
460 | sql += | 461 | sql += |
461 | "(?inventoryID, ?assetID, ?assetType, ?parentFolderID, ?avatarID, ?inventoryName, ?inventoryDescription" | 462 | "(?inventoryID, ?assetID, ?assetType, ?parentFolderID, ?avatarID, ?inventoryName, ?inventoryDescription" |
462 | + ", ?inventoryNextPermissions, ?inventoryCurrentPermissions, ?invType, ?creatorID" | 463 | + ", ?inventoryNextPermissions, ?inventoryCurrentPermissions, ?invType, ?creatorID" |
463 | + ", ?inventoryBasePermissions, ?inventoryEveryOnePermissions, ?salePrice, ?saleType, ?creationDate" | 464 | + ", ?inventoryBasePermissions, ?inventoryEveryOnePermissions, ?inventoryGroupPermissions, ?salePrice, ?saleType, ?creationDate" |
464 | + ", ?groupID, ?groupOwned, ?flags)"; | 465 | + ", ?groupID, ?groupOwned, ?flags)"; |
465 | 466 | ||
466 | try | 467 | try |
@@ -482,6 +483,7 @@ namespace OpenSim.Data.MySQL | |||
482 | result.Parameters.AddWithValue("?creatorID", item.Creator.ToString()); | 483 | result.Parameters.AddWithValue("?creatorID", item.Creator.ToString()); |
483 | result.Parameters.AddWithValue("?inventoryBasePermissions", item.BasePermissions); | 484 | result.Parameters.AddWithValue("?inventoryBasePermissions", item.BasePermissions); |
484 | result.Parameters.AddWithValue("?inventoryEveryOnePermissions", item.EveryOnePermissions); | 485 | result.Parameters.AddWithValue("?inventoryEveryOnePermissions", item.EveryOnePermissions); |
486 | result.Parameters.AddWithValue("?inventoryGroupPermissions", item.GroupPermissions); | ||
485 | result.Parameters.AddWithValue("?salePrice", item.SalePrice); | 487 | result.Parameters.AddWithValue("?salePrice", item.SalePrice); |
486 | result.Parameters.AddWithValue("?saleType", item.SaleType); | 488 | result.Parameters.AddWithValue("?saleType", item.SaleType); |
487 | result.Parameters.AddWithValue("?creationDate", item.CreationDate); | 489 | result.Parameters.AddWithValue("?creationDate", item.CreationDate); |