Sunday, June 04, 2006

Update WC 2006 APEX app

After the success of the first version of the World Cup 2006 APEX application, I got infected by the "APEX-bug" (= couldn't stop using APEX anymore) and the last couple of days I have tried to put some more APEX features in the WC 2006 application.

The following features are now included:

  • use of webservices to get information about the World Cup
  • custom login mechanism (based on the login of the APEX forum application)
  • authentication and authorization schemes
  • custom themes/templates/lay-out
  • use of translations (only country names)
  • next to that the application is now hosted on a production environment, thanks to Jes of ShellPrompt
  • there're also new graphics included (so don't worry about copyright), thanks to Kristel of G&G Design
But that's not all!! The application allows betting! And you can win prizes with it!
So check it out now! The new application can be found at


Colin Sheppard said...

Can you offer a feature to edit and update user profile information please?

For example, I want to be able to change email addresses.

Anonymous said...

This is one of the coolest applications out there, it's amazing the amount of interest people have when,
football (soccer, the beautiful game) is involved.

Great Job!

Dimitri Gielis said...

Colin, you can change your profile now ;-)

Kirtan said...

I just found the link to WC 2006 APEX app website from tom's (kyte) blog. I think this is a very very very good example of APEX application.
I have already registered and submitted a few bets.
kudos on a great effort.

Anonymous said...

Problem with the app - I selected poor Ghana to lose all its games. It (and all the other losers) are in the 1/8 final screen. The winners go home and the losers play on?

Dimitri Gielis said...

The scores you predict are invisible for the others and do not influence... As soon as the games are played the score is filled in, in the overview and you'll see the 1/8 finals change dynamically, just like you see in the first version of this application:

Anonymous said...

Ok - my bad. I thought you would calculate the 1/8 round teams, based on who the user thought would win the first round matches (matching FIFA rules for tie records, etc.)

This way the user could pick all rounds before any game was played, and the rounds would be logically consistent with the predicted winners.

But it sounds like lots of work :-)

Anonymous said...

Ahg I registered twice, don't worry I'll only bet once though :)

Dimitri Gielis said...

Hi Carl, I can delete one account if you'd like... you just liked the application too much ;-)

Anonymous said...

I couldn't resist registering to play too, but I realised there would be cries of "Foul!" if I actually won any of the prizes.

Then I realised I'm English and therefore the chance of winning anything World Cup related is next to nil ;)

Excellent job Dimitri!

Anonymous said...

As I browse the site after I login and at some point if I logout I am shown the logout message. If I hit the browser back button and go to any of the pages (say update profile) my session is still valid and it allows me to update.

Dimitri Gielis said...

Hi bala, thanks for telling. I changed the link, it should work now.

Anonymous said...

Actually, where does one get a free collection of icon flags from?

Dimitri Gielis said...

When you type this into google: free icon flags, you get a lot of sites... Mine are comming from the Excel file I got via mail.

Dimitri Gielis said...

There's also some info in the APEX forum on the Oracle site:

Gleisson Henrique said...

ok, call me dummy. I forgot my loginname/password, what do I do ? Do I register again? I have made bets for all first games. Please let me know!

Gleisson Henrique

PS Great work by the way !

Dimitri Gielis said...

Gleisson I've sent you a mail... your password has been reset.

Anonymous said...

Hey Dimi,

Heb juist mijn scores ingevuld, dus vertel maar aan de rest dat de eerste plaats al bezet is :-)

Heel mooi gemaakt trouwens...

Anonymous said...

Ben momenteel ook bezig met de mogelijkheden van APEX een beetje te leren kennen, maar dit ziet er echt wel leuk uit.
En laat die T-shirt maar komen! :)

Joel R. Kallman said...

I'm still contemplating what I'm going to do with one year of free Application Express hosting after *I* win.

By the way, my money is not on Team USA. I wager with my mind, not my heart.

Dimitri Gielis said...

Everybody is sure of themselves ;-)
We'll see!

Anonymous said...

Great work dimitri...just a thought...may be it would be easier for users if the time on the schedule page for the matches is shown as per user's time zone!


Dimitri Gielis said...

Users time zone is included now.

Some other new features:
- Latest news included
- Pictures for stadia
- Prediction minute of first goal in finale will be included too, to define the winner in case of people have the same score (in the rank)

Anonymous said...


Congratulations with this application, great Idea.

I entered a bet but in 1/4 round no countries are appearing. What do I do wrong ?

Sander van Houdt

Dimitri Gielis said...

* this question returns a lot *

So I added this to the application:

How to score points (Bet) in the Finals?
Although you already can fill-in the results of all the finals now, the teams will only be known after the previous round. The teams in the finals don't depend on the bets YOU made in the previous rounds, but they're based on the official results!

Unknown said...

HI, I have a question for you, it still exists? can you send to me or to publish link to download? thanks