diff options
| author | Filip <boev.filip@gmail.com> | 2013-10-24 15:18:15 +0200 |
|---|---|---|
| committer | Filip <boev.filip@gmail.com> | 2013-10-24 15:18:15 +0200 |
| commit | 626f1f0f9f688f73d517fd168ebb9f8d8945f2f8 (patch) | |
| tree | 7c981292b450b90a04f4363ca040a408aee7015f | |
| parent | 950ac949cb11cee7e21e3b33ea4f2496b0b6b598 (diff) | |
DB/Errors: Db error clean up
By @untaught fixes #11116
| -rw-r--r-- | sql/updates/world/2013_10_24_01_world_errors.sql | 11 |
1 files changed, 11 insertions, 0 deletions
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); |