Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

Ulduar

Members
 View Profile  See their activity

  • Posts

    90

  • Joined

  • Last visited

  • Days Won

    5

 Content Type 

Posts posted by Ulduar

  1. Hotfix_blob table

    in Help and Support

    Posted

    5 hours ago, Shauren said:

    This table exists only to send sniffed hotfixes for db2 files that are not loaded by TC. You should never try to manually insert data into it.

     

    Thanks, Shauren. i know that.

     

    5 hours ago, Shauren said:

    If you really must know - blob is simply the entire db2 row written as binary

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

     
     

  2. Hotfix_blob table

    in Help and Support

    Posted

    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.

    image.png

  5. Smart_Scripts Event Player only

    in Help and Support

    Posted

    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

    • Like 1

  8. SpellXSpellVisual.db2

    in Help and Support

    Posted

    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.

  13. SpellXSpellVisual.db2

    in Help and Support

    Posted

    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.
     

  17. SpellXSpellVisual.db2

    in Help and Support

    Posted

    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.

     

     

×
×
  • Create New...