Advertisement
bucur35

Bellygrub

Sep 3rd, 2012
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.73 KB | None | 0 0
  1. -- Spawn Bellygrub
  2.  
  3. SET @GUID := 2136489;
  4.      
  5. DELETE FROM `creature` WHERE  `guid`=@GUID;
  6. 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
  7. (@GUID, 345, 0, 1, 1, 703, 0, -9279.562500, -1958.969568, 73.1899568, 2.521460, 300, 0, 0, 1, 0, 0, 0, 0, 0);
  8.  
  9. -- Q item
  10. DELETE FROM `creature_loot_template` WHERE  `entry`=0 AND `item`=0;
  11. INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  12. (345, 3631, 100, 1, 0, 1, 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement