TDB 335.19091 - 2019/09/15TDB335.19091

23 files changed, 97 insertions, 0 deletions

diff --git a/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql b/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql
new file mode 100644
index 00000000000..6544c316449
--- /dev/null
+++ b/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19081 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql b/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql
new file mode 100644
index 00000000000..5d9a26ec653
--- /dev/null
+++ b/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19081 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql
new file mode 100644
index 00000000000..7cb4c1c9abb
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql
@@ -0,0 +1,3 @@
+-- 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/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql
new file mode 100644
index 00000000000..860c830e416
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql
@@ -0,0 +1,6 @@
+-- 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/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql
new file mode 100644
index 00000000000..f9239dd8a2e
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql
@@ -0,0 +1,4 @@
+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/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql
new file mode 100644
index 00000000000..fa322bbb391
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql
@@ -0,0 +1,3 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql
new file mode 100644
index 00000000000..bc781184e28
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql
@@ -0,0 +1,4 @@
+-- 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/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql
new file mode 100644
index 00000000000..d5b8414eaa8
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql
@@ -0,0 +1,3 @@
+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/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql
new file mode 100644
index 00000000000..7f0e90367a7
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql
@@ -0,0 +1,2 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql
new file mode 100644
index 00000000000..4b5eb530785
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql
@@ -0,0 +1,10 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql
new file mode 100644
index 00000000000..f47fcb7d056
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql
@@ -0,0 +1,2 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql
new file mode 100644
index 00000000000..3b100cd4b75
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql
@@ -0,0 +1,2 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql
new file mode 100644
index 00000000000..cc2285867f9
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql
@@ -0,0 +1,14 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql
new file mode 100644
index 00000000000..e465b964d02
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql
@@ -0,0 +1,2 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql
new file mode 100644
index 00000000000..613583dbd6b
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql
@@ -0,0 +1,2 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql
new file mode 100644
index 00000000000..852c6588cb8
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql
@@ -0,0 +1,2 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql
new file mode 100644
index 00000000000..68eb8bdd2c0
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql
@@ -0,0 +1,2 @@
+-- 
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7725;
diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql
new file mode 100644
index 00000000000..7fd1fa416d6
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql
@@ -0,0 +1,5 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql
new file mode 100644
index 00000000000..595175a2f40
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql
@@ -0,0 +1,18 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql
new file mode 100644
index 00000000000..7afa08f854e
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `creature_template` SET `flags_extra` = `flags_extra`|128 WHERE `entry` =21321;
diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql
new file mode 100644
index 00000000000..e492c6cdb5a
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql
@@ -0,0 +1,2 @@
+-- O'Mally's Instrument Bunny (entry: 22021)
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=22021;
diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql
new file mode 100644
index 00000000000..805033401e7
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql
@@ -0,0 +1,3 @@
+-- 
+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/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql
new file mode 100644
index 00000000000..033a7471c56
--- /dev/null
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `creature_template` SET `unit_flags`=32832, `dynamicflags`=0 WHERE `entry` IN (37604 ,37809, 37779);