Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @CGUID = XXXXXX;
- SET @POOL = XXXXXX;
- DELETE FROM `creature` WHERE `guid` IN (@CGUID, @CGUID+1, @CGUID+2,@CGUID+3);
- INSERT INTO `creature` VALUES
- (@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),
- (@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),
- (@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),
- (@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);
- DELETE FROM `pool_template` WHERE `entry` IN (@POOL, @POOL+1);
- INSERT INTO `pool_template` VALUES
- (@POOL, 1, 'Dr. Whitherlimb '),
- (@POOL+1, 1, 'Dr. Whitherlimb 2 ');
- DELETE FROM `pool_creature` WHERE `pool_entry` IN (@POOL, @POOL+1);
- INSERT INTO `pool_creature` VALUES
- (@CGUID, @POOL, 33, 'Dr. Whitherlimb spawn loc 1'),
- (@CGUID+1, @POOL, 33, 'Dr. Whitherlimb spawn loc 2'),
- (@CGUID+2, @POOL, 33, 'Dr. Whitherlimb spawn loc 3'),
- (@CGUID+3, @POOL+1, 50, 'Dr. Whitherlimb spawn loc 4'),
- (82907, @POOL+1, 50, 'Masophet the Black spawn');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement