Trinitycore: DB/Quest: Emergency Protocol: Section 8.2, Paragraph D

Created on 23 Dec 2018 · 5Comments · Source: TrinityCore/TrinityCore

Description:
https://db.rising-gods.de/?quest=11796
The Emergency Tourch fails when used at the northernmost (61.1,30.1), southwestern (59.5,39.2) and central (61.6,36) Crashed Flying Machines.
The spell fails becuse these spots do not have the spellfocus https://db.rising-gods.de/?object=188019 nearby.

In addition
https://www.wowhead.com/quest=11796/emergency-protocol-section-8-2-paragraph-d#comments:id=446300

Branch(es):
3.3.5

TC rev. hash/commit:
50f78e686c25

Comp-Database Feedback-PatchFix Sub-Quests Sub-Spawns

Source

PolarCookie

Most helpful comment

``` sql

DELETE FROM gameobject WHERE guid IN (6687,6688,6689);
INSERT INTO gameobject (guid, id, map, zoneId, areaId, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES
(6687, 188019, 571, 0, 0, 1, 1, 3739.25, 5047.19, 2.57367, 2.70438, -0, -0, -0.9762, -0.21687, 300, 255, 1),
(6688, 188019, 571, 0, 0, 1, 1, 3390.51, 5137.37, 16.1839, 2.64766, -0, -0, -0.969659, -0.244463, 300, 255, 1),
(6689, 188019, 571, 0, 0, 1, 1, 3515.22, 5017.28, 1.93156, 1.74533, -0, -0, -0.766045, -0.642787, 300, 255, 1);

DELETE FROM creature_text WHERE CreatureID=25807;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(25807,0,0,"Are you crazy? You're about to blow us sky high! I'll take care of this wreck once everything else is finished.",12,0,100,0,0,0,25043,0,"Iggy Tailspin Cogtoggle");

DELETE FROM smart_scripts WHERE entryorguid=-119150 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
(-119150,0,0,0,8,0,100,512,46171,0,0,0,1,0,0,0,0,0,0,19,25807,20,0,0,0,0,0,"East Crash - On Spellhit - say text");

DELETE FROM smart_scripts WHERE entryorguid IN (25845, 25847, 25846) AND source_type=0 AND id=1;
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
(25845,0,1,0,8,0,100,512,46171,0,0,0,11,34521,0,0,0,0,0,1,0,0,0,0,0,0,0,"Northwest Crash - On Spellhit - cast Serverside - Summon Fire"),
(25846,0,1,0,8,0,100,512,46171,0,0,0,11,34521,0,0,0,0,0,1,0,0,0,0,0,0,0,"South Crash - On Spellhit - cast Serverside - Summon Fire"),
(25847,0,1,0,8,0,100,512,46171,0,0,0,11,34521,0,0,0,0,0,1,0,0,0,0,0,0,0,"East Crash - On Spellhit - cast Serverside - Summon Fire");

Killyana on 24 Dec 2018

👍2

All 5 comments

there are 3 gos of that id spawned.
https://i.imgur.com/xHLAwfP.png

Aokromes on 23 Dec 2018

There are 6 crashed planes.

SELECT * FROM creature WHERE id IN (25845, 25846, 25847);

PolarCookie on 23 Dec 2018

TrinityCore rev. cb136387218b 2018-12-19 16:08:35 +0100 (3.3.5 branch) (Win64, RelWithDebInfo, Static)

Kill credit NPCs:

SELECT * FROM `creature_template` WHERE `entry` IN (25845, 25846, 25847);

entry  difficulty_entry_1  difficulty_entry_2  difficulty_entry_3  KillCredit1  KillCredit2  modelid1  modelid2  modelid3  modelid4  name             subname  IconName  gossip_menu_id  minlevel  maxlevel     exp  faction  npcflag  speed_walk  speed_run   scale    rank  dmgschool  BaseAttackTime  RangeAttackTime  BaseVariance  RangeVariance  unit_class  unit_flags  unit_flags2  dynamicflags  family  trainer_type  trainer_spell  trainer_class  trainer_race    type  type_flags  lootid  pickpocketloot  skinloot  resistance1  resistance2  resistance3  resistance4  resistance5  resistance6  spell1  spell2  spell3  spell4  spell5  spell6  spell7  spell8  PetSpellDataId  VehicleId  mingold  maxgold  AIName   MovementType  HoverHeight  HealthModifier  ManaModifier  ArmorModifier  DamageModifier  ExperienceModifier  RacialLeader  movementId  RegenHealth  mechanic_immune_mask  spell_school_immune_mask  flags_extra  ScriptName  VerifiedBuild
-----  ------------------  ------------------  ------------------  -----------  -----------  --------  --------  --------  --------  ---------------  -------  --------  --------------  --------  --------  ------  -------  -------  ----------  ---------  ------  ------  ---------  --------------  ---------------  ------------  -------------  ----------  ----------  -----------  ------------  ------  ------------  -------------  -------------  ------------  ------  ----------  ------  --------------  --------  -----------  -----------  -----------  -----------  -----------  -----------  ------  ------  ------  ------  ------  ------  ------  ------  --------------  ---------  -------  -------  -------  ------------  -----------  --------------  ------------  -------------  --------------  ------------------  ------------  ----------  -----------  --------------------  ------------------------  -----------  ----------  -------------
25845                   0                   0                   0            0            0      1060     17188         0         0  Northwest Crash                                  0        70        70       2       35        0           1    1.14286       1       0          0            2000             2000             1              1           2    33554944         2048             0       0             0              0              0             0      10           0       0               0         0            0            0            0            0            0            0       0       0       0       0       0       0       0       0               0          0        0        0  SmartAI             0            1               1             1              1               1                   1             0           0            1                     0                         0          128                      12340
25846                   0                   0                   0            0            0      1060     17188         0         0  South Crash                                      0        70        70       2       35        0           1    1.14286       1       0          0            2000             2000             1              1           2    33554944         2048             0       0             0              0              0             0      10           0       0               0         0            0            0            0            0            0            0       0       0       0       0       0       0       0       0               0          0        0        0  SmartAI             0            1               1             1              1               1                   1             0           0            1                     0                         0          128                      12340
25847                   0                   0                   0            0            0      1060     17188         0         0  East Crash                                       0        70        70       2       35        0           1    1.14286       1       0          0            2000             2000             1              1           2    33554944         2048             0       0             0              0              0             0      10           0       0               0         0            0            0            0            0            0            0       0       0       0       0       0       0       0       0               0          0        0        0  SmartAI             0            1               1             1              1               1                   1             0           0            1                     0                         0          128                      12340



md5-8f8e08648b5602d14e428cc34db3b9a1

guid id map zoneId areaId spawnMask phaseMask modelid equipment_id position_x position_y position_z orientation spawntimesecs spawndist currentwaypoint curhealth curmana MovementType npcflag unit_flags dynamicflags ScriptName VerifiedBuild

118881 25845 571 0 0 1 1 17188 0 3606.57 5063 14.4285 0.785398 300 5 0 8982 3155 1 0 0 0 0
118886 25845 571 0 0 1 1 17188 0 3739.39 5047.41 -0.865776 2.14675 300 5 0 8982 3155 1 0 0 0 0
119029 25846 571 0 0 1 1 17188 0 3357.67 5049.81 14.1139 0.314159 300 5 0 8982 3155 1 0 0 0 0
119030 25846 571 0 0 1 1 17188 0 3390.86 5135.81 14.4616 1.18682 300 5 0 8982 3155 1 0 0 0 0
119150 25847 571 0 0 1 1 17188 0 3515.69 5016.58 -0.550566 1.74533 300 5 0 8982 3155 1 0 0 0 0
119186 25847 571 0 0 1 1 17188 0 3475.71 4917.4 13.3331 4.93928 300 5 0 8982 3155 1 0 0 0 0

So yes. if the gameobjects are meant to be spell focus for each of the kill credit NPCs, there should be 6 gameobjects, not 3:
```sql
SELECT * FROM `gameobject` WHERE `id`=188019;

 guid      id     map  zoneId  areaId  spawnMask  phaseMask  position_x  position_y  position_z  orientation  rotation0  rotation1  rotation2  rotation3  spawntimesecs  animprogress   state  ScriptName  VerifiedBuild
-----  ------  ------  ------  ------  ---------  ---------  ----------  ----------  ----------  -----------  ---------  ---------  ---------  ---------  -------------  ------------  ------  ----------  -------------
99826  188019     571       0       0          1          1      3604.6        5065     13.2919      5.39233          0          0   0.430844  -0.902427             25             0       1                          0
99827  188019     571       0       0          1          1     3476.66     4918.67     13.8639      4.62499          0          0   0.737322  -0.675541             25             0       1                          0
99828  188019     571       0       0          1          1     3355.87     5049.47     14.2951      6.05756          0          0   0.112574  -0.993643             25             0       1                          0

edit: BTW, I checked those 6 visible crashed biplanes and found only 3 gameobjects (.gobject near), are the visible objects "doodads", since there is no gameobject at 3 of the 6 crashed planes?