🎲 Monster Drop System

📖 Overview

Monster drops are controlled by two main tables: cq_dropitemrule and cq_monstertype. Both must match using drop_item_rule ↔ group_id.

⚙️ cq_dropitemrule

• group_id → must match drop_item_rule in cq_monstertype
• chance → drop rate
• Example values:
  200000 = low (200k)
  500000 = medium (500k)
  1000000 = high (1M)
• item0–item14 → item IDs to drop (from cq_itemtype)

⚔️ cq_monstertype

• drop_money_min → minimum money per gold pile
• drop_money_max → maximum money per gold pile
• drop_money_chance → chance of dropping money
• drop_item_chance → chance of dropping items (includes unidentified/low-quality equipment)
• explode_item_chance1/2/3 → extra item drop chances
• drop_item_rule → must match cq_dropitemrule.group_id

💻 Example SQL

-- Set drop rule 1001 to drop item ID 729020 with lower chance
UPDATE cq_dropitemrule 
SET chance = 200000, item0 = 729020 
WHERE group_id = 1001;

-- Assign monster 1001 to use drop rule 1001
UPDATE cq_monstertype 
SET drop_money_min = 100,
    drop_money_max = 500,
    drop_money_chance = 800000,
    drop_item_chance = 500000, -- includes unidentified / low-quality equips
    drop_item_rule = 1001
WHERE id = 1001;