diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-03 17:19:44 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-02 00:41:08 +0100 |
| commit | 316abe9d77180672be634559b30936ae5fe89cc3 (patch) | |
| tree | da7fa6b09555efedb10c1bcb39854eae64abcfae | |
| parent | 8bf9637c3c61fd60a9127af99336c1dabe7fe6ee (diff) | |
DB/Loot: Add reference for Depleted items (Ogri'la)
Closes #24546
(cherry picked from commit 2284790d31fd50dedc84fba97725bd7477c5165d)
| -rw-r--r-- | sql/updates/world/master/2022_01_01_51_world_2020_05_03_01_world.sql | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_51_world_2020_05_03_01_world.sql b/sql/updates/world/master/2022_01_01_51_world_2020_05_03_01_world.sql new file mode 100644 index 00000000000..1f2649bea31 --- /dev/null +++ b/sql/updates/world/master/2022_01_01_51_world_2020_05_03_01_world.sql @@ -0,0 +1,40 @@ +-- +SET @ENTRY := 14100; +DELETE FROM `reference_loot_template` WHERE `Entry` = @ENTRY; +INSERT INTO `reference_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES +(@ENTRY,32670,0,0,0,1,1,1,1), +(@ENTRY,32671,0,0,0,1,1,1,1), +(@ENTRY,32672,0,0,0,1,1,1,1), +(@ENTRY,32673,0,0,0,1,1,1,1), +(@ENTRY,32674,0,0,0,1,1,1,1), +(@ENTRY,32675,0,0,0,1,1,1,1), +(@ENTRY,32676,0,0,0,1,1,1,1), +(@ENTRY,32677,0,0,0,1,1,1,1), +(@ENTRY,32678,0,0,0,1,1,1,1), +(@ENTRY,32679,0,0,0,1,1,1,1); +DELETE FROM `creature_loot_template` WHERE `Entry` IN (19973,20557,22175,22180,22181,22182,22195,22204,22241,22242,22243,22244,22254,22275,22281,22291,23061,23230,23261,23281,23282,23353,23354,23355) AND (`Item` IN (32670,32671,32672,32673,32674,32675,32676,32677,32678,32679) OR `Item` = @ENTRY AND `Reference` = @ENTRY); +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(19973,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(20557,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22175,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22180,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22181,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22182,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22195,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22204,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22241,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22242,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22243,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22244,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22254,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22275,@ENTRY,@ENTRY,10,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22281,@ENTRY,@ENTRY,10,0,1,0,1,1,"Depleted items (Ogri'la)"), +(22291,@ENTRY,@ENTRY,1,0,1,0,1,1,"Depleted items (Ogri'la)"), +(23061,@ENTRY,@ENTRY,10,0,1,0,1,1,"Depleted items (Ogri'la)"), +(23230,@ENTRY,@ENTRY,100,0,1,0,1,1,"Depleted items (Ogri'la)"), +(23261,@ENTRY,@ENTRY,10,0,1,0,1,1,"Depleted items (Ogri'la)"), +(23281,@ENTRY,@ENTRY,10,0,1,0,1,1,"Depleted items (Ogri'la)"), +(23282,@ENTRY,@ENTRY,10,0,1,0,1,1,"Depleted items (Ogri'la)"), +(23353,@ENTRY,@ENTRY,10,0,1,0,1,1,"Depleted items (Ogri'la)"), +(23354,@ENTRY,@ENTRY,10,0,1,0,1,1,"Depleted items (Ogri'la)"), +(23355,@ENTRY,@ENTRY,10,0,1,0,1,1,"Depleted items (Ogri'la)"); |