From 62a0057f258696abb44d75699a3d8eefa6a14b35 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Sun, 23 Jun 2019 22:02:13 +0200
Subject: Rename files

---
 sql/updates/world/3.3.5/2019_06_23_010_world.sql |  2 --
 sql/updates/world/3.3.5/2019_06_23_011_world.sql |  2 --
 sql/updates/world/3.3.5/2019_06_23_012_world.sql | 10 -------
 sql/updates/world/3.3.5/2019_06_23_013_world.sql | 38 ------------------------
 sql/updates/world/3.3.5/2019_06_23_014_world.sql | 10 -------
 sql/updates/world/3.3.5/2019_06_23_015_world.sql | 23 --------------
 sql/updates/world/3.3.5/2019_06_23_016_world.sql | 31 -------------------
 sql/updates/world/3.3.5/2019_06_23_017_world.sql | 10 -------
 sql/updates/world/3.3.5/2019_06_23_018_world.sql |  2 --
 sql/updates/world/3.3.5/2019_06_23_10_world.sql  |  2 ++
 sql/updates/world/3.3.5/2019_06_23_11_world.sql  |  2 ++
 sql/updates/world/3.3.5/2019_06_23_12_world.sql  | 10 +++++++
 sql/updates/world/3.3.5/2019_06_23_13_world.sql  | 38 ++++++++++++++++++++++++
 sql/updates/world/3.3.5/2019_06_23_14_world.sql  | 10 +++++++
 sql/updates/world/3.3.5/2019_06_23_15_world.sql  | 23 ++++++++++++++
 sql/updates/world/3.3.5/2019_06_23_16_world.sql  | 31 +++++++++++++++++++
 sql/updates/world/3.3.5/2019_06_23_17_world.sql  | 10 +++++++
 sql/updates/world/3.3.5/2019_06_23_18_world.sql  |  2 ++
 18 files changed, 128 insertions(+), 128 deletions(-)
 delete mode 100644 sql/updates/world/3.3.5/2019_06_23_010_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2019_06_23_011_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2019_06_23_012_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2019_06_23_013_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2019_06_23_014_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2019_06_23_015_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2019_06_23_016_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2019_06_23_017_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2019_06_23_018_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_06_23_10_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_06_23_11_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_06_23_12_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_06_23_13_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_06_23_14_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_06_23_15_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_06_23_16_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_06_23_17_world.sql
 create mode 100644 sql/updates/world/3.3.5/2019_06_23_18_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2019_06_23_010_world.sql b/sql/updates/world/3.3.5/2019_06_23_010_world.sql
