This is a read only copy without any forum functionality of the old Modcraft forum.
If there is anything that you would like to have removed, message me on Discord via Kaev#5208.
Big thanks to Alastor for making this copy!

Menu

Author Topic: Custom Quest Trouble  (Read 1548 times)

Piccolodmq

  • Registred Member
  • Model Change Addict
  • *****
  • Posts: 200
    • View Profile
Custom Quest Trouble
« on: November 22, 2016, 01:04:30 am »
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!
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

Amaroth

  • Contributors
  • Creator of Worlds
  • *****
  • Posts: 1219
    • View Profile
    • Amaroth's Tools
Re: Custom Quest Trouble
« Reply #1 on: November 22, 2016, 10:09:22 am »
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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
English YT tutorial channel. Check it out if you preffer videos over walls of text.:
https://www.youtube.com/AmarothEng

Want to support me for my releases and/or tutorials? You can send donation via Paypal to:
jantoms@seznam.cz

Piccolodmq

  • Registred Member
  • Model Change Addict
  • *****
  • Posts: 200
    • View Profile
Re: Custom Quest Trouble
« Reply #2 on: November 22, 2016, 07:23:43 pm »
Quote from: "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.


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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

Makpptfox

  • Contributors
  • Loreweaver
  • *****
  • Posts: 103
    • View Profile
Re: Custom Quest Trouble
« Reply #3 on: November 22, 2016, 10:21:55 pm »
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)
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
For support, send your Discord's ID by PM.

Piccolodmq

  • Registred Member
  • Model Change Addict
  • *****
  • Posts: 200
    • View Profile
Re: Custom Quest Trouble
« Reply #4 on: November 23, 2016, 03:54:47 am »
Quote from: "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)

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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

Makpptfox

  • Contributors
  • Loreweaver
  • *****
  • Posts: 103
    • View Profile
Re: Custom Quest Trouble
« Reply #5 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 :

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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
For support, send your Discord's ID by PM.

Piccolodmq

  • Registred Member
  • Model Change Addict
  • *****
  • Posts: 200
    • View Profile
Re: Custom Quest Trouble
« Reply #6 on: November 24, 2016, 05:31:42 pm »
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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »