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
AA_ is there a way to add our desired leagues manual?
I mean some times we need a league that don't have a lot of fans here, so is there away to add it to our site only? please give us the instruction to add our leagues .
Thanks.
no, this is not possible.
a (local) manual intervention makes the application/database incompatible with future seasons.
at a reasonable expense compensation I may also add exotic events/leagues (if they are compatible with the mod).
I can make an extra donation for the league of Venezuela.
Let me know if its compatible with your mod.
I can also make an extra donation for this https://vborg.vbsupport.ru/attachmen...1&d=1268350495 but on the vbulletin publishing suite.
Database error in vBulletin 4.1.8:
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 `soccer_user_bet` AS b
INNER JOIN `soccer_match` AS m ON (m.`id`=b.`match_id`)
WHERE `dateline` BETWEEN 1341100800 AND 1343779200 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 '(`database name`.`b`.`bet_home` - `database name`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Saturday, July 21st 2012 @ 12:13:49 PM
Error Date : Saturday, July 21st 2012 @ 12:13:49 PM
Script : http://*******/vbsoccer.php?do=overallranking
Referrer : http://******/vbsoccer.php
IP Address : ******
Username : *****
Classname : vB_Database
MySQL Version : 5.6.4-m7
Hello, i got the same problem like abieteh.com
Tipped Russian Leaque, everything works fine. After game result update from Soccerserv, i got the database Error on ranking on season and total Rankings.