Skip to content

[Fix] Disables invasion connected obsolete quests #5285

Closed
Trista opened this Issue Feb 17, 2012 · 7 comments

3 participants

@Trista
Trista commented Feb 17, 2012

Wowiki quote: "This quest was part of the Scourge Invasion which was a world event in Patch 3.0.2 that heralded the release of Wrath of the Lich King. Once the event has run its course the quest will no longer be available." - reffers to first weeks of oppening WotLK.
Close this #5023 + expands to all factions related.
For more info check this http://www.wowwiki.com/Quest:Silvermoon -> Horde side and http://www.wowwiki.com/Quest%3AThe_Exodar for Alliance.
I made more research and turned out to be right, all npcs /the apothecaries/ connected with the quests under don't exist in game anymore, Grand Apothecary Putress exist as 1 lvl npc at Shattrah, the 1st quest start from commoners all over the world and ends at that npc, which gives the following quests listed under
-- Disabling obsolete quests to prevent giving next one that is not completeble

@kandera
kandera commented Feb 17, 2012

why not add them to the disabled list instead of deleting them?

@Trista
Trista commented Feb 17, 2012

Didn't know such thing exist since am noob at this and from previous request got no help :/. Feel free to do it, I just don't know how., sorry.
You mean this http://www.trinitycore.info/Disables_tc2?

@kandera
kandera commented Feb 17, 2012

yes


DELETE FROM `Disables` WHERE `sourceType` = 1 AND `entry` in (12788,12812,12785,12786,12787,12774,12776,12771,12809,12773);
INSERT INTO `Disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES
(1,12788,0,0,0,'Disable quest from Scourge Invasion for Blood Elves'),
(1,12812,0,0,0,'Disable quest from Scourge Invasion for Orcs'),
(1,12785,0,0,0,'Disable quest from Scourge Invasion for Trolls'),
(1,12786,0,0,0,'Disable quest from Scourge Invasion for Tauren'),
(1,12787,0,0,0,'Disable quest from Scourge Invasion for undead'),
(1,12774,0,0,0,'Disable quest from Scourge Invasion for Human'),
(1,12776,0,0,0,'Disable quest from Scourge Invasion for Draenei'),
(1,12771,0,0,0,'Disable quest from Scourge Invasion for Dwarves'),
(1,12809,0,0,0,'Disable quest from Scourge Invasion for Gnomes'),
(1,12773,0,0,0,'Disable quest from Scourge Invasion for Night Elves');
@Trista
Trista commented Feb 17, 2012

Thanks, a lot. I can add 1st part of the chain now. /PS: How the heck are the highlights done ^^/

-- Disables quest "Desperate Research" for all factions
DELETE FROM `Disables` WHERE `sourceType` = 1 AND `entry` in (12782,12783,12811,12784,12752,12775,12777,12753,12808,12772);
INSERT INTO `Disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES
(1,12782,0,0,0,'Disable quest from Scourge Invasion for Blood Elves'),
(1,12783,0,0,0,'Disable quest from Scourge Invasion for Orcs'),
(1,12811,0,0,0,'Disable quest from Scourge Invasion for Trolls'),
(1,12784,0,0,0,'Disable quest from Scourge Invasion for Tauren'),
(1,12752,0,0,0,'Disable quest from Scourge Invasion for undead'),
(1,12775,0,0,0,'Disable quest from Scourge Invasion for Human'),
(1,12777,0,0,0,'Disable quest from Scourge Invasion for Draenei'),
(1,12753,0,0,0,'Disable quest from Scourge Invasion for Dwarves'),
(1,12808,0,0,0,'Disable quest from Scourge Invasion for Gnomes'),
(1,12772,0,0,0,'Disable quest from Scourge Invasion for Night Elves');
@DDuarte
TrinityCore member
DDuarte commented Feb 18, 2012

@Trista, you mean syntax highlighting? You have to write your code around ```sql ...code... ```

@kandera
kandera commented Apr 13, 2012

any updates @Trista

@Trista
Trista commented Apr 13, 2012

@kandera, it was complete, it is what you've written and the add up below, but I didn't update first post, sorry. Here is a merged version:

