-[Mu-DownLoaDs]- ~ View topic

Admin Joined: 05 Jun 2006 Posts: 37 Location: Vilnius

The NEW Lineage II chronicle server setup guide - 09-25-2004

--------------------------------------------------------------------------------

Download your chronicle server files here(English Server)

FIXES:
http://forum.ragezone.com/attachments/9457-dbscript.zip?d=1096230948
http://forum.ragezone.com/attachments/9459-gm_commands.zip?d=1096232286
http://forum.ragezone.com/attachments/9838-npcdata.zip?d=1097082950
http://forum.ragezone.com/attachments/9416-l2asp.zip?d=1096173380
http://forum.ragezone.com/attachments/9395-l2decrypt.zip?d=1096140853

Backup ur data and unzip the fixes and overwrite into your server files folder!!
AND READ THE WORDS IN PALE GREEN COLOR

ok, here we go

################################################## ##

Part 1 - changing INI's (base on my fixes)
!!!IF YOU DONT HAVE THING LIKE ROUTER THEN LEAVE 127.0.0.1 THERE, BUT
DevServerIP="213.107.107.18" HAVE TO BE YOUR WAN IP!!!

-------------------------------------------------------------------------------------

edit config.txt under NewAuthetc folder

serverPort=2104
serverExPort=2106
serverIntPort=2108
worldport=7777
DBConnectionNum=10
encrypt=true
numServerThread=2
numServerExThread=2
numServerIntThread=2
logDirectory="log"
;30810 : l2, 30310 : Sl
ProtocolVersion=30810
;8:lineage2, 4 halo
GameID=8
DesApply=false
PacketSizeType=3
ReadLocalServerList=false
OneTimeLogOut=true
CountryCode=2
DevConnectOuter=true
;change it as your WAN IP
DevServerIP="213.107.107.18"
;SocketTimeOut if player no Action while they in game then kick out.
SocketTimeOut=10
SocketLimit=5000
AcceptCallNum=1
UseOneIOCom=true
AcceptThread=1
WaitingUserLimit=100
dumppacket=false
UserData=false
UseLogD=false
;change it as your LAN IP
logdip="127.0.0.1"
logdport=3999
logdconnectinterval=120
;(true=auth-main reconnect on/false=auth-main reconnect off)
SupportReconnect=false
AutokickAccount=true
NewEncrypt=false

-------------------------------------------------------------------------------------

edit l2cache.ini under CacheD folder

[LogD]
;change it as your LAN IP
address="127.0.0.1"
port=3999

[Setting]
;Country=0 KR
;Country=1 US
;Country=2 JP
;Country=3 TW
;Country=4 CN
Country=4
ExceptionMailing=false
MailServer=mail.ncsoft.co.kr

[World]
WorldId=1
Pair=0

[ItemAudit]
DefaultPriceLimit=100000000
DefaultPriceCheck=50000000
ChgRatioLimit=30
AdenaLimit=100000000
AdenaCheck=50000000
AdenaChgRatioLimit=30

[SQL]
SQLExecLimit=9000
;clear unowned item data[0:false, 1:true]
ItemClearOnStart=0
DiffBBSConn=0
SaveQsData=0
BBSDBTimeOut=60
USEBBS=0

-------------------------------------------------------------------------------------

edit l2logd.ini under L2LogD folder

[LogD]
;change it as your LAN IP
address=127.0.0.1
port=3999
sendable=true

[LogTable]
Daily=1
BCPFolder=1

[Start]
BCPInt=3600000
ServerInt=3600000
AutoBCP=0

[World]
WorldId=1

[SQL]
SQLExecLimit=5000
PollingInterval=6000
BCPThreadCount=5

[Setting]
;Country=0 KR
;Country=1 US
;Country=2 JP
;Country=3 TW
;Country=4 CN
country=4
ExceptionMailing=false
MailServer=ncs-mail.ncsoft.co.kr

-------------------------------------------------------------------------------------

eidt L2NPC.ini under L2NPC folder

[LogD]
;change it as your LAN IP
address="127.0.0.1"
port=3999

[CacheD]
;change it as your LAN IP
address="127.0.0.1"
port=2008

[server]
;change it as your LAN IP
address="127.0.0.1"
port=2002

[map]
directory="map"

[World]
WorldId=1

[db]
;change it as your LAN IP
address="127.0.0.1"
port=2005
;your SQL database account
user="gamma"
;your SQL database password
password="l2online"

[Setting]
;Country=0 KR
;Country=1 US
;Country=2 JP
;Country=3 TW
;Country=4 CN
Country=4
ExceptionMailing=false
MailServer=ncs-mail.ncsoft.co.kr

-------------------------------------------------------------------------------------

edit l2server.ini under L2Server folder

[LogD]
;change it as your LAN IP
address="127.0.0.1"
port=3999

[CacheD]
;change it as your LAN IP
address="127.0.0.1"
port=2006

[AuthD]
;change it as your LAN IP
address="127.0.0.1"
port=2104

[petitionD]
;change it as your LAN IP
address="127.0.0.1"
port=2107
;change the name whatever u like
worldname="Lineage2"

[World]
WorldId=1
UserLimit=2000
LetBuilder=0

[Report]
;minute
Interval=60

