wectf_scoring.sql

-- Following CCC's algorithm
-- @base + ( @top - @base ) / (1 + (max(0, solves -1)/ 11.92201) ** 1.206069)

CREATE EVENT IF NOT EXISTS `calc_challenges_new_score`
ON SCHEDULE
  EVERY 3 SECOND
  COMMENT 'Calculate points for challenges'
  DO
  UPDATE challenges AS c SET c.`point` = CONVERT(c.base_point + (c.top_point - c.base_point) / (1 + POW(GREATEST(c.solved_count - 1, 0) / 11.92201, 1.206069)), UNSIGNED);
  
CREATE EVENT IF NOT EXISTS `calc_challenges_new_score_for_all_submissions`
ON SCHEDULE
  EVERY 3 SECOND
  COMMENT 'Update points for each submission'
  DO
  UPDATE submissions AS s INNER JOIN challenges AS c ON s.challenge_id = c.id SET s.`point` = c.`point`;