DB/Spawns add some missing spawns to Stormwind Harbor

+ delete some old spawns
+ handle Darnassian Refugee Phase
+ some SAI Scripts + Waypoints
Closes #28353

1 files changed, 215 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_10_13_01_world.sql b/sql/updates/world/master/2022_10_13_01_world.sql
new file mode 100644
index 00000000000..2269c9639c2
--- /dev/null
+++ b/sql/updates/world/master/2022_10_13_01_world.sql
@@ -0,0 +1,215 @@
+-- SW City update - part 2 =>> Area : Stormwind Harbor ( 1 / 4 )
+
+SET @CGUID := 850628;
+SET @OGUID := 501811;
+
+-- Delete some old spawns (Auberdine Sentinel, Nayura Dockmaster)
+DELETE FROM `creature` WHERE `guid` IN (251159, 251153, 313450, 313448, 251163);
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+26;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 158512, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8284.6220703125, 1403.74658203125, 4.493558883666992187, 2.683667421340942382, 120, 0, 0, 1604, 0, 0, 0, 0, 0, 45338), -- Daniel Julian (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+1, 158488, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8285.9580078125, 1403.1458740234375, 4.500016689300537109, 1.426343798637390136, 120, 0, 0, 1604, 0, 0, 0, 0, 0, 45338), -- Ty Julian (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+2, 142641, 0, 1519, 4411, 0, 0, 0, 0, 0, -8650.2451171875, 1325.2291259765625, 5.316545486450195312, 5.508950233459472656, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745), -- Aron Kyleson - Dockmaster (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+3, 141902, 0, 1519, 4411, 0, 0, 0, 0, 0, -8643.294921875, 1308.390625, 5.3175201416015625, 5.433049201965332031, 120, 0, 0, 4579, 0, 0, 0, 0, 0, 45745), -- Perrin Moontear (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+4, 3469, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8600.9658203125, 1199.092041015625, 5.2983856201171875, 0.866046667098999023, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- 3469 (Area: Stormwind Harbor - Difficulty: 0) (Auras: 244971 - Set Health (Random 15%-55%))
+(@CGUID+5, 158589, 0, 1519, 4411, 0, 0, 0, 0, 0, -8286.9697265625, 1398.6190185546875, 4.516635417938232421, 0.180753707885742187, 120, 10, 0, 27, 0, 1, 0, 0, 0, 45338), -- Eisley (Area: Stormwind Harbor - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+6, 140253, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8531.263671875, 1211.4947509765625, 5.30043792724609375, 5.292941093444824218, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- 140253 (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+7, 140253, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8604.169921875, 1224.4427490234375, 5.313576698303222656, 0.467964798212051391, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- 140253 (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+8, 140253, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8531.544921875, 1209.607666015625, 5.378472328186035156, 0.467964798212051391, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- 140253 (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+9, 53527, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8640.830078125, 1325.7742919921875, 5.316489696502685546, 5.203694820404052734, 120, 0, 0, 4812, 0, 0, 0, 0, 0, 45745), -- Prisoner (Area: Stormwind Harbor - Difficulty: 0) (Auras: 99365 - Under Arrest)
+(@CGUID+10, 68, 0, 1519, 4411, 0, 11595, 0, 0, 1, -8641.7587890625, 1327.6944580078125, 5.316112995147705078, 5.148721218109130859, 120, 10, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(@CGUID+11, 140253, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8628.9462890625, 1269.251708984375, 5.316493034362792968, 5.351186275482177734, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- Darnassian Refugee (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+12, 140253, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8630.158203125, 1267.998291015625, 5.315853118896484375, 0.199740275740623474, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- Darnassian Refugee (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+13, 140253, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8595.3994140625, 1262.3802490234375, 5.313805580139160156, 4.168401241302490234, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- Darnassian Refugee (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+14, 140253, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8594.720703125, 1259.40283203125, 5.313995361328125, 2.350676298141479492, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- Darnassian Refugee (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+15, 140253, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8597.361328125, 1259.607666015625, 5.51643991470336914, 5.585411548614501953, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- Darnassian Refugee (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+16, 140403, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8529.0107421875, 1209.4375, 5.360833168029785156, 2.649040460586547851, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- Displaced Gilnean Refugee (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+17, 140403, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8601.6337890625, 1224.2725830078125, 5.313576698303222656, 2.649040460586547851, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- Displaced Gilnean Refugee (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+18, 5504, 0, 1519, 4411, 0, 0, 0, 0, 1, -8575.11328125, 1246.201416015625, 5.313568115234375, 4.729842185974121093, 120, 0, 0, 15918, 0, 0, 0, 0, 0, 45745), -- Sheldras Moontree (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+19, 141554, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8568.658203125, 1215.2691650390625, 5.206286430358886718, 0, 120, 0, 0, 186, 100, 0, 0, 0, 0, 45745), -- 141554 (Area: Stormwind Harbor - Difficulty: 0) (Auras: 52455 - PvP Vehicle Health Regen Suppression)
+(@CGUID+20, 140253, 0, 1519, 4411, 0, 11595, 0, 0, 0, -8603.888671875, 1226.329833984375, 5.313576698303222656, 5.292941093444824218, 120, 0, 0, 124, 0, 0, 0, 0, 0, 45745), -- 140253 (Area: Stormwind Harbor - Difficulty: 0)
+(@CGUID+21, 151187, 0, 1519, 4411, 0, 0, 0, 0, 0, -8215.2158203125, 1311.871826171875, -0.24692121148109436, 0.880308151245117187, 120, 0, 0, 4579, 1807, 0, 0, 0, 0, 45745), -- 151187 (Area: Stormwind Harbor - Difficulty: 0) (Auras: 292845 - [DNT] Ship Blessing)
+(@CGUID+22, 188374, 0, 1519, 4411, 0, 0, 0, 0, 0, -8437.984375, 1225.9617919921875, 5.313569545745849609, 6.178342819213867187, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45338), -- Millbert (Area: Stormwind Harbor - Difficulty: 0) (Auras: 370841 - Cosmetic - Carry Box)
+(@CGUID+23, 139088, 0, 1519, 4411, 0, 0, 0, 0, 1, -8645.2509765625, 1315.32861328125, 5.315582275390625, 0.558505356311798095, 120, 0, 0, 377265, 0, 0, 0, 0, 0, 45745), -- Boralus Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: )
+(@CGUID+24, 139088, 0, 1519, 4411, 0, 0, 0, 0, 1, -8632.423828125, 1322.6668701171875, 5.315583705902099609, 3.630284786224365234, 120, 0, 0, 377265, 0, 0, 0, 0, 0, 45745), -- Boralus Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: )
+(@CGUID+25, 139088, 0, 1519, 4411, 0, 0, 0, 0, 1, -8593.7890625, 1246.0025634765625, 5.313799381256103515, 4.101523876190185546, 120, 0, 0, 377265, 0, 0, 0, 0, 0, 45745), -- Boralus Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: )
+(@CGUID+26, 139088, 0, 1519, 4411, 0, 0, 0, 0, 1, -8606.9775390625, 1239.413330078125, 5.314605712890625, 0.506145477294921875, 120, 0, 0, 377265, 0, 0, 0, 0, 0, 45745); -- Boralus Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: )
+
+DELETE FROM `creature_template_movement` WHERE `CreatureId` = 44880;
+INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES
+(44880, 0, 0, 1, 0, 0, 0, NULL);
+
+DELETE FROM `creature_model_info` WHERE `DisplayID`=98849;
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(98849, 0.326728612184524536, 0.550000011920928955, 0, 45745);
+
+UPDATE `creature_model_info` SET `VerifiedBuild`=45745 WHERE `DisplayID` IN (1473, 99418, 1472, 3285, 39532, 99496, 37087, 99497, 99498, 5233, 1519, 1509, 1544, 14493, 77690, 77687, 221, 39052, 49021, 93574, 28282, 28111, 72724, 22769, 33303, 37850, 262, 61764, 14492, 19670, 15921, 42276, 7996, 36758, 15594, 80, 5074, 2974, 10624, 1447, 1427, 1446, 99615, 1433, 1423, 1525, 1438, 99495, 1439, 42722, 33520, 42720, 36597, 99391, 33519, 33518, 5546, 37372, 5547, 5444, 1436, 1429, 1450, 20873, 99389, 33468, 5545, 4888, 1443, 36839, 25901, 3246, 5552, 7992, 5551, 99197, 99196, 11686, 1431, 7991, 37310, 36213, 3133, 3167, 1541, 14472, 5082, 1445, 5446, 1437, 5567, 1418, 4181, 33948, 1141, 37311, 1448, 2208, 106457, 338, 1440, 87182, 1434, 2176, 42274, 42273, 21342, 34070, 1444, 27823);
+UPDATE `creature_model_info` SET `BoundingRadius`=0.326728612184524536, `CombatReach`=0.550000011920928955, `VerifiedBuild`=45745 WHERE `DisplayID`=98847;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.681569099426269531, `CombatReach`=1.399999976158142089, `VerifiedBuild`=45745 WHERE `DisplayID`=913;
+
+DELETE FROM `creature_equip_template` WHERE (`ID`=1 AND `CreatureID` IN (139088, 5504, 29152, 29288, 29296, 26548));
+INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES
+(139088, 1, 158900, 0, 0, 0, 0, 0, 155816, 1, 0, 45745), -- Boralus Guard
+(29152, 1, 1902, 0, 0, 0, 0, 0, 0, 0, 0, 45745), -- Stormwind Dock Worker
+(29288, 1, 1902, 0, 0, 0, 0, 0, 0, 0, 0, 45745), -- Engineer Kurtis Paddock
+(29296, 1, 1117, 0, 0, 0, 0, 0, 0, 0, 0, 45745), -- Justin Boehm
+(26548, 1, 2715, 0, 0, 0, 0, 0, 0, 0, 0, 45745), -- Leesha Tannerby
+(5504, 1, 12328, 0, 0, 0, 0, 0, 0, 0, 0, 45745); -- Sheldras Moontree
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (139088, 141554, 151187 /*151187 - [DNT] Ship Blessing*/, 29296);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(141554, 0, 0, 0, 1, 0, 0, 0, 0, 0, '52455'), -- 141554 - PvP Vehicle Health Regen Suppression
+(151187, 0, 0, 0, 1, 0, 0, 0, 0, 3, '292845'), -- 151187 - [DNT] Ship Blessing
+(29296, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- Justin Boehm
+(139088, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''); -- 139088 (Boralus Guard)
+
+UPDATE `creature_template_addon` SET `emote` = 455 WHERE `entry` = 44880;
+
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+26;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(@CGUID+4, 0, 0, 0, 1, 0, 0, 0, 0, 0, '244971'), -- 3469 - 244971 - Set Health (Random 15%-55%)
+(@CGUID+6, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- Darnassian Refugee
+(@CGUID+7, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- Darnassian Refugee
+(@CGUID+8, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- Darnassian Refugee
+(@CGUID+11, 0, 0, 0, 1, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee
+(@CGUID+12, 0, 0, 0, 1, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee
+(@CGUID+13, 0, 0, 0, 1, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee
+(@CGUID+14, 0, 0, 0, 1, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee
+(@CGUID+15, 0, 0, 3, 1, 0, 0, 0, 0, 0, ''), -- Darnassian Refugee
+(@CGUID+16, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- Displaced Gilnean Refugee
+(@CGUID+17, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- Displaced Gilnean Refugee
+(@CGUID+20, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- Darnassian Refugee
+(@CGUID+23, 0, 0, 0, 257, 716, 0, 0, 0, 0, ''), -- Boralus Guard
+(@CGUID+24, 0, 0, 0, 257, 716, 0, 0, 0, 0, ''), -- Boralus Guard
+(@CGUID+25, 0, 0, 0, 257, 716, 0, 0, 0, 0, ''), -- Boralus Guard
+(@CGUID+26, 0, 0, 0, 257, 716, 0, 0, 0, 0, ''); -- Boralus Guard
+
+UPDATE `creature_template` SET `subname` = '', `VerifiedBuild`=45745 WHERE `entry`=11397; -- Nara Meideros
+UPDATE `creature_template` SET `subname` = '', `VerifiedBuild`=45745 WHERE `entry`=5504; -- Sheldras Moontree
+UPDATE `creature_template` SET `subname` = '', `VerifiedBuild`=45745 WHERE `entry`=29299; -- Serban Oprescu
+UPDATE `creature_template` SET `subname` = '', `VerifiedBuild`=45745 WHERE `entry`=29296; -- Justin Boehm
+UPDATE `creature_template` SET `npcflag`=0 WHERE `entry`=139088; -- Boralus Guard
+
+DELETE FROM `creature_template_model` WHERE (`Idx`=0 AND `CreatureID` = 29296 ) OR (`Idx`=0 AND `CreatureID` = 151187 ) OR (`Idx`=1 AND `CreatureID` = 151187 ) OR (`Idx`=0 AND `CreatureID` = 29152 ) OR (`Idx`=1 AND `CreatureID` = 29152 ) OR (`Idx`=2 AND `CreatureID` = 29152 ) OR (`Idx`=0 AND `CreatureID` = 140403 ) OR (`Idx`=1 AND `CreatureID` = 140403 ) OR (`Idx`=2 AND `CreatureID` = 140403 ) OR (`Idx`=3 AND `CreatureID` = 140403 ) OR (`Idx`=4 AND `CreatureID` = 140403 ) OR (`Idx`=5 AND `CreatureID` = 140403 ) OR (`Idx`=6 AND `CreatureID` = 140403 ) OR (`Idx`=7 AND `CreatureID` = 140403 ) OR (`Idx`=8 AND `CreatureID` = 140403 ) OR (`Idx`=9 AND `CreatureID` = 140403 ) OR (`Idx`=10 AND `CreatureID` = 140403 ) OR (`Idx`=11 AND `CreatureID` = 140403 ) OR (`Idx`=12 AND `CreatureID` = 140403 ) OR (`Idx`=13 AND `CreatureID` = 140403 ) OR (`Idx`=14 AND `CreatureID` = 140403 ) OR (`Idx`=15 AND `CreatureID` = 140403 );
+INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`) VALUES
+(140403, 15, 37112, 1, 1, 45745), -- 140403
+(140403, 14, 37111, 1, 1, 45745), -- 140403
+(140403, 13, 37110, 1, 1, 45745), -- 140403
+(140403, 12, 37109, 1, 1, 45745), -- 140403
+(140403, 11, 37116, 1, 1, 45745), -- 140403
+(140403, 10, 37115, 1, 1, 45745), -- 140403
+(140403, 9, 37114, 1, 1, 45745), -- 140403
+(140403, 8, 37113, 1, 1, 45745), -- 140403
+(140403, 7, 37124, 1, 1, 45745), -- 140403
+(140403, 6, 37123, 1, 1, 45745), -- 140403
+(140403, 5, 37122, 1, 1, 45745), -- 140403
+(140403, 4, 37121, 1, 1, 45745), -- 140403
+(140403, 3, 37120, 1, 1, 45745), -- 140403
+(140403, 2, 37119, 1, 1, 45745), -- 140403
+(140403, 1, 37118, 1, 1, 45745), -- 140403
+(140403, 0, 37117, 1, 1, 45745), -- 140403
+(151187, 1, 11686, 1, 1, 45745), -- 151187
+(151187, 0, 169, 0.150000005960464477, 0, 45745), -- 151187
+(29296, 0, 26115, 1, 1, 45745), -- 29296
+(29152, 2, 5003, 1, 1, 45745), -- 29152
+(29152, 1, 5008, 1, 1, 45745), -- 29152
+(29152, 0, 99501, 1, 1, 45745); -- 29152
+
+DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` = 151187) OR (`Entry`=185696 AND `DifficultyID`=0);
+INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES 
+(151187, 0, 0, 0, 464, 45745),
+(185696, 0, 0, 0, 2057, 45745);
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+4;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 247015, 0, 1519, 4411, 0, 11595, 0, -8284.86328125, 1402.638916015625, 4.421866416931152343, 3.831023693084716796, 0, 0, -0.94117164611816406, 0.3379288911819458, 120, 255, 1, 45745), -- Luggage (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+1, 293894, 0, 1519, 4411, 0, 0, 0, -8645.388671875, 1308.27783203125, 5.233562946319580078, 0, 0, 0, 0, 1, 120, 255, 0, 45745), -- Portal to Darnassus (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+2, 292774, 0, 1519, 4411, 0, 11595, 0, -8597.248046875, 1259.4930419921875, 5.231070518493652343, 6.091175556182861328, 0, 0, -0.09585762023925781, 0.995395064353942871, 120, 255, 1, 45745), -- Sleeping Mat B (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+3, 292774, 0, 1519, 4411, 0, 11595, 0, -8597.1220703125, 1263.3785400390625, 5.230750083923339843, 5.688809871673583984, 0, 0, -0.2928323745727539, 0.956163763999938964, 120, 255, 1, 45745), -- Sleeping Mat B (Area: Stormwind Harbor - Difficulty: 0)
+(@OGUID+4, 293696, 0, 1519, 4411, 0, 11595, 0, -8657.2470703125, 1262.4896240234375, 0, 2.02551126480102539, 0, 0, 0.848294258117675781, 0.529525160789489746, 120, 255, 1, 45745); -- Darnassian Ship (Area: Stormwind Harbor - Difficulty: 0)
+
+DELETE FROM `gameobject_template_addon` WHERE `entry` IN (293894 /*293894*/, 293696 /*293696*/);
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(293696, 0, 1048608, 0, 0), -- 293696
+(293894, 35, 0, 0, 0); -- 293894
+
+UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=203801; -- Sack of Confectioner's Sugar
+
+-- Engineer Kurtis
+SET @WGUID := 313488;
+SET @PATH := @WGUID * 10;
+DELETE FROM `waypoint_data` WHERE `id`= @PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES
+(@PATH, 0, -8425.372, 1299.794, 20.86869, NULL, 0),
+(@PATH, 1, -8419.859, 1298.597, 20.92038, 4.73377, 39917),
+(@PATH, 2, -8425.742, 1310.585, 11.35291, NULL, 10310),
+(@PATH, 3, -8421.018, 1318.639, 11.20441, NULL, 8340);
+
+UPDATE `creature` SET `position_x`= -8425.372, `position_y`= 1299.794, `position_z`= 20.86869, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @WGUID;
+DELETE FROM `creature_addon` WHERE `guid`= @WGUID;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@WGUID, @PATH, 1);
+
+ -- Engineer Kurtis Paddock smart ai
+SET @ENTRY := 29288;
+DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY*100;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(@ENTRY, 0, 0, 0, 34, 0, 100, 0, 2, 1, 0, 0, 80, 2928800, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Start timed action list id #2928800 (update out of combat)'),
+(@ENTRY*100, 9, 0, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 10, 6, 396, 273, 374, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5 seconds - Self: Play random emote: 6, 396, 273, 374,'),
+(@ENTRY*100, 9, 1, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 10, 6, 396, 273, 374, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 15 seconds - Self: Play random emote: 6, 396, 273, 374,'),
+(@ENTRY*100, 9, 2, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 10, 6, 396, 273, 374, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 15 seconds - Self: Play random emote: 6, 396, 273, 374,');
+
+-- Justin Boehm
+SET @WPGUID := 313499;
+SET @PATH := @WPGUID * 10;
+DELETE FROM `waypoint_data` WHERE `id`= @PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES
+(@PATH, 0, -8407.187, 1319.194, 6.739105, NULL, 0),
+(@PATH, 1, -8402.29, 1322.5, 6.753046, NULL, 59263),
+(@PATH, 2, -8427.583, 1319.495, 9.85485, NULL, 0),
+(@PATH, 3, -8432.926, 1319.452, 6.907104, NULL, 56771);
+
+UPDATE `creature` SET `position_x`= -8407.187, `position_y`= 1319.194, `position_z`= 6.739105, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @WPGUID;
+DELETE FROM `creature_addon` WHERE `guid`= @WPGUID;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@WPGUID, @PATH, 1);
+
+ -- Justin Boehm smart ai
+SET @ENTRY := 29296;
+DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY*100;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(@ENTRY, 0, 0, 0, 34, 0, 100, 0, 2, 1, 0, 0, 80, 2929600, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Start timed action list id #2929600 (update out of combat)'),
+(@ENTRY, 0, 1, 0, 34, 0, 100, 0, 2, 3, 0, 0, 80, 2929600, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 3 - Self: Start timed action list id #2929600 (update out of combat)'),
+(@ENTRY*100, 9, 0, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 17, 379, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 3 seconds - Self: Set emote state to 379'),
+(@ENTRY*100, 9, 1, 0, 0, 0, 100, 0, 50000, 50000, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 50 seconds - Self: Set emote state to 0');
+
+ -- Darnassian Refugee & Displaced Gilnean Refugee smart ai
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` IN (-(@CGUID+17), -(@CGUID+7), -(@CGUID+20), -(@CGUID+6), -(@CGUID+16), -(@CGUID+8));
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` IN (140253, 140403);
+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
+(-(@CGUID+17), 0, 0, 0, 60, 0, 100, 0, 2000, 7000, 2000, 7000, 10, 603, 25, 1, 274, 6, 273, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 2 - 7 seconds - Self: Play random emote: 603, 25, 1, 274, 6, 273'),
+(-(@CGUID+7), 0, 0, 0, 60, 0, 100, 0, 2000, 7000, 2000, 7000, 10, 603, 25, 1, 274, 6, 273, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 2 - 7 seconds - Self: Play random emote: 603, 25, 1, 274, 6, 273'),
+(-(@CGUID+20), 0, 0, 0, 60, 0, 100, 0, 2000, 7000, 2000, 7000, 10, 603, 25, 1, 274, 6, 273, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 2 - 7 seconds - Self: Play random emote: 603, 25, 1, 274, 6, 273'),
+(-(@CGUID+6), 0, 0, 0, 60, 0, 100, 0, 2000, 7000, 2000, 7000, 10, 603, 25, 1, 274, 6, 273, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 2 - 7 seconds - Self: Play random emote: 603, 25, 1, 274, 6, 273'),
+(-(@CGUID+16), 0, 0, 0, 60, 0, 100, 0, 2000, 7000, 2000, 7000, 10, 603, 25, 1, 274, 6, 273, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 2 - 7 seconds - Self: Play random emote: 603, 25, 1, 274, 6, 273'),
+(-(@CGUID+8), 0, 0, 0, 60, 0, 100, 0, 2000, 7000, 2000, 7000, 10, 603, 25, 1, 274, 6, 273, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 2 - 7 seconds - Self: Play random emote: 603, 25, 1, 274, 6, 273');
+
+-- Phasing
+DELETE FROM `phase_area` WHERE `AreaId` = 1519 AND `PhaseId` = 11595;
+INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
+(1519, 11595, 'Cosmetic - See Darnassian and Gilnean Refugee in Stormwind');
+
+DELETE FROM `phase_name` WHERE `ID` = 11595;
+INSERT INTO `phase_name` (`ID`, `Name`) VALUES
+(11595, 'Cosmetic - See Darnassian and Gilnean Refugees');
+
+-- Condition
+DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 11595 AND `SourceEntry` = 1519);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES
+(26, 11595, 1519, 0, 0, 27, 0, 50, 3, 0, 0, 'Apply Phase 11585 If Player Level is equal or higher then 50');