vBookie - vBulletin Betting Hack

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.


_______________________________________

[LoOnEyToOnZ]

Originally Posted by da prez

this is correct because it subtracts initial bet from your total.

if you had $500 and bet $100 your new vCash total is $400
then when bet is settled you get what you bet $100 + wininngs $170 (@1.7 to 1 odds)

that is correct way to do it.

I thought the correct way would be for the $100 initial bet to be included within the $170 winning though.... since 1.7 odds usually means that you win only 0.7

[romeshomey]

Originally Posted by LoOnEyToOnZ

I thought the correct way would be for the $100 initial bet to be included within the $170 winning though.... since 1.7 odds usually means that you win only 0.7

No.

Say for instance you made a $10 bet on something with 42-1 odds.
Say you had $500 before making the bet.

If you lose, you would be down $10 and your balance down to $490, but if you win you would win $420 making your balance now $920.

I made a $10 bet on the Ravens to win the Super Bowl in 2000 on 42-1 odds before the season started. $420 was deposited to my account the day after the Super Bowl for my winnings.

So basically if you bet $10 on something on 10-1 odds and win, you would win $100, or if you lost would only lose your initial $10.

[da prez]

the easiest way to look at it is, if you laid a $50 chip down at vegas roulette wheel on black (1 to 1 odds),
and it came up black, you would get your chip back and another one.

betting in first 3rd 1-12 (3 to 1 odds)
if you bet $50 and you won, you would get first $50 chip and 3 more of them, etc.

[romeshomey]

Is it possible to retract a bid another user has made?

For example. I had a event set up for Eddie Georges signing. Betting on what team he would sign with.

There was no way to set a date that would end on the day and time of the event so it was left open.

Anyhow, when he signed, I had a bet made by someone for 400 vCash and it was a bet made after the event took place but I wasnt here to end the event when it actually ended.

So, how can I go about taking those winnings he made back?

Would it be possible to add a date and time to when each bet was made, and then to make it possible to edit vCash in the Admin CP under user information like you can for post count?

[joshskeety]

I get this error message when installing.. It gets to the "do database modifications" part and then I get..

Database error in vBulletin 3.0.1:

Invalid SQL:
CREATE TABLE vb3_vbookie_groups (
group_id SMALLINT UNSIGNED DEFAULT '1' AUTO_INCREMENT NOT NULL PRIMARY KEY,
group_title VARCHAR(255) NOT NULL
) TYPE=MyISAM

mysql error: Invalid default value for 'group_id'

mysql error number: 1067

Any solutions?

Josh

[romeshomey]

OK, I figured out how to edit amounts won, etc..

What can I do to add a date stamp to bets that are made so I can see date and time they are placed?

[RMS-Chef]

Originally Posted by romeshomey

OK, I figured out how to edit amounts won, etc..

What can I do to add a date stamp to bets that are made so I can see date and time they are placed?

Again, in the database, you would have to find the bet in question. There is a timestamp in there. This post may help: http://www.respawned.co.uk/forums/showthread.php?t=1832

[amairiya]

I currently have uShop installed and I am running vB 3.0.3

And I'm having some problems with the modification of init.php. I keep getting parse errors anytime I try to combine these pieces of code.

'stylecache', 
            // +++ vBookie 
            'vbookiesettings' 
            // --- vBookie 
        ), $specialtemplates);

and the one from uShop

	// ## <ucs>
			'stylecache',
			'utt_store_act'
// ## </ucs>
			), $specialtemplates);

If anyone has these two hacks installed and working properly, could you please tell me the piece of code that I need to put in the init.php file in order for them to work and not get parse errors? Thanks.

[amairiya]

nevermind I figured it out myself, thanks!

[joshskeety]

I get this error message when installing.. It gets to the "do database modifications" part and then I get..

Database error in vBulletin 3.0.1:

Invalid SQL:
CREATE TABLE vb3_vbookie_groups (
group_id SMALLINT UNSIGNED DEFAULT '1' AUTO_INCREMENT NOT NULL PRIMARY KEY,
group_title VARCHAR(255) NOT NULL
) TYPE=MyISAM

mysql error: Invalid default value for 'group_id'

mysql error number: 1067

Any solutions?

Josh