vBookie for vBulletin 4

[dartho]

is there a way to fix this? It messes my site up

Looks like you fixed it?

[1320Nation]

You would need to know those numbers mean (which I don't) but I just looked at a betting site which had this to say:



So taking your example of:
Glover Teixeira (-440) vs. Ryan Bader (+350)

You would risk $440 in order to win $100 if you bet on Teixeira and you would risk $100 in order to win $350 by if betting on Bader.

To convert this to odds, just reverse the numbers. "100 to 1" means win 100 for every 1 bet, so using that based on the information above would give us:

Odds for Teixeira to win would be 100 to 440 (Win 100 for every 440 bet)
Odds for Baden to win would be 350 to 100 (win 350 for every 100 bet)

Thanks for the response. So based on that, would you then enter the odds as....
Teixeira to win "1 to 4.5"
Bader to win "3.5 to 1"

Also is anything you know of that can simplify setting up say all the weeks scheduled NFL game's?

[dartho]

Yep - although I can't remember if vbookie takes decimals, if not 2 to 9 and 7 to 2 would be the same as "1 to 4.5" and "3.5 to 1". That being said, "100 to 440" is totally valid, and possibly looks more "right" to those that are familiar with odds in the -440 / + 350 format

No easy way to set up the weekly schedules, other than get someone else to do it :) On my site I have the normal moderators AND I also created a "bookmakers" group with the permissions necessary to do the vbookie stuff.

[LgsOfChampions]

Looks like you fixed it?

nope! here is link, scroll to bottom when u get a chance....thanks

http://www.leaguesofchampions.com/vbookie.php

[EasyEazy]

nope! here is link, scroll to bottom when u get a chance....thanks

http://www.leaguesofchampions.com/vbookie.php

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

https://vborg.vbsupport.ru/showpost.php?p=2338427&postcount=846

Not sure if it will work for you though.

[kylek]

Did a quick search but found nothing.

On a site I have just set vbookie up to use vcash and everything looks like its working however when I place a bet, and click bet now, the page refreshes and the bet does not show, and it also does not show in the vcash postbit display as removed.

Now after doing another refresh then the bet shows and the proper amount of vcash shows. Same with settling a bet, you select winner, click on settle, it doesn't show bet settled until you do another refresh and then it shows as settled.

Is this the way its supposed to work or should it update bets, vcash amounts, etc without having to do extra page refreshes?

[dartho]

No - that's not how it's meant to happen. Sounds like your database is slow to be updated, or that there is some caching going on either in your browser or server ?

[dartho]

nope! here is link, scroll to bottom when u get a chance....thanks

http://www.leaguesofchampions.com/vbookie.php

Try EasyEazy's suggestion

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

https://vborg.vbsupport.ru/showpost.php?p=2338427&postcount=846

Not sure if it will work for you though.

[1320Nation]

Yep - although I can't remember if vbookie takes decimals, if not 2 to 9 and 7 to 2 would be the same as "1 to 4.5" and "3.5 to 1". That being said, "100 to 440" is totally valid, and possibly looks more "right" to those that are familiar with odds in the -440 / + 350 format

No easy way to set up the weekly schedules, other than get someone else to do it :) On my site I have the normal moderators AND I also created a "bookmakers" group with the permissions necessary to do the vbookie stuff.

Great and again thanks for the info.

Do you know of a method that can simplify setting up say all the weeks scheduled NFL game's? Or do we have to enter them individually as it appears?

[kylek]

No - that's not how it's meant to happen. Sounds like your database is slow to be updated, or that there is some caching going on either in your browser or server ?

Thanks Dartho for the quick reply. We have xcache set on the server so that could be why its not updating right away, will see if thats the culprit.

Edited: found out its firefox cache thats doing it, works in chrome and IE instantly, now have to figure out what to do with firefox.

[LgsOfChampions]

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

https://vborg.vbsupport.ru/showpost.php?p=2338427&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. :o 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. :o

