DB/Creature: Phase Wyrm

(cherry picked from commit c1269e79d2b5c638fc1cbfee75b6d23fdbbc0aef)

1 files changed, 65 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_12_17_04_world_2019_07_23_03_world.sql b/sql/updates/world/master/2021_12_17_04_world_2019_07_23_03_world.sql
new file mode 100644
index 00000000000..12866655f1a
--- /dev/null
+++ b/sql/updates/world/master/2021_12_17_04_world_2019_07_23_03_world.sql
@@ -0,0 +1,65 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (112023, 112025, 112030, 112032, 112035, 112038, 112042, 112234, 112235, 112240, 112250, 112295, 112297, 112299, 112303, 112304, 112374, 112397, 112419, 112430, 112464, 112481, 112617, 112719, 112720, 112723, 112724, 112725, 112727, 112728, 112732, 112735, 112737, 112743, 112744, 112747, 112748, 112795, 112818, 112820, 112825, 112839, 112849, 112877, 112902, 112904, 112918, 112996);
+DELETE FROM `creature` WHERE `id`=22244 AND `guid` IN (113004, 113075, 113110, 113142);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(112023, 24917, 530, 0, 0, '0', 170, 0, 0, 4016.76, 5829.19, 267.382, 3.40863, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112025, 24917, 530, 0, 0, '0', 170, 0, 0, 3985.31, 5826.51, 266.025, 1.05086, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112030, 24917, 530, 0, 0, '0', 170, 0, 0, 3966.79, 5957.74, 273.080, 2.88869, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112032, 24917, 530, 0, 0, '0', 170, 0, 0, 3944.08, 5943.11, 266.682, 3.36779, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112035, 24917, 530, 0, 0, '0', 170, 0, 0, 3947.04, 6000.65, 266.063, 5.77503, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112038, 24917, 530, 0, 0, '0', 170, 0, 0, 3983.83, 5988.99, 273.401, 1.76557, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112042, 24917, 530, 0, 0, '0', 170, 0, 0, 3777.96, 6159.33, 265.721, 0.13194, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112234, 24917, 530, 0, 0, '0', 170, 0, 0, 3782.32, 6180.99, 266.126, 1.76557, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112235, 24917, 530, 0, 0, '0', 170, 0, 0, 3778.14, 6107.49, 266.290, 0.17120, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112240, 24917, 530, 0, 0, '0', 170, 0, 0, 3855.15, 6109.11, 267.109, 3.70158, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112250, 24917, 530, 0, 0, '0', 170, 0, 0, 3712.09, 6058.85, 265.832, 5.81037, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112295, 24917, 530, 0, 0, '0', 170, 0, 0, 3795.77, 5995.85, 265.060, 4.51840, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112297, 24917, 530, 0, 0, '0', 170, 0, 0, 3787.39, 5965.92, 266.111, 5.01320, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112299, 24917, 530, 0, 0, '0', 170, 0, 0, 3936.976, 5978.676, 266.500, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112303, 24917, 530, 0, 0, '0', 170, 0, 0, 3923.171, 6046.599, 266.828, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112304, 24917, 530, 0, 0, '0', 170, 0, 0, 3986.741, 6046.500, 266.238, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112374, 24917, 530, 0, 0, '0', 170, 0, 0, 3959.321, 6051.131, 266.539, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112397, 24917, 530, 0, 0, '0', 170, 0, 0, 3966.047, 6081.679, 269.708, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112419, 24917, 530, 0, 0, '0', 170, 0, 0, 3927.097, 6019.004, 269.648, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112430, 24917, 530, 0, 0, '0', 170, 0, 0, 3916.038, 6094.708, 270.932, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112464, 24917, 530, 0, 0, '0', 170, 0, 0, 3976.842, 6012.200, 268.413, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112481, 24917, 530, 0, 0, '0', 170, 0, 0, 4008.262, 6018.897, 267.563, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112617, 24917, 530, 0, 0, '0', 170, 0, 0, 3857.819, 6057.005, 265.646, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112719, 24917, 530, 0, 0, '0', 170, 0, 0, 3816.233, 5966.625, 266.560, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112720, 24917, 530, 0, 0, '0', 170, 0, 0, 3974.260, 5926.065, 267.653, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112723, 24917, 530, 0, 0, '0', 170, 0, 0, 3921.568, 5936.235, 266.911, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112724, 24917, 530, 0, 0, '0', 170, 0, 0, 3729.556, 5921.477, 266.505, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112725, 24917, 530, 0, 0, '0', 170, 0, 0, 3728.004, 5974.951, 267.982, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112727, 24917, 530, 0, 0, '0', 170, 0, 0, 3755.249, 5899.458, 265.151, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112728, 24917, 530, 0, 0, '0', 170, 0, 0, 3803.827, 5933.419, 265.977, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112732, 24917, 530, 0, 0, '0', 170, 0, 0, 3763.992, 5930.677, 265.525, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112735, 24917, 530, 0, 0, '0', 170, 0, 0, 3831.801, 6032.336, 266.697, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112737, 24917, 530, 0, 0, '0', 170, 0, 0, 3779.406, 6030.569, 265.532, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112743, 24917, 530, 0, 0, '0', 170, 0, 0, 3775.539, 6000.383, 267.275, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112744, 24917, 530, 0, 0, '0', 170, 0, 0, 3701.691, 5992.166, 265.340, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112747, 24917, 530, 0, 0, '0', 170, 0, 0, 3800.953, 6057.917, 267.066, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112748, 24917, 530, 0, 0, '0', 170, 0, 0, 3733.605, 6026.433, 266.745, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112795, 24917, 530, 0, 0, '0', 170, 0, 0, 3680.470, 6070.118, 267.130, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112818, 24917, 530, 0, 0, '0', 170, 0, 0, 3717.450, 6113.807, 266.641, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112820, 24917, 530, 0, 0, '0', 170, 0, 0, 3714.303, 6079.629, 267.547, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112825, 24917, 530, 0, 0, '0', 170, 0, 0, 3785.864, 6085.778, 266.230, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112839, 24917, 530, 0, 0, '0', 170, 0, 0, 3755.868, 6105.103, 268.484, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112849, 24917, 530, 0, 0, '0', 170, 0, 0, 3670.174, 6144.466, 266.763, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112877, 24917, 530, 0, 0, '0', 170, 0, 0, 3700.149, 6148.887, 266.705, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112902, 24917, 530, 0, 0, '0', 170, 0, 0, 3812.946, 6109.024, 265.974, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112904, 24917, 530, 0, 0, '0', 170, 0, 0, 3685.623, 6181.240, 266.067, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112918, 24917, 530, 0, 0, '0', 170, 0, 0, 3730.544, 6179.441, 266.784, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(112996, 24917, 530, 0, 0, '0', 170, 0, 0, 3831.597, 6136.519, 266.026, 1.32968, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(113004, 22244, 530, 0, 0, '0', 0, 0, 0, 4024.21, 5916.89, 267.871, 3.39678, 300, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(113075, 22244, 530, 0, 0, '0', 0, 0, 0, 3982.43, 6003.25, 267.936, 2.13622, 300, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(113110, 22244, 530, 0, 0, '0', 0, 0, 0, 3966.62, 6084.14, 269.127, 4.61415, 300, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(113142, 22244, 530, 0, 0, '0', 0, 0, 0, 3826.34, 6061.31, 264.852, 4.42487, 300, 7, 0, 0, 0, 1, 0, 0, 0, 0);
+
+DELETE FROM `creature_template_addon` WHERE `entry`=24917;
+INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
+(24917,0,0,1,0, "44855");
+
+UPDATE `creature_template` SET `AIName`='SmartAI'  WHERE `entry`=24917;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24917) AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(24917,0,0,0,23,0,100,0,35319,0,5000,5000,11,35319,0,0,0,0,0,1,0,0,0,0,0,0,0,"Phase Wyrm - On missing aura - cast spell 35319");