At SOE Live, on the forums, or attached to bricks thrown through our windows, the question often comes up, "What do the different SPA numbers mean?" closely followed by "Don't you know the difference between effect and affect?!" While we have no good answer for the latter, we can provide a list of the former. The majority of them are known, but there are a good quantity that are a mystery outside of our walls. Behold, the SPA list: AFFECTNUMBER - AFFECTNAME 0 - HP 1 - AC 2 - Attack Power 3 - Movement Rate 4 - STR 5 - DEX 6 - AGI 7 - STA 8 - INT 9 - WIS 10 - CHA 11 - Melee Speed 12 - Invisibility 13 - See Invis 14 - Enduring Breath 15 - Mana 16 - NPC-Frenzy 17 - NPC-Awareness 18 - NPC Aggro 19 - NPC Faction 20 - Blindness 21 - Stun 22 - Charm 23 - Fear 24 - Fatigue 25 - Bind Affinity 26 - Gate 27 - Dispel Magic 28 - Invis Vs Undead 29 - Invis Vs Animals 30 - NPC-ReactRange 31 - Enthrall (Mez) 32 - Create Item 33 - Spawn NPC 34 - Confuse 35 - Disease 36 - Poison 37 - DetectHostile 38 - DetectMagic 39 - NoTwincast 40 - Invulnerability 41 - Banish 42 - Shadow Step 43 - Berserk 44 - Lycanthropy 45 - Vampirism 46 - Resist Fire 47 - Resist Cold 48 - Resist Poison 49 - Resist Disease 50 - Resist Magic 51 - Detect (Switch) Traps 52 - Detect Undead 53 - Detect Summoned 54 - Detect Animals 55 - Stoneskin 56 - True North 57 - Levitation 58 - Change Form 59 - Damage Attackers (DS) 60 - TransferItem 61 - Identify 62 - Item ID 63 - NPC-WipeHatelist 64 - Spin Stun 65 - Infravision 66 - Ultravision 67 - NPC-POV 68 - Reclaim Energy 69 - Max HP 70 - CorpseBomb 71 - Create Undead 72 - PreserveCorpse 73 - TargetsView 74 - FeignDeath 75 - Ventriloquism 76 - Sentinel 77 - LocateCorpse 78 - SpellShield 79 - InstantHP 80 - Enchant:Light 81 - Resurrect 82 - Summon Target 83 - Portal 84 - Hp-NPC-ONLY 85 - Contact Ability (Melee Proc) 86 - NPC-Help-Radius 87 - Telescope 88 - Combat Portal 89 - Height 90 - IgnorePet 91 - SummonCorpse 92 - Hate (On Spell Land) 93 - WeatherControl 94 - Fragile 95 - Sacrifice 96 - Silence 97 - Max Mana 98 - Bard Haste 99 - Root 100 - HP Duration Only 101 - Complete Heal (Residual Buff) 102 - Pet No Fear 103 - Summon Pet 104 - Translocate 105 - Anti-Gate (NPC Only) 106 - BeastLordPet 107 - Alter Pet Level 108 - Familiar 109 - CreateItemInBag 110 - Removed (Archery RNG Acc%) 111 - Resistances 112 - Adjust Casting Skill (Fizzles) 113 - SummonMount 114 - Modify Hate 115 - Cornucopia 116 - Curse 117 - HitMagic 118 - Amplification 119 - BardHaste2 120 - HealMod 121 - IronMaiden 122 - ReduceSkill 123 - Immunity 124 - Fc_Damage_% 125 - Fc_HealMod 126 - Fc_ResistMod 127 - Fc_CastTimeMod1 128 - Fc_DurationMod 129 - Fc_RangeMod 130 - Fc_HateMod 131 - Fc_ReagentMod 132 - Fc_ManaMod 133 - Fc_StunTimeMod 134 - Ff_LevelMax 135 - Ff_ResistType 136 - Ff_TargetType 137 - Ff_WhichSPA 138 - Ff_Beneficial 139 - Ff_WhichSpellID 140 - Ff_DurationMin 141 - Ff_InstantOnly 142 - Ff_LevelMin 143 - Ff_CastTimeMin 144 - Ff_CastTimeMax 145 - Portal NPC Warder Banish 146 - Portal Locations 147 - Percent Heal 148 - StackingBlocker 149 - StripVirtualSlot 150 - Divine Intervention/Death Pact 151 - PocketPet 152 - PetSwarm 153 - Damage Balance 154 - Cancel Negative 155 - PoP Resurrect 156 - Mirror Form 157 - Feedback 158 - Reflect 159 - Mod all Stats 160 - Inebriation | Sobriety 161 - Spell Guard 162 - Melee Guard 163 - Absorb Hit 164 - Object - Sense Trap 165 - Object - Disarm Trap 166 - Object - Picklock 167 - Fc_Pet 168 - Defensive 169 - Critical Melee (PC Only) 170 - Spell Crit Damage 171 - Crippling Blow 172 - Evasion 173 - Riposte 174 - Dodge 175 - Parry 176 - Dual Wield 177 - Double Attack 178 - Melee Resource Drain 179 - Puretone 180 - Sanctification 181 - Fearless 182 - Hundred Hands 183 - UNUSED - Skill Increase Chance 184 - Accuracy % 185 - Skill Damage Mod 1 186 - Min Damage Done Mod 187 - Mana Balance 188 - Block 189 - Endurance 190 - Max Endurance 191 - Amnesia 192 - Hate (Duration Only) 193 - Skill Attack 194 - Fade 195 - Stun Resist (Melee+Spell) 196 - Deprecated (strikethrough) 197 - Skill Damage Taken Incoming 198 - Instant Endurance 199 - Taunt 200 - Weapon Proc Chance 201 - Ranged Proc 202 - IllusionOther 203 - MassBuff 204 - Group Fear Immunity 205 - AE Rampage Instant (PC Only) 206 - AE Taunt 207 - Flesh to Bone 208 - Purge Poison 209 - Cancel Beneficial 210 - Shield Caster 211 - AE Melee (PC Only) 212 - Fc_FrenziedDevastation 213 - Pet % HP 214 - HP Max Percent 215 - Pet Avoidance % 216 - Melee Accuracy Amt 217 - Headshot 218 - Pet Crit Melee Chance (Owner) 219 - Slay Undead 220 - Skill Min_Damage Amt 1 221 - ReduceWeight 222 - BlockBehind 223 - Double Riposte 224 - AddRiposte 225 - Give Double Attack 226 - 2hbash 227 - ReduceSkillTimer 228 - ReduceFallDmg 229 - CastThroughStun 230 - Increase Shield Distance 231 - StunBashChance 232 - Divine Save 233 - Metabolism 234 - Poison Mastery 235 - FocusChannelling 236 - Free Pet 237 - PetAffinity 238 - Permanent Illusion 239 - Stonewall 240 - String Unbreakable 241 - Improve Reclaim Energy 242 - IncreaseChanceMemwipe 243 - NoBreakCharmChance 244 - RootBreakChance 245 - Trap Circumvention 246 - Lung Capacity 247 - IncreaseSkillCap 248 - ExtraSpecialization 249 - Offhand Weapon MinDamage Bonus 250 - Increase ContactAbility Chance 251 - EndlessQuiver 252 - Backstab FullDamage From Front 253 - Chaotic Stab 254 - NoSpell 255 - Shielding Duration Mod 256 - Shroud of Stealth 257 - DEPRECATED - GivePetHold 258 - Triple Backstab 259 - ACLimitMod 260 - AddInstrumentMod 261 - SongModCap 262 - StatsCap 263 - TradeskillMasteries 264 - ReduceAATimer 265 - NoFizzle 266 - AddExtraAttack% (2h) 267 - AddPetCommands 268 - AlcFailRate 269 - Bandage Max HP Limit % 270 - Bard Song Beneficial Radius % 271 - BaseRunMod 272 - Bard Song Level 273 - Critical DoT 274 - CriticalHeal 275 - Critical Mend % 276 - DualWieldAmt 277 - ExtraDIChance 278 - FinishingBlow 279 - FlurryChance (PC Only) 280 - Pet Flurry Chance (Owner) 281 - GivePetFeign 282 - Increase Bandage Heal % 283 - SpecialAttackChain 284 - LoHSetHeal 285 - Allow Hide/Evade While Moving 286 - Fc_Damage_Amt 287 - Fc_DurationMod (static) 288 - Add Proc Hit (AA) 289 - Doom Duration 290 - Increase Movement Cap 291 - Purify 292 - Strikethrough 293 - StunResist2 (Melee) 294 - Spell Crit Chance 295 - ReduceTimerSpecial 296 - Fc_Spell_Damage_%_Incoming 297 - Fc_Spell_Damage_Amt_Incoming 298 - Height (Small) 299 - Wake the Dead 1 (Corpse Class) 300 - Doppelganger 301 - Increase Range Damage 302 - Fc_Damage_%_Crit 303 - Fc_Damage_Amt_Crit 304 - Secondary Riposte Mod 305 - Mitigate Damage Shield Offhand 306 - Wake the Dead 2 (File Class) 307 - Appraisal 308 - Zone Suspend Minion 309 - Teleport Caster's Bindpoint 310 - Fc_ReuseTimer 311 - Ff_CombatSkill 312 - Observer 313 - Forage Master 314 - Improved Invis 315 - Improved Invis Undead 316 - Improved Invis Animals 317 - Worn Regen Cap 318 - Worn Mana Regen Cap 319 - Critical HP Regen 320 - Shield Block Chance 321 - Reduce Target Hate 322 - Gate Starting City 323 - Defensive Proc 324 - HP for Mana 325 - No Break AE Sneak 326 - Spell Slots 327 - Buff Slots 328 - Negative HP Limit 329 - Mana Absorb % Damage 330 - Critical Melee Damage Mod 331 - Alchemy Item Recovery 332 - Summon to Corpse 333 - Doom Rune Consumed 334 - HP No Move 335 - Fc_Immunity_Focus 336 - Illusionary Target 337 - Increase Exp % 338 - Expedient Recovery 339 - Fc_CastProc 340 - Chance Spell 341 - Worn Attack Cap 342 - No Panic 343 - Spell Interrupt 344 - Item Channeling 345 - Assassinate Max Level / Chance 346 - Headshot Max 347 - Double Ranged Attack 348 - Ff_Mana_Min 349 - Increase Damage With Shield 350 - Manaburn 351 - Spawn Interactive Object 352 - Increase Trap Count 353 - Increase SOI Count 354 - Deactivate All Traps 355 - Learn Trap 356 - Change Trigger Type 357 - Fc_Mute 358 - Instant Mana 359 - Passive Sense Trap 360 - Proc On Kill Shot 361 - Proc On Death 362 - Potion Belt 363 - Bandolier 364 - AddTripleAttackChance 365 - Proc On Spell Kill Shot 366 - Group Shielding 367 - Modify Body Type 368 - Modify Faction 369 - Corruption 370 - ResistCorruption 371 - Slow 372 - Grant Foraging 373 - Doom Always 374 - Trigger Spell 375 - Critical DoT Damage Mod % 376 - Fling 377 - Removed (Doom Entity) 378 - Resist Other SPA 379 - Directional Shadowstep 380 - Knockback Explosive (PC Only) 381 - Fling Target to Caster 382 - Suppression 383 - Fc_CastProcNormalized 384 - Fling Caster to Target 385 - Ff_WhichSpellGroup 386 - Doom Dispeller 387 - Doom Dispelled 388 - Summon All Corpses 389 - Fc_Timer_Refresh 390 - Fc_Timer_Lockout 391 - Ff_Mana_Max 392 - Fc_Heal_Amt 393 - Fc_Heal_%_Incoming 394 - Fc_Heal_Amt_Incoming 395 - Fc_Heal_%_Crit 396 - Fc_Heal_Amt_Crit 397 - Pet Add AC 398 - Fc_Swarm_Pet_Duration 399 - Fc_Twincast 400 - Healburn 401 - Mana Ignite 402 - Endurance Ignite 403 - Ff_SpellClass 404 - Ff_SpellSubclass 405 - Staff Block Chance 406 - Doom Limit Use 407 - Doom Focus Used 408 - Limit HP 409 - Limit Mana 410 - Limit Endurance 411 - Ff_ClassPlayer 412 - Ff_Race 413 - Fc_BaseEffects 414 - Ff_CastingSkill 415 - Ff_ItemClass 416 - AC_2 417 - Mana_2 418 - Skill Min_Damage Amt 2 419 - Contact Ability 2 (Melee Proc) 420 - Fc_Limit_Use 421 - Fc_Limit_Use_Amt 422 - Ff_Limit_Use_Min 423 - Ff_Limit_Use_Type 424 - Gravitate 425 - Fly 426 - AddExtTargetSlots 427 - Skill Proc (Attempt) 428 - Proc Skill Modifier 429 - Skill Proc (Success) 430 - PostEffect 431 - PostEffectData 432 - ExpandMaxActiveTrophyBenefits 433 - Normalized Skill Min_Dmg Amt 1 434 - Normalized Skill Min_Dmg Amt 2 435 - Fragile Defense 436 - Toggle Freeze Buff Timers 437 - Teleport to Anchor 438 - Translocate to Anchor 439 - Assassinate Chance / DMG 440 - FinishingBlowMax 441 - Distance Removal 442 - Doom Req Bearer 443 - Doom Req Caster 444 - Improved Taunt 445 - Add Merc Slot 446 - A_Stacker 447 - B_Stacker 448 - C_Stacker 449 - D_Stacker 450 - DoT Guard 451 - Melee Threshold Guard 452 - Spell Threshold Guard 453 - Doom Melee Threshold 454 - Doom Spell Threshold 455 - Add Hate % (On Land) 456 - Add Hate Over Time % 457 - Resource Tap 458 - Faction Mod % 459 - Skill Damage Mod 2 460 - Ff_Override_NotFocusable 461 - Fc_Damage_%_Crit 2 462 - Fc_Damage_Amt 2 463 - Shield Target 464 - PC Pet Rampage 465 - PC Pet AE Rampage 466 - PC Pet Flurry Chance 467 - DS Mitigation Amount 468 - DS Mitigation Percentage 469 - Chance Best in Spell Group 470 - Trigger Best in Spell Group 471 - Double Melee Round (PC Only) 472 - Buy AA Rank 473 - Double Backstab From Front 474 - Pet Crit Melee Damage% (Owner) 475 - Trigger Spell Non-Item 476 - Weapon Stance 477 - Hatelist To Top Index 478 - Hatelist To Tail Index 479 - Ff_Value_Min 480 - Ff_Value_Max 481 - Fc_Cast_Spell_On_Land 482 - Skill Base Damage Mod 483 - Fc_Spell_Damage_%_IncomingPC 484 - Fc_Spell_Damage_Amt_IncomingPC 485 - Ff_CasterClass 486 - Ff_Same_Caster 487 - Extend Tradeskill Cap 488 - Defender Melee Force % (PC) 489 - Worn Endurance Regen Cap 490 - Ff_ReuseTimeMin 491 - Ff_ReuseTimeMax 492 - Ff_Endurance_Min 493 - Ff_Endurance_Max 494 - Pet Add Atk 495 - Ff_DurationMax 496 - Critical Melee Damage Mod Max 497 - Ff_FocusCastProcNoBypass 498 - AddExtraAttack% (1h-Primary) 499 - AddExtraAttack% (1h-Secondary) 500 - Fc_CastTimeMod2 501 - Fc_CastTimeAmt 502 - Fearstun 503 - Melee Damage Position Mod 504 - Melee Damage Position Amt 505 - Damage Taken Position Mod 506 - Damage Taken Position Amt 507 - Fc_Amplify_Mod 508 - Fc_Amplify_Amt 509 - Health Transfer 510 - Fc_ResistIncoming 511 - Ff_FocusTimerMin 512 - Proc Timer Modifier 513 - Mana Max Percent 514 - Endurance Max Percent 515 - AC Avoidance Max Percent 516 - AC Mitigation Max Percent 517 - Attack Offense Max Percent 518 - Attack Accuracy Max Percent 519 - Luck Amount 520 - Luck Percent (I suspect this will create more questions than it answers.) Updated 12/10/18
Thank you for the list. For those wondering (I was), here is what SPA is: And we will forgive SOE's grammar....this time
It seems there is a lot more (previously unknown/not widespread) information being released by official sources. Could some of these get sticky'd (at least for a bit)? Or could we get a "knowledge" forum for stuff like this? Or... even an in game command would be awesome /spalist Anyhow, always appreciate more info. Thanks!
One of the reasons I have my wiki is to keep permanent (well, I hope it is permanent) records of this kind of stuff. I've created a SPA list page for this. Everyone is welcome to add stuff to the wiki. Far too often, trying to track down past information becomes impossible, especially with (if I recall correctly) the first SOE EQ forums vanishing into thin air and the second now archived (which broke all the links to posts). I can't even recall if there was yet another SOE EQ forum that was deleted by SOE at some time. All I know is that I collected lots of links to information that became useless as SOE removed the information. So I just started (finally) keeping my own copies. Even so, it would be great if SOE could create a permanent listing of this stuff. A "knowledge" forum would be awesome. The official wiki might also be a good spot, although, like the forums here, I can't guaranty it will be around in five years.
There's no way to view the spell data in game, so having a /spalist wouldn't be very useful. This is more for the people working on the lucy or raidloot spell parsers, and as a curiosity for people who like knowing technical details of the game. The raw spell data is not something that's useful to anyone, it looks like this: 31700^Corrosive Filth^PLAYER_1^^^^You are blasted by corrosive filth.^ is covered in filth.^^200^50^0^0^0^1500^1500^0^0^0^0^-26295^2^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^26295^0^0^0^0^0^0^0^0^0^0^0^2513^2121^-1^-1^-1^-1^1^1^1^1^-1^-1^-1^-1^100^100^100^100^100^100^100^100^100^100^100^100^0^0^0^5^0^27^254^254^254^254^254^254^254^254^254^254^5^89^5^-1^0^0^255^255^255^255^255^255^255^255^255^255^255^255^255^255^255^255^43^0^0^25^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^100^0^48^200^0^-950^0^0^0^1^0^0^0^17779^29^68^^0^0^0^0^100^-950^0^0^0^0^0^0^0^0^0^0^0^0^0^100^0^- I hope game detail openness continues. Like maybe displaying AC as its real numbers in a useful way.
Also including the percentage increases in AA descriptions for things like CA/CS and crit chance and amount mods!
Most of the CA/CS is known except for the part I have marked as "Estimated". http://everquest.fanra.info/wiki/Tips#Combat_Agility_.2F_Combat_Stability Other stuff I have under Skill Modifiers and Combat Effects (I still need to add in some things like "Heal Amount" on gear when I can get to it). Of course, some of what I have could be wrong. I've tried to use SOE comments as much as I can (I have links to some but the links are now mostly dead due to SOE deleting/moving forums) but otherwise it is based off of other people who seem knowledgeable (though much is old and might be outdated). It would be nice to get official word on these things but I don't think the Devs have much time to spend on it.
Awesome, I look forward to seeing the better Spell parsers make use of this great information; it will definitely make using them easier. On a side note, Original forum from when game started(?) was closed sometime, I think before I started playing in early 2002; 2nd forum came around in either late 2003 or early 2004; 3rd forum came around maybe 2006 or 2007, but it copied the member info and posts from the 2nd version into it, and had several iterations of different board in the forum; 4th forum is the current iteration by my reckoning.
459 - "Skill Damage Mod 2" - Copy of 185 to deal with stacking conflicts. 460 - Ff_Override_NotFocusable - Allow this focus effect to apply to spells that are otherwise exempt from spell focuses.
Beimeth & Dzarn et al, what can we do with this information as a long time player familiar with the game but not as in depth as you are Beimeth. I'm just wondering if there's something meaningful I'm missing out on in my unintended ignorance.