[TheLeech]

I'm making a master account system where players can use their forum name in game to log in, From here they will get a menu to select one of there 5 characters, How would I do this using MySQL? I had done it before in Dini but with a really complex method I want it to be Less Complex, I want players character names to appear in a dialog.

Would it be somewhere along the lines of this?

PHP Code:


for(new i = 1; i < MAX_CHARACTERSPERPLAYER;i++)
{
mysql_format(mysql, query, sizeof(query),"SELECT `CharacterName`, `ID` FROM `characters` WHERE `MasterName` = '%e' LIMIT 1", PlayerInfo[playerid][Name]);
mysql_tquery(mysql, query, "OnCharacterLoad", "i", playerid);
} 


[coool]

Would it be somewhere along the lines of this?

PHP Code:


for(new i = 1; i < MAX_CHARACTERSPERPLAYER;i++)
{
mysql_format(mysql, query, sizeof(query),"SELECT `CharacterName`, `ID` FROM `characters` WHERE `MasterName` = '%e' LIMIT 1", PlayerInfo[playerid][Name]);
mysql_tquery(mysql, query, "OnCharacterLoad", "i", playerid);
} 


[/QUOTE]

Not between this but in the public OnCharacterLoad.