PDA

View Full Version : Integration with vBulletin - Soccer Betting Game ("Fussball-Tippspiele")


Pages : 1 2 3 4 5 [6] 7

jmm1
10-11-2011, 08:51 PM
Thanks for getting back to me, Force. As it turns out, I just needed to log out and log back in, lol. Silly me.

ahlynews
10-13-2011, 08:39 PM
any chance you can add the Egyptian league ? there is no point to install it if you can't add the league want

alex1962
10-28-2011, 07:49 AM
in vb 4.1.7 not install this module...
i upload all files in folder and install products in admin panel but when click start installation not work
error is truncated...."this product not........."
help me
alex

alex1962
10-28-2011, 01:24 PM
are you installing the one in my sig?

yes ... if you want to pm i can give you the url and user administration

K a M a L
11-03-2011, 01:12 AM
Is there a way to add another league ?
I visited the link you posted http://groups.google.com/group/vbsoccer_ and I couldn't find a start point

lolly01
11-05-2011, 01:39 AM
How can i change the Usernames in Ranglist in HTML Markup.

I will the Ranglist User in the Usergrup Colors.

Has anyone an idea?

PSV-Forum
11-06-2011, 09:34 AM
ranglist? you will need to explain that

My guess would be he means 'list' (Dutch is 'ranglijst').
Second guess would be he means 'want' instead of 'will'.
Still guessing though...:)

