Talk:Check inventory script
From OpenSimulator
(Difference between revisions)
(Created page with "With UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory'; All "My inventory" root folders will be o...") |
|||
| Line 6: | Line 6: | ||
I used | I used | ||
UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory' AND `parentFolderID` != '00000000-0000-0000-0000-000000000000'; | UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory' AND `parentFolderID` != '00000000-0000-0000-0000-000000000000'; | ||
| + | |||
| + | |||
| + | DBeaver does operations based on the dataset you selected so technically that works, but I'll change the query up. | ||
Latest revision as of 20:57, 12 May 2022
With
UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory';
All "My inventory" root folders will be of type -1.
I used
UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory' AND `parentFolderID` != '00000000-0000-0000-0000-000000000000';
DBeaver does operations based on the dataset you selected so technically that works, but I'll change the query up.
