Trinitycore: DB/Creature: Kirin Tor Mage in Ulduar

[aleigood]

Description:

Due to the error of NPC spawn point, the characters are overlapped.
.go xyz -814.109985 -201.125 429.924988 603
NPC ID: 33672

Kirin Tor Mage in Ulduar Raid must be summoned via an event
https://www.youtube.com/watch?v=UuPPW5jJaP4&feature=youtu.be

Branch(es):
3.3.5

TC rev. hash/commit:
961adea3727e32c068245735e76db2445c2fcd2d

Operating system:
CentOS

[jackpoz]

could you describe the issue with more words ?

[aleigood]

could you describe the issue with more words ?

Sorry, I updated the description of the problem.

[natnat201193]

okie, first 2 spawns:
.go xyz -814.109985 -201.125 429.924988 603
NPC ID: 33672 - Kirin Tor Mage - Ulduar Raid
These NPCs should either not be spawned at all and instead be summoned, or they should toggle invis off/on at certain times, whether it be through an aura or other means. These are the NPCs coming from the portal that should run over to the boxes of supplies, do some stuff, then go back to the portal and disappear/despawn. The scripting for this is currently missing.
https://www.youtube.com/watch?v=UuPPW5jJaP4&feature=youtu.be

[natnat201193]

Second spawn:
.go xyz 105.116997 4338.259766 101.589996 530
NPC ID: 18758 - Telhamat Protector - Temple of Telhamat - Zangarmarsh - Outland
Just a wrong spawn, can be removed.

DELETE FROM `creature` WHERE `guid` =67032 AND `id` =18758;

[Killyana]

@natnat201193 thanks for the video it will help.

[Rushor]

events done. only the spawndist must be renamed. db errors fixed

the paths are actually sniffed

-- battlemage
SET @NPC := 136529;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-800.089,`position_y`=-226.5122,`position_z`=430.2167 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,69, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-800.089,-226.5122,430.2167,0,5000,0,0,100,0),
(@PATH,2,-802.8542,-226.9937,429.9667,0,0,0,0,100,0),
(@PATH,3,-802.8514,-226.9598,430.2167,0,0,0,0,100,0),
(@PATH,4,-809.0789,-230.1994,429.9667,4.625123,0,0,0,100,0),
(@PATH,5,-814.1212,-219.8692,429.9667,0,0,0,0,100,0),
(@PATH,6,-814.0085,-219.9779,430.2167,0,0,0,0,100,0),
(@PATH,7,-817.5067,-218.3777,430.2167,0,5000,0,0,100,0),
(@PATH,8,-810.8352,-217.8873,429.9667,0,0,0,0,100,0),
(@PATH,9,-810.7053,-217.8378,430.2167,0,0,0,0,100,0),
(@PATH,10,-804.5867,-221.2963,430.2167,0,0,0,0,100,0),
(@PATH,11,-800.0966,-226.504,430.2167,0,0,0,0,100,0);

