frenzied ghoul issue?

[Kobias]

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:

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:

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!