If anyone wants to report an npc that is walking too fast here is the spot to do it.
-- fix walk speed for several npc's
UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry` IN
(19449, -- Thunderlord Grunt
17855); -- Expedition Warden[/sql]
If anyone wants to report an npc that is walking too fast here is the spot to do it.
-- fix walk speed for several npc's
UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry` IN
(19449, -- Thunderlord Grunt
17855); -- Expedition Warden[/sql]
Kinda off-topic:
SET @EquiEntry = XXX; -- (creature_equip_template.entry - need 1)
UPDATE `creature_template` SET `equipment_id`=@EquiEntry,`speed_walk`=1 WHERE `entry`=17855; -- Expedition Warden
DELETE FROM `creature_equip_template` WHERE `entry`=@EquiEntry;
INSERT INTO `creature_equip_template` (`entry`,`equipentry1`,`equipentry2`,`equipentry3`) VALUES
(@EquiEntry,14475,12523,32768);
UPDATE `creature_template_addon` SET `bytes1`=0,`bytes2`=257,`mount`=0,`emote`=0,`auras`=NULL WHERE `entry`=17855; -- Expedition Warden[/sql]