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

[Knindza GXG]

Hey,

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.


-- 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');
-- 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');
-- 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.

[Apple]

Thanks for sharing :) +rep

[Knindza GXG]

You're welcome and thanks for rep.