diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2024_10_11_00_world.sql | 124 |
1 files changed, 124 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_11_00_world.sql b/sql/updates/world/3.3.5/2024_10_11_00_world.sql new file mode 100644 index 00000000000..04cb0a88b45 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_11_00_world.sql @@ -0,0 +1,124 @@ +-- *** Sunstrider Isle *** + +SET @REF := 1059; +DELETE FROM `reference_loot_template` WHERE `Entry` BETWEEN @REF AND @REF + 4; + +-- Food Reference loot for level 1 to 5 +SET @REFFOOD4 := @REF; +INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@REFFOOD4,159,0,33,0,1,1,1,1, 'Food 1-5 - Refreshing Spring Water'), +(@REFFOOD4,4540,0,67,0,1,1,1,1, 'Food 1-5 - Tough Hunk of Bread'); + +-- Mana Wyrm Reference loot for level 1 to 5 +SET @REFWYRM := @REF + 1; +INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@REFWYRM,20845,0,50,0,1,1,1,1, 'Wyrm 1-5 - Torn Wyrm Scale'), +(@REFWYRM,20846,0,50,0,1,1,1,1, 'Wyrm 1-5 - Faintly Glowing Eye'); + +-- Lynx Reference loot for level 1 to 5 +SET @REFLYNX := @REF + 2; +INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@REFLYNX,20812,0,50,0,1,1,1,1, 'Lynx 1-5 - Tattered Pelt'), +(@REFLYNX,20813,0,50,0,1,1,1,1, 'Lynx 1-5 - Lynx Tooth'); + +-- Tender Reference loot for level 1 to 5 +SET @REFTENDER := @REF + 3; +INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@REFTENDER,20842,0,50,0,1,1,1,1, 'Tender 1-5 - Frayed Tender Vine'), +(@REFTENDER,20843,0,50,0,1,1,1,1, 'Tender 1-5 - Smashed Petal'); + +-- Wraith Reference loot for level 1 to 5 +SET @REFWRAITH := @REF + 4; +INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@REFWRAITH,20847,0,50,0,1,1,1,1, 'Wraith 1-5 - Wraith Fragment'), +(@REFWRAITH,20848,0,50,0,1,1,1,1, 'Wraith 1-5 - Sparkling Dust'); + +-- Update loot for Entry 15274 : Mana Wyrm +SET @NPC := 15274; +DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@NPC,@REFWYRM,@REFWYRM,100,0,1,0,1,1, 'Mana Wyrm - (Wyrm 1-5 EXP 1 ReferenceTable)'), +(@NPC,1057,1057,30,0,1,0,1,1, 'Mana Wyrm - (Grey 1-5 EXP 1 ReferenceTable)'), +(@NPC,11111,11111,.2,0,1,0,1,1, 'Mana Wyrm - (Small Pouch ReferenceTable)'), +(@NPC,20482,0,80,1,1,0,1,1, 'Mana Wyrm - Arcane Sliver'); + +-- Update loot for Entry 15366 : Springpaw Cub +SET @NPC := 15366; +DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@NPC,@REFLYNX,@REFLYNX,100,0,1,0,1,1, 'Springpaw Cub - (Lynx 1-5 EXP 1 ReferenceTable)'), +-- (@NPC,@REFLYNX,@REFLYNX,30,0,1,1,1,1, 'Springpaw Cub - (Lynx 1-5 EXP 1 ReferenceTable)'), +(@NPC,1057,1057,30,0,1,0,1,1, 'Springpaw Cub - (Grey 1-5 EXP 1 ReferenceTable)'), +(@NPC,11111,11111,.2,0,1,0,1,1, 'Springpaw Cub - (Small Pouch ReferenceTable)'), +(@NPC,20797,0,80,1,1,0,1,1, 'Springpaw Cub - Lynx Collar'); + +-- Update loot for Entry 15372 : Springpaw Lynx +SET @NPC := 15372; +DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@NPC,@REFLYNX,@REFLYNX,100,0,1,0,1,1, 'Springpaw Lynx - (Lynx 1-5 EXP 1 ReferenceTable)'), +-- (@NPC,@REFLYNX,@REFLYNX,30,0,1,1,1,1, 'Springpaw Lynx - (Lynx 1-5 EXP 1 ReferenceTable)'), +(@NPC,1057,1057,30,0,1,0,1,1, 'Springpaw Lynx - (Grey 1-5 EXP 1 ReferenceTable)'), +(@NPC,11111,11111,.2,0,1,0,1,1, 'Springpaw Lynx - (Small Pouch ReferenceTable)'), +(@NPC,20797,0,80,1,1,0,1,1, 'Springpaw Lynx - Lynx Collar'); + +-- Update loot for Entry 15271 : Tender +SET @NPC := 15271; +DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@NPC,@REFTENDER,@REFTENDER,90,0,1,0,1,1, 'Tender - (Tender 1-5 EXP 1 ReferenceTable)'), +(@NPC,1057,1057,30,0,1,0,1,1, 'Tender - (Grey 1-5 EXP 1 ReferenceTable)'), +(@NPC,11111,11111,.2,0,1,0,1,1, 'Tender - (Small Pouch ReferenceTable)'); + +-- Update loot for Entry 15294 : Feral Tender +SET @NPC := 15294; +DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@NPC,@REFTENDER,@REFTENDER,100,0,1,0,1,1, 'Feral Tender - (Tender 1-5 EXP 1 ReferenceTable)'), +(@NPC,1057,1057,30,0,1,0,1,1, 'Feral Tender - (Grey 1-5 EXP 1 ReferenceTable)'), +(@NPC,11111,11111,.2,0,1,0,1,1, 'Feral Tender - (Small Pouch ReferenceTable)'), +(@NPC,20482,0,80,1,1,0,1,1, 'Feral Tender - Arcane Sliver'); + +-- Update loot for Entry 15273 : Arcane Wraith +SET @NPC := 15273; +DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@NPC,@REFWRAITH,@REFWRAITH,100,0,1,0,1,1, 'Arcane Wraith - (Wraith 1-5 EXP 1 ReferenceTable)'), +-- (@NPC,@REFWRAITH,@REFWRAITH,30,0,1,1,1,1, 'Arcane Wraith - (Wraith 1-5 EXP 1 ReferenceTable)'), +(@NPC,1057,1057,30,0,1,0,1,1, 'Arcane Wraith - (Grey 1-5 EXP 1 ReferenceTable)'), +(@NPC,11111,11111,.2,0,1,0,1,1, 'Arcane Wraith - (Small Pouch ReferenceTable)'), +(@NPC,20934,0,80,1,1,0,1,1, 'Arcane Wraith - Wraith Essence'), +(@NPC,20482,0,80,1,1,0,1,1, 'Arcane Wraith - Arcane Sliver'); + +-- Update loot for Entry 15298 : Tainted Arcane Wraith +SET @NPC := 15298; +DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@NPC,@REFWRAITH,@REFWRAITH,100,0,1,0,1,1, 'Tainted Arcane Wraith - (Wraith 1-5 EXP 1 ReferenceTable)'), +-- (@NPC,@REFWRAITH,@REFWRAITH,30,0,1,1,1,1, 'Tainted Arcane Wraith - (Wraith 1-5 EXP 1 ReferenceTable)'), +(@NPC,1057,1057,30,0,1,0,1,1, 'Tainted Arcane Wraith - (Grey 1-5 EXP 1 ReferenceTable)'), +(@NPC,11111,11111,.2,0,1,0,1,1, 'Tainted Arcane Wraith - (Small Pouch ReferenceTable)'), +(@NPC,20483,0,100,0,1,0,1,1, 'Tainted Arcane Wraith - Tainted Arcane Sliver'), +(@NPC,20934,0,80,1,1,0,1,1, 'Tainted Arcane Wraith - Wraith Essence'), +(@NPC,20482,0,80,1,1,0,1,1, 'Tainted Arcane Wraith - Arcane Sliver'); + +-- Update loot for Entry 15367 : Felendren the Banished +SET @NPC := 15367; +DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@NPC,@REFFOOD4,@REFFOOD4,100,0,1,0,1,1, 'Felendren the Banished - (Food 1-5 EXP 1 ReferenceTable)'), +(@NPC,1057,1057,30,0,1,0,1,1, 'Felendren the Banished - (Grey 1-5 EXP 1 ReferenceTable)'), +(@NPC,11111,11111,.2,0,1,0,1,1, 'Felendren the Banished - (Small Pouch ReferenceTable)'), +(@NPC,20799,0,100,1,1,0,1,1, 'Felendren the Banished - Felendren''s Head'); + +-- Update loot for Entry 15644 : Wretched Urchin +SET @NPC := 15644; +DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(@NPC,@REFFOOD4,@REFFOOD4,100,0,1,0,1,1, 'Wretched Urchin - (Food 1-5 EXP 1 ReferenceTable)'), +(@NPC,1057,1057,30,0,1,0,1,1, 'Wretched Urchin - (Grey 1-5 EXP 1 ReferenceTable)'), +(@NPC,11111,11111,.2,0,1,0,1,1, 'Wretched Urchin - (Small Pouch ReferenceTable)'); + +-- *** Sunstrider Isle *** +UPDATE `creature_template` SET `mingold`=1, `maxgold`=7 WHERE `entry` IN (15367); +DELETE FROM `reference_loot_template` WHERE `Entry`=24072; |