- [Location, Faction, Race]Hillsbrad Foothills, Horde
- [Name, Type] Coastal Coastal Delicacies!, Quest
- [Problem Description] When accepting the quest, nothing really happens. No spider is summoned and the quest doesn't give credit. Also the Hungry Mine Spider has no spells to cast.
- [How it should work] Take a look at this video: https://www.youtube.com/watch?v=upGIXZyv1fI&t=1s
Also to mention, in SAI for the quest giver, it's summoning the player the Hungry Mine Spider when in reality that's not the correct way to do it. The quest give is supposed to cast a spell on the player (https://www.wowhead.com/spell=88762/hungry-mine-creeper#screenshots) which summons the spider and already follows the player. I've provided a few queries to fix a few things but the quest itself does not work correctly.
Code:
-- Fixes Hungry Mine Creepers level and faction
UPDATE `creature_template` SET `minlevel`='20', `maxlevel`='20', `faction_A`='22', `faction_H`='22' WHERE `entry`=47662;
-- Adds spell for summon Hungry Mine Creeper
UPDATE `quest_template` SET `SourceSpellId`='88762' WHERE `Id`=28146;
-- Removes useless SAI since creature is summoned VIA spell in quest_template (SourceSpellId)
DELETE FROM `smart_scripts` WHERE `entryorguid`=47551 AND `source_type`=0 AND `id`=0 AND `link`=0;
-- Hungry Mine Creeper - removes SAI for following player since it's useless (check https://www.wowhead.com/spell=88762/hungry-mine-creeper#screenshots), also adds correct spells (creature doesn't cast spells for some reason? needs checking?)
SET @ENTRY := 47662;
SET [MENTION=8308]Sour[/MENTION]CETYPE := 0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type` [MENTION=8308]Sour[/MENTION]CETYPE;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY LIMIT 1;
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
(@ENTRY [MENTION=8308]Sour[/MENTION]CETYPE,0,0,54,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,"On Just Summoned - Set Defensive"),
(@ENTRY [MENTION=8308]Sour[/MENTION]CETYPE,1,0,0,0,100,0,7500,10000,7500,10000,11,88760,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"IC - Cast Shot Web"),
(@ENTRY [MENTION=8308]Sour[/MENTION]CETYPE,2,0,0,0,100,0,5000,12500,5000,12500,11,3396,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"IC - Cast Corrosive Poison")
Last edited:
