06.11.2013, 13:47
Whilst attempting to load the Sub-Accounts that are linked to a master account into dialog with the following code it returns a Mysql Dead connection error.
Error Code
Loading Code
Error Code
Код:
[14:59:19] >> mysql_query( Connection handle: 1 ) [14:59:19] CMySQLHandler::Query(SELECT * FROM `Character_Data` WHERE ( `owner_id` = '1' )) - Successfully executed. [14:59:19] >> mysql_num_rows( Connection handle: 1 ) [14:59:19] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [14:59:19] >> mysql_free_result( Connection handle: 1 ) [14:59:19] CMySQLHandler::FreeResult() - The result is already empty. [14:59:19] >> mysql_free_result( Connection handle: 1 ) [14:59:19] CMySQLHandler::FreeResult() - The result is already empty.
pawn Код:
public LoadMasterSubAccounts(playerid)
{
new count = 0, CharacterName[MAX_PLAYER_NAME];
format(MasterAccount[playerid][CharacterString], 128, "");
if(MasterAccount[playerid][MasterLoggedIn])
{
format(Query, sizeof(Query), "SELECT * FROM `Character_Data` WHERE ( `owner_id` = '%d' )", MasterAccount[playerid][MasterID]);
mysql_query(Query);
count = mysql_num_rows();
if(count == 0)
{
ShowPlayerDialog(playerid, DIALOG_MAINMENU, DIALOG_STYLE_LIST, "Main Menu - Character Selection", "No characters available.", "Spawn", "Quit");
}
for(new a;a<count;a++)
{
mysql_get_field("CharacterName", CharacterName);
format( MasterAccount[playerid][CharacterString], 128, "%s\n%s", MasterAccount[playerid][CharacterString], strreplace(CharacterName, '_', ' '));
printf("Character Loaded: %s",CharacterName);
mysql_next_row();
}
if(strlen(MasterAccount[playerid][CharacterString]) >= 1) { ShowPlayerDialog(playerid, DIALOG_MAINMENU, DIALOG_STYLE_LIST, "Main Menu - Character Selection", MasterAccount[playerid][CharacterString], "Spawn", "Quit"); }
mysql_free_result();
}
}