diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_08_01_03_world.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_08_01_03_world.sql b/sql/updates/world/6.x/2016_08_01_03_world.sql new file mode 100644 index 00000000000..bb84723321b --- /dev/null +++ b/sql/updates/world/6.x/2016_08_01_03_world.sql @@ -0,0 +1,28 @@ +-- Add items to gameobject_loot_template +DELETE FROM `gameobject_loot_template` WHERE `Entry`=29711; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(29711, 55249, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Triton Legplates'), +(29711, 55250, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Nautilus Ring'), +(29711, 55251, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Might of the Ocean'), +(29711, 55252, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Whitefin Axe'), +(29711, 55253, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Wentletrap Vest'), +(29711, 55254, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Abalone Plate Armor'), +(29711, 55255, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Mnemiopsis Gloves'), +(29711, 55256, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Sea Star'), +(29711, 55258, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Pipefish Cord'), +(29711, 55259, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Normal contains Bioluminescent Lamp'); + +-- Add items to gameobject_loot_template +DELETE FROM `gameobject_loot_template` WHERE `Entry`=36142; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(36142, 52078, 0, 100, 0, 1, 0, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Chaos Orb'), +(36142, 56281, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Wentletrap Vest'), +(36142, 56282, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Nautilus Ring'), +(36142, 56283, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Triton Legplates'), +(36142, 56284, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Whitefin Axe'), +(36142, 56285, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Might of the Ocean'), +(36142, 56286, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Mnemiopsis Gloves'), +(36142, 56288, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Pipefish Cord'), +(36142, 56289, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Bioluminescent Lamp'), +(36142, 56290, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Sea Star'), +(36142, 56291, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Neptulon''s Cache Heroic contains Abalone Plate Armor'); |