diff options
| -rw-r--r-- | Wintergrasp_temp/Spawns.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/Wintergrasp_temp/Spawns.sql b/Wintergrasp_temp/Spawns.sql index 72ade18933c..7d6308b70b4 100644 --- a/Wintergrasp_temp/Spawns.sql +++ b/Wintergrasp_temp/Spawns.sql @@ -1,3 +1,6 @@ +-- Delete unused creature_data rows +DELETE FROM creature_addon WHERE guid IN (131728,131282,131283,131284,131285,131286,131287,131288,131289,131290,131291,131292,131293,131294,131295,131296,131297,131298,131299,131300,131301,131302,131303,131304,131305,131306,131307,131308,131309,131310,131311,131312,131313,131314,131315,131316,131317,131318,131319,131320,131321,131322,131326,131327,131328,131350,131351,131352,131353,131354,131376,131377,131378,131379,131380,131392,131437,131458,131631,131632,131633,131634,131635,131636,131706,131727,13128,131729,131730,131731); + -- Replace Wintergrasp spawns with properly phased spawns SET @GUID := 290000; DELETE FROM `creature` WHERE `id` IN (31841,31842,30400,30499,30489,30869,31036,31051,31052,31054,31108,31109,31153,39172,30870,31053,31091,31101,31102,31106,31107,31151,32294,39173,32296,30488); |