SRO Game Files (v1.188)

[JellyBitz]

Originally Posted by 204063135

i have many issues and i followed everything

You can create a new user "admin" with password "123123123" or also rename "sa" to "admin" and set the password as "123123123".


If you cannot make this step, don't try to go further.

[joaodematejr]

Good, I managed to make it work, just one question: after I release all the areas, when I call a unique one, it disappears, what could it be?

[ZαKuRα]

Originally Posted by joaodematejr

Good, I managed to make it work, just one question: after I release all the areas, when I call a unique one, it disappears, what could it be?

For this, a second GameServer is needed since the limit of 1 GameServer is 50k, so areas can be assigned to another GameServer

[JellyBitz]

Originally Posted by joaodematejr

when I call a unique one, it disappears, what could it be?

The GameServer has a limit on how many NPCs can spawn on all those regions assigned (50k, includes monsters, pets, etc.). You can check that by using GM console "/worldstatus"

One option is to set up more than one GameServer (I can't help you there), and split the regions handled by each one so you don't exceed this limit.

Another option is to change this limit for a higher one through ASM edits, check here:

[204063135]

what do u mean dont go any further? because i did this step as u did and still have some issues with Certification

[JellyBitz]

Originally Posted by 204063135

what do u mean dont go any further? because i did this step as u did and still have some issues with Certification

The video has step by step, everything is there. You cannot get an error and go to the next without fixing it. Just watch the video, I also got an error on Certification because I didn't remember some stuffs but I fixed that there. So, try to follow the video, there is no hidden steps.

[Pasko92]

Thank you very much for the clear explanations! Everything works for me until launching the SilkroadLauncher.exe.

When I launch it I get: "The server is undergoing inspection or updates". When I click OK, it opens the Launcher but the Start button is missing. Any ideas?

[JellyBitz]

Originally Posted by Pasko92

When I launch it I get: "The server is undergoing inspection or updates"

Did you change the original IP? You maybe missing the step which involves using IPINPUT. No other clue.

[Pasko92]

Originally Posted by JellyBitz

Did you change the original IP? You maybe missing the step which involves using IPINPUT. No other clue.

That was exactly what I was missing. I had to use the IPINPUT and set the IP to my own. Thank you!

[raptoru20]

Hi,

I Watched and did everything same in video but there is couple problem. I Dont know is this about server files or mis-configuration.

I Use server 2022 and sql server 2022

- I Used IPINPUT and i open game but i see server in check status i cant login game
- In sql Shardservice -> shardid is 3 because in smc i see shard [3]
- In smc the shard part always red. I Tried to click "Start All Services" and "Service Type Operating"
- In SR_Gameserver and SR_ShardManager log i see the " DB Connection Failed! " line but after this line i see the " SR_GameServer is initialized successfully " line
- I Checked everything. SQL Working normal, iss working normal, users and passwords are true

I Tried everything to make Shard area green but its shows always red. I Dont know why

I Add video and screenshot about what i describe upper side

Photo :

 Spoiler

Video :

 Spoiler

Can you help me please

Thank you

[JellyBitz]

Originally Posted by raptoru20

My quick guess is you didn't changed the SRO_CERTIFICATION.ServerMachine IP from that table.
Or maybe you're trying to use another user/password instead "admin"/"123123123", in such case you'll have to change more tables from SRO_CERTIFICATION like Division and Shard. Maybe something else have to be changed, idk.

[tiojotta]

What is the password to extract?

[misteryou1607]

Hi i have a problem with globalmanager when i click on it its pop up and closed. Cert and sql all working fine. any solution?much appreciated


EDIT: i managed to launched the game but my question is how do i create an account?

[JellyBitz]

Originally Posted by misteryou1607

how do i create an account?

PHP Code:

USE SRO_VT_ACCOUNT

DECLARE @_@AccountID VARCHAR(25) = 'myadmin'
DECLARE @_@AccountPW VARCHAR(50) = '123123123'
DECLARE @_@IsAdmin BIT = 1 -- 0 = User, 1 = Admin
DECLARE @_@SilkAmount INTEGER = 10000

--- Add user
DECLARE @_@TB_User_JID INTEGER = IDENT_CURRENT('dbo.TB_User') + 1
INSERT INTO dbo.TB_User
    ([StrUserID],[password],[sec_primary],[sec_content],[AccPlayTime],[LatestUpdateTime_ToPlayTime])
VALUES
    (LOWER(@_@AccountID) -- Lower just in case
    ,LOWER(CONVERT(VARCHAR(32), HashBytes('MD5', @_@AccountPW), 2)) -- Encrypt password
    ,CASE
        WHEN @_@IsAdmin = 1 THEN 1 -- Admin
        ELSE 3 -- User
    END
    ,CASE
        WHEN @_@IsAdmin = 1 THEN 1 -- Admin
        ELSE 3 -- User
    END
    ,0
    ,0)
-- Add silk record
INSERT INTO dbo.SK_Silk
VALUES
    (@_@TB_User_JID
    ,@_@SilkAmount
    ,0
    ,0) 


[misteryou1607]

Thank you! and one lastt thing no unique spawn?