Trinitycore: DB/SAI: Mogu'Shan Palace Trash Mobs

Created on 26 Feb 2017 · 10Comments · Source: TrinityCore/TrinityCore

Dunno if this is proper. Stolen from https://github.com/Ragebones/StormCore/commit/614a710fd8cea92c4c27047e9aa4be005e504c31
Since it is 1:1 copy of TC with their modifications and all headers stripped to say

Since none of their code came from TC, then this didn't come from them.

// EDIT
Apparently even this isn't theirs. SAI by @cooler-SAI.
// EDIT

``mysql -- Glintrok Greenhorn SET @ENTRY := 61247; SET @ENTRYTOTEM := 100099; SET @TOTEMSPELL := 196942; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; UPDATEcreature_templateSETAIName='0' WHEREentry=@ENTRYTOTEM; UPDATEcreature_templateSETspell1=@TOTEMSPELL WHEREentry=@ENTRYTOTEM; INSERT INTOsmart_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,0,0,0,0,0,100,0,5000,8000,25000,37000,11,202318,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Hexaustion'); -- Glintrok Hexxer SET @ENTRY := 61216; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,0,0,100,0,5000,8000,12000,15000,11,118903,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Hex of Lethargy'); -- Glintrok Hexxer SET @ENTRY := 61340; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,0,0,100,0,5000,8000,12000,15000,11,118903,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Hex of Lethargy'); -- Glintrok Ironhide SET @ENTRY := 61337; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,2,0,100,0,0,40,22000,25000,11,118958,2,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Iron Protector at 40% HP'); -- Glintrok Ironhide SET @ENTRY := 61242; SET @ENTRYTOTEM := 100099; SET @TOTEMSPELL := 196942; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; UPDATEcreature_templateSETAIName='0' WHEREentry=@ENTRYTOTEM; UPDATEcreature_templateSETspell1=@TOTEMSPELL WHEREentry=@ENTRYTOTEM; INSERT INTOsmart_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,0,0,0,0,0,100,0,5000,8000,25000,37000,11,202318,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Hexaustion'), (@ENTRY,0,1,0,2,0,100,0,0,40,22000,25000,11,118958,2,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Iron Protector at 40% HP'); -- Glintrok Oracle SET @ENTRY := 61339; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,14,0,100,0,30000,40,15000,18000,11,118940,0,0,0,0,0,7,0,0,0,0,0,0,0,'Cast Cleansing Flame on Friendlies'); -- Glintrok Oracle SET @ENTRY := 61239; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,14,0,100,0,30000,40,15000,18000,11,118940,0,0,0,0,0,7,0,0,0,0,0,0,0,'Cast Cleansing Flame on Friendlies'); -- Glintrok Pillager SET @ENTRY := 61246; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,6,0,100,1,0,0,0,0,11,84369,3,0,0,0,0,0,1,0,0,0,0,0,0,'Cast Summon Gold Pile on Death'); -- Glintrok Skulker SET @ENTRY := 61338; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,11,0,100,1,0,0,0,0,11,118969,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Stealth on Spawn'), (@ENTRY,0,1,0,7,0,100,1,0,0,0,0,11,118969,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Stealth on Evade'), (@ENTRY,0,2,0,0,0,100,0,5000,8000,12000,15000,11,118963,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Shank'); -- Glintrok Skulker SET @ENTRY := 61240; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,11,0,100,1,0,0,0,0,11,118969,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Stealth on Spawn'), (@ENTRY,0,1,0,7,0,100,1,0,0,0,0,11,118969,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Stealth on Evade'), (@ENTRY,0,2,0,0,0,100,0,5000,8000,12000,15000,11,118963,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Shank'); -- Gurthan Swiftblade SET @ENTRY := 65402; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,4,0,100,1,0,0,0,0,11,128239,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Blade Rush on Aggro'), (@ENTRY,0,1,0,0,0,100,0,5000,8000,12000,15000,11,128238,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Swift Strike'); -- Harthak Flameseeker SET @ENTRY := 61392; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,0,0,100,0,0,0,3400,4700,11,121165,64,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Fireball'), (@ENTRY,0,1,0,0,0,100,0,10000,10000,16000,22000,11,121182,2,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Molten Barrage'), (@ENTRY,0,2,0,0,0,100,0,5000,8000,12000,15000,11,121174,2,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Erupting Flame'); -- Harthak Stormcaller SET @ENTRY := 61946; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,0,0,100,0,0,0,3400,4700,11,121601,64,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Lightning Bolt'), (@ENTRY,0,1,0,9,0,100,0,0,20,15000,25000,11,123648,2,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Shock on Close'), (@ENTRY,0,2,0,0,0,100,0,5000,8000,15000,18000,11,120562,0,0,0,0,0,4,0,0,0,0,0,0,0,'Cast Lightning Storm'); -- Kargesh Grunt SET @ENTRY := 61450; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,0,0,100,0,5000,8000,12000,15000,11,120160,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Conflagrate'); -- Kargesh Grunt SET @ENTRY := 61551; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,0,0,100,0,5000,8000,12000,15000,11,120160,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Conflagrate'); -- Kargesh Highguard SET @ENTRY := 61389; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,0,0,100,0,5000,8000,12000,15000,11,121185,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Crunch Armor'), (@ENTRY,0,1,0,9,0,100,0,5,45,15000,25000,11,121173,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Hurl Shield on Close'); -- Kargesh Ribcrusher SET @ENTRY := 61947; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,9,0,100,0,0,5,15000,25000,11,123652,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Whirlwind on Close'), (@ENTRY,0,1,0,0,0,100,0,5000,8000,12000,15000,11,123649,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Mace Smash'); -- Mu'Shiba SET @ENTRY := 61453; UPDATEcreature_templateSETAIName='SmartAI' WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=@ENTRY; INSERT INTOsmart_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,0,0,0,0,0,100,0,5000,8000,12000,15000,11,119948,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Ravage');

Branch-master Comp-Database Feedback-PatchFix

Source

Exodius

Most helpful comment

Here is a simplified and more efficient version of the SQL above, with proper SAI comment format.

-- Mogu'Shan Palace trash mobs
UPDATE `creature_template` SET `spell1`= 196942, `AIName`='' WHERE `entry`= 100099; -- Voodoo Totem, Shaman spell Hex
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (61216,61239,61240,61242,61246,61247,61337,61338,61339,61340,61389,61392,61450,61453,61551,61946,61947,65402);

DELETE FROM `smart_scripts` WHERE `source_type`= 0 AND `entryorguid` IN (61216,61239,61240,61242,61246,61247,61337,61338,61339,61340,61389,61392,61450,61453,61551,61946,61947,65402);
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
(61247,0,0,0, 0,0,100,0, 5000, 8000,25000,37000,11,202318, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Greenhorn - In Combat - Cast 'Hexaustion'"),
(61216,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,118903, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Glintrok Hexxer - In Combat - Cast 'Hex of Lethargy'"),
(61340,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,118903, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Glintrok Hexxer - In Combat - Cast 'Hex of Lethargy'"),
(61242,0,0,0, 0,0,100,0, 5000, 8000,25000,37000,11,202318, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Ironhide - In Combat - Cast 'Hexaustion'"),
(61242,0,1,0, 2,0,100,0,    0,   40,22000,25000,11,118958, 2,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Ironhide - At 40% HP - Cast 'Iron Protector'"),
(61337,0,0,0, 2,0,100,0,    0,   40,22000,25000,11,118958, 2,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Ironhide - At 40% HP - Cast 'Iron Protector'"),
(61239,0,0,0,14,0,100,0,30000,   40,15000,18000,11,118940, 0,0,0,0,0,7,0,0,0,0,0,0,0,"Glintrok Oracle - On Friendly Health Low - Cast 'Cleansing Flame'"),
(61339,0,0,0,14,0,100,0,30000,   40,15000,18000,11,118940, 0,0,0,0,0,7,0,0,0,0,0,0,0,"Glintrok Oracle - On Friendly Health Low - Cast 'Cleansing Flame'"),
(61246,0,0,0, 6,0,100,1,    0,    0,    0,    0,11, 84369, 3,0,0,0,0,0,1,0,0,0,0,0,0,"Glintrok Pillager - On Death - Cast 'Summon Gold Pile'(no repeat)"),
(61240,0,0,0,11,0,100,1,    0,    0,    0,    0,11,118969, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Skulker - On Respawn - Cast 'Stealth'(no repeat)"),
(61240,0,1,0, 7,0,100,1,    0,    0,    0,    0,11,118969, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Skulker - On Evade - Cast 'Stealth'(no repeat)"),
(61240,0,2,0, 0,0,100,0, 5000, 8000,12000,15000,11,118963, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Glintrok Skulker - In Combat - Cast 'Shank'"),
(61338,0,0,0,11,0,100,1,    0,    0,    0,    0,11,118969, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Skulker - On Respawn - Cast 'Stealth'(no repeat)"),
(61338,0,1,0, 7,0,100,1,    0,    0,    0,    0,11,118969, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Skulker - On Evade - Cast 'Stealth'(no repeat)"),
(61338,0,2,0, 0,0,100,0, 5000, 8000,12000,15000,11,118963, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Glintrok Skulker - In Combat - Cast 'Shank'"),
(65402,0,0,0, 4,0,100,1,    0,    0,    0,    0,11,128239, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Gurthan Swiftblade - On Aggro - Cast 'Blade Rush'(no repeat)"),
(65402,0,1,0, 0,0,100,0, 5000, 8000,12000,15000,11,128238, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Gurthan Swiftblade - In Combat - Cast 'Swift Strike'"),
(61392,0,0,0, 0,0,100,0,    0,    0, 3400, 4700,11,121165,64,0,0,0,0,2,0,0,0,0,0,0,0,"Harthak Flameseeker - In Combat - Cast 'Fireball'"),
(61392,0,1,0, 0,0,100,0,10000,10000,16000,22000,11,121182, 2,0,0,0,0,1,0,0,0,0,0,0,0,"Harthak Flameseeker - In Combat - Cast 'Molten Barrage'"),
(61392,0,2,0, 0,0,100,0, 5000, 8000,12000,15000,11,121174, 2,0,0,0,0,2,0,0,0,0,0,0,0,"Harthak Flameseeker - In Combat - Cast 'Erupting Flame'"),
(61946,0,0,0, 0,0,100,0,    0,    0, 3400, 4700,11,121601,64,0,0,0,0,2,0,0,0,0,0,0,0,"Harthak Stormcaller - In Combat - Cast 'Lightning Bolt'"),
(61946,0,1,0, 9,0,100,0,    0,   20,15000,25000,11,123648, 2,0,0,0,0,2,0,0,0,0,0,0,0,"Harthak Stormcaller - On Target In Range - Cast 'Shock'"),
(61946,0,2,0, 0,0,100,0, 5000, 8000,15000,18000,11,120562, 0,0,0,0,0,4,0,0,0,0,0,0,0,"Harthak Stormcaller - In Combat - Cast 'Lightning Storm'"),
(61450,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,120160, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Grunt - In Combat - Cast 'Conflagrate'"),
(61551,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,120160, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Grunt - In Combat - Cast 'Conflagrate'"),
(61389,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,121185, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Highguard - In Combat - Cast 'Crunch Armor'"),
(61389,0,1,0, 9,0,100,0,    5,   45,15000,25000,11,121173, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Highguard - On Target In Range - Cast 'Hurl Shield'"),
(61947,0,0,0, 9,0,100,0,    0,    5,15000,25000,11,123652, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Kargesh Ribcrusher - On Target In Range - Cast 'Whirlwind'"),
(61947,0,1,0, 0,0,100,0, 5000, 8000,12000,15000,11,123649, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Ribcrusher - In Combat - Cast 'Mace Smash'"),
(61453,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,119948, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Mu'Shiba - In Combat - Cast 'Ravage'");

I have neither tested it nor verified the content, there is no change in functionality.

ghost on 27 Feb 2017

👍4

All 10 comments

Since it is 1:1 copy of TC with their modifications and all headers stripped to say
Since none of their code came from TC, then this didn't come from them.

We do not need to lower our ethics or morals to match the people of that TrinityCore fork. Ask the author of that code (@Zydrax) for permission to use it.

DDuarte on 27 Feb 2017

Here is a simplified and more efficient version of the SQL above, with proper SAI comment format.

-- Mogu'Shan Palace trash mobs
UPDATE `creature_template` SET `spell1`= 196942, `AIName`='' WHERE `entry`= 100099; -- Voodoo Totem, Shaman spell Hex
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (61216,61239,61240,61242,61246,61247,61337,61338,61339,61340,61389,61392,61450,61453,61551,61946,61947,65402);

DELETE FROM `smart_scripts` WHERE `source_type`= 0 AND `entryorguid` IN (61216,61239,61240,61242,61246,61247,61337,61338,61339,61340,61389,61392,61450,61453,61551,61946,61947,65402);
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
(61247,0,0,0, 0,0,100,0, 5000, 8000,25000,37000,11,202318, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Greenhorn - In Combat - Cast 'Hexaustion'"),
(61216,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,118903, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Glintrok Hexxer - In Combat - Cast 'Hex of Lethargy'"),
(61340,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,118903, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Glintrok Hexxer - In Combat - Cast 'Hex of Lethargy'"),
(61242,0,0,0, 0,0,100,0, 5000, 8000,25000,37000,11,202318, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Ironhide - In Combat - Cast 'Hexaustion'"),
(61242,0,1,0, 2,0,100,0,    0,   40,22000,25000,11,118958, 2,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Ironhide - At 40% HP - Cast 'Iron Protector'"),
(61337,0,0,0, 2,0,100,0,    0,   40,22000,25000,11,118958, 2,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Ironhide - At 40% HP - Cast 'Iron Protector'"),
(61239,0,0,0,14,0,100,0,30000,   40,15000,18000,11,118940, 0,0,0,0,0,7,0,0,0,0,0,0,0,"Glintrok Oracle - On Friendly Health Low - Cast 'Cleansing Flame'"),
(61339,0,0,0,14,0,100,0,30000,   40,15000,18000,11,118940, 0,0,0,0,0,7,0,0,0,0,0,0,0,"Glintrok Oracle - On Friendly Health Low - Cast 'Cleansing Flame'"),
(61246,0,0,0, 6,0,100,1,    0,    0,    0,    0,11, 84369, 3,0,0,0,0,0,1,0,0,0,0,0,0,"Glintrok Pillager - On Death - Cast 'Summon Gold Pile'(no repeat)"),
(61240,0,0,0,11,0,100,1,    0,    0,    0,    0,11,118969, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Skulker - On Respawn - Cast 'Stealth'(no repeat)"),
(61240,0,1,0, 7,0,100,1,    0,    0,    0,    0,11,118969, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Skulker - On Evade - Cast 'Stealth'(no repeat)"),
(61240,0,2,0, 0,0,100,0, 5000, 8000,12000,15000,11,118963, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Glintrok Skulker - In Combat - Cast 'Shank'"),
(61338,0,0,0,11,0,100,1,    0,    0,    0,    0,11,118969, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Skulker - On Respawn - Cast 'Stealth'(no repeat)"),
(61338,0,1,0, 7,0,100,1,    0,    0,    0,    0,11,118969, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Glintrok Skulker - On Evade - Cast 'Stealth'(no repeat)"),
(61338,0,2,0, 0,0,100,0, 5000, 8000,12000,15000,11,118963, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Glintrok Skulker - In Combat - Cast 'Shank'"),
(65402,0,0,0, 4,0,100,1,    0,    0,    0,    0,11,128239, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Gurthan Swiftblade - On Aggro - Cast 'Blade Rush'(no repeat)"),
(65402,0,1,0, 0,0,100,0, 5000, 8000,12000,15000,11,128238, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Gurthan Swiftblade - In Combat - Cast 'Swift Strike'"),
(61392,0,0,0, 0,0,100,0,    0,    0, 3400, 4700,11,121165,64,0,0,0,0,2,0,0,0,0,0,0,0,"Harthak Flameseeker - In Combat - Cast 'Fireball'"),
(61392,0,1,0, 0,0,100,0,10000,10000,16000,22000,11,121182, 2,0,0,0,0,1,0,0,0,0,0,0,0,"Harthak Flameseeker - In Combat - Cast 'Molten Barrage'"),
(61392,0,2,0, 0,0,100,0, 5000, 8000,12000,15000,11,121174, 2,0,0,0,0,2,0,0,0,0,0,0,0,"Harthak Flameseeker - In Combat - Cast 'Erupting Flame'"),
(61946,0,0,0, 0,0,100,0,    0,    0, 3400, 4700,11,121601,64,0,0,0,0,2,0,0,0,0,0,0,0,"Harthak Stormcaller - In Combat - Cast 'Lightning Bolt'"),
(61946,0,1,0, 9,0,100,0,    0,   20,15000,25000,11,123648, 2,0,0,0,0,2,0,0,0,0,0,0,0,"Harthak Stormcaller - On Target In Range - Cast 'Shock'"),
(61946,0,2,0, 0,0,100,0, 5000, 8000,15000,18000,11,120562, 0,0,0,0,0,4,0,0,0,0,0,0,0,"Harthak Stormcaller - In Combat - Cast 'Lightning Storm'"),
(61450,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,120160, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Grunt - In Combat - Cast 'Conflagrate'"),
(61551,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,120160, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Grunt - In Combat - Cast 'Conflagrate'"),
(61389,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,121185, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Highguard - In Combat - Cast 'Crunch Armor'"),
(61389,0,1,0, 9,0,100,0,    5,   45,15000,25000,11,121173, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Highguard - On Target In Range - Cast 'Hurl Shield'"),
(61947,0,0,0, 9,0,100,0,    0,    5,15000,25000,11,123652, 0,0,0,0,0,1,0,0,0,0,0,0,0,"Kargesh Ribcrusher - On Target In Range - Cast 'Whirlwind'"),
(61947,0,1,0, 0,0,100,0, 5000, 8000,12000,15000,11,123649, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Kargesh Ribcrusher - In Combat - Cast 'Mace Smash'"),
(61453,0,0,0, 0,0,100,0, 5000, 8000,12000,15000,11,119948, 0,0,0,0,0,2,0,0,0,0,0,0,0,"Mu'Shiba - In Combat - Cast 'Ravage'");

I have neither tested it nor verified the content, there is no change in functionality.

ghost on 27 Feb 2017

👍4

@DDuarte those SAI's are not even of StormCore. They are from JadeCore i think..

LuigiElleBalotta on 27 Feb 2017

@DDuarte @LuigiElleBalotta original author Cooler-SAI

zgn1988 on 27 Feb 2017

😄1 👍1

@Exodius, @DDuarte , @tkrokli , @LuigiElleBalotta , hey all!))) @zamalaev right, they are from my repo
https://github.com/cooler-SAI/patch/blob/5.4.8/Development/Dungeons/Pandaria/Mogu'shan%20Palace.sql
it's mine) but you can use it. just named author

cooler-SAI on 27 Feb 2017

Thanks @cooler-SAI

Why do people keep stealing and getting away with it? 🤔

DDuarte on 27 Feb 2017

@DDuarte , coz they need reputation and respect, I think)

cooler-SAI on 27 Feb 2017

That sounds counterproductive.

DDuarte on 27 Feb 2017

Dunno. I just stumbled upon the repo linked in first post here, saw what they did and then went a couple of pages through commits and posting original authors of the commit (I was bored). As I wrote, that repo is 1:1 clone of TC's master branch with some minor modifications and all headers stripped of TC copyright line... Since they don't recognize TC as their base branch, then I am gonna lurk and leach everything from them... 😈

Exodius on 27 Feb 2017

@Exodius , RAGEE!!!))))))))

cooler-SAI on 28 Feb 2017

Was this page helpful?

0 / 5 - 0 ratings