Trinitycore: [3.3.5] Transllation to Ello - Stitches does not spawn

[TerrorBringer]

Description:

Upon completing quest https://www.wowhead.com/quest=252/translation-to-ello, Stitches -https://www.wowhead.com/npc=412/stitches should spawn near Raven Hill. He does not spawn upon completing the quest.

Branch(es):

3.3.5

TC rev. hash/commit:
https://github.com/TrinityCore/TrinityCore/commit/073ba8ee5fb9dacfe6149e43f17754d73d418a57

Operating system: Windows 10 x64

[illfated]

Related cases:

• [3.3.5][Quest] Completion of "Translation_to_Ello" does not spawn Stitches #16514 (Closed)
• [3.3.5][6.x] Core/Creature: Active Grid Load for creatures #16455 (Open / "how to keep creatures moving with no players around")
• Core/SAI: keep a creature active while it's executing an ActionList #20710 (Open)

---

edit: At the time of issue #22186 (2018-07-21) I had started doing all the quests in Duskwood on my journey to discover the human race quest lines level 1-35 (up to and including Theramore Isle). I noticed all the references to something bad going to happen to Darkshire in relation to

• https://wow.gamepedia.com/Quest:The_Hermit_(old)
• https://wow.gamepedia.com/Quest:The_Embalmer%27s_Revenge
• https://wow.gamepedia.com/Abercrombie

I never saw those references leading to anything actually happening in the game, but at the time I was more focused on checking the functionality of the questline https://wow.gamepedia.com/Quest:The_Legend_of_Stalvan before going on to Theramore Isle. As a consequence, I can confirm that I never saw Stitches around at the time (5 weeks ago), so he was not spawned then either.

Looking back through the issues listed above, I can understand why it is difficult to script the spawning of a creature which should be moving on its own ("the Fel Reaver of Duskwood", as someone on wowhead.com titled the monster), as long as the server is running and even if there is no player nearby or even in the entire map.

[Killyana]

https://wow.gamepedia.com/Stitches

Notes:
Prior to Patch 4.0.3, Stitches was spawned behind Abercrombie's shack, northeast of the Raven Hill Cemetery, after completing A [30] Translation to Ello. Stitches would then patrol down the road through Duskwood to Darkshire. This triggered an event, spawning two sets of Night Watch guards to defend the road to Darkshire, one at the camp across from the Vul'Gol Ogre Mound, and another outside of The Rotting Orchard. Without player aid, Stitches would decimate both sets of guards, and continue to Darkshire. It was highly common for players to die to Stitches, due to him being an Elite Level 35 mob in an at the time Level 18-30 zone.

According to comments he must be neutral till he got to the road, not sure if he must be attackable when he's neutral.

https://github.com/cmangos/classic-db/commit/e34db074d40ba66a37b99cba027d88209ab88f25

[Killyana]

There's 2 solutions:

• Summon the npc when the quest is rewarded and in this case we must find a way to avoid a second spawn if Stitches is still alive.

• Spawn Stitches an make it invisible an not attackable, once the quest rewarde the invisibility and not attackable will be remove an the npc start the waypoint.

The second solution is easier to avoid a second spawn.

Note: faction before reaching the road is 7 and 93 one the roa reached

[ZenoX92]

The problems is that the quest is turned in too far from where Stitches is suppose to spawn. If you use the first solution (which is the current script), Stitches won't spawn unless there's a player near to Abercrombie's shack (because of the grid activity).

The second solution seems a lot better (maybe adding a permanent spawn for Stitches with phasemask 2), but I'm not sure if some SAI (probably SMART_ACTION_SET_DATA) could be used between NPCs that are too far from each other. I will test it and give feedback.

[ZenoX92]

As I feared, SMART_ACTION_SET_DATA is not working.

[ZenoX92]

I think I have a better idea. What if we create a game event for this?

This could be a start:
``sql -- Stitches Event DELETE FROMgame_eventWHEREeventEntry=78; INSERT INTOgame_event(eventEntry,start_time,end_time,occurence,length,holiday,holidayStage,description,world_event,announce`) VALUES
(78,NULL,NULL,5184000,2592000,0,0,"Stitches Event",0,2);

-- Stitches
SET @GUID := 300000; -- Find an appropriate guid here
DELETE FROM creature WHERE guid=@GUID;
INSERT INTO creature (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) VALUES
(@GUID,412,0,0,0,1,1,0,0,-10290.2,72.7811,38.8811,4.8015,300,0,0,12200,0,0,0,0,0,"",0);

DELETE FROM game_event_creature WHERE eventEntry=78;
INSERT INTO game_event_creature (eventEntry, guid) VALUES
(78,@GUID);

DELETE FROM smart_scripts WHERE entryorguid=412 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, event_param5, 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
(412,0,0,0,0,0,100,0,6900,12100,3500,11300,0,11,3106,0,0,0,0,0,2,0,0,0,0,0,0,0,"Stitches - In Combat - Cast 'Aura of Rot'"),
(412,0,1,0,11,0,100,0,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stitches - On Respawn - Set Active On"),
(412,0,2,0,11,0,100,0,0,0,0,0,0,53,1,412,0,0,0,2,1,0,0,0,0,0,0,0,"Stitches - On Respawn - Start Waypoint"),
(412,0,3,0,6,0,100,0,0,0,0,0,0,111,78,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stitches - On Just Died - Stop Game Event 'Stitches'");

-- Lord Ello Ebonlocke
DELETE FROM smart_scripts WHERE entryorguid=263 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid IN (26300, 26301) 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
(263,0,0,0,25,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Reset - Set Event Phase 1"),
(263,0,1,0,1,1,100,0,20000,30000,110000,130000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - Out of Combat - Say Line 0 (Phase 1)"),
(263,0,2,0,20,1,100,0,252,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Quest 'Translation to Ello' Finished - Set Active On (Phase 1)"),
(263,0,3,0,20,1,100,0,252,0,0,0,80,26300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Quest 'Translation to Ello' Finished - Run Script 1 (Phase 1)"),
(263,0,4,0,69,0,100,0,78,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Game Event 'Stitches' End - Set Event Phase 1"),
(263,0,5,0,69,0,100,0,78,0,0,0,48,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Game Event 'Stitches' End - Set Active Off"),
(26300,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,"Lord Ello Ebonlocke - On Script 1 - Set Event Phase 0"),
(26300,9,1,0,0,0,100,0,0,0,0,0,112,78,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Script 1 - Start Game Event 'Stitches'");

[Aokromes]

i remember one mob spawning on quest take on the entrance of black moras...

[Killyana]

I tested the script, Stitches will still not start the waypoint if the area is not active.

[Killyana]

I also got this runtime DB error:
SmartScript::ProcessAction: At case SMART_ACTION_GAME_EVENT_STOP, inactive event (id: 78)

[ZenoX92]

Yes. He's not moving. I thought it could work. :(

I will script the rest of the event, and then hope for another miracle.

[Killyana]

Upon killed the npc will despawn as the event will end, so it couln't be looted.

[Killyana]

``sql -- Stitches Event DELETE FROMgame_eventWHEREeventEntry=85; INSERT INTOgame_event(eventEntry,start_time,end_time,occurence,length,holiday,holidayStage,description,world_event,announce`) VALUES
(85,"2011-03-22 01:00:00","2030-12-31 07:00:00",5184000,30,0,0,"Stitches Event",0,2);

