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
• Forum sidebar manager
• Ad management
• Continuous improvement and development
• and much more...

vbsoccer-mailing list

[nick-harper]

Looks like the page needs to be /vbsoccer.php?do=ranking&l=9&pagenumber=2 to work.

Or /vbsoccer.php?page=2&do=ranking&l=9

So it is just missing the & between 2 and do

[5starpool]

I'm getting an sql error on the rankings page for the English Premier League. It is ok for the other league I have set up on my forum.

Here is what my error is:

Database error in vBulletin 3.8.8:

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 `soccer_user_bet` b
INNER JOIN `soccer_match` m ON (m.`id`=b.`match_id`)
WHERE m.`league_id`=32 GROUP BY `match_day`, b.`userid`;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`dbname_dbforum`.`b`.`bet_home` - `dbname_dbforum`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Sunday, August 9th 2015 @ 10:51:44 AM
Error Date : Sunday, August 9th 2015 @ 10:51:44 AM
Script : http://www.myurl.com/forum/vbsoccer....enumber=1&l=32
Referrer : http://www.myurl.com/forum/vbsoccer....=35&do=ranking
IP Address : 109.79.231.253
Username : xxxx
Classname : vB_Database
MySQL Version : 5.6.23

Has anyone got any suggestions on how to fix this?

[motd2]

MySQL problem )

vbsoccer.php
find twice this code

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

replace twice this code

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

next
includes/functions_vbsoccer.php
find

CAST(bet_home - bet_away AS SIGNED)

replace

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

[Braddock]

I made the changes from #1569 but i am not able to update!
Any suggestions?

[motd2]

Originally Posted by Braddock

Any suggestions?

try to return

$vurl = new vB_vURL($this->registry);

[5starpool]

Originally Posted by motd2

MySQL problem )

vbsoccer.php
find twice this code

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

replace twice this code

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

next
includes/functions_vbsoccer.php
find

CAST(bet_home - bet_away AS SIGNED)

replace

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

Works a treat, thank you so much.

[TiKu]

Is there any way to make this add-on work with mobile style? All I get in mobile style is a blank page.

[johon]

Does anybody know if Euro League will be available?

[tekram]

No. I?ve send AA_ some Message but no Reply.

The European League will start today

[5starpool]

My results aren't updating any more in this. There are a couple of games recently that didn't get the result through, and now it hasn't updated data since Sep 14th, and pressing the 'get updated data' button doesn't update it.

Is there anyway to fix this that doesn't involve deleting and readding the league? I'm not sure if that would fix it either, but I don't want to lose entered results as there are competitions ongoing, but it's useless at the minute.