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

[LgsOfChampions]

Originally Posted by EasyEazy

Had an issue with my template a while back. I tried this

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

Not sure if it will work for you though.

I don't do this much EasyEazy, however I'm going to do it for you!!!!

I bow down to you, almighty god...IT WORKED LOL

YOU DA MAN BRO!!!

thank you very much

dartho to save yourself a headache should add this fix to the top. thanks guys


update---------------------------

However now there is no links to place bets (open)

[dartho]

You create a new thread, and down where it says you can add a poll, there will be an option to add a vbookie event (assuming your permissions have been set right in admincp)

[LgsOfChampions]

yup that worked!!

side note--whats a good number to put for odds... i know it goes by giving the underdog the better odds over a beast team so something like 2 to 1?

[boggseric]

Having some issues with slow queries. Getting the good old copying to temp table and a healthy delay while that's done.

It's hitting the thread table so I'm guessing that's the problem as our thread table is rather large. Threads 878,024 Posts 14,841,008

Any idea if adding an index on thread.vbookie_item_id would help to speed these queries up?

Command: Query
   Time: 16
  State: Copying to tmp table
   Info: 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 0, 20
6 rows in set (0.00 sec)

Command: Query
   Time: 45
  State: Copying to tmp table
   Info: 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 0, 20

Command: Query
   Time: 3
  State: Copying to tmp table
   Info: 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='CLOSED'
                ORDER BY item.item_pay_after,  item.item_id DESC
                LIMIT 0, 20

etc...

thanks

[dartho]

No idea... Dare I say give it a go?

[boggseric]

I'm not that brave.

[wilford brimley]

having an issue where all the outcomes switch slots randomly but dont move the bets. anyone seen anything liek this? its like someone just moves the outcomes around

is there a way to log vbookie use? maybe someone hacked my forum

[wilford brimley]

i figured it out. if i edit the event..it flips the outcomes....it flips them top goes to bottom. open it up and just hit save agian and it fixes it back the right way...

any ideas.....?

edit; that was an event with only 3 items.

with more it makes them go into random places. the problem if the money placed stays in the same slot while the odds and names change slots. they stay together

[dawges]

I had to remove this addon sadly. vBookie was copying tables to tmp tables and locking up my forums.

I have seen other forums report this searching Google but no fix.

Has anyone had a problem like this?

My forum runs on two servers but I dont think that would be the issue would really like to know if there is a fix.

The question has been brought up here.

https://vborg.vbsupport.ru/showpost....1&postcount=12

[dartho]

I had a look at this.

Firstly - please note - I am not a database guy!!

That being said, I did some tests and found that adding an index to thread.vbookie_item_id reduced the query time on my test site from 15 seconds to 0.0010 seconds.

ALTER TABLE `thread` ADD INDEX ( `vbookie_item_id` )

edit: Just re-read boggseric's post and adding the above index was his original suggestion. I made (and unmade) several changes before coming to this one change which does indeed speed things up!