Advertisement
KolumbPL

Dr Whitherlimb

Feb 25th, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.08 KB | None | 0 0
  1. SET @CGUID = XXXXXX;
  2. SET @POOL = XXXXXX;
  3.  
  4. DELETE FROM `creature` WHERE `guid` IN (@CGUID, @CGUID+1, @CGUID+2,@CGUID+3);
  5. INSERT INTO `creature` VALUES
  6. (@CGUID, 22062, 530, 1, 1, 0, 0, 7170.17, -6615.04, 63.65, 2.81, 600, 0, 0, 1, 0, 0, 0, 0, 0, 0),
  7. (@CGUID+1, 22062, 530, 1, 1, 0, 0, 7223.39, -6415.25, 57.73, 0.32, 600, 0, 0, 1, 0, 0, 0, 0, 0, 0),
  8. (@CGUID+2, 22062, 530, 1, 1, 0, 0, 6310.87, -6249.58, 80.81, 2.37, 600, 0, 0, 1, 0, 0, 0, 0, 0, 0),
  9. (@CGUID+3, 22062, 530, 1, 1, 0, 0, 6305.87, -6463.66, 86.28, 3.92, 600, 0, 0, 1, 0, 0, 0, 0, 0, 0);
  10.  
  11. DELETE FROM `pool_template` WHERE `entry` IN (@POOL, @POOL+1);
  12. INSERT INTO `pool_template` VALUES
  13. (@POOL, 1, 'Dr. Whitherlimb '),
  14. (@POOL+1, 1, 'Dr. Whitherlimb 2 ');
  15.  
  16. DELETE FROM `pool_creature` WHERE `pool_entry` IN (@POOL, @POOL+1);
  17. INSERT INTO `pool_creature` VALUES
  18. (@CGUID, @POOL, 33, 'Dr. Whitherlimb spawn loc 1'),
  19. (@CGUID+1, @POOL, 33, 'Dr. Whitherlimb spawn loc 2'),
  20. (@CGUID+2, @POOL, 33, 'Dr. Whitherlimb spawn loc 3'),
  21.  
  22. (@CGUID+3, @POOL+1, 50, 'Dr. Whitherlimb spawn loc 4'),
  23. (82907, @POOL+1, 50, 'Masophet the Black spawn');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement