MiniDesant 0 Опубликовано 9 августа, 2014 Всем добрый день,подскажите пожалуйста решил поставить сборку эпилога от L2J столкнулся с проблемой заливки базы открыл database_installer и настроил так как у меня но все равно выдает ошибку подскажите в чем не правильно? @echo off REM ############################################## REM ## L2DC Database Installer - (by DrLecter) ## REM ############################################## REM ## Interactive script setup - (by TanelTM) ## REM ############################################## REM Copyright © 2010 L2DC DataPack REM This program 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 2 of the License, or (at REM your option) any later version. REM REM This program is distributed in the hope that it will be useful, but REM WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY REM or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License REM for more details. REM REM You should have received a copy of the GNU General Public License along REM with this program; if not, write to the Free Software Foundation, Inc., REM 675 Mass Ave, Cambridge, MA 02139, USA. Or contact the Official L2DC REM DataPack Project at http://www.l2dcproject.com or REM #l2dragonclaw @ irc://irc.freenode.net set config_file=vars.txt set config_version=0 set workdir="%cd%" set full=0 set stage=0 set logging=0 set upgrade_mode=0 set backup=. set logdir=. set safe_mode=1 set cmode=c set fresh_setup=0 :loadconfig title L2DC Installer - Reading configuration from file... cls 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_section set upgrade_mode=2 echo It seems to be the first time you run this version of echo database_installer but I found a settings file already. echo I'll hopefully ask this questions just once. echo. echo Configuration upgrade options: echo. echo (1) Import and continue: I'll read your old settings and echo continue execution, but since no new settings will be echo saved, you'll see this menu again next time. echo. echo (2) Import and configure: This tool has some new available echo options, you choose the values that fit your needs echo using former settings as a base. echo. echo (3) Ignose stored settings: I'll let you configure me echo with a fresh set of default values as a base. echo. echo (4) View saved settings: See the contents of the config echo file. echo. echo (5) Quit: Did you came here by mistake? echo. set /P upgrade_mode="Type a number, press Enter (default is '%upgrade_mode%'): " if %upgrade_mode%==1 goto ls_section 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 call :colors 17 title L2DC Installer - Setup cls set config_version=2 if NOT %upgrade_mode% == 2 ( set fresh_setup=1 set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.5\bin set lsuser=root set lspass=12345 set lsdb=l2jdb set lshost=localhost set cbuser=root set cbpass=12345 set cbdb=l2jcb set cbhost=localhost set gsuser=root set gspass=12345 set gsdb=l2jdb set gshost=localhost set cmode=c set backup=. set logdir=. ) set mysqlPath=%mysqlBinPath%\mysql.exe echo New settings will be created for this tool to run in echo your computer, so I need to ask you some questions. echo. echo 1-MySql Binaries echo -------------------- echo In order to perform my tasks, I need the path for commands echo such as 'mysql' and 'mysqldump'. Both executables are echo usually stored in the same place. echo. if "%mysqlBinPath%" == "" ( set mysqlBinPath=use path echo I can't determine if the binaries are available with your echo default settings. ) else ( echo I can try to find out if the current setting actually works... echo. echo %mysqlPath% ) if not "%mysqlBinPath%" == "use path" call :binaryfind echo. path|find "MySQL">NUL if %errorlevel% == 0 ( echo I found MySQL is in your PATH, this will be used by default. echo If you want to use something different, change 'use path' for echo something else. set mysqlBinPath=use path ) else ( echo Look, I can't find "MYSQL" in your PATH environment variable. echo It would be good if you go and find out where "mysql.exe" and echo "mysqldump.exe" are. echo. echo If you have no idea about the meaning of words such as MYSQL echo or PATH, you'd better close this window, and consider googling echo and reading about it. Setup and host an L2DC server requires a echo minimum of technical skills. ) echo. echo Write the path to your MySQL binaries (no trailing slash needed): set /P mysqlBinPath="(default %mysqlBinPath%): " cls echo. echo 2-LoginServer settings echo -------------------- echo I will connect to the MySQL server you specify, and setup a echo Loginserver database there, most people use a single MySQL echo server and database for both Login and Gameserver tables. echo. set /P lsuser="MySQL Username (default is '%lsuser%'): " set /P lspass="Password (will be shown as you type, default '%lspass%'): " set /P lsdb="Database (default is '%lsdb%'): " set /P lshost="Host (default is '%lshost%'): " if NOT "%lsuser%"=="%gsuser%" set gsuser=%lsuser% if NOT "%lspass%"=="%gspass%" set gspass=%lspass% if NOT "%lsdb%"=="%gsdb%" set gsdb=%lsdb% if NOT "%lshost%"=="%gshost%" set gshost=%lshost% echo. cls echo. echo 3-Community Board Server settings echo -------------------- echo I will connect to the MySQL server you specify, and setup a echo Community Board server database there, most people use a single MySQL echo server for both Login and Gameserver which CBserver can use too, echo but CBserver requires a different database! echo. set /P cbuser="MySQL Username (default is '%cbuser%'): " set /P cbpass="Password (will be shown as you type, default '%cbpass%'): " set /P cbdb="Database (default is '%cbdb%'): " set /P cbhost="Host (default is '%cbhost%'): " echo. echo 4-GameServer settings echo -------------------- set /P gsuser="User (default is '%gsuser%'): " set /P gspass="Pass (default is '%gspass%'): " set /P gsdb="Database (default is '%gsdb%'): " set /P gshost="Host (default is '%gshost%'): " echo. echo 5-Misc. settings echo -------------------- set /P cmode="Color mode ©olor or (n)on-color, default %cmode% : " set /P backup="Path for your backups (default '%backup%'): " set /P logdir="Path for your logs (default '%logdir%'): " :safe1 set safemode=y set /P safemode="Debugging messages and increase verbosity a lil bit (y/n, default '%safemode%'): " if /i %safemode%==y (set safe_mode=1&goto safe2) if /i %safemode%==n (set safe_mode=0&goto safe2) goto safe1 :safe2 echo. if "%mysqlBinPath%" == "use path" ( set mysqlBinPath= set mysqldumpPath=mysqldump set mysqlPath=mysql ) else ( set mysqldumpPath=%mysqlBinPath%\mysqldump.exe set mysqlPath=%mysqlBinPath%\mysql.exe ) echo @echo off > %config_file% echo set config_version=%config_version% >> %config_file% echo set cmode=%cmode%>> %config_file% echo set safe_mode=%safe_mode% >> %config_file% echo set mysqlPath=%mysqlPath%>> %config_file% echo set mysqlBinPath=%mysqlBinPath%>> %config_file% echo set mysqldumpPath=%mysqldumpPath%>> %config_file% echo set lsuser=%lsuser%>> %config_file% echo set lspass=%lspass%>> %config_file% echo set lsdb=%lsdb%>> %config_file% echo set lshost=%lshost% >> %config_file% echo set 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 Script setup complete, your settings were saved in the echo '%config_file%' file. Remember: your passwords are stored echo as clear text. echo. echo press any key to continue... pause> nul goto loadconfig :ls_section cls call :colors 17 set cmdline= set stage=1 title L2DC Installer - Login Server database setup echo. echo Trying to make a backup of your loginserver database. set cmdline="%mysqldumpPath%" --add-drop-table -h %lshost% -u %lsuser% --password=%lspass% %lsdb% ^> "%backup%\loginserver_backup.sql" 2^> NUL %cmdline% if %ERRORLEVEL% == 0 goto lsdbok if %safe_mode% == 1 goto omfg :ls_err1 call :colors 47 title L2DC Installer - Login Server database setup ERROR!!! cls echo. echo Backup attempt failed! A possible reason for this to echo happen, is that your DB doesn't exist yet. I could echo try to create %lsdb% for you, or maybe you prefer to echo proceed with the CommunityServer part of this tool. echo. :ls_ask1 set lsdbprompt=y echo ATTEMPT TO CREATE LOGINSERVER DATABASE: echo. echo (y)es echo. echo (n)o echo. echo ®econfigure echo. echo (q)uit echo. set /p lsdbprompt= Choose (default yes): if /i %lsdbprompt%==y goto lsdbcreate if /i %lsdbprompt%==n goto cb_backup if /i %lsdbprompt%==r goto configure if /i %lsdbprompt%==q goto end goto ls_ask1 :omfg cls call :colors 57 title L2DC Installer - potential PICNIC detected at stage %stage% echo. echo There was some problem while executing: echo. echo "%cmdline%" echo. echo I'd suggest you to look for correct values and try this echo script again later. But maybe you'd prefer to go on now. echo. if %stage% == 1 set label=ls_err1 if %stage% == 2 set label=ls_err2 if %stage% == 3 set label=cb_backup if %stage% == 4 set label=cb_err1 if %stage% == 5 set label=cb_err2 if %stage% == 6 set label=gs_backup if %stage% == 7 set label=gs_err1 if %stage% == 8 set label=gs_err2 if %stage% == 9 set label=horrible_end if %stage% == 10 set label=horrible_end :omfgask1 set omfgprompt=q echo ©ontinue running the script echo. echo ®econfigure echo. echo (q)uit now echo. set /p omfgprompt= Choose (default quit): if /i %omfgprompt%==c goto %label% if /i %omfgprompt%==r goto configure if /i %omfgprompt%==q goto horrible_end goto omfgask1 :lsdbcreate call :colors 17 set cmdline= set stage=2 title L2DC Installer - Login Server database setup - DB Creation echo. echo Trying to create a Login Server database... set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -e "CREATE DATABASE %lsdb%" 2^> NUL %cmdline% if %ERRORLEVEL% == 0 goto logininstall if %safe_mode% == 1 goto omfg :ls_err2 call :colors 47 title L2DC Installer - Login Server database setup - DB Creation error cls echo An error occured while trying to create a database for echo your login server. echo. echo Possible reasons: echo 1-You provided innacurate info , check user, password, etc. echo 2-User %lsuser% don't have enough privileges for echo database creation. Check your MySQL privileges. echo 3-Database exists already...? echo. echo Unless you're sure that the pending actions of this tool echo could work, i'd suggest you to look for correct values echo and try this script again later. echo. :ls_ask2 set omfgprompt=q echo ©ontinue running echo. echo ®econfigure echo. echo (q)uit now echo. set /p omfgprompt= Choose (default quit): if /i %omfgprompt%==c goto cb_backup if /i %omfgprompt%==q goto horrible_end if /i %omfgprompt%==r goto configure goto ls_ask2 :lsdbok call :colors 17 title L2DC Installer - Login Server database setup - WARNING!!! echo. :asklogin if %fresh_setup%==0 ( set loginprompt=s set msg=default skip ) else ( set loginprompt=x set msg=no default for fresh install ) echo LOGINSERVER DATABASE install type: echo. echo (f)ull: I will destroy data in your `accounts` and echo and `gameserver` tables. echo. echo (s)kip: I'll take you to the communityserver database echo installation and upgrade options. echo. echo ®econfigure: You'll be able to redefine MySQL path, echo user and database information and start over with echo those fresh values. echo. echo (q)uit echo. set /p loginprompt= Choose (%msg%) : if /i %loginprompt%==f goto logininstall if /i %loginprompt%==s goto cb_backup if /i %loginprompt%==r goto configure if /i %loginprompt%==q goto end goto asklogin :logininstall set stage=3 call :colors 17 set cmdline= title L2DC Installer - Login Server database setup - Full install echo Deleting loginserver tables for new content. set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% ^< login_install.sql 2^> NUL %cmdline% if not %ERRORLEVEL% == 0 goto omfg set full=1 goto cb_backup :cb_backup cls call :colors 17 set cmdline= if %full% == 1 goto communityinstall set stage=4 title L2DC Installer - Community Board Server database setup echo. echo Trying to make a backup of your cbserver database. set cmdline="%mysqldumpPath%" --add-drop-table -h %cbhost% -u %cbuser% --password=%cbpass% %cbdb% ^> "%backup%\cbserver_backup.sql" 2^> NUL %cmdline% if %ERRORLEVEL% == 0 goto cbdbok REM if %safe_mode% == 1 goto omfg :cb_err1 call :colors 47 title L2DC Installer - Community Board Server database setup ERROR!!! cls echo. echo Backup attempt failed! A possible reason for this to echo happen, is that your DB doesn't exist yet. I could echo try to create %cbdb% for you, or maybe you prefer to echo proceed with the GameServer part of this tool. echo. :cb_ask1 set cbdbprompt=y echo ATTEMPT TO CREATE COMMUNITYSERVER DATABASE: echo. echo (y)es echo. echo (n)o echo. echo ®econfigure echo. echo (q)uit echo. set /p cbdbprompt= Choose (default yes): if /i %cbdbprompt%==y goto cbdbcreate if /i %cbdbprompt%==n goto gs_backup if /i %cbdbprompt%==r goto configure if /i %cbdbprompt%==q goto end goto cb_ask1 :cbdbcreate call :colors 17 set cmdline= set stage=5 title L2DC Installer - Communty Board Server database setup - DB Creation echo. echo Trying to create a Community Board Server database... set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -e "CREATE DATABASE %cbdb%" 2^> NUL %cmdline% if %ERRORLEVEL% == 0 goto communityinstall if %safe_mode% == 1 goto omfg :cb_err2 call :colors 47 title L2DC Installer - Community Board Server database setup - DB Creation error cls echo An error occured while trying to create a database for echo your Community Board server. echo. echo Possible reasons: echo 1-You provided innacurate info , check user, password, etc. echo 2-User %cbuser% don't have enough privileges for echo database creation. Check your MySQL privileges. echo 3-Database exists already...? echo. echo Unless you're sure that the pending actions of this tool echo could work, i'd suggest you to look for correct values echo and try this script again later. echo. :cb_ask2 set omfgprompt=q echo ©ontinue running echo. echo ®econfigure echo. echo (q)uit now echo. set /p omfgprompt= Choose (default quit): if /i %omfgprompt%==c goto gs_backup if /i %omfgprompt%==q goto horrible_end if /i %omfgprompt%==r goto configure goto cb_ask2 :cbdbok call :colors 17 title L2DC Installer - Community Board Server database setup - WARNING!!! echo. :askcommunity if %fresh_setup%==0 ( set communityprompt=s set msg=default skip ) else ( set communityprompt=x set msg=no default for fresh install ) echo COMMUNITYSERVER DATABASE install type: echo. echo (f)ull: WARNING! I'll destroy ALL of your existing community echo data (i really mean it: mail, forum, memo.. ALL) echo. echo (u)pgrade: I'll do my best to preserve all of your community echo data. echo. echo (s)kip: I'll take you to the gameserver database echo installation and upgrade options. echo. echo ®econfigure: You'll be able to redefine MySQL path, echo user and database information and start over with echo those fresh values. echo. echo (q)uit echo. set /p communityprompt= Choose (%msg%) : if /i %communityprompt%==f goto communityinstall if /i %communityprompt%==u goto upgradecbinstall if /i %communityprompt%==s goto gs_backup if /i %communityprompt%==r goto configure if /i %communityprompt%==q goto end goto askcommunity :communityinstall set stage=6 call :colors 17 set cmdline= title L2DC Installer - Community Board Server database setup - Full install echo Deleting communityserver tables for new content. set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< community_install.sql 2^> NUL %cmdline% if not %ERRORLEVEL% == 0 goto omfg goto upgradecbinstall :upgradecbinstall set stage=6 set cmdline= if %full% == 1 ( title L2DC Installer - Community Board Server database setup - Installing... echo Installing new communityserver content. ) else ( title L2DC Installer - Community Board Server database setup - Upgrading... echo Upgrading communityserver content. ) if %logging% == 0 set output=NUL set dest=cb for %%i in ( clan_introductions.sql comments.sql forums.sql registered_gameservers.sql posts.sql topics.sql ) do call :dump %%i echo done... echo. goto gs_backup :gs_backup cls call :colors 17 set cmdline= if %full% == 1 goto fullinstall set stage=7 title L2DC Installer - Game server database setup cls echo. echo Making a backup of the original gameserver database. set cmdline="%mysqldumpPath%" --add-drop-table -h %gshost% -u %gsuser% --password=%gspass% %gsdb% ^> "%backup%\gameserver_backup.sql" 2^> NUL %cmdline% if %ERRORLEVEL% == 0 goto gsdbok rem if %safe_mode% == 1 goto omfg :gs_err1 call :colors 47 title L2DC Installer - Game Server database setup - Backup failed! cls echo. echo Backup attempt failed! A possible reason for this to happen, echo is that your DB doesn't exist yet. I could try to create echo %gsdb% for you, but maybe you prefer me to continue with echo last part of the script. echo. :askgsdb set gsdbprompt=y echo ATTEMPT TO CREATE GAMESERVER DATABASE? echo. echo (y)es echo. echo (n)o echo. echo ®econfigure echo. echo (q)uit echo. set /p gsdbprompt= Choose (default yes): if /i %gsdbprompt%==y goto gsdbcreate if /i %gsdbprompt%==n goto horrible_end if /i %gsdbprompt%==r goto configure if /i %gsdbprompt%==q goto end goto askgsdb :gsdbcreate call :colors 17 set stage=8 set cmdline= title L2DC Installer - Game Server database setup - DB Creation cls echo Trying to create Game Server database... set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -e "CREATE DATABASE %gsdb%" 2^> NUL %cmdline% if %ERRORLEVEL% == 0 goto fullinstall if %safe_mode% == 1 goto omfg :gs_err2 call :colors 47 title L2DC Installer - Game Server database setup - DB Creation failed! cls echo. echo An error occured while trying to create a database for echo your game server. echo. echo Possible reasons: echo 1-You provided innacurate info, check username, pass, etc. echo 2-User %gsuser% don't have enough privileges for echo database creation. echo 3-Database exists already...? echo. echo I'd suggest you to look for correct values and try this echo script again later. But you can try to reconfigure it now. echo. :askgsdbcreate set omfgprompt=q echo ®estart script with fresh configuration values echo. echo (q)uit now echo. set /p omfgprompt= Choose (default quit): if /i %omfgprompt%==r goto configure if /i %omfgprompt%==q goto horrible_end goto askgsdbcreate :gsdbok call :colors 17 title L2DC Installer - Game Server database setup - WARNING!!! cls echo. :asktype set installtype=u echo GAMESERVER DATABASE install: echo. echo (f)ull: WARNING! I'll destroy ALL of your existing character echo data (i really mean it: items, pets.. ALL) echo. echo (u)pgrade: I'll do my best to preserve all of your character echo data. echo. echo (s)kip: We'll get into the last set of questions (cummulative echo updates, custom stuff...) echo. echo (q)uit echo. set /p installtype= Choose (default upgrade): if /i %installtype%==f goto fullinstall if /i %installtype%==u goto upgradeinstall if /i %installtype%==s goto custom if /i %installtype%==q goto end goto asktype :fullinstall call :colors 17 set stage=9 set cmdline= title L2DC Installer - Game Server database setup - Full install echo Deleting all gameserver tables for new content... set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< full_install.sql 2^> NUL %cmdline% if not %ERRORLEVEL% == 0 goto omfg set full=1 echo. echo Game Server tables were deleted. goto upgradeinstall :upgradeinstall set stage=9 set cmdline= if %full% == 1 ( title L2DC Installer - Game Server database setup - Installing... echo Installing new gameserver content. ) else ( title L2DC Installer - Game Server database setup - Upgrading... echo Upgrading gameserver content. ) if %logging% == 0 set output=NUL set dest=ls for %%i in ( accounts.sql account_data.sql gameservers.sql ) do call :dump %%i set dest=gs for %%i in ( admin_command_access_rights.sql airships.sql armorsets.sql auction_bid.sql auction_watch.sql auto_announcements.sql auto_chat.sql auto_chat_text.sql castle_door.sql castle_doorupgrade.sql castle_functions.sql castle_manor_procure.sql castle_manor_production.sql castle_siege_guards.sql char_creation_items.sql char_templates.sql character_hennas.sql character_instance_time.sql character_macroses.sql character_premium_items.sql character_quest_global_data.sql character_offline_trade_items.sql character_offline_trade.sql character_quests.sql character_quests_item.sql character_raid_points.sql character_recipebook.sql character_recipeshoplist.sql character_recommends.sql character_relations.sql character_shortcuts.sql character_skills.sql character_skills_save.sql character_subclasses.sql character_tpbookmark.sql character_ui_actions.sql character_ui_categories.sql characters.sql clan_data.sql clan_privs.sql clan_skills.sql clan_subpledges.sql clan_wars.sql clan_notices.sql clanhall_functions.sql clanhall_siege_spawns.sql class_list.sql cursed_weapons.sql dimensional_rift.sql droplist.sql enchant_skill_chances.sql fish.sql fishing_skill_trees.sql fort_doorupgrade.sql fort_functions.sql fort_siege_guards.sql fort_spawnlist.sql fort_staticobjects.sql fortsiege_clans.sql four_sepulchers_spawnlist.sql games.sql global_tasks.sql grandboss_list.sql helper_buff_list.sql henna.sql henna_trees.sql hero_diary.sql hero_matches.sql heroes.sql item_attributes.sql items.sql itemsonground.sql kamaloka_results.sql locations.sql lvlupgain.sql mails.sql mapregion.sql merchant_areas_list.sql merchant_buylists.sql merchant_lease.sql merchant_shopids.sql merchants.sql minions.sql npc.sql npc_buffer.sql npcAIData.sql npcskills.sql olympiad_data.sql olympiad_nobles.sql olympiad_nobles_eom.sql pets.sql pets_skills.sql pets_stats.sql pledge_skill_trees.sql posts.sql quest_global_data.sql raidboss_spawnlist.sql random_spawn.sql random_spawn_loc.sql scriptspawns_removed.sql seven_signs.sql siege_clans.sql skill_learn.sql skill_residential.sql skill_spellbooks.sql skill_trees.sql spawnlist.sql special_skill_trees.sql squad_skill_trees.sql teleport.sql topic.sql territories.sql territory_registrations.sql territory_spawnlist.sql transform_skill_trees.sql vanhalter_spawnlist.sql walker_routes.sql zone_vertices.sql ) do call :dump %%i if %full% == 1 ( for %%i in ( access_levels.sql auction.sql castle.sql clanhall.sql fort.sql forums.sql grandboss_data.sql hellbound_table.sql seven_signs_festival.sql seven_signs_status.sql ) do call :dump %%i ) echo done... echo. goto custom :dump set cmdline= if /i %full% == 1 (set action=Installing) else (set action=Upgrading) echo %action% %1>>"%output%" echo %action% %~nx1 if "%dest%"=="ls" set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% ^< ..\sql\%1 2^>^>"%output%" if "%dest%"=="cb" set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< ..\cb_sql\%1 2^>^>"%output%" if "%dest%"=="gs" set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< ..\sql\%1 2^>^>"%output%" %cmdline% if %logging%==0 if NOT %ERRORLEVEL%==0 call :omfg2 %1 goto :eof :omfg2 cls call :colors 47 title L2DC Installer - potential database issue at stage %stage% echo. echo Something caused an error while executing instruction : echo %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% echo. echo with file %~nx1 echo. echo What we should do now? echo. :askomfg2 set ntpebcak=c echo (l)og it: I will create a log for this file, then continue echo with the rest of the list in non-logging mode. echo. echo ©ontinue: Let's pretend that nothing happened and continue with echo the rest of the list. echo. echo ®econfigure: Perhaps these errors were caused by a typo. echo you can restart from scratch and redefine paths, databases echo and user info again. echo. echo (q)uit now echo. set /p ntpebcak= Choose (default continue): if /i %ntpebcak%==c (call :colors 17 & goto :eof) if /i %ntpebcak%==l (call :logginon %1 & goto :eof) if /i %ntpebcak%==r (call :configure & exit) if /i %ntpebcak%==q (call :horrible_end & exit) goto askomfg2 :logginon cls call :colors 17 title L2DC Installer - Game Server database setup - Logging options turned on set logging=1 if %full% == 1 ( set output=%logdir%\install-%~nx1.log ) else ( set output=%logdir%\upgrade-%~nx1.log ) echo. echo Per your request, i'll create a log file for your reading pleasure. echo. echo I'll call it %output% echo. echo If you already have such a file and would like to keep a copy. echo go now and read it or back it up, because it's not going to be rotated echo or anything, instead i'll just overwrite it. echo. echo When you're done or if you don't mind, press any key to start. pause>NUL set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^<..\sql\%1 2^>^>"%output%" date /t >"%output%" time /t >>"%output%" %cmdline% echo Log file created, resuming normal operations... call :colors 17 set logging=0 set output=NUL goto :eof :custom echo. set cstprompt=n set /p cstprompt=Install custom gameserver DB tables: (y) yes or (N) no or (q) quit? if /i %cstprompt%==y goto cstinstall if /i %cstprompt%==n goto newbie_helper if /i %cstprompt%==q goto end goto newbie_helper :cstinstall echo Installing custom content. cd ..\sql\custom\ echo @echo off> temp.bat if exist errors.txt del errors.txt for %%i in (*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> custom_errors.txt >> temp.bat call temp.bat> nul del temp.bat move custom_errors.txt %workdir% title L2DC Installer - Game Server database setup - custom tables processing complete cls echo Database structure for custom additions finished, i'm leaving a echo 'custom_errors.txt' file for your consideration. echo. echo Remember that in order to get these additions actually working echo you need to edit your configuration files. echo. pause cd %workdir% title L2DC Installer - Game Server database setup - L2DC Mods cls echo L2DC provides a basic infraestructure for some non-retail features echo (aka L2DC mods) to get enabled with a minimum of changes. echo. echo Some of these mods would require extra tables in order to work echo and those tables could be created now if you wanted to. echo. cd ..\sql\mods\ REM L2DC mods that needed extra tables to work properly, should be REM listed here. To do so copy & paste the following 4 lines and REM change them properly: REM MOD: Wedding. set modprompt=n set /p modprompt=Install "Wedding Mod" tables: (y) yes or (N) no? if /i %modprompt%==y "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < mods_wedding.sql 2>>NUL title L2DC Installer - Game Server database setup - L2DC Mods setup complete cls echo Database structure for L2DC mods finished. echo. echo Remember that in order to get these additions actually working echo you need to edit your configuration files. echo. pause cd %workdir% goto newbie_helper :newbie_helper call :colors 17 set stage=10 title L2DC Installer - Game/CB Server database setup - update SQL files cls if %full% == 1 goto end echo. echo In the sql/updates and cb_sql/updates folders, echo we use to store cummulative changes needed by echo the database structures. echo. echo Usually these SQL files are created whenever some new echo feature implementation requires it. echo. echo If you're too lame to know what these changes are about, echo i can try to apply these patches for you. :asknb set nbprompt=a echo. echo What we do with the files in sql/updates folder? echo. echo (a)utomagic processing: I'll get into the folders and echo try to dump _every_ '.sql' file i find there, into echo your database. A fresh setup wouldn't usually need echo such a thing. And, as any automagic task, this may echo pose a risk on your data. echo. echo automagi© processing: I'll do the automagic process echo only with the cb_sql/updates folder. echo. echo automa(g)ic processing: I'll do the automagic process echo only with the sql/updates folder. echo. echo (s)kip: I'll do nothing, it's up to you to find out echo which file does what, which one could be of use for echo you, etc. echo. set /p nbprompt= Choose (default auto): if /i %nbprompt%==a goto nbinstall if /i %nbprompt%==c goto nbcbinstall if /i %nbprompt%==g goto nbinstall if /i %nbprompt%==s goto end goto asknb :nbinstall cd ..\sql\updates\ echo @echo off> temp.bat if exist errors.txt del errors.txt for %%i in (*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> errors.txt >> temp.bat call temp.bat> nul del temp.bat move errors.txt %workdir% cd %workdir% if /i %nbprompt%==g goto nbfinished :nbcbinstall cd ..\cb_sql\updates\ echo @echo off> temp.bat if exist cberrors.txt del cberrors.txt for %%i in (*.sql) do echo "%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< %%i 2^>^> cberrors.txt >> temp.bat call temp.bat> nul del temp.bat move cberrors.txt %workdir% cd %workdir% :nbfinished title L2DC Installer - Game Server database setup - updates processing complete cls echo Automagic processing finished, i'm leaving an 'errors.txt' echo file for your consideration. echo. echo Remember that some of these files could have tried to add stuff that were echo part of your database structure already, so don't go out yelling about echo. echo 'Duplicate column name' echo. echo messages you may find there. echo. echo Rather you should focus in those that say echo. echo 'Table doesn't exist' echo. echo for example. echo. pause goto end :binaryfind if EXIST "%mysqlBinPath%" (echo Found) else (echo Not Found) goto :eof :horrible_end call :colors 47 title L2DC Installer - Oops! cls echo This wasn't a clean run, but don't worry. echo You can get help and support: echo. echo 1-Read the L2DC Datapack project wiki : echo (http://www.l2dcproject.com) echo 2-Search for a similar problem in our forums echo (http://www.l2dcproject.com) echo. echo You can ask for support in our forums or irc channel: echo irc://irc.freenode.net channel: #l2dragonclaw echo. echo I'll try to gather some versioning information that you echo may find useful when asking for support : echo. echo Datapack revision reported by 'SVN version': svnversion -n 2>NUL echo. if %ERRORLEVEL% == 9009 ( echo SVN commandline tools not found! echo Please download and install "Windows installer with echo the basic win32 binaries" (or something that fits our echo binaries needs) from : echo http://subversion.ti...ist?folderID=91 echo. ) set dpvf="..\config\l2dc-version.properties" echo Datapack revision reported by properties file : if NOT EXIST %dpvf% ( echo Your %dpvf% file is missing! echo Use eclipse/ant to build one from your DP SVN copy. echo With it we'll be able to help you better. ) else ( type %dpvf% | find "version" 2> NUL if not %ERRORLEVEL% == 0 ( echo An error occured while trying to read echo your %dpvf% file! echo Make sure you keep it up to date echo and in the correct place. echo %ERRORLEVEL% )) echo. rem del %config_file% pause goto end :end call :colors 17 title L2DC Installer - Script execution finished cls echo. echo L2DCDP database_installer version 0.2.2 echo © 2007-2010 L2DC Datapack Team echo database_installer comes with ABSOLUTELY NO WARRANTY; echo This is free software, and you are welcome to redistribute it echo under certain conditions; See the file gpl.txt for further echo details. echo. echo Thanks for using our software. echo visit http://www.l2dcproject.com for more info about echo the Official L2DC Datapack project. echo FOR MORE SQL ROWS, CHECK FOLDER "experimental" INTO "sql" FOLDER. echo. pause color А вот скрин ошибки Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
Angelika 622 Опубликовано 9 августа, 2014 если верно указали коннект к базе что под спойлером тыкайте кнопочку <r> и там запросит конфигурации - просто жмете энтер и подтверждаете ( прописать ручками если отличалось от варианта по дефолту ) потом сможете залить свою базу . Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
MiniDesant 0 Опубликовано 9 августа, 2014 если верно указали коннект к базе что под спойлером тыкайте кнопочку <r> и там запросит конфигурации - просто жмете энтер и подтверждаете ( прописать ручками если отличалось от варианта по дефолту ) потом сможете залить свою базу . пробовал уже не однакратно это делать,и сам писать пробовал и просто по дефолту пропускал все равно окончательный результат такой же что и на скрине,адрес MySQL указан верно,пароль,логин все проверил все верно не пойму в чем проблема может быть( Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
zedkill 16 Опубликовано 28 сентября, 2014 (изменено) Накосячил в скрипте, возьми с архива чистый bat и создай у себя базу и юзера как батнике, в самом батнике не чего не меняй ! Должно помочь. Изменено 28 сентября, 2014 пользователем zedkill Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
