[austin070]

My account system seems like it should be working 100%. It does register players and log them in how it's supposed to, but when a player is in game and the server is restarted, the dialog freezes when the player reconnects (meaning no text can be entered and you have to ctrl+alt+del to exit). Additionally, if the server has been sitting for a while, the dialog does not show up at all. If you connect normally when the server is fresh, it works just as it should.

pawn Код:

public OnPlayerConnect(playerid)
{
    new query[256];
    format(query, sizeof(query), "SELECT `user` FROM `playerdata` WHERE user = '%s'", GetPName(playerid));
    mysql_query(query);
    mysql_store_result();
    new rows = mysql_num_rows();
    mysql_free_result();
    
    if(rows != 0)
    {
       
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Please log-in", ""White"Welcome back to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to log-in!\n\n"White"Please insert "Red"your"White" password below:", "Login", "Cancel");
    }
    else
    {
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Please register",""White"Welcome to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to register!\n\n"White"Please insert a password below:", "Register", "Cancel");
    }
    return 1;
}