[Guide] Setting up a server based on VSRO server files

[Darkness™]

Originally Posted by octage

fo that use this:

GO
/****** Object: Table [dbo].[_PrivilegedIP] Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_PrivilegedIP](
[IP1] [tinyint] NOT NULL,
[IP2] [tinyint] NOT NULL,
[IP3] [tinyint] NOT NULL,
[IP4] [tinyint] NOT NULL,
[IP5] [tinyint] NOT NULL,
[IP6] [tinyint] NOT NULL,
[IP7] [tinyint] NOT NULL,
[IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO

first delete the dbo._P¨rivilegedIP, and then run the query

Originally Posted by isk0rpitx

Easy to fix only need to use LegendaryDev certification / ini file's.

i can't use those ini's.

when i run them crash.

(already edited ips,odbc,db)

[amar14]

Originally Posted by abdelfattah

So, let's start. Save all that files in a some folder on your hard disk, and extract them.

After you are done with setting up a mssql server, and restoring databases (i consider, database names will be SRO_VT_ACCOUNT, SRO_VT_SHARD, SRO_VT_SHARDLOG), you have to
create 3 ODBC sources (you can name then however you want, but i preffer to call them the same way as databases). Specify "SQL Server" as ODBC driver. Default language must be
English for all databases.
Also, you have to set ODBC default database names this way :

SRO_VT_ACCOUNT -> SRO_VT_ACCOUNT
SRO_VT_SHARD -> SRO_VT_SHARD
SRO_VT_SHARDLOG -> SRO_VT_SHARDLOG

It's pretty simple and understandable, because i use the same database names as ODBC.

Don't forget to edit _ShardService table, and change Shard ID to 64 in SRO_VT_ACCOUNT database.

After you are done with ODBC, you must configure your custom certification server to work with your database server. Just run 1 - Decompile file in it's folder,
it will decompile current packt.dat file, and save .ini files at "ini" folder. Open it, and you will see few files, which you have to replace with those
which you downloaded in another archive (from LegendaryDev). After you are done, open your "srGlobalService.ini", and configure it to work with your database
server. Don't forget, by default, mssql 2005 and 2008 does not bind on port 1433, they uses ODBC. So, you shouldn't put ",1433" after your server hostname (which
should look like "PC_NAME\SQLEXPRESS", or just "PC_NAME". Do same for "srShard.ini" file (also, you can edit some shard configuration there, like capacity).
Do not make server capacity more than 1000 for now (i will tell why a bit later). Then you will have to change the ip addresses for binding certification server. For
this, open srNoteType.ini, and change "wip" to your WAN ip, and "nip" to your local ip. After you are done with your common certification configs, run "2 - Compile.bat" file in order
to make a new "packt.dat" file (new one will be named "new_packt.dat"). After you are done with it, start third batch file ("3 - CustomCertificationServer.bat")



Have a Good Time

can you make some picture with these steps?
cause i have the most difficult with this.

[isk0rpitx]

Originally Posted by Darkness™

first delete the dbo._P¨rivilegedIP, and then run the query




i can't use those ini's.

when i run them crash.

(already edited ips,odbc,db)

Because if you use the LegendaryDev certification you need to use other server.cfg as the basic because the port is changed, use this ini / server.cfg

[Makaveli[ILS]]

can you explain odbc a little bit more?
or what is wrong?

[octage]

Originally Posted by isk0rpitx

Because if you use the LegendaryDev certification you need to use other server.cfg as the basic because the port is changed, use this ini / server.cfg

not working.... when i open certification it says (Error: Could not locate "Certification Manager" node type)

[the_belgian]

Don't forget to edit _ShardService table, and change Shard ID to 64 in SRO_VT_ACCOUNT database.

That mean you have to change Shard_id column name to 64 or to put in property "default value or biding = 64"?

[18andLife]

Originally Posted by isk0rpitx

Because if you use the LegendaryDev certification you need to use other server.cfg as the basic because the port is changed, use this ini / server.cfg

LegandaryDev's and cezaland's inis doesn't work.
Could not locate a "Certificate Manager" node. error

[amar14]

How do you make SRO_VT_ACCOUNT connect with msql?

[Dr.Abdelfattah]

MachineManager Patch :


Download patch and replace with old files then edit ur info (db info , ip , etc..)
and now MachineManager works fine

Srry redownload again i change something ..

[omier44]

How do i restore databases? I suck at SQL. -.-

[the_belgian]

abdel, do you have a way to fixe that?

[18andLife]

Originally Posted by abdelfattah

MachineManager Patch :


Download patch and replace with old files then edit ur info (db info , ip , etc..)
and now MachineManager works fine

ini's aren't correct certification manager not found

[octage]

Originally Posted by abdelfattah

MachineManager Patch :


Download patch and replace with old files then edit ur info (db info , ip , etc..)
and now MachineManager works fine

Srry redownload again i change something ..

redownload what the atach or the link )?


well nvm... i downloaded the link and the machinemanager worked :P... the problem now is that when i open smc and load plugins nomething happend ****.... and 1more thing..... Gatewayserver+AgentServer+SR_GameServer+SR_ShardMa nager are grey (by grey i mean no blue like the others lolz) funny thing all worked before i included this machine manager, iven smc && start server etc... ANY SOLUTIONS?

[jVardin]

any1 give me new port?

[Dr.Abdelfattah]

give me mint i will give the new port for smc