Help Problem With Lineage2 Ertheia Datebase

kiskiss · January 13, 2015

Hello, i was creating L2 Ertheia server but i have problem with datebase, who can help me to solve this problem? Thank you, regards

@echo off
REM ²M²z
if exist ..\game\data\stats\skills\27000-Add.xml del ..\game\data\stats\skills\27000-Add.xml
if exist ..\game\data\stats\skills\27000-Subclass.xml del ..\game\data\stats\skills\27000-Subclass.xml
if exist ..\game\data\stats\skills\27001-Item.xml del ..\game\data\stats\skills\27001-Item.xml
if exist ..\game\data\stats\skills\27004-Transfor.xml del ..\game\data\stats\skills\27004-Transfor.xml
if exist ..\game\data\stats\skills\27010-Other.xml del ..\game\data\stats\skills\27010-Other.xml
if exist ..\game\data\stats\items\50003-Cloak.xml del ..\game\data\stats\items\50003-Cloak.xml
if exist ..\game\data\stats\items\50004-Other.xml del ..\game\data\stats\items\50004-Other.xml
if exist ..\game\data\stats\npcs\50000-New.xml del ..\game\data\stats\npcs\50000-New.xml
if exist ..\sql\L2JTW_2\item_tw.sql del ..\sql\L2JTW_2\item_tw.sql
if exist ..\sql\L2JTW_2\npc_tw.sql del ..\sql\L2JTW_2\npc_tw.sql
if exist ..\sql\L2JTW_2\skill_tw.sql del ..\sql\L2JTW_2\skill_tw.sql

REM ÀË¬d¬O§_¦s¦b GS ¤ä´©ªºª©¥»¸ê°T
set dp_err=0
if not exist ..\doc\L2J_Server_Ver.txt echo ¨S¦³µo²{ GS ¤ä´©ªºª©¥»¸ê°T¡I
if not exist ..\doc\L2J_Server_Ver.txt echo ½Ð¦A¤@¦¸¡G§ó·s GS ¡÷ ½sÄ¶ GS ¡÷ ¸ÑÀ£ÁY GS ¡÷ ³]©w Config
if not exist ..\doc\L2J_Server_Ver.txt echo.
if not exist ..\doc\L2J_Server_Ver.txt pause
if not exist ..\doc\L2J_Server_Ver.txt goto end
REM ¨ú±o GS ¤ä´©ªºª©¥»¸ê°T
FOR /F %%g IN (..\doc\L2J_Server_Ver.txt) DO set vgs=%%g
REM ÀË¬d GS ¤ä´©ªºª©¥»¸ê°T
if not %vgs% == Ertheia echo µLªkÄ~Äò¦w¸Ë DP¡A¦]¬°¡G
if not %vgs% == Ertheia echo GS ¤ä´©ªºª©¥»¬O¡G%vgs%
if not %vgs% == Ertheia echo DP ¤ä´©ªºª©¥»¬O¡GErtheia
if not %vgs% == Ertheia echo ½Ð½T©w GS ©M DP ³£¨Ï¥Î¬Û¦Pªºª©¥»«á¡A¦A¸Õ¤@¦¸
if not %vgs% == Ertheia echo.
if not %vgs% == Ertheia pause
if not %vgs% == Ertheia goto end

REM ¥\¯à»¡©ú¡G¨C¹j¤@¬q®É¶¡§R°£ libs ©M§Ö¨ú¡A¥H¨¾¤î GS ¥X¿ù
if not exist ..\libs\*.jar echo ±z¥²¶·«·s¸ÑÀ£ÁY¡u½sÄ¶§¹¦¨¡vªº GS¡A¤~¥i¥HÄ~Äò¦w¸Ë¸ê®Æ®w
if not exist ..\libs\*.jar echo.
if not exist ..\libs\*.jar pause
if not exist ..\libs\*.jar exit

REM ¦pªG libs §Ö¨ú¤£¦s¦b¡Aªí¥ÜÁÙ¨S¦³±Ò°Ê¹L¦øªA¾¹¡A«h¸õ¹LÀË¬d
if not exist ..\libs\cachedir\ md ..\libs\cachedir\
if not exist ..\libs\cachedir\packages\*.pkc goto _lib_update

REM ¦pªG log ¤£¦s¦b¡Aªí¥ÜÁÙ¨S¦³±Ò°Ê¹L¦øªA¾¹¡A«h¸õ¹LÀË¬d
if not exist ..\game\log\*.log goto _lib_update

REM ------------------------------------------------------
REM _lib_check1 ªºÀË¬d ¶}©l
REM ¦pªG Windows ªº CMD ª©¥»¸ê°T¤w¦s¦b¡A«h¸õ¨ìÀË¬d1
if exist ..\libs\cachedir\check_w_ver.txt goto _lib_check1

REM ¦pªG Windows ªº CMD ª©¥»¸ê°T¤£¦s¦b¡A«h«Ø¥ß¸ê°T
ver > ..\libs\cachedir\check_w_ver.txt
goto _lib_del

:_lib_check1
REM ¨ú±o¥Ø«eªº Windows CMD ª©¥»¸ê°T
ver > %temp%\check.txt
FOR /F "skip=1 delims=*" %%a IN (%temp%\check.txt) do set aaa=%%a

REM ¨ú±o¤w¦s¦bªº Windows CMD ª©¥»¸ê°T
FOR /F "skip=1 delims=*" %%b IN (..\libs\cachedir\check_w_ver.txt) do set bbb=%%b

REM ¤ñ¸û Windows ªº CMD ª©¥»¸ê°T
if "%aaa%"=="%bbb%" goto _lib_check2
echo ¦]¬°±zªº Windows ª©¥»¦³§ó·s¡A©Ò¥H¥²¶·§R°£ÂÂªº libs ©M§Ö¨ú¡A¥H¨¾¤î GS ¥X¿ù
echo.
pause
goto _lib_del
REM _lib_check1 ªºÀË¬d µ²§ô
REM ------------------------------------------------------


REM ------------------------------------------------------
REM _lib_check2 ªºÀË¬d ¶}©l
REM ¦pªG Java ¸ô®|¤£¦s¦b¡A«h¸õ¨ì¤U¤@ÓÀË¬d
if not exist "%ProgramFiles%\Java\jdk1.8.*" goto _lib_check3

