From f9db6cfe01f8f610186d241930f3318565adb1e7 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Tue, 6 Aug 2019 19:18:26 +0200
Subject: DB/Creature: Frostworg and Son of Hodir

---
 sql/updates/world/3.3.5/2019_08_06_00_world.sql | 49 +++++++++++++++++++++++++
 sql/updates/world/3.3.5/2019_08_06_01_world.sql | 35 ++++++++++++++++++
 sql/updates/world/3.3.5/2019_08_06_07_world.sql | 49 -------------------------
 3 files changed, 84 insertions(+), 49 deletions(-)
 create mode 100644 sql/updates/world/3.3.5/2019_08_06_00_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_08_06_01_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2019_08_06_07_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2019_08_06_00_world.sql b/sql/updates/world/3.3.5/2019_08_06_00_world.sql
new file mode 100644
index 00000000000..2c2c8dff69c
--- /dev/null
+++ b/sql/updates/world/3.3.5/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`, `spawnMask`, `phaseMask`, `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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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');
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);
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_07_world.sql
deleted file mode 100644
index 2c2c8dff69c..00000000000
--- a/sql/updates/world/3.3.5/2019_08_06_07_world.sql
+++ /dev/null
@@ -1,49 +0,0 @@
--- 
-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`, `spawnMask`, `phaseMask`, `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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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, 1, 4, 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');
-- 
cgit v1.2.3