]>
git.sesse.net Git - ccbs/log
Steinar H. Gunderson [Sun, 12 Jun 2005 20:25:18 +0000 (20:25 +0000)]
Change initial seeding from alphabetical to random.
Steinar H. Gunderson [Sun, 12 Jun 2005 00:46:36 +0000 (00:46 +0000)]
Replace the web frontend's rank calculations with the stored procedures.
Steinar H. Gunderson [Sun, 12 Jun 2005 00:31:46 +0000 (00:31 +0000)]
Added a stored procedure for finding the min/max rank for an entire tournament.
Steinar H. Gunderson [Sun, 12 Jun 2005 00:25:07 +0000 (00:25 +0000)]
Added a "parallel" argument to the min/max stored procedures.
Steinar H. Gunderson [Sun, 12 Jun 2005 00:10:55 +0000 (00:10 +0000)]
Make the rank function work more than once. :-)
Steinar H. Gunderson [Sat, 11 Jun 2005 23:40:15 +0000 (23:40 +0000)]
Make a stored procedure implementation of finding min/max rank.
Steinar H. Gunderson [Sat, 11 Jun 2005 23:18:45 +0000 (23:18 +0000)]
Make a (somewhat inefficient?) stored procedure implementation of finding min and max score for players.
Steinar H. Gunderson [Sat, 11 Jun 2005 22:55:39 +0000 (22:55 +0000)]
Fixed a syntax error in the calling of a stored procedure.
Steinar H. Gunderson [Sat, 11 Jun 2005 22:54:56 +0000 (22:54 +0000)]
Moved FetchMaxScoreForPlayers into a stored procedure.
Steinar H. Gunderson [Sat, 11 Jun 2005 22:40:33 +0000 (22:40 +0000)]
Move FetchMaxScoreForSongs into a stored procedure.
Steinar H. Gunderson [Sun, 24 Apr 2005 22:40:32 +0000 (22:40 +0000)]
Fix bug where chosen scores would be blanked when multiple people were editing the same group.
Steinar H. Gunderson [Sun, 24 Apr 2005 22:09:01 +0000 (22:09 +0000)]
Added a (quite crude) link from the song list to the feetratings. Update TODO.
Steinar H. Gunderson [Sun, 24 Apr 2005 21:57:02 +0000 (21:57 +0000)]
Pull from --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-37
Add a script for exporting the song list of a machine to a simple SQL-ish text format.
Steinar H. Gunderson [Sun, 24 Apr 2005 20:15:15 +0000 (20:15 +0000)]
Combined patch (sorry): fix URL, fix points awarded.
Steinar H. Gunderson [Sat, 23 Apr 2005 16:28:41 +0000 (16:28 +0000)]
Fix so groups larger than nine are properly centered around the next player.
Steinar H. Gunderson [Sat, 23 Apr 2005 17:41:08 +0000 (17:41 +0000)]
Various changes and fixes for CC1.
Steinar H. Gunderson [Sat, 23 Apr 2005 14:50:21 +0000 (14:50 +0000)]
Pull in player editing code from --baby.
Patches applied:
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-14
Make a link from the "players registered in this tournament" list to the player pages.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-15
Add backend for editing players. Update TODO.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-16
Actually commit backend for editing players.
Steinar H. Gunderson [Sat, 23 Apr 2005 01:42:57 +0000 (01:42 +0000)]
Do "NOTIFY scores" when updating short titles.
Steinar H. Gunderson [Sat, 23 Apr 2005 01:41:05 +0000 (01:41 +0000)]
Add backend for updating short titles.
Steinar H. Gunderson [Sat, 23 Apr 2005 01:35:31 +0000 (01:35 +0000)]
Add a simple web interface for adding/updating short titles. (No backend yet.)
Steinar H. Gunderson [Sat, 23 Apr 2005 01:34:32 +0000 (01:34 +0000)]
Add a simple web interface for adding/updating short titles. (No backend yet.)
Steinar H. Gunderson [Sat, 23 Apr 2005 00:54:57 +0000 (00:54 +0000)]
Hardcode single-only songs for now.
Steinar H. Gunderson [Sat, 23 Apr 2005 00:48:17 +0000 (00:48 +0000)]
Pull in changes from --baby.
Patches applied:
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-2
UTF-8 fix.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-3
Change the final ranking list generation to the new rules.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-4
Seed people from round N to round N+1 based on the new system.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-5
Divide by the max possible songrating for single mode, not the max possible songrating for whatever the player chose to play.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-6
Don't pick challenge-only songs.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-7
Make sure the best players get last in their groups.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-8
Remove some debugging statements.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-9
Add TODO.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-10
Reduce resolution for laptop (local commit).
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-11
Add support for sub-pixel rendering for LCD screens.
* sgunderson@bigfoot.com--2005-baby/ccbs--baby--0.1--patch-12
Update TODO
Steinar H. Gunderson [Thu, 7 Apr 2005 14:38:47 +0000 (14:38 +0000)]
Various songratings.pl fixes from --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-29
Fix a bug where challenge would never be shown.
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-30
Order the song ratings list by title, not internal song number.
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-31
Show artist names in the song ratings.
Steinar H. Gunderson [Thu, 7 Apr 2005 14:28:06 +0000 (14:28 +0000)]
Add a (hidden) script for showing song ratings.
Steinar H. Gunderson [Tue, 5 Apr 2005 01:45:40 +0000 (01:45 +0000)]
Sync with --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-27
For the totals of players and songs, only count scores with scoringsystem = MS 10K score.
Steinar H. Gunderson [Tue, 5 Apr 2005 01:22:55 +0000 (01:22 +0000)]
Registration now supports countries and clubs.
Steinar H. Gunderson [Mon, 4 Apr 2005 16:04:06 +0000 (16:04 +0000)]
Pull patch into the right branch.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-22
More Norwegifying.
Steinar H. Gunderson [Mon, 4 Apr 2005 16:02:10 +0000 (16:02 +0000)]
Norwegian versions of new templates from --pgweb.
Steinar H. Gunderson [Mon, 4 Apr 2005 16:00:29 +0000 (16:00 +0000)]
Sync from --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-21
Add a listing of all songs.
Steinar H. Gunderson [Mon, 4 Apr 2005 14:09:32 +0000 (14:09 +0000)]
Sync with --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-20
Add a script for showing all players.
Steinar H. Gunderson [Mon, 4 Apr 2005 13:37:23 +0000 (13:37 +0000)]
Sync from --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-17
Add a script for exporting tournaments from the database.
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-18
Add example SQL for PG EC2.
Steinar H. Gunderson [Mon, 4 Apr 2005 12:31:34 +0000 (12:31 +0000)]
Sync from --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-16
Update a few nationalities.
Steinar H. Gunderson [Mon, 4 Apr 2005 03:03:04 +0000 (03:03 +0000)]
Sync with --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-13
Work around impressingly broken Perl interpreters by setting LC_ALL=C.
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-14
Join in tournaments on the right field, again.
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-15
Minor fix to the DDR Europe parser.
Steinar H. Gunderson [Mon, 4 Apr 2005 02:43:09 +0000 (02:43 +0000)]
Sync from --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-12
Lots of EX-fixes to the DDR Europe scoring script, updated SQL as well. More to come.
Steinar H. Gunderson [Mon, 4 Apr 2005 02:15:59 +0000 (02:15 +0000)]
Fix patch-381 (some bad changes snuck in).
Steinar H. Gunderson [Mon, 4 Apr 2005 02:14:58 +0000 (02:14 +0000)]
Players may now split places in tournament rankings.
Steinar H. Gunderson [Mon, 4 Apr 2005 02:00:39 +0000 (02:00 +0000)]
Merge in class fixes from --pgweb.
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-8
Set correct class on song high score table.
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-9
Correct CSS class for player high score table.
Steinar H. Gunderson [Mon, 4 Apr 2005 01:48:43 +0000 (01:48 +0000)]
Revert change to wrong branch.
Steinar H. Gunderson [Mon, 4 Apr 2005 01:46:44 +0000 (01:46 +0000)]
Specify join, so that we don't join tournament+score on country. :-)
Steinar H. Gunderson [Mon, 4 Apr 2005 01:42:27 +0000 (01:42 +0000)]
Set the title on a player's page to the nick.
Steinar H. Gunderson [Mon, 4 Apr 2005 01:41:17 +0000 (01:41 +0000)]
Link from the player's "all songs" list to the songs.
Steinar H. Gunderson [Mon, 4 Apr 2005 01:38:11 +0000 (01:38 +0000)]
Move a H2 out of a DIV.
Steinar H. Gunderson [Mon, 4 Apr 2005 01:37:40 +0000 (01:37 +0000)]
Link to the player page from the scores.
Steinar H. Gunderson [Mon, 4 Apr 2005 01:34:46 +0000 (01:34 +0000)]
Add a "show player" page.
Steinar H. Gunderson [Mon, 4 Apr 2005 00:31:01 +0000 (00:31 +0000)]
Added a timer for every page.
Steinar H. Gunderson [Fri, 1 Apr 2005 21:33:53 +0000 (21:33 +0000)]
Work around broken Red Hat PostgreSQL.
Steinar H. Gunderson [Wed, 30 Mar 2005 15:43:00 +0000 (15:43 +0000)]
Add some SQL for correcting nationalities from EC1.
Steinar H. Gunderson [Wed, 30 Mar 2005 15:20:32 +0000 (15:20 +0000)]
Add various tournaments from DDR Europe. Not all are insertable into the current database schema...
Steinar H. Gunderson [Wed, 30 Mar 2005 15:00:08 +0000 (15:00 +0000)]
Add -10K Machine score as a scoring system.
Steinar H. Gunderson [Wed, 30 Mar 2005 14:58:11 +0000 (14:58 +0000)]
Don't give 500 if we have no rounds.
Steinar H. Gunderson [Wed, 30 Mar 2005 14:53:18 +0000 (14:53 +0000)]
Add scripts and example SQL for parsing the EM2 series from 2002.
Steinar H. Gunderson [Wed, 30 Mar 2005 14:27:22 +0000 (14:27 +0000)]
Show countries (for European tournaments) or clubs (for all others) in the HTML.
Steinar H. Gunderson [Wed, 30 Mar 2005 14:11:08 +0000 (14:11 +0000)]
Add scripts for getting CC03 data, and premade SQL.
Steinar H. Gunderson [Wed, 30 Mar 2005 14:05:35 +0000 (14:05 +0000)]
DDR Europe tournament parser now by default sets all players to Norway. Syntax fixes for SQL. Update example SQL.
Steinar H. Gunderson [Wed, 30 Mar 2005 13:49:52 +0000 (13:49 +0000)]
Add a script (and output SQL) for getting the country list from Wikipedia.
Steinar H. Gunderson [Wed, 30 Mar 2005 13:37:08 +0000 (13:37 +0000)]
Begin changing the country stuff.
- All players must now have a country.
- There are clubs.
- Countries have three-letter IOC country codes.
The changes are not yet reflected in the data.
Steinar H. Gunderson [Wed, 30 Mar 2005 02:37:46 +0000 (02:37 +0000)]
Don't show bigscreen controls in public mode.
Steinar H. Gunderson [Wed, 30 Mar 2005 02:31:03 +0000 (02:31 +0000)]
The last do-finish-tournament fix was completely wrong, try to do it properly this time.
Steinar H. Gunderson [Wed, 30 Mar 2005 01:24:46 +0000 (01:24 +0000)]
Fix UTF-8.
Steinar H. Gunderson [Wed, 30 Mar 2005 01:22:49 +0000 (01:22 +0000)]
Make the DDR Europe parsing scripts distinguish tournaments based on their season as well, not just the name.
Steinar H. Gunderson [Wed, 30 Mar 2005 01:18:43 +0000 (01:18 +0000)]
Make more room for the players in the "top 10 scores" screen.
Steinar H. Gunderson [Wed, 30 Mar 2005 01:16:52 +0000 (01:16 +0000)]
Fix crash in RotateScreen when there are no subscreens.
Steinar H. Gunderson [Wed, 30 Mar 2005 01:15:58 +0000 (01:15 +0000)]
Fix max score for players; only chosen songs can't be selected twice.
Steinar H. Gunderson [Wed, 30 Mar 2005 01:14:29 +0000 (01:14 +0000)]
Fix list of finished groups; don't show elimination/seeding groups, show finished parallels even if they are in a non-finished round.
Steinar H. Gunderson [Sat, 5 Mar 2005 03:16:15 +0000 (03:16 +0000)]
Cache revision.
21:15-04:00
Steinar H. Gunderson [Sat, 5 Mar 2005 03:13:13 +0000 (03:13 +0000)]
Add an SQL snippet for fixing some stuff related to chosen/random songs in the data from DDR Europe.
Steinar H. Gunderson [Sat, 5 Mar 2005 02:59:39 +0000 (02:59 +0000)]
Added CC04-8 data.
Steinar H. Gunderson [Sat, 5 Mar 2005 02:50:40 +0000 (02:50 +0000)]
"Candy" now has a white star by it; updated parsers and all relevant SQL.
Steinar H. Gunderson [Sat, 5 Mar 2005 02:17:23 +0000 (02:17 +0000)]
Added a simple flag in ccbs.pm to make the system suitable for public viewing (ie. no changes).
Steinar H. Gunderson [Sat, 5 Mar 2005 01:47:10 +0000 (01:47 +0000)]
When there's only one group, insert it with ID 0, not ID 1, so the rest of the scripts understand it's special.
Steinar H. Gunderson [Sat, 5 Mar 2005 01:20:45 +0000 (01:20 +0000)]
Set all songs to single expert per default (this will break when we go to DDREx, though..)
Steinar H. Gunderson [Sat, 5 Mar 2005 01:14:31 +0000 (01:14 +0000)]
Don't show total if we only have one song.
Steinar H. Gunderson [Sat, 5 Mar 2005 01:09:11 +0000 (01:09 +0000)]
Fix off-by-one for "needs to lead" code.
Steinar H. Gunderson [Sat, 5 Mar 2005 01:08:39 +0000 (01:08 +0000)]
Don't show "needs to qualify" if all in group qualify.
Steinar H. Gunderson [Sat, 5 Mar 2005 01:05:57 +0000 (01:05 +0000)]
Fixed "number of played songs" detection for bigscreen, making the "needs to lead" etc. work again.
Steinar H. Gunderson [Sat, 5 Mar 2005 01:05:23 +0000 (01:05 +0000)]
Hack the rotate screen so it doesn't delay new updates of a screen any longer just because that screen contained new info at the time (see the comments).
Steinar H. Gunderson [Sat, 5 Mar 2005 00:48:17 +0000 (00:48 +0000)]
Remove versus item from the TODO, it should be okay now.
Steinar H. Gunderson [Sat, 5 Mar 2005 00:47:39 +0000 (00:47 +0000)]
Clarified the meaning of players_per_machine in the templates.
Steinar H. Gunderson [Sat, 5 Mar 2005 00:46:19 +0000 (00:46 +0000)]
Actually fetch the number of players on the machine at a time, so the versus code works.
Steinar H. Gunderson [Sat, 5 Mar 2005 00:40:01 +0000 (00:40 +0000)]
Add code in the bigscreen for supporting versus groups (not finished yet).
Steinar H. Gunderson [Sat, 5 Mar 2005 00:19:15 +0000 (00:19 +0000)]
Refactoring, always refactoring...
Steinar H. Gunderson [Sat, 5 Mar 2005 00:09:27 +0000 (00:09 +0000)]
Remove an obsolete comment.
Steinar H. Gunderson [Sat, 5 Mar 2005 00:09:06 +0000 (00:09 +0000)]
Yet more refactoring.
Steinar H. Gunderson [Fri, 4 Mar 2005 23:52:10 +0000 (23:52 +0000)]
Yet more refactoring.
Steinar H. Gunderson [Fri, 4 Mar 2005 23:37:37 +0000 (23:37 +0000)]
Added refactoring comment
Steinar H. Gunderson [Fri, 4 Mar 2005 23:36:54 +0000 (23:36 +0000)]
More refactoring.
Steinar H. Gunderson [Fri, 4 Mar 2005 23:26:22 +0000 (23:26 +0000)]
More refactoring.
Steinar H. Gunderson [Fri, 4 Mar 2005 23:17:58 +0000 (23:17 +0000)]
Mild refactoring.
Steinar H. Gunderson [Fri, 4 Mar 2005 22:47:22 +0000 (22:47 +0000)]
Make the bigscreen application read in the number of players per machine, but don't do anything useful with it yet.
Steinar H. Gunderson [Fri, 4 Mar 2005 22:38:17 +0000 (22:38 +0000)]
The front end can now choose how many players play per machine (1 or 2).
Steinar H. Gunderson [Fri, 4 Mar 2005 22:23:25 +0000 (22:23 +0000)]
Added a field in the bigscreen active groups allowing for versus play.
Steinar H. Gunderson [Fri, 4 Mar 2005 22:20:34 +0000 (22:20 +0000)]
Added note to TODO
Steinar H. Gunderson [Tue, 1 Mar 2005 03:04:18 +0000 (03:04 +0000)]
Let each screen get width and height in as a parameter on draw() instead of hardcoding it to SCREEN_WIDTH * SCREEN_HEIGHT.
This is quite ugly at places, but it seems to work well. This isn't really done for the speed
boost (although fades etc. are quite a lot smoother when the split screen can do all its work
in the native resolution instead of fading and _then_ downscaling), but primarily for the
legibility (ie. let FreeType _understand_ that we are on a smaller screen, so get hinting etc.
right), which seems to have improved by quite a lot (the overall "polish" look is a bit down,
though, probably the autohinter is evil).
19:30-04:00
Steinar H. Gunderson [Tue, 1 Mar 2005 02:21:33 +0000 (02:21 +0000)]
Forgot to add the prototype for set_screen_size().
Steinar H. Gunderson [Tue, 1 Mar 2005 02:21:04 +0000 (02:21 +0000)]
Let the font system take in a physical resolution, instead of #define-ing it (quite ugly).
Steinar H. Gunderson [Tue, 1 Mar 2005 02:14:33 +0000 (02:14 +0000)]
Set default resolution to 1024x768.
Steinar H. Gunderson [Tue, 1 Mar 2005 02:14:09 +0000 (02:14 +0000)]
Make a "logical resolution" (yuck!) of 800x600 for all the screens, and make fonts.cpp compensate for that.
Steinar H. Gunderson [Tue, 1 Mar 2005 01:59:31 +0000 (01:59 +0000)]
Replace 800x600 width a resolution from a .h file. Lots of positions are still hardcoded, though.
Steinar H. Gunderson [Tue, 1 Mar 2005 01:12:51 +0000 (01:12 +0000)]
Implement a simple priority system.
The priority system is used to determine which screen is shown first if two or more screens
have updated information (ie. a group screen is more important than a "today's high scores"
screen, which is in turn more important than "today's most chosen songs", as the latter is
mainly a curiosity).
- Add a get_priority() to GenericScreen, default 0.
- Implement get_priority() for GroupScreen and Top10ScoreScreen, set to 10 and 5 resp.
- Make RotateScreen automatically pick the screen with the highest priority if two or more
have forced updates.