eqanswers

AND OR -exclude "exact phrase" prefix*  ·  operators must be uppercase, so salt and pepper stays a plain search

Reference tables

4,288 identifiers across 66 tables, taken from the EQEmu documentation and indexed so a value can be looked up in either direction. These are the answers the search index cannot give you: nobody writes a forum post stating a race ID.

Smaller tables

48 tables of fewer than 20 rows, in full.

Readme 25

Activity Types

Type IDType NameInformation and usage
1DeliverTo have this activity automatically handled by the task system without the need to write any Perl quest code, set: goalmethod 0 goalid to the id of the item you want delivered delivertonpc to the npc_types id you want the item delivered to zoneid to the zoneidnumber the npc is in (or 0 for all) If you wish to allow the player to deliver any out of a group of items, then you can use a list. To do this, create a list in the goallist table containing the allowable items. Then set the goalmethod to 1 and put the list number in the goalid field.
2KillTo have this activity automatically handled by the task system without the need to write any Perl quest code, set: goalmethod to 0 goalid to the id of the npc that must be killed (from the npc_types table). zoneid should be set to 0 (any zone), or the zoneidnumber if the mobs must be killed in a particular zone to count. If you wish to allow the player to kill any out of a group of NPC types, then you can use a list as described for the Deliver activity. For common mobs, you will probably always be using lists, since there are a lot of entries for mobs with the same name in the npc_types table which differ by level, etc.
3LootTo have this activity automatically handled by the task system without the need to write any Perl quest code, set: goalmethod to 0 goalid to the id of the item that must be looted (from the items table). zoneid should be set to 0 (any zone), or the zoneidnumber if the item must be looted in a particular zone to count. If you wish to allow the player to loot any one of a group of items, then you can use a list as described for the Deliver activity.
4Speak WithTo have this activity automatically handled by the task system without the need to write any Perl quest code, set: goalmethod to 0 goalid to the id of the NPC that must be spoken to (from the npc_types table). zoneid should be set to 0 (any zone), or the zoneidnumber that the NPC is in. If you wish to allow the player to speak to any one of a group of NPCs, then you can use a list as described for the Deliver activity.
5ExploreTo have this activity automatically handled by the task system without the need to write any Perl quest code, you will need to add a row to the proximity table. Once you have added the row and given it a unique exploreid number, in the activity table, set: goalmethod to 0 goalid to the exploreid of your newly created row in the proximity table. zoneid should be set to the zoneidnumber that the proximity is in. It should be possible to set up multiple proximities in the same zone, using lists, such that any of the proximities will trigger the activity complete.
6TradeskillTo have this activity automatically handled by the task system, set: goalmethod to 0 goalid to the id of the item that must be created (from the items table). zoneid should be set to 0 (any zone), or the zoneidnumber that the items must be created in. If you wish to allow the player to create any one of a group of items, then you can use a list as described for the Deliver activity. Sometimes there are several items with the same name that can be created from a tradeskill, CLASS 1 Wood Point arrows being one of them.
7FishTo have this activity automatically handled by the task system, set: goalmethod to 0 goalid to the id of the item that must be fished (from the items table). zoneid should be set to 0 (any zone), or the zoneidnumber that the items must be fished in. If you wish to allow the player to fish any one of a group of items, then you can use a list as described for the Deliver activity.
8ForageTo have this activity automatically handled by the task system, set: goalmethod to 0 goalid to the id of the item that must be foraged (from the items table). zoneid should be set to 0 (any zone), or the zoneidnumber that the items must be fished in. If you wish to allow the player to forage any one of a group of items, then you can use a list as described for the Deliver activity.
9Use
10Use
11TouchTo have this activity automatically handled by the task system, set: goalmethod to 0 Since the zoneid field is used to specify the zoneidnumber, the goalid field is not used. It is also not possible to specify a list of zones.
100Give CashTo have this activity automatically handled by the task system, set: goalmethod to 0 npctypeid to the id of the NPC that the cash should be given to zoneid should be set to 0 (any zone), or the zoneidnumber that the NPC is found in.

