ss

-- Quests Sprout No More and Fungal Monstrosities

UPDATE `creature_template` SET `ScriptName` = "npc_war_guardian" WHERE `entry` = 44126;

UPDATE `creature_template` SET `exp` = 3, `ScriptName` = "npc_war_guardian_follower" WHERE `entry` = 44118;

UPDATE `creature_template` SET `ScriptName` = "npc_giant_mushroom" WHERE `entry` = 44049;

-- quest flags
UPDATE `quest_template` SET `QuestFlags` = 0 WHERE `entry` = 26791;

SET @GUID:= 530000; -- last guid;
-- corect spawn position
DELETE FROM `creature` WHERE `id` = 44126;
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,'44126','646','1','1','0','0','1276.26','1647.29','174.011','5.23412','300','0','0','278900','0','0','0','0','0');