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.
- Server Rules850
- Race List743
- Environment Emitters626
- Spell Effect Ids527
- Zone List483
- Spell Groups183
- Expansion100
- Logging Categories84
- Bot Spell Types76
- Class List45
- Emote Colors32
- Languages28
- Player Housing Zones27
- Textures25
- Item Slots23
- Mob Version List22
- Spell Types22
- Buff Duration Formulas21
Smaller tables
48 tables of fewer than 20 rows, in full.
Readme 25
Activity Types
| Type ID | Type Name | Information and usage |
|---|---|---|
1 | Deliver | To 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. |
2 | Kill | To 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. |
3 | Loot | To 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. |
4 | Speak With | To 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. |
5 | Explore | To 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. |
6 | Tradeskill | To 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. |
7 | Fish | To 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. |
8 | Forage | To 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. |
9 | Use | |
10 | Use | |
11 | Touch | To 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. |
100 | Give Cash | To 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 Value | Rule Name | Description |
|---|---|---|
True | TaskSystem:KeepOneRecordPerCompletedTask | Keeps one record for each completed task (the client displays the most recent 50; use quest::istaskcompleted for lookups). |
True | TaskSystem:EnableTaskProximity | Makes use of the 'proximities' table, independent of quest::set_proximitiy |
True | TaskSystem:RecordCompletedOptionalActivities | Makes use of the 'character_activities' table for optional tasks |
5 | TaskSystem:PeriodicCheckTimer | Seconds between checks for failed tasks. Also used by the 'Touch' activity |
True | TaskSystem:RecordCompletedTasks | Makes use of the 'character_activities' table for non-optional tasks |
True | TaskSystem:EnableTaskSystem | Globally enable or disable the Task system |
False | QueryServ:PlayerLogTaskUpdates | Logs Player Task Updates |
ExpeditionLockMessage
| value | constant | lock message |
|---|---|---|
0 | None | |
1 | Close | "Your expedition is nearing its close. You cannot bring any additional people into your expedition at this time." |
2 | Begin | "The trial has begun. You cannot bring any additional people into your expedition at this time." |
0 | None | |
1 | Close | "Your expedition is nearing its close. You cannot bring any additional people into your expedition at this time." |
2 | Begin | "The trial has begun. You cannot bring any additional people into your expedition at this time." |
Aa Nonspell Actions 16
| Nonspell Action ID | Nonspell Action Name |
|---|---|
0 | No Action |
1 | AE Taunt |
2 | Mass Buff |
3 | Flaming Arrows |
4 | Frost Arrows |
5 | Rampage |
6 | Shared Health |
7 | Celestial Regeneration |
8 | Dire Charm |
9 | Improved Familiar |
10 | Act of Valor |
11 | Suspended Minion |
12 | Escape |
13 | Bestial Alignment |
14 | Leech Touch |
15 | Project Illusion |
Bot Spell List Ids 16
| Bot Spell List ID | Bot Spell List Name |
|---|---|
3001 | Warrior |
3002 | Cleric |
3003 | Paladin |
3004 | Ranger |
3005 | Shadow Knight |
3006 | Druid |
3007 | Monk |
3008 | Bard |
3009 | Rogue |
3010 | Shaman |
3011 | Necromancer |
3012 | Wizard |
3013 | Magician |
3014 | Enchanter |
3015 | Beastlord |
3016 | Berserker |
Fields 16
| Value | Param | Type |
|---|---|---|
0 | Params[1] | DWORD |
1 | Params[2] | FLOAT |
-1.0 | Params[5] | FLOAT |
1.0 | Params[6] | FLOAT |
1.0 | Params[8] | FLOAT |
1.0 | Params[9] | FLOAT |
1.0 | Params[11] | FLOAT |
-1.0 | Params[12] | FLOAT |
-1.0 | Params[14] | FLOAT |
-1.0 | Params[15] | FLOAT |
4 | Params[16] | DWORD |
1 | Params[20] | DWORD |
2 | Params[21] | DWORD |
3 | Params[22] | DWORD |
1 | Params[24] | DWORD |
11 | Params[25] | DWORD |
Converting Qglobals 15
Shortcuts for Globals
| Value | Shortcut |
|---|---|
1 | All NPCs |
2 | All Players |
3 | All NPCs and Players |
4 | All Zones |
5 | All NPCs and Zones |
6 | All Players and Zones |
7 | All NPCs, Players and Zones |
Types of Globals and their specificities:
| NPC ID | Type | Player | Zone |
|---|---|---|---|
Current | 0 | Current | Current |
All | 1 | Current | Current |
Current | 2 | All | Current |
All | 3 | All | Current |
Current | 4 | Current | All |
All | 5 | Current | All |
Current | 6 | All | All |
All | 7 | All | All |
Food And Drink 14
Drink
| Value | Description |
|---|---|
0-5 | This is a whistle wetter. |
6-20 | This is a drink. |
21-30 | This is a refreshing drink. |
31-40 | This is a lasting drink. |
41-50 | This is a flowing drink! |
51-60 | This is an enduring drink! |
61-X | This is a miraculous drink! |
Food
| Value | Description |
|---|---|
0-5 | This is a snack. |
6-20 | This is a meal. |
21-30 | This is a hearty meal. |
31-40 | This is a banquet size meal. |
41-50 | This meal is a feast! |
51-60 | This is an enduring meal! |
61-X | This is a miraculous meal! |
Alternate Currencies 12
| Currency ID | Item Name | Item ID |
|---|---|---|
10 | Doubloon | 79910 |
11 | Orum | 79911 |
12 | Phosphene | 79912 |
13 | Phosphite | 79913 |
14 | Faycetum | 100941 |
15 | Chronobine | 103000 |
16 | Silver Token | 43942 |
18 | McKenzie's Special Brew | 41408 |
19 | Bayle Mark | 46779 |
20 | Token of Reclamation | 47698 |
21 | Brellium Token | 47900 |
22 | Dream Mote | 52149 |
Task Activity Types 12
| Task Activity Type ID | Task Activity Type Name |
|---|---|
1 | Deliver |
2 | Kill |
3 | Loot |
4 | Speak With |
5 | Explore |
6 | Tradeskill |
7 | Fish |
8 | Forage |
9 | Use |
10 | Use |
11 | Touch |
100 | Give Cash |
Aa Types 11
| Type ID | Type Name |
|---|---|
0 | Not Applicable |
1 | General |
2 | Archetype |
3 | Class |
4 | Planes of Power Advanced |
5 | Planes of Power Abilities |
6 | Gates of Discord |
7 | Omens of War |
8 | Veteran |
9 | Dragons of Norrath |
10 | Depths of Darkhollow |
Aa Categories 10
| Category ID | Category Name |
|---|---|
-1 | None |
1 | Passive |
2 | Progression |
3 | Shroud Passive |
4 | Shroud Active |
5 | Veteran Reward |
6 | Tradeskill |
7 | Expendable |
8 | Racial Innate |
9 | EverQuest |
Spell Resist Types 10
| Value | Resist Type | NOTES |
|---|---|---|
0 | NONE | Unresistable |
1 | MAGIC | |
2 | FIRE | |
3 | COLD | |
4 | POISON | |
5 | DISEASE | |
6 | CHROMATIC | Resist amount is the averages of MR, FR, CR, PR and DR |
7 | PRISMATIC | Resist amount is your lowest resist value from MR, FR, CR, PR or DR |
8 | PHYSICAL | This resist type exists on NPC's and uses a different formula than standard resists. Resist All spell effects do NOT raise this. |
9 | CORRUPTION |
Stance Types 10
| Stance Type ID | Stance Type Name |
|---|---|
0 | Unknown |
1 | Passive |
2 | Balanced |
3 | Efficient |
4 | Reactive |
5 | Aggressive |
6 | Assist |
7 | Burn |
8 | Efficient 2 |
9 | Burn AE |
Add Grid Entries 10
| Number | X | Y | Z | Heading | Pause |
|---|---|---|---|---|---|
0 | -162.35 | -152.14 | 16.78 | -1 | 30 |
1 | -132.503 | -153.421 | 15.9178 | -1 | 30 |
2 | -94.1068 | -148.684 | 14.2662 | -1 | 30 |
3 | -34.0962 | -141.684 | 14.7164 | -1 | 30 |
4 | 23.1549 | -111.449 | 13.9895 | -1 | 30 |
5 | 38.2853 | -40.2572 | 16.5154 | -1 | 30 |
6 | -57.144 | -53.4567 | 19.0392 | -1 | 30 |
7 | -94.8163 | -2.66101 | 20.0491 | -1 | 30 |
8 | -143.811 | -35.4007 | 18.8172 | -1 | 30 |
9 | -177.327 | -82.1346 | 19.5479 | -1 | 30 |
Approach 9
| Value | Faction |
|---|---|
1100+ | Ally |
750 to 1099 | Warmly |
500 to 749 | Kindly |
100 to 499 | Amiable |
0 to 99 | Indifferent |
-1 to -100 | Apprehensive |
-101 to -500 | Dubious |
-501 to -750 | Threateningly |
-751 | Ready to Attack |
Creating A New Faction 9
| Faction Value | Faction CON |
|---|---|
1100 -> ABOVE | ALLY |
750 -> 1099 | WARMLY |
500 -> 749 | KINDLY |
100 -> 400 | AMIABLE |
0 -> 99 | INDIFFERENT |
-100 -> -1 | APPREHENSIVE |
-500 -> -101 | DUBIOUS |
-750 -> -501 | THREATENLY |
BELOW -> -751 | SCOWLS |
Consider Levels 9
| Consider Level ID | Consider Level Name |
|---|---|
1 | Ally |
2 | Warmly |
3 | Kindly |
4 | Amiably |
5 | Indifferently |
6 | Apprehensively |
7 | Dubiously |
8 | Threateningly |
9 | Scowls |
Consider Levels From Faction Values 9
| Total Faction Value | Faction CON |
|---|---|
1100 -> ABOVE | ALLY |
750 -> 1099 | WARMLY |
500 -> 749 | KINDLY |
100 -> 499 | AMIABLE |
0 -> 99 | INDIFFERENT |
-100 -> -1 | APPREHENSIVE |
-500 -> -101 | DUBIOUS |
-750 -> -501 | THREATENLY |
BELOW -> -751 | SCOWLS |
Emote Event Types 9
| Emote Event Type ID | Emote Event Type Name |
|---|---|
0 | Leave Combat |
1 | Enter Combat |
2 | On Death |
3 | After Death |
4 | Hailed |
5 | Killed PC |
6 | Killed NPC |
7 | On Spawn |
8 | On Despawn |
Create The New Base Faction To Faction List 9
| Faction Value | Faction CON |
|---|---|
1100 -> ABOVE | ALLY |
750 -> 1099 | WARMLY |
500 -> 749 | KINDLY |
100 -> 400 | AMIABLE |
0 -> 99 | INDIFFERENT |
-100 -> -1 | APPREHENSIVE |
-500 -> -101 | DUBIOUS |
-750 -> -501 | THREATENLY |
BELOW -> -751 | SCOWLS |
Npc Spell Categories 9
| NPC Spell Category ID | NPC Spell Category Name |
|---|---|
0 | Not Applicable (Non NPC Spell) |
1 | Area of Effect Detrimental |
2 | Single Target Detrimental |
3 | Buffs |
4 | Pet Spells |
5 | Healing Spells |
6 | Gate or Last Cast |
7 | Debuffs |
8 | Dispells |
Aura Types 8
| Aura Type ID | Aura Type Name |
|---|---|
0 | On All Friendlies |
1 | On All Group Members |
2 | On Group Members' Pets |
3 | Totem |
4 | Enter Trap |
5 | Exit Trap |
6 | Fully Scripted |
7 | Max |
Consider Colors 8
| Consider Color ID | Consider Color Name |
|---|---|
2 | Green |
4 | Blue |
6 | Gray |
10 | White |
13 | Red |
15 | Yellow |
18 | Light Blue |
20 | White (Titanium) |
Databucket Time Input Examples 6
| Value | Input |
|---|---|
15 seconds | 15s |
15 seconds | s15 |
60 minutes | 60m |
7 days | 7d |
1 year | 1y |
600 seconds | 600 |
Aa Target Types 6
| Target Type ID | Target Type Name |
|---|---|
0 | None |
1 | Self |
2 | Current Target (Single) |
3 | Group |
4 | Group of Current Target |
5 | Pet |
Bard Types 6
| Bard Type ID | Bard Type Name |
|---|---|
23 | Wind Instruments |
24 | Stringed Instruments |
25 | Brass Instruments |
26 | Percussion Instruments |
50 | Singing |
51 | All |
Damage Shield Types 6
| Damage Shield Type ID | Damage Shield Type Name |
|---|---|
244 | Decay |
245 | Chilled |
246 | Freezing |
247 | Torment |
248 | Burn |
249 | Thorns |
Fly Modes 6
| Fly Mode ID | Fly Mode Name |
|---|---|
0 | Ground |
1 | Flying |
2 | Levitating |
3 | Water |
4 | Floating |
5 | Levitate While Running |
World Pvpsettings 6
| Value | Name | Desc |
|---|---|---|
0 | Disabled | Default, No PVP Enabled |
1 | Rallos Zek | Not yet supported |
2 | TZ/VZ | Partial Support |
4 | Sullon Zek | Partial support |
6 | Discord | Partial Support |
7+ | Discord+ (Any value above 6) | Discord without the no-drop restrictions removed |
Action Types 5
| Action Type ID | Action Type Name |
|---|---|
0 | Set Condition |
1 | Add to Condition |
2 | Subtract from Condition |
3 | Multiply Condition |
4 | Divide Condition |
Item Element Types 5
| Element Type ID | Element Type |
|---|---|
1 | Magic |
2 | Fire |
3 | Cold |
4 | Poison |
5 | Disease |
Ldon Themes 5
| LDoN Theme ID | LDoN Theme |
|---|---|
1 | Deepest Guk |
2 | Miragul's Menagerie |
3 | Mistmoore Catacombs |
4 | Rujarkian Hills |
5 | Takish-Hiz |
Npc Animation Types 5
| NPC Animation Type ID | NPC Animation Type Name |
|---|---|
0 | Standing |
1 | Sitting |
2 | Crouching |
3 | Laying |
4 | Looting |
Npc Despawn Types 5
| NPC Despawn Type ID | NPC Despawn Type Name |
|---|---|
0 | None |
1 | Repop |
2 | Repop on Timer |
3 | Depop |
4 | Depop on Timer |
On Change Types 5
| On Change Type ID | On Change Type Name |
|---|---|
0 | Do Nothing |
1 | Depop |
2 | Repop |
3 | Repop If Ready |
10 | Signal |
Zone Types 5
| Zone Type ID | Zone Type Name |
|---|---|
-1 | None |
0 | Indoors |
1 | Outdoors |
2 | Dungeon |
255 | Any |
Aura Movement Types 4
| Aura Movement Type ID | Aura Movement Type Name |
|---|---|
0 | Follow |
1 | Stationary |
2 | Pathing |
3 | Max |
Aura Spawn Types 4
| Aura Spawn Type ID | Aura Spawn Type Name |
|---|---|
0 | Group Members |
1 | Everyone |
2 | No One |
3 | Max |
Bag Sizes 4
| Bag Size ID | Bag Size |
|---|---|
1 | Small |
2 | Medium |
3 | Large |
4 | Giant |
Item Click Types 4
| Click Type ID | Click Type |
|---|---|
1 | Item can be cast from any slot. |
3 | Item can be cast from any slot. |
4 | Item must be equipped to cast effect. |
5 | Seems to involve poisoning a weapon. |
Task Duration Codes 4
| Task Duration Code ID | Task Duration Code Name |
|---|---|
0 | None |
1 | Short |
2 | Medium |
3 | Long |
Task Types 4
| Task Type ID | Task Type Name |
|---|---|
0 | Task |
1 | Shared |
2 | Quest |
3 | Expedition |
Emote Types 3
| Emote Type ID | Emote Type Name |
|---|---|
1 | Emote |
2 | Shout |
3 | Proximity Emote, Other - Say |
Environment Types 3
| Environment Type ID | Environment Type Name |
|---|---|
0 | Everywhere |
12 | Cities |
24 | Planes |
Genders 3
| Gender ID | Gender Name |
|---|---|
0 | Male |
1 | Female |
2 | Neuter |
Item Class 3
| Item Class ID | Item Class |
|---|---|
0 | Common item |
1 | Container |
2 | Book |
Item Lore Groups 3
| Lore Group ID | Lore Group |
|---|---|
-1 | Standard Lore Item. |
0 | Not a Lore Item. |
>0 | A member of a lore group. |
Time Of Day Types 3
| Time of Day Type ID | Time of Day Type Name |
|---|---|
0 | Any Time |
1 | Day Time |
2 | Night Time |
Blocked Spell Types 2
| Blocked Spell Type ID | Blocked Spell Type Name |
|---|---|
1 | Zone-wide |
2 | Region |