[3.3.5][6.x] DB/Quest: I Sense a Disturbance (12665)

[ccrs]

wrong spell target on gossip select
http://www.wowhead.com/spell=52187
http://www.wowhead.com/quest=12665/

player has to cast the spell to itself so current target SMART_TARGET_ACTION_INVOKER doesnt work.

ee12982

[ccrs]

UPDATE `smart_scripts` SET `action_type`=85 WHERE `entryorguid`=28401 and`source_type`=0 and`id`=0 and`link`=1;

[Killyana]

There's another issue with areatrigger_involvedrelation it doesn't trigger if the player is using a vehicle:

 SELECT * FROM `areatrigger_involvedrelation` WHERE `id` =5052 AND `quest`=12665;

[ghost]

@Killyana I've been messing around with the quest and it seems It will complete after someone on the server has done it once or has been in that general area after a server restart.

Either doing it twice or having someone near the trigger location allows it to be completed.

[ccrs]

so... grid load?

[ghost]

@ccrs Thinking that, but I don't really know enough to say whether it's related to that or not.

[Killyana]

@joslyn-liu I cannot reproduce it, for me the areatrigger is never trigged when I'm on the vehicle.

[Rushor]

UPDATE

@Treeston wrote:

3.3.5 0316dff

Quest: I Sense a Disturbance

Quest is completely nonfunctional. Selecting the related gossip option does nothing. Quest >cannot be completed

[dr-j]

Hmm I had previously disabled path finding for Har'koas kitten in Nov 2013 as had found this fixed the credit issue (ye we had the flags extra thing to disable path finding on tw a long time ago) but appears this was reported as not working again in Sep 2015 so idk what changed then p:

And @Treeston found no issue with gossip been missing but you have to make sure you try with correct spawn of Har'koa guid 118591 if you try with the npc at Zim'torga (guid 43491) even though same entry no gossip option is displayed and works just credit seems to now be broken.

[Treeston]

Gossip wasn't missing, it just did nothing when clicked for me.

[dr-j]

weird works for me just credit does not work its using action 11 target 7 and no cast flags but works fine, I have a feeling this may not work if player is mounted when gossip selected though as usually needs cast flags p:

[Aokromes]

So.... something here is needed?

[dr-j]

