[Req] Reset Gold Inventory/Locket Script please

[legionsNet]

Can someone share a script to wipeout/reset all goldfor inventory and locker?

TIA

 

[MarkLopez]

Use RanGame1
SELECT ChaInfo
SET ChaMoney = '0'

Use RanGame1
SELECT UserInven
SET UserMoney = '0'

Re-check database for variable name im not sure with this variable names.

 

[legionsNet]

Use RanGame1
SELECT ChaInfo
SET ChaMoney = '0'

Use RanGame1
SELECT UserInven
SET UserMoney = '0'

Re-check database for variable name im not sure with this variable names.

Msg 102, Level 15, State 1, Line 3Incorrect syntax near '='.Msg 102, Level 15, State 1, Line 7Incorrect syntax near '='.

 

[jetyao]

Msg 102, Level 15, State 1, Line 3Incorrect syntax near '='.Msg 102, Level 15, State 1, Line 7Incorrect syntax near '='.

Use RanGame1
go
update chainfo set chamoney='0'
go
update userinven set usermoney='0'
go