Rank Table
ID, Primary Key
RANK, The rank or level, 1 being the highest and 3 the lowest
MIN_SCORE, The minimum amount of point or XP needed to reach the rank
NAME, The associated name of the rank
Rank Table
+----+------+-----------+-------------------------+
| ID | RANK | MIN_SCORE | NAME |
+----+------+-----------+-------------------------+
| 1 | 1 | 18932 | Editor-in-Chief |
| 2 | 2 | 15146 | Senior Technical Writer |
| 3 | 3 | 12116 | Senior Copywriter |
+----+------+-----------+-------------------------+
Ranking Table
ID, Primary Key
FK_MEMEBER_ID, Foreign Key to member's Primary Key
FK_RANK, Foreign Key to Author Rank Table's Rank column (top)
SCORE, The member's current earned score or XP
Ranking Table
+-----+--------------+---------+-------+
| ID | FK_MEMBER_ID | FK_RANK | SCORE |
+-----+--------------+---------+-------+
| 1 | 1 | 1 | 17722 |
| 2 | 2 | 2 | 16257 |
| 3 | 3 | 3 | 12234 |
+-----+--------------+---------+-------+
In my class I have stored the ranks -- matching those in the Rank Table -- and correlating minimum scores; RANK as key and MINIMUM_SCORE as value.
When a member's score (XP) is updated (up/down) I want to test that updated score against the below array to determine if their rank needs updating too.
private $scores = array('3' => '12116', '2' => '15146', '1' => '18932',);
Using the updated score, how could I determine the correlating rank from the above array?
Everything is open to scrutiny, this is my first time creating a ranking system so I hope to get it right :)
