Trinitycore: ICC - Event before the entrance

[ForesterDev]

Description:
some creatures should run towards the icc entrance and some should fight with the Pustulent Horror and Vicious Geist every 3 minutes

npc: Knight of the Ebon Blade
npc: Argent Crusader

Branch(es): 3.3.5 / master

TC rev. hash/commit: 2139361319dcd235ad56e65015f324a7a5882e81

Operating system: win 10

[Killyana]

http://www.wowhead.com/npc=31147/vicious-geist#comments:id=910917
A large number of this NPC and a Pustulent Horror can occasionally be seen attacking the encampment outside of Icecrown Citadel, rather unsuccesfully though.
EDIT: A wave attacks from each side of the entrance, making that two Pustulent Horrors.

[Rushor]

sunwell has a script for this:

-- Lithe Stalker (30895)
DELETE FROM spell_target_position WHERE id=58119;
INSERT INTO spell_target_position VALUES (58119, 1, 571, 6471.59, 2044.12, 571, 5.88);
UPDATE creature_template SET minlevel=80, maxlevel=80, spell1=58282, spell2=58203, spell3=57882, spell4=58283, AIName='SmartAI', ScriptName='' WHERE entry=30895;
DELETE FROM smart_scripts WHERE entryorguid=30895 AND source_type=0;
INSERT INTO smart_scripts VALUES (30895, 0, 0, 0, 27, 0, 100, 1, 0, 0, 0, 0, 85, 58117, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Lithe Stalker - Passenger Boarded - Cast Force Scourge Reputation');
INSERT INTO smart_scripts VALUES (30895, 0, 1, 2, 28, 0, 100, 1, 0, 0, 0, 0, 28, 58117, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Lithe Stalker - Passenger Removed - Remove Aura Force Scourge Reputation');

-- Right and Left Camp Attack
DELETE FROM creature_addon WHERE guid IN(SELECT guid FROM creature WHERE id IN(38493, 38505));
DELETE FROM creature_formations WHERE leaderGUID IN(SELECT guid FROM creature WHERE id IN(38493, 38505));
INSERT INTO creature_formations VALUES (246905, 246905, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246905, 246900, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246905, 246901, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246905, 246902, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246905, 246904, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246905, 246906, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246905, 246907, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246915, 246915, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246915, 246910, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246915, 246911, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246915, 246912, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246915, 246913, 0, 0, 5, 0, 0);
INSERT INTO creature_formations VALUES (246915, 246914, 0, 0, 5, 0, 0);
DELETE FROM creature WHERE id IN(38493, 38505);
DELETE FROM creature_addon WHERE guid IN(123535, 123528);
DELETE FROM creature WHERE id=31139 AND guid IN(123535, 123528);
INSERT INTO creature VALUES (246900, 38493, 571, 1, 1, 0, 1, 5834.96, 2190.04, 636.042, 5.70036, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246901, 38493, 571, 1, 1, 0, 1, 5831.74, 2177.88, 636.042, 0.646328, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246902, 38493, 571, 1, 1, 0, 1, 5849.19, 2175.6, 636.042, 1.54954, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246903, 38493, 571, 1, 1, 0, 1, 5847.05, 2145.87, 636.042, 6.27764, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246904, 38493, 571, 1, 1, 0, 1, 5838.32, 2201.24, 636.042, 5.67288, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246905, 38493, 571, 1, 1, 0, 1, 5872.86, 2142.04, 636.042, 2.01685, 300, 0, 0, 65165, 0, 2, 0, 0, 0);
INSERT INTO creature VALUES (246906, 38505, 571, 1, 1, 0, 1, 5845.64, 2183.07, 636.042, 2.91221, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246907, 38505, 571, 1, 1, 0, 1, 5842.6, 2189.15, 636.042, 4.322, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246910, 38505, 571, 1, 1, 0, 1, 5922.95, 2039.25, 636.041, 1.52037, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246911, 38505, 571, 1, 1, 0, 1, 5908.02, 2033.22, 636.041, 1.69708, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246912, 38505, 571, 1, 1, 0, 1, 5894.38, 2032.71, 636.041, 0.428661, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246913, 38505, 571, 1, 1, 0, 1, 5882.94, 2054.38, 636.041, 1.33187, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246914, 38505, 571, 1, 1, 0, 1, 5905.04, 2055.25, 636.041, 4.88187, 300, 0, 0, 65165, 0, 0, 0, 0, 0);
INSERT INTO creature VALUES (246915, 38493, 571, 1, 1, 0, 1, 5910.19, 2068.75, 636.041, 5.33347, 300, 0, 0, 65165, 0, 2, 0, 0, 0);
REPLACE INTO creature_addon VALUES (246904, 0, 29937, 0, 4097, 0, '');
REPLACE INTO creature_addon VALUES (246905, 2469050, 29937, 0, 4097, 0, '');
DELETE FROM waypoint_data WHERE id=2469050;
INSERT INTO waypoint_data VALUES (2469050, 1, 5870.29, 2147.65, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 2, 5867.22, 2155.17, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 3, 5865.35, 2163.15, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 4, 5864.42, 2172.41, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 5, 5865.06, 2179.38, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 6, 5867.25, 2189.65, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 7, 5870.01, 2198.61, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 8, 5874.43, 2205.42, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 9, 5882.62, 2205.31, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 10, 5889.66, 2201.28, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 11, 5893.07, 2195.17, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 12, 5890.64, 2188.6, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 13, 5887.31, 2182.44, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 14, 5881.91, 2174.78, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 15, 5879.15, 2167.14, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 16, 5880.75, 2159.18, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 17, 5882.9, 2155.02, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 18, 5887.01, 2146.66, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 19, 5886.56, 2142.06, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 20, 5884.42, 2136.59, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 21, 5880.85, 2133.55, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 22, 5878.56, 2133.22, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 23, 5875.22, 2134.27, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 24, 5873.69, 2135.99, 636.042, 0, 0, 0, 0, 100, 0),(2469050, 25, 5872.12, 2140.42, 636.042, 0, 0, 0, 0, 100, 0);
REPLACE INTO creature_addon VALUES (246915, 2469150, 29937, 0, 4097, 0, '');
DELETE FROM waypoint_data WHERE id=2469150;
INSERT INTO waypoint_data VALUES (2469150, 1, 5913.05, 2065.04, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 2, 5917.99, 2060.07, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 3, 5925.71, 2054.87, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 4, 5936.31, 2049.94, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 5, 5946.34, 2046.82, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 6, 5954.52, 2046.6, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 7, 5960.7, 2050.03, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 8, 5963.44, 2055.16, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 9, 5963.36, 2059.85, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 10, 5961.52, 2065.36, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 11, 5954.64, 2069.68, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 12, 5946.58, 2070.59, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 13, 5937.28, 2071.07, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 14, 5929.96, 2074.59, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 15, 5923.44, 2081.23, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 16, 5918.98, 2089.4, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 17, 5916.49, 2093.29, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 18, 5913.62, 2095.3, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 19, 5910.21, 2096.08, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 20, 5908.02, 2095.35, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 21, 5905.89, 2094.44, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 22, 5903.17, 2092.24, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 23, 5901.87, 2089.06, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 24, 5901.34, 2085.6, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 25, 5903.01, 2079.96, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 26, 5905.72, 2074.75, 636.041, 0, 0, 0, 0, 100, 0),(2469150, 27, 5909.18, 2070.08, 636.041, 0, 0, 0, 0, 100, 0);
UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=38493;
DELETE FROM smart_scripts WHERE entryorguid IN(38493, -246904, -246915) AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid IN(38493*100, 38493*100+1) AND source_type=9;
INSERT INTO smart_scripts VALUES (-246904, 0, 0, 0, 60, 0, 100, 0, 180000, 180000, 180000, 180000, 80, 38493*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - On Update - Run Script');
INSERT INTO smart_scripts VALUES (-246904, 0, 1, 2, 17, 0, 100, 0, 0, 0, 0, 0, 45, 2, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - Just Summoned - Move Target To Position');
INSERT INTO smart_scripts VALUES (-246904, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 130, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 5869.55, 2192.07, 636.05, 0, 'Argent Cruasder - Just Summoned - Move Target To Position');
INSERT INTO smart_scripts VALUES (38493*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5869.55, 2192.07, 636.05, 0, 'Argent Cruasder - On Script - Move To Position');
INSERT INTO smart_scripts VALUES (38493*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 130, 1, 0, 0, 0, 0, 0, 10, 246900, 38493, 1, 5869.55, 2192.07, 636.05, 0, 'Argent Cruasder - On Script - Move Target To Position');
INSERT INTO smart_scripts VALUES (38493*100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 130, 1, 0, 0, 0, 0, 0, 10, 246901, 38493, 1, 5867.93, 2186.94, 636.05, 0, 'Argent Cruasder - On Script - Move Target To Position');
INSERT INTO smart_scripts VALUES (38493*100, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 130, 1, 0, 0, 0, 0, 0, 10, 246902, 38493, 1, 5866.62, 2189.55, 636.05, 0, 'Argent Cruasder - On Script - Move Target To Position');
INSERT INTO smart_scripts VALUES (38493*100, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 130, 1, 0, 0, 0, 0, 0, 10, 246906, 38505, 1, 5865.35, 2192.05, 636.05, 0, 'Argent Cruasder - On Script - Move Target To Position');
INSERT INTO smart_scripts VALUES (38493*100, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 130, 1, 0, 0, 0, 0, 0, 10, 246907, 38505, 1, 5864.19, 2194.34, 636.05, 0, 'Argent Cruasder - On Script - Move Target To Position');
INSERT INTO smart_scripts VALUES (38493*100, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 130, 1, 0, 0, 0, 0, 0, 10, 246905, 38493, 1, 5871.67, 2187.72, 636.05, 0, 'Argent Cruasder - On Script - Move Target To Position');
INSERT INTO smart_scripts VALUES (38493*100, 9, 7, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 12, 31139, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Pustulent Horror');
INSERT INTO smart_scripts VALUES (38493*100, 9, 8, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5943.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5937.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2230.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100, 9, 13, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2224.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100, 9, 14, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5943.53, 2230.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100, 9, 15, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5935.53, 2225.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100, 9, 16, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5941.53, 2222.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (-246915, 0, 0, 0, 60, 0, 100, 0, 180000, 180000, 180000, 180000, 80, 38493*100+1, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - On Update - Run Script');
INSERT INTO smart_scripts VALUES (-246915, 0, 1, 2, 17, 0, 100, 0, 0, 0, 0, 0, 45, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - Just Summoned - Set Data');
INSERT INTO smart_scripts VALUES (-246915, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 130, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 5911.48, 2049.00, 636.05, 0, 'Argent Cruasder - Just Summoned - Move Target To Position');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 0, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 12, 31139, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6018.40, 2091.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Pustulent Horror');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6018.40, 2091.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6018.40, 2093.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6015.40, 2092.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6022.40, 2091.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6019.40, 2088.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6017.40, 2094.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6020.40, 2095.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6014.40, 2090.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
INSERT INTO smart_scripts VALUES (38493*100+1, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6015.40, 2087.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');
UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry IN(31139, 31147);
DELETE FROM smart_scripts WHERE entryorguid IN(31139, 31147) AND source_type=0;
INSERT INTO smart_scripts VALUES (31139, 0, 0, 0, 38, 0, 100, 0, 1, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5911.48, 2049.00, 636.05, 0, 'Pustulent Horror - Is Summoned - Set Home Position');
INSERT INTO smart_scripts VALUES (31139, 0, 1, 0, 38, 0, 100, 0, 2, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5869.55, 2192.07, 636.05, 0, 'Pustulent Horror - Is Summoned - Set Home Position');
INSERT INTO smart_scripts VALUES (31147, 0, 0, 0, 38, 0, 100, 0, 1, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5911.48, 2049.00, 636.05, 0, 'Vicious Geist - Is Summoned - Set Home Position');
INSERT INTO smart_scripts VALUES (31147, 0, 1, 0, 38, 0, 100, 0, 2, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5869.55, 2192.07, 636.05, 0, 'Vicious Geist - Is Summoned - Set Home Position');

[Killyana]

This is an initial work:
``` sql

-- Right and Left Camp Attack
DELETE FROM creature_addon WHERE guid IN(SELECT guid FROM creature WHERE id IN(38493, 38505));
DELETE FROM creature_formations WHERE leaderGUID IN(77911,77919);
-- INSERT INTO creature_formations (leaderGUID, memberGUID, dist, angle, groupAI, point_1, point_2) VALUES
-- (77911, 77911, 5, 0, 5, 0, 0),
-- (77911, 77906, 5, 0, 5, 0, 0),
-- (77911, 77907, 5, 0, 5, 0, 0),
-- (77911, 77908, 5, 0, 5, 0, 0),
-- (77911, 77910, 5, 0, 5, 0, 0),
-- (77911, 77912, 5, 0, 5, 0, 0),
-- (77911, 77913, 5, 0, 5, 0, 0),
-- (77919, 77919, 5, 0, 5, 0, 0),
-- (77919, 77914, 5, 0, 5, 0, 0),
-- (77919, 77915, 5, 0, 5, 0, 0),
-- (77919, 77916, 5, 0, 5, 0, 0),
-- (77919, 77917, 5, 0, 5, 0, 0),
-- (77919, 77918, 5, 0, 5, 0, 0);

DELETE FROM creature WHERE id IN(38493, 38505);
DELETE FROM creature_addon WHERE guid IN(123535, 123528);
DELETE FROM creature WHERE id=31139 AND guid IN(123535, 123528);
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, curhealth, curmana, MovementType) VALUES
(77906, 38493, 571, 1, 1, 0, 1, 5834.96, 2190.04, 636.042, 5.70036, 300, 0, 0, 0, 0), -- 246900
(77907, 38493, 571, 1, 1, 0, 1, 5831.74, 2177.88, 636.042, 0.646328, 300, 0, 0, 0, 0), -- 246901
(77908, 38493, 571, 1, 1, 0, 1, 5849.19, 2175.6, 636.042, 1.54954, 300, 0, 0, 0, 0), -- 246902
(77909, 38493, 571, 1, 1, 0, 1, 5847.05, 2145.87, 636.042, 6.27764, 300, 0, 0, 0, 0), -- 246903
(77910, 38493, 571, 1, 1, 0, 1, 5838.32, 2201.24, 636.042, 5.67288, 300, 0, 0, 0, 0), -- 246904
(77911, 38493, 571, 1, 1, 0, 1, 5872.86, 2142.04, 636.042, 2.01685, 300, 0, 0, 0, 2), -- 246905
(77912, 38505, 571, 1, 1, 0, 1, 5845.64, 2183.07, 636.042, 2.91221, 300, 0, 0, 0, 0), -- 246906
(77913, 38505, 571, 1, 1, 0, 1, 5842.6, 2189.15, 636.042, 4.322, 300, 0, 0, 0, 0), -- 246907
(77914, 38505, 571, 1, 1, 0, 1, 5922.95, 2039.25, 636.041, 1.52037, 300, 0, 0, 0, 0), -- 246910
(77915, 38505, 571, 1, 1, 0, 1, 5908.02, 2033.22, 636.041, 1.69708, 300, 0, 0, 0, 0), -- 246911
(77916, 38505, 571, 1, 1, 0, 1, 5894.38, 2032.71, 636.041, 0.428661, 300, 0, 0, 0, 0), -- 246912
(77917, 38505, 571, 1, 1, 0, 1, 5882.94, 2054.38, 636.041, 1.33187, 300, 0, 0, 0, 0), -- 246913
(77918, 38505, 571, 1, 1, 0, 1, 5905.04, 2055.25, 636.041, 4.88187, 300, 0, 0, 0, 0), -- 246914
(77919, 38493, 571, 1, 1, 0, 1, 5910.19, 2068.75, 636.041, 5.33347, 300, 0, 0, 0, 2); -- 246915

DELETE FROM creature_addon WHERE guid IN(77910, 77911, 77919);
INSERT INTO creature_addon VALUES
(77910, 0, 29937, 0, 4097, 0, ''),
(77911, 779110, 29937, 0, 4097, 0, ''),
(77919, 779190, 29937, 0, 4097, 0, '');

DELETE FROM waypoint_data WHERE id=779110;
INSERT INTO waypoint_data VALUES
(779110, 1, 5870.29, 2147.65, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 2, 5867.22, 2155.17, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 3, 5865.35, 2163.15, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 4, 5864.42, 2172.41, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 5, 5865.06, 2179.38, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 6, 5867.25, 2189.65, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 7, 5870.01, 2198.61, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 8, 5874.43, 2205.42, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 9, 5882.62, 2205.31, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 10, 5889.66, 2201.28, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 11, 5893.07, 2195.17, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 12, 5890.64, 2188.6, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 13, 5887.31, 2182.44, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 14, 5881.91, 2174.78, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 15, 5879.15, 2167.14, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 16, 5880.75, 2159.18, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 17, 5882.9, 2155.02, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 18, 5887.01, 2146.66, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 19, 5886.56, 2142.06, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 20, 5884.42, 2136.59, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 21, 5880.85, 2133.55, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 22, 5878.56, 2133.22, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 23, 5875.22, 2134.27, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 24, 5873.69, 2135.99, 636.042, 0, 0, 0, 0, 100, 0),
(779110, 25, 5872.12, 2140.42, 636.042, 0, 0, 0, 0, 100, 0);

DELETE FROM waypoint_data WHERE id=779190;
INSERT INTO waypoint_data VALUES
(779190, 1, 5913.05, 2065.04, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 2, 5917.99, 2060.07, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 3, 5925.71, 2054.87, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 4, 5936.31, 2049.94, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 5, 5946.34, 2046.82, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 6, 5954.52, 2046.6, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 7, 5960.7, 2050.03, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 8, 5963.44, 2055.16, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 9, 5963.36, 2059.85, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 10, 5961.52, 2065.36, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 11, 5954.64, 2069.68, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 12, 5946.58, 2070.59, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 13, 5937.28, 2071.07, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 14, 5929.96, 2074.59, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 15, 5923.44, 2081.23, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 16, 5918.98, 2089.4, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 17, 5916.49, 2093.29, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 18, 5913.62, 2095.3, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 19, 5910.21, 2096.08, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 20, 5908.02, 2095.35, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 21, 5905.89, 2094.44, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 22, 5903.17, 2092.24, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 23, 5901.87, 2089.06, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 24, 5901.34, 2085.6, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 25, 5903.01, 2079.96, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 26, 5905.72, 2074.75, 636.041, 0, 0, 0, 0, 100, 0),
(779190, 27, 5909.18, 2070.08, 636.041, 0, 0, 0, 0, 100, 0);

UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry=38493;
DELETE FROM smart_scripts WHERE entryorguid IN(38493, -77910, -77919, -77906, -77907,-77908,-77912,-77913,-77911) AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid IN(38493100, 38493100+1) AND source_type=9;
INSERT INTO smart_scripts VALUES
(-77910, 0, 0, 0, 60, 0, 100, 0, 180000, 180000, 180000, 180000, 80, 38493*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - On Update - Run Script'),

(38493100, 9, 7, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 12, 31139, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Pustulent Horror'),
(38493100, 9, 8, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5943.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5937.53, 2227.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2230.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100, 9, 13, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5940.53, 2224.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100, 9, 14, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5943.53, 2230.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100, 9, 15, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5935.53, 2225.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100, 9, 16, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 5941.53, 2222.89, 636.05, 3.58, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),

(-77919, 0, 0, 0, 60, 0, 100, 0, 180000, 180000, 180000, 180000, 80, 38493*100+1, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - On Update - Run Script'),

(38493100+1, 9, 0, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 12, 31139, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6018.40, 2091.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Pustulent Horror'),
(38493100+1, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6018.40, 2091.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100+1, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6018.40, 2093.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100+1, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6015.40, 2092.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100+1, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6022.40, 2091.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100+1, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6019.40, 2088.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100+1, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6017.40, 2094.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100+1, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6020.40, 2095.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100+1, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6014.40, 2090.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist'),
(38493100+1, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 31147, 4, 30000, 0, 0, 0, 8, 0, 0, 0, 6015.40, 2087.17, 636.05, 3.47, 'Argent Cruasder - On Script - Summon Creature Vicious Geist');

UPDATE creature_template SET AIName='SmartAI', ScriptName='' WHERE entry IN(31139, 31147);
DELETE FROM smart_scripts WHERE entryorguid IN(31139, 31147) AND source_type=0;
INSERT INTO smart_scripts VALUES
(31139, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 100, 0, 0, 'Pustulent Horror - Is Summoned - Move offset'),
(31139, 0, 1, 0, 0, 0, 100, 512, 3000, 5000, 3000, 7000, 11, 28405, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Pustulent Horror - IC - Cast Knock Back'),
(31139, 0, 2, 0, 0, 0, 100, 512, 4000, 6000, 5000, 9000, 11, 63546, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Pustulent Horror - IC - Cast Stomp'),
(31147, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 100, 0, 0, 'Vicious Geist - Is Summoned - Move offset');

[Rushor]

according to creature_formations sunwell's groupai 5, in tc it would be groupai 3 once https://github.com/TrinityCore/TrinityCore/pull/18733 is merged