I got the same behavior making simple requests.
It looks like the assets table is very huge, you better
- search an indexed field like CreatorID or ID
- use inventoryitems table to search the assetID, and then only use
assets table to get the data
I got result with a request like this one:
SELECT assets.data FROM assets, inventoryitems WHERE inventoryName like
'%shape%' and assetID = assets.id;
Of course, you will adapt for your case, probably looking for the owner ID and
the name of the default shape…
--
http://www.speculoos.net/
secondlife://speculoos.net:8002/
Speculoos, the belgian cookie-flavored metaverse
Le 16 févr. 2012 à 09:44, Gökhan Gökçe a écrit :
> Hi,
>
> First, thanks to you for your replies. I couldnt try Vanis's advice because,
> in assets table i couldnt search this fields. Or i understood sth wrong i
> think.
>> LLWearable version 22
>> XYZ Shape
>>
>> when i try to :select * from assets where name like 'LLWearable version 22'
>> or XYZ Shape, my database is goes a critical side.
>>
>> Maybe i couldnt understand sth that you explain.
>
> 16 Şubat 2012 10:13 tarihinde Gudule Lapointe <[email protected]> yazdı:
> Oops. Forgot one useful information:
>> In the DB, each shape is stored as a new asset in the assets table, where
>> they look something like this:
>
>
> Gökhan,
>
> I see you repeat the question, but did you try Vanish's advice? (copied it
> below)
>
> Note about the "blocked" default avatar, I think it is not blocked by in
> "pure", unmodified OpenSim server. There are some tweaks with modules like
> Diva, which block the default outfit. A possible workaround is to create a
> new shape, in which case everything should be modifiable. Other workaround do
> exist, but it depends of your configuration and details of your project.
>
>
>> Without knowing what relates to all parameters here, a wild guess would be
>> that either the type parameter or (more likely) the parameter 1 defines the
>> gender.
>>
>> LLWearable version 22
>> XYZ Shape
>>
>> permissions 0
>> {
>> base_mask 7fffffff
>> owner_mask 7fffffff
>> group_mask 00000000
>> everyone_mask 00000000
>> next_owner_mask 00082000
>> creator_id 3a1b3c48-fc73-4e20-db52-1ca611b2f058
>> owner_id 3a1b3c48-fc73-4e20-db52-1ca611b2f058
>> last_owner_id 3a1b3c48-fc73-4e20-db52-1ca611b2f058
>> group_id 00000000-0000-0000-0000-000000000000
>> }
>> sale_info 0
>> {
>> sale_type not
>> sale_price 10
>> }
>> type 0
>> parameters 82
>> 1 0
>> 2 -.14
>> 4 .25
>> 5 -.1
>>
>> (…)
>>
>>
>>
> --
> http://www.speculoos.net/
> secondlife://speculoos.net:8002/
> Speculoos, the belgian cookie-flavored metaverse
>
> Le 16 févr. 2012 à 08:36, Gökhan Gökçe a écrit :
>
>> Hi,
>>
>> If you create an avatar on opensim in grid mode, it creates a default one
>> and you cannot edit your gender, and some body parts. (etc: boobs) This is a
>> work my friend. I dont care about gender but my customer does. So i asked a
>> basic question:
>>
>> Any record in database to change gender? or
>> Any permission in database to edit avatar on viewer?
>>
>> Thanks.
>>
>> 2012/2/16 Wade Schuette <[email protected]>
>> Who ever looks in the database, even if it is in there, because what would
>> it mean anyway?
>> Virtual sexual identity can be put on or taken off just like age, racial
>> identity, and other clothes.
>>
>> If you dress like a man, wear a male skin, and act like a man you'll get
>> treated like a man.
>> If you dress like a woman, wear a female skin, and act like a woman, you'll
>> get treated like a woman.
>> If you dress like a robot or dragon and have an ambiguous name, you'll be
>> treated neutrally.
>>
>> I'm not sure anyone cares what you "really" are in the database.
>> There are so called "male" and "female" core avatar mesh models, with
>> somewhat different controls over appearance, but I don't think that
>> information is visible if you aren't that obvious about your choice, and
>> even if it were visible, people mis-represent themselves in virtual worlds
>> and you can never be sure who someone else is.
>>
>>
>>
>>
>>
>>
>>
>>
>> On 2/15/12 10:49 PM, Gökhan Gökçe wrote:
>>>
>>> The editor says, i cant modify my gender, or appearance. It is a block in
>>> database i know. But how can i edit this?
>>>
>>> 15 Şubat 2012 20:34 tarihinde Sarge Misfit <[email protected]>
>>> yazdı:
>>> Wouldn't it be easiest to go inworld and Edit Appearance to change the
>>> gender?
>>>
>>>
>>> 2012/2/15 Gökhan Gökçe <[email protected]>
>>> Yeah i mean gender. So what can i do for define a male avatar?
>>>
>>> 15 Şubat 2012 18:40 tarihinde Garmin Kawaguichi
>>> <[email protected]> yazdı:
>>>
>>> 85% sure that the sex (gender) is not documented in an OpenSim table.
>>>
>>> Sex is a subjective idea resulting from the name and the appearence.
>>>
>>> GCI
>>> ----- Original Message -----
>>> From: Gökhan Gökçe
>>> To: [email protected]
>>> Sent: Wednesday, February 15, 2012 5:14 PM
>>> Subject: [Opensim-users] About Changing sex of Avatars
>>>
>>> Hi all,
>>>
>>> I am using opensim in grid mode and using mysql database. Can you tell me
>>> how can i change my avatar's sex in database?
>>>
>>> Thanks
>>>
>>> --
>>> Gökhan Gökçe
>>>
>>> Büyütech Yazılım ve Donanım
>>> Ar- ge Şefi / Bilgisayar Mühendisi
>>> www.gokhangokce.info
>>> 0506 726 34 68
>>>
>>>
>>> _______________________________________________
>>> Opensim-users mailing list
>>> [email protected]
>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>
>>> _______________________________________________
>>> Opensim-users mailing list
>>> [email protected]
>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>
>>>
>>>
>>>
>>> --
>>> Gökhan Gökçe
>>>
>>> Büyütech Yazılım ve Donanım
>>> Ar- ge Şefi / Bilgisayar Mühendisi
>>> www.gokhangokce.info
>>> 0506 726 34 68
>>>
>>>
>>> _______________________________________________
>>> Opensim-users mailing list
>>> [email protected]
>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>
>>>
>>>
>>> _______________________________________________
>>> Opensim-users mailing list
>>> [email protected]
>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>
>>>
>>>
>>>
>>> --
>>> Gökhan Gökçe
>>>
>>> Büyütech Yazılım ve Donanım
>>> Ar- ge Şefi / Bilgisayar Mühendisi
>>> www.gokhangokce.info
>>> 0506 726 34 68
>>>
>>>
>>>
>>> _______________________________________________
>>> Opensim-users mailing list
>>> [email protected]
>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>
>>
>> _______________________________________________
>> Opensim-users mailing list
>> [email protected]
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>
>>
>>
>>
>> --
>> Gökhan Gökçe
>>
>> Büyütech Yazılım ve Donanım
>> Ar- ge Şefi / Bilgisayar Mühendisi
>> www.gokhangokce.info
>> 0506 726 34 68
>>
>> _______________________________________________
>> Opensim-users mailing list
>> [email protected]
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>
> _______________________________________________
> Opensim-users mailing list
> [email protected]
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
> _______________________________________________
> Opensim-users mailing list
> [email protected]
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
>
>
> --
> Gökhan Gökçe
>
> Büyütech Yazılım ve Donanım
> Ar- ge Şefi / Bilgisayar Mühendisi
> www.gokhangokce.info
> 0506 726 34 68
>
> _______________________________________________
> Opensim-users mailing list
> [email protected]
> https://lists.berlios.de/mailman/listinfo/opensim-users
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