-- formerguy
SET @NPC := 136271;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-797.4893,`position_y`=-68.99318,`position_z`=430.355 WHERE `guid`=@NPC;
UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=-797.4893,`position_y`=-68.99318,`position_z`=430.355 WHERE `guid` In (136263, 136264);
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-797.4893,-68.99318,430.355,0,0,0,0,100,0),
(@PATH,2,-797.2393,-103.7432,430.355,0,0,0,0,100,0),
(@PATH,3,-801.9893,-142.7432,430.355,0,0,0,0,100,0),
(@PATH,4,-814.9893,-160.9932,430.355,0,0,0,0,100,0),
(@PATH,5,-831.4893,-165.9932,441.355,0,0,0,0,100,0),
(@PATH,6,-846.4893,-163.9932,452.105,0,0,0,0,100,0),
(@PATH,7,-855.9893,-164.2432,459.105,0,0,0,0,100,0),
(@PATH,8,-868.4705,-163.9879,458.8668,0,0,0,0,100,0),
(@PATH,9,-856.1097,-160.0616,459.1042,0,0,0,0,100,0),
(@PATH,10,-837.1097,-159.0616,445.3542,0,0,0,0,100,0),
(@PATH,11,-813.1097,-159.5616,430.3542,0,0,0,0,100,0),
(@PATH,12,-797.8597,-176.3116,430.3542,0,0,0,0,100,0),
(@PATH,13,-787.6097,-186.5616,430.3542,0,0,0,0,100,0),
(@PATH,14,-772.1097,-186.3116,430.3542,0,0,0,0,100,0),
(@PATH,15,-756.3597,-184.3116,430.3542,0,0,0,0,100,0),
(@PATH,16,-742.8285,-179.7665,429.89,0,0,0,0,100,0),
(@PATH,17,-735.0785,-160.2665,429.89,0,0,0,0,100,0),
(@PATH,18,-733.5785,-132.5165,429.89,0,0,0,0,100,0),
(@PATH,19,-735.0785,-105.5165,429.89,0,0,0,0,100,0),
(@PATH,20,-726.8285,-86.51649,429.89,0,0,0,0,100,0),
(@PATH,21,-711.0785,-81.01649,429.89,0,0,0,0,100,0),
(@PATH,22,-722.208,-80.19803,429.8908,0,0,0,0,100,0),
(@PATH,23,-735.458,-99.19803,429.8908,0,0,0,0,100,0),
(@PATH,24,-735.958,-124.948,429.8908,0,0,0,0,100,0),
(@PATH,25,-739.208,-154.448,429.8908,0,0,0,0,100,0),
(@PATH,26,-748.958,-176.448,429.8908,0,0,0,0,100,0),
(@PATH,27,-773.958,-186.448,429.8908,0,0,0,0,100,0),
(@PATH,28,-794.958,-180.948,429.8908,0,0,0,0,100,0),
(@PATH,29,-802.458,-153.698,429.8908,0,0,0,0,100,0),
(@PATH,30,-799.958,-131.948,429.6408,0,0,0,0,100,0),
(@PATH,31,-800.208,-108.948,429.8908,0,0,0,0,100,0),
(@PATH,32,-797.708,-86.19803,429.8908,0,0,0,0,100,0),
(@PATH,33,-796.458,-66.44803,429.8908,0,0,0,0,100,0);

DELETE FROM `creature_formations` WHERE `leaderGUID`=136271;
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
(136271, 136271, 0, 0, 515, 0, 0),
(136271, 136263, 3, 90, 515, 0, 0),
(136271, 136264, 3, 270, 515, 0, 0);

-- channelguys
-- Kirin Tor Battle-Mage SAI
SET @GUID := -136528;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33662;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,0,1,0,100,0,1000,1000,5000,5000,11,48310,0,0,0,0,0,10,137508,33779,0,0,0,0,0,"Kirin Tor Battle-Mage - Out of Combat - Cast 'Transitus Shield Beam'");

-- Kirin Tor Battle-Mage SAI
SET @GUID := -136525;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33662;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,0,1,0,100,1,1000,1000,5000,5000,11,48310,0,0,0,0,0,10,137507,33779,0,0,0,0,0,"Kirin Tor Battle-Mage - On Reset - Cast 'Transitus Shield Beam'");

-- portal visuals mage
-- Kirin Tor Battle-Mage SAI
SET @GUID := -136523;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33662;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,0,1,0,100,0,1000,1000,5000,5000,11,39550,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kirin Tor Battle-Mage - Out of Combat - Cast Portal");

