Trinitycore: DB/Quest: The Videre Elixir

[ZenoX92]

Description:

Quest "The Videre Elixir" is currently not working.

Current behaviour:

When you use the bait (item 11141) nothing happens.

Expected behaviour:

When you use the bait, Miblon Snarltooth should run towards it, unlocking the path to get the required item to complete the quest.

Branch(es):

3.3.5

TC rev. hash/commit:

TrinityCore rev. 1cc3d33 2018-02-19 20:21:57 +0100 (3.3.5 branch) (Win64, RelWithDebInfo, Static)

TDB version: 335.64

Operating system: Windows 7

Suggested Fix:
``sql -- Quest "The Videre Elixir" -- Miblon's Bait UPDATEgameobject_templateSETAIName="SmartGameObjectAI" WHEREentry=164758; DELETE FROMsmart_scriptsWHEREentryorguid=164758 ANDsource_type=1; INSERT INTOsmart_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
(164758,1,0,0,1,0,100,1,0,0,0,1000,45,1,1,0,0,0,0,19,9467,50,0,0,0,0,0,"Miblon's Bait - Out of Combat - Set Data to Miblon Snarltooth (No Repeat)");

-- Miblon Snarltooth
UPDATE creature_template SET AIName="SmartAI" WHERE entry=9467;
DELETE FROM smart_scripts WHERE entryorguid=9467 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid=946700 AND source_type=9;
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
(9467,0,0,0,11,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Respawn - Set Event Phase 1"),
(9467,0,1,0,38,1,100,0,1,1,0,0,80,946700,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Data Set - Run Script (Phase 1)"),
(946700,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Set Event Phase 0"),
(946700,9,1,0,0,0,100,0,0,0,0,0,83,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Remove NPC Flag Gossip"),
(946700,9,2,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Say Line 0"),
(946700,9,3,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,20,164758,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Set Orientation"),
(946700,9,4,0,0,0,100,0,1000,1000,0,0,41,0,115,0,0,0,0,14,17428,164729,0,0,0,0,0,"Miblon Snarltooth - On Script - Despawn Gameobject 'Miblon's Door'"),
(946700,9,5,0,0,0,100,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Set Run On"),
(946700,9,6,0,0,0,100,0,1000,1000,0,0,69,0,0,0,0,0,0,20,164758,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Move to Closest Gameobject 'Miblon's Bait'"),
(946700,9,7,0,0,0,100,0,3000,3000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Say Line 1"),
(946700,9,8,0,0,0,100,0,3000,3000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Say Line 2"),
(946700,9,9,0,0,0,100,0,4000,4000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Say Line 3"),
(946700,9,10,0,0,0,100,0,105000,105000,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Evade"),
(946700,9,11,0,0,0,100,0,0,0,0,0,82,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Add NPC Flag Gossip"),
(946700,9,12,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Miblon Snarltooth - On Script - Set Event Phase 1");

-- Texts
DELETE FROM creature_text WHERE CreatureID=9467;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(9467,0,0,"%s abandons the block he was holding up in the doorway, and looks towards the bait.",16,0,100,0,0,0,4836,0,"Miblon Snarltooth"),
(9467,1,0,"%s sniffs the bait.",16,0,100,0,0,0,4768,0,"Miblon Snarltooth"),
(9467,2,0,"Grumble...",12,0,100,0,0,0,4766,0,"Miblon Snarltooth"),
(9467,3,0,"%s gnaws at the bait ravenously.",16,0,100,0,0,0,4771,0,"Miblon Snarltooth");

[Killyana]

I'm not sure if it's normal, but if you talk to Miblon after he moves to the bait, he will set his home position to this position, so when he evades it will use it.

[offl]

Probably the gossip flag should be removed during the event.
https://youtu.be/-pZYz7QMluo?t=67

[ZenoX92]

I edited the fix, following @offl's advice. (Gossip flag is now removed during the event)

[mario-64]

Why was the original issue I opened closed and this one left open? Shouldn’t the new, duplicate issue be closed and the original left open? Seems backwards

[Aokromes]

well this contains the fix :)

[mario-64]

Duh! I see. I’ll test tonight and report back. I’m curious if this resolves the visual issue where the wall won’t disappear until the player moves. That seemed to be the previously unsolvable problem

[mario-64]

Never mind. It’s already been committed