[heroicpower7613]

related topic here but its very unclear if there's a fix or not
https://forums.alliedmods.net/showth...t=68161&page=2

there's another plugin that shows rank with this plugin's native

errors:

Spoiler

L 07/02/2017 - 20:57:27: [MySQL] No result set in this query!
L 07/02/2017 - 20:57:27: [AMXX] Displaying debug trace (plugin "counter.amxx")
L 07/02/2017 - 20:57:27: [AMXX] Run time error 10: native error (native "SQL_ReadResult")
L 07/02/2017 - 20:57:27: [AMXX] [0] counter.sma::Sql_Rank (line 740)

code (i made a comment where the error line is):

Spoiler

public plugin_natives( )
{
    register_native( "get_rank", "native_get_rank" );
}

public native_get_rank( plugin_id, argc )
{
    new id = get_param(1);
    if( !is_user_connected(id) ) 
        return 0;
    
    return Rank[id];
}

public GetRank(id)
{
    for(new i; i < MaxPlayers; i++)
    {
        if(is_user_connected(i))
            MySQL_Save(i);
    }
    new Data[1]; Data[0] = id;
    new szTemp[512];
    new szAuth[64];
    
    get_user_authid(id, szAuth, 63);
    
    format(szTemp,charsmax(szTemp), "SELECT (COUNT(*)+1) AS rank FROM `counter` WHERE (data1+data2) > (SELECT data1+data2 FROM `counter` WHERE steamid = '%s')", szAuth );
    SQL_ThreadQuery(MySQL_Tuple, "Sql_Rank", szTemp, Data, 1)
    
    return PLUGIN_HANDLED;
}

public Sql_Rank(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
    if(FailState == TQUERY_CONNECT_FAILED)
        log_amx("Could not load - Error connecting to database. [%d] %s", Errcode, Error)
    else if(FailState == TQUERY_QUERY_FAILED)
        log_amx("Load Query failed. [%d] %s", Errcode, Error)
        
    new id; id = Data[0];
    
    if( !is_user_connected( id ) ) 
    {
        Rank[id] = 0;
        return PLUGIN_HANDLED;
    }
    
    //error below
    Rank[id] = SQL_ReadResult(Query, 0);
    //error above
    
    return PLUGIN_HANDLED;
}

[Black Rose]

The errors you have is one error. The first line is the most important one.

Check if you have any result before trying to read it using SQL_NumResults().

[heroicpower7613]

like this?

public Sql_Rank(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
    if(FailState == TQUERY_CONNECT_FAILED)
        log_amx("Could not load - Error connecting to database. [%d] %s", Errcode, Error)
    else if(FailState == TQUERY_QUERY_FAILED)
        log_amx("Load Query failed. [%d] %s", Errcode, Error)
        
    new id; id = Data[0];
    
    if( !is_user_connected( id ) ) 
    {
        Rank[id] = 0;
        return PLUGIN_HANDLED;
    }
    
    if( SQL_NumResults( Query ) > 1 ) 
        Rank[id] = SQL_ReadResult(Query, 0);
    
    return PLUGIN_HANDLED;
}

i'll see if the error stops ty

[Black Rose]

Now you require 2 or more results to read it. Perhaps > 0 or => 1 to include 1 result as well.

[heroicpower7613]

yes haha I was just derping I did notice it.
btw shouldn't just this work too?

if( SQL_NumResults( Query ) )
        Rank[id] = SQL_ReadResult(Query, 0);

[Black Rose]

Unless that native doesn't return negative numbers on errors, yes.

[heroicpower7613]

ok it's been few days and as far as I can tell this is fixed.
the error definitely should've occurred by now so thanks