Ulduar Posted September 29, 2016 Report Share Posted September 29, 2016 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 More sharing options...
Ulduar Posted October 15, 2016 Author Report Share Posted October 15, 2016 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 More sharing options...
Skizooo Posted October 16, 2016 Report Share Posted October 16, 2016 @Ulduar what OS are you using mate? My spellwork as you may already know is not working for me Link to comment Share on other sites More sharing options...
Ulduar Posted October 16, 2016 Author Report Share Posted October 16, 2016 @Skizooo Using Windows 7. Just what does this have to this subject? Link to comment Share on other sites More sharing options...
Skizooo Posted October 16, 2016 Report Share Posted October 16, 2016 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.. Link to comment Share on other sites More sharing options...
Ulduar Posted December 5, 2016 Author Report Share Posted December 5, 2016 `Flags` can be taken from SpellXSpellVisual.db2 if you needed. Link to comment Share on other sites More sharing options...
Ulduar Posted January 17, 2018 Author Report Share Posted January 17, 2018 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 More sharing options...
Recommended Posts