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
Need some help with a recent SQL Error since I upgraded to vB 4.1.12 recently (from 4.1.6).
I also upgraded to the version of vbSoccer in ForceHSS's sig
The error I get when the vbSoccer Update (vbsoccer_fixtures.php) cron task runs...
Code:
Invalid SQL:
SELECT (_wr * 0) +
((_count - _wr - _rr - _rd) * 1) +
(_rd * 1) +
(_rr * 2) 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 vb_soccer_user_bet AS b
INNER JOIN vb_soccer_match AS m ON(m.id=b.match_id)
WHERE userid=3 AND score_key>0 AND match_is_finished=1
AND b.dateline > 315532800
AND m.dateline > 315532800
GROUP BY userid) AS userpoints;
MySQL Error : Unknown column 'b.dateline' in 'where clause'
The error is clear - table b, i.e. vb_soccer_user_bet, does not contain a dateline column.
Just not sure though how this SQL is being created. I thought I had narrowed down the SQL to the construct_saison_rankings() function in functions_vbsoccer.php but alas it's not the same SQL statement.
In fact I can't find where this gets created at all.
I've tried importing the product again - but no dice..
Problem I have is that the current season is in progress so I don't want to uninstall and lose all the information.
Any help in tracking down the root cause of this greatly appreciated.
TIA
Found the problem..
My bad - wasn't the vbsoccer at all - was the plugin for vbExperience for vbSoccer points...
Guessing those scripts aren't being maintained either...
Sorted now.
Not a soccer fan nor many soccer fans on my site but if this were available for NFL, NBA, MLB, NHL and NCAA, this would be the greatest sports mod ever invented.