diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_14_03_world.sql | 15 |
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); |