Need Query Delete Gold From all player

04/27/2016 12:27 gmroske#1
i Need Query Delete Gold From all player any one know Code?
04/27/2016 14:12 mtnman33#2
use SRO_VT_SHARD
go
update _Char set RemainGold = 0
04/28/2016 08:03 gmroske#3
Quote:
Originally Posted by mtnman33 View Post
use SRO_VT_SHARD
go
update _Char set RemainGold = 0
But maybe some one have gold at storge or storge guild.
04/28/2016 14:50 blapanda#4
Quote:
Originally Posted by gmroske View Post
But maybe some one have gold at storge or storge guild.
You need to learn how to query those simple stuffs by yourself.
This ain't advanced nor amateur queries, which you are requesting. Those are rated less than beginner.

Code:
USE SRO_VT_SHARD
UPDATE _AccountJID
SET Gold = 0
Edit: Try to figure out how to set gold values of guilds to zero. This may be a lesson for you actually to learn something.
04/29/2016 01:57 gmroske#5
Quote:
Originally Posted by blapanda View Post
You need to learn how to query those simple stuffs by yourself.
This ain't advanced nor amateur queries, which you are requesting. Those are rated less than beginner.

Code:
USE SRO_VT_SHARD
UPDATE _AccountJID
SET Gold = 0
Edit: Try to figure out how to set gold values of guilds to zero. This may be a lesson for you actually to learn something.
Thanks it`s Working :)