ccbs
15 years agoUpdate the wiki parser and the EM2 SQL to match the new feet rating data.
Steinar H. Gunderson [Fri, 18 Feb 2005 15:33:29 +0000 (15:33 +0000)]
Update the wiki parser and the EM2 SQL to match the new feet rating data.

15 years agoAdd CC03 as a season in the test data.
Steinar H. Gunderson [Fri, 18 Feb 2005 15:28:30 +0000 (15:28 +0000)]
Add CC03 as a season in the test data.

15 years agoDifferent songs can have different ratings on different machines, so change the SQL...
Steinar H. Gunderson [Fri, 18 Feb 2005 15:27:12 +0000 (15:27 +0000)]
Different songs can have different ratings on different machines, so change the SQL schemas.

15 years agoDon't include NULL scores in the top 50 list.
Steinar H. Gunderson [Fri, 18 Feb 2005 15:11:39 +0000 (15:11 +0000)]
Don't include NULL scores in the top 50 list.

15 years agoAdded a ranking beside each player in the song highscore list.
Steinar H. Gunderson [Fri, 18 Feb 2005 13:38:07 +0000 (13:38 +0000)]
Added a ranking beside each player in the song highscore list.

15 years agoLimited the song highscore list to 50 people.
Steinar H. Gunderson [Fri, 18 Feb 2005 13:36:38 +0000 (13:36 +0000)]
Limited the song highscore list to 50 people.

15 years agoAdded a link from the song highscore list to the tournaments.
Steinar H. Gunderson [Fri, 18 Feb 2005 13:36:00 +0000 (13:36 +0000)]
Added a link from the song highscore list to the tournaments.

15 years agoAdd a backend for showing songs and the best scores on them.
Steinar H. Gunderson [Fri, 18 Feb 2005 13:35:19 +0000 (13:35 +0000)]
Add a backend for showing songs and the best scores on them.

15 years agoAdded links for all songs (no backend yet) in the tournament view.
Steinar H. Gunderson [Fri, 18 Feb 2005 13:27:39 +0000 (13:27 +0000)]
Added links for all songs (no backend yet) in the tournament view.

15 years agoAdd the "add tournament" link to the tournaments page.
Steinar H. Gunderson [Thu, 17 Feb 2005 19:43:48 +0000 (19:43 +0000)]
Add the "add tournament" link to the tournaments page.
19:45-20:45

15 years agoAdd a navigational menu at the top.
Steinar H. Gunderson [Thu, 17 Feb 2005 19:40:05 +0000 (19:40 +0000)]
Add a navigational menu at the top.

15 years agoAutomatically zoom to the new player when adding a new one.
Steinar H. Gunderson [Thu, 17 Feb 2005 19:36:51 +0000 (19:36 +0000)]
Automatically zoom to the new player when adding a new one.

15 years agoAdd backend for adding players.
Steinar H. Gunderson [Thu, 17 Feb 2005 19:35:02 +0000 (19:35 +0000)]
Add backend for adding players.

15 years agoAdd form (no backend yet) for registering new players.
Steinar H. Gunderson [Thu, 17 Feb 2005 19:31:34 +0000 (19:31 +0000)]
Add form (no backend yet) for registering new players.

15 years agoAdd backend for resetting the song chooser.
Steinar H. Gunderson [Thu, 17 Feb 2005 19:25:13 +0000 (19:25 +0000)]
Add backend for resetting the song chooser.

15 years agoAdd front end for resetting the song chooser.
Steinar H. Gunderson [Thu, 17 Feb 2005 19:20:31 +0000 (19:20 +0000)]
Add front end for resetting the song chooser.

15 years agoChanged front page text.
Steinar H. Gunderson [Thu, 17 Feb 2005 19:16:09 +0000 (19:16 +0000)]
Changed front page text.

15 years agoAdd backend code for ranking people.
Steinar H. Gunderson [Thu, 17 Feb 2005 19:12:00 +0000 (19:12 +0000)]
Add backend code for ranking people.

15 years agoAdded template code for showing rank.
Steinar H. Gunderson [Thu, 17 Feb 2005 18:54:47 +0000 (18:54 +0000)]
Added template code for showing rank.

15 years agoFix showing of newly created rounds again.
Steinar H. Gunderson [Thu, 17 Feb 2005 18:49:16 +0000 (18:49 +0000)]
Fix showing of newly created rounds again.

