Part One: Connecting to your Database
1) Open & Connect your Database Editor
2) Under the Ascent Database, find the Table 'quests'
3) Click 'Add Record" (On HeidiSQL, its a +)
Part Two: Creating the Quest
Entry: Have it a high ID. Something that is not used and you will remember. This is just for the Quest_starter and Quest_Finisher at the end. Also if you want to make Chain Quests.
ZoneID: Just what Zone the Quest is set as (Doesn't affect the Quest) Some Zone ID's are:
CODE
blank = 5
aldrassil = 256
azshara = 16
azshara crater = 268
blasted lands = 4
duskwood = 10
echo ridge mine = 34
Elwynn forest = 12
kul tiras = 21
longshore = 2
moonbrook = 20
refuge pointe = 320
reuse me 6 = 66
stranglethorn vale = 33
swamp of sorrows = 8
the cemetery = 32
the dark portal = 72
the maclure vineyards = 64
the world tree = 13
westfall = 49
ziata'jal ruins = 128
Sort: Just put the same Number you put in ZoneID. Doesn't affect Quest.
Flags: Not sure what this does. I put either 0 or 8 (I think its whether the Account has TBC or not)
MinLevel: The minimal Level a Player has to be to pickup the Quest.
QuestLevel: The Level of the Quest. Not the maximum Level a person can be, the Level the Quest is for (If it is 3, then to a Level 1 it will be yellow, and for a 60 it will be gray)
Type: Pretty simple, the Types are:
CODE
0/blank - Soloable
1 - Group
41 - PvP
62 - Raid
81 - Dungeon
Required Races: Races that are able to pickup the Quest. The Race ID's are as followed:
CODE
1 = human
2 = orc
4 = dwarf
8 = night elf
16 = undead
32 = tauren
64 = gnome
128 = troll
512 = bloodelf
1024 = dranei
690 = all horde races
1101 = all alliance races
If you want two Races together to both be able to pick the Quest up (e.x. - Only Tauren and Undead are aloud to take the Quest), then just add the two wanted Faction ID's together (e.x. - For Tauren and Undead, it would be 32 + 16 = 4
Required Classes to Required Repvalue: Don't touch these. Not sure if they work correctly.
Limit Time: If you want a Limit Time to be set for the Quest (e.x. - Kill so-and-so in 30 minutes) then put the time in as Milliseconds.
SpecialFlags: Not sure what this does. Doesn't affect Quest. Leave at 0 if unsure.
PrevQuestID: If its the second in a Chain Quest, put the Quest ID of the first Quest here.
NextQuestID: If its the first in a Chain Quest, put the Quest ID of the second Quest here.
scrItem: Entry ID of an Item that you get when Accepting the Quest
scrItemCount: How many of the Items from column above you receive (e.x. - If set as 3, you will get 3 of the Items)
Title: The Title of the Quest that appears in your Quest Log
Details: The Text at the top of the Quest in your Quest Log. Its what your supposed to do and any other information wanted.
Objectives: The main Objectives of the Quest (e.x. - Kill 20 Wrath Soldiers)
CompletionText: The Text that appears when handing in and completing the Quest.
IncompleteText: The Text that appears when failing the Quest and talking to the appointed Quest giver.
EndText: Shown below the Objectives of the Quest.
ObjectiveText1-4: The Text that shows what Mobs you have to kill. Shows when given Quest Tracking (e.x. - Goblin Engineer)
RequireItemid1-4: Required Items you need to finish the Quest successfully.
RequireItemcount1-4: How many of the Items you need to finish the Quest successfully.
ReqKillMoborGoID1-4: The Entry ID of Mobs that you have to Kill in order to finish the Quest successfully. The first of these must coegspond with the 'ObjectiveText1', the second of these must coegspond with the 'ObjectText2' and so on.
ReqKillMoborGoID1-4: How many of the Mobs you have to Kill in order to finish the Quest successfully.
ReqCastSpellID1-4: Not sure what this does. I believe its what Spell you have to Cast to finish the Quest successfully.
RewChoiceItemID1-6: The Entry ID of Items that you get to choose from when handing the Quest in.
RewChoiceItemCount1-6: The amount of Items you get if you choose that Item.
RewItemID1-4: The Entry ID of Items that you get when handing in the Quest (You get these along with one of the RewChoiceItems)
RewItemCount1-4: The amount of Reward Items you get when handing in the Quest.
RewRepFaction1-2: ID's of a Faction that you get Reputation for when handing in the Quest.
RewRepValue1-2: The amount of Reputation that you get for handing in the Quest.
RewRepLimit: May have a use but all Blizzard quests have 0.
RewMoney: The amount of Money you get for handing in the Quest (e.x. - 24Gold, 13Silver and 25Copper is 241325)
RewXP: The amount of EXP you get for handing in the Quest
RewSpell: The Spell ID of a Spell you attain when handing in the Quest.
CastSpell: Spell ID of a Spell that gets Casted on you upon handing the Quest in.
PointMapID: Not sure how this works. Leave this at its Default. (0)
PointX: Not sure how this works. Leave this at its Default. (0)
PointY: Not sure how this works. Leave this at its Default. (0)
PointOpt: Not sure how this works. Leave this at its Default. (0)
RequiredMoney: The Required Money you must have to complete the Quest (e.x. - 24Gold, 73Silver and 27Copper is 247327)
ExploreTrigger1-4: Locations you must have explored to complete the Quest.
RequiredQuest1-4: ID's of Quests you must have Completed to be able to attain this one.
ReceiveItemID1-4: IDs of item(s) you will receive upon completing the Quest. (often used to give additional Quest Items for later Quest chains)
ReceiveItemCount1-4: The amount of Items you will receive upon completing the Quest.
IsRepeatable: If the Quest is repeatable.
CODE:
0 - No
1 - Yes
Part Three: Putting the Quest on a NPC
1) Go to the Table 'Creature_quest_starter'
2) Click Add Record (For HeidiSQL it is a +)
3) For the id, put the Entry ID of the NPC you want to give the Quest
4) For quest, put the ID of the Quest you want the NPC to give (Up from the top)
5) Go to the Table 'Creature_quest_finisher'
6) Click Add Record (For HeidiSQL it is a +)
7) For the id, put the Entry ID of the NPC you want to give the Quest
For quest, put the ID of the Quest you want the NPC to give (Up from the top)
Hope it helped someone.