Error when Removing DG13 Dg12 from drops

[GehadGamal]

Hello Epvpers .. i was Trying Hardly to Remove Dg13 Dg12 Drops from Mobs and Uniques . But no good :S i tried This Way

PHP Code:

FIRST DISABLE IN DB 

Use SRO_VT_SHARD 
UPDATE _RefObjCommon 
Set Service = 0 
WHERE CodeName128 like '%ITEM_%_%_10_%'   


THEN DISABLE FROM NPCs 

Use SRO_VT_SHARD 
UPDATE _RefPackageItem 
Set Service = 0 
WHERE CodeName128 like '%ITEM_%_%_10_%'   




Use SRO_VT_SHARD 
UPDATE _RefPricePolicyOfItem 
Set Service = 0 
WHERE RefPackageitemCodeName like '%ITEM_%_%_10_%'   




Use SRO_VT_SHARD 
UPDATE _RefScrapOfPackageItem 
Set Service = 0 
WHERE RefPackageitemCodeName like '%ITEM_%_%_10_%'  


Use SRO_VT_SHARD 
UPDATE _RefShopGoods 
Set Service = 0 
WHERE RefTabCodeName like '%ITEM_%_%_10_%' 


But after i did . when i open SR_Gameserver a Flood of errors Hits me
the Errors :




i know that this makes the DB ruined so i can Restore it .. But i am still Looking for a way to Disable the Drops :S .. Thanks in Advance

[Aaron*]

Your query can only fck gs but it can't remove drops
here is a better one that will remove d12 drops

update rdit
set dropcount = 0
from _refdropitemassign rdit
join _refobjcommon roc
on rdit.refitemid = roc.id
where roc.codename128 like 'ITEM_%_12%'