Integration with vBulletin - Soccer Betting Game ("Fussball-Tippspiele")

More than 20 soccer leagues and competitions in a single Bet!

FEATURES

• No results input by administrators or moderators!
  Results and fixtures come from our own data service
• Configurable scoring
• Season archives with all schedules, tips and points
• League tables, crosstabs, group tables
• Configurable Match Preview (Next x Days)
• Rankings
• Hall of Fame of the best 3 tipsters from all competitions and seasons
• Result entry by user
  Users can also report results for current games themselves. These results will be reported to the data service, which these other forums is directly available. Distributed reporting game results!
• E-mail reminder
• Users can even select it to see what competitions
• Users can determine the color of the points themselves
• Modification or translation of any team name and the name of competition
• Configurable menu grouping for Competitions
• Details of fixtures
• Interface to report false results or fixtures in our data service
• Show the tips of other users
• Optional integration of club logos and association logos
• Available in multiple languages and character encodings
• Continuous improvement and development
• and much more...

vbsoccer-mailing list

[burak61]

Why it is not updating the results ?

[kailew]

Hi,

I'm getting a SQL Error:

----------------------
Datenbankfehler in vBulletin 3.8.6:

Invalid SQL:

SELECT
b.`userid`, `match_day`,
COUNT(*) AS `bets`,
SUM(`score_key`>0) AS 'evaluated',
SUM(`score_key`>0 AND `score_key` != `bet_score_key`) AS 'wr',
SUM(`score_key`>0 AND `bet_home`=`points_home` AND `bet_away`=`points_away`) AS 'rr',
SUM(`score_key`>0 AND CAST(`bet_home`-`bet_away` AS SIGNED)=(`points_home`-`points_away`) AND NOT (`bet_home`=`points_home` AND `bet_away`=`points_away`)) AS 'rd'
FROM `pfosoccer_user_bet` b
INNER JOIN `pfosoccer_match` m ON (m.`id`=b.`match_id`)
WHERE m.`league_id`=12 GROUP BY `match_day`, b.`userid`;

MySQL-Fehler : BIGINT UNSIGNED value is out of range in '(`dbxxxxx_xx`.`b`.`bet_home` - `dbxxxxx_xx`.`b`.`bet_away`)'
Fehler-Nr. : 1690
Fehler-Zeit : Friday, 01.02.2013 @ 10:00:57
Datum : Friday, 01.02.2013 @ 10:00:57
Skript : http://www.myforum.org/vbsoccer.php?do=ranking
Referrer : http://www.myforum.org/vbsoccer.php?do=live
IP-Adresse : 91.xx.xxx.xx
Benutzername : xxx
Klassenname : vB_Database
MySQL-Version : 5.5.28-log
-----------------------------------

Any ideas?

Kai

[eazygreek]

can you please add a greek superleague league?

[Robert9]

Find in vbsoccer.php two times:

CAST(`bet_home`-`bet_away` AS SIGNED)

and replace it with

CAST(`bet_home` AS SIGNED) - CAST(`bet_away` AS SIGNED)

[Pladimir]

Is there no more update for the current 2015 / 2016 season?

[digif]

Is this still working?

[cheech47]

It was for me until last week, getting an access denied message when trying to get scores updated and in the diagnostics but cant see any other error message to give me a hint why

[Butzel]

wird die Europa-Liga nicht mehr angeboten ? Bis dato kann man sie leider nicht einpflegen.
Danke für einen Hinweis.

[ArcadeSyndicate]

hello butzel, the server seems to be offline...

http://www.vbulletin-germany.org/sho...4748#post84748

or take a look at the vb4 thread for this mod.

[Butzel]

Danke f?r die Info.
Das waere sehr schade um das Soccer-Game