DOWNLOADS:
MYSQLDOWNLOAD
DOWNLOAD

NAVICAT

DOWNLOAD
DOWNLOAD

SERVER FILES
DOWNLOAD
JAVAWWW.JAVA.COM

STEP 1: INSTALLING MYSQL:








HERE YOU INSERT A PASSWORD, AND YOU MUST REMEMBER IT !



STEP 2: INSTALLING NAVICAT:
http://i298.photobucket.com/albums/m.../navicat_1.jpg
http://i298.photobucket.com/albums/m.../navicat_2.jpg
http://i298.photobucket.com/albums/m.../navicat_3.jpg
http://i298.photobucket.com/albums/m.../navicat_4.jpg
http://i298.photobucket.com/albums/m.../navicat_5.jpg
http://i298.photobucket.com/albums/m.../navicat_6.jpg
http://i298.photobucket.com/albums/m.../navicat_7.jpg
http://i298.photobucket.com/albums/m.../navicat_8.jpg

MAKE L2JDB SCREENSHOTS HERE:
http://i298.photobucket.com/albums/m...database_1.jpg
http://i298.photobucket.com/albums/m...database_2.jpg
http://i298.photobucket.com/albums/m...database_3.jpg

STEP 3: SERVER CONFIGURATION
Now go to gameserver/config/server.properties and edit :
Code:
# This is the server configuration file. Here you can set up the connection for your server.
# Usually you have to change the ExternalHostname option to
# - 127.0.0.1 (if you want to play alone / testing purpose)
# - LAN IP* (if you want to play from another computer in the network)
# - WAN IP** (if you want to play with friends over internet)
# - Questions? => http://l2jfree.com
#
# * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"
# **= If you want to get you WAN IP, visit http://www.whatismyip.com
# ===================================================================================================
 
# ================================================================
# General server setting !!! REQUIRED to configure to everyone !!!
# ================================================================

# Bind ip of the gameserver, use 0.0.0.0 to bind on all available IPs
GameserverHostname=YOUR IP HERE
GameserverPort=7777

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname=YOUR IP HERE
# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname=YOUR IP HERE
# Define internal networks (10.0.0.0/8,192.168.0.0/16 is default internal networks)
InternalNetworks=
# Define optional networks and router IPs
# IP (200.100.200.100) or fully qualified domain name
# (google.com) that resolves to an IP (use ping to determine if a domain resolves).
# Format: ip,net/mask;ip,net/mask,net/mask
# (mask 192.168.0.0/16 or 192.168.0.0/255.255.0.0 would be 192.168.*.*)
# Note: keep InternalNetworks and OptionalNetworks blank for compatibility with older login server
OptionalNetworks=

# The Loginserver host and port
LoginPort=9014
LoginHost=YOUR IP HERE

# This is the server id that the gameserver will request (i.e. 1 is Bartz)
RequestServerID = 1
# If set to true, the login will give an other id to the server  if the requested id is allready reserved
AcceptAlternateID = True

# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=YOUR DATABASE PASSWORD HERE 
MaximumDbConnections=50

# Datapack root directory, defaults to current directory from which the server is started
#DatapackRoot=H:/workEclipse/L2J Free/trunk/L2_DataPack_IL

# Define character name template
# These ones are regular expressions, visit http://www.regular-expressions.info for details
# Note: Checking lengths are done server side, but keep it in pattern for future purposes
# Character name ( Default [A-Za-z0-9\-]{3,16} )
CnameTemplate=[A-Za-z0-9\-]{3,16}
Now go to loginserver/config/server.properties and edit :
Code:
# ================================================================
# General login server setting !!! REQUIRED to configure to everyone !!!
# ================================================================

# Bind ip of the loginserver, use 0.0.0.0 to bind on all available IPs
LoginServerHostname=YOUR IP HERE
LoginServerPort=2106
GMMinLevel=100

# The port, ip on which login will listen for GameServers
LoginHostname=YOUR IP HERE
LoginPort=9014

# If set to true any GameServer can register on your login's free slots
AcceptNewGameServer = False

# If false, the licence (after the login) will not be shown
ShowLicence = True

# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=YOUR DB PASSWORD HERE

# Useable values: "True" - "False", use this option to choose whether accounts will be created
# automatically or not.
AutoCreateAccounts=True

# The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)
# (0 = disable)
IpUpdateTime=0


# ==============================================================
# Test server setting, shoudnt be touched in online game server
# ==============================================================

Debug = False
Assert = False
Developer = False
# Enforce GG Authorization from client
# Login server will kick client if client bypassed GameGuard authentication
ForceGGAuth=False

#FloodProtection. time in ms
EnableFloodProtection=True
FastConnectionLimit=15
NormalConnectionTime=700
FastConnectionTime=350
MaxConnectionPerIP=50

#Ban management
# number of attempt before a user is banned when he fails his login
LoginTryBeforeBan=10
# Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600)
LoginBlockAfterBan=600
Now lets put all the info of the SQL files into ur database.

-Ull find a file called Database_installer.bat at the Tools folder that will be inside ur server's folder.

-Right click on it and choose EDIT.

-Insert in the line "set mysqlBinPath=" the correct address of ur MySQL BIN FOLDER, than save it.

-Execute the modified file. A Ms-dos window will open giving u choices. Press "F" (full installation) every time it ask u to choose.

SCREENSHOTS:


http://i298.photobucket.com/albums/m...ici/edit_1.jpg
http://i298.photobucket.com/albums/m...ici/tool_1.jpg
http://i298.photobucket.com/albums/m...ici/tool_2.jpg
http://i298.photobucket.com/albums/m...ici/tool_3.jpg

STEP 4: REGISTER A SERVER :
Now go to loginserver/registergameserver.bat !
Write 1 in cmd and press enter ! Now your server will be Bartz !

http://i298.photobucket.com/albums/m...register_1.jpg

Done it a file called hexid(id 1 or something like).txt will appear into ur login folder. Rename it to hexid.txt , copy and paste inside ur gameserver/config/ folder and in gameserver folder !

Now just need to start the "startloginserver.bat" (login folder) and "startgameserver.bat" (gameserver folder). It will be opened when stops on the following lines (check the image). Remember, ur server is setted up to autocreate accounts so u dont need to execute "startaccountmanager.bat" this time