How to build a Lineage 2 private server

[VainSlay]

  Hello. In this tutorial I'll be explaining how to build a Lineage 2 private server. This applies to C4, C5 and Interlude "official" servers, afterall all the C5 and Interlude servers are mere C4 PTS servers with extenders, given the fact C5 and Interlude official files were never leaked.

 

 

1. The basics:

The first thing you have to understand is that Lineage 2 OFF servers consume a shitload of resources and if you are opening a serious server, it sure will cost you an average amount of money. So from own experience, I can suggest these pre-requisites for required and recommended specs.

 

Required:Athlon 64 4200+ Processor

4GB RAM

200GB HDD

10mbit dedicated connection

Windows 2003 x64 Server OS

 

Recommended: Dual Intel Xeon 2.8ghz

8GB or 16GB RAM

2x or 3x 200GB 10k+ RPM HDDs.

100mbit dedicated connection

Windows 2003 x64 Server OS

 

ATTENTION:Make sure the operating system is a 64-bits system, since L2Server won't work in a 32-bits system.

 

With the "Required" specs you'll be able to get about 300 ~ 500 players with no lag. Anything above that will cause unwanted lag.

With the "Recommended" specs you'll be able to get about 1000 ~ 1500 players with 8GB RAM and with 16GB RAM it should take on 2000 ~ 3000 players without major problems.

 

2. Understanding the server: Before I start explaining furthermore, first you'll need to understand how the server works.

Lineage 2 OFF servers database system is SQL. All kinds of information about characters, accounts etc. are stored in the SQL database. Therefore, you'll need MSSQL, which can be downloaded below.

 

There's something else you also need to know. Lineage 2 OFF servers basically consist of the following:

 

AuthD (Login Server)

CacheD (Acts like a bridge between L2Server.exe and SQL)

L2Server.exe (Game Server)

L2NPC.exe (Loads all NPCs in the Game Server)

 

Besides that, there are several folders with all several types of files.

The most important folders, that means... Those you will be dealing with all the time to edit items, NPCs, skills, terrain issues, quests and so on are the following:

 

Script

HTML

Geodata

 

3. Server files: Alright, so you already got your server?

 

That's great. Now we need to get some files.

 

You'll need to download the following files:

 

1. Server Files

2. MSSQL server

[/url] 3. CacheD Serial Generator

 

4.1. Configuring the Database: 1. Install MSSQL server to any folder of your choice. It's a very basic installation, you'll mainly just choose "Yes" all the time. When it asks you for what kind of installation, choose "Complete". This should avoid any problems in the future. When it asks for what user to choose, leave it as "sa" and choose whatever password you wish.

 

2. Once it's finished installing, go on start menu and look for the SQL Server Management Studio. Open it. It should prompt a connection window. If the connection name isn't "localhost", type it down there and click on "Connect"

 

3. Click on "New Query", then go to your PPC Release folder and look for a folder named DBScript. Open the file "0_create-db.sql" with notepad then copy and paste all content to the New Query window, right click and press "Execute Query". You can also simply click 0_create-db.sql twice and it'll automatically perform the query. After you've done that, all databases and tables should be created. (lin2world, lin2db etc.)

 

4. Close the New Query window. Look at the left side for "Databases". Open it, then go to lin2db > tables. Right click on dbo.server and choose "Open Table". Now you'll configure the server settings in this table.

 

 

 

ID: 1 (2, 3, 4 and so on for more servers)

Name: Pick a 11 characters (no more, no less) name.

IP: Insert the WAN IP here. (To get your WAN IP, click here)

inner_ip: Insert your localhost (127.0.0.1) IP here.

ageLimit: 0

pk_flag: 1

kind: 0

port: 7777

region: 0 (1, 2, 3 and so on for more servers)

 

4.2. Configuring the OBDC: This should be piece of cake. You'll have to configure your OBDC in order for this to function correctly.

1. Go on Start > Administrative Tools > Data Sources (OBDC):

 

2. Go to "File DSN" tab and click on "Set Directory":

 

3. Write the adress that appears in this window somewhere for your own records and then press "Yes" to set that directory as default for OBDC file DSNs:

P.S: It usually is always the same: 'C:\Program Files\Common Files\OBDC\Data Sources'

 

4. Go to that place in your computer, and create two file DSNs:

 

lin2world.dsn

lin2db.dsn

 

After you do that, open the DSNs with notepad and insert this:

 

 

lin2world.dsn:

[ODBC]

DRIVER=SQL Server

UID=sa

DATABASE=lin2world

WSID=host_name

APP=Microsoft Data Access Components

Trusted_Connection=Yes

SERVER=host_name

lin2db.dsn:

[ODBC]

DRIVER=SQL Server

UID=sa

DATABASE=lin2db

WSID=host_name

APP=Microsoft Data Access Components

Trusted_Connection=Yes

SERVER=host_name

If you're going to use other tables such as l2comm and so on, simply make more DSN files with respective names and alter the DATABASE line.

As you can see in WSID and SERVER lines you'll have to replace host_name with your actual computer Host Name, which can be found by performing ipconfig /all.

 

5. Go back to Start > Administrative Tools > Data Sources (OBDC), then go to "File DSN" tab. The DSNs you've just created should be listed there. If they still do not list up, click on "Add", choose "SQL Server", browse the DSNs where they are located and press OK.

 

Congratulations, you've successfully configured your OBDC!

[`NeverMore]

Topic cleaned!

@VainSlay try to edit your topic and use [ code ] or [ quote ] where is needed ;)