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 fco.sepulveda

You can add an own league?

No mate just the 20 or so that are setup for the mod

[madddenaddicto]

I got the points working correctly.
It was my mistake.
The spanish league is working fine.

I had it this way.

1 point for guessin the winner.
2 points for guessing the exact score.

Now, I have it this way.

1 point for guessing the winner.
1 point for guessing the winner with the goal diferential.
2 points for guessing the exact score.

AA> This mod is by the best mod out there.
You should charge per league download and add a few paid features to make it even better.

Thank you for this mod once again.
If you ever need any help, let me know.
I speak spanish and english.

[madddenaddicto]

Originally Posted by fco.sepulveda

You can add an own league?

In the near future, they will add more leagues.

[AA_]

Originally Posted by ProFifaLeagues

No mate just the 20 or so that are setup for the mod

+---------+-----------+
| leagues | saison    |
+---------+-----------+
|       2 | 1999/2000 |
|       2 | 2000/2001 |
|       2 | 2001/2002 |
|       3 | 2002/2003 |
|       2 | 2003/2004 |
|       2 | 2004/2005 |
|       2 | 2005/2006 |
|       3 | 2006/2007 |
|       5 | 2007/2008 |
|      12 | 2008/2009 |
|      25 | 2009/2010 |
|      35 | 2010/2011 |
|      28 | 2011/2012 |
|      33 | 2012/2013 |
+---------+-----------+

[madddenaddicto]

Awesome work.

[Yshuya]

Hello,

I have a problem with the module. Sql error to display result.
I do not understand very well the query.

Maybe someone has already met this problem and knows the solution.

Database error in vBulletin 4.2.0:

Invalid SQL:

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 `vbsoccer_user_bet` AS b
INNER JOIN `vbsoccer_match` AS m ON (m.`id`=b.`match_id`)
WHERE `dateline` BETWEEN 1343779200 AND 1346457600 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`)'
Error Number : 1690

[AA_]

Originally Posted by Yshuya

Hello,

I have a problem with the module. Sql error to display result.
I do not understand very well the query.

Maybe someone has already met this problem and knows the solution.

fixed in 1.4.25 RC6

[Yshuya]

Ok thanks.

[madddenaddicto]

I have this problem.
It only happens on this page.

http://www.iplayfifa.com/vbsoccer.php?do=overallranking

Warning: DateTime::modify() [datetime.modify]: Failed to parse time string (+-4.5 HOURS) at position 0 (+): Unexpected character in [path]/vbsoccer.php on line 3443

Please help.

[AA_]

Originally Posted by madddenaddicto

I have this problem.
It only happens on this page.

http://www.iplayfifa.com/vbsoccer.php?do=overallranking

Warning: DateTime::modify() [datetime.modify]: Failed to parse time string (+-4.5 HOURS) at position 0 (+): Unexpected character in [path]/vbsoccer.php on line 3443

Please help.

search in vbsoccer.php:

$dt->modify('+' . $vbulletin->userinfo['timezoneoffset'] . ' HOURS');

replace with:

$dt->modify(sprintf('%+d minutes', $vbulletin->userinfo['timezoneoffset'] * 60));