diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_21_00_world_2020_06_30_00_world.sql | 148 |
1 files changed, 148 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_21_00_world_2020_06_30_00_world.sql b/sql/updates/world/master/2022_01_21_00_world_2020_06_30_00_world.sql new file mode 100644 index 00000000000..dc70f8cf025 --- /dev/null +++ b/sql/updates/world/master/2022_01_21_00_world_2020_06_30_00_world.sql @@ -0,0 +1,148 @@ +UPDATE `creature_template` SET `faction`=104, `unit_flags`=`unit_flags`&~512 WHERE `entry`=10600; +UPDATE `creature_template` SET `type_flags`=8, `flags_extra`=`flags_extra`|0x40000000 WHERE `entry` IN (10599, 10600); +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (3063, 10599, 10600, 10721); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3063, 10599, 10600, 10721) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (306300, 306301, 1059900, 1059901, 1059902, 1059903, 1059904, 1060000, 1060001, 1060002, 1060003, 1060004, 1072100, 1072101, 1072102, 1072103, 1072104, 1072105) 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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(3063, 0, 0, 0, 1, 0, 100, 0, 5000, 5000, 780000, 900000, 0, 80, 306300, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - OOC - Run Script"), +(3063, 0, 1, 0, 1, 1, 100, 0, 0, 0, 8000, 8000, 0, 45, 3, 3, 0, 0, 0, 0, 9, 10721, 0, 100, 0, 0, 0, 0, 0, "Krang Stonehoof - OOC - Set Data 3 3 (Novice Warrior)"), +(3063, 0, 2, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Data 1 1 Set - Say Line 3"), +(3063, 0, 3, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 80, 306301, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Data 2 2 Set - Run Script"), + +(306300, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Say Line 0"), +(306300, 9, 1, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 10599, 100, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Set Data 1 1 (Hulfnar Stonetotem)"), +(306300, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 10600, 100, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Set Data 1 1 (Thontek Rumblehoof)"), +(306300, 9, 3, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Say Line 1"), +(306300, 9, 4, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 10721, 0, 100, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Set Data 1 1 (Novice Warrior)"), +(306300, 9, 5, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 10599, 100, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Set Data 2 2 (Hulfnar Stonetotem)"), +(306300, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 10600, 100, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Set Data 2 2 (Thontek Rumblehoof)"), +(306300, 9, 7, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Say Line 2"), +(306300, 9, 8, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 9, 10721, 0, 100, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Set Data 2 2 (Novice Warrior)"), +(306300, 9, 9, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Set Event Phase 1"), +(306301, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Set Event Phase 0"), +(306301, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Say Line 4"), +(306301, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Say Line 5"), +(306301, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Say Line 6"), +(306301, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 4, 4, 0, 0, 0, 0, 9, 10721, 0, 100, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Set Data 4 4 (Novice Warrior)"), +(306301, 9, 5, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Say Line 7"), +(306301, 9, 6, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Play Emote Bow"), +(306301, 9, 7, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 1, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Krang Stonehoof - On Script - Say Line 8"), + +(10721, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 91, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Data 1 1 Set - Remove Standstate Sit"), +(10721, 0, 1, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 5, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Data 2 2 Set - Play Emote Cheer"), +(10721, 0, 2, 0, 38, 0, 100, 0, 3, 3, 0, 0, 0, 88, 1072100, 1072104, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Data 3 3 Set - Play Emote Cheer"), +(10721, 0, 3, 0, 38, 0, 100, 0, 4, 4, 0, 0, 0, 80, 1072105, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Data 4 4 Set - Run Script"), + +(1072100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 5, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Script - Play Emote Cheer"), +(1072101, 9, 0, 0, 0, 0, 100, 0, 1500, 1500, 0, 0, 0, 5, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Script - Play Emote Cheer"), +(1072102, 9, 0, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 5, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Script - Play Emote Cheer"), +(1072103, 9, 0, 0, 0, 0, 100, 0, 4500, 4500, 0, 0, 0, 5, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Script - Play Emote Cheer"), +(1072104, 9, 0, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 5, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Script - Play Emote Cheer"), +(1072105, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 90, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Novice Warrior - On Script - Set Standstate Sit"), + +(10599, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 80, 1059900, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Data 1 1 Set - Run Script"), +(10599, 0, 1, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 80, 1059901, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Data 2 2 Set - Run Script"), +(10599, 0, 2, 0, 0, 1, 100, 0, 8000, 20000, 8000, 20000, 0, 80, 1059902, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - In Combat - Run Script (Phase 1)"), +(10599, 0, 3, 0, 2, 1, 100, 1, 0, 15, 0, 0, 0, 11, 17648, 0, 0, 0, 0, 0, 19, 10600, 100, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Health Below 15% - Cast 'Surrender' (Thontek Rumblehoof) (Phase 1)"), +(10599, 0, 4, 5, 8, 0, 100, 0, 17648, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On SpellHit 'Surrender' - Set ReactState Passive"), +(10599, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 0, 46, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On SpellHit 'Surrender' - Stop Attack"), +(10599, 0, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 0, 11, 17649, 0, 0, 0, 0, 0, 19, 10600, 100, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On SpellHit 'Surrender' - Cast 'Accept Surrender' (Thontek Rumblehoof)"), +(10599, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 80, 1059903, 2, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On SpellHit 'Surrender' - Run Script"), +(10599, 0, 8, 9, 8, 0, 100, 0, 17649, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On SpellHit 'Accept Surrender' - Set ReactState Passive"), +(10599, 0, 9, 10, 61, 0, 100, 0, 0, 0, 0, 0, 0, 46, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On SpellHit 'Accept Surrender' - Stop Attack"), +(10599, 0, 10, 11, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 3063, 100, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On SpellHit 'Accept Surrender' - Set Data 2 2 (Krang Stonehoof)"), +(10599, 0, 11, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 80, 1059903, 2, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On SpellHit 'Accept Surrender' - Run Script"), +(10599, 0, 12, 0, 34, 0, 100, 0, 0, 1, 0, 0, 0, 80, 1059904, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On MovePoint 1 Reached - Run Script"), + +(1059900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 91, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Data 1 1 Set - Remove Standstate Sit"), +(1059900, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set Run Off"), +(1059900, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 114, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, 0, 0, "Hulfnar Stonetotem - On Data 1 1 Set - Move Forward"), +(1059900, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 3063, 100, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Face Krang Stonehoof"), +(1059900, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set Run On"), +(1059900, 9, 5, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Play Emote Bow"), +(1059901, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 10600, 100, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Face Thontek Rumblehoof"), +(1059901, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Say Line 0"), +(1059901, 9, 2, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Say Line 1"), +(1059901, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 5, 15, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Play Emote Roar"), +(1059901, 9, 4, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 2, 1606, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set Faction"), +(1059901, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set Event Phase 1"), +(1059901, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 10600, 100, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Attack Thontek Rumblehoof"), +(1059902, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 16740, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Cast 'War Stomp'"), +(1059902, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 3063, 100, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set Data 1 1 (Krang Stonehoof)"), +(1059903, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set Event Phase 0"), +(1059903, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Play Emote Bow"), +(1059903, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 3063, 100, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Face Krang Stonehoof"), +(1059903, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Play Emote Bow"), +(1059903, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set Run Off"), +(1059903, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, -2360.290039, -519.245972, -9.299930, 0, "Hulfnar Stonetotem - On Script - Move To Pos"), +(1059904, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 117, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Disable Evade Mode"), +(1059904, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Reset Orienation"), +(1059904, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 117, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Enable Evade Mode"), +(1059904, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set Run On"), +(1059904, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 2, 104, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set Faction"), +(1059904, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Set ReactState Aggressive"), +(1059904, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Hulfnar Stonetotem - On Script - Enter Evade Mode"), + +(10600, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 80, 1060000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Data 1 1 Set - Run Script"), +(10600, 0, 1, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 80, 1060001, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Data 2 2 Set - Run Script"), +(10600, 0, 2, 0, 0, 1, 100, 0, 8000, 20000, 8000, 20000, 0, 80, 1060002, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - In Combat - Run Script (Phase 1)"), +(10600, 0, 3, 0, 2, 1, 100, 1, 0, 15, 0, 0, 0, 11, 17648, 0, 0, 0, 0, 0, 19, 10599, 100, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Health Below 15% - Cast 'Surrender' (Hulfnar Stonetotem) (Phase 1)"), +(10600, 0, 4, 5, 8, 0, 100, 0, 17648, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On SpellHit 'Surrender' - Set ReactState Passive"), +(10600, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 0, 46, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On SpellHit 'Surrender' - Stop Attack"), +(10600, 0, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 0, 11, 17649, 0, 0, 0, 0, 0, 19, 10599, 100, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On SpellHit 'Surrender' - Cast 'Accept Surrender' (Hulfnar Stonetotem)"), +(10600, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 80, 1060003, 2, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On SpellHit 'Surrender' - Run Script"), +(10600, 0, 8, 9, 8, 0, 100, 0, 17649, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On SpellHit 'Accept Surrender' - Set ReactState Passive"), +(10600, 0, 9, 10, 61, 0, 100, 0, 0, 0, 0, 0, 0, 46, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On SpellHit 'Accept Surrender' - Stop Attack"), +(10600, 0, 10, 11, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 3063, 100, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On SpellHit 'Accept Surrender' - Set Data 2 2 (Krang Stonehoof)"), +(10600, 0, 11, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 80, 1060003, 2, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On SpellHit 'Accept Surrender' - Run Script"), +(10600, 0, 12, 0, 34, 0, 100, 0, 0, 1, 0, 0, 0, 80, 1060004, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On MovePoint 1 Reached - Run Script"), + +(1060000, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 91, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Remove Standstate Sit"), +(1060000, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set Run Off"), +(1060000, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 114, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, 0, 0, "Thontek Rumblehoof - On Script - Move Forward"), +(1060000, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 3063, 100, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Face Krang Stonehoof"), +(1060000, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set Run On"), +(1060000, 9, 5, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Play Emote Bow"), +(1060001, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 10599, 100, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Face Hulfnar Stonetotem"), +(1060001, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Say Line 0"), +(1060001, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 5, 25, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Play Emote Point"), +(1060001, 9, 3, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 4, 6278, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Play Sound"), +(1060001, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 5, 15, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Play Emote Roar"), +(1060001, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 2, 1606, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set Faction"), +(1060001, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set Event Phase 1"), +(1060001, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 10599, 100, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Attack Hulfnar Stonetotem"), +(1060002, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 16740, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Cast 'War Stomp'"), +(1060002, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 3063, 100, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set Data 1 1 (Krang Stonehoof)"), +(1060003, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set Event Phase 0"), +(1060003, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Play Emote Bow"), +(1060003, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 3063, 100, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Face Krang Stonehoof"), +(1060003, 9, 3, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 5, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Play Emote Bow"), +(1060003, 9, 4, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set Run Off"), +(1060003, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, -2333.959961, -512.051025, -9.299930, 0, "Thontek Rumblehoof - On Script - Move To Pos"), +(1060004, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 117, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Disable Evade Mode"), +(1060004, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Reset Orienation"), +(1060004, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 117, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Enable Evade Mode"), +(1060004, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set Run On"), +(1060004, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 2, 104, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set Faction"), +(1060004, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Set ReactState Aggressive"), +(1060004, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Thontek Rumblehoof - On Script - Enter Evade Mode"); + +DELETE FROM `creature_text` WHERE `CreatureID` IN (3063, 10599, 10600); +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(3063, 0, 0, "Hulfnar! Thontek! Stand and address me.", 12, 3, 100, 1, 0, 0, 6005, 0, "Krang Stonehoof"), +(3063, 1, 0, "I want you both to demonstrate the techniques I have taught you for the benefit of the younger students here. Ready... begin!", 12, 3, 100, 1, 0, 0, 6020, 0, "Krang Stonehoof"), +(3063, 2, 0, "Enough talk you two! Commence fighting!", 12, 3, 100, 22, 0, 0, 6025, 0, "Krang Stonehoof"), +(3063, 3, 0, "Now that's a War Stomp! Good job!", 12, 3, 100, 21, 0, 0, 6072, 0, "Krang Stonehoof"), +(3063, 3, 1, "That's how it's done class! You better be paying attention!", 12, 3, 100, 21, 0, 0, 6073, 0, "Krang Stonehoof"), +(3063, 3, 2, "Now that's putting your hoof down!", 12, 3, 100, 21, 0, 0, 6074, 0, "Krang Stonehoof"), +(3063, 4, 0, "Ish nu! That's enough!", 12, 3, 100, 1, 0, 0, 6091, 0, "Krang Stonehoof"), +(3063, 5, 0, "Well Done!", 12, 3, 100, 1, 0, 6575, 6038, 0, "Krang Stonehoof"), +(3063, 6, 0, "Good, good. Now bow to each other.", 12, 3, 100, 1, 0, 0, 6098, 0, "Krang Stonehoof"), +(3063, 7, 0, "Now bow to me.", 12, 3, 100, 1, 0, 0, 6099, 0, "Krang Stonehoof"), +(3063, 8, 0, "Good job you two. Now go have a seat.", 12, 3, 100, 1, 0, 0, 6100, 0, "Krang Stonehoof"), +(10599, 0, 0, "Start running!", 12, 3, 100, 25, 0, 6280, 5966, 0, "Hulfnar Stonetotem"), +(10599, 1, 0, "Bring it on!", 12, 3, 100, 22, 0, 6281, 5967, 0, "Hulfnar Stonetotem"), +(10600, 0, 0, "Do not push me, or I will impale you on my horns!", 12, 3, 100, 22, 0, 6277, 5968, 0, "Thontek Rumblehoof"); + +UPDATE `creature` SET `modelid`=0 WHERE id=10721; |