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)

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?


All times are GMT. The time now is 11:29 PM.

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.02619 seconds
  • Memory Usage 1,747KB
  • 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
  • (1)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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