[Setting]
;Country=0 KR
;Country=1 US
;Country=2 JP
;Country=3 TW
;Country=4 CN
Country=4
UserPathFind=false
WorldCollision=false
ExceptionMailing=false
MailServer=mail.ncsoft.co.kr
AcceptLowerProtocol=true
;you might need to change here, but leave it unless you got crash when u run L2Server.exe
IOBufferCount=3000
;limit hour for week, (number means hour. 0 means don't use. default is 0)
playtimelimit=0
;use auth reconn (1:use, 0:don't. default is 0)
;have to be 0, if dont, u can't login
reconnectauth=0

-------------------------------------------------------------------------------------

edit config.txt under PetitionDetc folder

;Number of threads working for transaction and service socket.
numberOfServiceThreads=10

;Port number for world server
worldPort=2107

;Port number for petition client
servicePort=2109

;Run as test mode
runMode=0

;WebAuthD address
;change it as your LAN IP
webAuthServer="127.0.0.1"

;WebAuthD port
webAuthPort=2108

; Number of WebAuthD connections
numberOfWebAuthConnections=0

;Log directory
logDirectory="log"

;status refresh interval(seconds)
statusRefresh=1

;Number of connections to petition database
numberOfPetitionDBConnections=12

;petition database connection string
;number of games to support, should be consistent with game_title table
numberGames=2
petitionDatabase = "0xF6DBBAA8A7C57B6F418E95A7CFCBB4DAF09B9A5E39B2FCA 717A7EA9C44E98FCDA34297C97542494D9977C5E9ED58FBE58 14852F7D8DAF11478AFEB5861F5572B4A2A7FE96453BBF6A3E 4445310F58A15FB3FA2D8D26BA61F2D6E0113053A1A6D3FF2B BDE07E242E5E29593F12D148CD1284ED2D17E6FE16FE96034D 3B4C21363"

-------------------------------------------------------------------------------------

Part 1 - END

################################################## ##

################################################## ##

Part 2 - SQL database's (base on my fixes)
!!!IF YOU DONT HAVE THING LIKE ROUTER THEN LEAVE 127.0.0.1 THERE!!!
!!!ALSO READ _drunk_ 's REPLY BELOW ABOUT THE world_id!!!

-------------------------------------------------------------------------------------

edit lin2comm_new.sql under DBScript

find
set @conn_str = '127.0.0.' + @world_id + ''';''gamma'';''l2online'
change 127.0.0. as your LAN IP
change gamma 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';'gamma';'l2online'
change 127.0.0.1 as your LAN IP
change gamma as your SQL database account
change l2online as your SQL database password
there is only 1 line you have to change

-------------------------------------------------------------------------------------

edit lin2world_20040609_all.sql under DBScript

find
set @conn_str = '127.0.0.' + @world_id + ''';''gamma'';''l2online'
change 127.0.0. as your LAN IP
change gamma 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';'gamma';'l2online'
change 127.0.0.1 as your LAN IP
change gamma as your SQL database account
change l2online as your SQL database password
there are 2 lines you have to change

-------------------------------------------------------------------------------------

MS-SQL config

HERE IS COPY FROM Zelda803's translation
IF YOU STILL CANT UNDERSAND HOW TO USE SQL CHECK HERE klop's guide (Guide to make YOU SERVER-100%.Work.Download HERE:))
1. Creation of Databases

- lin2world
- lin2comm
- lin2log
- lin2report
- lin2db
- petition
Databases mentioned above should be created.

2. Rightclick the Database - Registered sql server Property Edit(e) Click

sql server identity uses(q) (Check this one)
User Name(l)
Password(a)
Put the Name and Password which you have used on the installation

This is the important part of this installation .Usually errors occur somewhere in

here, so follow along really carefully.

RUN your SQL Server Agent

3. lin2world Database - lin2world_20040609_all.sql Analyze Query,than press save and next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

4. lin2comm Database - lin2comm_new.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

5. lin2log Database - lin2log_20040416.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

6. lin2report Database - lin2report_20040416.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

7. lin2db Database - lin2db_AuthDBSchema.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

8. lin2db Database - lin2db_update.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

9. petition Database - petition.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

IMPORTANT!!!

lin2db Database -> Table -> Server (open table)

add

id = 1
name = same as the worldname in l2server.ini
ip = your WAN IP
inner_ip = your LAN IP
ageLimit = 0
pk_flag = 0 PK not allow; 1 allow
kind=0
port=7777

-------------------------------------------------------------------------------------

DSN config

Control Pannel - Administrative Tools- ODBC - FILE DSN

Add - SQL server - lin2world - Server(s): (local) - Windows NT identification(W) - Change the Basic Database to following(D): lin2world

Add - SQL server - lin2comm - Server(s): (local) - Windows NT identification(W) - Change the Basic Database to following(D): lin2comm

Add - SQL server - lin2log - Server(s): (local) - Windows NT identification(W) - Change the Basic Database to following(D): lin2log

Add - SQL server - lin2report - Server(s): (local) - Windows NT identification(W) - Change the Basic Database to following(D): lin2report

Add - SQL server - lin2db - Server(s): (local) - Windows NT identification(W) - Change the Basic Database to following(D): lin2db

Add - SQL server - petition - Server(s): (local) - Windows NT identification(W) - Change the Basic Database to following(D): petition

-------------------------------------------------------------------------------------

Part 2 - END

################################################## ##

################################################## ##

Part 3 - RUN the server

-------------------------------------------------------------------------------------

edit boot.ini under C:
!!!IMPORTANT THE WAY TO RUN ALL NPC'S!!!

You might see different, depend which OS u got

[boot loader]
timeout=0
default=multi(0)disk(0)rdisk(0)partition(1)WINDOW S
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)WINDOWS="Micro soft Windows XP Professional" /nodetect /3GB

add /3GB at the end save it and reboot your computer

-------------------------------------------------------------------------------------

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

-------------------------------------------------------------------------------------

Part 3 - END

################################################## ##

################################################## ##

Part 4 - ASP account register system
You can downlod the ASP syatem below in English

-------------------------------------------------------------------------------------

edit config.asp

<%
const WEB_SIT_NAME = "Lineage2"
const SERVER_MAX_CLIENT = 600

'Change the COOKIE_HEAD whatever you like.
const COOKIE_HEAD = "none"
%>

WEB_SIT_NAME ="your server's name"
COOKIE_HEAD = "put whatever u like"

-------------------------------------------------------------------------------------

edit conn.asp

'MS SQL Database address
ms_sql_server_host_addr = "127.0.0.1"

'MS SQL account
sql_server_username = "gamma"

'MS SQL password
sql_server_password = "l2online"

'Lin2db database(user_auth)
lin2db = "lin2db"

'Lin2world database(user_data)
lin2world = "lin2world"

' Encrypt or decrypt L2AuthD(otherwise will say password not match)
' 1) When using L2AuthD_encrypt.zip then set sys_type = "encrypt"
' 2) When using L2AuthD_decrypt.zip then set sys_type = "none"
sys_type = "encrypt"

-------------------------------------------------------------------------------------

Part 4 - END

################################################## ##

################################################## ##

Part 5 - RUN the game

-------------------------------------------------------------------------------------

All CHRONICLE 1 clients can be use

ftp://l2clientdownload.lineage2.com/...2installer.zip (US clients)
Lineage2 C1 US client patch(need ftp)
for the patch check here (stinger)

-------------------------------------------------------------------------------------

edit l2.ini file

u need a tool called l2decrypt.exe to crack the l2.ini, you can download it below

decrypt the l2.ini then you got a file called l2.clear.ini
edit l2.clear.ini
change the IP as the Lineage2 server which you want to play
ServerAddr=127.0.0.1
crypt the l2.clear.ini using 212 then you got a file called l2.crypt.ini
rename the l2.crypt.ini as l2.ini and copy to your lineage2 system folder

-------------------------------------------------------------------------------------

Part 5 - END

################################################## ##

################################################## ##

Part 6 - GM config

open builder_account under lin2world databse

account_name = your GM account (normal account)
default_builder = 1,2,3,4...9
account_id = your GM account ID (can find out in user_account table under lin2db database)

open user_dat under lin2world database
find out the GM in the GM account
builder = default_builder (1,2,3,4...9)

Part 6 - END

################################################## ##

################################################## ##

Part 7 - Server files updata

exp x10 sp x15 money x20 drop x 10 npcdata.txt

no errors DBScript.zip

Part 7 - END

################################################## ##

Admin Joined: 13 May 2006 Posts: 187 Location: Å iauliai

O LT?

Admin Joined: 05 Jun 2006 Posts: 37 Location: Vilnius

O LT versija po truputuka verciu bet kolkas kas supranta anglishkai tai dawiau tiems Smile

Admin Joined: 13 May 2006 Posts: 187 Location: Å iauliai

Saunolis ( Mldc ) Versk toliau Smile

)

