[Guide]L2 Official Server Setup Guide for Noobs-English

[Makaveli]

Here is the best guide for an L2 Official Server Setup, i post the links for the files later, u can search all files in google the mostly u will find.

-----------------------------------------------------------------------------------------------
Requirement and Precautions:
-----------------------------------------------------------------------------------------------

Running a server require at lease a P4 1.8Ghz with at lease 512MB of ram. The server will load, but very slowly. Don't expect to be able to play on the same machine hosting the server! This is not L2j Server Emulator! So yes! You need a 2nd PC to play!

You'll also need BASIC Knowledge in networking such as knowning how to find your IP Address from your router (if you using one)! If you don't know how to setup a home/office network or understand what the hell is a IP. Then don't even bother trying to setup a server! :P Also some basic understanding of using MSSQL would help!

By following this guide, I cannot take responsibility for what goes wrong with your computer system ! This guide is ment for Users running Windows XP Professional w/ Service Pack 2 Installed along with Microsoft SQL Enterprise Manager v8.0 (SQLEVAL).

*To find your computer's IP, do a "ipconfig" in Command Prompt.

-----------------------------------------------------------------------------------------------
Getting Started
-----------------------------------------------------------------------------------------------

First off grab all the stuff you need off of Hick's post. You'll need these following files:

Server Files:

//Pick one !

Meifu's C1 Server [English]
Sina's C1 Server [Chinese]
TW's C1 Server [Taiwanese]

Support / Fix files:

//You need them all!

L2server.zip (1.81 MB)
L2ASP.zip (434.1 KB)
l2decrypt.zip (24.0 KB)
DBScript.zip (103.4 KB)
GM_commands.zip (1.2 KB)
npcdata.zip (152.6 KB)
Fixed15-10-2004html.zip (Find it!)

Other stuff:

l2cnpatch.zip
c2textures.zip
l2cnmeshes.zip


MSSQL:



Extract your Lineage2 Server (170MB+) files onto a directory. Extract L2server.zip (1.81 MB) into your Server's root directory that contains CacheD, L2LogD, L2NPC, NewAuth, etc. Overwrite all the files when prompt. Extract DBScript.zip (103.4 KB) into your Server's root directory that contains the folder DBScript and override all the files.

When installing MSSQL. Make sure you take note of the account/user login and password!! You'll need them for later. Here's a quick walkthru installation guide:

Make sure you choose "Local Computer"
Then "Creater a new instance of SQL Server, or install Client Tools" //or something similar. If you don't have this option prompt. Don't worry about it. You get this if you're installing again for the 2nd time.
Make sure you pick "Server and Client Tools" along the way in the installation process.
It'll automatically check "Default" for instance name or you can specific one. It doesn't really matter which one you pick as long as you remember the instance name.
Along the way in the installation process, make sure you pick an option that uses Both MySQL Login and Windows Login.

-----------------------------------------------------------------------------------------------
IP Configurations
-----------------------------------------------------------------------------------------------

Go to your Lineage 2 Server folder.

In each of these following folders: L2LogD, CacheD, NewAuth, PetitionD, L2NPC, and L2Server, they contain a configuration file that is either a *.ini or *.txt document. You don't need to change anything and make sure they're set at 127.0.0.1. The only time you would need to change them is if you are loading them from multiple computers! It doesn't matter if you even have a router! As long as you are loading all 6 Process from the same machine, you just need to keep most of the IP adress as 127.0.0.1.

Change the following lines in config.txt under "NewAuth\etc" folder:
DevServerIP="24.68.124.198" //Change this to your Internet IP address, your WAN, the IP that you get from your ISP. Visit to find it.
logdip="127.0.0.1" //Change this to what you used for your L2LogD.ini address.

Change the following lines in l2cache.ini under CacheD folder:
address="127.0.0.1" //Change this only if you plan to load this from a different computer! Adjust it to the ip of that computer! If PC2 has IP of 192.168.0.121 and it is planning to load L2CacheD.exe there. Then change it, otherwise leave it as 127.0.0.1!

