From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/spell_custom_attr.md | 96 ++++++++++++++++++++++++++++++++++++++++++++--- 1 file changed, 91 insertions(+), 5 deletions(-) (limited to 'docs/spell_custom_attr.md') diff --git a/docs/spell_custom_attr.md b/docs/spell_custom_attr.md index 5c92df3..33c1606 100644 --- a/docs/spell_custom_attr.md +++ b/docs/spell_custom_attr.md @@ -1,6 +1,92 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [spell_custom_attr](spell_custom_attr) +# spell\_custom\_attr + +`Back-to:World` + +**The \`spell\_custom\_attr\` table** + +Table used for storing custom spell attributes. + +**Structure** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

entry

medium int(8)

unsigned

PRI

NO

0

 

spell id

attributes

medium int(8)

unsigned

 

NO

0

 

SpellCustomAttributes

+ +  + +  + +**Description of the fields** + +### entry + +Spell ID. See [Spell.dbc](http://collab.kpsn.org/display/tc/spell_dbc) . + +### attributes + +Spell custom attributes from the enumeration SpellCustomAttributes in SpellInfo.h + +``` sql +SET @SPELL_ATTR0_CU_ENCHANT_PROC = 1, + @SPELL_ATTR0_CU_CONE_BACK = 2, + @SPELL_ATTR0_CU_CONE_LINE = 4, + @SPELL_ATTR0_CU_SHARE_DAMAGE = 8, + @SPELL_ATTR0_CU_NO_INITIAL_THREAT = 16, + @SPELL_ATTR0_CU_AURA_CC = 64, + @SPELL_ATTR0_CU_DIRECT_DAMAGE = 256, + @SPELL_ATTR0_CU_CHARGE = 512, + @SPELL_ATTR0_CU_PICKPOCKET = 1024, + @SPELL_ATTR0_CU_NEGATIVE_EFF0 = 4096, + @SPELL_ATTR0_CU_NEGATIVE_EFF1 = 8192, + @SPELL_ATTR0_CU_NEGATIVE_EFF2 = 16384, + @SPELL_ATTR0_CU_IGNORE_ARMOR = 32768, + @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER = 65536, + @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET = 131072; + +DELETE FROM `spell_custom_attr` WHERE `entry`=123; +INSERT INTO `spell_custom_attr` (`entry`, `attributes`) VALUES +(123, @SPELL_ATTR0_CU_FLAG1 | @SPELL_ATTR0_CU_FLAG2); +``` + -Column | Type | Description ---- | --- | --- -Entry | mediumint(8) unsigned | -Attributes | mediumint(8) unsigned | -- cgit