[SQL] Halls of Stone (Tribunal of the Ages)

Results 1 to 1 of 1
  1. #1
    Registered Knindza is offline
    MemberRank
    Mar 2018 Join Date
    BelgradeLocation
    7Posts

    [SQL] Halls of Stone (Tribunal of the Ages)

    Hey,

    Wasn't able to find Trinity Core part, so i'll post here.


    For some reason, Tribunal of the Ages not working well on Trinity core.
    Here's small fix for NPC's that coming and attacking Brann during encounter.


    Code:
    -- Creating a new SmartAI script for [Creature] ENTRY 27983 (name: Dark Rune Protector)
    -- Table creature_template
    UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 27983;
    -- Table smart_scripts
    DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 27983);
    INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
    (27983, 0, 0, 0, 4, 0, 100, 7, 10, 20, 0, 0, 11, 22120, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Charge on agrro - No repeat'),
    (27983, 0, 1, 0, 0, 0, 100, 6, 3500, 6800, 9100, 14200, 11, 42724, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'In combat - Cast cleave - Repeat');

    Code:
    -- Creating a new SmartAI script for [Creature] ENTRY 27984 (name: Dark Rune Stormcaller)
    -- Table creature_template
    UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 27984;
    -- Table smart_scripts
    DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 27984);
    INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
    (27984, 0, 0, 0, 0, 0, 100, 6, 2000, 4800, 6700, 9300, 11, 12167, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'In combat - Cast Lightning Bolt - Repeat'),
    (27984, 0, 1, 0, 0, 0, 100, 6, 5600, 9700, 14100, 16300, 11, 15654, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'In combat - Cast Shadow Word: Pain - Repeat - Random target');

    Code:
    -- Creating a new SmartAI script for [Creature] ENTRY 27985 (name: Iron Golem Custodian)
    -- Table creature_template
    UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 27985;
    -- Table smart_scripts
    DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 27985);
    INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
    (27985, 0, 0, 0, 0, 0, 100, 6, 3900, 5800, 7800, 13200, 11, 33661, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'In combat - Cast Crush Armor - Repeat'),
    (27985, 0, 1, 0, 0, 0, 100, 4, 7200, 9600, 17400, 23600, 11, 59865, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'in combat - Cast Ground Smash - Repeat - Heroic only');

    .reload creature_template "Entry ID"
    .reload smart_scripts


    No need for server restart.
    If you wanna test after importing, make sure to be inside any Dungeon, cause they wont work outside.




Advertisement