Version: 1.0.7, by Andreas
Developer Last Online: Jan 2023
Version: 3.5.3
Rating:
Released: 08-11-2005
Last Update: 02-17-2006
Installs: 633
DB Changes Uses Plugins Template Edits
Additional Files Is in Beta Stage
No support by the author.
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.
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?
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.
Quote:
Originally Posted by punchbowl
Me too. Any one else?
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?
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?
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...
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?