vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Integration with vBulletin - Soccer Betting Game ("Fussball-Tippspiele") (https://vborg.vbsupport.ru/showthread.php?t=238043)

Bluefin221 12-22-2011 05:58 PM

Quote:

Originally Posted by ForceHSS (Post 2279470)
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

Code:

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

Quote:

Originally Posted by ForceHSS (Post 2318860)
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

Quote:

Originally Posted by betts02 (Post 2319478)
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

Quote:

Originally Posted by ForceHSS (Post 2318860)
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...
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

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

Quote:

Originally Posted by nick-harper (Post 2324994)
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

Quote:

Originally Posted by nick-harper (Post 2324994)
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

Quote:

Originally Posted by ForceHSS (Post 2331606)
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

Quote:

Originally Posted by ForceHSS (Post 2331918)
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

Quote:

Originally Posted by Tony_FPM (Post 2333831)
I need it for 4.2!!

Pleaseeeee

working fine with 4.2.0..

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

and change to
Quote:

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

madddenaddicto 05-28-2012 11:24 AM

Quote:

Originally Posted by gazza2008 (Post 2333658)
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

Quote:

Originally Posted by ForceHSS (Post 2333859)
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

Quote:

Originally Posted by Tony_FPM (Post 2333860)
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

Quote:

Originally Posted by gazza2008 (Post 2333658)
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?


All times are GMT. The time now is 09:22 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02799 seconds
  • Memory Usage 1,827KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (14)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete