TDB 335.19091 - 2019/09/15TDB335.19091

24 files changed, 5 insertions, 95 deletions

diff --git a/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql b/sql/updates/auth/3.3.5/2019_09_15_00_auth.sql
index 6544c316449..2bca2a89a56 100644
--- a/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql
+++ b/sql/updates/auth/3.3.5/2019_09_15_00_auth.sql
@@ -1,2 +1,2 @@
--- TDB 335.19081 auth
+-- TDB 335.19091 auth
 UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql b/sql/updates/characters/3.3.5/2019_09_15_00_characters.sql
index 5d9a26ec653..e01645f91b0 100644
--- a/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql
+++ b/sql/updates/characters/3.3.5/2019_09_15_00_characters.sql
@@ -1,2 +1,2 @@
--- TDB 335.19081 characters
+-- TDB 335.19091 characters
 UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2019_08_16_00_world.sql b/sql/updates/world/3.3.5/2019_08_16_00_world.sql
deleted file mode 100644
index 7cb4c1c9abb..00000000000
--- a/sql/updates/world/3.3.5/2019_08_16_00_world.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- TDB 335.19081 world
-UPDATE `version` SET `db_version`='TDB 335.19081', `cache_id`=19081 LIMIT 1;
-UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2019_08_17_00_world.sql b/sql/updates/world/3.3.5/2019_08_17_00_world.sql
deleted file mode 100644
index 860c830e416..00000000000
--- a/sql/updates/world/3.3.5/2019_08_17_00_world.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- Burn with fire spell_linked_spell hack
-DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (-19386, -24132, -24133, -27068, -49011, -49012);
-
-DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_wyvern_sting';
-INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
-(-19386,'spell_hun_wyvern_sting');
diff --git a/sql/updates/world/3.3.5/2019_08_17_01_world.sql b/sql/updates/world/3.3.5/2019_08_17_01_world.sql
deleted file mode 100644
index f9239dd8a2e..00000000000
--- a/sql/updates/world/3.3.5/2019_08_17_01_world.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `spell_proc` ADD `DisableEffectsMask` int(10) unsigned NOT NULL DEFAULT '0' AFTER `AttributesMask`;
-
-UPDATE `spell_proc` SET `DisableEffectsMask`=((`AttributesMask` >> 4) & 0x7);
-UPDATE `spell_proc` SET `AttributesMask`=(`AttributesMask` & 0xF);
diff --git a/sql/updates/world/3.3.5/2019_08_17_02_world.sql b/sql/updates/world/3.3.5/2019_08_17_02_world.sql
deleted file mode 100644
index fa322bbb391..00000000000
--- a/sql/updates/world/3.3.5/2019_08_17_02_world.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- 
-UPDATE `waypoint_data` SET `position_z`= 154.61 WHERE `id`= 1287390; 
-UPDATE `creature_template` SET `flags_extra`=`flags_extra`|536870912 WHERE `entry` = 29047;
diff --git a/sql/updates/world/3.3.5/2019_08_18_00_world.sql b/sql/updates/world/3.3.5/2019_08_18_00_world.sql
deleted file mode 100644
index bc781184e28..00000000000
--- a/sql/updates/world/3.3.5/2019_08_18_00_world.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- Missing 5 man normal spellid
-DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gal_darah_stampede_charge' AND `spell_id`=55220;
-INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
-(55220,'spell_gal_darah_stampede_charge');
diff --git a/sql/updates/world/3.3.5/2019_08_22_00_world.sql b/sql/updates/world/3.3.5/2019_08_22_00_world.sql
deleted file mode 100644
index d5b8414eaa8..00000000000
--- a/sql/updates/world/3.3.5/2019_08_22_00_world.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gal_darah_clear_puncture';
-INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES 
-(60022,'spell_gal_darah_clear_puncture');
diff --git a/sql/updates/world/3.3.5/2019_08_30_00_world.sql b/sql/updates/world/3.3.5/2019_08_30_00_world.sql
deleted file mode 100644
index 7f0e90367a7..00000000000
--- a/sql/updates/world/3.3.5/2019_08_30_00_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `creature_template` SET `unit_flags`=33554688, `speed_walk`=1.2, `speed_run`=1.71429 WHERE `entry` IN (36678,38431,38585,38586);
diff --git a/sql/updates/world/3.3.5/2019_09_07_00_world.sql b/sql/updates/world/3.3.5/2019_09_07_00_world.sql
deleted file mode 100644
index 4b5eb530785..00000000000
--- a/sql/updates/world/3.3.5/2019_09_07_00_world.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- 
-DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=13381;
-DELETE FROM `quest_template_addon` WHERE `ID` IN (13404, 13382);
-INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`, `SpecialFlags`) VALUES
-(13404, 13380,1),
-(13382, 13381,1);
-UPDATE `quest_template_addon` SET `PrevQuestID`=13374  WHERE `id`=13376;
-DELETE FROM `player_factionchange_quests` WHERE `alliance_id`=13404;
-INSERT INTO `player_factionchange_quests` (`alliance_id`, `horde_id`) VALUES
-(13404, 13406);
diff --git a/sql/updates/world/3.3.5/2019_09_07_01_world.sql b/sql/updates/world/3.3.5/2019_09_07_01_world.sql
deleted file mode 100644
index f47fcb7d056..00000000000
--- a/sql/updates/world/3.3.5/2019_09_07_01_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `smart_scripts` SET `action_param1`=83 WHERE `entryorguid` IN (-32379,-32378,-32380, 12858) AND `source_type`=0 AND `id`=0;
diff --git a/sql/updates/world/3.3.5/2019_09_07_02_world.sql b/sql/updates/world/3.3.5/2019_09_07_02_world.sql
deleted file mode 100644
index 3b100cd4b75..00000000000
--- a/sql/updates/world/3.3.5/2019_09_07_02_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `quest_offer_reward` SET `RewardText`="They're being driven insane? Voices in their heads?$B$BVoices in your head?!$B$BI want you to clear your mind of the taint that has crept into that place, $g boy : girl;.$B$BWe'll try to get the remainder of them out of there again tomorrow when you've had a chance to rest." WHERE `ID`=13302;
diff --git a/sql/updates/world/3.3.5/2019_09_07_03_world.sql b/sql/updates/world/3.3.5/2019_09_07_03_world.sql
deleted file mode 100644
index cc2285867f9..00000000000
--- a/sql/updates/world/3.3.5/2019_09_07_03_world.sql
+++ /dev/null
@@ -1,14 +0,0 @@
--- 
-UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=23;
-UPDATE `smart_scripts` SET `event_type`=38, `event_param1`=15, `event_param2`=15 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=27;
-UPDATE `creature_text` SET `Type`=14 WHERE `CreatureID` IN (18471) AND `GroupID`=12;
-DELETE FROM `creature_text` WHERE `CreatureID` IN (18471) AND `GroupID`=13;
-INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES 
-(18471,13,0,"For the first time in the Ring of Blood's history, Mogor has chosen to exercise his right of battle! On this wartorn ground, $n will face Mogor, hero of the Warmaul!",14,0,100,0,0,0,15481,0,'Gurgthock');
-UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` IN (18069) AND `source_type`=0 AND `id`=9;
-UPDATE `smart_scripts` SET `event_type`=40, `event_param1`=3, `event_param2`=18069, `action_type`=45, `action_param1`=1, `action_param2`=6, `target_type`=19, `target_param1`=18471  WHERE `entryorguid` IN (18069) AND `source_type`=0 AND `id`=10;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=18471 AND `source_type`=0 AND `id` IN (29,30);
-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 
-(18471, 0, 29, 0, 38, 0, 100, 0, 1, 6, 0, 0, 1, 13, 2000, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, "Gurgthock - On Data Set 1 13 - Say Line 13"),
-(18471, 0, 30, 0, 52, 0, 100, 0, 13, 18471, 0, 0, 1, 3, 0, 0, 0, 0, 0, 19, 18069, 0, 0, 0, 0, 0, 0, "Gurgthock - On text over - Say Line 3");
-UPDATE `smart_scripts` SET `target_type`=7, `target_param1`=0  WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id` IN (4,10,0,6,8);
diff --git a/sql/updates/world/3.3.5/2019_09_07_04_world.sql b/sql/updates/world/3.3.5/2019_09_07_04_world.sql
deleted file mode 100644
index e465b964d02..00000000000
--- a/sql/updates/world/3.3.5/2019_09_07_04_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `smart_scripts` SET `target_type`=7, `target_param1`=0  WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=2;
diff --git a/sql/updates/world/3.3.5/2019_09_08_00_world.sql b/sql/updates/world/3.3.5/2019_09_08_00_world.sql
deleted file mode 100644
index 613583dbd6b..00000000000
--- a/sql/updates/world/3.3.5/2019_09_08_00_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `quest_request_items` SET `CompletionText`="Finally, you've arrived... and discretely also. Good.$b$bOur world is full of fools, $N. Even the mighty Thrall has greater flaws than most can see. He turns his back on the power needed to make this land ours completely! We're not the same people who were manipulated and used by creatures from the Nether. We are our own people. We are proud... and we are strong." WHERE `ID`=3090;
diff --git a/sql/updates/world/3.3.5/2019_09_08_01_world.sql b/sql/updates/world/3.3.5/2019_09_08_01_world.sql
deleted file mode 100644
index 852c6588cb8..00000000000
--- a/sql/updates/world/3.3.5/2019_09_08_01_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `quest_request_items` SET `CompletionText`="Our spells of Fortify are very powerful, $N. They allow our companions to take further injury from all types of attacks and survive in situations where they would normally fall. But this is nothing when compared to our abilities to heal. There are no greater healers than a priest--do well to remember that. Your power alone can turn the tides of battle easily." WHERE `ID`=5621;
diff --git a/sql/updates/world/3.3.5/2019_09_09_00_world.sql b/sql/updates/world/3.3.5/2019_09_09_00_world.sql
deleted file mode 100644
index 68eb8bdd2c0..00000000000
--- a/sql/updates/world/3.3.5/2019_09_09_00_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7725;
diff --git a/sql/updates/world/3.3.5/2019_09_09_01_world_335.sql b/sql/updates/world/3.3.5/2019_09_09_01_world_335.sql
deleted file mode 100644
index 7fd1fa416d6..00000000000
--- a/sql/updates/world/3.3.5/2019_09_09_01_world_335.sql
+++ /dev/null
@@ -1,5 +0,0 @@
--- 
-DELETE FROM `gameobject_template` WHERE `entry` IN (183278,183282);
-INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES
-(183282, 6, 0, "Infernaling Summoner Damage Trap", 1,   0, 1, 4, 29115, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", -18019),
-(183278, 6, 5752, "Infernaling Summoner", 2.5,   0, 0, 0, 33533, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", -18019);
diff --git a/sql/updates/world/3.3.5/2019_09_09_02_world.sql b/sql/updates/world/3.3.5/2019_09_09_02_world.sql
deleted file mode 100644
index 595175a2f40..00000000000
--- a/sql/updates/world/3.3.5/2019_09_09_02_world.sql
+++ /dev/null
@@ -1,18 +0,0 @@
--- 
-DELETE FROM `smart_scripts` WHERE `entryorguid` IN (19067,19210) AND `source_type`=0;
-DELETE FROM `smart_scripts` WHERE `entryorguid` IN (1906700,1921000) 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
-(19067, 0, 0, 0, 8, 0, 100, 0, 33531, 0, 0, 0, 80, 1906700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - On spell hit - Action list"),
-(1906700, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.210368, "Fel Cannon: Hate - Action list - set orientation"),
-(1906700, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 33535, 0, 0, 0, 0, 0, 19, 19212, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - cast spell"),
-(1906700, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 19067, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Credit quest"),
-(1906700, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 92, 0, 33535, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Interrupt spell"),
-(1906700, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 42346, 0, 0, 0, 0, 0, 19, 19212, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Self cast spell"),
-(1906700, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - set orientation"),
-(19210, 0, 0, 0, 8, 0, 100, 0, 33532, 0, 0, 0, 80, 1921000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - On spell hit - Action list"),
-(1921000, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.737549, "Fel Cannon: Fear - Action list - set orientation"),
-(1921000, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 33535, 0, 0, 0, 0, 0, 19, 19211, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - cast spell"),
-(1921000, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 19210, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Credit quest"),
-(1921000, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 92, 0, 33535, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Interrupt spell"),
-(1921000, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 42346, 0, 0, 0, 0, 0, 19, 19211, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Self cast spell"),
-(1921000, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - set orientation");
diff --git a/sql/updates/world/3.3.5/2019_09_10_00_world.sql b/sql/updates/world/3.3.5/2019_09_10_00_world.sql
deleted file mode 100644
index 7afa08f854e..00000000000
--- a/sql/updates/world/3.3.5/2019_09_10_00_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `creature_template` SET `flags_extra` = `flags_extra`|128 WHERE `entry` =21321;
diff --git a/sql/updates/world/3.3.5/2019_09_12_01_world.sql b/sql/updates/world/3.3.5/2019_09_12_01_world.sql
deleted file mode 100644
index e492c6cdb5a..00000000000
--- a/sql/updates/world/3.3.5/2019_09_12_01_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- O'Mally's Instrument Bunny (entry: 22021)
-UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=22021;
diff --git a/sql/updates/world/3.3.5/2019_09_12_02_world.sql b/sql/updates/world/3.3.5/2019_09_12_02_world.sql
deleted file mode 100644
index 805033401e7..00000000000
--- a/sql/updates/world/3.3.5/2019_09_12_02_world.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- 
-UPDATE `creature_template` SET `unit_flags`=320 WHERE `entry` IN (37591,37606);
-UPDATE `creature_template` SET `gossip_menu_id`=10923 WHERE `entry` IN (37607);
diff --git a/sql/updates/world/3.3.5/2019_09_12_03_world.sql b/sql/updates/world/3.3.5/2019_09_12_03_world.sql
deleted file mode 100644
index 033a7471c56..00000000000
--- a/sql/updates/world/3.3.5/2019_09_12_03_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `creature_template` SET `unit_flags`=32832, `dynamicflags`=0 WHERE `entry` IN (37604 ,37809, 37779);
diff --git a/sql/updates/world/3.3.5/2019_09_15_00_world.sql b/sql/updates/world/3.3.5/2019_09_15_00_world.sql
new file mode 100644
index 00000000000..6d3536df062
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_09_15_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.19091 world
+UPDATE `version` SET `db_version`='TDB 335.19091', `cache_id`=19091 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';