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

[jmm1]

Thanks for getting back to me, Force. As it turns out, I just needed to log out and log back in, lol. Silly me.

[ahlynews]

any chance you can add the Egyptian league ? there is no point to install it if you can't add the league want

[alex1962]

in vb 4.1.7 not install this module...
i upload all files in folder and install products in admin panel but when click start installation not work
error is truncated...."this product not........."
help me
alex

[alex1962]

Originally Posted by ForceHSS

are you installing the one in my sig?

yes ... if you want to pm i can give you the url and user administration

[K a M a L]

Is there a way to add another league ?
I visited the link you posted http://groups.google.com/group/vbsoccer_ and I couldn't find a start point

[lolly01]

How can i change the Usernames in Ranglist in HTML Markup.

I will the Ranglist User in the Usergrup Colors.

Has anyone an idea?

[PSV-Forum]

Originally Posted by ForceHSS

ranglist? you will need to explain that

My guess would be he means 'list' (Dutch is 'ranglijst').
Second guess would be he means 'want' instead of 'will'.
Still guessing though...

[nick-harper]

I am starting to get a lot of these :

SELECT `userid`, '' AS `username`, `bets`, `wr`, `rd`, (`bets`-`wr`-`rr`-`rd`) AS `rw`, `rr`,
			(`wr`*0)+
			(`rr`*3)+
			(`rd`*2)+
			((`bets`-`wr`-`rr`-`rd`)*1) AS `sum_pts`,
			((`wr`/`bets`)*0)+
			((`rr`/`bets`)*3)+
			((`rd`/`bets`)*2)+
			(((`bets`-`wr`-`rr`-`rd`)/`bets`)*1) AS `avg_pts`
		FROM
		(
			SELECT b.`userid`, COUNT(*) AS `bets`,
				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 `vb_soccer_user_bet` AS b
			INNER JOIN `vb_soccer_match` AS m ON (m.`id`=b.`match_id`)
			WHERE `dateline` BETWEEN 1320105600 AND 1322697600 AND `score_key`>0
			GROUP BY b.`userid`
		) AS `foo`
		ORDER BY sum_pts desc , avg_pts desc
		LIMIT 0, 30;

MySQL Error   : BIGINT UNSIGNED value is out of range in '(`forum`.`b`.`bet_home` - `forum`.`b`.`bet_away`)'

[nick-harper]

IT is happening with every user. I have just upgraded mySQL and it has happened since then.

[tidus78]

Advances are no longer in my league and when i click for update data I've this error :

Database error in vBulletin 4.1.8:

Invalid SQL:

			SELECT t.`sd_id`, t.`id`, t.`sd_homepage`, t.`sd_shortname`, lt.`points`, lt.league_id, lt.`ingroup`, phrase.text AS masterphrase
			FROM `soccer_team` AS t
			LEFT JOIN `soccer_league_team` AS lt ON (lt.`team_id`=t.`id` AND lt.league_id=7)
			LEFT JOIN `phrase` AS phrase ON(phrase.`languageid`=0 AND phrase.`fieldname`='vbsoccernames' AND varname=CONCAT('soccer_team_', t.sd_id))
			WHERE t.`sd_id` IN(137,139,155,161,218,219,225,226,227,228,229,230,231,232,234,237,238,366,669,732);

MySQL Error   : Unknown column 'lt.ingroup' in 'field list'
Error Number  : 1054
Request Date  : Friday, November 25th 2011 @ 08:04:41 PM
Error Date    : Friday, November 25th 2011 @ 08:04:43 PM
Script        : http://www.console-planet.it/vbsoccer.php?do=sdupdate&l=7&redo=schedule
Referrer      : http://www.console-planet.it/vbsoccer.php
IP Address    : 93.38.78.2
Username      : Tidus
Classname     : vB_Database
MySQL Version : 5.0.92-enterprise-gpl-log

http://www.console-planet.it/vbsoccer.php