DB/Creature: Remove wrong spawns for Commoners and link some other to Winter Veil

Closes #16068

1 files changed, 49 insertions, 0 deletions

diff --git a/sql/updates/world/2015_12_29_09_world.sql b/sql/updates/world/2015_12_29_09_world.sql
new file mode 100644
index 00000000000..d57785e8d88
--- /dev/null
+++ b/sql/updates/world/2015_12_29_09_world.sql
@@ -0,0 +1,49 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (134960, 134962, 134968, 134969, 84418, 84423, 84402, 134976, 134977);
+DELETE FROM `game_event_creature` WHERE `guid` IN (134961, 134963, 84419,  84424,  134964, 134965, 134966, 134967, 84400,  84409,  84410,  84430,  84435,  84440,  84441,  134970, 134971, 134972, 134973, 134974, 134975, 134982, 134983, 86732,  86733,  134980, 134981, 134978, 134979, 727, 726, 725, 724, 134848, 134984, 134985, 134986, 134987, 134988, 134989, 134990, 134991, 134992, 134993, 134994);
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES 
+(2, 134961),
+(2, 134963),
+(2, 84419), 
+(2, 84424), 
+(2, 134964),
+(2, 134965),
+(2, 134966),
+(2, 134967),
+(2, 84400), 
+(2, 84409), 
+(2, 84410), 
+(2, 84430), 
+(2, 84435), 
+(2, 84440), 
+(2, 84441), 
+(2, 134970),
+(2, 134971),
+(2, 134972),
+(2, 134973),
+(2, 134974),
+(2, 134975),
+(2, 134982),
+(2, 134983),
+(2, 86732), 
+(2, 86733), 
+(2, 134980),
+(2, 134981),
+(2, 134978),
+(2, 134979),
+(2, 727),
+(2, 726),
+(2, 725),
+(2, 724),
+(2, 134848),
+(2, 134984),
+(2, 134985),
+(2, 134986),
+(2, 134987),
+(2, 134988),
+(2, 134989),
+(2, 134990),
+(2, 134991),
+(2, 134992),
+(2, 134993),
+(2, 134994);