REM ¦pªG Java ª©¥»¸ê°T¤w¦s¦b¡A«h¸õ¨ìÀË¬d2
if exist ..\libs\cachedir\check_j_ver.txt goto _lib_check2

REM ¦pªG Java ª©¥»¸ê°T¤£¦s¦b¡A«h«Ø¥ß¸ê°T
dir "%ProgramFiles%\Java\jdk1.8.*" /A:D /B /O > ..\libs\cachedir\check_j_ver.txt
goto _lib_del

:_lib_check2
REM ¨ú±o¥Ø«eªº Java ª©¥»¸ê°T
dir "%ProgramFiles%\Java\jdk1.8.*" /A:D /B /O > %temp%\check.txt
FOR /F %%j IN (%temp%\check.txt) DO set jjj=%%j

REM ¨ú±o¤w¦s¦bªº Java ª©¥»¸ê°T
FOR /F %%k IN (..\libs\cachedir\check_j_ver.txt) do set kkk=%%k

REM ¤ñ¸û Java ª©¥»¸ê°T
if "%jjj%"=="%kkk%" goto _lib_end
echo ¦]¬°±zªº Java ª©¥»¦³§ó·s¡A©Ò¥H¥²¶·§R°£ÂÂªº libs ©M§Ö¨ú¡A¥H¨¾¤î GS ¥X¿ù
echo.
pause
goto _lib_del
REM _lib_check2 ªºÀË¬d µ²§ô
REM ------------------------------------------------------

REM ¼È°± _lib_check3 ³oÓÀË¬d 
REM ------------------------------------------------------
REM _lib_check3 ªºÀË¬d ¶}©l
REM ¦pªG ¤é´Á-¤ë¥÷ ªº¸ê°T¤w¦s¦b¡A«h¸õ¨ìÀË¬d3
if exist ..\libs\cachedir\check_d_ver.txt goto _lib_check3

REM ¦pªG ¤é´Á-¤ë¥÷ ªº¸ê°T¤£¦s¦b¡A«h«Ø¥ß¸ê°T
date/t > ..\libs\cachedir\check_d_ver.txt
goto _lib_del

:_lib_check3
REM ¨ú±o¥Ø«eªº ¤é´Á-¤ë¥÷ ¸ê°T
date/t > %temp%\check.txt
FOR /F "tokens=2 delims=/" %%d IN (%temp%\check.txt) DO set ddd=%%d

REM ¨ú±o¤w¦s¦bªº ¤é´Á-¤ë¥÷ ¸ê°T
FOR /F "tokens=2 delims=/" %%m IN (..\libs\cachedir\check_d_ver.txt) do set mmm=%%m

REM ¤ñ¸û ¤é´Á-¤ë¥÷ ¸ê°T
if "%ddd%"=="%mmm%" goto _lib_end
echo ¦¹¬°¨CÓ¤ë¦Û°Ê²M²zÂÂªº libs ©M§Ö¨ú¡A¥H¨¾¤î GS ¥X¿ù
echo.
pause
goto _lib_del
REM _lib_check3 ªºÀË¬d µ²§ô
REM ------------------------------------------------------


REM ------------------------------------------------------
:_lib_del
echo.
if not exist ..\libs\backup\ md ..\libs\backup\
copy ..\libs\*.* ..\libs\backup\ /Y > nul
del ..\libs\*.* /F /Q > nul
del ..\libs\cachedir\packages\*.* /F /Q > nul
if exist ..\libs\*.jar echo µLªk§R°£ libs ©M§Ö¨ú¡I½Ð¥ýÃö³¬¦øªA¾¹©Î«·s¶}¾÷¡AµM«á¦A¸Õ¤@¦¸
if exist ..\libs\*.jar echo.
if exist ..\libs\*.jar pause
if exist ..\libs\*.jar exit
if exist ..\libs\cachedir\packages\*.pkc echo µLªk§R°£ libs ©M§Ö¨ú¡I½Ð¥ýÃö³¬¦øªA¾¹©Î«·s¶}¾÷¡AµM«á¦A¸Õ¤@¦¸
if exist ..\libs\cachedir\packages\*.pkc echo.
if exist ..\libs\cachedir\packages\*.pkc pause
if exist ..\libs\cachedir\packages\*.pkc exit
ver > ..\libs\cachedir\check_w_ver.txt
dir "%ProgramFiles%\Java\jdk1.8.*" /A:D /B /O > ..\libs\cachedir\check_j_ver.txt
date/t > ..\libs\cachedir\check_d_ver.txt
CLS
echo ÂÂªº libs ©M§Ö¨ú²M²z§¹²¦¡I
echo ±z¥²¶·«·s¸ÑÀ£ÁY¡u½sÄ¶§¹¦¨¡vªº GS¡A¤~¥i¥HÄ~Äò¦w¸Ë¸ê®Æ®w
echo.
pause
exit

:_lib_update
ver > ..\libs\cachedir\check_w_ver.txt
dir "%ProgramFiles%\Java\jdk1.8.*" /A:D /B /O > ..\libs\cachedir\check_j_ver.txt
date/t > ..\libs\cachedir\check_d_ver.txt

:_lib_end
REM ------------------------------------------------------


REM ##############################################
REM ## L2JDP Database Installer - (by DrLecter) ##
REM ##############################################
REM ## Interactive script setup -  (by TanelTM) ##
REM ##############################################
REM Copyright (C) 2004-2013 L2J DataPack
REM
REM This file is part of L2J DataPack.
REM
REM L2J DataPack is free software: you can redistribute it and/or modify
REM it under the terms of the GNU General Public License as published by
REM the Free Software Foundation, either version 3 of the License, or
REM (at your option) any later version.
REM
REM L2J DataPack is distributed in the hope that it will be useful,
REM but WITHOUT ANY WARRANTY; without even the implied warranty of
REM MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
REM General Public License for more details.
REM
REM You should have received a copy of the GNU General Public License
REM along with this program. If not, see <http://www.gnu.org/licenses/>.

set config_file=vars.txt
set config_version=0

set workdir="%cd%"
set full=0
set stage=0-1
set logging=0

set upgrade_mode=0
set backup=.
set logdir=.
set safe_mode=1
set cmode=c
set fresh_setup=0

:loadconfig
cls
title ¦w¸Ë L2JTW DP - Åª¨ú³]©wÀÉ...¡]¶¥¬q %stage%¡^
if not exist %config_file% goto configure
ren %config_file% vars.bat
call vars.bat
ren vars.bat %config_file%
call :colors 17
if /i %config_version% == 2 goto ls_backup
set upgrade_mode=2
echo ±z¦ü¥G¬O²Ä¤@¦¸¨Ï¥Î³oÓª©¥»ªº database_installer
echo ¦ý¬O§Úµo²{¦w¸Ë¸ê®Æ®wªº³]©wÀÉ¤w¸g¦s¦b
echo ¦]¦¹§Ú±N°Ý±z´XÓ°ÝÃD¡A¤Þ¾É±zÄ~Äò¦w¸Ë
echo.
echo §ó·s³]©w¿ï¶µ¡G
echo.
echo (1) ¾É¤J¡®Ä~Äò¨Ï¥ÎÂÂªº³]©w¡G±N¨Ï¥Îì¥»ÂÂªº¸ê®Æ¨Ã¥B¶i¦æ§ó·s§@·~
echo.
echo (2) ¾É¤J¡®¨Ï¥Î·sªº³]©w¡G¾É¤J·sªº¸ê®Æ¨Ã¥B«·s³]©w¸ê®Æ
echo.
echo (3) ¾É¤J¥þ·sªº¸ê®Æ¡G©Ò¦³ÂÂªº¸ê®Æ±N·|²¾°£¨Ã¥B¾É¤J·sªº¸ê®Æ
echo.
echo (4) ¬d¬Ý¦s¨úªº³]©wÈ
echo.
echo (5) °h¥X
echo.
set /P upgrade_mode="¿é¤J¼Æ¦r«á¡A½Ð«ö Enter¡]¹w³]È¬°¡u%upgrade_mode%¡v¡^: "
if %upgrade_mode%==1 goto ls_backup
if %upgrade_mode%==2 goto configure
if %upgrade_mode%==3 goto configure
if %upgrade_mode%==4 (cls&type %config_file%&pause&goto loadconfig)
if %upgrade_mode%==5 goto :eof
goto loadconfig

:colors
if /i "%cmode%"=="n" (
if not "%1"=="17" ( color F ) else ( color )
) else ( color %1 )
goto :eof

:configure
cls
call :colors 17
set stage=0-2
title ¦w¸Ë L2JTW DP - ¦w¸Ë¡]¶¥¬q %stage%¡^
set config_version=2
if NOT %upgrade_mode% == 2 (
set fresh_setup=1
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 5.5\bin

:_MySQL51
if not exist "%ProgramFiles%\MySQL\MySQL Server 5.1\bin\mysql.exe" goto _MySQL55
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 5.1\bin

:_MySQL55
if not exist "%ProgramFiles%\MySQL\MySQL Server 5.5\bin\mysql.exe" goto _MySQL60
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 5.5\bin

:_MySQL60
if not exist "%ProgramFiles%\MySQL\MySQL Server 6.0\bin\mysql.exe" goto _AppServ
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 6.0\bin

:_AppServ
if not exist "%SystemDrive%\AppServ\MySQL\bin\mysql.exe" goto _other
set mysqlBinPath=%SystemDrive%\AppServ\MySQL\bin

:_other
set lsuser=root
set lspass=000000
set lsdb=l2jls_ertheia
set lshost=localhost
set cbuser=root
set cbpass=000000
set cbdb=l2jcs
set cbhost=localhost
set gsuser=root
set gspass=000000
set gsdb=l2jgs_ertheia
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
)
set mysqlPath=%mysqlBinPath%\mysql.exe
echo ·sªº³]©wÈ¡G
echo.
echo 1.MySql µ{¦¡
echo --------------------
echo ½Ð³]©w mysql.exe ©M mysqldump.exe ªº¦ì¸m
echo.
if "%mysqlBinPath%" == "" (
set mysqlBinPath=use path
echo ¨S¦³§ä¨ì MySQL ªº¦ì¸m
) else (
echo ½Ð´ú¸Õ¥H¤U©Ò§ä¨ìªº MySQL ¦ì¸m¡A¬O§_¥i¥H¶i¦æ¾É¤J§@·~
echo.
echo %mysqlPath%
)
if not "%mysqlBinPath%" == "use path" call :binaryfind
echo.
path|find "MySQL">NUL
if %errorlevel% == 0 (
echo ¤W±¬O§ä¨ìªº MySQL¡A¦¹¦ì¸m±N·|³Q³]¬°¹w³]È¡A¦pªG·Q´«¦ì¸m½Ð×§ï...
set mysqlBinPath=use path
) else (
echo µLªk§ä¨ì MySQL¡A½Ð¿é¤J mysql.exe ªº¦ì¸m...
echo.
echo ¦pªG¤£½T©w³o¬O¤°»ò·N«ä©M¦p¦ó¾Þ§@¡A½Ð¨ì¬ÛÃöºô¯¸¬d¸ß©ÎªÌ¦Ü L2JTW ©x¤èºô¯¸µo°Ý©Î´M§ä¬ÛÃö¸ê°T
)
echo.
echo ½Ð¿é¤J mysql.exe ªº¦ì¸m¡G
set /P mysqlBinPath="(default %mysqlBinPath%): "
cls
echo.
echo 2.¡uµn¤J¦øªA¾¹¡v³]©w
echo --------------------
echo ¦¹§@·~±N·|³s½u¦Ü¡uµn¤J¦øªA¾¹¡vªº MySQL ¦øªA¾¹¡A¨Ã¥B¶i¦æ¾É¤J§@·~
echo.
set /P lsuser="¨Ï¥ÎªÌ¦WºÙ¡]¹w³]È¡u%lsuser%¡v¡^: "
:_lspass
set /P lspass="¨Ï¥ÎªÌ±K½X¡]¹w³]È¡u%lspass%¡v¡^: "
if "%lspass%"=="" goto _lspass
set /P lsdb="¸ê®Æ®w¡]¹w³]È¡u%lsdb%¡v¡^: "
set /P lshost="¦ì¸m¡]¹w³]È¡u%lshost%¡v¡^: "
echo.
cls
echo.
echo 3-¡u°Q½×ª©¦øªA¾¹¡v³]©w
echo --------------------
echo ¦¹§@·~±N·|³s½u¦Ü¡u°Q½×ª©¦øªA¾¹¡vªº MySQL ¦øªA¾¹¡A¨Ã¥B¶i¦æ¾É¤J§@·~
echo.
set /P cbuser="¨Ï¥ÎªÌ¦WºÙ¡]¹w³]È¡u%cbuser%¡v¡^: "
:_cbpass
set /P cbpass="¨Ï¥ÎªÌ±K½X¡]¹w³]È¡u%cbpass%¡v¡^: "
if "%cbpass%"=="" goto _cbpass
set /P cbdb="¸ê®Æ®w¡]¹w³]È¡u%cbdb%¡v¡^: "
set /P cbhost="¦ì¸m¡]¹w³]È¡u%cbhost%¡v¡^: "
echo.
cls
echo.
echo 4.¡u¹CÀ¸¦øªA¾¹¡v³]©w
echo --------------------
echo ¦¹§@·~±N·|³s½u¦Ü¡u¹CÀ¸¦øªA¾¹¡vªº MySQL ¦øªA¾¹¡A¨Ã¥B¶i¦æ¾É¤J§@·~
set /P gsuser="¨Ï¥ÎªÌ¦WºÙ¡]¹w³]È¡u%gsuser%¡v¡^: "
:_gspass
set /P gspass="¨Ï¥ÎªÌ±K½X¡]¹w³]È¡u%gspass%¡v¡^: "
if "%gspass%"=="" goto _gspass
set /P gsdb="¸ê®Æ®w¡]¹w³]È¡u%gsdb%¡v¡^: "
set /P gshost="¦ì¸m¡]¹w³]È¡u%gshost%¡v¡^: "
echo.
cls
echo.
echo 5.¨ä¥L³]©w
echo --------------------
set /P cmode="ÃC¦â¼Ò¦¡ (c)¬°ÃC¦â ©Î (n)¬°µLÃC¦â¡]¹w³]È¡u%cmode%¡v¡^: "
set /P backup="³Æ¥÷¦ì¸m¡]¹w³]È¡u%backup%¡v¡^: "
set /P logdir="Logs°T®§¦ì¸m¡]¹w³]È¡u%logdir%¡v¡^: "
:safe1
set safemode=y
set /P safemode="Debug ¼Ò¦¡¡]y/n¡A ¹w³]È¡u%safemode%¡v¡^: "
if /i %safemode%==y (set safe_mode=1&goto safe2)
if /i %safemode%==n (set safe_mode=0&goto safe2)
goto safe1

