vb.org Archive
Page 160 of 167 « First 60110150158159 160 161162 Last »
Show 40 post(s) from this thread on one page

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)

nick-harper 07-27-2015 07:57 PM
Looks like the page needs to be /vbsoccer.php?do=ranking&l=9&pagenumber=2 to work.

Or /vbsoccer.php?page=2&do=ranking&l=9

So it is just missing the & between 2 and do

5starpool 08-09-2015 09:04 AM
I'm getting an sql error on the rankings page for the English Premier League. It is ok for the other league I have set up on my forum.

Here is what my error is:

Quote:
Database error in vBulletin 3.8.8:

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 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`=32 GROUP BY `match_day`, b.`userid`;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`dbname_dbforum`.`b`.`bet_home` - `dbname_dbforum`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Sunday, August 9th 2015 @ 10:51:44 AM
Error Date : Sunday, August 9th 2015 @ 10:51:44 AM
Script : http://www.myurl.com/forum/vbsoccer....enumber=1&l=32
Referrer : http://www.myurl.com/forum/vbsoccer....=35&do=ranking
IP Address : 109.79.231.253
Username : xxxx
Classname : vB_Database
MySQL Version : 5.6.23
Has anyone got any suggestions on how to fix this?

motd2 08-09-2015 05:27 PM
MySQL problem )

vbsoccer.php
find twice this code
Code:
CAST(`bet_home`-`bet_away` AS SIGNED)
replace twice this code
Code:
CAST(`bet_home` AS SIGNED) - CAST(`bet_away` AS SIGNED)
next
includes/functions_vbsoccer.php
find
Code:
CAST(bet_home - bet_away AS SIGNED)
replace
Code:
CAST(bet_home AS SIGNED) - CAST(bet_away AS SIGNED)

Braddock 08-10-2015 09:23 AM
I made the changes from #1569 but i am not able to update! :(
Any suggestions?

motd2 08-10-2015 09:41 AM
Quote:
Originally Posted by Braddock (Post 2552552)
Any suggestions?
try to return
Code:
$vurl = new vB_vURL($this->registry);

5starpool 08-10-2015 10:06 PM
Quote:
Originally Posted by motd2 (Post 2552524)
MySQL problem )

vbsoccer.php
find twice this code
Code:
CAST(`bet_home`-`bet_away` AS SIGNED)
replace twice this code
Code:
CAST(`bet_home` AS SIGNED) - CAST(`bet_away` AS SIGNED)
next
includes/functions_vbsoccer.php
find
Code:
CAST(bet_home - bet_away AS SIGNED)
replace
Code:
CAST(bet_home AS SIGNED) - CAST(bet_away AS SIGNED)
Works a treat, thank you so much.

TiKu 08-23-2015 02:36 PM
Is there any way to make this add-on work with mobile style? All I get in mobile style is a blank page.

johon 09-14-2015 10:17 AM
Does anybody know if Euro League will be available?

tekram 09-17-2015 04:40 AM
No. I?ve send AA_ some Message but no Reply.

The European League will start today :(

5starpool 09-19-2015 12:42 PM
My results aren't updating any more in this. There are a couple of games recently that didn't get the result through, and now it hasn't updated data since Sep 14th, and pressing the 'get updated data' button doesn't update it.

Is there anyway to fix this that doesn't involve deleting and readding the league? I'm not sure if that would fix it either, but I don't want to lose entered results as there are competitions ongoing, but it's useless at the minute.


All times are GMT. The time now is 03:53 AM.
Page 160 of 167 « First 60110150158159 160 161162 Last »
Show 40 post(s) from this thread on one page

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.03291 seconds
  • Memory Usage 1,746KB
  • 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
  • (9)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
  • (3)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