[GreigM]

Originally Posted by msu2k

For people wondering how to reset all user's vCash to 500, you need to execute this SQL query:

UPDATE user SET vbookie_cash=500;

If you totally want to clear all past events as well, execute these SQL queries:

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

Run these at your own risk...you may want to backup your DB first before running them. I run these once each year and have not had any problems with them.

from the old thread, just ran it on my install and it set everyone to 1000 which is what I set the vcash too

edit: actually this will work for members currently registered but anyone new would still start with 500, would it be possible to add a admincp option to set the default vcash value? I guess the 500 default is set in the xml import, maybe we could just change it in there?