[08:47:42] [Command]: [vR]Yottabyte has used the command /banreason.
[08:47:46] [debug] Server crashed while executing vR.amx
[08:47:46] [debug] AMX backtrace:
[08:47:46] [debug] #0 00000061 in ?? () at <unknown file>:0
[08:47:46] [debug] #1 00000061 in public cmd_banreason () at <unknown file>:0
[08:47:46] [debug] #2 native CallLocalFunction () from samp03svr
[08:47:46] [debug] #3 00000a58 in public OnPlayerCommandText (playerid=0, cmdtext[]=@016e8090 "/banreason dwa") at E:\All Folders\Hobbies\Server Hosting\SA-MP\__VR\pawno\include\zcmd.inc:108

CMD:banreason(playerid, params[])
{
    if(PlayerInfo[playerid][pAdmin] <= 3) return 0;
    new name[24], query[128], string[128], reason[128];
    if(sscanf(params, "s[24]", name)) return SendClientMessage(playerid, COLOR_WHITE, "Usage: /banreason [Player Name]");
    format(query, sizeof(query), "SELECT `pReason` FROM `Users` WHERE `Name` = '%s'", name);
    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", name, reason);
            SendClientMessage(playerid, COLOR_YELLOW, string);
            format(amsg,sizeof(amsg), "[Admin Log]: %s is requesting ban information on %s", GetName(playerid), name);
            // Rest of code here
        }
        else
        {
            SendClientMessage(playerid, COLOR_RED, "Error: That player isn't banned.");
        }
    }
    return 1;
}

CMD:banreason(playerid, params[])
{
    if(PlayerInfo[playerid][pAdmin] <= 3) return 0;
    new name[24], query[128], string[128], reason[128];
    if(sscanf(params, "s[24]", name)) return SendClientMessage(playerid, COLOR_WHITE, "Usage: /banreason [Player Name]");
    format(query, sizeof(query), "SELECT `pReason` FROM `Users` WHERE `Name` = '%s'", name);
    new Cache:cquery;
    cquery = 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", name, reason);
            SendClientMessage(playerid, COLOR_YELLOW, string);
            format(amsg,sizeof(amsg), "[Admin Log]: %s is requesting ban information on %s", GetName(playerid), name);
            // Rest of code here
        }
        else
        {
            SendClientMessage(playerid, COLOR_RED, "Error: That player isn't banned.");
        }
    }
    cache_delete(cquery);
    return 1;
}

../gamemodes/inc/admincommands.pwn(314) : error 021: symbol already defined: "query"
../gamemodes/inc/admincommands.pwn(315) : error 035: argument type mismatch (argument 2)

../gamemodes/inc/admincommands.pwn(315) : error 033: array must be indexed (variable "query")

 cquery = mysql_query(ServerMySQL, query); //315

CMD:oban(playerid, params[])
{
    if(PlayerInfo[playerid][pAdmin] < 3) return 0;
    {
        new name[24], query[250], reason[128], string[128];
        if(sscanf(params, "s[24]s[24]", name, reason)) return SendClientMessage(playerid, COLOR_WHITE, "Usage: /offlineban [Player Name] [Reason]");
        mysql_format(ServerMySQL, query, sizeof(query), "UPDATE `Users` SET pBanned = 1, pBannedBy = '%s', pReason = '%s' WHERE Name='%s'", GetName(playerid), reason, name);
        new Cache:c = mysql_query(ServerMySQL, query);
        if (!cache_affected_rows(ServerMySQL))
        {
            cache_delete©;
            return SendClientMessage(playerid, COLOR_RED, "Error: That player doesn't exist"); 
        }
        format(string,sizeof(string), "*You have successfully banned player %s.", name);
        SendClientMessage(playerid, COLOR_ADMIN, string);
        format(amsg, sizeof(amsg), "[Admin Log]: %s has offline banned player %s [Reason: %s]", GetName(playerid), name, reason);
        ABroadCast(COLOR_ADMIN,amsg, 1);
        foreach(new i : Player)
        {
            GetPlayerName(i, string, 24);
            if(!strcmp(string, name, true))
            {
                SetTimerEx("UnsetBan", 500, 0, "i", i);
                break;
            }
        }
        cache_delete©;
    }
    return 1;
}

CMD:unban(playerid,params[])
{
    if(PlayerInfo[playerid][pAdmin] <= 3) return 0;
    new name[24], query[300], cmdstring[44], string[128];
    if(sscanf(params, "s", name)) return SendClientMessage(playerid, COLOR_WHITE,"Usage: /unban [Player Name]");
    mysql_format(ServerMySQL, query, sizeof(query), "UPDATE `Users` SET pBanned = 0, pBannedBy = '%s', pReason = '' WHERE Name='%s'", GetName(playerid), name);
    new Cache:c = mysql_query(ServerMySQL, query);
    if(!cache_affected_rows(ServerMySQL)) 
    {
        cache_delete©;
        return SendClientMessage(playerid, COLOR_RED, "Error: That player doesn't exist"); 
    }
    cache_delete©;
    mysql_format(ServerMySQL, query, sizeof(query), "SELECT `IP_COLUMN_NAME_HERE` FROM `Users` WHERE Name='%s'", name); // You need to fetch player IP first
    c = mysql_query(ServerMySQL, query);
    if(cache_num_rows())
    {
        new playerip[16];
        cache_get_field_content(0, 'IP_COLUMN_NAME_HERE', playerip, ServerMySQL, 16);
        format(cmdstring, sizeof(cmdstring), "unbanip %s", playerip);
        SendRconCommand(cmdstring);
        SendRconCommand("reloadbans");
    }
    format(string,sizeof(string), "*You have successfully unbanned %s.", name);
    SendClientMessage(playerid, COLOR_ADMIN, string);
    format(amsg, sizeof(amsg), "[Admin Log]: %s has unbanned player %s", GetName(playerid), name);
    ABroadCast(COLOR_ADMIN,amsg, 1);
    cache_delete©;
    return 1;
}