[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.php?p=1677771&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!

[madness85]

So is it possible to use my own credit system with this? I'm using dbtech shop cash atm.

[dawges]

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.



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!

Hi Dartho is this something that has to be done manually? I am not a database guy either.

[dartho]

Yep - you need to run the following query on your thread table

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

or if you use phpmyadmin, you could browse to the thread table, select the 'Structure' tab, check the vbookie_item_id field and click the 'Index' icon to add an index.

[dartho]

So is it possible to use my own credit system with this? I'm using dbtech shop cash atm.

Yes - you can write plugins to do this. Have a look at the vbookie_functions.php file

[boggseric]

Excellent Dartho. When I get a chance I will run a backup and make the change and see if it does the same speedup on our forum.

[dawges]

Yep - you need to run the following query on your thread table

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

or if you use phpmyadmin, you could browse to the thread table, select the 'Structure' tab, check the vbookie_item_id field and click the 'Index' icon to add an index.

Thanks dartho. Re-installed and indexed. Lets see how it goes.

[mmacrypt]

Header spacing question, maybe?? ;) All of my site respects the top area but vbookie doesn't, it cuts off most of the header area. Is there a way to add space in one of the vbookie files?

https://vborg.vbsupport.ru/external/2013/11/31.png

https://vborg.vbsupport.ru/external/2013/11/32.png

[mmacrypt]

Sorry guys, I kept searching and found the solutions here. Just incase somebody else comes along.

had to add
{vb:raw headinclude_bottom}
before the
</head> the in the VBOOKIE Style

Thank you Robbed

[madness85]

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.

https://vborg.vbsupport.ru/external/2013/11/1.png?1362517275


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).

sadly i have this same problem

[Spangle]

sadly i have this same problem

Check usergroup permissions are set to "Can use V Bookie"

[madness85]

Check usergroup permissions are set to "Can use V Bookie"

HI Spangle ive checked everything still looks the same

[boggseric]

Anyone seen issues with people getting like 28 trillion in vcash? Our forum is large and has hiccups everynow and then so I thinking the users is placing a bet and it's going through but doesn't appear to go through then the user places the bet again and then end up with a negative value. Now I'm assuming the variable being used is unsigned so instead of the negative value it's showing the extremely large value.

