How to Create a Quest

[JulianX]

Ok after searching through my pc looking for old guides I made I found this quest guide although it was out of date and for MaNGOS originally, I will edit it to be for Ascent just for all of you.

In this tutorial we are going to make a Chain of Quests! I will just use existing quest That I added that are in no other DB but NCDB that I fixed for them. I will show you all my resources and the way I made all 3 of them.
We will use the Champion Quests in Caverns of Time.

Step 1 :: Selecting the Quest Starter and Quest Finisher.
>Ok in this step we will decide in the person who start and end the quest.<

In this case the person will be the same since I followed the Blizz way more info here - Champion's Pledge - Quests - World of Warcraft
[As you can see all the quest on the right hand side that display the Chain and the quest starter/finisher]

Open up your 'creature_quest_starter' Table in your Main Ascent Database and it will have 2 columns as I will show below:

ID: This is the creature ID you will use.
I will use '19935' which is Soridormi.
Quest: This is the quests ID that you have made
In this case I will use '10462', '10466', and '10470'. For all the 3 quests.

Template:

INSERT INTO `creature_quest_starter` VALUES ('ID','QUEST')

Open up your 'creature_quest_Finisher' Table in your Main Ascent Database and it will have 2 columns as I will show below:

ID: This is the creature ID you will use.
I will use '19935' which is Soridormi.

Quest: This is the quests ID that you have made
In this case I will use '10462', '10466', and '10470'. For all the 3 quests.

Template:

INSERT INTO `creature_quest_finisher` VALUES ('ID','QUEST')

Step 2 :: Making the Quest or Quests
>This is a step to step Guide on making quests, it will come with a template at bottom<

Open up SQLyog and go to your Main Ascent Database and open up the table named 'quests'. You will see the Following Columns

ENTRY:The Entry is the ID of the quest.
I will use '10462' or '10466', and '10470'

ZoneID: The Zone ID can is where the quest should be.
[To Finde ZoneID just use .gps and it is Zone]
Since I am following the Blizzlike way I will use '1941'

QuestSort: Just leave this blank
Set to '0'

QuestFlags: The Quest Flags are what you flag the quest.
For this quest We will set it to '8'

MinLevel: This is the minimum Level requirement for the Quest.
Since this quest is for level 70's we will set it to'70'

MaxLevel: This is the Maximum Level requirement to do the quest.
Since this quest is for level 70's we will set it to '70'

Type: This is the Type of quest
Set to '0'

RequiredRaces: This is the ID of the Races that can accept the quest.
Set to '1101' for all races

RequiredClass to RequiredTradeSkill:These are kinda useless unless they are profession quests or class trainer quests.
Set to '0'

RequiredRepFaction: This is the Faction that they have to be repped with or leave '0' if you do not want them to be repped. [Rep Faction List]
For this quest we will use '0' but for the other 2 quests '990'

RequiredRepValues: This is the Amount of Reputation that they will need for the faction to start the quest.
For this quest we will use '0', but for the other 2 we will use '9000' and '21000'.

LimitTime: This is the Time Limit if it is a timed quest.
IN this quest I will set to '0'

SpecialFlags: These are the flags of the quess if it be a special quest.
Special Flags List:

• QUEST_SPECIAL_FLAGS_NONE = 0
• QUEST_SPECIAL_FLAGS_DELIVER = 1
• QUEST_SPECIAL_FLAGS_EXPLORATION = 2
• QUEST_SPECIAL_FLAGS_SPEAKTO = 4
• QUEST_SPECIAL_FLAGS_KILL_OR_CAST = 8
• QUEST_SPECIAL_FLAGS_TIMED = 16
• Flag 32 unknown
• QUEST_SPECIAL_FLAGS_REPUTATION = 64

For this quest and the other 3 we will use'1'

PrevQuestId: This is the ID of the quest Before this 1 if it is a chain quest.
Since this is the start of the chain quest we will set to '0' but the next one is '10462' and then the next quest '10466'.

NextQuestId: This is the ID of the quest after this 1 and since this is the start of a chain quest we will use the next quests ID, or if it is not a chain quest we will use '0'.
Set this to '10466' for this quest and '10470' for the second 1.

SrcItem: This is the starting Item that they give you I think.
This quest we will use'29298' and the next'29298' and the next '29299'

SrcItemCount: This is the amount of the item they give you.
For This Quest we will use '1' same with the other 2.

