[QUEST] Neutralizing the Plague #10025

KronemeyerJoshua · 2013-06-13T18:59:27Z

http://www.wowhead.com/quest=13297
http://www.wowhead.com/quest=13281

Not working. Upon using Pustulant Spinal Fluid(44010), it says requires Mord'rethar Plague Cauldron.

If you place game objected 300239 (TEMP Mord'rethar Plague Cauldron) next to the cauldron, you will be able to use the item, but gives no credit.

The quest calls for the bunny to be there. The ID of the bunny is 31767, which also has the quest plate attached to it. Plague Cauldron Neutralized: 0/1
With just the bunny spawned, you can not use the quest item.

Pustulant Spinal Fluid(44010) uses spell 59655, at the end of the spell it is supposed to cast spell 59659 to give the player credit for doing the quest.
f8d9a8d 2013-06-08

The text was updated successfully, but these errors were encountered:

dr-j · 2013-06-13T20:35:54Z

    UPDATE `gameobject_template` SET `data1`=30 WHERE  `entry`=300239;
    UPDATE `creature_template` SET `flags_extra`=128 WHERE  `entry`=31767;

    DELETE FROM `creature` WHERE `guid`=0 AND `id`=31767;
    INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
    (0, 31767, 571, 1, 1, 0, 0, 6753.08, 1583.76, 396.051, 0.268601, 300, 0, 0, 42, 0, 0, 0, 0, 0);

    DELETE FROM `disables` WHERE `sourceType`=0 AND `entry`=59655;

    INSERT INTO `disables` (`sourceType`, `entry`, `flags`, `params_0`, `params_1`, `comment`) VALUES
    (0, 59655, 64, '', '', 'Ignore LOS on Neutralize Plague');

    DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=59655;
    INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
    (13, 1, 59655, 0, 1, 31, 0, 3, 31767, 0, 0, 0, 0, '', 'Neutralize Plague hits Plague Cauldron KC Bunny');

    UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE  `entry`=31767;

    DELETE FROM `smart_scripts` WHERE `entryorguid` =31767;

    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
    (31767, 0, 0, 0, 8,  0, 100, 0, 59659, 0, 0, 0, 33, 31767, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Plague Cauldron KC Bunny - On Spellhit Neutralizing Dose Applied - Kill  Credit');

filipboev · 2013-06-13T22:01:13Z

Dr-j, if that's taken from BC database, it's still not complete. I remember sniffing this and adding it to Bc's db; it shouldn't only give quest credit on spellhit, there should be more events. I'll look into it.

dr-j · 2013-06-13T22:12:01Z

No I writ that but may not be complete either.

Vincent-Michael · 2013-06-15T23:27:22Z

1.your credit is hack, we have spell credit: ID - 59876 Kill Credit
2.use magic number for guid
3.your conditions is wrong, that hit:

ServerToClient: SMSG_SPELL_GO (0x0132) Length: 41 Time: 09/14/2010 12:32:20.000 Number: 176640
Caster GUID: Full: xxxx Type: Item Low: xxxx
Caster Unit GUID: Full: xxxxType: Player Low: xxxx
Cast Count: 102
Spell ID: 59655
Cast Flags: Unknown3, Unknown4, Unknown7, Unknown16 (262424)
Time: 272349562
Hit Count: 1
[0] Hit GUID: Full: 0xF130007EBA2DD059 Type: Unit Entry: 32442 Low: 3002457
Miss Count: 0
Target Flags: Unit (2)
Target GUID: 0x0

SQL:

SET @CGUID:= xxxxxx;

DELETE FROM `creature` WHERE `id` IN (32442,32445);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(@CGUID, 31773, 571, 1, 1, 6776.598, 1628.575, 390.9221, 4.729842, 120, 0, 0), -- Plague Cauldron Target (Area: Mord'rethar: The Death Gate)
(@CGUID+1, 32442, 571, 1, 1, 6777.509, 1539.352, 390.8735, 1.623156, 120, 0, 0); -- Plague Cauldron Target 02 (Area: Mord'rethar: The Death Gate)

UPDATE `creature_template` SET `speed_walk`=1.142857, `speed_run`=1 WHERE `entry` IN (32442,32445);

DELETE FROM `creature_template_addon` WHERE `entry` IN (32442,32445);
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
(32442, 0, 0x0, 0x1, ''),
(32445, 0, 0x0, 0x1, '');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=59655;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
 (13, 1, 59655, 0, 1, 31, 0, 3, 32442, 0, 0, 0, 0, '', 'Neutralize Plague - Plague Cauldron Target 02');

DELETE FROM `creature_text` WHERE `entry` IN (32442,32445);
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
(32442, 0, 0, 'The plague cauldron begins to boil vigorously!', 41, 0, 100, 0, 0, 0, 'Plague Cauldron Target 02'),
(32445, 0, 0, 'Something emerges from the cauldron!', 41, 0, 100, 0, 0, 0, 'Summoned Plague Cauldron Bunny 02'),

for more info need you sniff ...

filipboev · 2013-06-16T11:26:24Z

I need to find data I've sniffed for this. There should be a RANDOM_TIMED_ACTIONLIST for more events after the item spell has been used. You either get credit or you get a swarm of ghouls + oozes that spawn from the cauldron.
I'll work on it once my schedule is cleared.

dr-j · 2013-06-16T16:11:26Z

Well as I previously said may not have been complete, and I knew about guids think rushed when posted this as was doing something else at same time d:

filipboev · 2013-06-19T22:56:24Z

This was a bitch to sniff, so many random event scripts...

SET @CGUID          := 15;
SET @GOGUID         := 5196; -- Set by TDB, these are free guids.
SET @KC_TARGET      := 31773;
SET @KC_TARGET2     := 32442;
SET @PC_BUNNY       := 32445;
SET @SUMM_PC_BUNNY  := 61026;
SET @GREEN_SPLASH   := 60059;
SET @SPELL          := 59655;
SET @SPELL_DOSE     := 59659;
SET @GHOUL          := 32178;
SET @LIVING_PLAGUE  := 32181;
SET @SUMMON_LPLAGUE := 60058;
SET @SUMMON_GHOUL   := 60056;
SET @RADIATION_AURA := 45797;
SET @KILL_CREDIT    := 31767;

UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80, `faction_A`=21, `faction_H`=21, `speed_walk`=1.142857, `speed_run`=1, `mindmg`=286, `maxdmg`=322, `rangeattacktime`=2000, `unit_flags`=32768, `dynamicflags`=0, `Health_mod`=3 WHERE `entry`=32181; -- Living Plague
UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80, `faction_A`=21, `faction_H`=21, `speed_walk`=1.428571, `speed_run`=4, `mindmg`=98, `maxdmg`=134, `rangeattacktime`=2000, `unit_flags`=32768, `dynamicflags`=0, `Health_mod`=4 WHERE `entry`=32178; -- Rampaging Ghoul
UPDATE `creature_template` SET `speed_walk`=1.142857, `speed_run`=1, `rangeattacktime`=2000, `dynamicflags`=0 WHERE `entry`=32442; -- Plague Cauldron Target 02
UPDATE `creature_template` SET `speed_walk`=1.142857, `speed_run`=1, `rangeattacktime`=2000, `dynamicflags`=0 WHERE `entry`=31773; -- Plague Cauldron Target
UPDATE `creature_template` SET `modelid1`=21342, `modelid2`=0, `flags_extra`= 128 WHERE  `entry`=@PC_BUNNY;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@KC_TARGET,@KC_TARGET2,@PC_BUNNY,@LIVING_PLAGUE,@GHOUL);
UPDATE `gameobject_template` SET `data1`=30 WHERE `entry`=300239;

DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (@LIVING_PLAGUE,@GHOUL);
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 
(@GHOUL, 0, 0, 0, 0, 0, 100,0, 5000, 17000, 29000, 42000, 11, 54475, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Rampaging Ghoul - In Combat - Cast Rampage'),
(@GHOUL, 0, 1, 0, 0, 0, 100,0, 2000, 14000, 25000, 34000, 11, 6016, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Rampaging Ghoul - In Combat - Cast Pierce Armor'),
(@GHOUL, 0, 2, 3, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rampaging Ghoul - Just Summoned - Set React State Aggresive'),
(@GHOUL, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 46, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rampaging Ghoul - On Link - Move Forward'),
(@GHOUL, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Rampaging Ghoul - On Link - Attack Hostile Random'),
-- Living Plague AI
(@LIVING_PLAGUE, 0, 1, 2, 54, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Living Plague - Just Summoned - Set React State Aggresive'),
(@LIVING_PLAGUE, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 46, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Living Plague - On Link - Move Forward'),
(@LIVING_PLAGUE, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Living Plague - On Link - Attack Hostile Random');

DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@KC_TARGET;
DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN (@KC_TARGET*100);
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 
(@KC_TARGET, 0, 0, 1, 8, 0, 100, 0, @SPELL_DOSE, 0, 0, 0, 80, @KC_TARGET*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'KC Bunny - On spell hit - Trigger script'),
(@KC_TARGET, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'KC Target - On Link - Say Text 0'),
(@KC_TARGET, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, @RADIATION_AURA, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'KC Target - On Link - Aura Radiation'),
(@KC_TARGET, 0, 3, 0, 38, 0, 100, 0, 1, 2, 0, 0, 28, @RADIATION_AURA, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'KC Target - On Data Set - Remove Aura'),
(@KC_TARGET*100, 9, 0, 0, 0, 0, 100, 0, 4000, 4000, 4000, 4000, 11, @SUMM_PC_BUNNY, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'KC Target  - Script - Summon Bunny');

DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@KC_TARGET2;
DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN (@KC_TARGET2*100);
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 
(@KC_TARGET2, 0, 0, 1, 8, 0, 100, 0, @SPELL_DOSE, 0, 0, 0, 80, @KC_TARGET*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'KC Bunny - On spell hit - Trigger script'),
(@KC_TARGET2, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'KC Target - On Link - Say Text 0'),
(@KC_TARGET2, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, @RADIATION_AURA, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'KC Target - On Link - Aura Radiation'),
(@KC_TARGET2, 0, 3, 0, 38, 0, 100, 0, 1, 1, 0, 0, 28, @RADIATION_AURA, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'KC Target - On Data Set - Remove Aura'),
(@KC_TARGET2*100, 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 11, @SUMM_PC_BUNNY, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'KC Target - Script - Summon Bunny');


DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@PC_BUNNY;
DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN (@PC_BUNNY*100,@PC_BUNNY*100+1,@PC_BUNNY*100+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 
(@PC_BUNNY, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 87, @PC_BUNNY*100, @PC_BUNNY*100+1, @PC_BUNNY*100+2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'PC Bunny - Just Summoned - Trigger script'),
(@PC_BUNNY, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'PC Bunny - On Link - Say Text 0'),
(@PC_BUNNY, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, @GREEN_SPLASH, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'PC Bunny - On Link - Cast cosmetic Green Splash'),
-- First Action Event
(@PC_BUNNY*100, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 11, @SUMMON_GHOUL, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Ghoul'),
(@PC_BUNNY*100, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 11, @SUMMON_LPLAGUE, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Living Plague'),
(@PC_BUNNY*100, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 11, @SUMMON_LPLAGUE, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Living Plague'),
(@PC_BUNNY*100, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, @KC_TARGET2, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Set Data 1 1'),
(@PC_BUNNY*100, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 2, 0, 0, 0, 0, 19, @KC_TARGET, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Set Data 1 2'),
(@PC_BUNNY*100, 9, 6, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Despawn'),
-- Third Action Event
(@PC_BUNNY*100+2, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 11, @SUMMON_LPLAGUE, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Living Plague'),
(@PC_BUNNY*100+2, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 11, @SUMMON_LPLAGUE, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Living Plague'),
(@PC_BUNNY*100+2, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 11, @SUMMON_LPLAGUE, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Living Plague'),
(@PC_BUNNY*100+2, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 11, @SUMMON_LPLAGUE, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Living Plague'),
(@PC_BUNNY*100+2, 9, 5, 0, 0, 0, 100, 1, 10500, 10500, 10500, 10500, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny - On Script - Say 1'),
(@PC_BUNNY*100+2, 9, 6, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 11, @SUMMON_GHOUL, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Ghoul'),
(@PC_BUNNY*100+2, 9, 7, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 11, @SUMMON_LPLAGUE, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Living Plague'),
(@PC_BUNNY*100+2, 9, 8, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 11, @SUMMON_LPLAGUE, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Summon Living Plague'),
(@PC_BUNNY*100+2, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, @KC_TARGET2, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Set Data 1 1'),
(@PC_BUNNY*100+2, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 2, 0, 0, 0, 0, 19, @KC_TARGET, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Set Data 1 2'),
(@PC_BUNNY*100+2, 9, 11, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Despawn'),
-- Second Action Event
(@PC_BUNNY*100+1, 9, 0, 0, 0, 0, 100, 0, 7000, 7000, 7000, 7000, 33, @KILL_CREDIT, 0, 0, 0, 0, 0, 21, 50, 0, 0, 0, 0, 0, 0, 'KC Target - On spellhit - Give quest credit'),
(@PC_BUNNY*100+1, 9, 1, 0, 0, 0, 100, 0, 1500, 1500, 1500, 1500, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Say 1'),
(@PC_BUNNY*100+1, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, @KC_TARGET2, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Set Data 1 1'),
(@PC_BUNNY*100+1, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 2, 0, 0, 0, 0, 19, @KC_TARGET, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Set Data 1 2'),
(@PC_BUNNY*100+1, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 1000, 1000, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'PC Bunny  - On Script - Despawn');


DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=59655;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(13, 1, 59655, 0, 1, 31, 0, 3, 31773, 0, 0, 0, 0, '', 'Neutralize Plague hits Plague Cauldron Target Bunny'),
(13, 1, 59655, 0, 0, 31, 0, 3, 32442, 0, 0, 0, 0, '', 'Neutralize Plague hits Plague Cauldron Target Bunny');

DELETE FROM `creature` WHERE `id` IN (31773,32442);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(@CGUID, 31773, 571, 1, 1, 6776.598, 1628.575, 392.1221, 4.729842, 120, 0, 0),   -- Plague Cauldron Target (Area: Mord'rethar: The Death Gate)
(@CGUID+1, 32442, 571, 1, 1, 6777.509, 1539.352, 392.1735, 1.623156, 120, 0, 0); -- Plague Cauldron Target 02 (Area: Mord'rethar: The Death Gate)

DELETE FROM `gameobject` WHERE `id` IN (300239);
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES 
(@GOGUID, 300239, 571, 1, 1, 6776.6, 1628.57, 390.922, 5.39315, 0, 0, 0.430474, -0.902603, 300, 0, 1),
(@GOGUID+1, 300239, 571, 1, 1, 6777.51, 1539.35, 390.874, 1.62316, 0, 0, 0.725376, 0.688353, 300, 0, 1);


DELETE FROM `creature_template_addon` WHERE `entry` IN (31150,32442,@LIVING_PLAGUE,@GHOUL);
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
(31150, 0, 0x0, 0x1, '50106'), -- 
(32442, 0, 0x0, 0x1, ''),
(32181, 0, 0x0, 0x1, '61587'), -- Living Plague - Living Plague
(32178, 0, 0x0, 0x1, '58812'); -- Rampaging Ghoul - Ghoul Aura

DELETE FROM `creature_text` WHERE `entry` IN (@KC_TARGET,@KC_TARGET2,@PC_BUNNY);
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
(@PC_BUNNY, 0, 0, 'Something emerges from the cauldron!', 41, 0, 100, 0, 0, 0, 'Player Bunny'),
(@PC_BUNNY, 1, 0, 'The cauldron continues to boil...', 41, 0, 100, 0, 0, 0, 'Player Bunny'),
(@PC_BUNNY, 2, 0, 'Plague batch neutralized!', 41, 0, 100, 0, 0, 0, 'Player Bunny'),
(@KC_TARGET, 0, 0, 'The plague cauldron begins to boil vigorously!', 41, 0, 100, 0, 0, 0, 'Plague Cauldron Target'),
(@KC_TARGET2, 0, 0, 'The plague cauldron begins to boil vigorously!', 41, 0, 100, 0, 0, 0, 'Plague Cauldron Target 02');

KronemeyerJoshua · 2013-06-19T23:50:39Z

You sir, are a god.
Will test this in a bit.

UPDATE: Nevermind, just had to change the GUID. Works great!

Subv · 2013-06-20T02:02:59Z

@KirkHammett Screw that, http://xkcd.com/221/

filipboev · 2013-06-20T08:45:37Z

Now why didn't I think of that!?

Pitcrawler · 2013-06-20T09:13:50Z

You have a random timed action list in the first KC_TARGET SAI. That's probably some kind of leftover, I guess...

Other than that, great work!

filipboev · 2013-06-20T09:44:09Z

Nah, I removed that thing this morning. It should show as 80 now, not 87.

filipboev · 2013-06-23T17:57:02Z

Well, if no one wishes to share their "test" results, can we go ahead and push this?

nelegalno · 2013-10-07T09:08:58Z

Fix works for the 2 small cauldron's but not for the big one in the middle.
Also fixes Basic Chemistry (13295, 13279)

filipboev · 2013-10-07T09:12:17Z

Large cauldron doesn't need to work. Sniff indicates that there isn't any bunny npc to handle a script there, only the one on the left and the right.

nelegalno · 2013-10-07T13:19:59Z

You might be right - Carbonite and QuestHelper point to the big cauldron between the 2 small ones for Basic Chemistry and to the small ones for Neutralizing the Plague, I can't find a video of the quest and this guide stated that all 3 should work: http://worldofguidecraft.com/2011/07/28/quest-basic-chemistry/

P.S. I don't see anything about the Flesh Giant Spine (44009) or the Pustulent Horror (31139) needed for the creation of Pustulant Spinal Fluid (44010) for Neutralizing the Plague Daily in this fix (it's provided for the Basic Chemistry quest).

filipboev · 2013-10-07T16:24:47Z

Those things already worked before, this script covered what didn't work. And as for the middle cauldron, if it needed to work it would return some data on the sniff about a bunny being in that location, and/or doing something. Sniffing that data wouldn't just block out that cauldron and show the other two. In short, if there isn't any info for it, it's probably just cosmetic.

Closes TrinityCore#10025

ghost · 2015-01-10T10:33:04Z

@KirkHammett Again bugged, all works good, but credit is not get. When i try .cast 59659 nothing is done.

jobbais · 2015-02-12T21:34:27Z

Problem: U can use Pustulant Spinal Fluid on a cauldron and after 2 or 3 uses u get message cauldron Neutralized, but no credit for quest.
How it should work: U shouldget credit for neutralizing cauldron
Other relevant information: As i did read about this quest, it cannot be done solo, at least on retal, because cauldron needs Pustulant Spinal Fluid more often than just once every 90 seconds, before u can neutralize it, but here seems to work solo, looks likethere is no internal timer on cauldron. Also tried it with another person, not working

P.S. The same goes for quest called Neutralizing the Plague, (since they are practically the same quest),no credit for cauldron neutralized

ghost assigned malcrom Jun 13, 2013

ZxBiohazardZx closed this as completed in 8ead61c Jun 24, 2013

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

DB/SAI: add SAI support for Neutralizing the Plague

ca7d937

Closes TrinityCore#10025

KronemeyerJoshua unassigned malcrom Jan 10, 2015

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[QUEST] Neutralizing the Plague #10025

[QUEST] Neutralizing the Plague #10025

KronemeyerJoshua commented Jun 13, 2013

dr-j commented Jun 13, 2013

filipboev commented Jun 13, 2013

dr-j commented Jun 13, 2013

Vincent-Michael commented Jun 15, 2013

filipboev commented Jun 16, 2013

dr-j commented Jun 16, 2013

filipboev commented Jun 19, 2013

KronemeyerJoshua commented Jun 19, 2013

Subv commented Jun 20, 2013

filipboev commented Jun 20, 2013

Pitcrawler commented Jun 20, 2013

filipboev commented Jun 20, 2013

filipboev commented Jun 23, 2013

nelegalno commented Oct 7, 2013

filipboev commented Oct 7, 2013

nelegalno commented Oct 7, 2013

filipboev commented Oct 7, 2013

ghost commented Jan 10, 2015

jobbais commented Feb 12, 2015

[QUEST] Neutralizing the Plague #10025

[QUEST] Neutralizing the Plague #10025

Comments

KronemeyerJoshua commented Jun 13, 2013

dr-j commented Jun 13, 2013

filipboev commented Jun 13, 2013

dr-j commented Jun 13, 2013

Vincent-Michael commented Jun 15, 2013

filipboev commented Jun 16, 2013

dr-j commented Jun 16, 2013

filipboev commented Jun 19, 2013

KronemeyerJoshua commented Jun 19, 2013

Subv commented Jun 20, 2013

filipboev commented Jun 20, 2013

Pitcrawler commented Jun 20, 2013

filipboev commented Jun 20, 2013

filipboev commented Jun 23, 2013

nelegalno commented Oct 7, 2013

filipboev commented Oct 7, 2013

nelegalno commented Oct 7, 2013

filipboev commented Oct 7, 2013

ghost commented Jan 10, 2015

jobbais commented Feb 12, 2015