aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/master/2025_04_04_00_world.sql125
1 files changed, 125 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_04_04_00_world.sql b/sql/updates/world/master/2025_04_04_00_world.sql
new file mode 100644
index 00000000000..a4190453dba
--- /dev/null
+++ b/sql/updates/world/master/2025_04_04_00_world.sql
@@ -0,0 +1,125 @@
+SET @REFERENCEID := 700000;
+
+-- Helena Gentle
+UPDATE `creature_template_difficulty` SET `LootID` = 124953, `GoldMin` = 8000, `GoldMax` = 25000 WHERE `Entry` = 124953;
+
+DELETE FROM `creature_loot_template` WHERE `Entry` = 124953;
+INSERT INTO `creature_loot_template` (`Entry`, `ItemType`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(124953, 0, 172954, 0.01, 1, 1, 0, 4, 4, 'Echo of Mortality'),
+(124953, 0, 152576, 66, 0, 1, 0, 1, 3, 'Tidespray Linen'),
+(124953, 0, 152577, 9, 0, 1, 0, 1, 1, 'Deep Sea Satin'),
+(124953, 1, @REFERENCEID+0, 10, 0, 1, 0, 1, 1, 'Reference World drop greens loot'),
+(124953, 1, @REFERENCEID+1, 19, 0, 1, 0, 1, 1, 'Reference World drop junk loot');
+
+-- Reference Loot table for greens (World drop)
+DELETE FROM `reference_loot_template` WHERE `Entry` = @REFERENCEID+0;
+INSERT INTO `reference_loot_template` (`Entry`, `ItemType`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(@REFERENCEID+0, 0, 154845, 0, 0, 1, 1, 1, 1, 'Corlain Spaulders'),
+(@REFERENCEID+0, 0, 159284, 0, 0, 1, 1, 1, 1, 'Corlain Cape'),
+(@REFERENCEID+0, 0, 154842, 0, 0, 1, 1, 1, 1, 'Corlain Girdle'),
+(@REFERENCEID+0, 0, 159564, 0, 0, 1, 1, 1, 1, 'Stagheart Staff'),
+(@REFERENCEID+0, 0, 159803, 0, 0, 1, 1, 1, 1, 'Goldscale Shield'),
+(@REFERENCEID+0, 0, 154843, 0, 0, 1, 1, 1, 1, 'Corlain Greathelm'),
+(@REFERENCEID+0, 0, 154850, 0, 0, 1, 1, 1, 1, 'Crimsonwood Boots'),
+(@REFERENCEID+0, 0, 154854, 0, 0, 1, 1, 1, 1, 'Crimsonwood Jerkin'),
+(@REFERENCEID+0, 0, 159537, 0, 0, 1, 1, 1, 1, 'Deepwarden Gavel'),
+(@REFERENCEID+0, 0, 159475, 0, 0, 1, 1, 1, 1, 'Shipwrecker Axe'),
+(@REFERENCEID+0, 0, 159590, 0, 0, 1, 1, 1, 1, 'Shipwrecker Blade'),
+(@REFERENCEID+0, 0, 159569, 0, 0, 1, 1, 1, 1, 'Wavecaller Spire'),
+(@REFERENCEID+0, 0, 154859, 0, 0, 1, 1, 1, 1, 'Barrowknoll Bracers'),
+(@REFERENCEID+0, 0, 154862, 0, 0, 1, 1, 1, 1, 'Barrowknoll Coif'),
+(@REFERENCEID+0, 0, 154864, 0, 0, 1, 1, 1, 1, 'Barrowknoll Pauldrons'),
+(@REFERENCEID+0, 0, 159520, 0, 0, 1, 1, 1, 1, 'Coralshell Dagger'),
+(@REFERENCEID+0, 0, 159539, 0, 0, 1, 1, 1, 1, 'Ironcrest Club'),
+(@REFERENCEID+0, 0, 159474, 0, 0, 1, 1, 1, 1, 'Tideguard Handaxe'),
+(@REFERENCEID+0, 0, 159593, 0, 0, 1, 1, 1, 1, 'Wavecaller Cutlass'),
+(@REFERENCEID+0, 0, 159535, 0, 0, 1, 1, 1, 1, 'Wavecaller Mace'),
+(@REFERENCEID+0, 0, 154840, 0, 0, 1, 1, 1, 1, 'Corlain Breastplate'),
+(@REFERENCEID+0, 0, 159799, 0, 0, 1, 1, 1, 1, 'Wintersail Bulwark'),
+(@REFERENCEID+0, 0, 154865, 0, 0, 1, 1, 1, 1, 'Barrowknoll Chainmail'),
+(@REFERENCEID+0, 0, 159509, 0, 0, 1, 1, 1, 1, 'Gnarlwood Spikes'),
+(@REFERENCEID+0, 0, 159497, 0, 0, 1, 1, 1, 1, 'Deepwarden Flintlock'),
+(@REFERENCEID+0, 0, 159571, 0, 0, 1, 1, 1, 1, 'Deepwarden Staff'),
+(@REFERENCEID+0, 0, 159585, 0, 0, 1, 1, 1, 1, 'Ironcrest Sword'),
+(@REFERENCEID+0, 0, 159566, 0, 0, 1, 1, 1, 1, 'Shipwrecker Spire'),
+(@REFERENCEID+0, 0, 159511, 0, 0, 1, 1, 1, 1, 'Wavecaller Fists'),
+(@REFERENCEID+0, 0, 159818, 0, 0, 1, 1, 1, 1, 'Deepwarden Torch'),
+(@REFERENCEID+0, 0, 159496, 0, 0, 1, 1, 1, 1, 'Gol Osigr Crossbow'),
+(@REFERENCEID+0, 0, 154860, 0, 0, 1, 1, 1, 1, 'Barrowknoll Gloves'),
+(@REFERENCEID+0, 0, 159551, 0, 0, 1, 1, 1, 1, 'Tideguard Maul'),
+(@REFERENCEID+0, 0, 159283, 0, 0, 1, 1, 1, 1, 'Barrowknoll Cloak'),
+(@REFERENCEID+0, 0, 154851, 0, 0, 1, 1, 1, 1, 'Crimsonwood Breeches'),
+(@REFERENCEID+0, 0, 159280, 0, 0, 1, 1, 1, 1, 'Crimsonwood Drape'),
+(@REFERENCEID+0, 0, 159540, 0, 0, 1, 1, 1, 1, 'Goralshell Hammer'),
+(@REFERENCEID+0, 0, 154844, 0, 0, 1, 1, 1, 1, 'Corlain Greaves'),
+(@REFERENCEID+0, 0, 154847, 0, 0, 1, 1, 1, 1, 'Corlain Vambraces'),
+(@REFERENCEID+0, 0, 159519, 0, 0, 1, 1, 1, 1, 'Ironcrest Knife'),
+(@REFERENCEID+0, 0, 159800, 0, 0, 1, 1, 1, 1, 'Wavecaller Buckler'),
+(@REFERENCEID+0, 0, 159602, 0, 0, 1, 1, 1, 1, 'Gol Osigr Wand'),
+(@REFERENCEID+0, 0, 154858, 0, 0, 1, 1, 1, 1, 'Barrowknoll Cinch'),
+(@REFERENCEID+0, 0, 154863, 0, 0, 1, 1, 1, 1, 'Barrowknoll Legguards'),
+(@REFERENCEID+0, 0, 154853, 0, 0, 1, 1, 1, 1, 'Crimsonwood Crowl'),
+(@REFERENCEID+0, 0, 159806, 0, 0, 1, 1, 1, 1, 'Dockyard Targe'),
+(@REFERENCEID+0, 0, 159522, 0, 0, 1, 1, 1, 1, 'Stagheart Knife'),
+(@REFERENCEID+0, 0, 159805, 0, 0, 1, 1, 1, 1, 'Coralshell Shield'),
+(@REFERENCEID+0, 0, 159473, 0, 0, 1, 1, 1, 1, 'Dockyard Axe'),
+(@REFERENCEID+0, 0, 159524, 0, 0, 1, 1, 1, 1, 'Shipwrecker Knife'),
+(@REFERENCEID+0, 0, 159797, 0, 0, 1, 1, 1, 1, 'Shipwrecker Shield'),
+(@REFERENCEID+0, 0, 159525, 0, 0, 1, 1, 1, 1, 'Coldscale Dagger'),
+(@REFERENCEID+0, 0, 159502, 0, 0, 1, 1, 1, 1, 'Stagheart Warglaives'),
+(@REFERENCEID+0, 0, 159523, 0, 0, 1, 1, 1, 1, 'Tideguard Shanker');
+
+-- Reference Loot table for junk (World drop)
+DELETE FROM `reference_loot_template` WHERE `Entry` = @REFERENCEID+1;
+INSERT INTO `reference_loot_template` (`Entry`, `ItemType`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(@REFERENCEID+1, 0, 160930, 0, 0, 1, 1, 1, 1, 'Barnacled Greataxe'),
+(@REFERENCEID+1, 0, 154771, 0, 0, 1, 1, 1, 1, 'Cracked Hide Boots'),
+(@REFERENCEID+1, 0, 160931, 0, 0, 1, 1, 1, 1, 'Rough Cooking Spit'),
+(@REFERENCEID+1, 0, 160924, 0, 0, 1, 1, 1, 1, 'Scored Antique Blade'),
+(@REFERENCEID+1, 0, 154796, 0, 0, 1, 1, 1, 1, 'Crumbling Chain Sabatons'),
+(@REFERENCEID+1, 0, 154784, 0, 0, 1, 1, 1, 1, 'Ruptured Plate Breastplate'),
+(@REFERENCEID+1, 0, 160932, 0, 0, 1, 1, 1, 1, 'Termite-Addled Staff'),
+(@REFERENCEID+1, 0, 154791, 0, 0, 1, 1, 1, 1, 'Unraveling Cloth Cowl'),
+(@REFERENCEID+1, 0, 154800, 0, 0, 1, 1, 1, 1, 'Crumbling Chain Coif'),
+(@REFERENCEID+1, 0, 160926, 0, 0, 1, 1, 1, 1, 'Broken Mooring Post'),
+(@REFERENCEID+1, 0, 154798, 0, 0, 1, 1, 1, 1, 'Crumbling Chain Bauberk'),
+(@REFERENCEID+1, 0, 154794, 0, 0, 1, 1, 1, 1, 'Crumbling Chain Wristguards'),
+(@REFERENCEID+1, 0, 154790, 0, 0, 1, 1, 1, 1, 'Unraveling Cloth Handwraps'),
+(@REFERENCEID+1, 0, 154803, 0, 0, 1, 1, 1, 1, 'Battered Greatmaul'),
+(@REFERENCEID+1, 0, 154774, 0, 0, 1, 1, 1, 1, 'Cracked Hide Pants'),
+(@REFERENCEID+1, 0, 154795, 0, 0, 1, 1, 1, 1, 'Crumbling Chain Spaulders'),
+(@REFERENCEID+1, 0, 154802, 0, 0, 1, 1, 1, 1, 'Notched Handaxe'),
+(@REFERENCEID+1, 0, 154780, 0, 0, 1, 1, 1, 1, 'Ruptured Plate Pauldrons'),
+(@REFERENCEID+1, 0, 154792, 0, 0, 1, 1, 1, 1, 'Unraveling Cloth Cord'),
+(@REFERENCEID+1, 0, 154788, 0, 0, 1, 1, 1, 1, 'Unraveling Cloth Sandals'),
+(@REFERENCEID+1, 0, 160929, 0, 0, 1, 1, 1, 1, 'Cracked Cannon Ram'),
+(@REFERENCEID+1, 0, 154772, 0, 0, 1, 1, 1, 1, 'Cracked Hide Gloves'),
+(@REFERENCEID+1, 0, 154799, 0, 0, 1, 1, 1, 1, 'Crumbling Chain Gloves'),
+(@REFERENCEID+1, 0, 154786, 0, 0, 1, 1, 1, 1, 'Unraveling Cloth Wristwraps'),
+(@REFERENCEID+1, 0, 160928, 0, 0, 1, 1, 1, 1, 'Weathered Greatsword'),
+(@REFERENCEID+1, 0, 154770, 0, 0, 1, 1, 1, 1, 'Cracked Hide Belt'),
+(@REFERENCEID+1, 0, 160937, 0, 0, 1, 1, 1, 1, 'Arrow-Pocked Aegis'),
+(@REFERENCEID+1, 0, 160927, 0, 0, 1, 1, 1, 1, 'Chipped Stone Hatchet'),
+(@REFERENCEID+1, 0, 154775, 0, 0, 1, 1, 1, 1, 'Cracked Hide Shoulders'),
+(@REFERENCEID+1, 0, 154805, 0, 0, 1, 1, 1, 1, 'Rottingwood Quarterstaff'),
+(@REFERENCEID+1, 0, 154785, 0, 0, 1, 1, 1, 1, 'Ruptured Plate Belt'),
+(@REFERENCEID+1, 0, 154789, 0, 0, 1, 1, 1, 1, 'Unraveling Cloth Pants'),
+(@REFERENCEID+1, 0, 154773, 0, 0, 1, 1, 1, 1, 'Cracked Hide Hood'),
+(@REFERENCEID+1, 0, 154797, 0, 0, 1, 1, 1, 1, 'Crumbling Chain Leggings'),
+(@REFERENCEID+1, 0, 160935, 0, 0, 1, 1, 1, 1, 'Backfiring Blunderbuss'),
+(@REFERENCEID+1, 0, 154801, 0, 0, 1, 1, 1, 1, 'Crumbling Chain Belt'),
+(@REFERENCEID+1, 0, 160936, 0, 0, 1, 1, 1, 1, 'Depleted Arcane Scepter'),
+(@REFERENCEID+1, 0, 154778, 0, 0, 1, 1, 1, 1, 'Ruptured Plate Vambraces'),
+(@REFERENCEID+1, 0, 154787, 0, 0, 1, 1, 1, 1, 'Unraveling Cloth Shirt'),
+(@REFERENCEID+1, 0, 154783, 0, 0, 1, 1, 1, 1, 'Ruptured Plate Gauntlets'),
+(@REFERENCEID+1, 0, 160933, 0, 0, 1, 1, 1, 1, 'Splintered Longbow'),
+(@REFERENCEID+1, 0, 154781, 0, 0, 1, 1, 1, 1, 'Ruptured Plate Leggings'),
+(@REFERENCEID+1, 0, 160938, 0, 0, 1, 1, 1, 1, 'Bent Punching Blade'),
+(@REFERENCEID+1, 0, 154776, 0, 0, 1, 1, 1, 1, 'Cracked Hide Vest'),
+(@REFERENCEID+1, 0, 154777, 0, 0, 1, 1, 1, 1, 'Cracked Hide Wristguards'),
+(@REFERENCEID+1, 0, 154804, 0, 0, 1, 1, 1, 1, 'Chipped-Blade Scimitar'),
+(@REFERENCEID+1, 0, 160934, 0, 0, 1, 1, 1, 1, 'Mud-Soaked Crossbow'),
+(@REFERENCEID+1, 0, 154782, 0, 0, 1, 1, 1, 1, 'Ruptured Plate Helmet'),
+(@REFERENCEID+1, 0, 160925, 0, 0, 1, 1, 1, 1, 'Crusty Cutlass'),
+(@REFERENCEID+1, 0, 154779, 0, 0, 1, 1, 1, 1, 'Ruptured Plate Stompers'),
+(@REFERENCEID+1, 0, 154793, 0, 0, 1, 1, 1, 1, 'Unraveling Cloth Amice');