- 0
-
Posts
-
Hello. You may encounter the Push item fail error when trying to pick up an item dropped on the ground by a mob. or You can throw something out of your inventory and pick it up again, several times. Probably this is a quantum dependency) I don't understand at what point this happens, sometimes two items one after another experience push item errors, and sometimes I don't have enough thousands of attempts to repeat this trick) In any case, this is just a visual error and after the relog, the item appears in the inventory. I think first i need to disconnect the extender and check it on a bare server. I still need time to check this, maybe it's not even about the autoloot function. https://youtu.be/6mcfmdImofE ----------- In general, I would like to thank our wonderful Emca Eressea for her deep knowledge in programming and reverse engineering. And for the fact that her work is open to everyone, this is very amazing, and incredibly valuable. -
By Tinker123aa · Posted
Hello, I see that the price seems expensive, those who are interested, you can make your bid from 1000usd, the highest bidder will keep it. -
.png.d2878e0ddf398e6d741f0d921247bb17.thumb.png.3598dbb90aef6a9a62710d1724bc23b3.png)
By DiscordOGE · Posted
https://discord0ld.mysellix.io/ -
By iamcommand · Posted
WTS: TH 45 Necro 46 PP 46 SE 46 BD 44 All with mails. Adena Eminence bow Any top C luxor weapon discord : xeenthekeen -
ADENA 500 K = 40e 1kk = 70e 3kk = 190e ITEMS staff of life = 150e karmian set = 90e elven jewls top D = 30e Orcish Poleaxe+1 best C pole = 680e any D grade armor on demand discord wiz0642_81242
-
-
-
-
Topics
-
Question
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ª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 «Ø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. pause6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.