View Single Post
  #11  
Old 08-13-2011, 01:04 PM
Kobias Kobias is offline
Aviak

Kobias's Avatar

Join Date: May 2011
Posts: 80
Default

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!
__________________
[47 Wizard] Kobias (Human)

Originally from Tarew Marr. May it rest in peace, as it died to become Drinal :'(
Last edited by Kobias; 08-13-2011 at 01:20 PM.. Reason: Clarification