Wipeout/clear Alz

can someone share query to wipeout/clear alz on account like on inventory, warehouse, guild warehouse and on mail? thanks :)

Basic querry u have to know.

Quote:

---

UPDATE myTable SET myColumn =0
WHERE myCondition

---

find out your self how to do it.

USE [Server01]

Set ALZ='0' FROM cabal_char_table

already fix this, thanks !

USE SERVER01 (or you server game DB)
update cabal_warehouse_table set Alz=0
update cabal_mail_received_table set Alz=0
update cabal_mail_sent_table set Alz=0
update guild_warehouse_table set Alz=0
update cabal_Inventory_table set Alz=0
======================
If you want clear where alz more 1000 alz add WHERE ALZ >1000
update cabal_Inventory_table set Alz=0 WHERE ALZ >1000
:blush::):