Skip to content
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

[Bug]The Lord of Blackrock(Horde) event missing #12255

Closed
Crysicle opened this Issue Jun 10, 2014 · 9 comments

Comments

Projects
None yet
7 participants
@Crysicle
Copy link

Crysicle commented Jun 10, 2014

Bug:
After "The Lord of Blackrock" is finished an event should start.

  1. "Overlord Runthak" will yell(zone wide):
    a) "NEFARIAN IS SLAIN! People of Orgrimmar, bow down before the might of [Player Name] and his allies for they have laid a blow against the Black Dragonflight that is sure to stir the Aspects from their malaise! This defeat shall surely be felt by the father of the Black Flight: Deathwing reels in pain and anguish this day!"
    b) "Be lifted by [Player Name]'s accomplishment! Revel in his rallying cry!"
  2. "Overlord Runthak" will impale Nefarian's head on a spike.
  3. "Rallying Cry of the Dragonslayer" will be cast.

Unknown in which order.

Links:
The Lord of Blackrock - http://www.wowhead.com/quest=7784#comments
Rallying Cry of the Dragonslayer - http://www.wowhead.com/spell=22888#comments
Video of the event - https://www.youtube.com/watch?v=szm0tKJIzqg

Core revision: ea279da
Database version: TDB 335.53
Addons: Anticheat1

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

@Crysicle Crysicle changed the title [Bug]The Lord of Blackrock event missing [Bug]The Lord of Blackrock(horde) event missing Jun 10, 2014

@Crysicle Crysicle changed the title [Bug]The Lord of Blackrock(horde) event missing [Bug]The Lord of Blackrock(Horde) event missing Jun 10, 2014

@Rushor

This comment has been minimized.

Copy link
Contributor

Rushor commented Jun 10, 2014

i think it will be hard to get datas for such an old quest (sadly) :/

@Aokromes Aokromes added this to the 3.3.5a cosmetic milestone Aug 28, 2014

@Rushor

This comment has been minimized.

Copy link
Contributor

Rushor commented Feb 15, 2015

shure that this quest was still available and completable at 3.3.5?

@Crysicle

This comment has been minimized.

Copy link
Author

Crysicle commented Feb 15, 2015

Yes, the quest even exists in cata and mop based on wowhead comments.

http://www.wowhead.com/quest=7784/the-lord-of-blackrock#comments
By Skeksil (10,626 – 3·20·68) on 2010/10/20 (Patch 4.0.1)
If you have the head already, this quest DOES still exist in Cataclysm, at least in beta. The original turn-in is with Garrosh, not Thrall.

http://www.wowhead.com/npc=14392/overlord-natoj#comments
By arkensis (9,360 – 1·7·46) on 2014/01/21 (Patch 5.4.2)
Since he's sided with Garrosh in the Siege of Orgimmar, we'll likely see a new NPC for turning in Nefarian's head in the next expansion.

@DDuarte DDuarte modified the milestone: Cosmetic Mar 22, 2016

@offl

This comment has been minimized.

Copy link

offl commented Dec 26, 2016

In case someone wants to convert this to SAI.

@Rushor

This comment has been minimized.

Copy link
Contributor

Rushor commented Dec 26, 2016

triggered <3

@Aokromes

This comment has been minimized.

Copy link
Member

Aokromes commented Dec 26, 2016

use details thing xd

@offl

This comment has been minimized.

Copy link

offl commented Dec 26, 2016

Yep, I saw it. But the fix from CMaNGOS looks better. That's the reason why I added only the link to CMaNGOS fix.

@Rushor

This comment has been minimized.

Copy link
Contributor

Rushor commented Dec 26, 2016

updated fix

-- Overlord Runthak SAI
SET @ENTRY := 14392;
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,1,20,0,100,0,7784,0,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Overlord Runthak - On Quest 'The Lord of Blackrock' Finished - Run Script"),
(@ENTRY,0,1,0,61,0,100,0,7784,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Overlord Runthak - On Quest 'The Lord of Blackrock' Finished - Store Targetlist");

-- Actionlist SAI
SET @ENTRY := 1439200;
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,1000,1000,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Overlord Runthak - On Script - Remove Npc Flag Questgiver"),
(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Overlord Runthak - On Script - Set Run Off"),
(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,69,0,0,0,0,0,0,8,0,0,0,1544,-4425.87,10.9056,3.323,"Overlord Runthak - On Script - Move To Position"),
(@ENTRY,9,3,0,0,0,100,0,14000,14000,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0.6367,"Overlord Runthak - On Script - Set Orientation 0,6367"),
(@ENTRY,9,4,0,0,0,100,0,3000,3000,0,0,1,0,17000,0,0,0,0,12,1,0,0,0,0,0,0,"Overlord Runthak - On Script - Say Line 0"),
(@ENTRY,9,5,0,0,0,100,0,17000,17000,0,0,1,1,10000,0,0,0,0,12,1,0,0,0,0,0,0,"Overlord Runthak - On Script - Say Line 1"),
(@ENTRY,9,6,0,0,0,100,0,3000,3000,0,0,50,179881,21600,0,0,0,0,8,0,0,0,1540.28,-4422.19,7.0051,5.22833,"Overlord Runthak - On Script - Summon Gameobject 'The Severed Head of Nefarian'"),
(@ENTRY,9,7,0,0,0,100,0,5000,5000,0,0,9,0,0,0,0,0,0,20,179881,100,0,0,0,0,0,"Overlord Runthak - On Script - Activate Gameobject"),
(@ENTRY,9,8,0,0,0,100,0,5000,5000,0,0,11,22888,0,0,0,0,0,1,0,0,0,0,0,0,0,"Overlord Runthak - On Script - Cast 'Rallying Cry of the Dragonslayer'"),
(@ENTRY,9,9,0,0,0,100,0,10000,10000,0,0,69,0,0,0,0,0,0,8,0,0,0,1568,-4405.87,8.13371,0.3434,"Overlord Runthak - On Script - Move To Position"),
(@ENTRY,9,10,0,0,0,100,0,15000,15000,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,3.31613,"Overlord Runthak - On Script - Set Orientation 3,31613"),
(@ENTRY,9,11,0,0,0,100,0,1000,1000,0,0,82,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Overlord Runthak - On Script - Add Npc Flag Questgiver");

DELETE FROM `creature_text` WHERE `entry` IN (14392);
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextId`) VALUES 
(14392, 0, 0, 'NEFARIAN IS SLAIN! people of Orgrimmar, bow down before the might of $N and his allies for they have laid a blow against the Black Dragonflight that is sure to stir the Aspects from their malaise! This defeat shall surely be felt by the father of the Black Flight: Deathwing reels in pain and anguish this day!', 14, 0, 100, 0, 0, 0, 'Overlord Runthak', 9867),
(14392, 1, 0, 'Be lifted by $N accomplishment! Revel in his rallying cry!', 14, 0, 100, 0, 0, 0, 'Overlord Runthak', 9868);

GitHub Logo
https://youtu.be/VfkwV2dgjjY

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

@Rushor

This comment has been minimized.

Copy link
Contributor

Rushor commented Dec 27, 2016

tc bot failed to close?

@Killyana Killyana closed this Dec 27, 2016

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

joschiwald added a commit that referenced this issue Apr 21, 2018

DB/Quest: The Lord of Blackrock
Closes #12256
By Rushor
(cherry picked from commit 8d91cf1)

DB/Quest: The Lord of Blackrock (Horde)

Closes #12255
By Rushor
(cherry picked from commit 85898b4)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.