[patch] Spell 50574

[NeatElves]

Его нет в дбц, но он аналог следующих:
http://www.wowhead.com/spell=50634
http://www.wowhead.com/spell=51233
http://www.wowhead.com/spell=51232
вот как вариант:

DELETE FROM spell_template WHERE id = 50574;
INSERT INTO `spell_template` (`id`, `attr`, `attr_ex`, `attr_ex2`, `proc_flags`, `proc_chance`, `duration_index`, `effect0`, `effect0_implicit_target_a`, `effect0_implicit_target_b`, `effect0_radius_idx`, `effect0_apply_aura_name`, `effect0_misc_value`, `effect0_misc_value_b`, `effect0_trigger_spell`, `comments`) VALUES
(50574, 0x00000100, 0x00000000, 0x00000000, 0x00000000, 101, 0, 90, 25, 0, 11, 0, 28042, 0, 0, 'Captain Brandon Kill Credit');

Для квестов, у которых "исправили" шаблон на лог загрузки.))

UPDATE `quest_template` SET `RewSpellCast` = '50574' WHERE `entry` in (12588,12597,12502,12564);

[schmoozerd]

Hmm, do you have any source that a spell 50574 is used for the quest-credit?
Afaik the both related quests (12596, 12587) have simple quest-credit requirements.

We can give these directly via gosisp, quest_accept, quest_complete or whatever we require.

[NeatElves]

Spell completing another quest, WDB:

('enGB', 12564, 1057, 12564, 2, 76, 74, 66, 0, 0, 0, 0, 0, 0, 0, 2, 15800, 31800, 0, 50574, 0, 0, 0, 4232, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1106, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Troll Patrol: Something for the Pain', 'Captain Brandon at Drak\'Sotra wants you to collect 5 Mature Water-Poppies from Drak\'Sotra Fields.', 'Gritty as my men are, they\'re still mortal.$b$bWounds and pain diminish their ability to perform their missions. No amount of training changes that simple fact of life.$b$bThankfully, one of our alchemists has developed a recipe for a salve that binds to our bandages and greatly reduces the pain our soldiers experience.$b$bThe salve requires a special poppy these trolls cultivate just west of here. Go to Drak\'Sotra Fields and harvest some of them to keep our stockpiles from running out.', '', 'Return to Captain Brandon at Drak\'Sotra in Zul\'Drak.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38552, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '')

Analog:

('enGB', 12568, 889, 12568, 2, 76, 74, 66, 0, 0, 0, 0, 0, 0, 0, 2, 15800, 31800, 0, 50634, 0, 0, 38556, 4224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1106, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Troll Patrol: Done to Death', 'Captain Rupert wants you to use the Incinerating Oil on 5 Defeated Argent Footmen in Drak\'Sotra.', 'Trust me, $r. I know....$b$bThe smell of burnt flesh has become sickening to even me, a Forsaken. Nevertheless, it is our solemn duty to ensure that our brethren never walk with the Scourge.$b$bPour this oil on the corpses of our fallen to ensure that we never face them on the battlefield as enemies.', '', 'Return to Captain Rupert at Drak\'Sotra in Zul\'Drak.', 28316, 5, 38556, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Argent Footman Corpse Incinerated', '', '', '')
('enGB', 12585, 979, 12585, 2, 76, 74, 66, 0, 0, 0, 0, 0, 0, 0, 2, 15800, 31800, 0, 51233, 0, 0, 0, 4224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1106, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Troll Patrol: Creature Comforts', 'Captain Grondel at Drak\'Agal wants you to bring him 20 pieces of Dead Thornwood.', 'Well, it ain\'t glamorous, but it needs doin\'.$b$bMy troops have been fightin\' their hearts out while knee-deep in stagnant water for days on end. That just can\'t be good fer ya.$b$bWhat they need is a nice fire to dry \'em out and lighten their spirits.$b$bThis part of the city\'s soaked, but the dead roots of these thornwood trees have a way of resistin\' the moisture.$b$bRound us up some fuel for burnin\' and we\'ll be mighty grateful.', '', 'Return to Captain Grondel at Drak\'Agal in Zul\'Drak.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38563, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '')
('enGB', 12601, 1142, 12601, 2, 76, 74, 66, 0, 0, 0, 0, 0, 0, 0, 2, 15800, 31800, 0, 51232, 0, 0, 0, 4232, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1106, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Alchemist\'s Apprentice', 'Alchemist Finklestein at Heb\'valok wants you to assist him in the creation of a truth serum.$b$bWhen you are ready to begin, you are to speak to him and follow his instructions.', 'Ahh, you must be the promised patrol. Your timing couldn\'t be better. I have urgent need of an extra pair of hands.$b$bWe have a Drakkari prisoner who\'s been sent here to undergo questioning. Before the interrogation begins, I require assistance in the creation of a truth serum.$b$bCreating a truth serum is tricky business, demanding keen instincts, perfect timing, and improvisation at every step.$b$bLet me know when you\'re ready, $r. And remember, timing is everything!', '', 'Return to Alchemist Finklestein at Reliquary of Pain in Zul\'Drak.', 28248, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Truth Serum Created', '', '', '')

example
The player takes http://www.wowhead.com/quest=12587, goes to the NPC http://www.wowhead.com/npc=28044, it performs a random assignment(http://www.wowhead.com/quest=12568, http://www.wowhead.com/quest=12509, http://www.wowhead.com/quest=12591) and the player cast killkredit http://www.wowhead.com/spell=50634.))

And we need the following
The player takes http://www.wowhead.com/quest=12587, goes to the NPC http://www.wowhead.com/npc=28042, it performs a random assignment(http://www.wowhead.com/quest=12588, http://www.wowhead.com/quest=12502, http://www.wowhead.com/quest=12564) and the player cast killkredit http://www.wowhead.com/spell=50574(not in DBC).))

[schmoozerd]

In [12465]. Thank you