Quests

From ArcEmu-Wiki
(Difference between revisions)
Jump to: navigation, search
Line 1: Line 1:
== Description ==
+
{{LanguageLinks|Quests|EN}}
  
 +
== Description ==
 
This table contains all base information on quests.
 
This table contains all base information on quests.
  
 
+
'''See also'''
'''Also see'''
+
  
 
*[[Quest_Events]]
 
*[[Quest_Events]]
Line 12: Line 12:
 
*[[Creature_quest_starter]]
 
*[[Creature_quest_starter]]
 
**[[Creature_quest_finisher]]
 
**[[Creature_quest_finisher]]
 
  
 
'''Game Objects'''
 
'''Game Objects'''
Line 29: Line 28:
  
 
*[[Quest_Commands]]
 
*[[Quest_Commands]]
 
 
 
 
 
 
 
 
  
 
{{TocRight}}
 
{{TocRight}}
 
 
==entry ==
 
==entry ==
  

Revision as of 12:23, 31 August 2012

+/-
Main Page                   Other languages:   English  •   German   •   FrenchArcEmu Website     ArcEmu Forum     Bug Tracker


Description

This table contains all base information on quests.

See also

Creatures

Game Objects

Items

Commands

Contents


entry

Is the ID of the quest


ZoneId

ID for sorting the zone in the Questlog.


sort

Categorizes the quest
0   => <NOT SET>
1   => Epic
21  => REUSE - Old Wailing Caverns
22  => Seasonal
23  => REUSE - Old Undercity
24  => Herbalism
25  => Battlegrounds
41  => REUSE - Old Uldaman
61  => Warlock
81  => Warrior
82  => Shaman
101 => Fishing
121 => Blacksmithing
141 => Paladin
161 => Mage
162 => Rogue
181 => Alchemy
182 => Leatherworking
201 => Engineering
221 => Treasure Map
241 => REUSE - Old Sunken Temple
261 => Hunter
262 => Priest
263 => Druid
264 => Tailoring
284 => Special
304 => Cooking
324 => First Aid
344 => Legendary
364 => Darkmoon Faire
365 => Ahn'Qiraj War
366 => Lunar Festival
367 => Reputation
368 => Invasion
369 => Midsummer
370 => Brewfest
371 => Inscription
372 => Death Knight
373 => Jewelcrafting


flags

 0   => QUEST_FLAG_NONE
 1   => QUEST_FLAG_DELIVER   
 2   => QUEST_FLAG_KILL
 4   => QUEST_FLAG_SPEAKTO
 8   => QUEST_FLAG_REPEATABLE
16   => QUEST_FLAG_EXPLORATION
32   => QUEST_FLAG_TIMED
128  => QUEST_FLAG_REPUTATION
4096 => QUEST_FLAG_ONLY_ONE_REQUIRED


MinLevel

Minimum level required to obtain the quest.


questlevel

The level "recommended" to do the quest. Quest color (Grey, green, yellow, orange, red) are based on:
Grey   => 5+ levels below "questlevel".
Green  => 3+ levels below "questlevel".
Yellow => Within 2 levels of "questlevel".
Orange => 3+ levels above "questlevel".
Red    => 5+ levels above "questlevel".

Type

The type of the quest:
0  => Normal
1  => Group
21 => Life
41 => PvP
62 => Raid
81 => Dungeon
82 => World Event
83 => Legendary
84 => Escort
85 => Heroic
88 => Raid (10)
89 => Raid (25)


RequiredRaces

Races who can accept/view this quest:
0    => All Races
1    => Human
2    => Orc
4    => Dwarf
8    => Night Elf
16   => Undead
32   => Tauren
64   => Gnome
128  => Troll
512  => Blood Elf
1024 => Draenei
690  => All the Hordes Races
1101 => All the Alliance Races

RequiredClass

Classes who can accept/view this quest:
0    => All Classes
1    => Warrior
2    => Paladin
4    => Hunter
8    => Rogue
16   => Priest
32   => Death Knight
64   => Shaman
128  => Mage
256  => Warlock
1024 => Druid

RequiredTradeskill

Required Tradeskill/Profession to accept/view the quest (Unknown if implemented on ArcEmu.)
171 => Alchemy
164 => Blacksmith
333 => Enchanting
202 => Engineering
182 => Herbalism
755 => Jewelcrafting
165 => Leatherworking
186 => Mining
393 => Skinning
197 => Tailoring
185 => Cooking
129 => First Aid
356 => Fishing
762 => Riding


