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 http://wc2006.shellprompt.net/
at

26 comments:

  1. Colin Sheppard6/05/2006 1:29 PM

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

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

    ReplyDelete
  2. Anonymous6/05/2006 4:59 PM

    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!

    ReplyDelete
  3. Dimitri Gielis6/06/2006 11:33 AM

    Colin, you can change your profile now ;-)

    ReplyDelete
  4. Kirtan6/06/2006 4:01 PM

    Hi,
    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.
    KD

    ReplyDelete
  5. Anonymous6/06/2006 4:34 PM

    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?

    ReplyDelete
  6. Dimitri Gielis6/06/2006 4:40 PM

    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:
    http://htmldb.oracle.com/pls/otn/f?p=wc2006:overview

    ReplyDelete
  7. Anonymous6/06/2006 6:54 PM

    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 :-)

    ReplyDelete
  8. Anonymous6/06/2006 10:28 PM

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

    ReplyDelete
  9. Dimitri Gielis6/06/2006 11:03 PM

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

    ReplyDelete
  10. Anonymous6/06/2006 11:16 PM

    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!

    ReplyDelete
  11. Anonymous6/07/2006 10:24 AM

    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.

    ReplyDelete
  12. Dimitri Gielis6/07/2006 11:00 AM

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

    ReplyDelete
  13. Anonymous6/07/2006 11:18 AM

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

    ReplyDelete
  14. Dimitri Gielis6/07/2006 11:30 AM

    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.

    ReplyDelete
  15. Dimitri Gielis6/07/2006 4:32 PM

    There's also some info in the APEX forum on the Oracle site: http://forums.oracle.com/forums/thread.jspa?threadID=393208&tstart=0

    ReplyDelete
  16. Gleisson Henrique6/07/2006 5:42 PM

    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 !

    ReplyDelete
  17. Dimitri Gielis6/07/2006 6:36 PM

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

    ReplyDelete
  18. Anonymous6/07/2006 6:49 PM

    Hey Dimi,

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

    Heel mooi gemaakt trouwens...

    ReplyDelete
  19. Anonymous6/08/2006 11:16 AM

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

    ReplyDelete
  20. Joel R. Kallman6/08/2006 3:12 PM

    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.

    ReplyDelete
  21. Dimitri Gielis6/08/2006 3:25 PM

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

    ReplyDelete
  22. Anonymous6/09/2006 1:16 AM

    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!

    Thanks!

    ReplyDelete
  23. Dimitri Gielis6/09/2006 12:19 PM

    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)

    ReplyDelete
  24. Anonymous6/09/2006 2:18 PM

    Dimitri

    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

    ReplyDelete
  25. Dimitri Gielis6/09/2006 2:37 PM

    * 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!

    ReplyDelete
  26. Unknown1/12/2018 4:33 PM

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

    ReplyDelete