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

[ProFifaLeagues]

Originally Posted by MattGarner

The one from the signature? Yeah. Do you know if you use MySQL 5.5 or not? I think 5.5 may cause these issues somehow.

Could be the problem as we use
MySQL Version 5.0.95

[huuquynh]

Me too. MySQL Version : 5.5.15.

Both ranking and overallranking.

[Antonio Pereira]

Football Betting Game 1.4.25RC1 Version
Vbulletin vBulletin 4.1.12 Patch Level 2
vBSEO 3.6.0 PL2

Hi find a strange bug with the navigation page ranking, affect:
overallranking
ranking

Wen i have more than 100 users the page force to click in page 2 to see next players points like this:

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

give error

but wen i submit option "go to page" and insert "2" goes to the correct url

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

Any solution for this?

Best regards

[artcrimes]

this is fantastic! thank you!

[fortforum]

I get an issue in navbar, where the plugg overwrites new posts with something. Not nice.

Appart from that it seems to be working just fine on 4.2.

Running mysql 5.0.51a-24+lenny5-log

[Gn_Snake]

Football Betting Game 1.4.25RC1 Version
Vbulletin vBulletin 4.1.12 Patch Level 2
vBSEO 3.6.0 PL2

I've uninstalled and reinstalled the product some time ago, continues to give me problems mysql:

Database error in vBulletin 4.1.12:

Invalid SQL:

			SELECT (_wr * 0) +
			((_count - _wr - _rr - _rd) * 1) +
			(_rd * 2) +
			(_rr * 3) AS points
			FROM (
				SELECT userid, COUNT(*) AS _count,
				SUM(score_key != bet_score_key) AS _wr,
				SUM(bet_home=points_home AND bet_away=points_away) AS _rr,
				SUM(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 HG_soccer_user_bet AS b
			INNER JOIN HG_soccer_match AS m ON(m.id=b.match_id)
			WHERE userid=1 AND score_key>0 AND match_is_finished=1
			GROUP BY userid) AS userpoints;

MySQL Error   : BIGINT UNSIGNED value is out of range in '(`hardware_Hardwaregame`.`b`.`bet_home` - `hardware_Hardwaregame`.`b`.`bet_away`)'
Error Number  : 1690
Request Date  : Tuesday, June 12th 2012 @ 01:50:09 PM
Error Date    : Tuesday, June 12th 2012 @ 01:50:09 PM

What's?? Help please

[madddenaddicto]

I installed it about a month ago and never had any problems.
I have the lastest vbulletin.
I only have 21 users and we dot use the forums.

For La Liga I plan to have over 200 users.

[fortforum]

I get this stupid overlay and it kinda drives me nuts. I can?t figure out how to get rid of it. Appart from this, it works great.


http://www.2shared.com/photo/3i5GA_z2/screen.html

[Gn_Snake]

And how to stop it?

[W!cKeD]

Originally Posted by Gn_Snake

And how to stop it?

Search in vbsoccer.php the query and put this =>

PHP Code:

$vbulletin->db->query_read("
    SET sql_mode='NO_UNSIGNED_SUBTRACTION';
        "); 


befor the query.