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?