Add-On Releases - vBookie for vBulletin 4

Please See the first post for a F.A.Q.
I will endevour to link to useful posts within this thread there as I spot them. You should check there before posting issues etc.

This is a port of vBookie for vBulletin 3.5 by Andreas which was a port of vBookie - vBulletin Betting Hack by tjdrico. Permission was given by tjdrico to port this.

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'.

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.

Install Instructions
1. Unzip product file
2. Upload files from 'Upload' folder to your forum
3. Install product XML
[S]4. Edit "newthread" template as per readme.txt ionstructions[/S]
5. Set usergroup permissions
6. Set vBookie settings
7. Enjoy.
8. Check out Dismounted's Activity Stream addon
9. Click Mark As Installed and Rate

Upgrade instructions
same as above, but undo edits made in point 4 if upgrading from pre 4.0.7! (see readme.txt for more info)

Version Control
4.0.0 (19 Jan '10 ) - Initial Release
4.0.1 (21 Jan '10 ) - Removed some junk from templates, added enable private bets option
4.0.2 (24 Jan '10 ) - fixed options for hiding vcash, added some more stuff to teh settings screen, added some vCash utilities (reset balances, give to everyone, set default balance) and fixed some template bugs.
4.0.3 (25 Jan '10) - fixed bugs I introduced in 4.0.2 see post #109
4.0.4 (25 Jan '10) - fixed time zone not being saved, can delete events, + plus a couple other things.
4.0.5 (Australia Day '10) - no longer uses bitfields for permissions, fixed vCash display, fixed stats page error
4.0.6 (27 Jan '10) - fixed TABLE PREFIX issue in vBookie stats page
4.0.7 (23 Mar '10) - fixed redirect bug when editing events, fixed display of cash holdings in events, added plugin to make template mods (no template mods needed now) and updated code to 4.0.2 standards, added hooks for vbcredits integration.
NOTE 0- if upgrading from pre 4.0.7, you will need to eitehr revert your "newthread" temp[late, or manually undo template edits as there is now a plugin which does this for you. Check teh readme.txt in the archive for more info.
4.0.8 (31 May '10) - hopefully fixed bug with updating number of outcomes when editing events. To upgrade from previous version (4.0.7) just overwrite vbookie.php
4.0.9 (25 July 10) - Added ability to select Reputation points for currency. Phrased had coded text. Fixed bug in displaying vCash balance in postbit.
4.2.0 (21 August 12) Added in navigation manager Code for vBulletin 4.2, disabled old nav plugin
4.2.1 (24 January 13) Added missing template, fixed Nav code, fixed some small bugs

[Bozza]

Originally Posted by Bozza

Just re-installed this.

Does (or did) anyone have issue with vCash being displayed in postbit legacy? it duplicates for every post on the page of the thread. So, post 1 has vCash shown once, the tenth post on the page has the same thing 10 times and the 20th post on the page has it shown 20 times!

I've reverted my postbit templates to standard, but it's still happening, so I've had to turn off postbit display now, but I'd rather have it on if I can.

Anyone?

What it's doing is showing the vCash for the person who has made the post plus that for everyone else who has made a post on the same thread earlier than that person.

Example postbit from the 20th post on a thread:

Registered User
Join Date Oct 2013
Posts 1,114
vCash 500
vCash 750
vCash 3400
vCash 500
vCash 3400
vCash 1000
vCash 0
vCash 0
vCash 0
vCash 500
vCash 3400
vCash 0
vCash 3400
vCash 0
vCash 250
vCash 0
vCash 0
vCash 3400
vCash 995
vCash 3400

[dartho]

What version of vBulletin?

Could you also confirm which hook the "vBookie: Add Cash to Postbit" plugin is on and also the code in that plugin.

should be:

if (($this->registry->options['vbookieactive']) && ($this->registry->options['vbookiecash']=="vCash") && ($this->registry->options['vbookiecashon']))
{
$template_hook[postbit_userinfo_right_after_posts] .= "<dt>".$vbphrase['vbookie_vcash']."</dt> <dd>".$post['vbookie_cash']."</dd>";
}

[Bozza]

Originally Posted by dartho

What version of vBulletin?

Could you also confirm which hook the "vBookie: Add Cash to Postbit" plugin is on and also the code in that plugin.

should be:

if (($this->registry->options['vbookieactive']) && ($this->registry->options['vbookiecash']=="vCash") && ($this->registry->options['vbookiecashon']))
{
$template_hook[postbit_userinfo_right_after_posts] .= "<dt>".$vbphrase['vbookie_vcash']."</dt> <dd>".$post['vbookie_cash']."</dd>";
}

vB 4.2.0.

I can't find 'vbookieactive' or 'vbookiecash' if I do a search across all my templates, including postbit_legacy.

[dartho]

Plugins, not templates

[Prentice]

When performing a few different functions with vBookie, I'm getting the following:

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT
		SUM(bet_amount_won) AS sumbets
		FROM vb_vbookie_bets_placed
		WHERE bet_settled='Y' AND userid=372
		AND dateline > 315532800
		GROUP BY userid;

MySQL Error   : Unknown column 'dateline' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, July 26th 2014 @ 12:39:02 PM
Error Date    : Saturday, July 26th 2014 @ 12:39:04 PM
Script        : http://www.wfcforums.com/vbookie.php
Referrer      : http://www.wfcforums.com/showthread.php?52101-Test-2&p=982331
IP Address    : **.***.**.***
Username      : SM#16
Classname     : vB_Database
MySQL Version : 5.0.95

How can I fix this?

[RichieBoy67]

Hey peops, been years since I have used or set this up.

Is there any way I can set a cap per bet so if i have 10 things listed in a bet I can limit them to a certain amount? I don't want people to be able to bet all their money on one thing.

Thanks,
Rich

[RichieBoy67]

We are using this for a contest where the winner who has the most money at the end of the event will win first place.

The problem is many betters are betting all their vcash on one outcome.

I really need to limit the amount people can bet per outcome so they bet on more outcomes thus limiting the risk of ties.

Thanks

[EasyEazy]

Originally Posted by RichieBoy67

We are using this for a contest where the winner who has the most money at the end of the event will win first place.

The problem is many betters are betting all their vcash on one outcome.

I really need to limit the amount people can bet per outcome so they bet on more outcomes thus limiting the risk of ties.

Thanks

Maybe try this

https://vborg.vbsupport.ru/showpost....&postcount=734

Not sure if its what your looking for mate.

[RichieBoy67]

Originally Posted by EasyEazy

Maybe try this

https://vborg.vbsupport.ru/showpost....&postcount=734

Not sure if its what your looking for mate.

Thanks, kind of you to assist.

That is really close but I believe it alters the maximum bet. What I want to do is to just limit the max bet per outcome.

In other words if you have 5 race car drivers for example you will stop people from betting a large amount on each one by allowing them to only bet a certain amount on each one or the ones they want to bet on. They can still bet a larfge amount but must choose multiple race car drivers.

[dartho]

I think that post EasyEazy linked to is as close as you'll get to what you're after without finding someone to do some programming for you (which I can't do)