Versiones comparadas

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.

...

Table used for storing custom spell attributes.

Panel

Structure


Field

Type

Attributes

Key

Null

Default

Extra

Comment

entry

74306389

medium int(8)

unsigned

PRI

NO

0

 


spell id

attributes

medium int(8)

unsigned

 


NO

0

 


SpellCustomAttributes

 

 



Panel

Description of the fields

...

Spell custom attributes from the enumeration SpellCustomAttributes in SpellInfo.h


Bloque de código
language
languagesql
themeConfluence
sqllinenumberstrue
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                       = 32,
	@SPELL_ATTR0_CU_DONT_BREAK_STEALTH            = 64,
    @SPELL_ATTR0_CU_CAN_CRIT				      = 128,
    @SPELL_ATTR0_CU_DIRECT_DAMAGE                 = 256,
    @SPELL_ATTR0_CU_CHARGE                        = 512,
    @SPELL_ATTR0_CU_PICKPOCKET                    = 1024,
    @SPELL_ATTR0_CU_ROLLING_PERIODIC              = 2048,
    @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,
    @SPELL_ATTR0_CU_ALLOW_INFLIGHT_TARGET         = 262144,
    @SPELL_ATTR0_CU_NEEDS_AMMO_DATA               = 524288,
    @SPELL_ATTR0_CU_BINARY_SPELL                  = 1048576,
    @SPELL_ATTR0_CU_SCHOOLMASK_NORMAL_WITH_MAGIC  = 2097152,
    @SPELL_ATTR0_CU_LIQUID_AURA                   = 4194304;

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);

...