vb.org Archive
Page 102 of 108 « First 25292100101 102 103104 Last »
Show 40 post(s) from this thread on one page

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)

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!


All times are GMT. The time now is 05:06 AM.
Page 102 of 108 « First 25292100101 102 103104 Last »
Show 40 post(s) from this thread on one page

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.03410 seconds
  • Memory Usage 1,747KB
  • 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
  • (2)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