Quest: Triage #25387

schell244 · 2020-09-03T20:12:09Z

Description:
Quest Triage has a few bugs.
https://classic.wowhead.com/quest=6624/triage
https://classic.wowhead.com/item=16991/triage-bandage

Expected behaviour:

injured soldiers spawn randomly with low health, and health is slowly reducing
succesfully using item [Triage Bandage] on injured soldier should restore full health and soldier walks aways (and has some text emote)
using [Triage Bandage] should always reduce the charges by 1

Actual behaviour:

injured soldiers spawn randomly, but health increases instead of decreases and does weird jumps
on succesfully using item [Triage Bandage] -> soldier walks away, meanwhile this db error occurs:
CreatureTextMgr: Could not find Text for Creature Badly Injured Alliance Soldier (Entry 12936, spawnId 0) in 'creature_text' table. Ignoring. CreatureTextMgr: Could not find Text for Creature Injured Alliance Soldier (Entry 12938, spawnId 0) in 'creature_text' table. Ignoring. CreatureTextMgr: Could not find Text for Creature Critically Injured Alliance Soldier (Entry 12937, spawnId 0) in 'creature_text' table. Ignoring.
using [Triage Bandage] does not always reduce the charges by 1 ( I guess if not succesful, but hard to tell since health does jumps)
also Quest: Triage (Alliance) - 1 spawn faces wrong direction #26802

Branch(es):
3.3.5

TC rev. hash/commit:
TrinityCore rev. f45aa5c 2020-09-02 22:04:45 +0200 (3.3.5 branch)

Operating system:
Win 10

The text was updated successfully, but these errors were encountered:

offl · 2020-09-03T20:41:27Z

injured soldiers spawn randomly with low health, and health is slowly reducing
succesfully using item [Triage Bandage] on injured soldier should restore full health and soldier walks aways (and has some text emote)

They should not have their health reduced nor increased, they spawn with full HP always.

Rushor · 2020-09-09T10:43:13Z

errorfix

