[madness85]

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

[dawges]

Originally Posted by 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.



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]

Originally Posted by madness85

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]

Originally Posted by 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.

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?

[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]

Originally Posted by 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).

sadly i have this same problem

[Spangle]

Originally Posted by madness85

sadly i have this same problem

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

[madness85]

Originally Posted by Spangle

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.

Originally Posted by Jay-C

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 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]

Originally Posted by boggseric

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