qbsql - Project Hosting on Google Code

Yesterday 47 hours ago r76 (Fix minor bugs in tournament import from SQBS.) committed by ajlyon - Fix minor bugs in tournament import from SQBS. Fix minor bugs in tournament import from SQBS. Last 7 days Dec 18, 2009 r75 (Improved integration of SQBS import, better error reporting,...) committed by ajlyon - Improved integration of SQBS import, better error reporting, fixed tabbing on new tournament form. Improved integration of SQBS import, better error reporting, fixed tabbing on new tournament form. Dec 17, 2009 issue 1 (Static pages for archiving completed tournaments) commented on by ajlyon - This is discussed at http://stackoverflow.com/questions/66610/how-can-i-create-a-site-in-php-and-have-it-generate-a-static-version . While it would still be better to do this from within PHP and create, say, an HTML file with all the files, the spidering method with wget will work in the meantime. This is discussed at http://stackoverflow.com/questions/66610/how-can-i-create-a-site-in-php-and-have-it-generate-a-static-version . While it would still be better to do this from within PHP and create, say, an HTML file with all the files, the spidering method with wget will work in the meantime. Dec 17, 2009 r74 (Clarify bracket explanation) committed by ajlyon - Clarify bracket explanation Clarify bracket explanation Dec 17, 2009 issue 11 (Importer for SQBS data) changed by ajlyon - This issue was closed by revision r73. Status: Fixed This issue was closed by revision r73. Status: Fixed Dec 17, 2009 r73 (Adds SQBS import. Fixes issue 11.) committed by ajlyon - Adds SQBS import. Fixes issue 11 . Adds SQBS import. Fixes issue 11 . Last 30 days Dec 13, 2009 issue 27 (Career / historical / unified statistics) reported by ajlyon - It should be possible to look at stats across multiple tournaments. This should mean historical stats for players and teams, and stats from multiple sites using a single set. This may be out of the scope of QBSQL. If so, QBSQL should work to make its data easily accessible by other software that tracks such unified statistics. It should be possible to look at stats across multiple tournaments. This should mean historical stats for players and teams, and stats from multiple sites using a single set. This may be out of the scope of QBSQL. If so, QBSQL should work to make its data easily accessible by other software that tracks such unified statistics. Dec 13, 2009 issue 26 (Export / interchange format for quizbowl) reported by ajlyon - There should be a standard format for exporting and importing quizbowl data. When such a format is defined, QBSQL should support it. There should be a standard format for exporting and importing quizbowl data. When such a format is defined, QBSQL should support it. Dec 13, 2009 issue 25 (Tossup-by-tossup ("live") stats entry) reported by ajlyon - It would be good to provide a means of entering stats live, a la QBTPS. This would require a new table of buzzes, and an interface to facilitate input. It would be good to provide a means of entering stats live, a la QBTPS. This would require a new table of buzzes, and an interface to facilitate input. Dec 03, 2009 r72 (undoing property changes) committed by ajlyon - undoing property changes undoing property changes Dec 03, 2009 r71 (Added config.php to svn:ignore.) committed by ajlyon - Added config.php to svn:ignore. Added config.php to svn:ignore. Dec 03, 2009 r70 (Removing wymeditor examples directory and fixing config regr...) committed by ajlyon - Removing wymeditor examples directory and fixing config regression. Removing wymeditor examples directory and fixing config regression. Dec 03, 2009 qbsql-0.6.1.zip (Now with data integrity checking, forfeits, and more. Fixes ...) file uploaded by ajlyon - Labels: Featured Labels: Featured Dec 02, 2009 issue 23 (Round summary incorrect when one team has negative score) changed by ajlyon - This issue was closed by revision r69. Status: Fixed This issue was closed by revision r69. Status: Fixed Dec 02, 2009 r69 (Fix regression due to null values in forfeit column. Fixes i...) committed by ajlyon - Fix regression due to null values in forfeit column. Fixes issue 23 . Fix regression due to null values in forfeit column. Fixes issue 23 . Dec 02, 2009 issue 23 (Round summary incorrect when one team has negative score) Labels changed by ajlyon - Note round 8 Stanford B vs. UCLA http://quizbowl.gimranov.com/stats/stats_round.php?t=eft2009 This is a major issue. Labels: Priority-Critical −Priority-High Note round 8 Stanford B vs. UCLA http://quizbowl.gimranov.com/stats/stats_round.php?t=eft2009 This is a major issue. Labels: Priority-Critical −Priority-High Dec 02, 2009 issue 24 (Write-only plans should have preferences access) Status changed by ajlyon - Status: Invalid Status: Invalid Dec 02, 2009 issue 24 (Write-only plans should have preferences access) commented on by ajlyon - This is on the wrong bug tracker. This is on the wrong bug tracker. Dec 02, 2009 issue 19 (Sanity checking for round input) changed by ajlyon - As of r68, we have non-enforced data integrity assertions, in the function verify_game(..). The logged-in user is notified of problematic data when viewing game details and after submitting new or updated game stats. It would still be nice to do some of this in JavaScript, but this will probably do well enough for now. Status: Started Labels: Priority-Low −Priority-Medium As of r68, we have non-enforced data integrity assertions, in the function verify_game(..). The logged-in user is notified of problematic data when viewing game details and after submitting new or updated game stats. It would still be nice to do some of this in JavaScript, but this will probably do well enough for now. Status: Started Labels: Priority-Low −Priority-Medium Dec 02, 2009 r68 (Added game data integrity checking. We don't prevent users f...) committed by ajlyon - Added game data integrity checking. We don't prevent users from entering odd data, but we notify when the round is added, modified, or viewed by the logged in user. This starts to address issue 19. Added game data integrity checking. We don't prevent users from entering odd data, but we notify when the round is added, modified, or viewed by the logged in user. This starts to address issue 19. Dec 01, 2009 issue 24 (Write-only plans should have preferences access) reported by ajlyon - Currently, write-only plans are denied access to the preference pages. This means that they can't choose a stylesheet, nor can they change their password or set a guest password. While perhaps this is by design, the [vegcoop] plan is now stuck referring to a custom stylesheet that has been offline for years. I can envision a scenario where we wouldn't want to allow custom stylesheets for public plans, since someone could set the stylesheet to an external file, then track the usage of that file to monitor who (which IP addresses) are editing the plan. I cannot, however, imagine a reason why the non-public plans (group plans) should be stuck not changing their passwords, not setting guest access preferences, and not setting guest passwords. Currently, write-only plans are denied access to the preference pages. This means that they can't choose a stylesheet, nor can they change their password or set a guest password. While perhaps this is by design, the [vegcoop] plan is now stuck referring to a custom stylesheet that has been offline for years. I can envision a scenario where we wouldn't want to allow custom stylesheets for public plans, since someone could set the stylesheet to an external file, then track the usage of that file to monitor who (which IP addresses) are editing the plan. I cannot, however, imagine a reason why the non-public plans (group plans) should be stuck not changing their passwords, not setting guest access preferences, and not setting guest passwords. Dec 01, 2009 issue 23 (Round summary incorrect when one team has negative score) reported by ajlyon - In the test installation of QBSQL on gimranov.com, the round 1 game between Franktown A and Bobtown incorrectly puts Franktown as the winner, with -35 points. Bobtown should be the winner, with its 995. This misinterpretation of a negative score happens in both stats_team.php and in stats_round.php, but not in round details or in team details. In the test installation of QBSQL on gimranov.com, the round 1 game between Franktown A and Bobtown incorrectly puts Franktown as the winner, with -35 points. Bobtown should be the winner, with its 995. This misinterpretation of a negative score happens in both stats_team.php and in stats_round.php, but not in round details or in team details. Nov 27, 2009 issue 19 (Sanity checking for round input) changed by ajlyon - Owner: m...@stanford.edu Cc: ajlyon Owner: m...@stanford.edu Cc: ajlyon Nov 27, 2009 issue 11 (Importer for SQBS data) commented on by ajlyon - This should be pretty easy; the mapping of QBSQL data structures and SQBS data files is worked out in the SQBS export function already. This should be pretty easy; the mapping of QBSQL data structures and SQBS data files is worked out in the SQBS export function already. Nov 27, 2009 issue 1 (Static pages for archiving completed tournaments) Labels changed by ajlyon - Labels: Priority-High −Priority-Medium Labels: Priority-High −Priority-Medium Nov 27, 2009 issue 22 (Cleaner support for multiple tournaments) reported by ajlyon - We should switch from hard-coding t={$mysql_prefix} in every link in favor of PHP's built-in URL-rewriting: bool output_add_rewrite_var ( string $name , string $value ) This is documented at http://www.php.net/manual/en/function.output-add-rewrite-var.php . We should switch from hard-coding t={$mysql_prefix} in every link in favor of PHP's built-in URL-rewriting: bool output_add_rewrite_var ( string $name , string $value ) This is documented at http://www.php.net/manual/en/function.output-add-rewrite-var.php . Nov 27, 2009 qbsql-0.6.0.zip (Now with proper support for forfeits, NAQT integration and m...) file uploaded by ajlyon - Labels: Featured Type-Archive Labels: Featured Type-Archive Nov 27, 2009 zotero-0.6.0.zip (Now with proper support for forfeits, NAQT integration and m...) file uploaded by ajlyon - Labels: Featured Type-Archive Labels: Featured Type-Archive Nov 23, 2009 issue 21 (Database-backed session store) changed by ajlyon - This is due to requests from the client being handled by different servers, and thus different instances of Apache and PHP. These instances don't share their PHP session codes, meaning that whenever a user send a new request, there's a risk that the server won't have their session data. The more robust solution is switching to MySQL-backed session stores, which PHP handles (via http://www.php.net/manual/en/function.session-set-save-handler.php) Summary: Database-backed session store Status: Accepted Owner: m...@stanford.edu Cc: ajlyon Labels: Priority-High −Priority-Critical This is due to requests from the client being handled by different servers, and thus different instances of Apache and PHP. These instances don't share their PHP session codes, meaning that whenever a user send a new request, there's a risk that the server won't have their session data. The more robust solution is switching to MySQL-backed session stores, which PHP handles (via http://www.php.net/manual/en/function.session-set-save-handler.php) Summary: Database-backed session store Status: Accepted Owner: m...@stanford.edu Cc: ajlyon Labels: Priority-High −Priority-Critical Nov 23, 2009 r67 (Included proper forfeit checks in round summaries.) committed by m...@stanford.edu - Included proper forfeit checks in round summaries. Included proper forfeit checks in round summaries. Nov 23, 2009 r66 (Fix issue where forfeit was assigned to the wrong team.) committed by ajlyon - Fix issue where forfeit was assigned to the wrong team. Fix issue where forfeit was assigned to the wrong team. Nov 21, 2009 r65 (First commit for forfeits support. Possibly unstable.) committed by ajlyon - First commit for forfeits support. Possibly unstable. First commit for forfeits support. Possibly unstable. Earlier this year Nov 19, 2009 issue 21 (Authentication problems: ) Labels changed by ajlyon - This was reported by Stanford-- not clear what caused them to have to frequently log back in to the system. Labels: Priority-Critical −Priority-Medium This was reported by Stanford-- not clear what caused them to have to frequently log back in to the system. Labels: Priority-Critical −Priority-Medium Nov 19, 2009 issue 21 (Authentication problems: ) reported by ajlyon - [...] the program would claim that we were logged out ("You must log in to use this system."), when I was not. I had to keep sending the request multiple times until it resolved. [...] the program would claim that we were logged out ("You must log in to use this system."), when I was not. I had to keep sending the request multiple times until it resolved. Nov 19, 2009 issue 18 (Brackets) Labels changed by ajlyon - Also, it should be possible to specify the bracket when adding a new team. Labels: Priority-High −Priority-Medium Also, it should be possible to specify the bracket when adding a new team. Labels: Priority-High −Priority-Medium Oct 11, 2009 issue 20 (Linking player and team records) Status changed by ajlyon - r64 makes this happen. We don't link team records for now, nor is it probably very helpful to do so. Next big step is a more flexible way of combining player results from disparate sources, or at least across QBSQL tournaments. Status: Fixed r64 makes this happen. We don't link team records for now, nor is it probably very helpful to do so. Next big step is a more flexible way of combining player results from disparate sources, or at least across QBSQL tournaments. Status: Fixed Oct 11, 2009 r64 (fixes issue 20, except for team records. They are less vital...) committed by ajlyon - fixes issue 20 , except for team records. They are less vital and probably won't happen. fixes issue 20 , except for team records. They are less vital and probably won't happen. Oct 11, 2009 issue 20 (Linking player and team records) commented on by ajlyon - As of r62, potential matches are shown when an admin is looking at a player detail, and a link to the NAQT records is shown when a player ID is available. This slows down admin viewing of player details, since each view waits for the NAQT server to respond before being sent to the browser. This is not an issue for non-admins and when the NAQT ID field has been filled in. This is a nice start. The prompting being done here should also happen when adding players, perhaps as part of a much-needed rewrite of that entire script. As of r62, potential matches are shown when an admin is looking at a player detail, and a link to the NAQT records is shown when a player ID is available. This slows down admin viewing of player details, since each view waits for the NAQT server to respond before being sent to the browser. This is not an issue for non-admins and when the NAQT ID field has been filled in. This is a nice start. The prompting being done here should also happen when adding players, perhaps as part of a much-needed rewrite of that entire script. Oct 11, 2009 r63 (Basic NAQT player database support. Linking message appears ...) committed by ajlyon - Basic NAQT player database support. Linking message appears when an admin is looking at a player detail page. Basic NAQT player database support. Linking message appears when an admin is looking at a player detail page. Oct 04, 2009 r62 (Fix prefix checking. ) committed by ajlyon - Fix prefix checking. Fix prefix checking. Oct 04, 2009 r61 (Fixes after EFT mirror. Added a round summary section with i...) committed by ajlyon - Fixes after EFT mirror. Added a round summary section with info for comparing packet/round difficulty, a la SQBS. Also added more sanity checking for tournament names. Fixes after EFT mirror. Added a round summary section with info for comparing packet/round difficulty, a la SQBS. Also added more sanity checking for tournament names. May 24, 2009 r60 (Several cosmetic improvements to styling, linking, etc. ) committed by ajlyon - Several cosmetic improvements to styling, linking, etc. Several cosmetic improvements to styling, linking, etc. May 24, 2009 r59 (beginning of naqt integration, fix for sorting bug ) committed by ajlyon - beginning of naqt integration, fix for sorting bug beginning of naqt integration, fix for sorting bug May 24, 2009 issue 20 (Linking player and team records) reported by ajlyon - It would be good to link player results in QBSQL tournaments to result aggregators like NAQT's. r58 introduces a field for NAQT player IDs, but they must be added manually from the player edit screen. We should attempt to determine the ID automatically using the NAQT search page: http://www.naqt.com/stats/player-search.jsp?PASSBACK=PLAYER_SEARCH&FIRST_NAME=Avram&LAST_NAME=Lyon It would be good to link player results in QBSQL tournaments to result aggregators like NAQT's. r58 introduces a field for NAQT player IDs, but they must be added manually from the player edit screen. We should attempt to determine the ID automatically using the NAQT search page: http://www.naqt.com/stats/player-search.jsp?PASSBACK=PLAYER_SEARCH&FIRST_NAME=Avram&LAST_NAME=Lyon May 24, 2009 r58 (Adding basic support for linking to NAQT results database. ) committed by ajlyon - Adding basic support for linking to NAQT results database. Adding basic support for linking to NAQT results database. Mar 08, 2009 qbsql-0.5.3.tar.gz (Full-featured and stable, with SQBS export, table sorting an...) file uploaded by ajlyon - Labels: Featured Labels: Featured Mar 08, 2009 r57 (Important to make bracket not null! Otherwise things break. ) committed by ajlyon - Important to make bracket not null! Otherwise things break. Important to make bracket not null! Otherwise things break. Mar 02, 2009 qbsql-0.5.2.tar.gz (Full-featured and stable, with SQBS export, table sorting an...) file uploaded by ajlyon - Labels: Featured Labels: Featured Mar 02, 2009 r56 (Additional sorting and styling. ) committed by ajlyon - Additional sorting and styling. Additional sorting and styling. Mar 02, 2009 r55 (Addressing bug in tournament creation. ) committed by ajlyon - Addressing bug in tournament creation. Addressing bug in tournament creation.

issue 24 (Write-only plans should have preferences access) reported by ajlyon - Currently, write-only plans are denied access to the preference pages. This means that they can't choose a stylesheet, nor can they change their password or set a guest password. While perhaps this is by design, the [vegcoop] plan is now stuck referring to a custom stylesheet that has been offline for years. I can envision a scenario where we wouldn't want to allow custom stylesheets for public plans, since someone could set the stylesheet to an external file, then track the usage of that file to monitor who (which IP addresses) are editing the plan. I cannot, however, imagine a reason why the non-public plans (group plans) should be stuck not changing their passwords, not setting guest access preferences, and not setting guest passwords.

Currently, write-only plans are denied access to the preference pages. This means that they can't choose a stylesheet, nor can they change their password or set a guest password. While perhaps this is by design, the [vegcoop] plan is now stuck referring to a custom stylesheet that has been offline for years. I can envision a scenario where we wouldn't want to allow custom stylesheets for public plans, since someone could set the stylesheet to an external file, then track the usage of that file to monitor who (which IP addresses) are editing the plan. I cannot, however, imagine a reason why the non-public plans (group plans) should be stuck not changing their passwords, not setting guest access preferences, and not setting guest passwords.

Yesterday

Last 7 days

Last 30 days

Earlier this year