Open nazwadi opened 1 year ago
Source(s):
UPDATE lootdrop_entries
SET disabled_chance = chance, chance = 0
WHERE item_id = 24094; -- Nodding Blue Lily
Source(s):
[x] Small Froglok Bone Vial (id:6597) was first introduced during the Shadows of Luclin expansion _Based on earliest Alla's comment, it appears to have been added in Shadows of Luclin to the krup_ghoul_knight's loot table. It only appears in lootdrop table id: 4420. Recommend setting the minexpansion on this table to 3 (Luclin) accordingly.
UPDATE lootdrop
SET min_expansion = 3
WHERE id = 4420; --lootdrop.name is "2393_Krup_Ghoul_Knight_Misc"
For lootdrop.id 159121, create a copy of that table and max_expansion the one where it is disabled to 2, min_expansion the one where it is enabled to 3.
UPDATE lootdrop
SET min_expansion = 3
WHERE lootdrop.id = 3761 -- used by skeletal_harbinger and skeletal_baron in Sebilis
OR lootdrop.id = 3764 -- used by skeletal_duke in Sebilis
OR lootdrop.id = 4330 -- used by skeletal_hierophant in Sebilis
-- OR lootdrop.id = 159121; --shares a table with other items; needs to be separated
Source: https://everquest.allakhazam.com/db/item.html?item=12211#m102216651555804_
UPDATE lootdrop
SET min_expansion = 5
WHERE lootdrop.id = 1563 -- Sebilite_Guardian
OR lootdrop.id = 2197 -- sebilite_golem, spectral_revenant
OR lootdrop.id = 3758 -- spectral_commander
OR lootdrop.id = 3774 -- spectral_crusader
OR lootdrop.id = 3781 -- spectral_harbinger
Source: https://everquest.allakhazam.com/db/item.html?item=8670
UPDATE lootdrop_entries le
SET chance = 0.5
WHERE le.lootdrop_id = 808 -- used by froglok_jin_shaman
OR le.lootdrop_id = 811; -- used by froglok_jin_wizard
Source(s):
[ ] Wild Lord's Crown should be flagged to drop in Luclin era off Froggy. _Recommend adding a new lootdrop table to Froggy's loot table. The pre-existing lootdrop table that includes the Wild Lord's Crown has had a min_expansion flag of 3 (Luclin) added to it (I've renamed it to "895_Froggy_Wear_Luclin"). The new lootdrop table is a duplicate of the original but without the Wild Lord's Crown and has a maxexpansion flag of 2 (Velious) added to it. They should be mutually exclusive as the server progresses.
Source(s):
Source(s):
https://everquest.allakhazam.com/db/item.html?item=7384 (first comment Dec. 13, 2001; Beastlords first appeared with The Shadows of Luclin expansion)
[x] Gruplinort should drop Sarnak Warhammer ultra rare 1%.
Naz: "Recommend content_flag its drop occurrence from froglok_reet_knight (89003) so that it stops dropping 1 month into Kunark. Then will need to add a content flagged lootdrop table to whichever mob(s) it drops from in VP after the November 2000 patch." Turbo: "From what I saw the blade drops until the November 2000 patch not the April 2000 patch. Once Nov 2000 comes around it is removed from game and a similar but upgraded weapon drops in VP."
This was likely removed from drop table and replaced with the Blade of the Green Dragon Eye in VP. Source: https://everquest.allakhazam.com/db/item.html?item=343#m98026419227453, and https://everquest.allakhazam.com/db/item.html?item=343#m98109210924577 . There is a Sep 07 2000 comment stating that Eq'lizer still listed a froglok reet knight as dropping the Blade of the Black Dragon Eye: https://everquest.allakhazam.com/db/npc.html?id=5019#m9683064075683
[x] Remove Sludged Girdle and Bone Mask of the Jarsath from Leprous Scarab
[x] Ensure Bone Mask of the Jarsath only drops from pox scarab and sepsis scarab
[ ] The only item the sebilite golem drops is Worn Cloth Mantle
[x] Obulous Death Shroud only drops from froglok dar knight and froglok bok wizard Remarks: Allakhazam's currently also lists a dar ghoul knight (Source: https://everquest.allakhazam.com/db/item.html?item=1059). Earliest comments show June 03, 2001. Mana Preservation property doesn't seem Kunark era though.
[x] Undead froglok spine is out of era and should be set at 0% in the db _Based on https://everquest.allakhazam.com/db/item.html?item=50878 Estimating this to 2017 based on the Task it is associated with (Kuughrak's Task)...and tasks were definitely not classic. 2017 was Ring of Scale. Recommending setting the lootdrop table where this i s the sole entry (Lootdrop id: 4885 associated with dar_ghoul_knight (89080) to a minexpansion=24).
[ ] Drop chance % are switched on Hierophant Prime Grekal. Should be:
Hierophant's Cloak - 32%
Sword of Skyfire - 50%
Sword of the Morning - 8%
[ ] Juggs should drop all 56-59 spells at a overall drop rate of 1 spell every 15 kills.
Sludged Girdle does not drop in Kunark era. Needs % dropped to 0% in Kunark.
Remove Sludged Girdle and Bone Mask of the Jarsath from Leprous Scarab
Bone Mask of the Harsath only drops from pox scarab and sepsis scarab
Only 1 froglok forager and froglok hunter can be up at a time
The only item the sebilite golem drops is Worn Cloth Mantle
Obulous Death Shroud only drops from froglok dar knight and froglok bok wizard
Undead froglok spine is out of era and should be set at 0% in the db
Looks like Emp Chottal has 2 item loot tables for Deepwater Vambraces, Nathsar Greatsword and Rod of Lamentation. Should only have 1 or verify only 1 is active.
Only 1 froglok forager and froglok hunter can be up at a time
My understanding is that this wasn't fixed until the patch on EQ Live on June 13, 2006. P99 Wiki states "10/25/2017 - Confirmed multiple from the same cycle can be up at a time."
Only 1 froglok forager and froglok hunter can be up at a time
My understanding is that this wasn't fixed until the patch on EQ Live on June 13, 2006. P99 Wiki states "10/25/2017 - Confirmed multiple from the same cycle can be up at a time."
This are in traks teeth, not sebilis, right?
Only 1 froglok forager and froglok hunter can be up at a time
My understanding is that this wasn't fixed until the patch on EQ Live on June 13, 2006. P99 Wiki states "10/25/2017 - Confirmed multiple from the same cycle can be up at a time."
This are in traks teeth, not sebilis, right?
Yeah - this belongs in #30
Looks like Emp Chottal has 2 item loot tables for Deepwater Vambraces, Nathsar Greatsword and Rod of Lamentation. Should only have 1 or verify only 1 is active.
When Kunark_LegacyItemDrops
are enabled, loot table includes Deepwater Vambraces, Nathsar Greatsword, and Rod of Mourning. When disabled, that table is disabled and replaced with one where the Rod of Mourning is replaced with Rod of Lamentation. This is by design since Rod of Mourning (ID: 6629) was replaced by Rod of Lamentation (ID: 6693) (see https://fvproject.com/index.php/Content_Flags#Kunark_LegacyItemDrops)
Sludged Girdle does not drop in Kunark era. Needs % dropped to 0% in Kunark.
Found Nov 2000 comment on Alla's saying it was dropping from pox scarab: https://everquest.allakhazam.com/db/npc.html?id=5142#m97345296323358
Undead froglok spine is out of era and should be set at 0% in the db
https://everquest.allakhazam.com/db/item.html?item=50878 Estimating this to 2017 based on the Task it is associated with (Kuughrak's Task)...and tasks were definitely not classic. 2017 was Ring of Scale. Recommending setting the lootdrop table where this i s the sole entry (Lootdrop id: 4885 associated with dar_ghoul_knight (89080) to a min_expansion=24).
Remove Sludged Girdle and Bone Mask of the Jarsath from Leprous Scarab
Added to Loot Discrepancies list
Bone Mask of the Harsath only drops from pox scarab and sepsis scarab
Added to Loot Discrepancies list
The only item the sebilite golem drops is Worn Cloth Mantle
Added to Loot Discrepancies list
Obulous Death Shroud only drops from froglok dar knight and froglok bok wizard
Added to Loot Discrepancies list
Undead froglok spine is out of era and should be set at 0% in the db
Added to Loot Discrepancies list
Issue: Crypt Entrance and Entrance to Emperor Chottal's chamber should have lockpick set at 201. Currently only the crypt entrance has lockpick set, and it is set to 100.
Endstate:
Source: A 50 rogue needed mechanical lockpicks to open or level 51 skilled up to 201. https://thesafehouse.org/forums/forum/everquest-wing/main-lounge/27621-sebilis-locked-door
Blade of the Black Dragon Eye drops until release of the November 2000 patch. Naz: "Recommend content_flag its drop occurrence from froglok_reet_knight (89003) so that it stops dropping 1 month into Kunark. Then will need to add a content flagged lootdrop table to whichever mob(s) it drops from in VP after the November 2000 patch." Turbo: "From what I saw the blade drops until the November 2000 patch not the April 2000 patch. Once Nov 2000 comes around it is removed from game and a similar but upgraded weapon drops in VP."
This was likely removed from drop table and replaced with the Blade of the Green Dragon Eye in VP. Source: https://everquest.allakhazam.com/db/item.html?item=343#m98026419227453, and https://everquest.allakhazam.com/db/item.html?item=343#m98109210924577 . There is a Sep 07 2000 comment stating that Eq'lizer still listed a froglok reet knight as dropping the Blade of the Black Dragon Eye: https://everquest.allakhazam.com/db/npc.html?id=5019#m9683064075683
Like other "nerfed" items, Blade of the Black Dragon Eye was added to the Kunark Old World Drops list. This item will drop for the entirety of Kunark, however, it will be a part of occasional events where Kunark drops will be enabled on Velious.