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

Given that those 2 OPEN events are the same 'book' but have different thread ID's, and those thread ID's are quite a spread (33249 & 5996), and that the vBookie item id is only 15 - I would guess that vBookie has only recently been installed - but was also installed sometime ago but not fully uninstalled or something and now you have multiple threads (real old ones and new ones) link to the same books.

You'll need to tidy up the database - uninstall and reinstall should work, but it might leave threads looking odd as they no longer have a bookie event link to them and of course all old bookie events will be gone - as would vcash balances.

Otherwise, you might be able to set the vbookie_item_id (in the thread table) to zero on all threads older than your first recent vbookie thread? This should remove the duplicate links.

Ba'al

02-22-2013 04:00 AM

Quote:

Originally Posted by dartho (Post 2405560)

Makes sense since we just went from 4.1.12 to 4.2.0 and we just had the new one on the dev. site playing with it and forgot to uninstall the old version before moving everything over, thanx brother

Spangle

03-01-2013 04:43 PM

I'm trying to use this for football matches but I am hitting a very big snag, I don't seem to be able to put more than one event in at a time, and only one event per post.

What I need to be able to do is set up a fixture list, and members bet on Home win, Away win, or a draw for each fixture.

dartho

03-02-2013 11:24 PM

You can only have one event, but in that event you would put multiple outcomes:

EVENT 1

Team A defeats Team B
Team B defeats Team A
Team A Draws with Team B
Team C defeats Team D
Team D defeats Team C
Team C Draws with Team D

etc.

Storer

03-05-2013 08:01 PM

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

dartho

03-06-2013 11:39 AM

Could you link me to your site and turn on template names in HTML comments?

Ba'al

03-18-2013 12:12 AM

Hey dartho,
We need your help, i know its been awhile since you gave me advice but our vbookie has been down and i have been to busy to get into it to much but after uninstalling and reinstalling we now get a database error that we just cant pin down, any help would be great.

jonty

04-11-2013 10:39 AM

We've a large-ish forum with 95k threads and almost 175k posts.
We get an intermittent delay when posting replies to non-bookie threads as well as delays when posting vbookie events.

Turns out it was a delay in a query

Code:

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 880, 20;

The simplest solution was to add an index on the mysql table 'thread' on the vbookie_item_id column. :up:

All times are GMT. The time now is 10:21 PM.

Page 99 of 108

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05513 seconds Memory Usage 1,746KB 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 (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)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: