[Opensim-users] Inventory Broken Links

Wed Jan 7 21:40:47 UTC 2015

Current outfit items are actually just links to other items (you can see this if you right-click and select "find
original" on them).

(Ordinary) items in turn reference assets.  The asset contains the actual data (e.g. eye texture, colour, etc.).

If the avatar has no existing outfit entries in the avatars table then it's not necessary to populate it.  The viewer
will populate it when it reads the current outfit data.  This doesn't work the other way around.

So the steps are

1)  Make sure the assets existing in the destination installation.  For Ruth, they already will.
2)  Create the inventory items (e.g. at least hair, skin, shape, eyes, top and pants).  Every user will need a unique
item UUID but all items of the same type will reference the same asset UUID (e.g. all eyes reference the same eye asset).
3)  Create the inventory item links in the "Current Outfit" folder. In this case, the asset ID of the link actually
references the linked item UUID.  Again, all the item UUID links need to be unique.

This is not commonly done stuff.  As linked previously, [1] shows example PHP code for doing this kind of thing.  I also
extended and corrected [2] a tiny bit.

[1] https://github.com/justincc/opensimulator-tools/tree/master/integration/php/src/programs/add-cabp
[2] http://opensimulator.org/wiki/Attachment_Protocols

On 07/01/15 11:59, Drover, Matt wrote:
> I think I’m missing the link between “current outfit” and assets maybe.
> The “current outfit” items should be the same as Wearables and attachments
> listed in the avatars table correct?
> 
> I have the old grid still running so the data is still there for me to
> work with. Would this work?:
> 
> On old server for each user
> -export the current outfit inventory items and their associated assets
> (via sql)
> On new server for each user
> -remove the current outfit inventory items
> -remove the wearables and attachments from the avatars table
> -import all the assets from above
> 
> -put the each users assets in the users inventory
> -create the current outfit inventory items
> -update wearables and attachments in avatars table
> 
> It will be a lot of scripting but should work right?
> 
> -Matt
> 
> On 2015-01-06, 5:12 PM, "Justin Clark-Casey" <jjustincc at googlemail.com>
> wrote:
> 
>> I do have sample PHP code in [1] which show how to do that via service
>> calls.  However, it pre-supposes using its own
>> example files - for instance add-inventory-items.php would need to be
>> adapted to add the ruth clothing and body parts.
>>
>> [1]
>> https://github.com/justincc/opensimulator-tools/tree/master/integration/ph
>> p/src/programs/add-cabp
>> On 06/01/15 18:17, Drover, Matt wrote:
>>> Is there a way I can “ruth” everyone ? Meaning add a specific shape to
>>> every user.
>>>
>>> -Matt
>>>
>>> On 2015-01-06, 2:39 PM, "Mike Chase" <mike.chase at alternatemetaverse.com>
>>> wrote:
>>>
>>>> They need to be wearing at least the basic skin, hair, eyes, shape for
>>>> things to work.  Most likely the Current Outfits folder is empty and so
>>>> they don't have these basic elements.
>>>>
>>>> Mike
>>>>
>>>> On 1/6/15 12:52 PM, Drover, Matt wrote:
>>>>> I¹m back at this now that the holidays are over, here is what happened
>>>>> last month. I exported all my users to iars and islands to oars.
>>>>> Created a
>>>>> new world and imported them all. The users¹ current outfit got messed
>>>>> up
>>>>> and now they cannot wear anything because of the error.²Cannot wear
>>>>> blahblah until shape is downloaded." Which it never does.
>>>>>
>>>>> I think my issue here is that I copied over the avatars table from the
>>>>> old
>>>>> grid.
>>>>>
>>>>> Any suggestions?
>>>>>
>>>>> -Matt
>>>>>
>>>>> On 2014-12-17, 4:26 PM, "Ai Austin" <ai.ai.austin at gmail.com> wrote:
>>>>>
>>>>>>> On Wed, Dec 17, 2014 at 10:30 AM, Drover, Matt <mattdrover at mun.ca
>>>>>>> <mailto:mattdrover at mun.ca>> wrote:
>>>>>>>>        To repair some database issues, I exported all my
>>>>>>> islands/users to oars/iars and imported them in a new grid.
>>>>>>>>        Everything worked great, except my current outfit is not
>>>>>>> rezing and in my inventory next to each item it says
>>>>>>>>        (broken link). I?ve checked and all the assets/textures are
>>>>>>> in the database, so I know they came over. What exactly
>>>>>>>>        does broken link mean? And how can I fix it?
>>>>>>
>>>>>> Matt, there is a way to manually repair the broken symbolic links
>>>>>> using the Firestorm viewer latest release 4.6.9  by right clicking on
>>>>>> any broken link and selecting "Replace Links"... but as you can
>>>>>> understand its a very laborious process and only suited for
>>>>>> identifying the actual assets that are still in their correct
>>>>>> place.  For those with many outfits or symbolic links. its much
>>>>>> better just to start from scratch and make new outfits.
>>>>>>
>>>>>> I move all the broken "My Outfits" sub-folders into a new folder
>>>>>> "Broken Outfits" and use those as a guide to what I need in the
>>>>>> outfits, but the start from scratch.
>>>>>>
>>>>>> Remember "Current Outfit" is broken as well, which is why every
>>>>>> avatar on the rebuilt grid will initially show as a cloud.  So every
>>>>>> avatar does need to select and wear a new outfit.  I provide a "Ruth"
>>>>>> new outfit or they can select whatever initial avatar they had for
>>>>>> that purpose for every avatar.
>>>>>>
>>>>>> I have not tried your idea of doing data base changes to make this
>>>>>> smoother for users.   I just tell them on login to the rebuilt grid
>>>>>> to re-wear their basic body items and suitable clothing items and
>>>>>> then they will rez and not be a cloud.  Then they should save that
>>>>>> outfit again.
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Opensim-users mailing list
>>>>>> Opensim-users at opensimulator.org
>>>>>> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>>>>> _______________________________________________
>>>>> Opensim-users mailing list
>>>>> Opensim-users at opensimulator.org
>>>>> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>>>>
>>>> _______________________________________________
>>>> Opensim-users mailing list
>>>> Opensim-users at opensimulator.org
>>>> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>>>
>>> _______________________________________________
>>> Opensim-users mailing list
>>> Opensim-users at opensimulator.org
>>> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>>>
>>
>>
>> -- 
>> Justin Clark-Casey (justincc)
>> OSVW Consulting
>> http://justincc.org
>> http://twitter.com/justincc
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at opensimulator.org
>> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
> 
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
> 

-- 
Justin Clark-Casey (justincc)
OSVW Consulting
http://justincc.org
http://twitter.com/justincc