ccbs
15 years agoInstall PL/PgSQL in the schema etc.
Steinar H. Gunderson [Fri, 18 Feb 2005 18:35:33 +0000 (18:35 +0000)]
Install PL/PgSQL in the schema etc.
16:00-19:30

15 years agoStarted on a bigscreen SQL schema.
Steinar H. Gunderson [Fri, 18 Feb 2005 18:20:26 +0000 (18:20 +0000)]
Started on a bigscreen SQL schema.

15 years agoSwitch SQL host from cirkus to altersex, to get PostgreSQL 7.4
Steinar H. Gunderson [Fri, 18 Feb 2005 18:04:20 +0000 (18:04 +0000)]
Switch SQL host from cirkus to altersex, to get PostgreSQL 7.4

15 years agoFix so we actually get the NOTIFY.
Steinar H. Gunderson [Fri, 18 Feb 2005 18:00:30 +0000 (18:00 +0000)]
Fix so we actually get the NOTIFY.

15 years agoTry to listen on a NOTIFY trigger.
Steinar H. Gunderson [Fri, 18 Feb 2005 17:55:57 +0000 (17:55 +0000)]
Try to listen on a NOTIFY trigger.

15 years agoReplace transaction<> with work.
Steinar H. Gunderson [Fri, 18 Feb 2005 17:40:21 +0000 (17:40 +0000)]
Replace transaction<> with work.

15 years agoFix DDRFreak parser to output some UTF-8 glyphs instead of HTML entities. Update...
Steinar H. Gunderson [Fri, 18 Feb 2005 17:25:43 +0000 (17:25 +0000)]
Fix DDRFreak parser to output some UTF-8 glyphs instead of HTML entities. Update Extreme SQL accordingly.

15 years agoFetch the title, not some random ID.
Steinar H. Gunderson [Fri, 18 Feb 2005 17:13:13 +0000 (17:13 +0000)]
Fetch the title, not some random ID.

15 years agoFetch out some numbers from a table.
Steinar H. Gunderson [Fri, 18 Feb 2005 17:04:18 +0000 (17:04 +0000)]
Fetch out some numbers from a table.

15 years agoAdd pq++ dependency, start code for just connecting.
Steinar H. Gunderson [Fri, 18 Feb 2005 16:58:10 +0000 (16:58 +0000)]
Add pq++ dependency, start code for just connecting.

15 years agoAdd -L/usr/X11R6/lib to LDFLAGS for the bigscreen Makefile.
Steinar H. Gunderson [Fri, 18 Feb 2005 16:46:25 +0000 (16:46 +0000)]
Add -L/usr/X11R6/lib to LDFLAGS for the bigscreen Makefile.

15 years agoMake the DDRFreak parser script case insensitive with regard to previous songs (most...
Steinar H. Gunderson [Fri, 18 Feb 2005 16:31:36 +0000 (16:31 +0000)]
Make the DDRFreak parser script case insensitive with regard to previous songs (most other title handling code is case-insensitive). Update SQL base data accordingly.

15 years agoAdd the Extreme song list (from DDRFreak) to the base SQL data.
Steinar H. Gunderson [Fri, 18 Feb 2005 16:27:18 +0000 (16:27 +0000)]
Add the Extreme song list (from DDRFreak) to the base SQL data.

15 years agoMake the DDRFreak parse script also add the songs to machinesongs.
Steinar H. Gunderson [Fri, 18 Feb 2005 16:26:56 +0000 (16:26 +0000)]
Make the DDRFreak parse script also add the songs to machinesongs.

15 years agoAdd a hack for "Fantasy" from DDREx
Steinar H. Gunderson [Fri, 18 Feb 2005 16:20:45 +0000 (16:20 +0000)]
Add a hack for "Fantasy" from DDREx

15 years agoOnly insert a song if it doesn't already exist.
Steinar H. Gunderson [Fri, 18 Feb 2005 16:16:57 +0000 (16:16 +0000)]
Only insert a song if it doesn't already exist.

15 years agoAdd a script for parsing DDRFreak's song lists.
Steinar H. Gunderson [Fri, 18 Feb 2005 16:11:06 +0000 (16:11 +0000)]
Add a script for parsing DDRFreak's song lists.

15 years agoAdded DDR Extreme as a machine for the basic data.
Steinar H. Gunderson [Fri, 18 Feb 2005 15:38:47 +0000 (15:38 +0000)]
Added DDR Extreme as a machine for the basic data.

15 years agoUpdated the score edit functionality to check for steps on the selected mix only.
Steinar H. Gunderson [Fri, 18 Feb 2005 15:38:06 +0000 (15:38 +0000)]
Updated the score edit functionality to check for steps on the selected mix only.

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.