[GUIDE]POS ANOIGETE 2 SERVER STO IDIO LOGIN

[A-error]

Hi paidia  edo mporite na anoi3ete 2 server se ena login..

arxisoume  pigene gameserver\config\server

 

meta pigenete  edo

 

# Bind ip of the gameserver, use * to bind on all available IPs
GameserverHostname = *
GameserverPort = 7777

 

8a alla3ete to (7777) kai 8a to kanete (7778)

 

meta brite aytro

 

# 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 = 

 

kai mou leei (l2jdb) kanteto l2jdb_2 kai eistai ok

 

meta klenete ta config kai pame sta tools kai brite to

database_installer

 

kante de3ei kleik  kai 8a sas bgalei ayto edo

 

 

patiste epe3ergasia

 

kai molis anoi3ei 8a   dite ola ayta  mesa

 

@echo off
REM ##############################################
REM ##         L2Dot Database Installer         ##
REM ##############################################
REM ## Interactive script setup - L2 Dot Team   ##
REM ##############################################



:configure
call :colors 17
title L2Dot installer - Setup
cls
set config_version=1
if NOT %upgrade_mode% == 2 (
set fresh_setup=1
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 5.0\bin
set lsuser=root
set lspass=
set lsdb=l2jdb
set lshost=localhost
set gsuser=root
set gspass=
set gsdb=l2jdb
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
)
set mysqlPath=%mysqlBinPath%\mysql.exe
echo New settings will be created for this tool to run in
echo your computer, so I need to ask you some questions.
echo.
echo 1-MySql Binaries
echo --------------------
echo In order to perform my tasks, I need the path for commands
echo such as 'mysql' and 'mysqldump'. Both executables are
echo usually stored in the same place.
echo.
if "%mysqlBinPath%" == "" (
set mysqlBinPath=use path
echo I can't determine if the binaries are available with your
echo default settings.
) else (
echo I can try to find out if the current setting actually works...
echo.
echo %mysqlPath%
)
if not "%mysqlBinPath%" == "use path" call :binaryfind
echo.
path|find "MySQL">NUL
if %errorlevel% == 0 (
echo I found MySQL is in your PATH, this will be used by default.
echo If you want to use something different, change 'use path' for 
echo something else.
set mysqlBinPath=use path
) else (
echo Look, I can't find "MYSQL" in your PATH environment variable.
echo It would be good if you go and find out where "mysql.exe" and 
echo "mysqldump.exe" are.
echo.
echo If you have no idea about the meaning of words such as MYSQL
echo or PATH, you'd better close this window, and consider googling
echo and reading about it. Setup and host an L2J server requires a
echo minimum of technical skills.
)
echo.
echo Write the path to your MySQL binaries (no trailing slash needed):
set /P mysqlBinPath="(default %mysqlBinPath%): "
cls
echo.
echo 2-LoginServer settings
echo --------------------
echo I will connect to the MySQL server you specify, and setup a
echo Loginserver database there, most people use a single MySQL
echo server and database for both Login and Gameserver tables.
echo.
set /P lsuser="MySQL Username (default is '%lsuser%'): "
set /P lspass="Password (will be shown as you type, default '%lspass%'): "
set /P lsdb="Database (default is '%lsdb%'): "
set /P lshost="Host (default is '%lshost%'): "
if NOT "%lsuser%"=="%gsuser%" set gsuser=%lsuser%
if NOT "%lspass%"=="%gspass%" set gspass=%lspass%
if NOT "%lsdb%"=="%gsdb%" set gsdb=%lsdb%
if NOT "%lshost%"=="%gshost%" set gshost=%lshost%
echo.
echo 3-GameServer settings
echo --------------------
set /P gsuser="User (default is '%gsuser%'): "
set /P gspass="Pass (default is '%gspass%'): "
set /P gsdb="Database (default is '%gsdb%'): "
set /P gshost="Host (default is '%gshost%'): "
echo.
echo 4-Misc. settings
echo --------------------
set /P cmode="Color mode (c)olor or (n)on-color, default %cmode% : "
set /P backup="Path for your backups (default '%backup%'): "
set /P logdir="Path for your logs (default '%logdir%'): "
:safe1
set safemode=y
set /P safemode="Debugging messages and increase verbosity a lil bit (y/n, default '%safemode%'): "
if /i %safemode%==y (set safe_mode=1&goto safe2)
if /i %safemode%==n (set safe_mode=0&goto safe2)
goto safe1
:safe2
echo.
if "%mysqlBinPath%" == "use path" (
set mysqlBinPath=
set mysqldumpPath=mysqldump
set mysqlPath=mysql
) else (
set mysqldumpPath=%mysqlBinPath%\mysqldump.exe
set mysqlPath=%mysqlBinPath%\mysql.exe
)
echo @echo off > %config_file%
echo set config_version=%config_version% >> %config_file%
echo set cmode=%cmode%>> %config_file%
echo set safe_mode=%safe_mode% >> %config_file%
echo set mysqlPath=%mysqlPath%>> %config_file%
echo set mysqlBinPath=%mysqlBinPath%>> %config_file%
echo set mysqldumpPath=%mysqldumpPath%>> %config_file%
echo set lsuser=%lsuser%>> %config_file%
echo set lspass=%lspass%>> %config_file%
echo set lsdb=%lsdb%>> %config_file%
echo set lshost=%lshost% >> %config_file%
echo set gsuser=%gsuser%>> %config_file%
echo set gspass=%gspass%>> %config_file%
echo set gsdb=%gsdb%>> %config_file%
echo set gshost=%gshost%>> %config_file%
echo set logdir=%logdir%>> %config_file%
echo set backup=%backup%>> %config_file%
echo.
echo Script setup complete, your settings were saved in the
echo '%config_file%' file. Remember: your passwords are stored
echo as clear text.
echo.
echo press any key to continue...
pause> nul
goto loadconfig

