spells_new

Column

Data Type

Description

id

int

Unique Spell Identifier

name

varchar

Name

player_1

varchar

Player_1

teleport_zone

varchar

The zone you are teleporting to or the NPC Name you want to spawn.

you_cast

varchar

The message sent to others when you cast the spell.

other_casts

varchar

The message seen when someone around you casts the spell.

cast_on_you

varchar

The message received when the spell is cast on you.

cast_on_other

varchar

The message recieved when the spell is cast on another.

spell_fades

varchar

The message recieved when the spell fades.

range

int

Range

aoerange

int

Area of Effect Range

pushback

int

Push Back

pushup

int

Push Up

cast_time

int

Cast Time in Milliseconds

recovery_time

int

Recovery Time in Seconds

recast_time

int

Recast Time in Seconds

buffdurationformula

int

Buff Duration Formula

buffduration

int

Buff Duration

AEDuration

int

Area of Effect Duration

mana

int

Mana Cost

effect_base_value1

int

Effect Base Value 1

effect_base_value2

int

Effect Base Value 2

effect_base_value3

int

Effect Base Value 3

effect_base_value4

int

Effect Base Value 4

effect_base_value5

int

Effect Base Value 5

effect_base_value6

int

Effect Base Value 6

effect_base_value7

int

Effect Base Value 7

effect_base_value8

int

Effect Base Value 8

effect_base_value9

int

Effect Base Value 9

effect_base_value10

int

Effect Base Value 10

effect_base_value11

int

Effect Base Value 11

effect_base_value12

int

Effect Base Value 12

effect_limit_value1

int

Effect Limit Value 1

effect_limit_value2

int

Effect Limit Value 2

effect_limit_value3

int

Effect Limit Value 3

effect_limit_value4

int

Effect Limit Value 4

effect_limit_value5

int

Effect Limit Value 5

effect_limit_value6

int

Effect Limit Value 6

effect_limit_value7

int

Effect Limit Value 7

effect_limit_value8

int

Effect Limit Value 8

effect_limit_value9

int

Effect Limit Value 9

effect_limit_value10

int

Effect Limit Value 10

effect_limit_value11

int

Effect Limit Value 11

effect_limit_value12

int

Effect Limit Value 12

max1

int

Max 1

max2

int

Max 2

max3

int

Max 3

max4

int

Max 4

max5

int

Max 5

max6

int

Max 6

max7

int

Max 7

max8

int

Max 8

max9

int

Max 9

max10

int

Max 10

max11

int

Max 11

max12

int

Max 12

icon

int

Icon

memicon

int

Memmed Icon

components1

int

Item Identifier

components2

int

Item Identifier

components3

int

Item Identifier

components4

int

Item Identifier

component_counts1

int

Component Count 1

component_counts2

int

Component Count 2

component_counts3

int

Component Count 3

component_counts4

int

Component Count 4

NoexpendReagent1

int

If it is a number between 1-4 it means component number 1-4 is a focus and not to expend it. If it is a valid item ID it means this item is a focus as well.

NoexpendReagent2

int

If it is a number between 1-4 it means component number 1-4 is a focus and not to expend it. If it is a valid item ID it means this item is a focus as well.

NoexpendReagent3

int

If it is a number between 1-4 it means component number 1-4 is a focus and not to expend it. If it is a valid item ID it means this item is a focus as well.

NoexpendReagent4

int

If it is a number between 1-4 it means component number 1-4 is a focus and not to expend it. If it is a valid item ID it means this item is a focus as well.

formula1

int

Formula 1

formula2

int

Formula 2

formula3

int

Formula 3

formula4

int

Formula 4

formula5

int

Formula 5

formula6

int

Formula 6

formula7

int

Formula 7

formula8

int

Formula 8

formula9

int

Formula 9

formula10

int

Formula 10

formula11

int

Formula 11

formula12

int

Formula 12

LightType

int

Light Type

goodEffect

int

Good Effect: 0 = Detrimental, 1 = Beneficial, 2 = Beneficial Group Only

Activated

int

Activated

resisttype

int

Resist Type

effectid1

int

Effect Identifier 1

effectid2

int

Effect Identifier 2

effectid3

int

Effect Identifier 3

effectid4

int

Effect Identifier 4

effectid5

int

Effect Identifier 5

effectid6

int

Effect Identifier 6

effectid7

int

Effect Identifier 7

effectid8

int

Effect Identifier 8

effectid9

int

Effect Identifier 9

effectid10

int

Effect Identifier 10

effectid11

int

Effect Identifier 11

effectid12

int

Effect Identifier 12

targettype

int

Target Type

basediff

int

Base Difficult Fizzle Adjustment

skill

int

Skill Identifier

zonetype

int

Zone Type

EnvironmentType

int

Environment Type

TimeOfDay

int

Time of Day Type

classes1

int

Required Level for Warrior

classes2

int

Required Level for Cleric

classes3

int

Required Level for Paladin

classes4

int

Required Level for Shadow Knight

classes5

int

Required Level for Ranger

classes6

int

Required Level for Druid

classes7

int

Required Level for Monk

classes8

int

