Gath'Ilzogg

-- Spawn Gath'Ilzogg

SET @GUID := xxxxx;

DELETE FROM `creature` WHERE  `id`=334;
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, 334, 0, 1, 1, 6050, 0, -9383.098633, -3081.347412, 157.872345, 1.700709, 300, 0, 0, 1, 0, 0, 0, 0, 0);

DELETE FROM `creature_loot_template` WHERE  `entry`=0 AND `item`=0;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(334, 3633, 100, 1, 0, 1, 1);