Hello, I'm trying to show the player's classification, I found an example but he doesn't count the position if the amount is equal, for example:
Player 1: 600Exp
Player 2: 400 Exp
Player 3: 400 Exp
Player 4: 300 Exp
The way I found the position of player 2 and 3 is the same as:
Player 1: Top 1
Player 2: Top 2
Player 3: Top 2
Player 4: Top 3
I would like it to look like this:
Player 1: Top 1
Player 2: Top 2
Player 3: Top 3
Player 4: Top 4
Here is an example I found below:
dispbottom "============== My Rank ==============", 0xffe066;
query_sql( "SELECT `points`, 1 + (SELECT COUNT(1) FROM `mvp_ranking` t1 WHERE t1.`points` > t2.`points`) FROM `mvp_ranking` t2 WHERE `char_id` = "+ getcharid(0), .@points, .@rank);
dispbottom "My Rank is: " + .@rank+ ".", 0x6666ff;
dispbottom "My Points is: " + .@points+ ".", 0x6666ff;
dispbottom "==========================================", 0xffe066;