[Tass007]

Quote:

Originally Posted by Konstantinos Actually "name" (misleading variable name) would need to be integer and you'd have to use "r" or "u" specifier in sscanf. GetName function accepts an integer, not a string so that'd give error 035. Is that the whole code in the command? If not, post the whole command. All are natives except GetName which is still not reported even if you have -d3 flag. And remove the cache from memory otherwise you're going to have memory leaks.

How do I remove the cache?

Also I changed everything to "u" specifier however now whenever I type the command it doesn't crash. But nothing is displayed no error message or success message.

PHP код:

 CMD:oban(playerid, params[])
{
    if(PlayerInfo[playerid][pAdmin] < 3) return 0;
    {
        new ID, query[250], reason[128], string[128];
        if(sscanf(params, "us[24]", ID, reason)) return SendClientMessage(playerid, COLOR_WHITE, "Usage: /offlineban [Player Name] [Reason]");
        mysql_format(ServerMySQL, query, sizeof(query), "UPDATE `Users` SET pBanned = %d, pBannedBy = '%s', pReason = '%s' WHERE Name='%s'", 1, GetName(playerid), reason, GetName(ID));
        mysql_tquery(ServerMySQL, query, "", "");
        if (!cache_affected_rows(ServerMySQL)) return SendClientMessage(playerid, COLOR_RED, "Error: That player doesn't exist"); 
        format(string,sizeof(string), "*You have successfully banned player %s.", GetName(ID));
        SendClientMessage(playerid, COLOR_ADMIN, string);
        format(amsg, sizeof(amsg), "[Admin Log]: %s has offline banned player %s [Reason: %s]", GetName(playerid), GetName(ID), reason);
        ABroadCast(COLOR_ADMIN,amsg, 1);
        if(IsPlayerConnected(ID))
        {
            SetTimerEx("UnsetBan", 500, 0, "i", ID);
        }
    }
    return 1;
}
CMD:unban(playerid,params[])
{
    if(PlayerInfo[playerid][pAdmin] <= 3) return 0;
    new ID, query[300], cmdstring[44], string[128];
    if(sscanf(params, "u", ID)) return SendClientMessage(playerid, COLOR_WHITE,"Usage: /unban [Player Name]");
    mysql_format(ServerMySQL, query, sizeof(query), "UPDATE `Users` SET pBanned = %d, pBannedBy = '%s', pReason = '%s' WHERE Name='%s'", 1, GetName(playerid), "", GetName(ID));
    mysql_tquery(ServerMySQL, query, "", "");
    if(!cache_affected_rows(ServerMySQL)) return SendClientMessage(playerid, COLOR_RED, "Error: That player doesn't exist"); 
    format(cmdstring, sizeof(cmdstring), "unbanip %s", PlayerInfo[ID][pIP]);
    SendRconCommand(cmdstring);
    SendRconCommand("reloadbans");
    format(string,sizeof(string), "*You have successfully unbanned %s.", GetName(ID));
    SendClientMessage(playerid, COLOR_ADMIN, string);
    format(amsg, sizeof(amsg), "[Admin Log]: %s has unbanned player %s", GetName(playerid), GetName(ID));
    ABroadCast(COLOR_ADMIN,amsg, 1);
    //UnBlockIpAddress( ip_address );
    return 1;
}
CMD:banreason(playerid, params[])
{
    if(PlayerInfo[playerid][pAdmin] <= 3) return 0;
    new ID, query[128], string[128], reason[128];
    if(sscanf(params, "u", ID)) return SendClientMessage(playerid, COLOR_WHITE, "Usage: /banreason [Player Name]");
    format(query, sizeof(query), "SELECT `pReason` FROM `Users` WHERE `Name` = '%s'", GetName(ID));
    mysql_query(ServerMySQL, query);
    if(cache_num_rows())
    {
        cache_get_field_content(0, "pReason", reason);
        if(!strcmp(reason, "", false, 1))
        {
            format(string,sizeof(string), "[BAN REASON]: %s was banned for: %s",GetName(ID), reason);
            SendClientMessage(playerid, COLOR_YELLOW, string);
            format(amsg,sizeof(amsg), "[Admin Log]: %s is requesting ban information on %s", GetName(playerid), GetName(ID));
        }
        else
        {
            SendClientMessage(playerid, COLOR_RED, "Error: That player isn't banned.");
        }
    }
    return 1;
}