Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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

Newbie Spellweaver
Joined
Mar 23, 2018
Messages
12
Reaction score
1
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.
 
Back
Top