-- Disables quest "Desperate Research" for all factions // 10x to kandera
DELETE FROM `disables` WHERE `sourceType` = 1 AND `entry` in (12782,12783,12811,12784,12752,12775,12777,12753,12808,12772);
INSERT INTO `disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES
(1,12782,0,0,0,'Disable quest from Scourge Invasion for Blood Elves'),
(1,12783,0,0,0,'Disable quest from Scourge Invasion for Orcs'),
(1,12811,0,0,0,'Disable quest from Scourge Invasion for Trolls'),
(1,12784,0,0,0,'Disable quest from Scourge Invasion for Tauren'),
(1,12752,0,0,0,'Disable quest from Scourge Invasion for undead'),
(1,12775,0,0,0,'Disable quest from Scourge Invasion for Human'),
(1,12777,0,0,0,'Disable quest from Scourge Invasion for Draenei'),
(1,12753,0,0,0,'Disable quest from Scourge Invasion for Dwarves'),
(1,12808,0,0,0,'Disable quest from Scourge Invasion for Gnomes'),
(1,12772,0,0,0,'Disable quest from Scourge Invasion for Night Elves');
-- Disables scourge invasion connected quests listed below
DELETE FROM `disables` WHERE `sourceType` = 1 AND `entry` in (12788,12812,12785,12786,12787,12774,12776,12771,12809,12773);
INSERT INTO `disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES
(1,12788,0,0,0,'Disable quest from Scourge Invasion for Blood Elves'),
(1,12812,0,0,0,'Disable quest from Scourge Invasion for Orcs'),
(1,12785,0,0,0,'Disable quest from Scourge Invasion for Trolls'),
(1,12786,0,0,0,'Disable quest from Scourge Invasion for Tauren'),
(1,12787,0,0,0,'Disable quest from Scourge Invasion for undead'),
(1,12774,0,0,0,'Disable quest from Scourge Invasion for Human'),
(1,12776,0,0,0,'Disable quest from Scourge Invasion for Draenei'),
(1,12771,0,0,0,'Disable quest from Scourge Invasion for Dwarves'),
(1,12809,0,0,0,'Disable quest from Scourge Invasion for Gnomes'),
(1,12773,0,0,0,'Disable quest from Scourge Invasion for Night Elves');
@kandera kandera was assigned Apr 23, 2012
@kandera kandera added a commit that closed this issue May 10, 2012
@kandera kandera DB/Misc: various fixes from the issue tracker.
	Remove obsolete requirement 'cooking profession' from quest 'Beer Basted Boar Ribs' (thx tifkat) closes #5198
	Fix proc for Death's Verdict/Choice (author: kandera) closes #6041
	Disables quest "Desperate Research" for all factions author trista closes #5285
	Disables scourge invasion connected quests
	Limit Bloodgem Shard use to Netherstorm Cristal Target author: nelegalno closes #4165
	Path of xx and A Change of Heart (Ashen Band rings) author: studioworks closes #2544
	spawn farmer torp author: zxbiohazardzx closes #6256
	Disgusting Oozeling aura author: gecko32 closes #6197
	Mr. Chilly Add aura chilly for Periodic slide
	Update to Change <name> to $n in page text author: gecko32 closes #5930
	Update frost shock and you to only be for shamans. author: whit33r closes #4727
	fixes ashen band of destruction proc author: kandera
	fixes quest credit from Fel reaver no thanks! author: tREAk & shlomi1515 closes #3715
	fix areatrigger for wickerman camp author: boomper closes #3549
	yous have da darkrune should be daily author: kaelima closes #3457
	fix infinite corruptor loot id author: vincent-michael
62b1d4b
@kandera kandera closed this in 62b1d4b May 10, 2012
@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
@kandera kandera DB/Misc: various fixes from the issue tracker.
	Remove obsolete requirement 'cooking profession' from quest 'Beer Basted Boar Ribs' (thx tifkat) closes #5198
	Fix proc for Death's Verdict/Choice (author: kandera) closes #6041
	Disables quest "Desperate Research" for all factions author trista closes #5285
	Disables scourge invasion connected quests
	Limit Bloodgem Shard use to Netherstorm Cristal Target author: nelegalno closes #4165
	Path of xx and A Change of Heart (Ashen Band rings) author: studioworks closes #2544
	spawn farmer torp author: zxbiohazardzx closes #6256
	Disgusting Oozeling aura author: gecko32 closes #6197
	Mr. Chilly Add aura chilly for Periodic slide
	Update to Change <name> to $n in page text author: gecko32 closes #5930
	Update frost shock and you to only be for shamans. author: whit33r closes #4727
	fixes ashen band of destruction proc author: kandera
	fixes quest credit from Fel reaver no thanks! author: tREAk & shlomi1515 closes #3715
	fix areatrigger for wickerman camp author: boomper closes #3549
	yous have da darkrune should be daily author: kaelima closes #3457
	fix infinite corruptor loot id author: vincent-michael
79e66a0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.