46
Miscellaneous / Re: Custom Quest Trouble
« on: November 24, 2016, 10:28:53 am »
For the TC-JSON-API install you have all the informations here : https://github.com/ShinDarth/TC-JSON-AP ... INSTALL.md
And for your quest you're missing the quest_template_addon, quest_request_items and the quest_offer_reward tables informations.
It should be something like that :
Hope it helps.
And for your quest you're missing the quest_template_addon, quest_request_items and the quest_offer_reward tables informations.
It should be something like that :
Code: [Select]
-- FULL `quest_template_addon` of ID 90000
DELETE FROM `quest_template_addon` WHERE (ID = 90000);
INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) VALUES
(90000, 0, 0, 0, 63, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- FULL `quest_request_items` of ID 90000
DELETE FROM `quest_request_items` WHERE (ID = 90000);
INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `CompletionText`, `VerifiedBuild`) VALUES
(90000, 1, 0, 'YOUR_REQUESTITEM_TEXT', 12340);
-- FULL `quest_offer_reward` of ID 90000
DELETE FROM `quest_offer_reward` WHERE (ID = 90000);
INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
(90000, 0, 0, 0, 0, 0, 0, 0, 0, 'YOUR_REWARD_TEXT', 12340);
Hope it helps.