L2J Server

Code: Select all

[img]http://img689.imageshack.us/img689/549/errorpc.jpg[/img]

Code: Select all

@echo offclstitle L2J - SQL Account Managercolor 17java -Djava.util.logging.config.file=console.cfg -cp ./../libs/*;l2jlogin.jar com.l2jserver.accountmanager.SQLAccountManager 2> NULif %errorlevel% == 0 (echo.echo Execution succesfulecho.) else (echo.echo An error has ocurred while running the L2J Account Manager!echo.echo Possible reasons for this to happen:echo.echo - Missing .jar files or ../libs directory.echo - MySQL server not running or incorrect MySQL settings:echo    check ./config/loginserver.propertiesecho - Wrong data types or values out of range were provided:echo    specify correct values for each required fieldecho.)pause

Code: Select all

[img]http://img686.imageshack.us/img686/2296/errordatabaseinstall.jpg[/img]

Code: Select all

 @echo off set config_version=2 set cmode=cset safe_mode=1 set mysqlPath=C:\Programmi\MySQL\MySQL Server 5.0\bin\mysql.exeset mysqlBinPath=C:\Programmi\MySQL\MySQL Server 5.0\binset mysqldumpPath=C:\Programmi\MySQL\MySQL Server 5.0\bin\mysqldump.exeset lsuser=rootset lspass=*******set lsdb=l2jdbset lshost=localhost set cbuser=rootset cbpass=b*******set cbdb=l2jcbset cbhost=*******set gsuser=rootset gspass=******set gsdb=l2jdbset gshost=localhostset logdir=.set backup=. 

Code: Select all

echo An error has ocurred while running the L2J Account Manager!echo.echo Possible reasons for this to happen:echo.echo - [b]Missing .jar files or ../libs directory.[/b]echo - [b]MySQL server not running or incorrect MySQL settings:[/b]echo    [b]check ./config/loginserver.properties[/b]echo - [b]Wrong data types or values out of range were provided:[/b]echo    [b]specify correct values for each required field[/b] 

Code: Select all

# ---------------------------------------------------------------------------# Login Server Settings# ---------------------------------------------------------------------------# This is the server configuration file. Here you can set up the connection information for your server.# This was written with the assumption that you are behind a router.# Dumbed Down Definitions...# LAN (LOCAL area network) - typically consists of computers connected to the same router as you.# WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet).# x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers.# ---------------------------------------------------------------------------# Networking# ---------------------------------------------------------------------------# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname# Common settings...# 127.0.0.1 - If you are playing alone on a test server# 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect# x.x.x.x - WAN IP obtained from http://www.whatismyip.com/. This is if you want people outside your internal network to be able to connect to your server.# ---------------------------------------------------------------------------# Default: 127.0.0.1ExternalHostname = 82.#.#.# # ---------------------------------------------------------------------------# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname.# This can be the internal IP such as 127.0.0.1 or the computer's IP such as 192.168.x.x.# ---------------------------------------------------------------------------# Default: 127.0.0.1InternalHostname = 82.#.#.# # ---------------------------------------------------------------------------# If you are behind a router which using its own local IP for Port Forwarding then set this to the routers# local IP if you want people outside your internal network to be able to connect to your server.# ---------------------------------------------------------------------------# RouterHostname = # Bind ip of the LoginServer, use * to bind on all available IPs# Default: *LoginserverHostname = 82.#.#.# # Default: 2106LoginserverPort = 2106 # The address on which login will listen for GameServers, use * to bind on all available IPs# Default: *LoginHostname = 82.#.#.# # The port on which login will listen for GameServers# Default: 9014LoginPort = 9014 # The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)# Default: 15IpUpdateTime = 15 # ---------------------------------------------------------------------------# Security# ---------------------------------------------------------------------------# Default: TrueLogLoginController = True # How many times you can provide an invalid account/pass before the IP gets banned.# Default: 10LoginTryBeforeBan = 10 # Time you won't be able to login back again after LoginTryBeforeBan tries to login.# Default: 600 (10 minutes)LoginBlockAfterBan = 600 # If set to True any GameServer can register on your login's free slots# Default: FalseAcceptNewGameServer = False # Enforce GameGuard authorization from client?# If True, login server will kick client if the client bypassed GameGuard authentication.# Default: FalseForceGGAuth = False # Flood Protection. All values are in MILISECONDS.# Default: TrueEnableFloodProtection = True # Default: 15FastConnectionLimit = 15 # Default: 700NormalConnectionTime = 700 # Default: 350FastConnectionTime = 350 # Default: 50MaxConnectionPerIP = 50 # ---------------------------------------------------------------------------# Database# ---------------------------------------------------------------------------# Specify the appropriate driver and url for the database you're using.# Examples:# Driver = com.mysql.jdbc.Driver (default)# Driver = org.hsqldb.jdbcDriver# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriverDriver = com.mysql.jdbc.Driver # Database URL# URL = jdbc:mysql://localhost/l2jdb (default)# URL = jdbc:hsqldb:hsql://localhost/l2jdb# URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =URL = jdbc:mysql://localhost/l2jlogin # Database user info (default is "root" but it's not recommended)Login = root # Database connection passwordPassword = ************ # Default: 10MaximumDbConnections = 10 # Default: 0MaximumDbIdleTime = 0 # ---------------------------------------------------------------------------# Misc.# ---------------------------------------------------------------------------# If False, the license (after the login) will not be shown.# Default: TrueShowLicence = True # Default: TrueAutoCreateAccounts = False # ---------------------------------------------------------------------------# Developer Settings# ---------------------------------------------------------------------------# Default: FalseDebug = False # Default: FalseAssert = False # Default: FalseDeveloper = False  

Code: Select all

lsdb=l2jdb

Code: Select all

URL = jdbc:mysql://localhost/l2jlogin

Code: Select all

URL = jdbc:mysql://localhost/l2jdb

Code: Select all

URL = jdbc:mysql://localhost/l2jls

Code: Select all

URL = jdbc:mysql://localhost/l2jgs

Code: Select all

# Database user info (default is "root" but it's not recommended)Login = root# Database connection passwordPassword = *******

Code: Select all

InternalHostname = 192.168.*.*

Code: Select all

InternalHostname = 127.0.0.1

Code: Select all

@echo off set config_version=2 set cmode=cset safe_mode=1 set mysqlPath=C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe (or whatever your path is)set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.1\bin (or whatever your path is)set mysqldumpPath=C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump.exe (or whatever your path is)set lsuser=rootset lspass=passwordset lsdb=l2jlsset lshost=localhost or 127.0.0.1 or 192.168.*.*set cbuser=rootset cbpass=passwordset cbdb=l2jcbset cbhost=localhost or 127.0.0.1 or 192.168.*.*set gsuser=rootset gspass=passwordset gsdb=l2jgsset gshost=localhost or 127.0.0.1 or 192.168.*.*set logdir=.set backup=.