Jump to content
TrinityCore

SpellXSpellVisual.db2


Ulduar
 Share

Recommended Posts

Hello everyone. Please tell me - how should working this table? I can override visual effects for any spell? 

ID - 100029 Разитель Алисры
=================================================
Description: Вы – разитель Алисры! Вероятность нанесения критического урона повышена на $s1%.

ToolTip: Увеличение шанса критического удара на $s1%.
Category = 0, SpellIconID = 3173, activeIconID = 0, SpellVisual = (21105,0)
Family SPELLFAMILY_GENERIC, flag [0] 0x00000000 [1] 0x00000000 [2] 0x00000000 [3] 0x00000000

SpellSchoolMask = 1 (SPELL_SCHOOL_MASK_NORMAL)
DamageClass = 0 (SPELL_DAMAGE_CLASS_NONE)
PreventionType = 0 (SPELL_PREVENTION_TYPE_NONE)
=================================================
Attributes: 0xA4000000 (SPELL_ATTR0_NEGATIVE_1, SPELL_ATTR0_UNAFFECTED_BY_INVULNERABILITY, SPELL_ATTR0_CANT_CANCEL)
AttributesEx3: 0x00040100 (SPELL_ATTR3_ONLY_TARGET_PLAYERS, SPELL_ATTR3_IGNORE_HIT_RESULT)
AttributesEx7: 0x02000000 (SPELL_ATTR7_UNK25)
=================================================
Spell Level = 0, base 0, max 0

Category = 0
DispelType = 0 (DISPEL_NONE)
Mechanic = 0 (MECHANIC_NONE)
SpellRange: (Id 1) "Self Only":
    MinRangeNegative = 0, MinRangePositive = 0
    MaxRangeNegative = 0, MaxRangePositive = 0

Cast time (Id 1) = 0,00
Duration: ID (64)  40000, 0, 40000
Interrupt Flags: 0x00000000, AuraIF 0x00480000, ChannelIF 0x00000000

Allowed areas:
5723 - Огненные Просторы (Map: 720)

Chance = 0, charges - 0
=================================================
Effect 0: Id 6 (SPELL_EFFECT_APPLY_AURA) DIFFICULTY_NONE
BasePoints = 75
Targets (1, 0) (TARGET_UNIT_CASTER, NO_TARGET)
Aura Id 290 (SPELL_AURA_MOD_CRIT_PCT), value = 75, misc = 0 (0), miscB = 0, periodic = 0

 

ID - 152975 Защитный барьер
=================================================

ToolTip: Уменьшает получаемый урон на $s1%.
Category = 0, SpellIconID = 9644, activeIconID = 0, SpellVisual = (37333,0)
Family SPELLFAMILY_GENERIC, flag [0] 0x00000000 [1] 0x00000000 [2] 0x00000000 [3] 0x00000000

SpellSchoolMask = 1 (SPELL_SCHOOL_MASK_NORMAL)
DamageClass = 0 (SPELL_DAMAGE_CLASS_NONE)
PreventionType = 0 (SPELL_PREVENTION_TYPE_NONE)
=================================================
AttributesEx2: 0x00000004 (SPELL_ATTR2_CAN_TARGET_NOT_IN_LOS)
=================================================
Spell Level = 0, base 0, max 0

Category = 0
DispelType = 0 (DISPEL_NONE)
Mechanic = 0 (MECHANIC_NONE)
SpellRange: (Id 6) "Vision Range":
    MinRangeNegative = 0, MinRangePositive = 0
    MaxRangeNegative = 100, MaxRangePositive = 100

Cast time (Id 1) = 0,00
Duration: ID (21)  -1, 0, -1
Interrupt Flags: 0x00000000, AuraIF 0x00000000, ChannelIF 0x00000000
Chance = 0, charges - 0
=================================================
Effect 0: Id 6 (SPELL_EFFECT_APPLY_AURA) DIFFICULTY_NONE
BasePoints = -90
Targets (25, 0) (TARGET_UNIT_TARGET_ANY, NO_TARGET)
Aura Id 87 (SPELL_AURA_MOD_DAMAGE_PERCENT_TAKEN), value = -90, misc = 127 (127), miscB = 0, periodic = 0

 

Replace visual effect 21105 for 100029 on 37333 from spellid 152975.

DROP TABLE IF EXISTS `spell_x_spell_visual`;
  /*!40101 SET @saved_cs_client = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `spell_x_spell_visual` (
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `SpellID` int(10) unsigned NOT NULL DEFAULT '0',
  `DifficultyID` int(10) unsigned NOT NULL DEFAULT '0',
  `SpellVisualID1` int(10) unsigned NOT NULL DEFAULT '0',
  `SpellVisualID2` int(10) unsigned NOT NULL DEFAULT '0',
  `Unk620` float NOT NULL DEFAULT '0',
  `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;

 

https://github.com/TrinityCore/TrinityCore/blob/a1f59c9d8d9351bd4373e1e4355eee09369c589f/sql/base/dev/hotfixes_database.sql#L3096

Id - what need add? Spellid? Or what?

SpellId - in this case should be = 100029?

DifficultyID - this is understand - from spelleffect. Can be = 0.

SpellVisualID01 - should be = old value? 21105 or need add 37333? Or should be pointer on spellid (likely aura 403)?

SpellVisualID02 - see SpellVisualID01 questions.

How should be for working?

Replace visual effect need for test. I wand understand, how should be working this table. Thanks advance.

Shauren, please help. Thanks advance.

 

 

Link to comment
Share on other sites

  • 3 weeks later...

Solved:

insert into `spell_x_spell_visual` (`ID`, `SpellID`, `DifficultyID`, `SpellVisualID1`, `SpellVisualID2`, `Unk620`, `PlayerConditionID`, `Flags`, `VerifiedBuild`) values
('1','100029','0','36238','0','1','0','0','0');

Where 1 = integer value. You can set on any, example 2, 3 or 100 or more.
Where 100029 - spell id, for which you want to change the visual effect
0 - can be 0. Not necessarily change
36238 - a visual effect that you want to see for this spell.
0 - always be 0. On current state.
Unk620 - should be always = 1. On 7.0.3 should be always = 0. From pxrwowdev.
PlayerConditionID`- can be 0.
Flags - can be 0.
VerifiedBuild`- can be 0.
 

Link to comment
Share on other sites

  • 1 month later...
  • 1 year later...

Do not even try to do this with spells that have SPELL_EFFECT 179 (create areatrigger) and SPELL_EFFECT_27 (persistent area aura). This will not work.

If spell have effect for example SPELL_EFFECT_SPAWN (spell effect 46), but don't have SPELL_EFFECT_179 or 27, spell visual not displaying.

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...