The Arcive of Official vBulletin Modifications Site.

vBookie - vBulletin Betting Hack · **Released**: 06-03-2004

vBookie

Introduction

vBookie is a 'bookmakers' or betting extension to vBulletin. It enables authorised members to post Events and Outcomes that forum members can bet on. Each Outcome has its own set of odds, and odds can be modified through the life of an Event (bets that are placed are stored with the prevailing odds, so even if the odds change, your users are paid at the correct rate).

Once the results are known, Events can be settled and forums members awarded their winnings.

vBookie uses its own vCash by default, but this has no more use than as 'bragging rights'. However, vBookie also comes with a built-in switch to allow it to use either uCash or Petz money instead. That means that all bets are paid for and settled using uCash or Petz money, making betting even more attractive than just for fun on forums with uShop/Petz installed. Although vBookie does not have any built-in facility to integrate with any other store hacks, it's a very simple job to hack vBookie itself to integrate it with any store/points system you care to use.

Features

master switch to turn vBookie off
option to use uCash
option to use Petz money
settings to restrict the creation of Events to specific user groups
settings to restrict which user groups can bet on Events
settings to restrict which user groups can edit or settle other people's Events
per-Event, specify whether punters may bet on more than one outcome
optional 'charity mode' so that the poorest members of the forum always have something to play with
supplied with a module for vBadvanced

Please click

if you install this hack, thanks. Please also let me know - send me an email or a PM. If you'd let me know the forum URL too that'd be cool!

vBookie is free, and will remain free.

Updates

1.0.0 -> 1.0.1

- adds the ability to delete Events. See this post for upgrade instructions if you already have 1.0.0

1.0.1 -> 1.0.2

Corrected a minor bug with the charity mode when using uCash. See this post for manual upgrade instructions from 1.0.1.

1.0.2 -> 1.0.3

Corrected a minor bug with the richest people display when using uCash. Just overwrite includes/functions_vbookie.php with the one from the new Zip file.

1.0.3 -> 1.0.4

Corrected some date display problems when using "Detailed" dates. For manual update instructions, see this post.

Corrected Petz bug whereby all winnings were paid to the bet's owner rather than individual winners. To upgrade from 1.03 or earlier, see this post or overwrite includes/functions.vbookie.php with the 1.0.4 version.

Problems?

-> Petz - If you are using Petz there is a bug in all versions up to and inclusing 1.0.3. Your players won't get paid their winning, and all payouts will end up in the account of the person that posted the Event. To correct this, please see this post. This fix will be incororated into 1.0.4 onwards.

-> If you can't post Events, or can't bet on them make sure you have set your user permissions

-> If you have an SQL error Invalid SQL: UPDATE SET =25 WHERE <25 make sure you are using version 1.0.3 or later.

-> If you have any other general problems, please check the installation/hack instructions and make sure you have carried out all the steps and also check that you made the changes correctly

Anything else, ask in this thread.

Other Stuff

-> If you are using Detailed Date & Time display and have a problem with Event dates appearing as '1 Minute Ago', see this post.

-> If you want to use poster 'Reputation' as the currency for vBookie, see this post.

About Odds

Odds of "5/1" are "amount won per amount placed". This means that I would win 5 for every 1 placed. Of course, if I win, I get my stake back as well. Odds of "1/5" means that I win 1 for every 5 placed. I'd have to place 25 to win just 5.

Decimal Odds

Decimal odds are just another way of displaying the same information. 2.0 is the same as 2/1. 0.2 is the same as 1/5. vBookie only lets you specify odds in terms of x/y, but if you think in terms of decimal you can still work out what odds to provide. Simply think of your decimal odds as "2.0 / 1.0" or "0.5 / 1.0" and then multiply each side through by 10 or 100 until there are only zeros to the right of the decimal point, then just take the whole number part.

2.0 / 1.0 has no decimals, so this is the same as 2/1

0.5 / 1.0 has a 0.5, so multiply both parts by 10 to get 5.0 / 10.0. Then you can specify your odds as 5 / 10. You might also realise that this is the same as 1/2. The technique is a simple way to work out any odds you may need to specify.

Odds of 0.65 -> 0.65 / 1.0 -> 65.0 / 100.0 or 65/100. Then you can divide through by 5 to get to 13 / 20, although this step isn't necessary.

