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)

AA_ 07-18-2012 04:55 AM

Quote:

Originally Posted by SilverBoy (Post 2349140)
AA_ is there a way to add our desired leagues manual?

I mean some times we need a league that don't have a lot of fans here, so is there away to add it to our site only? please give us the instruction to add our leagues :).

Thanks.

no, this is not possible.
a (local) manual intervention makes the application/database incompatible with future seasons.

at a reasonable expense compensation I may also add exotic events/leagues (if they are compatible with the mod).

nick-harper 07-18-2012 05:40 AM

Would it be possible to add English League One? Happy to make a donation for it :)

nikosb 07-18-2012 05:54 AM

Would it be possible to add Greece Super League? Happy to make a donation for it :)

madddenaddicto 07-18-2012 11:17 AM

I can make an extra donation for the league of Venezuela.
Let me know if its compatible with your mod.
I can also make an extra donation for this https://vborg.vbsupport.ru/attachmen...1&d=1268350495 but on the vbulletin publishing suite.

abieteh.com 07-21-2012 07:16 AM

Hello, I Have This Database error ..

Code:

Database error in vBulletin 4.1.8:

Invalid SQL:

        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 `soccer_user_bet` AS b
            INNER JOIN `soccer_match` AS m ON (m.`id`=b.`match_id`)
            WHERE `dateline` BETWEEN 1341100800 AND 1343779200 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 '(`database name`.`b`.`bet_home` - `database name`.`b`.`bet_away`)'
Error Number  : 1690
Request Date  : Saturday, July 21st 2012 @ 12:13:49 PM
Error Date    : Saturday, July 21st 2012 @ 12:13:49 PM
Script        : http://*******/vbsoccer.php?do=overallranking
Referrer      : http://******/vbsoccer.php
IP Address    : ******
Username      : *****
Classname    : vB_Database
MySQL Version : 5.6.4-m7


imported_hbs 07-21-2012 05:54 PM

the mod have the Israeli Premier League 2010/2011

is it possible to add the 2011/12 seasson and the upcoming 2012/13 seasson ?

Blannes 07-22-2012 08:09 AM

Hello, i got the same problem like abieteh.com
Tipped Russian Leaque, everything works fine. After game result update from Soccerserv, i got the database Error on ranking on season and total Rankings.

Hope you can help us.
thx

AA_ 07-23-2012 09:41 AM

Quote:

Originally Posted by abieteh.com (Post 2350047)
Hello, I Have This Database error .. (...)

I need a database access to reproduce / fix the error (PM).

madddenaddicto 07-24-2012 12:04 PM

nvm. I got it working.

gazza2008 07-27-2012 07:01 AM

IS the fixtures for the new premiership season out yet.

I dont mind paying if needs be

gaz


All times are GMT. The time now is 06:50 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.04507 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
  • (1)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