Change the following lines in l2logd.ini under L2LogD folder:
address="127.0.0.1" //Same thing as L2CacheD.ini

Change the following lines in config.txt under PetitionD\etc folder:
webAuthServer="127.0.0.1" //Same thing as L2CacheD.ini

Change the following lines in L2NPC.ini under L2NPC folder:
//Change them accordingly to what you adjusted for them. If L2LogD.ini has ip of 192.168.0.121 on PC2. Then change that IP in L2NPC.ini to that. You are pointing L2NPC.exe to connect to the other Server Processes. Leave the ports alone!

[LogD]
address="127.0.0.1"
port=3999

[CacheD]
address="127.0.0.1"
port=2008

[server]
address="127.0.0.1"
port=2002

[map]
directory="map"

[World]
WorldId=1

[db]
address="127.0.0.1"
user="gamma" //This should be your MSSQL Login (I used sa since it sets up the sa account for you when you install SQL and sa has all permissions)
password="l2online" //This should be your MSSQL Password

[Setting]
;Country=0 KR
;Country=1 US
;Country=2 JP
;Country=3 TW
;Country=4 CN
Country=1 //Change this accordingly to what "CLIENT" version you allow to connect!
ExceptionMailing=false
MailServer=ncs-mail.ncsoft.co.kr

Change the following lines in l2server.ini under L2Server folder:
//Again, the same explaination from L2NPC.ini config applies here as well!

[LogD]
address="127.0.0.1"
port=3999

[CacheD]
address="127.0.0.1"
port=2006

[AuthD]
address="127.0.0.1"
port=2104

[petitionD]
address="127.0.0.1"
port=2107
WorldId=1 //Leave this as 1 if you don't plan to run multiple servers! WorldId = ServerId in lin2db (will be explained furtherdown). If they're not the same number, your server won't be connecting to the same gameworld or won't find one to connect to!

[Makaveli]

-----------------------------------------------------------------------------------------------
Setting up Database Scripts
-----------------------------------------------------------------------------------------------

Important! - If you are running MSSQL Server on the same machine that's hosting the server. Leave everything at 127.0.0. and 127.0.0.1!! The only time you would need to change this is if you're trying to connect to a different computer running Lineage 2 Chronicle One Server! You would then need to adjust it accordingly to that computer's IP!

Important!! #2 - If you already have an existing mysql db installed and are changing connection to connect to a different MSSQL Server (say to your friend's computer). You will need to update your MSSQL database information again. By doing this, make sure you export all your previous data! Because if you input the new IP changes, everything from the previous data will be lost! All character and account information are stored in lin2db and lin2world!

open lin2comm_new.sql under DBScript

find
set @conn_str = '127.0.0.' + @world_id + ''';''sa'';''l2online'
change 127.0.0. to the first 3 sets of numbers of your internal IP (If your internal IP is 192.168.0.121 then enter 192.168.0.)
change "sa" as your SQL database account
change "l2online" as your SQL database password
there are 3 lines you have to change

find
'SQLOLEDB', '127.0.0.1';'sa';'l2online'
change 127.0.0.1 to your internal IP
change "sa" as your SQL database account
change "l2online" as your SQL database password
there is only 1 line you have to change

save and close the file.

open lin2world_20040609_all.sql under DBScript

find
set @conn_str = '127.0.0.' + @world_id + ''';''sa'';''l2online'
change 127.0.0. to the first 3 sets of numbers of your internal IP (If your internal IP is 192.168.0.121 then enter 192.168.0.)
change "sa" as your SQL database account
change "l2online" as your SQL database password
there are 3 lines you have to change

find
'SQLOLEDB', '127.0.0.1';'sa';'l2online'
change 127.0.0.1 to your internal IP
change "sa" as your SQL database account
change "l2online" as your SQL database password
there are 2 lines you have to change

save and close the file.