-- Stitches
SET @GUID := 128980;
DELETE FROM creature WHERE guid=@GUID;
INSERT INTO creature (guid, id, map, zoneId, areaId, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, wander_distance, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, ScriptName, VerifiedBuild) VALUES
(@GUID,412,0,0,0,1,1,0,0,-10290.2,72.7811,38.8811,4.8015,5,0,0,12200,0,0,0,0,0,"",0);

DELETE FROM game_event_creature WHERE eventEntry=85;
INSERT INTO game_event_creature (eventEntry, guid) VALUES
(85,@GUID);

DELETE FROM smart_scripts WHERE entryorguid=412 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, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o, comment) VALUES
(412, 0, 0, 0, 0, 0, 100, 0, 6900, 12100, 3500, 11300, 0, 11, 3106, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Stitches - In Combat - Cast 'Aura of Rot'"),
(412, 0, 1, 2, 11, 0, 100, 0, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Stitches - On Just Summoned - Set Active On"),
(412, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 53, 1, 412, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Stitches - On Just Summoned - Start Waypoint"),
(412, 0, 3, 0, 1, 0, 100, 0, 30000, 40000, 30000, 40000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Stitches - ooc - Say Line 0"),
(412, 0, 4, 5, 58, 0, 100, 0, 0, 412, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Stitches - On Waypoint ended - Set Home Position"),
(412, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 89, 20, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Stitches - On Waypoint ended - Start Random Movement"),
(412, 0, 6, 0, 36, 0, 100, 0, 0, 0, 0, 0, 0, 111, 85, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Stitches - On corpse removed - Stop Game Event 'Stitches'");

-- Lord Ello Ebonlocke
DELETE FROM smart_scripts WHERE entryorguid=263 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
(263,0,1,0,1,0,100,0,20000,30000,110000,130000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - Out of Combat - Say Line 0"),
(263,0,4,0,20,0,100,0,252,0,0,0,112,85,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Game Event 'Stitches' End - Start event 85");

[illfated]

Looks promising. Am I remembering this correctly, that SMART_ACTION_SET_DATA is working again?

---

edit: Never mind, I should have read the comment lines more closely.

[Rushor]

there is also some kind of event in between where stiches is running on the path towards the village

here: https://github.com/cmangos/classic-db/commit/b03ae1d191528ef9100dbef293840fd736281b9f

[Killyana]

I will maybe add this watchers spawns linked to the game_event instead of summon them

[ZenoX92]

This is what I have done so far:
``sql -- Stitches Event SET @STITCHESEVENT := 85; DELETE FROMgame_eventWHEREeventEntry=@STITCHESEVENT; INSERT INTOgame_event(eventEntry,start_time,end_time,occurence,length,holiday,holidayStage,description,world_event,announce`) VALUES
(@STITCHESEVENT,"2011-03-22 01:00:00","2030-12-31 07:00:00",5184000,30,0,0,"Stitches Event",0,2);

-- Stitches
SET @GUID := 300000;
DELETE FROM creature WHERE guid=@GUID;
INSERT INTO creature (guid, id, map, zoneId, areaId, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, wander_distance, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, ScriptName, VerifiedBuild) VALUES
(@GUID,412,0,0,0,1,1,0,0,-10290.2,72.7811,38.8811,4.8015,300,0,0,12200,0,0,0,0,0,"",0);

DELETE FROM creature_addon WHERE guid=@GUID;
INSERT INTO creature_addon (guid, path_id, mount, bytes1, bytes2, emote, visibilityDistanceType, auras) VALUES
(@GUID,0,0,0,0,0,5,"");

DELETE FROM game_event_creature WHERE eventEntry=@STITCHESEVENT;
INSERT INTO game_event_creature (eventEntry, guid) VALUES
(@STITCHESEVENT,@GUID),
(@STITCHESEVENT,86847),
(@STITCHESEVENT,86851),
(@STITCHESEVENT,86852),
(@STITCHESEVENT,86853),
(@STITCHESEVENT,86846),
(@STITCHESEVENT,86845),
(@STITCHESEVENT,86857);

UPDATE creature_template SET faction=7 WHERE entry=412;
DELETE FROM smart_scripts WHERE entryorguid=412 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, event_param5, 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
(412,0,0,0,0,0,100,0,6000,12000,6000,12000,0,11,3106,0,0,0,0,0,2,0,0,0,0,0,0,0,"Stitches - In Combat - Cast 'Aura of Rot'"),
(412,0,1,2,11,0,100,0,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stitches - On Respawn - Set Active On"),
(412,0,2,0,61,0,100,0,0,0,0,0,0,53,1,412,0,0,0,2,1,0,0,0,0,0,0,0,"Stitches - On Respawn - Start Waypoint"),
(412,0,3,0,36,0,100,0,0,0,0,0,0,111,85,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stitches - On Corpse Removed - Stop Game Event 'Stitches'"),
(412,0,4,0,40,0,100,0,36,412,0,0,0,2,93,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stitches - On Waypoint 36 Reached - Set Faction 93"),
(412,0,5,0,40,0,100,0,36,412,0,0,0,1,1,0,0,0,0,0,10,4185,468,0,0,0,0,0,"Stitches - On Waypoint 36 Reached - Say Line 1 (Town Crier)"),
(412,0,6,0,40,0,100,0,51,412,0,0,0,1,2,0,0,0,0,0,10,4185,468,0,0,0,0,0,"Stitches - On Waypoint 51 Reached - Say Line 2 (Town Crier)"),
(412,0,7,0,40,0,100,0,68,412,0,0,0,1,3,0,0,0,0,0,10,4185,468,0,0,0,0,0,"Stitches - On Waypoint 68 Reached - Say Line 3 (Town Crier)"),
(412,0,8,0,40,0,100,0,85,412,0,0,0,1,4,0,0,0,0,0,10,4185,468,0,0,0,0,0,"Stitches - On Waypoint 85 Reached - Say Line 4 (Town Crier)"),
(412,0,9,0,40,0,100,0,90,412,0,0,0,89,5,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stitches - On Waypoint 90 Reached - Start Random Movement"),
(412,0,10,0,6,0,100,0,0,0,0,0,0,1,5,0,0,0,0,0,10,4185,468,0,0,0,0,0,"Stitches - On Just Died - Say Line 5 (Town Crier)"),
(412,0,11,0,60,0,100,0,30000,40000,30000,40000,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stitches - Update - Say Line 0");

-- Lord Ello Ebonlocke
DELETE FROM smart_scripts WHERE entryorguid=263 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid IN (26300, 26301) 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
(263,0,0,0,25,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Reset - Set Event Phase 1"),
(263,0,1,0,1,1,100,0,20000,30000,110000,130000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - Out of Combat - Say Line 0 (Phase 1)"),
(263,0,2,0,20,1,100,0,252,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Quest 'Translation to Ello' Finished - Set Active On (Phase 1)"),
(263,0,3,0,20,1,100,0,252,0,0,0,80,26300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Quest 'Translation to Ello' Finished - Run Script 1 (Phase 1)"),
(263,0,4,0,20,0,100,0,252,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Quest 'Translation to Ello' Finished - Store Target"),
(263,0,5,0,38,0,100,0,1,1,0,0,80,26302,2,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Data Set - Run Script 2"),
(263,0,6,0,69,0,100,0,@STITCHESEVENT,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Game Event 'Stitches' End - Set Event Phase 1"),
(263,0,7,0,69,0,100,0,@STITCHESEVENT,0,0,0,48,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Game Event 'Stitches' End - Set Active Off"),
(26300,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,"Lord Ello Ebonlocke - On Script 1 - Set Event Phase 0"),
(26300,9,1,0,0,0,100,0,0,0,0,0,12,1436,8,0,0,0,0,8,0,0,0,-10604.2,-1179.31,27.995,0.16,"Lord Ello Ebonlocke - On Script 1 - Summon Creature 'Watcher Cutford'"),
(26301,9,0,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,19,1436,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Script 2 - Set Orientation"),
(26301,9,1,0,0,0,100,0,500,500,0,0,1,1,0,0,0,0,0,19,1436,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Script 2 - Say Line 1 (Watcher Cutford)"),
(26301,9,2,0,0,0,100,0,5000,5000,0,0,1,2,0,0,0,0,0,19,1436,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Script 2 - Say Line 2 (Watcher Cutford)"),
(26301,9,3,0,0,0,100,0,5000,5000,0,0,1,3,0,0,0,0,0,19,1436,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Script 2 - Say Line 3 (Watcher Cutford)"),
(26301,9,4,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,12,1,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Script 2 - Say Line 1"),
(26301,9,5,0,0,0,100,0,5000,5000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Script 2 - Say Line 2"),
(26301,9,6,0,0,0,100,0,5500,5500,0,0,1,4,0,0,0,0,0,19,1436,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Script 2 - Say Line 4 (Watcher Cutford)"),
(26301,9,7,0,0,0,100,0,3000,3000,0,0,66,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lord Ello Ebonlocke - On Script - Set Orientation");

-- Watcher Cutford
UPDATE creature_template SET AIName="SmartAI" WHERE entry=1436;
DELETE FROM smart_scripts WHERE entryorguid=1436 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
(1436,0,0,0,54,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Watcher Cutford - Just Summoned - Set Active On"),
(1436,0,1,0,54,0,100,0,0,0,0,0,53,1,1436,0,0,0,0,1,0,0,0,0,0,0,0,"Watcher Cutford - Just Summoned - Start Waypoint (No Repeat)"),
(1436,0,2,0,40,0,100,0,1,1436,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Watcher Cutford - On Waypoint 1 Reached - Say Line 0 (No Repeat)"),
(1436,0,3,0,40,0,100,0,12,1436,0,0,66,0,0,0,0,0,0,19,263,0,0,0,0,0,0,"Watcher Cutford - On Waypoint 12 Reached - Set Orientation"),
(1436,0,4,0,40,0,100,0,12,1436,0,0,54,28000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Watcher Cutford - On Waypoint 12 Reached - Pause Waypoint"),
(1436,0,5,0,40,0,100,0,12,1436,0,0,45,1,1,0,0,0,0,19,263,0,0,0,0,0,0,"Watcher Cutford - On Waypoint 12 Reached - Set Data"),
(1436,0,6,0,40,0,100,0,22,1436,0,0,66,0,0,0,0,0,0,19,264,0,0,0,0,0,0,"Watcher Cutford - On Waypoint 22 Reached - Set Orientation"),
(1436,0,7,0,40,0,100,0,22,1436,0,0,54,17000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Watcher Cutford - On Waypoint 22 Reached - Pause Waypoint"),
(1436,0,8,0,40,0,100,0,22,1436,0,0,45,1,1,0,0,0,0,19,264,0,0,0,0,0,0,"Watcher Cutford - On Waypoint 22 Reached - Set Data"),
(1436,0,9,0,40,0,100,0,25,1436,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Watcher Cutford - On Waypoint 25 Reached - Despawn In 3000 ms");

DELETE FROM waypoints WHERE entry=1436;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z) VALUES
(1436,1,-10584.2,-1174.31,28.662),
(1436,2,-10557.4,-1149.16,28.033),
(1436,3,-10559.6,-1132.51,30.067),
(1436,4,-10565,-1124.78,30.067),
(1436,5,-10569.2,-1125.4,29.2035),
(1436,6,-10575,-1125.57,29.167),
(1436,7,-10576.6,-1111.12,30.07),
(1436,8,-10572.9,-1107.8,30.069),
(1436,9,-10558.3,-1105.98,30.069),
(1436,10,-10556,-1106.37,31.0298),
(1436,11,-10555,-1106.46,31.429),
(1436,12,-10553.4,-1106.64,31.428),
(1436,13,-10558.3,-1105.98,30.069),
(1436,14,-10572.8,-1107,30.071),
(1436,15,-10576.6,-1111.12,30.07),
(1436,16,-10575.7,-1116.16,30.0691),
(1436,17,-10575.8,-1121.12,29.9733),
(1436,18,-10575,-1125.57,29.167),
(1436,19,-10565,-1124.78,30.067),
(1436,20,-10559.6,-1132.51,30.067),
(1436,21,-10557.5,-1146.89,28.034),
(1436,22,-10559.3,-1151.77,28.034),
(1436,23,-10568.3,-1154.32,27.412),
(1436,24,-10582.2,-1173.28,28.53),
(1436,25,-10623,-1184.54,28.819);

-- Commander Althea Ebonlocke
DELETE FROM smart_scripts WHERE entryorguid=264 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid=26400 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
(264,0,0,0,25,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Reset - Set Event Phase 1"),
(264,0,1,0,1,1,100,0,1000,15000,150000,180000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Commander Althea Ebonlocke - Out of Combat - Say Line 0 (Phase 1)"),
(264,0,2,0,38,0,100,0,1,1,0,0,80,26400,0,0,0,0,0,1,0,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Data Set - Run Script"),
(264,0,3,0,38,0,100,0,1,1,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Data Set - Set Active On"),
(264,0,4,0,69,0,100,0,@STITCHESEVENT,0,0,0,48,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Game Event 'Stitches' End - Set Active Off"),
(26400,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,"Commander Althea Ebonlocke - On Script - Set Event Phase 0"),
(26400,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,19,1436,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Script - Set Orientation"),
(26400,9,2,0,0,0,100,0,500,500,0,0,1,5,0,0,0,0,0,19,1436,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Script - Say Line 5 (Watcher Cutford)"),
(26400,9,3,0,0,0,100,0,7000,7000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Script - Say Line 1"),
(26400,9,4,0,0,0,100,0,6500,6500,0,0,1,6,0,0,0,0,0,19,1436,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Script - Say Line 6 (Watcher Cutford)"),
(26400,9,5,0,0,0,100,0,5000,5000,0,0,1,0,0,0,0,0,0,19,1436,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Script - Say Line 7 (Watcher Cutford)"),
(26400,9,6,0,0,0,100,0,0,0,0,0,112,@STITCHESEVENT,0,0,0,0,0,1,0,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Script - Start Game Event 'Stitches'"),
(26400,9,7,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Script - Set Orientation"),
(26400,9,8,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Commander Althea Ebonlocke - On Script - Event Phase 1");

-- Town Crier
UPDATE creature_template SET AIName="SmartAI" WHERE entry=468;
DELETE FROM smart_scripts WHERE entryorguid=468 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
(468,0,0,0,68,0,100,0,@STITCHESEVENT,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Game Event 'Stitches' Start - Set Active On"),
(468,0,1,0,69,0,100,0,@STITCHESEVENT,0,0,0,48,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Game Event 'Stitches' End - Set Active Off");

-- Texts
DELETE FROM creature_text WHERE CreatureID IN (1436,468,412);
DELETE FROM creature_text WHERE CreatureID=263 AND GroupID>0;
DELETE FROM creature_text WHERE CreatureID=264 AND GroupID=1;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(1436,0,0,"Make Way! Make Way!",14,7,100,0,0,0,549,0,"Watcher Cutford"),
(1436,1,0,"Lord Mayor! Our scouts report strange activity to the west.",12,7,100,5,0,0,265,0,"Watcher Cutford"),
(1436,1,1,"Mayor Ello! Our graveyard scouts return with ominous reports...",12,7,100,5,0,0,266,0,"Watcher Cutford"),
(1436,2,0,"Hideous bellows and growls are heard coming from that old hermit's shack!",12,7,100,1,0,0,267,0,"Watcher Cutford"),
(1436,3,0,"Wolves head this way, as if fleeing from...something.",12,7,100,1,0,0,268,0,"Watcher Cutford"),
(1436,4,0,"Yes, Lord Mayor.",12,7,100,66,0,0,269,0,"Watcher Cutford"),
(1436,5,0,"Althea, there are reports of strange happenings at the graveyard. Ello believes it portends an attack on Darkshire.",12,7,100,1,0,0,272,0,"Watcher Cutford"),
(1436,6,0,"Yes, commander!",12,7,100,66,0,0,275,0,"Watcher Cutford"),
(1436,7,0,"Beware! Beware! A threat lurks in the wild! Night Watchers, be on the alert!",14,7,100,0,0,0,276,2,"Watcher Cutford"),
(263,1,0,"This is grim news, and I fear it is linked to the dealings $n had with the Embalmer.",12,7,100,1,0,0,270,0,"Lord Ello Ebonlocke"),
(263,2,0,"Watcher, inform Althea that a dire threat is marshalling against our town. We must prepare!",12,7,100,25,0,0,271,0,"Lord Ello Ebonlocke"),
(264,1,0,"This doesn't bode well. Send scouts to gather more intelligence, and stay on alert.",12,7,100,1,0,0,273,0,"Watcher Cutford"),
(412,0,0,"ROARRRRR!!",14,0,100,0,0,0,278,2,"Stitches"),
(412,0,1,"DARKSHIRE... I HUNGER!!",14,0,100,0,0,0,277,2,"Stitches"),
(468,1,0,"Rouse and to arms, citizens of Darkshire! An abomination of the undead approaches along the road!",14,7,100,22,0,0,89,2,"Town Crier"),
(468,2,0,"The abomination has overrun the Night Watch camp! Quickly, we must intercept it before it reaches town!",14,7,100,22,0,0,90,2,"Town Crier"),
(468,3,0,"It isn't enough! Defenders, gather in the center of town. Together we will stand against the undead monster!",14,7,100,22,0,0,91,2,"Town Crier"),
(468,4,0,"The abomination has come! Forward!",14,7,100,22,0,0,92,2,"Town Crier"),
(468,5,0,"The beast is slain! All's well in Darkshire!",14,7,100,22,0,0,93,2,"Town Crier");

-- Fix position for some Watchers
UPDATE creature SET position_x=-10825.9, position_y=-830.622, position_z=55.5523, orientation=1.83813 WHERE guid=86847; -- Watcher Merant
UPDATE creature SET position_x=-10832, position_y=-829.286, position_z=55.7114, orientation=1.58489 WHERE guid=86851; -- Watcher Gelwin
UPDATE creature SET position_x=-10824.9, position_y=-827.806, position_z=55.5331, orientation=1.93238 WHERE guid=86852; -- Watcher Selkin
UPDATE creature SET position_x=-10829.1, position_y=-831.335, position_z=55.7146, orientation=1.82557 WHERE guid=86853; -- Watcher Selkin

[Killyana]

@ZenoX92 did this work for you ? (412,0,3,0,36,0,100,0,0,0,0,0,0,111,@STITCHESEVENT,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stitches - On Corpse Removed - Stop Game Event 'Stitches'"),

Also when the event starts some watchers must also spawns (some of them are already spawned they need to be added to the event)

[ZenoX92]

No, @Killyana. It didn't work. Maybe SMART_EVENT_CORPSE_REMOVED is not working?

I edited the fix. I made a workaround to stop the event properly. I also added the watchers to the event. I moved some of them since their spawn positions were wrong.

[Killyana]

I don't like this set data on death, the npc could be in an inactive grid, better to fix SMART_EVENT_CORPSE_REMOVED and use it

[ZenoX92]

OK. I reverted that change.

[ZenoX92]

@Killyana, I'm getting these DB errores:
SmartAIMgr: Entry 412 SourceType 0 Event 5 Action 1 using non-existent Text id 1, skipped
SmartAIMgr: Entry 412 SourceType 0 Event 6 Action 1 using non-existent Text id 2, skipped
SmartAIMgr: Entry 412 SourceType 0 Event 7 Action 1 using non-existent Text id 3, skipped
SmartAIMgr: Entry 412 SourceType 0 Event 8 Action 1 using non-existent Text id 4, skipped
SmartAIMgr: Entry 412 SourceType 0 Event 10 Action 1 using non-existent Text id 5, skipped

They refer to these scripts:
(412,0,5,0,40,0,100,0,36,412,0,0,0,1,1,0,0,0,0,0,10,4185,0,0,0,0,0,0,"Stitches - On Waypoint 36 Reached - Say Line 1 (Town Crier)"),
(412,0,6,0,40,0,100,0,51,412,0,0,0,1,2,0,0,0,0,0,10,4185,0,0,0,0,0,0,"Stitches - On Waypoint 51 Reached - Say Line 2 (Town Crier)"),
(412,0,7,0,40,0,100,0,68,412,0,0,0,1,3,0,0,0,0,0,10,4185,0,0,0,0,0,0,"Stitches - On Waypoint 68 Reached - Say Line 3 (Town Crier)"),
(412,0,8,0,40,0,100,0,85,412,0,0,0,1,4,0,0,0,0,0,10,4185,0,0,0,0,0,0,"Stitches - On Waypoint 85 Reached - Say Line 4 (Town Crier)"),
(412,0,10,0,6,0,100,0,0,0,0,0,0,1,5,0,0,0,0,0,10,4185,0,0,0,0,0,0,"Stitches - On Just Died - Say Line 5 (Town Crier)"),

It seems as if you cannot use SMART_ACTION_TALK with target type 10 (or 19) if the NPC that calls the action doesn't have an own text with the corresponding group id. In this case, since Stitches doesn't have texts with group id 1, 2, 3, 4 or 5, he can't force the Town Crier to say any text with those group ids.

Can you check this?

[Killyana]

Try to add entry to the target: 10,4185,468 we have similar cases and it works just fine

[illfated]

I wonder if you need to run a script instead, because it looks like you are asking more of a single SAI line than what it can do at the moment.

"Stitches - On Waypoint 36 Reached - Run Script 1 (Town Crier)"
"Stitches - On Waypoint 51 Reached - Run Script 2 (Town Crier)"
"Stitches - On Waypoint 68 Reached - Run Script 3 (Town Crier)"
"Stitches - On Waypoint 85 Reached - Run Script 4 (Town Crier)"

---

edit: NVM, looks like Killyana has given you a solution already.

[ZenoX92]

I added the entry and I still got the same errors.

[offl]

Whoever wants to implement this properly, use spawn groups to avoid multiple summons instead of game event

[dr-j]

Well here is working version of this its not using spawn groups though, corpse removed does not activate still to stop event but all texts now work.
~~~sql
-- Stitches Event
SET @STITCHESEVENT := 85;
DELETE FROM game_event WHERE eventEntry=@STITCHESEVENT;
INSERT INTO game_event (eventEntry, start_time, end_time, occurence, length, holiday, holidayStage, description, world_event, announce) VALUES
(@STITCHESEVENT,"2011-03-22 01:00:00","2030-12-31 07:00:00",5184000,30,0,0,"Stitches Event",0,2);

-- Stitches
SET @GUID := 300000;
DELETE FROM creature WHERE guidIN(@GUID,@GUID+1,@GUID+2);
INSERT INTO creature (guid, id, map, zoneId, areaId, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, wander_distance, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, ScriptName, VerifiedBuild) VALUES
(@GUID, 412, 0, 0, 0, 1, 1, 0, 0, -10290.2, 72.7811, 38.8811, 4.8015, 300, 0, 0, 12200, 0, 0, 0, 0, 0, '', 0);

DELETE FROM creature_addon WHERE guid=@GUID;
INSERT INTO creature_addon (guid, path_id, mount, bytes1, bytes2, emote, visibilityDistanceType, auras) VALUES
(@GUID,0,0,0,0,0,5,"");

DELETE FROM game_event_creature WHERE eventEntry=@STITCHESEVENT;
INSERT INTO game_event_creature (eventEntry, guid) VALUES
(@STITCHESEVENT,@GUID),
(@STITCHESEVENT,86847),
(@STITCHESEVENT,86851),
(@STITCHESEVENT,86852),
(@STITCHESEVENT,86853),
(@STITCHESEVENT,86846),
(@STITCHESEVENT,86845),
(@STITCHESEVENT,86857);

UPDATE creature_template SET faction=7 WHERE entry=412;
DELETE FROM smart_scripts WHERE entryorguid=412 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, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o, cus_target_param1, comment) VALUES
(412, 0, 0, 0, 0, 0, 100, 0, 6000, 12000, 6000, 12000, 0, 11, 3106, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stitches - In Combat - Cast \'Aura of Rot\''),
(412, 0, 1, 2, 11, 0, 100, 0, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stitches - On Respawn - Set Active On'),
(412, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 53, 1, 412, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stitches - On Respawn - Start Waypoint'),
(412, 0, 4, 0, 40, 0, 100, 0, 36, 412, 0, 0, 0, 2, 93, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stitches - On Waypoint 36 Reached - Set Faction 93'),
(412, 0, 5, 0, 40, 0, 100, 0, 36, 412, 0, 0, 0, 45, 2, 1, 0, 0, 0, 0, 10, 4185, 468, 0, 0, 0, 0, 0, 0, 0, 'Stitches - On Waypoint 36 Reached - Say Line 1 (Town Crier)'),
(412, 0, 6, 0, 40, 0, 100, 0, 51, 412, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 10, 4185, 468, 0, 0, 0, 0, 0, 0, 0, 'Stitches - On Waypoint 51 Reached - Say Line 2 (Town Crier)'),
(412, 0, 7, 0, 40, 0, 100, 0, 68, 412, 0, 0, 0, 45, 2, 3, 0, 0, 0, 0, 10, 4185, 468, 0, 0, 0, 0, 0, 0, 0, 'Stitches - On Waypoint 68 Reached - Say Line 3 (Town Crier)'),
(412, 0, 8, 0, 40, 0, 100, 0, 85, 412, 0, 0, 0, 45, 2, 4, 0, 0, 0, 0, 10, 4185, 468, 0, 0, 0, 0, 0, 0, 0, 'Stitches - On Waypoint 85 Reached - Say Line 4 (Town Crier)'),
(412, 0, 9, 0, 40, 0, 100, 0, 90, 412, 0, 0, 0, 89, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stitches - On Waypoint 90 Reached - Start Random Movement'),
(412, 0, 10, 0, 6, 0, 100, 0, 0, 0, 0, 0, 0, 45, 2, 5, 0, 0, 0, 0, 10, 4185, 468, 0, 0, 0, 0, 0, 0, 0, 'Stitches - On Just Died - Say Line 5 (Town Crier)'),
(412, 0, 11, 0, 1, 0, 100, 0, 30000, 40000, 60000, 90000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stitches - Update - Say Line 0');

-- Lord Ello Ebonlocke
DELETE FROM smart_scripts WHERE entryorguid=263 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid IN (26300, 26301) 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, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o, cus_target_param1, comment) VALUES
(263, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Reset - Set Event Phase 1'),
(263, 0, 1, 0, 1, 1, 100, 0, 20000, 30000, 110000, 130000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - Out of Combat - Say Line 0 (Phase 1)'),
(263, 0, 2, 0, 20, 1, 100, 0, 252, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Quest \'Translation to Ello\' Finished - Set Active On (Phase 1)'),
(263, 0, 3, 0, 20, 1, 100, 0, 252, 0, 0, 0, 0, 80, 26300, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Quest \'Translation to Ello\' Finished - Run Script 1 (Phase 1)'),
(263, 0, 4, 0, 20, 0, 100, 0, 252, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Quest \'Translation to Ello\' Finished - Store Target'),
(263, 0, 5, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 80, 26301, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Data Set - Run Script 2'),
(263, 0, 6, 0, 69, 0, 100, 0, 85, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Game Event \'Stitches\' End - Set Event Phase 1'),
(263, 0, 7, 0, 69, 0, 100, 0, 85, 0, 0, 0, 0, 48, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Game Event \'Stitches\' End - Set Active Off'),
(26300, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Script 1 - Set Event Phase 0'),
(26300, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12,1436,8,0,0,0,0,8,0,0,0,0,-10604.2,-1179.31,27.995,0.16,0, 'Lord Ello Ebonlocke - On Script 1 - Summon Creature \'Watcher Cutford\''),
(26301, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 1436, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Script 2 - Set Orientation'),
(26301, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 45, 3, 1, 0, 0, 0, 0, 19, 1436, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Script 2 - Say Line 1 (Watcher Cutford)'),
(26301, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 45, 3, 2, 0, 0, 0, 0, 19, 1436, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Script 2 - Say Line 2 (Watcher Cutford)'),
(26301, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 1436, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Script 2 - Say Line 3 (Watcher Cutford)'),
(26301, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Script 2 - Say Line 1'),
(26301, 9, 5, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Script 2 - Say Line 2'),
(26301, 9, 6, 0, 0, 0, 100, 0, 5500, 5500, 0, 0, 0, 45, 3, 4, 0, 0, 0, 0, 19, 1436, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Script 2 - Say Line 4 (Watcher Cutford)'),
(26301, 9, 7, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Ello Ebonlocke - On Script - Set Orientation');

-- Watcher Cutford
UPDATE creature_template SET AIName="SmartAI" WHERE entry=1436;
DELETE FROM smart_scripts WHERE entryorguidIN(143600) AND source_type=9;

DELETE FROM smart_scripts WHERE entryorguidIN(1436) 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, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o, cus_target_param1, comment) VALUES
(1436, 0, 0, 0, 38, 0, 100, 0, 3, 8, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - Just Summoned - Set Active On'),
(1436, 0, 1, 0, 38, 0, 100, 0, 3, 8, 0, 0, 0, 53, 1, 1436, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - Just Summoned - Start Waypoint (No Repeat)'),
(1436, 0, 2, 0, 38, 0, 100, 0, 3, 8, 0, 0, 0, 28, 16380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - Just Summoned - Start Waypoint (No Repeat)'),
(1436, 0, 3, 0, 40, 0, 100, 0, 1, 1436, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Waypoint 1 Reached - Say Line 0 (No Repeat)'),
(1436, 0, 4, 0, 40, 0, 100, 0, 12, 1436, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 263, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Waypoint 12 Reached - Set Orientation'),
(1436, 0, 5, 0, 40, 0, 100, 0, 12, 1436, 0, 0, 0, 54, 28000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Waypoint 12 Reached - Pause Waypoint'),
(1436, 0, 6, 0, 40, 0, 100, 0, 12, 1436, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 263, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Waypoint 12 Reached - Set Data'),
(1436, 0, 7, 0, 40, 0, 100, 0, 22, 1436, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 264, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Waypoint 22 Reached - Set Orientation'),
(1436, 0, 8, 0, 40, 0, 100, 0, 22, 1436, 0, 0, 0, 54, 17000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Waypoint 22 Reached - Pause Waypoint'),
(1436, 0, 9, 0, 40, 0, 100, 0, 22, 1436, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 264, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Waypoint 22 Reached - Set Data'),
(1436, 0, 10, 0, 40, 0, 100, 0, 25, 1436, 0, 0, 0, 11, 16380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Waypoint 25 Reached - Despawn In 3000 ms'),
(1436, 0, 11, 0, 38, 0, 100, 0, 3, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Data Set - Say line 1'),
(1436, 0, 12, 0, 38, 0, 100, 0, 3, 2, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Data Set - Say line 2'),
(1436, 0, 13, 0, 38, 0, 100, 0, 3, 3, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Data Set - Say line 3'),
(1436, 0, 14, 0, 38, 0, 100, 0, 3, 4, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Data Set - Say line 4'),
(1436, 0, 15, 0, 38, 0, 100, 0, 3, 5, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Data Set - Say line 3'),
(1436, 0, 16, 0, 38, 0, 100, 0, 3, 6, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Data Set - Say line 4'),
(1436, 0, 17, 0, 38, 0, 100, 0, 3, 9, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Data Set - Say line 4'),
(1436, 0, 18, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 11, 16380, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Spawn - Invisible'),
(1436, 0, 19, 0, 40, 0, 100, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Watcher Cutford - On Reached WP - Set Home Position');

DELETE FROM waypoints WHERE entry=1436;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z) VALUES
(1436,1,-10584.2,-1174.31,28.662),
(1436,2,-10557.4,-1149.16,28.033),
(1436,3,-10559.6,-1132.51,30.067),
(1436,4,-10565,-1124.78,30.067),
(1436,5,-10569.2,-1125.4,29.2035),
(1436,6,-10575,-1125.57,29.167),
(1436,7,-10576.6,-1111.12,30.07),
(1436,8,-10572.9,-1107.8,30.069),
(1436,9,-10558.3,-1105.98,30.069),
(1436,10,-10556,-1106.37,31.0298),
(1436,11,-10555,-1106.46,31.429),
(1436,12,-10553.4,-1106.64,31.428),
(1436,13,-10558.3,-1105.98,30.069),
(1436,14,-10572.8,-1107,30.071),
(1436,15,-10576.6,-1111.12,30.07),
(1436,16,-10575.7,-1116.16,30.0691),
(1436,17,-10575.8,-1121.12,29.9733),
(1436,18,-10575,-1125.57,29.167),
(1436,19,-10565,-1124.78,30.067),
(1436,20,-10559.6,-1132.51,30.067),
(1436,21,-10557.5,-1146.89,28.034),
(1436,22,-10559.3,-1151.77,28.034),
(1436,23,-10568.3,-1154.32,27.412),
(1436,24,-10582.2,-1173.28,28.53),
(1436,25,-10623,-1184.54,28.819);

-- Commander Althea Ebonlocke
DELETE FROM smart_scripts WHERE entryorguid=264 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid=26400 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, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o, cus_target_param1, comment) VALUES
(264, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Reset - Set Event Phase 1'),
(264, 0, 1, 0, 1, 1, 100, 0, 1000, 15000, 150000, 180000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - Out of Combat - Say Line 0 (Phase 1)'),
(264, 0, 2, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 80, 26400, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Data Set - Run Script'),
(264, 0, 3, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Data Set - Set Active On'),
(264, 0, 4, 0, 69, 0, 100, 0, 85, 0, 0, 0, 0, 48, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Game Event \'Stitches\' End - Set Active Off'),
(26400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Script - Set Event Phase 0'),
(26400, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 1436, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Script - Set Orientation'),
(26400, 9, 2, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 45, 3, 5, 0, 0, 0, 0, 19, 1436, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Script - Say Line 5 (Watcher Cutford)'),
(26400, 9, 3, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Script - Say Line 1'),
(26400, 9, 4, 0, 0, 0, 100, 0, 6500, 6500, 0, 0, 0, 45, 3, 6, 0, 0, 0, 0, 19, 1436, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Script - Say Line 6 (Watcher Cutford)'),
(26400, 9, 5, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 45, 3, 9, 0, 0, 0, 0, 19, 1436, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Script - Say Line 7 (Watcher Cutford)'),
(26400, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 112, 85, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Script - Start Game Event \'Stitches\''),
(26400, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Script - Set Orientation'),
(26400, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Althea Ebonlocke - On Script - Event Phase 1');

-- Town Crier
UPDATE creature_template SET AIName="SmartAI" WHERE entry=468;
DELETE FROM smart_scripts WHERE entryorguid=468 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
(468,0,0,0,68,0,100,0,@STITCHESEVENT,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Game Event 'Stitches' Start - Set Active On"),
(468,0,1,0,69,0,100,0,@STITCHESEVENT,0,0,0,48,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Game Event 'Stitches' End - Set Active Off"),

(468,0,2,0,38,0,100,0,2,1,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Data Set - Say Line 1"),
(468,0,3,0,38,0,100,0,2,2,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Data Set - Say Line 2"),
(468,0,4,0,38,0,100,0,2,3,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Data Set - Say Line 3"),
(468,0,5,0,38,0,100,0,2,4,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Data Set - Say Line 4"),
(468,0,6,7,38,0,100,0,2,5,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Data Set - Say Line 5"),
(468,0,7,0,61,0,100,0,0,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - On Data Set - Set Phase 2"),
(468,0,8,9,1,2,100,0,120000,120000,120000,120000,111,85,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - OOC (Phase 2) - Stop Event"),
(468,0,9,0,61,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - OOC (Phase 2) - Set Phase 0"),
(468,0,10,0,11,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Town Crier - Spawn - Set Active");

-- Texts
DELETE FROM creature_text WHERE CreatureID IN (1436,468,412);
DELETE FROM creature_text WHERE CreatureID=263 AND GroupID>0;
DELETE FROM creature_text WHERE CreatureID=264 AND GroupID=1;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(1436,0,0,"Make Way! Make Way!",14,7,100,0,0,0,549,1,"Watcher Cutford"),
(1436,1,0,"Lord Mayor! Our scouts report strange activity to the west.",12,7,100,5,0,0,265,1,"Watcher Cutford"),
(1436,1,1,"Mayor Ello! Our graveyard scouts return with ominous reports...",12,7,100,5,0,0,266,1,"Watcher Cutford"),
(1436,2,0,"Hideous bellows and growls are heard coming from that old hermit's shack!",12,7,100,1,0,0,267,1,"Watcher Cutford"),
(1436,3,0,"Wolves head this way, as if fleeing from...something.",12,7,100,1,0,0,268,1,"Watcher Cutford"),
(1436,4,0,"Yes, Lord Mayor.",12,7,100,66,0,0,269,1,"Watcher Cutford"),
(1436,5,0,"Althea, there are reports of strange happenings at the graveyard. Ello believes it portends an attack on Darkshire.",12,7,100,1,0,0,272,1,"Watcher Cutford"),
(1436,6,0,"Yes, commander!",12,7,100,66,0,0,275,1,"Watcher Cutford"),
(1436,7,0,"Beware! Beware! A threat lurks in the wild! Night Watchers, be on the alert!",14,7,100,0,0,0,276,2,"Watcher Cutford"),
(263,1,0,"This is grim news, and I fear it is linked to the dealings $n had with the Embalmer.",12,7,100,1,0,0,270,1,"Lord Ello Ebonlocke"),
(263,2,0,"Watcher, inform Althea that a dire threat is marshalling against our town. We must prepare!",12,7,100,25,0,0,271,1,"Lord Ello Ebonlocke"),
(264,1,0,"This doesn't bode well. Send scouts to gather more intelligence, and stay on alert.",12,7,100,1,0,0,273,1,"Watcher Cutford"),
(412,0,0,"ROARRRRR!!",14,0,100,0,0,0,278,2,"Stitches"),
(412,0,1,"DARKSHIRE... I HUNGER!!",14,0,100,0,0,0,277,2,"Stitches"),
(468,1,0,"Rouse and to arms, citizens of Darkshire! An abomination of the undead approaches along the road!",14,7,100,22,0,0,89,2,"Town Crier"),
(468,2,0,"The abomination has overrun the Night Watch camp! Quickly, we must intercept it before it reaches town!",14,7,100,22,0,0,90,2,"Town Crier"),
(468,3,0,"It isn't enough! Defenders, gather in the center of town. Together we will stand against the undead monster!",14,7,100,22,0,0,91,2,"Town Crier"),
(468,4,0,"The abomination has come! Forward!",14,7,100,22,0,0,92,2,"Town Crier"),
(468,5,0,"The beast is slain! All's well in Darkshire!",14,7,100,22,0,0,93,2,"Town Crier");

-- Fix position for some Watchers
UPDATE creature SET position_x=-10825.9, position_y=-830.622, position_z=55.5523, orientation=1.83813 WHERE guid=86847; -- Watcher Merant
UPDATE creature SET position_x=-10832, position_y=-829.286, position_z=55.7114, orientation=1.58489 WHERE guid=86851; -- Watcher Gelwin
UPDATE creature SET position_x=-10824.9, position_y=-827.806, position_z=55.5331, orientation=1.93238 WHERE guid=86852; -- Watcher Selkin
UPDATE creature SET position_x=-10829.1, position_y=-831.335, position_z=55.7146, orientation=1.82557 WHERE guid=86853; -- Watcher Selkin