This fixes the credit however not in proper way (proper way is already scripted) but there seems to be issues with vehicle triggering areatrigger (ie only works if you go on foot,

This simply adds event to the timed action list which is triggered when the vehicle reaches the corpse of Quetz'lun

DELETE FROM `smart_scripts` WHERE `entryorguid`=2905000 AND `source_type`=9 AND `id`=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
(2905000, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 15, 12665, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'Har\'koa - On Script - Complete quest');

[dewmguy]

Quest can only be completed by using .cast 52187 and then manually running to the corpse of Quetz'lun

9ec3724

[Rushor]

we need invoker cast now and we need to add the charmflag in script9

-- Har'koa SAI
SET @ENTRY := 28401;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,1,62,0,100,0,9687,0,0,0,85,52187,2,0,0,0,0,7,0,0,0,0,0,0,0,"Har'koa - On Gossip Option 0 Selected - Invoker Cast 'I Sense a Disturbance: Character Force Cast From Gossip'"),
(@ENTRY,0,1,0,61,0,100,512,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Har'koa - On Gossip Option 0 Selected - Close Gossip"),
(@ENTRY,0,2,3,20,0,100,512,12684,0,0,0,70,30,0,0,0,0,0,14,16964,190736,0,0,0,0,0,"Har'koa - On Quest 'Blood of a Dead God' Finished - Respawn Closest Gameobject 'Underworld Power Fragment'"),
(@ENTRY,0,3,4,61,0,100,512,0,0,0,0,70,30,0,0,0,0,0,14,16965,190737,0,0,0,0,0,"Har'koa - On Quest Finished - Respawn Closest Gameobject 'Underworld Power Fragment'"),
(@ENTRY,0,4,5,61,0,100,512,0,0,0,0,70,30,0,0,0,0,0,14,16966,190738,0,0,0,0,0,"Har'koa - On Quest Finished - Respawn Closest Gameobject 'Underworld Power Fragment'"),
(@ENTRY,0,5,6,61,0,100,512,0,0,0,0,70,30,0,0,0,0,0,14,16967,190738,0,0,0,0,0,"Har'koa - On Quest Finished - Respawn Closest Gameobject 'Underworld Power Fragment'"),
(@ENTRY,0,6,7,61,0,100,512,0,0,0,0,70,30,0,0,0,0,0,14,16968,190737,0,0,0,0,0,"Har'koa - On Quest Finished - Respawn Closest Gameobject 'Underworld Power Fragment'"),
(@ENTRY,0,7,8,61,0,100,512,0,0,0,0,12,23837,3,30000,0,0,0,8,0,0,0,5335.71,-3770.93,373.701,3.92699,"Har'koa - On Quest Finished - Summon Creature 'ELM General Purpose Bunny'"),
(@ENTRY,0,8,9,61,0,100,512,0,0,0,0,12,23837,3,30000,0,0,0,8,0,0,0,5329.66,-3770.81,372.802,4.43314,"Har'koa - On Quest Finished - Summon Creature 'ELM General Purpose Bunny'"),
(@ENTRY,0,9,10,61,0,100,512,0,0,0,0,12,23837,3,30000,0,0,0,8,0,0,0,5332.67,-3770.17,373.23,4.08407,"Har'koa - On Quest Finished - Summon Creature 'ELM General Purpose Bunny'"),
(@ENTRY,0,10,11,61,0,100,512,0,0,0,0,12,23837,3,30000,0,0,0,8,0,0,0,5336.71,-3774.09,372.905,0,"Har'koa - On Quest Finished - Summon Creature 'ELM General Purpose Bunny'"),
(@ENTRY,0,11,12,61,0,100,512,0,0,0,0,12,23837,3,30000,0,0,0,8,0,0,0,5335.77,-3777.74,373.331,3.38594,"Har'koa - On Quest Finished - Summon Creature 'ELM General Purpose Bunny'"),
(@ENTRY,0,12,0,61,0,100,512,0,0,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa - On Quest Finished - Run Script"),
(@ENTRY,0,13,0,64,0,100,512,0,0,0,0,98,9687,13139,0,0,0,0,7,0,0,0,0,0,0,0,"Har'koa - On Gossip Hello - Send Gossip"),
(@ENTRY,0,14,15,38,0,100,0,0,1,0,0,1,0,0,0,0,0,0,12,1,0,0,0,0,0,0,"Har'koa - On Data Set 0 1 - Say Line 0 for duration 0 not using Talktarget"),
(@ENTRY,0,15,0,61,0,100,512,0,0,0,0,45,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa - On Data Set 0 0 - Set Data 0 0"),
(@ENTRY,0,16,15,38,0,100,0,0,2,0,0,1,1,0,0,0,0,0,12,1,0,0,0,0,0,0,"Har'koa - On Data Set 0 2 - Say Line 1 for duration 0 not using Talktarget");

-- Har'koa's Kitten SAI
SET @ENTRY := 28665;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,1,63,0,100,512,0,0,0,0,75,52188,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Just Created - Add Aura 'Stealth'"),
(@ENTRY,0,1,0,61,0,100,512,0,0,0,0,80,@ENTRY*100+05,2,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Just Created - Run Script"),
(@ENTRY,0,2,0,40,0,100,512,1,28665,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 1 Reached - Say Line 0 for duration 0 not using Talktarget"),
(@ENTRY,0,3,4,40,0,100,512,10,28665,0,0,54,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 10 Reached - Pause Waypoint"),
(@ENTRY,0,4,0,61,0,100,512,0,0,0,0,1,1,0,0,0,0,0,23,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 0 Reached - Say Line 1 for duration 0 not using Talktarget"),
(@ENTRY,0,5,6,40,0,100,512,18,28665,0,0,54,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 18 Reached - Pause Waypoint"),
(@ENTRY,0,6,7,61,0,100,512,0,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 0 Reached - Set Run Off"),
(@ENTRY,0,7,0,61,0,100,512,0,0,0,0,1,2,0,0,0,0,0,23,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 0 Reached - Say Line 2 for duration 0 not using Talktarget"),
(@ENTRY,0,9,0,40,0,100,512,21,28665,0,0,84,0,0,0,0,0,0,19,28671,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 21 Reached - Say Line 0"),
(@ENTRY,0,10,11,40,0,100,512,22,28665,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 22 Reached - Set Run On"),
(@ENTRY,0,11,0,61,0,100,512,0,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 0 Reached - Say Line 3 for duration 0 not using Talktarget"),
(@ENTRY,0,12,0,40,0,100,512,31,28665,0,0,11,39870,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 31 Reached - Cast 'Speed Burst'"),
(@ENTRY,0,13,14,40,0,100,512,34,28665,0,0,28,39870,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 34 Reached - Remove Aura 'Speed Burst'"),
(@ENTRY,0,14,15,61,0,100,512,0,0,0,0,97,30,10,0,0,0,0,8,0,0,0,5651.19,-3790.46,361.974,0,"Har'koa's Kitten - On Waypoint 0 Reached - Jump To Pos"),
(@ENTRY,0,15,0,61,0,100,512,0,0,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 0 Reached - Run Script"),
(@ENTRY,0,16,17,40,0,100,512,11,286650,0,0,1,5,0,0,0,0,0,23,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 11 Reached - Say Line 5 for duration 0 not using Talktarget"),
(@ENTRY,0,17,18,61,0,100,512,0,0,0,0,28,25673,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 0 Reached - Remove Aura 'Riding Har'koa's Kitten'"),
(@ENTRY,0,18,0,61,0,100,512,0,0,0,0,41,500,0,0,0,0,0,1,0,0,0,0,0,0,0,"Har'koa's Kitten - On Waypoint 0 Reached - Despawn In 500 ms");

-- Actionlist SAI
SET @ENTRY := 2866505;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,9,0,0,0,0,100,512,2000,2000,0,0,53,1,28665,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Start Waypoint");

DELETE FROM `smart_scripts` WHERE `entryorguid`=2905000 AND `source_type`=9 AND `id`=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
(2905000, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 15, 12665, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'Har\'koa - On Script - Complete quest');

[ghost]

(maybe add ```sql for syntax highlighting?)