Ulduar

Thanks, Shauren. i know that. Maybe Casc can show binary values. I already understood, that can fix only existing data. I was not going to insert custom data.

Hey everyone. Sorry for questions. Hotfix_blob table - how does this table work? TableHash - not questions, understandably. Taken from db2 hash in WoW Packet Parser. RecordId - not questions, understandably. Taken id from approapriate db client files. blob - need understand, how customer keys are generated. Not just only from sniff. Thanks advance.

It is likely that a blizzard will use SendPlaySpellVisualKit to send a visual effect. Or SendPlaySpellVisual for missile trajectrory. And there is another version: Blizzard was fixed using hotfixes base, but was not touched in the client files.

Areatrigger template id - used value from sniff. But you can add custom id. Spell_areatrigger - SpellMiscId = SpellEffect MiscValueA, AreaTriggerId -called from Areatrigger template id.

Use CONDITION_OBJECT_ENTRY_GUID = 31, // TypeID entry guid true if object is type TypeID and the entry is 0 or matches entry of the object or matches guid of the object CONDITION_SOURCE_TYPE_SMART_EVENT 22 ID (smart_scripts.id) + 1 4 : TYPEID_PLAYER https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130002/conditions

I found structure for DissolveEffect.db2. Tell me please, what opcode need for Play effect from this table? https://github.com/WowDevTools/WDBXEditor/blob/dev/WDBXEditor/Definitions/Legion 7.3.5 (26654).xml#L1320 Also, fonded structure for DecalProperties.db2 https://github.com/WowDevTools/WDBXEditor/blob/dev/WDBXEditor/Definitions/Legion 7.3.5 (26654).xml#L1240

Hello everyone. Blizzard add new SpellVisualEvent.db2. How opcodes needed for handler this table in core? About DissolveEffect.db2. How handlers in core on current state?

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.

You should not change db2 files, otherwise your kernel will simply not run. If core not have this hotfixes support, need implement in core and you can change in hotfixes databases.

https://github.com/Warpten/DBFilesClient.NET If not wrong, need VS 2015 for compile.

`Flags` can be taken from SpellXSpellVisual.db2 if you needed.

@Skizooo Using Windows 7. Just what does this have to this subject?

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.

SPELL_AURA_OBS_MOD_HEALTH implemented in core.

Brandmauer Windows also can blocked SpellWork.

Antivirus can blocked running SpellWork (memory stuck). Disable antivirus and run SpellWork. After enable antivirus.

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.

Set Health. else if (e.action.sethealthpointorpercent.healthpointmod == 2) (*itr)->ToUnit()->SetHealth(me->GetHealth()); else if (e.action.sethealthpointorpercent.healthpointmod == 3) me->SetHealth((*itr)->ToUnit()->GetHealth()); For example.

No, on official server npc also have neutral state. Yellow.