Help Problem With Lineage2 Ertheia Datebase

[kiskiss]

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ªG­n¨Ï³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ªG­n¨Ï³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 «ØijÀˬ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]

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

[Zake]

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

['Baggos']

 if mxc provides support

We are on 2015 Zake..

Time to move on.

[Zake]

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']

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

Exactly.. The newest client. :P

[Zake]

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

Edited April 8, 2015 by Zake