Trinitycore: [NPC] "Swamp Eye" Jarl - Creepy Event

[Rushor]

Description:
While reading this https://ironyca.wordpress.com/2010/09/15/the-10-most-creepy-things-in-wow/ i found some spooky shit that's not implemented currently:

– “I brought you a housewarming gift, Jarl.
Go on, open it. I think you’ll like it.
Jarl?”

– “Unless It’s something I can eat, I don’t want it.”

– “Jarl, you haven’t been yourself ever since I arrived. What’s going on?”

– “Nothing. Wanna help me whip up some frog leg stew?”

– “I came out here to visit you, Jarl! And I find you living in an empty cabin i the middle of nowhere babbling about frogs? You’re hopeless!”

Branch(es): 3.3.5 / master (Tell us which branch(es) this issue affects.)
3.3.5
TC rev. hash/commit:
https://github.com/TrinityCore/TrinityCore/commit/bddf15d6965d7deafed3f0da3efda6b8e41de9e0

Operating system:
win 10

[Kittnz]

an event? oh boy oh boy

[Rushor]

yeah cmangos has some stuff for it, i'm going to convert it. let's see how it looks xd

[Kittnz]

Oh i was about to sniff it on retail

[Rushor]

@Kittnz if you want you could sniff https://youtu.be/5RS_hogcD-w?t=5 https://www.youtube.com/watch?v=c1OESPtnmtU

a script for the goldshirekids would be nice. it's basically only waypoints but in the house there should be some c'thun sounds. couldn't find a sniff for this so far :(

http://wowwiki.wikia.com/wiki/Children_of_Goldshire

[Kittnz]

Iv already been working on that one, and i have sniffed that one but it seems since cata they aren't walking inside the house anymore. they stay outside. But that's a different issue.

[Rushor]

