Avatar creation using mySQL?

Post here your questions about the OpenSpace 1.x or notify bugs and suggestions.

Moderators: Lapo, Bax

Post Reply
Star
Posts: 1
Joined: 14 Nov 2008, 16:14

Avatar creation using mySQL?

Post by Star »

Is it possible to create avatars for OpenSpace using mySQL? I already have a site, and I am able to create avatars using mySQL that are not used in OpenSpace, but I was curious if there was some way to add them, and the user accounts into OpenSpace?
I use Adobe Flash CS3, along with the OpenSpace trial, phpBB forums, and nulavatar, and I was hoping someone could let me know is this is somehow possible, and, if so, could you point me in the right direction of how to do this, or at least give me a site that might help me? (I'm new to coding with such advanced stuff, but I catch on quickly, so if you explain, I'll probably be able to understand.)
I look forward to getting your responses.
If this isn't possible, that's okay, too. Thanks so much!
Senshi
Posts: 12
Joined: 02 Nov 2008, 21:23
Location: the Netherlands, Friesland

Post by Senshi »

Hey Star,

I myself haven't gotten as far as the Avatar Creation System yet, but I can log in using PHP and MySQL. I suggest you google up some tutorials on MySQL, PHP and AS3, but the basic layout would probably be:

MySQL Table with columns:
Username/ ID
Hair
Shirt
Pants
Shoes
Accessories

Making a PHP script returning a value for Hair, Shirt, etc.
Then, in AS3, pass those returned values to the initialSkin of the OS Engine.

I have no idea if this is the most efficient way of doing things, but it's probably how I'm gonna try it for my game. ;)

Best of luck!

~Senshi
function signature():void{
if(currentsig == boring){
readervoteboring+=1;}
else if(currentsig == ok){
readervotekeep+=1;}}
public var readervoteboring:Number = 0;
public var readervotekeep:Number = 0;
User avatar
Bax
Site Admin
Posts: 4626
Joined: 29 Mar 2005, 09:50
Location: Italy
Contact:

Post by Bax »

I second the Senshi reply.
Paolo Bax
The SmartFoxServer Team
Post Reply