diff options
| -rw-r--r-- | sql/updates/world/master/2017_10_30_02_world.sql | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_10_30_02_world.sql b/sql/updates/world/master/2017_10_30_02_world.sql new file mode 100644 index 00000000000..c0a57815cdb --- /dev/null +++ b/sql/updates/world/master/2017_10_30_02_world.sql @@ -0,0 +1,65 @@ +-- Poor Quality Table Level 1 - 5 +SET @ENTRY := 10100; +DELETE FROM `reference_loot_template` WHERE `Entry`=@ENTRY; +INSERT INTO `reference_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(@ENTRY,1364,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Ragged Leather Vest'), +(@ENTRY,1366,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Ragged Leather Pants'), +(@ENTRY,1367,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Ragged Leather Boots'), +(@ENTRY,1368,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Ragged Leather Gloves'), +(@ENTRY,1369,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Ragged Leather Belt'), +(@ENTRY,1370,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Ragged Leather Bracers'), +(@ENTRY,1372,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Ragged Cloak'), +(@ENTRY,1374,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Frayed Shoes'), +(@ENTRY,1375,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Frayed Cloak'), +(@ENTRY,1376,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Frayed Gloves'), +(@ENTRY,1377,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Frayed Pants'), +(@ENTRY,1380,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Frayed Robe'), +(@ENTRY,2210,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Battered Buckler'), +(@ENTRY,2211,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Bent Large Shield'), +(@ENTRY,2649,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Flimsy Chain Belt'), +(@ENTRY,2650,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Flimsy Chain Boots'), +(@ENTRY,2651,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Flimsy Chain Bracers'), +(@ENTRY,2652,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Flimsy Chain Cloak'), +(@ENTRY,2653,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Flimsy Chain Gloves'), +(@ENTRY,2654,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Flimsy Chain Pants'), +(@ENTRY,2656,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Flimsy Chain Vest'), +(@ENTRY,3363,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Frayed Belt'), +(@ENTRY,3365,0,0,0,1,0,1,1, 'Poor Quality Table Level 1 to 5 - Frayed Bracers'); + +-- Poor Quality Table Level 6 - 9 +SET @ENTRY := 10101; +DELETE FROM `reference_loot_template` WHERE `Entry`=@ENTRY; +INSERT INTO `reference_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(@ENTRY,1411,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Withered Staff'), +(@ENTRY,1412,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Crude Bastard Sword'), +(@ENTRY,1413,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Feeble Sword'), +(@ENTRY,1414,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Cracked Sledge'), +(@ENTRY,1415,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Carpenter''s Mallet'), +(@ENTRY,1416,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Rusty Hatchet'), +(@ENTRY,1417,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Beaten Battle Axe'), +(@ENTRY,1418,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Worn Leather Belt'), +(@ENTRY,1419,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Worn Leather Boots'), +(@ENTRY,1420,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Worn Leather Bracers'), +(@ENTRY,1421,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Worn Hide Cloak'), +(@ENTRY,1422,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Worn Leather Gloves'), +(@ENTRY,1423,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Worn Leather Pants'), +(@ENTRY,1425,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Worn Leather Vest'), +(@ENTRY,1427,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Patchwork Shoes'), +(@ENTRY,1429,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Patchwork Cloak'), +(@ENTRY,1430,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Patchwork Gloves'), +(@ENTRY,1431,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Patchwork Pants'), +(@ENTRY,1433,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Patchwork Armor'), +(@ENTRY,2138,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Sharpened Letter Opener'), +(@ENTRY,2212,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Cracked Buckler'), +(@ENTRY,2213,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Worn Large Shield'), +(@ENTRY,2635,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Loose Chain Belt'), +(@ENTRY,2642,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Loose Chain Boots'), +(@ENTRY,2643,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Loose Chain Bracers'), +(@ENTRY,2644,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Loose Chain Cloak'), +(@ENTRY,2645,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Loose Chain Gloves'), +(@ENTRY,2646,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Loose Chain Pants'), +(@ENTRY,2648,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Loose Chain Vest'), +(@ENTRY,2773,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Cracked Shortbow'), +(@ENTRY,2774,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Rust-Covered Blunderbuss'), +(@ENTRY,3370,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Patchwork Belt'), +(@ENTRY,3373,0,0,0,1,0,1,1, 'Poor Quality Table Level 6 to 9 - Patchwork Bracers'); |