HOW TO REMOVE EU RACE DROPS

[devdash]

how can i replace eu race drops with ch race drops, because my server is Chinese race, and how can i disable Tablets drops aswell,
thanks in advance

[loader8]

Use this query is from DG just execute and change the DG

 Spoiler

USE SRO_VT_SHARD
update _RefDropItemAssign set Service = 0
from _RefDropItemAssign Drops
left join _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID)
WHERE CodeName128 like '%ITEM_EU_%_10_%'

[devdash]

Originally Posted by loader8

Use this query is from DG just execute and change the DG

 Spoiler

USE SRO_VT_SHARD
update _RefDropItemAssign set Service = 0
from _RefDropItemAssign Drops
left join _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID)
WHERE CodeName128 like '%ITEM_EU_%_10_%'

is that inculding rare EU items ?

[loader8]

Originally Posted by alydandy

is that inculding rare EU items ?

yes
if you want to know what is going to inculding, use this Query frist

select * from _RefObjCommon where CodeName128 like '%ITEM_EU_%_10_%'