:safe2
cls
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 cbuser=%cbuser%>> %config_file%
echo set cbpass=%cbpass%>> %config_file%
echo set cbdb=%cbdb%>> %config_file%
echo set cbhost=%cbhost% >> %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 ³]©w¦¨¥\¡I
echo §Aªº³]©wÈ±N·|Àx¦s¦b¡u%config_file%¡v¡A©Ò¦³ªº±b¸¹±K½X±N¥H©ú¤åÅã¥Ü
echo.
pause
goto loadconfig

:ls_backup
cls
call :colors 17
set cmdline=
set stage=1-1
title ¦w¸Ë L2JTW DP - ³Æ¥÷¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¥¿¦b³Æ¥÷¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w...
set cmdline="%mysqldumpPath%" --add-drop-table -h %lshost% -u %lsuser% --password=%lspass% %lsdb% ^> "%backup%\ls_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto ls_db_ok

:ls_err1
cls
set lsdbprompt=y
call :colors 47
set stage=1-2
title ¦w¸Ë L2JTW DP - ¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w³Æ¥÷¥¢±Ñ¡I¡]¶¥¬q %stage%¡^
echo.
echo ³Æ¥÷¥¢±Ñ¡I
echo ì¦]¬O¦]¬°¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¤£¦s¦b
echo ²{¦b¥i¥HÀ°§A«Ø¥ß %lsdb%¡A©ÎªÌÄ~Äò¨ä¥¦³]©w
echo.
echo «Ø¥ß¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¡H
echo.
echo (y)½T©w
echo.
echo (n)¨ú®ø
echo.
echo (r)«·s³]©w
echo.
echo (q)°h¥X
echo.
set /p lsdbprompt=½Ð¿ï¾Ü¡]¹w³]È-½T©w¡^:
if /i %lsdbprompt%==y goto ls_db_create
if /i %lsdbprompt%==n goto cs_backup
if /i %lsdbprompt%==r goto configure
if /i %lsdbprompt%==q goto end
goto ls_err1

:ls_db_create
cls
call :colors 17
set cmdline=
set stage=2-1
title ¦w¸Ë L2JTW DP - «Ø¥ß¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¥¿¦b«Ø¥ß¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w...
set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -e "CREATE DATABASE %lsdb%" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto ls_db_ok
if %safe_mode% == 1 goto omfg

:ls_err2
cls
set omfgprompt=q
call :colors 47
set stage=2-2
title ¦w¸Ë L2JTW DP - ¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w«Ø¥ß¥¢±Ñ¡I¡]¶¥¬q %stage%¡^
echo.
echo ¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w«Ø¥ß¥¢±Ñ¡I
echo.
echo ¥i¯àªºì¦]¡G
echo 1.¿é¤Jªº¸ê®Æ¿ù»~¡A¨Ò¦p¡G¨Ï¥ÎªÌ¦WºÙ/¨Ï¥ÎªÌ±K½X/¨ä¥L¬ÛÃö¸ê®Æ
echo 2.¨Ï¥ÎªÌ¡u%lsuser%¡vªºÅv¤£¨¬
echo 3.¸ê®Æ®w¤w¦s¦b
echo.
echo ½ÐÀË¬d³]©w¨Ã¥B×¥¿¡A©ÎªÌª½±µ«·s³]©w
echo.
echo (c)Ä~Äò
echo.
echo (r)«·s³]©w
echo.
echo (q)°h¥X
echo.
set /p omfgprompt=½Ð¿ï¾Ü¡]¹w³]È-°h¥X¡^:
if /i %omfgprompt%==c goto cs_backup
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto ls_err2

