Npc Garrosh Hellscream Warsong Hold Fix 7.02

[eyerobot]

The wrong Garrosh hellscream was spawned in Warsong Hold.
The correct one is 25237

DELETE FROM `creature` WHERE `id`=25237;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (725746, 25237, 571, 3537, 4129, 1, 65535, 0, 25237, 2839.24, 6187.76, 84.6831, 3.89442, 300, 0, 0, 100, 0, 0, 0, 0, 0, 0);

This query will not remove the wrong Garrosh Hellscream from Warsong Hold. I would have included that, But it was my wife that removed the old one, So I no longer have his info.

 

[ExO]

Executed thanks!

Remember when doing delete creature where guid = xx also do `id` = creature (because guid may be different), but I corrected it so np

 

[eyerobot]

I didn't even notice it came out that way. let me fix it for everyone else real quick.
I just had a conversation with my wife about not removing npc's. So that i can get their guid numbers before i zap them.