vb.org Archive - Add-On Releases - vBookie for vBulletin 4

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)

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"

All times are GMT. The time now is 09:43 PM.

Page 103 of 108

103

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02166 seconds Memory Usage 1,740KB 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 (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: