Advanced

Change History

Discuss your script development with others (bugs, optimizations, methods ...)

Message: GetFinds, favorite_points_pct field

Changed By: bmuzzin
Change Date: February 06, 2026 03:02AM

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?
Changed By: bmuzzin
Change Date: February 06, 2026 03:02AM

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 = favorite_points / num_finds. floor(favorite_points / num_finds). 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?

Original Message

Author: bmuzzin
Date: February 06, 2026 03:02AM

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 = favorite_points / num_finds. 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?