[Danyal]

pawn Код:

stock MySQL_Login(playerid)
{
    new query[300], exec[20], string[256];
    format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Nick` = '%s'", GetName(playerid));
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows() > 0)
    {
        if(mysql_retrieve_row())
        {
            mysql_fetch_field_row(exec,"Admin");
            PlayerInfo[playerid][Admin] = strval(exec);
            mysql_fetch_field_row(exec,"Score");
            PlayerInfo[playerid][Score] = strval(exec);
            mysql_fetch_field_row(exec,"Money");
            PlayerInfo[playerid][Money] = strval(exec);
            mysql_fetch_field_row(exec,"Kills");
            PlayerInfo[playerid][Kills] = strval(exec);
            mysql_fetch_field_row(exec,"Deaths");
            PlayerInfo[playerid][Deaths] = strval(exec);
            mysql_fetch_field_row(exec,"Muted");
            PlayerInfo[playerid][Muted] = strval(exec);
        }
    }
    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;
}