-----------------------------------------------------------------------------------------------
Setting up MSSQL Database for Lineage 2
-----------------------------------------------------------------------------------------------



Make sure the SQL server is running, Open Service Manager (found in start menu) and if the start/continue button isn't greyed out click it.

Open SQL Server Enterprise Manager (start menu again), double click SQL Server Group, double click (local) the click OK. Double click on databases folder, to make a database right click and select New Database. Make the following databases: lin2world, lin2comm, lin2log, lin2report, lin2db, petition



If you used "sa" as your account you dont have to give permissions cause they already are set, if you used another account you have to make it and give permissions to the databases.

Go to the tools menu, then click SQL Query Analyser.



Change the database drop down menu on the top bar to lin2world. Then click the Load SQL Script button (Also on the top bar). Choose lin2world_20040609_all.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2comm. Then click the Load SQL Script button (Also on the top bar). Choose lin2comm_new.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2log. Then click the Load SQL Script button (Also on the top bar). Choose lin2log_20040416.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2report. Then click the Load SQL Script button (Also on the top bar). Choose lin2report_20040416.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2db. Then click the Load SQL Script button (Also on the top bar). Choose lin2db_AuthDBSchema.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2db. Then click the Load SQL Script button (Also on the top bar). Choose lin2db_update.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to petition. Then click the Load SQL Script button (Also on the top bar). Choose petition.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Close SQL Query Analyzer and open SQL Server Enterprise Manager. Under databases click lin2db then double click the tables icon. Right click on the server table go open table, then select return all rows. Add the following information:



To add information in for the example [ id = 1 ] you would put the number 1 in the id column:
id = 1
name = same as the worldname in l2server.ini
ip = your external IP
inner_ip = your internal IP
ageLimit = 0
pk_flag = 0 PK not allow; 1 allow
kind=0
port=7777

Close the SQL Server Enterprise Manager.

-----------------------------------------------------------------------------------------------
DSN Configuration
-----------------------------------------------------------------------------------------------

Open control panel, click administrative tools, then double click Data Sources (ODBC).



Choose the File DSN tab then click the add button. Select SQL Server and click next, type lin2world. Leave description blank and select (local) in the server dropdown menu then click next. Leave it on windows NT configuration and click next. Check the box next to Change Default Database to, then select the lin2world database and click next, then click finish and ok.

Click add button again. Select SQL Server and click next, type petition. Leave description blank and select (local) in the server dropdown menu then click next. Leave it on windows NT configuration and click next. Check the box next to Change Default Database to, then select the petition database and click next, then click finish and ok.

Click add button again. Select SQL Server and click next, type lin2comm. Leave description blank and select (local) in the server dropdown menu then click next. Leave it on windows NT configuration and click next. Check the box next to Change Default Database to, then select the lin2comm database and click next, then click finish and ok.

Click add button again. Select SQL Server and click next, type lin2log. Leave description blank and select (local) in the server dropdown menu then click next. Leave it on windows NT configuration and click next. Check the box next to Change Default Database to, then select the lin2log database and click next, then click finish and ok.

Click add button again. Select SQL Server and click next, type lin2report. Leave description blank and select (local) in the server dropdown menu then click next. Leave it on windows NT configuration and click next. Check the box next to Change Default Database to, then select the lin2report database and click next, then click finish and ok.

Click add button again. Select SQL Server and click next, type lin2db. Leave description blank and select (local) in the server dropdown menu then click next. Leave it on windows NT configuration and click next. Check the box next to Change Default Database to, then select the lin2db database and click next, then click finish and ok.

-----------------------------------------------------------------------------------------------
System INI Configuration
-----------------------------------------------------------------------------------------------

Go to your control panel (from start menu) then click the system icon, advanced tab, under performance click settings, then choose the advanced tab again and click the change button under virtual memory. Set Custom size with minimum set at 1024 and maximum set at 4096

You must do this to run all the NPC's.

Locate your boot.ini file in C:\ Drive. You'll need to change folder view setting to include hidden and system files or else you won't be able to find it.

