[Completed][Wip] The Yeti Next Door


I came across a total of 10 bugs in this quest, which are the following.

  1. Spell “Place Ram Meat” should only be usable inside Wildervar Mine - DONE

  2. He should cast Ground Smash. - DONE

  3. He should become aggressive on combat enter. - DONE

  4. When he reaches home he should cast 42648 (Sleeping Sleep) - DONE

  5. The ‘Wildervar Miners’ who are mining inside the mine should not be targetable. - DONE

  6. He should be un-attackable until meat is placed. - DONE

  7. When he reaches home he should become un-attackable again. - DONE

  8. Two of the ‘Wildervar Miners’ outside the mine should emote to talk. - DONE

  9. On combat enter he should emote something. - DONE

  10. He should despawn five seconds after he’s dead. (core issue) - DONE

  11. The meat should ALWAYS spawn at those co-ords: - DONE

X: 2636.288086 Y: -5050.891113 Z: 295.537445 O: 5.374982

I have a total of three videos which I can base my information from.

[CODE]-- Make the Wildervar Miners unselectable
UPDATE creature_template SET unit_flags=33554432 WHERE entry=24062;

– Make two miners emote to talk
DELETE FROM creature_addon WHERE guid IN (120419,120422);
INSERT INTO creature_addon (guid,path_id,mount,bytes1,bytes2,emote,auras) VALUES

– The ram meat spell may only be used if player is inside the mine
DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry=43209;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ElseGroup,ConditionTypeOrReference,ConditionValue1,ConditionValue2,ConditionValue3,ErrorTextId,ScriptName,Comment) VALUES
(17,0,43209,0,23,4534,0,0,64,‘’,‘Place Ram Meat can only be used in Wildervar Mine’);

– Insert missing spell_target_position for Place Ram Meat spell
DELETE FROM spell_target_position WHERE id=43209;
INSERT INTO spell_target_position (id,target_map,target_position_x,target_position_y,target_position_z,target_orientation) VALUES

– Shatterhorn SAI
SET @ENTRY := 24178;
SET @SPELL_GROUND_SMASH := 12734; – Ground Smash
UPDATE creature_template SET AIName=‘SmartAI’,unit_flags=256 WHERE entry=@ENTRY;
DELETE FROM creature_addon WHERE guid=106573;
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY;
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,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Shatterhorn - On Aggro - Say Line 0’),
(@ENTRY,0,1,0,21,0,100,0,0,0,0,0,11,42648,1,0,0,0,0,1,0,0,0,0,0,0,0,“Shatterhorn - On Reached Home - Cast Sleeping Sleep”),
(@ENTRY,0,2,0,11,0,100,0,0,0,0,0,11,42648,0,0,0,0,0,1,0,0,0,0,0,0,0,“Shatterhorn - On Spawn - Cast Sleeping Sleep”),
(@ENTRY,0,3,0,21,0,100,0,0,0,0,0,18,256,1,0,0,0,0,1,0,0,0,0,0,0,0,“Shatterhorn - On Reached Home - Set Unit Flags Not Attackable”),
(@ENTRY,0,4,0,0,0,100,0,0,0,0,0,8,2,0,0,0,0,0,1,0,0,0,0,0,0,0,“Shatterhorn - On Enter Combat - Set React State Aggressive”),
(@ENTRY,0,5,0,0,0,100,0,3000,5000,12000,13000,11,@SPELL_GROUND_SMASH,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Shatterhorn - In Combat - Cast Ground Smash’),
(@ENTRY,0,6,0,6,0,100,0,0,0,0,0,41,10,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Shatterhorn - Force Despawn 8 Seconds After Death’); – Doesn’t work but in use for later
– Text
DELETE FROM creature_text WHERE entry=@ENTRY;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(@ENTRY,0,0,‘%s wakes up from the smell of fresh meat!’,16,0,100,15,0,0,‘Shatterhorn on aggro line and roar at same time’);[/sql]

I still have no idea how to make the spell properly summon the object at a specific point. Right now it spawns at the target you have, but it should ALWAYS and at ANY TIME spawn at the co-ordinates I posted in the top of this post.

Thanks in advance


Checking DBC for that spell shows that that spell has:


BasePoints = 1

Targets (17, 0) (TARGET_DST_DB, NO_TARGET)

EffectMiscValueA = 186288

and then, searching on code for target_dst_db:


if (SpellTargetPosition const* st = sSpellMgr->[B]GetSpellTargetPosition/B)

GetSpellTargetPosition returns SpellTargetPosition and searching for SpellTargetPosition you can find a method named LoadSpellTargetPositions that has a line with

QueryResult result = WorldDatabase.Query(“SELECT id, target_map, target_position_x, target_position_y, target_position_z, target_orientation FROM spell_target_position”);

and voilá, you need the coordinates on the spell_target_position table.

I didn’t know this either that’s why I am showing how I found it…



(@ENTRY,0,6,0,6,0,100,0,0,0,0,0,41,5000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Shatterhorn - Force Despawn 5 Seconds after Death'),

Interesting. Inserted a spell_target_position entry and it works perfectly fine now. /emoticons/default_smile.png

As I expected, this is overwritten by core. Really there is a very big bug regarding despawn timers… =/

Updated main post. Move to completed, posting on tracker.

Complete = finished

Wip = Work in progress

a “Complete Wip” is ?