:ls_db_ok
cls
set loginprompt=u
call :colors 17
set stage=2-3
title ¦w¸Ë L2JTW DP - ¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¦w¸Ë¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¡G
echo.
echo (f) §¹¾ã¡G±N²¾°£©Ò¦³ÂÂªº¸ê®Æ¡A«·s¾É¤J·sªº¸ê®Æ
echo.
echo (u) §ó·s¡G±N«O¯d©Ò¦³ÂÂªº¸ê®Æ¡A¨Ã¥B¶i¦æ§ó·s§@·~
echo.
echo (s) ¬Ù²¤¡G¸õ¹L¦¹¿ï¶µ
echo.
echo (r) «·s³]©w
echo.
echo (q) °h¥X
echo.
set /p loginprompt=½Ð¿ï¾Ü¡]¹w³]È-§ó·s¡^:
if /i %loginprompt%==f goto ls_cleanup
if /i %loginprompt%==u goto ls_upgrade
if /i %loginprompt%==s goto cs_backup
if /i %loginprompt%==r goto configure
if /i %loginprompt%==q goto end
goto ls_db_ok

:ls_cleanup
call :colors 17
set cmdline=
set stage=2-4
title ¦w¸Ë L2JTW DP - §¹¾ã¦w¸Ë¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¥¿¦b²¾°£¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¡AµM«á¾É¤J·sªº¸ê®Æ®w...
set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% ^< ls_cleanup.sql 2^> NUL
%cmdline%
if not %ERRORLEVEL% == 0 goto omfg
set full=1
echo.
echo ¡uµn¤J¦øªA¾¹¡v¸ê®Æ®w¤w³Q§R°£
goto ls_install

:ls_upgrade
cls
echo.
echo §ó·s¡uµn¤J¦øªA¾¹¡v¸ê®Æ®wµ²ºc
echo.
echo @echo off> temp.bat
if exist ls_errors.log del ls_errors.log
for %%i in (..\sql\login\updates\*.sql) do echo "%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% --force ^< %%i 2^>^> ls_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move ls_errors.log %workdir%
goto ls_install

:ls_install
cls
set cmdline=
if %full% == 1 (
set stage=2-5
title ¦w¸Ë L2JTW DP - ¦w¸Ë¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w...¡]¶¥¬q %stage%¡^
echo.
echo ¦w¸Ë·sªº¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¤º®e
echo.
) else (
title ¦w¸Ë L2JTW DP - §ó·s¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w...¡]¶¥¬q %stage%¡^
echo.
echo §ó·s¡uµn¤J¦øªA¾¹¡vªº¸ê®Æ®w¤º®e
echo.
)
if %logging% == 0 set output=NUL
set dest=ls
for %%i in (..\sql\login\*.sql) do call :dump %%i

echo §¹¦¨...
echo.
goto cs_backup

:cs_backup
cls
call :colors 17
set cmdline=
set stage=3-1
title ¦w¸Ë L2JTW DP - ³Æ¥÷¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¥¿¦b³Æ¥÷¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w...
set cmdline="%mysqldumpPath%" --add-drop-table -h %cbhost% -u %cbuser% --password=%cbpass% %cbdb% ^> "%backup%\cs_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto cs_db_ok

:cs_err1
cls
set cbdbprompt=y
call :colors 47
set stage=3-2
title ¦w¸Ë L2JTW DP - ¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w³Æ¥÷¥¢±Ñ¡I¡]¶¥¬q %stage%¡^
echo.
echo ³Æ¥÷¥¢±Ñ¡I
echo ì¦]¬O¦]¬°¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¤£¦s¦b
echo ²{¦b¥i¥HÀ°§A«Ø¥ß %cbdb%¡A©ÎªÌÄ~Äò¨ä¥¦³]©w
echo.
echo «Ø¥ß¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¡H
echo.
echo (y)½T©w
echo.
echo (n)¨ú®ø
echo.
echo (r)«·s³]©w
echo.
echo (q)°h¥X
echo.
set /p cbdbprompt=½Ð¿ï¾Ü¡]¹w³]È-½T©w¡^:
if /i %cbdbprompt%==y goto cs_db_create
if /i %cbdbprompt%==n goto gs_backup
if /i %cbdbprompt%==r goto configure
if /i %cbdbprompt%==q goto end
goto cs_err1

:cs_db_create
cls
call :colors 17
set cmdline=
set stage=4-1
title ¦w¸Ë L2JTW DP - «Ø¥ß¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¥¿¦b«Ø¥ß¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w...
set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -e "CREATE DATABASE %cbdb%" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto cs_db_ok
if %safe_mode% == 1 goto omfg

:cs_err2
cls
set omfgprompt=q
call :colors 47
set stage=4-2
title ¦w¸Ë L2JTW DP - ¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w«Ø¥ß¥¢±Ñ¡I¡]¶¥¬q %stage%¡^
echo.
echo ¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w«Ø¥ß¥¢±Ñ¡I
echo.
echo ¥i¯àªºì¦]¡G
echo 1.¿é¤Jªº¸ê®Æ¿ù»~¡A¨Ò¦p¡G¨Ï¥ÎªÌ¦WºÙ/¨Ï¥ÎªÌ±K½X/¨ä¥L¬ÛÃö¸ê®Æ
echo 2.¨Ï¥ÎªÌ¡u%cbuser%¡vªºÅv¤£¨¬
echo 3.¸ê®Æ®w¤w¦s¦b
echo.
echo ½ÐÀË¬d³]©w¨Ã¥B×¥¿¡A©ÎªÌª½±µ«·s³]©w
echo.
echo (c)Ä~Äò
echo.
echo (r)«·s³]©w
echo.
echo (q)°h¥X
echo.
set /p omfgprompt=½Ð¿ï¾Ü¡]¹w³]È-°h¥X¡^:
if /i %omfgprompt%==c goto gs_backup
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto cs_err2

