clockwerk-opensim – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 vero 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  
28 using System;
29 using System.Collections.Generic;
30 using OpenMetaverse;
31 using log4net;
32 using Nini.Config;
33 using System.Reflection;
34 using OpenSim.Services.Base;
35 using OpenSim.Services.Interfaces;
36 using OpenSim.Data;
37 using OpenSim.Framework;
38  
39 namespace OpenSim.Services.InventoryService
40 {
41 public class XInventoryService : ServiceBase, IInventoryService
42 {
43 private static readonly ILog m_log =
44 LogManager.GetLogger(
45 MethodBase.GetCurrentMethod().DeclaringType);
46  
47 protected IXInventoryData m_Database;
48 protected bool m_AllowDelete = true;
49 protected string m_ConfigName = "InventoryService";
50  
51 public XInventoryService(IConfigSource config)
52 : this(config, "InventoryService")
53 {
54 }
55  
56 public XInventoryService(IConfigSource config, string configName) : base(config)
57 {
58 if (configName != string.Empty)
59 m_ConfigName = configName;
60  
61 string dllName = String.Empty;
62 string connString = String.Empty;
63 //string realm = "Inventory"; // OSG version doesn't use this
64  
65 //
66 // Try reading the [InventoryService] section first, if it exists
67 //
68 IConfig authConfig = config.Configs[m_ConfigName];
69 if (authConfig != null)
70 {
71 dllName = authConfig.GetString("StorageProvider", dllName);
72 connString = authConfig.GetString("ConnectionString", connString);
73 m_AllowDelete = authConfig.GetBoolean("AllowDelete", true);
74 // realm = authConfig.GetString("Realm", realm);
75 }
76  
77 //
78 // Try reading the [DatabaseService] section, if it exists
79 //
80 IConfig dbConfig = config.Configs["DatabaseService"];
81 if (dbConfig != null)
82 {
83 if (dllName == String.Empty)
84 dllName = dbConfig.GetString("StorageProvider", String.Empty);
85 if (connString == String.Empty)
86 connString = dbConfig.GetString("ConnectionString", String.Empty);
87 }
88  
89 //
90 // We tried, but this doesn't exist. We can't proceed.
91 //
92 if (dllName == String.Empty)
93 throw new Exception("No StorageProvider configured");
94  
95 m_Database = LoadPlugin<IXInventoryData>(dllName,
96 new Object[] {connString, String.Empty});
97  
98 if (m_Database == null)
99 throw new Exception("Could not find a storage interface in the given module");
100 }
101  
102 public virtual bool CreateUserInventory(UUID principalID)
103 {
104 // This is braindeaad. We can't ever communicate that we fixed
105 // an existing inventory. Well, just return root folder status,
106 // but check sanity anyway.
107 //
108 bool result = false;
109  
110 InventoryFolderBase rootFolder = GetRootFolder(principalID);
111  
112 if (rootFolder == null)
113 {
114 rootFolder = ConvertToOpenSim(CreateFolder(principalID, UUID.Zero, (int)AssetType.RootFolder, "My Inventory"));
115 result = true;
116 }
117  
118 XInventoryFolder[] sysFolders = GetSystemFolders(principalID, rootFolder.ID);
119  
120 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Animation) return true; return false; }))
121 CreateFolder(principalID, rootFolder.ID, (int)AssetType.Animation, "Animations");
122 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Bodypart) return true; return false; }))
123 CreateFolder(principalID, rootFolder.ID, (int)AssetType.Bodypart, "Body Parts");
124 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.CallingCard) return true; return false; }))
125 {
126 XInventoryFolder folder = CreateFolder(principalID, rootFolder.ID, (int)AssetType.CallingCard, "Calling Cards");
127 folder = CreateFolder(principalID, folder.folderID, (int)AssetType.CallingCard, "Friends");
128 CreateFolder(principalID, folder.folderID, (int)AssetType.CallingCard, "All");
129 }
130 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Clothing) return true; return false; }))
131 CreateFolder(principalID, rootFolder.ID, (int)AssetType.Clothing, "Clothing");
132 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.CurrentOutfitFolder) return true; return false; }))
133 CreateFolder(principalID, rootFolder.ID, (int)AssetType.CurrentOutfitFolder, "Current Outfit");
134 if (!Array.Exists(sysFolders, delegate(XInventoryFolder f) { if (f.type == (int)AssetType.FavoriteFolder) return true; return false; }))
135 CreateFolder(principalID, rootFolder.ID, (int)AssetType.FavoriteFolder, "Favorites");
136 if (!Array.Exists(sysFolders, delegate(XInventoryFolder f) { if (f.type == (int)AssetType.Gesture) return true; return false; }))
137 CreateFolder(principalID, rootFolder.ID, (int)AssetType.Gesture, "Gestures");
138 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Landmark) return true; return false; }))
139 CreateFolder(principalID, rootFolder.ID, (int)AssetType.Landmark, "Landmarks");
140 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.LostAndFoundFolder) return true; return false; }))
141 CreateFolder(principalID, rootFolder.ID, (int)AssetType.LostAndFoundFolder, "Lost And Found");
142 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Notecard) return true; return false; }))
143 CreateFolder(principalID, rootFolder.ID, (int)AssetType.Notecard, "Notecards");
144 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Object) return true; return false; }))
145 CreateFolder(principalID, rootFolder.ID, (int)AssetType.Object, "Objects");
146 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.SnapshotFolder) return true; return false; }))
147 CreateFolder(principalID, rootFolder.ID, (int)AssetType.SnapshotFolder, "Photo Album");
148 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.LSLText) return true; return false; }))
149 CreateFolder(principalID, rootFolder.ID, (int)AssetType.LSLText, "Scripts");
150 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Sound) return true; return false; }))
151 CreateFolder(principalID, rootFolder.ID, (int)AssetType.Sound, "Sounds");
152 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.Texture) return true; return false; }))
153 CreateFolder(principalID, rootFolder.ID, (int)AssetType.Texture, "Textures");
154 if (!Array.Exists(sysFolders, delegate (XInventoryFolder f) { if (f.type == (int)AssetType.TrashFolder) return true; return false; }))
155 CreateFolder(principalID, rootFolder.ID, (int)AssetType.TrashFolder, "Trash");
156  
157 return result;
158 }
159  
160 protected XInventoryFolder CreateFolder(UUID principalID, UUID parentID, int type, string name)
161 {
162 XInventoryFolder newFolder = new XInventoryFolder();
163  
164 newFolder.folderName = name;
165 newFolder.type = type;
166 newFolder.version = 1;
167 newFolder.folderID = UUID.Random();
168 newFolder.agentID = principalID;
169 newFolder.parentFolderID = parentID;
170  
171 m_Database.StoreFolder(newFolder);
172  
173 return newFolder;
174 }
175  
176 protected virtual XInventoryFolder[] GetSystemFolders(UUID principalID, UUID rootID)
177 {
178 // m_log.DebugFormat("[XINVENTORY SERVICE]: Getting system folders for {0}", principalID);
179  
180 XInventoryFolder[] allFolders = m_Database.GetFolders(
181 new string[] { "agentID", "parentFolderID" },
182 new string[] { principalID.ToString(), rootID.ToString() });
183  
184 XInventoryFolder[] sysFolders = Array.FindAll(
185 allFolders,
186 delegate (XInventoryFolder f)
187 {
188 if (f.type > 0)
189 return true;
190 return false;
191 });
192  
193 // m_log.DebugFormat(
194 // "[XINVENTORY SERVICE]: Found {0} system folders for {1}", sysFolders.Length, principalID);
195  
196 return sysFolders;
197 }
198  
199 public virtual List<InventoryFolderBase> GetInventorySkeleton(UUID principalID)
200 {
201 XInventoryFolder[] allFolders = m_Database.GetFolders(
202 new string[] { "agentID" },
203 new string[] { principalID.ToString() });
204  
205 if (allFolders.Length == 0)
206 return null;
207  
208 List<InventoryFolderBase> folders = new List<InventoryFolderBase>();
209  
210 foreach (XInventoryFolder x in allFolders)
211 {
212 //m_log.DebugFormat("[XINVENTORY SERVICE]: Adding folder {0} to skeleton", x.folderName);
213 folders.Add(ConvertToOpenSim(x));
214 }
215  
216 return folders;
217 }
218  
219 public virtual InventoryFolderBase GetRootFolder(UUID principalID)
220 {
221 XInventoryFolder[] folders = m_Database.GetFolders(
222 new string[] { "agentID", "parentFolderID"},
223 new string[] { principalID.ToString(), UUID.Zero.ToString() });
224  
225 if (folders.Length == 0)
226 return null;
227  
228 XInventoryFolder root = null;
229 foreach (XInventoryFolder folder in folders)
230 {
231 if (folder.folderName == "My Inventory")
232 {
233 root = folder;
234 break;
235 }
236 }
237  
238 if (root == null) // oops
239 root = folders[0];
240  
241 return ConvertToOpenSim(root);
242 }
243  
244 public virtual InventoryFolderBase GetFolderForType(UUID principalID, AssetType type)
245 {
246 // m_log.DebugFormat("[XINVENTORY SERVICE]: Getting folder type {0} for user {1}", type, principalID);
247  
248 InventoryFolderBase rootFolder = GetRootFolder(principalID);
249  
250 if (rootFolder == null)
251 {
252 m_log.WarnFormat(
253 "[XINVENTORY]: Found no root folder for {0} in GetFolderForType() when looking for {1}",
254 principalID, type);
255  
256 return null;
257 }
258  
259 return GetSystemFolderForType(rootFolder, type);
260 }
261  
262 private InventoryFolderBase GetSystemFolderForType(InventoryFolderBase rootFolder, AssetType type)
263 {
264 // m_log.DebugFormat("[XINVENTORY SERVICE]: Getting folder type {0} for user {1}", type, principalID);
265  
266 if (type == AssetType.RootFolder)
267 return rootFolder;
268  
269 XInventoryFolder[] folders = m_Database.GetFolders(
270 new string[] { "agentID", "parentFolderID", "type"},
271 new string[] { rootFolder.Owner.ToString(), rootFolder.ID.ToString(), ((int)type).ToString() });
272  
273 if (folders.Length == 0)
274 {
275 // m_log.WarnFormat("[XINVENTORY SERVICE]: Found no folder for type {0} for user {1}", type, principalID);
276 return null;
277 }
278  
279 // m_log.DebugFormat(
280 // "[XINVENTORY SERVICE]: Found folder {0} {1} for type {2} for user {3}",
281 // folders[0].folderName, folders[0].folderID, type, principalID);
282  
283 return ConvertToOpenSim(folders[0]);
284 }
285  
286 public virtual InventoryCollection GetFolderContent(UUID principalID, UUID folderID)
287 {
288 // This method doesn't receive a valud principal id from the
289 // connector. So we disregard the principal and look
290 // by ID.
291 //
292 //m_log.DebugFormat("[XINVENTORY SERVICE]: Fetch contents for folder {0}", folderID.ToString());
293 InventoryCollection inventory = new InventoryCollection();
294 inventory.UserID = principalID;
295 inventory.Folders = new List<InventoryFolderBase>();
296 inventory.Items = new List<InventoryItemBase>();
297  
298 XInventoryFolder[] folders = m_Database.GetFolders(
299 new string[] { "parentFolderID"},
300 new string[] { folderID.ToString() });
301  
302 foreach (XInventoryFolder x in folders)
303 {
304 //m_log.DebugFormat("[XINVENTORY]: Adding folder {0} to response", x.folderName);
305 inventory.Folders.Add(ConvertToOpenSim(x));
306 }
307  
308 XInventoryItem[] items = m_Database.GetItems(
309 new string[] { "parentFolderID"},
310 new string[] { folderID.ToString() });
311  
312 foreach (XInventoryItem i in items)
313 {
314 //m_log.DebugFormat("[XINVENTORY]: Adding item {0} to response", i.inventoryName);
315 inventory.Items.Add(ConvertToOpenSim(i));
316 }
317  
318 return inventory;
319 }
320  
321 public virtual List<InventoryItemBase> GetFolderItems(UUID principalID, UUID folderID)
322 {
323 // m_log.DebugFormat("[XINVENTORY]: Fetch items for folder {0}", folderID);
324  
325 // Since we probably don't get a valid principal here, either ...
326 //
327 List<InventoryItemBase> invItems = new List<InventoryItemBase>();
328  
329 XInventoryItem[] items = m_Database.GetItems(
330 new string[] { "parentFolderID" },
331 new string[] { folderID.ToString() });
332  
333 foreach (XInventoryItem i in items)
334 invItems.Add(ConvertToOpenSim(i));
335  
336 return invItems;
337 }
338  
339 public virtual bool AddFolder(InventoryFolderBase folder)
340 {
341 // m_log.DebugFormat("[XINVENTORY]: Add folder {0} type {1} in parent {2}", folder.Name, folder.Type, folder.ParentID);
342  
343 InventoryFolderBase check = GetFolder(folder);
344 if (check != null)
345 return false;
346  
347 if (folder.Type != (short)AssetType.Folder && folder.Type != (short)AssetType.Unknown)
348 {
349 InventoryFolderBase rootFolder = GetRootFolder(folder.Owner);
350  
351 if (rootFolder == null)
352 {
353 m_log.WarnFormat(
354 "[XINVENTORY]: Found no root folder for {0} in AddFolder() when looking for {1}",
355 folder.Owner, folder.Type);
356  
357 return false;
358 }
359  
360 // Check we're not trying to add this as a system folder.
361 if (folder.ParentID == rootFolder.ID)
362 {
363 InventoryFolderBase existingSystemFolder
364 = GetSystemFolderForType(rootFolder, (AssetType)folder.Type);
365  
366 if (existingSystemFolder != null)
367 {
368 m_log.WarnFormat(
369 "[XINVENTORY]: System folder of type {0} already exists when tried to add {1} to {2} for {3}",
370 folder.Type, folder.Name, folder.ParentID, folder.Owner);
371  
372 return false;
373 }
374 }
375 }
376  
377 XInventoryFolder xFolder = ConvertFromOpenSim(folder);
378 return m_Database.StoreFolder(xFolder);
379 }
380  
381 public virtual bool UpdateFolder(InventoryFolderBase folder)
382 {
383 // m_log.DebugFormat("[XINVENTORY]: Update folder {0} {1} ({2})", folder.Name, folder.Type, folder.ID);
384  
385 XInventoryFolder xFolder = ConvertFromOpenSim(folder);
386 InventoryFolderBase check = GetFolder(folder);
387  
388 if (check == null)
389 return AddFolder(folder);
390  
391 if ((check.Type != (short)AssetType.Unknown || xFolder.type != (short)AssetType.Unknown)
392 && (check.Type != (short)AssetType.OutfitFolder || xFolder.type != (short)AssetType.OutfitFolder))
393 {
394 if (xFolder.version < check.Version)
395 {
396 // m_log.DebugFormat("[XINVENTORY]: {0} < {1} can't do", xFolder.version, check.Version);
397 return false;
398 }
399  
400 check.Version = (ushort)xFolder.version;
401 xFolder = ConvertFromOpenSim(check);
402  
403 // m_log.DebugFormat(
404 // "[XINVENTORY]: Storing version only update to system folder {0} {1} {2}",
405 // xFolder.folderName, xFolder.version, xFolder.type);
406  
407 return m_Database.StoreFolder(xFolder);
408 }
409  
410 if (xFolder.version < check.Version)
411 xFolder.version = check.Version;
412  
413 xFolder.folderID = check.ID;
414  
415 return m_Database.StoreFolder(xFolder);
416 }
417  
418 public virtual bool MoveFolder(InventoryFolderBase folder)
419 {
420 return m_Database.MoveFolder(folder.ID.ToString(), folder.ParentID.ToString());
421 }
422  
423 // We don't check the principal's ID here
424 //
425 public virtual bool DeleteFolders(UUID principalID, List<UUID> folderIDs)
426 {
427 return DeleteFolders(principalID, folderIDs, true);
428 }
429  
430 public virtual bool DeleteFolders(UUID principalID, List<UUID> folderIDs, bool onlyIfTrash)
431 {
432 if (!m_AllowDelete)
433 return false;
434  
435 // Ignore principal ID, it's bogus at connector level
436 //
437 foreach (UUID id in folderIDs)
438 {
439 if (onlyIfTrash && !ParentIsTrash(id))
440 continue;
441 //m_log.InfoFormat("[XINVENTORY SERVICE]: Delete folder {0}", id);
442 InventoryFolderBase f = new InventoryFolderBase();
443 f.ID = id;
444 PurgeFolder(f, onlyIfTrash);
445 m_Database.DeleteFolders("folderID", id.ToString());
446 }
447  
448 return true;
449 }
450  
451 public virtual bool PurgeFolder(InventoryFolderBase folder)
452 {
453 return PurgeFolder(folder, true);
454 }
455  
456 public virtual bool PurgeFolder(InventoryFolderBase folder, bool onlyIfTrash)
457 {
458 if (!m_AllowDelete)
459 return false;
460  
461 if (onlyIfTrash && !ParentIsTrash(folder.ID))
462 return false;
463  
464 XInventoryFolder[] subFolders = m_Database.GetFolders(
465 new string[] { "parentFolderID" },
466 new string[] { folder.ID.ToString() });
467  
468 foreach (XInventoryFolder x in subFolders)
469 {
470 PurgeFolder(ConvertToOpenSim(x), onlyIfTrash);
471 m_Database.DeleteFolders("folderID", x.folderID.ToString());
472 }
473  
474 m_Database.DeleteItems("parentFolderID", folder.ID.ToString());
475  
476 return true;
477 }
478  
479 public virtual bool AddItem(InventoryItemBase item)
480 {
481 // m_log.DebugFormat(
482 // "[XINVENTORY SERVICE]: Adding item {0} {1} to folder {2} for {3}", item.Name, item.ID, item.Folder, item.Owner);
483  
484 return m_Database.StoreItem(ConvertFromOpenSim(item));
485 }
486  
487 public virtual bool UpdateItem(InventoryItemBase item)
488 {
489 if (!m_AllowDelete)
490 if (item.AssetType == (sbyte)AssetType.Link || item.AssetType == (sbyte)AssetType.LinkFolder)
491 return false;
492  
493 // m_log.InfoFormat(
494 // "[XINVENTORY SERVICE]: Updating item {0} {1} in folder {2}", item.Name, item.ID, item.Folder);
495  
496 InventoryItemBase retrievedItem = GetItem(item);
497  
498 if (retrievedItem == null)
499 {
500 m_log.WarnFormat(
501 "[XINVENTORY SERVICE]: Tried to update item {0} {1}, owner {2} but no existing item found.",
502 item.Name, item.ID, item.Owner);
503  
504 return false;
505 }
506  
507 // Do not allow invariants to change. Changes to folder ID occur in MoveItems()
508 if (retrievedItem.InvType != item.InvType
509 || retrievedItem.AssetType != item.AssetType
510 || retrievedItem.Folder != item.Folder
511 || retrievedItem.CreatorIdentification != item.CreatorIdentification
512 || retrievedItem.Owner != item.Owner)
513 {
514 m_log.WarnFormat(
515 "[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})",
516 retrievedItem.Name,
517 retrievedItem.ID,
518 retrievedItem.InvType,
519 retrievedItem.AssetType,
520 retrievedItem.Folder,
521 retrievedItem.CreatorIdentification,
522 retrievedItem.Owner,
523 item.InvType,
524 item.AssetType,
525 item.Folder,
526 item.CreatorIdentification,
527 item.Owner);
528  
529 item.InvType = retrievedItem.InvType;
530 item.AssetType = retrievedItem.AssetType;
531 item.Folder = retrievedItem.Folder;
532 item.CreatorIdentification = retrievedItem.CreatorIdentification;
533 item.Owner = retrievedItem.Owner;
534 }
535  
536 return m_Database.StoreItem(ConvertFromOpenSim(item));
537 }
538  
539 public virtual bool MoveItems(UUID principalID, List<InventoryItemBase> items)
540 {
541 // Principal is b0rked. *sigh*
542 //
543 foreach (InventoryItemBase i in items)
544 {
545 m_Database.MoveItem(i.ID.ToString(), i.Folder.ToString());
546 }
547  
548 return true;
549 }
550  
551 public virtual bool DeleteItems(UUID principalID, List<UUID> itemIDs)
552 {
553 if (!m_AllowDelete)
554 {
555 // We must still allow links and links to folders to be deleted, otherwise they will build up
556 // in the player's inventory until they can no longer log in. Deletions of links due to code bugs or
557 // similar is inconvenient but on a par with accidental movement of items. The original item is never
558 // touched.
559 foreach (UUID id in itemIDs)
560 {
561 if (!m_Database.DeleteItems(
562 new string[] { "inventoryID", "assetType" },
563 new string[] { id.ToString(), ((sbyte)AssetType.Link).ToString() }))
564 {
565 m_Database.DeleteItems(
566 new string[] { "inventoryID", "assetType" },
567 new string[] { id.ToString(), ((sbyte)AssetType.LinkFolder).ToString() });
568 }
569 }
570 }
571 else
572 {
573 // Just use the ID... *facepalms*
574 //
575 foreach (UUID id in itemIDs)
576 m_Database.DeleteItems("inventoryID", id.ToString());
577 }
578  
579 return true;
580 }
581  
582 public virtual InventoryItemBase GetItem(InventoryItemBase item)
583 {
584 XInventoryItem[] items = m_Database.GetItems(
585 new string[] { "inventoryID" },
586 new string[] { item.ID.ToString() });
587  
588 if (items.Length == 0)
589 return null;
590  
591 return ConvertToOpenSim(items[0]);
592 }
593  
594 public virtual InventoryFolderBase GetFolder(InventoryFolderBase folder)
595 {
596 XInventoryFolder[] folders = m_Database.GetFolders(
597 new string[] { "folderID"},
598 new string[] { folder.ID.ToString() });
599  
600 if (folders.Length == 0)
601 return null;
602  
603 return ConvertToOpenSim(folders[0]);
604 }
605  
606 public virtual List<InventoryItemBase> GetActiveGestures(UUID principalID)
607 {
608 XInventoryItem[] items = m_Database.GetActiveGestures(principalID);
609  
610 if (items.Length == 0)
611 return new List<InventoryItemBase>();
612  
613 List<InventoryItemBase> ret = new List<InventoryItemBase>();
614  
615 foreach (XInventoryItem x in items)
616 ret.Add(ConvertToOpenSim(x));
617  
618 return ret;
619 }
620  
621 public virtual int GetAssetPermissions(UUID principalID, UUID assetID)
622 {
623 return m_Database.GetAssetPermissions(principalID, assetID);
624 }
625  
626 // Unused.
627 //
628 public bool HasInventoryForUser(UUID userID)
629 {
630 return false;
631 }
632  
633 // CM Helpers
634 //
635 protected InventoryFolderBase ConvertToOpenSim(XInventoryFolder folder)
636 {
637 InventoryFolderBase newFolder = new InventoryFolderBase();
638  
639 newFolder.ParentID = folder.parentFolderID;
640 newFolder.Type = (short)folder.type;
641 // Viewer can't understand anything that's not in it's LLFolderType enum
642 if (newFolder.Type == InventoryItemBase.SUITCASE_FOLDER_TYPE)
643 newFolder.Type = InventoryItemBase.SUITCASE_FOLDER_FAKE_TYPE;
644 newFolder.Version = (ushort)folder.version;
645 newFolder.Name = folder.folderName;
646 newFolder.Owner = folder.agentID;
647 newFolder.ID = folder.folderID;
648  
649 return newFolder;
650 }
651  
652 protected XInventoryFolder ConvertFromOpenSim(InventoryFolderBase folder)
653 {
654 XInventoryFolder newFolder = new XInventoryFolder();
655  
656 newFolder.parentFolderID = folder.ParentID;
657 newFolder.type = (int)folder.Type;
658 newFolder.version = (int)folder.Version;
659 newFolder.folderName = folder.Name;
660 newFolder.agentID = folder.Owner;
661 newFolder.folderID = folder.ID;
662  
663 return newFolder;
664 }
665  
666 protected InventoryItemBase ConvertToOpenSim(XInventoryItem item)
667 {
668 InventoryItemBase newItem = new InventoryItemBase();
669  
670 newItem.AssetID = item.assetID;
671 newItem.AssetType = item.assetType;
672 newItem.Name = item.inventoryName;
673 newItem.Owner = item.avatarID;
674 newItem.ID = item.inventoryID;
675 newItem.InvType = item.invType;
676 newItem.Folder = item.parentFolderID;
677 newItem.CreatorIdentification = item.creatorID;
678 newItem.Description = item.inventoryDescription;
679 newItem.NextPermissions = (uint)item.inventoryNextPermissions;
680 newItem.CurrentPermissions = (uint)item.inventoryCurrentPermissions;
681 newItem.BasePermissions = (uint)item.inventoryBasePermissions;
682 newItem.EveryOnePermissions = (uint)item.inventoryEveryOnePermissions;
683 newItem.GroupPermissions = (uint)item.inventoryGroupPermissions;
684 newItem.GroupID = item.groupID;
685 if (item.groupOwned == 0)
686 newItem.GroupOwned = false;
687 else
688 newItem.GroupOwned = true;
689 newItem.SalePrice = item.salePrice;
690 newItem.SaleType = (byte)item.saleType;
691 newItem.Flags = (uint)item.flags;
692 newItem.CreationDate = item.creationDate;
693  
694 return newItem;
695 }
696  
697 protected XInventoryItem ConvertFromOpenSim(InventoryItemBase item)
698 {
699 XInventoryItem newItem = new XInventoryItem();
700  
701 newItem.assetID = item.AssetID;
702 newItem.assetType = item.AssetType;
703 newItem.inventoryName = item.Name;
704 newItem.avatarID = item.Owner;
705 newItem.inventoryID = item.ID;
706 newItem.invType = item.InvType;
707 newItem.parentFolderID = item.Folder;
708 newItem.creatorID = item.CreatorIdentification;
709 newItem.inventoryDescription = item.Description;
710 newItem.inventoryNextPermissions = (int)item.NextPermissions;
711 newItem.inventoryCurrentPermissions = (int)item.CurrentPermissions;
712 newItem.inventoryBasePermissions = (int)item.BasePermissions;
713 newItem.inventoryEveryOnePermissions = (int)item.EveryOnePermissions;
714 newItem.inventoryGroupPermissions = (int)item.GroupPermissions;
715 newItem.groupID = item.GroupID;
716 if (item.GroupOwned)
717 newItem.groupOwned = 1;
718 else
719 newItem.groupOwned = 0;
720 newItem.salePrice = item.SalePrice;
721 newItem.saleType = (int)item.SaleType;
722 newItem.flags = (int)item.Flags;
723 newItem.creationDate = item.CreationDate;
724  
725 return newItem;
726 }
727  
728 private bool ParentIsTrash(UUID folderID)
729 {
730 XInventoryFolder[] folder = m_Database.GetFolders(new string[] {"folderID"}, new string[] {folderID.ToString()});
731 if (folder.Length < 1)
732 return false;
733  
734 if (folder[0].type == (int)AssetType.TrashFolder)
735 return true;
736  
737 UUID parentFolder = folder[0].parentFolderID;
738  
739 while (parentFolder != UUID.Zero)
740 {
741 XInventoryFolder[] parent = m_Database.GetFolders(new string[] {"folderID"}, new string[] {parentFolder.ToString()});
742 if (parent.Length < 1)
743 return false;
744  
745 if (parent[0].type == (int)AssetType.TrashFolder)
746 return true;
747 if (parent[0].type == (int)AssetType.RootFolder)
748 return false;
749  
750 parentFolder = parent[0].parentFolderID;
751 }
752 return false;
753 }
754 }
755 }