ccbs
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.

15 years agoMake DDR Europe parser script convert from ISO8859-1 to UTF-8. Update test SQL accord...
Steinar H. Gunderson [Mon, 14 Feb 2005 01:42:16 +0000 (01:42 +0000)]
Make DDR Europe parser script convert from ISO8859-1 to UTF-8. Update test SQL accordingly.

15 years agoAdd a "general facts" to the score screen.
Steinar H. Gunderson [Mon, 14 Feb 2005 01:34:49 +0000 (01:34 +0000)]
Add a "general facts" to the score screen.

15 years agoAdd some spacing around the score tables.
Steinar H. Gunderson [Mon, 14 Feb 2005 01:30:25 +0000 (01:30 +0000)]
Add some spacing around the score tables.

15 years agoAdd headings to the score display.
Steinar H. Gunderson [Mon, 14 Feb 2005 01:27:05 +0000 (01:27 +0000)]
Add headings to the score display.

15 years agoDisconnect the database handle cleanly on exit.
Steinar H. Gunderson [Mon, 14 Feb 2005 01:06:24 +0000 (01:06 +0000)]
Disconnect the database handle cleanly on exit.

15 years agoAdding show-tournament.pl (arch is weird)...
Steinar H. Gunderson [Mon, 14 Feb 2005 01:05:08 +0000 (01:05 +0000)]
Adding show-tournament.pl (arch is weird)...

15 years agoAdd a script for showing the tournaments.
Steinar H. Gunderson [Mon, 14 Feb 2005 01:04:45 +0000 (01:04 +0000)]
Add a script for showing the tournaments.

15 years agoOrganize tournaments by season.
Steinar H. Gunderson [Mon, 14 Feb 2005 00:10:35 +0000 (00:10 +0000)]
Organize tournaments by season.

15 years agoAdd list over tournaments.
Steinar H. Gunderson [Mon, 14 Feb 2005 00:06:27 +0000 (00:06 +0000)]
Add list over tournaments.

15 years agoChange all instances of "name" to something more sane, to get easy natural joins.
Steinar H. Gunderson [Mon, 14 Feb 2005 00:00:25 +0000 (00:00 +0000)]
Change all instances of "name" to something more sane, to get easy natural joins.

15 years agoAdd main menu.
Steinar H. Gunderson [Sun, 13 Feb 2005 23:52:10 +0000 (23:52 +0000)]
Add main menu.

15 years agoUpdate username/password.
Steinar H. Gunderson [Sun, 13 Feb 2005 23:47:18 +0000 (23:47 +0000)]
Update username/password.

15 years agoAdd error template.
Steinar H. Gunderson [Sun, 13 Feb 2005 23:45:44 +0000 (23:45 +0000)]
Add error template.

15 years agoAdd first beginnings of web control system.
Steinar H. Gunderson [Sun, 13 Feb 2005 23:45:00 +0000 (23:45 +0000)]
Add first beginnings of web control system.

15 years agoAdd html/ directory.
Steinar H. Gunderson [Sun, 13 Feb 2005 23:32:12 +0000 (23:32 +0000)]
Add html/ directory.

15 years agoUpdate the DDR Europe parser to add song ordering information. Update the CC SQL...
Steinar H. Gunderson [Sun, 13 Feb 2005 23:30:15 +0000 (23:30 +0000)]
Update the DDR Europe parser to add song ordering information. Update the CC SQL test files accordingly.

15 years agoAdd a "song number" to the score schema.
Steinar H. Gunderson [Sun, 13 Feb 2005 23:27:02 +0000 (23:27 +0000)]
Add a "song number" to the score schema.

15 years agoAdd? Hello?
Steinar H. Gunderson [Sun, 13 Feb 2005 23:19:25 +0000 (23:19 +0000)]
Add? Hello?

15 years agoErm, actually add the script. :-)
Steinar H. Gunderson [Sun, 13 Feb 2005 23:19:07 +0000 (23:19 +0000)]
Erm, actually add the script. :-)

15 years agoAdd a small utility for updating all the CC SQL files.
Steinar H. Gunderson [Sun, 13 Feb 2005 23:18:34 +0000 (23:18 +0000)]
Add a small utility for updating all the CC SQL files.

15 years agoUpdate CC test data.
Steinar H. Gunderson [Sun, 13 Feb 2005 23:17:12 +0000 (23:17 +0000)]
Update CC test data.