Task System Rules

Default ValueRule NameDescription
TrueTaskSystem:KeepOneRecordPerCompletedTaskKeeps one record for each completed task (the client displays the most recent 50; use quest::istaskcompleted for lookups).
TrueTaskSystem:EnableTaskProximityMakes use of the 'proximities' table, independent of quest::set_proximitiy
TrueTaskSystem:RecordCompletedOptionalActivitiesMakes use of the 'character_activities' table for optional tasks
5TaskSystem:PeriodicCheckTimerSeconds between checks for failed tasks. Also used by the 'Touch' activity
TrueTaskSystem:RecordCompletedTasksMakes use of the 'character_activities' table for non-optional tasks
TrueTaskSystem:EnableTaskSystemGlobally enable or disable the Task system
FalseQueryServ:PlayerLogTaskUpdatesLogs Player Task Updates

ExpeditionLockMessage

valueconstantlock message
0None
1Close"Your expedition is nearing its close. You cannot bring any additional people into your expedition at this time."
2Begin"The trial has begun. You cannot bring any additional people into your expedition at this time."
0None
1Close"Your expedition is nearing its close. You cannot bring any additional people into your expedition at this time."
2Begin"The trial has begun. You cannot bring any additional people into your expedition at this time."

Aa Nonspell Actions 16

Nonspell Action IDNonspell Action Name
0No Action
1AE Taunt
2Mass Buff
3Flaming Arrows
4Frost Arrows
5Rampage
6Shared Health
7Celestial Regeneration
8Dire Charm
9Improved Familiar
10Act of Valor
11Suspended Minion
12Escape
13Bestial Alignment
14Leech Touch
15Project Illusion

Bot Spell List Ids 16

Bot Spell List IDBot Spell List Name
3001Warrior
3002Cleric
3003Paladin
3004Ranger
3005Shadow Knight
3006Druid
3007Monk
3008Bard
3009Rogue
3010Shaman
3011Necromancer
3012Wizard
3013Magician
3014Enchanter
3015Beastlord
3016Berserker

Fields 16

ValueParamType
0Params[1]DWORD
1Params[2]FLOAT
-1.0Params[5]FLOAT
1.0Params[6]FLOAT
1.0Params[8]FLOAT
1.0Params[9]FLOAT
1.0Params[11]FLOAT
-1.0Params[12]FLOAT
-1.0Params[14]FLOAT
-1.0Params[15]FLOAT
4Params[16]DWORD
1Params[20]DWORD
2Params[21]DWORD
3Params[22]DWORD
1Params[24]DWORD
11Params[25]DWORD

Converting Qglobals 15

Shortcuts for Globals

ValueShortcut
1All NPCs
2All Players
3All NPCs and Players
4All Zones
5All NPCs and Zones
6All Players and Zones
7All NPCs, Players and Zones

Types of Globals and their specificities:

NPC IDTypePlayerZone
Current0CurrentCurrent
All1CurrentCurrent
Current2AllCurrent
All3AllCurrent
Current4CurrentAll
All5CurrentAll
Current6AllAll
All7AllAll

Food And Drink 14

Drink

ValueDescription
0-5This is a whistle wetter.
6-20This is a drink.
21-30This is a refreshing drink.
31-40This is a lasting drink.
41-50This is a flowing drink!
51-60This is an enduring drink!
61-XThis is a miraculous drink!

Food

ValueDescription
0-5This is a snack.
6-20This is a meal.
21-30This is a hearty meal.
31-40This is a banquet size meal.
41-50This meal is a feast!
51-60This is an enduring meal!
61-XThis is a miraculous meal!

Alternate Currencies 12

Currency IDItem NameItem ID
10Doubloon79910
11Orum79911
12Phosphene79912
13Phosphite79913
14Faycetum100941
15Chronobine103000
16Silver Token43942
18McKenzie's Special Brew41408
19Bayle Mark46779
20Token of Reclamation47698
21Brellium Token47900
22Dream Mote52149

Task Activity Types 12