:cs_db_ok
cls
set communityprompt=u
call :colors 17
set stage=4-3
title ¦w¸Ë L2JTW DP - ¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¦w¸Ë¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¡G
echo.
echo (f)§¹¾ã¡G±N²¾°£©Ò¦³ÂÂªº¸ê®Æ¡A«·s¾É¤J·sªº¸ê®Æ
echo.
echo (u)§ó·s¡G±N«O¯d©Ò¦³ÂÂªº¸ê®Æ¡A¨Ã¥B¶i¦æ§ó·s§@·~
echo.
echo (s)¬Ù²¤¡G¸õ¹L¦¹¿ï¶µ
echo.
echo (r)«·s³]©w
echo.
echo (q)°h¥X
echo.
set /p communityprompt=½Ð¿ï¾Ü¡]¹w³]È-§ó·s¡^:
if /i %communityprompt%==f goto cs_cleanup
if /i %communityprompt%==u goto cs_upgrade
if /i %communityprompt%==s goto gs_backup
if /i %communityprompt%==r goto configure
if /i %communityprompt%==q goto end
goto cs_db_ok

:cs_cleanup
call :colors 17
set cmdline=
set stage=4-4
title ¦w¸Ë L2JTW DP - §¹¾ã¦w¸Ë¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¥¿¦b²¾°£¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¡AµM«á¾É¤J·sªº¸ê®Æ®w...
set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< cs_cleanup.sql 2^> NUL
%cmdline%
if not %ERRORLEVEL% == 0 goto omfg
set full=1
echo.
echo ¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¤w³Q§R°£
goto cs_install

:cs_upgrade
cls
echo.
echo §ó·s¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®wµ²ºc
echo.
echo @echo off> temp.bat
if exist cs_errors.log del cs_errors.log
for %%i in (..\sql\community\updates\*.sql) do echo "%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% --force ^< %%i 2^>^> cs_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move cs_errors.log %workdir%
goto cs_install

:cs_install
cls
set cmdline=
if %full% == 1 (
set stage=4-5
title ¦w¸Ë L2JTW DP - ¦w¸Ë¡u°Q½×¦øªA¾¹¡vªº¸ê®Æ®w...¡]¶¥¬q %stage%¡^
echo.
echo ¦w¸Ë·sªº¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¤º®e...
echo.
) else (
title ¦w¸Ë L2JTW DP - §ó·s¡u°Q½×¦øªA¾¹¡vªº¸ê®Æ®w..¡]¶¥¬q %stage%¡^
echo.
echo §ó·s¡u°Q½×ª©¦øªA¾¹¡vªº¸ê®Æ®w¤º®e...
echo.
)
if %logging% == 0 set output=NUL
set dest=cb
for %%i in (..\sql\community\*.sql) do call :dump %%i

echo done...
echo.
goto gs_backup

:gs_backup
cls
call :colors 17
set cmdline=
set stage=5-1
title ¦w¸Ë L2JTW DP - ³Æ¥÷¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¥¿¦b³Æ¥÷¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w...
set cmdline="%mysqldumpPath%" --add-drop-table -h %gshost% -u %gsuser% --password=%gspass% %gsdb% ^> "%backup%\gs_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto gs_db_ok

:gs_err1
cls
set gsdbprompt=y
call :colors 47
set stage=5-2
title ¦w¸Ë L2JTW DP - ¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w³Æ¥÷¥¢±Ñ¡I¡]¶¥¬q %stage%¡^
echo.
echo ³Æ¥÷¥¢±Ñ¡I
echo ì¦]¬O¦]¬°¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¤£¦s¦b
echo ²{¦b¥i¥HÀ°§A«Ø¥ß %gsdb%¡A©ÎªÌÄ~Äò¨ä¥¦³]©w
echo.
echo «Ø¥ß¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¡H
echo.
echo (y)½T©w
echo.
echo (n)¨ú®ø
echo.
echo (r)«·s³]©w
echo.
echo (q)°h¥X
echo.
set /p gsdbprompt=½Ð¿ï¾Ü¡]¹w³]È-½T©w¡^:
if /i %gsdbprompt%==y goto gs_db_create
if /i %gsdbprompt%==n goto eof
if /i %gsdbprompt%==r goto configure
if /i %gsdbprompt%==q goto end
goto gs_err1

:gs_db_create
cls
call :colors 17
set stage=6-1
set cmdline=
title ¦w¸Ë L2JTW DP - «Ø¥ß¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ¡]¶¥¬q %stage%¡^
echo.
echo ¥¿¦b«Ø¥ß¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w...
set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -e "CREATE DATABASE %gsdb%" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto gs_db_ok
if %safe_mode% == 1 goto omfg

:gs_err2
cls
set omfgprompt=q
call :colors 47
set stage=6-2
title ¦w¸Ë L2JTW DP - ¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w«Ø¥ß¥¢±Ñ¡I¡]¶¥¬q %stage%¡^
echo.
echo ¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w«Ø¥ß¥¢±Ñ¡I
echo.
echo ¥i¯àªºì¦]¡G
echo 1.¿é¤Jªº¸ê®Æ¿ù»~¡A¨Ò¦p¡G¨Ï¥ÎªÌ¦WºÙ/¨Ï¥ÎªÌ±K½X/¨ä¥L¬ÛÃö¸ê®Æ
echo 2.¨Ï¥ÎªÌ¡u%gsuser%¡vªºÅv¤£¨¬
echo 3.¸ê®Æ®w¤w¦s¦b
echo.
echo ½ÐÀË¬d³]©w¨Ã¥B×¥¿¡A©ÎªÌª½±µ«·s³]©w
echo.
echo (r)«·s³]©w
echo.
echo (q)°h¥X
echo.
set /p omfgprompt=½Ð¿ï¾Ü¡]¹w³]È-°h¥X¡^:
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto gs_err2

:gs_db_ok
cls
set installtype=u
call :colors 17
set stage=6-3
title ¦w¸Ë L2JTW DP - ¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¦w¸Ë¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¡G
echo.
echo (f)§¹¾ã¡G±N²¾°£©Ò¦³ÂÂªº¸ê®Æ¡A«·s¾É¤J·sªº¸ê®Æ
echo.
echo (u)§ó·s¡G±N«O¯d©Ò¦³ÂÂªº¸ê®Æ¡A¨Ã¥B¶i¦æ§ó·s§@·~
echo.
echo (s)¬Ù²¤¡G¸õ¹L¦¹¿ï¶µ
echo.
echo (q)°h¥X
echo.
set /p installtype=½Ð¿ï¾Ü¡]¹w³]È-§ó·s¡^:
if /i %installtype%==f goto gs_cleanup
if /i %installtype%==u goto gs_upgrade
if /i %installtype%==s goto custom_ask
if /i %installtype%==q goto end
goto gs_db_ok

