[Request] How to remove Drop items from uniques

i wanna to know How to remove Drop items from uniques

ThanQ :)

DELETE _RefDropItemAssign
FROM _RefDropItemAssign Drops
LEFT JOIN _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID)
WHERE CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_%_12_%'

all drop close :3

PHP Code:

---

USE SRO_VT_SHARD
UPDATE _RefMonster_AssignedItemDrop 
SET DropRatio = 0 
WHERE RefMonsterID = X and RefItemID = Y 


---

I tried a few times to delete the references but always happen any errors.
what I did was to set the dropratio 0

X= MONSTER ID
Y= ITEM ID

FOR MOB ID:

PHP Code:

---

USE SRO_VT_SHARD
SELECT * FROM _RefObjCommon
WHERE CodeName128 like '%tigerwoman%' 


---

ThanQ ^_^

- - - Updated - - -

Quote:

---

Originally Posted by lepitismak

PHP Code:

---

USE SRO_VT_SHARD
UPDATE _RefMonster_AssignedItemDrop 
SET DropRatio = 0 
WHERE RefMonsterID = X and RefItemID = Y 


---

I tried a few times to delete the references but always happen any errors.
what I did was to set the dropratio 0

X= MONSTER ID
Y= ITEM ID

FOR MOB ID:

PHP Code:

---

USE SRO_VT_SHARD
SELECT * FROM _RefObjCommon
WHERE CodeName128 like '%tigerwoman%' 


---

---

ThanQ <3 :)

- - - Updated - - -

Quote:

---

Originally Posted by yow4141

DELETE _RefDropItemAssign
FROM _RefDropItemAssign Drops
LEFT JOIN _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID)
WHERE CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_%_12_%'

all drop close :3

---

ThanQ <3