Re: GetFinds, favorite_points_pct field

Take these two checkers:
https://project-gc.com/Challenges//111480
https://project-gc.com/Challenges/GC536C2/111479

In theory, they should do the same thing, with the one using favorite_points_pct directly, and the other calculating favorite_points_pct = floor(favorite_points / num_finds * 100). However, the favorite_points_pct field is considerably higher. For example, running myself on the calculated version, the first entry is:
GC735VZ - 198/352 = 56%

That similar entry using the field is:
GC735VZ 198/352 = 64.2857%

Is the favorite_points_pct field not just supposed to be favs/finds? Why is this field in the DB, since it can just easily be calculated?



Edited 2 time(s). Last edit at 02/06/2026 03:02AM by bmuzzin. (view changes)

Sounds like you've missunderstood how FP% are calculated.

FP% are number of FP divided by number of finders with premium and number of basic members that gave an FP (aka expired premium). That wouldn't be easily calculated by a script as the script lacks some of the data.

Huh, yes this is my misunderstanding... I actually didn't realize that basic users can't award FPs. Guess it makes sense, although, kind of moot since I assume FP % challenges wouldn't be allowed anymore anyhow.