From 03333b1ec4248dd251c4014a8c7307da2b8157ed Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 2 Oct 2024 21:55:18 +0200 Subject: DB/Loot: Fix thorium ore prospection sometimes resulting in 0 items closes #30284 by meji46 --- sql/updates/world/3.3.5/2024_10_02_00_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/3.3.5/2024_10_02_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2024_10_02_00_world.sql b/sql/updates/world/3.3.5/2024_10_02_00_world.sql new file mode 100644 index 00000000000..7c5cc2b4193 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_02_00_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `prospecting_loot_template` WHERE `Entry`=10620 AND `Reference`=13001; +DELETE FROM `prospecting_loot_template` WHERE `Entry`=10620 AND `Item` IN (21929,23077,23079,23107,23112,23117); +INSERT INTO `prospecting_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(10620,21929,0,0,0,1,1,1,2,NULL), +(10620,23077,0,0,0,1,1,1,2,NULL), +(10620,23079,0,0,0,1,1,1,2,NULL), +(10620,23107,0,0,0,1,1,1,2,NULL), +(10620,23112,0,0,0,1,1,1,2,NULL), +(10620,23117,0,0,0,1,1,1,2,NULL); -- cgit v1.2.3