vb.org Archive
Page 34 of 42 « First 243233 34 3536 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)

Gemma 06-07-2012 04:02 PM
Quote:
Originally Posted by vcoderzdotcom (Post 2337242)
does it work on vbulletin 3.8.7?
https://vborg.vbsupport.ru/showthread.php?t=237934

fortforum 06-08-2012 01:30 PM
Trying this but it just gives me this:

"The Maintenance Service doesn't respond or is not available yet. Please try it later again.
"

Is this service discontinued?

MattGarner 06-08-2012 03:31 PM
These errors have been starting on certain parts of the plugin:

Quote:
Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT
b.`userid`, DATE_FORMAT(FROM_UNIXTIME(m.`dateline`), '%Y%m%d') AS `mdate`, `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`=1 GROUP BY DATE_FORMAT(FROM_UNIXTIME(m.`dateline`), '%Y%m%d'), b.`userid`;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`habboxfo_forumhx`.`b`.`bet_home` - `habboxfo_forumhx`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Friday, June 8th 2012 @ 05:30:51 PM
Error Date : Friday, June 8th 2012 @ 05:30:51 PM
Script : http://www.habboxforum.com/vbsoccer....anking&l=1&m=2
Referrer : http://www.habboxforum.com/vbsoccer.php?do=tab&l=1&m=2
Classname : vB_Database
MySQL Version : 5.5.24-cll
Anyone have any idea?

MattGarner 06-08-2012 03:35 PM
Quote:
Originally Posted by ForceHSS (Post 2337782)
no support for vb version you are running as it has not been tested on that version yet
It was working fine before any matches started but ok :P

MattGarner 06-08-2012 05:20 PM
From what I have read in this thread, it's related if a user has entered too much of a high bid in one of the predictions. A user did have the number 45 in two of his predictions and I have removed them to see if it was the problem. The error still exists, anyone else had problems with vb 4.2 and MySQL 5.5? I know the plugin isn't fully supported but it was working before any of the matches started.

Gn_Snake 06-08-2012 08:15 PM
Hi for all,
in the ACP do not have the Euro 2012 championship, how?

ProFifaLeagues 06-08-2012 08:28 PM
Confirm its been working fine for us on 4.2 even after todays games have been updated and the scores confirmed....

MattGarner 06-08-2012 08:29 PM
Quote:
Originally Posted by ProFifaLeagues (Post 2337926)
Confirm its been working fine for us on 4.2 even after todays games have been updated and the scores confirmed....
Including the rankings?

ProFifaLeagues 06-08-2012 09:24 PM
Quote:
Originally Posted by MattGarner (Post 2337927)
Including the rankings?


Yes just doubled Checked them now and all A1.

We are only running the euros at present Not sure if it would matter any?

Are you using the Fixed Version which was posted?

MattGarner 06-08-2012 09:49 PM
Quote:
Originally Posted by ProFifaLeagues (Post 2337937)
Yes just doubled Checked them now and all A1.

We are only running the euros at present Not sure if it would matter any?

Are you using the Fixed Version which was posted?
The one from the signature? Yeah. Do you know if you use MySQL 5.5 or not? I think 5.5 may cause these issues somehow.

ProFifaLeagues 06-08-2012 09:55 PM
Quote:
Originally Posted by MattGarner (Post 2337942)
The one from the signature? Yeah. Do you know if you use MySQL 5.5 or not? I think 5.5 may cause these issues somehow.

Could be the problem as we use
MySQL Version 5.0.95

huuquynh 06-09-2012 12:28 AM
Me too. MySQL Version : 5.5.15.

Both ranking and overallranking.

Antonio Pereira 06-09-2012 06:51 AM
Football Betting Game 1.4.25RC1 Version
Vbulletin vBulletin 4.1.12 Patch Level 2
vBSEO 3.6.0 PL2

Hi find a strange bug with the navigation page ranking, affect:
overallranking
ranking

Wen i have more than 100 users the page force to click in page 2 to see next players points like this:
Code:
/vbsoccer.php?page=2do=ranking&l=12
give error

but wen i submit option "go to page" and insert "2" goes to the correct url
Code:
/vbsoccer.php?do=ranking&l=12&page=2
Any solution for this?

Best regards

artcrimes 06-09-2012 05:53 PM
this is fantastic! thank you!

fortforum 06-10-2012 01:10 PM
I get an issue in navbar, where the plugg overwrites new posts with something. Not nice.

Appart from that it seems to be working just fine on 4.2.

Running mysql 5.0.51a-24+lenny5-log

Gn_Snake 06-12-2012 11:41 AM
Football Betting Game 1.4.25RC1 Version
Vbulletin vBulletin 4.1.12 Patch Level 2
vBSEO 3.6.0 PL2

I've uninstalled and reinstalled the product some time ago, continues to give me problems mysql:

Code:


Database error in vBulletin 4.1.12:

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
Request Date  : Tuesday, June 12th 2012 @ 01:50:09 PM
Error Date    : Tuesday, June 12th 2012 @ 01:50:09 PM
What's?? Help please

madddenaddicto 06-12-2012 12:41 PM
I installed it about a month ago and never had any problems.
I have the lastest vbulletin.
I only have 21 users and we dot use the forums.

