Support Call: 442
Subject leaderboard problems
Status Closed
Assigned To ADM David "Heavy" Pasiechnyk
Logged By FA Joshua Hawkins
Logged On Dec 06, 2011
Call Text Something I just noticed. Kimiao's points for SP are 0. I don't know why either. Also, I'm not sure if there's a total points breakdown with SP + MP with the DR system. it's been too long since I made it to remember.

Either way, can someone look into this before the 10th please? I tried but I'm kinda clueless.
Action History
Dec 06, 2011 Ahh figured it out. Somehow the math isn't catching. Before I edited it, there was a max of 15 points for type 1. and anything between 15 and 10000 should have all been calculated for 60%, however, if one went past 15 points, the math wouldn't render and you'd get a divided by zero effect. so I added a 16 and 60% line and it's fine.

This caused another error to show up, for some reason I couldn't add in the new lines I needed on the admin page, I needed to use PMA to do it. Which is weird. (ADM Joshua Hawkins)
Dec 08, 2011 /test/index.php line 203ish
$dr1 = cell (" percent FROM josh_dr_values WHERE type = 1 AND activities = '$sub_points1' ");

This line needs to be adjusted. I keep having to add in lines to the table so things don't display as 0. We need to figure out how to get the max points in the table and if the member has more than that, use whatever the last percentage was. I had a max od 10000 points there, but for some reason it's not working anymore. (ADM Joshua Hawkins)
Dec 09, 2011 I may be on LOA, but I do have a couple thoughts here...

The formulae should probably do a reference of total points >= the value in the table SORT decending so that it catches the highest percentage option.

Granted though, I am also of the opinion that this system is still a little broken, as our current formulae generate a reduced value of all points, as opposed to something similar to an income tax bracket system (i.e. points 1-3 are worth 100%, points 4-6 are worth 70% (i.e. 3 + 3*0.7), points 7-15 are worth 50% (i.e. 3 + 3*0.7 + 8*0.5), etc.). Our current percentage brackets and formulae have small windows of error where someone with X points and someone with Y points where X is greater than Y, the person with X actually ends up with fewer net points than person with Y after dim. returns. (ADM David "Heavy" Pasiechnyk)
Dec 19, 2011 Additional item I found borked on the Leaderboard:

Somehow the math is broken such that both Red and Renegade Squadrons have different squad totals, despite having the same number reporting and the same starting player merits/points. (ADM David "Heavy" Pasiechnyk)
Dec 19, 2011 Ok, so after taking a look at the base points prior to being marginalized, the formulas are usign the subtotal points, not the total player points. I can't remember if this was intentional, that the bonus were for player totals only and not squadron, or otherwise. (ADM David "Heavy" Pasiechnyk)
Dec 19, 2011 Well, for now I've changed the formula to take the overall player points, and I've fixed the DR values formula to not require uber large values in the josh_dr_values table (I changed the WHERE clause to look for the dr value where activities <= "player points" as opposed to = player points, however that was working before). (ADM David "Heavy" Pasiechnyk)
Dec 19, 2011 Poking around on this also gave me the idea that there should probably be a function that locks in the active squad count for a session when a new one is created to try and keep the accuracy on closed sessions. (ADM David "Heavy" Pasiechnyk)
Feb 28, 2012 This seems to be fixed I think. I'm closing this for now. If problem happens again we'll reopen )or make another and reference this) (ADM Joshua Hawkins)