Question about deleting Eu in the game

08/27/2019 07:43 silkroadntc#1
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.
08/27/2019 11:09 _SGA_#2
Haven't tested but this should work.

Quote:
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.

Quote:
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
Quote:
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.
08/27/2019 11:27 Ryotic#3
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 [Only registered and activated users can see links. Click Here To Register...]

Sent from my PAR-LX1M using Tapatalk
08/27/2019 18:03 silkroadntc#4
I will check and answer the results..Thank you very much

Quote:
Originally Posted by legendworld View Post
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 [Only registered and activated users can see links. Click Here To Register...]

Sent from my PAR-LX1M using Tapatalk
Do we delete this part in the client?

Quote:
Originally Posted by _SGA_ View Post
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
08/27/2019 18:12 Ryotic#5
No just update this files with your file

Sent from my PAR-LX1M using Tapatalk
08/28/2019 11:07 _SGA_#6
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.
08/29/2019 16:28 silkroadntc#7
Quote:
Originally Posted by _SGA_ View Post
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 ^^