Emucoach Announcement | MoP Premium 4 Release Date | Cataclysm VIP 17 Release Date | Happy New Years!
What's new

Quest From The Ashes 10771 Fix 7.02

eyerobot

eyerobot

Gold Supporter
Superior Member
917
2015
23
Location
Barryton Michigan USA
Created new fertile soil 185149 to replace bugged 185148
adjust requirements of quest 10771
corrected missing data in gameobject templates


Code: 
DELETE FROM `quest_template` WHERE `Id`=10771;
INSERT INTO `quest_template` (`Id`, `Method`, `Note`, `Status`, `Level`, `MinLevel`, `MaxLevel`, `ZoneOrSort`, `Type`, `SuggestedPlayers`, `LimitTime`, `RequiredClasses`, `RequiredRaces`, `RequiredSkillId`, `RequiredSkillPoints`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestIdChain`, `RewardXPId`, `RewardOrRequiredMoney`, `RewardMoneyMaxLevel`, `RewardSpell`, `RewardSpellCast`, `RewardHonor`, `RewardHonorMultiplier`, `RewardMailTemplateId`, `RewardMailDelay`, `SourceItemId`, `SourceItemCount`, `SourceSpellId`, `Flags`, `SpecialFlags`, `MinimapTargetMark`, `RewardTitleId`, `RequiredPlayerKills`, `RewardTalents`, `RewardArenaPoints`, `RewardSkillId`, `RewardSkillPoints`, `RewardReputationMask`, `QuestGiverPortrait`, `QuestTurnInPortrait`, `RewardItemId1`, `RewardItemId2`, `RewardItemId3`, `RewardItemId4`, `RewardItemCount1`, `RewardItemCount2`, `RewardItemCount3`, `RewardItemCount4`, `RewardChoiceItemId1`, `RewardChoiceItemId2`, `RewardChoiceItemId3`, `RewardChoiceItemId4`, `RewardChoiceItemId5`, `RewardChoiceItemId6`, `RewardChoiceItemCount1`, `RewardChoiceItemCount2`, `RewardChoiceItemCount3`, `RewardChoiceItemCount4`, `RewardChoiceItemCount5`, `RewardChoiceItemCount6`, `RewardFactionId1`, `RewardFactionId2`, `RewardFactionId3`, `RewardFactionId4`, `RewardFactionId5`, `RewardFactionValueId1`, `RewardFactionValueId2`, `RewardFactionValueId3`, `RewardFactionValueId4`, `RewardFactionValueId5`, `RewardFactionValueIdOverride1`, `RewardFactionValueIdOverride2`, `RewardFactionValueIdOverride3`, `RewardFactionValueIdOverride4`, `RewardFactionValueIdOverride5`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`, `Objectives`, `Details`, `EndText`, `OfferRewardText`, `RequestItemsText`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGo2`, `RequiredNpcOrGo3`, `RequiredNpcOrGo4`, `RequiredNpcOrGoCount1`, `RequiredNpcOrGoCount2`, `RequiredNpcOrGoCount3`, `RequiredNpcOrGoCount4`, `RequiredSourceItemId1`, `RequiredSourceItemId2`, `RequiredSourceItemId3`, `RequiredSourceItemId4`, `RequiredSourceItemCount1`, `RequiredSourceItemCount2`, `RequiredSourceItemCount3`, `RequiredSourceItemCount4`, `RequiredItemId1`, `RequiredItemId2`, `RequiredItemId3`, `RequiredItemId4`, `RequiredItemId5`, `RequiredItemId6`, `RequiredItemCount1`, `RequiredItemCount2`, `RequiredItemCount3`, `RequiredItemCount4`, `RequiredItemCount5`, `RequiredItemCount6`, `RequiredSpell`, `RequiredSpellCast1`, `RequiredSpellCast2`, `RequiredSpellCast3`, `RequiredSpellCast4`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `RewardCurrencyId1`, `RewardCurrencyId2`, `RewardCurrencyId3`, `RewardCurrencyId4`, `RewardCurrencyCount1`, `RewardCurrencyCount2`, `RewardCurrencyCount3`, `RewardCurrencyCount4`, `RequiredCurrencyId1`, `RequiredCurrencyId2`, `RequiredCurrencyId3`, `RequiredCurrencyId4`, `RequiredCurrencyCount1`, `RequiredCurrencyCount2`, `RequiredCurrencyCount3`, `RequiredCurrencyCount4`, `QuestGiverTextWindow`, `QuestGiverTargetName`, `QuestTurnTextWindow`, `QuestTurnTargetName`, `SoundAccept`, `SoundTurnIn`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `EmoteOnIncomplete`, `EmoteOnComplete`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES (10771, 2, NULL, 'Untested', 67, 65, 0, 3522, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 37000, 69900, 0, 0, 0, 0, 0, 0, 31300, 1, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31414, 31416, 31415, 0, 0, 0, 1, 1, 1, 0, 0, 0, 942, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'From the Ashes', 'Mosswood the Ancient wants you to journey to Skald and plant Ironroot Seeds in three different mounds of Fertile Volcanic Soil and then return to him in Ruuan Weald.', 'If you follow the road east and up the side of the mountain, then turn north, you will come to my long lost home.$b$bOnce there was a wood there. Its name is forgotten. Long ago the Burning Legion summoned scorched imps and other creatures of flame. My home was destroyed and my people fled. Now only I remain. $B$BI have saved some ironroot seeds that could be planted in fertile volcanic soil. Their magic is strong. Do this for me and I will share with you the treasures of a forgotten age.', '', 'You destroyed many of those foul little creatures.  I can rest easier in that knowledge.', 'Is it done?  Did you return some life to my ancient home?', 'Return to Mosswood the Ancient at Evergrove in the Blade\'s Edge Mountains.', -185124, -185147, -185149, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31300, 0, 0, 0, 0, 0, 1, 0, 0, 0, 29773, 29773, 29773, 0, 'Southern Volcanic Soil', 'Central Volcanic Soil', 'Northern Volcanic Soil', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 890, 878, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15595);

DELETE FROM `gameobject_template` WHERE `entry`=185124;
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `unkInt32`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (185124, 10, 7297, 'Fertile Volcanic Soil', '', '', '', 94, 0, 4, 0, 0, 0, 0, 0, 0, 1720, 10771, 0, 20000, 0, 1, 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, 'SmartGameObjectAI', '', 15595);


DELETE FROM `gameobject_template` WHERE `entry`=185147;
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `unkInt32`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (185147, 10, 7297, 'Fertile Volcanic Soil', '', '', '', 94, 0, 4, 0, 0, 0, 0, 0, 0, 1720, 10771, 0, 20000, 0, 1, 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, 'SmartGameObjectAI', '', 15595);


DELETE FROM `gameobject_template` WHERE `entry`=185149;
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `unkInt32`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (185149, 10, 7297, 'Fertile Volcanic Soil', '', '', '', 94, 0, 4, 0, 0, 0, 0, 0, 0, 1720, 10771, 0, 20000, 0, 1, 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, 'SmartGameObjectAI', '', 15595);

DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=0 AND `link`=1;
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 (185149, 1, 0, 1, 70, 0, 100, 0, 2, 0, 0, 0, 50, 185179, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3732.36, 4957.41, 276.98, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Grass 2\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=1 AND `link`=2;
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 (185149, 1, 1, 2, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185173, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3737.89, 4942.58, 278.22, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 2 (Big)\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=2 AND `link`=3;
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 (185149, 1, 2, 3, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185173, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3759.93, 4927.35, 278.18, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 2 (Big)\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=3 AND `link`=4;
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 (185149, 1, 3, 4, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185179, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3761.11, 4931.52, 277.78, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Grass 2\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=4 AND `link`=5;
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 (185149, 1, 4, 5, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185174, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3761.2, 4957.85, 282.38, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 3\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=5 AND `link`=6;
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 (185149, 1, 5, 6, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185175, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3757.2, 4955.87, 279.65, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Bush 1\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=6 AND `link`=7;
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 (185149, 1, 6, 7, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185173, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3748.29, 4952.12, 277.16, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 2 (Big)\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=7 AND `link`=8;
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 (185149, 1, 7, 8, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185179, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3752.71, 4958.1, 277.1, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Grass 2\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=8 AND `link`=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 (185149, 1, 8, 9, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185175, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3745.54, 4953.12, 277.33, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Bush 1\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=9 AND `link`=10;
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 (185149, 1, 9, 10, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185175, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3752.82, 4962.79, 275.95, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Bush 1\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=10 AND `link`=11;
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 (185149, 1, 10, 11, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185177, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3748.26, 4965.41, 275.99, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Bush 2\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=11 AND `link`=12;
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 (185149, 1, 11, 12, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185173, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3755.12, 4968.1, 276.89, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 2 (Big)\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=12 AND `link`=13;
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 (185149, 1, 12, 13, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185175, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3751.39, 4970.02, 277.68, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Bush 1\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=13 AND `link`=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 (185149, 1, 13, 14, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185172, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3752.91, 4972.14, 279.31, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 1\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=14 AND `link`=15;
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 (185149, 1, 14, 15, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185174, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3746.39, 4973.75, 276.07, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 3\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=15 AND `link`=16;
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 (185149, 1, 15, 16, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185178, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3744.78, 4973.14, 275.9, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Grass 1\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=16 AND `link`=17;
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 (185149, 1, 16, 17, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185173, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3735.67, 4981.06, 275.53, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 2 (Big)\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=17 AND `link`=18;
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 (185149, 1, 17, 18, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185172, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3746.98, 4980, 276.61, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 1\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=18 AND `link`=19;
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 (185149, 1, 18, 19, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185179, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3742.48, 5002, 275.93, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Grass 2\'');
DELETE FROM `smart_scripts` WHERE `entryorguid`=185149 AND `source_type`=1 AND `id`=19 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`, `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 (185149, 1, 19, 0, 61, 0, 100, 0, 2, 0, 0, 0, 50, 185173, 240000, 0, 0, 0, 0, 8, 0, 0, 0, 3741.27, 5007.89, 275.3, 0, 'Fertile Volcanic Soil - On Gameobject State Changed - Summon Gameobject \'Blades Edge Quest - Skald Tree 2 (Big)\'');

DELETE FROM `gameobject` WHERE `guid`=29261;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (29261, 185149, 530, 3522, 3866, 1, 65535, 3741.7, 4960.64, 276.914, 5.91861, 0, 0, 0.181279, -0.983432, 300, 0, 1);
 
You must log in or register to reply here.
Top