HOW TO REMOVE EU RACE DROPS

03/15/2018 18:23 devdash#1

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

03/16/2018 18:10 loader8#2

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

Spoiler

03/16/2018 18:41 devdash#3

Quote:

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 ?

03/16/2018 21:29 loader8#4

Quote:

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

Code:

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