Hi, <br><br>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. <br><blockquote type="cite" style>LLWearable version 22<br>
XYZ Shape<br><br>when i try to :select * from assets where name like 'LLWearable version 22' or XYZ Shape, my database is goes a critical side. <br><br>Maybe i couldnt understand sth that you explain. </blockquote>
<br><div class="gmail_quote">16 Şubat 2012 10:13 tarihinde Gudule Lapointe <span dir="ltr"><<a href="mailto:gudule@spekuloos.be">gudule@spekuloos.be</a>></span> yazdı:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">Oops. Forgot one useful information: <div><div class="im"><blockquote type="cite">In the DB, each shape is stored as a new asset in the assets table, where they look something like this:<br>
</blockquote><br></div><div><div class="h5"><div><div><div style="word-wrap:break-word"><br></div><div style="word-wrap:break-word">Gökhan,<br><div><br></div><div>I see you repeat the question, but did you try Vanish's advice? (copied it below)</div>
<div><br></div><div>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.</div>
<div><br></div><div><br></div><div><blockquote type="cite">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.</blockquote>
<div><blockquote type="cite"><br></blockquote></div><blockquote type="cite">LLWearable version 22<br>XYZ Shape<br><br><span style="white-space:pre-wrap"> </span>permissions 0<br><span style="white-space:pre-wrap"> </span>{<br>
<span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>base_mask<span style="white-space:pre-wrap"> </span>7fffffff<br><span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>owner_mask<span style="white-space:pre-wrap"> </span>7fffffff<br>
<span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>group_mask<span style="white-space:pre-wrap"> </span>00000000<br><span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>everyone_mask<span style="white-space:pre-wrap"> </span>00000000<br>
<span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>next_owner_mask<span style="white-space:pre-wrap"> </span>00082000<br><span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>creator_id<span style="white-space:pre-wrap"> </span>3a1b3c48-fc73-4e20-db52-1ca611b2f058<br>
<span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>owner_id<span style="white-space:pre-wrap"> </span>3a1b3c48-fc73-4e20-db52-1ca611b2f058<br><span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>last_owner_id<span style="white-space:pre-wrap"> </span>3a1b3c48-fc73-4e20-db52-1ca611b2f058<br>
<span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>group_id<span style="white-space:pre-wrap"> </span>00000000-0000-0000-0000-000000000000<br><span style="white-space:pre-wrap"> </span>}<br>
<span style="white-space:pre-wrap"> </span>sale_info<span style="white-space:pre-wrap"> </span>0<br><span style="white-space:pre-wrap"> </span>{<br><span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>sale_type<span style="white-space:pre-wrap"> </span>not<br>
<span style="white-space:pre-wrap"> </span><span style="white-space:pre-wrap"> </span>sale_price<span style="white-space:pre-wrap"> </span>10<br><span style="white-space:pre-wrap"> </span>}<br>type 0<br>parameters 82<br>1 0<br>
2 -.14<br>4 .25<br>5 -.1</blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">(…)<br><br><br><div><br></div><div>
<span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"></span></div>
</span></div></span></div></span></div></span></span></div></blockquote><div><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<div>--</div><div><a href="http://www.speculoos.net/" target="_blank">http://www.speculoos.net/</a></div><div><a>secondlife://speculoos.net:8002/</a></div><div>Speculoos, the belgian cookie-flavored metaverse</div></div></span></div>
</span></div></span></div></span></div></span></span>
</div>
<br><div><div>Le 16 févr. 2012 à 08:36, Gökhan Gökçe a écrit :</div><br><blockquote type="cite">Hi,<br><br>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:<div>
<br>Any record in database to change gender? or <br>Any permission in database to edit avatar on viewer?<br><br>Thanks.<br><br><div class="gmail_quote">2012/2/16 Wade Schuette <span dir="ltr"><<a href="mailto:wade.schuette@gmail.com" target="_blank">wade.schuette@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Who ever looks in the database, even if it is in there, because what
would it mean anyway?<br>
Virtual sexual identity can be put on or taken off just like age,
racial identity, and other clothes.<br>
<br>
If you dress like a man, wear a male skin, and act like a man
you'll get treated like a man.<br>
If you dress like a woman, wear a female skin, and act like a woman,
you'll get treated like a woman.<br>
If you dress like a robot or dragon and have an ambiguous name,
you'll be treated neutrally.<br>
<br>
I'm not sure anyone cares what you "really" are in the database.<br>
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.<div><div><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
On 2/15/12 10:49 PM, Gökhan Gökçe wrote:
<blockquote type="cite">The editor says, i cant modify my gender, or
appearance. It is a block in database i know. But how can i edit
this?<br>
<br>
<div class="gmail_quote">15 Şubat 2012 20:34 tarihinde Sarge
Misfit <span dir="ltr"><<a href="mailto:fubat.enterprises@gmail.com" target="_blank">fubat.enterprises@gmail.com</a>></span>
yazdı:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Wouldn't it
be easiest to go inworld and Edit Appearance to change the
gender?
<div>
<div><br>
<br>
<div class="gmail_quote">2012/2/15 Gökhan Gökçe <span dir="ltr"><<a href="mailto:gokhangokce86@gmail.com" target="_blank">gokhangokce86@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Yeah
i mean gender. So what can i do for define a male
avatar?<br>
<br>
<div class="gmail_quote">15 Şubat 2012 18:40 tarihinde
Garmin Kawaguichi <span dir="ltr"><<a href="mailto:garmin.kawaguichi@magalaxie.com" target="_blank">garmin.kawaguichi@magalaxie.com</a>></span>
yazdı:
<div>
<div><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#ffffff">
<div><font face="Arial">85% sure that the
sex (gender) is not documented in an
OpenSim table.</font></div>
<div> </div>
<div><font face="Arial">Sex is a subjective
idea resulting from the name and the
appearence.</font></div>
<div> </div>
<div><font face="Arial">GCI</font></div>
<blockquote style="BORDER-LEFT:#000000 2px solid;PADDING-LEFT:5px;PADDING-RIGHT:0px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px">
<div>
<div>
<div style="FONT:10pt arial">-----
Original Message ----- </div>
<div style="FONT:10pt arial;BACKGROUND:#e4e4e4"><b>From:</b>
<a title="gokhangokce86@gmail.com" href="mailto:gokhangokce86@gmail.com" target="_blank">Gökhan Gökçe</a> </div>
<div style="FONT:10pt arial"><b>To:</b>
<a title="opensim-users@lists.berlios.de" href="mailto:opensim-users@lists.berlios.de" target="_blank">opensim-users@lists.berlios.de</a>
</div>
<div style="FONT:10pt arial"><b>Sent:</b>
Wednesday, February 15, 2012 5:14 PM</div>
<div style="FONT:10pt arial"><b>Subject:</b>
[Opensim-users] About Changing sex
of Avatars</div>
<div><br>
</div>
Hi all,<br>
<br>
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? <br>
<br>
Thanks <br clear="all">
<div><br>
</div>
-- <br>
Gökhan Gökçe
<div><br>
Büyütech Yazılım ve Donanım <br>
</div>
<div>Ar- ge Şefi / Bilgisayar
Mühendisi <br>
</div>
<div><a href="http://www.gokhangokce.info/" target="_blank">www.gokhangokce.info</a></div>
<div><a href="tel:0506%20726%2034%2068" value="+905067263468" target="_blank">0506 726 34 68</a></div>
<br>
</div>
</div><div> <br></div>
<hr>
_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
</blockquote>
</div>
<br>
_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
<br>
</blockquote>
</div>
</div>
</div>
<div>
<div><br>
<br clear="all">
<div><br>
</div>
-- <br>
Gökhan Gökçe
<div><br>
Büyütech Yazılım ve Donanım <br>
</div>
<div>Ar- ge Şefi / Bilgisayar Mühendisi <br>
</div>
<div><a href="http://www.gokhangokce.info/" target="_blank">www.gokhangokce.info</a></div>
<div><a href="tel:0506%20726%2034%2068" value="+905067263468" target="_blank">0506 726
34 68</a></div>
<br>
</div>
</div>
<br>
_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
<br>
_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Gökhan Gökçe
<div><br>
Büyütech Yazılım ve Donanım <br>
</div>
<div>Ar- ge Şefi / Bilgisayar Mühendisi <br>
</div>
<div><a href="http://www.gokhangokce.info/" target="_blank">www.gokhangokce.info</a></div>
<div><a href="tel:0506%20726%2034%2068" value="+905067263468" target="_blank">0506 726 34 68</a></div>
<br>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Opensim-users mailing list
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
<br>
</div></div></div>
<br>_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Gökhan Gökçe<div><br>Büyütech Yazılım ve Donanım <br></div><div>Ar- ge Şefi / Bilgisayar Mühendisi <br></div><div><a href="http://www.gokhangokce.info/" target="_blank">www.gokhangokce.info</a></div>
<div><a href="tel:0506%20726%2034%2068" value="+905067263468" target="_blank">0506 726 34 68</a></div><br>
</div>
_______________________________________________<br>Opensim-users mailing list<br><a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br><a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
</blockquote></div><br></div></div>_______________________________________________<br>Opensim-users mailing list<br><a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br><a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
</div></div><br></div></div></div></div><br>_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Gökhan Gökçe<div><br>Büyütech Yazılım ve Donanım <br></div><div>Ar- ge Şefi / Bilgisayar Mühendisi <br></div><div><a href="http://www.gokhangokce.info" target="_blank">www.gokhangokce.info</a></div>
<div>0506 726 34 68</div><br>