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

[dartho]

No idea why that would be happening - can you provide a link ?

[Ba'al]

Originally Posted by dartho

No idea why that would be happening - can you provide a link ?

Link

[dartho]

Given that those 2 OPEN events are the same 'book' but have different thread ID's, and those thread ID's are quite a spread (33249 & 5996), and that the vBookie item id is only 15 - I would guess that vBookie has only recently been installed - but was also installed sometime ago but not fully uninstalled or something and now you have multiple threads (real old ones and new ones) link to the same books.

You'll need to tidy up the database - uninstall and reinstall should work, but it might leave threads looking odd as they no longer have a bookie event link to them and of course all old bookie events will be gone - as would vcash balances.

Otherwise, you might be able to set the vbookie_item_id (in the thread table) to zero on all threads older than your first recent vbookie thread? This should remove the duplicate links.

[Ba'al]

Originally Posted by dartho

Given that those 2 OPEN events are the same 'book' but have different thread ID's, and those thread ID's are quite a spread (33249 & 5996), and that the vBookie item id is only 15 - I would guess that vBookie has only recently been installed - but was also installed sometime ago but not fully uninstalled or something and now you have multiple threads (real old ones and new ones) link to the same books.

You'll need to tidy up the database - uninstall and reinstall should work, but it might leave threads looking odd as they no longer have a bookie event link to them and of course all old bookie events will be gone - as would vcash balances.

Otherwise, you might be able to set the vbookie_item_id (in the thread table) to zero on all threads older than your first recent vbookie thread? This should remove the duplicate links.

Makes sense since we just went from 4.1.12 to 4.2.0 and we just had the new one on the dev. site playing with it and forgot to uninstall the old version before moving everything over, thanx brother

[Spangle]

I'm trying to use this for football matches but I am hitting a very big snag, I don't seem to be able to put more than one event in at a time, and only one event per post.

What I need to be able to do is set up a fixture list, and members bet on Home win, Away win, or a draw for each fixture.

[dartho]

You can only have one event, but in that event you would put multiple outcomes:

EVENT 1

Team A defeats Team B
Team B defeats Team A
Team A Draws with Team B
Team C defeats Team D
Team D defeats Team C
Team C Draws with Team D

etc.

[Storer]

Sorry if this has been posted else where, but when I create my thread and have set up the vBookie event, I click submit but when it loads the table and stuff are there but I can't actually bet.

Image attached.

Any help would be appreciated.




EDIT: Just logged out and confirmed that guests can see it properly.

EDIT: Also, after I abandon an event, I can see the table fine, I just can't bet (obviously).

[dartho]

Could you link me to your site and turn on template names in HTML comments?

[Ba'al]

Hey dartho,
We need your help, i know its been awhile since you gave me advice but our vbookie has been down and i have been to busy to get into it to much but after uninstalling and reinstalling we now get a database error that we just cant pin down, any help would be great.

[jonty]

We've a large-ish forum with 95k threads and almost 175k posts.
We get an intermittent delay when posting replies to non-bookie threads as well as delays when posting vbookie events.

Turns out it was a delay in a query

SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_pay_after, thread.threadid, thread.forumid, thread.postuserid
                 FROM vbookie_items AS item
                 LEFT JOIN vbookie_groups AS grp ON grp.group_id = item.group_id
                 LEFT JOIN thread AS thread ON thread.vbookie_item_id = item.item_id
                 WHERE item.item_status='SETTLED'
                 ORDER BY  item.item_id DESC
                 LIMIT 880, 20;

The simplest solution was to add an index on the mysql table 'thread' on the vbookie_item_id column. :up: