Q>Zeny & Bank Wipe out

[Sallycantdance]

hello guys how can i wipe all characters zeny and character banks in sql thanks in advance

[Emistry]

shutdown the server and run the SQL script.

UPDATE `char` SET `zeny` = 0;
UPDATE `mail` SET `zeny` = 0;
UPDATE `acc_reg_num` SET `value` = 0 WHERE `key` LIKE '#BANKVAULT';

 

[mR L]

 

[Sallycantdance]

20 hours ago, Emistry said:

shutdown the server and run the SQL script.

UPDATE `char` SET `zeny` = 0;
UPDATE `mail` SET `zeny` = 0;
UPDATE `acc_reg_num` SET `value` = 0 WHERE `key` LIKE '#BANKVAULT';

 

hello emistry do you have any tutorials for running sql script? i only know how to delete it in table manually and my main problem is the bank because theres no bank tables in sql and i dont have any idea how to run a sql script im using sqlyog ultimate

[Emistry]

On 3/10/2022 at 4:46 PM, GM Winter said:

dont have any idea how to run a sql script im using sqlyog ultimate

a simple google search would have solved your questions.

https://sqlyogkb.webyog.com/article/46-executing-sql-queries

https://sqlyogkb.webyog.com/article/117-execute-sql-script

 

On 3/10/2022 at 4:46 PM, GM Winter said:

no bank tables

it stored as account variable, so its the acc_reg_num table.

[Sallycantdance]

7 hours ago, Emistry said:

a simple google search would have solved your questions.

https://sqlyogkb.webyog.com/article/46-executing-sql-queries

https://sqlyogkb.webyog.com/article/117-execute-sql-script

 

it stored as account variable, so its the acc_reg_num table.

thank you verymuch sir emistry