nick-harper
11-20-2011, 12:37 AM
I am starting to get a lot of these :

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 `vb_soccer_user_bet` AS b
INNER JOIN `vb_soccer_match` AS m ON (m.`id`=b.`match_id`)
WHERE `dateline` BETWEEN 1320105600 AND 1322697600 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`)'

nick-harper
11-22-2011, 08:09 AM
IT is happening with every user. I have just upgraded mySQL and it has happened since then.

tidus78
11-25-2011, 06:05 PM
Advances are no longer in my league and when i click for update data I've this error :

Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT t.`sd_id`, t.`id`, t.`sd_homepage`, t.`sd_shortname`, lt.`points`, lt.league_id, lt.`ingroup`, phrase.text AS masterphrase
FROM `soccer_team` AS t
LEFT JOIN `soccer_league_team` AS lt ON (lt.`team_id`=t.`id` AND lt.league_id=7)
LEFT JOIN `phrase` AS phrase ON(phrase.`languageid`=0 AND phrase.`fieldname`='vbsoccernames' AND varname=CONCAT('soccer_team_', t.sd_id))
WHERE t.`sd_id` IN(137,139,155,161,218,219,225,226,227,228,229,230 ,231,232,234,237,238,366,669,732);

MySQL Error : Unknown column 'lt.ingroup' in 'field list'
Error Number : 1054
Request Date : Friday, November 25th 2011 @ 08:04:41 PM
Error Date : Friday, November 25th 2011 @ 08:04:43 PM
Script : http://www.console-planet.it/vbsoccer.php?do=sdupdate&l=7&redo=schedule
Referrer : http://www.console-planet.it/vbsoccer.php
IP Address : 93.38.78.2
Username : Tidus
Classname : vB_Database
MySQL Version : 5.0.92-enterprise-gpl-log

http://www.console-planet.it/vbsoccer.php

tidus78
11-25-2011, 08:56 PM
How can I modify the table?

Meizu
11-25-2011, 09:30 PM
How can use it with vBCredits. If it's great.

tidus78
11-26-2011, 03:59 PM
in your admin panel scroll down to Maintenance/Execute SQL Query in the Manual Query box put that in and click continue on the next page click continue again

It tells me I have not permissions but I'm the founder :(

tidus78
11-26-2011, 05:16 PM
Edit

Mission complete thanks ForceHSS

Ocean-Wonders
11-27-2011, 12:12 PM
Can anyone tell me how i get this to install on 4.1.8 ? Just getting a message telling me it's incompatible ?

cheers

Ocean-Wonders
11-27-2011, 05:45 PM
use the one in my sig

Thanks very much :) appreciated !

fourat
11-30-2011, 12:13 AM
GREAT MOD thank you
I have some questions
-How i disable the bets .. i want to show the results and fixtures only
-I try to show the ranking in the sidebar in my forum .. But it is not appear !!
-Is there an option to view the scorers in the tournament ?
- Can I add the Spanish King's Cup (copa del rey) ?

fourat
11-30-2011, 03:53 AM
2) Forums & Moderators/Forum Blocks Manager/Add Block pick football betting from the list

I do that but the its not appear ! my vb 4.1.7
3) Options/football betting/View other users bets/show all bets in the drop down menu

the scorers not appear

thank you

ArtakEVN
11-30-2011, 02:43 PM
There is a BIG problem with Russian premier league. Until this season there was 30 matchdays in season. Now(2011) there are 45. But on my forum it stops after 30-rd mathday. How to update league data??

fourat
12-01-2011, 01:13 AM
the sidebar enabled but the ranking not appear

nick-harper
12-01-2011, 08:01 AM
one or more of your members is trying to input to high of bet

That is just when I go to view the table rather than placing a bet. Placing a bet is fine, but it is when I go to view rankings it gives these errors.

How would I find the data causing this issue?

stb74
12-02-2011, 02:39 PM
ask here
http://groups.google.com/group/vbsoccer_

build your own here
http://code.google.com/p/vbsoccer/source/checkout
http://vbsoccer.googlecode.com/svn/vb4/


Are there any instructions on how to build your own leagues.

ArtakEVN
12-05-2011, 05:40 PM
Hi, Can anyone help me with Russian Premier League? Where can I find the project homepage to report them about mistake ?

ArtakEVN
12-05-2011, 07:10 PM
:) Thank You. But I need something else. There is Russian Premier League in vbsoccer. Season 2011/12. But it is absolutely wrong. The real season includes 45 matchdays not 30 as presented in vbsoccer. I want to ask authors to update it.

ArtakEVN
12-06-2011, 03:03 PM
And where is that paid section ?
Oh I see. But What I need is a bit differente, again :) I can update league information in my DB. But will it update match results ? Where from it gets match results ?

Bluefin221
12-16-2011, 05:31 PM
Thanks again. I don't like "Football Betting" title though, I'd rather if was called Prediction League. Where do I change the name it put on my navbar/quick links section?

I'd also like to do this but having searched all the phrases and changing them to Prediction League nothing is happening.

Bluefin221
12-20-2011, 09:36 AM
Does anyone know where to change the navbar title?

blue6995
12-20-2011, 01:33 PM
Does anyone know where to change the navbar title?

Search for it in the Phrase Manager - The varname is vbsoccer_navtab_title

vbsoccer_navtab_title English (US) Translation Fussball

Bluefin221
12-20-2011, 02:44 PM
Search for it in the Phrase Manager - The varname is vbsoccer_navtab_title

vbsoccer_navtab_title English (US) Translation Fussball

Thank you, I couldn't find that anywhere.

@ForceHSS - That throws up an error on 4.1.8 on the top of the screen.

blue6995
12-20-2011, 04:03 PM
Thank you, I couldn't find that anywhere.

@ForceHSS - That throws up an error on 4.1.8 on the top of the screen.

In the ACP Options find the Fussball-Tippspiele menu, click Options and scroll to bottom where you will find Show Button in the Navbar?

Choose the 'template_hook'-position here when the betting game is to be displayed as a navigation button. The text for this button can be changed with the phrase vbsoccer_navtab_title.

That is a link to where you can change text

Bluefin221
12-22-2011, 05:58 PM
then you have some other problem with your files as i or others have not got this problem a screenshot of the problem would help

Its a template issue, I have a heavily customised template.

gazzak
02-06-2012, 08:06 AM
Is this still running? My own league table isn't updating since January 11th??

johon
02-24-2012, 11:05 AM
Any way to delete the bug that in Europe Leauge and Champions League no draws are valid?
Obviously a draw is also a valid result in the KO round, because its always the aggregate of 2 games.....

prandah
02-29-2012, 03:47 PM
there is no way with vb 4.1.10 ?

stemmy
03-14-2012, 11:47 AM
I currently have a competition running on my forum. If I upgrade to the 1.4.25 version will this delete all the members and their scores from the current competition ???

Gn_Snake
03-29-2012, 11:28 AM
Hi,
receive this error when user view the page Soccer betting

Invalid SQL:

SELECT (_wr * 0) +
((_count - _wr - _rr - _rd) * 1) +
(_rd * 2) +
(_rr * 3) 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 HG_soccer_user_bet AS b
INNER JOIN HG_soccer_match AS m ON(m.id=b.match_id)
WHERE userid=1 AND score_key>0 AND match_is_finished=1
GROUP BY userid) AS userpoints;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`hardware_Hardwaregame`.`b`.`bet_home` - `hardware_Hardwaregame`.`b`.`bet_away`)'
Error Number : 1690

Help me
thx

Gn_Snake
03-29-2012, 11:40 AM
Thanks ForceHSS for support,
but because the one from your sig and not the download?

Gn_Snake
03-29-2012, 01:11 PM
Sorry,
wondering why use the plugin in your signature and not available in the download?

Merenguista
04-09-2012, 11:22 AM
Is there a way to add it in CMS (by widget) like sidebar block ?

betts02
04-09-2012, 02:05 PM
Does this work or what ?
Running latest version of vB

Merenguista
04-11-2012, 01:16 PM
there is a way to integrate it in cms widget ?

Baghira
04-12-2012, 04:40 AM
This works on 4.1.12 and it is in my sig as the owner no longer updates it

Is there a trick to let it run like it has to?
I run 4.1.12 and when I try to install, I get a message that this addon is for vb until 4.06

scaramanga
04-12-2012, 12:15 PM
Fantastic mod, this is really useful for my forum.

I've added the English Premier League, but the match dates are all wrong. Anyone else having this problem?

betts02
04-12-2012, 05:27 PM
Is there any chance to show the FA Cup ?

Also on mine i have 4 games that have no times and the dates saying they play tomorrow when in fact they play on may 2nd

scaramanga
04-13-2012, 09:24 AM
Is there any chance to show the FA Cup ?

Also on mine i have 4 games that have no times and the dates saying they play tomorrow when in fact they play on may 2nd

That seems to be the issue I'm having - it's the matches that have been rearranged due to this weekend's FA Cup, they're all marked as being today.

NickyNet
04-24-2012, 08:18 AM
This works on 4.1.12 and it is in my sig as the owner no longer updates it


Hi ForceHSS, can you please explain what was updated in your release?
Thank you!

DemoniK_AK
04-26-2012, 04:31 AM
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...
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

DemoniK_AK
04-28-2012, 01:43 PM
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.

ScarlosSantana
04-28-2012, 03:36 PM
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.

nick-harper
04-30-2012, 07:42 PM
Is it possible to request a league? If not, is there a way to add one manually where we can add in the results?

NickyNet
05-04-2012, 07:04 AM
Is it possible to request a league? If not, is there a way to add one manually where we can add in the results?

as developer is not more active.. it think new leagues will be ignored.
to your 2nd question: no, it is not possible.

ProFifaLeagues
05-15-2012, 02:25 PM
Is it possible to request a league? If not, is there a way to add one manually where we can add in the results?



Euro 2012 Just been added to the system so there may be a chance of getting others still mate!

Worth checking there Group on Google and also there twitter :up:

Deriel
05-16-2012, 11:57 AM
Please, could we have the Campeonato Brasileiro 2012 Primeira e Segunda Divis?o (Brazilian Championship - First and Second Divisions??). Pretty please? :D

pipibunny
05-21-2012, 06:42 AM
I have a trick to install this mod on vBulletin 4.1.12 but I'm not sure if they have any errors in the future.

You open file "product-vbsoccer-en-utf-8.xml" by notepad or notepad++

Search and delete this row "<dependency dependencytype="vbulletin" minversion="4.0.2" maxversion="4.1.12"/>"

After, ACP > Plugin > and install it.

Right now, it work to me but future I'm not sure.

W!cKeD
05-21-2012, 09:39 AM
The Style in vBulletin 4.1.12 is messed up, please update to 4.1.12 - thanks

madddenaddicto
05-22-2012, 03:45 PM
I have vbulleting Version 4.1.12! does this mod work with my version yes or no?

W!cKeD
05-23-2012, 07:51 AM
Should work but if you not sure put up test forums if you need to test first
But use the one in my sig

I use this one from your Sig, but the same bug with style, it messed up, tables and cells not right.

W!cKeD
05-24-2012, 05:27 AM
Then you need to fix your style as it is not this plugin doing it

on vBulletin 4.1.12 Standard-Style?

Gn_Snake
05-24-2012, 09:10 PM
Where is the block forum?
I do not know what code to put in the block forum

gazza2008
05-27-2012, 08:56 PM
is there gonna be anything for the euro 2012 at all

Tony_FPM
05-28-2012, 09:23 AM
I need it for 4.2!!

Pleaseeeee

NickyNet
05-28-2012, 11:10 AM
I need it for 4.2!!

Pleaseeeee

working fine with 4.2.0..

just open: product-vbsoccer-en-XXXXX.xml

and change to
<dependency dependencytype="vbulletin" minversion="4.0.2" maxversion="4.99.99"/>"

madddenaddicto
05-28-2012, 11:24 AM
is there gonna be anything for the euro 2012 at all

Its already out bro.
I have it.

Tony_FPM
05-28-2012, 11:31 AM
The one in my sig already does that

Thanks! Worked indeed.
Now i need to find the Button because we have a complete customized menu.
I will try to find it but if somebody has the url name to the soccer page i would be thankfull.

Tony_FPM
05-28-2012, 11:32 AM
Thanks! Worked indeed.
Now i need to find the Button because we have a complete customized menu.
I will try to find it but if somebody has the url name to the soccer page i would be thankfull.

Found it!

Tony_FPM
05-28-2012, 11:42 AM
is there gonna be anything for the euro 2012 at all

In ACP scroll down and find the options on the left side.
Import the EURO 2012 over there.

MSALEH
05-30-2012, 07:43 PM
Thanks to the product
Is it possible to add a league
For example, the league is not supported in the product like African competitions

MattGarner
06-05-2012, 12:21 PM
Was there flags ever added to the Euro 2012 league?

DoDe
06-06-2012, 12:13 PM
Hi all,

When the betting is not allowed any more for a match? Just before the match starts? Because I see right now for the euro matches that I can change the submitted score any time I want.

Regards!

vcoderzdotcom
06-06-2012, 07:28 PM
does it work on vbulletin 3.8.7?

Gemma
06-07-2012, 04:02 PM
does it work on vbulletin 3.8.7?

https://vborg.vbsupport.ru/showthread.php?t=237934

fortforum
06-08-2012, 01:30 PM
Trying this but it just gives me this:

"The Maintenance Service doesn't respond or is not available yet. Please try it later again.
"

Is this service discontinued?

MattGarner
06-08-2012, 03:31 PM
These errors have been starting on certain parts of the plugin:

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.php?do=ranking&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

Anyone have any idea?

MattGarner
06-08-2012, 03:35 PM
no support for vb version you are running as it has not been tested on that version yet

It was working fine before any matches started but ok :P

MattGarner
06-08-2012, 05:20 PM
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.

Gn_Snake
06-08-2012, 08:15 PM
Hi for all,
in the ACP do not have the Euro 2012 championship, how?

ProFifaLeagues
06-08-2012, 08:28 PM
Confirm its been working fine for us on 4.2 even after todays games have been updated and the scores confirmed....

MattGarner
06-08-2012, 08:29 PM
Confirm its been working fine for us on 4.2 even after todays games have been updated and the scores confirmed....

Including the rankings?

ProFifaLeagues
06-08-2012, 09:24 PM
Including the rankings?



Yes just doubled Checked them now and all A1.

We are only running the euros at present Not sure if it would matter any?

Are you using the Fixed Version which was posted?

MattGarner
06-08-2012, 09:49 PM
Yes just doubled Checked them now and all A1.

We are only running the euros at present Not sure if it would matter any?

Are you using the Fixed Version which was posted?

The one from the signature? Yeah. Do you know if you use MySQL 5.5 or not? I think 5.5 may cause these issues somehow.

ProFifaLeagues
06-08-2012, 09:55 PM
The one from the signature? Yeah. Do you know if you use MySQL 5.5 or not? I think 5.5 may cause these issues somehow.


Could be the problem as we use
MySQL Version 5.0.95

huuquynh
06-09-2012, 12:28 AM
Me too. MySQL Version : 5.5.15.

Both ranking and overallranking.

Antonio Pereira
06-09-2012, 06:51 AM
Football Betting Game 1.4.25RC1 Version
Vbulletin vBulletin 4.1.12 Patch Level 2
vBSEO 3.6.0 PL2

Hi find a strange bug with the navigation page ranking, affect:
overallranking
ranking

Wen i have more than 100 users the page force to click in page 2 to see next players points like this:
/vbsoccer.php?page=2do=ranking&l=12 give error

but wen i submit option "go to page" and insert "2" goes to the correct url
/vbsoccer.php?do=ranking&l=12&page=2

Any solution for this?

Best regards

artcrimes
06-09-2012, 05:53 PM
this is fantastic! thank you!

fortforum
06-10-2012, 01:10 PM
I get an issue in navbar, where the plugg overwrites new posts with something. Not nice.

Appart from that it seems to be working just fine on 4.2.

Running mysql 5.0.51a-24+lenny5-log

Gn_Snake
06-12-2012, 11:41 AM
Football Betting Game 1.4.25RC1 Version
Vbulletin vBulletin 4.1.12 Patch Level 2
vBSEO 3.6.0 PL2

I've uninstalled and reinstalled the product some time ago, continues to give me problems mysql:




Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT (_wr * 0) +
((_count - _wr - _rr - _rd) * 1) +
(_rd * 2) +
(_rr * 3) 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 HG_soccer_user_bet AS b
INNER JOIN HG_soccer_match AS m ON(m.id=b.match_id)
WHERE userid=1 AND score_key>0 AND match_is_finished=1
GROUP BY userid) AS userpoints;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`hardware_Hardwaregame`.`b`.`bet_home` - `hardware_Hardwaregame`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Tuesday, June 12th 2012 @ 01:50:09 PM
Error Date : Tuesday, June 12th 2012 @ 01:50:09 PM

What's?? Help please

madddenaddicto
06-12-2012, 12:41 PM
I installed it about a month ago and never had any problems.
I have the lastest vbulletin.
I only have 21 users and we dot use the forums.

For La Liga I plan to have over 200 users.

fortforum
06-12-2012, 10:01 PM
I get this stupid overlay and it kinda drives me nuts. I can?t figure out how to get rid of it. Appart from this, it works great.


http://www.2shared.com/photo/3i5GA_z2/screen.html

Gn_Snake
06-13-2012, 08:16 AM
And how to stop it?

W!cKeD
06-13-2012, 11:16 AM
And how to stop it?

Search in vbsoccer.php the query and put this =>
$vbulletin->db->query_read("
SET sql_mode='NO_UNSIGNED_SUBTRACTION';
");
befor the query.

Gn_Snake
06-13-2012, 11:50 AM
Thanks W!cKeD,
but what query should i look?

huuquynh
06-13-2012, 02:26 PM
Hi,

You find the string: // in verbindung mit der usertabelle!

and $sortarrow[$sortfield] = $templater->render();

then put after them.

I tried and got no error. But I'm not sure about the result, because I'm not coder.

ProFifaLeagues
06-15-2012, 01:58 PM
New version now works with 4.2.0 link in my sig



Whats the Changes mate?? The old one seemed to be working A1 for us on 4.2 as well would it be worth us upgrading?
Thanks

ProFifaLeagues
06-15-2012, 05:46 PM
Cheers ForceHSS Will update this evening as I know yours has been the one Ive used for a while being moving up to 4.2 and Always been A1

Datenpapst
06-17-2012, 04:55 PM
is there a betting option for the European Championship?

ProFifaLeagues
06-17-2012, 04:56 PM
is there a betting option for the European Championship?
yes m8 there is :up:

Datenpapst
06-17-2012, 05:05 PM
Well but its not working with 4.1.10 or 4.2? ^^

ProFifaLeagues
06-17-2012, 06:06 PM
Working fine on both mate I am using it on 4.2 with the Euros and used it on 4.1.10 too until the last week or so

madddenaddicto
06-17-2012, 06:39 PM
When do the upcoming leagues usually come out?
How long before they start?

ProFifaLeagues
06-17-2012, 07:03 PM
Depends on the Fixtures being Released for Each League mate.
English Premier league comes out tomorrow So maybe soon we will see that added with any luck

scaramanga
06-18-2012, 09:06 AM
Search in vbsoccer.php the query and put this =>
$vbulletin->db->query_read("
SET sql_mode='NO_UNSIGNED_SUBTRACTION';
");
befor the query.

That worked perfectly, thanks! It seems to me this error happens if you predict more away goals than home, making home - away < 0.

The only query I can't find is the hall of fame one - I have that issue there. Do you know where to find it?

betts02
06-19-2012, 07:52 PM
When will they new seasons be added ?

Many thanks and keep up the great work

Datenpapst
06-24-2012, 06:37 AM
Tested the whole script seems to work fine with 4.2 but there is one bug:
the pagnavigation in the ranking.

If you got 2 pages and you wanna go to the 2nd one by clicking on the "2" this links is called:
http://www.c-arena.com/vbsoccer.php?page=2do=ranking&l=1

But it should be this link:
http://www.c-arena.com/vbsoccer.php?do=ranking&l=1&page=2

Maybe you can fix this quiet easily? If not I gonna have to take a closer look at the script.

beertruck
06-25-2012, 06:05 PM
ForceHSS thanks for the great mod! One question. Is there any way to add to user reputation for every guessed game, score etc?

betts02
06-27-2012, 09:41 PM
This has already been asked please search for answer

Ive searched and for the life of me i can not find it,lol

nick-harper
07-04-2012, 08:04 AM
Is there a way to add a league? I am happy to make a donation :) My team has been relegated :(

madddenaddicto
07-11-2012, 12:19 AM
Ok. The German Leagues are out!! When can we expect the other leagues?

liesislief
07-12-2012, 03:12 PM
Ok. The German Leagues are out!! When can we expect the other leagues?

On the vbulletin-germany.org the author has said this year will only be germany, because the high costs for data.

betts02
07-12-2012, 09:22 PM
On the vbulletin-germany.org the author has said this year will only be germany, because the high costs for data.

Is this true ?

If so i will have to remove it due to we only use the English Leagues

Hope they do get used

ProFifaLeagues
07-13-2012, 09:17 AM
Gutted to hear that it will be the german league only this coming Season as its such a Class mod and there is not one that matches it out there for us!

Hopefully the maker may even look at subs and then bring in other leagues like the Premier League again with any luck

madddenaddicto
07-14-2012, 11:59 AM
I hope this is not true.

betts02
07-14-2012, 09:30 PM
Also to add, If this is true then it needs to be noted in the title and description along with UPDATED status ?

AA_
07-14-2012, 10:48 PM
it is true - the number of leagues has been reduced this year. I have not received enough donations for funding of the Service (fixtures, live scores, results). I can not tell you which leagues this year are not available. that is dependent on sponsorship by interested users.

Next year I may have a better and more reliable funding model :)

// edit: current status (https://twitter.com/vbsoccer_)

betts02
07-14-2012, 10:56 PM
How much would it be for say the UK Premier League ?

I can then see what i can do with any other members who want this league

many thanks

AA_
07-14-2012, 11:03 PM
How much would it be for say the UK Premier League ?


the premier league I have published today.

betts02
07-14-2012, 11:07 PM
You are a star mate, You got a link so i can donate pal ?

Cheers again

AA_
07-14-2012, 11:15 PM
You are a star mate, You got a link so i can donate pal ?


in the first post, "Support Developer"

madddenaddicto
07-15-2012, 12:48 AM
I already donated.
The spanish league is out!

Love it!
Will donate again soon.

blue6995
07-15-2012, 07:22 AM
Donation made, thanks!

betts02
07-15-2012, 08:26 AM
Donated = betts02@hotmail.com

If you can add the UK Championship League a further donation shall be sent pal, Cheers again your a star

BillyD
07-15-2012, 07:07 PM
how much does adding a league cost, in my case the turkish super league

AA_
07-15-2012, 08:57 PM
how much does adding a league cost, in my case the turkish super league

S?per Lig 2012/2013 is now available. (any donation is welcome, thanks)

nikosb
07-16-2012, 04:24 AM
any luck for Greek super league?

Limality
07-16-2012, 05:49 AM
Hi

Is there any way for this mod to run on a newer version of vbulletin?

ProFifaLeagues
07-16-2012, 05:51 AM
Hi

Is there any way for this mod to run on a newer version of vbulletin?


Working fine on latest Release of Vbulletin mate 4.2

madddenaddicto
07-16-2012, 03:41 PM
People, we all know this is the best mod ever "if" you like football.

Please donate so we can keep this mod alive.
Ive donated already and will donate again soon.

madddenaddicto
07-16-2012, 03:47 PM
Is there a way to have the football olimpics ?
Possible?

suneka
07-16-2012, 09:38 PM
And about brazil?

Campeonato Brasileiro Serie A

Plz.

http://www.cbf.com.br/competicoes/campeonato-brasileiro/serie-a/2012

madddenaddicto
07-18-2012, 12:58 AM
Donated again to this great mod.
Thank you.

SilverBoy
07-18-2012, 03:05 AM
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.

AA_
07-18-2012, 04:55 AM
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).

nick-harper
07-18-2012, 05:40 AM
Would it be possible to add English League One? Happy to make a donation for it :)

nikosb
07-18-2012, 05:54 AM
Would it be possible to add Greece Super League? Happy to make a donation for it :)

madddenaddicto
07-18-2012, 11:17 AM
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/attachment.php?attachmentid=113911&d=1268350495 but on the vbulletin publishing suite.

abieteh.com
07-21-2012, 07:16 AM
Hello, I Have This Database error ..

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

imported_hbs
07-21-2012, 05:54 PM
the mod have the Israeli Premier League 2010/2011

is it possible to add the 2011/12 seasson and the upcoming 2012/13 seasson ?

Blannes
07-22-2012, 08:09 AM
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.

Hope you can help us.
thx

AA_
07-23-2012, 09:41 AM
Hello, I Have This Database error .. (...)

I need a database access to reproduce / fix the error (PM).

madddenaddicto
07-24-2012, 12:04 PM
nvm. I got it working.

gazza2008
07-27-2012, 07:01 AM
IS the fixtures for the new premiership season out yet.

I dont mind paying if needs be

gaz

madddenaddicto
07-27-2012, 11:19 AM
The english premier league has been out for a while!

Yshuya
08-01-2012, 07:46 AM
The belgian jupiler league will be availaible soon?
What could I do to have it?
Donation?

madddenaddicto
08-01-2012, 11:53 AM
Yes, we all had to donate.
Send AA a pm asking him if the Belgium League is compatible first and then donate a fair amount.

AA_
08-01-2012, 12:07 PM
Yes, we all had to donate.
Send AA a pm asking him if the Belgium League is compatible first and then donate a fair amount.

the belgium league is currently not compatible.
in the next major release (1.5.x, starting with VB5), I will consider this league system.

Yshuya
08-01-2012, 12:20 PM
Thank you for the response.

Have you an approximative idea when the upgrade coming? Just to know if i'm waiting or i'm searching an other system.

You can add only the first phase

I'll making a donation when the compatibility will be ok.

Thanks

madddenaddicto
08-01-2012, 04:21 PM
You shouldnt look for another script or mod.
This is the best thing out there hands down.

But go ahead and look for other systems so you can be sure.

Yshuya
08-02-2012, 09:26 AM
I trust you, but the championship as started, and I need to a system for our website/forum.
We have a big communautary project and user would have a prono system.

For waiting we probably do that manualy.

Sorry for my poor english!

AA_
08-02-2012, 10:23 AM
The belgian jupiler league will be availaible soon?
What could I do to have it?
Donation?

140256

Merenguista
08-02-2012, 04:18 PM
How can i add a cms-widget ?

Yshuya
08-02-2012, 05:11 PM
140256

Rhoooo !

Many Thanks, I speak with our forum team to fix a donation, very soon !

SilverBoy
08-04-2012, 06:59 AM
we need a CMS widget AA_ for this great mod Please :)

nick-harper
08-04-2012, 02:22 PM
I have just PM'd you.

I really need the English League 1, happy to donate too :)

AA_
08-04-2012, 06:36 PM
I have just PM'd you.

I really need the English League 1, happy to donate too :)

now available: League One 2012/2013

madddenaddicto
08-05-2012, 10:53 AM
we need a CMS widget AA_ for this great mod Please :)

I told him I would donate 50 Dollars for that and he doesnt even answer that PM.

nick-harper
08-05-2012, 10:59 AM
now available: League One 2012/2013

Thanks and donation sent :)

1 Point though, it was really hard to donate through the plugin as it was all in german :( It might put people off!

nick-harper
08-05-2012, 11:15 AM
What would the CMS widget do?

Regs
08-05-2012, 12:20 PM
What would the CMS widget do?

I would imagine the same thing the forums block does - shows standings, a selector to view other standings and links to those sections.

AA_
08-05-2012, 12:35 PM
I told him I would donate 50 Dollars for that and he doesnt even answer that PM.

not even for $ 1,000 ;)
the cms widget is planned for vbulletin5. later there will be a variant of vbulletin4.

sorry, my focus is not on new features, but stability and continuity.

madddenaddicto
08-05-2012, 01:14 PM
Good stuff bro.
Keep it coming.

SilverBoy
08-05-2012, 08:56 PM
so is there any body able to convert the forum block to cms widget?

Limality
08-06-2012, 07:23 AM
any plans to make this work on vb 4.2?

ProFifaLeagues
08-06-2012, 07:32 AM
any plans to make this work on vb 4.2?


Works Superb on 4.2 mate :up:

Limality
08-07-2012, 06:57 AM
Works Superb on 4.2 mate :up:

ah i see this is a new version, nice. i tried to install 1.4.24 a while back and it didn't work, telling me that it wasn't compatible with my vbulletin version of 4.2...nice :D

skol
08-07-2012, 08:01 AM
Works Superb on 4.2 mate :up:

Does your English premier division show the 17th for the first matches?I believe the English premier starts on the 18th..

razorflowers
08-07-2012, 11:16 AM
Hi all,

I'm running vb 4.2 and i have a problem with the sidebar...The blockhead is weird ^^
The problem is only with the soccer module...

Can someone help me ?

https://vborg.vbsupport.ru/

AA_
08-07-2012, 11:30 AM
Hi all,

I'm running vb 4.2 and i have a problem with the sidebar...The blockhead is weird ^^
The problem is only with the soccer module...

Can someone help me ?

http://nsa29.casimages.com/img/2012/08/07/120807023011719669.png

is this really a problem with the addon?
here an example with the standard design:

https://vborg.vbsupport.ru/attachment.php?attachmentid=140376&d=1344342627

razorflowers
08-07-2012, 11:35 AM
Yes i think cause there are no problems with the rest of the sidebar...

See on the screen

http://nsa29.casimages.com/img/2012/08/07/120807024834900552.png

AA_
08-07-2012, 11:42 AM
Yes i think cause there are no problems with the rest of the sidebar...


where can I test it?

razorflowers
08-07-2012, 11:49 AM
I've sent a pm, thanks a lot AA :)

Problem solved : thanks a lot

AA_
08-07-2012, 12:51 PM
There was a problem of your style ;)
you have an extra div - element in your widget style code (<div class="clear"></div> just below the title). This is not original and not (full)compatible with the original vbulletin style.

razorflowers
08-07-2012, 01:53 PM
Another little problem this time...The time (schedule) for matches isn't correct. All the kick-off time are one day before the real time...

Ligue 1 => 10th august (Montpellier - Toulouse) and for the rest (11th august)
Premier League => 18th - 19th and 20th august.

It is a problem with the 4.2 version of vb ?

http://nsa30.casimages.com/img/2012/08/07/120807050738960424.png

AA_
08-07-2012, 03:49 PM
server time zone is correct?

razorflowers
08-07-2012, 03:59 PM
Yes it's correct.

It seems ok just for the bundesliga 1, i don't understand why...

pesclub
08-07-2012, 08:00 PM
witam czy da się dodac jakoś własne zespoły i je aktualizować stworzyć osobną ligę?

pesclub
08-07-2012, 08:01 PM
hello is it possible to somehow add their own teams and update them to create a separate league?

dany_danay
08-08-2012, 12:24 AM
I have a disaster style, but my question is, where can users view other users bets?

skol
08-08-2012, 06:20 AM
server time zone is correct?

It's the same on the English Premier also.

jo8jo
08-08-2012, 06:24 AM
I have a disaster style, but my question is, where can users view other users bets?

You can view other users bets by clicking the green "done"-icon when a match was finished or the "soccer"-icon when a match is live (see second screenshot above in mod description).

Limality
08-08-2012, 06:59 AM
another question: matchup of the next 3 days show's only ligue 1 matches but none of the others like Swiss Super League which have matches starting on the same day...

when i disable ligue 1, no coming matches are showed...

okay, i upped number of days to preview in the options and now it works...but still... ligue 1 and super leage have matches on 11. august but only ligue 1 would appear when the preview days would be set to 3 (3 days from now would be the 11. august)

AA_
08-08-2012, 07:40 AM
another question: matchup of the next 3 days show's only ligue 1 matches but none of the others like Swiss Super League which have matches starting on the same day...

when i disable ligue 1, no coming matches are showed...

okay, i upped number of days to preview in the options and now it works...but still... ligue 1 and super leage have matches on 11. august but only ligue 1 would appear when the preview days would be set to 3 (3 days from now would be the 11. august)

where can I test it?

AA_
08-08-2012, 07:42 AM
It's the same on the English Premier also.

Another little problem this time...The time (schedule) for matches isn't correct. All the kick-off time are one day before the real time...

(...)

the addon is not a long-term schedule planner. The exact times will be 1-3 days before updated.

skol
08-08-2012, 07:52 AM
I pm'd you,at the same time as you posted..Thanks and understand..

Edit: I just clicked on "get updated data" and it's updated correctly now..

Thanks.

dany_danay
08-08-2012, 09:45 AM
Thanks a lot!!
Now i will try to solve css issue.
Other question, there is a possibility to show general stadisttics of bets per macth? I mean, i dont interested on seeing "xuser" bets this, im interested i view general (40% bets local team win, 40 bets draw and 20 bets foreing team)

skol
08-08-2012, 10:08 PM
Thanks a lot!!
Now i will try to solve css issue.
Other question, there is a possibility to show general stadisttics of bets per macth? I mean, i dont interested on seeing "xuser" bets this, im interested i view general (40% bets local team win, 40 bets draw and 20 bets foreing team)

You have the option to "Show bet forecast" But thats dependant on how you set "View other users bets"...:D

madddenaddicto
08-17-2012, 08:24 PM
Hi. I see a problem with the 2nd division from spain.
The Villareal vs Real Madrid Castillas just finished and Im still able to edit that score.

Can you help me with this?

betts02
08-17-2012, 09:43 PM
Just a quick 1

Will any of the CUP games be added ?

Cheers

madddenaddicto
08-18-2012, 06:40 PM
Is anyone else running the spanish league and having problems?

ProFifaLeagues
08-18-2012, 07:43 PM
Worked Superb today using the EPL and Championship Leagues

madddenaddicto
08-19-2012, 12:58 AM
I have the english league also and it worked fine.
But the spanish league is not adding the points correctly

fco.sepulveda
08-19-2012, 10:16 AM
You can add an own league?

ProFifaLeagues
08-19-2012, 10:52 AM
You can add an own league?
No mate just the 20 or so that are setup for the mod

madddenaddicto
08-19-2012, 10:53 AM
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
08-19-2012, 10:55 AM
You can add an own league?

In the near future, they will add more leagues.

AA_
08-19-2012, 11:05 AM
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
08-19-2012, 12:57 PM
Awesome work.

Yshuya
08-20-2012, 07:31 PM
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_
08-20-2012, 07:41 PM
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
08-21-2012, 06:15 AM
Ok thanks.

madddenaddicto
08-21-2012, 05:09 PM
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_
08-21-2012, 06:03 PM
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));

madddenaddicto
08-21-2012, 08:36 PM
Thank you very much!

:up:

tidus78
08-21-2012, 09:00 PM
Hi

My last update match is 27-07-2012....

League Serie A don't counts advances,any idea?

AA_
08-21-2012, 09:21 PM
Hi

My last update match is 27-07-2012....

League Serie A don't counts advances,any idea?

updated

tidus78
08-21-2012, 09:34 PM
Powerful!

imported_hbs
08-25-2012, 09:22 AM
Is it possible to add the Israeli Premier League ?
10x in advance

W!cKeD
09-03-2012, 10:08 AM
Hi AA_

My last update match is 28-08-2012

Can you Please update it? Thanks

onfranco
09-06-2012, 03:31 PM
Sorry, where are installation instuctions ?

onfranco
09-09-2012, 05:24 PM
Now you can not add leagues. Do you have any idea? it seems that the server does not respond

hoangserip
09-10-2012, 06:26 AM
Can you add a new plugin to create an our league, and I can input the score or manage our league myself (admin).
We really need that to public our scores, matchs to our member.
Please help. Thanks a lots ^^!

MattGarner
09-14-2012, 08:21 PM
Has anyone noticed that on the UEFA Champions League 2012/2013 has the dates incorrect? Not sure about all dates but it says the first matches are on the 17th when they are on the 18th.

http://soccernet.espn.go.com/fixtures/_/league/uefa.champions/uefa-champions-league#?cc=5739

betts02
10-02-2012, 07:20 PM
Is it possible to remove people from the tables ?

If so how without actually deleting the user

AA_
10-03-2012, 06:55 AM
Is it possible to remove people from the tables ?

If so how without actually deleting the user

DELETE FROM soccer_user_bet WHERE userid=userid

betts02
10-03-2012, 06:02 PM
DELETE FROM soccer_user_bet WHERE userid=userid

what do i do with that code mate ?
Cheers

Tariq AlAli
10-05-2012, 05:20 PM
Greetingz

When adding Champions League 2012/2013 it displays it in Gray (inactive). Any clue ?

Regards

Tariq AlAli

Bounce
10-19-2012, 06:00 PM
what do i do with that code mate ?
Cheers

Execute SQL Query in vb admin

nick-harper
11-08-2012, 09:53 AM
On the sidebar block I get "Bets on this tournament have not yet been evaluated"

Even though when you go into it, it works fine.

ataozcelik
11-11-2012, 07:52 AM
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.

tipsterx
11-11-2012, 12:22 PM
i did install but and import , but cant see ths product on my website :(((

KGI_Bling
11-28-2012, 12:33 AM
--------------------------- 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


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!!!!!!!!!!!! -------------------------

I fixed it... Thanks

Morpheuss89
12-03-2012, 05:21 PM
any news ? =)

pape sets fire
12-03-2012, 08:17 PM
Question: I can create my own leagues?

Morpheuss89
12-03-2012, 10:23 PM
no you can't...

AA can u add Italy - Serie B ? some users are asking for it from 2 years xD will be really appreciated !

Morpheuss89
12-04-2012, 02:21 PM
i can not save any tips, save button just dont work. any suggestions ??

same for me !! anyone know how to fix it ? :/

swapps
02-01-2013, 05:13 PM
MySQL Error : BIGINT UNSIGNED value is out of range in...


I got the same error.
To fix it use CAST() in the SQL at (`bet_home`-`bet_away`)


... (CAST(`bet_home` AS SIGNED) - CAST(`bet_away` AS SIGNED)) ...

lollodev
02-08-2013, 02:48 PM
how can I add the Italian Language of Fussball-Tippspiele? Where do I upload the xml file?
Please let me know.

Ok, I found out how to do it...you need to overwrite the language.

madddenaddicto
02-09-2013, 04:58 PM
When I put a draw result for the champions league example.. Valencia Vs PSG.. its tells me this.. You bet on a draw in 1 knockout matches. You will not be awarded any points for this, as a knockout match will always have a winner. Goals after extra time as well as the penalties will be counted for the final result!

This is the first leg and they can draw..
Can anyone help me with this?
How does this work?
Can I leave my result 1-1 and it will count?

lollodev
02-11-2013, 10:40 AM
When I put a draw result for the champions league example.. Valencia Vs PSG.. its tells me this.. You bet on a draw in 1 knockout matches. You will not be awarded any points for this, as a knockout match will always have a winner. Goals after extra time as well as the penalties will be counted for the final result!

This is the first leg and they can draw..
Can anyone help me with this?
How does this work?
Can I leave my result 1-1 and it will count?

I have the same exact problem. Is there any special setting to fix this?

tsafarog
02-12-2013, 01:07 PM
same problem here

lollodev
02-13-2013, 03:04 PM
When I put a draw result for the champions league example.. Valencia Vs PSG.. its tells me this.. You bet on a draw in 1 knockout matches. You will not be awarded any points for this, as a knockout match will always have a winner. Goals after extra time as well as the penalties will be counted for the final result!

This is the first leg and they can draw..
Can anyone help me with this?
How does this work?
Can I leave my result 1-1 and it will count?

This also occurs with Europa League games.

There are games this week and next week...can we please have a solution to this problem?

lollodev
02-16-2013, 11:04 AM
support seems dead....

ForceHSS
02-16-2013, 04:37 PM
support seems dead....

I told all this a long time ago but no one would listen

TRBozo
02-28-2013, 08:26 AM
Please add PTT 1.Ligue (TR)

from link http://gollercepte.tv/gc/league.aspx?leagueId=4

Mr_Devlin
02-28-2013, 09:12 AM
When I put a draw result for the champions league example.. Valencia Vs PSG.. its tells me this.. You bet on a draw in 1 knockout matches. You will not be awarded any points for this, as a knockout match will always have a winner. Goals after extra time as well as the penalties will be counted for the final result!

This is the first leg and they can draw..
Can anyone help me with this?
How does this work?
Can I leave my result 1-1 and it will count?

Which version of addon do you use?
And which vB version, php and mysql do you have have installed?
CL- and EL-Games will be count as "knockout games", that MUST HAVE a winning team. This should only occur in german DFB-Pokal (or other cup matches) when a rematch is not scheduled. This issue needs to be updated by the author.

This error should NOT occur when using the current version of the Addon on any vB 4.x with PHP 5.x and MySQL 5.x.
Same for BIGINT-Error.

MattGarner
03-13-2013, 09:58 PM
I assume no one will be able to fix/update the Champions League 2012/2013 one as some of the dates are wrong and means they are missing the scores.

lollodev
03-21-2013, 10:32 AM
This error should NOT occur when using the current version of the Addon on any vB 4.x with PHP 5.x and MySQL 5.x.
Same for BIGINT-Error.

Hi,

this is what I'm using....and unfortunately the first leg matches don't accept a tie...
VB version: 4.2.0
PHP: 5.3.17
MySQL: 5.1.63-cll
vbsoccer version: vbsoccer_vb4_en_1.4.25RC8.zip

Please let me know if there is a way to fix this problem.

Regards,
-L.

AA_
03-22-2013, 10:04 PM
Hi,

this is what I'm using....and unfortunately the first leg matches don't accept a tie...
VB version: 4.2.0
PHP: 5.3.17
MySQL: 5.1.63-cll
vbsoccer version: vbsoccer_vb4_en_1.4.25RC8.zip

Please let me know if there is a way to fix this problem.

Regards,
-L.

search in /includes/functions_vbsoccer.php:
-----------------------------------------------------------

function fetch_knockout_matchtypes()
{


and REPLACE with:
-----------------------------------------------------------

function fetch_knockout_matchtypes()
{
return array();

markhendo1986
04-19-2013, 12:24 PM
Tagging this modification.

Would love this to be installed but currently afraid to do so after reading the amount of people with issues and no apparent support for it.

If there's any confirmation that it works with v4.2.1 then I'll install without hesitation.

Thanks!
Mark

Mr_Devlin
04-19-2013, 12:36 PM
It works fine. Try it and enjoy, it's the best and most comfortable addon for this kind of betting games. You're members will love it if they like soccer...

Merenguista
04-23-2013, 01:29 PM
Hi

When will this product be available for vb5 ?

kutukupret
04-24-2013, 08:30 AM
can you help me for this issue (pic on attachment)

VB 4.2.1

thanks

Mr_Devlin
04-24-2013, 11:51 AM
can you help me for this issue (pic on attachment)

VB 4.2.1



thanks

Which issue do you mean?
Did you upload the whole content in the upload-folder - all files and pics?

kutukupret
04-25-2013, 05:02 AM
there are broken display on table chart

no option for forum

yes, i already upload all files

thanks

madddenaddicto
06-03-2013, 02:26 PM
Ive used this mod all season long without any problems! I used about 6 leagues.
Thank you AA.
Best mod ever for sure!!!

Can you add the Confederation Cup?

Spangle
06-04-2013, 04:59 PM
I'm trying to upload this to a 4.2.1 and I keep getting this error :

Please upload the files that came with the vbsoccer package before installing or upgrading!

I've uploaded all the files !

EDIT: Fixed

Mariner1
06-04-2013, 06:41 PM
Ive installed this on 4.2.1 but cant see a navbar tab or anything to actually play the game

MrD
06-05-2013, 09:23 AM
Hi,
You Must edit the Navbarentry manually.
The Navbar are changed in 4.2.0 and the Addon Use the Old Code.

Mariner1
06-05-2013, 09:48 AM
Thanks MrD,is there any instruction on how to do it pls

MrD
06-05-2013, 10:43 AM
Hi,
Take a Look in the DownloadsII thread.
There are many helpfull hints in it ;)

Mariner1
06-05-2013, 11:21 AM
Got it,cheers :)

madddenaddicto
06-13-2013, 05:22 PM
Thank you for adding the Confederations Cup