RequiredRepFaction

Reputation needed with specific faction to obtain quest


RequiredRepValue

Value of the reputation required to obtain the quest
3000  => Friendly
9000  => Honored
21000 => Revered
42000 => Exalted


LimitTime

Quests that need to be completed in specified time (in milliseconds, not yet implemented on ArcEmu)


SpecialFlags

Not Used


PrevQuestId

Previous quest in quest chain, not used in core.

NextQuestId

Quest that will be displayed right after you finish this one (thus, only works if quest finisher starts the next quest)


srcItem

Item that is provided by quest giver on quest start


SrcItemCount

Count of items You will get on quest acception


Title

Title of the quest


Details

(See also: Text replacements)

Detail of the quest


Objectives

The main objectives of the quest


CompletionText

Text shown when quest is completed


IncompleteText

Text shown when quest is incomplete


EndText

Text shown when quest is completed (like go and see Toto he can have a quest for you - CF NextQuestId)


ObjectiveText1-4

Objective displayed on quest log (Usually used for quests requiring to interact with several GOs)


ReqItemId1-4

ID of items required to be delivered to quest finisher.


ReqItemCount1-4

Count of required items


ReqKillMobOrGOId1-4

Required ID of Mob(s) to be killed, or Game Object(s) to be interacted with (GOs are not fully implemented)


ReqKillMobOrGOCount1-4

Count of mob(s) to kill, or Game Object(s) to interact with


ReqCastSpellId1-4

ID of the spell you must cast in order to complete the quest


RewChoiceItemId1-6

Item ID's from which player can choose as a quest reward (can only chose 1)


RewChoiceItemCount1-6

Count of each item


RewItemId1-4

ID of Item you attain when you complete the quest (found in 'items'), can be mixed with rewchoiceitems


RewItemCount1-4

Amount of the items you are rewarded with


RewRepFaction1-6

ID of faction for which You will get reputation on quest finish


RewRepValue1-6

Value of Reputation You will gain on quest finish


RewRepLimit

Reputation value on player at which the quest wont give anymore reputation (will only disable reputation given. Quest can still be completed)


RewMoney

