Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Spawn Bellygrub
- SET @GUID := 2136489;
- DELETE FROM `creature` WHERE `guid`=@GUID;
- 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, 345, 0, 1, 1, 703, 0, -9279.562500, -1958.969568, 73.1899568, 2.521460, 300, 0, 0, 1, 0, 0, 0, 0, 0);
- -- Q item
- DELETE FROM `creature_loot_template` WHERE `entry`=0 AND `item`=0;
- INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
- (345, 3631, 100, 1, 0, 1, 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement