Trinitycore: [3.3.5] Sniffing Out the Perpetrator (Quest 12910)
Description:
- http://www.wowhead.com/quest=12910/sniffing-out-the-perpetrator
If you sit on the Tiger, the QuestEvent with Dwarfs does not start.
Nothing happens. you can't complete this part for this Quest.
Testet with playerchar.
https://www.youtube.com/watch?v=jAJyFFhH02M
Steps to reproduce the problem:
.go 7770 -1063 929 571
.quest add 12910
Branch(es): 3.3.5 / 6.x
TC hash/commit:
TrinityCore rev. 19e757af5cb6 2016-09-06 22:23:34 -0300 (335 branch)
TDB version:
TDB_full_world_335.61_2016_04_11.sql + all updates
Operating system:
Win7 64Bit
Tauriella
All 14 comments
@tkrokli SMART_EVENT_FLAG_WHILE_CHARMED
Treeston
on 8 Sep 2016
and if that doesn't do it and the initial WP movement is started in just summoned event, change that to start in SMART_EVENT_CHARMED.
Treeston
on 8 Sep 2016
http://www.wowhead.com/quest=12910/sniffing-out-the-perpetrator
https://www.youtube.com/watch?v=0RxjPFMEG-g (Sniffing Out the Perpetrator ID: 12910)
OK, so we need to look at the NPC in question to find the SAI.
Track scent to its source: http://www.wowhead.com/npc=29677
SELECT * FROM `smart_scripts` WHERE `entryorguid` LIKE '29677%';
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
----------- ----------- ------ ------ ---------- ---------------- ------------ ----------- ------------ ------------ ------------ ------------ ----------- ------------- ------------- ------------- ------------- ------------- ------------- ----------- ------------- ------------- ------------- -------- -------- -------- -------- -----------------------------------------------------------
29677 0 0 1 54 0 100 0 0 0 0 0 11 54993 0 0 0 0 0 1 0 0 0 0 0 0 0 Frosthound - On Just Summoned - Cast Frosthound Periodic
29677 0 1 0 61 0 100 512 0 0 0 0 80 2967700 0 0 0 0 0 1 0 0 0 0 0 0 0 Frosthound - On Just Summoned - Run Script
29677 0 2 0 7 0 100 0 0 0 0 0 11 54993 0 0 0 0 0 1 0 0 0 0 0 0 0 Frosthound - On Evade - Cast Frosthound Periodic
29677 0 3 4 40 0 100 0 33 29677 0 0 1 2 0 0 0 0 0 1 0 0 0 0 0 0 0 Frosthound - On Reached WP33 - Say Line 2
29677 0 4 5 61 0 100 0 0 0 0 0 1 3 0 0 0 0 0 23 0 0 0 0 0 0 0 Frosthound - On Reached WP33 - Say Line 3
29677 0 5 6 61 0 100 0 0 0 0 0 11 55036 0 0 0 0 0 23 0 0 0 0 0 0 0 Frosthound - On Reached WP33 - Cast Frosthound Boss Emote 2
29677 0 6 0 61 0 100 512 0 0 0 0 41 0 0 0 0 0 0 1 0 0 0 0 0 0 0 Frosthound - On Reached WP33 - Despawn
2967700 9 0 0 0 0 100 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 Frosthound - Script - Say Line 0
2967700 9 1 0 0 0 100 0 0 0 0 0 11 55026 0 0 0 0 0 1 0 0 0 0 0 0 0 Frosthound - Script - Cast Frosthound Boss Emote
2967700 9 2 0 0 0 100 0 0 0 0 0 53 1 29677 0 0 0 0 1 0 0 0 0 0 0 0 Frosthound - Script - Start WP
2967700 9 3 0 0 0 100 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 Frosthound - Script - Say Line 1
Anything against adding 512 to all of the lines, since it clearly does not seem to be enough with 2?
UPDATE `smart_scripts` SET `flags`= `flags` | 512 WHERE `entryorguid` IN (29677, 2967700);
ghost
on 9 Sep 2016
@tkrokli have you tested it? If it doesn't work, change event_type to 29 on id=0.
Treeston
on 9 Sep 2016
OK, I haven't tested it, I have only looked at the values so far. I am doing some other testing, but I will get back to it as soon as I can (depending on how well the other testing goes, like my Lunaclaw PR test).
ghost
on 9 Sep 2016
Commit 3219346 makes the quest once again functional. However, there is still an issue with the summoned dwarves not pursing properly - some of the despawn almost immediately, or just evade back after a short time.
I don't have time to dig into that one right now, would appreciate if someone else could.
Treeston
on 9 Sep 2016
The quest Works now fine :+1: but we Need a loot item "Brann's Communicator" but Tracker Thulin don't drop this
http://www.wowhead.com/item=40971/branns-communicator#dropped-by:0-10-9+1
Tauriella
on 9 Sep 2016
@Tauriella Try this:
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup`=29695 AND `SourceEntry`=40971;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(1, 29695, 40971, 0, 0, 2, 0, 40971, 1, 1, 1, 0, 0, '', 'Brann\'s Communicator drop if player do not have the item'),
(1, 29695, 40971, 0, 0, 14, 0, 12855, 0, 0, 1, 0, 0, '', 'Brann\'s Communicator if has the Alliance quest'),
(1, 29695, 40971, 0, 0, 8, 0, 12855, 0, 0, 1, 0, 0, '', 'Brann\'s Communicator if the Alliance quest is not rewarded'),
(1, 29695, 40971, 0, 1, 2, 0, 40971, 1, 1, 1, 0, 0, '', 'Brann\'s Communicator drop if player do not have the item'),
(1, 29695, 40971, 0, 1, 14, 0, 12910, 0, 0, 1, 0, 0, '', 'Brann\'s Communicator if player has the Horde quest'),
(1, 29695, 40971, 0, 1, 8, 0, 12910, 0, 0, 1, 0, 0, '', 'Brann\'s Communicator if the Horde quest is not rewarded');
sirikfoll
on 9 Sep 2016
Item should now drop properly for both factions.
It's effectively what @sirikfoll did above, except I'm just _way_ too lazy to have all the different combinations as rows so I added a new condition instead.
Treeston
on 9 Sep 2016
Quest can now complete :+1:
But only one Cosmetic Bug
On Blizz you can't sit on the tiger if you don't have accept this Quest.
Tauriella
on 9 Sep 2016
@Tauriella
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup`=29857 AND `SourceEntry`=55460;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(18, 29857, 55460, 0, 0, 9, 0, 12910, 0, 0, 0, 0, 0, '', "Ride Frostbite (Khaliisi's Pet) Spellclick requires Active (taken) quest 'Sniffing Out the Perpetrator'.");
[SQL comment edit by tkrokli]
Rushor
on 24 Nov 2016
@Rushor
It works perfekt :+1:
Thank you!
Tauriella
on 24 Nov 2016
what of all is needed here?
Aokromes
on 27 Nov 2016
We need only @Rushor Fix the other is already in Git :+1:
Tauriella
on 27 Nov 2016
Related issues
Rushor
路
3Comments
Blasphemous
路
3Comments
jerbookins
路
3Comments
Rushor
路
3Comments
DDuarte
路
3Comments
Most helpful comment
Item should now drop properly for both factions.
It's effectively what @sirikfoll did above, except I'm just _way_ too lazy to have all the different combinations as rows so I added a new condition instead.