vb.org Archive - Integration with vBulletin - Soccer Betting Game ("Fussball-Tippspiele")

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)

search in vbsoccer.php:

Code:

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

replace with:

Code:

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

All times are GMT. The time now is 05:44 PM.

Page 145 of 167

145

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02762 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 (3)bbcode_code_printable (6)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
Messages: