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

Already on GitHub? Sign in to your account

[SAI | NPC 9026] Overmaster Pyron #9267

Closed
alpharius opened this Issue Feb 21, 2013 · 2 comments

Comments

Projects
None yet
2 participants

Core 5143804
DB TDB 335.51
no modifications

Overmaster Pyron should comment on his death.
see http://www.youtube.com/watch?v=ZimyK3klEAI#t=0m50s

This should work:

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 
(9026, 0, 2, 0, 6, 0, 100, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Overmaster Pyron - On Death - Say Line 0");

INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
(9026, 0, 0, "I will be reborn, mortals! Incendius shall raise me from these ashes!",12,0,100,0,0,0,"Overmaster Pyron");

post scriptum:
There is a cornish rex cat in dun morogh, creature.guid = 1528 creature_template.id = 7384, I think it's wrongly placed - nothing serious, just cosmetic.

Contributor

ZxBiohazardZx commented Feb 25, 2013

always add a delete before insert

DELETE FROM `smart_scripts` WHERE `entryorguid`=9026 AND `source_type`=0 AND `id`=2;
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 
(9026,0,2,0,6,0,100,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0, "Overmaster Pyron - On Death - Say Line 0");

DELETE FROM `creature_text` WHERE `entry`=9026 AND `groupid`=0;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
(9026,0,0, "I will be reborn, mortals! Incendius shall raise me from these ashes!",12,0,100,0,0,0,"Overmaster Pyron");

@ghost ghost assigned ZxBiohazardZx Mar 3, 2013

Okay, I will keep that in mind, next time. :-)

raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment