• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

[SOLVED] Npc can't complete quest

Status
Not open for further replies.
B

brh11

Respected Member
Okay so I know I probably screwed up.I finally fixed it so you can see the grey question mark above the questender.The problem is I cant complete the quest.I want to make it so when you talk to him it completes the quest.Thanks
 
Tommy

Tommy

Founder
brh11 said:
Okay so I know I probably screwed up.I finally fixed it so you can see the grey question mark above the questender.The problem is I cant complete the quest.I want to make it so when you talk to him it completes the quest.Thanks
Click to expand...

Need more information about the quest. Do you kill creatures? Are you just accepting the quest and running to another NPC to complete it?

Make sure you have the correct entry ID in creature_questender.
 
B

brh11

Respected Member
Yes Just running to the other npc :D and yes its in the creature_questender and its the correct id and quest
 
Tommy

Tommy

Founder
brh11 said:
Yes Just running to the other npc :D and yes its in the creature_questender and its the correct id and quest
Click to expand...

Are you sure? Considering you can't complete the quest. Paste me the quest_template, creature_queststarter and creature_questender sqls.
 
B

brh11

Respected Member
Code: 
DELETE FROM `creature_queststarter` WHERE `quest` = 186754;
DELETE FROM `gameobject_queststarter` WHERE `quest` = 186754;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 186754;
INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES (456789, 186754);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 456789;
INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES (456789, 186754);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 456789;
DELETE FROM `creature_questender` WHERE `quest` = 186754;
DELETE FROM `gameobject_questender` WHERE `quest` = 186754;
INSERT INTO `creature_questender` (`id`, `quest`) VALUES (4567810, 186754);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=4567810;
REPLACE INTO `quest_template` (`Id`, `Method`, `Level`, `MinLevel`, `MaxLevel`, `ZoneOrSort`, `Type`, `SuggestedPlayers`, `LimitTime`, `RequiredClasses`, `RequiredRaces`, `RequiredSkillId`, `RequiredSkillPoints`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestIdChain`, `RewardXPId`, `RewardOrRequiredMoney`, `RewardMoneyMaxLevel`, `RewardSpell`, `RewardSpellCast`, `RewardHonor`, `RewardHonorMultiplier`, `RewardMailTemplateId`, `RewardMailDelay`, `SourceItemId`, `SourceItemCount`, `SourceSpellId`, `Flags`, `SpecialFlags`, `RewardTitleId`, `RequiredPlayerKills`, `RewardTalents`, `RewardArenaPoints`, `RewardItemId1`, `RewardItemId2`, `RewardItemId3`, `RewardItemId4`, `RewardItemCount1`, `RewardItemCount2`, `RewardItemCount3`, `RewardItemCount4`, `RewardChoiceItemId1`, `RewardChoiceItemId2`, `RewardChoiceItemId3`, `RewardChoiceItemId4`, `RewardChoiceItemId5`, `RewardChoiceItemId6`, `RewardChoiceItemCount1`, `RewardChoiceItemCount2`, `RewardChoiceItemCount3`, `RewardChoiceItemCount4`, `RewardChoiceItemCount5`, `RewardChoiceItemCount6`, `RewardFactionId1`, `RewardFactionId2`, `RewardFactionId3`, `RewardFactionId4`, `RewardFactionId5`, `RewardFactionValueId1`, `RewardFactionValueId2`, `RewardFactionValueId3`, `RewardFactionValueId4`, `RewardFactionValueId5`, `RewardFactionValueIdOverride1`, `RewardFactionValueIdOverride2`, `RewardFactionValueIdOverride3`, `RewardFactionValueIdOverride4`, `RewardFactionValueIdOverride5`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`, `Objectives`, `Details`, `EndText`, `OfferRewardText`, `RequestItemsText`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGo2`, `RequiredNpcOrGo3`, `RequiredNpcOrGo4`, `RequiredNpcOrGoCount1`, `RequiredNpcOrGoCount2`, `RequiredNpcOrGoCount3`, `RequiredNpcOrGoCount4`, `RequiredSourceItemId1`, `RequiredSourceItemId2`, `RequiredSourceItemId3`, `RequiredSourceItemId4`, `RequiredSourceItemCount1`, `RequiredSourceItemCount2`, `RequiredSourceItemCount3`, `RequiredSourceItemCount4`, `RequiredItemId1`, `RequiredItemId2`, `RequiredItemId3`, `RequiredItemId4`, `RequiredItemId5`, `RequiredItemId6`, `RequiredItemCount1`, `RequiredItemCount2`, `RequiredItemCount3`, `RequiredItemCount4`, `RequiredItemCount5`, `RequiredItemCount6`, `RequiredSpellCast1`, `RequiredSpellCast2`, `RequiredSpellCast3`, `RequiredSpellCast4`, `Unknown0`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `EmoteOnIncomplete`, `EmoteOnComplete`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `WDBVerified`) VALUES (186754, 2, 0, 0, 0, '', 0, 0, 0, 1535, 1791, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Conquer the stairs and find my son', 'Go talk to anduain at the top of the stairs', 'Anduain has gone to the top of the stiars,please go and talk to him for me gracious hero', 'Thank you for finding me', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Find anduain at the top of the stairs ', '', '', '', 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 00, 0, 0, 0);
DELETE FROM `areatrigger_involvedrelation` WHERE `quest` = 186754;
INSERT INTO `areatrigger_involvedrelation` (`id`, `quest`) VALUES (0, 186754);


A few are missing in the quest temeplate I manually added those.I also manually added creature_involved relation to I believe
 
Tommy

Tommy

Founder
Why are you using the same quest for creature, gameobject and as the starter quest on an item? You only need one. If it is for a creature, only use creature, etc..
 
B

brh11

Respected Member
Well I used truice so yea..... But the only problem is the npc wont complete the quest when talking to it.do you think RequiredNpcOrGo1 is the answer.But I dont want to kill the npc only talk to it
 
Tommy

Tommy

Founder
brh11 said:
Well I used truice so yea..... But the only problem is the npc wont complete the quest when talking to it.do you think RequiredNpcOrGo1 is the answer.But I dont want to kill the npc only talk to it
Click to expand...

You don't changed any required column to complete a quest when you want to do nothing. You only make the quest title, details and give it a start/end npc then done. Apparently Truice sucks if it does that shit, really stupid and it is probably confusing the server on how to complete the quest. :/

Either way, this is the only thing you should have:

Code: 
INSERT INTO `quest_template` VALUES ('186754', '2', '0', '0', '0', '0', '0', '0', '0', '1535', '1791', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Conquer the stairs and find my son', 'Go talk to anduain at the top of the stairs', 'Anduain has gone to the top of the stiars,please go and talk to him for me gracious hero', 'Thank you for finding me', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Find anduain at the top of the stairs ', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Code: 
INSERT INTO `creature_queststarter` VALUES ('456789', '186754');
INSERT INTO `creature_questender` VALUES ('4567810', '186754');
 
B

brh11

Respected Member
I deleted the quest and all the other junk.I ran those queries.But now when I go to talk to varrian theres no quest... :?
 
Tommy

Tommy

Founder
brh11 said:
I deleted the quest and all the other junk.I ran those queries.But now when I go to talk to varrian theres no quest... :?
Click to expand...

Make sure you don't have it set to a specific race or a specific level, just double check the quest row to see if you don't have any requirements to accept the quest. Gee, it isn't this hard to make a quick quest. :p
 
B

brh11

Respected Member
Okay I got the quests to show up in the npcs by using creature_involvedrelation and creature_questrelation.Stuck again at where I can't complete the quest :/.So mad right now lol
 
Tommy

Tommy

Founder
brh11 said:
Okay I got the quests to show up in the npcs by using creature_involvedrelation and creature_questrelation.Stuck again at where I can't complete the quest :/.So mad right now lol
Click to expand...

I think your issue is you set your "Method" column value to "2" when it should be "0".

I guess your server isn't updated with queststarter/questender new table names, eh? :p
 
B

brh11

Respected Member
Tommy Im stupid.uggg I did something wrong from the begining.Thank you so much for helping a dumb ass :p
 
Status
Not open for further replies.
Top