Let me first preface my post by saying: P1999 is not necessarily PEQ. I'm not a developer here, but I have noticed certain things are similar to PEQ. Recreating spawns and loot tables by hand is very, very cumbersome. Because of that, I can understand if they haven't diverged from PEQ in this aspect, and instead only changed what wasn't classic into classic.
Based on PEQ DB:
Named NPC Spawn Points:
Code:
SELECT SE.spawngroupID, npcID, NT.name, zone, chance, respawntime, `variance` from spawnentry SE
JOIN spawn2 S2 ON S2.spawngroupID = SE.spawngroupID
JOIN npc_types NT ON NT.id = npcID
WHERE npcID in (SELECT id FROM npc_types WHERE name LIKE '%frenzied_ghoul%')
Yields:
[You must be logged in to view images. Log in or Register.]
Explanation:
-There are 3 Spawn points for the Frenzy
-
Frenzy has a 10% Chance to spawn in each of those points.
NPC Loot Drops:
Code:
SELECT NT.id, NT.name, IT.name as "Item Name", LTE.probability, LTE.multiplier, LDE.chance from npc_types NT
JOIN loottable LT ON LT.id = NT.loottable_id
JOIN loottable_entries LTE ON LTE.loottable_id = LT.id
JOIN lootdrop_entries LDE ON LDE.lootdrop_id = LTE.lootdrop_id
JOIN items IT ON IT.id = LDE.item_id
where NT.id in (SELECT id FROM npc_types WHERE name LIKE '%frenzied_ghoul%')
Yields:
[You must be logged in to view images. Log in or Register.]
Explanation:- Probability => Chance that this item set appears
- Multiplier => # of items that could drop from this. [1, Multiplier]
- Chance => The probability this item drops from this set.
- FBSS = 20% Chance, Moonstone Ring = 80% Chance
Again, re-emphasizing... this may or may not be P1999's loot drop values. However, I thought it might be interesting for you to look at in-case that they are identical... or at least give you hope that it'll drop eventually =)
Good luck!