Hi guys. I wanted to know if this way of obtaining rank can cause server lag. Sorry for my english :c
PHP Code:
public clcmd__Rank(id)
{
static iData[1]
formatex(g_szQuery, charsmax( g_szQuery ), "SELECT * FROM %s ORDER BY `Level` DESC, `KILLS` DESC", szTableData)
iData[0] = id
mysql_query(g_Connection, "rankMe", g_szQuery, iData, 1)
}
public rankMe(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 {
static id; id = data[0]
if(mysql_num_results())
{
static Count, Character[33]
Count = 0
WPN_MAXTOP = mysql_num_results()
for(new i = 0;i < Count;i++)
mysql_next_row()
while(mysql_more_results())
{
if(Count < WPN_MAXTOP)
{
mysql_read_result(mysql_fieldnametonum("Character"), Character, 32)
if (equal(Character, g_playername[id]))
{
colorChat(id, _, "!g[%s]!y Rank position:!g %d / %d", COMMUNITY, Count+1, WPN_MAXTOP)
mysql_next_row()
break;
}
Count++
mysql_next_row()
}
else
break;
}
}
}
}