-- portal event
-- first mage
-- Kirin Tor Mage SAI
SET @GUID := -136553;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33672;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,1,1,0,100,0,5000,5000,50000,50000,80,13655300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kirin Tor Mage - Out of Combat - Run Script"),
(@GUID,0,1,0,61,0,100,0,5000,5000,50000,50000,47,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kirin Tor Mage - Out of Combat - Set Visibility On");

-- Actionlist SAI
SET @ENTRY := 13655300;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
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
(@ENTRY,9,0,0,0,0,100,0,1000,1000,0,0,11,12980,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Cast 'Simple Teleport'"),
(@ENTRY,9,1,0,0,0,100,0,1000,1000,0,0,69,0,0,0,0,0,0,8,0,0,0,-815.467712,-228.523056,429.841766,4.479870,"On Script - Move To Position"),
(@ENTRY,9,2,0,0,0,100,0,5000,5000,0,0,75,68442,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Add Aura 'Kneel'"),
(@ENTRY,9,3,0,0,0,100,0,20000,20000,0,0,28,68442,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Remove Aura 'Kneel'"),
(@ENTRY,9,4,0,0,0,100,0,0,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-814.755310,-201.520081,429.841766,1.837791,"On Script - Move To Position"),
(@ENTRY,9,5,0,0,0,100,0,5000,5000,0,0,11,12980,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Cast 'Simple Teleport'"),
(@ENTRY,9,6,0,0,0,100,0,2000,2000,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Visibility Off");

-- second mage
-- Kirin Tor Mage SAI
SET @GUID := -136552;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33672;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,1,1,0,100,0,5000,5000,30000,30000,80,13655200,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kirin Tor Mage - Out of Combat - Run Script"),
(@GUID,0,1,0,61,0,100,0,5000,5000,50000,50000,47,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kirin Tor Mage - Out of Combat - Set Visibility On");

-- Actionlist SAI
SET @ENTRY := 13655200;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
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
(@ENTRY,9,0,0,0,0,100,0,1000,1000,0,0,11,12980,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Cast 'Simple Teleport'"),
(@ENTRY,9,1,0,0,0,100,0,1000,1000,0,0,69,0,0,0,0,0,0,8,0,0,0,-818.564209,-208.605743,429.841736,3.791860,"On Script - Move To Position"),
(@ENTRY,9,2,0,0,0,100,0,2000,2000,0,0,75,68442,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Add Aura 'Kneel'"),
(@ENTRY,9,3,0,0,0,100,0,10000,10000,0,0,28,68442,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Remove Aura 'Kneel'"),
(@ENTRY,9,4,0,0,0,100,0,0,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-814.755310,-201.520081,429.841766,1.837791,"On Script - Move To Position"),
(@ENTRY,9,5,0,0,0,100,0,2000,2000,0,0,11,12980,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Cast 'Simple Teleport'"),
(@ENTRY,9,6,0,0,0,100,0,2000,2000,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Visibility Off");

-- unneeded
DELETE FROM `creature` WHERE `guid`=137509;
-- wrong emotestate, only used during event
DELETE FROM `creature_template_addon` WHERE  `entry`=33672;
-- mage laugh script
-- Emote ID: OneShotYes (273)
-- Emote ID: OneShotTalk (1)
-- Emote ID: OneShotQuestion (6)
-- Emote ID: OneShotNo (274)
-- Emote ID: OneShotExclamation (5)
-- Kirin Tor Mage SAI
SET @GUID := -136538;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33672;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,0,1,0,100,0,3000,4000,3000,4000,10,273,1,6,274,5,0,1,0,0,0,0,0,0,0,"Kirin Tor Mage - Out of Combat - Play Random Emote (273, 1, 6, 274, 5)");

-- Kirin Tor Battle-Mage SAI
SET @GUID := -136521;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33662;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,0,1,0,100,0,3000,4000,3000,4000,10,273,1,6,274,5,0,1,0,0,0,0,0,0,0,"Kirin Tor Battle-Mage - Out of Combat - Play Random Emote (273, 1, 6, 274, 5)");

-- Kirin Tor Mage SAI
SET @GUID := -136539;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33672;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,0,1,0,100,0,3000,4000,3000,4000,10,273,1,6,274,5,0,1,0,0,0,0,0,0,0,"Kirin Tor Mage - Out of Combat - Play Random Emote (273, 1, 6, 274, 5)");

-- Kirin Tor Battle-Mage SAI
SET @GUID := -136522;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33662;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,0,1,0,100,0,3000,4000,3000,4000,10,273,1,6,274,5,0,1,0,0,0,0,0,0,0,"Kirin Tor Battle-Mage - Out of Combat - Play Random Emote (273, 1, 6, 274, 5)");

-- Kirin Tor Mage SAI
SET @GUID := -136546;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33672;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,0,1,0,100,0,3000,4000,3000,4000,10,273,1,6,274,5,0,1,0,0,0,0,0,0,0,"Kirin Tor Mage - Out of Combat - Play Random Emote (273, 1, 6, 274, 5)");

-- Kirin Tor Mage SAI
SET @GUID := -136545;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=33672;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
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
(@GUID,0,0,0,1,0,100,0,3000,4000,3000,4000,10,273,1,6,274,5,0,1,0,0,0,0,0,0,0,"Kirin Tor Mage - Out of Combat - Play Random Emote (273, 1, 6, 274, 5)");