diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_03_19_03_world_335.sql | 143 |
1 files changed, 143 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_03_19_03_world_335.sql b/sql/updates/world/3.3.5/2021_03_19_03_world_335.sql new file mode 100644 index 00000000000..0989eacc286 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_03_19_03_world_335.sql @@ -0,0 +1,143 @@ +-- Remaining with Blue Dragonscale +UPDATE `creature_template` SET `skinloot` = 60028 WHERE `entry` IN (6109); +UPDATE `creature_template` SET `skinloot` = 60029 WHERE `entry` IN (193,6129,6130,6131,7435); +UPDATE `creature_template` SET `skinloot` = 60030 WHERE `entry` IN (7436,7437,10662,10663,10664,10196,10202); +UPDATE `creature_template` SET `skinloot` = 60031 WHERE `entry` IN (10659,10660,10661); + +DELETE FROM `skinning_loot_template` WHERE `Entry` BETWEEN 60028 AND 60031; +DELETE FROM `skinning_loot_template` WHERE `Entry` IN (6109,193,6129,6130,6131,7435,7436,7437,10662,10663,10664,10196,10202,10659,10660,10661); +INSERT INTO `skinning_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(60028,15415,0,100,0,1,1,3,6,"Blue Dragonscale"), +(60029,4304,0,25,0,1,1,1,2,"Thick Leather"), +(60029,8165,0,10,0,1,1,1,1,"Worn Dragonscale"), +(60029,8169,0,3,0,1,1,1,1,"Thick Hide"), +(60029,8170,0,43,0,1,1,1,2,"Rugged Leather"), +(60029,8171,0,4,0,1,1,1,1,"Rugged Hide"), +(60029,15415,0,15,0,1,1,1,1,"Blue Dragonscale"), +(60030,4304,0,5,0,1,1,1,2,"Thick Leather"), +(60030,8165,0,10,0,1,1,1,1,"Worn Dragonscale"), +(60030,8170,0,55,0,1,1,1,2,"Rugged Leather"), +(60030,8171,0,5,0,1,1,1,1,"Rugged Hide"), +(60030,15415,0,25,0,1,1,1,1,"Blue Dragonscale"), +(60031,4304,0,40,0,1,1,1,1,"Thick Leather"), +(60031,8165,0,5,0,1,1,1,1,"Worn Dragonscale"), +(60031,8169,0,3,0,1,1,1,1,"Thick Hide"), +(60031,8170,0,45,0,1,1,1,1,"Rugged Leather"), +(60031,8171,0,4,0,1,1,1,1,"Rugged Hide"), +(60031,15415,0,3,0,1,1,1,1,"Blue Dragonscale"); + +-- Remaining with Green Dragonscale +UPDATE `creature_template` SET `skinloot` = 60032 WHERE `entry` IN (14887,14888,14889,14890); +UPDATE `creature_template` SET `skinloot` = 60033 WHERE `entry` IN (742,743,744,745,746); +UPDATE `creature_template` SET `skinloot` = 60034 WHERE `entry` IN (5709); +UPDATE `creature_template` SET `skinloot` = 60035 WHERE `entry` IN (5277,5280,5283,8497); +UPDATE `creature_template` SET `skinloot` = 60036 WHERE `entry` IN (5719,5720,5721,5722); +UPDATE `creature_template` SET `skinloot` = 60037 WHERE `entry` IN (1063,14445); +UPDATE `creature_template` SET `skinloot` = 60038 WHERE `entry` IN (8319); +UPDATE `creature_template` SET `skinloot` = 60039 WHERE `entry` IN (5312,5314,5317,5718,5319,5320,12474,12475,12476,12477,12478,12479,12496,12497,12498,12900); + +DELETE FROM `skinning_loot_template` WHERE `Entry` BETWEEN 60032 AND 60039; +DELETE FROM `skinning_loot_template` WHERE `Entry` IN (742,743,744,745,746,5709,5277,5280,5283,8497,5719,5720,5721,5722,1063,14445,8319,5319,5320,12474,12475,12476,12477,12479,12498,12900,15412); +INSERT INTO `skinning_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(60032,20381,0,100,0,1,0,3,5,"Dreamscale"), +(60032,15412,0,100,0,1,0,5,8,"Green Dragonscale"), +(60033,4234,0,25,0,1,1,1,2,"Heavy Leather"), +(60033,4235,0,5,0,1,1,1,1,"Heavy Hide"), +(60033,4304,0,45,0,1,1,1,2,"Thick Leather"), +(60033,8165,0,5,0,1,1,1,2,"Worn Dragonscale"), +(60033,8169,0,5,0,1,1,1,1,"Thick Hide"), +(60033,15412,0,15,0,1,1,1,1,"Green Dragonscale"), +-- May be slightly different +(60034,4304,0,27,0,1,1,1,2,"Thick Leather"), +(60034,8165,0,10,0,1,1,1,1,"Worn Dragonscale"), +(60034,8169,0,3,0,1,1,1,1,"Thick Hide"), +(60034,8170,0,27,0,1,1,1,2,"Rugged Leather"), +(60034,8171,0,3,0,1,1,1,1,"Rugged Hide"), +(60034,15412,0,30,0,1,1,1,1,"Green Dragonscale"), +(60035,4304,0,48,0,1,1,1,2,"Thick Leather"), +(60035,8165,0,7,0,1,1,1,2,"Worn Dragonscale"), +(60035,8169,0,5,0,1,1,1,1,"Thick Hide"), +(60035,8170,0,15,0,1,1,1,2,"Rugged Leather"), +(60035,15412,0,25,0,1,1,1,1,"Green Dragonscale"), +(60036,8165,0,100,0,1,0,1,2,"Worn Dragonscale"), +(60036,8169,0,20,0,1,0,1,1,"Thick Hide"), +(60036,8170,0,100,0,1,0,2,3,"Rugged Leather"), +(60036,15412,0,100,0,1,0,2,3,"Green Dragonscale"), +-- May be slightly different. Completely dead-end case, we'll never know correct chance +(60037,4304,0,68,0,1,1,1,1,"Thick Leather"), +(60037,8165,0,5,0,1,1,1,1,"Worn Dragonscale"), +(60037,8169,0,3,0,1,1,1,1,"Thick Hide"), +(60037,8170,0,20,0,1,1,1,1,"Rugged Leather"), +(60037,15412,0,4,0,1,1,1,1,"Green Dragonscale"), +(60038,4304,0,68,0,1,1,1,2,"Thick Leather"), +(60038,8165,0,5,0,1,1,1,1,"Worn Dragonscale"), +(60038,8169,0,3,0,1,1,1,1,"Thick Hide"), +(60038,8170,0,20,0,1,1,1,2,"Rugged Leather"), +(60038,15412,0,4,0,1,1,1,1,"Green Dragonscale"), +-- Another completely dead-end case, may be different +(60039,4304,0,5,0,1,1,1,2,"Thick Leather"), +(60039,8165,0,10,0,1,1,1,1,"Worn Dragonscale"), +(60039,8170,0,40,0,1,1,1,2,"Rugged Leather"), +(60039,8171,0,5,0,1,1,1,1,"Rugged Hide"), +(60039,15412,0,40,0,1,1,1,1,"Green Dragonscale"); + +-- Remaining with Red Dragonscale +UPDATE `creature_template` SET `skinloot` = 0 WHERE `entry` IN (15414); +UPDATE `creature_template` SET `skinloot` = 60040 WHERE `entry` IN (1045,1046,1047,1048,1049,1050,12899); + +DELETE FROM `skinning_loot_template` WHERE `Entry` IN (15414,60040,1045,1046,1047,1048,1049,1050,12899); +INSERT INTO `skinning_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(60040,4304,0,5,0,1,1,1,2,"Thick Leather"), +(60040,8165,0,10,0,1,1,1,1,"Worn Dragonscale"), +(60040,8170,0,55,0,1,1,1,2,"Rugged Leather"), +(60040,8171,0,5,0,1,1,1,1,"Rugged Hide"), +(60040,15414,0,25,0,1,1,1,2,"Red Dragonscale"); + +-- Remaining with Worn Dragonscale +UPDATE `creature_template` SET `skinloot` = 60041 WHERE `entry` IN (2725,4323,4324,5278,7997,23687); +UPDATE `creature_template` SET `skinloot` = 60042 WHERE `entry` IN (2447,2726,4328,4329,4331,4334,4339); +UPDATE `creature_template` SET `skinloot` = 60043 WHERE `entry` IN (10678,14398); +UPDATE `creature_template` SET `skinloot` = 60044 WHERE `entry` IN (12129,36572); +UPDATE `creature_template` SET `skinloot` = 60045 WHERE `entry` IN (5276); +UPDATE `creature_template` SET `skinloot` = 60046 WHERE `entry` IN (8196); +UPDATE `creature_template` SET `skinloot` = 60047 WHERE `entry` IN (8197); +UPDATE `creature_template` SET `skinloot` = 60048 WHERE `entry` IN (8198); + +DELETE FROM `skinning_loot_template` WHERE `Entry` BETWEEN 60041 AND 60048; +DELETE FROM `skinning_loot_template` WHERE `Entry` IN (2725,4323,4324,5278,2447,2726,4328,4329,4331,4334,4339,10678,14398,12129,5276,8196,8197,8198); +INSERT INTO `skinning_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(60041,4234,0,40,0,1,1,1,1,"Heavy Leather"), +(60041,4235,0,3,0,1,1,1,1,"Heavy Hide"), +(60041,4304,0,50,0,1,1,1,1,"Thick Leather"), +(60041,8165,0,3,0,1,1,1,1,"Worn Dragonscale"), +(60041,8169,0,4,0,1,1,1,1,"Thick Hide"), +(60042,4234,0,35,0,1,1,1,2,"Heavy Leather"), +(60042,4235,0,5,0,1,1,1,1,"Heavy Hide"), +(60042,4304,0,50,0,1,1,1,2,"Thick Leather"), +(60042,8165,0,5,0,1,1,1,2,"Worn Dragonscale"), +(60042,8169,0,5,0,1,1,1,1,"Thick Hide"), +(60043,4304,0,15,0,1,1,1,1,"Thick Leather"), +(60043,8165,0,5,0,1,1,1,1,"Worn Dragonscale"), +(60043,8170,0,75,0,1,1,1,1,"Rugged Leather"), +(60043,8171,0,5,0,1,1,1,1,"Rugged Hide"), +-- Hm, interesting https://www.wowhead.com/npc=12129/onyxian-warder#comments:id=1061033 +(60044,8170,0,80,0,1,1,1,20,"Rugged Leather"), +(60044,8171,0,20,0,1,1,5,10,"Rugged Hide"), +-- Below 100% are not accurate, completely dead-end cases +(60045,4304,0,77,0,1,1,1,1,"Thick Leather"), +(60045,8165,0,3,0,1,1,1,1,"Worn Dragonscale"), +(60045,8169,0,3,0,1,1,1,1,"Thick Hide"), +(60045,8170,0,17,0,1,1,1,1,"Rugged Leather"), +(60046,4304,0,70,0,1,1,1,2,"Thick Leather"), +(60046,8165,0,5,0,1,1,1,2,"Worn Dragonscale"), +(60046,8169,0,5,0,1,1,1,1,"Thick Hide"), +(60046,8170,0,20,0,1,1,1,2,"Rugged Leather"), +(60047,4304,0,5,0,1,1,1,2,"Thick Leather"), +(60047,8165,0,10,0,1,1,1,1,"Worn Dragonscale"), +(60047,8170,0,80,0,1,1,1,2,"Rugged Leather"), +(60047,8171,0,5,0,1,1,1,1,"Rugged Hide"), +(60048,4304,0,40,0,1,1,1,2,"Thick Leather"), +(60048,8165,0,10,0,1,1,1,1,"Worn Dragonscale"), +(60048,8169,0,3,0,1,1,1,1,"Thick Hide"), +(60048,8170,0,44,0,1,1,1,2,"Rugged Leather"), +(60048,8171,0,3,0,1,1,1,1,"Rugged Hide"); |