[patch/dev]Spells for quests Drake Hunt [11919,11940]

[virusav]

Patch: http://paste2.org/p/1310538

There are 3 problems:

1. By sniffs must be cast spells 46675, 46678, then 46691 but spell 46691 somehow cancels 46675, so long had to reorder.

2. After complete quest NPC despawn, but his re-spawn visually shows the result of casting spells 46674, ie beam from the NPC to the player. Tried to scroll through the list of spells with dummi-auras and output to a log, but this spell on the list was not. - FIXED

3. Remove from the NPC all the negative effects that, after changing the faction, he again went into battle. - FIXED

Another part of the quest is realized in SD2.

To these quests, finally, earned is necessary to solve these problems.

[virusav]

Queries:

1. For mangos:

DELETE FROM `creature_ai_scripts` WHERE `id` = 2612703;
DELETE FROM `spell_script_target` WHERE `entry` = 46704;
INSERT INTO `spell_script_target` SET `entry` = 46704, `type` = 1, `targetentry` = 26117;
UPDATE `creature` SET `position_x` = 3570.79, `position_y` = 6650.47, `position_z` = 195.181, `orientation` = 0.646218 WHERE `guid` = 118396;

UPDATE `creature_template` SET `scriptname` = 'npc_raelorasz' WHERE `entry` = 26117;
UPDATE `creature_template` SET `scriptname` = 'npc_nexus_drake_hatchling' WHERE `entry` = 26127;

2. For SD2:

INSERT INTO `script_texts` (`entry`, `content_default`, `comment`) VALUES
(-1000015, 'Nexus Drake Hatchling', 'SAY_RAELORASZ_1');
UPDATE `script_texts` SET `content_loc8` = 'Hatchling Dragon Nexus'WHERE `entry` =- 1000015; 

Patch for SD2: http://paste2.org/p/1291180

[virusav]

Correct paragraph 3, and updated the link in first post.

[virusav]

Corrected paragraph 2, changed the code a bit and link to the first post.

It is strange that

m_target->SetChannelObjectGuid(ObjectGuid());
m_target->SetUInt32Value(UNIT_CHANNEL_SPELL,0);

not satisfied when you remove the aura.

Another interesting point: when you remove the aura 46675 timer in a row ((Creature*)m_target)->ForcedDespawn(100); is the death of NPC, and not despawn.