Title: This is the Name of the Quest.
For this quest we will use "Champion's Pledge" and the other 2 "Champion's Vow" and "Champion's Oath".

Details: This is the Quest Details
for this quest we will use nothing since there are no Details for it!.
But for an example for the 2nd Quest we will use 'You\'ve made your pledge, $c. Now it is up to you to see it through.$B$BServe the Scale of the Sands well and you will be rewarded. Fail and the timeline as we know it will be unravelled!'

Objectives: This is the Objective of the Quest
For this quest there is no Objective so leave it blank as well.
But an example of this for your next quest is 'Bring your Band of Eternity to Soridormi at the Caverns of Time after obtaining Honored reputation with the Scale of the Sands.'

CompletionText: This is what they will say to you when you finish the quest
For this quest we will use
'Are you sure this is the path you seek to take, $N? This is not a decision you ought to take lightly.

This ring is imbued with a droplet from the Well of Eternity. It will grow in power as you prove yourself to the Scale of the Sands.'

IncompleteText: This is what they say to you if you do not have the quest finished
This quest does not have one so we will leave it blank.
But for example the last quest uses this 'You\'ve returned. You wish to speak to me?'

EndText to ObjectiveText4: these are kinda useless.
Leave these all Blank

ReqItemID1: This is the Item ID that you have to get for the quest giver.
For this quest it is '29298'

ReqIemdID2-ReqIemdID4:This is the other Item ID's that you have to acquire
For this quest set all to '0'

ReqItemCount1: This is the Amount of the Item you need that matches ReqItemID1
For this quest we will use '0'

ReqItemCount2 - ReqItemCount4: This is the Amount of that item that matches ReqItemID2-4 that you need to finish the quest.
For this Quest we will set them all to '0'

ReqKillMoborGOID1 - ReqKillMoborGOID4: These are for if the quest requires you to kill a creature or a GameObject.
For this quest we will set them all to '0'.

ReqKillMoborGOCount1 - ReqKillMoborGOCount4: These are the amount of creatures or Game Objects that you have to kill matching there coressponding ReqKillModorGOID slots.
For this quest we will set them all to '0'.

RewChoiceItemID1 - RewChoiceItemID6: These are what items your character gets to choose from after completing their task.
For this quest we will set them all to '0'.

RewChoiceItemCount1 - RewChoiceItemCount6: These are the amount of items your character is rewarded of that item ID.
For this quest we will set them all to '0'.

RewItemID1 - RewItemID4: These are the Items your character is rewarded from completing the quest.
For this guide we will Reward 1 item so we will set RewItemID1 to '29298' and the rest to '0'.

RewItemCount1 - RewItemCount4: This is the amount of that item they are rewarded.
For this Quest we will set RewItemCount1 to '1' and the rest to '0'

RewRepFaction1 - RewRepFaction2: These are the faction that you are rewarded rep for.
For this quest we will use '990' for RewRepFaction1 and '0' RewRepFaction2.

RewRepValue1 - RewRepValue2: These are the amount of Rep you earn to the Faction that it is set to.
For this quest we will set it to '250' for RewRepValue1 and to '0' for RewRepValue2.

RewRepLimit: Not Sure on this 1.
Leave at '0'

RewMoney: The amount of money you reward for this quest
For this quest we will set to'10466' which is 1G 4S 66C

RewXP: This is the Amount of Experience you reward for the completion of this quest.
For this quest we will use '0'

RewSpell - Point0pt: These are useless to me they are just spells that you can get for finishing the quest and other crap. I find them useless.
For this quest they will all be set to '0'

RequireMoney: This is the amount of money you will need to finish thee quest.
For this quest leave it at '0'

ExploreTrigger1 - ExploreTrigger4: These are just quests that require you to enter an areatrigger that enables you to discover. GAY and useless in my Opinion.
For this quest set all to '0'

RequiredQuest1 - RequiredQuest4: These are the quests that you need to do this quest.
For this quest set them all to '0'

RecieveItemID1 - RecieveItemID4: These are the Items that you get for completing the Quest.
For this quest we will use '29298' for RecieveItemID1 and '0' for The rest.

RecieveItemCount1 - RecieveItemCount4: These are the amount of the Item you will recieve.
For this quest we will use '1' for RecieveItemCount1 and '0' for the Rest.

IsRepeatable: This is where you decide if the quest is repeatable or not '0' for no '1'for yes.
For this quest we will set it to '0'

Template:

