Question about deleting Eu in the game

[silkroadntc]

How to delete Eu in the game and related Eu items? I plan to launch a Private Server and only use Asia. I would appreciate the answers. Thanks for the experts.

[_SGA_]

Haven't tested but this should work.

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_%'

WARNING!!!
I haven't tested this, after you disable the services the gs might crash while launching.
Make sure to backup your database before testing it, if GS doesn't run after using this query you can restore the old state by running this one.

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

and again, please note I haven't tested this!


Alternatively you can disable only the items which contains degree information this way you will make sure you won't disable quest and other items that contain ITEM_EU_.
Example

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_%'

Other than that disable the EU maps from RefRegionBindassoc table.

[Ryotic]

There is post for it and update data pk2 to remove EU from creating new character

Sent from my PAR-LX1M using Tapatalk

Update this

Sent from my PAR-LX1M using Tapatalk

[silkroadntc]

I will check and answer the results..Thank you very much

Originally Posted by legendworld

There is post for it and update data pk2 to remove EU from creating new character

Sent from my PAR-LX1M using Tapatalk

Update this

Sent from my PAR-LX1M using Tapatalk

Do we delete this part in the client?

Originally Posted by _SGA_

Haven't tested but this should work.



WARNING!!!
I haven't tested this, after you disable the services the gs might crash while launching.
Make sure to backup your database before testing it, if GS doesn't run after using this query you can restore the old state by running this one.



and again, please note I haven't tested this!


Alternatively you can disable only the items which contains degree information this way you will make sure you won't disable quest and other items that contain ITEM_EU_.
Example


Other than that disable the EU maps from RefRegionBindassoc table.

Let me test it. Thanks, anyway

[Ryotic]

No just update this files with your file

Sent from my PAR-LX1M using Tapatalk

[_SGA_]

Please Note: Legendworld's files will only disable EU from client side, which means anyone will be able to create EU char connecting with another client! So make sure to disable it from server side too.

[silkroadntc]

Originally Posted by _SGA_

Haven't tested but this should work.



WARNING!!!
I haven't tested this, after you disable the services the gs might crash while launching.
Make sure to backup your database before testing it, if GS doesn't run after using this query you can restore the old state by running this one.



and again, please note I haven't tested this!


Alternatively you can disable only the items which contains degree information this way you will make sure you won't disable quest and other items that contain ITEM_EU_.
Example


Other than that disable the EU maps from RefRegionBindassoc table.

Unable to start SR_GameServer if using the above command ^^