diff options
| author | Killyana <morphone1@gmail.com> | 2020-01-25 22:08:26 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-20 23:47:37 +0100 |
| commit | 885b6fa6979fb6766eeeaaf110304fc3cc4a9c62 (patch) | |
| tree | 886306a3e30a0323875b53af254aa5ad380997ee | |
| parent | 2452b9c7f7a25912792db6256d128bd8b0f236f2 (diff) | |
DB/Creature: Lost Soul pooling
(cherry picked from commit 14517326668ee97f1017ea24e9b56fbcde7557b7)
| -rw-r--r-- | sql/updates/world/master/2021_12_20_29_world_2020_01_25_05_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_20_29_world_2020_01_25_05_world.sql b/sql/updates/world/master/2021_12_20_29_world_2020_01_25_05_world.sql new file mode 100644 index 00000000000..d253a8651a5 --- /dev/null +++ b/sql/updates/world/master/2021_12_20_29_world_2020_01_25_05_world.sql @@ -0,0 +1,12 @@ +-- Lost Soul +SET @POOL := 351; +DELETE FROM `pool_template` WHERE `entry` = @POOL; +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(@POOL, 1, 'Lost Soul'); +DELETE FROM `pool_members` WHERE `poolSpawnId` = @POOL; +INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES +(0, 325765, @POOL, 0, "Lost Soul - Spawn 1"), +(0, 325966, @POOL, 0, "Lost Soul - Spawn 2"), +(0, 325970, @POOL, 0, "Lost Soul - Spawn 3"); + +-- UPDATE `creature` SET `position_x`=2757.901611, `position_y`=859.967407, `position_z`=113.202911 WHERE `guid` = 44863; |