Query to reset gold

07/06/2013 12:20 szymo228#1

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

Its very important for me.

*for all toons*

07/06/2013 14:17 infinite59#2

Code:

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.

07/06/2013 14:49 nubness#3

Quote:

Originally Posted by infinite59

Code:

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

Code:

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

Code:

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

07/06/2013 19:10 szymo228#4

all work, thanks a lot :P