123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 |
- package OpenSim::InventoryServer::Config;
- use strict;
- our %SYS_SQL = (
- save_inventory_folder =>
- "REPLACE INTO inventoryfolders VALUES (?,?,?,?,?,?)",
- save_inventory_item =>
- "REPLACE INTO inventoryitems VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
- get_root_folder =>
- "SELECT * FROM inventoryfolders WHERE parentFolderID=? AND agentId=?",
- get_children_folders =>
- "SELECT * FROM inventoryfolders WHERE parentFolderID=?",
- get_user_inventory_folders =>
- "SELECT * FROM inventoryfolders WHERE agentID=?",
- get_user_inventory_items =>
- "SELECT * FROM inventoryitems WHERE avatarID=?",
- delete_inventory_item =>
- "DELETE FROM inventoryitems WHERE inventoryID=?",
- move_inventory_folder =>
- "UPDATE inventoryfolders SET parentFolderID=? WHERE folderID=?",
- );
- our @INVENTORYFOLDERS_COLUMNS = (
- "folderID",
- "agentID",
- "parentFolderID",
- "folderName",
- "type",
- "version",
- );
- our @INVENTORYITEMS_COLUMNS = (
- "inventoryID",
- "assetID",
- "type",
- "parentFolderID",
- "avatarID",
- "inventoryName",
- "inventoryDescription",
- "inventoryNextPermissions",
- "inventoryCurrentPermissions",
- "assetType",
- "invType",
- "creatorID",
- "inventoryBasePermissions",
- "inventoryEveryOnePermissions",
- );
- 1;
|