diff options
| author | Rushor <PBienati@web.de> | 2016-02-11 17:23:27 +0100 |
|---|---|---|
| committer | Rushor <PBienati@web.de> | 2016-02-11 17:23:27 +0100 |
| commit | d05177bf1dcb8709361d33a998cc25da32669dc5 (patch) | |
| tree | 57f5a54c2225b3c28ccb8012032d4c648acec253 | |
| parent | 7f817a4fc0a7ddbfd6f2b663eef5f3936d18ab74 (diff) | |
DB/Item: Scarlet Insignia Ring - Questloot
* by Saben65 & tkrokli
* closes #16405
| -rw-r--r-- | sql/updates/world/2016_02_11_00_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2016_02_11_00_world.sql b/sql/updates/world/2016_02_11_00_world.sql new file mode 100644 index 00000000000..b130133a2ca --- /dev/null +++ b/sql/updates/world/2016_02_11_00_world.sql @@ -0,0 +1,6 @@ +-- Scarlet Insignia Ring - Questloot +DELETE FROM `creature_loot_template` WHERE `Entry` IN (1538,1539,1540) AND `Item`= 2875; +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(1538, 2875, 0, 40, 1, 1, 0, 1, 1, 'Scarlet Friar - Scarlet Insignia Ring'), +(1539, 2875, 0, 40, 1, 1, 0, 1, 1, 'Scarlet Neophyte - Scarlet Insignia Ring'), +(1540, 2875, 0, 40, 1, 1, 0, 1, 1, 'Scarlet Vanguard - Scarlet Insignia Ring'); |