Ahhhhh you took my money:(.. Once I placed all my bets I had 200 vcash and put it all on Bama and it froze up and clicked again and instead of saying I had 0vcash it gave me all that money.. Although I tried to bet to see if it would let me but it wouldn't, all my bets were my money except it voted for Bama twice:D so minus the $200 all the bets were legit.. I should have 0 as of now, do I get any points for being honest:jest:??

I'm on a old phone so forgive my spelling:)..

[dartho]

Now I'm assuming the variable being used is unsigned so instead of the negative value it's showing the extremely large value.

That's right. The db or webserver would need to be slow or glitch at a specific point for this to happen, but it can - making your currency signed (user.vbookie_cash if using the default) should stop this from being able to happen.

[mort2412]

Has anyone got this installed on 4.2.2?

[kylek]

Runs fine on 4.2.2

[mort2412]

Great thanks kylek

[mort2412]

In main vbookie window, under the item heading for the list of events, under each event there is:
Thread | Info | Delete

Where would I find the template to edit 'Thread' I'd like to change the link text to 'Place Bet'

[Gamelobby]

In main vbookie window, under the item heading for the list of events, under each event there is:
Thread | Info | Delete

Where would I find the template to edit 'Thread' I'd like to change the link text to 'Place Bet'
Great idea.. a link to where they can actually make the threads.!!
Also, is there a way to earn vCash for people to spend.? (besides winning bets, like activity)

Thanks

PS. if im running 4.2.0 which version should i upgrade to.?

[dartho]

In main vbookie window, under the item heading for the list of events, under each event there is:
Thread | Info | Delete

Where would I find the template to edit 'Thread' I'd like to change the link text to 'Place Bet'

check the vbookie_main_items_bit template and change the bit which is like:
<a href="showthread.php?t={vb:raw item.threadid}">{vb:phrase thread}</a>
to
<a href="showthread.php?t={vb:raw item.threadid}">Place Bet</a>

[dartho]

Great idea.. a link to where they can actually make the threads.!!
Also, is there a way to earn vCash for people to spend.? (besides winning bets, like activity)

Thanks

PS. if im running 4.2.0 which version should i upgrade to.?

As for a link to where people can make vbookie threads - that is entirely dependent on how you set up your site. You'd just link them to the forum in which you want/allow them to create vbookie events/threads.

There are other "cash" systems available here (vb.org) that provide ways of earning more cash which can work with vBookie.

[mort2412]

check the vbookie_main_items_bit template and change the bit which is like:
<a href="showthread.php?t={vb:raw item.threadid}">{vb:phrase thread}</a>
to
<a href="showthread.php?t={vb:raw item.threadid}">Place Bet</a>

Brilliant

Thanks dartho

[Alan_SP]

I have two questions:

Which version I should install, I have vB 4.1.12 (still not on vB4.2.x)?

And how vBookie stands with Google AdSense? I know they have policy against gambling. Can I use vBookie and still show their ads?

[boggseric]

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.



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!

Oh yea. That is a necessity. Day and night difference.

[Edgecrusher]

Hello there,

First post on the forum ever here!

Am I missing something here, because vBookie just isn't working on my 4.2.2 installation.

As this working for everyone?

[kylek]

I have it running on vb 4.2.2 with no problems. Make sure you check all your usergroup settings.

[Edgecrusher]

Thanks for reply kylek.

Really sorry, but a friend had uploaded vBookie, and I didn't realise he was getting permission errors on some files...

My fault, I changed permissions and re-uploaded, and we're good now. So in case I worried anyone, it does seem to all be working fine now.

Thanks kylek.

[blue6995]

Since updating to the latest version I cannot bet on an event and I don't seem to be able to settle an event either. I am sure I have the User-group ids set up correctly

[blue6995]

Since updating to the latest version I cannot bet on an event and I don't seem to be able to settle an event either. I am sure I have the User-group ids set up correctly

To answer my own question there was a compatibility issue with one of the mods I was playing around with for the events feature - Events Forum, so I've disabled that and everything is now working

[valendono]

Hi Darto,

I juts upgrade to 4.2.1
https://vborg.vbsupport.ru/external/2014/06/65.png

the Odds 12/10 should be 1.2 not 2.2 , but the cash is correct, its time 1.2.

How to fix this ?

[Bozza]

Just re-installed this.

Does (or did) anyone have issue with vCash being displayed in postbit legacy? it duplicates for every post on the page of the thread. So, post 1 has vCash shown once, the tenth post on the page has the same thing 10 times and the 20th post on the page has it shown 20 times!

I've reverted my postbit templates to standard, but it's still happening, so I've had to turn off postbit display now, but I'd rather have it on if I can.

[Bozza]

Just re-installed this.

Does (or did) anyone have issue with vCash being displayed in postbit legacy? it duplicates for every post on the page of the thread. So, post 1 has vCash shown once, the tenth post on the page has the same thing 10 times and the 20th post on the page has it shown 20 times!

I've reverted my postbit templates to standard, but it's still happening, so I've had to turn off postbit display now, but I'd rather have it on if I can.

Anyone?

What it's doing is showing the vCash for the person who has made the post plus that for everyone else who has made a post on the same thread earlier than that person.

Example postbit from the 20th post on a thread:

Registered User
Join Date Oct 2013
Posts 1,114
vCash 500
vCash 750
vCash 3400
vCash 500
vCash 3400
vCash 1000
vCash 0
vCash 0
vCash 0
vCash 500
vCash 3400
vCash 0
vCash 3400
vCash 0
vCash 250
vCash 0
vCash 0
vCash 3400
vCash 995
vCash 3400

[dartho]

What version of vBulletin?

Could you also confirm which hook the "vBookie: Add Cash to Postbit" plugin is on and also the code in that plugin.

should be:


if (($this->registry->options['vbookieactive']) && ($this->registry->options['vbookiecash']=="vCash") && ($this->registry->options['vbookiecashon']))
{
$template_hook[postbit_userinfo_right_after_posts] .= "<dt>".$vbphrase['vbookie_vcash']."</dt> <dd>".$post['vbookie_cash']."</dd>";
}

[Bozza]

What version of vBulletin?

Could you also confirm which hook the "vBookie: Add Cash to Postbit" plugin is on and also the code in that plugin.

should be:


if (($this->registry->options['vbookieactive']) && ($this->registry->options['vbookiecash']=="vCash") && ($this->registry->options['vbookiecashon']))
{
$template_hook[postbit_userinfo_right_after_posts] .= "<dt>".$vbphrase['vbookie_vcash']."</dt> <dd>".$post['vbookie_cash']."</dd>";
}

vB 4.2.0.

I can't find 'vbookieactive' or 'vbookiecash' if I do a search across all my templates, including postbit_legacy.

[dartho]

Plugins, not templates

[Prentice]

When performing a few different functions with vBookie, I'm getting the following:

Database error in vBulletin 4.2.2:

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

MySQL Error : Unknown column 'dateline' in 'where clause'
Error Number : 1054
Request Date : Saturday, July 26th 2014 @ 12:39:02 PM
Error Date : Saturday, July 26th 2014 @ 12:39:04 PM
Script : http://www.wfcforums.com/vbookie.php
Referrer : http://www.wfcforums.com/showthread.php?52101-Test-2&p=982331
IP Address : **.***.**.***
Username : SM#16
Classname : vB_Database
MySQL Version : 5.0.95

How can I fix this?

[RichieBoy67]

Hey peops, been years since I have used or set this up.

Is there any way I can set a cap per bet so if i have 10 things listed in a bet I can limit them to a certain amount? I don't want people to be able to bet all their money on one thing.

Thanks,
Rich

[RichieBoy67]

We are using this for a contest where the winner who has the most money at the end of the event will win first place.

The problem is many betters are betting all their vcash on one outcome.

I really need to limit the amount people can bet per outcome so they bet on more outcomes thus limiting the risk of ties.

Thanks

[EasyEazy]

We are using this for a contest where the winner who has the most money at the end of the event will win first place.

The problem is many betters are betting all their vcash on one outcome.

I really need to limit the amount people can bet per outcome so they bet on more outcomes thus limiting the risk of ties.

Thanks

Maybe try this

https://vborg.vbsupport.ru/showpost.php?p=2260040&postcount=734

Not sure if its what your looking for mate.

[RichieBoy67]

Maybe try this

https://vborg.vbsupport.ru/showpost.php?p=2260040&postcount=734

Not sure if its what your looking for mate.

Thanks, kind of you to assist.

That is really close but I believe it alters the maximum bet. What I want to do is to just limit the max bet per outcome.

In other words if you have 5 race car drivers for example you will stop people from betting a large amount on each one by allowing them to only bet a certain amount on each one or the ones they want to bet on. They can still bet a larfge amount but must choose multiple race car drivers.

[dartho]

I think that post EasyEazy linked to is as close as you'll get to what you're after without finding someone to do some programming for you (which I can't do)

[RichieBoy67]

I think that post EasyEazy linked to is as close as you'll get to what you're after.

Doesn't it limit the entire bet amount though? We have 21 possible outcomes in are contest and many people are betting all their points on one outcome. I would like to do the same exact thing as Ease mentioned only with outcomes and not the entire bet.

Anyhow, I appreciate the info.

[dartho]

Having a *quick* look, that does appear to be for each individual outcome in a book, not the total amount staked across outcomes for a book, so I think it should suit you needs.

[RichieBoy67]

Having a *quick* look, that does appear to be for each individual outcome in a book, not the total amount staked across outcomes for a book, so I think it should suit you needs.

Really?? Cool! I guess I misunderstood it. Thanks for getting me straight. I am going to try it today.

[RichieBoy67]

Having a *quick* look, that does appear to be for each individual outcome in a book, not the total amount staked across outcomes for a book, so I think it should suit you needs.

Hey Dartho,

I added the phrasing like I would normally do but there is no phrasetypeid and I am getting the phrase not found message. I thought this is now the fieldname and I tried vbookie and vbsettings for that..neither work.

Thanks

[dartho]

In the code, try using:
standard_error('You have exceeded the maximum amount of $100 per bet');
rather than
eval(standard_error(fetch_error('vbookie_exceeded_ max_bet')));

and forget about the phrases - at least to check that it works the way you want.

[RichieBoy67]

I should have thought of that! Simple work around! Thanks dartho!

[Toorak Times]

Hi Guys,

I am forever on the look out for ways I can improve or create new options for my gig guide, got a solid live music site, can this be adapted for a Gig Guide?

[Furcal]

I've tried running the build bit link, didn't help.

Anyway I can fix this....http://overtimeheroics.com/snip.PNG

Thanks!

[Furcal]

Is this mod supported still?

[kylek]

At the top it says "Not Supported"

[blue6995]

Is it possible to change the default number of outcomes from 2 to 3 etc? If it is, how would I do it?

Thanks

[MikeGF]

Is it possible to change the default number of outcomes from 2 to 3 etc? If it is, how would I do it?

Thanks

There is a button above the current outcomes to add more.

[airborneCAL]

Anyone still using this on vbulletin 4.2.5? I can't seem to find where to settle the bets anymore and I'm worried something broke when I upgraded.