Ruby on Rails sqlite3 ranking

Rails
1

I am making a browser-based game using ruby on rails and I am having
trouble implementing a ranking system for my game. Each player has
five skills: intelligence, creativity, strength, charisma and
technological. I want the player to have a rank for each skill. The
ranking I have in place right now gives the same rank if two players
have the same amount of skill.

SELECT COUNT(*) AS [rank] FROM players "+
"WHERE intelligence >= "+
"(SELECT intelligence FROM players WHERE id = #{@player.id})

I want each player to have a different rank even if they have the same
amount of skill as another player but I can’t seem to figure out how
to implement that. I have an intelligence column and an irank column,
the same for the rest of the skills, and I was thinking that I could
first sort the intelligence column and then according to that sorting
assign a number to the irank column from 1 and so on but I can’t
figure out how to exactly implement this. I was thinking maybe a for
loop or a .each do loop but I hit a roadblock. I know I can do
Player.all(:order => ‘intelligence DESC’) to sort it but after that
I’m stumped.

I would appreciate any hints or help that anyone could provide me if
willing. Thanks.

2

what if:
ranked_players = Array.new
Player.all(:order => ‘intelligence’).each_with_index do |player|
ranked_players << “#{index + 1}. #{player[:name]} with
#{player[:intelligence]} intelligence”
end

#now you have ranked players list
ranked_players.each do |player|
puts player
end

3

Correction:
ranked_players = Array.new
Player.all(:order => ‘intelligence’).each_with_index do |player, index|
ranked_players << “#{index + 1}. #{player[:name]} with
#{player[:intelligence]} intelligence”
end

#now you have ranked players list
ranked_players.each do |player|
puts player
end

4

I’m sorry. Of course |player, index| it’s my misprint

5

Thanks you guys for the responses. I greatly appreciate it. I am going
to implement this into my website and see how it works. thanks. : )

6

hey, so I put the code in my website and this is what it outputted for
me. I used ranked_players[0] and so on to get the output.

  1. nascargurly with 30 intelligence 1. nascargurly48 with 30
    creativity 1. nascargurly48 with 10 strength 1. nascargurly48 with 10
    charisma 1. nascargurly48 with 30 technological
    2 2. nascargurly48 with 90 intelligence 2. nascargurly with 30
    creativity 2. nascargurly with 10 strength 2. nascargurly with 10
    charisma 2. nascargurly with 90 technological
7

It shows nascargurly with 30 intelligence higher than nascargurly48
with 90 intelligence when it should be the other way around. Its like
its ordering by the way things are added to array then by the order of
intelligence. I added nascargurly to the website after nascargurly48.
the command prompt says its ordering by intelligence but the array
doesnt show it. Any ideas?