Resetting vCash in vBookie?!?!

[pdcimc1]

I have been researching this problem for a while now. I have scoured this site and google for the answer and I have found nothing but dead ends. Resetting the vCash has to be a common thing...Ive seen a lot people asking about this as well...but I swear on my life I cant find out how to do it anywhere in the AdminCP. If anyone knows how to do this PLEASE HELP! I know someone out there has to know how to do this.

THANKS!

[harmor19]

Go into you Admin CP
Maintenance --> Execute SQL Query

In the text area input

UPDATE user SET vbookie_cash="0";

This will change everyone's cash to zero.

[pdcimc1]

Thank you so much. The issue has been resolved and rather easily I must say. Cant thank you enough. :banana:

[harmor19]

I'm always glad to help.

Take care.

[sidewinder1]

so to just do a single member would you do it like UPDATE user235 SET vbookie_cash="0";

[Dismounted]

[sql]UPDATE user SET vbookie_cash = 0 WHERE userid = 123[/sql]

[CowboyJeffR]

I just executed the following SQL command from Admin CP / Maintenance / Execute SQL Query

PHP Code:

UPDATE user SET vbookie_cash="10000"; 


I get the following error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'Forum database.user' doesn't exist


What am I missing?

Fixed, I should have enter vb_user instead of just user.....

sorry for taking up space.