:gs_cleanup
call :colors 17
set cmdline=
set stage=6-4
title ¦w¸Ë L2JTW DP - §¹¾ã¦w¸Ë¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¡]¶¥¬q %stage%¡^
echo.
echo ¥¿¦b²¾°£¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¡AµM«á¾É¤J·sªº¸ê®Æ®w...
set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< gs_cleanup.sql 2^> NUL
%cmdline%
if not %ERRORLEVEL% == 0 goto omfg
set full=1
echo.
echo ¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¤w³Q§R°£
goto gs_install

:gs_upgrade
cls
echo.
echo §ó·s¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®wµ²ºc
echo.
echo @echo off> temp.bat
if exist gs_errors.log del gs_errors.log
for %%i in (..\sql\game\updates\*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% --force ^< %%i 2^>^> gs_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move gs_errors.log %workdir%
goto gs_install

:gs_install
cls
set cmdline=
if %full% == 1 (
set stage=6-5
title ¦w¸Ë L2JTW DP - ¦w¸Ë¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w...¡]¶¥¬q %stage%¡^
echo.
echo ¦w¸Ë·sªº¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¤º®e
echo.
) else (
title ¦w¸Ë L2JTW DP - §ó·s¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w...¡]¶¥¬q %stage%¡^
echo.
echo §ó·s¡u¹CÀ¸¦øªA¾¹¡vªº¸ê®Æ®w¤º®e
echo.
)
if %logging% == 0 set output=NUL
set dest=gs
for %%i in (..\sql\game\*.sql) do call :dump %%i
for %%i in (..\sql\game\mods\*.sql) do call :dump %%i
for %%i in (..\sql\game\custom\*.sql) do call :dump %%i
for %%i in (..\sql\L2JTW\*.sql) do call :dump %%i

echo §¹¦¨...
echo.
set charprompt=y
set /p charprompt=¦w¸Ë¡uNPC/ª««~/§Þ¯àµ¥¦WºÙ¡v¤¤¤å¤Æ: (y) ½T©w ©Î (N) ¨ú®ø¡H¡]¹w³]È-½T©w¡^:
if /i %charprompt%==n goto custom_ask
for %%i in (..\sql\L2JTW_2\*.sql) do call :dump %%i
echo §¹¦¨...
echo.
echo ¡¸ª`·N¡G³¡¤À¨t²Î¦w¸Ë¤¤¤å¤Æ·|¥¢±Ñ¡A¾ÉP¹CÀ¸¤¤¥X²{¶Ã½X
echo ¡@¡@¡@¡@¦pªG¹J¨ì³oºØ±¡§Î¡A½Ð¦A¤â°Ê¾É¤J SQL ¸Ì±ªº
echo ¡@¡@¡@¡@skill_tw / item_tw / messagetable ³o 3 Ó SQL
goto custom_ask

:dump
set cmdline=
if /i %full% == 1 (set action=¦w¸Ë) else (set action=§ó·s)
echo %action% %1>>"%output%"
echo %action% %~nx1
if "%dest%"=="ls" set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% ^< %1 2^>^>"%output%"
if "%dest%"=="cb" set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< %1 2^>^>"%output%"
if "%dest%"=="gs" set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %1 2^>^>"%output%"
%cmdline%
if %logging%==0 if NOT %ERRORLEVEL%==0 call :omfg2 %1
goto :eof

:omfg2
REM ------------------------------------------------------
REM ¸ê®Æ®w¦w¸Ë¹Lµ{¤¤µo¥Í¿ù»~
set dp_err=2
echo ¸ê®Æ®w¦w¸Ë¹Lµ{¤¤µo¥Í¿ù»~¡GErtheia> ..\doc\L2J_DataPack_Ver.txt
REM ------------------------------------------------------
cls
set ntpebcak=c
call :colors 47
title ¦w¸Ë L2JTW DP - ¶¥¬q %stage% µo¥Í¿ù»~
echo.
echo ¥X²{¿ù»~¡G
echo %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb%
echo.
echo ÀÉ®× %~nx1
echo.
echo ³B²z¤è¦¡¡H
echo.
echo (l)Àx¦s¿ù»~°T®§¡A¥H¤è«K¬d¸ß
echo.
echo (c)Ä~Äò
echo.
echo (r)«·s³]©w
echo.
echo (q)°h¥X
echo.
set /p ntpebcak=½Ð¿ï¾Ü¡]¹w³]È-Ä~Äò¡^:
if /i %ntpebcak%==c (call :colors 17 & goto :eof)
if /i %ntpebcak%==l (call :logginon %1 & goto :eof)
if /i %ntpebcak%==r set dp_err=0
if /i %ntpebcak%==r (call :configure & exit)
if /i %ntpebcak%==q (call :end)
goto omfg2

:logginon
cls
call :colors 17
title ¦w¸Ë L2JTW DP - Àx¦s¿ù»~°T®§
set logging=1
if %full% == 1 (
  set output=%logdir%\install-%~nx1.log
) else (
  set output=%logdir%\upgrade-%~nx1.log
)
echo.
echo ·Ç³ÆÀx¦s¿ù»~°T®§
echo.
echo ÀÉ®×¬°¡u%output%¡v
echo.
echo ¦pªG¦¹ÀÉ®×¤w¦s¦b¡A½Ð¶i¦æ³Æ¥÷¡A§_«h±N·|ÂÐ»\¹L¥h
echo.
pause
set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^<..\sql\%1 2^>^>"%output%"
date /t >"%output%"
time /t >>"%output%"
%cmdline%
echo Àx¦s¿ù»~°T®§...
call :colors 17
set logging=0
set output=NUL
goto :eof

:custom_ask
set stage=7
title ¦w¸Ë L2JTW DP - custom ¦Ûq¸ê®Æªí¡]¶¥¬q %stage%¡^
cls
set cstprompt=y
echo.
echo custom ¦Ûq¸ê®Æªí¥[¤J¸ê®Æ®w§¹¦¨
echo ©Ò¦³¿ù»~°T®§±NÀx¦s¦b¡ucustom_errors.log¡v
echo.
echo ½Ðª`·N¡A¦pªGn¨Ï³o¨Ç¦Ûq¸ê®Æªí¯à°÷±Ò¥Î
echo §A¥²¶·×§ï config ªºÀÉ®×³]©w
echo.
set /p cstprompt=¦w¸Ë custom ¦Ûq¸ê®Æªí: (y) ½T©w ©Î (N) ¨ú®ø¡]¹w³]È-½T©w¡^:
if /i %cstprompt%==y goto custom_install
if /i %cstprompt%==n goto mod_ask

