vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vBookie for vBulletin 3.5 (https://vborg.vbsupport.ru/showthread.php?t=94128)

cedar 10-29-2008 04:31 PM

Because 3.7.3 has some different code with 3.6.x, so you should search for calendar only, and remove the whole lines between <td ...> and </td>!You are recommended to know a little of html to do it correctly...

@all : why some of my member has a vCash of 18446744073709551416???What's wrong???

Bounce 10-31-2008 05:48 PM

Anyone got this working on a beta 3.8 yet ?:cool:

Cobra-J82 11-01-2008 03:34 AM

Its a Pitty such a Good mod with no Support or Update.

Bounce 11-01-2008 09:14 PM

Quote:

Originally Posted by Cobra-J82 (Post 1656939)
Its a Pitty such a Good mod with no Support or Update.

Indeed, please someone take over and update this mod :rolleyes:

Maxman1544 11-02-2008 12:46 AM

With over 12,000 bets placed and 6,000 records in some of the other tables the vbookie queries are hanging my server. Taking 10 minutes to run, it is killing our cpu.

$result = $db->query_read("
SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_
FROM " . TABLE_PREFIX . "vbookie_items AS item
LEFT JOIN " . TABLE_PREFIX . "vbookie_groups AS grp ON grp.group_id = item.group_id
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON thread.vbookie_item_id = item.item_id
WHERE item.item_status='".$db->escape_string($type)."'
ORDER BY $orderby item.item_id DESC
LIMIT $limit, $perpage

and this one

// Most bet-on Events
$result = $db->query_read("
SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_
LEFT JOIN " . TABLE_PREFIX . "vbookie_groups AS grp ON grp.group_id = item.group_id
ORDER BY item.item_n_bets_placed DESC
LIMIT 5

I wonder if I prune the data if it would help. Any thoughts?

Maxman1544 11-02-2008 12:55 AM

Quote:

Originally Posted by Maxman1544 (Post 1657583)
With over 12,000 bets placed and 6,000 records in some of the other tables the vbookie queries are hanging my server. Taking 10 minutes to run, it is killing our cpu.

$result = $db->query_read("
SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_
FROM " . TABLE_PREFIX . "vbookie_items AS item
LEFT JOIN " . TABLE_PREFIX . "vbookie_groups AS grp ON grp.group_id = item.group_id
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON thread.vbookie_item_id = item.item_id
WHERE item.item_status='".$db->escape_string($type)."'
ORDER BY $orderby item.item_id DESC
LIMIT $limit, $perpage

and this one

// Most bet-on Events
$result = $db->query_read("
SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_
LEFT JOIN " . TABLE_PREFIX . "vbookie_groups AS grp ON grp.group_id = item.group_id
ORDER BY item.item_n_bets_placed DESC
LIMIT 5

I wonder if I prune the data if it would help. Any thoughts?

http://www.vbulletin.com/forum/showp...3&postcount=85

Seems like the same issue I am having, interesting.

Maxman1544 11-02-2008 12:28 PM

Quote:

Originally Posted by Maxman1544 (Post 1657589)
http://www.vbulletin.com/forum/showp...3&postcount=85

Seems like the same issue I am having, interesting.

Well -- not to keep talking to myself, but just to document this -- we ran that query above and created the index. So far it looks good. The table doesn't get locked when vbookie queries are running.

I will probably purge some of the bet history as well to make the data smaller. But for now things seem better.

msu2k 11-07-2008 07:14 PM

Quote:

Originally Posted by Cobra-J82 (Post 1656939)
Its a Pitty such a Good mod with no Support or Update.

Yep, this mod is essential to my site at this point. I would be willing to pay for someone to support and update this mod.

chick 11-10-2008 02:13 PM

I know I ran across it here but my hands are numb, I can't go though a thousand posts again, how do you incorporate it to work with vbcredits?

solved found it seaching forum https://vborg.vbsupport.ru/showpost....postcount=2055

chick 11-10-2008 02:23 PM

I have the bookie setup in forum ID 69

How would I go about adding the leader-board links from vbookie.php to the top of that forum ID 69

These links Bookie Home | Event Forum | Bet Statistics

Would this be an <if forumID 69 condition?????

Can someone help. That forum 69 needs easier maneuvering for members... they will become confused.


All times are GMT. The time now is 07:51 PM.

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.02737 seconds
  • Memory Usage 1,745KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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