Solution:
PHP Code:
public clcmd__Rank(const id)
{
static iData[1];
formatex(g_szQuery, charsmax( g_szQuery ), "select * from ( select T.*,(@rownum := @rownum + 1) as posicion from ( select * from %s group by PJ_ID order by Level DESC, KILLS DESC ) as T JOIN (SELECT @rownum := 0) r ) as w where PJ_ID = ^"%d^"", szTableData, g_CharacterID[id]);
iData[0] = id;
mysql_query(g_Connection, "show__Rank", g_szQuery, iData, 1);
}
public show__Rank(failstate, error[], errnum, data[], size, Float:queuetime)
{
if(failstate == TQUERY_CONNECT_FAILED || failstate == TQUERY_QUERY_FAILED)
{
log_to_file( "SQL_LOG_TQ.txt", "Error en la consulta al MySQL [%i]: %s", errnum, error );
return;
}
else
{
new id = data[0]
g__RankPosition[id] = mysql_read_result(mysql_fieldnametonum("posicion"))
colorChat(id, _, "!g[%s]!y Rank position #%i / #%d", COMMUNITY, g__RankPosition[id], g__GlobalTotalCharacters)
}
}