15 years agoFix parsing of chosen songs.
Steinar H. Gunderson [Sun, 13 Feb 2005 23:12:24 +0000 (23:12 +0000)]
Fix parsing of chosen songs.

15 years agoAdded test data (almost entire CC 2004 season).
Steinar H. Gunderson [Sun, 13 Feb 2005 19:26:41 +0000 (19:26 +0000)]
Added test data (almost entire CC 2004 season).
16:15-20:30

15 years agoAdded even more song mappings.
Steinar H. Gunderson [Sun, 13 Feb 2005 19:25:42 +0000 (19:25 +0000)]
Added even more song mappings.

15 years agoAdd more song aliases.
Steinar H. Gunderson [Sun, 13 Feb 2005 19:12:15 +0000 (19:12 +0000)]
Add more song aliases.

15 years agoFixed uniqueness contrains for seasons
Steinar H. Gunderson [Sun, 13 Feb 2005 18:55:22 +0000 (18:55 +0000)]
Fixed uniqueness contrains for seasons

15 years agoCache revision
Steinar H. Gunderson [Sun, 13 Feb 2005 18:46:11 +0000 (18:46 +0000)]
Cache revision

15 years agoAdd missing comma to roundparticipation definition.
Steinar H. Gunderson [Sun, 13 Feb 2005 18:45:41 +0000 (18:45 +0000)]
Add missing comma to roundparticipation definition.

15 years agoEvil trick to be able to put scoreparsing into a transaction block again.
Steinar H. Gunderson [Sun, 13 Feb 2005 18:44:34 +0000 (18:44 +0000)]
Evil trick to be able to put scoreparsing into a transaction block again.

15 years agoAdd position to roundparticipation (so we can order by it).
Steinar H. Gunderson [Sun, 13 Feb 2005 18:32:15 +0000 (18:32 +0000)]
Add position to roundparticipation (so we can order by it).

15 years agoSome more score parsing fixes, looks like most stuff is OK now.
Steinar H. Gunderson [Sun, 13 Feb 2005 18:27:27 +0000 (18:27 +0000)]
Some more score parsing fixes, looks like most stuff is OK now.

15 years agoAdd uniqueness constraint to tournaments as well.
Steinar H. Gunderson [Sun, 13 Feb 2005 18:16:27 +0000 (18:16 +0000)]
Add uniqueness constraint to tournaments as well.

15 years agoAdd people to roundparticipations as we go.
Steinar H. Gunderson [Sun, 13 Feb 2005 18:16:01 +0000 (18:16 +0000)]
Add people to roundparticipations as we go.

15 years agoAdd UNIQUE to the trivial tables.
Steinar H. Gunderson [Sun, 13 Feb 2005 18:11:49 +0000 (18:11 +0000)]
Add UNIQUE to the trivial tables.

15 years agoAttempt parsing scores.
Steinar H. Gunderson [Sun, 13 Feb 2005 18:11:06 +0000 (18:11 +0000)]
Attempt parsing scores.

15 years agoFix (read: hack) "number of chosen songs" parsing.
Steinar H. Gunderson [Sun, 13 Feb 2005 17:56:18 +0000 (17:56 +0000)]
Fix (read: hack) "number of chosen songs" parsing.

15 years agoImprove DDREurope parsing further
Steinar H. Gunderson [Sun, 13 Feb 2005 17:52:07 +0000 (17:52 +0000)]
Improve DDREurope parsing further
- Fix SQL escaping.
- Understand groups correctly.
- Add a lot of new alternative spellings.

15 years agoHandle better different namings/capitalizations of some songs.
Steinar H. Gunderson [Sun, 13 Feb 2005 17:36:19 +0000 (17:36 +0000)]
Handle better different namings/capitalizations of some songs.

15 years agoImprove DDR Europe parsing; we now understand groups and rounds
Steinar H. Gunderson [Sun, 13 Feb 2005 17:31:49 +0000 (17:31 +0000)]
Improve DDR Europe parsing; we now understand groups and rounds

15 years agoAdd the bigscreen/ directory (a bit overdue?)
Steinar H. Gunderson [Sun, 13 Feb 2005 17:09:14 +0000 (17:09 +0000)]
Add the bigscreen/ directory (a bit overdue?)

