Error when Removing DG13 Dg12 from drops

04/10/2015 02:06 GehadGamal#1
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 :
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

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
04/11/2015 14:09 Aaron*#2
Your query can only fck gs but it can't remove drops
here is a better one that will remove d12 drops
Quote:
update rdit
set dropcount = 0
from _refdropitemassign rdit
join _refobjcommon roc
on rdit.refitemid = roc.id
where roc.codename128 like 'ITEM_%_12%'