Talk:Check inventory script
From OpenSimulator
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.
