New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[NPC] "Swamp Eye" Jarl - Creepy Event #18583

Closed
Rushor opened this Issue Dec 25, 2016 · 18 comments

Comments

Projects
None yet
6 participants
@Rushor
Contributor

Rushor commented Dec 25, 2016

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!”

GitHub Logo

Branch(es): 3.3.5 / master (Tell us which branch(es) this issue affects.)
3.3.5
TC rev. hash/commit:
bddf15d

Operating system:
win 10

@Kittnz

This comment has been minimized.

Show comment
Hide comment
@Kittnz

Kittnz Dec 25, 2016

Member

an event? oh boy oh boy

Member

Kittnz commented Dec 25, 2016

an event? oh boy oh boy

@Rushor

This comment has been minimized.

Show comment
Hide comment
@Rushor

Rushor Dec 25, 2016

Contributor

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

Contributor

Rushor commented Dec 25, 2016

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

@Kittnz

This comment has been minimized.

Show comment
Hide comment
@Kittnz

Kittnz Dec 25, 2016

Member

Oh i was about to sniff it on retail

Member

Kittnz commented Dec 25, 2016

Oh i was about to sniff it on retail

@Rushor

This comment has been minimized.

Show comment
Hide comment
@Rushor

Rushor Dec 25, 2016

Contributor

@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

Contributor

Rushor commented Dec 25, 2016

@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

This comment has been minimized.

Show comment
Hide comment
@Kittnz

Kittnz Dec 25, 2016

Member

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.

Member

Kittnz commented Dec 25, 2016

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

This comment has been minimized.

Show comment
Hide comment
@Rushor

Rushor Dec 25, 2016

Contributor

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

Contributor

Rushor commented Dec 25, 2016

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

@Kittnz

This comment has been minimized.

Show comment
Hide comment
@Kittnz

Kittnz Dec 25, 2016

Member

Have that already too 👍

Member

Kittnz commented Dec 25, 2016

Have that already too 👍

@Kittnz

This comment has been minimized.

Show comment
Hide comment
@Kittnz

Kittnz Dec 25, 2016

Member

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.

Member

Kittnz commented Dec 25, 2016

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

This comment has been minimized.

Show comment
Hide comment
@offl

offl Dec 25, 2016

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.

offl commented Dec 25, 2016

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

This comment has been minimized.

Show comment
Hide comment
@Rushor

Rushor Dec 25, 2016

Contributor

the present is id: 186418

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

Contributor

Rushor commented Dec 25, 2016

the present is id: 186418

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

@Kittnz

This comment has been minimized.

Show comment
Hide comment
@Kittnz

Kittnz Dec 25, 2016

Member

every 5 min

Member

Kittnz commented Dec 25, 2016

every 5 min

@Rushor

This comment has been minimized.

Show comment
Hide comment
@Rushor

Rushor Dec 25, 2016

Contributor

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');

GitHub Logo

https://youtu.be/Ga3FsyPWeA0

Contributor

Rushor commented Dec 25, 2016

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');

GitHub Logo

https://youtu.be/Ga3FsyPWeA0

Killyana added a commit that referenced this issue Dec 26, 2016

DB/NPC: "Swamp Eye" Jarl
Closes #18583
By Rushor
@Kittnz

This comment has been minimized.

Show comment
Hide comment
@Kittnz

Kittnz Dec 26, 2016

Member

You are missing a set orientation, he faces jarl.

FaceDirection: 5.742133

Member

Kittnz commented Dec 26, 2016

You are missing a set orientation, he faces jarl.

FaceDirection: 5.742133

@Kittnz Kittnz reopened this Dec 26, 2016

@Killyana

This comment has been minimized.

Show comment
Hide comment
@Killyana

Killyana Dec 26, 2016

Member

Which line?

Member

Killyana commented Dec 26, 2016

Which line?

@Kittnz

This comment has been minimized.

Show comment
Hide comment
@Kittnz

Kittnz Dec 26, 2016

Member

between 1 and 2

Member

Kittnz commented Dec 26, 2016

between 1 and 2

@Rushor

This comment has been minimized.

Show comment
Hide comment
@Rushor

Rushor Dec 26, 2016

Contributor

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

Contributor

Rushor commented Dec 26, 2016

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

Killyana added a commit that referenced this issue Dec 26, 2016

@Rushor

This comment has been minimized.

Show comment
Hide comment
@Rushor

Rushor Dec 26, 2016

Contributor

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

Contributor

Rushor commented Dec 26, 2016

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

This comment has been minimized.

Show comment
Hide comment
@Kittnz

Kittnz Dec 26, 2016

Member

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

Member

Kittnz commented Dec 26, 2016

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

Aokromes added a commit to Aokromes/TrinityCore that referenced this issue Dec 28, 2016

Aokromes added a commit to Aokromes/TrinityCore that referenced this issue Dec 28, 2016

Aszune added a commit to Aszune/TrinityCoreRP that referenced this issue Apr 4, 2018

DB/NPC: "Swamp Eye" Jarl
Closes #18583
By Rushor

(cherry picked from commit 1879bbb)

Aszune added a commit to Aszune/TrinityCoreRP that referenced this issue Apr 4, 2018

DB/SAI: Fix an Orientation issue for "Swamp Eye" Jarl
By Rushor
Closes #18583

(cherry picked from commit d78d458)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment