Trinitycore: DB/Creature: Stonemaul Spirit

[ZenoX92]

Description:

• Add missing texts on spawn for Stonemaul Spirit

Branch(es):

3.3.5

TC rev. hash/commit:

TrinityCore rev. 1cc3d33 2018-02-19 20:21:57 +0100 (3.3.5 branch) (Win64, RelWithDebInfo, Static)

TDB version: 335.64

Operating system: Windows 7

Suggested Fix:
``sql -- Stonemaul Spirit UPDATEcreature_templateSETAIName="SmartAI" WHEREentry=23786; DELETE FROMsmart_scriptsWHEREentryorguid=23786 ANDsource_type=0; DELETE FROMsmart_scriptsWHEREentryorguid=2378600 ANDsource_type=9; 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
(23786,0,0,0,11,0,100,0,0,0,0,0,80,2378600,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stonemaul Spirit - On Spawn - Run Script"),
(2378600,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,"Stonemaul Spirit - On Script - Say Line 0"),
(2378600,9,1,0,0,0,100,0,2000,2000,0,0,49,0,0,0,0,0,0,23,0,0,0,0,0,0,0,"Stonemaul Spirit - On Script - Start Attacking");

DELETE FROM creature_text WHERE CreatureID=23786;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(23786,0,0,"Me crush puny friend of dragons!",12,0,100,15,0,0,22416,0,"Stonemaul Spirit"),
(23786,0,1,"You leave Stonemaul lands now!",12,0,100,15,0,0,22417,0,"Stonemaul Spirit"),
(23786,0,2,"Why you wake ghost? Where other Stonemauls?!",12,0,100,15,0,0,22418,0,"Stonemaul Spirit"),
(23786,0,3,"Raaar!!! Me smash $r!",12,0,100,15,0,0,1925,0,"Stonemaul Spirit"),
(23786,0,4,"Me smash! You die!",12,0,100,15,0,0,1926,0,"Stonemaul Spirit"),
(23786,0,5,"I'll crush you!",12,0,100,15,0,0,1927,0,"Stonemaul Spirit");

[offl]

As I know from movies

(23786,0,0,"Me crush puny friend of dragons!",12,0,100,15,0,0,22416,0,"Stonemaul Spirit"),
(23786,0,1,"You leave Stonemaul lands now!",12,0,100,15,0,0,22417,0,"Stonemaul Spirit"),
(23786,0,2,"Why you wake ghost? Where other Stonemauls?!",12,0,100,15,0,0,22418,0,"Stonemaul Spirit"),

Only on spawn, always

(23786,0,3,"Raaar!!! Me smash $r!",12,0,100,15,0,0,1925,0,"Stonemaul Spirit"),
(23786,0,4,"Me smash! You die!",12,0,100,15,0,0,1926,0,"Stonemaul Spirit"),
(23786,0,5,"I'll crush you!",12,0,100,15,0,0,1927,0,"Stonemaul Spirit");

Only on aggro, 15% chance
Without the emote ofc

https://youtu.be/jHpHWzHj42s?t=144

[ZenoX92]

All the texts are always said on spawn, @offl. No aggro texts this time.

And I scripted it based on a video from here https://www.youtube.com/user/excandersham/videos
(It's Part 43, I think.)

[offl]

Just change the speed to 0.25 :)
https://youtu.be/558vNOJ7rvA?t=373

[ZenoX92]

You're right, @offl. My bad!

@Killyana, could you push this again?
``sql -- Stonemaul Spirit UPDATEcreature_templateSETAIName="SmartAI" WHEREentry=23786; DELETE FROMsmart_scriptsWHEREentryorguid=23786 ANDsource_type=0; DELETE FROMsmart_scriptsWHEREentryorguid=2378600 ANDsource_type=9; 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
(23786,0,0,0,11,0,100,0,0,0,0,0,80,2378600,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stonemaul Spirit - On Spawn - Run Script"),
(23786,0,1,0,4,0,15,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stonemaul Spirit - On Aggro - Say Line 1"),
(2378600,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stonemaul Spirit - On Script - Say Line 0"),
(2378600,9,1,0,0,0,100,0,2000,2000,0,0,49,0,0,0,0,0,0,23,0,0,0,0,0,0,0,"Stonemaul Spirit - On Script - Start Attacking");

DELETE FROM creature_text WHERE CreatureID=23786;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(23786,0,0,"Me crush puny friend of dragons!",12,0,100,15,0,0,22416,0,"Stonemaul Spirit"),
(23786,0,1,"You leave Stonemaul lands now!",12,0,100,15,0,0,22417,0,"Stonemaul Spirit"),
(23786,0,2,"Why you wake ghost? Where other Stonemauls?!",12,0,100,15,0,0,22418,0,"Stonemaul Spirit"),
(23786,1,0,"Raaar!!! Me smash $r!",12,0,100,0,0,0,1925,0,"Stonemaul Spirit"),
(23786,1,1,"Me smash! You die!",12,0,100,0,0,0,1926,0,"Stonemaul Spirit"),
(23786,1,2,"I'll crush you!",12,0,100,0,0,0,1927,0,"Stonemaul Spirit");