Version: 1.4.25, by AA_
Developer Last Online: Aug 2013
Category: Integration with vBulletin -
Version: 4.0.3
Rating:
Released: 03-10-2010
Last Update: 08-29-2012
Installs: 446
DB Changes Uses Plugins
Additional Files Is in Beta Stage
No support by the author.
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
These errors have been starting on certain parts of the plugin:
Quote:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT
b.`userid`, DATE_FORMAT(FROM_UNIXTIME(m.`dateline`), '%Y%m%d') AS `mdate`, `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`=1 GROUP BY DATE_FORMAT(FROM_UNIXTIME(m.`dateline`), '%Y%m%d'), b.`userid`;
MySQL Error : BIGINT UNSIGNED value is out of range in '(`habboxfo_forumhx`.`b`.`bet_home` - `habboxfo_forumhx`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Friday, June 8th 2012 @ 05:30:51 PM
Error Date : Friday, June 8th 2012 @ 05:30:51 PM
Script : http://www.habboxforum.com/vbsoccer....anking&l=1&m=2
Referrer : http://www.habboxforum.com/vbsoccer.php?do=tab&l=1&m=2
Classname : vB_Database
MySQL Version : 5.5.24-cll
From what I have read in this thread, it's related if a user has entered too much of a high bid in one of the predictions. A user did have the number 45 in two of his predictions and I have removed them to see if it was the problem. The error still exists, anyone else had problems with vb 4.2 and MySQL 5.5? I know the plugin isn't fully supported but it was working before any of the matches started.