For La Liga I plan to have over 200 users.

fortforum 06-12-2012 10:01 PM
I get this stupid overlay and it kinda drives me nuts. I can?t figure out how to get rid of it. Appart from this, it works great.


http://www.2shared.com/photo/3i5GA_z2/screen.html

Gn_Snake 06-13-2012 08:16 AM
And how to stop it?

W!cKeD 06-13-2012 11:16 AM
Quote:
Originally Posted by Gn_Snake (Post 2339211)
And how to stop it?
Search in vbsoccer.php the query and put this =>
PHP Code:
$vbulletin->db->query_read("
    SET sql_mode='NO_UNSIGNED_SUBTRACTION';
        "); 
befor the query.

Gn_Snake 06-13-2012 11:50 AM
Thanks W!cKeD,
but what query should i look?

huuquynh 06-13-2012 02:26 PM
Hi,

You find the string:
Quote:
// in verbindung mit der usertabelle!
and
Quote:
$sortarrow[$sortfield] = $templater->render();
then put after them.

I tried and got no error. But I'm not sure about the result, because I'm not coder.

ProFifaLeagues 06-15-2012 01:58 PM
Quote:
Originally Posted by ForceHSS (Post 2339787)
New version now works with 4.2.0 link in my sig


Whats the Changes mate?? The old one seemed to be working A1 for us on 4.2 as well would it be worth us upgrading?
Thanks

ProFifaLeagues 06-15-2012 05:46 PM
Cheers ForceHSS Will update this evening as I know yours has been the one Ive used for a while being moving up to 4.2 and Always been A1

Datenpapst 06-17-2012 04:55 PM
is there a betting option for the European Championship?

ProFifaLeagues 06-17-2012 04:56 PM
Quote:
Originally Posted by Datenpapst (Post 2340450)
is there a betting option for the European Championship?
yes m8 there is :up:

Datenpapst 06-17-2012 05:05 PM
Well but its not working with 4.1.10 or 4.2? ^^

ProFifaLeagues 06-17-2012 06:06 PM
Working fine on both mate I am using it on 4.2 with the Euros and used it on 4.1.10 too until the last week or so

madddenaddicto 06-17-2012 06:39 PM
When do the upcoming leagues usually come out?
How long before they start?

ProFifaLeagues 06-17-2012 07:03 PM
Depends on the Fixtures being Released for Each League mate.
English Premier league comes out tomorrow So maybe soon we will see that added with any luck

scaramanga 06-18-2012 09:06 AM
Quote:
Originally Posted by W!cKeD (Post 2339244)
Search in vbsoccer.php the query and put this =>
PHP Code:
$vbulletin->db->query_read("
    SET sql_mode='NO_UNSIGNED_SUBTRACTION';
        "); 
befor the query.
That worked perfectly, thanks! It seems to me this error happens if you predict more away goals than home, making home - away < 0.

The only query I can't find is the hall of fame one - I have that issue there. Do you know where to find it?

betts02 06-19-2012 07:52 PM
When will they new seasons be added ?

Many thanks and keep up the great work

Datenpapst 06-24-2012 06:37 AM
Tested the whole script seems to work fine with 4.2 but there is one bug:
the pagnavigation in the ranking.

If you got 2 pages and you wanna go to the 2nd one by clicking on the "2" this links is called:
http://www.c-arena.com/vbsoccer.php?...do=ranking&l=1

But it should be this link:
http://www.c-arena.com/vbsoccer.php?...ing&l=1&page=2

Maybe you can fix this quiet easily? If not I gonna have to take a closer look at the script.

beertruck 06-25-2012 06:05 PM
ForceHSS thanks for the great mod! One question. Is there any way to add to user reputation for every guessed game, score etc?

betts02 06-27-2012 09:41 PM
Quote:
Originally Posted by ForceHSS (Post 2342861)
This has already been asked please search for answer
Ive searched and for the life of me i can not find it,lol

nick-harper 07-04-2012 08:04 AM
Is there a way to add a league? I am happy to make a donation :) My team has been relegated :(

madddenaddicto 07-11-2012 12:19 AM
Ok. The German Leagues are out!! When can we expect the other leagues?

liesislief 07-12-2012 03:12 PM
Quote:
Originally Posted by madddenaddicto (Post 2346842)
Ok. The German Leagues are out!! When can we expect the other leagues?
On the vbulletin-germany.org the author has said this year will only be germany, because the high costs for data.

betts02 07-12-2012 09:22 PM
Quote:
Originally Posted by liesislief (Post 2347305)
On the vbulletin-germany.org the author has said this year will only be germany, because the high costs for data.
Is this true ?

If so i will have to remove it due to we only use the English Leagues

Hope they do get used

ProFifaLeagues 07-13-2012 09:17 AM
Gutted to hear that it will be the german league only this coming Season as its such a Class mod and there is not one that matches it out there for us!

Hopefully the maker may even look at subs and then bring in other leagues like the Premier League again with any luck


All times are GMT. The time now is 09:31 AM.
Page 34 of 42 « First 243233 34 3536 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.02728 seconds
  • Memory Usage 1,834KB
  • 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
  • (3)bbcode_code_printable
  • (2)bbcode_php_printable
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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