Fastor wrote:+1Tenebro wrote:Suggestion: can you make ladder show only the quests you've done on your faction instead of both since there is not way to reach first 2 positions in ladder without faction changing
You could run the computation weekly (i.e. Wednesday 3 am) as it shouldn't be done too often as it might take up server load:Etro wrote:
- 1. Retrieve top 300 players (so that we hopefully get 100 players from each side).
2. For every player retrieved do the following: increment a counter by 1 for every quest rewarded that is doable by their current faction.
3. Sort the players according to the newly found values. Remove unnecessary players as we only need 100 per faction.
2. Quest_Template (AllowableRaces) can be used to retrieve all quest doable by given faction and some other table contains quests rewarded for an individual player. Use the tables together and you can compute a more fair count.
3. Sorting is sorting.
The challenge lies in point 2 obviously, but once this is done you can pretty much do the same for other ladders (mount, companion, professions) etc.