Open C:\Boot.ini in notepad, the last line should look like:

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS=" Microsoft Windows XP Professional" /nodetect

or something similar, add the /3GB tag at the end. It should look like this (if your line was the same as the line above)

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS=" Microsoft Windows XP Professional" /nodetect /3GB

Reboot your computer

[Makaveli]

-----------------------------------------------------------------------------------------------
ASP Account Registeration System
-----------------------------------------------------------------------------------------------

Extract L2Asp.zip to your C:\Inetpub\wwwroot (or wherever you have as your IIS root directory, this is default)

If you don't have Internet Information Services installed. Then you'll need to find your Windows XP Pro CD. Go to Add/Remove Program and select "Add/Remove Windows Components" -Select Internet Information Services from the list and install it.

Open the conn.asp (from the directory that you just extracted to) with notepad and change the following:
ms_sql_server_host_addr = "127.0.0.1" //This should be set to your WAN IP. Leave it as 127.0.0.1 if you want to just manually make accounts on your computer for your friends.
sql_server_username = "sa"
sql_server_password = "l2online"
save and close the file.

Open control panel, click administrative tools, then double click Internet Information Services. Click on local computer then click websites. Right click default websites and go properties. Click on the documents tab and then the add button. Under default document name type index.asp then press OK. Select index.asp and use the up arrow to move it to the top of the list then press OK.



Close IIS and open internet explorer and type (where 127.0.0.1 is your internal IP)
Once the website comes up click register. Then enter a username and a password and click next.

You have now made an account on your server.


-----------------------------------------------------------------------------------------------
Client Setup
-----------------------------------------------------------------------------------------------
Install your Lineage 2 Chronicle ONE Client (either download it or off a CD). Chronicle 2 Client will NOT WORK on C1 Private Server!
If you want things to be in english, install the US client and unzip l2cnpatch.zip, c2textures and l2cnmeshes.zip to your /System/ directory.

