vBookie locking the thread table for 455 seconds! The whole site stops for that long. Look at how many rows examined! Dang these LEFT JOINs.

Did some digging:

mysql> select count(*) from thread;
+----------+
| count(*) |
+----------+
| 159281 |
+----------+

mysql> select count(*) from vbookie_items;
+----------+
| count(*) |
+----------+
| 844 |
+----------+

I think it scanned the entire thread table about 844 times to do the query, and it created temporary tables to boot.


My fix was to enter the following query:

create index thread_vbookie on thread (vbookie_item_id);

This costs sizeof(MEDIUM_INT)*159281 bytes of RAM to keep the needed field in RAM all the time.

At MEDIUM_INT = 2 bytes, it's 320K. At 4 bytes, it's 640K. Puny amount of memory to save all those table scans.

I'm pretty sure it worked, as I went to the vbookie.php page and did all kinds of sorts and they were instant.

Ok, I installed it, with no problems, I hadn't added any events yet, but the page was working. Now, when I click on the link, all I get is a blank white page. the php file is definitely still uploaded, and the link in the navbar is going to the right place, so, what's up?

Oh, and this is only when the hack is turned on. When its off, there's a standard 'you can't access this page' message.

Set the default to 100 in vbookie_cash in the user table in your mySQL db.

A lil help here?

Ok easy question here...how do you settle an event after the event has ended and you know the outcome? I can't seem to figure this one out and the online manual can't be found.

Thanks

bump...anyone?

Is there an uninstaller for this? I need to reinstall the queris

hi... i have this installed on my forums but when i set which usergroup to be able to bet it just wont let that usegroup bet...

any idea what could be the problem?

i want every usergroup to able to bet on events... so i set "can this usergroup bet on events" to yes...

but when i make an event it says "you may not bet on this event" ?!?!

help please.

great hack

How do I increase the number of Richest people displayed on the Stats screen?

works with 3.0.7?

Heya mate! Just curious, what happened to the vBookie sections on Respawned?

[high]* Lord Brar crosses fingers that you are still supporting this hack ;)[/high]

ok I installed this and everything seen good but when try to create a event after summit all the info .
I can see a preview but after hit summit new event nothing happen event isn't seen in vbookie area. or nothing xtra on the thread .
any help please?

TIA

When I go to the vbookie.php it duplicates the event and when I click to go to the thread of the duplicated event, it brings me to a different vbookie event's thread with the new event I added at the top, very weird! How do I fix this?

Hi everyone,
I installed this hack , everything sounds fine , i set admins to can post events in user groups .
In newthread.php it doesnt show that i can add an event or add a vbookie event ...
i double checked edits in newthread and they are there all
the code states if vbookie is on and usercan post events to show it, since ive done that i stilll cannot see add events ...
suggestions ?

i added new usergroup and a new member allowed there
it showed add a new bookie event to newthread that way ...
I went on , and when i am submitting new event it replies that i dont have access to view that page !
Permissions are confusing me , they are set but they act as if they aint

sorry for multiple posts , just to let anyone having any issue like this know this
admin wasnt able to place a new event , so i created new group although i did allow admins to place new events but i still had to create a group
Make sure group is non moderated ( i had problems because i had it moderated by mistake ) and i was searching and searching untill i was doing new group all over for that lousy simple button choice that i was in a rush to look at !

Same issue.

is a nice hack but no one to help any more .

does this work with VBulletin 3.0.7??

Works fine for me. :)

hi..i cant get the vBookies own cash to show up in postbit... all the code is correct and ive ticked "yes" in the vbookie options...but its still not showin?

Flow Fusion ,
Add a new group , a new user and login using that user ( specifying that this group CAN add events ) it will work.
I still couldnt let admin add events, but as long as i can login into another user who can its okey with me.

am confused about onething,
I just added new events and noticed that eventhough i allowed registered and moderators ( can bet on events ) . They were still NOT able to
So here is my way of fixing it :
In the edit which you do on showthread.php

$nopermission = 0;
if (!($forumperms & CANBET))
{
$nopermission = 1;

I replaced with
$nopermission = 0;
if (($forumperms & CANBET))
{
$nopermission = 1;

Which means i reversed the canbet perms , which is weird but this way the whole permissions worked exactly as i set them and instead of having a non working code or messed up , i had it working like a charm !
I posted it just incase someone wanted to try doing the same if having same problems with permissions issues.

ive installed it, so how does it work.

do members use there uCash points for the gambling? I have uCash/uShop installed. so wondering if thats how it works?

anothe question, do you have to make a thread to make a bet? is there a way to make bets without starting threads?

how i can add event ? i installed it, there is no error , I did add a group that can add Event , Edit Event ..... and then login with that group ...but i don't know i can add event ....could u please show me how to do that thing ? ( i am using v 3.0.7 ) is this working properly ?

vBookie works fine with 3.0.7. If you are having trouble and getting errors I would advise double checking your code modifications.

To create a new vBookie event you have to start a new thread ? but be sure to tick the box where it says "Yes, post a vBookie Event with this thread" as there is no way to add an event to a thread afterwards.

thanks . I got it!

some members created the bookie event but it doesnt get listed in the vbookie page why not?

looks like it doesnt like my board, i just un isntalled it until i get some support

cheers

Is it possible to automatically award members vcash after making so many posts?

use ucash/ushop for it

Hi the answer to my question is-

To reset everyone to whatever you want use : I cant see where in the admin to put it. When i search vbookie_cash i get 2 options which are-

vbookie_cash_bit

and

postbit


Do i just add that line (UPDATE user SET vbookie_cash=500;) in there somewhere? :( Thank. Also i know i dont wanna run before i can walk but id be as well asking if you dont mind. I prefer the avatars and post count etc down the left of the forum but find that the vbookie totals dont show if i have it that way.

All help appreciated as ive been fiddling for over 12hrs now and its got me down a bit.

Thanks

Great hack and thanks but is it possible to put a cap on what a person can bet, I.e i dont want anybody to be able to bet over 50 points on any event.

??? anybody? any suggestions?

ok sorted that but now im in REAL bother :(

Ive fell out with all the other admin on my forum over the running of our vbookie competition as they said my way was too tricky etc (but it aint) Everything is going great and i was pretty pleased with some of the events i had posted up

http://www.thedailypunt.com

So anyhow i ended up DELETING the first post from an event and i cant get to see the vbookie event. I understand it will payout folks money when it aint settled 7 days after it closes but thats after the end of our tourney :( I gotta work this out so all help would be very appreciated. Heres 2 other posts on the matter but i couldnt see a reply sorry :(



and....



thanks for the great hack but their gonna hack me in about 2 hours :( anyone know the answer?

thanks :hope

http://img145.echo.cx/img145/4452/bahhh5kg.jpg

:(

The golf one actually has quite a bit of cash on it all at diff prices so i'd love to be able to see it again but its disappeared into the ether :(

Ps i know youve had a discusion on this on this thread but your decimals odds ARE wrong at least in Europe. to us 7.00 = 6/1 as we include our stake. I belive American odds are as shown. Is there an easy way to change this?

Also i might as well ask if there is any way you can set a DAILY limit? I aint checked that yet so ill go do a search the now but if anyone could help me in my original question then i'll give them a virtual kiss. Thanks :(

Not sure if this is a bug or what.

I have vBookie set to where every registered user can bet, but only the Admin group can create/edit events.

We recently had an event where one of the moderators was able to pay out the bet at the end of the event. A quick double check of the permissions for that group confirmed it was set to bet only. Is vBookie set internally to allow any "staff" member to pay out? I had assumed that only the admin group would be able to do this.