Custom Quest Trouble

[Piccolodmq]

I used to easily do custom quests back in 2012 trinitycore 3.3.5a version. I know the basic´s of making custom quests. Recently I tried to make custom quests with no luck. Any updated guides for this?

I have alredy tried to copy existing working quests in Quest templates, and change the columns need it, (NPC to kill, rewards, text, etc). I also tried to edit the other 2 DB related files, (creature_quest starter and creature quest ender) with the apropiate information (quest ID and NPC involved).

When I reset the server I get nothing.

Is there something I am missing? IS there an uptaded guide, because all I can find is old guides.


Thanks!

[Amaroth]

There are sooo many things which can go wrong...
Incorrect creature ID in queststarter table. Incorrect min level. Incorrect class/race restrictions. Creature might be missing quest giver flag... And so on.

[Piccolodmq]

There are sooo many things which can go wrong...
Incorrect creature ID in queststarter table. Incorrect min level. Incorrect class/race restrictions. Creature might be missing quest giver flag... And so on.

Yea I know , but a small tutorial of what templates of the DB should be changed would help me.  Individual columns I can check in trinitycore.org wiki, but I can´t find an example of a complete custom up to date tutorial of a custom quest, and I am sure I am missing something.

[Makpptfox]

You can use this to learn on the blizzard's one and generate some code to create a custom quest.

Be careful to not delete any existing ID when you make the sql request.

http://keira2.altervista.org/Keira2-dev/#/quest

(You can also install keira2 on your server, but if it's just to learn some things, it's not useful)

[Piccolodmq]

You can use this to learn on the blizzard's one and generate some code to create a custom quest.

Be careful to not delete any existing ID when you make the sql request.

http://keira2.altervista.org/Keira2-dev/#/quest

(You can also install keira2 on your server, but if it's just to learn some things, it's not useful)

Thanks!  I saw that this uses a system like Truice used to do.   But sadly I dont know how to "install" or merge this with my server.  truice was simple, just put the Auth world information have mysql ready and that is it.

Could you tell me how to install Keira?
This part specifically I dont get - "Extract "TC-JSON-API" folder inside your server web directory"


Here are the SQl´s of the quests I have so far.

I have tried this, with no luck. So there must be a mistake on my side. For a simple quest, lo load there shoudnt be anything else than

creature_template = for the right npc id lets say NPC 80036


Quest_template = 90000

Here is the sql for it.
INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestLevel`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardMoney`, `RewardBonusMoney`, `RewardDisplaySpell`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `Flags`, `RequiredPlayerKills`, `RewardItem1`, `RewardAmount1`, `RewardItem2`, `RewardAmount2`, `RewardItem3`, `RewardAmount3`, `RewardItem4`, `RewardAmount4`, `ItemDrop1`, `ItemDropQuantity1`, `ItemDrop2`, `ItemDropQuantity2`, `ItemDrop3`, `ItemDropQuantity3`, `ItemDrop4`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemQuantity1`, `RewardChoiceItemID2`, `RewardChoiceItemQuantity2`, `RewardChoiceItemID3`, `RewardChoiceItemQuantity3`, `RewardChoiceItemID4`, `RewardChoiceItemQuantity4`, `RewardChoiceItemID5`, `RewardChoiceItemQuantity5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardTalents`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionValue1`, `RewardFactionOverride1`, `RewardFactionID2`, `RewardFactionValue2`, `RewardFactionOverride2`, `RewardFactionID3`, `RewardFactionValue3`, `RewardFactionOverride3`, `RewardFactionID4`, `RewardFactionValue4`, `RewardFactionOverride4`, `RewardFactionID5`, `RewardFactionValue5`, `RewardFactionOverride5`, `TimeAllowed`, `AllowableRaces`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RequiredNpcOrGo1`, `RequiredNpcOrGo2`, `RequiredNpcOrGo3`, `RequiredNpcOrGo4`, `RequiredNpcOrGoCount1`, `RequiredNpcOrGoCount2`, `RequiredNpcOrGoCount3`, `RequiredNpcOrGoCount4`, `RequiredItemId1`, `RequiredItemId2`, `RequiredItemId3`, `RequiredItemId4`, `RequiredItemId5`, `RequiredItemId6`, `RequiredItemCount1`, `RequiredItemCount2`, `RequiredItemCount3`, `RequiredItemCount4`, `RequiredItemCount5`, `RequiredItemCount6`, `Unknown0`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `VerifiedBuild`) VALUES (90000, 2, 78, 255, 616, 0, 0, 0, 0, 0, 0, 7, 5, 50000, 78800, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 57321, 1, 57320, 1, 57322, 1, 57324, 1, 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, ' Bonecrusher Ogres Hunting: Damm Giants!', 'Hyjal protectors request for you help getting rid of this pesky Bonecrusher Ogres that keep coming and coming. Please dispatch 5 Ogre Slave', 'Hyjal is is rife with fascinating creatures, mostly peacefull. .$B$BThe area is been invaded by this mix race of Ogre,but the seem to have hierarchy. I need you to dispatch 5 of this Ogre Bonecrushers so we can take an advance to see who is behind this attack, For Cenarius!', NULL, 'Return to Ma Fendolor Sonriver at teh Hyjal Encampent.', 0, 80026, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, NULL, NULL, NULL, 12340);

-----
creature_quest_ender =

INSERT INTO `creature_questender` (`id`, `quest`) VALUES (80032, 90000);

Creature_quest_started=

INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES (80032, 90000);

------

Creature Template

INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES (80032, 0, 0, 0, 0, 0, 138230, 138230, 138230, 138230, 'Fendolor Songriver', 'Hyjal Protector', '0', 0, 80, 83, 2, 1775, 3, 1, 1.14286, 1, 0, 0, 2000, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 2, 0, 7, 0, 80024, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3000, 4000, 'SmartAI', 0, 3, 0, 8, 8, 1, 6, 0, 0, 0, 1, 1, 0, '0', 12430);
------------------------------------------------------------------------

so yea, this is what I have.

[Makpptfox]

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 :

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.

[Piccolodmq]

yes ! It did help thanks a lot!

Will try to make Keira work.   I seems like a powerfull addon.

I Don´t get the "put the files in the webserver" part.