Unzip Fixed15-10-2004html.zip to your server directory (\L2server\html&#092 and overwrite all the files.

Extract l2decrypt.zip to your computer (doesnt matter where). Run the decrypter and decrypt the L2.ini file. Then open up L2.ini file with notepad.

"L2.ini"

MapExt=unr
EXEName=l2.exe
SaveExt=usa
Port=7777
Class=LineageWarrior.MFighter
ServerAddr=69.105.31.9 //Change it to your WAN IP
IsL2NetLogin=True
IsL2Console=True
IsL2Seamless=True
IsL2Projector=True

Change the IP to your WAN IP. The IP that's the same as NewAuth and the one in MsSql Lin2db Server entry.

Re-encrypt the file with v212 or v211 setting. Copy it to your Client's /System/ Folder and override the L2.ini file there. When you start up your client. Make sure you are using the L2.exe from the /System/ Folder and not the Lineage2.exe in /Lineage 2/ Folder


-----------------------------------------------------------------------------------------------
Running the Server
-----------------------------------------------------------------------------------------------

Open the files in the following order.

L2LogD.exe

File DB = lin2log
login name = your SQL account
password = your SQL password

CacheD.exe

File DB = lin2world
login name = your SQL account
password = your SQL password

L2AuthD.exe

File DSN = lin2db
login name = your SQL account
password = your SQL password

PetitionD.exe

Server = (local) //or the name of the server for your MySQL Server Agent
login name = your SQL account
password = your SQL password
Database = petition

L2Server.exe

L2NPC.exe

Congrats with setting up your server!

If you want to free up some system resources. You can shutdown Petition Server once everything is fully loaded. Some people claim L2LogD Server is also not require to run. You can try shutting it down, but I don't recommend it, since CacheD, L2AuthD, L2Server, and L2NPC requires it when loading. L2Server.exe must be running on the same machine with L2NPC.exe! You cannot load them on seperate computers for some stupid reason!

-----------------------------------------------------------------------------------------------
Setting up Administration Account / GM Characters
-----------------------------------------------------------------------------------------------

For this to work you must have created an user account.

Open SQL Server Enterprise Manager (start menu again), double click SQL Server Group, double click on your local server then click OK. Double click on databases folder and select lin2db. Click on tables then find user_account, right click on it and select Open Table then Return All Rows. Note the name and uid of the account that you want to make a gm.

Go back to databases and this time select lin2world. Click tables and select builder_account, right click select Open table then Return All Rows. Under account name enter the name of your character (that you noted before in user_account) and under default builder enter 1 and under account_id enter the uid you noted from user_account.

When you make a new character on this account it will have GM powers, the commands are located in script/BuilderCmdAlias.txt and are used //command so to disable invisible mode you would type in: //hide off

To give a current character GM powers, Go back to databases and select lin2world. Click tables and select user_data, right click select Open table then Return All Rows. All the character on the server will be listed, you can just change the builder value from 0 to 9 for any character you want to give GM powers.

-----------------------------------------------------------------------------------------------
Editing the Server / Gameplay Properties
-----------------------------------------------------------------------------------------------

All the things you can edit are in the /scripts folder.
For EXP/SP/Adena rates and drops you can edit: npcdata.txt
For GM Commands you can edit: BuilderCmdAlias.txt
For Item stats you can edit: Itemdata.txt
For Blacksmith sell lists you can edit: multisell.txt
For NPC spawn locations you can edit: npcpos.txt
For Recipe information you can edit: recipe.txt
For Teleporters and store you can edit: ai.obj

Before you begin editting anything. A rule of thumb is ALWAYS BACK UP YOUR FILES.


--End Guide.

[Makaveli]

And Here are all links for the files u need

Server files:
//Pick One
LineageII_meifu_server_C1.zip (177.06 MB)
Lineage2ServerCHS.rar (173.80 MB)
LineageII_tw_server_C1.rar (110.25 MB)

Support / Fix Files:
//u need them all
L2server.zip (1.80 MB)
L2ASP.zip (434.06 KB)
l2decrypt.zip (23.98 KB)
DBScript.zip (103.37 KB)
GM_commands.zip (1.18 KB)
npcdata.zip (152.59 KB)
Fixed15-10-2004html.zip (3.86 MB)

Misc Files:
l2cnpatch.rar (1.96 MB)
l2cnmeshes.rar (164.92 KB)

And here is the tool u need to change the rates of your server
NpcdataControl.zip (259.92 KB)

And here is a little guide for the NpcdataControl rates changer:

The npcdata.txt is located in your l2server/script folder.

1. Right click on npcdata.txt > Open With > Notepad (DONT USE WORDPAD FOR THIS ONE) > File > Save As > And in Encoding choose ANSI > Save

2. PUT NpcdataControl.exe in the same place as the npcdata.txt

3. RUN NpcdataControl.exe choose the rates you want

4. In case your wondering this is the order of the rates in npcdatacontrol

1 - drop
2 - spoil
3 - adena
4 - XP
5 - SP

5. Click in the first button from top to bottom to generate the rates

6. NOW, IF YOU GET A "IS NOT A VALID FLOAT POINT ERROR" do this, go to Control Panel > Regional and Language Settings > Change it to English US. Then do step 5 again.

7. There will be a new file named exXspXadenaXetc.txt. Open that file with WORDPAD. File > Save as > Save as type > Unicode

8. Rename the file back to npcdata.txt replace with the old one and VOILA you have the new rates.

---END

[hoduken]

im gettin this error when i try to get to the registration site do you know what the problem is?

thanks for the post by the way its ben a great help!

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'brooklynn'.
/conn.asp, line 48

[Makaveli]

yeah i had the same error with the asp registration page, u must edit it to the correct sql login in conn.asp.

here is an example of my sql login in conn.asp and it works, i use the windows authentication mode:
'---------------------------------------------------------------------------
'-------------------------------Change below--------------------------------

'MS SQL Database address
ms_sql_server_host_addr = "MAKAVELI\MAKAVELITHADON" (MAKAVELI is my Computer name and MAKAVELITHADON is the windows authentication login name of my windows xp account )

'MS SQL account
sql_server_username = ""

'MS SQL password
sql_server_password = ""

'Lin2db database(user_auth)
lin2db = "lin2db"

'Lin2world database(user_data)
lin2world = "lin2world"

be sure your SQL Server Service Manager is still runnin

[x]vIrus[x]

hab echt gedacht bei so einer anleitung gibts keine probleme mehr ^^

[Makaveli]

dürfte auch keine probleme geben, aber das problem mit der ASP (Account Registration Page) hat fast jeder weil man da immer schauen muss was man in der conn.asp für anmelde daten eintragen muss, hab da auch nen weng rumgemacht

[x]vIrus[x]

aber steht ja in der tut dass mans machn muss

[Makaveli]

geht auch ohne asp aber dan musste die ppl selber in die database registrieren und bei mehr ppl is das ne hammer arbeit

@hoduken
what is the name of your Server in the SQL Server Service Manager?

[Makaveli]

and here i have the important and most used commands

target your charakter or an other charakter to change the lvl and Sp:
//setparam level 1-75
//setparam SP 0-999999....

to change your class try this:
//setclass <number>

0=>"Fighter",1=>"Warrior",2=>"Gladiator",3=>"Warlo rd",
4=>"Knight",5=>"Paladin",6=>"Dark_avenger",7=>"Rog ue",
8=>"Treasure_hunter",9=>"Hawkeye",10=>"Mage",11=>" Wizard",
12=>"Sorcerer",13=>"Necromancer",14=>"Warlock",15= >"Cleric",
16=>"Bishop",17=>"Prophet",18=>"Elven_fighter",19= >"Elven_knight",
20=>"Temple_knight",21=>"Swordsinger",22=>"Elven_s cout",23=>"Plains_walker",
24=>"Silver_ranger",25=>"Elven_mage",26=>" Elven_wizard",27=>" Spellsinger",
28=>"Elemental_summoner ",29=>"Oracle",30=>"Elder",31=>"Dark_fighter",
32=>"Palus_knight",33=>"Shillien_knight",34=>"Blad edancer",35=>"Assasin",
36=>" Abyss_walker",37=>"Phantom_ranger",38=>"Dark_mage" ,39=>"Dark_wizard",
40=>"Spellhowler",41=>"Phantom_summoner",42=>"Shil lien_oracle",43=>"Shilien_elder",
44=>"Orc_fighter",45=>"Orc_raider",46=>"Destroyer" ,47=>"Orc_monk",
48=>"Tyrant",49=>"Orc_mage",50=>"Orc_shaman",51=>" Overlord",
52=>"Warcryer",53=>"Dwarven_fighter",54=>"Scavenge r",55=>"Bounty_hunter",
56=>"Artisan", 57=> "Warsmith"

to summon any items search in the itemdata.txt for the itemid, to summon any monsters look in the npcdata.txt for the name or id:
//summon <itemid> <item count> (use itemcount only with countet items like ss, arrows etc.)
//summon <MonsterName or MonsterId>

announcement commands:
//setannounce 1-10 <here your text> (1-10 is the order)
//announce (is usefully when u would announce the server restart or other important things)

and here some teleport commands:
//home (return to starter town)
//teleportto <charakter name>
//teleport x y [z] (type here the correct location parameters)
//recall <playername> (teleports an player to you)

u have a little in game menu, to open it press "alt+g" but u can only check your players in this menu, nothing else

ok i think that was all of the important commands

[Pepperutzu]

links not working

[Makaveli]

yes i know, sry the guy is changing their ftp again

[Pepperutzu]

ok np. by the way i'm new around here glad this project is alive

[chaosfinity]

Whats the status on the FTP's? All i really need is the english ASP registration if someone could put a link to one or something ty