"""Identifie les rvdata skill IDs sans coût et sans icône (pour flag is_enemy_skill=1)."""
import sys, csv
sys.stdout.reconfigure(encoding="utf-8")
from pathlib import Path

D = Path(r"c:\wamp64\www\csi-world\csv_data\csi-forever")
with (D / "Skills.csv").open(encoding="utf-8-sig") as f:
    rows = list(csv.DictReader(f, delimiter=";"))

ids = []
for r in rows:
    if int(r["mp_cost"]) == 0 and int(r["tp_cost"]) == 0 and int(r["icon_index"]) == 0:
        ids.append(int(r["id"]))

id_list = ",".join(str(i) for i in sorted(ids))
print(f"Skills sans coût ni icône : {len(ids)} ids")
print(f"UPDATE skill SET is_enemy_skill=1 WHERE game_id=0 AND original_id IN ({id_list})")