vSRO Magic Pop (Gacha System) üzerinde D11 itemleri enable/disable yapma. _RefGachaItemSet ve _RefObjCommon join ile 11 degree itemlerin Service değerini kontrol etme ve aç/kapatma SQL scripti.

---

SQL Query: Select D11 Magic Pop Items



SELECT a.CodeName128, p.Service
FROM _RefGachaItemSet p
INNER JOIN _RefObjCommon a ON a.ID = p.RefItemID
WHERE a.CodeName128 LIKE '%11%'

---

SQL Query: Disable D11 Items



UPDATE _RefGachaItemSet
SET Service = 0
FROM _RefGachaItemSet p
INNER JOIN _RefObjCommon a ON a.ID = p.RefItemID
WHERE a.ID = p.RefItemID
AND a.CodeName128 LIKE '%11%'

---

SQL Query: Enable D11 Items



UPDATE _RefGachaItemSet
SET Service = 1
FROM _RefGachaItemSet p
INNER JOIN _RefObjCommon a ON a.ID = p.RefItemID
WHERE a.ID = p.RefItemID
AND a.CodeName128 LIKE '%11%'

---

Explanation:

• _RefGachaItemSet → Magic Pop / Gacha reward pool
• Service → item aktif/pasif durumu
• _RefObjCommon → item kod bilgisi
• %11% → D11 (11 degree) item filtreleme
• Service = 0 → item reward pool'dan çıkar
• Service = 1 → item tekrar aktif olur

---

Use Cases:

• Magic Pop balance düzenleme
• D11 item drop kontrolü
• Event reward filtering
• Server economy tuning
• Gacha system management

Tek