[Opensim-users] About Changing sex of Avatars

[Gudule Lapointe]

Hi again

Just tried and changed Demo gender…

I am afraid you already got the best answers
	- the locked default avatar is a common issue, not really related to the database or the viewer
	(and this applies actually to each body part and clothe included in the default avatar)
	- the place in the database where you can change gender should be one of the parameters inside "data" field of the shape asset

IMHO, the simplest would be to provide to your customer:
	- 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)
	- 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

Additionally
	- there are a couple of web interfaces which provide the ability to choose avatar upon account creation.
	- 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


--
http://www.speculoos.net/
secondlife://speculoos.net:8002/
Speculoos, the belgian cookie-flavored metaverse

Le 16 févr. 2012 à 11:51, Gökhan Gökçe a écrit :

> Hi, 
> 
> I opened a demo user in my system. 
> 
> Username : Demo Demo
> pass: 12345678
> 
> login ip: http://94.73.162.61:8002
> 
> 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:
> 
> dbname : opensim ,--- table: avatar --- columnname: gender 
> 
> column data: 1 
> 
> --------------------
> Is there any data like that i asked. 
> 
> 
> 2012/2/16 InuYasha Meiji <inuyasha.meiji at gmail.com>
> I am starting to wonder if we are all misunderstanding the question.
> 
> 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?
> 
> Another thing it might be: Are you looking for an external way either by web page or script to change the sex of avatars?
> 
> Answering this might help us help you.
> I am only trying to be helpfull,
> InuYasha.
> 
> 
> 
> On 2/16/2012 4:28 AM, Gudule Lapointe wrote:
> 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…
> 
> 
> 
> -- 
> ________________________________________________________________
> Opensim User: Standalone Grid on Version 0.7.2 with 49 Regions
> on Windows 7, 64-bit. Phenom 9500 2.2 ghz Quad Core, Terabyte Hard
> Drive, 8gig DDR2 RAM.  Used XAMPP to load PHP Version 5.3.0, Apache
> and MySQL 5.1.41-community edition.
> ________________________________________________________________
> 
> 
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> 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
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20120216/99c7d8a5/attachment.html>