:ls_section
cls
call :colors 17
set cmdline=
set stage=1
title L2Dot installer - Login Server database setup
echo.
echo Trying to make a backup of your loginserver database.
set cmdline="%mysqldumpPath%" --add-drop-table -h %lshost% -u %lsuser% --password=%lspass% %lsdb% ^> "%backup%\loginserver_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto lsdbok
REM if %safe_mode% == 1 goto omfg
:ls_err1
call :colors 47
title L2Dot installer - Login Server database setup ERROR!!!
cls
echo.

 

brite  ayto edo to simio

 

:configure
call :colors 17
title L2Dot installer - Setup
cls
set config_version=1
if NOT %upgrade_mode% == 2 (
set fresh_setup=1
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 5.0\bin
set lsuser=root
set lspass=
set lsdb=l2jdb
set lshost=localhost
set gsuser=root
set gspass=
set gsdb=l2jdb
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
)

 

kai ekei pou exei to (set lsdb=l2jdb)  8a to kanete eseis (l2jdb_2) kai  meta 8a to kleisete kai 8a kane installer

 

kai fiska prin na kanete installer tin database

 

pigenete stin Navicat kai kante ta exeis bimata

 

 

kai meta kante to installer  meta molis teliosei to installer pigenete sto login

kai brite to RegisterGameServer

 

kai kante ta e3eis pragmata

 

 

meta 8a se bgei to hexid

 

 

kai kanteto metanomiza apo (hexid_2 pou bgenei kanteto (hexid) sketo

 

meta pigene anoixte ta config tou 2 server kai  balte to hexid mesa kai  o server einai ok meta

 

 

3ero oti exoun ginei polla post tetoia alla pisteyo  oti to ekana polu diaforetiko apo ta alla.. ama exete problima me to post kanteto delete..ty

[Kwlotoumpas]

Analitikotatos.Kapoios na to kanei sticky gia tous newbies!

Pio aplo kai analytiko dn mporouse na einai!

Euxaristw poly!

[Animus]

Analitikotatos.Kapoios na to kanei sticky gia tous newbies!

Pio aplo kai analytiko dn mporouse na einai!

Euxaristw poly!

 

file exeis apolito dikoio  einai to kalitero mexri stigmis pou exo dei

sinexise etsi A-error

+1 :P

[4fun]

polu kalo to Guide sou ta leei opos prepi ...makari na mporousa na sou edina +1

[par1s]

oreo guide

[SySt3MGaM3RFr3aKs]

Mprabo Very Nice Guide THANKS

[3xpl0it3R]

Poli kalo guide.Thx poli alla prepei na episimanoume oti afto den einai se ola ta packs.Diladi ama exei kapios L2 Emu mporei na exei problima....

[p4lik4ri]

wraios thx

 

[soublakias]

File egw to dokimasa se L2JFree kai mou bgazei wrong hedix...btw douleuei se L2JFree?

[manolisdim]

to pio analytiko guide gia ayto to 8ema

[Sortep]

file para poly kalo Guide, tnx.

[A-error]

File egw to dokimasa se L2JFree kai mou bgazei wrong hedix...btw douleuei se L2JFree?

 

file kati la8os exeis kanei ama einai kane post ta config  na ta do kai na sta ftia3o

[Grim.]

epitelous ebgala akri ..bravo agori m

auta ta moving poli m arecan xD

[tiranous]

otan les anoikste ta cofing tou 2 server?

dn to katalava... to ekana antikatastasi me to palio k m exei 1 server mesa.

[Jimaras22]

me diskw ti kanoume? oi me backup?