Admin Joined: 16 May 2006 Posts: 45 Location: Vilnius

levai .. C1 gereu reikejo ydet C4 ar nors teksturas kokias ....

Admin Joined: 13 May 2006 Posts: 187 Location: Å iauliai

)0 Gal. ...

Admin Joined: 13 May 2006 Posts: 45

Teisingai siaip dabar jei kuri serva tai arba c4 arba c3...bet c4 labiau patartina nes nieks jokiu c1 nelos 8)

Admin Joined: 16 May 2006 Posts: 45 Location: Vilnius

c1 liko tik seni jau isivaziave serai .. manau o dabar nauji visi kruia gal daugiau c3 kadangi gal jame daugiau bugu tvarkyta nos as apie l2 nlb ka nusimanau Very Happy

Admin Joined: 05 Jun 2006 Posts: 37 Location: Vilnius

nu sjp man jau gereu nebugowas c1 nei bugowas }c4 :} nzn kajp kitiem...

Admin Joined: 27 May 2006 Posts: 35

bet kitiem px tie bugai daugiausiai c4 losia...

Admin Joined: 13 May 2006 Posts: 187 Location: Å iauliai

Dejo jie ant tu Bugu jiems svarbu nuzudyt Monstra pasikelt LVL ir nuzudyt koki katiki susikursi charla ju sistema xD