vb.org Archive
Page 37 of 42 « First 273536 37 3839 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)

ProFifaLeagues 08-19-2012 10:52 AM
Quote:
Originally Posted by fco.sepulveda (Post 2358122)
You can add an own league?
No mate just the 20 or so that are setup for the mod

madddenaddicto 08-19-2012 10:53 AM
I got the points working correctly.
It was my mistake.
The spanish league is working fine.

I had it this way.

1 point for guessin the winner.
2 points for guessing the exact score.

Now, I have it this way.

1 point for guessing the winner.
1 point for guessing the winner with the goal diferential.
2 points for guessing the exact score.

AA> This mod is by the best mod out there.
You should charge per league download and add a few paid features to make it even better.

Thank you for this mod once again.
If you ever need any help, let me know.
I speak spanish and english.

madddenaddicto 08-19-2012 10:55 AM
Quote:
Originally Posted by fco.sepulveda (Post 2358122)
You can add an own league?
In the near future, they will add more leagues.

AA_ 08-19-2012 11:05 AM
Quote:
Originally Posted by ProFifaLeagues (Post 2358127)
No mate just the 20 or so that are setup for the mod
Code:
+---------+-----------+
| leagues | saison    |
+---------+-----------+
|      2 | 1999/2000 |
|      2 | 2000/2001 |
|      2 | 2001/2002 |
|      3 | 2002/2003 |
|      2 | 2003/2004 |
|      2 | 2004/2005 |
|      2 | 2005/2006 |
|      3 | 2006/2007 |
|      5 | 2007/2008 |
|      12 | 2008/2009 |
|      25 | 2009/2010 |
|      35 | 2010/2011 |
|      28 | 2011/2012 |
|      33 | 2012/2013 |
+---------+-----------+
;)

madddenaddicto 08-19-2012 12:57 PM
Awesome work.

Yshuya 08-20-2012 07:31 PM
Hello,

I have a problem with the module. Sql error to display result.
I do not understand very well the query.

Maybe someone has already met this problem and knows the solution.


Quote:
Database error in vBulletin 4.2.0:

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 `vbsoccer_user_bet` AS b
INNER JOIN `vbsoccer_match` AS m ON (m.`id`=b.`match_id`)
WHERE `dateline` BETWEEN 1343779200 AND 1346457600 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`)'
Error Number : 1690

AA_ 08-20-2012 07:41 PM
Quote:
Originally Posted by Yshuya (Post 2358556)
Hello,

I have a problem with the module. Sql error to display result.
I do not understand very well the query.

Maybe someone has already met this problem and knows the solution.
fixed in 1.4.25 RC6

Yshuya 08-21-2012 06:15 AM
Ok thanks.

madddenaddicto 08-21-2012 05:09 PM
I have this problem.
It only happens on this page.

http://www.iplayfifa.com/vbsoccer.php?do=overallranking

Warning: DateTime::modify() [datetime.modify]: Failed to parse time string (+-4.5 HOURS) at position 0 (+): Unexpected character in [path]/vbsoccer.php on line 3443

Please help.

AA_ 08-21-2012 06:03 PM
Quote:
Originally Posted by madddenaddicto (Post 2358770)
I have this problem.
It only happens on this page.

http://www.iplayfifa.com/vbsoccer.php?do=overallranking

Warning: DateTime::modify() [datetime.modify]: Failed to parse time string (+-4.5 HOURS) at position 0 (+): Unexpected character in [path]/vbsoccer.php on line 3443

Please help.
search in vbsoccer.php:

Code:
$dt->modify('+' . $vbulletin->userinfo['timezoneoffset'] . ' HOURS');
replace with:

Code:
$dt->modify(sprintf('%+d minutes', $vbulletin->userinfo['timezoneoffset'] * 60));

madddenaddicto 08-21-2012 08:36 PM
Thank you very much!

:up:

tidus78 08-21-2012 09:00 PM
Hi

My last update match is 27-07-2012....

League Serie A don't counts advances,any idea?

AA_ 08-21-2012 09:21 PM
Quote:
Originally Posted by tidus78 (Post 2358822)
Hi

My last update match is 27-07-2012....

League Serie A don't counts advances,any idea?
updated

tidus78 08-21-2012 09:34 PM
Powerful!

imported_hbs 08-25-2012 09:22 AM
Is it possible to add the Israeli Premier League ?
10x in advance

W!cKeD 09-03-2012 10:08 AM
Hi AA_

My last update match is 28-08-2012

Can you Please update it? Thanks

onfranco 09-06-2012 03:31 PM
Sorry, where are installation instuctions ?

onfranco 09-09-2012 05:24 PM
Now you can not add leagues. Do you have any idea? it seems that the server does not respond

hoangserip 09-10-2012 06:26 AM
Can you add a new plugin to create an our league, and I can input the score or manage our league myself (admin).
We really need that to public our scores, matchs to our member.
Please help. Thanks a lots ^^!

MattGarner 09-14-2012 08:21 PM
Has anyone noticed that on the UEFA Champions League 2012/2013 has the dates incorrect? Not sure about all dates but it says the first matches are on the 17th when they are on the 18th.

http://soccernet.espn.go.com/fixture...eague#?cc=5739

betts02 10-02-2012 07:20 PM
Is it possible to remove people from the tables ?

If so how without actually deleting the user

AA_ 10-03-2012 06:55 AM
Quote:
Originally Posted by betts02 (Post 2370280)
Is it possible to remove people from the tables ?

If so how without actually deleting the user
Code:
DELETE FROM soccer_user_bet WHERE userid=userid

betts02 10-03-2012 06:02 PM
Quote:
Originally Posted by AA_ (Post 2370418)
Code:
DELETE FROM soccer_user_bet WHERE userid=userid
what do i do with that code mate ?
Cheers

Tariq AlAli 10-05-2012 05:20 PM
Greetingz

When adding Champions League 2012/2013 it displays it in Gray (inactive). Any clue ?

Regards

Tariq AlAli

Bounce 10-19-2012 06:00 PM
Quote:
Originally Posted by betts02 (Post 2370542)
what do i do with that code mate ?
Cheers
Execute SQL Query in vb admin

nick-harper 11-08-2012 09:53 AM
On the sidebar block I get "Bets on this tournament have not yet been evaluated"

Even though when you go into it, it works fine.

ataozcelik 11-11-2012 07:52 AM
Hi there, is it possible to change the score for specific games? The results are not wrong but since the time/date were wrong some users misused and entered the scores after the actual game has been completed and I want to invalidate those matches for the competition, many thanks.

tipsterx 11-11-2012 12:22 PM
i did install but and import , but cant see ths product on my website :(((

KGI_Bling 11-28-2012 12:33 AM
--------------------------- IGNORE THIS _ FIXED IT!!!!!!!!!!!! -------------------------



Can anyone help me out here?

I'm getting a database error when I try to access the season rankings at:
/vbsoccer.php?do=ranking

Code:
Database error in vBulletin 4.2.0:

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 (`bet_home`-`bet_away`)=(`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 `match_day`, b.`userid`;

