Argent Riders

-- ARGENT RIDERS SPAWN
DELETE FROM `creature` WHERE `id`='11102';
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
VALUES
('11102', '0', '1', '1', '0', '0', '2348.42', '-5291.46', '83.5432', '5.49667', '600', '0', '0', '24416', '0', '0', '0'),
('11102', '0', '1', '1', '0', '0', '2345.25', '-5295.37', '83.4182', '5.48989', '600', '0', '0', '24416', '0', '0', '2');
UPDATE creature_template SET `modelid2` = "10562", `modelid3` = "0", `minlevel` = "60", `maxlevel` = "60", `minhealth` = "24416", `maxhealth` = "24416", `armor` = "3750", `faction_A` = "794", `faction_H` = "794", `speed_walk` = "1", `speed_run` = "1.38571", `maxdmg` = "144", `attackpower` = "36", `dmg_multiplier` = "3.6", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "512", `minrangedmg` = "77", `maxrangedmg` = "115", `rangedattackpower` = "29", `mingold` = "0", `maxgold` = "0" WHERE entry=11102;

-- MOVEMENT
SET @guid=(SELECT `guid` FROM `creature` WHERE `id`='11102' AND `MovementType`='2');
SET @guid2=(SELECT `guid` FROM `creature` WHERE `id`='11102' AND `MovementType`='0');
DELETE FROM `creature_movement` WHERE `id`=@guid;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`)
VALUES
(@guid, '1', '2343.79', '-5292.86', '83.0378', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '2', '2332.99', '-5279.48', '81.772', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '3', '2321.77', '-5269.6', '82.4866', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '4', '2311.33', '-5265.62', '82.6097', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '5', '2293.43', '-5266.33', '81.9087', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '6', '2275.25', '-5268.16', '81.2737', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '7', '2261.36', '-5265.3', '79.2683', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '8', '2241.24', '-5266.45', '76.1552', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '9', '2227.64', '-5271.48', '77.3005', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '10', '2245.63', '-5264.25', '76.2871', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '11', '2264.43', '-5259.57', '78.4057', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '12', '2283.01', '-5260.56', '81.0241', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '13', '2304.04', '-5263.8', '82.3756', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '14', '2324.28', '-5272.41', '82.1822', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(@guid, '15', '2332.13', '-5279.84', '81.7747', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

-- FOLLOW W/ FORMATION
INSERT INTO `creature_linking_template` () VALUES
(@guid2, @guid, '4096');