kiskiss

New server is open for beta test PVP 1000x

Very good sever, just need more players.

If you have any questions tell me here! More info soon! Note: Website and game status will be edited when it change, they're color is green for you to know. [Website Status: Soon it work...] [Comment: ]------> We apologize for downtime, please be patient! [Game Status: Soon it work... ] (Problem: On the 4th April 2015, Our server, were hacked and downed by an anonymous source. We are working hard to maintain the servers and put them backup and running. Note: Updates will be write here, they're color is yellow! Working instances: Ruby Sanctum,Eye of Eternity,Naxxramas...

About server: Sunstrider is 3.3.5a Wrath of the Lich King progressive PVP & PVE Server Following our successful Beta Launch, the server is now live Available for all players The server is focused on the PVP Aspects of the game, But offering a lot to PVE lovers. Realm Info: Progressive raiding PVP Tournaments Dedicated Staff No pay-to-win 20x XP rate Powerful specs Website: http://sunstriderwow.cu.cc/ Realm list: set realmlist 134.255.219.146 We are soo sorry for soo long downtime, but it seems then owner is on vacation for few days, I'll let you know ;) Server is setting up by new owner. Previous owner now is co-owner.

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