_______________________________________

Koopa · #**652** 08-12-2005, 07:18 PM

I have a problem. When I update a Bet, it redirects me to a different bet afterwards. I'm running vB 3.0.7.

Thanks

sonic3d · #**653** 08-13-2005, 01:51 AM

maybe i am just slow but i still dont understand how the odds work.

use this as an example:
Favorite...........Open.....Today.....O/U....Underdog
at Cincinnati.....2 1/2.....2 1/2.......37.....New England

what are the odds for cincinnate and the odds for new england. once someone shows me how its done then i can do the rest.

thank you

later
sonic

Lionsault · #**654** 08-13-2005, 02:50 AM

OK... I fixed that Marco, but now that the vBookie tab is to the side, there are no options for me to edit it.

Also, there is another tab, General Settings, which has no options when you expand it.

Lionsault · #**655** 08-13-2005, 10:45 PM

sorry bout the double post, but i fixed that problem above^

Now i got a new problem...

Everything works, I can get to the point of making the thread and then when i hit submit vBookie, this comes up:

Code:

Invalid SQL: SELECT  FROM  WHERE userid='4'
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM  WHERE userid='4'' at line 1

It appears to have something to do with my user ID settings perhaps, ID 4 on my forum is (COPPA) Users Awaiting Moderation which I do not use.

Help Please

Andreas · #**656** 08-15-2005, 08:42 AM

Security Warning

This Hack contained serious XSS and SQL injection vulnerbilities.
If you downloaded this Hack before 14.08.2005 19:10 CEST I strongly recommend to make the following changes immediately to keep your installation safe.

Security Warning

Code:

In vbookie.php (around line 226) find
--------------------------------------------------
if (!$_GET['type'])
	$_GET['type'] = 'OPEN';
--------------------------------------------------

BELOW that ADD
--------------------------------------------------
globalize($_GET, array('type' => STR_NOHTML));
--------------------------------------------------


FIND
--------------------------------------------------
$q = "INSERT INTO " . TABLE_PREFIX . "vbookie_bets_placed (option_id, item_id, userid, bet_amount_placed, bet_odds_against, bet_odds_for, bet_private) VALUES ($k, $item_id, $bbuserinfo[userid], $v, ".$odds1[$k].", ".$odds2[$k].", '$private')";
--------------------------------------------------

REPLACE that with
--------------------------------------------------
$q = "INSERT INTO " . TABLE_PREFIX . "vbookie_bets_placed (option_id, item_id, userid, bet_amount_placed, bet_odds_against, bet_odds_for, bet_private) VALUES ($k, $item_id, $bbuserinfo[userid], $v, ". intval($odds1[$k]).", ".intval($odds2[$k]).", '$private')";
--------------------------------------------------
		

In Template vbookie_main
FIND
--------------------------------------------------
$_GET[type]
--------------------------------------------------

REPLACE that with
--------------------------------------------------
$type
--------------------------------------------------

The ZIP File has been updated accordingly.

cuphongle · #**657** 08-15-2005, 05:03 PM

thanks, i just need help real quick

can someone please help me
i got everything installed...
i set up a bookie event and everything

but how do you bet?

foxy11 · #**658** 08-16-2005, 10:54 AM

Thanks for the warning Kirby!

Ski-Whiz · #**659** 08-17-2005, 07:09 PM

Anyone know how to limit the odds?? I know you can limit the bet, but with odds at like 100, it still pays too high. I'ld like to limit the odds..

Sorry if I'm missing something. I jsut didn't see where.. Thanks ahead of time!

Koopa · #**660** 08-18-2005, 05:47 PM

Quote:

Originally Posted by Koopa

I have a problem. When I update a Bet, it redirects me to a different bet afterwards. I'm running vB 3.0.7.

Thanks

Has no one any idea whats wrong with mine then?

Celtic_Mad · #**661** 08-21-2005, 07:29 PM

I have had a problem with this hack for a while now. Every time someone creates a new bet, it adds two links in the vbookie.php page. Below is a link to a screenshot I took of the problem...

http://img.photobucket.com/albums/v5...d/ed982b8f.gif

One links to the actual betting thread and the other links to another totally random vbookie event...it's very confusing.

Anyone know how to solve this?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05784 seconds Memory Usage 2,321KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!