Help fast please [Query reset GOld]

01/16/2015 05:43 kubed#1
hello
can any one help me
i need query reset gold from all players and from them inv and them guild and pet
thanks
01/16/2015 14:19 Aaron*#2
use this query
Quote:
USE SRO_VT_SHARD
update _char
set remaingold = 'GOLD COUNT'

about storage gold i've checked _Chest many times and i can't find any row related to gold
01/17/2015 01:42 kubed#3
it's Query :
Quote:
update _Char set RemainGold = 0 where CharID >= 0
update _Guild set Gold = 0 where ID >= 0
UPDATE _AccountJID set Gold = 0 where JID >= 0