<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi again<div><br></div><div>Just tried and changed Demo gender…</div><div><br></div><div>I am afraid you already got the best answers</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>- the locked default avatar is a common issue, not really related to the database or the viewer</div><div><div><span class="Apple-tab-span" style="white-space: pre; "> </span>(and this applies actually to each body part and clothe included in the default avatar)</div><div><span class="Apple-tab-span" style="white-space: pre; "> </span>- the place in the database where you can change gender should be one of the parameters inside "data" field of the shape asset</div></div><div><br></div><div>IMHO, the simplest would be to provide to your customer:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>- a simple notice to tell them they have to create a new shape/body part to be able to edit it (which includes choosing gender)</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>- a collection of freebie avatars so they can just choose one instead of having to change learn how to make an avatar as a first step inside your world</div><div><br></div><div>Additionally</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>- there are a couple of web interfaces which provide the ability to choose avatar upon account creation.</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>- in an earlier discussion on this mailing list about locked avatar, if I can trust my memories, this issue has been told as solved in recent opensim builds. But it can still exist however, depending of other modules you may have installed</div><div><br></div><div><br><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>--</div><div><a href="http://www.speculoos.net/">http://www.speculoos.net/</a></div><div><a href="secondlife://speculoos.net:8002/">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 à 11:51, Gökhan Gökçe a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi, <br><br>I opened a demo user in my system. <br><br>Username : Demo Demo<br>pass: 12345678<br><br>login ip: <a href="http://94.73.162.61:8002/">http://94.73.162.61:8002</a><br><br>When i create a new avatar, it becomes a female and i cant change the settings of it on Imprudence or Hippo. I just wonder that, if the database has a block for me to change gender. For example:<br>
<br>dbname : opensim ,--- table: avatar --- columnname: gender <br><br><div>column data: 1 <br><br>--------------------<br>Is there any data like that i asked. <br><br><br><div class="gmail_quote">2012/2/16 InuYasha Meiji <span dir="ltr"><<a href="mailto:inuyasha.meiji@gmail.com">inuyasha.meiji@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I am starting to wonder if we are all misunderstanding the question.<br>
<br>
Is the problem that when a new user starts out they get the female AV, and wish the default AV was a male AV? Or, are you finding new users get the female Ruth AV and can't edit the appearance and can't change the sex, not realizing that the sex is part of the all around appearance of the AV?<br>
<br>
Another thing it might be: Are you looking for an external way either by web page or script to change the sex of avatars?<br>
<br>
Answering this might help us help you.<br>
I am only trying to be helpfull,<br>
InuYasha.<div class="im"><br>
<br>
<br>
On 2/16/2012 4:28 AM, Gudule Lapointe wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I got the same behavior making simple requests.<br>
<br>
It looks like the assets table is very huge, you better<br>
- search an indexed field like CreatorID or ID<br>
- use inventoryitems table to search the assetID, and then only use assets table to get the data<br>
<br>
I got result with a request like this one:<br>
SELECT assets.data FROM assets, inventoryitems WHERE inventoryName like '%shape%' and assetID = <a href="http://assets.id/" target="_blank">assets.id</a>;<br>
<br>
Of course, you will adapt for your case, probably looking for the owner ID and the name of the default shape…<br>
<br>
<br>
</blockquote>
<br>
-- <br></div>
______________________________<u></u>______________________________<u></u>____<br>
Opensim User: Standalone Grid on Version 0.7.2 with 49 Regions<br>
on Windows 7, 64-bit. Phenom 9500 2.2 ghz Quad Core, Terabyte Hard<br>
Drive, 8gig DDR2 RAM. Used XAMPP to load PHP Version 5.3.0, Apache<br>
and MySQL 5.1.41-community edition.<br>
______________________________<u></u>______________________________<u></u>____<div class="HOEnZb"><div class="h5"><br>
<br>
______________________________<u></u>_________________<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/<u></u>mailman/listinfo/opensim-users</a><br>
</div></div></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>
</div>
_______________________________________________<br>Opensim-users mailing list<br><a href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a><br>https://lists.berlios.de/mailman/listinfo/opensim-users<br></blockquote></div><br></div></body></html>