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)

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

Quote:

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

Quote:

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

Code:

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 :

Code:

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


All times are GMT. The time now is 02:41 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.02422 seconds
  • Memory Usage 1,745KB
  • 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
  • (2)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