Required Level for Bard

classes9

int

Required Level for Rogue

classes10

int

Required Level for Shaman

classes11

int

Required Level for Necromancer

classes12

int

Required Level for Wizard

classes13

int

Required Level for Magician

classes14

int

Required Level for Enchanter

classes15

int

Required Level for Beastlord

classes16

int

Required Level for Berserker

CastingAnim

int

Casting Animation

TargetAnim

int

Target Animation

TravelType

int

Travel Type (Unused)

SpellAffectIndex

int

Spell Affect Index

disallow_sit

int

Disallow Sit: 0 = False, 1 = True

deities0

int

Deity List

deities1

int

Deity List

deities2

int

Deity List

deities3

int

Deity List

deities4

int

Deity List

deities5

int

Deity List

deities6

int

Deity List

deities7

int

Deity List

deities8

int

Deity List

deities9

int

Deity List

deities10

int

Deity List

deities11

int

Deity List

deities12

int

Deity List

deities13

int

Deity List

deities14

int

Deity List

deities15

int

Deity List

deities16

int

Deity List

field142

int

Unknown

field143

int

Unknown

new_icon

int

New Icon

spellanim

int

Spell Animation

uninterruptable

int

Uninterruptable: 0 = False, 1 = True

ResistDiff

int

Resist Difference

dot_stacking_exempt

int

Damage Over Time Stacking Exempt: 0 = False, 1 = True

deleteable

int

Deleteable: 0 = False, 1 = True

RecourseLink

int

Recourse Spell Identifier

no_partial_resist

int

No Partial Resist: 0 = False, 1 = True

field152

int

Unknown

field153

int

Unknown

short_buff_box

int

Short Buff Box: 0 = False, 1 = True

descnum

int

Description Number

typedescnum

int

Type Description Number

effectdescnum

int

Effect Description Number

effectdescnum2

int

Effect Description Number 2

npc_no_los

int

NPC No Line of Sight: 0 = False, 1 = True

field160

int

Unknown

reflectable

int

Reflectable: 0 = False, 1 = True

bonushate

int

Bonus Hate

field163

int

Unknown

field164

int

Unknown

ldon_trap

int

LDoN Trap Identifier

EndurCost

int

Endurance Cost

EndurTimerIndex

int

Endurance Timer

IsDiscipline

int

Is Discipline: 0 = False, 1 = True

field169

int

Unknown

field170

int

Unknown

field171

int

Unknown

field172

int

Unknown

HateAdded

int

Hate Added

EndurUpkeep

int

Endurance Upkeep

numhitstype

int

Number of Hits Type

numhits

int

Number of Hits

pvpresistbase

int

PVP Resist Base

pvpresistcalc

int

PVP Resist Calc

pvpresistcap

int

PVP Resist Cap

spell_category

int

Spell Category

field181

int

Unknown

field182

int

Unknown

pcnpc_only_flag

int

PC/NPC Only Flag: 0 = Not Applicable, 1 = PCs and Mercs, 2 = NPCs

cast_not_standing

int

Cast Not Standing: 0 = False, 1 = True

can_mgb

int

Can Mass Group Buff: 0 = False, 1 = True

nodispell

int

No Dispell: 0 = False, 1 = True

npc_category

int

NPC Spell Category Identifier

npc_usefulness

int

NPC Usefulness

MinResist

int

Minimum Resistance

MaxResist

int

Maximum Resistance

viral_targets

int

Viral Targets

viral_timer

int

Viral Timer

nimbuseffect

int

Nimbus Effect

ConeStartAngle

int

Cone Start Angle

ConeStopAngle

int

Cone Stop Angle

sneaking

int

Sneaking: 0 = False, 1 = True

not_extendable

int

Not Extendable: 0 = False, 1 = True

field198

int

Unknown

field199

int

Unknown

suspendable

int

Suspendable: 0 = False, 1 = True

viral_range

int

Viral Range

songcap

int

Song Cap

field203

int

Unknown

field204

int

Unknown

no_block

int

No Block: 0 = False, 1 = True

field206

int

Unknown

spellgroup

int

Spell Group

rank

int

Rank

field209

int

Unknown

field210

int

Unknown

CastRestriction

int

Cast Restrictions

allowrest

int

Allow Rest: 0 = False, 1 = True

InCombat

int

In Combat: 0 = False, 1 = True

OutofCombat

int

Out Of Combat: 0 = False, 1 = True

field215

int

Unknown

field216

int

Unknown

field217

int

Unknown

aemaxtargets

int

Area of Effect Max Targets

maxtargets

int

Max Targets

field220

int

Unknown

field221

int

Unknown

field222

int

Unknown

field223

int

Unknown

persistdeath

int

Persist Death: 0 = False, 1 = True

field225

int

Unknown

field226

int

Unknown

min_dist

float

Minimum Distance

min_dist_mod

float

Minimum Distance Modifier

max_dist

float

Maximum Distance

max_dist_mod

float

Maximum Distance Modifier

min_range

int

Minimum Range

field232

int

Unknown

field233

int

Unknown

field234

int

Unknown

field235

int

Unknown

field236

int

Unknown