Break Proc Effects apart and normalize to effect style

Alc field spells missing AoE, Wiz storm spells missing AoE, Group drain spells missing AoE

Added Area of effect

Move Proc effect IDs into range of SpellEffectIds

WIZ should have spells that are 1 second cast 1 sec recast

Clean up pet Spell IDs and Pet Spell Effect IDs

Break Created Items Effects apart from the items themselves and normalize to effect style with StackTypes

Get proc effects filled in on spell effects sheet

Remove duplicate Spell IDs and point to multiple Effects

Added ConsumeItemID from 50k on for created items for temp items

All taunts changed to 20 range

Go through stack types and correct based on information from https://docs.google.com/spreadsheets/d/1X2U5hpa6po2JJ2zBSb5WMqV_L07yIH44/edit#gid=1064117000

Fix pet modelIDs, Wiz 60 pets, pet weapon damage

Address the known list of ability issues below

Fix background colors based on icon database

Go column-by-column and find blanks that should not exist and missing data

Ask about descriptions of scrolls and spells https://www.youtube.com/watch?v=-qeneV5ko70

Implementing Procs:

Normal Spell learn process from scroll/cm/given by game

Spell cast triggers spell effects

Spell should cast with "normal" checks based on the Spell Effects target/scope. Many procs are attached to buffs for self / target, some are pet only, some are group proc buffs

Proc Type in Spell Effects indicates whether proc may go off when hit by monster (defensive) or when hitting a monster (offensive). Defensive procs have 100% proc rate on hit.

Modifier in spell effect should determine frequency of offensive proc based on caster

Spell effect (ongoing duration) triggers proc effects

TYPE of proc effect can be used in the same way as it was for non-proc effects

Unique ID for spells

When proc is triggered, all (max 2) "Proc effects" should be triggered via Spell Effect reference

Spell name, shown in UI

Scaling for proc effect values are in their proc effect modifier'

Scroll in inventory or unlocked via a Mastery purchase

Proc Type in Spell Effects indicates whether proc may go off when hit by monster (defensive) or when hitting a monster (offensive)

Which Class Mastery, if applicable

Heals are indicated by positive HP1 and should be applied to scope and target type of "Proc effect" based on who is "casting" the proc

Whether scroll is a vendor purchase, quest reward, or drop

All negative HP1 numbers indicate damage to monster, only oddity is the undead enemy check

Which classes have access

Which races have access

Character animation

How spell is used. Creates an item, damage/healing, stat changes, teleports, charm, etc.

Level required to learn, either through a scroll or when the CM becomes available

Max range of spell. Self are set to 1. Units not clear at this time. Think meters for rough distance. This check should happen after all other spell conditions (target) are satisfied.

Seconds after pressing button until spell takes effect

Mana cost to cast

Background color behind spell icon, only appears in spell book menu, not in UI while casting ability

Description of icon, not necessarily required for database

ID of icon for spell book menu

Determines who the spell effects. Group, self, and PlayerBased AoE need no checks (other than currently casting a spell) and can only fail if mana is too low. Pet will need to check that pet exists (only can be cast on that player's pet). Pet should not require targeting your pet. Target and TargetBased AoE require having a target conned.

Based on scope, which characters does your spell effect? Friendly are player characters, enemy are monsters (or duel opponent). TargetBased AoE are only going to effect mobs. PlayerBased AoE only effect characters. Target can be either. Group only effects grouped characters.

Cooldown, begins after spell is cast by character (after casttime), not when button is pressed

Spell must check equipped weapon types before cast. 1HandBlunt (mace, club, etc), 1HandSlash (sword), 1HandPierce (dagger), 2 hand versions of those, Range meaning holding bow or crossbow, Shield is equipped, Any weapon type (includes no weapons), or None (bare fists).

Time effect lasts

MinLevelEffect

Minimum character level that can recieve buff. Most will be level 1.

These effects are what the spell actually will do. One example of a multiple effect spell is a glamour. One effect is the character model change, the other is the stat buff

Unique ID for effects

Name of spell, will be shown in scrolling list as "Status" on right side of initial start menu.

Character animation for procs when they are triggered

Best used to determine how the rest of effect is implemented

May be used to override lower level buffs that have the same stack type

Determines who the effect effects. May be redundant

Expands "Enemy" with summoned, undead, and beast types. Used for specific damage spells and charms

Which character statistic will be referenced to increase the effect of the spell

What fraction of the above statistic will be added to the base number statistic / damage

Whether or not the effect will be increased based on character level

What multiplier or fraction the level of the character is modified by, added to any existing stat/damage change

Taunts and detaunts. Equivalent in aggro effect to the damage dealt by any character (?)

How long does buff / HoT, PoT, charm etc last for. HoT and PoT tick twice on first effect and every 6seconds after

What is damage resisted by? DiseaseResist, Poison, Lightning, Cold, Fire, Arcane, etc. Can resist up to a cap %.

These are the change to statistics that the effected monster or character will see, increased or decreased by modifiers or resists

Increase in max hitpoints

Increase in max power

Power over time increase, characters naturally gain 1 PoT per 50 Power.

Health over time increase (normal heals are large HoT increases), characters naturally gain 1 HoT per 50 Health.

Normal heals should not be considered HoT increases

Armor class, this is the armor value your equipment and spells give you

Damage (or heal) base number. Also modified by any scaling in Modifier and Percentage and/or level scaling

Damage (or heal) secondary number. Used to display multiple numbers on screen and for TargetBased-AoE (AoE hits target and also the radius from the target, including target a second time).

Damage over time, ticks twice on first hit. Every 6 seconds after

Immediate power changes to enemy or friendly.

Increase to MAX hp based on your level (60 hp at lvl 60)

Used during melee swing damage calculation. Essentially increases relative level of attacker over monster

Used during melee swing damage calculation. Essentially increases relative level of defender over monster

Increase or decrease of movement speed

Debuff to specific resist of enemy

Debuff to specific resist of enemy

Debuff to specific resist of enemy

Debuff to specific resist of enemy

Unique ID of item created by spell. DOES NOT MATCH HAGLEY ITEMS! Will require research and fixes

How many items are created