MySQL Error  : BIGINT UNSIGNED value is out of range in '(`*********`.`b`.`bet_home` - `*********`.`b`.`bet_away`)'
Error Number  : 1690
Request Date  : Tuesday, November 27th 2012 @ 04:46:57 PM
Error Date    : Tuesday, November 27th 2012 @ 04:46:57 PM
Script        : http://www.*********/vbsoccer.php?do=ranking
Referrer      : http://www.*********/vbsoccer.php?do=live
-------------------------------------------------

Anyone any ideas?

--------------------------- IGNORE THIS _ FIXED IT!!!!!!!!!!!! -------------------------

I fixed it... Thanks

Morpheuss89 12-03-2012 05:21 PM
any news ? =)

pape sets fire 12-03-2012 08:17 PM
Question: I can create my own leagues?

Morpheuss89 12-03-2012 10:23 PM
no you can't...

AA can u add Italy - Serie B ? some users are asking for it from 2 years xD will be really appreciated !

Morpheuss89 12-04-2012 02:21 PM
Quote:
Originally Posted by od3m (Post 2087293)
i can not save any tips, save button just dont work. any suggestions ??
same for me !! anyone know how to fix it ? :/

swapps 02-01-2013 05:13 PM
MySQL Error : BIGINT UNSIGNED value is out of range in...


I got the same error.
To fix it use CAST() in the SQL at (`bet_home`-`bet_away`)

Code:
...  (CAST(`bet_home` AS SIGNED) - CAST(`bet_away` AS SIGNED)) ...

lollodev 02-08-2013 02:48 PM
how can I add the Italian Language of Fussball-Tippspiele? Where do I upload the xml file?
Please let me know.

Ok, I found out how to do it...you need to overwrite the language.

madddenaddicto 02-09-2013 04:58 PM
When I put a draw result for the champions league example.. Valencia Vs PSG.. its tells me this.. You bet on a draw in 1 knockout matches. You will not be awarded any points for this, as a knockout match will always have a winner. Goals after extra time as well as the penalties will be counted for the final result!

This is the first leg and they can draw..
Can anyone help me with this?
How does this work?
Can I leave my result 1-1 and it will count?

lollodev 02-11-2013 10:40 AM
Quote:
Originally Posted by madddenaddicto (Post 2403114)
When I put a draw result for the champions league example.. Valencia Vs PSG.. its tells me this.. You bet on a draw in 1 knockout matches. You will not be awarded any points for this, as a knockout match will always have a winner. Goals after extra time as well as the penalties will be counted for the final result!

This is the first leg and they can draw..
Can anyone help me with this?
How does this work?
Can I leave my result 1-1 and it will count?
I have the same exact problem. Is there any special setting to fix this?

tsafarog 02-12-2013 01:07 PM
same problem here

lollodev 02-13-2013 03:04 PM
Quote:
Originally Posted by madddenaddicto (Post 2403114)
When I put a draw result for the champions league example.. Valencia Vs PSG.. its tells me this.. You bet on a draw in 1 knockout matches. You will not be awarded any points for this, as a knockout match will always have a winner. Goals after extra time as well as the penalties will be counted for the final result!

This is the first leg and they can draw..
Can anyone help me with this?
How does this work?
Can I leave my result 1-1 and it will count?
This also occurs with Europa League games.

There are games this week and next week...can we please have a solution to this problem?

lollodev 02-16-2013 11:04 AM
support seems dead....


All times are GMT. The time now is 12:40 PM.
Page 37 of 42 « First 273536 37 3839 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.03110 seconds
  • Memory Usage 1,840KB
  • 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
  • (7)bbcode_code_printable
  • (13)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