Query to reset gold

[szymo228]

Hello, i need a query to sql to remove all gold from my serwer.. :P

Its very important for me.


*for all toons*

[infinite59]

Use PS_GameData
GO
UPDATE Chars SET Money=0
DELETE FROM CharItems WHERE ItemID=94001
DELETE FROM CharItems WHERE ItemID=94002
DELETE FROM CharItems WHERE ItemID=94003
DELETE FROM CharItems WHERE ItemID=94004
DELETE FROM CharItems WHERE ItemID=94005
DELETE FROM CharItems WHERE ItemID=94006
DELETE FROM UserStoredItems WHERE ItemID=94001
DELETE FROM UserStoredItems WHERE ItemID=94002
DELETE FROM UserStoredItems WHERE ItemID=94003
DELETE FROM UserStoredItems WHERE ItemID=94004
DELETE FROM UserStoredItems WHERE ItemID=94005
DELETE FROM UserStoredItems WHERE ItemID=94006
DELETE FROM GuildStoredItems WHERE ItemID=94001
DELETE FROM GuildStoredItems WHERE ItemID=94002
DELETE FROM GuildStoredItems WHERE ItemID=94003
DELETE FROM GuildStoredItems WHERE ItemID=94004
DELETE FROM GuildStoredItems WHERE ItemID=94005
DELETE FROM GuildStoredItems WHERE ItemID=94006

First line is for remove all gold then delete all the gold bars from inventory, warehouse and GWH.

[nubness]

Originally Posted by infinite59

Use PS_GameData
GO
UPDATE Chars SET Money=0
DELETE FROM CharItems WHERE ItemID=94001
DELETE FROM CharItems WHERE ItemID=94002
DELETE FROM CharItems WHERE ItemID=94003
DELETE FROM CharItems WHERE ItemID=94004
DELETE FROM CharItems WHERE ItemID=94005
DELETE FROM CharItems WHERE ItemID=94006
DELETE FROM UserStoredItems WHERE ItemID=94001
DELETE FROM UserStoredItems WHERE ItemID=94002
DELETE FROM UserStoredItems WHERE ItemID=94003
DELETE FROM UserStoredItems WHERE ItemID=94004
DELETE FROM UserStoredItems WHERE ItemID=94005
DELETE FROM UserStoredItems WHERE ItemID=94006
DELETE FROM GuildStoredItems WHERE ItemID=94001
DELETE FROM GuildStoredItems WHERE ItemID=94002
DELETE FROM GuildStoredItems WHERE ItemID=94003
DELETE FROM GuildStoredItems WHERE ItemID=94004
DELETE FROM GuildStoredItems WHERE ItemID=94005
DELETE FROM GuildStoredItems WHERE ItemID=94006

First line is for remove all gold then delete all the gold bars from inventory, warehouse and GWH.

Just a little piece of advice, so you don't type that much next time. Instead of

DELETE FROM CharItems WHERE ItemID=94001
DELETE FROM CharItems WHERE ItemID=94002
DELETE FROM CharItems WHERE ItemID=94003
DELETE FROM CharItems WHERE ItemID=94004
DELETE FROM CharItems WHERE ItemID=94005
DELETE FROM CharItems WHERE ItemID=94006

you can type

DELETE FROM CharItems WHERE ItemID IN (94001,94002,94003,94004,94005,94006)

[szymo228]

all work, thanks a lot :P