#!/usr/bin/env python3
"""Delete all drop rows for NPC 841 (orphan — not in pk_npcdef.sql)."""
import sys, os, shutil
sys.path.insert(0, '/Users/tomassimkus/VS/openrsc-develop')
os.chdir('/Users/tomassimkus/VS/openrsc-develop')
from update_drops import parse_update_sql, write_update_sql

shutil.copy("pk_npcdrops.sql", "pk_npcdrops_update.sql")

header, rows, footer = parse_update_sql()
before = len(rows)
rows = [r for r in rows if r[0] != 841]
removed = before - len(rows)

rows.sort(key=lambda r: (r[0], 0 if r[3] == 0 else 1, r[3], r[2]))
write_update_sql(header, rows, footer)

shutil.copy("pk_npcdrops_update.sql", "pk_npcdrops.sql")
shutil.copy("pk_npcdrops_update.sql", "pk_npcdrops_p2p_update.sql")

print(f"Removed {removed} rows for NPC 841.")