INSERT INTO`quests` VALUES
(`entry`,`ZoneId`,`QuestSort`,`QuestFlags`,`MinLevel`,`MaxLevel`,`Type`,`RequiredRaces`,`RequiredClass`,`RequiredTradeskill`,`RequiredRepFaction`,`RequiredRepValue`,`LimitTime`,`SpecialFlags`,`PrevQuestId`,`NextQuestId`,`srcItem`,`SrcItemCount`,`Title`,`Details`,`Objectives`,`CompletionText`,`IncompleteText`,`EndText`,`ObjectiveText1`,`ObjectiveText2`,`ObjectiveText3`,`ObjectiveText4`,`ReqItemId1`,`ReqItemId2`,`ReqItemId3`,`ReqItemId4`,`ReqItemCount1`,`ReqItemCount2`,`ReqItemCount3`,`ReqItemCount4`,`ReqKillMobOrGOId1`,`ReqKillMobOrGOId2`,`ReqKillMobOrGOId3`,`ReqKillMobOrGOId4`,`ReqKillMobOrGOCount1`,`ReqKillMobOrGOCount2`,`ReqKillMobOrGOCount3`,`ReqKillMobOrGOCount4`,`RewChoiceItemId1`,`RewChoiceItemId2`,`RewChoiceItemId3`,`RewChoiceItemId4`,`RewChoiceItemId5`,`RewChoiceItemId6`,`RewChoiceItemCount1`,`RewChoiceItemCount2`,`RewChoiceItemCount3`,`RewChoiceItemCount4`,`RewChoiceItemCount5`,`RewChoiceItemCount6`,`RewItemId1`,`RewItemId2`,`RewItemId3`,`RewItemId4`,`RewItemCount1`,`RewItemCount2`,`RewItemCount3`,`RewItemCount4`,`RewRepFaction1`,`RewRepFaction2`,`RewRepValue1`,`RewRepValue2`,`RewRepLimit`,`RewMoney`,`RewXP`,`RewSpell`,`CastSpell`,`PointMapId`,`PointX`,`PointY`,`PointOpt`,`RequiredMoney`,`ExploreTrigger1`,`ExploreTrigger2`,`ExploreTrigger3`,`ExploreTrigger4`,`RequiredQuest1`,`RequiredQuest2`,`RequiredQuest3`,`RequiredQuest4`,`ReceiveItemId1`,`ReceiveItemId2`,`ReceiveItemId3`,`ReceiveItemId4`,`ReceiveItemCount1`,`ReceiveItemCount2`,`ReceiveItemCount3`,`ReceiveItemCount4`,`IsRepeatable`) ;

To see the Finished results for all 3 Quests Go Here - Next Chapter Community Forums

[ironman2173]

Another Great Guide By JulianX!!! Tyvm For The Great Share!!! +REP

[thelightman]

GREAT GUIDE! +REP! Thanks for Sharing m8, but ive got one little problem. when i load in my items that ive made for my quest. one that is the quest item needed. and one is the quest reward. when i Execute those files into my DB Antrix.exe wont start just pops up an fail window. Help Please :]

[JulianX]

can you show th error message

[Killer_Dajobe]

i did it, spawned my guy and he diddnt have a Quest?

[JulianX]

o sorry you may have not flagged him a quest giver use my other guide on creating a mob for a quest giver flag and then make it and yadayadayada make sure you make him quest finisher and starter and vhoila you got it wrking

[Tinyterror666]

Thank you for the share im gonna try it now

[LTGH]

JulianX you rock you have guides to everything i need.
erhm.. Without a good portal creation guide, i dont get the portals to work with the existing guide...

[TripZone]

WOOT Juilian is on a role lol love his guides even tho i use Crispee repack i still use juilian for ingame shit Keep on the good work Juilian +Rep

[omgimamonkey]

sorry , i really dont get how to find the zone id, i did .gps on the place i wanted it too be in, shows X -608.717651 Y -4248.05371 Z 38.955006 and orientation 1.939146, wich one is it?

[Koest]

Nice guide looking forever lol +rep

[chose]

I can't get my quest to work

It worked once but only as a test, where the reward was 5g and all the quest text was "test" - but then when I made the reward xp higher, and g higher, and real text, the NPC didn't seem to have the quest anymore.

[Relentlesserv]

cool one , gj

[Blindgunner]

Great 1 man i loove u just pulling out rabbits outa that hat of yours lol

[Kill604]

Thanks man