diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2024-10-02 21:55:18 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-10-02 21:55:18 +0200 |
| commit | 03333b1ec4248dd251c4014a8c7307da2b8157ed (patch) | |
| tree | b72adb1d23246514c40884f5e6951a9aefb7d08f | |
| parent | fd85a71f5dcd3f2ef72699af86033638cc96890c (diff) | |
DB/Loot: Fix thorium ore prospection sometimes resulting in 0 items
closes #30284 by meji46
| -rw-r--r-- | sql/updates/world/3.3.5/2024_10_02_00_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
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); |