[s4kuL]

Bom.. dei uma atualizada no comando, mas continua a aparecer que nгo encontrou nenhum ban com o NICK ou IP que digitei..

pawn Код:

CMD:pban(playerid,params[])
{
    if(PlayerInfo[playerid][Admin] < 2) return SendClientMessage(playerid,Vermelho,"Vocк nгo tem permissгo para isso");
    if(isnull(params)) return SendClientMessage(playerid,Cinza,"use: /pban <nick/ip>");

    new query[1024],savingstring[256],string[1024];

    format(query,sizeof(query),"SELECT * FROM bans WHERE nick LIKE '%%%s%%' or ip LIKE '%%%s%% LIMIT 10'",params, params);
    mysql_query(Mysql, query);
    mysql_store_result();

    new
        BannedBy,
        BannedName,
        BannedIP,
        BannedReason,
        BannedDay,
        BannedMonth,
        BannedYear,
        BannedHour,
        BannedMinute
    ;

    if(mysql_num_rows() > 0)
    {
        SendClientMessage(playerid,-1,"Bans encontrados:");

        mysql_fetch_field_row(savingstring, "admin"); BannedBy = strval(savingstring);
        mysql_fetch_field_row(savingstring, "motivo"); BannedReason = strval(savingstring);
        mysql_fetch_field_row(savingstring, "dia"); BannedDay = strval(savingstring);
        mysql_fetch_field_row(savingstring, "mes"); BannedMonth = strval(savingstring);
        mysql_fetch_field_row(savingstring, "ano"); BannedYear = strval(savingstring);
        mysql_fetch_field_row(savingstring, "hora"); BannedHour = strval(savingstring);
        mysql_fetch_field_row(savingstring, "minutos"); BannedMinute = strval(savingstring);
        mysql_fetch_field_row(savingstring, "nick"); BannedName = strval(savingstring);
        mysql_fetch_field_row(savingstring, "ip"); BannedIP = strval(savingstring);

        format(string,sizeof(string),"Dia %02d/%02d/%d бs %02d/%02d %s Baniu %s(%s) por %s",
            BannedDay,
            BannedMonth,
            BannedYear,
            BannedHour,
            BannedMinute,
            BannedBy,
            BannedName,
            BannedIP,
            BannedReason
        );

        SendClientMessage(playerid,Amarelo,string);
    }
    else
    {
        SendClientMessage(playerid,Vermelho,"Nenhum ban encontrado.");
    }
    mysql_free_result();
    return 1;
}