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.


_______________________________________

[Pro]

nvm... my bad - i found it on your website.

GREAT SYSTEM! THANKS! I'LL TRY TO DONATE SOON!

[limey]

Cool hack tjdrico! One of the best. Will install when I can.

[nydk]

Originally Posted by limey

Cool hack tjdrico! One of the best. Will install when I can.

I had some problems, but I worked through it... but now I was wondering this:

- Richest Members in vBookie Stats only shows my richest uShop/uCash members, except the 2 richest. The two richest have like $13.xx and $17.xx, and 3rd richest has $7.xx ... the list in vBookie starts at the $7.xx person. (If that made any sense)

- Also, when I click the option to add an event with the thread, I don't get taken to a "Post a vBookie Event" page... any ideas... ? I did set my usergroup to be able to add events

[tjdrico]

Originally Posted by nydk

I had some problems, but I worked through it... but now I was wondering this:

- Richest Members in vBookie Stats only shows my richest uShop/uCash members, except the 2 richest. The two richest have like $13.xx and $17.xx, and 3rd richest has $7.xx ... the list in vBookie starts at the $7.xx person. (If that made any sense)

- Also, when I click the option to add an event with the thread, I don't get taken to a "Post a vBookie Event" page... any ideas... ? I did set my usergroup to be able to add events

Regarding the first, which version of the installation file did you have? Is it version 1.0.3? Check the 'includes/functions_vbookie.php' file, and the 'function vbookie_get_richest()' function. You should see this code:

PHP Code:

    if ($vbookiesettings['ucash'] == 1)
    {
        $q = "SELECT u.username, (p.".$vboptions['uttpoints_pointsfield']."+0) AS cash FROM " . TABLE_PREFIX . $vboptions['uttpoints_pointtable']." AS p LEFT JOIN " . TABLE_PREFIX . "user AS u ON u.userid=p.userid ORDER BY cash DESC LIMIT 5";    
    } 


The main point here is that there is a "+0" on the uttpoints_pointsfield column, as this forces it to be an integer rather than a string.

The second suggests that you didn't make all the changes correctly, or missed one all together. One suspect would be this one in 'newthread.php':

FIND

PHP Code:

if ($newpost['postpoll']) 
        { 
            $url = "poll.php?$session[sessionurl]t=$newpost[threadid]&polloptions=$newpost[polloptions]"; 
        } 


AFTER, ADD

PHP Code:

// +++ vBookie 
        else if ($newpost['postvbookieevent']) 
        { 
            $url = "vbookie.php?$session[sessionurl]t=$newpost[threadid]&vbookieeventoptions=$newpost[vbookieeventoptions]&do=newevent"; 
        } 
        // --- vBookie 


The change above is what specifies the page you are directed to after submitting a new thread. Double check all the changes prescribed in the installation instructions.

[nydk]

Thanks for the quick reply...

- Regarding the first issue(how my Store uses decimals), is there a way to fix this? Or do you suggest changing my point system over to integers?? I liked the idea of dollars and cents

- New Event... well everything seems correct... I'm gonna try to double check...

ahhhh... found it :nervous:

PHP Code:

FIND
$newpost['polloptions'] = intval($_POST['polloptions']); 

AFTER, ADD
// +++ vBookie 
    $newpost['postvbookieevent'] = $_POST['postvbookieevent']; 
    $newpost['vbookieeventoptions'] = intval($_POST['vbookieeventoptions']); 
// --- vBookie 


That's what I forgot ... thanks again for your help

*clicked install*

[tjdrico]

Originally Posted by nydk

Thanks for the quick reply...

- Regarding the first issue(how my Store uses decimals), is there a way to fix this? Or do you suggest changing my point system over to integers?? I liked the idea of dollars and cents

Well, actually, the "+0" should just convert it to a number, not strictly an integer. The problem with the ordering was that the uttpoints field is a VARCHAR, so "ORDER BY" uses dictionary ordering. In dictionary ordering "8.5" comes after "700", so the numbers come out wrong. The "+0" forces them to be viewed as numbers, so "8.5" comes before "700".

I don't know why it uses a char field rather than a decimal or int for a numeric amount, but it seems to work OK and the +0 on my SELECT should fix it if it's not present in your copy of the file.

[deathemperor]

tjdrico, this is a great hack and how about: don't the money the users lost goes thrash, there should be an account like 'bet master' to keep all of the money users have lost and pay how much they won. and you should make it like: in ACP admin can have the option that if he wants the money goes to someone and if yes enter the user id of that person.
hope it gives more fun ^^

[Okiewan]

Silly question I'm sure, but how would one settle an event?
Is there not an option shown to do so until the end date/time has passed?

[tjdrico]

No, the "Settle" option is only shown once the "This event will pay out after" date has been reached. If you want to settle a bet before that time, edit it and change the date. Presumably, however, one wouldn't settle an event until the result is known, so it makes sense to set the "This event will pay out after " to that time in the first place. It defaults to being the same as the "accept bets until" date/time, which should be before the result is known.

[Okiewan]

Excellent hack. HOTM level stuff!