Assigning Goals to Players

The next step for me was to develop a way to easily assign the teams goals to players. This happens in my goal table, and I developed a simple "World Cup Goal Assigner" WPF application, which lists every game for a tournament, shows the games goals, and allows me to easily assign or edit goal scoring information for any player. This allowed me to very quickly (about 20 minutes) assign the 145 goals for South Africa 2010. In the screenshot below you can see this in action:

Now Hosted!

You can view my project here: My World Cup Project

Adding in the Goals

Now that I've loaded all the tournaments, the games are all in one user control, I've started to focus on adding some of the detail, the first area I've done this is Group F of South Africa 2010. As you can see, although the data is there, I need to adjust the formatting slightly, but it's coming along...

Charts and Reusable Controls

I've been working on the Main Tournament page over the past week, and trying to get some reusable controls to work propably, one is an expandable panel with JQuery, the other is a list of Games for that particular range. I've also been playing with the .NET 4.0 Charting, experimenting with different charts. Things are moving along, but at the same time, things are also slowing down as I fine tune the 19 tournaments.

1st Round of Data Uploads Complete!!

I finished the basic data upload today for all 19 World Cups, uploading all the teams and every game and result, along with the group tables and playoff brackets. I'm going to work with this data for a little while, before I go back to loading in the players and individual goal scorers.

This was quite challenging for some of the earlier tournaments, as all tournaments before 1994 you only got 2 points for a win, World Cup's 1950 and 1938 had some withdrawn teams, 1954 had group playoff games if teams finished with the same number of points,and the hardest problem, 1938 playoff games did not go to penalties, they replayed the game a few days later. I managed to solve most of the issues without changing the database, but I will have to spend some time on the website to show these exceptions correctly. Playoff replays are going to be the worst, mostly because there is just not that much room on the playoff table...

Updating the Tournament Format

As I mentioned in my last post, as I worked through the tournaments (now I have the basics of 1970-2010 loaded in the database), I realized that my simple tournament format table wasn't going to work. Without over engineering things, and after reviewing the formats of all the World Cups, I decided to create a new table that stored the content of each round, and then in the tournament_format table, I added a round_1_format_code, round_2_format_code, and round_3_format_code columns linking to this new table. The new table holds information about if the round is a group or playoff, and then if it's a group, the number of teams that advance from each group, and the overall number of teams that should progress from this stage. This helped to solve some of the 3rd place teams, (e.g. in Mexico 1986, there were 24 teams in 6 groups in the group stage, and the top 2 from each group went through, (12 teams), as well as 4 third place teams). This forced me to add a 'round_number' column (not to be confused with 'round_code') to the game table, to track what stage of the tournament we are in. So far it's all working great!!

Next time I'm going to talk about 2 other challenges I had, co-hosted tournaments (Korea & Japan), and the change in points (2 points for a win in all tournament from 1930-1990, 3 points for a win in all tournaments from 1994 - 2010.

Adding More Tournaments

Next I worked on importing some more tournaments. This was pretty straight forward. Using the Wikipedia pages, I was able to work backwards using my excel spreadsheets, making minor adjustments as the tournaments had less teams (1994 only had 24 teams, and then in 1982, I reached my first major round block, as the tournament had THREE rounds. At this stage I had to rework the group tables to allow multiple rounds, and then I had to rework the playoff stage so that it dynamically displayed the rounds as needed (as the 1982 final round only involved 4 teams). I finally got this all to work tonight. As you can see below, I also added a header and footers with 'Breadcrumbs' (with Master pages).


Next I'll be working on a Tournament summary, basic stats page.