[Patrick]

Quote:

Originally Posted by iBeast can somebody guide me with the fetch field since I dont really understand sscanf that well.

This should work sscanf version.

pawn Код:

stock MySQL_Login(playerid)
{
    new query[300], string[256];

    format( query, sizeof( query ), "SELECT * FROM `Accounts` WHERE `Nick` = '%s'", GetName( playerid ) );
    mysql_query( query );

    mysql_store_result( );

    if( mysql_num_rows( ) )
    {
        if(mysql_fetch_row_format(query, "|"))
        {
            sscanf(query, "p<|>iiiiii", PlayerInfo[playerid][Admin], PlayerInfo[playerid][Score], PlayerInfo[playerid][Money], PlayerInfo[playerid][Kills], PlayerInfo[playerid][Deaths], PlayerInfo[playerid][Muted]);
        }
    }
    mysql_free_result( );

    GivePlayerMoney( playerid, PlayerInfo[playerid][Money] ), SetPlayerScore( playerid, PlayerInfo[playerid][Score] );

    PlayerInfo[ playerid ][ Login ] = 1;

    if(PlayerInfo[playerid][Admin] >= 1)
    {
        format(string, sizeof(string), "[ACCOUNT] "cwhite"Successfully Logged in. Welcome Admin. Your Level is %d",PlayerInfo[playerid][Admin]);
        SCM(playerid, xgreen, string);
    }
    else
    {
        format(string, sizeof(string), "[ACCOUNT] "cwhite"Successfully Logged in.");
        SCM(playerid, xgreen, string);
    }
    return 1;
}