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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...