* Committing Lulurun's Cgi/Perl implementation of the UGAI servers.

* I love you long time.

1 files changed, 51 insertions, 0 deletions

diff --git a/share/perl/lib/OpenSim/InventoryServer/Config.pm b/share/perl/lib/OpenSim/InventoryServer/Config.pm
new file mode 100644
index 0000000..64dbdd1
--- /dev/null
+++ b/share/perl/lib/OpenSim/InventoryServer/Config.pm
@@ -0,0 +1,51 @@
+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;