DB/Quest: Polishing the Helm

(cherry picked from commit b2554c0944ec84b0a4da511b8826510c33ed0f2d)

1 files changed, 49 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_12_18_17_world_2019_08_06_00_world.sql b/sql/updates/world/master/2021_12_18_17_world_2019_08_06_00_world.sql
new file mode 100644
index 00000000000..87d65ea0666
--- /dev/null
+++ b/sql/updates/world/master/2021_12_18_17_world_2019_08_06_00_world.sql
@@ -0,0 +1,49 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (116202, 116203, 116204, 116205, 116206, 116207, 116208, 116209, 116210, 116211, 116212, 116218, 116227, 116235, 116237, 116244, 116392, 116394, 116443, 116561, 116571, 116572, 116573, 116576, 116577, 116578, 116596, 116600, 116601, 116604, 116640) AND `id` IN (30302);
+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
+(116202, 30302, 571, 0, 0, '0', 171, 0, 0, 7082.54, -2100.78, 804.909, 3.7350, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116203, 30302, 571, 0, 0, '0', 171, 0, 0, 7082.82, -2161.2, 803.592, 4.99164, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116204, 30302, 571, 0, 0, '0', 171, 0, 0, 7117.25, -2149.36, 828.855, 1.1519, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116205, 30302, 571, 0, 0, '0', 171, 0, 0, 7122.11, -2206.1, 803.657, 2.54818, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116206, 30302, 571, 0, 0, '0', 171, 0, 0, 7123.21, -2075.44, 811.86, 5.74213, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116207, 30302, 571, 0, 0, '0', 171, 0, 0, 7155.47, -2195.56, 829.488, 2.0245, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116208, 30302, 571, 0, 0, '0', 171, 0, 0, 7156.14, -2172.65, 805.483, 4.3458, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116209, 30302, 571, 0, 0, '0', 171, 0, 0, 7158.29, -2196.43, 845.092, 1.5184, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116210, 30302, 571, 0, 0, '0', 171, 0, 0, 7171.04, -2254.51, 804.536, 2.5830, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116211, 30302, 571, 0, 0, '0', 171, 0, 0, 7206.62, -2246.4, 826.224, 6.09120, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116212, 30302, 571, 0, 0, '0', 171, 0, 0, 7217.31, -2216.68, 804.466, 5.6374, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116218, 30302, 571, 0, 0, '0', 171, 0, 0, 7224.47, -2306.54, 797.298, 0.7679, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116227, 30302, 571, 0, 0, '0', 171, 0, 0, 7241.52, -2273.98, 840.661, 3.1765, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116235, 30302, 571, 0, 0, '0', 171, 0, 0, 7266.55, -2253.47, 801.22, 0.80285, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116237, 30302, 571, 0, 0, '0', 171, 0, 0, 7283.03, -2308.79, 820.664, 2.3387, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116244, 30302, 571, 0, 0, '0', 171, 0, 0, 7295.55, -2363.3, 796.967, 3.33358, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116392, 30302, 571, 0, 0, '0', 171, 0, 0, 7316.59, -2426.5, 795.789, 3.33358, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116394, 30302, 571, 0, 0, '0', 171, 0, 0, 7318.72, -2349.06, 833.57, 1.65806, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116443, 30302, 571, 0, 0, '0', 171, 0, 0, 7338.45, -2363.68, 818.77, 0.26179, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116561, 30302, 571, 0, 0, '0', 171, 0, 0, 7359.32, -2321.25, 797.658, 4.3284, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116571, 30302, 571, 0, 0, '0', 171, 0, 0, 7360.49, -2741.37, 854.655, 4.4156, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116572, 30302, 571, 0, 0, '0', 171, 0, 0, 7371.05, -2709.3, 851.329, 1.97222, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116573, 30302, 571, 0, 0, '0', 171, 0, 0, 7372.72, -2726.62, 855.929, 4.6600, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116576, 30302, 571, 0, 0, '0', 171, 0, 0, 7374.73, -2725.97, 867.125, 0.9948, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116577, 30302, 571, 0, 0, '0', 171, 0, 0, 7378.38, -2713.14, 853.977, 3.1765, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116578, 30302, 571, 0, 0, '0', 171, 0, 0, 7383.9, -2733.53, 865.533, 4.46804, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116596, 30302, 571, 0, 0, '0', 171, 0, 0, 7385.21, -2722.85, 871.328, 2.7227, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116600, 30302, 571, 0, 0, '0', 171, 0, 0, 7387.69, -2415.56, 794.019, 2.3561, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116601, 30302, 571, 0, 0, '0', 171, 0, 0, 7389.77, -2729.4, 873.385, 5.35816, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116604, 30302, 571, 0, 0, '0', 171, 0, 0, 7390.7, -2716.59, 868.861, 4.43314, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116640, 30302, 571, 0, 0, '0', 171, 0, 0, 7393.31, -2734.24, 869.933, 4.3633, 180, 0, 0, 0, 0, 0, 0, 0, 0, 0);
+
+DELETE FROM `creature_template_movement` WHERE `CreatureId`= 30302;
+INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`) VALUES
+(30302, 0, 0, 1, 0);
+
+UPDATE `gameobject_template` SET `AIName` = 'SmartGameObjectAI' WHERE `entry` IN (192080);
+UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (30302);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (192080) AND `source_type` = 1;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30302) AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3030200,3030201) AND `source_type` = 9;
+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
+(192080, 1, 0, 0, 20, 0, 100, 0, 13006, 5000, 5000, 0, 45, 1, 1, 0, 0, 0, 0, 11, 30302, 40, 0, 0, 0, 0, 0, 'Hodirs Helm - On quest Rewarded - Set Data'),
+(30302, 0, 0, 0, 38, 0, 100, 0, 1, 1, 5000, 5000, 87, 3030200, 3030201, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Helm Sparkle Bunny - On data set - Random action list'),
+(3030200, 9, 0, 0, 0, 0, 100, 0, 1000, 5000, 0, 0, 11, 56507, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Helm Sparkle Bunny - Action list - Cast spell'),
+(3030201, 9, 0, 0, 0, 0, 100, 0, 1000, 5000, 0, 0, 11, 56494, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Helm Sparkle Bunny - Action list - Cast spell');