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

[DS MrSinister]

How about the first post mate.

Download version 4.0.9

[MagicThemeParks]

Just to confirm: Is the style fix referenced in the 2nd post supposed to be entered before </head> in the "page" template? If so, it was already there and still showing a broken style. Any other suggestions on what we can do to avoid having the vBookie page displaying the header and footer issues?

EDITED: Just reread the posts near the suggested fix and realized it's not the "page" template, but the "VBOOKIE" template that needs that piece of code added. :up:

[Dismounted]

Just a heads up for those of you interested: dmActivityStream now has a vBookie integration.

[MagicThemeParks]

How can you increase the number of "News and Events" displayed on the vbookie.php page?

Edited: Found it. Open vBookie.php and go down to line 406 and change the "4" number in the following line to whatever you'd like.

$newsresult = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "vbookie_news ORDER BY news_id DESC LIMIT 4");

[dartho]

Originally Posted by MagicThemeParks

How can you increase the number of "News and Events" displayed on the vbookie.php page?

Edit vbookie.php search for $newsresult = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "vbookie_news ORDER BY news_id DESC LIMIT 4"); and change the 4 on the end with the number of news items you want disaplyed.

[lapiervb]

Could this be used to create an NFL Pool?

[Jellymedia]

Looking for a little support, if you don't mind. Our forum has been cripplingly slow for the last few days and it turns out that this query is tying up the user table in our database for at least 20 seconds each time:

PHP Code:

SELECT user.username, user.userid, user.vbookie_cash AS vcash, userban.liftdate, if( customavatar.dateline IS NULL , NULL , 1 ) AS hasAvatar, (

SELECT bet_id
FROM vbookie_bets_placed
WHERE userid = user.userid
AND bet_private = 'N'
AND bet_settled = 'Y'
AND bet_amount_won >0
ORDER BY bet_placed DESC 
LIMIT 1 
) AS lastwinid
FROM user
LEFT JOIN userban ON user.userid = userban.userid
LEFT JOIN customavatar ON customavatar.userid = user.userid
WHERE user.vbookie_cash >450
AND userban.liftdate IS NULL /* REMOVE THIS FOR REAL DATA */
AND (

SELECT bet_amount_won
FROM vbookie_bets_placed
WHERE userid = user.userid
AND bet_private = 'N'
AND bet_settled = 'Y'
ORDER BY bet_placed DESC 
LIMIT 1 
) >0/* ^^^^ REMOVE THIS FOR REAL DATA */
ORDER BY user.vbookie_cash DESC 
LIMIT 7 


Trouble is--or one of the troubles--is that I can't find where this is being executed, so I can't remove/rewrite it. Any idea?

[fly]

Why not just disable the product?

[dartho]

That query is not like any in the stock vbookie. You've modified it and added that in your self somewhere along the way.

Why not search through the vbookie.php and the includes/functions_vbookie.php files and also check the plugins associated with vbookie to see if you can track it down? Failing those you could search your database and also grep your files...

[dgparent]

How the hell do you actually add a event to bet on ??????