:custom_install
cls
echo.
echo ¦w¸Ë custom ¦Ûq¤º®e
echo @echo off> temp.bat
if exist custom_errors.log del custom_errors.log
for %%i in (..\sql\game\custom\*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> custom_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move custom_errors.log %workdir%
goto mod_ask

:mod_ask
set stage=8
title ¦w¸Ë L2JTW DP - Mod ¦Ûq¸ê®Æªí¡]¶¥¬q %stage%¡^
cls
set cstprompt=y
echo.
echo Mod ¦Ûq¸ê®Æªí¥[¤J¸ê®Æ®w§¹¦¨
echo ©Ò¦³¿ù»~¸ê°T±N©ñ¤J¡umod_errors.log¡v
echo.
echo ½Ðª`·N¡A¦pªGn¨Ï³o¨Ç¦Ûq¸ê®Æªí¯à°÷±Ò¥Î
echo §A¥²¶·×§ï config ªºÀÉ®×³]©w
echo.
echo.
set /p cstprompt=¦w¸Ë Mods ¦Ûq¸ê®Æªí: (y) ½T©w ©Î (N) ¨ú®ø¡]¹w³]È-½T©w¡^:
if /i %cstprompt%==y goto mod_install
if /i %cstprompt%==n goto end

:mod_install
cls
echo.
echo ¦w¸Ë Mods ¦Ûq¤º®e
echo @echo off> temp.bat
if exist mods_errors.log del mods_errors.log
for %%i in (..\sql\game\mods\*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> mods_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move mods_errors.log %workdir%
REM ------------------------------------------------------
REM ¸ê®Æ®w¦w¸Ë§¹¦¨
if %dp_err% == 0 set dp_err=1
REM ------------------------------------------------------
goto end

:omfg
REM ------------------------------------------------------
REM ¸ê®Æ®w¦w¸Ë¹Lµ{¤¤µo¥Í¿ù»~
set dp_err=2
echo ¸ê®Æ®w¦w¸Ë¹Lµ{¤¤µo¥Í¿ù»~¡GErtheia> ..\doc\L2J_DataPack_Ver.txt
REM ------------------------------------------------------
set omfgprompt=q
call :colors 57
cls
title ¦w¸Ë L2JTW DP - ¶¥¬q %stage% µo¥Í¿ù»~
echo.
echo °õ¦æ®É¥X²{¿ù»~¡G
echo.
echo "%cmdline%"
echo.
echo «ØÄ³ÀË¬d¤@¤U³]©wªº¸ê®Æ¡A¥H½T«O©Ò¦³¿é¤Jªº¼ÆÈ¨S¦³¿ù»~¡I
echo.
if %stage% == 1 set label=ls_err1
if %stage% == 2 set label=ls_err2
if %stage% == 3 set label=cs_err1
if %stage% == 4 set label=cs_err2
if %stage% == 5 set label=gs_err1
if %stage% == 6 set label=gs_err2
echo.
echo (c)Ä~Äò
echo.
echo (r)«·s³]©w
echo.
echo (q)°h¥X
echo.
set /p omfgprompt=½Ð¿ï¾Ü¡]¹w³]È-°h¥X¡^:
if /i %omfgprompt%==c goto %label%
if /i %omfgprompt%==r set dp_err=0
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto omfg

:binaryfind
if EXIST "%mysqlBinPath%" (echo §ä¨ìªº MySQL) else (echo ¨S¦³§ä¨ì MySQL¡A½Ð¦b¤U±¿é¤J¥¿½Tªº¦ì¸m...)
goto :eof

:end
REM ------------------------------------------------------
REM Àx¦s DP ¤ä´©ªºª©¥»¸ê°T
if %dp_err% == 0 echo ¸ê®Æ®w¦w¸Ë¥¼§¹¦¨¡GErtheia> ..\doc\L2J_DataPack_Ver.txt
if %dp_err% == 1 echo Ertheia> ..\doc\L2J_DataPack_Ver.txt
REM ------------------------------------------------------
call :colors 17
title ¦w¸Ë L2JTW DP - §¹¦¨
cls
echo.
echo L2JTW DP ¦w¸Ë§¹²¦
echo.
echo ·PÁÂ¨Ï¥Î L2JTW ¦øªA¾¹
echo ¬ÛÃö¸ê°T¥i¥H¦b http://www.l2jtw.com¬d¸ß¨ì
echo.
pause

kyosume · January 13, 2015

l2jtw....This project is dead and not even close to a start build.

Zake · April 5, 2015

First of all, idk if mxc provides support for such projects, but where is the error?

'Baggos' · April 5, 2015

if mxc provides support

We are on 2015 Zake..

Time to move on.

Zake · April 6, 2015

We are on 2015 Zake..

Time to move on.

Well i guess this "Ertheia" is a new client right?

Edited April 6, 2015 by Zake

'Baggos' · April 6, 2015

Well i guess this "Ertheia" is a new client right?

Exactly.. The newest client. :P

Zake · April 8, 2015

Well so let's get back on topic, where is the error?

Edited April 8, 2015 by Zake

Help Problem With Lineage2 Ertheia Datebase

Question

kiskiss

Link to comment

Share on other sites

6 answers to this question

Recommended Posts

kyosume

Link to comment

Share on other sites

Zake

Link to comment

Share on other sites

'Baggos'

Link to comment

Share on other sites

Zake

Link to comment

Share on other sites

'Baggos'

Link to comment

Share on other sites

Zake

Link to comment

Share on other sites

Join the conversation

Posts

Topics

Browse

Activity

Store