XInventoryService.cs 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775
  1. /*
  2. * Copyright (c) Contributors, http://opensimulator.org/
  3. * See CONTRIBUTORS.TXT for a full list of copyright holders.
  4. *
  5. * Redistribution and use in source and binary forms, with or without
  6. * modification, are permitted provided that the following conditions are met:
  7. * * Redistributions of source code must retain the above copyright
  8. * notice, this list of conditions and the following disclaimer.
  9. * * Redistributions in binary form must reproduce the above copyright
  10. * notice, this list of conditions and the following disclaimer in the
  11. * documentation and/or other materials provided with the distribution.
  12. * * Neither the name of the OpenSimulator Project nor the
  13. * names of its contributors may be used to endorse or promote products
  14. * derived from this software without specific prior written permission.
  15. *
  16. * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY
  17. * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
  18. * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  19. * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY
  20. * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
  21. * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
  22. * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  23. * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  24. * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
  25. * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  26. */
  27. using System;
  28. using System.Collections.Generic;
  29. using OpenMetaverse;
  30. using log4net;
  31. using Nini.Config;
  32. using System.Reflection;
  33. using OpenSim.Services.Base;
  34. using OpenSim.Services.Interfaces;
  35. using OpenSim.Data;
  36. using OpenSim.Framework;
  37. namespace OpenSim.Services.InventoryService
  38. {
  39. public class XInventoryService : ServiceBase, IInventoryService
  40. {
  41. private static readonly ILog m_log =
  42. LogManager.GetLogger(
  43. MethodBase.GetCurrentMethod().DeclaringType);
  44. protected IXInventoryData m_Database;
  45. protected bool m_AllowDelete = true;
  46. protected string m_ConfigName = "InventoryService";
  47. public XInventoryService(IConfigSource config)
  48. : this(config, "InventoryService")
  49. {
  50. }
  51. public XInventoryService(IConfigSource config, string configName) : base(config)
  52. {
  53. if (configName != string.Empty)
  54. m_ConfigName = configName;
  55. string dllName = String.Empty;
  56. string connString = String.Empty;
  57. //string realm = "Inventory"; // OSG version doesn't use this
  58. //
  59. // Try reading the [InventoryService] section first, if it exists
  60. //
  61. IConfig authConfig = config.Configs[m_ConfigName];
  62. if (authConfig != null)
  63. {
  64. dllName = authConfig.GetString("StorageProvider", dllName);
  65. connString = authConfig.GetString("ConnectionString", connString);
  66. m_AllowDelete = authConfig.GetBoolean("AllowDelete", true);
  67. // realm = authConfig.GetString("Realm", realm);
  68. }
  69. //
  70. // Try reading the [DatabaseService] section, if it exists
  71. //
  72. IConfig dbConfig = config.Configs["DatabaseService"];
  73. if (dbConfig != null)
  74. {
  75. if (dllName == String.Empty)
  76. dllName = dbConfig.GetString("StorageProvider", String.Empty);
  77. if (connString == String.Empty)
  78. connString = dbConfig.GetString("ConnectionString", String.Empty);
  79. }
  80. //
  81. // We tried, but this doesn't exist. We can't proceed.
  82. //
  83. if (dllName == String.Empty)
  84. throw new Exception("No StorageProvider configured");
  85. m_Database = LoadPlugin<IXInventoryData>(dllName,
  86. new Object[] {connString, String.Empty});
  87. if (m_Database == null)
  88. throw new Exception("Could not find a storage interface in the given module");
  89. }
  90. public virtual bool CreateUserInventory(UUID principalID)
  91. {
  92. // This is braindeaad. We can't ever communicate that we fixed
  93. // an existing inventory. Well, just return root folder status,
  94. // but check sanity anyway.
  95. //
  96. bool result = false;
  97. InventoryFolderBase rootFolder = GetRootFolder(principalID);
  98. if (rootFolder == null)
  99. {
  100. rootFolder = ConvertToOpenSim(CreateFolder(principalID, UUID.Zero, (int)AssetType.RootFolder, "My Inventory"));
  101. result = true;
  102. }
  103. XInventoryFolder[] sysFolders = GetSystemFolders(principalID, rootFolder.ID);
  104. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Animation) return true; return false; }))
  105. CreateFolder(principalID, rootFolder.ID, (int)AssetType.Animation, "Animations");
  106. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Bodypart) return true; return false; }))
  107. CreateFolder(principalID, rootFolder.ID, (int)AssetType.Bodypart, "Body Parts");
  108. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.CallingCard) return true; return false; }))
  109. CreateFolder(principalID, rootFolder.ID, (int)AssetType.CallingCard, "Calling Cards");
  110. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Clothing) return true; return false; }))
  111. CreateFolder(principalID, rootFolder.ID, (int)AssetType.Clothing, "Clothing");
  112. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Gesture) return true; return false; }))
  113. CreateFolder(principalID, rootFolder.ID, (int)AssetType.Gesture, "Gestures");
  114. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Landmark) return true; return false; }))
  115. CreateFolder(principalID, rootFolder.ID, (int)AssetType.Landmark, "Landmarks");
  116. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.LostAndFoundFolder) return true; return false; }))
  117. CreateFolder(principalID, rootFolder.ID, (int)AssetType.LostAndFoundFolder, "Lost And Found");
  118. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Notecard) return true; return false; }))
  119. CreateFolder(principalID, rootFolder.ID, (int)AssetType.Notecard, "Notecards");
  120. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Object) return true; return false; }))
  121. CreateFolder(principalID, rootFolder.ID, (int)AssetType.Object, "Objects");
  122. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.SnapshotFolder) return true; return false; }))
  123. CreateFolder(principalID, rootFolder.ID, (int)AssetType.SnapshotFolder, "Photo Album");
  124. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.LSLText) return true; return false; }))
  125. CreateFolder(principalID, rootFolder.ID, (int)AssetType.LSLText, "Scripts");
  126. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Sound) return true; return false; }))
  127. CreateFolder(principalID, rootFolder.ID, (int)AssetType.Sound, "Sounds");
  128. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Texture) return true; return false; }))
  129. CreateFolder(principalID, rootFolder.ID, (int)AssetType.Texture, "Textures");
  130. if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.TrashFolder) return true; return false; }))
  131. CreateFolder(principalID, rootFolder.ID, (int)AssetType.TrashFolder, "Trash");
  132. return result;
  133. }
  134. protected XInventoryFolder CreateFolder(UUID principalID, UUID parentID, int type, string name)
  135. {
  136. XInventoryFolder newFolder = new XInventoryFolder();
  137. newFolder.folderName = name;
  138. newFolder.type = type;
  139. newFolder.version = 1;
  140. newFolder.folderID = UUID.Random();
  141. newFolder.agentID = principalID;
  142. newFolder.parentFolderID = parentID;
  143. m_Database.StoreFolder(newFolder);
  144. return newFolder;
  145. }
  146. protected virtual XInventoryFolder[] GetSystemFolders(UUID principalID, UUID rootID)
  147. {
  148. // m_log.DebugFormat("[XINVENTORY SERVICE]: Getting system folders for {0}", principalID);
  149. XInventoryFolder[] allFolders = m_Database.GetFolders(
  150. new string[] { "agentID", "parentFolderID" },
  151. new string[] { principalID.ToString(), rootID.ToString() });
  152. XInventoryFolder[] sysFolders = Array.FindAll(
  153. allFolders,
  154. delegate (XInventoryFolder f)
  155. {
  156. if (f.type > 0)
  157. return true;
  158. return false;
  159. });
  160. // m_log.DebugFormat(
  161. // "[XINVENTORY SERVICE]: Found {0} system folders for {1}", sysFolders.Length, principalID);
  162. return sysFolders;
  163. }
  164. public virtual List<InventoryFolderBase> GetInventorySkeleton(UUID principalID)
  165. {
  166. XInventoryFolder[] allFolders = m_Database.GetFolders(
  167. new string[] { "agentID" },
  168. new string[] { principalID.ToString() });
  169. if (allFolders.Length == 0)
  170. return null;
  171. List<InventoryFolderBase> folders = new List<InventoryFolderBase>();
  172. foreach (XInventoryFolder x in allFolders)
  173. {
  174. //m_log.DebugFormat("[XINVENTORY SERVICE]: Adding folder {0} to skeleton", x.folderName);
  175. folders.Add(ConvertToOpenSim(x));
  176. }
  177. return folders;
  178. }
  179. public virtual InventoryFolderBase GetRootFolder(UUID principalID)
  180. {
  181. XInventoryFolder[] folders = m_Database.GetFolders(
  182. new string[] { "agentID", "parentFolderID"},
  183. new string[] { principalID.ToString(), UUID.Zero.ToString() });
  184. if (folders.Length == 0)
  185. return null;
  186. XInventoryFolder root = null;
  187. foreach (XInventoryFolder folder in folders)
  188. {
  189. if (folder.folderName == "My Inventory")
  190. {
  191. root = folder;
  192. break;
  193. }
  194. }
  195. if (root == null) // oops
  196. root = folders[0];
  197. return ConvertToOpenSim(root);
  198. }
  199. public virtual InventoryFolderBase GetFolderForType(UUID principalID, AssetType type)
  200. {
  201. // m_log.DebugFormat("[XINVENTORY SERVICE]: Getting folder type {0} for user {1}", type, principalID);
  202. InventoryFolderBase rootFolder = GetRootFolder(principalID);
  203. if (rootFolder == null)
  204. {
  205. m_log.WarnFormat(
  206. "[XINVENTORY]: Found no root folder for {0} in GetFolderForType() when looking for {1}",
  207. principalID, type);
  208. return null;
  209. }
  210. return GetSystemFolderForType(rootFolder, type);
  211. }
  212. private InventoryFolderBase GetSystemFolderForType(InventoryFolderBase rootFolder, AssetType type)
  213. {
  214. // m_log.DebugFormat("[XINVENTORY SERVICE]: Getting folder type {0} for user {1}", type, principalID);
  215. if (type == AssetType.RootFolder)
  216. return rootFolder;
  217. XInventoryFolder[] folders = m_Database.GetFolders(
  218. new string[] { "agentID", "parentFolderID", "type"},
  219. new string[] { rootFolder.Owner.ToString(), rootFolder.ID.ToString(), ((int)type).ToString() });
  220. if (folders.Length == 0)
  221. {
  222. // m_log.WarnFormat("[XINVENTORY SERVICE]: Found no folder for type {0} for user {1}", type, principalID);
  223. return null;
  224. }
  225. // m_log.DebugFormat(
  226. // "[XINVENTORY SERVICE]: Found folder {0} {1} for type {2} for user {3}",
  227. // folders[0].folderName, folders[0].folderID, type, principalID);
  228. return ConvertToOpenSim(folders[0]);
  229. }
  230. public virtual InventoryCollection GetFolderContent(UUID principalID, UUID folderID)
  231. {
  232. // This method doesn't receive a valud principal id from the
  233. // connector. So we disregard the principal and look
  234. // by ID.
  235. //
  236. //m_log.DebugFormat("[XINVENTORY SERVICE]: Fetch contents for folder {0}", folderID.ToString());
  237. InventoryCollection inventory = new InventoryCollection();
  238. inventory.UserID = principalID;
  239. inventory.Folders = new List<InventoryFolderBase>();
  240. inventory.Items = new List<InventoryItemBase>();
  241. XInventoryFolder[] folders = m_Database.GetFolders(
  242. new string[] { "parentFolderID"},
  243. new string[] { folderID.ToString() });
  244. foreach (XInventoryFolder x in folders)
  245. {
  246. //m_log.DebugFormat("[XINVENTORY]: Adding folder {0} to response", x.folderName);
  247. inventory.Folders.Add(ConvertToOpenSim(x));
  248. }
  249. XInventoryItem[] items = m_Database.GetItems(
  250. new string[] { "parentFolderID"},
  251. new string[] { folderID.ToString() });
  252. foreach (XInventoryItem i in items)
  253. {
  254. //m_log.DebugFormat("[XINVENTORY]: Adding item {0} to response", i.inventoryName);
  255. inventory.Items.Add(ConvertToOpenSim(i));
  256. }
  257. return inventory;
  258. }
  259. public virtual List<InventoryItemBase> GetFolderItems(UUID principalID, UUID folderID)
  260. {
  261. // m_log.DebugFormat("[XINVENTORY]: Fetch items for folder {0}", folderID);
  262. // Since we probably don't get a valid principal here, either ...
  263. //
  264. List<InventoryItemBase> invItems = new List<InventoryItemBase>();
  265. XInventoryItem[] items = m_Database.GetItems(
  266. new string[] { "parentFolderID" },
  267. new string[] { folderID.ToString() });
  268. foreach (XInventoryItem i in items)
  269. invItems.Add(ConvertToOpenSim(i));
  270. return invItems;
  271. }
  272. public virtual bool AddFolder(InventoryFolderBase folder)
  273. {
  274. // m_log.DebugFormat("[XINVENTORY]: Add folder {0} type {1} in parent {2}", folder.Name, folder.Type, folder.ParentID);
  275. InventoryFolderBase check = GetFolder(folder);
  276. if (check != null)
  277. return false;
  278. if (folder.Type != (short)AssetType.Folder && folder.Type != (short)AssetType.Unknown)
  279. {
  280. InventoryFolderBase rootFolder = GetRootFolder(folder.Owner);
  281. if (rootFolder == null)
  282. {
  283. m_log.WarnFormat(
  284. "[XINVENTORY]: Found no root folder for {0} in AddFolder() when looking for {1}",
  285. folder.Owner, folder.Type);
  286. return false;
  287. }
  288. // Check we're not trying to add this as a system folder.
  289. if (folder.ParentID == rootFolder.ID)
  290. {
  291. InventoryFolderBase existingSystemFolder
  292. = GetSystemFolderForType(rootFolder, (AssetType)folder.Type);
  293. if (existingSystemFolder != null)
  294. {
  295. m_log.WarnFormat(
  296. "[XINVENTORY]: System folder of type {0} already exists when tried to add {1} to {2} for {3}",
  297. folder.Type, folder.Name, folder.ParentID, folder.Owner);
  298. return false;
  299. }
  300. }
  301. }
  302. XInventoryFolder xFolder = ConvertFromOpenSim(folder);
  303. return m_Database.StoreFolder(xFolder);
  304. }
  305. public virtual bool UpdateFolder(InventoryFolderBase folder)
  306. {
  307. // m_log.DebugFormat("[XINVENTORY]: Update folder {0} {1} ({2})", folder.Name, folder.Type, folder.ID);
  308. XInventoryFolder xFolder = ConvertFromOpenSim(folder);
  309. InventoryFolderBase check = GetFolder(folder);
  310. if (check == null)
  311. return AddFolder(folder);
  312. if ((check.Type != (short)AssetType.Unknown || xFolder.type != (short)AssetType.Unknown)
  313. && (check.Type != (short)AssetType.OutfitFolder || xFolder.type != (short)AssetType.OutfitFolder))
  314. {
  315. if (xFolder.version < check.Version)
  316. {
  317. // m_log.DebugFormat("[XINVENTORY]: {0} < {1} can't do", xFolder.version, check.Version);
  318. return false;
  319. }
  320. check.Version = (ushort)xFolder.version;
  321. xFolder = ConvertFromOpenSim(check);
  322. // m_log.DebugFormat(
  323. // "[XINVENTORY]: Storing version only update to system folder {0} {1} {2}",
  324. // xFolder.folderName, xFolder.version, xFolder.type);
  325. return m_Database.StoreFolder(xFolder);
  326. }
  327. if (xFolder.version < check.Version)
  328. xFolder.version = check.Version;
  329. xFolder.folderID = check.ID;
  330. return m_Database.StoreFolder(xFolder);
  331. }
  332. public virtual bool MoveFolder(InventoryFolderBase folder)
  333. {
  334. return m_Database.MoveFolder(folder.ID.ToString(), folder.ParentID.ToString());
  335. }
  336. // We don't check the principal's ID here
  337. //
  338. public virtual bool DeleteFolders(UUID principalID, List<UUID> folderIDs)
  339. {
  340. return DeleteFolders(principalID, folderIDs, true);
  341. }
  342. public virtual bool DeleteFolders(UUID principalID, List<UUID> folderIDs, bool onlyIfTrash)
  343. {
  344. if (!m_AllowDelete)
  345. return false;
  346. // Ignore principal ID, it's bogus at connector level
  347. //
  348. foreach (UUID id in folderIDs)
  349. {
  350. if (onlyIfTrash && !ParentIsTrash(id))
  351. continue;
  352. //m_log.InfoFormat("[XINVENTORY SERVICE]: Delete folder {0}", id);
  353. InventoryFolderBase f = new InventoryFolderBase();
  354. f.ID = id;
  355. PurgeFolder(f, onlyIfTrash);
  356. m_Database.DeleteFolders("folderID", id.ToString());
  357. }
  358. return true;
  359. }
  360. public virtual bool PurgeFolder(InventoryFolderBase folder)
  361. {
  362. return PurgeFolder(folder, true);
  363. }
  364. public virtual bool PurgeFolder(InventoryFolderBase folder, bool onlyIfTrash)
  365. {
  366. if (!m_AllowDelete)
  367. return false;
  368. if (onlyIfTrash && !ParentIsTrash(folder.ID))
  369. return false;
  370. XInventoryFolder[] subFolders = m_Database.GetFolders(
  371. new string[] { "parentFolderID" },
  372. new string[] { folder.ID.ToString() });
  373. foreach (XInventoryFolder x in subFolders)
  374. {
  375. PurgeFolder(ConvertToOpenSim(x), onlyIfTrash);
  376. m_Database.DeleteFolders("folderID", x.folderID.ToString());
  377. }
  378. m_Database.DeleteItems("parentFolderID", folder.ID.ToString());
  379. return true;
  380. }
  381. public virtual bool AddItem(InventoryItemBase item)
  382. {
  383. // m_log.DebugFormat(
  384. // "[XINVENTORY SERVICE]: Adding item {0} {1} to folder {2} for {3}", item.Name, item.ID, item.Folder, item.Owner);
  385. return m_Database.StoreItem(ConvertFromOpenSim(item));
  386. }
  387. public virtual bool UpdateItem(InventoryItemBase item)
  388. {
  389. if (!m_AllowDelete)
  390. if (item.AssetType == (sbyte)AssetType.Link || item.AssetType == (sbyte)AssetType.LinkFolder)
  391. return false;
  392. // m_log.InfoFormat(
  393. // "[XINVENTORY SERVICE]: Updating item {0} {1} in folder {2}", item.Name, item.ID, item.Folder);
  394. InventoryItemBase retrievedItem = GetItem(item);
  395. if (retrievedItem == null)
  396. {
  397. m_log.WarnFormat(
  398. "[XINVENTORY SERVICE]: Tried to update item {0} {1}, owner {2} but no existing item found.",
  399. item.Name, item.ID, item.Owner);
  400. return false;
  401. }
  402. // Do not allow invariants to change. Changes to folder ID occur in MoveItems()
  403. if (retrievedItem.InvType != item.InvType
  404. || retrievedItem.AssetType != item.AssetType
  405. || retrievedItem.Folder != item.Folder
  406. || retrievedItem.CreatorIdentification != item.CreatorIdentification
  407. || retrievedItem.Owner != item.Owner)
  408. {
  409. m_log.WarnFormat(
  410. "[XINVENTORY SERVICE]: Caller to UpdateItem() for {0} {1} tried to alter property(s) that should be invariant, (InvType, AssetType, Folder, CreatorIdentification, Owner), existing ({2}, {3}, {4}, {5}, {6}), update ({7}, {8}, {9}, {10}, {11})",
  411. retrievedItem.Name,
  412. retrievedItem.ID,
  413. retrievedItem.InvType,
  414. retrievedItem.AssetType,
  415. retrievedItem.Folder,
  416. retrievedItem.CreatorIdentification,
  417. retrievedItem.Owner,
  418. item.InvType,
  419. item.AssetType,
  420. item.Folder,
  421. item.CreatorIdentification,
  422. item.Owner);
  423. item.InvType = retrievedItem.InvType;
  424. item.AssetType = retrievedItem.AssetType;
  425. item.Folder = retrievedItem.Folder;
  426. item.CreatorIdentification = retrievedItem.CreatorIdentification;
  427. item.Owner = retrievedItem.Owner;
  428. }
  429. return m_Database.StoreItem(ConvertFromOpenSim(item));
  430. }
  431. public virtual bool MoveItems(UUID principalID, List<InventoryItemBase> items)
  432. {
  433. // Principal is b0rked. *sigh*
  434. //
  435. foreach (InventoryItemBase i in items)
  436. {
  437. m_Database.MoveItem(i.ID.ToString(), i.Folder.ToString());
  438. }
  439. return true;
  440. }
  441. public virtual bool DeleteItems(UUID principalID, List<UUID> itemIDs)
  442. {
  443. if (!m_AllowDelete)
  444. {
  445. // We must still allow links and links to folders to be deleted, otherwise they will build up
  446. // in the player's inventory until they can no longer log in. Deletions of links due to code bugs or
  447. // similar is inconvenient but on a par with accidental movement of items. The original item is never
  448. // touched.
  449. foreach (UUID id in itemIDs)
  450. {
  451. if (!m_Database.DeleteItems(
  452. new string[] { "inventoryID", "assetType" },
  453. new string[] { id.ToString(), ((sbyte)AssetType.Link).ToString() }))
  454. {
  455. m_Database.DeleteItems(
  456. new string[] { "inventoryID", "assetType" },
  457. new string[] { id.ToString(), ((sbyte)AssetType.LinkFolder).ToString() });
  458. }
  459. }
  460. }
  461. else
  462. {
  463. // Just use the ID... *facepalms*
  464. //
  465. foreach (UUID id in itemIDs)
  466. m_Database.DeleteItems("inventoryID", id.ToString());
  467. }
  468. return true;
  469. }
  470. public virtual InventoryItemBase GetItem(InventoryItemBase item)
  471. {
  472. XInventoryItem[] items = m_Database.GetItems(
  473. new string[] { "inventoryID" },
  474. new string[] { item.ID.ToString() });
  475. if (items.Length == 0)
  476. return null;
  477. return ConvertToOpenSim(items[0]);
  478. }
  479. public virtual InventoryFolderBase GetFolder(InventoryFolderBase folder)
  480. {
  481. XInventoryFolder[] folders = m_Database.GetFolders(
  482. new string[] { "folderID"},
  483. new string[] { folder.ID.ToString() });
  484. if (folders.Length == 0)
  485. return null;
  486. return ConvertToOpenSim(folders[0]);
  487. }
  488. public virtual List<InventoryItemBase> GetActiveGestures(UUID principalID)
  489. {
  490. XInventoryItem[] items = m_Database.GetActiveGestures(principalID);
  491. if (items.Length == 0)
  492. return new List<InventoryItemBase>();
  493. List<InventoryItemBase> ret = new List<InventoryItemBase>();
  494. foreach (XInventoryItem x in items)
  495. ret.Add(ConvertToOpenSim(x));
  496. return ret;
  497. }
  498. public virtual int GetAssetPermissions(UUID principalID, UUID assetID)
  499. {
  500. return m_Database.GetAssetPermissions(principalID, assetID);
  501. }
  502. public virtual InventoryCollection GetUserInventory(UUID userID)
  503. {
  504. InventoryCollection userInventory = new InventoryCollection();
  505. userInventory.UserID = userID;
  506. userInventory.Folders = new List<InventoryFolderBase>();
  507. userInventory.Items = new List<InventoryItemBase>();
  508. List<InventoryFolderBase> skel = GetInventorySkeleton(userID);
  509. if (skel != null)
  510. {
  511. foreach (InventoryFolderBase f in skel)
  512. {
  513. InventoryCollection c = GetFolderContent(userID, f.ID);
  514. if (c != null && c.Items != null && c.Items.Count > 0)
  515. userInventory.Items.AddRange(c.Items);
  516. if (c != null && c.Folders != null && c.Folders.Count > 0)
  517. userInventory.Folders.AddRange(c.Folders);
  518. }
  519. }
  520. m_log.DebugFormat("[XINVENTORY SERVICE]: GetUserInventory for user {0} returning {1} folders and {2} items",
  521. userID, userInventory.Folders.Count, userInventory.Items.Count);
  522. return userInventory;
  523. }
  524. public void GetUserInventory(UUID userID, InventoryReceiptCallback callback)
  525. {
  526. }
  527. // Unused.
  528. //
  529. public bool HasInventoryForUser(UUID userID)
  530. {
  531. return false;
  532. }
  533. // CM Helpers
  534. //
  535. protected InventoryFolderBase ConvertToOpenSim(XInventoryFolder folder)
  536. {
  537. InventoryFolderBase newFolder = new InventoryFolderBase();
  538. newFolder.ParentID = folder.parentFolderID;
  539. newFolder.Type = (short)folder.type;
  540. // Viewer can't understand anything that's not in it's LLFolderType enum
  541. if (newFolder.Type == 100)
  542. newFolder.Type = -1;
  543. newFolder.Version = (ushort)folder.version;
  544. newFolder.Name = folder.folderName;
  545. newFolder.Owner = folder.agentID;
  546. newFolder.ID = folder.folderID;
  547. return newFolder;
  548. }
  549. protected XInventoryFolder ConvertFromOpenSim(InventoryFolderBase folder)
  550. {
  551. XInventoryFolder newFolder = new XInventoryFolder();
  552. newFolder.parentFolderID = folder.ParentID;
  553. newFolder.type = (int)folder.Type;
  554. newFolder.version = (int)folder.Version;
  555. newFolder.folderName = folder.Name;
  556. newFolder.agentID = folder.Owner;
  557. newFolder.folderID = folder.ID;
  558. return newFolder;
  559. }
  560. protected InventoryItemBase ConvertToOpenSim(XInventoryItem item)
  561. {
  562. InventoryItemBase newItem = new InventoryItemBase();
  563. newItem.AssetID = item.assetID;
  564. newItem.AssetType = item.assetType;
  565. newItem.Name = item.inventoryName;
  566. newItem.Owner = item.avatarID;
  567. newItem.ID = item.inventoryID;
  568. newItem.InvType = item.invType;
  569. newItem.Folder = item.parentFolderID;
  570. newItem.CreatorIdentification = item.creatorID;
  571. newItem.Description = item.inventoryDescription;
  572. newItem.NextPermissions = (uint)item.inventoryNextPermissions;
  573. newItem.CurrentPermissions = (uint)item.inventoryCurrentPermissions;
  574. newItem.BasePermissions = (uint)item.inventoryBasePermissions;
  575. newItem.EveryOnePermissions = (uint)item.inventoryEveryOnePermissions;
  576. newItem.GroupPermissions = (uint)item.inventoryGroupPermissions;
  577. newItem.GroupID = item.groupID;
  578. if (item.groupOwned == 0)
  579. newItem.GroupOwned = false;
  580. else
  581. newItem.GroupOwned = true;
  582. newItem.SalePrice = item.salePrice;
  583. newItem.SaleType = (byte)item.saleType;
  584. newItem.Flags = (uint)item.flags;
  585. newItem.CreationDate = item.creationDate;
  586. return newItem;
  587. }
  588. protected XInventoryItem ConvertFromOpenSim(InventoryItemBase item)
  589. {
  590. XInventoryItem newItem = new XInventoryItem();
  591. newItem.assetID = item.AssetID;
  592. newItem.assetType = item.AssetType;
  593. newItem.inventoryName = item.Name;
  594. newItem.avatarID = item.Owner;
  595. newItem.inventoryID = item.ID;
  596. newItem.invType = item.InvType;
  597. newItem.parentFolderID = item.Folder;
  598. newItem.creatorID = item.CreatorIdentification;
  599. newItem.inventoryDescription = item.Description;
  600. newItem.inventoryNextPermissions = (int)item.NextPermissions;
  601. newItem.inventoryCurrentPermissions = (int)item.CurrentPermissions;
  602. newItem.inventoryBasePermissions = (int)item.BasePermissions;
  603. newItem.inventoryEveryOnePermissions = (int)item.EveryOnePermissions;
  604. newItem.inventoryGroupPermissions = (int)item.GroupPermissions;
  605. newItem.groupID = item.GroupID;
  606. if (item.GroupOwned)
  607. newItem.groupOwned = 1;
  608. else
  609. newItem.groupOwned = 0;
  610. newItem.salePrice = item.SalePrice;
  611. newItem.saleType = (int)item.SaleType;
  612. newItem.flags = (int)item.Flags;
  613. newItem.creationDate = item.CreationDate;
  614. return newItem;
  615. }
  616. private bool ParentIsTrash(UUID folderID)
  617. {
  618. XInventoryFolder[] folder = m_Database.GetFolders(new string[] {"folderID"}, new string[] {folderID.ToString()});
  619. if (folder.Length < 1)
  620. return false;
  621. if (folder[0].type == (int)AssetType.TrashFolder)
  622. return true;
  623. UUID parentFolder = folder[0].parentFolderID;
  624. while (parentFolder != UUID.Zero)
  625. {
  626. XInventoryFolder[] parent = m_Database.GetFolders(new string[] {"folderID"}, new string[] {parentFolder.ToString()});
  627. if (parent.Length < 1)
  628. return false;
  629. if (parent[0].type == (int)AssetType.TrashFolder)
  630. return true;
  631. if (parent[0].type == (int)AssetType.RootFolder)
  632. return false;
  633. parentFolder = parent[0].parentFolderID;
  634. }
  635. return false;
  636. }
  637. }
  638. }