Fixing Problem of some quests in teldrassil

[AlirezaAbsolut]

Hi, I've got to fix the problem quests, hope to be useful:

1. Fel Moss Corruption (28714) * http://wow.gamepedia.com/Quest:Fel_Moss_Corruption
2. A Favor for Melithar (28734) * http://wow.gamepedia.com/Quest:A_Favor_for_Melithar
3. Demonic Thieves (28713) * http://wow.gamepedia.com/Quest:Demonic_Thieves
4. Verdant Sigil (3120) * http://wow.gamepedia.com/Quest:Verdant_Sigil
5. Moonfire (26948) * http://wow.gamepedia.com/Quest:Moonfire_%28night_elf%29
6. Etched Sigil (3117) * http://wow.gamepedia.com/Quest:Etched_Sigil
7. A Woodsman's Training (26947) * http://wow.gamepedia.com/Quest:A_Woodsman's_Training 8 Quest : Forbidden Sigil (26841) * http://wow.gamepedia.com/Quest:Forbidden_Sigil 9 Quest : Frost Nova (26940) * http://www.wowhead.com/quest=26940

[SQL Code] >>> Database = Wolrd

/*  
01  Quest = Fel Moss Corruption (28714)
>   http://wow.gamepedia.com/Quest:Fel_Moss_Corruption
02  Quest = A Favor for Melithar (28734)
>   http://wow.gamepedia.com/Quest:A_Favor_for_Melithar
03  Quest = Demonic Thieves (28715)
>   http://wow.gamepedia.com/Quest:Demonic_Thieves
04  Quest : Verdant Sigil (3120)
>   http://wow.gamepedia.com/Quest:Verdant_Sigil
05  Quest : Moonfire (26948)
>   http://wow.gamepedia.com/Quest:Moonfire_%28night_elf%29
06  Quest : Etched Sigil (3117)
>   http://wow.gamepedia.com/Quest:Etched_Sigil
07  Quest : A Woodsman's Training (26947)
>   http://wow.gamepedia.com/Quest:A_Woodsman's_Training
08  Quest : Forbidden Sigil (26841)
>   http://wow.gamepedia.com/Quest:Forbidden_Sigil
09  Quest : Frost Nova (26940)
>   http://www.wowhead.com/quest=26940
>   Authored by AlirezaAbsolut [https://github.com/AlirezaAbsolut]
*/
-- Edit Quest
UPDATE `quest_template` SET `Flags` = 8388608 WHERE `Id` = 28714;
update `quest_template` set `Flags` = 8650752, `OfferRewardText` = 'Ilthalaine sent you? He was wise to do so. I am indeed in need of help.' where `Id` = 28734;
update `quest_template` set `Flags` = 0 where `Id` = 28715;
update `quest_template` set `Flags` = 0 where `Id` = 3120;
update `quest_template` set `Flags` = 2097152, `Title` = 'Moonfire', `Objectives` = 'Reach level 3 to learn [Moonfire]. Use it on a training dummy in Aldrassil.', `Details` = 'Druids play an important role in our society, but all too often we are seen as passive dreamers in a world that is changing around us.$B$BThe truth is, though, we must actively practice and go out onto the world to develop our connection to nature. So go, get some more experience. You will begin to feel your connection deepen, learning new skills. Demonstrate the first you learn for me.' where `Id` = 26948;
update `quest_template` set `Flags` = 8650752, `PrevQuestId` = 28714, `NextQuestId` = 26947, `ExclusiveGroup` = 3120, `NextQuestIdChain` = 26947 where `Id` = 3117;
delete from `quest_poi` where `questId` = 26947;
delete from `quest_poi_points` where `questId` = 26947;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(26947, 0, -1, 1, 41, 0, 0, 1),
(26947, 1, 0, 1, 41, 0, 0, 1),
(26947, 2, 1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(26947, 0, 0, 10480, 825),
(26947, 1, 0, 10476, 720),
(26947, 1, 1, 10519, 732),
(26947, 1, 2, 10538, 745),
(26947, 1, 3, 10569, 775),
(26947, 1, 4, 10581, 812),
(26947, 1, 5, 10551, 862),
(26947, 1, 6, 10500, 892),
(26947, 1, 7, 10464, 893),
(26947, 1, 8, 10427, 868),
(26947, 1, 9, 10414, 812),
(26947, 1, 10, 10420, 775),
(26947, 1, 11, 10451, 738),
(26947, 2, 0, 10470, 707),
(26947, 2, 1, 10525, 714),
(26947, 2, 2, 10569, 738),
(26947, 2, 3, 10581, 782),
(26947, 2, 4, 10575, 812),
(26947, 2, 5, 10544, 868),
(26947, 2, 6, 10513, 880),
(26947, 2, 7, 10470, 887),
(26947, 2, 8, 10427, 880),
(26947, 2, 9, 10402, 850),
(26947, 2, 10, 10408, 794),
(26947, 2, 11, 10439, 732);
update `quest_template` set `OfferRewardText` = 'I will be your mentor and guide for now. It is my duty to teach you the arcane arts and how you might best fit in among our people.$B$BAs you learn and grow in power, you will learn an immense variety of spells that should allow you to deal with nearly any situation. But until then, return to me as often as you like and I will teach you what I can in the ways of our kind.', `RequestItemsText` = 'I''m glad that you''ve come, $n.' where `Id` = 26841;
delete from `quest_poi` where `questId` = 26841;
delete from `quest_poi_points` where `questId` = 26841;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(26841, 0, -1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(26841, 0, 0, 10456, 805);
update `quest_template` set `Title` = 'Frost Nova', `OfferRewardText` = 'I knew you would master this lesson quickly. You are a credit to the highborn and to all our kin. Remember, as you grow in power, return to me and will instruct you further.', `RequestItemsText` = 'This is just the first of many techniques you will learn. Master them all, $n, and you will have an impressive array of skills at your command.' where `Id` = 26940;
delete from `quest_poi` where `questId` = 26940;
delete from `quest_poi_points` where `questId` = 26940;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(26940, 0, -1, 1, 41, 0, 0, 1),
(26940, 1, 0, 1, 41, 0, 0, 1),
(26940, 2, 1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(26940, 0, 0, 10480, 825),
(26940, 1, 0, 10476, 720),
(26940, 1, 1, 10519, 732),
(26940, 1, 2, 10538, 745),
(26940, 1, 3, 10569, 775),
(26940, 1, 4, 10581, 812),
(26940, 1, 5, 10551, 862),
(26940, 1, 6, 10500, 892),
(26940, 1, 7, 10464, 893),
(26940, 1, 8, 10427, 868),
(26940, 1, 9, 10414, 812),
(26940, 1, 10, 10420, 775),
(26940, 1, 11, 10451, 738),
(26940, 2, 0, 10470, 707),
(26940, 2, 1, 10525, 714),
(26940, 2, 2, 10569, 738),
(26940, 2, 3, 10581, 782),
(26940, 2, 4, 10575, 812),
(26940, 2, 5, 10544, 868),
(26940, 2, 6, 10513, 880),
(26940, 2, 7, 10470, 887),
(26940, 2, 8, 10427, 880),
(26940, 2, 9, 10402, 850),
(26940, 2, 10, 10408, 794),
(26940, 2, 11, 10439, 732);
update `creature_queststarter` set `id` = 43006 where `quest` = 26940;
update `quest_objective` set `objectId` = 122, `description` = 'Reach level 3 to learn Frost Nova' where `questId` = 26940 and `index` = 255;
update `quest_objective` set `objectId` = 44175, `description` = 'Practice using Frost Nova' where `questId` = 26940 and `index` = 0;

-- Edit Mobs of Quest's Objective
UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE `id` IN (1988, 1989, 1984, 883, 721);
UPDATE `creature_classlevelstats` SET `OldContentBaseHP` = 55, `CurrentContentBaseHP` = 55 WHERE `level` = 2 AND `class` = 1;
UPDATE `creature_classlevelstats` SET `OldContentBaseHP` = 71, `CurrentContentBaseHP` = 71 WHERE `level` = 3 AND `class` = 1;
UPDATE `creature_classlevelstats` SET `OldContentBaseHP` = 86, `CurrentContentBaseHP` = 86 WHERE `level` = 4 AND `class` = 1;
update `creature_template` set `mindmg` = 2, `maxdmg` = 3, `Health_mod` = 1 where `entry` = 2031;
update `creature_template` set `mindmg` = 2, `maxdmg` = 2, `Health_mod` = 1 where `entry` = 1984;
UPDATE `creature_template` SET `mindmg` = 2, `maxdmg` = 3, `Health_mod` = 1 WHERE `entry` = 1988;
UPDATE `creature_template` SET `mindmg` = 2, `maxdmg` = 3, `Health_mod` = 1 WHERE `entry` = 1989;
update `creature_template` set `KillCredit1` = 44175 where `entry` = 44614;

-- Edit Loots
update `gameobject_loot_template` set `ChanceOrQuestChance` = -100 where `entry` = 27260 and `item` = 46700;

[AlirezaAbsolut]

I've got to fix the problem quests, hope to be useful: -Quest : Calligraphed Sigil (31168)>>>>>>>http://www.wowhead.com/quest=31168 -Quest : The Art of the Monk (31169)>>>>>http://www.wowhead.com/quest=31169

[SQL Code] >> DB = World

/*
01  Quest : Calligraphed Sigil (31168)
>   http://www.wowhead.com/quest=31168
02  Quest : The Art of the Monk (31169)
>   http://www.wowhead.com/quest=31169
>  Authored by AlirezaAbsolut [https://github.com/AlirezaAbsolut
*/
-- Edit Quest : Calligraphed Sigil (31168)
update `quest_template` set `RequestItemsText` = 'Ah, you have come. Good.$B$BI am learning so much - your people have a wealth of knowledge unmatched anywhere I have seen. As much as I am humbled by that fact, I hope that I may teach you of our ways, as well.', `OfferRewardText` = 'I was warned that not all of your people would be welcoming, but I have found quite the opposite - not only have I been welcomed, but I have learned so much from you.$B$BYou seem quite promising as a young monk, and I hope I can teach you much of our ways, as your people have taught me of yours.', `RequiredClasses` = 512 where `Id` = 31168;
delete from `creature_queststarter` where `quest` = 31168;
insert into `creature_queststarter` (`id`, `quest`) values
(2077, 31168);
delete from `creature_queststarter` where `id` = 63331 and `quest` = 28723;
insert into `creature_queststarter` (`id`, `quest`) values
(63331, 28723);
delete from `quest_poi` where `questId` = 31168;
delete from `quest_poi_points` where `questId` = 31168;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(31168, 0, -1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(31168, 0, 0, 10529, 784);
-- add creature laoxi (63331)
set @CGUID = xxx;
delete from `creature` where `id` = 63331;
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) values
(@CGUID, 63331, 1, 1, 1, 0, 1, 10529.57, 784.489, 1329.5992, 3.27115, 300, 0, 0, 0, 0, 0, 0, 0, 0);

-- Edit Quest : The Art of the Monk (31169)
update `quest_template` set `OfferRewardText` = 'You''ve proven a capable student. When it is time to resume your training, return to me and I will show you other techniques.' where `Id` = 31169;
delete from `quest_poi` where `questId` = 31169;
delete from `quest_poi_points` where `questId` = 31169;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(31169, 0, -1, 1, 41, 0, 0, 1),
(31169, 1, 0, 1, 41, 0, 0, 1),
(31169, 2, 1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(31169, 0, 0, 10480, 825),
(31169, 1, 0, 10476, 720),
(31169, 1, 1, 10519, 732),
(31169, 1, 2, 10538, 745),
(31169, 1, 3, 10569, 775),
(31169, 1, 4, 10581, 812),
(31169, 1, 5, 10551, 862),
(31169, 1, 6, 10500, 892),
(31169, 1, 7, 10464, 893),
(31169, 1, 8, 10427, 868),
(31169, 1, 9, 10414, 812),
(31169, 1, 10, 10420, 775),
(31169, 1, 11, 10451, 738),
(31169, 2, 0, 10470, 707),
(31169, 2, 1, 10525, 714),
(31169, 2, 2, 10569, 738),
(31169, 2, 3, 10581, 782),
(31169, 2, 4, 10575, 812),
(31169, 2, 5, 10544, 868),
(31169, 2, 6, 10513, 880),
(31169, 2, 7, 10470, 887),
(31169, 2, 8, 10427, 880),
(31169, 2, 9, 10402, 850),
(31169, 2, 10, 10408, 794),
(31169, 2, 11, 10439, 732);

[SkyFire]

Just so you know. some of the mechanics of the quest system still need to be updated. So some of the flags may look incorrect. I will work on it next weekend when I have off.

[AlirezaAbsolut]

Sound is good. i still work on quest and i don't change the flag of quests.

[AlirezaAbsolut]

with this update all of quests in "Shadow Glen's Part" in "Teldrassil" is fixed.

/*
01      Quest : Learning the Word (night elf) (26949)
02      Quest : A Rogue's Advantage (26946)
03      Quest : Learning New Techniques (26945)
04      Quest : Iverron's Antidote (28724)
05      Quest : The Woodland Protecter (28725)
06      Creatures : Thistle Boar - Mangy Nightsaber - Webwood Spider (1985 - 2032 - 1986)
07      Quest : Vile Touch (28727)
08      Quest : Teldrassil : Crown of Azeroth (28729)
09      Quest : Teldrassil : Passing Awareness (28731)
        Authored by AlirezaAbsolut [https://github.com/AlirezaAbsolut]
*/
-- 01
update `quest_template` set `Title` = 'Learning the Word', `Objectives` = 'Reach level 3 to learn [Shadow Word: Pain], then use it 5 times on training dummies.', `Details` = 'As you venture out into the world and develop your skills, you will begin to learn new abilities that you never knew you had within you. I''d like you to go out, get some more experience, and then show me the first new ability you learn.', `OfferRewardText` = 'You will find no lack of allies in need of healing. Return to me when you need further training.' where `Id` = 26949;
delete from `quest_poi` where `questId` = 26949;
delete from `quest_poi_points` where `questId` = 26949;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(26949, 0, -1, 1, 41, 0, 0, 1),
(26949, 1, 0, 1, 41, 0, 0, 1),
(26949, 2, 1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(26949, 0, 0, 10458, 800),
(26949, 1, 0, 10476, 720),
(26949, 1, 1, 10519, 732),
(26949, 1, 2, 10538, 745),
(26949, 1, 3, 10569, 775),
(26949, 1, 4, 10581, 812),
(26949, 1, 5, 10551, 862),
(26949, 1, 6, 10500, 892),
(26949, 1, 7, 10464, 893),
(26949, 1, 8, 10427, 868),
(26949, 1, 9, 10414, 812),
(26949, 1, 10, 10420, 775),
(26949, 1, 11, 10451, 738),
(26949, 2, 0, 10470, 707),
(26949, 2, 1, 10525, 714),
(26949, 2, 2, 10569, 738),
(26949, 2, 3, 10581, 782),
(26949, 2, 4, 10575, 812),
(26949, 2, 5, 10544, 868),
(26949, 2, 6, 10513, 880),
(26949, 2, 7, 10470, 887),
(26949, 2, 8, 10427, 880),
(26949, 2, 9, 10402, 850),
(26949, 2, 10, 10408, 794),
(26949, 2, 11, 10439, 732);

-- 02
delete from `quest_poi` where `questId` = 26946;
delete from `quest_poi_points` where `questId` = 26946;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(26946, 0, -1, 1, 41, 0, 0, 1),
(26946, 1, 0, 1, 41, 0, 0, 1),
(26946, 2, 1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(26946, 0, 0, 10519, 778),
(26946, 1, 0, 10476, 720),
(26946, 1, 1, 10519, 732),
(26946, 1, 2, 10538, 745),
(26946, 1, 3, 10569, 775),
(26946, 1, 4, 10581, 812),
(26946, 1, 5, 10551, 862),
(26946, 1, 6, 10500, 892),
(26946, 1, 7, 10464, 893),
(26946, 1, 8, 10427, 868),
(26946, 1, 9, 10414, 812),
(26946, 1, 10, 10420, 775),
(26946, 1, 11, 10451, 738),
(26946, 2, 0, 10470, 707),
(26946, 2, 1, 10525, 714),
(26946, 2, 2, 10569, 738),
(26946, 2, 3, 10581, 782),
(26946, 2, 4, 10575, 812),
(26946, 2, 5, 10544, 868),
(26946, 2, 6, 10513, 880),
(26946, 2, 7, 10470, 887),
(26946, 2, 8, 10427, 880),
(26946, 2, 9, 10402, 850),
(26946, 2, 10, 10408, 794),
(26946, 2, 11, 10439, 732);

-- 03
update `quest_template` set `OfferRewardText` = 'You''ve proven a capable student. When it is time to resume your training, return to me and I will show you other techniques.', `RequestItemsText` = 'Speed and momentum are important tools for beating your opponents. Have you been practicing your charge?' where `Id` = 26945;
delete from `quest_poi` where `questId` = 26945;
delete from `quest_poi_points` where `questId` = 26945;
insert into `quest_poi` (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`) values
(26945, 0, -1, 1, 41, 0, 0, 1),
(26945, 1, 0, 1, 41, 0, 0, 1),
(26945, 2, 1, 1, 41, 0, 0, 1);
insert into `quest_poi_points` (`questId`, `id`, `idx`, `x`, `y`) values
(26945, 0, 0, 10526, 778),
(26945, 1, 0, 10476, 720),
(26945, 1, 1, 10519, 732),
(26945, 1, 2, 10538, 745),
(26945, 1, 3, 10569, 775),
(26945, 1, 4, 10581, 812),
(26945, 1, 5, 10551, 862),
(26945, 1, 6, 10500, 892),
(26945, 1, 7, 10464, 893),
(26945, 1, 8, 10427, 868),
(26945, 1, 9, 10414, 812),
(26945, 1, 10, 10420, 775),
(26945, 1, 11, 10451, 738),
(26945, 2, 0, 10470, 707),
(26945, 2, 1, 10525, 714),
(26945, 2, 2, 10569, 738),
(26945, 2, 3, 10581, 782),
(26945, 2, 4, 10575, 812),
(26945, 2, 5, 10544, 868),
(26945, 2, 6, 10513, 880),
(26945, 2, 7, 10470, 887),
(26945, 2, 8, 10427, 880),
(26945, 2, 9, 10402, 850),
(26945, 2, 10, 10408, 794),
(26945, 2, 11, 10439, 732);

-- 04
update `creature_template` set `AIName` = 'SmartAI' where `entry` = 49479;
delete from `creature_text` where `entry` = 49479;
insert into `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) values
(49479, 0, 0, 'Iverron''s poison is cured, but it will take some time for him to recover.', 12, 0, 100, 0, 8000, 0, 'Dentaria Silverglade');
delete from `smart_scripts` where `entryorguid` = 49479 and `source_type` = 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
(49479, 0, 0, 0, 20, 0, 100, 0, 28724, 0, 0, 0, 1, 0, 8000, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Dentaria Silverglade - On Target Rewarded Quest (28724) - Say Line 0');

-- 05
update `quest_poi` set `unk4` = 1 where `questId` = 28725 and `id` = 0;
delete from `creature` where `id` = 49480;
set @TARINDRELLA = xxx;
insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) values
(@TARINDRELLA, 49480, 1, 1, 1, 0, 1, 10764.24, 925.85, 1337.846, 3.40599, 120, 0, 0, 252, 0, 0, 0, 0, 0);


-- 06
update `creature` set `spawndist` = 5, `MovementType` = 1 where `id` in (1985, 2032, 1986) and `map` = 1;
update `creature_template` set `mindmg`= 4, `maxdmg` = 5 where `entry` = 1985;
update `creature_template` set `mindmg`= 5, `maxdmg` = 6 where `entry` = 1986;
update `creature_template` set `mindmg`= 2, `maxdmg` = 3 where `entry` = 2032;

-- 07
update `quest_template` set `RequestItemsText` = 'I adore these forests. I want to see the corruption purged from them completely. When next I return, I wand to do so with a lighter heart.' where `Id` = 28727;
update `creature_template` set `mindmg` = 7, `maxdmg` = 8 where `entry` = 1994;

-- 08
update `quest_poi` set `unk4` = 1 where `questId` = 28729 and `id` = 1;
update `creature_template` set `flags_extra` = 128 where `entry` = 34575;

-- 09
update `creature_addon` set `auras` = '' where `guid` = 138764;

[SkyFire]

I will test some of this out tonight.

[JustZerooo]

Er have fixxed this?!