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)