[Jefff]

pawn Код:

CMD:searchban(playerid, params[])
{
    if(!PlayerInfo[playerid][AdminLevel]) SendClientMessage(playerid, COLOR_ORANGE, "NOTE: You need to be an admin!");
    else if(isnull(params)) SendClientMessage(playerid, COLOR_NOTES, "USAGE: /searchban PLAYERNAME/PLAYERIP");
    else{
        new Query[240], string[145];
        format(Query, sizeof(Query), "SELECT * FROM `BANNED` WHERE `NAME` LIKE '%s' OR `IP` LIKE '%s' ORDER BY `DATE` DESC LIMIT 6", params, params);
        new DBResult:Result = db_query(HDF, Query);
        if(db_num_rows(Result))
        {
            new BannedBy[MAX_PLAYER_NAME], BannedName[MAX_PLAYER_NAME], BannedIP[MAX_PLAYER_NAME], BannedReason[MAX_PLAYER_NAME*2];
            do
            {
                db_get_field_assoc(Result, "NAME", BannedName, sizeof(BannedName));
                db_get_field_assoc(Result, "IP", BannedIP, sizeof(BannedIP));
                db_get_field_assoc(Result, "ADMIN", BannedBy, sizeof(BannedBy));
                db_get_field_assoc(Result, "REASON", BannedReason, sizeof(BannedReason));

                format(string, sizeof(string), "- %s(IP: %s) - banned by %s - due to %s", BannedName, BannedIP, BannedBy, BannedReason);
                SendClientMessage(playerid, COLOR_NOTES2, string);
            }
            while(db_next_row(Result));
        }
        else SendClientMessage(playerid, COLOR_ORANGE, "NOTE: No bans found!");
        db_free_result(Result);
    }
    return 1;
}