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
Hi there, is it possible to change the score for specific games? The results are not wrong but since the time/date were wrong some users misused and entered the scores after the actual game has been completed and I want to invalidate those matches for the competition, many thanks.
--------------------------- IGNORE THIS _ FIXED IT!!!!!!!!!!!! -------------------------
Can anyone help me out here?
I'm getting a database error when I try to access the season rankings at:
/vbsoccer.php?do=ranking
Code:
Database error in vBulletin 4.2.0:
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 (`bet_home`-`bet_away`)=(`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 `match_day`, b.`userid`;
MySQL Error : BIGINT UNSIGNED value is out of range in '(`*********`.`b`.`bet_home` - `*********`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Tuesday, November 27th 2012 @ 04:46:57 PM
Error Date : Tuesday, November 27th 2012 @ 04:46:57 PM
Script : http://www.*********/vbsoccer.php?do=ranking
Referrer : http://www.*********/vbsoccer.php?do=live
-------------------------------------------------
Anyone any ideas?
--------------------------- IGNORE THIS _ FIXED IT!!!!!!!!!!!! -------------------------