Trinitycore: DB/Quests: Night Elf starting zone quest chain is broken
Description:
In the starting zone of Night Elfs, Shadowglen, the initial quest chain is broken. The only quest you have to do is 26947 "A woodsman麓s training" that it was deprecated.
Current behaviour:
You eventualy has one quest in quest list, 26947, that its deprecated.
Expected behaviour:
You should have another quest series like in wowhead http://www.wowhead.com/teldrassil#quests
Steps to reproduce the problem:
- Create a Night Elf (i tested with a Hunter)
- Start quest chain until you have only 26947
Branch(es): master
TC rev. hash/commit: 777d839a5fda0d09c9f5340ac0942187f10e211e
TDB version: 720.00 + updates
Operating system: Windows 10
HannibalRoG
All 22 comments
Specifically, the chain now is:
- [The balance of nature]
In this moment Ilthalaine [id 2069] also offer you [Etched sigil] Not in wowhead, and also now you can obtain [A woodsman's Training] from Ayanna Evertride [id 3596] deprecated.
- [Fel Moss Corruption]
- [A Favor for Melithar] and
- [Demonic Thieves]
Once you complete this quest the chain is broken.
I think you can obtain this quest chain after that http://www.wowhead.com/quest=28723/priestess-of-the-moon
Some sniffer bring more lights.
HannibalRoG
on 16 Jun 2017
@HannibalRoG
This is my Fix for my DB , Ran a Hunter,Priest,Mage and Druid thru retail wrote all quest and npc ID's.
Fixed Quests Chains.Found the error , he was queststarter and finsher for quest 28723
-- Night Elf Startarea Shadow Glen Legion
-- By Taaboy
-- Fix Quest Starters ShadowGlen Legion
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=3116;
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=3117;
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=3118;
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=3119;
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=3120;
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=26841;
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=28713;
INSERT INTO `creature_queststarter` VALUES (2079, 28713);
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=28714;
INSERT INTO `creature_queststarter` VALUES (2079, 28714);
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=28723;
INSERT INTO `creature_queststarter` VALUES (2079, 28723);
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`=28734;
INSERT INTO `creature_queststarter` VALUES (2079, 28734);
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`=3116;
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`=3117;
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`=3118;
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`=3119;
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`=3120;
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`=26841;
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`=28715;
INSERT INTO `creature_queststarter` VALUES (2077, 28715);
DELETE FROM `creature_queststarter` WHERE `id`=45006 AND `quest`=26940;
DELETE FROM `creature_queststarter` WHERE `id`=3593 AND `quest`=26945;
DELETE FROM `creature_queststarter` WHERE `id`=3594 AND `quest`=26946;
DELETE FROM `creature_queststarter` WHERE `id`=3596 AND `quest`=26947;
DELETE FROM `creature_queststarter` WHERE `id`=3597 AND `quest`=26948;
DELETE FROM `creature_queststarter` WHERE `id`=3595 AND `quest`=26949;
DELETE FROM `creature_queststarter` WHERE `id`=3593 AND `quest`=28723;
DELETE FROM `creature_queststarter` WHERE `id`=3594 AND `quest`=28723;
DELETE FROM `creature_queststarter` WHERE `id`=3595 AND `quest`=28723;
DELETE FROM `creature_queststarter` WHERE `id`=3596 AND `quest`=28723;
DELETE FROM `creature_queststarter` WHERE `id`=3597 AND `quest`=28723;
DELETE FROM `creature_queststarter` WHERE `id`=43006 AND `quest`=28723;
-- Fix Quest Enders ShadowGlen Legion
DELETE FROM `creature_questender` WHERE `id`=2079 AND `quest`=456;
DELETE FROM `creature_questender` WHERE `id`=2079 AND `quest`=457;
DELETE FROM `creature_questender` WHERE `id`=2079 AND `quest`=28713;
INSERT INTO `creature_questender` VALUES (2079, 28713);
DELETE FROM `creature_questender` WHERE `id`=2079 AND `quest`=28714;
INSERT INTO `creature_questender` VALUES (2079, 28714);
DELETE FROM `creature_questender` WHERE `id`=2079 AND `quest`=28723;
DELETE FROM `creature_questender` WHERE `id`=3514 AND `quest`=920;
DELETE FROM `creature_questender` WHERE `id`=3514 AND `quest`=921;
DELETE FROM `creature_questender` WHERE `id`=3514 AND `quest`=28730;
INSERT INTO `creature_questender` VALUES (3514, 28730);
DELETE FROM `creature_questender` WHERE `id`=3593 AND `quest`=3116;
DELETE FROM `creature_questender` WHERE `id`=3593 AND `quest`=26945;
DELETE FROM `creature_questender` WHERE `id`=3594 AND `quest`=3118;
DELETE FROM `creature_questender` WHERE `id`=3594 AND `quest`=26946;
DELETE FROM `creature_questender` WHERE `id`=3595 AND `quest`=3119;
DELETE FROM `creature_questender` WHERE `id`=3595 AND `quest`=26949;
DELETE FROM `creature_questender` WHERE `id`=3596 AND `quest`=3117;
DELETE FROM `creature_questender` WHERE `id`=3596 AND `quest`=26947;
DELETE FROM `creature_questender` WHERE `id`=3597 AND `quest`=3120;
DELETE FROM `creature_questender` WHERE `id`=3597 AND `quest`=26948;
-- Fix Quest Template Legion
DELETE FROM `quest_template` WHERE `ID`=28713;
INSERT INTO `quest_template` VALUES (28713, 2, 2, 9614, 1, 188, 0, 0, 28714, 5, 1, 35, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 524288, 512, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69, 5, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 1, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, -1, 0, 0, 'The Balance of Nature', 'Kill 6 Young Nightsabers.', 'Greetings, $n. I am Ilthalaine. My purpose in Shadowglen is to train young $cs like you and to ensure that the balance of nature is maintained.$b$bThe spring rains were particularly heavy this year, causing some of the forest\'s beasts to flourish while others suffered. Unfortunately, the nightsaber numbers grew too large, and they will devastate the other populations if they are not culled.$B$BJourney forth, young $c, and thin saber populations so that nature\'s harmony will be preserved.', '', '', '', '', '', '', 23911);
DELETE FROM `quest_template` WHERE `ID`=28714;
INSERT INTO `quest_template` VALUES (28714, 2, 3, 600, 1, 188, 0, 0, 28723, 5, 1, 50, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 524288, 0, 961, 3, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69, 5, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 1, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 2147483647, 0, 0, 'Fel Moss Corruption', 'Collect 6 Fel Moss from the grellkin to the west of Ilthalaine.', 'You seem to know what you\'re doing. Perhaps I can task you with something a little more important.$B$BAs you may well know, the corruption in Teldrassil was supposedly wiped away. Yet something lingers. The creatures have not calmed and all manner of problems still plague us.$B$BI need you to deal with the grellkin that have gathered to the west, and while you\'re there, I want you to search them for fel moss. This will help me determine from where this continuing corruption stems.', '', '', '', '', '', '', 23911);
DELETE FROM `quest_template` WHERE `ID`=28734;
INSERT INTO `quest_template` VALUES (28734, 2, 3, 0, 1, 188, 0, 0, 28715, 1, 1, 5, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 524288, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69, 1, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 52430847, 0, 0, 'A Favor for Melithar', 'Speak to Melithar Staghelm in Shadowglen.', 'You should speak with Melithar. I believe he had some troubles with the grell already.$B$BI expect he can offer you a well needed place to store more of your goods should you aid him.', '', '', '', '', '', '', 23911);
-- Fix Quest Template Addon Legion
DELETE FROM `quest_template_addon` WHERE `ID`=28714;
INSERT INTO `quest_template_addon` VALUES (28714, 0, 0, 0, 28713, 28723, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
DELETE FROM `quest_template_addon` WHERE `ID`=28734;
INSERT INTO `quest_template_addon` VALUES (28734, 0, 0, 0, 28713, 28715, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
DELETE FROM `quest_template_addon` WHERE `ID`=2519;
INSERT INTO `quest_template_addon` VALUES (2519, 0, 0, 0, 28730, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- Obselete Quests Shadow Glen Deletion Legion
DELETE FROM `quest_template` WHERE `ID`=26949;
DELETE FROM `quest_template` WHERE `ID`=3116;
DELETE FROM `quest_template` WHERE `ID`=3117;
DELETE FROM `quest_template` WHERE `ID`=3118;
DELETE FROM `quest_template` WHERE `ID`=3119;
DELETE FROM `quest_template` WHERE `ID`=3120;
DELETE FROM `quest_template` WHERE `ID`=26940;
DELETE FROM `quest_template` WHERE `ID`=26945;
DELETE FROM `quest_template` WHERE `ID`=26946;
DELETE FROM `quest_template` WHERE `ID`=26947;
DELETE FROM `quest_template` WHERE `ID`=26948;
-- Obselete Quest addons Shadow Glen Legion
DELETE FROM `quest_template_addon` WHERE `ID`=26940;
DELETE FROM `quest_template_addon` WHERE `ID`=26945;
DELETE FROM `quest_template_addon` WHERE `ID`=26946;
DELETE FROM `quest_template_addon` WHERE `ID`=26947;
DELETE FROM `quest_template_addon` WHERE `ID`=26948;
DELETE FROM `quest_template_addon` WHERE `ID`=26949;
DELETE FROM `quest_template_addon` WHERE `ID`=3116;
DELETE FROM `quest_template_addon` WHERE `ID`=3117;
DELETE FROM `quest_template_addon` WHERE `ID`=3118;
DELETE FROM `quest_template_addon` WHERE `ID`=3119;
DELETE FROM `quest_template_addon` WHERE `ID`=3120;
Taaboy
on 18 Jun 2017
@Taaboy : there is room for improvement in your SQL. Allow me to suggest this format:
-- Shadowglen quest starters
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`IN (3116,3117,3118,3119,3120,26841,28715);
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`IN (3116,3117,3118,3119,3120,26841,28713,28714,28723,28734);
INSERT INTO `creature_queststarter` (`id`,`quest`) VALUES
(2077, 28715),
(2079, 28713),
(2079, 28714),
(2079, 28723),
(2079, 28734);
DELETE FROM `creature_queststarter` WHERE `id`= 3593 AND `quest` = 26945;
DELETE FROM `creature_queststarter` WHERE `id`= 3594 AND `quest` = 26946;
DELETE FROM `creature_queststarter` WHERE `id`= 3595 AND `quest` = 26949;
DELETE FROM `creature_queststarter` WHERE `id`= 3596 AND `quest` = 26947;
DELETE FROM `creature_queststarter` WHERE `id`= 3597 AND `quest` = 26948;
DELETE FROM `creature_queststarter` WHERE `id`=45006 AND `quest` = 26940;
DELETE FROM `creature_queststarter` WHERE `quest` = 28723 AND `id` IN (3593,3594,3595,3596,3597,43006);
-- Shadowglen quest enders
DELETE FROM `creature_questender` WHERE `id`=2079 AND `quest` IN (456,457,28713,28714,28723);
DELETE FROM `creature_questender` WHERE `id`=3514 AND `quest` IN (920,921,28730);
DELETE FROM `creature_questender` WHERE `id`=3593 AND `quest` IN (3116, 26945);
DELETE FROM `creature_questender` WHERE `id`=3594 AND `quest` IN (3118, 26946);
DELETE FROM `creature_questender` WHERE `id`=3595 AND `quest` IN (3119, 26949);
DELETE FROM `creature_questender` WHERE `id`=3596 AND `quest` IN (3117, 26947);
DELETE FROM `creature_questender` WHERE `id`=3597 AND `quest` IN (3120, 26948);
INSERT INTO `creature_questender` (`id`,`quest`) VALUES
(2079, 28713),
(2079, 28714),
(2079, 28723),
(3514, 28730);
-- Quest Template
DELETE FROM `quest_template` WHERE `ID` IN (28713,28714,28734);
INSERT INTO `quest_template` (`ID`,`QuestType`,`QuestLevel`,`QuestPackageID`,`MinLevel`,`QuestSortID`,`QuestInfoID`,`SuggestedGroupNum`,`RewardNextQuest`,`RewardXPDifficulty`,`RewardXPMultiplier`,`RewardMoney`,`RewardMoneyDifficulty`,`RewardMoneyMultiplier`,`RewardBonusMoney`,`RewardDisplaySpell1`,`RewardDisplaySpell2`,`RewardDisplaySpell3`,`RewardSpell`,`RewardHonor`,`RewardKillHonor`,`StartItem`,`RewardArtifactXPDifficulty`,`RewardArtifactXPMultiplier`,`RewardArtifactCategoryID`,`Flags`,`FlagsEx`,`RewardSkillLineID`,`RewardNumSkillUps`,`PortraitGiver`,`PortraitTurnIn`,`RewardItem1`,`RewardItem2`,`RewardItem3`,`RewardItem4`,`RewardAmount1`,`RewardAmount2`,`RewardAmount3`,`RewardAmount4`,`ItemDrop1`,`ItemDrop2`,`ItemDrop3`,`ItemDrop4`,`ItemDropQuantity1`,`ItemDropQuantity2`,`ItemDropQuantity3`,`ItemDropQuantity4`,`RewardChoiceItemID1`,`RewardChoiceItemID2`,`RewardChoiceItemID3`,`RewardChoiceItemID4`,`RewardChoiceItemID5`,`RewardChoiceItemID6`,`RewardChoiceItemQuantity1`,`RewardChoiceItemQuantity2`,`RewardChoiceItemQuantity3`,`RewardChoiceItemQuantity4`,`RewardChoiceItemQuantity5`,`RewardChoiceItemQuantity6`,`RewardChoiceItemDisplayID1`,`RewardChoiceItemDisplayID2`,`RewardChoiceItemDisplayID3`,`RewardChoiceItemDisplayID4`,`RewardChoiceItemDisplayID5`,`RewardChoiceItemDisplayID6`,`POIContinent`,`POIx`,`POIy`,`POIPriority`,`RewardTitle`,`RewardArenaPoints`,`RewardFactionID1`,`RewardFactionID2`,`RewardFactionID3`,`RewardFactionID4`,`RewardFactionID5`,`RewardFactionValue1`,`RewardFactionValue2`,`RewardFactionValue3`,`RewardFactionValue4`,`RewardFactionValue5`,`RewardFactionCapIn1`,`RewardFactionCapIn2`,`RewardFactionCapIn3`,`RewardFactionCapIn4`,`RewardFactionCapIn5`,`RewardFactionOverride1`,`RewardFactionOverride2`,`RewardFactionOverride3`,`RewardFactionOverride4`,`RewardFactionOverride5`,`RewardFactionFlags`,`AreaGroupID`,`TimeAllowed`,`AllowableRaces`,`QuestRewardID`,`Expansion`,`LogTitle`,`LogDescription`,`QuestDescription`,`AreaDescription`,`QuestCompletionLog`,`RewardCurrencyID1`,`RewardCurrencyID2`,`RewardCurrencyID3`,`RewardCurrencyID4`,`RewardCurrencyQty1`,`RewardCurrencyQty2`,`RewardCurrencyQty3`,`RewardCurrencyQty4`,`PortraitGiverText`,`PortraitGiverName`,`PortraitTurnInText`,`PortraitTurnInName`,`AcceptedSoundKitID`,`CompleteSoundKitID`,`VerifiedBuild`) VALUES
(28713, 2, 2, 9614, 1, 188, 0,0, 28714, 5, 1, 35, 5, 1, 0,0,0,0,0,0,0,0,0, 1, 0, 524288, 512, 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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 69, 5, 0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 1,0,0,0,0,0,0,0,0, 890, 878, 0,0, -1, 0,0, 'The Balance of Nature', 'Kill 6 Young Nightsabers.', 'Greetings, $n. I am Ilthalaine. My purpose in Shadowglen is to train young $cs like you and to ensure that the balance of nature is maintained.$b$bThe spring rains were particularly heavy this year, causing some of the forest\'s beasts to flourish while others suffered. Unfortunately, the nightsaber numbers grew too large, and they will devastate the other populations if they are not culled.$B$BJourney forth, young $c, and thin saber populations so that nature\'s harmony will be preserved.', '', '', '', '', '', '', 23911),
(28714, 2, 3, 600, 1, 188, 0,0, 28723, 5, 1, 50, 5, 1, 0,0,0,0,0,0,0,0,0, 1, 0, 524288, 0, 961,3,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 69, 5, 0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 1,0,0,0,0,0,0,0,0, 890, 878, 0,0, 2147483647, 0,0, 'Fel Moss Corruption', 'Collect 6 Fel Moss from the grellkin to the west of Ilthalaine.', 'You seem to know what you\'re doing. Perhaps I can task you with something a little more important.$B$BAs you may well know, the corruption in Teldrassil was supposedly wiped away. Yet something lingers. The creatures have not calmed and all manner of problems still plague us.$B$BI need you to deal with the grellkin that have gathered to the west, and while you\'re there, I want you to search them for fel moss. This will help me determine from where this continuing corruption stems.', '', '', '', '', '', '', 23911),
(28734, 2, 3, 0, 1, 188, 0,0, 28715, 1, 1, 5, 1, 1, 0,0,0,0,0,0,0,0,0, 1, 0, 524288, 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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 69, 1, 0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0,0,0,0,0,0,0, 890, 878, 0,0, 52430847, 0,0, 'A Favor for Melithar', 'Speak to Melithar Staghelm in Shadowglen.', 'You should speak with Melithar. I believe he had some troubles with the grell already.$B$BI expect he can offer you a well needed place to store more of your goods should you aid him.', '', '', '', '', '', '', 23911);
-- Quest Template Addon
DELETE FROM `quest_template_addon` WHERE `ID` IN (2519,28714,28734);
INSERT INTO `quest_template_addon` VALUES
( 2519, 0,0,0, 28730, 0, 0,0,0,0,0,0,0,0,0,0,0),
(28714, 0,0,0, 28713, 28723, 0,0,0,0,0,0,0,0,0,0,0),
(28734, 0,0,0, 28713, 28715, 0,0,0,0,0,0,0,0,0,0,0);
-- obsolete quests in Shadowglen
DELETE FROM `quest_template` WHERE `ID` IN (3116,3117,3118,3119,3120,26940,26945,26946,26947,26948,26949);
DELETE FROM `quest_template_addon` WHERE `ID` IN (3116,3117,3118,3119,3120,26940,26945,26946,26947,26948,26949);
(reducing your 114 lines to 50 as well as grouping identical values)
Also notice that I have added the column names for INSERT INTO queries as part of the TC SQL codestyle.
(edit) Please also note that TC normally adds obsolete quests to the table disables as Deprecated quest entries instead of deleting them.
ghost
on 18 Jun 2017
@tkrokli
INSERT INTO `creature_questender` (`id`,`quest`) VALUES
(2079, 28713),
(2079, 28714),
(2079, 28723),
(3514, 28730);
2079,28723 was the problem, but everything looks great Thank you
INSERT INTO `creature_questender` (`id`,`quest`) VALUES
(2079, 28713),
(2079, 28714),
(3514, 28730);
Thanks to tkrokli for his cleanup of my crappy sql , 1 minor fix and this below works great and quest chains work, for Night Elf Start Area ShadowGlen.
-- Shadowglen quest starters
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`IN (3116,3117,3118,3119,3120,26841,28715);
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`IN (3116,3117,3118,3119,3120,26841,28713,28714,28723,28734);
INSERT INTO `creature_queststarter` (`id`,`quest`) VALUES
(2077, 28715),
(2079, 28713),
(2079, 28714),
(2079, 28723),
(2079, 28734);
DELETE FROM `creature_queststarter` WHERE `id`= 3593 AND `quest` = 26945;
DELETE FROM `creature_queststarter` WHERE `id`= 3594 AND `quest` = 26946;
DELETE FROM `creature_queststarter` WHERE `id`= 3595 AND `quest` = 26949;
DELETE FROM `creature_queststarter` WHERE `id`= 3596 AND `quest` = 26947;
DELETE FROM `creature_queststarter` WHERE `id`= 3597 AND `quest` = 26948;
DELETE FROM `creature_queststarter` WHERE `id`=45006 AND `quest` = 26940;
DELETE FROM `creature_queststarter` WHERE `quest` = 28723 AND `id` IN (3593,3594,3595,3596,3597,43006);
-- Shadowglen quest enders
DELETE FROM `creature_questender` WHERE `id`=2079 AND `quest` IN (456,457,28713,28714,28723);
DELETE FROM `creature_questender` WHERE `id`=3514 AND `quest` IN (920,921,28730);
DELETE FROM `creature_questender` WHERE `id`=3593 AND `quest` IN (3116, 26945);
DELETE FROM `creature_questender` WHERE `id`=3594 AND `quest` IN (3118, 26946);
DELETE FROM `creature_questender` WHERE `id`=3595 AND `quest` IN (3119, 26949);
DELETE FROM `creature_questender` WHERE `id`=3596 AND `quest` IN (3117, 26947);
DELETE FROM `creature_questender` WHERE `id`=3597 AND `quest` IN (3120, 26948);
INSERT INTO `creature_questender` (`id`,`quest`) VALUES
(2079, 28713),
(2079, 28714),
(3514, 28730);
-- Quest Template
DELETE FROM `quest_template` WHERE `ID` IN (28713,28714,28734);
INSERT INTO `quest_template` (`ID`,`QuestType`,`QuestLevel`,`QuestPackageID`,`MinLevel`,`QuestSortID`,`QuestInfoID`,`SuggestedGroupNum`,`RewardNextQuest`,`RewardXPDifficulty`,`RewardXPMultiplier`,`RewardMoney`,`RewardMoneyDifficulty`,`RewardMoneyMultiplier`,`RewardBonusMoney`,`RewardDisplaySpell1`,`RewardDisplaySpell2`,`RewardDisplaySpell3`,`RewardSpell`,`RewardHonor`,`RewardKillHonor`,`StartItem`,`RewardArtifactXPDifficulty`,`RewardArtifactXPMultiplier`,`RewardArtifactCategoryID`,`Flags`,`FlagsEx`,`RewardSkillLineID`,`RewardNumSkillUps`,`PortraitGiver`,`PortraitTurnIn`,`RewardItem1`,`RewardItem2`,`RewardItem3`,`RewardItem4`,`RewardAmount1`,`RewardAmount2`,`RewardAmount3`,`RewardAmount4`,`ItemDrop1`,`ItemDrop2`,`ItemDrop3`,`ItemDrop4`,`ItemDropQuantity1`,`ItemDropQuantity2`,`ItemDropQuantity3`,`ItemDropQuantity4`,`RewardChoiceItemID1`,`RewardChoiceItemID2`,`RewardChoiceItemID3`,`RewardChoiceItemID4`,`RewardChoiceItemID5`,`RewardChoiceItemID6`,`RewardChoiceItemQuantity1`,`RewardChoiceItemQuantity2`,`RewardChoiceItemQuantity3`,`RewardChoiceItemQuantity4`,`RewardChoiceItemQuantity5`,`RewardChoiceItemQuantity6`,`RewardChoiceItemDisplayID1`,`RewardChoiceItemDisplayID2`,`RewardChoiceItemDisplayID3`,`RewardChoiceItemDisplayID4`,`RewardChoiceItemDisplayID5`,`RewardChoiceItemDisplayID6`,`POIContinent`,`POIx`,`POIy`,`POIPriority`,`RewardTitle`,`RewardArenaPoints`,`RewardFactionID1`,`RewardFactionID2`,`RewardFactionID3`,`RewardFactionID4`,`RewardFactionID5`,`RewardFactionValue1`,`RewardFactionValue2`,`RewardFactionValue3`,`RewardFactionValue4`,`RewardFactionValue5`,`RewardFactionCapIn1`,`RewardFactionCapIn2`,`RewardFactionCapIn3`,`RewardFactionCapIn4`,`RewardFactionCapIn5`,`RewardFactionOverride1`,`RewardFactionOverride2`,`RewardFactionOverride3`,`RewardFactionOverride4`,`RewardFactionOverride5`,`RewardFactionFlags`,`AreaGroupID`,`TimeAllowed`,`AllowableRaces`,`QuestRewardID`,`Expansion`,`LogTitle`,`LogDescription`,`QuestDescription`,`AreaDescription`,`QuestCompletionLog`,`RewardCurrencyID1`,`RewardCurrencyID2`,`RewardCurrencyID3`,`RewardCurrencyID4`,`RewardCurrencyQty1`,`RewardCurrencyQty2`,`RewardCurrencyQty3`,`RewardCurrencyQty4`,`PortraitGiverText`,`PortraitGiverName`,`PortraitTurnInText`,`PortraitTurnInName`,`AcceptedSoundKitID`,`CompleteSoundKitID`,`VerifiedBuild`) VALUES
(28713, 2, 2, 9614, 1, 188, 0,0, 28714, 5, 1, 35, 5, 1, 0,0,0,0,0,0,0,0,0, 1, 0, 524288, 512, 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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 69, 5, 0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 1,0,0,0,0,0,0,0,0, 890, 878, 0,0, -1, 0,0, 'The Balance of Nature', 'Kill 6 Young Nightsabers.', 'Greetings, $n. I am Ilthalaine. My purpose in Shadowglen is to train young $cs like you and to ensure that the balance of nature is maintained.$b$bThe spring rains were particularly heavy this year, causing some of the forest\'s beasts to flourish while others suffered. Unfortunately, the nightsaber numbers grew too large, and they will devastate the other populations if they are not culled.$B$BJourney forth, young $c, and thin saber populations so that nature\'s harmony will be preserved.', '', '', '', '', '', '', 23911),
(28714, 2, 3, 600, 1, 188, 0,0, 28723, 5, 1, 50, 5, 1, 0,0,0,0,0,0,0,0,0, 1, 0, 524288, 0, 961,3,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 69, 5, 0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 1,0,0,0,0,0,0,0,0, 890, 878, 0,0, 2147483647, 0,0, 'Fel Moss Corruption', 'Collect 6 Fel Moss from the grellkin to the west of Ilthalaine.', 'You seem to know what you\'re doing. Perhaps I can task you with something a little more important.$B$BAs you may well know, the corruption in Teldrassil was supposedly wiped away. Yet something lingers. The creatures have not calmed and all manner of problems still plague us.$B$BI need you to deal with the grellkin that have gathered to the west, and while you\'re there, I want you to search them for fel moss. This will help me determine from where this continuing corruption stems.', '', '', '', '', '', '', 23911),
(28734, 2, 3, 0, 1, 188, 0,0, 28715, 1, 1, 5, 1, 1, 0,0,0,0,0,0,0,0,0, 1, 0, 524288, 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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 69, 1, 0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0, 7, 0,0,0,0,0,0,0,0,0, 890, 878, 0,0, 52430847, 0,0, 'A Favor for Melithar', 'Speak to Melithar Staghelm in Shadowglen.', 'You should speak with Melithar. I believe he had some troubles with the grell already.$B$BI expect he can offer you a well needed place to store more of your goods should you aid him.', '', '', '', '', '', '', 23911);
-- Quest Template Addon
DELETE FROM `quest_template_addon` WHERE `ID` IN (2519,28714,28734);
INSERT INTO `quest_template_addon` VALUES
( 2519, 0,0,0, 28730, 0, 0,0,0,0,0,0,0,0,0,0,0),
(28714, 0,0,0, 28713, 28723, 0,0,0,0,0,0,0,0,0,0,0),
(28734, 0,0,0, 28713, 28715, 0,0,0,0,0,0,0,0,0,0,0);
-- obsolete quests in Shadowglen
DELETE FROM `quest_template` WHERE `ID` IN (3116,3117,3118,3119,3120,26940,26945,26946,26947,26948,26949);
DELETE FROM `quest_template_addon` WHERE `ID` IN (3116,3117,3118,3119,3120,26940,26945,26946,26947,26948,26949);
SELECT * FROM `disables` WHERE `sourceType`= 1 AND `entry` IN (3116,3117,3118,3119,3120,26940,26945,26946,26947,26948,26949);
```
sourceType entry flags params_0 params_1 comment
```sql
DELETE FROM `disables` WHERE `sourceType`= 1 AND `entry` IN (3116,3117,3118,3119,3120,26940,26945,26946,26947,26948,26949);
INSERT INTO `disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES
(1, 3116, 0, '', '', 'Deprecated quest: Simple Sigil'),
(1, 3117, 0, '', '', 'Deprecated quest: Etched Sigil'),
(1, 3118, 0, '', '', 'Deprecated quest: Encrypted Sigil'),
(1, 3119, 0, '', '', 'Deprecated quest: Hallowed Sigil'),
(1, 3120, 0, '', '', 'Deprecated quest: Verdant Sigil'),
(1, 26940, 0, '', '', 'Deprecated quest: Frost Nova'),
(1, 26945, 0, '', '', 'Deprecated quest: Learning New Techniques'),
(1, 26946, 0, '', '', "Deprecated quest: A Rogue's Advantage"),
(1, 26947, 0, '', '', "Deprecated quest: A Woodsman's Training"),
(1, 26948, 0, '', '', 'Deprecated quest: Moonfire'),
(1, 26949, 0, '', '', 'Deprecated quest: Learning the Word');
Also upon Accepting Quest 28728 Npc 49480 modify existing SAI to teleport to NPC 49479 that wasn't happening when quest was accepted.
/* Table creature_template */ UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 49480;
/* Table smart_scripts */ DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 49480);
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_param_string`, `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
(49480, 0, 0, 0, 1, 0, 100, 512, 3000, 3000, 3000, 3000, '', 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - ooc - despawn if in area 188'),
(49480, 0, 1, 0, 0, 0, 100, 0, 3000, 6000, 8000, 9000, '', 11, 33844, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - IC - Cast Entangling Roots'),
(49480, 0, 2, 0, 38, 0, 100, 0, 1, 3, 0, 0, '', 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - on data set - Say text 3'),
(49480, 0, 3, 0, 38, 0, 100, 512, 1, 3, 0, 0, '', 11, 92573, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - on data seto - Cast to Summon Nature\'s Bite'),
(49480, 0, 4, 0, 38, 0, 100, 512, 1, 3, 0, 0, '', 11, 92573, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - on data set - Cast to Summon Nature\'s Bite'),
(49480, 0, 5, 0, 38, 0, 100, 512, 1, 3, 0, 0, '', 11, 92573, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - In aggro - Cast to Summon Nature\'s Bite'),
(49480, 0, 6, 7, 54, 0, 100, 0, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - just summoned - Say text 0'),
(49480, 0, 7, 0, 61, 0, 100, 512, 0, 0, 0, 0, '', 8, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - just summoned - react passif'),
(49480, 0, 8, 0, 38, 0, 40, 0, 1, 2, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - on data set - Say text 1'),
(49480, 0, 9, 0, 38, 0, 100, 0, 1, 1, 0, 0, '', 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - on data set - Say text 2'),
(49480, 0, 10, 0, 20, 0, 100, 0, 28727, 0, 0, 0, '', 1, 4, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - ooc - Say text 4'),
(49480, 0, 11, 0, 0, 0, 100, 0, 3000, 6000, 5000, 6000, '', 11, 66056, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'Tarindrella - IC - Cast Entangling Roots'),
(49480, 0, 12, 0, 19, 0, 100, 512, 28728, 0, 0, 0, '', 62, 1, 0, 0, 0, 0, 0, 18, 10, 0, 0, 10541.5, 875.09, 1309.06, 0.035, 'Tarindrella - On quest taken - Teleport');
@taaboy thanks for the fix, i will test it today.
HannibalRoG
on 18 Jun 2017
Something is missing, now a can麓t take any missions
HannibalRoG
on 18 Jun 2017
@Taaboy : TC SAI SQL codestyle, some suggestions:
-- Tarindrella
SET @Tarindrella := 49480;
DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryorguid` = @Tarindrella;
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_param_string`,`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
(@Tarindrella, 0, 0,0, 1, 0,100,512, 3000, 3000, 3000, 3000, '', 41, 0, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - OOC - Despawn if in area 188'),
(@Tarindrella, 0, 1,0, 0, 0,100, 0, 3000, 6000, 8000, 9000, '', 11, 33844, 0, 0, 0, 0, 0, 2, 0,0,0, 0, 0, 0, 0, 'Tarindrella - IC - Cast Entangling Roots'),
(@Tarindrella, 0, 2,0, 38, 0,100, 0, 1, 3, 0, 0, '', 1, 3, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On data set - Say text 3'),
(@Tarindrella, 0, 3,0, 38, 0,100,512, 1, 3, 0, 0, '', 11, 92573, 2, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, "Tarindrella - On data set - Summon Nature's Bite"),
(@Tarindrella, 0, 4,0, 38, 0,100,512, 1, 3, 0, 0, '', 11, 92573, 2, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, "Tarindrella - On data set - Summon Nature's Bite"),
(@Tarindrella, 0, 5,0, 38, 0,100,512, 1, 3, 0, 0, '', 11, 92573, 2, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, "Tarindrella - On aggro - Summon Nature's Bite"),
(@Tarindrella, 0, 6,7, 54, 0,100, 0, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 7, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On just summoned - Say text 0'),
(@Tarindrella, 0, 7,0, 61, 0,100,512, 0, 0, 0, 0, '', 8, 1, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On just summoned - react passive'),
(@Tarindrella, 0, 8,0, 38, 0, 40, 0, 1, 2, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On data set - Say text 1'),
(@Tarindrella, 0, 9,0, 38, 0,100, 0, 1, 1, 0, 0, '', 1, 2, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On data set - Say text 2'),
(@Tarindrella, 0,10,0, 20, 0,100, 0, 28727, 0, 0, 0, '', 1, 4, 0, 0, 0, 0, 0, 23, 0,0,0, 0, 0, 0, 0, 'Tarindrella - OOC - Say text 4'),
(@Tarindrella, 0,11,0, 0, 0,100, 0, 3000, 6000, 5000, 6000, '', 11, 66056, 0, 0, 0, 0, 0, 23, 0,0,0, 0, 0, 0, 0, 'Tarindrella - IC - Cast Entangling Roots'),
(@Tarindrella, 0,12,0, 19, 0,100,512, 28728, 0, 0, 0, '', 62, 1, 0, 0, 0, 0, 0, 18, 10,0,0,10541.5, 875.09, 1309.06, 0.035, 'Tarindrella - On quest taken - Teleport');
Notice that creature 49480 (Tarindrella) already has got AIName = SmartAI in creature_template .
The space alignment is purely for readability and not actual code style, but it can help by keeping a good overview while working on the SQL. For comment style, avoid placing comments on the same line as SQL commands if you can. Use -- in front of a comment line instead of /* */ as well. If you need to comment on the same line as an SQL command or inserted data, use a -- comment _behind_ the SQL code and not in front of it.
ghost
on 18 Jun 2017
I see some error in that fix, there is no spawn creature in Shadowglen with id 45006, then this sentence is useless:
DELETE FROM creature_queststarter WHERE id=45006 AND quest = 26940;
Instead there is a npc with id 43006 Ryhanda [mage trainer] i supouse that it's you want referenced
I can't identify why npc id 2079 don't show the first quest 28713
@tkrokli some ideas?
HannibalRoG
on 18 Jun 2017
Yeah, you are correct. http://www.wowhead.com/npc=45006/aggra (Aggra, Thrall's mate since the Shattering/Cataclysm) is not in Shadowglen, she is found near or in the Maelstrom. I did not spend any time checking the content of @Taaboy's SQL, I only suggested a better TC SQL codestyle format.
Also, quests should not be deleted from quest_template , only disabled in the table disables. But regarding quest 26940 (http://www.wowhead.com/quest=26940/frost-nova), this quest is specific to Aggra, at least if wowhead.com can be trusted with that info being correct, so that entire row should be removed where quest 26940 (Frost Nova) or NPC 45006 (Aggra) is used in the SQL samples above.
Quest 28723 (http://www.wowhead.com/quest=28723/priestess-of-the-moon) is listed as a multi-NPC quest, which looks a bit weird to me. I don't know if wowhead.com is correct on that one. Anyway, the suggested SQL code needs to be reviewed and tested before it is ready to be committed. Changing the status label for now until the SQL can be presented in a comprehensive and correct way.
ghost
on 18 Jun 2017
@tkrokli Maybe in past expansion the quest you mention [Quest 28723 (http://www.wowhead.com/quest=28723/priestess-of-the-moon)] is listed as multiple npc quest because in that moment it became available when the diferent class complete his class quest now deprecated,
now that quest is steel valid but class quest not and the trainer class is not who star the quest, now it can be started from another npc Melithar id 2077 when you complete his chain.
HannibalRoG
on 18 Jun 2017
👍1
-- Disable Shadowglen quests deprecated between 3.3.5/WotLK and Legion
DELETE FROM `disables` WHERE `sourceType`= 1 AND `entry` IN (3116,3117,3118,3119,3120,26945,26946,26947,26948,26949);
INSERT INTO `disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES
(1, 3116, 0, '', '', 'Deprecated quest: Simple Sigil'),
(1, 3117, 0, '', '', 'Deprecated quest: Etched Sigil'),
(1, 3118, 0, '', '', 'Deprecated quest: Encrypted Sigil'),
(1, 3119, 0, '', '', 'Deprecated quest: Hallowed Sigil'),
(1, 3120, 0, '', '', 'Deprecated quest: Verdant Sigil'),
(1, 26945, 0, '', '', 'Deprecated quest: Learning New Techniques'),
(1, 26946, 0, '', '', "Deprecated quest: A Rogue's Advantage"),
(1, 26947, 0, '', '', "Deprecated quest: A Woodsman's Training"),
(1, 26948, 0, '', '', 'Deprecated quest: Moonfire'),
(1, 26949, 0, '', '', 'Deprecated quest: Learning the Word');
-- Shadowglen quest starters
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`IN (3116,3117,3118,3119,3120,26841,28715);
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`IN (3116,3117,3118,3119,3120,26841,28713,28714,28723,28734);
INSERT INTO `creature_queststarter` (`id`,`quest`) VALUES
(2077, 28715),
(2079, 28713),
(2079, 28714),
(2079, 28723),
(2079, 28734);
DELETE FROM `creature_queststarter` WHERE `id`= 3593 AND `quest` = 26945;
DELETE FROM `creature_queststarter` WHERE `id`= 3594 AND `quest` = 26946;
DELETE FROM `creature_queststarter` WHERE `id`= 3595 AND `quest` = 26949;
DELETE FROM `creature_queststarter` WHERE `id`= 3596 AND `quest` = 26947;
DELETE FROM `creature_queststarter` WHERE `id`= 3597 AND `quest` = 26948;
DELETE FROM `creature_queststarter` WHERE `quest` = 28723 AND `id` IN (3593,3594,3595,3596,3597,43006);
-- Shadowglen quest enders
DELETE FROM `creature_questender` WHERE `id`=2079 AND `quest` IN (456,457,28713,28714,28723);
DELETE FROM `creature_questender` WHERE `id`=3514 AND `quest` IN (920,921,28730);
DELETE FROM `creature_questender` WHERE `id`=3593 AND `quest` IN (3116, 26945);
DELETE FROM `creature_questender` WHERE `id`=3594 AND `quest` IN (3118, 26946);
DELETE FROM `creature_questender` WHERE `id`=3595 AND `quest` IN (3119, 26949);
DELETE FROM `creature_questender` WHERE `id`=3596 AND `quest` IN (3117, 26947);
DELETE FROM `creature_questender` WHERE `id`=3597 AND `quest` IN (3120, 26948);
INSERT INTO `creature_questender` (`id`,`quest`) VALUES
(2079, 28713),
(2079, 28714),
(3514, 28730);
-- Quest Template Addon
UPDATE `quest_template_addon` SET `NextQuestID`= 28723 WHERE `ID`= 28714;
UPDATE `quest_template_addon` SET `NextQuestID`= 28715 WHERE `ID`= 28734;
DELETE FROM `quest_template_addon` WHERE `ID`= 2519;
INSERT INTO `quest_template_addon` VALUES
(2519, 0,0,0, 28730, 0,0,0,0,0,0,0,0,0,0,0,0);
-- Tarindrella
SET @Tarindrella := 49480;
DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryorguid` = @Tarindrella;
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_param_string`,`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
(@Tarindrella, 0, 0,0, 1, 0,100,512, 3000, 3000, 3000, 3000, '', 41, 0, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - OOC - Despawn if in area 188'),
(@Tarindrella, 0, 1,0, 0, 0,100, 0, 3000, 6000, 8000, 9000, '', 11, 33844, 0, 0, 0, 0, 0, 2, 0,0,0, 0, 0, 0, 0, 'Tarindrella - IC - Cast Entangling Roots'),
(@Tarindrella, 0, 2,0, 38, 0,100, 0, 1, 3, 0, 0, '', 1, 3, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On data set - Say text 3'),
(@Tarindrella, 0, 3,0, 38, 0,100,512, 1, 3, 0, 0, '', 11, 92573, 2, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, "Tarindrella - On data set - Summon Nature's Bite"),
(@Tarindrella, 0, 4,0, 38, 0,100,512, 1, 3, 0, 0, '', 11, 92573, 2, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, "Tarindrella - On data set - Summon Nature's Bite"),
(@Tarindrella, 0, 5,0, 38, 0,100,512, 1, 3, 0, 0, '', 11, 92573, 2, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, "Tarindrella - On aggro - Summon Nature's Bite"),
(@Tarindrella, 0, 6,7, 54, 0,100, 0, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 7, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On just summoned - Say text 0'),
(@Tarindrella, 0, 7,0, 61, 0,100,512, 0, 0, 0, 0, '', 8, 1, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On just summoned - react passive'),
(@Tarindrella, 0, 8,0, 38, 0, 40, 0, 1, 2, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On data set - Say text 1'),
(@Tarindrella, 0, 9,0, 38, 0,100, 0, 1, 1, 0, 0, '', 1, 2, 0, 0, 0, 0, 0, 1, 0,0,0, 0, 0, 0, 0, 'Tarindrella - On data set - Say text 2'),
(@Tarindrella, 0,10,0, 20, 0,100, 0, 28727, 0, 0, 0, '', 1, 4, 0, 0, 0, 0, 0, 23, 0,0,0, 0, 0, 0, 0, 'Tarindrella - OOC - Say text 4'),
(@Tarindrella, 0,11,0, 0, 0,100, 0, 3000, 6000, 5000, 6000, '', 11, 66056, 0, 0, 0, 0, 0, 23, 0,0,0, 0, 0, 0, 0, 'Tarindrella - IC - Cast Entangling Roots'),
(@Tarindrella, 0,12,0, 19, 0,100,512, 28728, 0, 0, 0, '', 62, 1, 0, 0, 0, 0, 0, 18, 10,0,0,10541.5, 875.09, 1309.06, 0.035, 'Tarindrella - On quest taken - Teleport');
Notice that I have removed the queries
DELETE FROM `quest_template` WHERE `ID` IN (28713,28714,28734);
INSERT INTO `quest_template` [ ... ]
because that content is already present in the DB and the recommended method is to update those rows in the table if data is already present. The only exception is if all of that data is incorrect or it will take too much writing to use UPDATE compared to DELETE FROM / INSERT INTO for the same rows.
Anyway, please take your time to copy the suggested SQL to Notepad++, Notepadqq, Sublime Text, Atom, Geany or Gedit (or any other code editor you prefer) and add comments ( -- ) to all lines to see which line does what and see if you can find inconsistencies where it needs to be changed or improved. The code above is still untested for my part. Feel free to post edited and tested versions of this in a new comment when you find that it works as intended and blizzlike.
ghost
on 18 Jun 2017
👍1
The sai is wrong, the correct one is already on the DB.
The spell 92420 is used to teleport the player.
```
49480, 0, 12, 0, 19, 0, 100, 512, 28728, 0, 0, 0, 80, 4948000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, Tarindrella - ON quest taken - Actionlist
4948000, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 92420, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, Tarindrella - Actionlist - CAST teleport
4948000, 9, 1, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, Tarindrella - Actionlist - Despawn
Killyana
on 18 Jun 2017
👍1
Ok, @tkrolki it's works as intended, now the complete quest chain is available, allow me to invite you to a beer, you choose the place ;)
Remove the sai part from .sql and that it's all.
HannibalRoG
on 18 Jun 2017
@HannibalRoG : did you mean that it works if you remove that SAI from @Taaboy which I included above?
(edit) If I understand this correctly, the working version should look like this:
-- Disable Shadowglen quests deprecated between 3.3.5/WotLK and Legion
DELETE FROM `disables` WHERE `sourceType`= 1 AND `entry` IN (3116,3117,3118,3119,3120,26945,26946,26947,26948,26949);
INSERT INTO `disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES
(1, 3116, 0, '', '', 'Deprecated quest: Simple Sigil'),
(1, 3117, 0, '', '', 'Deprecated quest: Etched Sigil'),
(1, 3118, 0, '', '', 'Deprecated quest: Encrypted Sigil'),
(1, 3119, 0, '', '', 'Deprecated quest: Hallowed Sigil'),
(1, 3120, 0, '', '', 'Deprecated quest: Verdant Sigil'),
(1, 26945, 0, '', '', 'Deprecated quest: Learning New Techniques'),
(1, 26946, 0, '', '', "Deprecated quest: A Rogue's Advantage"),
(1, 26947, 0, '', '', "Deprecated quest: A Woodsman's Training"),
(1, 26948, 0, '', '', 'Deprecated quest: Moonfire'),
(1, 26949, 0, '', '', 'Deprecated quest: Learning the Word');
-- Shadowglen quest starters
DELETE FROM `creature_queststarter` WHERE `id`=2077 AND `quest`IN (3116,3117,3118,3119,3120,26841,28715);
DELETE FROM `creature_queststarter` WHERE `id`=2079 AND `quest`IN (3116,3117,3118,3119,3120,26841,28713,28714,28723,28734);
INSERT INTO `creature_queststarter` (`id`,`quest`) VALUES
(2077, 28715),
(2079, 28713),
(2079, 28714),
(2079, 28723),
(2079, 28734);
DELETE FROM `creature_queststarter` WHERE `id`= 3593 AND `quest` = 26945;
DELETE FROM `creature_queststarter` WHERE `id`= 3594 AND `quest` = 26946;
DELETE FROM `creature_queststarter` WHERE `id`= 3595 AND `quest` = 26949;
DELETE FROM `creature_queststarter` WHERE `id`= 3596 AND `quest` = 26947;
DELETE FROM `creature_queststarter` WHERE `id`= 3597 AND `quest` = 26948;
DELETE FROM `creature_queststarter` WHERE `quest` = 28723 AND `id` IN (3593,3594,3595,3596,3597,43006);
-- Shadowglen quest enders
DELETE FROM `creature_questender` WHERE `id`=2079 AND `quest` IN (456,457,28713,28714,28723);
DELETE FROM `creature_questender` WHERE `id`=3514 AND `quest` IN (920,921,28730);
DELETE FROM `creature_questender` WHERE `id`=3593 AND `quest` IN (3116, 26945);
DELETE FROM `creature_questender` WHERE `id`=3594 AND `quest` IN (3118, 26946);
DELETE FROM `creature_questender` WHERE `id`=3595 AND `quest` IN (3119, 26949);
DELETE FROM `creature_questender` WHERE `id`=3596 AND `quest` IN (3117, 26947);
DELETE FROM `creature_questender` WHERE `id`=3597 AND `quest` IN (3120, 26948);
INSERT INTO `creature_questender` (`id`,`quest`) VALUES
(2079, 28713),
(2079, 28714),
(3514, 28730);
-- Quest Template Addon
UPDATE `quest_template_addon` SET `NextQuestID`= 28723 WHERE `ID`= 28714;
UPDATE `quest_template_addon` SET `NextQuestID`= 28715 WHERE `ID`= 28734;
DELETE FROM `quest_template_addon` WHERE `ID`= 2519;
INSERT INTO `quest_template_addon` (`ID`,`MaxLevel`,`AllowableClasses`,`SourceSpellID`,`PrevQuestID`,`NextQuestID`,`ExclusiveGroup`,`RewardMailTemplateID`,`RewardMailDelay`,`RequiredSkillID`,`RequiredSkillPoints`,`RequiredMinRepFaction`,`RequiredMaxRepFaction`,`RequiredMinRepValue`,`RequiredMaxRepValue`,`ProvidedItemCount`,`SpecialFlags`) VALUES
(2519, 0,0,0, 28730, 0,0,0,0,0,0,0,0,0,0,0,0);
Its works in both cases but the sai already in DB is more correct like killana said. The only i see is Tirandrella not attack, in retail she does. Maybe this is becose of this https://github.com/TrinityCore/TrinityCore/issues/16997
HannibalRoG
on 18 Jun 2017
@tkrokli i edit my last comment, do you think i am rigth?
HannibalRoG
on 18 Jun 2017
It is possible that Tarindrella's missing attacks can be caused by SAI issues, but even if that is the case, it is not within the scope of this issue or the suggested solution, since we're dealing with the quest chains here and not NPC actions.
ghost
on 18 Jun 2017
ok, just confirming.
HannibalRoG
on 18 Jun 2017
@HannibalRoG @tkrokli @Killyana
The SAi was in DB like i stated but her spell didn't work 100% of the time, i experiment with it with 20 times running thru till i got it to work 100% and the best option was to change line 12 from a timeactionlist and changed to a quest accepted to teleport to location of nearest player.
And yes the code that I and tkrokli cleaned up for me worked, tested mutliple times and . i have a page of npc-quest start and finishers.
And also clean your WOW-Folder cache folder everytime if you are checking for errors, as i have found it kept the problem in there, once cleaned out started new character problem dissapeared and quest as it should.
Taaboy
on 19 Jun 2017
Thank you for the effort and your time spent on this. It is a different issue than the quest issue on this page, so feel free to open a new issue page about that DB/Creature issue.
ghost
on 19 Jun 2017
Was this page helpful?
0 / 5 - 0 ratings
Related issues
Rushor
路
3Comments
daddycaddy
路
3Comments
Rochet2
路
3Comments
funjoker
路
3Comments
Jildor
路
3Comments