[jonty]

Originally Posted by GreigM

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?

ALTER TABLE user CHANGE COLUMN vbookie_cash vbookie_cash BIGINT(20) UNSIGNED NULL DEFAULT 1000  ;

Changes the default value to '1000' for new members (if you've already imported the product)