[HFB]

Originally Posted by Polish Guy

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.

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.