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

[New Joe]

does this work with vb4.2.0?

Or do I have to do any fixes from some of the above posts?
Will dartho be up dating this for 4.2.0?

[thenamesgould]

Originally Posted by sutto

Followed these steps, however I don't quite understand how to add the subnav aswell.
The nav is there and is working, however I just don't see any other options.

cheers

I'm not sure how to add the subnav parts either (assuming this is the links to the vBookie Home, Your Bets, Bet Statistics, Books part that goes below the vBookie tab).

Can anyone help with some explanation on how to do it? Pleeeease?

[sitwi]

Originally Posted by ChromeDome

I get this error when I surf on one of the vbookie pages:

Database error in vBulletin 4.1.8:

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

MySQL Error   : Unknown column 'dateline' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, November 17th 2011 @ 11:01:50 PM
Error Date    : Thursday, November 17th 2011 @ 11:01:50 PM
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :

I realise this was over six months ago, but would you be kind enough to share your solution please? What was the problem with vBExperience, as I'm getting exactly the same error message.

Thanks.

[wilford brimley]

Yes the sub nav isnt working even if you add that patch^

Hey, dartho, is there a way to change the display name of the vcash? even just how it reads under the avatars. I'd like to use a custom name. Thanks.

edit: i figured it out myself. search in phrases "vcash". edit phrase "vbookie_vcash" to whatever you want. i usually jsut add things to the "english translation" box and leave the original code.

[sitwi]

A partial solution to the sub-nav - here are the pages that it should link to:

vBookie summary: domain.com/vbookie.php
vBookie stats: domain.com/vbookie.php?do=stats
Open bets: domain.com/vbookie.php?type=OPEN
Settled bets: domain.com/vbookie.php?type=SETTLED
Your bets: domain.com/vbookie.php?do=bets

I'd be grateful if someone could give me some guidance on why my bookie page is breaking out of the template, please? See this page. (As opposed to the usual template). Thanks!

[EasyEazy]

Originally Posted by sitwi

I'd be grateful if someone could give me some guidance on why my bookie page is breaking out of the template, please? See this page. (As opposed to the usual template). Thanks!

Not sure if this will work but you could try inserting the code below in your VBOOKIE template of your custom style

{vb:raw headinclude_bottom}

Insert is just above the </head>

[sitwi]

That actually worked a treat, first time.

Thanks so much for taking the time - learning already how great the VB.org community is!

[New Joe]

Originally Posted by New Joe

does this work with vb4.2.0?

Or do I have to do any fixes from some of the above posts?
Will dartho be up dating this for 4.2.0?

Anyone

[sitwi]

Originally Posted by New Joe

Anyone

Seems to work, apart from the nav bar. It doesn't want to work with that, currently.

[sitwi]

Can anyone please give any pointers why this doesn't work with the navbar on 4.2, please?

It doesn't show, even on an otherwise vanilla installation with the default style?

Appreciate any help.