Split `ia_score`
Review Request #64 - Created Feb. 27, 2009 and submitted - Latest diff uploaded
Information | |
---|---|
Savin Tiberiu | |
infoarena | |
Reviewers | |
hackers | |
All records from `ia_score` go to `ia_rating` and `ia_score_user_round_task` as following: * name = deviation or name = deviation -> ia rating * name = score -> ia_score_user_round_task * name = submit_count -> unnecesary record, dumped. All score queries have been updated. Rankings macro can now show extra columns with scores for each task and each round. Warning: Eval needs to be restarted
I took a larger db from bogdan and did the following tests: 1. algoritmiada round1, round2, round3 rankings with round details -> looks great :) 2. algoritmiada round1, round2, round3 rankings with round and task details -> looks kinda crappy, too many columns 3. recomputed ratings -> absolutely no problem 4. A more complex round test: * created round "test_round" * domino, bogdan2412 and devilkind registered * tasks : adunare, cmmdc, fractii (I added graders) * domino, bogdan2412, devilkind and mariusdrg (unregistered user) submited * scores update OK * rankings at the end were ok with task details * ratings were update without problems for registered users 5. All tests from /tests (round.php, task.php etc) passed.