How to make Tournament underway?

[Alan Field]

Hey,

The main website has this description:

"Once a tournament is underway, users can keep track of their progress as the administrator for a tournament updates the results of games. Tournaments results are updated by the administrator with the same interface players use to enter their brackets. Players are prevented from editing their brackets once it has been added to a pool that has a tournament underway."

How do you specify in the GUI that a tournament is underway? I didn't see it in the Getting started page either.

Thanks,
Alan

[Avery J. Regier]

The system currently defines this as a tournament having a game that has a winner or has a START_TIME in the past.

You can accomplish this in two ways.  The simple way is just to pre-select a winner for one of the games until the first game is officially won.  If you do that for a 1 seed beating a 16, everyone will temporarily have a point, but the pools will then be closed. 

You can then go into the database and run something like the following (which I just did myself and it works fine):

First, you need to find out the id of the tournament you are wanting to mark as underway.

mysql> select * from tournament;
+---------------+-----------------------------+--------------------+------------
----+-----------+
| TOURNAMENT_ID | NAME                        | TOURNAMENT_TYPE_ID | START_TIME
    | LEAGUE_ID |
+---------------+-----------------------------+--------------------+------------
----+-----------+
|             1 | 2004 Mens NCAA Tournament   |                  1 | 20081114000
000 |      NULL |
|             2 | 2005 Mens ACC Tournament    |                  2 | 20081125000
000 |      NULL |
|             3 | 2005 Womens NCAA Tournament |                  1 | 00000000000
000 |      NULL |
|             4 | 2005 Mens NCAA Tournament   |                  1 | 00000000000
000 |      NULL |
|             5 | ACC Men's 2006              |                  4 | 20060306113
617 |         3 |
|             6 | Big 10 Men's 2006           |                  3 | 20060306134
041 |         5 |
|             7 | 2006 Men's NCAA Tournament  |                  1 | 20060316111
113 |         1 |
+---------------+-----------------------------+--------------------+------------
----+-----------+
7 rows in set (0.00 sec)

Here the id I want is 7.  You can also see this in the URLs in the user interface.

mysql> select * from game where tournament_id=7;
+--------------+---------------+--------+----------------+
| GAME_NODE_ID | TOURNAMENT_ID | WINNER | START_TIME     |
+--------------+---------------+--------+----------------+
|           56 |             7 |      1 | 20060316111849 |
+--------------+---------------+--------+----------------+
1 row in set (0.00 sec)

mysql> update game set winner=null where game_node_id=56 and tournament_id=7;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Then I restart.  The points are taken away, but the pools are still closed.

Sorry there isn't an easier way to do this yet.  This is one of the reasons this hasn't reached 1.0 yet.

-Avery

[Avery J. Regier]

There is now a way to set the start time for the tournament when you create it.  The code is in CVS and will be put out with the 0.50 release.

-Avery