sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20260404085149_world.sql
T
NickTyrer 34b2c6646e Pool EPL Thorium (credit cmangos) (#3328)
2026-04-06 10:33:27 +01:00

187 lines
17 KiB
SQL
Raw Permalink Blame History

DROP PROCEDURE IF EXISTS add_migration;
DELIMITER ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20260404085149');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20260404085149');
-- Add your query below.
SET @PTEMPLATE = 4673;
DELETE FROM `pool_pool` WHERE `pool_id` IN (1374, 1375, 14425, 14426, 1376, 1380);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 1' WHERE `entry` IN (1374, 1375, 14425, 14426, 1376, 1380);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 1' WHERE `pool_entry` IN (1374, 1375, 14425, 14426, 1376, 1380);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 1 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(1374, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Small Thorium Vein', 0),
(1375, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Small Thorium Vein', 0),
(14425, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Small Thorium Vein', 0),
(14426, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Small Thorium Vein', 0),
(1376, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Small Thorium Vein', 0),
(1380, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Small Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (14424, 1370, 1369, 1366, 1361);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 2' WHERE `entry` IN (14424, 1370, 1369, 1366, 1361);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 2' WHERE `pool_entry` IN (14424, 1370, 1369, 1366, 1361);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+2, 1, 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 2 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(14424, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Small Thorium Vein', 0),
(1370, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Small Thorium Vein', 0),
(1369, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Small Thorium Vein', 0),
(1366, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Small Thorium Vein', 0),
(1361, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Small Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (1373, 1372, 1367, 17007, 1371);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 3' WHERE `entry` IN (1373, 1372, 1367, 17007, 1371);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 3' WHERE `pool_entry` IN (1373, 1372, 1367, 17007, 1371);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+3, 1, 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 3 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(1373, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Small Thorium Vein', 0),
(1372, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Small Thorium Vein', 0),
(1367, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Small Thorium Vein', 0),
(17007, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Small Thorium Vein', 0),
(1371, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Small Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (1363, 1365, 1362, 1360, 1364);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 4' WHERE `entry` IN (1363, 1365, 1362, 1360, 1364);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 4' WHERE `pool_entry` IN (1363, 1365, 1362, 1360, 1364);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+4, 1, 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 4 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(1363, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Small Thorium Vein', 0),
(1365, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Small Thorium Vein', 0),
(1362, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Small Thorium Vein', 0),
(1360, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Small Thorium Vein', 0),
(1364, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Small Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (1381, 1377, 1378, 1379, 9438);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 5' WHERE `entry` IN (1381, 1377, 1378, 1379, 9438);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 5' WHERE `pool_entry` IN (1381, 1377, 1378, 1379, 9438);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+5, 1, 'Truesilver Deposit / Small Thorium Vein - Eastern Plaguelands - Group 5 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(1381, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Small Thorium Vein', 0),
(1377, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Small Thorium Vein', 0),
(1378, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Small Thorium Vein', 0),
(1379, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Small Thorium Vein', 0),
(9438, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Small Thorium Vein', 0);
DELETE FROM `pool_template` WHERE `entry` = 1264;
SET @PTEMPLATE = 4678;
DELETE FROM `pool_pool` WHERE `pool_id` IN (1435, 1417, 1415, 1434, 1413, 1368);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 1' WHERE `entry` IN (1435, 1417, 1415, 1434, 1413, 1368);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 1' WHERE `pool_entry` IN (1435, 1417, 1415, 1434, 1413, 1368);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 1 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(1435, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Rich Thorium Vein', 0),
(1417, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Rich Thorium Vein', 0),
(1415, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Rich Thorium Vein', 0),
(1434, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Rich Thorium Vein', 0),
(1413, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Rich Thorium Vein', 0),
(1368, @PTEMPLATE+1, 0, 'Eastern Plaguelands - Group 1 - Truesilver Deposit / Rich Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (1418, 1420, 1421, 1419, 1416, 1414);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 2' WHERE `entry` IN (1418, 1420, 1421, 1419, 1416, 1414);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 2' WHERE `pool_entry` IN (1418, 1420, 1421, 1419, 1416, 1414);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+2, 1, 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 2 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(1418, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Rich Thorium Vein', 0),
(1420, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Rich Thorium Vein', 0),
(1421, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Rich Thorium Vein', 0),
(1419, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Rich Thorium Vein', 0),
(1416, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Rich Thorium Vein', 0),
(1414, @PTEMPLATE+2, 0, 'Eastern Plaguelands - Group 2 - Truesilver Deposit / Rich Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (14436, 1428, 1436, 14435, 9433, 1431);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 3' WHERE `entry` IN (14436, 1428, 1436, 14435, 9433, 1431);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 3' WHERE `pool_entry` IN (14436, 1428, 1436, 14435, 9433, 1431);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+3, 1, 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 3 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(14436, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Rich Thorium Vein', 0),
(1428, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Rich Thorium Vein', 0),
(1436, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Rich Thorium Vein', 0),
(14435, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Rich Thorium Vein', 0),
(9433, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Rich Thorium Vein', 0),
(1431, @PTEMPLATE+3, 0, 'Eastern Plaguelands - Group 3 - Truesilver Deposit / Rich Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (9427, 3986, 1423, 1422, 9428);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 4' WHERE `entry` IN (9427, 3986, 1423, 1422, 9428);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 4' WHERE `pool_entry` IN (9427, 3986, 1423, 1422, 9428);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+4, 1, 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 4 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(9427, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Rich Thorium Vein', 0),
(3986, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Rich Thorium Vein', 0),
(1423, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Rich Thorium Vein', 0),
(1422, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Rich Thorium Vein', 0),
(9428, @PTEMPLATE+4, 0, 'Eastern Plaguelands - Group 4 - Truesilver Deposit / Rich Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (1411, 14438, 9429, 1409, 3985);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 5' WHERE `entry` IN (1411, 14438, 9429, 1409, 3985);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 5' WHERE `pool_entry` IN (1411, 14438, 9429, 1409, 3985);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+5, 1, 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 5 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(1411, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Rich Thorium Vein', 0),
(14438, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Rich Thorium Vein', 0),
(9429, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Rich Thorium Vein', 0),
(1409, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Rich Thorium Vein', 0),
(3985, @PTEMPLATE+5, 0, 'Eastern Plaguelands - Group 5 - Truesilver Deposit / Rich Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (1429, 1427, 1425, 9430, 1426);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 6' WHERE `entry` IN (1429, 1427, 1425, 9430, 1426);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 6' WHERE `pool_entry` IN (1429, 1427, 1425, 9430, 1426);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+6, 1, 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 6 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(1429, @PTEMPLATE+6, 0, 'Eastern Plaguelands - Group 6 - Truesilver Deposit / Rich Thorium Vein', 0),
(1427, @PTEMPLATE+6, 0, 'Eastern Plaguelands - Group 6 - Truesilver Deposit / Rich Thorium Vein', 0),
(1425, @PTEMPLATE+6, 0, 'Eastern Plaguelands - Group 6 - Truesilver Deposit / Rich Thorium Vein', 0),
(9430, @PTEMPLATE+6, 0, 'Eastern Plaguelands - Group 6 - Truesilver Deposit / Rich Thorium Vein', 0),
(1426, @PTEMPLATE+6, 0, 'Eastern Plaguelands - Group 6 - Truesilver Deposit / Rich Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (14437, 1424, 9434, 9435, 1430);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 7' WHERE `entry` IN (14437, 1424, 9434, 9435, 1430);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 7' WHERE `pool_entry` IN (14437, 1424, 9434, 9435, 1430);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+7, 1, 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 7 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(14437, @PTEMPLATE+7, 0, 'Eastern Plaguelands - Group 7 - Truesilver Deposit / Rich Thorium Vein', 0),
(1424, @PTEMPLATE+7, 0, 'Eastern Plaguelands - Group 7 - Truesilver Deposit / Rich Thorium Vein', 0),
(9434, @PTEMPLATE+7, 0, 'Eastern Plaguelands - Group 7 - Truesilver Deposit / Rich Thorium Vein', 0),
(9435, @PTEMPLATE+7, 0, 'Eastern Plaguelands - Group 7 - Truesilver Deposit / Rich Thorium Vein', 0),
(1430, @PTEMPLATE+7, 0, 'Eastern Plaguelands - Group 7 - Truesilver Deposit / Rich Thorium Vein', 0);
DELETE FROM `pool_pool` WHERE `pool_id` IN (1432, 9431, 1433, 9432);
UPDATE `pool_template` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 8' WHERE `entry` IN (1432, 9431, 1433, 9432);
UPDATE `pool_gameobject` SET `description` = 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 8' WHERE `pool_entry` IN (1432, 9431, 1433, 9432);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+8, 1, 'Truesilver Deposit / Rich Thorium Vein - Eastern Plaguelands - Group 8 - Master', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(1432, @PTEMPLATE+8, 0, 'Eastern Plaguelands - Group 8 - Truesilver Deposit / Rich Thorium Vein', 0),
(9431, @PTEMPLATE+8, 0, 'Eastern Plaguelands - Group 8 - Truesilver Deposit / Rich Thorium Vein', 0),
(1433, @PTEMPLATE+8, 0, 'Eastern Plaguelands - Group 8 - Truesilver Deposit / Rich Thorium Vein', 0),
(9432, @PTEMPLATE+8, 0, 'Eastern Plaguelands - Group 8 - Truesilver Deposit / Rich Thorium Vein', 0);
DELETE FROM `pool_template` WHERE `entry` IN (1412, 1410, 1408, 8135, 8133, 8136, 8134, 325, 8132, 8137);
DELETE FROM `gameobject` WHERE `guid` IN (24980, 25009, 24982, 25011, 24984, 25013);
DELETE FROM `pool_gameobject` WHERE `pool_entry` IN (1412, 1410, 1408);
DELETE FROM `pool_pool` WHERE `pool_id` IN (1412, 1410, 1408);
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in New Issue View Git Blame Copy Permalink