ratkosrb
80 lines
4.5 KiB
SQL
80 lines
4.5 KiB
SQL
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`='20251207124458');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20251207124458');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Dark Cleric Salem's Chest
|
|
UPDATE `gameobject_template` SET `data1`=15360 WHERE `entry`=178464;
|
|
-- To prevent startup errors, add the key itself to the chest.
|
|
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`, `patch_min`, `patch_max`) VALUES (15360, 17242, 100, 0, 1, 1, 0, 0, 10);
|
|
|
|
-- Stolen Chest
|
|
UPDATE `gameobject_template` SET `data1`=15380 WHERE `entry`=178504;
|
|
-- To prevent startup errors, add the key itself to the chest.
|
|
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`, `patch_min`, `patch_max`) VALUES (15380, 17262, 100, 0, 1, 1, 0, 0, 10);
|
|
|
|
-- Drek'Thar's Scrolls
|
|
UPDATE `gameobject_template` SET `data1`=15920 WHERE `entry`=179004;
|
|
|
|
-- Drek'Thar's Scrolls
|
|
UPDATE `gameobject_template` SET `data1`=15920 WHERE `entry`=179005;
|
|
|
|
-- Vanndar's Documents
|
|
UPDATE `gameobject_template` SET `data1`=15921 WHERE `entry`=179006;
|
|
|
|
-- Vanndar's Documents
|
|
UPDATE `gameobject_template` SET `data1`=15921 WHERE `entry`=179007;
|
|
|
|
-- Vanndar's Documents
|
|
UPDATE `gameobject_template` SET `data1`=15921 WHERE `entry`=179008;
|
|
|
|
-- Four Horsemen Chest
|
|
UPDATE `gameobject_template` SET `data1`=18036 WHERE `entry`=181366;
|
|
UPDATE `gameobject_loot_template` SET `entry`=18036 WHERE `entry`=181366;
|
|
|
|
-- Arena Spoils
|
|
UPDATE `gameobject_template` SET `data1`=17918 WHERE `entry`=181074;
|
|
UPDATE `gameobject_loot_template` SET `entry`=17918 WHERE `entry`=181074;
|
|
|
|
-- Steamsaw
|
|
UPDATE `gameobject_template` SET `data1`=15561 WHERE `entry` IN (178664, 178665);
|
|
UPDATE `gameobject_loot_template` SET `entry`=15561 WHERE `item`=17411;
|
|
DELETE FROM `gameobject_template` WHERE `entry`=300000;
|
|
DELETE FROM `gameobject` WHERE `id`=300000;
|
|
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`) VALUES (407814, 178664, 30, 495.966, -525.183, 67.6816, 2.70526, 0, 0, 0.976295, 0.216442, 300, 300, 100, 1, 0, 0, 3);
|
|
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`) VALUES (407815, 178665, 30, -484.905, -397.004, 28.4078, 3.31614, 0, 0, -0.996194, 0.087165, 300, 300, 100, 1, 0, 0, 3);
|
|
|
|
-- Hidden Strongbox - Bloodstone Pendant
|
|
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`, `patch_min`, `patch_max`) VALUES (1711, 3744, -100, 0, 1, 1, 0, 0, 10);
|
|
|
|
-- Deepmoss Eggs - Deepmoss Egg
|
|
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`, `patch_min`, `patch_max`) VALUES (3081, 5570, -80, 0, 1, 1, 0, 0, 10);
|
|
|
|
-- Agamand Weapon Rack - Agamand Family Mace
|
|
DELETE FROM `gameobject_loot_template` WHERE `entry`=4766;
|
|
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`, `patch_min`, `patch_max`) VALUES (4766, 7569, -100, 0, 1, 1, 0, 0, 10);
|
|
|
|
-- Agamand Weapon Rack - Agamand Family Dagger
|
|
DELETE FROM `gameobject_loot_template` WHERE `entry`=4767;
|
|
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`, `patch_min`, `patch_max`) VALUES (4767, 7568, -100, 0, 1, 1, 0, 0, 10);
|
|
|
|
-- Drek'Thar's Scrolls - Frostwolf Maps
|
|
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`, `patch_min`, `patch_max`) VALUES (15920, 17822, -100, 0, 1, 1, 0, 3, 10);
|
|
|
|
-- Vanndar's Documents - Stormpike Battle Plans
|
|
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`, `patch_min`, `patch_max`) VALUES (15921, 17823, -100, 0, 1, 1, 0, 3, 10);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|