altitude ranks

[Nikon]

When are the rankings going to be fixed on the ladder site? it's been a while now, is anything going on behind the scenes in trying to solve this problem?

[trendy11one]

you jelly?

[[Y]]

Originally Posted by trendy11one

you jelly?

the real question is, who's holding rank 0?

???

[some poor soul]

trendy is working hard to fix this asap

[Aki1024]

I have read only access to the database. This is the fix.

SET @rownum=0;
UPDATE player_ladder_stats pls,
	(SELECT @rownum:=@rownum+1 rownum, pls2.vaporid, pls2.rating FROM player_ladder_stats pls2 ORDER BY 3 DESC) pls_row
SET pls.rank = pls_row.rownum
WHERE (pls.vaporid = pls_row.vaporid) AND pls.game_mode = 'ball_6v6'

I have other SQL that needs ran on the database. PST ^.^

[Tekn0]

Aki, you forgot one important thing:

DROP TABLE player_ladder_stats

[Aki1024]

Originally Posted by Tekn0

Aki, you forgot one important thing:

I knew I was missing something! Just couldn't put my finger on it.