vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Add-On Releases - vBookie for vBulletin 4 (https://vborg.vbsupport.ru/showthread.php?t=233473)

dartho 09-05-2013 09:45 AM

Quote:

Originally Posted by LgsOfChampions (Post 2443300)
is there a way to fix this? It messes my site up

Looks like you fixed it?

1320Nation 09-06-2013 12:13 AM

Quote:

Originally Posted by dartho (Post 2443373)
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 09-06-2013 12:21 AM

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 09-06-2013 03:56 PM

Quote:

Originally Posted by dartho (Post 2443407)
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 09-06-2013 04:33 PM

Quote:

Originally Posted by LgsOfChampions (Post 2443753)
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....&postcount=846

Not sure if it will work for you though.

kylek 09-06-2013 10:00 PM

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 09-06-2013 10:06 PM

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 09-06-2013 10:11 PM

Quote:

Originally Posted by LgsOfChampions (Post 2443753)
nope! here is link, scroll to bottom when u get a chance....thanks

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

Try EasyEazy's suggestion

Quote:

Originally Posted by EasyEazy (Post 2443763)
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.


1320Nation 09-06-2013 10:22 PM

Quote:

Originally Posted by dartho (Post 2443587)
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 09-06-2013 10:38 PM

Quote:

Originally Posted by dartho (Post 2443801)
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 09-06-2013 10:49 PM

Quote:

Originally Posted by EasyEazy (Post 2443763)
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 09-07-2013 05:01 AM

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 09-07-2013 01:03 PM

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 10-13-2013 03:37 AM

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?

Code:

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)

Code:

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

Code:

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 10-17-2013 05:28 AM

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

boggseric 10-27-2013 11:58 PM

I'm not that brave. :o

wilford brimley 11-03-2013 05:36 AM

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 11-03-2013 06:16 PM

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 11-04-2013 01:09 AM

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 11-04-2013 04:29 AM

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.

Quote:

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 11-04-2013 11:29 AM

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

dawges 11-04-2013 06:09 PM

Quote:

Originally Posted by dartho (Post 2458131)
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 11-04-2013 08:54 PM

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 11-04-2013 08:56 PM

Quote:

Originally Posted by madness85 (Post 2458161)
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 11-05-2013 04:33 AM

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 11-09-2013 02:00 AM

Quote:

Originally Posted by dartho (Post 2458233)
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 11-16-2013 05:32 AM

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 11-16-2013 06:34 AM

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 11-16-2013 02:52 PM

Quote:

Originally Posted by Storer (Post 2408137)
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/...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 11-18-2013 03:28 PM

Quote:

Originally Posted by madness85 (Post 2461121)
sadly i have this same problem

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

madness85 11-18-2013 07:51 PM

Quote:

Originally Posted by Spangle (Post 2461839)
Check usergroup permissions are set to "Can use V Bookie"

HI Spangle ive checked everything still looks the same

boggseric 11-19-2013 09:42 PM

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.

Quote:

Originally Posted by Jay-C (Post 16069880)
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 11-20-2013 10:07 PM

Quote:

Originally Posted by boggseric (Post 2462161)
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 11-30-2013 02:40 PM

Has anyone got this installed on 4.2.2?

kylek 11-30-2013 06:15 PM

Runs fine on 4.2.2

mort2412 11-30-2013 08:01 PM

Great thanks kylek

mort2412 12-08-2013 01:54 AM

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 12-21-2013 03:21 AM

Quote:

Originally Posted by mort2412 (Post 2466725)
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 12-23-2013 02:01 AM

Quote:

Originally Posted by mort2412 (Post 2466725)
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 12-23-2013 02:22 AM

Quote:

Originally Posted by Gamelobby (Post 2469777)
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.


All times are GMT. The time now is 04:00 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03826 seconds
  • Memory Usage 1,851KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (21)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete