The Arcive of vBulletin Modifications Site.

anyway to move point in bank out to their cash on hand · **Released**: 01-24-2005

anyway to move point in bank out to their cash on hand.

i intend to deactivate the bank.

i think the bank point is not just store in a field in database.
it seems to store in a certain format along with other info in the field.

Link14716 · #2 01-25-2005, 03:50 AM

There is a table for the bank. If you are using MySQL 4.x, I believe you could use a query like this.

[sql]UPDATE user, utt_store_bank SET user.uttpoints=user.uttpoints+utt_store_bank.amoun t WHERE user.userid=utt_store_bank.userid;[/sql]

And then to clear the bank of all accounts, use these two queries.
[sql]DELETE FROM utt_store_bank;
UPDATE user SET uttstore_bankdata='';[/sql]

pelican · #3 01-25-2005, 11:25 AM

havent tried yet. but thanks.

mindbuster · #4 02-04-2005, 07:46 PM

Anyone tried this ?

I wanna turn off bank too, just dont wanna mess anything up.

pelican · #5 10-05-2005, 01:17 AM

Quote:

Originally Posted by mindbuster

Anyone tried this ?

I wanna turn off bank too, just dont wanna mess anything up.

anyone knows how to move the amount from bank to cash on hand. i wanted to close the bank.

after about 8 months of asking, it seems like no one knows how to move the cash from bank to hand.