How to remove 10 DG İtems drop ??

[buriko_0007]

How can I change and what tables.

[buriko_0007]

Please help ;

Please help i need disable 10 dg all items...

I make _RefObjCommon in Service 1 to 0 => Game Server Error ;

this item is to drop but can`t find in _RefObjCommon,check it out its existance or service on/off [RefID:***]

[asanoftw]

1- Search for Dg10 items

select * from _RefObjCommon where CodeName128 like 'ITEM_%_10_%_RARE'

Copy ID for using "BETWEEN"

2 - Delete Items D10 for Drops

delete from _RefMonster_AssignedItemDrop where RefItemID between 4041 and 5735

[​Exo]

Ofc it gave an error you cant just set service to 0 when its used somewhere else

Originally Posted by asanoftw

1- Search for Dg10 items

select * from _RefObjCommon where CodeName128 like 'ITEM_%_10_%_RARE'

Copy ID for using "BETWEEN"

2 - Delete Items D10 for Drops

delete from _RefMonster_AssignedItemDrop where RefItemID between 4041 and 5735

This will disable too much ****

[ipause]

_RefObjCommon set service to 0

[spinal2]

To Simple .

Execute Querys in ordem ..

In my case, iam Disable Novas EU D11 and automatic drops Chance for Star D10 on mobs 104++

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 CodeName128 like '%ITEM_%_%_10_%'

[Zodiao]

PHP Code:

Update _RefDropItemAssign
set service='0'
where RefItemID in(Select ID From _RefobjCommon where codename128 like 'ITEM_%10%') 


Or you know, you can always disable it from _RefDropClassSel_Equip?
Set ProbX
where MonLevel > 100?