Chronicle Server Setup Simplified

Lineage 2 Chronicle Server Guide:
(Honestly It was very hard for me to get this all setup, so I will post a guide on how I did it)

*By following this guide I have my server up with all textures/quests and options of the actualy Lineage 2 server and it runs fine even on my computer with 512mb or RAM!

*Also this guide is my way of following hicks guide posted above, most of the work was done by him, im just recording what I am doing step by step to follow his guide as best I can


Requirements:

Windows XP SP2 (SP1 WILL NOT WORK BECAUSE OF BOOT.INI ISSUES)
Microsoft SQL Server (I Used 2000 Developer version, DO NOT get Enterprise edition as it only works on Windows NT)


Files: (Almost all these can be downloaded with links from hicks post)

Lineage 2 Chronicle Client (Buy the game or download: ftp://l2clientdownload.lineage2.com/...2installer.zip, open the game at let it update to get chronicle 1)
L2Server.rar (173 MB)
L2server.zip (1.81 MB)
L2ASP.zip (434.1 KB)
l2j-tools.zip (21.7 KB) *THIS FILE IS FROM L2J SERVER, GOOGLE IT :)
DBScript.zip (103.4 KB)
Fixed15-10-2004html.zip (3.86 MB) *This file was posted on Ragezone forums
l2cnmeshes.zip (164 KB) *This file was posted by hicks on forum
l2cnpatch.zip (1.96 MB) *This file was posted by hicks on forum
c2Textures.zip (268 MB) *Google C2 Texture or check forum


<<Pre-Config Section>>

Extract L2Server.rar to a directory on your computer
Extract L2Server.zip to the CHN_Server_20040604 directory, when asked to overwrite click yes
Extract DBScript.zip to the DBScript directory, when asked to overwrite click yes

<<Changing INI Files>>

*If you dont have a router replace 192.168.0.100 with 127.0.0.1 in the lines below, if you do have a router replace 192.168.0.100 with your internal IP, to get your internal IP go: Start->Run->cmd.exe then type ipconfig, the IP Address listed is your internal IP.

*If you are playing on the internet replace 24.68.124.198 with your external IP address, to get this go to http://www.whatismyip.com (and forward the appropriate ports if you have a router/firewall so people can access)

*If you are playing on a LAN network just use your internal IP as your external IP so only people from your network can connect



Change the following lines in config.txt under NewAuth\etc folder:
DevServerIP="24.68.124.198"
logdip="192.168.0.100"

Change the following lines in l2cache.ini under CacheD folder:
address="192.168.0.100"

Change the following lines in l2logd.ini under L2LogD folder:
address=192.168.0.100

Change the following lines in L2NPC.ini under L2NPC folder:
address="192.168.0.100"
address="192.168.0.100"
address="192.168.0.100"
address="192.168.0.100"
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

Change the following lines in l2server.ini under L2Server folder:
address="192.168.0.100"
address="192.168.0.100"
address="192.168.0.100"
address="192.168.0.100"
WorldId=1 *This should be the digits of your internal IP after the last . (In my case WorldId=100)

Change the following lines in config.txt under PetitionD\etc folder:
webAuthServer="192.168.0.100"


<<Setting up Database Scripts>>

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.100 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.100 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 Databases>>

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 (I just used the sa account)

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:
(too 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.


**Continued in Next Post**

<<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.


<<Edit System INI's>>

Go to your control panel (from start menu) then click the system icon, advanced tab, under performance click settings, then choose the advanced tab agin 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, dont attempt to edit your boot.ini on Windows XP SP1 (Trust me I know), update to SP2 before proceeding.

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


<<ASP Account Register System>>

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

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 internal IP
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 http://127.0.0.1 (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 client (either downloaded or off a CD) make sure you are updated to Chronicle 1 (either using update server or a patch)
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\) and overwrite all the files.

Extract l2j-tools.zip to your computer (doesnt matter where). Run updateIni.bat, when asked type in the location of your lineage client install do so, then press enter. You will be asked for your lineage login server address. If you are running this on your computer you can use your internal IP address, otherwise (if your sending to other people etc) use your external IP address. Press enter and your client will be set to connect to your private server.


<<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)
login name = your SQL account
password = your SQL password
Database = petition

L2Server.exe

L2NPC.exe

Congrats with setting up your server!


<<Setup Admin>>

For this to work you must have logged into the server with your character before.
Open SQL Server Enterprise Manager (start menu again), double click SQL Server Group, double click (local) the 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 character 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 enable invisible mode you would type in: //hide on

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 1 for any character you want to give GM powers.


<<Editing the Server>>

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

;) Great guide!

i run it on Xp SP1.. no problem :P
just make XP view all hidden files.. and there it is :)

l2j tools can be found http://l2j.sourceforge.net/nightly/

nice guide thou i like hicks better.. more details :)

nice guide helped me alot simular to other but not so in ya face
dont suppose u or anyone can help with the gm set up? in a english sorta way of explain it

my boot.ini won't save it says theres already a file named as that

yes right click it and take tick away from the readonly box . then it allow u to overwrite it.
make sure when u have over written it u put tick back to readonly then reboot pc

Nice Guide...PIN pls...

kev..
1. open the database "lin2world" in MS SQL.
2. find the table "user_data".
Remember your "ID" and change "builder" to 1
3. find the table "builder_account" in the same database.
Change "defualt_builder" to 1 and "account_id" to your "ID"!

it can't be explained more easy! :P
if you want more GMs there's a command ingame to make players GM :D

Anyone able to link to Microsoft SQL Server 2000 Dev and SQL Server Enterprise Manager
also the Fixed15-10-2004html.zip

please ;)

Microsoft SQL Server 2000 SQL Server Enterprise manager
http://download.microsoft.com/downlo...73/SQLEVAL.exe

For the fix go make a search on "fixed" for this forum... its there ;)

Props to you very nice.

Nice work.

But I can't seem to find boot.ini

and yes I'm using sp2

Look...i did all in the guide but when i try load L2AuthD.exe i get error ... and then msg the server ready on port... and when i load L2server.exe when it get to file Pathnode.bin in geodata it just give me error and quit server...same when i go to L2NPC.exe i just get C++ Error .
Can you help me?

ok, i followed guide exactly, everything is setup. time to run all the exe's

http://www.paradiss.com/l2server.jpg


I load L2logd, Cached, L2AuthD, PetitionD, then when i load L2 Server, no window pops up. computer slows down a hell of alot. is a window supposed to pop up? same with l2npc

Anyone know?