aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.3.5/2020_05_10_01_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_10_01_world.sql b/sql/updates/world/3.3.5/2020_05_10_01_world.sql
new file mode 100644
index 00000000000..26830cbd0b9
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_10_01_world.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `creature_loot_template` WHERE `entry` = 3715 AND (`Item` IN (414,422,1179,1707,1708,2287,3770,3771,4537,4538,4539,4541,4542,4544,4605,4606,4607,765,785,2447,2449,2450,2452,2453,3355,3356,3357,3818,3820,2770,2772,2835,2836,2838,2589,2592,4306,4338,1710,2455,3827,2555,3396,3608,3612,3832,3867,3870,3873,3874,4296,4353,4412,4416,5543,5974,7085,7091,7092,7288,7363,7453,7910,10601,11039,11167,3610,4294,4297,4349,4694,5578,6391,7084,7360,7364,10407,11081,3611,3830,4293,4347,5774,6044,6045,6454,7086,11038,11098,2601,3394,3872,4299,4350,4410,6375,6566,10405,804,857,1529,1705,1725,2882,2883,3393,3864,4698,4700,5500,5575,5576,6390,6579,6588,7909,10316,11165,14170) OR `Reference` IN (24037,24038,24041,24047,24048,24049,24050,24051,24052,24053,24054,24056,24057,24058,24061,24063,24065,24066,24067,24068,24069));
+DELETE FROM `creature_loot_template` WHERE `entry` = 2850 AND (`Item` IN (422,785,804,857,858,929,1205,1206,1210,1529,1645,1705,1707,1708,1710,1725,2449,2450,2452,2453,2455,2589,2592,2601,2770,2772,2835,2836,2838,2882,2883,3355,3356,3357,3385,3393,3394,3396,3608,3611,3770,3771,3818,3821,3827,3830,3831,3864,3866,3867,3868,3869,3870,3873,3874,3914,3927,3928,4294,4296,4297,4300,4306,4338,4347,4348,4349,4350,4352,4353,4410,4412,4414,4416,4417,4538,4539,4542,4544,4599,4601,4602,4606,4607,4608,4694,4698,4700,5498,5500,5543,5575,5576,5578,5774,5972,5974,6044,6045,6149,6211,6375,6390,6391,6454,6566,6579,6588,7084,7085,7086,7090,7091,7092,7360,7363,7364,7449,7450,7453,7912,7975,7992,8029,8385,8386,8387,8831,9293,10300,10301,10302,10312,10316,10405,10407,10424,10601,10603,10604,10606,11038,11039,11081,11098,11164,11165,11167,11202,11204,14170) OR `Reference` IN (24036,24039,24040,24041,24042,24049,24058,24059,24060,24061,24062,24063,24064,24065,24066,24067,24068,24069,24078));
+DELETE FROM `creature_loot_template` WHERE `entry` = 4095 AND (`Item` IN (785,929,1210,1707,1708,1710,2452,2453,2589,2770,2772,2835,2836,2838,3355,3356,3357,3771,3827,4539,4544,4606,4607,4700,7912) OR `Reference` IN (24047,24050,24052,24059,24060,24062));
+DELETE FROM `creature_loot_template` WHERE `entry` = 4096 AND (`Item` IN (414,765,785,856,1179,1529,1707,1708,1710,1725,2287,2407,2408,2447,2449,2450,2452,2453,2455,2555,2589,2657,2772,2835,2836,2838,3355,3356,3357,3610,3771,3818,3827,3830,3832,3864,3867,3870,3872,3873,3874,4297,4299,4338,4353,4408,4416,4537,4538,4539,4541,4544,4605,4607,4694,4698,4700,5498,5500,5543,5573,5574,5774,5974,6044,6045,6566,6579,6588,7084,7085,7086,7288,7364,7453,7909,7910,10405,10407,10601,11098,11165,11167,14170) OR `Reference` IN (24037,24038,24041,24047,24049,24050,24051,24052,24053,24054,24056,24057,24060,24061,24070,24077,24078));