diff options
| -rw-r--r-- | sql/updates/world/master/2017_01_25_00_world.sql | 71 |
1 files changed, 71 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_25_00_world.sql b/sql/updates/world/master/2017_01_25_00_world.sql new file mode 100644 index 00000000000..f2e8b8c906a --- /dev/null +++ b/sql/updates/world/master/2017_01_25_00_world.sql @@ -0,0 +1,71 @@ +-- Quests and quest givers removed in patch 7.0.3 +-- Blood elf starting area (Sunstrider Isle) + +-- The following NPCs are no longer quest givers: +UPDATE `creature_template` SET `npcflag` = `npcflag`& ~2 WHERE `entry` IN +(15279, -- Julia Sunstriker <Mage Trainer> + 15280, -- Jesthenis Sunstriker <Paladin Trainer> + 15283, -- Summoner Teli'Larien <Warlock Trainer> + 15284, -- Matron Arena <Priest Trainer> + 15285, -- Pathstalker Kariel <Rogue Trainer> + 15513, -- Ranger Sallina <Hunter Trainer> + 43010, -- Delios Silverblade <Warrior Trainer> + 63332); -- Pao <Monk Trainer> + +-- Magistrix Erona (15278) no longer starts these quests: +DELETE FROM `creature_queststarter` WHERE `id`= 15278 AND `quest` IN +(8328, -- Quest:Mage Training + 8329, -- Quest:Warrior Training + 8563, -- Quest:Warlock Training + 8564, -- Quest:Priest Training + 9392, -- Quest:Rogue Training + 9393, -- Quest:Hunter Training + 9676); -- Quest:Paladin Training + +-- These NPCs no longer start the following obsolete quests: +DELETE FROM `creature_queststarter` WHERE `id`= 15279 AND `quest`= 10068; -- Julia Sunstriker <Mage Trainer>, Quest:Frost Nova +DELETE FROM `creature_queststarter` WHERE `id`= 15280 AND `quest`= 10069; -- Jesthenis Sunstriker <Paladin Trainer>, Quest:Ways of the Light +DELETE FROM `creature_queststarter` WHERE `id`= 15283 AND `quest`= 10073; -- Summoner Teli'Larien <Warlock Trainer>, Quest:Curruption +DELETE FROM `creature_queststarter` WHERE `id`= 15284 AND `quest`= 10072; -- Matron Arena <Priest Trainer>, Quest:Learning the Word +DELETE FROM `creature_queststarter` WHERE `id`= 15285 AND `quest`= 10071; -- Pathstalker Kariel <Rogue Trainer>, Quest:Evisceration +DELETE FROM `creature_queststarter` WHERE `id`= 15513 AND `quest`= 10070; -- Ranger Sallina <Hunter Trainer>, Quest:Steady Shot +DELETE FROM `creature_queststarter` WHERE `id`= 43010 AND `quest`= 27091; -- Delios Silverblade <Warrior Trainer>, Quest:Charge +DELETE FROM `creature_queststarter` WHERE `id`= 63332 AND `quest`= 31171; -- Pao <Monk Trainer>, Quest:Tiger Palm + +-- Well Watcher Solanian (15295) also gives these 2 extra quest IDs for existing quests 8330, 8345: +DELETE FROM `creature_queststarter` WHERE `id`= 15295 AND `quest` IN (37442,37443); +INSERT INTO `creature_queststarter` (`id`,`quest`) VALUES +(15295, 37442), -- The Shrine of Dath'Remar (also 8345) +(15295, 37443); -- Solanian's Belongings (also 8330) + +-- These NPCs no longer end the following obsolete quests: +DELETE FROM `creature_questender` WHERE `id`= 15279 AND `quest` IN (8328,10068); -- Julia Sunstriker <Mage Trainer>, Quest:Mage Training & Frost Nova +DELETE FROM `creature_questender` WHERE `id`= 15280 AND `quest` IN (9676,10069); -- Jesthenis Sunstriker <Paladin Trainer>, Quest:Paladin Training & Ways of the Light +DELETE FROM `creature_questender` WHERE `id`= 15283 AND `quest` IN (8344,8563,10073); -- Summoner Teli'Larien <Warlock Trainer>, Quests:Windows to the Source,Warlock Training,Curruption +DELETE FROM `creature_questender` WHERE `id`= 15284 AND `quest` IN (8564,10072); -- Matron Arena <Priest Trainer>, Quest:Priest Training & Learning the Word +DELETE FROM `creature_questender` WHERE `id`= 15285 AND `quest` IN (9392,10071); -- Pathstalker Kariel <Rogue Trainer>, Quest:Rogue Training & Evisceration +DELETE FROM `creature_questender` WHERE `id`= 15513 AND `quest` IN (9393,10070); -- Ranger Sallina <Hunter Trainer>, Quest:Hunter Training & Steady Shot +DELETE FROM `creature_questender` WHERE `id`= 43010 AND `quest` IN (8329, 27091); -- Delios Silverblade <Warrior Trainer>, Quest:Warrior Training & Charge +DELETE FROM `creature_questender` WHERE `id`= 63332 AND `quest` IN (31170, 31171); -- Pao <Monk Trainer>, Quest:Monk Training & Tiger Palm + +-- These quests are obsolete and need to be disabled: +DELETE FROM `disables` WHERE `sourceType`= 1 AND `entry` IN (8328,8329,8344,8563,8564,9392,9393,9676,10068,10069,10070,10071,10072,10073,27091,31170,31171,37441); +INSERT INTO `disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES +(1, 8328, 0, '', '', 'Obsolete quest: Mage Training'), +(1, 8329, 0, '', '', 'Obsolete quest: Warrior Training'), +(1, 8344, 0, '', '', 'Obsolete quest: Windows to the Source'), +(1, 8563, 0, '', '', 'Obsolete quest: Warlock Training'), +(1, 8564, 0, '', '', 'Obsolete quest: Priest Training'), +(1, 9392, 0, '', '', 'Obsolete quest: Rogue Training'), +(1, 9393, 0, '', '', 'Obsolete quest: Hunter Training'), +(1, 9676, 0, '', '', 'Obsolete quest: Paladin Training'), +(1, 10068, 0, '', '', 'Obsolete quest: Frost Nova'), +(1, 10069, 0, '', '', 'Obsolete quest: Ways of the Light'), +(1, 10070, 0, '', '', 'Obsolete quest: Steady Shot'), +(1, 10071, 0, '', '', 'Obsolete quest: Evisceration'), +(1, 10072, 0, '', '', 'Obsolete quest: Learning the Word'), +(1, 10073, 0, '', '', 'Obsolete quest: Curruption'), +(1, 27091, 0, '', '', 'Obsolete quest: Charge'), +(1, 31170, 0, '', '', 'Obsolete quest: Monk Training'), +(1, 31171, 0, '', '', 'Obsolete quest: Tiger Palm'), +(1, 37441, 0, '', '', 'Obsolete quest: Solanian\'s Belongings'); -- Replaced by Quest ID 37443 |