15 years agoChange to text/html (for IE demonstration)
Steinar H. Gunderson [Wed, 16 Feb 2005 21:29:57 +0000 (21:29 +0000)]
Change to text/html (for IE demonstration)

15 years agoCache revision
Steinar H. Gunderson [Wed, 16 Feb 2005 20:38:03 +0000 (20:38 +0000)]
Cache revision
19:45-21:45

15 years agoImplement the rest of the ranking.
Steinar H. Gunderson [Wed, 16 Feb 2005 20:22:26 +0000 (20:22 +0000)]
Implement the rest of the ranking.

15 years agoActually add the backend for ranking (forgot tla add last time :-) ).
Steinar H. Gunderson [Wed, 16 Feb 2005 20:11:46 +0000 (20:11 +0000)]
Actually add the backend for ranking (forgot tla add last time :-) ).

15 years agoImplement the first (trivial) parts of the ranking system.
Steinar H. Gunderson [Wed, 16 Feb 2005 20:11:12 +0000 (20:11 +0000)]
Implement the first (trivial) parts of the ranking system.

15 years agoAdd FIXME comment about empty last group.
Steinar H. Gunderson [Wed, 16 Feb 2005 19:19:11 +0000 (19:19 +0000)]
Add FIXME comment about empty last group.

15 years agoAdded a "finish tournament" button that is shown if one can finish the tournament.
Steinar H. Gunderson [Wed, 16 Feb 2005 19:15:26 +0000 (19:15 +0000)]
Added a "finish tournament" button that is shown if one can finish the tournament.

15 years agoCheck that there are steps for the selected song/playmode/difficulty combination...
Steinar H. Gunderson [Wed, 16 Feb 2005 18:55:02 +0000 (18:55 +0000)]
Check that there are steps for the selected song/playmode/difficulty combination, instead of giving an SQL error.

15 years agoCheck for scores out of range, instead of giving SQL errors.
Steinar H. Gunderson [Wed, 16 Feb 2005 18:44:23 +0000 (18:44 +0000)]
Check for scores out of range, instead of giving SQL errors.

15 years agoCache revision.
Steinar H. Gunderson [Wed, 16 Feb 2005 15:34:44 +0000 (15:34 +0000)]
Cache revision.
14:45-16:45

15 years agoDon't show the "start next round" form until we can actually do so.
Steinar H. Gunderson [Wed, 16 Feb 2005 15:32:17 +0000 (15:32 +0000)]
Don't show the "start next round" form until we can actually do so.

15 years agoRemove the extra header for locked rounds.
Steinar H. Gunderson [Wed, 16 Feb 2005 15:24:12 +0000 (15:24 +0000)]
Remove the extra header for locked rounds.

15 years agoFix bug where showing of an empty tournament would crash.
Steinar H. Gunderson [Wed, 16 Feb 2005 15:16:32 +0000 (15:16 +0000)]
Fix bug where showing of an empty tournament would crash.

15 years agoMake system for making groups after the very first round.
Steinar H. Gunderson [Wed, 16 Feb 2005 15:15:59 +0000 (15:15 +0000)]
Make system for making groups after the very first round.

15 years agoRemove/hide some borders between the score/playmode/difficulty settings.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:53:10 +0000 (14:53 +0000)]
Remove/hide some borders between the score/playmode/difficulty settings.

15 years agoRemoved name= on the submit buttons again, we don't need it anymore.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:48:32 +0000 (14:48 +0000)]
Removed name= on the submit buttons again, we don't need it anymore.

15 years agoChange locking semantics -- now everything in the last round can be edited, and nothi...
Steinar H. Gunderson [Wed, 16 Feb 2005 14:47:25 +0000 (14:47 +0000)]
Change locking semantics -- now everything in the last round can be edited, and nothing else.

15 years agoChosen song can now be set.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:44:41 +0000 (14:44 +0000)]
Chosen song can now be set.

15 years agoHandle <> etc. in __DIE__ handler messages.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:40:52 +0000 (14:40 +0000)]
Handle <> etc. in __DIE__ handler messages.

15 years agoFiddled around with the table layout.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:39:55 +0000 (14:39 +0000)]
Fiddled around with the table layout.

15 years agoAdd edit of playmode and difficulty.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:37:40 +0000 (14:37 +0000)]
Add edit of playmode and difficulty.

