Guest User

Untitled

a guest
Apr 20th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.79 KB | None | 0 0
  1. -- Fix for Skoll(35189)
  2. -- Adding spawns in pool
  3. DELETE FROM `pool_creature` WHERE `pool_entry`=35189;
  4. INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `comment`, `description`) VALUES
  5. (404345,35189,0.0, '','Skoll(35189) - Spawn 1'), -- North West
  6. (404346,35189,0.0, '','Skoll(35189) - Spawn 2'), -- North East
  7. (404347,35189,0.0, '','Skoll(35189) - Spawn 3'), -- West
  8. (404348,35189,0.0, '','Skoll(35189) - Spawn 4'), -- East south East
  9. (404349,35189,0.0, '','Skoll(35189) - Spawn 5'); -- East South West
  10. DELETE FROM `pool_template` WHERE `entry`=100000;
  11. INSERT INTO `pool_template` (`entry`, `max_limit`, `comment`, `description`) VALUES
  12. (100000, 1, '', 'Skoll(35189)');
  13. DELETE FROM `creature` WHERE `id` = 35189;
  14. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
  15. (404345, 35189, 571, 1, 1, 0, 0,7791.978,-135.737,880.305, 3.64, 129600, 3, 0, 18900, 0, 1),
  16. (404346, 35189, 571, 1, 1, 0, 0,7792.886,-257.132,891.531, 3.64, 108000, 5, 0, 18900, 0, 1),
  17. (404347, 35189, 571, 1, 1, 0, 0,7149.754,-326.094,799.686, 3.64, 43200, 3, 0, 18900, 0, 1),
  18. (404348, 35189, 571, 1, 1, 0, 0,7234.498,-1310.097,916.610, 3.64, 86400, 10, 0, 18900, 0, 1),
  19. (404349, 35189, 571, 1, 1, 0, 0,7109.498,-1425.345,923.268, 3.64, 64800, 5, 0, 18900, 0, 1);
  20. UPDATE `creature_template` SET `skinloot`=35189 WHERE `entry` = 35189;
  21. DELETE FROM `skinning_loot_template` WHERE `entry`=35189;
  22. INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
  23. (35189, 33568, 100, 1, 0, 1, 3, 0, 0, 0);
Add Comment
Please, Sign In to add comment