APEX

Hello,

That by far is the most important application I've seen APEX put to lately :)

only 9 more days to go ....... I can barley wait.


Carl

Hi Carl,

Happy you enjoy it... maybe an app for the wiki, apex studio or sourfourge?! ;-)
I suppose you're a VS supporter? Belgium isn't even qualified!

Dimitri

That's the ultimate killer application for Apex ;-)

But how do you know already first results ;-) ????

Regards

Alex

The number 1 app I've seen.
I've filled Englands scores in for you.

We should make it multi-lingual ;-)
I already created a translation page; http://htmldb.oracle.com/pls/otn/f?p=12318:204
Waiting for translation in English and German

Dimitri,

your script has at least an error

failed to parse SQL query:
ORA-00904: "M"."WROUND": invalid identifier

this column is not defined in the table

WC_MATCH

as far as I can see. Could you post the updated ddl script somehow? It is interesting - I will provide a link to my user to a copy of your application (got to be in English).

Denes Kubicek

Cool app. You may want to put some security on the ">> Update Score <<" link or someone may have some fun changing the results!!

Mike

I made this little application (partial) multi-lingual ;-)
The translation depends on the language settings of your browser.
(IE: Tools - Internet options - Language; Firefox: Tools - Advanced - Language)

The country names are dynamically taken. I created a new table and based my queries on a view. I translated the countries in Dutch, English, French and German.
In my query I've now where c.lang = <application item> where I store your language of the browser.

For Dutch I also made an XLIFF translation.
* The column names I couldn't translate?! Is this a bug or should it be a feature enhancement? *

-with translation: http://htmldb.oracle.com/pls/otn/f?p=12318:overview
-without translation: http://htmldb.oracle.com/pls/otn/f?p=12318:soverview

Denes,

I updated the zip-file on my blog with the latest version (the multi lingual page is also included)

Hope it works now,
Dimitri

The application is now available in following languages:
- Dutch (nl)
- English (en)
- French (fr)
- German (de)
- Simplified Chinese (zh-cn) - China
- Traditional Chinese (zh-tw) - Taiwan
- Japanese (ja)
(only the countries are translated)

Thanks to Robert Pang for the translations (zh-cn, zh-tw, ja) and the testing of the application... it took a while, but finally we managed to get it working!

:-)

To show the flags: grant execute on PROC_FLAG_DISPLAY to public

a colleague of mine made a similar application, but then you can bet on each game what the result will be, and it supports multiple users so the whole company can bet on it (and in the end see who has the most points).

ApEx sure has some good uses ;)

You're not the first who tells me the idea of betting ;-)
Some people of the customer I'm currently working for, already asked me if I couldn't add that. So if this already exists, I'm interested to see it... If you allow me, I'll integrate your code in the app.

* Only one thing, I don't allow betting for money! Betting for an Oracle T-shirts is a lot more fun ;-) *

Tell you what.....

If you can come up with a method where people can somehow bet and then accumulate points (i.e. so at the end of the World Cup we have a ranking of how many points people have got) then....

...I will throw in a Years Free Hosting as the prize of the person who scores the most points.

(Obviously I've left out the fine detail of how you work out how people score points ;)

Nice app ... really.

C.

New version available, see this topic in the forum 395208

Excellent app, with a nice look and feel. Betfair.com watch out !

1 suggestion is a search facility on the bet / game lists

Jules

Hi Jules,

You can already select the round and you will see only the games of that round...
You can also order the rows by column. I don't understand why you would like to have more search facilities. I changed a bit the layout, maybe now it's better on your screen?

Dimitri

The pictures of the stadia are also included in the application now.
Go to the webservices tab - at the end of the page you can select a stadium - if you do, you will see two pictures...
I would like to thank Jurgen Pirotte for sending the pictures to me.

Picky of me I guess, but I always tend to have a single free text search field in these type of report regions, where there are more than 10 or so rows. I guess it's only an issue in round 1, and I guess sorting by group would do that. Not a big deal unless you are going to extend the app for next years champions league ?

J

What I miss on that page is comments of users....

It's 5 o'clock in the morning in Belgium ... but as I'm staying in Washington (ODTUG) for the moment, it's "only" 11 o'clock... so I've still some time to have a look at it ;-)

Probably the application will become APEX Open Source on Source Forge, so you can adapt as you wish.

I'll have a look at what you're asking, as there're some others who mentioned that too.

I included the new feature...

Great application.

Why not use points divided by games predicted for the ranking?

This allows folks like me, who started late, to get a fairer shake?
Cheers.

Great Application.

I love the idea.
Its simple but to the point.

I added the P/G in the rank.