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???

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

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

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

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.

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.

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.

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

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.

How do I do that?

I have installed vBookie on my vBulletin 3.5 so it should be working, but there is no option for me to post an event.

I just rebuilt the bitfields and it works fantastic.

Is there anyways to change a bet that has been settled. The wrong box was clicked when settling bets. Can this be edited so the right box can be selected and appropriate points are distributed?

no only through database

I got it installed and working. One problem that I have seen asked a few times on here but didn't see an answer: I want to reset everyone's money each week to 500 (to have weekly contests). How would I go about doing this?

Is this something that can be explain so I can fix it? Will it adjust all the points or just the "WIN" word? Thanks in advance. You can PM me if that is easier.

I am not able to post vBookie events...I have the option when posting a new thread, but it just posts a regular thread....weird

just to inform you guys i have a coder on my payroll who is looking into creating a vbookie type script - its not taking over this one and porting it into a newer version it is starting from scratch to go through and create our own bookmaker mod.

Nice, I look forward to this!

if i remember right you would have to go INSIDE the vbookie table for BETS and find the proper bet (you can search by user id or i think the bet id) from there you can edit it you have two choices from switching from which team or you can just do it manually (by editing) the person's point amount and just post a note in the Vbookie thread

That would be absolutely awesome.

I certainly don't know the story as to why this is no longer supported and the code cannot be reused .......... it is a real shame.

Anyone have any suggestions as to why I have the option to post a vBookie event but it just posts a regular post? :(

I have installed this on 3.8 b3 and i cant save usergroup permissions it always revert to no.

Rebuild the bitfields

This was asked on the previous page, but has not been answered yet to my knowledge.

I am looking to reset all the vBookie stats (vCash amounts, bets placed, and totals on the stats page). I do not want to go into my database and redo everything since I'm iffy when it comes to SQL. Is there a way to reset these tables to get this done?

Has anyone ever came across the vb_vbookie_items - item_title getting updated with "Please your bets please"

Exactly what I was looking for. Thanks!

Me too. Any one else?

Is this working for you in 3.8?

If anyone else has this running on 3.8 please let us know, very curious to see if there are any issues.

Thanks!

i am running this on my test 3.8 (testing all my mods i have installed before i make the upgrade) and i am having no problems running vbookie

usergroups are fine, posting is fine, placing bets are fine

On 3.6.x - How do I edit this to not show $vbphrase[anon] but show the word?

You can run the SQL queries in AdminCP in the Maintenance menu.

For a complete vBookie reset run these SQL queries:

Reset everyone's vCash:

UPDATE user SET vbookie_cash=X;
where X= vCash (eg 500)

To totally clear all past events:

DELETE FROM vbookie_news;
DELETE FROM vbookie_bets_placed;
DELETE FROM vbookie_item_options;
DELETE FROM vbookie_items;
DELETE FROM vbookie_groups;

Some other useful vBookies queries people might find useful:

To remove a specific event:
DELETE FROM vbookie_items WHERE item_id = 'X';

replace X with the item id which you can get by mousing over the info link in the affected vbookie event.

To remove a news event:
DELETE FROM vbookie_news WHERE news_id = X';

To Abandon/Mitigate a wrongly settled event:

UPDATE vbookie_items SET item_status='CLOSED' WHERE item_id= 'X';

This will change it from Settled to Closed. Then click the Abandon Event link in the thread. This only returns the original stakes. vCash won as a result of the incorrect settlement is not taken away and changing the winner in the thread has no effect.


I've encountered the problem with ridiculously large vCash numbers too. Unfortunately there's a way to cheat which I won't go into. It can also occur unintentionally with slaved db servers. You can dramatically reduce it by not permitting events that allow more than one bet.

Following an update to vBulletin, the code below used to fix it so you could post vBookie events. It doesn't seem to work with vBulletin v 3.8.0 Any ideas on how I can get back the options to post vBookie events?

Thanks

if ($newpost['postvbookieevent'])
{
$vbulletin->url = 'vbookie.php?' . $vbulletin->session->vars['sessionurl'] . "t=$newpost[threadid]&vbookieeventoptions=$newpost[vbookieeventoptions]&do=newevent";
eval(print_standard_redirect('redirect_postthanks_ moderate', true, false));
}

I am having the same problem. If anyone has this working in 3.8 any insight would be appreciated.

I believe that it was posted in here that this works with 3.8.

It was working fine for me till 3.7.4 but after upgrading to 3.8.0 it has stopped working and not showing the option to create a vbookie event when i try to create a new thread...

Anyone experiencing the same issues????

I created a test event then deleted it, the problem i am having now is, when i go into the vbookie the test events is still listed as open but no option to delete it now. How can i get rid of this?

This used to work prior to vBulletin version 3.8.0. Unfortunately, it doesn't work with v3.8.0
Any ideas on how we can fix this?

Once I change that plugin as noted above, it now works fine. Thanks for the reminder!

The option to make a vbookie event doesn't show up anymore...it seems like this modification is going to die unfortunately unless someone updates it.

I doesn't work on mine! Did you do anything different other than copy that code in?