SRO Game Files (v1.188)

[Rev 9]

This Ladys and Gentleman is the SRO Legend himself!

Thank u for the release. Finally i can make a clean backup of all stuff from 1 hand and i dont have to look tho 100 threads and search for the **** i want

[Tommeeeh]

Originally Posted by JellyBitz

Yes. the only requirements are the one being mentioned, just take a look to the video tutorial.




Take in mind these files are preconfigurated to use 192.168.1.121, so anywhere you find that IP you'll need to change it.

I didn't have plans to explain it since I may don't remember correctly but I'm gonna try (and if I miss something I'll add it)

• You'll have to change the IP written inside the executable from modules, so that's the _IPSpoofing.exe tool you'll find inside the files; execute it write the executable name and set the new ip on each module.
• Then try to change the IP inside server.cfg,smc_updater.cfg, ServiceManager.cfg, Certification.xml text files.
• Last but not least, the IP from database tables; SRO_CERTIFICATION.ServerMachine, SRO_VT_ACCOUNT._PrivilegedIP.
• For the client side, use IPINPUT tool to change the host/IP.

Hey man, thanks for the amazing post with guide and files. much appreciated.
i hope you might be able to help with this, i followed the instructions and even tried the solution that you mentioned above.
when i start SR Module Manager, and click *almost* any manager or server, it will show a flash of a screen that disappears, the module then says it is Running..., but as soon as i try to start another then the first one will say Module not active!.

i think the flashing screen is the screen you get on the top right on your vid on: 36:40

ive disabled windows defender and the firewall, it is a clean windows server 2019.

checked all IP's i could find like 4 times now, i even deleted the DB (Cert) and restored it again (and changed the IP's). i also did everything u mentioned here in the quote.

i havent found anything in eventviewer... services are up and running and
Replace.Certification.exe is running without errors.

Does anyone have an idea?

[JellyBitz]

Originally Posted by Tommeeeh

when i start SR Module Manager, and click *almost* any manager or server, it will show a flash of a screen that disappears, the module then says it is Running..., but as soon as i try to start another then the first one will say Module not active!.

Maybe you're having issues with the Data Execution Prevention (DEP) on Windows Server, try to disable it or google about it. I don't have any other clue.

[Tommeeeh]

Originally Posted by JellyBitz

Maybe you're having issues with the Data Execution Prevention (DEP) on Windows Server, try to disable it or google about it. I don't have any other clue.

thanks! i'll try that, if that doesnt work ill set my VM on fire and build a new one


EDIT:
turning off DEP helped me to at least show the window that immediately dissapeared before.
however it did not solve the issue.

i now have it working, i tried the exact same thing as i did with my IP.
i re-wrote all IP adresses in the modules with the tooling that is provided,
i re-wrote the two DB's with the new IP and i rewrote all .cfg files that contained the old IP.
i changed all those IP's to the one in the vid (192.168.1.121) instead of my IP.
that worked, so i guess that turning off DEP helped, but i think there is also a location missing where you also have to change the IP.

if anyone knows, please share i am handy with windows servers but SQL is not one of my skills

[code19dec]

awesome, worked well.. but how to add website to this?! to register accounts xD

[JellyBitz]

Originally Posted by code19dec

how to add website to this?! to register accounts xD

That's another topic and it's up to you, take a look to one.

But if you're in a hurry, I just checked you can make an account manually like this.

PHP Code:

USE [SRO_VT_ACCOUNT]

DECLARE @AccountID VARCHAR(25) = 'myadmin'
DECLARE @AccountPW VARCHAR(50) = '123123123'
DECLARE @IsAdmin BIT = 1
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],[Play123Time])
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
    ,0) -- ?

-- Add silk record
INSERT INTO [dbo].[SK_Silk]
    ([JID],[silk_own],[silk_gift],[silk_point])
VALUES
    (@TB_User_JID
    ,@SilkAmount
    ,0
    ,0) 


[code19dec]

Originally Posted by JellyBitz

That's another topic and it's up to you, take a look to one.

But if you're in a hurry, I just checked you can make an account manually like this.

PHP Code:

USE [SRO_VT_ACCOUNT]

DECLARE @AccountID VARCHAR(25) = 'myadmin'
DECLARE @AccountPW VARCHAR(50) = '123123123'
DECLARE @IsAdmin BIT = 1
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],[Play123Time])
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
    ,0) -- ?

-- Add silk record
INSERT INTO [dbo].[SK_Silk]
    ([JID],[silk_own],[silk_gift],[silk_point])
VALUES
    (@TB_User_JID
    ,@SilkAmount
    ,0
    ,0) 


everything worked great for me, and im so happy.. thank you for help <3

[darkmonn]

rar pas pls

rar pas plss

[JellyBitz]

Originally Posted by darkmonn

rar pas pls

"EPVP" .. It's the only one with password to avoid get a reported flag by the system.

[darkmonn]

i don't understand what the password is and we can't use these files

[domgg29]

Very useful for new users!! thanks a lot jose gregorio

[feyexey103]

The program have virus same vsro file or

[ccrraazzyyxx]

First of all, I would like to thank you for your wonderful effort
I have already started the server, but there is a virus in the sro_client.exe file. Is there a solution for that? Also, Alexandria city is not allowed to travel to it can i fix it , and from where can i change exp rate and sp rate thank you

[JellyBitz]

Originally Posted by ccrraazzyyxx

there is a virus in the sro_client.exe file. Is there a solution for that?

I can't do nothing about it. I've used the most unmodified sro_client.exe I found, and just applied the "no xtrap" solution, nothing else as far as I remember.

It also depends on the antivirus you're using, personally I use Kaspersky and there is no such detection as virus. ()

Originally Posted by ccrraazzyyxx

Also, Alexandria city is not allowed to travel

Enabling all zones gonna reach +50k monsters over one gameserver, bugs are gonna happen. With that on mind, you can enable zones from SRO_VT_SHARD._RefRegionBindAssocServer

Originally Posted by ccrraazzyyxx

from where can i change exp rate and sp rate

Server files has a text file server.cfg, and there is some basic settings.. I think there is no SP rate but just EXP rate as "ExpRatio".

I recommend you to use the forum, all such questions have been answered in the past, my plan here is only having a running server setup for testing, nothing else.

[Sairentoz]

By far one of the best tutorials i've seen ! and also for free?
a guy wanted to charge me 250 bucks for ''helping'' me setting up my server