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? /forum/read.php?4,117817,117817#msg-117817 Sun, 09 Aug 2026 01:15:28 +0000 Phorum 5.2.23 /forum/read.php?4,117817,118361#msg-118361 /forum/read.php?4,117817,118361#msg-118361 bmuzzin Script development Mon, 16 Feb 2026 21:39:21 +0000 /forum/read.php?4,117817,117955#msg-117955 /forum/read.php?4,117817,117955#msg-117955
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.]]> Pleu Script development Sun, 08 Feb 2026 17:01:36 +0000 /forum/read.php?4,117817,117817#msg-117817 /forum/read.php?4,117817,117817#msg-117817 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?]]> bmuzzin Script development Fri, 06 Feb 2026 03:02:04 +0000