Money you earn when finishing quest (in copper [e.x. - 105075 = 10g 50s 75c) Negative value means that quest require money.


RewXP

EXP your are rewarded with when you complete the Quest


RewSpell

spell you ATTAIN when finishing quest, SHOULD BE AVOIDED (only use it if you know what you are doing)


CastSpell

Spell cast on the player, when they complete the quest (this SHOULD be used for teaching player spells, using the TRAINER spells)


PointMapId, PointX, PointY, PointOpt

Used for checkpoint types, or planned for use as such. Probably overwritten by triggers. (needs conformation)


RewardMoneyAtMaxLevel

Money you receive when you complete the quest at the server's max level


ExploreTrigger1-4

Areatriggers players need to go to, for finishing quest (used for exploration quests. Can be found in areatriggers)


RequiredOneOfQuest

IDs of quests that you must have completed one of to obtain this quest


RequiredQuest1-4

Quests player must complete before attaining this quest


RemoveQuests

On Completion these quests will be marked as completed for the player and therefore they will never show up for him again.

ReceiveItemId1-4

Item you will receive when accepting quest (should not exist at all, avoid)


ReceiveItemCount1-4

count of item received


IsRepeatable

0 => Non-Repeatable
1 => Repeatable (Repeatable quests are really bad on ArcEmu, they will override every requirement [e.x. - level, class, previous quests, tradeskill, etc.])
2 => Daily quest


bonushonor

The amount of Honor you get when you complete the quest


rewardtitleid

The ID of a Title you get when you complete the quest (found in DBC files)


rewardtalents

The amount of Talent Points you get when you complete the quest


suggestedplayers

The amount of players suggested to complete the quest (untested)


SQL Structure

CREATE TABLE `quests` (
  `entry` int(10) unsigned NOT NULL default '0',
  `ZoneId` int(10) unsigned NOT NULL default '0',
  `sort` int(10) unsigned NOT NULL default '0',
  `flags` int(10) unsigned NOT NULL default '0',
  `MinLevel` int(10) unsigned NOT NULL default '0',
  `questlevel` int(10) unsigned NOT NULL default '0',
  `Type` int(10) unsigned NOT NULL default '0',
  `RequiredRaces` int(10) unsigned NOT NULL default '0',
  `RequiredClass` int(10) unsigned NOT NULL default '0',
  `RequiredTradeskill` int(10) unsigned NOT NULL default '0',
  `RequiredTradeskillValue` int(5) unsigned NOT NULL default '0',
  `RequiredRepFaction` int(10) unsigned NOT NULL default '0',
  `RequiredRepValue` int(10) unsigned NOT NULL default '0',
  `LimitTime` int(10) unsigned NOT NULL default '0',
  `SpecialFlags` int(10) unsigned NOT NULL default '0',
  `PrevQuestId` int(10) unsigned NOT NULL default '0',
  `NextQuestId` int(10) unsigned NOT NULL default '0',
  `srcItem` int(10) unsigned NOT NULL default '0',
  `SrcItemCount` int(10) unsigned NOT NULL default '0',
  `Title` char(255) NOT NULL,
  `Details` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `Objectives` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `CompletionText` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `IncompleteText` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `EndText` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `ObjectiveText1` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `ObjectiveText2` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `ObjectiveText3` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `ObjectiveText4` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `ReqItemId1` int(10) unsigned NOT NULL default '0',
  `ReqItemId2` int(10) unsigned NOT NULL default '0',
  `ReqItemId3` int(10) unsigned NOT NULL default '0',
  `ReqItemId4` int(10) unsigned NOT NULL default '0',
  `ReqItemId5` int(10) unsigned NOT NULL default '0',
  `ReqItemId6` int(10) unsigned NOT NULL default '0',
  `ReqItemCount1` int(10) unsigned NOT NULL default '0',
  `ReqItemCount2` int(10) unsigned NOT NULL default '0',
  `ReqItemCount3` int(10) unsigned NOT NULL default '0',
  `ReqItemCount4` int(10) unsigned NOT NULL default '0',
  `ReqItemCount5` int(10) unsigned NOT NULL default '0',
  `ReqItemCount6` int(10) unsigned NOT NULL default '0',
  `ReqKillMobOrGOId1` int(10) NOT NULL default '0',
  `ReqKillMobOrGOId2` int(10) NOT NULL default '0',
  `ReqKillMobOrGOId3` int(10) NOT NULL default '0',
  `ReqKillMobOrGOId4` int(10) NOT NULL default '0',
  `ReqKillMobOrGOCount1` int(10) unsigned NOT NULL default '0',
  `ReqKillMobOrGOCount2` int(10) unsigned NOT NULL default '0',
  `ReqKillMobOrGOCount3` int(10) unsigned NOT NULL default '0',
  `ReqKillMobOrGOCount4` int(10) unsigned NOT NULL default '0',
  `ReqCastSpellId1` int(11) NOT NULL default '0',
  `ReqCastSpellId2` int(11) NOT NULL default '0',
  `ReqCastSpellId3` int(11) NOT NULL default '0',
  `ReqCastSpellId4` int(11) NOT NULL default '0',
  `ReqEmoteId1` int(10) unsigned default '0',
  `ReqEmoteId2` int(10) unsigned default '0',
  `ReqEmoteId3` int(10) unsigned default '0',
  `ReqEmoteId4` int(10) unsigned default '0',
  `RewChoiceItemId1` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemId2` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemId3` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemId4` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemId5` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemId6` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemCount1` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemCount2` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemCount3` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemCount4` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemCount5` int(10) unsigned NOT NULL default '0',
  `RewChoiceItemCount6` int(10) unsigned NOT NULL default '0',
  `RewItemId1` int(10) unsigned NOT NULL default '0',
  `RewItemId2` int(10) unsigned NOT NULL default '0',
  `RewItemId3` int(10) unsigned NOT NULL default '0',
  `RewItemId4` int(10) unsigned NOT NULL default '0',
  `RewItemCount1` int(10) unsigned NOT NULL default '0',
  `RewItemCount2` int(10) unsigned NOT NULL default '0',
  `RewItemCount3` int(10) unsigned NOT NULL default '0',
  `RewItemCount4` int(10) unsigned NOT NULL default '0',
  `RewRepFaction1` int(10) unsigned NOT NULL default '0',
  `RewRepFaction2` int(10) unsigned NOT NULL default '0',
  `RewRepFaction3` int(10) unsigned NOT NULL default '0',
  `RewRepFaction4` int(10) unsigned NOT NULL default '0',
  `RewRepFaction5` int(10) unsigned NOT NULL default '0',
  `RewRepFaction6` int(10) unsigned NOT NULL default '0',
  `RewRepValue1` int(10) NOT NULL default '0',
  `RewRepValue2` int(10) NOT NULL default '0',
  `RewRepValue3` int(10) unsigned NOT NULL default '0',
  `RewRepValue4` int(10) unsigned NOT NULL default '0',
  `RewRepValue5` int(10) unsigned NOT NULL default '0',
  `RewRepValue6` int(10) unsigned NOT NULL default '0',
  `RewRepLimit` int(10) unsigned NOT NULL default '0',
  `RewMoney` int(10) NOT NULL default '0',
  `RewXP` int(10) unsigned NOT NULL default '0',
  `RewSpell` int(10) unsigned NOT NULL default '0',
  `CastSpell` int(10) unsigned NOT NULL default '0',
  `PointMapId` int(10) unsigned NOT NULL default '0',
  `PointX` float NOT NULL default '0',
  `PointY` float NOT NULL default '0',
  `PointOpt` int(10) unsigned NOT NULL default '0',
  `RewardMoneyAtMaxLevel` int(10) unsigned NOT NULL default '0',
  `ExploreTrigger1` int(10) unsigned NOT NULL default '0',
  `ExploreTrigger2` int(10) unsigned NOT NULL default '0',
  `ExploreTrigger3` int(10) unsigned NOT NULL default '0',
  `ExploreTrigger4` int(10) unsigned NOT NULL default '0',
  `RequiredOneOfQuest` longtext NOT NULL,
  `RequiredQuest1` int(10) unsigned NOT NULL default '0',
  `RequiredQuest2` int(10) unsigned NOT NULL default '0',
  `RequiredQuest3` int(10) unsigned NOT NULL default '0',
  `RequiredQuest4` int(10) unsigned NOT NULL default '0',
  `RemoveQuests` longtext NOT NULL,
  `ReceiveItemId1` int(10) unsigned NOT NULL default '0',
  `ReceiveItemId2` int(10) unsigned NOT NULL default '0',
  `ReceiveItemId3` int(10) unsigned NOT NULL default '0',
  `ReceiveItemId4` int(10) unsigned NOT NULL default '0',
  `ReceiveItemCount1` int(10) unsigned NOT NULL default '0',
  `ReceiveItemCount2` int(10) unsigned NOT NULL default '0',
  `ReceiveItemCount3` int(10) unsigned NOT NULL default '0',
  `ReceiveItemCount4` int(10) unsigned NOT NULL default '0',
  `IsRepeatable` int(11) NOT NULL default '0',
  `bonushonor` int(10) unsigned NOT NULL default '0',
  `rewardtitleid` int(10) unsigned NOT NULL default '0',
  `rewardtalents` int(10) unsigned NOT NULL default '0',
  `suggestedplayers` int(10) unsigned NOT NULL default '0',
  `detailemotecount` int(10) unsigned NOT NULL default '0',
  `detailemote1` int(10) unsigned NOT NULL default '0',
  `detailemote2` int(10) unsigned NOT NULL default '0',
  `detailemote3` int(10) unsigned NOT NULL default '0',
  `detailemote4` int(10) unsigned NOT NULL default '0',
  `detailemotedelay1` int(10) unsigned NOT NULL default '0',
  `detailemotedelay2` int(10) unsigned NOT NULL default '0',
  `detailemotedelay3` int(10) unsigned NOT NULL default '0',
  `detailemotedelay4` int(10) unsigned NOT NULL default '0',
  `completionemotecnt` int(10) unsigned NOT NULL default '0',
  `completionemote1` int(10) unsigned NOT NULL default '0',
  `completionemote2` int(10) unsigned NOT NULL default '0',
  `completionemote3` int(10) unsigned NOT NULL default '0',
  `completionemote4` int(10) unsigned NOT NULL default '0',
  `completionemotedelay1` int(10) unsigned NOT NULL default '0',
  `completionemotedelay2` int(10) unsigned NOT NULL default '0',
  `completionemotedelay3` int(10) unsigned NOT NULL default '0',
  `completionemotedelay4` int(10) unsigned NOT NULL default '0',
  `completeemote` int(10) unsigned NOT NULL default '0',
  `incompleteemote` int(10) unsigned NOT NULL default '0',
  `iscompletedbyspelleffect` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Quests System';
Personal tools