PDA

View Full Version : anyway to move point in bank out to their cash on hand


pelican
01-24-2005, 10:45 PM
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
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.

UPDATE user, utt_store_bank SET user.uttpoints=user.uttpoints+utt_store_bank.amoun t WHERE user.userid=utt_store_bank.userid;

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

pelican
01-25-2005, 11:25 AM
havent tried yet. but thanks.

mindbuster
02-04-2005, 07:46 PM
Anyone tried this ?

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

pelican
10-05-2005, 02:17 AM
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.