15 years agoAdd the beginnings of a script for converting from the DDREurope result lists.
Steinar H. Gunderson [Sun, 13 Feb 2005 17:08:57 +0000 (17:08 +0000)]
Add the beginnings of a script for converting from the DDREurope result lists.

15 years agoAdd a score system to the basic data.
Steinar H. Gunderson [Sun, 13 Feb 2005 17:06:37 +0000 (17:06 +0000)]
Add a score system to the basic data.

15 years agoAdd an SQL file with the most basic data.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:54:40 +0000 (16:54 +0000)]
Add an SQL file with the most basic data.

15 years agoMove bigscreen stuff into its own directory.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:52:34 +0000 (16:52 +0000)]
Move bigscreen stuff into its own directory.

15 years agoMove SQL files into their own directory.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:52:08 +0000 (16:52 +0000)]
Move SQL files into their own directory.

15 years agoAdd an SQL file containing the entire EM2 songlist.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:50:59 +0000 (16:50 +0000)]
Add an SQL file containing the entire EM2 songlist.

15 years agoFix max/min-bpm-parsing so minbpm isn't negative.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:50:07 +0000 (16:50 +0000)]
Fix max/min-bpm-parsing so minbpm isn't negative.

15 years agoAdd an UNIQUE constraint on song title.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:47:46 +0000 (16:47 +0000)]
Add an UNIQUE constraint on song title.

15 years agoWrap INSERTs in a transaction.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:46:23 +0000 (16:46 +0000)]
Wrap INSERTs in a transaction.

15 years agoFix SQL escaping in wiki parser.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:45:40 +0000 (16:45 +0000)]
Fix SQL escaping in wiki parser.

15 years agoAdd missing comma to SQL schema.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:44:47 +0000 (16:44 +0000)]
Add missing comma to SQL schema.

15 years agodifficulty -> difficult (spelling fix)
Steinar H. Gunderson [Sun, 13 Feb 2005 16:43:26 +0000 (16:43 +0000)]
difficulty -> difficult (spelling fix)

15 years agoAdd a script to parse the songlist from DDRNO's wiki.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:42:42 +0000 (16:42 +0000)]
Add a script to parse the songlist from DDRNO's wiki.

15 years agoAdd minbpm and maxbpm to songs in SQL.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:33:25 +0000 (16:33 +0000)]
Add minbpm and maxbpm to songs in SQL.

15 years agoAdd directory that will hold parsers for old data.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:33:00 +0000 (16:33 +0000)]
Add directory that will hold parsers for old data.

15 years agoChanges to adjust better to the old SQL schemas.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:22:07 +0000 (16:22 +0000)]
Changes to adjust better to the old SQL schemas.

15 years agoEven more SQL syntax fixes (the schemas import into psql now).
Steinar H. Gunderson [Sun, 13 Feb 2005 16:05:57 +0000 (16:05 +0000)]
Even more SQL syntax fixes (the schemas import into psql now).

15 years agoMake vim stop breaking my SQL lines.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:03:15 +0000 (16:03 +0000)]
Make vim stop breaking my SQL lines.

15 years agoSyntax fixes.
Steinar H. Gunderson [Sun, 13 Feb 2005 16:02:08 +0000 (16:02 +0000)]
Syntax fixes.

15 years agoMore (minor) adjustments to the schemas.
Steinar H. Gunderson [Sun, 13 Feb 2005 15:59:05 +0000 (15:59 +0000)]
More (minor) adjustments to the schemas.

15 years agoMore work on the SQL schema.
Steinar H. Gunderson [Sun, 13 Feb 2005 15:52:07 +0000 (15:52 +0000)]
More work on the SQL schema.

15 years agoFirst shot at writing basic SQL schemas (not finished).
Steinar H. Gunderson [Sun, 13 Feb 2005 02:57:16 +0000 (02:57 +0000)]
First shot at writing basic SQL schemas (not finished).
03:30-04:00

15 years agoInitial commit.
Steinar H. Gunderson [Sun, 13 Feb 2005 02:35:02 +0000 (02:35 +0000)]
Initial commit.
Import glwindow.{cpp,h} from the demolib, and make a simple Makefile etc.

15 years agoinitial import
Steinar H. Gunderson [Sun, 13 Feb 2005 02:30:46 +0000 (02:30 +0000)]
initial import

(automatically generated log message)