spells_new¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| One-to-One | descnum | db_str | id |
| One-to-One | effectdescnum | db_str | id |
| One-to-One | effectdescnum2 | db_str | id |
| One-to-One | typedescnum | db_str | id |
| One-to-One | id | auras | spell_id |
| Has-Many | id | blocked_spells | spellid |
| Has-Many | id | bot_pets | spell_id |
| Has-Many | id | bot_pet_buffs | spell_id |
| Has-Many | id | bot_spells_entries | spellid |
| Has-Many | id | character_auras | spell_id |
| Has-Many | id | character_buffs | spell_id |
| Has-Many | id | character_disciplines | disc_id |
| Has-Many | id | character_pet_buffs | spell_id |
| Has-Many | id | character_pet_info | spell_id |
| Has-Many | id | character_spells | spell_id |
| Has-Many | id | damageshieldtypes | spellid |
| Has-Many | id | items | bardeffect |
| Has-Many | id | items | clickeffect |
| Has-Many | id | items | focuseffect |
| Has-Many | id | items | proceffect |
| Has-Many | id | items | scrolleffect |
| Has-Many | id | items | worneffect |
| Has-Many | id | ldon_trap_templates | spell_id |
| Has-Many | id | merc_spell_list_entries | spell_id |
| Has-Many | id | npc_spells_entries | spellid |
| Has-Many | id | spell_buckets | spellid |
| Has-Many | id | spell_globals | spellid |
Schema¶
| 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 Ranger |
| classes5 | int | Required Level for Shadow Knight |
| 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 |
| pvp_duration | int | PVP Duration |
| pvp_duration_cap | int | PVP Duration Cap |
| 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 |