[Release] Replace.Certification

07/27/2016 06:24 DaxterSoul#1
Hello, this is a release for all with slightly more complex setups who are tired of editing .ini files & compiling the pack.dat...

This works just like the CustomCertificationServer you know and might give you some "new" features.

How to setup:
- Create a new SRO_CERTIFICATION database.
- Execute Database\SRO_CERTIFICATION.sql script on it to create tables and predefined data.
- Change IPs, Ports and DBConfigs to your configuration.
- Make sure to change [SRO_VT_ACCOUNT].[_ShardService] to given ID(s) from [SRO_CERTIFICATION].[Shard] table.
- Change settings in Config\Certification.xml
- Start Replace.Certification.exe

Tested on vSRO 1.188

Features:
- Database (no pack.dat compiling)
- Change Shard name while server is running
- Change Shard capacity while server is running
- Implemented [Only registered and activated users can see links. Click Here To Register...]

Known issues:
- Multiple GlobalManagers are not supported yet
- Certain modified GatewayServers do not support shard updating.

Credits to Drew Benton for his awesome pioneering and with CustomCertificationServer, SilkroadSecurity, AsyncNetwork.
Credits to Painkiller for little hints here and there.
Credits to florian0 for MiniBillingServer

Planned for future versions:
- Migrate with CraYu's GUI.

Scan:
- [Only registered and activated users can see links. Click Here To Register...]
- [Only registered and activated users can see links. Click Here To Register...]

Source: [Only registered and activated users can see links. Click Here To Register...]

Download:
- [Only registered and activated users can see links. Click Here To Register...]
- [Only registered and activated users can see links. Click Here To Register...]
07/27/2016 10:12 rares495#2
Well it works as intended. Good job. Waiting for the new version with minibilling included since i'm too much of a lazy fuck to do it myself. :)
07/27/2016 12:37 xGyros#3
Great job, seems like somebody finally did fully working custom certification server. I didin't thought it will be released....

Note: This certification will work with all server files up to 2013. Later on Joymax, changed some stuff, incl. the encryption so I doubt it will work.

Certfication might be used to host some branches at once, but it couldn't host two same vsro servers - modules with same contentid.

Again good job, this is one of reasons I still believe in some people right there.

P.S. Was somebody google master there? The table structures seems soo similar.
07/27/2016 16:27 CraYu#4
Thanks this could be really useful.
And few days ago I found this on the net.
[Only registered and activated users can see links. Click Here To Register...]
Static Analysis -> Strings is the table structure from real Certification
07/27/2016 18:40 WickedNite.#5
Sweet, I'll be testing it on twsro later tonight or tomorrow and post screens.
07/27/2016 19:10 sirout1#6
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
07/30/2016 09:17 Dragonz2105#7
forgive me for silly question

- Make sure to change [SRO_VT_ACCOUNT].[_ShardService] to given ID(s) from [SRO_CERTIFICATION].[Shard] table.

in this part which id should i give to _ShardService cause i think i put all ids but launcher wont run
07/30/2016 11:53 rares495#8
Quote:
Originally Posted by Dragonz2105 View Post
forgive me for silly question

- Make sure to change [SRO_VT_ACCOUNT].[_ShardService] to given ID(s) from [SRO_CERTIFICATION].[Shard] table.

in this part which id should i give to _ShardService cause i think i put all ids but launcher wont run
For me ID is 3 and Service should be 1 :)
07/30/2016 15:25 xGyros#9
Quote:
Originally Posted by rares495 View Post
For me ID is 3 and Service should be 1 :)
On _ShardService it should be 0.
07/30/2016 18:01 rares495#10
Quote:
Originally Posted by xGyros View Post
On _ShardService it should be 0.

Well my server was on check with Service 0 and SMC didn't work even though it said operating so i changed it to 1 and then it was Easy. :)
07/30/2016 21:42 xGyros#11
Quote:
Originally Posted by rares495 View Post
Well my server was on check with Service 0 and SMC didn't work even though it said operating so i changed it to 1 and then it was Easy. :)
0 => Operating
1 => Examine
2 => Hidden

You might used wrong ShardID incase you get that.
07/31/2016 07:46 rares495#12
Quote:
Originally Posted by xGyros View Post
0 => Operating
1 => Examine
2 => Hidden

You might used wrong ShardID incase you get that.
I don't know but since i changed the Service and if affected my shard i guess i did something right :P
11/12/2016 07:32 DaxterSoul#13
- Update to 1.1.0.0

Implemented [Only registered and activated users can see links. Click Here To Register...]
03/16/2018 13:16 Genoxid#14
can u make a small tutorial to add more agents and gameserver to this cert since i cant really understand how the binding is working here and thank you for work ;)
03/29/2018 21:27 wuffles35#15
Tested for BlackRogue 100 / 110 Cap Files. Works fine.