Bring the Hammer Down

/***************************
   Bring the Hammer Down
***************************/

-- Script

SET @GUID := xxxxx;

DELETE FROM `creature_template` WHERE  `entry`=46203 LIMIT 1;
INSERT INTO `creature_template` (`entry`, `modelid1`,`modelid2`,  `modelid3`,  `modelid4`,  `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `faction_A`, `faction_H`, `speed_run`, `mindmg`,
`maxdmg`, `attackpower`, `baseattacktime`, `unit_class`, `dynamicflags`, `family`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`,
`lootid`, `skinloot`, `InhabitType`, `questItem1`, `equipment_id`, `WDBVerified`) VALUES
(46203, 34959, 34960, 34961, 34962, 'Twilight Vindicator', '', '', 84, 85, 16, 16, 1, 530, 713, 106, 2000, 1, 0, 0, 399, 559, 169, 7, 0, 46203, 0, 1, 0, 0, 1);

-- Spawn NPC

DELETE FROM `creature` WHERE  `guid`=@GUID LIMIT 1;
INSERT INTO `creature` (`guid`,  `id`,  `map`,  `spawnMask`,  `phaseMask`,  `modelid`,  `equipment_id`,  `position_x`,  `position_y`,  `position_z`,
`orientation`,  `spawntimesecs`,  `spawndist`,  `currentwaypoint`,  `curhealth`,  `curmana`,  `MovementType`,  `npcflag`,  `unit_flags`,  `dynamicflags`) VALUES
(@Guid+0, 46203, 0, 1, 2, 0, 0, -5154.72,   -4656.38, 354.510, 4.929660, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+1, 46203, 0, 1, 2, 0, 0, -5132.19,   -4731.93, 350.574, 5.200620, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+2, 46203, 0, 1, 2, 0, 0, -5056.11,   -4554.43, 356.516, 1.356100, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+3, 46203, 0, 1, 2, 0, 0, -5080.44,   -4465.46, 355.544, 0.358644, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+4, 46203, 0, 1, 2, 0, 0, -4892.70,   -4446.74, 320.970, 6.147030, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+5, 46203, 0, 1, 2, 0, 0, -4774.98,   -4412.43, 314.970, 0.417547, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+6, 46203, 0, 1, 2, 0, 0, -4536.96,   -4266.54, 322.742, 0.727780, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+7, 46203, 0, 1, 2, 0, 0, -4557.00,   -4228.19, 325.825, 2.149350, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+8, 46203, 0, 1, 2, 0, 0, -4501.62,   -4237.38, 331.260, 5.436250, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+9, 46203, 0, 1, 2, 0, 0, -4496.92,   -4266.76, 332.274, 5.220260, 300, 9, 0, 46, 0, 1, 0, 0, 0),
(@Guid+10, 46203,   0,  1,  2,  0,  0,  -4429.13, -4309.18, 325.509, 5.428390, 300, 9, 0, 46,   0,  1,  0,  0,  0),
(@Guid+11, 46203,   0,  1,  2,  0,  0,  -4476.93, -4337.68, 323.521, 3.048630, 300, 9, 0, 46,   0,  1,  0,  0,  0),
(@Guid+12, 46203,   0,  1,  2,  0,  0,  -5161.55, -4609.56, 358.882, 4.788290,  300, 9, 0, 46,  0,  1,  0,  0,  0),
(@Guid+13, 46203,   0,  1,  2,  0,  0,  -5207.71, -4449.02, 377.409, 0.500014,  300, 9, 0, 46,  0,  1,  0,  0,  0),
(@Guid+14, 46203,   0,  1,  2,  0,  0,  -5224.44, -4458.68, 380.112, 2.314280,  300, 9, 0, 46,  0,  1,  0,  0,  0),
(@Guid+15, 46203,   0,  1,  2,  0,  0,  -5184.79, -4518.18, 354.864, 1.081210,  300, 9, 0, 46,  0,  1,  0,  0,  0),
(@Guid+16, 46203,   0,  1,  2,  0,  0,  -5198.96, -4546.47, 352.787, 1.336460,  300, 9, 0, 46,  0,  1,  0,  0,  0),
(@Guid+17, 46203,   0,  1,  2,  0,  0,  -5174.86, -4575.63, 357.814, 2.373190,  300, 9, 0, 46, 0,   1,  0,  0,  0),
(@Guid+18, 46203,   0,  1,  2,  0,  0,  -4474.40, -4568.84, 187.421, 3.912570,  300, 9, 0, 46,  0,  1,  0,  0,  0),
(@Guid+17, 46203,   0,  1,  2,  0,  0,  -4402.51, -4504.05, 201.067, 3.892940,  300, 9, 0, 46,  0,  1,  0,  0,  0),
(@Guid+18, 46203,   0,  1,  2,  0,  0,  -4387.27, -4524.90, 192.779, 3.943990,  300, 9, 0, 46, 0,   1,  0,  0,  0),
(@Guid+19, 46203,   0,  1,  2,  0,  0,  -4389.85, -4500.07, 199.605, 3.001510,  300, 9, 0, 46,  0,  1,  0,  0,  0),
(@Guid+20, 46203,   0,  1,  2,  0,  0,  -4369.33, -4523.46, 189.372, 4.340610,  300, 9, 0, 46,  0,  1,  0,  0,  0),
(@Guid+21, 46203,   0,  1,  2,  0,  0,  -4376.24, -4478.44, 201.577, 3.390280,  300, 9, 0, 46,  0,  1,  0,  0,  0);

-- Assign

UPDATE `creature_questrelation` SET `id`=46203, `quest`=27654;