vBookie for vBulletin 3.5

vBookie

Introduction

This is a Port of the original vBookie Hack created by tdjrico; full credits to him for the idea and the kind permission to port his work

A t t e n t i o n
This Hack is unsopported and incompatible with vBulletin 3.6+
You are hereby advised to not use it.
Please do not ask me about support and/or updates - there will be none.

[cedar]

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]

Anyone got this working on a beta 3.8 yet ?

[Cobra-J82]

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

[Bounce]

Originally Posted by Cobra-J82

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

Indeed, please someone take over and update this mod

[Maxman1544]

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]

Originally Posted by Maxman1544

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]

Originally Posted by Maxman1544

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]

Originally Posted by Cobra-J82

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]

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]

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.