Task Activity Type IDTask Activity Type Name
1Deliver
2Kill
3Loot
4Speak With
5Explore
6Tradeskill
7Fish
8Forage
9Use
10Use
11Touch
100Give Cash

Aa Types 11

Type IDType Name
0Not Applicable
1General
2Archetype
3Class
4Planes of Power Advanced
5Planes of Power Abilities
6Gates of Discord
7Omens of War
8Veteran
9Dragons of Norrath
10Depths of Darkhollow

Aa Categories 10

Category IDCategory Name
-1None
1Passive
2Progression
3Shroud Passive
4Shroud Active
5Veteran Reward
6Tradeskill
7Expendable
8Racial Innate
9EverQuest

Spell Resist Types 10

ValueResist TypeNOTES
0NONEUnresistable
1MAGIC
2FIRE
3COLD
4POISON
5DISEASE
6CHROMATICResist amount is the averages of MR, FR, CR, PR and DR
7PRISMATICResist amount is your lowest resist value from MR, FR, CR, PR or DR
8PHYSICALThis resist type exists on NPC's and uses a different formula than standard resists. Resist All spell effects do NOT raise this.
9CORRUPTION

Stance Types 10

Stance Type IDStance Type Name
0Unknown
1Passive
2Balanced
3Efficient
4Reactive
5Aggressive
6Assist
7Burn
8Efficient 2
9Burn AE

Add Grid Entries 10

NumberXYZHeadingPause
0-162.35-152.1416.78-130
1-132.503-153.42115.9178-130
2-94.1068-148.68414.2662-130
3-34.0962-141.68414.7164-130
423.1549-111.44913.9895-130
538.2853-40.257216.5154-130
6-57.144-53.456719.0392-130
7-94.8163-2.6610120.0491-130
8-143.811-35.400718.8172-130
9-177.327-82.134619.5479-130

Approach 9

ValueFaction
1100+Ally
750 to 1099Warmly
500 to 749Kindly
100 to 499Amiable
0 to 99Indifferent
-1 to -100Apprehensive
-101 to -500Dubious
-501 to -750Threateningly
-751Ready to Attack

Creating A New Faction 9

Faction ValueFaction CON
1100 -> ABOVEALLY
750 -> 1099WARMLY
500 -> 749KINDLY
100 -> 400AMIABLE
0 -> 99INDIFFERENT
-100 -> -1APPREHENSIVE
-500 -> -101DUBIOUS
-750 -> -501THREATENLY
BELOW -> -751SCOWLS

Consider Levels 9

Consider Level IDConsider Level Name
1Ally
2Warmly
3Kindly
4Amiably
5Indifferently
6Apprehensively
7Dubiously
8Threateningly
9Scowls

Consider Levels From Faction Values 9

Total Faction ValueFaction CON
1100 -> ABOVEALLY
750 -> 1099WARMLY
500 -> 749KINDLY
100 -> 499AMIABLE
0 -> 99INDIFFERENT
-100 -> -1APPREHENSIVE
-500 -> -101DUBIOUS
-750 -> -501THREATENLY
BELOW -> -751SCOWLS

Emote Event Types 9

Emote Event Type IDEmote Event Type Name
0Leave Combat
1Enter Combat
2On Death
3After Death
4Hailed
5Killed PC
6Killed NPC
7On Spawn
8On Despawn

Create The New Base Faction To Faction List 9

Faction ValueFaction CON
1100 -> ABOVEALLY
750 -> 1099WARMLY
500 -> 749KINDLY
100 -> 400AMIABLE
0 -> 99INDIFFERENT
-100 -> -1APPREHENSIVE
-500 -> -101DUBIOUS
-750 -> -501THREATENLY
BELOW -> -751SCOWLS

Npc Spell Categories 9

NPC Spell Category IDNPC Spell Category Name
0Not Applicable (Non NPC Spell)
1Area of Effect Detrimental
2Single Target Detrimental
3Buffs
4Pet Spells
5Healing Spells
6Gate or Last Cast
7Debuffs
8Dispells

Aura Types 8