-- Injured Alliance Soldier / Injured Horde Soldier
DELETE FROM `creature_text` WHERE `CreatureID` IN (12923,12924,12925,12938,12936,12937);
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
(12923, 0, 0, 'I\'m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 8355, 0, 'Injured Horde Soldier'),
(12924, 0, 0, 'I\'m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 8355, 0, 'Injured Horde Soldier'),
(12925, 0, 0, 'I\'m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 8355, 0, 'Injured Horde Soldier'),
(12938, 0, 0, 'I\'m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 8355, 0, 'Injured Alliance Soldier'),
(12936, 0, 0, 'I\'m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 8355, 0, 'Injured Alliance Soldier'),
(12937, 0, 0, 'I\'m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 8355, 0, 'Injured Alliance Soldier');

ghost · 2020-10-01T06:59:27Z

Yesterday, I did the Horde quest in Hammerfall and it worked as expected (well, even easier than expected). From earlier times, I can remember that the HP bar of the dying Horde NPC would decrease gradually all the way until the channeling from 1 use of the item [Triage Bandage] completed, only then would the HP bar fill up and the NPC would stand up & run to the entrance near Doctor Gregory Victor while saying their text "I'm saved! Thank you, doctor!". Yesterday, I discovered that the HP bar starts filling up as soon as the [Triage Bandage] spell starts channeling, making it even easier to avoid running out of time.

I remember testing the Alliance quest a couple of years ago, but found that it was way harder to complete successfully compared to the Horde quest, both because of the space limitation and because of the frequent spawn of 2 Alliance NPCs simultaneously. The Horde version of the quest takes place in an open wooden barracks house, not in a cramped sleeping quarter, and the NPCs appear on mats on the floor, making it a lot easier to have full overview of all the summoned patients. I got almost disappointed that there were no double spawns in the Horde version.

TrinityCore rev. 0152878 2020-09-29 19:50:29 +0200 (3.3.5 branch) (Win64, Release, Static)

Current existing creature_text lines in the DB:

SELECT * FROM `creature_text` WHERE `CreatureID` IN (12920,12923,12924,12925,12936,12937,12938,12939);

CreatureID  GroupID    ID    Text                                  Type   Probability  BroadcastTextId  comment
----------  -------  ------  -----------------------------------  ------  -----------  ---------------  ------------------------
   12920       0       0     I'm saved! Thank you, doctor!          12         100           8355       injured_patient SAY_DOC1
   12920       0       1     HOORAY! I AM SAVED!                    12         100           8359       injured_patient SAY_DOC2
   12920       0       2     Sweet, sweet embrace... take me...     12         100           8361       injured_patient SAY_DOC3
   12923       0       0     I'm saved! Thank you, doctor!          12         100           8355
   12924       0       0     I'm saved! Thank you, doctor!          12         100           8355
   12925       0       0     I'm saved! Thank you, doctor!          12         100           8355
   12939       0       0     I'm saved! Thank you, doctor!          12         100           8355       injured_patient SAY_DOC1
   12939       0       1     HOORAY! I AM SAVED!                    12         100           8359       injured_patient SAY_DOC2
   12939       0       2     Sweet, sweet embrace... take me...     12         100           8361       injured_patient SAY_DOC3

Text seems to be missing for creature entry 12936, 12937, 12938.

SELECT `entry`,`modelid1`,`name`,`subname`,`faction`,`flags_extra`,`ScriptName`,`VerifiedBuild`
FROM `creature_template` WHERE `entry` IN (12920,12923,12924,12925,12936,12937,12938,12939);

entry  modelid1  name                                 subname         faction  flags_extra  ScriptName           VerifiedBuild
-----  --------  -----------------------------------  --------------  -------  -----------  -------------------  -------------
12920   12928    Doctor Gregory Victor                Trauma Surgeon     68        66       npc_doctor               12340
12923    6570    Injured Soldier                                         83        66       npc_injured_patient      12340
12924    2588    Badly Injured Soldier                                   83        66       npc_injured_patient      12340
12925    1027    Critically Injured Soldier                              83        66       npc_injured_patient      12340
12936    2986    Badly Injured Alliance Soldier                          12        66       npc_injured_patient      12340
12937    2985    Critically Injured Alliance Soldier                     12        66       npc_injured_patient      12340
12938    2987    Injured Alliance Soldier                                12        66       npc_injured_patient      12340
12939   12930    Doctor Gustaf VanHowzen              Trauma Surgeon    894        66       npc_doctor               12340

offl · 2021-01-07T13:38:56Z

Basically the same concept as c09bd08, but spawn group is not despawned but disabled(already spawned creatures does not despawn, new don't spawn, already spawned will despawn on their own when they die)
Each creature entry can die on their specific timer(depens of how badly he's injured)
Also they all are pooled

ghost · 2022-06-29T10:18:25Z

Currently, soldiers are not selectible and die all too soon, no chance of completing the Ally quest. (Branch 3.3.5)

CraftedRO · 2022-11-06T17:38:30Z

I tried to add conditions for those ones but doesn't works probably because of core script:

-- Conditions for Triage quests
-- Alliance
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 17 AND `SourceEntry` = 20804;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(17,0,20804,0,0,31,1,3,12936,0,0,0,0,'',"Spell 'Triage Bandage' target creature 'Badly Injured Alliance Soldier'"),
(17,0,20804,0,0,31,1,3,12937,0,0,0,0,'',"Spell 'Triage Bandage' target creature 'Critically Injured Alliance Soldier'"),
(17,0,20804,0,0,31,1,3,12938,0,0,0,0,'',"Spell 'Triage Bandage' target creature 'Injured Alliance Soldier'"),
-- Horde
(17,0,20804,0,0,31,1,3,12924,0,0,0,0,'',"Spell 'Triage Bandage' target creature 'Badly Injured Soldier'"),
(17,0,20804,0,0,31,1,3,12925,0,0,0,0,'',"Spell 'Triage Bandage' target creature 'Critically Injured Soldier'"),
(17,0,20804,0,0,31,1,3,12923,0,0,0,0,'',"Spell 'Triage Bandage' target creature 'Injured Soldier'");

Killyana · 2022-11-07T20:08:05Z

The script is so trash it cannot be fixed, it needs full rewrite fro scratch.

DELETE FROM `creature_text` WHERE `CreatureID` IN(12938, 12936, 12937, 12923, 12924, 12925, 12939);
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `comment`, `BroadcastTextId`) VALUES
(12939, 0, 0, "I regret to inform you that you have failed your examination, doctor.", 12, 0, 100, 0, 0, 0, "Doctor Gustaf VanHowzen", 8363),
(12938, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12938, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12938, 0, 2, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC3', 8362),
(12938, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12938, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12938, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12938, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12938, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12938, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12938, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12938, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12938, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12936, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12936, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12936, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC3', 8362),
(12936, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12936, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12936, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12936, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12936, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12936, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12936, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12936, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12936, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12937, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12937, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12937, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC3', 8362),
(12937, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12937, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12937, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12937, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12937, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12937, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12937, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12937, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12937, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12923, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12923, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12923, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC3', 8362),
(12923, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12923, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12923, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12923, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12923, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12923, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12923, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12923, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12923, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12924, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12924, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12924, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC4', 8362),
(12924, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12924, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12924, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12924, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12924, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12924, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12924, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12924, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12924, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12925, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12925, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12925, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC4', 8362),
(12925, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12925, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12925, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12925, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12925, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12925, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12925, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12925, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12925, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361);

Killyana · 2022-11-08T09:01:14Z

Wip (don't execute)

SET @ALLIANCE_QUEST := 6624;
SET @HORDE_QUEST := 6622;
SET @DOCTOR_ALLIANCE := 12939;
SET @DOCTOR_HORDE := 12920;
SET @ALLIANCE_SOLDIIER1 := 12936;
SET @ALLIANCE_SOLDIIER2 := 12937;
SET @ALLIANCE_SOLDIIER3 := 12938;
SET @HORDE_SOLDIIER1 := 12923;
SET @HORDE_SOLDIIER2 := 12924;
SET @HORDE_SOLDIIER3 := 12925;
SET @SPELL := 20804;

UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName`= "" WHERE `entry` IN (@DOCTOR_ALLIANCE, @DOCTOR_HORDE, @ALLIANCE_SOLDIIER1, @ALLIANCE_SOLDIIER2, @ALLIANCE_SOLDIIER3, @HORDE_SOLDIIER1, @HORDE_SOLDIIER2, @HORDE_SOLDIIER3);
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@DOCTOR_ALLIANCE, @DOCTOR_HORDE, @ALLIANCE_SOLDIIER1, @ALLIANCE_SOLDIIER2, @ALLIANCE_SOLDIIER3, @HORDE_SOLDIIER1, @HORDE_SOLDIIER2, @HORDE_SOLDIIER3) AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@DOCTOR_ALLIANCE*100, @DOCTOR_ALLIANCE*100+1, @DOCTOR_ALLIANCE*100+2, @ALLIANCE_SOLDIIER1*100, @ALLIANCE_SOLDIIER1*100+1, @ALLIANCE_SOLDIIER2*100, @ALLIANCE_SOLDIIER3*100) 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
-- Quest taken
(@DOCTOR_ALLIANCE, 0, 0, 0, 19, 0, 100, 0, @ALLIANCE_QUEST, 5000, 5000, 0, 80, @DOCTOR_ALLIANCE*100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - On quest accepted - Action list'),
(@DOCTOR_ALLIANCE*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 83, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action list- Remove npc flag quest giver'),
(@DOCTOR_ALLIANCE*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action list - Store target'),
(@DOCTOR_ALLIANCE*100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action list - Set event phase 1'),
(@DOCTOR_ALLIANCE*100, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 131, 69, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action list - Spawn spawn_group'),
-- Quest complete
(@DOCTOR_ALLIANCE, 0, 4, 0, 77, 1, 100, 0, 1, 15, 5000, 5000, 80, @DOCTOR_ALLIANCE*100+1, 2, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - On counter 1 set to 15 - Action list'),
(@DOCTOR_ALLIANCE*100+1, 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, 'Docteur Gustaf VanHowzen - Action List - Set event phase 0'),
(@DOCTOR_ALLIANCE*100+1, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 132, 69, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Despawn spawn_group'),
(@DOCTOR_ALLIANCE*100+1, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 63, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Reset counter 1'),
(@DOCTOR_ALLIANCE*100+1, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 63, 2, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Reset counter 2'),
(@DOCTOR_ALLIANCE*100+1, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 15, @ALLIANCE_QUEST, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Quest explored'),
(@DOCTOR_ALLIANCE*100+1, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 82, 2, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Add npc_flag quest giver'),
-- Quest fail
(@DOCTOR_ALLIANCE, 0, 5, 0, 77, 1, 100, 0, 2, 5, 5000, 5000, 80, @DOCTOR_ALLIANCE*100+2, 2, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - On counter 2 set to 5 - Action list'),
(@DOCTOR_ALLIANCE*100+2, 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, 'Docteur Gustaf VanHowzen - Action List - Set event phase 0'),
(@DOCTOR_ALLIANCE*100+2, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 132, 69, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Despawn spawn_group'),
(@DOCTOR_ALLIANCE*100+2, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 63, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Reset counter 1'),
(@DOCTOR_ALLIANCE*100+2, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 63, 2, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Reset counter 2'),
(@DOCTOR_ALLIANCE*100+2, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 6, @ALLIANCE_QUEST, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Fail quest'),
(@DOCTOR_ALLIANCE*100+2, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 82, 2, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Add npc_flag quest giver'),
(@DOCTOR_ALLIANCE*100+2, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Docteur Gustaf VanHowzen - Action List - Say line'),

-- Soldiers1 scripts
(@ALLIANCE_SOLDIIER1, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 80, @ALLIANCE_SOLDIIER1*100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - On just summoned - Action list'),
(@ALLIANCE_SOLDIIER1*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 65, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Set emote state dead'),
(@ALLIANCE_SOLDIIER1*100, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Say line'),
(@ALLIANCE_SOLDIIER1*100, 9, 2, 0, 0, 0, 100, 0, 16000, 16000, 0, 0, 63, 2, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - set counter'),
(@ALLIANCE_SOLDIIER1*100, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Kill self'),

(@ALLIANCE_SOLDIIER1, 0, 1, 0, 8, 0, 100, 1, 20804, 0, 0, 0, 80, @ALLIANCE_SOLDIIER1*100+1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - On spell hit - Action list'),
(@ALLIANCE_SOLDIIER1*100+1, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 58806, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Set emote state none'),
(@ALLIANCE_SOLDIIER1*100+1, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 63, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - set counter'),
(@ALLIANCE_SOLDIIER1*100+1, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Say line'),
(@ALLIANCE_SOLDIIER1*100+1, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 69, 0, 0, 0, 4, 0, 0, 19, @DOCTOR_ALLIANCE, 20, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Move to the docter'),
(@ALLIANCE_SOLDIIER1*100+1, 9, 4, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Despawn'),

-- Soldiers2 scripts
(@ALLIANCE_SOLDIIER2, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 80, @ALLIANCE_SOLDIIER2*100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - On just summoned - Action list'),
(@ALLIANCE_SOLDIIER2*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 65, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Set emote state dead'),
(@ALLIANCE_SOLDIIER2*100, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Say line'),
(@ALLIANCE_SOLDIIER2*100, 9, 2, 0, 0, 0, 100, 0, 16000, 16000, 0, 0, 63, 2, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - set counter'),
(@ALLIANCE_SOLDIIER2*100, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Kill self'),

(@ALLIANCE_SOLDIIER2, 0, 1, 0, 8, 0, 100, 1, 20804, 0, 0, 0, 80, @ALLIANCE_SOLDIIER1*100+1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - On spell hit - Action list'),

-- Soldiers3 scripts
(@ALLIANCE_SOLDIIER3, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 80, @ALLIANCE_SOLDIIER3*100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - On just summoned - Action list'),
(@ALLIANCE_SOLDIIER3*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 65, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Set emote state dead'),
(@ALLIANCE_SOLDIIER3*100, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Say line'),
(@ALLIANCE_SOLDIIER3*100, 9, 2, 0, 0, 0, 100, 0, 16000, 16000, 0, 0, 63, 2, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - set counter'),
(@ALLIANCE_SOLDIIER3*100, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - Action list - Kill self'),

(@ALLIANCE_SOLDIIER3, 0, 1, 0, 8, 0, 100, 1, 20804, 0, 0, 0, 80, @ALLIANCE_SOLDIIER1*100+1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alliance Soldier - On spell hit - Action list');
-- to be continued
DELETE FROM `creature_template_addon` WHERE `entry` IN (12936, 12937, 12938, 12923, 12924, 12925);
INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES
(12936, "58806"),
(12937, "58806"),
(12938, "58806"),
(12923, "58806"),
(12924, "58806"),
(12925, "58806");




-- Spawn soldiers
DELETE FROM `creature` WHERE `guid` IN (74033, 74083, 74142, 80342, 83066, 83067, 83068, 83069, 83087, 83139, 83140, 83141, 83142, 83143, 83144, 83145, 83146, 83147, 83148, 83149, 83423);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES 
(74033, @ALLIANCE_SOLDIIER1, 1, 1, 1, 0, 0, -3757.38, -4533.05, 14.16, 3.62, 7, 0, 0, 100, 0, 0),
(74083, @ALLIANCE_SOLDIIER2, 1, 1, 1, 0, 0, -3757.38, -4533.05, 14.16, 3.62, 7, 0, 0, 100, 0, 0),
(74142, @ALLIANCE_SOLDIIER3, 1, 1, 1, 0, 0, -3757.38, -4533.05, 14.16, 3.62, 7, 0, 0, 100, 0, 0),
(80342, @ALLIANCE_SOLDIIER1, 1, 1, 1, 0, 0, -3754.36, -4539.13, 14.16, 5.13, 7, 0, 0, 100, 0, 0),
(83066, @ALLIANCE_SOLDIIER2, 1, 1, 1, 0, 0, -3754.36, -4539.13, 14.16, 5.13, 7, 0, 0, 100, 0, 0),
(83067, @ALLIANCE_SOLDIIER3, 1, 1, 1, 0, 0, -3754.36, -4539.13, 14.16, 5.13, 7, 0, 0, 100, 0, 0),
(83068, @ALLIANCE_SOLDIIER1, 1, 1, 1, 0, 0, -3749.54, -4540.25, 14.28, 3.34, 7, 0, 0, 100, 0, 0),
(83069, @ALLIANCE_SOLDIIER2, 1, 1, 1, 0, 0, -3749.54, -4540.25, 14.28, 3.34, 7, 0, 0, 100, 0, 0),
(83087, @ALLIANCE_SOLDIIER3, 1, 1, 1, 0, 0, -3749.54, -4540.25, 14.28, 3.34, 7, 0, 0, 100, 0, 0),
(83139, @ALLIANCE_SOLDIIER1, 1, 1, 1, 0, 0, -3742.10, -4536.85, 14.28, 3.64, 7, 0, 0, 100, 0, 0),
(83140, @ALLIANCE_SOLDIIER2, 1, 1, 1, 0, 0, -3742.10, -4536.85, 14.28, 3.64, 7, 0, 0, 100, 0, 0),
(83141, @ALLIANCE_SOLDIIER3, 1, 1, 1, 0, 0, -3742.10, -4536.85, 14.28, 3.64, 7, 0, 0, 100, 0, 0),
(83142, @ALLIANCE_SOLDIIER1, 1, 1, 1, 0, 0, -3755.89, -4529.07, 14.05, 0.57, 7, 0, 0, 100, 0, 0),
(83143, @ALLIANCE_SOLDIIER2, 1, 1, 1, 0, 0, -3755.89, -4529.07, 14.05, 0.57, 7, 0, 0, 100, 0, 0),
(83144, @ALLIANCE_SOLDIIER3, 1, 1, 1, 0, 0, -3755.89, -4529.07, 14.05, 0.57, 7, 0, 0, 100, 0, 0),
(83145, @ALLIANCE_SOLDIIER1, 1, 1, 1, 0, 0, -3749.51, -4527.08, 14.07, 5.26, 7, 0, 0, 100, 0, 0),
(83146, @ALLIANCE_SOLDIIER2, 1, 1, 1, 0, 0, -3749.51, -4527.08, 14.07, 5.26, 7, 0, 0, 100, 0, 0),
(83147, @ALLIANCE_SOLDIIER3, 1, 1, 1, 0, 0, -3749.51, -4527.08, 14.07, 5.26, 7, 0, 0, 100, 0, 0),
(83148, @ALLIANCE_SOLDIIER1, 1, 1, 1, 0, 0, -3746.37, -4525.35, 14.16, 5.22, 7, 0, 0, 100, 0, 0),
(83149, @ALLIANCE_SOLDIIER2, 1, 1, 1, 0, 0, -3746.37, -4525.35, 14.16, 5.22, 7, 0, 0, 100, 0, 0),
(83423, @ALLIANCE_SOLDIIER3, 1, 1, 1, 0, 0, -3746.37, -4525.35, 14.16, 5.22, 7, 0, 0, 100, 0, 0);

DELETE FROM `pool_template` WHERE `entry` IN (368, 577, 578, 579, 580, 581, 582);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(368, 1, 'Injured alliance soldier for triage quest 1'),
(577, 1, 'Injured alliance soldier for triage quest 2'),
(578, 1, 'Injured alliance soldier for triage quest 3'),
(579, 1, 'Injured alliance soldier for triage quest 4'),
(580, 1, 'Injured alliance soldier for triage quest 5'),
(581, 1, 'Injured alliance soldier for triage quest 6'),
(582, 1, 'Injured alliance soldier for triage quest 7');

DELETE FROM `pool_members` WHERE `poolSpawnId` IN (368, 577, 578, 579, 580, 581, 582);
INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES
(0, 74033, 368, 0, "Injured alliance soldier1 for triage quest 1"),
(0, 74083, 368, 0, "Injured alliance soldier1 for triage quest 1"),
(0, 74142, 368, 0, "Injured alliance soldier1 for triage quest 1"),
(0, 80342, 577, 0, "Injured alliance soldier1 for triage quest 2"),
(0, 83066, 577, 0, "Injured alliance soldier1 for triage quest 2"),
(0, 83067, 577, 0, "Injured alliance soldier1 for triage quest 2"),
(0, 83068, 578, 0, "Injured alliance soldier1 for triage quest 3"),
(0, 83069, 578, 0, "Injured alliance soldier1 for triage quest 3"),
(0, 83087, 578, 0, "Injured alliance soldier1 for triage quest 3"),
(0, 83139, 579, 0, "Injured alliance soldier1 for triage quest 4"),
(0, 83140, 579, 0, "Injured alliance soldier1 for triage quest 4"),
(0, 83141, 579, 0, "Injured alliance soldier1 for triage quest 4"),
(0, 83142, 580, 0, "Injured alliance soldier1 for triage quest 5"),
(0, 83143, 580, 0, "Injured alliance soldier1 for triage quest 5"),
(0, 83144, 580, 0, "Injured alliance soldier1 for triage quest 5"),
(0, 83145, 581, 0, "Injured alliance soldier1 for triage quest 6"),
(0, 83146, 581, 0, "Injured alliance soldier1 for triage quest 6"),
(0, 83147, 581, 0, "Injured alliance soldier1 for triage quest 6"),
(0, 83148, 582, 0, "Injured alliance soldier1 for triage quest 7"),
(0, 83149, 582, 0, "Injured alliance soldier1 for triage quest 7"),
(0, 83423, 582, 0, "Injured alliance soldier1 for triage quest 7");

DELETE FROM `spawn_group_template` WHERE `groupId` IN (69,70);
INSERT INTO `spawn_group_template` (`groupId`, `groupName`, `groupFlags`) VALUES
(69,"Injured alliance soldiers - Triage quest",4),
(70,"Injured horde soldiers - Triage quest",4);

DELETE FROM `spawn_group` WHERE `groupId` IN (69,70) AND `spawnType` = 0;
INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES
-- Allinace
(69,0,74033),
(69,0,74083),
(69,0,74142),
(69,0,80342),
(69,0,83066),
(69,0,83067),
(69,0,83068),
(69,0,83069),
(69,0,83087),
(69,0,83139),
(69,0,83140),
(69,0,83141),
(69,0,83142),
(69,0,83143),
(69,0,83144),
(69,0,83145),
(69,0,83146),
(69,0,83147),
(69,0,83148),
(69,0,83149),
(69,0,83423);
-- Horde
-- (70,0,@CGUID+00),
-- (70,0,@CGUID+01),
-- (70,0,@CGUID+02),
-- (70,0,@CGUID+03),
-- (70,0,@CGUID+04),
-- (70,0,@CGUID+05),
-- (70,0,@CGUID+06),
-- (70,0,@CGUID+07),
-- (70,0,@CGUID+08),
-- (70,0,@CGUID+09),
-- (70,0,@CGUID+10),
-- (70,0,@CGUID+11),
-- (70,0,@CGUID+12),
-- (70,0,@CGUID+13),
-- (70,0,@CGUID+14),
-- (70,0,@CGUID+15),
-- (70,0,@CGUID+16),
-- (70,0,@CGUID+17),
-- (70,0,@CGUID+18),
-- (70,0,@CGUID+19),
-- (70,0,@CGUID+20);




DELETE FROM `creature_text` WHERE `CreatureID` IN(12938, 12936, 12937, 12923, 12924, 12925, 12939);
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `comment`, `BroadcastTextId`) VALUES
(12939, 0, 0, "I regret to inform you that you have failed your examination, doctor.", 12, 0, 100, 0, 0, 0, "Doctor Gustaf VanHowzen", 8363),
(12938, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12938, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12938, 0, 2, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC3', 8362),
(12938, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12938, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12938, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12938, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12938, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12938, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12938, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12938, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12938, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12936, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12936, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12936, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC3', 8362),
(12936, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12936, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12936, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12936, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12936, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12936, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12936, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12936, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12936, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12937, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12937, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12937, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC3', 8362),
(12937, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12937, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12937, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12937, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12937, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12937, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12937, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12937, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12937, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12923, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12923, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12923, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC3', 8362),
(12923, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12923, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12923, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12923, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12923, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12923, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12923, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12923, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12923, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12924, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12924, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12924, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC4', 8362),
(12924, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12924, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12924, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12924, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12924, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12924, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12924, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12924, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12924, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12925, 0, 0, 'I''m saved! Thank you, doctor!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC1', 8355),
(12925, 0, 1, 'HOORAY! I AM SAVED!', 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC2', 8359),
(12925, 0, 3, "The good doctor saves the day! HOORAY!", 12, 0, 100, 0, 0, 0, 'injured_patient SAY_DOC4', 8362),
(12925, 1, 0, 'Sweet, sweet embrace... take me...', 12, 0, 100, 0, 0, 0, 'injured_patient', 8361),
(12925, 1, 1, "Heeellp meee... ri... ribss... bro... broken.", 12, 0, 100, 0, 0, 0, 'injured_patient', 8352),
(12925, 1, 2, "Dying... See the light... gloriouss...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8353),
(12925, 1, 3, "I... I think I see Blue...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8354),
(12925, 1, 4, "My entrails are leaking out! HELP!", 12, 0, 100, 0, 0, 0, 'injured_patient', 8356),
(12925, 1, 5, "I'm not gonna make it... death comes...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8357),
(12925, 1, 6, "Goodbye, cruel world... I'm leavin' you today... goodbye... goodbye... goodbye...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8358),
(12925, 1, 7, "Brain encaved... mortar... bas... hed... leaking... dyin... g...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8360),
(12925, 1, 8, "Sweet, sweet embrace... take me...", 12, 0, 100, 0, 0, 0, 'injured_patient', 8361);

offl · 2022-11-08T15:58:18Z

Without SetActive they will spawn over and over again (grid unload doesn't stop spawning) and both fixes with spawn groups and SetActive caused problems and were reverted, that could be because both of them were complicated enough and something went wrong

CraftedRO · 2022-11-08T16:01:58Z

can't we make a "timed" action like ?

Killyana · 2022-11-08T16:09:01Z

There's no issue with spawns here, npcs are spawned on the DB, and will respawn via the pooling once the spawngroup activated and if the quest is completed or fail the spawngroup will be disabled.

offl · 2022-11-08T17:15:03Z

And if player leaves zone, script stops working, after grid unload spawn group will still be active, producing those spawns which will screw up newly created doctor's script by setting counter
Well, you can disable spawn group when doctors spawns

Killyana · 2022-11-08T17:17:21Z

That's a general issue with any script using a timed action list.

offl · 2022-11-08T17:27:28Z

Start quest
Leave zone
Unload grid
Return to zone
Here's your spawn group, still active

offl · 2022-11-08T17:42:05Z

Credit to vmangos

insert into `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `build`) values
(16042,12936,1,-3757.17,-4533.23,14.2505,5.11381,31727),
(501125,12938,1,-3757.17,-4533.23,14.2505,5.11381,35000),
(51229,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(43559,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(501113,12938,1,-3757.17,-4533.23,14.2505,5.11381,35000),
(154688,12938,1,-3757.17,-4533.23,14.2505,5.11381,32089),
(51236,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(13565,12938,1,-3757.17,-4533.23,14.2505,5.11381,31727),
(154679,12938,1,-3757.17,-4533.23,14.2505,5.11381,32089),
(29861,12938,1,-3757.17,-4533.23,14.2505,5.11381,31727),
(60656,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(18890,12938,1,-3757.17,-4533.23,14.2505,5.11381,31727),
(22578,12938,1,-3757.17,-4533.23,14.2505,5.11381,31727),
(65627,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(40037,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(653879,12937,1,-3757.17,-4533.23,14.2505,5.11381,36325),
(51248,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(501120,12937,1,-3757.17,-4533.23,14.2505,5.11381,35000),
(22569,12936,1,-3757.17,-4533.23,14.2505,5.11381,31727),
(51272,12937,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(22575,12936,1,-3757.17,-4533.23,14.2505,5.11381,31727),
(51244,12937,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(43548,12937,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(51258,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(43525,12936,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(43543,12936,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(43519,12937,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(43554,12936,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(40014,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(51268,12936,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(560021,12936,1,-3757.17,-4533.23,14.2505,5.11381,35753),
(41386,12936,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(501117,12936,1,-3757.17,-4533.23,14.2505,5.11381,35000),
(560056,12938,1,-3757.17,-4533.23,14.2505,5.11381,35753),
(51262,12938,1,-3757.17,-4533.23,14.2505,5.11381,31830),
(167857,12936,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(154628,12936,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(167852,12936,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(501121,12936,1,-3755.49,-4529.03,14.1116,0.418879,35000),
(41387,12936,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(40036,12936,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(51274,12936,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(560059,12936,1,-3755.49,-4529.03,14.1116,0.418879,35753),
(51251,12936,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(40013,12938,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(22580,12937,1,-3755.49,-4529.03,14.1116,0.418879,31727),
(51234,12936,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(13563,12937,1,-3755.49,-4529.03,14.1116,0.418879,31727),
(43547,12936,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(43520,12937,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(43522,12937,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(167853,12937,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(18903,12936,1,-3755.49,-4529.03,14.1116,0.418879,31727),
(51245,12937,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(51257,12938,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(22570,12938,1,-3755.49,-4529.03,14.1116,0.418879,31727),
(65624,12938,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(51239,12938,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(16043,12938,1,-3755.49,-4529.03,14.1116,0.418879,31727),
(167833,12938,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(167837,12938,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(167843,12938,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(167847,12938,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(167861,12938,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(167867,12938,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(29863,12938,1,-3755.49,-4529.03,14.1116,0.418879,31727),
(43541,12938,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(154691,12938,1,-3755.49,-4529.03,14.1116,0.418879,32089),
(43553,12938,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(501115,12938,1,-3755.49,-4529.03,14.1116,0.418879,35000),
(653882,12938,1,-3755.49,-4529.03,14.1116,0.418879,36325),
(51226,12938,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(51267,12938,1,-3755.49,-4529.03,14.1116,0.418879,31830),
(449074,12938,1,-3755.49,-4529.03,14.1116,0.418879,35000),
(560019,12938,1,-3755.49,-4529.03,14.1116,0.418879,35753),
(560053,12938,1,-3755.49,-4529.03,14.1116,0.418879,35753),
(40034,12936,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(51233,12936,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(560055,12938,1,-3754.35,-4539.17,14.2296,5.23599,35753),
(43557,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(51231,12936,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(41392,12936,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(653881,12938,1,-3754.35,-4539.17,14.2296,5.23599,36325),
(501123,12938,1,-3754.35,-4539.17,14.2296,5.23599,35000),
(501119,12938,1,-3754.35,-4539.17,14.2296,5.23599,35000),
(43551,12936,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(51249,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(51255,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(43545,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(51270,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(154697,12938,1,-3754.35,-4539.17,14.2296,5.23599,32089),
(43523,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(43518,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(13560,12938,1,-3754.35,-4539.17,14.2296,5.23599,31727),
(18893,12936,1,-3754.35,-4539.17,14.2296,5.23599,31727),
(40038,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(154677,12938,1,-3754.35,-4539.17,14.2296,5.23599,32089),
(29858,12938,1,-3754.35,-4539.17,14.2296,5.23599,31727),
(501114,12936,1,-3754.35,-4539.17,14.2296,5.23599,35000),
(65621,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(41384,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(51259,12937,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(16039,12938,1,-3754.35,-4539.17,14.2296,5.23599,31727),
(22568,12938,1,-3754.35,-4539.17,14.2296,5.23599,31727),
(51264,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(22577,12937,1,-3754.35,-4539.17,14.2296,5.23599,31727),
(51238,12938,1,-3754.35,-4539.17,14.2296,5.23599,31830),
(154610,12936,1,-3754.35,-4539.17,14.2296,5.23599,32089),
(560023,12936,1,-3754.35,-4539.17,14.2296,5.23599,35753),
(167862,12938,1,-3754.07,-4532.92,11.9102,0.098056,32089),
(167937,12938,1,-3754.03,-4532.92,11.9102,0.098056,32089),
(167896,12937,1,-3754,-4532.92,11.9102,0.098056,32089),
(167909,12936,1,-3754,-4532.92,11.9102,0.098056,32089),
(167902,12938,1,-3752.59,-4530.17,11.9102,5.90965,32089),
(167898,12936,1,-3752.53,-4530.19,11.9102,5.90965,32089),
(168003,12936,1,-3752.5,-4530.2,11.9102,5.90965,32089),
(167916,12938,1,-3752.12,-4536.99,11.9102,0.774357,32089),
(40015,12938,1,-3752.1,-4536.97,11.9102,0.774357,31830),
(167906,12938,1,-3752.06,-4536.94,11.9102,0.774357,32089),
(167850,12938,1,-3750.84,-4532.6,11.9102,0.098056,32089),
(167935,12938,1,-3750.8,-4532.6,11.9102,0.098056,32089),
(167842,12938,1,-3750.79,-4532.6,11.9102,0.098056,32089),
(167836,12938,1,-3750.79,-4532.6,11.9102,0.098056,32089),
(168007,12938,1,-3750.78,-4532.6,11.9102,0.098056,32089),
(167997,12936,1,-3750.76,-4532.6,11.9102,0.098056,32089),
(167866,12938,1,-3750.74,-4532.59,11.9102,0.098056,32089),
(167995,12936,1,-3750.73,-4532.59,11.9102,0.098056,32089),
(154692,12937,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(51260,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(167844,12938,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(167900,12938,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(167848,12938,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(22574,12938,1,-3749.98,-4540.12,14.3408,3.54302,31727),
(167910,12938,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(167890,12938,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(501108,12936,1,-3749.98,-4540.12,14.3408,3.54302,35000),
(18897,12938,1,-3749.98,-4540.12,14.3408,3.54302,31727),
(154676,12937,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(167924,12938,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(167929,12938,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(16038,12938,1,-3749.98,-4540.12,14.3408,3.54302,31727),
(41385,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(167934,12938,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(167855,12938,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(51250,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(167893,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(65622,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(167887,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(51237,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(167884,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(167869,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(22567,12936,1,-3749.98,-4540.12,14.3408,3.54302,31727),
(167864,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(167841,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(167835,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(29864,12938,1,-3749.98,-4540.12,14.3408,3.54302,31727),
(167832,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(168005,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(43544,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(43552,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(43516,12936,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(168000,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(43524,12936,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(51253,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(653883,12938,1,-3749.98,-4540.12,14.3408,3.54302,36325),
(51227,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(51265,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(501118,12938,1,-3749.98,-4540.12,14.3408,3.54302,35000),
(167992,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(449075,12938,1,-3749.98,-4540.12,14.3408,3.54302,35000),
(40035,12936,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(560054,12938,1,-3749.98,-4540.12,14.3408,3.54302,35753),
(560020,12938,1,-3749.98,-4540.12,14.3408,3.54302,35753),
(167996,12936,1,-3749.98,-4540.12,14.3408,3.54302,32089),
(51271,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(51275,12938,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(51243,12936,1,-3749.98,-4540.12,14.3408,3.54302,31830),
(168001,12936,1,-3749.79,-4534.71,11.9102,0.774357,32089),
(167933,12938,1,-3749.75,-4534.68,11.9102,0.774357,32089),
(167911,12938,1,-3749.75,-4534.67,11.9102,0.774357,32089),
(168006,12937,1,-3749.71,-4534.64,11.9102,0.774357,32089),
(167860,12937,1,-3749.7,-4534.62,11.9102,0.774357,32089),
(167936,12936,1,-3749.53,-4531.37,11.9102,5.90965,32089),
(501109,12938,1,-3749.51,-4531.38,11.9102,5.90965,35000),
(167886,12936,1,-3749.5,-4531.38,11.9102,5.90965,32089),
(168010,12936,1,-3749.5,-4531.38,11.9102,5.90965,32089),
(167907,12936,1,-3749.5,-4531.38,11.9102,5.90965,32089),
(167889,12937,1,-3749.48,-4531.39,11.9102,5.90965,32089),
(154696,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(43521,12938,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(13564,12938,1,-3749.35,-4527.15,14.1672,5.14872,31727),
(41390,12936,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(43555,12936,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(154678,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(43549,12936,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(167938,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(16045,12938,1,-3749.35,-4527.15,14.1672,5.14872,31727),
(51254,12936,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(449076,12938,1,-3749.35,-4527.15,14.1672,5.14872,35000),
(29865,12936,1,-3749.35,-4527.15,14.1672,5.14872,31727),
(29860,12936,1,-3749.35,-4527.15,14.1672,5.14872,31727),
(167931,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(51228,12936,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(43542,12938,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(167915,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(51232,12938,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(43560,12938,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(167845,12936,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(22579,12938,1,-3749.35,-4527.15,14.1672,5.14872,31727),
(167905,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(51242,12938,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(167859,12936,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(167895,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(40032,12938,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(167882,12936,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(22566,12938,1,-3749.35,-4527.15,14.1672,5.14872,31727),
(51276,12936,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(65625,12938,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(167891,12936,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(501122,12937,1,-3749.35,-4527.15,14.1672,5.14872,35000),
(167888,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(167868,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(51269,12938,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(167994,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(168002,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(501112,12938,1,-3749.35,-4527.15,14.1672,5.14872,35000),
(167925,12936,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(167927,12936,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(167928,12936,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(18886,12936,1,-3749.35,-4527.15,14.1672,5.14872,31727),
(167830,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(154616,12936,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(167851,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(167863,12937,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(653884,12938,1,-3749.35,-4527.15,14.1672,5.14872,36325),
(51246,12936,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(167998,12937,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(167839,12938,1,-3749.35,-4527.15,14.1672,5.14872,32089),
(40039,12937,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(51261,12938,1,-3749.35,-4527.15,14.1672,5.14872,31830),
(560057,12936,1,-3749.35,-4527.15,14.1672,5.14872,35753),
(560043,12938,1,-3749.35,-4527.15,14.1672,5.14872,35753),
(167903,12937,1,-3748.27,-4532.35,11.9102,0.098056,32089),
(167856,12938,1,-3748.27,-4532.35,11.9102,0.098056,32089),
(167846,12938,1,-3748.27,-4532.35,11.9102,0.098056,32089),
(40012,12936,1,-3748.15,-4530.1,11.9102,5.09957,31830),
(167894,12938,1,-3747.99,-4532.95,11.9102,0.774357,32089),
(425649,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(449077,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(543496,12939,1,-3747.27,-4532.25,11.9935,0.418879,35395),
(544573,12939,1,-3747.27,-4532.25,11.9935,0.418879,35395),
(541263,12939,1,-3747.27,-4532.25,11.9935,0.418879,35395),
(560017,12939,1,-3747.27,-4532.25,11.9935,0.418879,35753),
(18898,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(560552,12939,1,-3747.27,-4532.25,11.9935,0.418879,35753),
(431651,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(427597,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(601936,12939,1,-3747.27,-4532.25,11.9935,0.418879,36035),
(413058,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(814889,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(16044,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(4524,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(443261,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(396568,12939,1,-3747.27,-4532.25,11.9935,0.418879,34911),
(409108,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(497630,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(260,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(215,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(27956,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(29862,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(423562,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(627204,12939,1,-3747.27,-4532.25,11.9935,0.418879,36231),
(13566,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(635682,12939,1,-3747.27,-4532.25,11.9935,0.418879,36231),
(640635,12939,1,-3747.27,-4532.25,11.9935,0.418879,36307),
(43400,12939,1,-3747.27,-4532.25,11.9935,0.418879,31830),
(51170,12939,1,-3747.27,-4532.25,11.9935,0.418879,31830),
(683671,12939,1,-3747.27,-4532.25,11.9935,0.418879,36325),
(399582,12939,1,-3747.27,-4532.25,11.9935,0.418879,34911),
(289721,12939,1,-3747.27,-4532.25,11.9935,0.418879,32089),
(678184,12939,1,-3747.27,-4532.25,11.9935,0.418879,36325),
(651947,12939,1,-3747.27,-4532.25,11.9935,0.418879,36325),
(266522,12939,1,-3747.27,-4532.25,11.9935,0.418879,32887),
(659285,12939,1,-3747.27,-4532.25,11.9935,0.418879,36325),
(40019,12939,1,-3747.27,-4532.25,11.9935,0.418879,31830),
(667125,12939,1,-3747.27,-4532.25,11.9935,0.418879,36325),
(65626,12939,1,-3747.27,-4532.25,11.9935,0.418879,31830),
(41391,12939,1,-3747.27,-4532.25,11.9935,0.418879,31830),
(60028,12939,1,-3747.27,-4532.25,11.9935,0.418879,31830),
(60424,12939,1,-3747.27,-4532.25,11.9935,0.418879,31830),
(48826,12939,1,-3747.27,-4532.25,11.9935,0.418879,31830),
(109485,12939,1,-3747.27,-4532.25,11.9935,0.418879,31882),
(735659,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(780119,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(6537,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(154617,12939,1,-3747.27,-4532.25,11.9935,0.418879,32089),
(22516,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(791996,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(791016,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(167920,12939,1,-3747.27,-4532.25,11.9935,0.418879,32089),
(6599,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(167872,12939,1,-3747.27,-4532.25,11.9935,0.418879,32089),
(775600,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(106643,12939,1,-3747.27,-4532.25,11.9935,0.418879,31882),
(25963,12939,1,-3747.27,-4532.25,11.9935,0.418879,31727),
(168011,12939,1,-3747.27,-4532.25,11.9935,0.418879,32089),
(120020,12939,1,-3747.27,-4532.25,11.9935,0.418879,31882),
(167762,12939,1,-3747.27,-4532.25,11.9935,0.418879,32089),
(757696,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(130003,12939,1,-3747.27,-4532.25,11.9935,0.418879,31882),
(835170,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(814146,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(167989,12939,1,-3747.27,-4532.25,11.9935,0.418879,32089),
(830481,12939,1,-3747.27,-4532.25,11.9935,0.418879,36714),
(501111,12939,1,-3747.27,-4532.25,11.9935,0.418879,35000),
(43558,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(51230,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(43550,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(43517,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(29859,12938,1,-3742.9,-4536.82,14.313,0.244346,31727),
(16040,12938,1,-3742.9,-4536.82,14.313,0.244346,31727),
(22576,12938,1,-3742.9,-4536.82,14.313,0.244346,31727),
(22571,12938,1,-3742.9,-4536.82,14.313,0.244346,31727),
(51247,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(560052,12937,1,-3742.9,-4536.82,14.313,0.244346,35753),
(167930,12937,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167923,12937,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167908,12937,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167883,12937,1,-3742.9,-4536.82,14.313,0.244346,32089),
(51256,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(167999,12937,1,-3742.9,-4536.82,14.313,0.244346,32089),
(43532,12937,1,-3742.9,-4536.82,14.313,0.244346,31830),
(13559,12937,1,-3742.9,-4536.82,14.313,0.244346,31727),
(560058,12936,1,-3742.9,-4536.82,14.313,0.244346,35753),
(167914,12936,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167912,12936,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167897,12936,1,-3742.9,-4536.82,14.313,0.244346,32089),
(51266,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(167854,12936,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167831,12936,1,-3742.9,-4536.82,14.313,0.244346,32089),
(168004,12936,1,-3742.9,-4536.82,14.313,0.244346,32089),
(51273,12936,1,-3742.9,-4536.82,14.313,0.244346,31830),
(51252,12936,1,-3742.9,-4536.82,14.313,0.244346,31830),
(51241,12936,1,-3742.9,-4536.82,14.313,0.244346,31830),
(51235,12936,1,-3742.9,-4536.82,14.313,0.244346,31830),
(43546,12936,1,-3742.9,-4536.82,14.313,0.244346,31830),
(154611,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(40033,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(501110,12938,1,-3742.9,-4536.82,14.313,0.244346,35000),
(501116,12938,1,-3742.9,-4536.82,14.313,0.244346,35000),
(501124,12938,1,-3742.9,-4536.82,14.313,0.244346,35000),
(167932,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167926,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(449078,12938,1,-3742.9,-4536.82,14.313,0.244346,35000),
(560016,12938,1,-3742.9,-4536.82,14.313,0.244346,35753),
(65628,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(653880,12938,1,-3742.9,-4536.82,14.313,0.244346,36325),
(167901,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(41388,12938,1,-3742.9,-4536.82,14.313,0.244346,31830),
(167892,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167993,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167885,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167865,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167858,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167849,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(154675,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167834,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(167840,12938,1,-3742.9,-4536.82,14.313,0.244346,32089),
(826097,12924,0,-1021.22,-3499.24,63.0733,4.38078,36714),
(189872,12923,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(826087,12925,0,-1021.22,-3499.24,63.0733,4.38078,36714),
(826092,12924,0,-1021.22,-3499.24,63.0733,4.38078,36714),
(189882,12923,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(189892,12923,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(177716,12923,0,-1021.22,-3499.24,63.0733,4.38078,32421),
(189899,12923,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(177704,12925,0,-1021.22,-3499.24,63.0733,4.38078,32421),
(189909,12923,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(177722,12923,0,-1021.22,-3499.24,63.0733,4.38078,32421),
(189913,12923,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(177708,12924,0,-1021.22,-3499.24,63.0733,4.38078,32421),
(826086,12923,0,-1021.22,-3499.24,63.0733,4.38078,36714),
(189886,12925,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(189928,12924,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(476089,12923,0,-1021.22,-3499.24,63.0733,4.38078,35000),
(189852,12923,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(189932,12924,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(476098,12924,0,-1021.22,-3499.24,63.0733,4.38078,35000),
(476102,12923,0,-1021.22,-3499.24,63.0733,4.38078,35000),
(189857,12923,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(490760,12923,0,-1021.22,-3499.24,63.0733,4.38078,35000),
(189865,12923,0,-1021.22,-3499.24,63.0733,4.38078,32600),
(476095,12923,0,-1019.54,-3494.92,62.8864,4.39823,35000),
(189861,12923,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(189930,12924,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(476101,12924,0,-1019.54,-3494.92,62.8864,4.39823,35000),
(177712,12925,0,-1019.54,-3494.92,62.8864,4.39823,32421),
(189915,12923,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(826088,12923,0,-1019.54,-3494.92,62.8864,4.39823,36714),
(826093,12923,0,-1019.54,-3494.92,62.8864,4.39823,36714),
(189895,12925,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(826100,12923,0,-1019.54,-3494.92,62.8864,4.39823,36714),
(476106,12924,0,-1019.54,-3494.92,62.8864,4.39823,35000),
(189900,12925,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(189905,12925,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(490759,12924,0,-1019.54,-3494.92,62.8864,4.39823,35000),
(177723,12924,0,-1019.54,-3494.92,62.8864,4.39823,32421),
(189812,12924,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(177717,12923,0,-1019.54,-3494.92,62.8864,4.39823,32421),
(826085,12924,0,-1019.54,-3494.92,62.8864,4.39823,36714),
(189924,12925,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(189856,12924,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(189893,12924,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(177705,12923,0,-1019.54,-3494.92,62.8864,4.39823,32421),
(189868,12923,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(476088,12924,0,-1019.54,-3494.92,62.8864,4.39823,35000),
(189888,12924,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(189883,12924,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(189878,12924,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(189876,12924,0,-1019.54,-3494.92,62.8864,4.39823,32600),
(189808,12923,0,-1019,-3508.5,62.9518,4.94752,32600),
(189866,12924,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(476105,12924,0,-1017.77,-3490.76,62.7042,4.20624,35000),
(189933,12923,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(189871,12923,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(189862,12924,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(189860,12924,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(490761,12924,0,-1017.77,-3490.76,62.7042,4.20624,35000),
(826098,12924,0,-1017.77,-3490.76,62.7042,4.20624,36714),
(476096,12923,0,-1017.77,-3490.76,62.7042,4.20624,35000),
(189810,12924,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(189879,12923,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(177725,12923,0,-1017.77,-3490.76,62.7042,4.20624,32421),
(189898,12924,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(476087,12924,0,-1017.77,-3490.76,62.7042,4.20624,35000),
(177711,12923,0,-1017.77,-3490.76,62.7042,4.20624,32421),
(189926,12924,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(826084,12924,0,-1017.77,-3490.76,62.7042,4.20624,36714),
(189891,12923,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(189922,12925,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(189904,12924,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(826089,12923,0,-1017.77,-3490.76,62.7042,4.20624,36714),
(177718,12923,0,-1017.77,-3490.76,62.7042,4.20624,32421),
(177703,12924,0,-1017.77,-3490.76,62.7042,4.20624,32421),
(189908,12924,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(189853,12923,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(189914,12924,0,-1017.77,-3490.76,62.7042,4.20624,32600),
(189906,12924,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(177707,12925,0,-1017.3,-3500.71,63.0648,4.32842,32421),
(189921,12924,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(189887,12923,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(177714,12924,0,-1017.3,-3500.71,63.0648,4.32842,32421),
(189903,12924,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(189910,12925,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(826081,12923,0,-1017.3,-3500.71,63.0648,4.32842,36714),
(177721,12924,0,-1017.3,-3500.71,63.0648,4.32842,32421),
(189880,12923,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(189874,12924,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(490758,12923,0,-1017.3,-3500.71,63.0648,4.32842,35000),
(476103,12923,0,-1017.3,-3500.71,63.0648,4.32842,35000),
(476091,12924,0,-1017.3,-3500.71,63.0648,4.32842,35000),
(189897,12924,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(189851,12924,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(476097,12924,0,-1017.3,-3500.71,63.0648,4.32842,35000),
(177709,12923,0,-1017.3,-3500.71,63.0648,4.32842,32421),
(826094,12924,0,-1017.3,-3500.71,63.0648,4.32842,36714),
(189858,12923,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(189864,12924,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(189870,12924,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(189927,12923,0,-1017.3,-3500.71,63.0648,4.32842,32600),
(826099,12923,0,-1017.3,-3500.71,63.0648,4.32842,36714),
(189931,12923,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(189925,12923,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(476104,12924,0,-1015.5,-3496.51,62.8805,4.20624,35000),
(189863,12925,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(189911,12923,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(189855,12923,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(476100,12924,0,-1015.5,-3496.51,62.8805,4.20624,35000),
(189901,12923,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(476092,12923,0,-1015.5,-3496.51,62.8805,4.20624,35000),
(826091,12923,0,-1015.5,-3496.51,62.8805,4.20624,36714),
(177719,12923,0,-1015.5,-3496.51,62.8805,4.20624,32421),
(826095,12923,0,-1015.5,-3496.51,62.8805,4.20624,36714),
(177713,12924,0,-1015.5,-3496.51,62.8805,4.20624,32421),
(189885,12923,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(189867,12923,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(826083,12924,0,-1015.5,-3496.51,62.8805,4.20624,36714),
(189881,12923,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(177710,12923,0,-1015.5,-3496.51,62.8805,4.20624,32421),
(189811,12924,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(189896,12924,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(189873,12923,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(189889,12924,0,-1015.5,-3496.51,62.8805,4.20624,32600),
(490762,12923,0,-1015.5,-3496.51,62.8805,4.20624,35000),
(177706,12923,0,-1015.5,-3496.51,62.8805,4.20624,32421),
(189877,12923,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(189884,12923,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(189890,12923,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(177720,12925,0,-1013.76,-3492.57,62.7069,4.20624,32421),
(189859,12923,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(189907,12923,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(189854,12925,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(490763,12924,0,-1013.76,-3492.57,62.7069,4.20624,35000),
(189929,12923,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(189934,12923,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(476090,12923,0,-1013.76,-3492.57,62.7069,4.20624,35000),
(476099,12923,0,-1013.76,-3492.57,62.7069,4.20624,35000),
(177724,12923,0,-1013.76,-3492.57,62.7069,4.20624,32421),
(189923,12924,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(826090,12923,0,-1013.76,-3492.57,62.7069,4.20624,36714),
(826096,12923,0,-1013.76,-3492.57,62.7069,4.20624,36714),
(189912,12925,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(177715,12924,0,-1013.76,-3492.57,62.7069,4.20624,32421),
(189902,12924,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(189809,12924,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(189894,12924,0,-1013.76,-3492.57,62.7069,4.20624,32600),
(177702,12923,0,-1013.76,-3492.57,62.7069,4.20624,32421),
(826082,12925,0,-1013.76,-3492.57,62.7069,4.20624,36714),
(189869,12923,0,-1013.76,-3492.57,62.7069,4.20624,32600);

Killyana · 2022-11-09T18:47:28Z

Spawngroup doesn't support pooling (all spawns inside the group will be spawned and ignore the pool) So kinda sucks

ghost · 2024-02-25T00:17:00Z

75e38a5 2024-02-24 21:55:13 +0100 - The main issue I have experienced on current core is that the timer runs out way faster than the duration of the triage bandage spell cast time (7 seconds).

Expand or minimize code snippets and mistaken theory

Looking at the script code in npcs_special.cpp (as linked below),

TrinityCore/src/server/scripts/World/npcs_special.cpp

Lines 607 to 620 in 75e38a5

    
           void Initialize() 
        
           { 
        
               PlayerGUID.Clear(); 
        
               SummonPatientTimer = 10000; 
        
               SummonPatientCount = 0; 
        
               PatientDiedCount = 0; 
        
               PatientSavedCount = 0; 
        
               Patients.clear(); 
        
               Coordinates.clear(); 
        
               Event = false; 
        
           }

TrinityCore/src/server/scripts/World/npcs_special.cpp

Lines 640 to 662 in 75e38a5

    
           void BeginEvent(Player* player) 
        
           { 
        
               PlayerGUID = player->GetGUID(); 
        
               SummonPatientTimer = 10000; 
        
               SummonPatientCount = 0; 
        
               PatientDiedCount = 0; 
        
               PatientSavedCount = 0; 
        
               switch (me->GetEntry()) 
        
               { 
        
                   case DOCTOR_ALLIANCE: 
        
                       for (uint8 i = 0; i < ALLIANCE_COORDS; ++i) 
        
                           Coordinates.push_back(&AllianceCoords[i]); 
        
                       break; 
        
                   case DOCTOR_HORDE: 
        
                       for (uint8 i = 0; i < HORDE_COORDS; ++i) 
        
                           Coordinates.push_back(&HordeCoords[i]); 
        
                       break; 
        
               } 
        
               Event = true; 
        
               me->SetUnitFlag(UNIT_FLAG_UNINTERACTIBLE);

TrinityCore/src/server/scripts/World/npcs_special.cpp

Lines 780 to 794 in 75e38a5

    
           switch (mobId) 
        
           {                                                   //lower max health 
        
               case 12923: 
        
               case 12938:                                     //Injured Soldier 
        
                   me->SetHealth(me->CountPctFromMaxHealth(75)); 
        
                   break; 
        
               case 12924: 
        
               case 12936:                                     //Badly injured Soldier 
        
                   me->SetHealth(me->CountPctFromMaxHealth(50)); 
        
                   break; 
        
               case 12925: 
        
               case 12937:                                     //Critically injured Soldier 
        
                   me->SetHealth(me->CountPctFromMaxHealth(25)); 
        
                   break; 
        
           }

there seems to be a possible explanation that the way it currently works is that the 10000ms (10s) seems to be directly affected by the hp percentages of each patient, because the critically injured patient dies after approximately 2.5s (25% of expected time), the badly injured patient dies after 5s (50% of expected time) and lastly the injured patient dies after 7.5s (75% of expected time). There could in theory be enough time to save the normal injured patient if the player had automatically selected the NPC upon spawning, and use all available time to cast spell https://aowow.trinitycore.info/?spell=20804/triage with an already assigned keyboard button to press for max efficiency.

Maybe this is just a theory on thin ice, I contemplated changing the timer from 10000 ms initially to 40000 to make it end up on 10000 when reduced to 25%. I am not at all sure if that calculation works as intended, if the normal injured patient should be alive for 30s and the badly injured patient should be alive for 20s, that sounds a bit much to me, but perhaps just changing the script and testing it could change my mind when observing ingame.

edit: No, the SummonPatientTimer value only affects time before the triage starts and between each soldier patient. Also tested if it would help to reduce the hp decay factor value in ModifyHealth(-5) to only -1, but that only highlights the fact that the NPC npc_injured_patient is unaffected by the code me->SetUnitFlag(UNIT_FLAG_IN_COMBAT); and that the hp seems to bounce back up towards 100%.

I must conclude like several others above, this script needs a full rewrite, because there are multiple issues with the script, especially that it is very old and outdated in its current format.

saligin · 2024-05-22T12:50:31Z

It seems like no one has fixed the bug in TrinityCore yet. It's been 6 years since the issue was reported, but it looks like AzerothCore has already resolved this bug. When will this bug be fixed in TrinityCore? Does anyone have a temporary solution?

CraftedRO · 2024-05-22T13:09:59Z

actually as you can see above someone actually tried to fix this in SAI but because missing a core functionallity that fix won't properly work, we don't care about your crapzerothcore that's actually full of hack-fixes and garbage overall.

heyitsbench · 2024-05-22T13:15:17Z

[...] we don't care about your crapzerothcore that's actually full of hack-fixes and garbage overall.

We get it.

github-actions bot added the Branch-3.3.5a label Sep 3, 2020

offl added the Comp-C++Script label Sep 3, 2020

offl mentioned this issue Aug 12, 2021

Quest: Triage (Alliance) - 1 spawn faces wrong direction #26802

Closed

Killyana mentioned this issue Nov 9, 2022

Quest ID 6622 Triage - They die right away #27830

Closed

Killyana mentioned this issue Nov 18, 2022

Core/Spawn: Make SpawnGroup respect the pool #28549

Open

This was referenced Mar 11, 2023

Alliance First Aid Quest #28855

Closed

Triage Bug Ally & Horde #28857

Closed

Quest: Triage #25387

Quest: Triage #25387

Comments

schell244 commented Sep 3, 2020 • edited by offl Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

offl commented Sep 3, 2020 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

Rushor commented Sep 9, 2020

Uh oh!

ghost commented Oct 1, 2020

Uh oh!

offl commented Jan 7, 2021 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

ghost commented Jun 29, 2022 • edited by ghost Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

CraftedRO commented Nov 6, 2022

Uh oh!

Killyana commented Nov 7, 2022 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

Killyana commented Nov 8, 2022 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

offl commented Nov 8, 2022

Uh oh!

CraftedRO commented Nov 8, 2022

Uh oh!

Killyana commented Nov 8, 2022

Uh oh!

offl commented Nov 8, 2022

Uh oh!

Killyana commented Nov 8, 2022

Uh oh!

offl commented Nov 8, 2022

Uh oh!

offl commented Nov 8, 2022

Uh oh!

Killyana commented Nov 9, 2022

Uh oh!

ghost commented Feb 25, 2024 • edited by ghost Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

saligin commented May 22, 2024

Uh oh!

CraftedRO commented May 22, 2024

Uh oh!

heyitsbench commented May 22, 2024

Uh oh!

schell244 commented Sep 3, 2020 •

edited by offl

Loading

offl commented Sep 3, 2020 •

edited

Loading

offl commented Jan 7, 2021 •

edited

Loading

ghost commented Jun 29, 2022 •

edited by ghost

Loading

Killyana commented Nov 7, 2022 •

edited

Loading

Killyana commented Nov 8, 2022 •

edited

Loading

ghost commented Feb 25, 2024 •

edited by ghost

Loading