-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSQLDelete.sql
More file actions
4 lines (4 loc) · 750 Bytes
/
SQLDelete.sql
File metadata and controls
4 lines (4 loc) · 750 Bytes
1
2
3
4
-- Legendary Items --
DELETE FROM character_inventory WHERE item_template IN (22589,19018,22737,17142,22736,17182,17782,19019,19016,21176,18563,18564,17771,17204,13262,22726,22630,22631,22632);
-- Tier 3 --
DELETE FROM character_inventory WHERE item_template IN (22483,22476,22481,22478,22477,22479,22480,22482,23060,22440,22442,22441,22438,22437,22439,22436,22443,23067,22423,22416,22421,22422,22418,22417,22419,22420,23059,22492,22494,22493,22490,22489,22491,22488,22495,23064,22502,22503,22498,22501,22497,22496,22500,22499,23062,22510,22511,22506,22509,22505,22504,22508,22507,23063,22430,22431,22426,22428,22427,22429,22425,22424,23066,22468,22470,22469,22466,22465,22467,22464,22471,23065,22518,22519,22514,22517,22513,22512,22516,22515,23061);