SpellXSpellVisual.db2

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.

							[COLOR=rgb(167,29,93)]DROP [COLOR=rgb(167,29,93)]TABLE IF EXISTS [COLOR=rgb(24,54,145)]`spell_x_spell_visual[COLOR=rgb(24,54,145)]`;
						
					
							 
						
						
							[COLOR=rgb(150,152,150)]/*!40101 SET @saved_cs_client = @@character_set_client */;
						
					
							 
						
						
							[COLOR=rgb(150,152,150)]/*!40101 SET character_set_client = utf8 */;
						
					
							 
						
						
							[COLOR=rgb(167,29,93)]CREATE [COLOR=rgb(167,29,93)]TABLE `[COLOR=rgb(121,93,163)]spell_x_spell_visual` (
						
					
							 
						
						
							[COLOR=rgb(24,54,145)]`ID[COLOR=rgb(24,54,145)]` [COLOR=rgb(167,29,93)]int([COLOR=rgb(0,134,179)]10) unsigned [COLOR=rgb(167,29,93)]NOT NULL DEFAULT [COLOR=rgb(24,54,145)]'0[COLOR=rgb(24,54,145)]',
						
					
							 
						
						
							[COLOR=rgb(24,54,145)]`SpellID[COLOR=rgb(24,54,145)]` [COLOR=rgb(167,29,93)]int([COLOR=rgb(0,134,179)]10) unsigned [COLOR=rgb(167,29,93)]NOT NULL DEFAULT [COLOR=rgb(24,54,145)]'0[COLOR=rgb(24,54,145)]',
						
					
							 
						
						
							[COLOR=rgb(24,54,145)]`DifficultyID[COLOR=rgb(24,54,145)]` [COLOR=rgb(167,29,93)]int([COLOR=rgb(0,134,179)]10) unsigned [COLOR=rgb(167,29,93)]NOT NULL DEFAULT [COLOR=rgb(24,54,145)]'0[COLOR=rgb(24,54,145)]',
						
					
							 
						
						
							[COLOR=rgb(24,54,145)]`SpellVisualID1[COLOR=rgb(24,54,145)]` [COLOR=rgb(167,29,93)]int([COLOR=rgb(0,134,179)]10) unsigned [COLOR=rgb(167,29,93)]NOT NULL DEFAULT [COLOR=rgb(24,54,145)]'0[COLOR=rgb(24,54,145)]',
						
					
							 
						
						
							[COLOR=rgb(24,54,145)]`SpellVisualID2[COLOR=rgb(24,54,145)]` [COLOR=rgb(167,29,93)]int([COLOR=rgb(0,134,179)]10) unsigned [COLOR=rgb(167,29,93)]NOT NULL DEFAULT [COLOR=rgb(24,54,145)]'0[COLOR=rgb(24,54,145)]',
						
					
							 
						
						
							[COLOR=rgb(24,54,145)]`Unk620[COLOR=rgb(24,54,145)]` float [COLOR=rgb(167,29,93)]NOT NULL DEFAULT [COLOR=rgb(24,54,145)]'0[COLOR=rgb(24,54,145)]',
						
					
							 
						
						
							[COLOR=rgb(24,54,145)]`PlayerConditionID[COLOR=rgb(24,54,145)]` [COLOR=rgb(167,29,93)]int([COLOR=rgb(0,134,179)]10) unsigned [COLOR=rgb(167,29,93)]NOT NULL DEFAULT [COLOR=rgb(24,54,145)]'0[COLOR=rgb(24,54,145)]',
						
					
							 
						
						
							[COLOR=rgb(24,54,145)]`Flags[COLOR=rgb(24,54,145)]` [COLOR=rgb(167,29,93)]int([COLOR=rgb(0,134,179)]10) unsigned [COLOR=rgb(167,29,93)]NOT NULL DEFAULT [COLOR=rgb(24,54,145)]'0[COLOR=rgb(24,54,145)]',
						
					
							 
						
						
							[COLOR=rgb(24,54,145)]`VerifiedBuild[COLOR=rgb(24,54,145)]` [COLOR=rgb(167,29,93)]smallint([COLOR=rgb(0,134,179)]6) [COLOR=rgb(167,29,93)]NOT NULL DEFAULT [COLOR=rgb(24,54,145)]'0[COLOR=rgb(24,54,145)]',
						
					
							 
						
						
							[COLOR=rgb(167,29,93)]PRIMARY KEY ([COLOR=rgb(24,54,145)]`ID[COLOR=rgb(24,54,145)]`)
						
					
							 
						
						
							) ENGINE[COLOR=rgb(167,29,93)]=MyISAM DEFAULT CHARSET[COLOR=rgb(167,29,93)]=utf8;
						
					
							 
						
						
							[COLOR=rgb(150,152,150)]/*!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.

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.

@Ulduar what OS are you using mate? My spellwork as you may already know is not working for me

@Skizooo Using Windows 7.

Just what does this have to this subject?

I am so sorry mate, it was an off topic question , I tried to make a spellwork to work several times but it still doesn’t work though…

[COLOR=rgb(39,42,52)]Flags can be taken from SpellXSpellVisual.db2 if you needed.

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.