TDB 335.19111 - 2019/11/16TDB335.19111

24 files changed, 183 insertions, 0 deletions

diff --git a/sql/old/3.3.5a/auth/19101_2019_11_16/2019_10_18_00_auth.sql b/sql/old/3.3.5a/auth/19101_2019_11_16/2019_10_18_00_auth.sql
new file mode 100644
index 00000000000..78f7ecf4167
--- /dev/null
+++ b/sql/old/3.3.5a/auth/19101_2019_11_16/2019_10_18_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19101 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/3.3.5a/characters/19101_2019_11_16/2019_10_18_00_characters.sql b/sql/old/3.3.5a/characters/19101_2019_11_16/2019_10_18_00_characters.sql
new file mode 100644
index 00000000000..6fa0cc4e878
--- /dev/null
+++ b/sql/old/3.3.5a/characters/19101_2019_11_16/2019_10_18_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19101 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_18_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_18_00_world.sql
new file mode 100644
index 00000000000..2230240af2b
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_18_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.19101 world
+UPDATE `version` SET `db_version`='TDB 335.19101', `cache_id`=19101 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_00_world.sql
new file mode 100644
index 00000000000..c41161d61ab
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_00_world.sql
@@ -0,0 +1,6 @@
+-- 
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry` IN (15262, 15312);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (15262,15312) AND `source_type`=0 AND `id`=0 AND `link`=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_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(15262, 0, 0, 0, 25, 0, 100, 2, 0, 0, 0, 0, 0, 108, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Obsidian Eradicator - On reset - Set Mana To 0'),
+(15312, 0, 0, 0, 25, 0, 100, 2, 0, 0, 0, 0, 0, 108, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Obsidian Nullifier - On reset - Set Mana To 0');
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_01_world.sql
new file mode 100644
index 00000000000..62865c7c63b
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_01_world.sql
@@ -0,0 +1,3 @@
+-- 
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry` IN (14862);
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid` IN (14862) AND `source_type`=0 AND `id`=5;
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_02_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_02_world.sql
new file mode 100644
index 00000000000..6ed5ad174f1
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_20_02_world.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|33554432 WHERE `entry` IN (36497,36498);
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_00_world.sql
new file mode 100644
index 00000000000..085dfc4a44f
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_00_world.sql
@@ -0,0 +1,25 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (85978,117314,117315,117316);
+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
+(85978, 30669, 571, 210, 4501, 1, 64, 0, 0, 6309.156, 53.15728, 393.4325, 2.391101, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 30669 (Area: 4501 - Difficulty: 0)
+(117314, 30669, 571, 210, 4501, 1, 64, 0, 0, 6255.246, 112.484, 387.5711, 1.745329, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 30669 (Area: 4501 - Difficulty: 0)
+(117315, 30669, 571, 210, 4501, 1, 64, 0, 0, 6218.403, 75.91792, 378.1545, 1.850049, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 30669 (Area: 4501 - Difficulty: 0)
+(117316, 30669, 571, 210, 4501, 1, 64, 0, 0, 6155.497, 78.52045, 370.4583, 4.18879, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340); -- 30669 (Area: 4501 - Difficulty: 0)
+
+UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (30669);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30669) AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3066900, 3066901, 3066902, 3066903, 3066904, 3066905, 3066906, 3066907, 3066908, 3066909, 3066910, 3066911) 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
+(30669, 0, 0, 0, 1, 0, 100, 0, 20000, 40000, 30000, 50000, 88, 3066900, 3066911, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Ooc - Random action list'),
+(3066900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14560, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066901, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14563, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066902, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14562, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066903, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14561, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066904, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14556, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066905, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14559, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066906, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14558, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066907, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14557, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066908, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14564, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066909, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14565, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066910, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14566, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound'),
+(3066911, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 4, 14567, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Vanguard Sound Dummy - Action list - Play sound');
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_01_world.sql
new file mode 100644
index 00000000000..0350e637f3d
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_01_world.sql
@@ -0,0 +1,8 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (117317,117318,117319);
+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
+(117317, 30685, 571, 210, 4504, 1, 128, 0, 1, 6370.581, 227.0712, 396.1292, 3.089233, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 30685 (Area: 4504 - Difficulty: 0)
+(117318, 30685, 571, 210, 4504, 1, 128, 0, 1, 6378.393, 229.9219, 396.1292, 0.9250245, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 30685 (Area: 4504 - Difficulty: 0)
+(117319, 30685, 571, 210, 4504, 1, 128, 0, 1, 6378.936, 224.7951, 396.1292, 6.003932, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340); -- 30685 (Area: 4504 - Difficulty: 0)
+
+UPDATE `creature` SET `position_x`=6371.885, `position_y`=237.8247, `position_z`=396.1291, `orientation`=1.710423 WHERE `id`=30686;
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_02_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_02_world.sql
new file mode 100644
index 00000000000..446e3b568b9
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_02_world.sql
@@ -0,0 +1,6 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (117320);
+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
+(117320, 30719, 571, 210, 4501, 1, 128, 0, 0, 6368.458, 217.5608, 395.3252, 5.986479, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340); -- 30719 (Area: 4501 - Difficulty: 0)
+
+UPDATE `creature_template_addon` SET `bytes1`=1 WHERE `entry` IN (30719);
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_03_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_03_world.sql
new file mode 100644
index 00000000000..2bd16f61a5e
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_21_03_world.sql
@@ -0,0 +1,7 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (117321,117322,117323,117365);
+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
+(117321, 31220, 571, 0, 0, 1, 1, 0, 0, 6067.22, 1892.13, 632.662, 3.45575, 300, 0, 0, 0, 0, 0, 0, 0, 0, 12340),
+(117322, 31225, 571, 0, 0, 1, 2, 0, 0, 6027.64, 1921.29, 632.678, 4.34922, 300, 0, 0, 0, 0, 0, 0, 0, 0, 12340),
+(117323, 31223, 571, 0, 0, 1, 2, 0, 0, 6472.73, 1722.66, 508.784, 5.91667, 300, 0, 0, 0, 0, 0, 0, 0, 0, 12340),
+(117365, 31224, 571, 0, 0, 1, 2, 0, 0, 6564.38, 1613.81, 633.546, 1.66397, 300, 0, 0, 0, 0, 0, 0, 0, 0, 12340);
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_00_world.sql
new file mode 100644
index 00000000000..d3db029bdd1
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_00_world.sql
@@ -0,0 +1,9 @@
+-- 
+DELETE FROM `creature_template_addon` WHERE `entry` IN (30382,30383);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
+(30382, 0, 0, 0, 0, 0, '54500'),
+(30383, 0, 0, 0, 0, 0, '54500');
+
+DELETE FROM `spell_area` WHERE `spell`=56582 AND `area`=4431;
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
+(56582, 4431, 12880, 12973, 0, 0, 2, 1, 74, 1);
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_01_world.sql
new file mode 100644
index 00000000000..2b1941f464b
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_01_world.sql
@@ -0,0 +1,3 @@
+-- 
+UPDATE `quest_template_addon` SET `ExclusiveGroup`=-13047 WHERE `id` IN (13417,13047);
+UPDATE `quest_template_addon` SET `PrevQuestID`=13047 WHERE `id` IN (12869);
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_02_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_02_world.sql
new file mode 100644
index 00000000000..eeaa4ebea22
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_02_world.sql
@@ -0,0 +1,6 @@
+-- 
+UPDATE `creature_addon` SET `auras`="54500" WHERE `guid` IN (104811);
+DELETE FROM `spell_area` WHERE `spell`=56582 AND `area`=4432;
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
+(56582, 4432, 0, 12973, 0, 0, 2, 1, 0, 11);
+UPDATE `spell_area` SET `quest_end`=12973, `quest_end_status`=11 WHERE `spell`=55782 AND `area`=4432;
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_03_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_03_world.sql
new file mode 100644
index 00000000000..1fe3adeee65
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_22_03_world.sql
@@ -0,0 +1,7 @@
+-- 
+UPDATE `creature_addon` SET `auras`="60921" WHERE `guid` IN (104811);
+DELETE FROM `spell_area` WHERE `spell`=56582 AND `area`=4432;
+DELETE FROM `spell_area` WHERE `spell`=60922 AND `area` IN (4432,4431);
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
+(60922, 4432, 0, 12973, 0, 0, 2, 1, 0, 11),
+(60922, 4431, 0, 12973, 0, 0, 2, 1, 0, 11);
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_26_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_26_00_world.sql
new file mode 100644
index 00000000000..27fd0eb82e3
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_26_00_world.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `smart_scripts` SET `target_type`=16 WHERE `entryorguid` IN (3677000,3676400) AND `source_type`=9 AND `id`=5;
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_29_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_29_00_world.sql
new file mode 100644
index 00000000000..e2709b0ae4b
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_10_29_00_world.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `smart_scripts` SET `target_type`=23 WHERE `entryorguid` IN (3027400) AND `source_type`=9 AND `id`=1; 
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_00_world.sql
new file mode 100644
index 00000000000..d9070063b23
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_00_world.sql
@@ -0,0 +1,2 @@
+-- 
+DELETE FROM `creature_loot_template` WHERE `entry`=4096 AND `Item` IN (30322,30302);
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_01_world.sql
new file mode 100644
index 00000000000..60ca202b872
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_03_01_world.sql
@@ -0,0 +1,2 @@
+-- 
+DELETE FROM `conditions` WHERE `SourceGroup`=4096 AND `SourceEntry` IN (30302,30322) AND `SourceTypeOrReferenceId`=1;
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_00_world.sql
new file mode 100644
index 00000000000..1e65ad0d912
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_00_world.sql
@@ -0,0 +1,29 @@
+-- Archaeologist Andorin and Moteha Windborn Brann's Communicator recovery
+DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (9854, 9929);
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`) VALUES
+(9854, 1, 0, "I lost Brann's Communicator and need a replacement.",  31229, 1, 1, 0, 0, 0, 0, "", 0),
+(9929, 1, 0, "I lost Brann's Communicator and need a replacement.",  33084, 1, 1, 0, 0, 0, 0, "", 0);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (9854, 9929);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(15, 9854, 1, 0, 0, 28, 0, 12910, 0, 0, 0, 0, 0, '', 'Gossip Option requires quest complete 12910 before this option is visible'),
+(15, 9854, 1, 0, 0, 2, 0, 40971, 1, 0, 1, 0, 0, '', 'Gossip Option requires not having item 40971'),
+(15, 9929, 1, 0, 0, 28, 0, 12855, 0, 0, 0, 0, 0, '', 'Gossip Option requires quest complete 12855 before this option is visible'),
+(15, 9929, 1, 0, 0, 2, 0, 40971, 1, 0, 1, 0, 0, '', 'Gossip Option requires not having item 40971'),
+(15, 9854, 1, 0, 1, 8, 0, 12910, 0, 0, 0, 0, 0, '', 'Gossip Option requires quest rewarded 12910 before this option is visible'),
+(15, 9854, 1, 0, 1, 2, 0, 40971, 1, 0, 1, 0, 0, '', 'Gossip Option requires not having item 40971'),
+(15, 9929, 1, 0, 1, 8, 0, 12855, 0, 0, 0, 0, 0, '', 'Gossip Option requires quest rewarded 12855 before this option is visible'),
+(15, 9929, 1, 0, 1, 2, 0, 40971, 1, 0, 1, 0, 0, '', 'Gossip Option requires not having item 40971');
+
+UPDATE `creature_template` SET `AIName`="SmartAI", `ScriptName`="" WHERE `entry` IN (29937,29650);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29937) AND `source_type`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29650) AND `source_type`=0 AND `id`>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`, `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
+(29937, 0, 0, 1, 62, 0, 100, 0, 9854, 1, 0, 0, 11, 57093, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Moteha Windborn - On Gossip Option 0 Selected - Invoker cast Branns Communicator Replacement"),
+(29937, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Moteha Windborn - Link - Close Gossip"),
+(29650, 0, 1, 2, 62, 0, 100, 0, 9929, 1, 0, 0, 11, 57093, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Archaeologist Andorin - On Gossip Option 0 Selected - Invoker cast Branns Communicator Replacement"),
+(29650, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Archaeologist Andorin - Link - Close Gossip");
+
+DELETE FROM `spell_dbc` WHERE `Id`=57093;
+INSERT INTO `spell_dbc` (`Id`, `Dispel`, `Mechanic`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `Stances`, `StancesNot`, `Targets`, `CastingTimeIndex`, `AuraInterruptFlags`, `ProcFlags`, `ProcChance`, `ProcCharges`, `MaxLevel`, `BaseLevel`, `SpellLevel`, `DurationIndex`, `RangeIndex`, `StackAmount`, `EquippedItemClass`, `EquippedItemSubClassMask`, `EquippedItemInventoryTypeMask`, `Effect1`, `Effect2`, `Effect3`, `EffectDieSides1`, `EffectDieSides2`, `EffectDieSides3`, `EffectRealPointsPerLevel1`, `EffectRealPointsPerLevel2`, `EffectRealPointsPerLevel3`, `EffectBasePoints1`, `EffectBasePoints2`, `EffectBasePoints3`, `EffectMechanic1`, `EffectMechanic2`, `EffectMechanic3`, `EffectImplicitTargetA1`, `EffectImplicitTargetA2`, `EffectImplicitTargetA3`, `EffectImplicitTargetB1`, `EffectImplicitTargetB2`, `EffectImplicitTargetB3`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectRadiusIndex3`, `EffectApplyAuraName1`, `EffectApplyAuraName2`, `EffectApplyAuraName3`, `EffectAmplitude1`, `EffectAmplitude2`, `EffectAmplitude3`, `EffectMultipleValue1`, `EffectMultipleValue2`, `EffectMultipleValue3`, `EffectItemType1`, `EffectItemType2`, `EffectItemType3`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectMiscValue3`, `EffectMiscValueB1`, `EffectMiscValueB2`, `EffectMiscValueB3`, `EffectTriggerSpell1`, `EffectTriggerSpell2`, `EffectTriggerSpell3`, `EffectSpellClassMaskA1`, `EffectSpellClassMaskA2`, `EffectSpellClassMaskA3`, `EffectSpellClassMaskB1`, `EffectSpellClassMaskB2`, `EffectSpellClassMaskB3`, `EffectSpellClassMaskC1`, `EffectSpellClassMaskC2`, `EffectSpellClassMaskC3`, `MaxTargetLevel`, `SpellFamilyName`, `SpellFamilyFlags1`, `SpellFamilyFlags2`, `SpellFamilyFlags3`, `MaxAffectedTargets`, `DmgClass`, `PreventionType`, `DmgMultiplier1`, `DmgMultiplier2`, `DmgMultiplier3`, `AreaGroupId`, `SchoolMask`, `SpellName`) VALUES 
+(57093, 0, 0, 384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 101, 0, 0, 0, 0, 0, 13, 0, -1, 0, 0, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40971, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 'Brann\'s Communicator Replacement');
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_01_world.sql
new file mode 100644
index 00000000000..86aa7c5c177
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_09_01_world.sql
@@ -0,0 +1,16 @@
+UPDATE `creature` SET `spawntimesecs`=60 WHERE `id` IN (19565,20899);
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=20933;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=20933 AND `source_type`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=20899 AND `source_type`=0 AND `id` IN (3,4);
+DELETE FROM `smart_scripts` WHERE `entryorguid`=2093300 AND `source_type`=9;
+UPDATE `smart_scripts` SET `link`='3' WHERE  `entryorguid`=20899 AND `source_type`=0 AND `id`=2 AND `link`=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_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(20899, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 20933, 0, 100, 0, 0, 0, 0, 0, 'Void Conduit - On Death - Set Data'),
+(20899, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 19565, 40, 0, 0, 0, 0, 0, 0, 'Void Conduit - On Death - Kill npc'),
+(20933, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 0, 11, 35761, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Camera Shakers Manaforge Ultris - On Data Set - Cast Ultris Explosion'),
+(20933, 0, 1, 0, 61, 0, 100, 0, 1, 1, 0, 0, 0, 80, 2093300, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Camera Shakers Manaforge Ultris - On Data Set - Run Script'),
+(2093300, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 11, 35763, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Camera Shakers Manaforge Ultris - Script - Cast Ultris Explosion'),
+(2093300, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 11, 35763, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Camera Shakers Manaforge Ultris - Script - Cast Ultris Explosion'),
+(2093300, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 11, 35763, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Camera Shakers Manaforge Ultris - Script - Cast Ultris Explosion'),
+(2093300, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 11, 35763, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Camera Shakers Manaforge Ultris - Script - Cast Ultris Explosion'),
+(2093300, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 11, 35763, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Camera Shakers Manaforge Ultris - Script - Cast Ultris Explosion');
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_00_world.sql
new file mode 100644
index 00000000000..cef83d47b36
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_00_world.sql
@@ -0,0 +1,8 @@
+-- Hotfix (2010-02-18): The drop rate of Frost Lotus, from herbs in Northrend, has been increased by 50%. From 5% to 7.5%
+UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 24093 AND `Item` = 36908;
+UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 24224 AND `Item` = 36908;
+UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 24225 AND `Item` = 36908;
+UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 24226 AND `Item` = 36908;
+UPDATE `gameobject_loot_template` SET `MaxCount` = 1, `Chance` = 7.5 WHERE `Entry` = 24227 AND `Item` = 36908;
+UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 25089 AND `Item` = 36908;
+UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 25093 AND `Item` = 36908;
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_01_world.sql
new file mode 100644
index 00000000000..15c1b650bae
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_12_01_world.sql
@@ -0,0 +1,21 @@
+UPDATE `smart_scripts` SET `target_type`=23,`action_param3`=1 WHERE `entryorguid` IN (28948,2894800) AND `source_type` IN (0,9) AND `action_type`=1; 
+UPDATE `smart_scripts` SET `comment`= 'Malmortis - On Waypoint 80 Reached - Say Line 6 (No Repeat)' WHERE `entryorguid`=28948 AND `source_type`=0 AND `id`=6; 
+UPDATE `smart_scripts` SET `target_type`=23 WHERE  `entryorguid`=2894800 AND `source_type`=9 AND `id`=3 AND `link`=0;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=2894800 AND `source_type`=9 AND `id`=3;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=28948 AND `source_type`=0 AND `id`>14;
+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
+(28948,0,15,16,40,0,100,1,2,0,0,0,54,4000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Malmortis - On Waypoint 2 Reached - Pause Waypoint (No Repeat)'),
+(28948,0,16,17,61,0,100,1,0,0,0,0,1,2,0,0,0,0,0,23,0,0,0,0,0,0,0,'Malmortis - On Waypoint 2 Reached - Say Line 2 (No Repeat)'),
+(28948,0,17,0,61,0,100,1,0,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,'Malmortis - On Waypoint 2 Reached - Set Orientation To Invoker'),
+(28948,0,18,0,40,0,100,513,93,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,'Malmortis - On Waypoint 93 Reached - Set Orientation To Invoker'),
+(28948,0,19,0,40,0,100,0,93,0,0,0,1,13,5000,1,0,0,0,23,0,0,0,0,0,0,0,'Malmortis - On Waypoint 93 Reached - Say text 13'),
+(28948,0,20,0,52,0,100,0,13,28948,0,0,1,14,7000,1,0,0,0,23,0,0,0,0,0,0,0,'Malmortis - On Text 13 Over - Say text 14'),
+(28948,0,21,22,52,0,100,0,14,28948,0,0,1,15,3000,1,0,0,0,23,0,0,0,0,0,0,0,'Malmortis - On Text 14 Over  - Say text 15'),
+(28948,0,22,0,61,0,100,1,0,0,0,0,11,53101,2,0,0,0,0,23,0,0,0,0,0,0,0,'Malmortis - On Text 14 Over - Cast Kill Credit'),
+(28948,0,23,24,52,0,100,512,15,28948,0,0,11,52676,2,0,0,0,0,1,0,0,0,0,0,0,0,'Malmortis - On Text 15 Over - Cast Drakuramas Teleport Script 03'),
+(28948,0,24,0,61,0,100,513,0,0,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Malmortis - On Text 15 Over - Despawn');
+
+DELETE FROM `creature_text` WHERE `CreatureID` = 28948 AND `GroupID`=15;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `comment`, `BroadcastTextId`) VALUES 
+(28948, 15, 0, "Farewell", 12, 0, 100, 2, 0, 0, "Malmortis say", 29440);
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_00_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_00_world.sql
new file mode 100644
index 00000000000..3b8ede9f947
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_00_world.sql
@@ -0,0 +1,5 @@
+-- 
+DELETE FROM `gameobject` WHERE `guid` IN (9266,9268) AND `id` IN (184072,184092);
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(9266, 184072, 530, 3523, 3741, 1, 1, 4671.726, 2512.325, 240.0145, 0.802851, 0, 0, 0.3907309, 0.920505, 120, 255, 1, 15354), -- 184072 (Area: 3741 - Difficulty: 0)
+(9268, 184092, 530, 3523, 3741, 1, 1, 4671.729, 2512.325, 242.9658, 2.600535, 0, 0, 0.9636297, 0.267241, 120, 255, 1, 15354); -- 184092 (Area: 3741 - Difficulty: 0)
diff --git a/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_01_world.sql b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_01_world.sql
new file mode 100644
index 00000000000..028604de7c8
--- /dev/null
+++ b/sql/old/3.3.5a/world/19101_2019_11_16/2019_11_14_01_world.sql
@@ -0,0 +1,7 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (117621) AND `id`=20114;
+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
+(117621, 20114, 530, 0, 0, 1, 1, 0, 0, 3923.06, 3873.36, 180.752, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340);
+
+UPDATE `creature_template_addon` SET `auras`="34840 34832" WHERE `entry`=20086;
+UPDATE `creature_template_addon` SET `auras`="34858 34832" WHERE `entry`=20114;