vb.org Archive - Integration with vBulletin - Soccer Betting Game ("Fussball-Tippspiele")

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

All times are GMT. The time now is 04:57 PM.

Page 129 of 167

129

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02428 seconds Memory Usage 1,737KB 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 (1)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
Messages: