From 626f1f0f9f688f73d517fd168ebb9f8d8945f2f8 Mon Sep 17 00:00:00 2001 From: Filip Date: Thu, 24 Oct 2013 15:18:15 +0200 Subject: DB/Errors: Db error clean up By @untaught fixes #11116 --- sql/updates/world/2013_10_24_01_world_errors.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2013_10_24_01_world_errors.sql (limited to 'sql') diff --git a/sql/updates/world/2013_10_24_01_world_errors.sql b/sql/updates/world/2013_10_24_01_world_errors.sql new file mode 100644 index 00000000000..f246efda806 --- /dev/null +++ b/sql/updates/world/2013_10_24_01_world_errors.sql @@ -0,0 +1,11 @@ +-- Remove unused skinning_loot_template. +DELETE FROM `skinning_loot_template` WHERE `entry`=100015; +-- Spell effects without target types AREA/NEARBY/CONE so this conditions are useless. +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `sourcegroup`=1 AND `sourceentry` IN (43789,43891); +-- Must have the same loot as item 35348. In TDB it uses reference 11112 which is empty. +DELETE FROM `item_loot_template` WHERE `entry`=34863; +INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES +(34863,1,100,1,0,-11113,1), +(34863,2,60,1,0,-11116,1), +(34863,3,5,1,0,-11114,1), +(34863,4,60,1,0,-11115,1); -- cgit v1.2.3