Aura Type IDAura Type Name
0On All Friendlies
1On All Group Members
2On Group Members' Pets
3Totem
4Enter Trap
5Exit Trap
6Fully Scripted
7Max

Consider Colors 8

Consider Color IDConsider Color Name
2Green
4Blue
6Gray
10White
13Red
15Yellow
18Light Blue
20White (Titanium)

Databucket Time Input Examples 6

ValueInput
15 seconds15s
15 secondss15
60 minutes60m
7 days7d
1 year1y
600 seconds600

Aa Target Types 6

Target Type IDTarget Type Name
0None
1Self
2Current Target (Single)
3Group
4Group of Current Target
5Pet

Bard Types 6

Bard Type IDBard Type Name
23Wind Instruments
24Stringed Instruments
25Brass Instruments
26Percussion Instruments
50Singing
51All

Damage Shield Types 6

Damage Shield Type IDDamage Shield Type Name
244Decay
245Chilled
246Freezing
247Torment
248Burn
249Thorns

Fly Modes 6

Fly Mode IDFly Mode Name
0Ground
1Flying
2Levitating
3Water
4Floating
5Levitate While Running

World Pvpsettings 6

ValueNameDesc
0DisabledDefault, No PVP Enabled
1Rallos ZekNot yet supported
2TZ/VZPartial Support
4Sullon ZekPartial support
6DiscordPartial Support
7+Discord+ (Any value above 6)Discord without the no-drop restrictions removed

Action Types 5

Action Type IDAction Type Name
0Set Condition
1Add to Condition
2Subtract from Condition
3Multiply Condition
4Divide Condition

Item Element Types 5

Element Type IDElement Type
1Magic
2Fire
3Cold
4Poison
5Disease

Ldon Themes 5

LDoN Theme IDLDoN Theme
1Deepest Guk
2Miragul's Menagerie
3Mistmoore Catacombs
4Rujarkian Hills
5Takish-Hiz

Npc Animation Types 5

NPC Animation Type IDNPC Animation Type Name
0Standing
1Sitting
2Crouching
3Laying
4Looting

Npc Despawn Types 5

NPC Despawn Type IDNPC Despawn Type Name
0None
1Repop
2Repop on Timer
3Depop
4Depop on Timer

On Change Types 5

On Change Type IDOn Change Type Name
0Do Nothing
1Depop
2Repop
3Repop If Ready
10Signal

Zone Types 5

Zone Type IDZone Type Name
-1None
0Indoors
1Outdoors
2Dungeon
255Any

Aura Movement Types 4

Aura Movement Type IDAura Movement Type Name
0Follow
1Stationary
2Pathing
3Max

Aura Spawn Types 4

Aura Spawn Type IDAura Spawn Type Name
0Group Members
1Everyone
2No One
3Max

Bag Sizes 4

Bag Size IDBag Size
1Small
2Medium
3Large
4Giant

Item Click Types 4

Click Type IDClick Type
1Item can be cast from any slot.
3Item can be cast from any slot.
4Item must be equipped to cast effect.
5Seems to involve poisoning a weapon.

Task Duration Codes 4

Task Duration Code IDTask Duration Code Name
0None
1Short
2Medium
3Long

Task Types 4

Task Type IDTask Type Name
0Task
1Shared
2Quest
3Expedition

Emote Types 3

Emote Type IDEmote Type Name
1Emote
2Shout
3Proximity Emote, Other - Say

Environment Types 3

Environment Type IDEnvironment Type Name
0Everywhere
12Cities
24Planes

Genders 3

Gender IDGender Name
0Male
1Female
2Neuter

Item Class 3

Item Class IDItem Class
0Common item
1Container
2Book

Item Lore Groups 3

Lore Group IDLore Group
-1Standard Lore Item.
0Not a Lore Item.
>0A member of a lore group.

Time Of Day Types 3

Time of Day Type IDTime of Day Type Name
0Any Time
1Day Time
2Night Time

Blocked Spell Types 2

Blocked Spell Type IDBlocked Spell Type Name
1Zone-wide
2Region