deleted file mode 100644
index df3cd7828ad..00000000000
--- a/sql/updates/world/3.3.5/2019_06_23_010_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-DELETE FROM `creature_loot_template` WHERE `Entry`=2031 AND `Reference`=44007;
diff --git a/sql/updates/world/3.3.5/2019_06_23_011_world.sql b/sql/updates/world/3.3.5/2019_06_23_011_world.sql
deleted file mode 100644
index c13f9fcd724..00000000000
--- a/sql/updates/world/3.3.5/2019_06_23_011_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `creature_loot_template` SET `Chance`=0, `GroupId`=2 WHERE `Entry`=18693 AND `Item` IN (31163, 31164, 31165, 31166);
diff --git a/sql/updates/world/3.3.5/2019_06_23_012_world.sql b/sql/updates/world/3.3.5/2019_06_23_012_world.sql
deleted file mode 100644
index ff1ce658779..00000000000
--- a/sql/updates/world/3.3.5/2019_06_23_012_world.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- 
-DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (10214, 10255);
-INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
-(10214, 0, 1, "I want to browse your goods", 3370, 3, 128, 0, 0, 0, 0, "", 0, 0),
-(10255, 0, 1, "I want to browse your goods", 3370, 3, 128, 0, 0, 0, 0, "", 0, 0);
-
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (10214, 10255);
-INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
-(15, 10214, 0, 0, 0, 8, 0, 12870, 0, 0, 0, 0, 0, "", "NPC Rork Sharpchin can sell items only if quest 'Ancient Relics' is rewarded"),
-(15, 10255, 0, 0, 0, 8, 0, 12882, 0, 0, 0, 0, 0, "", "NPC Olut Alegut can sell items only if quest 'Ancient Relics' is rewarded");
diff --git a/sql/updates/world/3.3.5/2019_06_23_013_world.sql b/sql/updates/world/3.3.5/2019_06_23_013_world.sql
deleted file mode 100644
index c670691a9e1..00000000000
--- a/sql/updates/world/3.3.5/2019_06_23_013_world.sql
+++ /dev/null
@@ -1,38 +0,0 @@
--- 
-UPDATE `creature` SET `spawndist`=2 WHERE `guid` IN (108910, 108911, 108912, 108913);
-
-UPDATE `creature_template` SET `AIName`="SmartAI", `unit_flags`=`unit_flags`|256 WHERE `entry`=24547;
-UPDATE `creature` SET `position_x`=-49.74284, `position_y`=-3393.537, `position_z`=-8.100207, `orientation`=3.70 WHERE `guid`=117725;
-DELETE FROM `creature_template_addon` WHERE `entry`=24547;
-INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
-(24547, 0, 0, 3, 0, 0, "");
-
-DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24742, 24547, 2454700, 2474200) AND `source_type` IN (0, 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`, `event_param5`, `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
-(24742, 0, 0, 0, 0, 0, 100, 0, 0, 15000, 15000, 30000, 0, 11, 50188, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - IC - Cast Wildly Flailing"),
-(24742, 0, 1, 2, 34, 0, 100, 0, 8, 1, 0, 0, 0, 97, 20, 20, 0, 0, 0, 0, 1, 0, 0, 0, -37.5049, -3421.69, -14.2464, 0, "\"Mad\" Jonah Sterling - On MovementInform PointID 1 - Jump to Hozzer"),
-(24742, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 24547, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On WP 1 Reached - Set Data 1 1 Hozzer"),
-(24742, 0, 3, 0, 2, 0, 100, 513, 0, 25, 0, 0, 0, 80, 2474200, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On 25% Hp - Run Script"),
-(24547, 0, 0, 0, 0, 0, 100, 0, 5000, 10000, 15000, 20000, 0, 11, 34298, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Hozzer - In Combat - Cast Maul"),
-(24547, 0, 1, 2, 38, 0, 100, 0, 1, 1, 0, 0, 0, 53, 1, 24547, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Data 1 1 Set - Start Waypoint"),
-(24547, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 91, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Data 1 1 Set - Remove Standstate Sleep"),
-(24547, 0, 3, 0, 40, 0, 100, 0, 3, 24547, 0, 0, 0, 80, 2454700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Waypoint 3 Reached - Run Script"),
-(2454700, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Talk 0"),
-(2454700, 9, 1, 0, 0, 0, 100, 0, 200, 200, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 24742, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Talk 1 (\"Mad\" Jonah Sterling)"),
-(2454700, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 44458, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Cast Hozzer Feeds"),
-(2454700, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 24742, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Despawn \"Mad\" Jonah Sterling"),
-(2454700, 9, 4, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 19, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Remove Flag IMMUNE_TO_PC"),
-(2454700, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Set ReactState Aggressive"),
-(2474200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 117, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Disable Evade"),
-(2474200, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Set HP Regen Off"),
-(2474200, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 27, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Stop Combat"),
-(2474200, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 89, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Disable Random Move"),
-(2474200, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, -36.1289, -3425.64, 4.99862, 0, "\"Mad\" Jonah Sterling - On Script - Move To Pos"),
-(2474200, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 18, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Set Unit Flag IMMUNE_TO_PC"),
-(2474200, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Say Line 1");
-
-DELETE FROM `waypoints` WHERE `entry` IN (24547, 24742);
-INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
-(24547, 1, -31.82427, -3401.094, -14.61846, "Hozzer"),
-(24547, 2, -30.87391, -3411.618, -15.25708, "Hozzer"),
-(24547, 3, -35.8712, -3419.122, -14.47846, "Hozzer");
diff --git a/sql/updates/world/3.3.5/2019_06_23_014_world.sql b/sql/updates/world/3.3.5/2019_06_23_014_world.sql
deleted file mode 100644
index 409df2d5c12..00000000000
--- a/sql/updates/world/3.3.5/2019_06_23_014_world.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- 
-UPDATE `creature_template_addon` SET `auras`="45842" WHERE `entry`=25478;
-DELETE FROM `creature_addon` WHERE `guid`=113408;
-INSERT INTO `creature_addon` (`guid`, `auras`) VALUES
-(113408, "46076");
-
-DELETE FROM `spell_area` WHERE `spell` IN (45844, 46079);
-INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
-(45844, 4023, 11590, 0, 0, 0, 2, 1, 64, 11),
-(46079, 4023, 11681, 0, 0, 0, 2, 1, 66, 11);
diff --git a/sql/updates/world/3.3.5/2019_06_23_015_world.sql b/sql/updates/world/3.3.5/2019_06_23_015_world.sql
deleted file mode 100644
index d85e6c61667..00000000000
--- a/sql/updates/world/3.3.5/2019_06_23_015_world.sql
+++ /dev/null
@@ -1,23 +0,0 @@
--- 
-DELETE FROM `creature_text` WHERE `CreatureID` IN (31261, 31259);
-INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
-(31261, 0, 0, "This is madness! Cease this foolish battle!", 12, 1, 100, 0, 0, 0, 31915, 0, "Brother Keltan"),
-(31261, 0, 1, "Brothers and sisters, we must remain united! The Lich King will never fall to a world divided!", 12, 1, 100, 0, 0, 0, 31916, 0, "Brother Keltan"),
-(31261, 0, 2, "Can you not see that you play right into the Lich King's hands? He wants you to kill each other!", 12, 1, 100, 0, 0, 0, 31917, 0, "Brother Keltan"),
-(31261, 0, 3, "Join the Argent Crusade! United, we shall destroy the Lich King!", 12, 1, 100, 0, 0, 0, 31918, 0, "Brother Keltan"),
-(31261, 0, 4, "Judgment day comes, brothers and sisters! Will you be prepared?", 12, 1, 100, 0, 0, 0, 31919, 0, "Brother Keltan"),
-(31261, 0, 5, "How much of our efforts are being wasted by attacking the Alliance?", 12, 1, 100, 0, 0, 0, 31920, 0, "Brother Keltan"),
-(31261, 0, 6, "We must unite and focus our attention upon the true threat: THE LICH KING!", 12, 1, 100, 0, 0, 0, 31922, 0, "Brother Keltan"),
-(31259, 0, 0, "This is madness! Cease this foolish battle!", 12, 7, 100, 0, 0, 0, 31923, 0, "Absalan the Pious"),
-(31259, 0, 1, "Brothers and sisters, we must remain united! The Lich King will never fall to a world divided!", 12, 7, 100, 0, 0, 0, 31924, 0, "Absalan the Pious"),
-(31259, 0, 2, "Can you not see that you play right into the Lich King's hands? He wants you to kill each other!", 12, 7, 100, 0, 0, 0, 31925, 0, "Absalan the Pious"),
-(31259, 0, 3, "Join the Argent Crusade! United, we shall destroy the Lich King!", 12, 7, 100, 0, 0, 0, 31926, 0, "Absalan the Pious"),
-(31259, 0, 4, "Judgment day comes, brothers and sisters! Will you be prepared?", 12, 7, 100, 0, 0, 0, 31927, 0, "Absalan the Pious"),
-(31259, 0, 5, "How much of our efforts are being wasted by attacking the Horde?", 12, 7, 100, 0, 0, 0, 31928, 0, "Absalan the Pious"),
-(31259, 0, 6, "We must unite and focus our attention upon the true threat: THE LICH KING!", 12, 7, 100, 0, 0, 0, 31929, 0, "Absalan the Pious");
-
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (31261, 31259);
-DELETE FROM `smart_scripts` WHERE `entryorguid` IN (31261, 31259) 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`, `event_param5`, `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
-(31261, 0, 0, 0, 1, 0, 100, 0, 15000, 30000, 100000, 140000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Brother Keltan - Out Of Combat - Say Line 0"),
-(31259, 0, 0, 0, 1, 0, 100, 0, 15000, 30000, 100000, 140000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Absalan the Pious - Out Of Combat - Say Line 0");
diff --git a/sql/updates/world/3.3.5/2019_06_23_016_world.sql b/sql/updates/world/3.3.5/2019_06_23_016_world.sql
deleted file mode 100644
index 2b50e617dd2..00000000000
--- a/sql/updates/world/3.3.5/2019_06_23_016_world.sql
+++ /dev/null
@@ -1,31 +0,0 @@
--- 
-UPDATE `creature_addon` SET `auras`="55474" WHERE `guid` IN (125388, 125390, 125385);
-DELETE FROM `creature` WHERE `guid`=125391;
-DELETE FROM `creature_addon` WHERE `guid`=125391;
-
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=27432;
-DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-125386, 2743200) AND `source_type` IN (0, 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`, `event_param5`, `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
-(-125386, 0, 0, 0, 1, 0, 100, 0, 5000, 20000, 150000, 210000, 0, 80, 2743200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Warsong Peon - Out Of Combat - Run Script"),
-(2743200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 10, 125389, 27432, 0, 0, 0, 0, 0, "Warsong Peon - On Script - Say Line 0 (Warsong Peon)"),
-(2743200, 9, 1, 0, 0, 0, 50, 0, 60000, 120000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Warsong Peon - On Script - Say Line 1"),
-(2743200, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 5, 36, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Warsong Peon - On Script - Play Emote 'Attack 1H'"),
-(2743200, 9, 3, 0, 0, 0, 50, 0, 1000, 1000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 10, 125387, 27432, 0, 0, 0, 0, 0, "Warsong Peon - On Script - Say Line 2 (Warsong Peon)");
-
-DELETE FROM `creature_text` WHERE `CreatureID`=27432;
-INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
-(27432, 0, 0, "Me hungry.", 12, 1, 100, 1, 0, 0, 26572, 0, "Warsong Peon"),
-(27432, 0, 1, "Me sleepy.", 12, 1, 100, 1, 0, 0, 26573, 0, "Warsong Peon"),
-(27432, 0, 2, "Me cold.", 12, 1, 100, 1, 0, 0, 26574, 0, "Warsong Peon"),
-(27432, 0, 3, "Me scared of bug things.", 12, 1, 100, 1, 0, 0, 26575, 0, "Warsong Peon"),
-(27432, 0, 4, "Me got stuck in sticky bug rope.", 12, 1, 100, 1, 0, 0, 26576, 0, "Warsong Peon"),
-(27432, 0, 5, "Me no like rock place full of bugs.", 12, 1, 100, 1, 0, 0, 26577, 0, "Warsong Peon"),
-(27432, 0, 6, "Me no like new cold place.", 12, 1, 100, 1, 0, 0, 26578, 0, "Warsong Peon"),
-(27432, 0, 7, "It time for work! Zug zug!", 12, 1, 100, 1, 0, 0, 26589, 0, "Warsong Peon"),
-(27432, 1, 0, "Ha ha.", 12, 1, 100, 1, 0, 0, 26582, 0, "Warsong Peon"),
-(27432, 1, 1, "That funny.", 12, 1, 100, 1, 0, 0, 26583, 0, "Warsong Peon"),
-(27432, 1, 2, "Your head like rock.", 12, 1, 100, 1, 0, 0, 26588, 0, "Warsong Peon"),
-(27432, 2, 0, "Ow.", 12, 1, 100, 1, 0, 0, 26584, 0, "Warsong Peon"),
-(27432, 2, 1, "Stop it!", 12, 1, 100, 1, 0, 0, 26585, 0, "Warsong Peon"),
-(27432, 2, 2, "That hurt.", 12, 1, 100, 1, 0, 0, 26586, 0, "Warsong Peon"),
-(27432, 2, 3, "What that sound?", 12, 1, 100, 1, 0, 0, 26587, 0, "Warsong Peon");
diff --git a/sql/updates/world/3.3.5/2019_06_23_017_world.sql b/sql/updates/world/3.3.5/2019_06_23_017_world.sql
deleted file mode 100644
index 9c1f8aa866a..00000000000
--- a/sql/updates/world/3.3.5/2019_06_23_017_world.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- 
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=25294;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=25294 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`, `event_param5`, `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
-(25294, 0, 0, 1, 0, 0, 100, 0, 3000, 10000, 30000, 40000, 0, 11, 50284, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Nerub'ar Web Lord - In Combat - Cast 'Blinding Swarm'"),
-(25294, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Nerub'ar Web Lord - In Combat - Say Line 0");
-
-DELETE FROM `creature_text` WHERE `CreatureID`=25294;
-INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
-(25294, 0, 0, "The %s directs the blinding swarm directly in front of it.", 16, 0, 100, 0, 0, 0, 27381, 0, "Nerub'ar Web Lord");
diff --git a/sql/updates/world/3.3.5/2019_06_23_018_world.sql b/sql/updates/world/3.3.5/2019_06_23_018_world.sql
deleted file mode 100644
index a8889112f4f..00000000000
--- a/sql/updates/world/3.3.5/2019_06_23_018_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|1 WHERE `entry`=23090;
diff --git a/sql/updates/world/3.3.5/2019_06_23_10_world.sql b/sql/updates/world/3.3.5/2019_06_23_10_world.sql
new file mode 100644
index 00000000000..df3cd7828ad
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_23_10_world.sql
@@ -0,0 +1,2 @@
+-- 
+DELETE FROM `creature_loot_template` WHERE `Entry`=2031 AND `Reference`=44007;
diff --git a/sql/updates/world/3.3.5/2019_06_23_11_world.sql b/sql/updates/world/3.3.5/2019_06_23_11_world.sql
new file mode 100644
index 00000000000..c13f9fcd724
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_23_11_world.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `creature_loot_template` SET `Chance`=0, `GroupId`=2 WHERE `Entry`=18693 AND `Item` IN (31163, 31164, 31165, 31166);
diff --git a/sql/updates/world/3.3.5/2019_06_23_12_world.sql b/sql/updates/world/3.3.5/2019_06_23_12_world.sql
new file mode 100644
index 00000000000..ff1ce658779
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_23_12_world.sql
@@ -0,0 +1,10 @@
+-- 
+DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (10214, 10255);
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
+(10214, 0, 1, "I want to browse your goods", 3370, 3, 128, 0, 0, 0, 0, "", 0, 0),
+(10255, 0, 1, "I want to browse your goods", 3370, 3, 128, 0, 0, 0, 0, "", 0, 0);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (10214, 10255);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(15, 10214, 0, 0, 0, 8, 0, 12870, 0, 0, 0, 0, 0, "", "NPC Rork Sharpchin can sell items only if quest 'Ancient Relics' is rewarded"),
+(15, 10255, 0, 0, 0, 8, 0, 12882, 0, 0, 0, 0, 0, "", "NPC Olut Alegut can sell items only if quest 'Ancient Relics' is rewarded");
diff --git a/sql/updates/world/3.3.5/2019_06_23_13_world.sql b/sql/updates/world/3.3.5/2019_06_23_13_world.sql
new file mode 100644
index 00000000000..c670691a9e1
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_23_13_world.sql
@@ -0,0 +1,38 @@
+-- 
+UPDATE `creature` SET `spawndist`=2 WHERE `guid` IN (108910, 108911, 108912, 108913);
+
+UPDATE `creature_template` SET `AIName`="SmartAI", `unit_flags`=`unit_flags`|256 WHERE `entry`=24547;
+UPDATE `creature` SET `position_x`=-49.74284, `position_y`=-3393.537, `position_z`=-8.100207, `orientation`=3.70 WHERE `guid`=117725;
+DELETE FROM `creature_template_addon` WHERE `entry`=24547;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(24547, 0, 0, 3, 0, 0, "");
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24742, 24547, 2454700, 2474200) AND `source_type` IN (0, 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`, `event_param5`, `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
+(24742, 0, 0, 0, 0, 0, 100, 0, 0, 15000, 15000, 30000, 0, 11, 50188, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - IC - Cast Wildly Flailing"),
+(24742, 0, 1, 2, 34, 0, 100, 0, 8, 1, 0, 0, 0, 97, 20, 20, 0, 0, 0, 0, 1, 0, 0, 0, -37.5049, -3421.69, -14.2464, 0, "\"Mad\" Jonah Sterling - On MovementInform PointID 1 - Jump to Hozzer"),
+(24742, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 24547, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On WP 1 Reached - Set Data 1 1 Hozzer"),
+(24742, 0, 3, 0, 2, 0, 100, 513, 0, 25, 0, 0, 0, 80, 2474200, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On 25% Hp - Run Script"),
+(24547, 0, 0, 0, 0, 0, 100, 0, 5000, 10000, 15000, 20000, 0, 11, 34298, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Hozzer - In Combat - Cast Maul"),
+(24547, 0, 1, 2, 38, 0, 100, 0, 1, 1, 0, 0, 0, 53, 1, 24547, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Data 1 1 Set - Start Waypoint"),
+(24547, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 91, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Data 1 1 Set - Remove Standstate Sleep"),
+(24547, 0, 3, 0, 40, 0, 100, 0, 3, 24547, 0, 0, 0, 80, 2454700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Waypoint 3 Reached - Run Script"),
+(2454700, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Talk 0"),
+(2454700, 9, 1, 0, 0, 0, 100, 0, 200, 200, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 24742, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Talk 1 (\"Mad\" Jonah Sterling)"),
+(2454700, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 44458, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Cast Hozzer Feeds"),
+(2454700, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 24742, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Despawn \"Mad\" Jonah Sterling"),
+(2454700, 9, 4, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 19, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Remove Flag IMMUNE_TO_PC"),
+(2454700, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Hozzer - On Script - Set ReactState Aggressive"),
+(2474200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 117, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Disable Evade"),
+(2474200, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Set HP Regen Off"),
+(2474200, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 27, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Stop Combat"),
+(2474200, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 89, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Disable Random Move"),
+(2474200, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, -36.1289, -3425.64, 4.99862, 0, "\"Mad\" Jonah Sterling - On Script - Move To Pos"),
+(2474200, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 18, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Set Unit Flag IMMUNE_TO_PC"),
+(2474200, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "\"Mad\" Jonah Sterling - On Script - Say Line 1");
+
+DELETE FROM `waypoints` WHERE `entry` IN (24547, 24742);
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
+(24547, 1, -31.82427, -3401.094, -14.61846, "Hozzer"),
+(24547, 2, -30.87391, -3411.618, -15.25708, "Hozzer"),
+(24547, 3, -35.8712, -3419.122, -14.47846, "Hozzer");
diff --git a/sql/updates/world/3.3.5/2019_06_23_14_world.sql b/sql/updates/world/3.3.5/2019_06_23_14_world.sql
new file mode 100644
index 00000000000..409df2d5c12
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_23_14_world.sql
@@ -0,0 +1,10 @@
+-- 
+UPDATE `creature_template_addon` SET `auras`="45842" WHERE `entry`=25478;
+DELETE FROM `creature_addon` WHERE `guid`=113408;
+INSERT INTO `creature_addon` (`guid`, `auras`) VALUES
+(113408, "46076");
+
+DELETE FROM `spell_area` WHERE `spell` IN (45844, 46079);
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
+(45844, 4023, 11590, 0, 0, 0, 2, 1, 64, 11),
+(46079, 4023, 11681, 0, 0, 0, 2, 1, 66, 11);
diff --git a/sql/updates/world/3.3.5/2019_06_23_15_world.sql b/sql/updates/world/3.3.5/2019_06_23_15_world.sql
new file mode 100644
index 00000000000..d85e6c61667
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_23_15_world.sql
@@ -0,0 +1,23 @@
+-- 
+DELETE FROM `creature_text` WHERE `CreatureID` IN (31261, 31259);
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(31261, 0, 0, "This is madness! Cease this foolish battle!", 12, 1, 100, 0, 0, 0, 31915, 0, "Brother Keltan"),
+(31261, 0, 1, "Brothers and sisters, we must remain united! The Lich King will never fall to a world divided!", 12, 1, 100, 0, 0, 0, 31916, 0, "Brother Keltan"),
+(31261, 0, 2, "Can you not see that you play right into the Lich King's hands? He wants you to kill each other!", 12, 1, 100, 0, 0, 0, 31917, 0, "Brother Keltan"),
+(31261, 0, 3, "Join the Argent Crusade! United, we shall destroy the Lich King!", 12, 1, 100, 0, 0, 0, 31918, 0, "Brother Keltan"),
+(31261, 0, 4, "Judgment day comes, brothers and sisters! Will you be prepared?", 12, 1, 100, 0, 0, 0, 31919, 0, "Brother Keltan"),
+(31261, 0, 5, "How much of our efforts are being wasted by attacking the Alliance?", 12, 1, 100, 0, 0, 0, 31920, 0, "Brother Keltan"),
+(31261, 0, 6, "We must unite and focus our attention upon the true threat: THE LICH KING!", 12, 1, 100, 0, 0, 0, 31922, 0, "Brother Keltan"),
+(31259, 0, 0, "This is madness! Cease this foolish battle!", 12, 7, 100, 0, 0, 0, 31923, 0, "Absalan the Pious"),
+(31259, 0, 1, "Brothers and sisters, we must remain united! The Lich King will never fall to a world divided!", 12, 7, 100, 0, 0, 0, 31924, 0, "Absalan the Pious"),
+(31259, 0, 2, "Can you not see that you play right into the Lich King's hands? He wants you to kill each other!", 12, 7, 100, 0, 0, 0, 31925, 0, "Absalan the Pious"),
+(31259, 0, 3, "Join the Argent Crusade! United, we shall destroy the Lich King!", 12, 7, 100, 0, 0, 0, 31926, 0, "Absalan the Pious"),
+(31259, 0, 4, "Judgment day comes, brothers and sisters! Will you be prepared?", 12, 7, 100, 0, 0, 0, 31927, 0, "Absalan the Pious"),
+(31259, 0, 5, "How much of our efforts are being wasted by attacking the Horde?", 12, 7, 100, 0, 0, 0, 31928, 0, "Absalan the Pious"),
+(31259, 0, 6, "We must unite and focus our attention upon the true threat: THE LICH KING!", 12, 7, 100, 0, 0, 0, 31929, 0, "Absalan the Pious");
+
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (31261, 31259);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (31261, 31259) 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`, `event_param5`, `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
+(31261, 0, 0, 0, 1, 0, 100, 0, 15000, 30000, 100000, 140000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Brother Keltan - Out Of Combat - Say Line 0"),
+(31259, 0, 0, 0, 1, 0, 100, 0, 15000, 30000, 100000, 140000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Absalan the Pious - Out Of Combat - Say Line 0");
diff --git a/sql/updates/world/3.3.5/2019_06_23_16_world.sql b/sql/updates/world/3.3.5/2019_06_23_16_world.sql
new file mode 100644
index 00000000000..2b50e617dd2
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_23_16_world.sql
@@ -0,0 +1,31 @@
+-- 
+UPDATE `creature_addon` SET `auras`="55474" WHERE `guid` IN (125388, 125390, 125385);
+DELETE FROM `creature` WHERE `guid`=125391;
+DELETE FROM `creature_addon` WHERE `guid`=125391;
+
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=27432;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-125386, 2743200) AND `source_type` IN (0, 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`, `event_param5`, `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
+(-125386, 0, 0, 0, 1, 0, 100, 0, 5000, 20000, 150000, 210000, 0, 80, 2743200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Warsong Peon - Out Of Combat - Run Script"),
+(2743200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 10, 125389, 27432, 0, 0, 0, 0, 0, "Warsong Peon - On Script - Say Line 0 (Warsong Peon)"),
+(2743200, 9, 1, 0, 0, 0, 50, 0, 60000, 120000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Warsong Peon - On Script - Say Line 1"),
+(2743200, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 5, 36, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Warsong Peon - On Script - Play Emote 'Attack 1H'"),
+(2743200, 9, 3, 0, 0, 0, 50, 0, 1000, 1000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 10, 125387, 27432, 0, 0, 0, 0, 0, "Warsong Peon - On Script - Say Line 2 (Warsong Peon)");
+
+DELETE FROM `creature_text` WHERE `CreatureID`=27432;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(27432, 0, 0, "Me hungry.", 12, 1, 100, 1, 0, 0, 26572, 0, "Warsong Peon"),
+(27432, 0, 1, "Me sleepy.", 12, 1, 100, 1, 0, 0, 26573, 0, "Warsong Peon"),
+(27432, 0, 2, "Me cold.", 12, 1, 100, 1, 0, 0, 26574, 0, "Warsong Peon"),
+(27432, 0, 3, "Me scared of bug things.", 12, 1, 100, 1, 0, 0, 26575, 0, "Warsong Peon"),
+(27432, 0, 4, "Me got stuck in sticky bug rope.", 12, 1, 100, 1, 0, 0, 26576, 0, "Warsong Peon"),
+(27432, 0, 5, "Me no like rock place full of bugs.", 12, 1, 100, 1, 0, 0, 26577, 0, "Warsong Peon"),
+(27432, 0, 6, "Me no like new cold place.", 12, 1, 100, 1, 0, 0, 26578, 0, "Warsong Peon"),
+(27432, 0, 7, "It time for work! Zug zug!", 12, 1, 100, 1, 0, 0, 26589, 0, "Warsong Peon"),
+(27432, 1, 0, "Ha ha.", 12, 1, 100, 1, 0, 0, 26582, 0, "Warsong Peon"),
+(27432, 1, 1, "That funny.", 12, 1, 100, 1, 0, 0, 26583, 0, "Warsong Peon"),
+(27432, 1, 2, "Your head like rock.", 12, 1, 100, 1, 0, 0, 26588, 0, "Warsong Peon"),
+(27432, 2, 0, "Ow.", 12, 1, 100, 1, 0, 0, 26584, 0, "Warsong Peon"),
+(27432, 2, 1, "Stop it!", 12, 1, 100, 1, 0, 0, 26585, 0, "Warsong Peon"),
+(27432, 2, 2, "That hurt.", 12, 1, 100, 1, 0, 0, 26586, 0, "Warsong Peon"),
+(27432, 2, 3, "What that sound?", 12, 1, 100, 1, 0, 0, 26587, 0, "Warsong Peon");
diff --git a/sql/updates/world/3.3.5/2019_06_23_17_world.sql b/sql/updates/world/3.3.5/2019_06_23_17_world.sql
new file mode 100644
index 00000000000..9c1f8aa866a
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_23_17_world.sql
@@ -0,0 +1,10 @@
+-- 
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=25294;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=25294 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`, `event_param5`, `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
+(25294, 0, 0, 1, 0, 0, 100, 0, 3000, 10000, 30000, 40000, 0, 11, 50284, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Nerub'ar Web Lord - In Combat - Cast 'Blinding Swarm'"),
+(25294, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Nerub'ar Web Lord - In Combat - Say Line 0");
+
+DELETE FROM `creature_text` WHERE `CreatureID`=25294;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(25294, 0, 0, "The %s directs the blinding swarm directly in front of it.", 16, 0, 100, 0, 0, 0, 27381, 0, "Nerub'ar Web Lord");
diff --git a/sql/updates/world/3.3.5/2019_06_23_18_world.sql b/sql/updates/world/3.3.5/2019_06_23_18_world.sql
new file mode 100644
index 00000000000..a8889112f4f
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_23_18_world.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|1 WHERE `entry`=23090;
-- 
cgit v1.2.3