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

Quote:

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

Quote:

Originally Posted by isk0rpitx Easy to fix only need to use LegendaryDev certification / ini file's.

Quote:

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 ;)

Quote:

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)

Quote:

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 [Only registered and activated users can see links. Click Here To Register...]

Quote:

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

Quote:

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 [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by abdelfattah MachineManager Patch : [Only registered and activated users can see links. Click Here To Register...] Download patch and replace with old files then edit ur info (db info , ip , etc..) and now MachineManager works fine ;)

Quote:

Originally Posted by abdelfattah MachineManager Patch : [Only registered and activated users can see links. Click Here To Register...] 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 ..