oh damn :( summoning @offl for soundfile research :D

[Kittnz]

Have that already too 👍

[Kittnz]

Apparently on retail you don't see any present (the box). Rest of the event is there with waypoints and such. Just sniffed it, if you want it please poke me on IRC.

[offl]

I found only 8580 and 8585.

A banshee scream.
A ghoul call.
C'Thun saying, "You... Will... Die." - 8585
C'Thun saying, "Death is close." - 8580
Growling.
A woman crying.

[Rushor]

the present is id: 186418

do you know how often the event is repeated @Kittnz ? every 2 minutes or sth. like that?

[Kittnz]

every 5 min

[Rushor]

alright here we go:

-- "Swamp Eye" Jarl - Creepy Event -- https://ironyca.wordpress.com/2010/09/15/the-10-most-creepy-things-in-wow/ 
-- Mordant Grimsby SAI
SET @ENTRY := 23843;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,0,25,0,100,0,0,0,0,0,53,0,23843,1,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Reset - Start Waypoint"),
(@ENTRY,0,1,0,40,0,100,0,1,23843,0,0,54,15000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Waypoint 1 Reached - Pause Waypoint"),
(@ENTRY,0,2,0,40,0,100,0,2,23843,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Waypoint 2 Reached - Remove Npc Flag Questgiver"),
(@ENTRY,0,3,0,40,0,100,0,6,23843,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Waypoint 6 Reached - Run Script"),
(@ENTRY,0,4,0,40,0,100,0,10,23843,0,0,82,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Waypoint 10 Reached - Add Npc Flag Questgiver"),
(@ENTRY,0,5,0,40,0,100,0,11,23843,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Waypoint 11 Reached - Pause Waypoint");

-- Actionlist SAI
SET @ENTRY := 2384300;
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,0,0,0,0,54,54000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Pause Waypoint"),
(@ENTRY,9,1,0,0,0,100,0,3000,3000,0,0,5,381,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Play Emote 381"),
(@ENTRY,9,2,0,0,0,100,0,1000,1000,0,0,50,186418,45,0,0,0,0,8,0,0,0,-2954.89,-3883.94,32.9969,2.60053,"Mordant Grimsby - On Script - Summon Gameobject 'Mordant's Gift'"),
(@ENTRY,9,3,0,0,0,100,0,2000,2000,0,0,5,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Play Emote 0"),
(@ENTRY,9,4,0,0,0,100,0,2000,2000,0,0,1,0,4000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 0"),
(@ENTRY,9,5,0,0,0,100,0,4000,4000,0,0,1,1,5000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 1"),
(@ENTRY,9,6,0,0,0,100,0,5000,5000,0,0,1,2,6000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 2"),
(@ENTRY,9,7,0,0,0,100,0,6000,6000,0,0,1,0,5000,0,0,0,0,19,4792,20,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 0"),
(@ENTRY,9,8,0,0,0,100,0,5000,5000,0,0,1,3,6000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 3"),
(@ENTRY,9,9,0,0,0,100,0,6000,6000,0,0,1,1,5000,0,0,0,0,19,4792,20,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 1"),
(@ENTRY,9,10,0,0,0,100,0,5000,5000,0,0,1,4,8000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 4"),
(@ENTRY,9,11,0,0,0,100,0,8000,8000,0,0,5,381,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Play Emote 381");

DELETE FROM `waypoints` WHERE `entry`=23843;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES 
(23843, 1, -2948.36, -3893.17, 35.0324,  'Mordant Grimsby'),
(23843, 2, -2954, -3888.35, 34.991,      'Mordant Grimsby'),
(23843, 3, -2955.8, -3887.22, 33.729,    'Mordant Grimsby'),
(23843, 4, -2957.36, -3885.06, 33.0995,  'Mordant Grimsby'),
(23843, 5, -2957.23, -3882.92, 32.7325,  'Mordant Grimsby'),
(23843, 6, -2955.98, -3882.95, 32.8433,  'Mordant Grimsby'),
(23843, 7, -2955.55, -3885.08, 33.1672,  'Mordant Grimsby'),
(23843, 8, -2953.84, -3885.88, 33.9242,  'Mordant Grimsby'),
(23843, 9, -2952.99, -3887.91, 35.0223,  'Mordant Grimsby'),
(23843, 10, -2947.74, -3893.74, 35.0308, 'Mordant Grimsby'),
(23843, 11, -2948.36, -3893.17, 35.0324, 'Mordant Grimsby');

-- Texts
DELETE FROM `creature_text` WHERE `entry` IN(23843, 4792);
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES 
-- Mordant Grimsby
(23843, 0, 0, 'I brought you a housewarming gift, Jarl.', 12, 0, 100, 1, 0, 0, 22348, 'Mordant Grimsby'),
(23843, 1, 0, 'Go on, open it. I think you\'ll like it.', 12, 0, 100, 25, 0, 0, 22349, 'Mordant Grimsby'),
(23843, 2, 0, 'Jarl?', 12, 0, 100, 0, 0, 0, 22350, 'Mordant Grimsby'),
(23843, 3, 0, 'Jarl, you haven\'t been yourself ever since I arrived. What\'s going on?', 12, 0, 100, 1, 0, 0, 22352, 'Mordant Grimsby'),
(23843, 4, 0, 'I came out here to visit you, Jarl! And I find you living in an empty cabin in the middle of nowhere, babbling about frogs? You\'re hopeless!', 12, 0, 100, 5, 0, 0, 22354, 'Mordant Grimsby'),
-- "Swamp Eye" Jarl
(4792, 0, 0, 'Unless it\'s something I can eat, I don\'t want it.', 12, 0, 100, 6, 0, 0, 22351, '"Swamp Eye" Jarl'),
(4792, 1, 0, 'Nothing. Wanna help me whip up some frog leg stew?', 12, 0, 100, 1, 0, 0, 22353, '"Swamp Eye" Jarl');

https://youtu.be/Ga3FsyPWeA0

[Kittnz]

You are missing a set orientation, he faces jarl.

FaceDirection: 5.742133

[Killyana]

Which line?

[Kittnz]

between 1 and 2

[Rushor]

done:

-- Actionlist SAI
SET @ENTRY := 2384300;
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,0,0,0,0,54,54000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Pause Waypoint"),
(@ENTRY,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,19,4792,20,0,0,0,0,0,"Mordant Grimsby - On Script - Set Orientation Closest Creature Swamp Eye Jarl"),
(@ENTRY,9,2,0,0,0,100,0,3000,3000,0,0,5,381,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Play Emote 381"),
(@ENTRY,9,3,0,0,0,100,0,1000,1000,0,0,50,186418,45,0,0,0,0,8,0,0,0,-2954.89,-3883.94,32.9969,2.60053,"Mordant Grimsby - On Script - Summon Gameobject Mordant's Gift"),
(@ENTRY,9,4,0,0,0,100,0,2000,2000,0,0,5,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Play Emote 0"),
(@ENTRY,9,5,0,0,0,100,0,2000,2000,0,0,1,0,4000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 0"),
(@ENTRY,9,6,0,0,0,100,0,4000,4000,0,0,1,1,5000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 1"),
(@ENTRY,9,7,0,0,0,100,0,5000,5000,0,0,1,2,6000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 2"),
(@ENTRY,9,8,0,0,0,100,0,6000,6000,0,0,1,0,5000,0,0,0,0,19,4792,20,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 0"),
(@ENTRY,9,9,0,0,0,100,0,5000,5000,0,0,1,3,6000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 3"),
(@ENTRY,9,10,0,0,0,100,0,6000,6000,0,0,1,1,5000,0,0,0,0,19,4792,20,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 1"),
(@ENTRY,9,11,0,0,0,100,0,5000,5000,0,0,1,4,8000,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Say Line 4"),
(@ENTRY,9,12,0,0,0,100,0,8000,8000,0,0,5,381,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mordant Grimsby - On Script - Play Emote 381");

now he faces jarl, does it's loot animation, summons the present and talks line x

[Rushor]

i will be more focused for this orientation stuff in the future. in cmangos creatures actually set their orientation on each waypoint. this cannot be done is sai by default with waypoints because a) there is no column for orienation and b) if there was a column for it, it will not be rgistered like in waypoint_data

[Kittnz]

I know, it's annoying, i had this issue myself 💃