This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Atotona #930 | |
| -- Aotona1 | |
| DELETE FROM `creature` WHERE `guid`=152004; | |
| INSERT INTO `creature` VALUES (152004, 32481, 571, 0, 0, 1, 1, 0, 0, 5368.74, 4427.76, -133.397, 0.206642, 28800, 20, 0, 15952, 0, 2, 0, 0, 0, 0); | |
| SET @ENTRY := 1520040; | |
| SET @GUID := 152004; | |
| DELETE FROM `waypoint_data` WHERE `id`=1520040; | |
| INSERT INTO `waypoint_data` VALUES | |
| (1520040, 1, 5373.04, 4428.42, -129.448, 0, 0, 0, 0, 100, 0), |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Crystal Handler #4353 | |
| SET @ENTRY := 26627; | |
| SET @SOURCETYPE := 0; | |
| DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; | |
| UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY LIMIT 1; | |
| 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,@SOURCETYPE,0,0,0,0,100,0,1000,1000,5000,5000,11,49668,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Crystal Handler - In Combat - Cast 'Flash of Darkness'"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Bat Rider Guard #1072 | |
| DELETE FROM `creature` WHERE `id`=15242; | |
| INSERT INTO `creature` VALUES | |
| (54840, 15242, 530, 0, 0, 1, 1, 0, 0, 156.903, 2554.78, 170.895, 5.15224, 300, 0, 0, 13972, 0, 2, 0, 0, 0, 0), | |
| (54841, 15242, 530, 0, 0, 1, 1, 0, 0, 65.9778, 2661.21, 163.675, 0.511107, 300, 0, 0, 13972, 0, 2, 0, 0, 0, 0), | |
| (54842, 15242, 530, 0, 0, 1, 1, 0, 0, 263.597, 2694.82, 169.731, 1.23918, 300, 0, 0, 13972, 0, 2, 0, 0, 0, 0), | |
| (54843, 15242, 530, 0, 0, 1, 1, 0, 0, 62.4202, 2785.72, 192.112, 4.43018, 300, 0, 0, 13972, 0, 2, 0, 0, 0, 0), | |
| (54846, 15242, 530, 0, 0, 1, 1, 0, 0, -3013, 2633, 126, 5, 300, 7, 0, 13972, 0, 1, 0, 0, 0, 0), | |
| (54847, 15242, 530, 0, 0, 1, 1, 0, 0, -3101, 2598, 109, 1, 300, 7, 0, 13972, 0, 1, 0, 0, 0, 0), | |
| (54848, 15242, 530, 0, 0, 1, 1, 0, 0, 77.5297, 5191.24, 74.6276, 1.8675, 300, 7, 0, 13972, 0, 1, 0, 0, 0, 0), |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Scourge Brute #4356 | |
| SET @ENTRY := 26623; | |
| SET @SOURCETYPE := 0; | |
| DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE; | |
| UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY LIMIT 1; | |
| 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,@SOURCETYPE,0,0,0,0,100,2,1000,3000,14000,18500,11,16856,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Scourge Brute - In Combat - Cast 'Mortal Strike' (No Repeat)"), | |
| (@ENTRY,@SOURCETYPE,1,0,0,0,100,2,6000,9000,9000,12000,11,35011,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Scourge Brute - In Combat - Cast 'Knockdown' (No Repeat)"), | |
| (@ENTRY,@SOURCETYPE,2,0,0,0,100,2,1000,3000,10000 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Unleashed Hellion #4758 | |
| DELETE FROM `creature` WHERE `guid`=93983; | |
| INSERT INTO `creature` VALUES | |
| (93983, 25002, 530, 0, 0, 1, 1, 0, 1, 12667.5, -7094.47, 18.3963, 1.39092, 450, 4, 0, 5589, 3155, 1, 0, 0, 0, 0); | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Twilight avenger #4760 | |
| DELETE FROM `creature` WHERE `guid`=42997; | |
| INSERT INTO `creature` VALUES | |
| (42997, 11880, 1, 0, 0, 1, 1, 11812, 1, -7049.92, 1111.83, 5.21439, -0.756329, 300, 5, 0, 3876, 0, 1, 0, 0, 0, 0); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Twilight avenger #4761 | |
| DELETE FROM `creature` WHERE `guid`=42970; | |
| INSERT INTO `creature` VALUES | |
| (42970, 11880, 1, 0, 0, 1, 1, 11823, 1, -6972.02, 1073.48, 5.04001, 0.701645, 300, 5, 0, 3876, 0, 1, 0, 0, 0, 0); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- bonepaw Hyena #4819 | |
| DELETE FROM `creature` WHERE `guid`=27947; | |
| INSERT INTO `creature` VALUES | |
| (27947, 4688, 1, 0, 0, 1, 1, 10902, 0, -442.361, 2116.41, 90.3753, 4.39939, 300, 5, 0, 444, 0, 1, 0, 0, 0, 0); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- bonepaw Hyena1 #4820 | |
| DELETE FROM `creature` WHERE `guid`=27946; | |
| INSERT INTO `creature` VALUES | |
| (27946, 4688, 1, 0, 0, 1, 1, 10902, 0, -440.505, 2118.62, 90.3753, 4.09959, 300, 5, 0, 444, 0, 1, 0, 0, 0, 0); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- bonepaw Hyena3 #4821 | |
| DELETE FROM `creature` WHERE `guid`=27945; | |
| INSERT INTO `creature` VALUES | |
| (27945, 4688, 1, 0, 0, 1, 1, 10902, 0, -438.82, 2118.56, 90.3753, 4.32633, 300, 5, 0, 444, 0, 1, 0, 0, 0, 0); |
NewerOlder