Next quest in the line.
There is one issue about the spell http://www.wowhead.c…soul-font-void. When I made the fix everything worked well. I added the spell via creature_template_addon to the void zone npc which is of faction 2141 (friendly to players and hostile to monsters). So whenever a worshipper or berserker came near the soul font it got applied the debuff of the spell. Some days later I updated my core and the debuff wasn’t applied anymore. Seems there has been an update that broke this…
The working revision was of September, 12. After September, 28 it was broken. Maybe there was a fix for this recently. I didn’t have much time to check that or even update my core…
-- QUEST 12668 "Foundation for Revenge"
SET @GUID := XXX; -- need 47
SET @GUID_GO := YYY; -- need 13
SET @ENTRY_KC := 28713;
SET @ENTRY_VOID_ZONE := 28719;
SET @ENTRY_SOUL_FONT_BUNNY := 28724;
SET @ENTRY_WORSHIPPER := 28747;
SET @ENTRY_BERSERKER := 28748;
SET @SPELL_FONT_VOID := 52222;
SET @SPELL_VOID_CHANNEL := 52242;
SET @GO_SOUL_FONT := 190707;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@ENTRY_WORSHIPPER,@ENTRY_BERSERKER);
UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128, `AIName`='SmartAI' WHERE `entry`[email protected]_SOUL_FONT_BUNNY;
UPDATE `creature_template` SET `faction_A`=2141, `faction_H`=2141, `unit_flags`=`unit_flags`|33554432|512|256 WHERE `entry`[email protected]_VOID_ZONE;
DELETE FROM `creature_template_addon` WHERE `entry` IN (@ENTRY_VOID_ZONE,@ENTRY_WORSHIPPER);
INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
(@ENTRY_WORSHIPPER,0,0,0,1,431,NULL),
(@ENTRY_VOID_ZONE,0,0,0,1,0,'52222');
DELETE FROM `creature_addon` WHERE `guid` IN (@GUID+1,@GUID+3,@GUID+4,@GUID+5,@GUID+6,@GUID+7);
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
(@GUID+01,(@GUID+01)*10,0,0,1,0,NULL),
(@GUID+03,(@GUID+03)*10,0,0,1,0,NULL),
(@GUID+04,(@GUID+04)*10,0,0,1,0,NULL),
(@GUID+05,(@GUID+05)*10,0,0,1,0,NULL),
(@GUID+06,(@GUID+06)*10,0,0,1,0,NULL),
(@GUID+07,(@GUID+07)*10,0,0,1,0,NULL);
DELETE FROM `creature` WHERE `id` IN (@ENTRY_VOID_ZONE,@ENTRY_WORSHIPPER,@ENTRY_BERSERKER);
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
(@GUID+08,@ENTRY_VOID_ZONE,571,1,2,0,0,5825.935,-4297.850,374.005,3.142,300,0,0,1,0,0,0,0,8),
(@GUID+09,@ENTRY_VOID_ZONE,571,1,2,0,0,5742.790,-4291.866,373.998,4.712,300,0,0,1,0,0,0,0,8),
(@GUID+10,@ENTRY_VOID_ZONE,571,1,2,0,0,5819.884,-4212.103,362.323,4.712,300,0,0,1,0,0,0,0,8),
(@GUID+11,@ENTRY_VOID_ZONE,571,1,2,0,0,5716.602,-4224.761,362.748,4.712,300,0,0,1,0,0,0,0,8),
(@GUID+12,@ENTRY_VOID_ZONE,571,1,2,0,0,5622.066,-4238.932,363.441,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+13,@ENTRY_VOID_ZONE,571,1,2,0,0,5662.033,-4147.902,351.374,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+14,@ENTRY_VOID_ZONE,571,1,2,0,0,5662.543,-4085.739,352.178,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+15,@ENTRY_VOID_ZONE,571,1,2,0,0,5690.473,-4292.840,374.010,4.712,300,0,0,1,0,0,0,0,8),
(@GUID+16,@ENTRY_VOID_ZONE,571,1,2,0,0,5613.860,-4286.385,373.958,4.712,300,0,0,1,0,0,0,0,8),
(@GUID+17,@ENTRY_VOID_ZONE,571,1,2,0,0,5849.241,-4433.876,373.995,3.142,300,0,0,1,0,0,0,0,8),
(@GUID+18,@ENTRY_VOID_ZONE,571,1,2,0,0,5770.992,-4146.841,352.085,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+19,@ENTRY_VOID_ZONE,571,1,2,0,0,5766.851,-4085.466,352.087,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+20,@ENTRY_VOID_ZONE,571,1,2,0,0,5581.493,-4432.868,374.044,0.000,300,0,0,1,0,0,0,0,8),
(@GUID+21,@ENTRY_WORSHIPPER,571,1,2,0,0,5664.326,-4285.102,373.995,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+22,@ENTRY_WORSHIPPER,571,1,2,0,0,5640.871,-4312.253,374.043,0.743,300,0,0,1,0,0,0,0,8),
(@GUID+23,@ENTRY_WORSHIPPER,571,1,2,0,0,5790.022,-4314.787,374.015,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+24,@ENTRY_WORSHIPPER,571,1,2,0,0,5830.456,-4370.939,373.996,3.142,300,0,0,1,0,0,0,0,8),
(@GUID+25,@ENTRY_WORSHIPPER,571,1,2,0,0,5842.251,-4440.665,373.996,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+26,@ENTRY_WORSHIPPER,571,1,2,0,0,5605.659,-4368.061,373.995,0.000,300,0,0,1,0,0,0,0,8),
(@GUID+27,@ENTRY_WORSHIPPER,571,1,2,0,0,5592.050,-4436.903,373.996,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+28,@ENTRY_WORSHIPPER,571,1,2,0,0,5643.647,-4485.153,385.755,0.743,300,0,0,1,0,0,0,0,8),
(@GUID+29,@ENTRY_WORSHIPPER,571,1,2,0,0,5790.590,-4447.139,385.803,2.314,300,0,0,1,0,0,0,0,8),
(@GUID+30,@ENTRY_WORSHIPPER,571,1,2,0,0,5765.322,-4373.019,385.802,3.142,300,0,0,1,0,0,0,0,8),
(@GUID+31,@ENTRY_WORSHIPPER,571,1,2,0,0,5678.216,-4372.278,385.802,0.000,300,0,0,1,0,0,0,0,8),
(@GUID+32,@ENTRY_WORSHIPPER,571,1,2,0,0,5819.560,-4295.625,374.202,5.982,300,0,0,1,0,0,0,0,8),
(@GUID+33,@ENTRY_WORSHIPPER,571,1,2,0,0,5822.129,-4259.139,367.923,2.127,300,0,0,1,0,0,0,0,8),
(@GUID+34,@ENTRY_WORSHIPPER,571,1,2,0,0,5830.556,-4220.344,362.065,2.314,300,0,0,1,0,0,0,0,8),
(@GUID+35,@ENTRY_WORSHIPPER,571,1,2,0,0,5770.107,-4212.817,360.935,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+36,@ENTRY_WORSHIPPER,571,1,2,0,0,5678.333,-4220.999,362.748,3.142,300,0,0,1,0,0,0,0,8),
(@GUID+37,@ENTRY_WORSHIPPER,571,1,2,0,0,5618.709,-4228.177,363.554,4.712,300,0,0,1,0,0,0,0,8),
(@GUID+38,@ENTRY_WORSHIPPER,571,1,2,0,0,5668.057,-4172.854,353.183,1.832,300,0,0,1,0,0,0,0,8),
(@GUID+39,@ENTRY_WORSHIPPER,571,1,2,0,0,5672.698,-4136.670,351.429,3.918,300,0,0,1,0,0,0,0,8),
(@GUID+40,@ENTRY_WORSHIPPER,571,1,2,0,0,5636.121,-4146.457,351.499,3.142,300,0,0,1,0,0,0,0,8),
(@GUID+41,@ENTRY_WORSHIPPER,571,1,2,0,0,5667.368,-4080.593,352.231,4.043,300,0,0,1,0,0,0,0,8),
(@GUID+42,@ENTRY_WORSHIPPER,571,1,2,0,0,5636.747,-4086.012,352.193,3.142,300,0,0,1,0,0,0,0,8),
(@GUID+43,@ENTRY_WORSHIPPER,571,1,2,0,0,5797.730,-4087.556,352.303,0.000,300,0,0,1,0,0,0,0,8),
(@GUID+44,@ENTRY_WORSHIPPER,571,1,2,0,0,5798.070,-4147.763,352.091,0.000,300,0,0,1,0,0,0,0,8),
(@GUID+45,@ENTRY_WORSHIPPER,571,1,2,0,0,5757.631,-4079.349,352.302,5.508,300,0,0,1,0,0,0,0,8),
(@GUID+46,@ENTRY_WORSHIPPER,571,1,2,0,0,5756.672,-4146.403,352.085,0.000,300,0,0,1,0,0,0,0,8),
(@GUID+00,@ENTRY_BERSERKER,571,1,2,0,0,5840.009,-4346.181,373.995,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+01,@ENTRY_BERSERKER,571,1,2,0,0,5832.134,-4317.627,373.995,2.822,300,0,1,1,0,2,0,0,8),
(@GUID+02,@ENTRY_BERSERKER,571,1,2,0,0,5590.978,-4342.073,374.239,1.571,300,0,0,1,0,0,0,0,8),
(@GUID+03,@ENTRY_BERSERKER,571,1,2,0,0,5599.696,-4323.438,374.000,0.590,300,0,1,1,0,2,0,0,8),
(@GUID+04,@ENTRY_BERSERKER,571,1,2,0,0,5610.043,-4223.405,364.173,0.000,300,0,1,1,0,2,0,0,8),
(@GUID+05,@ENTRY_BERSERKER,571,1,2,0,0,5820.146,-4237.775,363.397,3.142,300,0,1,1,0,2,0,0,8),
(@GUID+06,@ENTRY_BERSERKER,571,1,2,0,0,5818.093,-4116.916,353.184,3.142,300,0,1,1,0,2,0,0,8),
(@GUID+07,@ENTRY_BERSERKER,571,1,2,0,0,5615.334,-4116.020,353.162,0.000,300,0,1,1,0,2,0,0,8);
DELETE FROM `gameobject` WHERE `id`[email protected]_SOUL_FONT;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(@GUID_GO+00,@GO_SOUL_FONT,571,1,2,5825.935,-4297.850,374.005,3.142,0,0,0,0,120,100,1),
(@GUID_GO+01,@GO_SOUL_FONT,571,1,2,5742.790,-4291.866,373.998,4.712,0,0,0,0,120,100,1),
(@GUID_GO+02,@GO_SOUL_FONT,571,1,2,5819.884,-4212.103,362.323,4.712,0,0,0,0,120,100,1),
(@GUID_GO+03,@GO_SOUL_FONT,571,1,2,5716.602,-4224.761,362.748,4.712,0,0,0,0,120,100,1),
(@GUID_GO+04,@GO_SOUL_FONT,571,1,2,5622.066,-4238.932,363.441,1.571,0,0,0,0,120,100,1),
(@GUID_GO+05,@GO_SOUL_FONT,571,1,2,5662.033,-4147.902,351.374,1.571,0,0,0,0,120,100,1),
(@GUID_GO+06,@GO_SOUL_FONT,571,1,2,5662.543,-4085.739,352.178,1.571,0,0,0,0,120,100,1),
(@GUID_GO+07,@GO_SOUL_FONT,571,1,2,5690.473,-4292.840,374.010,4.712,0,0,0,0,120,100,1),
(@GUID_GO+08,@GO_SOUL_FONT,571,1,2,5613.860,-4286.385,373.958,4.712,0,0,0,0,120,100,1),
(@GUID_GO+09,@GO_SOUL_FONT,571,1,2,5849.241,-4433.876,373.995,3.142,0,0,0,0,120,100,1),
(@GUID_GO+10,@GO_SOUL_FONT,571,1,2,5770.992,-4146.841,352.085,1.571,0,0,0,0,120,100,1),
(@GUID_GO+11,@GO_SOUL_FONT,571,1,2,5766.851,-4085.466,352.087,1.571,0,0,0,0,120,100,1),
(@GUID_GO+12,@GO_SOUL_FONT,571,1,2,5581.493,-4432.868,374.044,0.000,0,0,0,0,120,100,1);
DELETE FROM `waypoint_data` WHERE `id` IN ((@GUID+01)*10,(@GUID+03)*10,(@GUID+04)*10,(@GUID+05)*10,(@GUID+06)*10,(@GUID+07)*10);
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
((@GUID+01)*10,1,5832.134,-4317.627,373.995),
((@GUID+01)*10,2,5795.876,-4299.470,373.995),
((@GUID+01)*10,3,5729.642,-4299.368,373.996),
((@GUID+03)*10,1,5599.696,-4323.438,374.000),
((@GUID+03)*10,2,5631.256,-4300.181,373.995),
((@GUID+03)*10,3,5699.798,-4301.302,373.993),
((@GUID+04)*10,1,5610.043,-4223.405,364.173),
((@GUID+04)*10,2,5696.147,-4222.800,362.839),
((@GUID+05)*10,1,5820.146,-4237.775,363.397),
((@GUID+05)*10,2,5783.325,-4235.276,359.839),
((@GUID+05)*10,3,5763.505,-4229.624,362.447),
((@GUID+05)*10,4,5738.750,-4223.436,362.784),
((@GUID+05)*10,5,5763.505,-4229.624,362.447),
((@GUID+05)*10,6,5783.325,-4235.276,359.839),
((@GUID+06)*10,1,5818.093,-4116.916,353.184),
((@GUID+06)*10,2,5750.263,-4116.848,353.163),
((@GUID+06)*10,3,5750.950,-4167.937,353.402),
((@GUID+06)*10,4,5816.145,-4174.209,353.476),
((@GUID+07)*10,1,5615.334,-4116.020,353.162),
((@GUID+07)*10,2,5698.958,-4116.020,353.243);
-- SmartAIs
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY_SOUL_FONT_BUNNY,@ENTRY_WORSHIPPER,@ENTRY_BERSERKER) 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
-- Soul Font Bunny script
(@ENTRY_SOUL_FONT_BUNNY,0,0,0,54,0,100,0,0,0,0,0,11,@SPELL_VOID_CHANNEL,0,0,0,0,0,0,0,0,0,0,0,0,0, 'Soul Font Bunny - On summon - channel'),
-- Quetz'lun Worshipper script
(@ENTRY_WORSHIPPER,0,0,0,23,0,100,0,@SPELL_FONT_VOID,1,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Quetz''lun Worshipper - On aura 52222 - set event phase 1'),
(@ENTRY_WORSHIPPER,0,1,2,6,1,100,0,0,0,0,0,12,@ENTRY_SOUL_FONT_BUNNY,3,1000,0,0,0,1,0,0,0,0,0,0,0, 'Quetz''lun Worshipper - On death in phase 1 - summon Soul Font Bunny'),
(@ENTRY_WORSHIPPER,0,2,0,61,1,100,0,0,0,0,0,33,@ENTRY_KC,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Quetz''lun Worshipper - On death in phase 1 - give quest credit'),
(@ENTRY_WORSHIPPER,0,3,0,16,0,100,0,@SPELL_FONT_VOID,1,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Quetz''lun Worshipper - On missing aura 52222 - set event phase 0'),
-- Serpent-Touched Berserker
(@ENTRY_BERSERKER,0,0,0,23,0,100,0,@SPELL_FONT_VOID,1,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Serpent-Touched Berserker - On aura 52222 - set event phase 1'),
(@ENTRY_BERSERKER,0,1,2,6,1,100,0,0,0,0,0,12,@ENTRY_SOUL_FONT_BUNNY,3,1000,0,0,0,1,0,0,0,0,0,0,0, 'Serpent-Touched Berserker - On death in phase 1 - summon Soul Font Bunny'),
(@ENTRY_BERSERKER,0,2,0,61,1,100,0,0,0,0,0,33,@ENTRY_KC,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Serpent-Touched Berserker - On death in phase 1 - give quest credit'),
(@ENTRY_BERSERKER,0,3,0,16,0,100,0,@SPELL_FONT_VOID,1,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Serpent-Touched Berserker - On missing aura 52222 - set event phase 0');
[/sql]