diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-07-10 13:43:26 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-05 16:36:01 +0100 |
| commit | 401c6352b9608dfc700c517a6a65efb4e82338a8 (patch) | |
| tree | 4b02113ac7a5a77573e15c4df6bb7e9c9929935c | |
| parent | fcbda4c83ba22a8f376f42a068c74ba94cda6713 (diff) | |
DB/Loot: fix drop conditions and chance for item "Cracked Silithid Carapace"
(cherry picked from commit 844921a6156d7c08a2a9eec567e25b3d02803d12)
| -rw-r--r-- | sql/updates/world/master/2017_02_05_08_world_2016_07_10_06_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_05_08_world_2016_07_10_06_world.sql b/sql/updates/world/master/2017_02_05_08_world_2016_07_10_06_world.sql new file mode 100644 index 00000000000..7594560ce2a --- /dev/null +++ b/sql/updates/world/master/2017_02_05_08_world_2016_07_10_06_world.sql @@ -0,0 +1,13 @@ +-- +UPDATE `creature_loot_template` SET `Chance`=100 WHERE `Item`=5877; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceEntry`=5877; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(1, 4130, 5877, 0, 0, 8, 0, 1147, 0, 0, 0, 0, 0, "", "Item 'Cracked Silithid Carapace' can be looted if quest 'The Swarm Grows' is taken OR"), +(1, 4131, 5877, 0, 0, 8, 0, 1147, 0, 0, 0, 0, 0, "", "Item 'Cracked Silithid Carapace' can be looted if quest 'The Swarm Grows' is taken OR"), +(1, 4132, 5877, 0, 0, 8, 0, 1147, 0, 0, 0, 0, 0, "", "Item 'Cracked Silithid Carapace' can be looted if quest 'The Swarm Grows' is taken OR"), +(1, 4133, 5877, 0, 0, 8, 0, 1147, 0, 0, 0, 0, 0, "", "Item 'Cracked Silithid Carapace' can be looted if quest 'The Swarm Grows' is taken OR"), +(1, 4130, 5877, 0, 1, 9, 0, 1147, 0, 0, 0, 0, 0, "", "Item 'Cracked Silithid Carapace' can be looted if quest 'The Swarm Grows' is rewarded"), +(1, 4131, 5877, 0, 1, 9, 0, 1147, 0, 0, 0, 0, 0, "", "Item 'Cracked Silithid Carapace' can be looted if quest 'The Swarm Grows' is rewarded"), +(1, 4132, 5877, 0, 1, 9, 0, 1147, 0, 0, 0, 0, 0, "", "Item 'Cracked Silithid Carapace' can be looted if quest 'The Swarm Grows' is rewarded"), +(1, 4133, 5877, 0, 1, 9, 0, 1147, 0, 0, 0, 0, 0, "", "Item 'Cracked Silithid Carapace' can be looted if quest 'The Swarm Grows' is rewarded"); |