Hey man, thanks for the amazing post with guide and files. much appreciated.Quote:
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.
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.Quote:
thanks! i'll try that, if that doesnt work ill set my VM on fire and build a new one :pQuote:
That's another topic and it's up to you, take a look to [Only registered and activated users can see links. Click Here To Register...] one.Quote:
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 <3Quote:
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)
[Only registered and activated users can see links. Click Here To Register...]Quote:
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.Quote:
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._RefRegionBindAssocServerQuote:
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".Quote: