All pastes #582406 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-06-21 23:22 UTC
rendered paste body
-- Search for Thruth Quest
-- Remove quest & rewards if there

delete from creature_questrelation where (quest='1000199');  
delete from creature_questrelation where (quest='1000299'); 
delete from creature_questrelation where (quest='1000399'); 
delete from creature_questrelation where (quest='1000499'); 
delete from creature_questrelation where (quest='1000599'); 
delete from quest_template where (entry='1000199'); 
delete from quest_template where (entry='1000299');
delete from quest_template where (entry='1000399');
delete from quest_template where (entry='1000499');
delete from quest_template where (entry='1000599');
delete from creature_involvedrelation where (quest='1000599');
delete from creature_involvedrelation where (quest='1000499');
delete from creature_involvedrelation where (quest='1000399');
delete from creature_involvedrelation where (quest='1000299');
delete from creature_involvedrelation where (quest='1000199');
delete from item_template where (entry='39999');
delete from item_template where (entry='1139999');
delete from item_template where (entry='1239999');
delete from item_template where (entry='1339999');

-- Add quest & rewards to database

insert into creature_questrelation (id,quest) VALUES ('1365','1000199');
insert into creature_questrelation (id,quest) VALUES ('1365','1000299');
insert into creature_involvedrelation (id,quest) VALUES ('1365','1000199');
insert into quest_template (entry,MinLevel,QuestLevel,SpecialFlags,NextQuestId,Title,Details,Objectives,ObjectiveText1,ObjectiveText2,ObjectiveText3,ObjectiveText4,ReqCreatureOrGOId1,ReqCreatureOrGOId2,ReqCreatureOrGOId3,ReqCreatureOrGOId4,ReqCreatureOrGOCount1,ReqCreatureOrGOCount2,ReqCreatureOrGOCount3,ReqCreatureOrGOCount4,RewOrReqMoney,RewXPOrMoney) VALUES ('1000199','40','60','1','1000299','Search For Thruth Part One','Now that you have some power its time for you to learn the thruth $n .  Before you can be shown the thruth you need to prove your worth.  Go hunting in Loch Modan and kill 40 Mangy Boars and find the filthy horde and wipe them out and return back Iron Forge and report your progress to me.','','Kill 40 Mangy Boars','Kill Haren Swifthoof','Kill Thragomm','Kill Gradok','3023','2478','7170','2477','40','1','1','1','10000','2000');
insert  into quest_template values
(1000299,1537,0,0,40,60,0,0,1,0,0,0,0,1,1000199,1000399,0,0,0,'Search For Thruth Part Two','Travel to Stormwind and visit the the holy people there for your next part','Travel to the holy place in Stormwind.',NULL,NULL,NULL,'Find a holy man in Stormwind',NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0);
update quest_template set Title='Search For Thruth Part Two' where (entry='1000299');
update quest_template set PrevQuestId='1000199' where (entry='1000299');
insert into creature_involvedrelation (id,quest) VALUES ('1212','1000299');
insert into creature_questrelation (id,quest) VALUES ('1212','1000299');
update creature_template set npcflag='2' where (entry='1365');
update quest_template set SpecialFlags='0' where (entry='1000299');
update quest_template set Objectives='Travel to Loch Modan kill 40 Mangy Boars and kill the Horde and then report your progress to me.' where (entry='1000199');
update quest_template set Objectives='Travel to the holy place in Stormwind.' where (entry='1000299');
update quest_template set Details='Now that you have some power its time for you to learn the thruth $n . Before you can be shown the thruth you need to prove your worth. Go hunting in Loch Modan and kill 40 Mangy Boars and find the filthy horde and wipe them out and return back Iron Forge and report your progress to me.' where (entry='1000199');
update quest_template set MinLevel='40',QuestLevel='60' where (entry='1000299');
update quest_template set SpecialFlags='8' where (entry='1000199');
update quest_template set ReqCreatureOrGOId1='1191' where (entry='1000199');
update quest_template set `Type`='0' where (entry='1000199');
update quest_template set `Type`='0' where (entry='1000299'); 
update quest_template set `Type`='0' where (entry='1000399'); 
update quest_template set MinLevel='40',QuestLevel='60' where (entry='1000299');
update quest_template set OfferRewardText='You have done well $n' where (entry='1000199');
update quest_template set Title='Search for Thruth Part Three' where (entry='1000399');
insert into creature_questrelation (id,quest) VALUES ('1212','1000399');
insert into quest_template (entry,MinLevel,QuestLevel,SpecialFlags,PrevQuestId,NextQuestId,Title,Details,Objectives,ObjectiveText1,ObjectiveText2,ReqCreatureOrGOId1,ReqCreatureOrGOId2,ReqCreatureOrGOCount1,ReqCreatureOrGOCount2,RewOrReqMoney,RewXPOrMoney) VALUES ('1000399','40','60','8','1000299','1000499','Search for Thruth Parth Three','Now its time for you to Really prove your worth $n , travel to Azshara and find the Highborne, kill 10 Lichling and 10 Apparitions and return to me.','Travel to Azshara and find the Highborne, kill 10 Lichling and 10 Apparitions and return to me.','Kill 10 Highborne Lichlings','Kill 10 Highborne Apparitions','6117','6116','10','10','10000','2500');
update quest_template set PrevQuestId='1000199',NextQuestId='1000399' where (entry='1000299');
insert into creature_involvedrelation (id,quest) VALUES ('1212','1000399');
update quest_template set SpecialFlags='1' where (entry='1000299');
update quest_template set ObjectiveText1='Find a holy man in Stormwind' where (entry='1000299');
update quest_template set ZoneOrSort='1537' where (entry='1000199');
update quest_template set ZoneOrSort='1537' where (entry='1000299');
update quest_template set ZoneOrSort='1537' where (entry='1000399');
insert into quest_template (entry,ZoneOrSort,MinLevel,QuestLevel,PrevQuestId,NextQuestId,Title,Details,Objectives,ObjectiveText1,ObjectiveText2,ObjectiveText3,ObjectiveText4,ReqCreatureOrGOId1,ReqCreatureOrGOId2,ReqCreatureOrGOId3,ReqCreatureOrGOId4,ReqCreatureOrGOCount1,ReqCreatureOrGOCount2,ReqCreatureOrGOCount3,ReqCreatureOrGOCount4,RewOrReqMoney,RewXPOrMoney) VALUES ('1000499','1537','40','60','1000399','1000599','Search for Thruth Part Four','So far so good $n , you have done well.  Now comes a REAL test you need to venture into Zul Farrak and the Scarlet Monastery and kill Herod, Inquisitor Whitemane, Gahz Rilla and The Executioner.  Once you have completed your task go speak to Priestess Amoora in Darnassus.','kill Herod, Inquisitor Whitemane, Gahz Rilla and The Executioner and then speak to Priestess Amoora in Darnassus.','Kill Gahz Rilla','Kill Executioner','Kill Herod','Kill Inquisitor Whitemane','7273','7274','3975','3977','1','1','1','1','20000','10000');
update quest_template set SpecialFlags='8' where (entry='1000499');
insert into creature_questrelation (id,quest) VALUES ('1212','1000499');
insert into creature_questrelation (id,quest) VALUES ('6348','1000599');
insert into quest_template (entry,ZoneOrSort,MinLevel,QuestLevel,PrevQuestId,NextQuestId,Title,Details,RewXPOrMoney) VALUES ('1000599','1537','40','60','1000499','0','Search for Thruth Part Four','I am well impressed with your skills $n .  Please come visit me again when you reach level 50 or higher and we can continue your quest for truth.','250');
update creature_involvedrelation set id='7313' where (id='6348') and (quest='1000499');
update creature_involvedrelation set id='7313' where (id='6348') and (quest='1000599');
update creature_questrelation set id='7313' where (id='6348') and (quest='1000599'); 
update quest_template set RewChoiceItemId1='39999' where (entry='1000599');
update quest_template set RewChoiceItemCount1='1' where (entry='1000599');
update quest_template set RewItemId1='39999' where (entry='1000599');
update quest_template set RewItemCount1='1' where (entry='1000599');
update quest_template set RewXPOrMoney='25000' where (entry='1000599');
update quest_template set Title='Search for Thruth Part Five' where (entry='1000599');
update quest_template set Details='I am well impressed with your skills $n .  Its time for me to reward you, please take this sword and use it to upload help thruth!' where (entry='1000599');
insert  into item_template values 
(39999, 2, 7, -1, 'The Sword of a Thousand Truths', 'The Sword of a Thousand Truths', 'The Sword of a Thousand Truths', 'The Sword of a Thousand Truths', 35575, 4, 0, 1, 1500000, 500000, 13, -1, -1, 70, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '197', '296', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 2800, 0, '0', 10876, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used to kill those who have no life', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'internalitemhandler', 6604),
(1139999, 2, 10, -1, 'The Staff of a Thousand Truths', 'The Staff of a Thousand Truths', 'The Staff of a Thousand Truths', 'The Staff of a Thousand Truths', 35575, 4, 0, 1, 1500000, 500000, 17, -1, -1, 70, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '197', '296', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 2800, 0, '0', 10876, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used to kill those who have no life', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'internalitemhandler', 6604),
(1239999, 2, 4, -1, 'The Mace of a Thousand Truths', 'The Mace of a Thousand Truths', 'The Mace of a Thousand Truths', 'The Mace of a Thousand Truths', 35575, 4, 0, 1, 1500000, 500000, 21, -1, -1, 70, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '197', '296', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 2800, 0, '0', 10876, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used to kill those who have no life', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'internalitemhandler', 6604),
(1339999, 2, 18, -1, 'The Bow of a Thousand Truths', 'The Bow of a Thousand Truths', 'The Bow of a Thousand Truths', 'The Bow of a Thousand Truths', 35575, 4, 0, 1, 1500000, 500000, 26, -1, -1, 70, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '197', '296', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 2800, 0, '0', 10876, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used to kill those who have no life', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'internalitemhandler', 6604);
update quest_template set RewChoiceItemId2='1139999',RewChoiceItemId3='1239999',RewChoiceItemId4='1339999',RewChoiceItemCount2='1',RewChoiceItemCount3='1',RewChoiceItemCount4='1' where (entry='1000599');
update quest_template set RewItemCount2='1',RewItemCount3='1',RewItemCount4='1' where (entry='1000599');
update quest_template set RewItemId2='1139999',RewItemId3='1239999',RewItemId4='1339999' where (entry='1000599');
update quest_template set NextQuestId='1000299' where (entry='1000199');
update quest_template set PrevQuestId='1000199',NextQuestId='1000399' where (entry='1000299');
update quest_template set PrevQuestId='1000299',NextQuestId='1000499' where (entry='1000399');
update quest_template set PrevQuestId='1000399',NextQuestId='1000599' where (entry='1000499');
update quest_template set PrevQuestId='1000499' where (entry='1000599');
insert into creature_involvedrelation (id,quest) VALUES ('7313','1000499');
update quest_template set RewItemId1='0',RewItemId2='0',RewItemId3='0',RewItemId4='0',RewItemCount1='0',RewItemCount2='0',RewItemCount3='0',RewItemCount4='0' where (entry='1000599');
update quest_template set SpecialFlags='1' where (entry='1000599');
update quest_template set OfferRewardText='Well done $n . Come back to see me when you are level 60 and i will have a gift for you.' where (entry='1000499');
update quest_template set OfferRewardText='Please choice an item and go uphold thruth young one.' where (entry='1000599');
update item_template set displayid='35634' where (entry='1139999');
update item_template set displayid='39581' where (entry='1239999');
update item_template set displayid='40859' where (entry='1339999');
update quest_template set ExclusiveGroup='0' where (entry='1000299');
update quest_template set NextQuestInChain='1000299' where (entry='1000199');
update quest_template set NextQuestInChain='1000499' where (entry='1000399');  
update quest_template set SrcItemCount='0' where (entry='1000299');
update quest_template set ExclusiveGroup='0' where (entry='1000299');
update quest_template set NextQuestInChain='1000599' where (entry='1000499');
update quest_template set `Type`='1' where (entry='1000599');
update quest_template set RequiredRepValue='0' where (entry='1000299');
update quest_template set SpecialFlags='8' where (entry='1000599');
update quest_template set RequiredRaces='0' where (entry='1000299');
update quest_template set SpecialFlags='1' where (entry='10005991');
update quest_template set `Type`='0' where (entry='1000599');
update quest_template set Objectives='Pick your Reward' where (entry='1000599');
update quest_template set RequestItemsText='Please choice an item and go uphold thruth young one.',EndText='Please choice an item and go uphold thruth young one.' where (entry='1000599');
update quest_template set `Type`='1' where (entry='1000599');
insert into creature_involvedrelation (id,quest) VALUES ('1000599','7313');
update creature_involvedrelation set id='7313',quest='1000599' where (id='1000599') and (quest='7313');




-- Search For Unthruths Quest
-- Remove quest & rewards if there

delete from creature_questrelation where (quest='10001991');  
delete from creature_questrelation where (quest='10002991'); 
delete from creature_questrelation where (quest='10003991'); 
delete from creature_questrelation where (quest='10004991'); 
delete from creature_questrelation where (quest='10005991'); 
delete from quest_template where (entry='10001991'); 
delete from quest_template where (entry='10002991');
delete from quest_template where (entry='10003991');
delete from quest_template where (entry='10004991');
delete from quest_template where (entry='10005991');
delete from creature_involvedrelation where (quest='10005991');
delete from creature_involvedrelation where (quest='10004991');
delete from creature_involvedrelation where (quest='10003991');
delete from creature_involvedrelation where (quest='10002991');
delete from creature_involvedrelation where (quest='10001991');
delete from item_template where (entry='399991');
delete from item_template where (entry='11399991');
delete from item_template where (entry='12399991');
delete from item_template where (entry='13399991');

-- Add quest & rewards to database

insert into creature_questrelation (id,quest) VALUES ('14392','10001991');
insert into creature_questrelation (id,quest) VALUES ('14392','10002991');
insert into creature_involvedrelation (id,quest) VALUES ('14392','10001991');
insert into quest_template (entry,MinLevel,QuestLevel,SpecialFlags,NextQuestId,Title,Details,Objectives,ObjectiveText1,ObjectiveText2,ObjectiveText3,ObjectiveText4,ReqCreatureOrGOId1,ReqCreatureOrGOId2,ReqCreatureOrGOId3,ReqCreatureOrGOId4,ReqCreatureOrGOCount1,ReqCreatureOrGOCount2,ReqCreatureOrGOCount3,ReqCreatureOrGOCount4,RewOrReqMoney,RewXPOrMoney) VALUES ('10001991','40','60','1','10002991','Search For Unthruths Part One','Now that you have some power its time for you to learn the unthruths $n .  Before you can be shown the deception you need to prove your worth.  Go hunting in Durotar and kill 40 Bloodtalon Scythemaws and find the ugly Alliance in ratchet and wipe them out and return back Orgrimmar and report your progress to me.','','Kill 40 Bloodtalon Scythemaws','Kill Acolyte Magaz','Kill Acolyte Fenrick','Kill Acolyte Wytula','3123','6252','6253','6254','40','1','1','1','10000','2000');
insert  into quest_template values
(10002991,1537,0,0,40,60,0,0,1,0,0,0,0,1,10001991,10003991,0,0,0,'Search For Unthruths Part Two','Travel to Thunderbluff and seek out the undead people there for your next part','Travel to the unholy place in Thunderbluff.',NULL,NULL,NULL,'Find the undead in Thunderbluff',NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0);
update quest_template set Title='Search For Unthruths Part Two' where (entry='10002991');
update quest_template set PrevQuestId='10001991' where (entry='10002991');
insert into creature_involvedrelation (id,quest) VALUES ('3419','10002991');
insert into creature_questrelation (id,quest) VALUES ('3419','10002991');
update quest_template set SpecialFlags='0' where (entry='10002991');
update quest_template set MinLevel='40',QuestLevel='60' where (entry='10002991');
update quest_template set SpecialFlags='8' where (entry='10001991');
update quest_template set ReqCreatureOrGOId1='1191' where (entry='10001991');
update quest_template set `Type`='0' where (entry='10001991');
update quest_template set `Type`='0' where (entry='10002991'); 
update quest_template set `Type`='0' where (entry='10003991'); 
update quest_template set MinLevel='40',QuestLevel='60' where (entry='10002991');
update quest_template set OfferRewardText='You have done well $n' where (entry='10001991');
update quest_template set Title='Search For Unthruths Part Three' where (entry='10003991');
insert into creature_questrelation (id,quest) VALUES ('3419','10003991');
insert into quest_template (entry,MinLevel,QuestLevel,SpecialFlags,PrevQuestId,NextQuestId,Title,Details,Objectives,ObjectiveText1,ObjectiveText2,ReqCreatureOrGOId1,ReqCreatureOrGOId2,ReqCreatureOrGOCount1,ReqCreatureOrGOCount2,RewOrReqMoney,RewXPOrMoney) VALUES ('10003991','40','60','8','10002991','10004991','Search For Unthruths Parth Three','Now its time for you to Really prove your worth $n , travel to Azshara and find the Highborne, kill 10 Lichling and 10 Apparitions and return to me.','Travel to Azshara and find the Highborne, kill 10 Lichling and 10 Apparitions and return to me.','Kill 10 Highborne Lichlings','Kill 10 Highborne Apparitions','6117','6116','10','10','10000','2500');
update quest_template set PrevQuestId='10001991',NextQuestId='10003991' where (entry='10002991');
insert into creature_involvedrelation (id,quest) VALUES ('3419','10003991');
update quest_template set SpecialFlags='1' where (entry='10002991');
update quest_template set ZoneOrSort='1537' where (entry='10001991');
update quest_template set ZoneOrSort='1537' where (entry='10002991');
update quest_template set ZoneOrSort='1537' where (entry='10003991');
insert into quest_template (entry,ZoneOrSort,MinLevel,QuestLevel,PrevQuestId,NextQuestId,Title,Details,Objectives,ObjectiveText1,ObjectiveText2,ObjectiveText3,ObjectiveText4,ReqCreatureOrGOId1,ReqCreatureOrGOId2,ReqCreatureOrGOId3,ReqCreatureOrGOId4,ReqCreatureOrGOCount1,ReqCreatureOrGOCount2,ReqCreatureOrGOCount3,ReqCreatureOrGOCount4,RewOrReqMoney,RewXPOrMoney) VALUES ('10004991','1537','40','60','10003991','10005991','Search For Unthruths Part Four','So far so good $n , you have done well.  Now comes a REAL test you need to venture into Zul Farrak and the Scarlet Monastery and kill Herod, Inquisitor Whitemane, Gahz Rilla and The Executioner.  Once you have completed your task go speak to Lor themar Theron in Silvermoon.','kill Herod, Inquisitor Whitemane, Gahz Rilla and The Executioner and then speak to Priestess Amoora in Darnassus.','Kill Gahz Rilla','Kill Executioner','Kill Herod','Kill Inquisitor Whitemane','7273','7274','3975','3977','1','1','1','1','20000','10000');
update quest_template set SpecialFlags='8' where (entry='10004991');
insert into creature_questrelation (id,quest) VALUES ('3419','10004991');
insert into creature_questrelation (id,quest) VALUES ('6348','10005991');
insert into quest_template (entry,ZoneOrSort,MinLevel,QuestLevel,PrevQuestId,NextQuestId,Title,Details,RewXPOrMoney) VALUES ('10005991','1537','40','60','10004991','0','Search For Unthruths Part Four','I am well impressed with your skills $n .  Please come visit me again when you reach level 60 or higher and we can continue your quest for deception.','250');
update creature_involvedrelation set id='16802' where (id='6348') and (quest='10004991');
update creature_involvedrelation set id='16802' where (id='6348') and (quest='10005991');
update creature_questrelation set id='16802' where (id='6348') and (quest='10005991'); 
update quest_template set RewChoiceItemId1='39999' where (entry='10005991');
update quest_template set RewChoiceItemCount1='1' where (entry='10005991');
update quest_template set RewItemId1='39999' where (entry='10005991');
update quest_template set RewItemCount1='1' where (entry='10005991');
update quest_template set RewXPOrMoney='25000' where (entry='10005991');
update quest_template set Title='Search For Unthruths Part Five' where (entry='10005991');
update quest_template set Details='I am well impressed with your skills $n .  Its time for me to reward you, please take this sword and use it to crush thruth!' where (entry='10005991');
insert  into item_template values 
(399991, 2, 7, -1, 'The Sword of a Thousand Deceptions', 'The Sword of a Thousand Deceptions', 'The Sword of a Thousand Deceptions', 'The Sword of a Thousand Deceptions', 35575, 4, 0, 1, 1500000, 500000, 13, -1, -1, 70, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '197', '296', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 2800, 0, '0', 10876, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used to kill those who have no life', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'internalitemhandler', 6604),
(11399991, 2, 10, -1, 'The Staff of a Thousand Deceptions', 'The Staff of a Thousand Deceptions', 'The Staff of a Thousand Deceptions', 'The Staff of a Thousand Deceptions', 35575, 4, 0, 1, 1500000, 500000, 17, -1, -1, 70, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '197', '296', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 2800, 0, '0', 10876, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used to kill those who have no life', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'internalitemhandler', 6604),
(12399991, 2, 4, -1, 'The Mace of a Thousand Deceptions', 'The Mace of a Thousand Deceptions', 'The Mace of a Thousand Deceptions', 'The Mace of a Thousand Deceptions', 35575, 4, 0, 1, 1500000, 500000, 21, -1, -1, 70, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '197', '296', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 2800, 0, '0', 10876, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used to kill those who have no life', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'internalitemhandler', 6604),
(13399991, 2, 18, -1, 'The Bow of a Thousand Deceptions', 'The Bow of a Thousand Deceptions', 'The Bow of a Thousand Deceptions', 'The Bow of a Thousand Deceptions', 35575, 4, 0, 1, 1500000, 500000, 26, -1, -1, 70, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '197', '296', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 2800, 0, '0', 10876, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used to kill those who have no life', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'internalitemhandler', 6604);
update quest_template set RewChoiceItemId2='1139999',RewChoiceItemId3='1239999',RewChoiceItemId4='1339999',RewChoiceItemCount2='1',RewChoiceItemCount3='1',RewChoiceItemCount4='1' where (entry='10005991');
update quest_template set RewItemCount2='1',RewItemCount3='1',RewItemCount4='1' where (entry='10005991');
update quest_template set RewItemId2='1139999',RewItemId3='1239999',RewItemId4='1339999' where (entry='10005991');
update quest_template set NextQuestId='10002991' where (entry='10001991');
update quest_template set PrevQuestId='10001991',NextQuestId='10003991' where (entry='10002991');
update quest_template set PrevQuestId='10002991',NextQuestId='10004991' where (entry='10003991');
update quest_template set PrevQuestId='10003991',NextQuestId='10005991' where (entry='10004991');
update quest_template set PrevQuestId='10004991' where (entry='10005991');
insert into creature_involvedrelation (id,quest) VALUES ('16802','10004991');
update quest_template set RewItemId1='0',RewItemId2='0',RewItemId3='0',RewItemId4='0',RewItemCount1='0',RewItemCount2='0',RewItemCount3='0',RewItemCount4='0' where (entry='10005991');
update quest_template set SpecialFlags='1' where (entry='10005991');
update quest_template set OfferRewardText='Well done $n . Come back to see me when you are level 60 and i will have a gift for you.' where (entry='10004991');
update quest_template set OfferRewardText='Please choice an item and go destroy thruth young one.' where (entry='10005991');
update item_template set displayid='35634' where (entry='1139999');
update item_template set displayid='39581' where (entry='1239999');
update item_template set displayid='40859' where (entry='1339999');
update quest_template set ExclusiveGroup='0' where (entry='10002991');
update quest_template set NextQuestInChain='10004991' where (entry='10003991');
update quest_template set NextQuestInChain='10005991' where (entry='10004991');
update quest_template set `Type`='1' where (entry='10005991');
update quest_template set RequiredRepValue='0' where (entry='10002991');
update quest_template set SpecialFlags='8' where (entry='10005991');
update quest_template set RequiredRaces='0' where (entry='10002991');
update quest_template set SpecialFlags='1' where (entry='10005991');
update quest_template set `Type`='0' where (entry='10005991');
update quest_template set Objectives='Pick your Reward' where (entry='10005991');
update quest_template set Objectives='Kill 40 Bloodtalon Scythemaws and kill the Allaince scum and then report your progress to me.' where (entry='10001991');
update quest_template set RequestItemsText='Please choice an item and go destroy thruth young one.',EndText='Please choice an item and go destroy thruth young one.' where (entry='10005991');
update quest_template set `Type`='1' where (entry='10005991');
update quest_template set RewChoiceItemId1='399991',RewChoiceItemId2='11399991',RewChoiceItemId3='12399991',RewChoiceItemId4='13399991' where (entry='10005991');
insert into creature_involvedrelation (id,quest) VALUES ('10005991','16802');
update creature_involvedrelation set id='16802',quest='10005991' where (id='10005991') and (quest='16802');