Help:Query reset gold from game

hello
please can any one help me
i need query reset gold from players and from them inv and from them guild and from pets i need reset gold from all game please

Use SRO_VT_SHARD
update _Char Set RemainGold ='0'
Where CharID >0

it's for his inv only
i need from his guild storage and his storage (how ) !

you can make easy from smc.

How ?

- - - Updated - - -

Quote:

---

Originally Posted by BadFist

you can make easy from smc.

---

how i can do it ?

- - - Updated - - -

No one know how to reset Gold !!!

Code:

---

update _Char set RemainGold = 0 where CharID >= 0
update _Guild set Gold = 0 where ID >= 0
UPDATE _AccountJID set Gold = 0 where JID >= 0

---

Quote:

---

Originally Posted by saxz

Code:

---

update _Char set RemainGold = 0 where CharID >= 0
update _Guild set Gold = 0 where ID >= 0
UPDATE _AccountJID set Gold = 0 where JID >= 0

---

---

Thaank you ,you are king
working 100000 %
Big thanks
-another problem please i hope you can help :
when i try to sell items trade i got DC [trade from jangan to dw]
how i can fixed it ?