DB/Creature: Blackwing Spell Marker

1 files changed, 15 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_04_14_03_world.sql b/sql/updates/world/3.3.5/2019_04_14_03_world.sql
new file mode 100644
index 00000000000..cbfba7b1c2b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_04_14_03_world.sql
@@ -0,0 +1,15 @@
+-- 
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry` IN (16604);
+DELETE FROM `creature` WHERE `guid` IN (62788, 62789, 62790, 62791, 62792, 62793, 62794, 62795, 62796, 62797, 62798);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`,`spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
+(62788, 16604, 469, 1, 1, 0, 0, -7659.47, -1043.87, 407.282, 1.65806, 300, 0, 0, 42, 0, 0),
+(62789, 16604, 469, 1, 1, 0, 0, -7626.67, -1009.63, 413.465, 3.19395, 300, 0, 0, 42, 0, 0),
+(62790, 16604, 469, 1, 1, 0, 0, -7619.05, -1048.82, 408.24, 0.680678, 300, 0, 0, 42, 0, 0),
+(62791, 16604, 469, 1, 1, 0, 0, -7607.38, -1115.99, 407.282, 4.92183, 300, 0, 0, 42, 0, 0),
+(62792, 16604, 469, 1, 1, 0, 0, -7599.65, -1077.8, 408.24, 3.54302, 300, 0, 0, 42, 0, 0),
+(62793, 16604, 469, 1, 1, 0, 0, -7595.42, -1053.45, 408.24, 3.89208, 300, 0, 0, 42, 0, 0),
+(62794, 16604, 469, 1, 1, 0, 0, -7592.7, -1029.95, 408.24, 5.32325, 300, 0, 0, 42, 0, 0),
+(62795, 16604, 469, 1, 1, 0, 0, -7583.24, -990.03, 407.282, 2.89725, 300, 0, 0, 42, 0, 0),
+(62796, 16604, 469, 1, 1, 0, 0, -7571.81, -1058.2, 408.24, 5.74213, 300, 0, 0, 42, 0, 0),
+(62797, 16604, 469, 1, 1, 0, 0, -7566.78, -1095.09, 413.465, 4.71239, 300, 0, 0, 42, 0, 0),
+(62798, 16604, 469, 1, 1, 0, 0, -7532.15, -1062.56, 407.282, 4.72984, 300, 0, 0, 42, 0, 0);