Problem with quest "Lost In The Deeps"

Hello guys,

i was trying to repair some quests from Deepholm, but i stayed stuck at first one in my list. Its quest named “Lost In The Deeps”, simply quest. After talk with npc it starts to follow you into one point. My problem is, that i cant solve the last part of quest. I was trying many things, but no one of them was successful.

I would be glad for any advice.

Here is my code.

SET @ENTRY := 49956; UPDATE quest_template SET reqcreatureorgoid1 = 0, reqcreatureorgocount1 = 0 WHERE entry = 26710; UPDATE creature_template SET npcflag = 1, unit_flags = 768, flags_extra = 2, ainame = "SmartAI", gossip_menu_id = 49956, scriptname = "" WHERE entry = @ENTRY; INSERT INTO gossip_menu(entry, text_id) VALUES (@ENTRY, 17619); INSERT INTO gossip_menu_option(menu_id, id, option_icon, option_text, option_id, npc_option_npcflag) VALUES (@ENTRY, 0, 0, "Come little guy, let's get out of here.", 1, 1); DELETE FROM creature_text WHERE entry = @ENTRY; INSERT INTO creature_text(entry, TEXT, TYPE, probability, COMMENT) VALUES (@ENTRY, "Pebble's stones jitter as he obediently falls in beside you.", 16, 100, 'Pebble - emote at start of quest.'); 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,1,62,0,100,0,49956,0,0,0,29, 0, 0, 0, 0, 0,0,7,0,0,0,0,0,0,0, 'Pebble - start following target on gossi option click.'), (@ENTRY,0,1,2,61,0,100,0,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Pebble - emote at start of quest.'), (@ENTRY,0,2,3,61,0,100,0,0,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Pebble - flag change.'), (@ENTRY,0,3,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Pebble - turn off gossip.'), (@ENTRY,1,0,0,40,0,100,0,49956,0,0,0,26,26710,0,0,0,0,0,16,0,0,0,0,0,0,0, 'Pebble - complete quest.');--i got no idea, how handle this part [/sql]

UPDATE quest_template SET reqcreatureorgoid1 = 0, reqcreatureorgocount1 = 0 WHERE entry = 26710;[/sql]

Hack, they are wdb fields.

Isn’t this Cataclysm?

Lost in the Deeps is patch 4.0.3a. See http://www.wowwiki.c…st_In_The_Deeps

You’d be better off on the Skyfire forums with Cataclysm questions /emoticons/default_smile.png Try to study smart scripts queries ( For example some of Malcrom’s fixes), you may find your answer.

— Canned message start —

This help request is in no way related to the official codebase of TrinityCore and/or TrinityDatabase and does not belong on these boards.

— Canned message end