ratkosrb
395 lines
72 KiB
SQL
395 lines
72 KiB
SQL
DROP PROCEDURE IF EXISTS add_migration;
|
|
delimiter ??
|
|
CREATE PROCEDURE `add_migration`()
|
|
BEGIN
|
|
DECLARE v INT DEFAULT 1;
|
|
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20231111015434');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20231111015434');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Correct quest details.
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=29;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=272;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=0, `DetailsEmote2`=0 WHERE `entry`=542;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=1103;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=1190;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=0, `DetailsEmote2`=0 WHERE `entry`=1715;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1 WHERE `entry`=1858;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1 WHERE `entry`=1859;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=1960;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=5, `DetailsEmote3`=1 WHERE `entry`=1963;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0, `DetailsEmote3`=0 WHERE `entry`=2821;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=18, `DetailsEmoteDelay2`=200 WHERE `entry`=2844;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=0 WHERE `entry`=2845;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0, `DetailsEmote3`=0 WHERE `entry`=2869;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0, `DetailsEmote3`=0 WHERE `entry`=2870;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0 WHERE `entry`=2871;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0 WHERE `entry`=2941;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0 WHERE `entry`=2944;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=2969;
|
|
UPDATE `quest_template` SET `DetailsEmote3`=1 WHERE `entry`=2970;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0 WHERE `entry`=2982;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=1 WHERE `entry`=3085;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=3096;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=0, `DetailsEmote2`=0, `DetailsEmote3`=0 WHERE `entry`=3130;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0 WHERE `entry`=3633;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0, `DetailsEmote3`=0 WHERE `entry`=3639;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=4, `DetailsEmote3`=1 WHERE `entry`=3841;
|
|
UPDATE `quest_template` SET `DetailsEmote3`=0 WHERE `entry`=3842;
|
|
UPDATE `quest_template` SET `DetailsEmote3`=1 WHERE `entry`=3843;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=6, `DetailsEmote2`=1, `DetailsEmote3`=1 WHERE `entry`=4023;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=6, `DetailsEmote2`=1, `DetailsEmote3`=5 WHERE `entry`=4121;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1 WHERE `entry`=4122;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0, `DetailsEmote3`=0 WHERE `entry`=4125;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0 WHERE `entry`=4129;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=64, `DetailsEmote2`=30, `DetailsEmoteDelay2`=2000 WHERE `entry`=4130;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0, `DetailsEmote3`=0 WHERE `entry`=4131;
|
|
UPDATE `quest_template` SET `DetailsEmote2`=0 WHERE `entry`=4266;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=0, `DetailsEmote2`=0, `DetailsEmote3`=0 WHERE `entry`=4267;
|
|
UPDATE `quest_template` SET `DetailsEmote3`=0 WHERE `entry`=4297;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=5, `DetailsEmote2`=1 WHERE `entry`=4298;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=11, `DetailsEmote4`=1 WHERE `entry`=4487;
|
|
UPDATE `quest_template` SET `DetailsEmote3`=1 WHERE `entry`=4965;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=5061;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=66, `DetailsEmote3`=1 WHERE `entry`=5513;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=5921;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=5923;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=5925;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=5929;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=5931;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=6001;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=6069;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=6123;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=6124;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=6125;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=5 WHERE `entry`=6625;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1 WHERE `entry`=6628;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1 WHERE `entry`=8062;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1 WHERE `entry`=8066;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1 WHERE `entry`=8067;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1 WHERE `entry`=8153;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=8321;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=8420;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=8692;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1 WHERE `entry`=8696;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=5, `DetailsEmoteDelay1`=0 WHERE `entry`=8861;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=0, `DetailsEmote2`=0 WHERE `entry`=9051;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=0, `DetailsEmote2`=0 WHERE `entry`=9052;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=0, `DetailsEmote2`=0 WHERE `entry`=9053;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1 WHERE `entry`=9055;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1 WHERE `entry`=9059;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1 WHERE `entry`=9060;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=0 WHERE `entry`=9063;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1, `DetailsEmote4`=1 WHERE `entry`=9208;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1, `DetailsEmote4`=1 WHERE `entry`=9209;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1, `DetailsEmote4`=1 WHERE `entry`=9210;
|
|
UPDATE `quest_template` SET `DetailsEmote1`=1, `DetailsEmote2`=1, `DetailsEmote3`=1 WHERE `entry`=9237;
|
|
-- Correct quest offer reward.
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Salutations, young druid; the time has come for you to know our aquatic form. It is one that lets you move freely and indefinitely through water. You will find this aspect a useful tool and a blessing... but it is one that must be earned before it is mastered.$B$BYou will face two trials to overcome. The first will test your ability to work in water under pressure. The second will test your resolve to understand the aspects of the form itself.$B$BStand ready, as the time of testing is now upon us.' WHERE `entry`=26;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Well now, it looks like yet another druid has successfully completed the Trial of the Lake! Well done, my young friend - well done.$B$BAs I\'ve said, my name is Tajarri. It is my duty and my privilege to serve as a warden for Moonglade, and specifically this shrine. Keeper Remulos guides the Cenarion Circle in preservation of nature and balance, and his shrine serves as a lasting tribute to such. By using the bauble here, it serves as a nod to the importance of this place within the Circle.' WHERE `entry`=29;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardEmote2`=1, `OfferRewardEmote3`=1 WHERE `entry`=96;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Thank you, $N. I\'ll send these to be destroyed immediately.' WHERE `entry`=115;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Again, thank you for your help. The Stormwind army is so busy dealing with the orcs, they don\'t have the troops to protect Redridge from local threats like the gnolls.' WHERE `entry`=126;
|
|
UPDATE `quest_template` SET `OfferRewardText`='I see you have fought valiantly against the Blackrock Clan, $C. Your service to our township is great indeed.' WHERE `entry`=128;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Thank you for collecting these, $N. Your efforts will help bring peace to the dead in the wake of this tragedy. I will see to it that the families are notified.' WHERE `entry`=168;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Fantastic work, $N! Gath\'Ilzogg led those brutes into battle, killing many innocent humans. Vindication is ours. This is the first step in reclaiming the keep for the kingdom of Stormwind!' WHERE `entry`=169;
|
|
UPDATE `quest_template` SET `OfferRewardText`='This is perfect, $N. The first step is complete!' WHERE `entry`=174;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Most superb! This will work perfectly. Many thanks!' WHERE `entry`=177;
|
|
UPDATE `quest_template` SET `OfferRewardText`='At last! The stargazing device is complete! Thank you, $N. Now I can continue my research. . .' WHERE `entry`=181;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=205;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Aha! You\'ve done it! You are a great force for good, $N, and may your strength never fade!$B$BI will study this Mind\'s Eye and determine if it may be used for good. If not...then it must be destroyed.' WHERE `entry`=206;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardEmote2`=1, `OfferRewardText`='You\'ve done it! Araj... the lich is finally defeated!$B$BYou\'ve done a tremendous service to the Alliance on this day, $N. Your bravery and perseverance are a testament to what it means to be a true hero. Please - accept this as a token for all to see and know that you have delivered the Alliance a victory for the ages!' WHERE `entry`=211;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardEmote2`=0, `OfferRewardEmote3`=0, `OfferRewardText`='You have done well, $N. In defeating the warlock Morganth, Stormwind is saved from a grave peril.$B$BI offer you this reward most humbly. And I would bid you peace, if these were peaceful times.$B$BBut instead, I will bid you luck with your trials, and victory in the conflicts ahead.' WHERE `entry`=249;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='You\'ve completed the Trial of the Sea Lion, $N - congratulations.$B$BEach task in acquiring the pendant shows that both agility and endurance are necessary to act in harmony with what you desire to do underwater. Neither can exist without the other, and both cannot be done without your willingness to embrace the aspect of the sea lion.$B$BRemember these lessons well, and count on them once you have gained your aquatic form.' WHERE `entry`=272;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardText`='Ah, so you\'ve seen Renato? Well here you are, $gsir:ma\'am;. A bottle of our special pinot noir. You\'ll not find its equal in all of Azeroth!' WHERE `entry`=332;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Oh, blast! I thought forgetting my kit would free me from work. Now I guess I\'ll have to help the Larsons with their sewing...$B$BOh, well. Fun will come later I guess.' WHERE `entry`=334;
|
|
UPDATE `quest_template` SET `OfferRewardText`='So Kam Deepfury finally got to feel what it is like to be on the receiving end of Death? Good. Serves the cowardly Dark Iron scum right. You have done well, $c. The victims of the Thandol Span attack were but mere victims in a world torn with war and unrest. Their families will have the peace of knowing Deepfury got the punishment he deserved. Longbraid\'s brother\'s death has been avenged.' WHERE `entry`=378;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Thank you, $N. My head rests a little easier, knowing that villain lost his.' WHERE `entry`=523;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardText`='Oh, you got them! Splendid! I must begin studying the Arm of Gri\'lek immediately!' WHERE `entry`=540;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardEmote2`=0, `OfferRewardEmote3`=0, `OfferRewardText`='My oh my! Look at these! I can\'t believe they survived the ruination of Alterac. And all those ogres too!$B$BThank you, $N. Thank you so much! You have helped preserve human knowledge, and you add to the grandeur of the Royal Library of Stormwind.' WHERE `entry`=542;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You retrieved the eye! Your might is the stuff of legends, $N!$B$BAnd in getting the Eye, you must have defeated Mai\'Zoth and sent him to the Nether. That is why the spirits would not mention him before.$B$BIt is good that he is gone from the world of flesh and bone, but now that he is in the realm of spirits...I fear he will begin a new reign.$B$BBut that is a worry for another time. Now, I must perform a ritual to bend the Mind\'s Eye to our needs...' WHERE `entry`=591;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You\'ve done it! You freed Yenniku from the will of Zanzil, and completed the mission I had thought was so desperate.$B$BOur tribe will remember your name in songs, $N, and we will etch your tale in stone so that it will live forever.' WHERE `entry`=592;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You place the Soul Gem upon his forehead. He shudders as his soul is sucked in, leaving his body, a mindless husk, behind.' WHERE `entry`=593;
|
|
UPDATE `quest_template` SET `OfferRewardText`='What?! I got a lot better things to do then talk to the likes of you, $c. Make it worth my while or get outta my face.$B$BHuh? Bloads sent ya, huh? Well, whaddaya got for me?$B$B<Privateer Groy looks over the bundle carefully.>$B$BNot bad, not bad at all. Another bundle will make my client quite happy.$B$BI suppose yer next question\'s gonna be about money, huh, $c? Of course it is!$B$BHere, take this coin and some advice: get off my docks.' WHERE `entry`=623;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Quite a day this is, $c. The blood of Trollbane will no longer haunt my people, and the sigils needed to take Trol\'kalar are in our possession. Soon, very soon, we will strike against the hated trolls of Zul\'Gurub.' WHERE `entry`=644;
|
|
UPDATE `quest_template` SET `OfferRewardText`='For generations, the forces of Strom and Arathor ravaged the trolls. Now their greatest weapon is in our hands. Our inching progress in the steamy forests of Zul\'Gurub will be no more.$b$bYour assistance has been great, $n, and the Darkspear trolls are indebted to you.$b$bI will be sure that the sword is delivered to Nimboya at Grom\'gol.' WHERE `entry`=646;
|
|
UPDATE `quest_template` SET `OfferRewardText`='These will work great! I just need to smash them into powder...then mix them with a little of this and a little of that.$B$BWatch out, scavengers! Prepare to be flashed!' WHERE `entry`=705;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Good tidings you bring bearing the Sign, $n. The Sign of the Earth was created by the Dark Iron dwarves of Angor Fortress to bind two of Deathwing\'s ruthless lieutenants, the twins Blacklash and Hematus.' WHERE `entry`=732;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=972;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=6, `OfferRewardEmote2`=1, `OfferRewardEmote3`=274, `OfferRewardText`='What makes you think I wish to be pestered by the likes of you, $c? Wait - let me stop the important duties I attend to on a daily basis so I can help you locate a doodad somewhere. By all means, the welfare of Darnassus - nay, all of Teldrassil - should come second to the acquisition of a bauble for your collection.$B$BThe fools in Moonglade waste my time with their call for assistance, and now I must endure this?' WHERE `entry`=1015;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=6, `OfferRewardEmote2`=5, `OfferRewardEmoteDelay2`=1000, `OfferRewardText`='A note from Zamah? Her needs must be great to send word from so far. Let us see what she says...$B$BAh, splendid! I know exactly what to do!' WHERE `entry`=1065;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardText`='Ahhh, den yur ready...$B$BI\'ll put me items in the brazier den, and you c\'n talk wit\' da spirit too.$B$BAn\' dontchu worry none \'bout seein\' into da spirit world wit\' da sapta... ol\' Tiev know a trick or two \'bout how da sapta magic works.$B$BCome now, head down wit\' me to the shrine and let\'s speak to da spirits together, $g brotha:sista;.' WHERE `entry`=1103;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=11, `OfferRewardEmoteDelay2`=2000, `OfferRewardText`='Ah, most of these are nearly bursting with venom, $N. Such are normally only gathered from young wyverns, or fertile females. It must have been quite a slaughter up there in Highperch!' WHERE `entry`=1135;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=6, `OfferRewardEmote2`=5, `OfferRewardText`='$N, you\'re back! You found Martek? You spoke with him? What did he say? Can he help??$B$BTell me, tell me, tell me!!' WHERE `entry`=1137;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Grenka was powerful, even by $r standards. You should be proud of your accomplishment this day.$B$BDuring your test of faith you displayed strength of spirit, and now you have shown endurance in battle by taking on the Roguefeather harpies, but the time has come for a new test.' WHERE `entry`=1150;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardEmote3`=1, `OfferRewardText`='This is the book I sent you to search for.$B$B<Parqual slowly caresses his hand over the top of the book as he stares down at it.>$B$BSo now you wish a question to prove your mind is as powerful as your body and spirit. If you have studied the book long enough, then I shall ask you your question and you can be done with these tests!' WHERE `entry`=1160;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=1191;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=6, `OfferRewardEmote2`=1, `OfferRewardEmote3`=1, `OfferRewardText`='Indurium? Interesting... If it is capable of resisting heat to the degree that you say, it would explain the performance increase the gnomes have displayed of late.$b$bThis sample you\'ve brought to me will be invaluable, also. I will be able to perform some tests on this, but I\'ll need more for this to actually be of any use to us.' WHERE `entry`=1194;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=36, `OfferRewardText`='He is dead! Khan Hratha is dead! And now the Maraudine will fall! When the Gelkis rule this land, $N, we will remember you. And the spirits of the earth will sing your name for all time.' WHERE `entry`=1380;
|
|
UPDATE `quest_template` SET `OfferRewardText`='What do you want, $g laddy:missy;? Can\'t you see I\'ve got problems to take care of here? Who has time to stand around yapping with some $r chatterbox?$b$bThere are trolls coming out of the woodwork! Make it snappy.' WHERE `entry`=1449;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Andromath sent you? Very good. I have an important task for you...' WHERE `entry`=1477;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='So you\'re an engineer, eh? Well, for your help in getting me those pearls, here\'s the recipe for flash bombs.$B$BGood luck, and try not to blind yourself!' WHERE `entry`=1559;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardEmote2`=0 WHERE `entry`=1715;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardText`='Hmmm, now this is interesting. You\'ve more than proved your worth with this, $N. I am quite impressed. Consider yourself the newest member of the Shattered Hand. And take this, it will be a great help to you in the future, I think.' WHERE `entry`=1858;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=1859;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=1961;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=2 WHERE `entry`=1962;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1 WHERE `entry`=1963;
|
|
UPDATE `quest_template` SET `OfferRewardEmoteDelay2`=800, `OfferRewardText`='I am astonished... Astonished that Keryn finally found a recruit that could possibly have the makings of a proper rogue. Take this blade, $N. A day will come when you will be called upon again to serve the SI:7. Hone your skills, keep your eyes open and that blade sharp.$B$BYou won\'t see us coming but you\'ll feel it when we get there...' WHERE `entry`=2206;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardEmote3`=1, `OfferRewardText`='Fine work, $N. Here is one sample of the assay for you and the remaining nine will be used in my research.$B$BAnytime you require more of the ground scorpok assay, return to me and we shall work out a deal. ' WHERE `entry`=2586;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=2750;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Ah, you want to help me? Great!$B$BThere\'s a part I want for an experiment I\'m working on, and I need a brave $c like you to help me get it!' WHERE `entry`=2769;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=0, `OfferRewardEmote3`=0 WHERE `entry`=2821;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0 WHERE `entry`=2844;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardEmote2`=0, `OfferRewardText`='Welcome back, $n. Your report on this gazebo is most... disturbing. It would seem that even if the naga there were not planning on an attack, their continued presence bodes ill for our push into Feralas. At any rate, here is compensation for your investigation.$B$BIt would seem that Feathermoon Stronghold is in dire need of additional assistance concerning the Hatecrest naga. I\'d like to offer you the task, if you are so inclined. There is much to do.' WHERE `entry`=2867;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=0, `OfferRewardEmote3`=0 WHERE `entry`=2869;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=0, `OfferRewardEmote3`=0, `OfferRewardText`='Well played, $n! Lord Shalzaru\'s demise will throw the naga into disarray for some time, if not permanently. The threat they pose is now under more of our control than it has ever been, and we have you to thank for it.$B$BHere is more bounty money from the stronghold treasury - you\'ve earned every copper. You and yours are welcome in Feathermoon Stronghold anytime, my friend.$B$BOne more thing before you depart, $n... if you could...' WHERE `entry`=2870;
|
|
UPDATE `quest_template` SET `OfferRewardEmote3`=0, `OfferRewardEmoteDelay2`=2500 WHERE `entry`=2871;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You apply some Cenarion plant salve to the songflower. It immediately begins to shed its corrupted form, blossoming into a vibrant and healthy plant.' WHERE `entry`=2878;
|
|
UPDATE `quest_template` SET `OfferRewardText`='I like to think that the last thing that went through his head as he collapsed to the ground was your foot, $r. With Thermaplugg dead, our plans to retake Gnomeregan are one step closer to becoming a reality.\n' WHERE `entry`=2929;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Oh, so Troyas Moonbreeze sent you?$B$B<mutters>...always bothering me with his wild notions that he found something important...$B$BLook, $N, I\'ll be blunt. Troyas always thinks he has found something important in those ruins. The truth is, anything that was truly valuable was probably hoarded away long ago by the ogres or the harpies that now reside there.$B$BYou\'re welcome to take a look around, but I don\'t know if you\'ll find any books here that will help you.' WHERE `entry`=2939;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=0, `OfferRewardText`='So, you\'d like to borrow Feralas: A History?$B$BLet me think...$B$BI will allow you to borrow this book, $N, but only if you do something for me first.' WHERE `entry`=2940;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=4, `OfferRewardEmoteDelay2`=200, `OfferRewardText`='Are you another one of Daryn\'s interns? She\'s quite a knowledgeable historian, $N. You should be grateful to be studying under her leadership.$B$BNow, let me get the Super Snapper FX. You\'re gonna love it!' WHERE `entry`=2941;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=2, `OfferRewardEmote3`=0, `OfferRewardEmoteDelay2`=300 WHERE `entry`=2942;
|
|
UPDATE `quest_template` SET `OfferRewardText`='The Sparklematic 5200 comes to life, lurching to and fro. Inside, the helpless grime that has encrusted the object placed within it is being pulverized by the machine\'s gnomish cleaning agent.$B$BThe Sparklematic 5200 comes to a halt, heralded by a familiar \"ding!\" The item receptacle of the machine spirals open, revealing a neatly wrapped box.' WHERE `entry`=2953;
|
|
UPDATE `quest_template` SET `OfferRewardEmote3`=1 WHERE `entry`=2969;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardEmote3`=1 WHERE `entry`=2970;
|
|
UPDATE `quest_template` SET `OfferRewardEmote3`=1, `OfferRewardEmote4`=2 WHERE `entry`=2972;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0 WHERE `entry`=2982;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=1, `OfferRewardText`='As ya test yeself, ya\'ll find ya have better an\' better control o\'er da spirits--ya\'ll be callin\' on dem fer greata an\' greata tings... dat\'s where ol\' Ken\'jai come in. You come talk to ole Ken\'jai when ya feel yer ready. If da spirits agree, den we see \'bout teachin\' ya more powerful abilities... but only if da spirits agree.$B$BGo now, talk to da rest of da Valley\'s people. Speak to me again later.' WHERE `entry`=3085;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1 WHERE `entry`=3096;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=1, `OfferRewardEmote3`=1, `OfferRewardText`='You must return to me often if you are to become powerful enough to destroy those who would oppose us. The rules of magic still apply to you, $N. You will still find corruption follows you like hungry wolves in the night. You will find its caress is not unlike an addiction, an old lover still wanting to be by your side. But these things can be staved off. These things will only control you if you allow them to.$B$BGo now, return to me when you\'ve grown more powerful.' WHERE `entry`=3098;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardEmote2`=0, `OfferRewardText`='Excellent, $n - I value a \"can do\" attitude in those who I work with.$B$BI\'ve been tasked by General Feathermoon to address the naga in a direct manner. My plans are two fold: one, we will weaken their forces both in number and in command, and two, we will uncover what they are up to in the ruins. With your help, we\'ll counter the naga presence without sacrificing the general security of the stronghold.' WHERE `entry`=3130;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Ah, what is this? This shell has an inner glow, as if it still pulses with life. Amazing! I must study it further.$B$BThank you, $N. With luck, this shell will hold a secret I can use to aid the poor land of Silverpine.' WHERE `entry`=3301;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Would you like to see the view atop one of the twin colossals? I can send you there, $r.$B$BDo consider how you will get down, though. This is a one way trip only.' WHERE `entry`=3567;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardEmote2`=0, `OfferRewardText`='Well $N, you were wise to seek my tutelage! Any schlep can become an expert at the basics of engineering - the gnomes and their irradiated home of Gnomeregan are proof of that. It takes a strong mind and a steady hand (emphasis on STEADY) though to master the discipline of Goblin Engineering.$B$BKeep your ears perked $N, and you might learn something.' WHERE `entry`=3633;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=0, `OfferRewardText`='Welcome aboard, Goblin Engineer $N! You soon will have access to the most powerful engineering schemata anywhere on Azeroth.$B$BNow that you have committed yourself to the pursuit of this knowledge, it is time to examine your goblin-oriented engineering work. From there, we\'ll help you build a plan to maximize your goblin engineering talents!' WHERE `entry`=3638;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardText`='Here is your first Goblin Engineer Membership Card!$B$BThis card has its dues paid for in advance for fourteen days; all cards expire after two weeks of activity. When it does, pay your next set of dues to any goblin engineer trainer in order to get another card; without the card, your membership will temporarily lapse and you cannot access new schemata.$B$BThis never affects what you already know; once a goblin engineer, always a goblin engineer.' WHERE `entry`=3639;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardEmote2`=0 WHERE `entry`=3791;
|
|
UPDATE `quest_template` SET `OfferRewardEmote3`=0 WHERE `entry`=3841;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1 WHERE `entry`=3842;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardEmote3`=1 WHERE `entry`=4023;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardEmote3`=5, `OfferRewardEmote4`=1 WHERE `entry`=4081;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You apply some Cenarion plant salve to the songflower. It immediately begins to shed its corrupted form, blossoming into a vibrant and healthy plant.' WHERE `entry`=4113;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You apply some Cenarion plant salve to the songflower. It immediately begins to shed its corrupted form, blossoming into a vibrant and healthy plant.' WHERE `entry`=4116;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Can you not see the power we gain by joining the legion of Blackrock? \n' WHERE `entry`=4122;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=0 WHERE `entry`=4124;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=0, `OfferRewardEmote3`=0 WHERE `entry`=4127;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=0 WHERE `entry`=4130;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=4261;
|
|
UPDATE `quest_template` SET `OfferRewardEmote3`=0 WHERE `entry`=4265;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=0 WHERE `entry`=4266;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardEmote3`=0, `OfferRewardEmote4`=0, `OfferRewardText`='Elune be praised, the delivery from Feathermoon Stronghold has finally arrived!$B$BYour presence here indicates to me that perhaps some ill fate may have befallen Raschal, our usual courier. I hope that everything works out. I know that recently, the Woodpaw have become highly agitated from some source to their south. Maybe he fell to the wilds there; I would be careful, friend.$B$BRegardless, thank you again. Here is payment for this parcel\'s delivery.' WHERE `entry`=4281;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardEmote2`=0, `OfferRewardEmote3`=0, `OfferRewardText`='These\'ll do nicely, and if I\'m not mistaken, your little egg\'s just about ready to hatch. How does it feel? You know, you about to be a $g father:mother;? Haha, didn\'t think ya\'d have to deal with such responsibility, now did ya?' WHERE `entry`=4297;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=11, `OfferRewardEmote3`=4, `OfferRewardText`='Here, take the egg... better you have it so it bonds to you and looks to you to be its $g dadda:momma;.$B$BCongrats, $N. You\'re a parent... kinda.' WHERE `entry`=4298;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You apply some Cenarion plant salve to the songflower. It immediately begins to shed its corrupted form, blossoming into a vibrant and healthy plant.' WHERE `entry`=4401;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You apply some Cenarion plant salve to the songflower. It immediately begins to shed its corrupted form, blossoming into a vibrant and healthy plant.' WHERE `entry`=4465;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=2, `OfferRewardEmote2`=1 WHERE `entry`=4487;
|
|
UPDATE `quest_template` SET `OfferRewardText`='The Sparklematic 5200 comes to life, lurching to and fro. Inside, the helpless grime that has encrusted the object placed within it is being pulverized by the machine\'s gnomish cleaning agent.$B$BThe Sparklematic 5200 comes to a halt, heralded by a familiar \"ding!\" The item receptacle of the machine spirals open, revealing a neatly wrapped box.' WHERE `entry`=4604;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You came from Stormwind? Wonderful -- I know of an object of art that Remington would kill to have in his museum, but extracting it won\'t be easy.$B$BThat\'s where you come in.' WHERE `entry`=4766;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=2 WHERE `entry`=4802;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardText`='Again, I think you for your assistance. Please accept this gift. While you still may not know when to use such an item, perhaps in the future the path of time will reveal its true intentions to you. You could say that I\'ve seen as such happening to you, $N.' WHERE `entry`=4973;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardText`='Very impressive, $N. You are ready to learn your aquatic form, and it is my pleasure to teach it to you.$B$BAlso, in recognition of your achievement during the two trials, I give you this item. I hope you\'ll find it to be a welcome addition to your gear as a protector of nature and a keeper of the balance.' WHERE `entry`=5061;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='You have the libram and the shield!$B$BTheir history is entwined with the history of Darrowshire, and somehow, I know that fate will bring them together again.' WHERE `entry`=5168;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='You found them! Wonderful!$B$BAlthough I don\'t fully understand how they can help us, I feel their power and I know in my bones that they are linked to my home village of Darrowshire.' WHERE `entry`=5206;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Well, here you are $N - the completed Skeleton Key. I am certain as I can be that this key will allow you within the confines of the Scholomance. There\'s only one way to be absolutely sure it works, though. Waste no time in trying it out, I say.$B$BGood luck, mighty hero. May you continue to bring light unto the darkness!' WHERE `entry`=5505;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Good, then Kor\'ja lives and goes off to defend our town from those malicious humans. I often wish to remember days of battle; where power was shown in combat and it was the wise who often destroyed those who relied on just their strength.$B$BYou done good by me, $N. You take this robe now. Maybe it help, maybe you not care, but you earned it and I\'m proud to call you $gbrother:sister;.' WHERE `entry`=5648;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=5652;
|
|
UPDATE `quest_template` SET `OfferRewardText`='We\'ve got quite the costly skeleton key there, don\'t we $N? Still, it remains unfinished; the time has now come to put some focus behind our creation. To that end, you\'re going to have to face the ultimate foe we\'ve been working towards facing in Andorhal... the nefarious being that runs the show within the ruined city walls.$B$BI\'m speaking of Araj the Summoner - a lich, and one of the most powerful beings the Scourge calls as its own.' WHERE `entry`=5801;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Yes, this is it! I... again, I\'m absolutely amazed at the depths of your heroism. It simply boggles the mind the lengths you are willing to go to achieve victory over the forces of darkness.$B$BAllow me now to play my small part in this. I\'ve prepared a special solvent that should allow me to secure the scarab on as the head of the key, infusing it with the power to breach the locked door of Scholomance.$B$BHere goes nothing...' WHERE `entry`=5803;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Well done! I\'ll put these supplies to good use! Thanks, $N!' WHERE `entry`=5892;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='\"And so it begins, Father Cenarius. And so it begins.\"$B$BDendrite makes a quick, invisible gesture in the air above him. A slight aura of power falls over him.$B$B\"The first perspective of nature you must adapt to is that of the bear. I will put you on the path to understanding this aspect of druidic life, but it is you that must embrace it and propagate it - now and forever!\"' WHERE `entry`=5921;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='I\'m glad you found your way here today, young druid. The time has come for you to take a large step into a much larger world.$B$BInside each of Cenarius\' children is the call to serve nature. Animals and plants are our friends as well as our charges. We choose to devote our lives as preservers of balance for their sakes as well as our own. Your first step into this world will be to learn of the ways of the bear, and to learn strength of body and heart.$B$BReady yourself!' WHERE `entry`=5923;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='I\'m glad you found your way here today, young druid. The time has come for you to take a large step into a much larger world.$B$BInside each of Cenarius\' children is the call to serve nature. Animals and plants are our friends as well as our charges. We choose to devote our lives as preservers of balance for their sakes as well as our own. Your first step into this world will be to learn of the ways of the bear, and to learn strength of body and heart.$B$BReady yourself!' WHERE `entry`=5925;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Dendrite makes another invisible gesture in the air above him as you approach. Another aura of power comes over him, and he smiles ever so slightly.$B$B\"I sense wisdom in you, young one, that was not present when we first met. You gaze upon me with strength and knowing intent, though this intent is yet not focused. You will now learn to focus your strength and adopt the nature of the bear into your work.\"' WHERE `entry`=5929;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Welcome back, $N. I sense that your first meeting with the Great Bear Spirit is the same as it is with all druids when they first start down the path of the Claw... a little bewildering, but very intense. I know it was that way with me.$B$BThe Great Bear Spirit has been a part of Azeroth as long as Azeroth has existed in the heavens. We have come to rely on its wisdom and its power to fuel our purpose. The time has now come for your first test of this purpose. Listen closely...' WHERE `entry`=5931;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Ah yes, there they are. Together they weave a powerful spell, one that will raise the spirits of Darrowshire.$B$BWith that spell, and with a little luck, we can save Joseph Redpath!' WHERE `entry`=5941;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardText`='You have finally taken your large step into a much larger world, $N. I sense the teaching of the Great Bear Spirit within you, and I sense that you have received the strength that Lunaclaw possessed.$B$BThere are no further obstacles in your way... let me now teach you what it means to be a Druid of the Claw!' WHERE `entry`=6001;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=2, `OfferRewardText`='Yes, I believe you are ready to be trained...' WHERE `entry`=6069;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=5, `OfferRewardText`='By Elune, this water is disgusting! No wonder the deer are sick.$B$BSomething is polluting the water, and in turn corrupting Darkshore\'s entire water table. Sick deer have been seen all over area, and not just by the river. While this water is most likely a primary source of the sickness spreading, there\'s something else at work here.$B$BThis water, believe it or not, will help us formulate a cure. While I research this water, I have need of some items to formulate a cure...' WHERE `entry`=6122;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardEmote2`=1, `OfferRewardText`='This is good, $N, so much so that it should be enough to make some ample doses of the salve - at least enough to start to make a difference.$B$BMaking a cure for poisons can be quite difficult at times because each one often requires a very specific antidote to counteract it. Imagine being able to cure a poison at will without having to worry about the exact ingredients of what the antidote must be!$B$BNow, let me get to work on this!' WHERE `entry`=6123;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=6124;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1 WHERE `entry`=6125;
|
|
UPDATE `quest_template` SET `OfferRewardEmote2`=1 WHERE `entry`=6628;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You have done well, $c. The corrupted elementals you cured were an outrage to all bodies of water. Our strength lies in our purity and if we are to win our war with the others, we must remain strong.' WHERE `entry`=6804;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardEmote2`=1 WHERE `entry`=7733;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote3`=0 WHERE `entry`=7735;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Wonderful! We thank you for your generous donation, $N!' WHERE `entry`=7798;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Wonderful! We thank you for your generous donation, $N!' WHERE `entry`=7817;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=5, `OfferRewardEmote2`=1 WHERE `entry`=8062;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=5, `OfferRewardEmote2`=1 WHERE `entry`=8066;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardEmote3`=1, `OfferRewardText`='Amongst the Zandalarians, the profession of hunter is revered. Our greatest hunters travel to the edge of the Maelstrom to prove their resolution.$B$BFrom the heart of the sea they pull strands of kelp known as Maelstrom Tendrils. The kelp is then woven into a talisman that is enchanted to improve their accuracy and power.$B$BI now grant you a single weaving of the Maelstrom\'s Tendril. As your bond with Zandalar grows, I shall weave more power into the talisman.' WHERE `entry`=8145;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Let them seek atonement at the end of your munitions.' WHERE `entry`=8146;
|
|
UPDATE `quest_template` SET `OfferRewardText`='It is no longer my purpose to hunt, but to teach the hunter. That is what fate has handed to me.$b$bCraft with me a hunter\'s charm -- a collection of trophies from fallen prey that will remind you of your past trials and triumphs. In the end I will keep the charm, but reward you with something else.' WHERE `entry`=8151;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=2 WHERE `entry`=8183;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Use it well, $c. Show the Hakkari no mercy!' WHERE `entry`=8187 && `patch`=9;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=2, `OfferRewardEmoteDelay2`=500 WHERE `entry`=8320;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='You\'ve done it! Vyral is killed! This can only mean doom for the Twilight Hammer\'s operations in Silithus. There may be more of them scurrying about, but the blow you dealt to the cult today is one from which they will not easily recover.' WHERE `entry`=8321;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='Wow! You are too kind. Especially for a warlock!$b$b<Impsy holds the felcloth to his face.>$b$bOh how I love the feel of it, the way it burns your skin and weaves evil thoughts through the mind...' WHERE `entry`=8420;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=2, `OfferRewardText`='Excellent! You\'ve shown your worth by defending our operations in Warsong Gulch! May word of your honor spread far and wide across our lands.' WHERE `entry`=8430;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Well done, $c! You\'ve helped ensure the Horde\'s ownership over Warsong Gulch!' WHERE `entry`=8435;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=5, `OfferRewardEmoteDelay2`=1000, `OfferRewardText`='Must be a cold day in the Burning Steppes. Look here, it\'s $N, and $g he\'s : she\'s; brought me a gift. Twenty iron bars! Just what I always wanted.$B$BIn all seriousness though, thank you, $N. You\'re a credit to yourself and the Alliance. Now get back out there and bring in more stuff for the war effort!' WHERE `entry`=8495;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=2, `OfferRewardEmote2`=1, `OfferRewardEmoteDelay2`=1000, `OfferRewardText`='I gladly accept your contribution on behalf of the Alliance, $N. Your efforts will directly lead to the creation of several potions and oils in support of our men and women in the field. Thank you, and should come across more, please consider returning to me.' WHERE `entry`=8506;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardEmoteDelay2`=1000, `OfferRewardText`='Good work, $c. I must say that I\'m pleasantly surprised. You would not believe the number of people that have come by, offering to help, but never returning. Let me just get those into a crate and tallied with your name on it, and then we can talk again about whether I need anymore of those plants.' WHERE `entry`=8509;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=4, `OfferRewardEmote2`=1, `OfferRewardEmoteDelay2`=1000, `OfferRewardText`='Simply outstanding, $N! You\'re a real credit to the Alliance. I\'ll make sure to get these herbs packed away until someone comes to make them into something useful for the war. Feel free to come back around anytime, especially if you have more Arthas\' Tears for me.' WHERE `entry`=8510;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardText`='You got my cutlass from Negolash! I can\'t believe my fortune, $N! Meeting you has turned my luck to the better, make no mistake there!$B$BThank you! And if I ever get a new ship and you\'re looking to sail the seas, you would be my honored guest.' WHERE `entry`=8554;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Ah, yes. Mux will be quite happy with this.$B$BThose bracers were part of a larger armor set. If you\'re interested in providing me with further assistance, I\'d be willing to consider parting with the rest of it.' WHERE `entry`=8915;
|
|
UPDATE `quest_template` SET `OfferRewardText`='Our agreement remains in place. Just remember, this is but a taste of what awaits you. Free me of this cursed fate and I will reward you with items of truly great power.' WHERE `entry`=8939;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardEmote2`=0, `OfferRewardText`='Thank you, $n. You are brave and wise.$b$bTell me, how did the devilsaur react to the toxin?' WHERE `entry`=9051;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardText`='The ingredients at last!$b$bWith the Un\'Goro soil I have collected, the toxin is easily concocted...' WHERE `entry`=9052;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=273, `OfferRewardEmote2`=1, `OfferRewardText`='As you don more of this armor, you will notice that your persona is changing. You will gain a preternatural ability for killing. Perhaps, even, a lust for blood.$B$BLet it be said that I will not be held responsible for what chaos you may invoke...' WHERE `entry`=9055;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardEmoteDelay2`=1000, `OfferRewardText`='Let the rage of the crypt fiend guide your hand, $N.' WHERE `entry`=9059;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardEmoteDelay2`=1000, `OfferRewardText`='A girdle fit for royalty! It\'s ready for you, $N.' WHERE `entry`=9060;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=0, `OfferRewardText`='You have traveled far to meet with me, $c, and not a moment too soon.' WHERE `entry`=9063;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardText`='A job well done, $N! As promised, the insignia is yours. Just remember, there\'s more where that came from...' WHERE `entry`=9128;
|
|
UPDATE `quest_template` SET `OfferRewardText`='You earned this, scrub. Now, don\'t cry about your orders. Fill \'em or destroy \'em.\n' WHERE `entry`=9142;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=6, `OfferRewardEmote2`=1, `OfferRewardText`='Thorium tubes? Gee, thanks.$B$B<Packmaster Stonebruiser throws the stack of thorium tubes into a large pile of assorted junk.>\n' WHERE `entry`=9198;
|
|
UPDATE `quest_template` SET `OfferRewardEmote1`=1, `OfferRewardEmote2`=1, `OfferRewardEmote3`=1, `OfferRewardText`='<Wilhelm wipes the sweat from his brow.>$B$BThat\'s some hard work! Enjoy the pants, $c. At least you\'ll die in a clean pair now.' WHERE `entry`=9232;
|
|
-- Correct quest request items.
|
|
UPDATE `quest_template` SET `RequestItemsText`='$n, now is no time for idle chatter. If you still wish to prove yourself to The People\'s Militia you need to slay the Defias I notified you about earlier. Return to me when you have completed your duty.' WHERE `entry`=14;
|
|
UPDATE `quest_template` SET `CompleteEmote`=25, `RequestItemsText`='Return to me once you have killed 15 Skeletal Fiends and 15 Skeletal Horrors, $n.' WHERE `entry`=57;
|
|
UPDATE `quest_template` SET `CompleteEmote`=25, `RequestItemsText`='I need your assistance, $N. Travel to the cemetery to the northwest and rid the eastern mausoleum of 20 Plague Spreaders.$b$bReturn to me when your task is complete.' WHERE `entry`=58;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=63;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=96;
|
|
UPDATE `quest_template` SET `RequestItemsText`='How goes your conflict with the shadowcasters? Did you find the midnight orbs?' WHERE `entry`=115;
|
|
UPDATE `quest_template` SET `RequestItemsText`='Yowler is a dangerous creature, $N. If you\'re not ready for him, I understand.' WHERE `entry`=126;
|
|
UPDATE `quest_template` SET `RequestItemsText`='What do you have there, $r?' WHERE `entry`=169;
|
|
UPDATE `quest_template` SET `RequestItemsText`='I showed Cog the beginnings of our star-viewing machine. He was impressed. Did you happen to find a reflective device?' WHERE `entry`=177;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='Do you have those fetishes, $N? They might hold the secret to Kurzen\'s degradation...I must know!' WHERE `entry`=205;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='I give you my blessing. Mai\'Zoth\'s strength is matched only by his evil.' WHERE `entry`=206;
|
|
UPDATE `quest_template` SET `CompleteEmote`=6, `RequestItemsText`='Your task has been given to you, $N. Do you have a shard from the lich\'s phylactery as proof of the task being accomplished?' WHERE `entry`=211;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='You\'d best be careful when dealing with the spiders, I\'ve lost a few of my men to them, and trust me, it isn\'t a pleasant sight to see a man hanging upside down in their webs after the venom has started to soften them up.$b$bI wouldn\'t want to see one of the bugs having you for lunch.' WHERE `entry`=245;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0 WHERE `entry`=249;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0 WHERE `entry`=255;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1, `RequestItemsText`='Have you formed your pendant for me to inspect, $N? If you need help in locating the parts, try asking the local populace for information. Not only will you find what you seek, but it will give you a reason to explore this wondrous and sacred glade.' WHERE `entry`=272;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0, `RequestItemsText`='Battle hard, $N. And do not despair, for despair is evil\'s greatest weapon.' WHERE `entry`=323;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='Greetings and welcome, $gmaster:madam;. Have you yet tried one of our fine wines?' WHERE `entry`=332;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=334;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=356;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='I see you have returned but your task is not complete. Perhaps you are at ease with the mere humans interfering with The Dark Lady\'s plan? Or perhaps you can heed the call of duty and slay Captain Vachon and his band of Scarlet Friars!' WHERE `entry`=371;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='Baron Vardus cannot think Southshore will allow him to send his thugs against us with impunity. I want his head!' WHERE `entry`=523;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0, `RequestItemsText`='$N, you\'ve returned! How did your foray into Alterac go? Did you bring anything back with you?' WHERE `entry`=542;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='The trolls truly possessed some amazing magical objects, $n. And now, perhaps, I have the opportunity to add one to my extensive collection. Did you have any luck finding the source of the rumor?' WHERE `entry`=578;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='$N. Kin\'weelay told me you set out to capture Yenniku.$B$BIs it true? Do you have him?' WHERE `entry`=592;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=593;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=619;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6 WHERE `entry`=623;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='$n! Do you have the second sigil?' WHERE `entry`=641;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='Valorcall will not be easy to track down, $n. Mounted on horseback, he can cover ground quickly. Nonetheless, we must have his sigil.' WHERE `entry`=643;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='You\'ve returned, $n. Is the line of Ignaeus Trollbane broken?' WHERE `entry`=644;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=645;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='$n! Have you taken the sword?' WHERE `entry`=646;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='The nomadic band of ogres travels between their camps across the Badlands; heat rising from the dry earth and the swirling winds will make it difficult to track their progress. I have heard that sometimes they travel through Camp Boff. If you are lost, you might try your search there.' WHERE `entry`=732;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6 WHERE `entry`=898;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='The Demon Seed still exists. I can sense its power...' WHERE `entry`=924;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=1065;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0 WHERE `entry`=1101;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Ya have the sapta, $g brotha:sista;?$B$BI know another that had trouble after defeating da corrupt water spirit--seems he waited too long and he came out of the spirit world too quick fer his taste. Hate to see dat happen to another, so I\'ll just wait here fer a bit to make sure no one else be needin\' me help.' WHERE `entry`=1103;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='Did you find Highperch, $N? Any luck with the wyverns there?' WHERE `entry`=1135;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1, `RequestItemsText`='I hope you made the Scarlet Crusade suffer some before stealing the book from them.$B$BMy views of their kind are not unwarranted. The Crusade may have been followers of the Light at one time, but now, they seek to destroy any creatures that have not sided with their religion. They believe all undead, Forsaken or otherwise, must be cleansed, and those traveling in their lands must either be insane, or subject to the undead\'s powerful magics. Idiots. Idiots and fools; all of them.' WHERE `entry`=1160;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=1249;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=2, `CompleteEmote`=2 WHERE `entry`=1324;
|
|
UPDATE `quest_template` SET `RequestItemsText`='You have found a sickly, corrupted version of what appears to be a windblossom plant. The berries that hang from the plant appear rotten and poisonous. It desperately needs some sort of attention if it is to be turned back to normal.' WHERE `entry`=1514;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=1858;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=1961;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1 WHERE `entry`=1963;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0, `RequestItemsText`='Your mortality wanes with every moment you waste loitering in the barracks, $c. ' WHERE `entry`=2206;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=2586;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=2681;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=25, `CompleteEmote`=25 WHERE `entry`=2821;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=2845;
|
|
UPDATE `quest_template` SET `RequestItemsText`='$n, if you\'re here to verify the task given to you, then excellent - it is ten Hatecrest scales I seek. If you are here for chit-chat, then I am currently unavailable for such trivialities.$B$BKnow this - we night elves are not warmongers. Our race is dedicated to the preservation of peace and harmony. This does not mean, however, that we will not proactively protect our own interests. This is my duty to General Feathermoon, and to the stronghold.' WHERE `entry`=2869;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=5, `CompleteEmote`=5, `RequestItemsText`='Bringing down Lord Shalzaru would certainly set their plans back weeks, if not months. On top of that, the relic he uncovered is of definite interest to us.$B$BHave you performed the mission given to you, $n?' WHERE `entry`=2870;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Yes, may I assist you?$B$BHold on, you\'re the $c that has been helping General Feathermoon and Latro out with the naga threat, yes? I\'m Vestia, Latro\'s - erm, rather, Latronicus\' wife. It is a pleasure to meet you!$B$BI\'m sorry, you\'re here on business, of course. Do you have something for me - from him, perchance?' WHERE `entry`=2871;
|
|
UPDATE `quest_template` SET `RequestItemsText`='You have found a sickly, corrupted version of what appears to be a songflower plant. A pungent, unhealthy odor emanates from the plant. It desperately needs some sort of attention if it is to be turned back to normal.' WHERE `entry`=2878;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=2879;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=5 WHERE `entry`=2926;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=2941;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0 WHERE `entry`=2942;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=2945;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=5 WHERE `entry`=2947;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6 WHERE `entry`=2948;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=2953;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=2, `CompleteEmote`=2 WHERE `entry`=2972;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0 WHERE `entry`=2982;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='Have you searched the cages, $N? We must find Sharpbeak!' WHERE `entry`=2988;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=2989;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=2994;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=2 WHERE `entry`=3085;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6 WHERE `entry`=3096;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1 WHERE `entry`=3098;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='I can smell the dust of the Barrens on you, $c. You have traveled far.' WHERE `entry`=3301;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=25, `CompleteEmote`=25, `RequestItemsText`='I can smell fresh recruits much like I can an excellent blasting powder - from a mile away. Have you come seeking to learn about the mastery of the explosion?' WHERE `entry`=3633;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1, `CompleteEmote`=1, `RequestItemsText`='If you\'ve signed the document and are ready to hand it to me, then that is that. You\'ve been told that this is a one way trip. If you\'re ready, then hop on board!' WHERE `entry`=3638;
|
|
UPDATE `quest_template` SET `RequestItemsText`='Once I receive your crafted engineering items for my review, I will hand you a genuine Goblin Engineer Membership Card! So long as the card is valid, you will have unlimited access to any goblin engineer trainer anywhere in the world.' WHERE `entry`=3639;
|
|
UPDATE `quest_template` SET `RequestItemsText`='Hello again, $N. My research is progressing fairly well, but if you have five more Morrowgrain I\'d be happy to take them off your hands. Well... happy is a figurative term in this case; the more I am around them, the more uncomfortable I feel. Still, my research demands I buckle down and get through this.' WHERE `entry`=3792;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=2, `CompleteEmote`=2, `RequestItemsText`='Why hello, $c.$B$BDon\'t let my location fool you, I\'m really not here for the races... as entertaining as they may be.$B$BI\'m actually here in Thousand Needles investigating all I can to find out how salvageable the land is. It has become my crusade of sorts to revitalize and replenish the area with new, fertile soil. Perhaps I\'ll find there\'s a water source nearby.$B$BTell me you haven\'t noticed how odd the transition between Feralas and Thousand Needles is. Strange magic was afoot when that happened.' WHERE `entry`=3841;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6 WHERE `entry`=3843;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1 WHERE `entry`=3906;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=15, `CompleteEmote`=15 WHERE `entry`=4023;
|
|
UPDATE `quest_template` SET `RequestItemsText`='You have found a sickly, corrupted version of what appears to be a songflower plant. A pungent, unhealthy odor emanates from the plant. It desperately needs some sort of attention if it is to be turned back to normal.' WHERE `entry`=4116;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1, `CompleteEmote`=1 WHERE `entry`=4127;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6 WHERE `entry`=4129;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=4185;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=4262;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='Welcome to Thalanaar, $c. Do you need assistance of some sort?' WHERE `entry`=4281;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1 WHERE `entry`=4512;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1 WHERE `entry`=4513;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=4604;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6 WHERE `entry`=4734;
|
|
UPDATE `quest_template` SET `RequestItemsText`='Yes, $N? Have you chosen? Infernal or felhound?$B$BEach choice is personal and should reflect your strengths and weaknesses. It is not unheard of for a warlock to enhance themselves further instead of making up in areas they lack. Sometimes overpowering an enemy is just as strong a tactic than becoming a more balanced spell caster.' WHERE `entry`=4963;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1 WHERE `entry`=5061;
|
|
UPDATE `quest_template` SET `CompleteEmote`=6, `RequestItemsText`='Do you have the skulls? Chromie said they will be critical for her spell, and that spell will give us the chance to save Darrowshire.' WHERE `entry`=5206;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `RequestItemsText`='Do you have the stem of the skeletal key finished? I\'m sorry you had to bear the brunt of the fee to purchase the mold, but we must all do our part to counter the Scourge. Once you hand me the unfinished key, you\'ll be ready for the final item needed to complete its construction.$B$BIt won\'t be easy at all, but the work you\'ve done to date in preparing for an assault on Andorhal will now start to pay for itself. You\'ll see.' WHERE `entry`=5801;
|
|
UPDATE `quest_template` SET `RequestItemsText`='You\'ve come this far $N - only the destruction of the physical form of Araj the Summoner will provide us with the means to finish the key. Get Araj\'s scarab by whatever means necessary and bring it to me - I will fuse it on as the head of the key.' WHERE `entry`=5803;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1, `RequestItemsText`='A Cenarion beacon allows a seasoned herbalist to spot insidious fel creep - a malfeasant product of Felwood\'s corruption. My work here has taught me the knowledge of purifying fel creep into a cleansing reagent... used in what we now refer to as Cenarion plant salve.$B$BWhen you gather herbs in Felwood, you should encounter the fel creep so long as you have the beacon. In exchange for what you bring to me, I will give you pre-made Cenarion plant salve.' WHERE `entry`=5884;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1, `RequestItemsText`='Do you have the supplies, $N? We can never have enough! ' WHERE `entry`=5892;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=25, `CompleteEmote`=25 WHERE `entry`=5929;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='I have been in contact with your friend Carlin. He feels great pain for the doom of his village, but he speaks very highly of you and knows that you can set things right.$B$BOh, but I\'m drifting from the subject at hand... $N, do you have the relics I asked for?' WHERE `entry`=5941;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=6001;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='You\'re the one that the Cenarion Circle in Moonglade sent? That\'s wonderful! We\'ve quite the crisis our hands here regarding the poor deer, and we\'re happy for all the help we can get.$B$BDo you have the sample of water that Dendrite Starblaze said you\'d have? He notified me that you\'d draw one so we could work on a cure together...' WHERE `entry`=6122;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Have you got the reagents I need to make the salve? The deer aren\'t getting any better on their own, so we better hurry to help them out!' WHERE `entry`=6123;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Have you completed what was asked of you by Alanndarian Nightsong of Auberdine? Your work is not complete unless it is.' WHERE `entry`=6124;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=6805;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='Did you enter the Coldtooth mine in Horde territory, $N? Did you raid their supplies?' WHERE `entry`=6982;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=5, `CompleteEmote`=5, `RequestItemsText`='$N, you have not yet assaulted a graveyard. Return to me when this task is complete!' WHERE `entry`=7081;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0, `RequestItemsText`='You haven\'t yet assaulted a tower, $N! What are you waiting for?' WHERE `entry`=7102;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=7122;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0 WHERE `entry`=7488;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6 WHERE `entry`=7735;
|
|
UPDATE `quest_template` SET `RequestItemsText`='As with most other fabrics, our stocks of silk are at an all-time low. Our stores are such that we\'d only need sixty pieces of silk from you total; we should be able to reach our goal with the support of others.$B$BA benevolent gift such as silk, might I add, would certainly increase your local standing in the community! If you have the sixty pieces of silk cloth on you and are ready to donate them, I\'m able to take them from you now.' WHERE `entry`=7798;
|
|
UPDATE `quest_template` SET `RequestItemsText`='We are currently accepting donations for wool cloth. A donation of sixty pieces of wool cloth will net you full recognition by the Gnomeregan Exiles for your generous actions. Our stores are such on wool that we would only need sixty pieces from you total; we should be able to acquire enough from others in the realm to support our drive.$B$BIf you have the sixty pieces of wool cloth on you and are ready to donate them, I\'m able to take them from you now.' WHERE `entry`=7807;
|
|
UPDATE `quest_template` SET `RequestItemsText`='As with most other fabrics, our stocks of silk are at an all-time low. Our stores are such that we\'d only need sixty pieces of silk from you total; we should be able to reach our goal with the support of others.$B$BA benevolent gift such as silk, might I add, would certainly increase your local standing in the community! If you have the sixty pieces of silk cloth on you and are ready to donate them, I\'m able to take them from you now.' WHERE `entry`=7814;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6 WHERE `entry`=8062;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6 WHERE `entry`=8066;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=1, `RequestItemsText`='Ah, $N, it is good to smell you again.$B$B<Falthir grins.>$B$BYou\'ll have to excuse my sense of humor. It can be most foul at times.$B$BI sense that you have caused great anguish to our enemies. The forces of Hakkar cry out your name in anger. This is most excellent.$B$BYou have earned another weave on your talisman. Hand it to me.' WHERE `entry`=8146;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=8183;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=5, `CompleteEmote`=5, `RequestItemsText`='Zanza can create the ancient troll enchantments with the right components.$B$BThe first is a primal Hakkari idol that must be taken from the most powerful of the Hakkari lieutenants: Jin\'do and the Bloodlord.$B$BThe second is a punctured voodoo doll. These can be found in the piles of refuse that litter this foul place. Look inside the jinxed hoodoo piles.$B$BBring me these things and I will create a powerful enchantment for you!\n' WHERE `entry`=8187 && `patch`=9;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=8281;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=5, `CompleteEmote`=5, `RequestItemsText`='Enter the desert and find the Twilight geolords, $N. Return to me after they are slain.' WHERE `entry`=8320;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6 WHERE `entry`=8321;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6 WHERE `entry`=8420;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Ok, so it looks like I still need more Arthas\' Tears, $c. I would imagine that you will be able to find them in the general location that you gathered them up last time. The war effort is coming along nicely, but the quicker we get these, the faster we can start up the offensive against the forces at Ahn\'Qiraj.$B$BYou gonna help us out again, $N?' WHERE `entry`=8510;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=8554;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=8915;
|
|
UPDATE `quest_template` SET `CompleteEmote`=0 WHERE `entry`=8939;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0 WHERE `entry`=9051;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0 WHERE `entry`=9052;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=0, `CompleteEmote`=0 WHERE `entry`=9053;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Do you have the items I asked for, $c?' WHERE `entry`=9055;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Do you have the items I asked for, $c?' WHERE `entry`=9059;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Do you have the items I asked for, $c?' WHERE `entry`=9060;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Filling a work order, $c?' WHERE `entry`=9198;
|
|
UPDATE `quest_template` SET `IncompleteEmote`=6, `CompleteEmote`=6, `RequestItemsText`='Filling a work order, $c?' WHERE `entry`=9200;
|
|
UPDATE `quest_template` SET `RequestItemsText`='They must be fools to think that we would allow them to establish bases so close to one of our capitals.$b$bWe will bleed their numbers until they turn tail and retreat back to the south.' WHERE `entry`=9665;
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|