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

[Neal-UK]

I'm getting this error when trying to view bookie statistics, and so are other users:

Database error in vBulletin 4.0.7:

Invalid SQL:
;

MySQL Error : Query was empty
Error Number : 1065
Request Date : Monday, September 20th 2010 @ 01:21:35 PM
Error Date : Monday, September 20th 2010 @ 01:21:35 PM
Script : myforumaddress/vbookie.php?do=stats
Referrer : myforumaddress/vbookie.php?do=bets
IP Address : **.**.**.**
Username : A User
Classname : vB_Database
MySQL Version : 5.0.91-community

EDIT: And fixed it by doing what it says here: https://vborg.vbsupport.ru/showpost....&postcount=350

[jretzer]

I've got a problem with two vBookie events. After the games finished, I came back to "settle the bets", but that option was gone. There are winners that deserve their points, but I can't do anything about it. Is there anyway to "unsettle" the bets so that I can fix the problem. Basically, the bets were settled with no winner chosen.

[dartho]

Originally Posted by Neal-UK

EDIT: And fixed it by doing what it says here: https://vborg.vbsupport.ru/showpost....&postcount=350

Thanks for getting back to us

Originally Posted by jretzer

I've got a problem with two vBookie events. After the games finished, I came back to "settle the bets", but that option was gone. There are winners that deserve their points, but I can't do anything about it. Is there anyway to "unsettle" the bets so that I can fix the problem. Basically, the bets were settled with no winner chosen.

Sorry - books can't be unsettled - you will need to manually calculate retruns and manually give cash to your users.

[neverstop]

Im having a problem settling bets.

It seems that when a certain admin of mine settles bets, he does not get paid on the outcomes. This only happens when this certain admin settles bets, and only h is payouts are affected. Can you think of any reason why this would happen?

[dartho]

Does it say he has been paid and give you the payout figure?

[neverstop]

yup he won multiple wagers on the book but did not receive the credits for the wins. It seems everyone else received what they were due. He is listed on the results page as being a winner.

We have been trying to trouble shoot it and it might only happen on events that he has created

[dartho]

I would guess a credits integration issue as I can;t think of any reason why vBookie would do this itself - are you using vbcredits version of integration, or the vbookies?

[neverstop]

I am using vbcredits. Im not sure what you mean about integration. I have it set in the admincp section of vbookie to use vbcredits but I am not using any of the vbcredits addon things they have for vbookie.

[dartho]

Maybe it's karma for removing credits/copyright from a free addon?

[neverstop]

busted i guess. i didnt read your terms obv. As you can see on my site I always keep copyrights (or buy branding free) but I have a reason (not an excuse) for removing them on vbookie. Im sure you wont care, but I removed it as I have a forum competing with me that basically rips all my ideas. Theyre a gambling forum too and this was such a success I wanted the competitive advantage. I had always planned on putting the credits back but forgot. Sorry bro.