15 years agoMake it possible to enter NULL values by leaving fields blank.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:35:20 +0000 (14:35 +0000)]
Make it possible to enter NULL values by leaving fields blank.

15 years agoMake it possible to edit scores.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:33:30 +0000 (14:33 +0000)]
Make it possible to edit scores.

15 years agoAdd old- versions of all data in the form; we can't really detect what button was...
Steinar H. Gunderson [Wed, 16 Feb 2005 14:21:05 +0000 (14:21 +0000)]
Add old- versions of all data in the form; we can't really detect what button was clicked anyhow. :-/

15 years agoThe "edit scores" backend now finds out which update button was pressed.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:10:57 +0000 (14:10 +0000)]
The "edit scores" backend now finds out which update button was pressed.

15 years agoAdd tournament/round hidden inputs for all cases :-)
Steinar H. Gunderson [Wed, 16 Feb 2005 14:08:03 +0000 (14:08 +0000)]
Add tournament/round hidden inputs for all cases :-)

15 years agoMoved the hidden tournament/round inputs into a place where they actually make sense.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:06:47 +0000 (14:06 +0000)]
Moved the hidden tournament/round inputs into a place where they actually make sense.

15 years agoAdd a (dummy) do-edit-scores.pl backend. (Nevermind, it crept into the previous commi...
Steinar H. Gunderson [Wed, 16 Feb 2005 14:04:55 +0000 (14:04 +0000)]
Add a (dummy) do-edit-scores.pl backend. (Nevermind, it crept into the previous commit anyhow...)

15 years agoAdd hidden tournament and round form elements.
Steinar H. Gunderson [Wed, 16 Feb 2005 14:01:34 +0000 (14:01 +0000)]
Add hidden tournament and round form elements.

15 years agoAdd name= to the submit buttons, and some information fixes.
Steinar H. Gunderson [Wed, 16 Feb 2005 13:58:19 +0000 (13:58 +0000)]
Add name= to the submit buttons, and some information fixes.

15 years agoChange nowrap="nowrap" to CSS.
Steinar H. Gunderson [Wed, 16 Feb 2005 13:52:43 +0000 (13:52 +0000)]
Change nowrap="nowrap" to CSS.

15 years agoDistinguish the name= on the form elements.
Steinar H. Gunderson [Wed, 16 Feb 2005 13:49:00 +0000 (13:49 +0000)]
Distinguish the name= on the form elements.

15 years agoAdd a <form> around the scores table.
Steinar H. Gunderson [Wed, 16 Feb 2005 13:46:26 +0000 (13:46 +0000)]
Add a <form> around the scores table.

15 years agoCache revision.
Steinar H. Gunderson [Mon, 14 Feb 2005 23:48:04 +0000 (23:48 +0000)]
Cache revision.
19:00-00:00

15 years agoAdded showing/selection of playmode and difficulty.
Steinar H. Gunderson [Mon, 14 Feb 2005 23:44:44 +0000 (23:44 +0000)]
Added showing/selection of playmode and difficulty.

15 years agoIndented the show-tournament template.
Steinar H. Gunderson [Mon, 14 Feb 2005 23:34:29 +0000 (23:34 +0000)]
Indented the show-tournament template.

15 years agoAdd preliminary edit boxes (no backend) for columns missing data.
Steinar H. Gunderson [Mon, 14 Feb 2005 23:17:03 +0000 (23:17 +0000)]
Add preliminary edit boxes (no backend) for columns missing data.

15 years agoSwitch to XHTML MIME type for now, fix a validation error or two.
Steinar H. Gunderson [Mon, 14 Feb 2005 22:31:54 +0000 (22:31 +0000)]
Switch to XHTML MIME type for now, fix a validation error or two.

15 years agoSplit chosen songs into two table cells.
Steinar H. Gunderson [Mon, 14 Feb 2005 22:15:04 +0000 (22:15 +0000)]
Split chosen songs into two table cells.

15 years agoAdd state to the random song chooser, so it doesn't choose the same songs twice....
Steinar H. Gunderson [Mon, 14 Feb 2005 22:05:06 +0000 (22:05 +0000)]
Add state to the random song chooser, so it doesn't choose the same songs twice. Only choose songs from the mix used in this tournament.

15 years agoAdded a machinesongs table, and a small snippet to insert all songs as EM2 machine...
Steinar H. Gunderson [Mon, 14 Feb 2005 21:56:28 +0000 (21:56 +0000)]
Added a machinesongs table, and a small snippet to insert all songs as EM2 machine songs.

15 years agoFix more stuff related to making new groups.
Steinar H. Gunderson [Mon, 14 Feb 2005 21:46:25 +0000 (21:46 +0000)]
Fix more stuff related to making new groups.

15 years agoRemoved NOT NULL from score in the SQL schema.
Steinar H. Gunderson [Mon, 14 Feb 2005 21:20:19 +0000 (21:20 +0000)]
Removed NOT NULL from score in the SQL schema.

15 years agoCache revision.
Steinar H. Gunderson [Mon, 14 Feb 2005 20:39:17 +0000 (20:39 +0000)]
Cache revision.

15 years agoCorrect number of qualified people from round >= 1.
Steinar H. Gunderson [Mon, 14 Feb 2005 20:38:03 +0000 (20:38 +0000)]
Correct number of qualified people from round >= 1.

15 years agoDo LEFT JOINs to get out info for unfinished groups.
Steinar H. Gunderson [Mon, 14 Feb 2005 20:35:22 +0000 (20:35 +0000)]
Do LEFT JOINs to get out info for unfinished groups.

15 years agoAdd people into groups.
Steinar H. Gunderson [Mon, 14 Feb 2005 20:25:35 +0000 (20:25 +0000)]
Add people into groups.

15 years agoAdded preliminary backend for creating rounds and groups.
Steinar H. Gunderson [Mon, 14 Feb 2005 19:44:08 +0000 (19:44 +0000)]
Added preliminary backend for creating rounds and groups.

15 years agoHide rankinglist if there is none. Count the number of qualified for next round.
Steinar H. Gunderson [Mon, 14 Feb 2005 19:32:16 +0000 (19:32 +0000)]
Hide rankinglist if there is none. Count the number of qualified for next round.

15 years agoAdded a "number of people qualifying for each round" attribute to the SQL schema.
Steinar H. Gunderson [Mon, 14 Feb 2005 19:15:37 +0000 (19:15 +0000)]
Added a "number of people qualifying for each round" attribute to the SQL schema.

15 years agoMisc. changes -- some formatting and add a preliminary "start new round" form.
Steinar H. Gunderson [Mon, 14 Feb 2005 19:10:27 +0000 (19:10 +0000)]
Misc. changes -- some formatting and add a preliminary "start new round" form.

15 years agoReverted separate start forms -- we'll generalize it instead.
Steinar H. Gunderson [Mon, 14 Feb 2005 18:55:29 +0000 (18:55 +0000)]
Reverted separate start forms -- we'll generalize it instead.

15 years agoAdded a function for starting a tournament (no backend yet).
Steinar H. Gunderson [Mon, 14 Feb 2005 18:44:40 +0000 (18:44 +0000)]
Added a function for starting a tournament (no backend yet).

15 years agoAdded a link to "start tournament" in the tournament listing.
Steinar H. Gunderson [Mon, 14 Feb 2005 18:28:18 +0000 (18:28 +0000)]
Added a link to "start tournament" in the tournament listing.

15 years agoAdd an option for un-registering people.
Steinar H. Gunderson [Mon, 14 Feb 2005 18:22:30 +0000 (18:22 +0000)]
Add an option for un-registering people.

15 years agoAdded backend for setting paid/not paid.
Steinar H. Gunderson [Mon, 14 Feb 2005 18:16:42 +0000 (18:16 +0000)]
Added backend for setting paid/not paid.

15 years agoRegistration stuff now validates.
Steinar H. Gunderson [Mon, 14 Feb 2005 18:12:58 +0000 (18:12 +0000)]
Registration stuff now validates.

15 years agoFix some validation errors, more remain.
Steinar H. Gunderson [Mon, 14 Feb 2005 15:49:59 +0000 (15:49 +0000)]
Fix some validation errors, more remain.
15:15-16:45

15 years agoAdd buttons for setting paid/not paid (not validating, no backend).
Steinar H. Gunderson [Mon, 14 Feb 2005 15:43:33 +0000 (15:43 +0000)]
Add buttons for setting paid/not paid (not validating, no backend).

15 years agoPrint out who have paid and who have not (in red).
Steinar H. Gunderson [Mon, 14 Feb 2005 15:33:37 +0000 (15:33 +0000)]
Print out who have paid and who have not (in red).

15 years agoSort list of registered people.
Steinar H. Gunderson [Mon, 14 Feb 2005 15:30:15 +0000 (15:30 +0000)]
Sort list of registered people.

15 years agoFix so registration works.
Steinar H. Gunderson [Mon, 14 Feb 2005 15:29:10 +0000 (15:29 +0000)]
Fix so registration works.

15 years agoAdded a backend (not working yet) for registering people.
Steinar H. Gunderson [Mon, 14 Feb 2005 15:27:42 +0000 (15:27 +0000)]
Added a backend (not working yet) for registering people.

15 years agoFix <option> values for registration form.
Steinar H. Gunderson [Mon, 14 Feb 2005 15:21:31 +0000 (15:21 +0000)]
Fix <option> values for registration form.

15 years agoMoved the list of registered people to the bottom (having the registration on the...
Steinar H. Gunderson [Mon, 14 Feb 2005 15:18:25 +0000 (15:18 +0000)]
Moved the list of registered people to the bottom (having the registration on the top is more useful in the long run).

15 years agoSort case-insensitively.
Steinar H. Gunderson [Mon, 14 Feb 2005 15:17:16 +0000 (15:17 +0000)]
Sort case-insensitively.

15 years agoAdd a box for adding people.
Steinar H. Gunderson [Mon, 14 Feb 2005 15:16:16 +0000 (15:16 +0000)]
Add a box for adding people.

15 years agoAdded a minimal list over people registered at a tournament.
Steinar H. Gunderson [Mon, 14 Feb 2005 15:04:00 +0000 (15:04 +0000)]
Added a minimal list over people registered at a tournament.

15 years agoRemoved the link to registration, added a link for it under "tournaments" instead.
Steinar H. Gunderson [Mon, 14 Feb 2005 14:52:11 +0000 (14:52 +0000)]
Removed the link to registration, added a link for it under "tournaments" instead.

15 years agoAdd a new table to the SQL for tournament participation.
Steinar H. Gunderson [Mon, 14 Feb 2005 14:46:00 +0000 (14:46 +0000)]
Add a new table to the SQL for tournament participation.

15 years agoAdded a link to a (soon-to-come) tournament registration system.
Steinar H. Gunderson [Mon, 14 Feb 2005 14:43:11 +0000 (14:43 +0000)]
Added a link to a (soon-to-come) tournament registration system.

15 years agoMinor language fix.
Steinar H. Gunderson [Mon, 14 Feb 2005 14:36:35 +0000 (14:36 +0000)]
Minor language fix.

15 years agoAdd a template and functions for signalling user errors (as opposed to internal errors).
Steinar H. Gunderson [Mon, 14 Feb 2005 14:36:07 +0000 (14:36 +0000)]
Add a template and functions for signalling user errors (as opposed to internal errors).

15 years agoAdd backend code for adding tournaments.
Steinar H. Gunderson [Mon, 14 Feb 2005 14:32:42 +0000 (14:32 +0000)]
Add backend code for adding tournaments.

15 years agoAdd a "total score" for each player the score screen.
Steinar H. Gunderson [Mon, 14 Feb 2005 14:13:47 +0000 (14:13 +0000)]
Add a "total score" for each player the score screen.

15 years agoShow ranking list on the web interface.
Steinar H. Gunderson [Mon, 14 Feb 2005 02:37:43 +0000 (02:37 +0000)]
Show ranking list on the web interface.
00:00-03:30

15 years agoMake sure players are created before adding them to the rankings. Update test SQL.
Steinar H. Gunderson [Mon, 14 Feb 2005 02:24:53 +0000 (02:24 +0000)]
Make sure players are created before adding them to the rankings. Update test SQL.

15 years agoUpdate the parser scripts to handle tournament rankings, and fix a typo in the SQL...
Steinar H. Gunderson [Mon, 14 Feb 2005 02:18:26 +0000 (02:18 +0000)]
Update the parser scripts to handle tournament rankings, and fix a typo in the SQL for it. Update CC04 test SQL.

15 years agoAdd a table for tournament ranking to the SQL schema.
Steinar H. Gunderson [Mon, 14 Feb 2005 02:01:32 +0000 (02:01 +0000)]
Add a table for tournament ranking to the SQL schema.

15 years agoAdded a form (no logic yet) for adding tournaments.
Steinar H. Gunderson [Mon, 14 Feb 2005 01:56:35 +0000 (01:56 +0000)]
Added a form (no logic yet) for adding tournaments.