Add-On Releases - European Cup 2008 Bet Game

Works for vBulletin 3.6.x too!

Description:

This modification is a Addon for the European Cup 2008. You can bet and win with it, see screens.

Functions:

• TV channel, Date / Time / Games you can change in the AdminCP
• Roster you can edit in the AdminCP
• View you can edit in the AdminCP
• Information for unauthorized Users you can change in the AdminCP
• Bets per page adjustable
• Countrie Flags enable/disable
• Bets of all members you can see ( THX @Tal )
• Moderators can edit the results
  

Install:

--> Read the installation.txt in the zip archiv.

Update:

Import only the product xml again and set overwrite "yes".

The coder of the Hack is Tyran, i?m only the translator!

Note: In this Hack are two TV channels, which called "ARD" and "ZDF". I can?t edit this for every country, you can do it in the database or in the xml file before installation.

Special Thanks to:

Mr.Zeropage (fixed security bugs), Janka, J?rn & entertain

And last but not least:

My english isn?t perfect, but i think the most phrases are correctly. Please post translation bugs or other forgotten things. We have time until sunday.

Please click install to support the coder of this great modification!

Update - 16.06.08 - Bug Fix (Table calculation)

Please overwrite your EM2008.php in the root folder with the new file in the zip archiv!

[weedheaven]

This is a very nice addon! My users like it, and i got no problems with timezone's (live in the netherlands) europe time

[Rat1972]

same for me if that addon is made, i give also a donation

[GaiLoan]

thanks for the great mod, "install"

[socalrico]

[QUOTE=mcyates;1542462]Thank you, installed [QUOTE]

Love it! Greatmnod! Thanks!

[fulviods]

perfect!! thanks!

[M-Tuning]

Which table was wrong?

As I have translated EM2008.php

[PiTXI]

Originally Posted by M-Tuning

Which table was wrong?

As I have translated EM2008.php

me too

[Fraxter]

No sql table, the group table calculation (A-D) was wrong. Take a look into your tables and you will see that for example switzerland before czech is display (thats wrong).

If you have translated your em2008.php file, you can change it manuell with this:

Find:

PHP Code:

$sql = "SELECT t.name, t.shortname, t.groupname, gs.match_played, gs.won, 
                    gs.drawn, gs.lost, gs.goal_plus, gs.goal_minus, gs.goal_diff, gs.points 
                    FROM " . TABLE_PREFIX . "rth_em08_teams AS t 
                    LEFT JOIN " . TABLE_PREFIX . "rth_em08_group_scores AS gs ON ( t.team_id = gs.team_id ) 
                    ORDER BY t.groupname, gs.points DESC, gs.goal_diff DESC, gs.goal_plus DESC"; 


Replace with:

PHP Code:

$sql = "SELECT t.name, t.shortname, t.groupname, gs.match_played, gs.won, 
                    gs.drawn, gs.lost, gs.goal_plus, gs.goal_minus, gs.goal_diff, gs.points 
                    FROM " . TABLE_PREFIX . "rth_em08_teams AS t 
                    LEFT JOIN " . TABLE_PREFIX . "rth_em08_group_scores AS gs ON ( t.team_id = gs.team_id ) 
                    ORDER BY t.groupname, gs.points DESC, gs.goal_plus DESC, gs.goal_minus ASC"; 


That?s all. Only a little sql query bug.

best regards

Pander23

[M-Tuning]

thanks

[Bobbrown]

Has been working on my site since day 1 but now I can not select the next stages (quarters,semis,final)
The drop down list has never hyperlinked to the desired places.
Any fixes please.