aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZxBiohazardZx <zxbiohazardzx@gmail.com>2011-08-06 15:11:00 +0200
committerZxBiohazardZx <zxbiohazardzx@gmail.com>2011-08-06 15:11:00 +0200
commitd3ab5941b2a466b74791bba3a10dba0e6a1fca96 (patch)
tree9aa82c2f3cab7359e6a07569ab633ed95fb01049
parent3d935c218fc5abb0915d9ff42a931fb018ef79b0 (diff)
DB/Loot : Updated Lootid for ICC 25 man and fix a wrong item while at it
Closes #2491
-rw-r--r--sql/updates/world/2011_08_06_00_world_creature_template.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2011_08_06_00_world_creature_template.sql b/sql/updates/world/2011_08_06_00_world_creature_template.sql
new file mode 100644
index 00000000000..1bf46fce8c3
--- /dev/null
+++ b/sql/updates/world/2011_08_06_00_world_creature_template.sql
@@ -0,0 +1,4 @@
+-- Fix ICC 25 man loot:
+UPDATE `creature_template` SET `lootid`=100002 WHERE `entry` IN (37655,38031,38057,38058,38059,38062,38063,38072,38073,38074,38075,38076,38098,38099,38100,38101,38102,38108,38110,38139,38197,38198,38258,38418,38445,38446,38479,38480,38481);
+-- Fix itemid in the grey reference
+UPDATE `reference_loot_template` SET `item`=33364 WHERE `entry`=35063 AND `item`=33346;