DB/Creature: Frostworg and Son of Hodir

2 files changed, 35 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_08_06_07_world.sql b/sql/updates/world/3.3.5/2019_08_06_00_world.sql
index 2c2c8dff69c..2c2c8dff69c 100644
--- a/sql/updates/world/3.3.5/2019_08_06_07_world.sql
+++ b/sql/updates/world/3.3.5/2019_08_06_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_06_01_world.sql b/sql/updates/world/3.3.5/2019_08_06_01_world.sql
new file mode 100644
index 00000000000..2f42367fc48
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_08_06_01_world.sql
@@ -0,0 +1,35 @@
+-- 
+DELETE FROM `creature` WHERE `id` IN (30262,30455);
+DELETE FROM `creature` WHERE `guid` IN (116641, 116642, 116643, 116644, 116645, 116646, 116647, 116648, 116649, 116650, 116651, 116652, 116653, 116654, 116655, 116657, 116670, 116671, 116672, 116679, 116680, 116681, 116682, 116683, 116684, 116685, 116686, 116687, 116696, 116697, 116699) AND `id` IN (30262,30455);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(116641, 30262, 571, 0, 0, 1, 4, 0, 0, 7433, -2497.83, 753.685, 1.56884000, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116642, 30262, 571, 0, 0, 1, 4, 0, 0, 7281.06, -2466.81, 756.269, 1.35234, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116643, 30262, 571, 0, 0, 1, 4, 0, 0, 7422.8, -2430.07, 752.256, 3.119790, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116644, 30262, 571, 0, 0, 1, 4, 0, 0, 7325.62, -2406.67, 749.517, 0.53539, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116645, 30262, 571, 0, 0, 1, 4, 0, 0, 7393.38, -2486.52, 749.268, 4.52843, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116646, 30262, 571, 0, 0, 1, 4, 0, 0, 7288.75, -2579.84, 750.516, 1.13446, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116647, 30262, 571, 0, 0, 1, 4, 0, 0, 7236.56, -2881.45, 824.59, 1.588250, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116648, 30262, 571, 0, 0, 1, 4, 0, 0, 7261.38, -2803.25, 777.168, 6.27733, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116649, 30262, 571, 0, 0, 1, 4, 0, 0, 7455.26, -2808.89, 784.35, 1.540530, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116650, 30262, 571, 0, 0, 1, 4, 0, 0, 7347.37, -2903.99, 821.735, 3.17088, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116651, 30262, 571, 0, 0, 1, 4, 0, 0, 7407.6, -2934.94, 847.905, 1.954770, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116652, 30262, 571, 0, 0, 1, 4, 0, 0, 7419.77, -2885.54, 823.037, 1.64061, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116653, 30262, 571, 0, 0, 1, 4, 0, 0, 7126.99, -2749.76, 786.682, 0.26179, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116654, 30262, 571, 0, 0, 1, 4, 0, 0, 7305.37, -2755.09, 775.266, 1.22173, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116655, 30262, 571, 0, 0, 1, 4, 0, 0, 7239.24, -2638.54, 753.62, 5.480330, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116657, 30262, 571, 0, 0, 1, 4, 0, 0, 7206.07, -2828.18, 824.699, 1.46608, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116670, 30262, 571, 0, 0, 1, 4, 0, 0, 7465.24, -2663.38, 808.285, 1.27232, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116671, 30262, 571, 0, 0, 1, 4, 0, 0, 7388.52, -2512.66, 749.585, 4.52843, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116672, 30262, 571, 0, 0, 1, 4, 0, 0, 7322.56, -2524.51, 748.825, 4.41849, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116679, 30262, 571, 0, 0, 1, 4, 0, 0, 7331.37, -2495.4, 749.588, 4.704660, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116680, 30262, 571, 0, 0, 1, 4, 0, 0, 7280.42, -2633.48, 814.933, 3.09183, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116681, 30262, 571, 0, 0, 1, 4, 0, 0, 7345.45, -2762.18, 762.99, 1.490310, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116682, 30262, 571, 0, 0, 1, 4, 0, 0, 7237.31, -2637.68, 814.252, 3.73500, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116683, 30262, 571, 0, 0, 1, 4, 0, 0, 7281.36, -2896.48, 823.797, 6.19235, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116684, 30262, 571, 0, 0, 1, 4, 0, 0, 7125.52, -2690.9, 786.766, 0.244346, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116685, 30262, 571, 0, 0, 1, 4, 0, 0, 7227.84, -2794.43, 777.938, 2.32163, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116686, 30455, 571, 0, 0, 1, 4, 0, 0, 7254.89, -2736.84, 747.566, 3.36217, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116687, 30455, 571, 0, 0, 1, 4, 0, 0, 7228.7, -2672.65, 749.007, 4.793140, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116696, 30455, 571, 0, 0, 1, 4, 0, 0, 7341.4, -2660.14, 747.465, 0.738549, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116697, 30455, 571, 0, 0, 1, 4, 0, 0, 7373.69, -2718.41, 747.09, 1.460420, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0),
+(116699, 30455, 571, 0, 0, 1, 4, 0, 0, 7275.86, -2655.71, 747.09, 2.983970, 480, 5, 0, 0, 0, 1, 0, 0, 0, 0);