From b61eafb43b7802112a086fe5d153b339107e7c4c Mon Sep 17 00:00:00 2001
From: Aokromes <Aokromes@users.noreply.github.com>
Date: Wed, 12 Jun 2019 17:31:22 +0200
Subject: DB/Loot: Fix self-reference issue

by killradio
Fixes one infinite loop crash when milling / prospecting some cata > herbs / veins
cherry pick of https://gitlab.com/trinitycore/TrinityCore_434/commit/71f693529eccf96fd867c2fbf7cf54048f930056
---
 sql/updates/world/master/2019_06_12_00_world.sql | 2 ++
 1 file changed, 2 insertions(+)
 create mode 100644 sql/updates/world/master/2019_06_12_00_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/master/2019_06_12_00_world.sql b/sql/updates/world/master/2019_06_12_00_world.sql
new file mode 100644
index 00000000000..3ab9592552e
--- /dev/null
+++ b/sql/updates/world/master/2019_06_12_00_world.sql
@@ -0,0 +1,2 @@
+-- Fix self-reference issue
+UPDATE `reference_loot_template` SET `Reference` = 0 WHERE `Entry` IN (11919,11920,11921,13006,13007,13008,13009,13010);
-- 
cgit v1.2.3