Altitude Game: Forums  

Go Back   Altitude Game: Forums > Altitude Discussion > Ladder Discussion

Ladder Discussion Everything related to altitudeladder.com and the ladder servers goes here.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2012, 09:48 PM
Nikon Nikon is offline
Senior Member
 
Join Date: Dec 2009
Location: ball_grotto
Posts: 1,239
Default altitude ranks

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?
Reply With Quote
  #2  
Old 02-28-2012, 09:57 PM
trendy11one trendy11one is offline
Senior Member
 
Join Date: Jun 2010
Location: Moscow
Posts: 672
Default

you jelly?
Reply With Quote
  #3  
Old 02-28-2012, 11:23 PM
[Y] [Y] is offline
Senior Member
 
Join Date: Nov 2009
Location: The mafia hideout.
Posts: 3,254
Default

Quote:
Originally Posted by trendy11one View Post
you jelly?
the real question is, who's holding rank 0?

???
Reply With Quote
  #4  
Old 02-29-2012, 03:30 AM
some poor soul some poor soul is offline
Member
 
Join Date: May 2011
Posts: 30
Default

trendy is working hard to fix this asap
Reply With Quote
  #5  
Old 02-29-2012, 08:55 AM
Aki1024 Aki1024 is offline
Senior Member
 
Join Date: Jul 2011
Location: Across from you at a chess table. Your play is?
Posts: 1,080
Default

I have read only access to the database. This is the fix.
Code:
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 ^.^

Last edited by Aki1024; 02-29-2012 at 09:04 AM.
Reply With Quote
  #6  
Old 02-29-2012, 05:54 PM
Tekn0 Tekn0 is offline
Senior Member
 
Join Date: Dec 2010
Posts: 1,548
Default

Aki, you forgot one important thing:
Code:
DROP TABLE player_ladder_stats
Reply With Quote
  #7  
Old 02-29-2012, 06:30 PM
Aki1024 Aki1024 is offline
Senior Member
 
Join Date: Jul 2011
Location: Across from you at a chess table. Your play is?
Posts: 1,080
Default

Quote:
Originally Posted by Tekn0 View Post
Aki, you forgot one important thing:
I knew I was missing something! Just couldn't put my finger on it.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ace Ranks Sean General Altitude Discussion 2 08-20-2010 07:12 AM
Ace Ranks alexjalen Suggestions 7 06-12-2010 07:08 PM
Scaling XP earned for ace ranks zwanglos Suggestions 10 03-17-2010 01:44 PM
Wtf happened to all my ace ranks!!!! flyin ace Tech Support 1 02-28-2010 10:44 AM
Ace Ranks Suggestion nesnl Suggestions 30 02-21-2010 06:19 AM


All times are GMT. The time now is 03:05 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
2008 Nimbly Games LLC