[Jefff]

Escape string in unban cmd

pawn Код:

@OnUnbanCheck(playerid, name[]);
@OnUnbanCheck(playerid, name[])
{
    if(cache_num_rows() > 0)
    {
        if(cache_get_field_content_int(0, "banned"))
        {
            new query[128];
            mysql_format(SQL,query,sizeof(query),"UPDATE `players` SET `banned` = 0 WHERE `username` = '%s' LIMIT 1", name);
            mysql_tquery(SQL,query,"","");
            print(query);
            SendClientMessage(playerid, -1, "SERVER:Done!");
        }//else not banned
    }
    else
        SendClientMessage(playerid, -1, "[MySQL]:This player is not registered.");

    return;
}

CMD:unban(playerid, params[])
{
    if(!IsPlayerAdmin(playerid) || Player[playerid][Admin] >= 3) SendClientMessage(playerid, -1, "SERVER:You're not admin!");
    else if(isnull(params)) SendClientMessage(playerid, -1, "SERVER:/unban [Name]");
    else if(!(2 < strlen(params) < 21)) SendClientMessage(playerid, -1, "ERROR: Name must be between 3-20 characters");
    else{
        new query[128];
        mysql_format(SQL, query, sizeof(query), "SELECT * FROM `players` WHERE `username` = '%e' LIMIT 1", params);
        mysql_tquery(SQL, query, "@OnUnbanCheck", "is", playerid, params);
    }
    return 1;
}