http://opensimulator.org/index.php?action=history&feed=atom&title=Talk%3ACheck_inventory_scriptTalk:Check inventory script - Revision history2026-06-04T15:03:29ZRevision history for this page on the wikiMediaWiki 1.19.9http://opensimulator.org/index.php?title=Talk:Check_inventory_script&diff=52478&oldid=prevTampa at 04:57, 13 May 20222022-05-13T04:57:59Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 04:57, 13 May 2022</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 6:</td>
<td colspan="2" class="diff-lineno">Line 6:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>I used  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>I used  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory' AND `parentFolderID` != '00000000-0000-0000-0000-000000000000';</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory' AND `parentFolderID` != '00000000-0000-0000-0000-000000000000';</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">DBeaver does operations based on the dataset you selected so technically that works, but I'll change the query up.</ins></div></td></tr>
</table>Tampahttp://opensimulator.org/index.php?title=Talk:Check_inventory_script&diff=52477&oldid=prevAcryline: 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..."2022-05-13T00:23:41Z<p>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..."</p>
<p><b>New page</b></p><div>With <br />
UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory';<br />
<br />
All "My inventory" root folders will be of type -1.<br />
<br />
I used <br />
UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory' AND `parentFolderID` != '00000000-0000-0000-0000-000000000000';</div>Acryline