L2J Server

Code: Select all

@echo offREM ##############################################REM ## L2JDP Database Installer - (by DrLecter) ##REM ##############################################REM ## Interactive script setup -  (by TanelTM) ##REM ##############################################REM Copyright (C) 2010 L2J DataPackREM 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 (atREM your option) any later version.REMREM This program is distributed in the hope that it will be useful, but REM WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITYREM or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License REM for more details.REMREM 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 L2JREM DataPack Project at http://www.l2jdp.com, http://www.l2jdp.com/forum orREM #l2j-datapack @ irc://irc.freenode.net set config_file=vars.txtset config_version=0 set workdir="%cd%"set full=0set stage=0set logging=0 set upgrade_mode=0set backup=.set logdir=.set safe_mode=1set cmode=cset fresh_setup=0 :loadconfigtitle L2JDP installer - Reading configuration from file...clsif not exist %config_file% goto configureren %config_file% vars.batcall vars.batren vars.bat %config_file%call :colors 17if /i %config_version% == 2 goto ls_sectionset upgrade_mode=2echo It seems to be the first time you run this version ofecho 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 andecho    continue execution, but since no new settings will beecho    saved, you'll see this menu again next time.echo.echo (2) Import and configure: This tool has some new availableecho    options, you choose the values that fit your needsecho    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_sectionif %upgrade_mode%==2 goto configureif %upgrade_mode%==3 goto configureif %upgrade_mode%==4 (cls&type %config_file%&pause&goto loadconfig)if %upgrade_mode%==5 goto :eofgoto loadconfig :colorsif /i "%cmode%"=="n" (if not "%1"=="17" (	color F	) else ( color )) else ( color %1 )goto :eof :configurecall :colors 17title L2JDP installer - Setupclsset config_version=2if NOT %upgrade_mode% == 2 (set fresh_setup=1set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.1\binset lsuser=rootset lspass=rootset lsdb=l2jdbset lshost=localhostset cbuser=rootset cbpass=rootset cbdb=l2jcbset cbhost=localhostset gsuser=rootset gspass=rootset gsdb=l2jdbset gshost=localhostset cmode=cset backup=.set logdir=.)set mysqlPath=C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exeecho New settings will be created for this tool to run inecho your computer, so I need to ask you some questions.echo.echo 1-MySql Binariesecho --------------------echo In order to perform my tasks, I need the path for commandsecho such as 'mysql' and 'mysqldump'. Both executables areecho usually stored in the same place.echo.if "%mysqlBinPath%" == "" (set mysqlBinPath=use pathecho I can't determine if the binaries are available with yourecho 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 :binaryfindecho.path|find "MySQL">NULif %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 MYSQLecho or PATH, you'd better close this window, and consider googlingecho and reading about it. Setup and host an L2J server requires aecho minimum of technical skills.)echo.echo Write the path to your MySQL binaries (no trailing slash needed):set /P mysqlBinPath="(default %mysqlBinPath%): "clsecho.echo 2-LoginServer settingsecho --------------------echo I will connect to the MySQL server you specify, and setup aecho Loginserver database there, most people use a single MySQLecho 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.clsecho.echo 3-Community Board Server settingsecho --------------------echo I will connect to the MySQL server you specify, and setup aecho Community Board server database there, most people use a single MySQLecho 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 settingsecho --------------------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. settingsecho --------------------set /P cmode="Color mode (c)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%'): ":safe1set safemode=yset /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:safe2echo.if "%mysqlBinPath%" == "use path" (set mysqlBinPath=set mysqldumpPath=mysqldumpset mysqlPath=mysql) else (set mysqldumpPath=%mysqlBinPath%\mysqldump.exeset 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 theecho '%config_file%' file. Remember: your passwords are storedecho as clear text.echo.echo press any key to continue...pause> nulgoto loadconfig :ls_sectionclscall :colors 17set cmdline=set stage=1title L2JDP installer - Login Server database setupecho.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 lsdbokREM if %safe_mode% == 1 goto omfg:ls_err1call :colors 47title L2JDP installer - Login Server database setup ERROR!!!clsecho.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 toecho proceed with the CommunityServer part of this tool.echo.:ls_ask1set lsdbprompt=yecho ATTEMPT TO CREATE LOGINSERVER DATABASE:echo.echo (y)esecho.echo (n)oecho.echo (r)econfigureecho.echo (q)uitecho.set /p lsdbprompt= Choose (default yes):if /i %lsdbprompt%==y goto lsdbcreateif /i %lsdbprompt%==n goto cb_backupif /i %lsdbprompt%==r goto configureif /i %lsdbprompt%==q goto endgoto ls_ask1 :omfgclscall :colors 57title L2JDP 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 thisecho script again later. But maybe you'd prefer to go on now.echo.if %stage% == 1 set label=ls_err1if %stage% == 2 set label=ls_err2if %stage% == 3 set label=cb_backupif %stage% == 4 set label=cb_err1if %stage% == 5 set label=cb_err2if %stage% == 6 set label=gs_backupif %stage% == 7 set label=gs_err1if %stage% == 8 set label=gs_err2if %stage% == 9 set label=horrible_endif %stage% == 10 set label=horrible_end:omfgask1set omfgprompt=qecho (c)ontinue running the scriptecho.echo (r)econfigureecho.echo (q)uit nowecho.set /p omfgprompt= Choose (default quit):if  /i %omfgprompt%==c goto %label%if  /i %omfgprompt%==r goto configureif  /i %omfgprompt%==q goto horrible_endgoto omfgask1 :lsdbcreatecall :colors 17set cmdline=set stage=2title L2JDP installer - Login Server database setup - DB Creationecho.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 logininstallif %safe_mode% == 1 goto omfg:ls_err2call :colors 47title L2JDP installer - Login Server database setup - DB Creation errorclsecho 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 valuesecho and try this script again later.echo.:ls_ask2set omfgprompt=qecho (c)ontinue runningecho.echo (r)econfigureecho.echo (q)uit nowecho.set /p omfgprompt= Choose (default quit):if /i %omfgprompt%==c goto cb_backupif /i %omfgprompt%==q goto horrible_endif /i %omfgprompt%==r goto configuregoto ls_ask2 :lsdbokcall :colors 17title L2JDP installer - Login Server database setup - WARNING!!!echo.:askloginif %fresh_setup%==0 (set loginprompt=sset msg=default skip) else (set loginprompt=xset msg=no default for fresh install)echo LOGINSERVER DATABASE install type:echo.echo (f)ull: I will destroy data in your `accounts` andecho    and `gameserver` tables.echo.echo (s)kip: I'll take you to the communityserver databaseecho    installation and upgrade options.echo.echo (r)econfigure: You'll be able to redefine MySQL path,echo    user and database information and start over withecho    those fresh values.echo.echo (q)uitecho.set /p loginprompt= Choose (%msg%) : if /i %loginprompt%==f goto logininstallif /i %loginprompt%==s goto cb_backupif /i %loginprompt%==r goto configureif /i %loginprompt%==q goto endgoto asklogin :logininstallset stage=3call :colors 17set cmdline=title L2JDP installer - Login Server database setup - Full installecho 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 omfgset full=1goto cb_backup :cb_backupclscall :colors 17set cmdline=if %full% == 1 goto communityinstallset stage=4title L2JDP installer - Community Board Server database setupecho.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 cbdbokREM if %safe_mode% == 1 goto omfg:cb_err1call :colors 47title L2JDP installer - Community Board Server database setup ERROR!!!clsecho.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 toecho proceed with the GameServer part of this tool.echo.:cb_ask1set cbdbprompt=yecho ATTEMPT TO CREATE COMMUNITYSERVER DATABASE:echo.echo (y)esecho.echo (n)oecho.echo (r)econfigureecho.echo (q)uitecho.set /p cbdbprompt= Choose (default yes):if /i %cbdbprompt%==y goto cbdbcreateif /i %cbdbprompt%==n goto gs_backupif /i %cbdbprompt%==r goto configureif /i %cbdbprompt%==q goto endgoto cb_ask1 :cbdbcreatecall :colors 17set cmdline=set stage=5title L2JDP installer - Communty Board Server database setup - DB Creationecho.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 communityinstallif %safe_mode% == 1 goto omfg:cb_err2call :colors 47title L2JDP installer - Community Board Server database setup - DB Creation errorclsecho 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 valuesecho and try this script again later.echo.:cb_ask2set omfgprompt=qecho (c)ontinue runningecho.echo (r)econfigureecho.echo (q)uit nowecho.set /p omfgprompt= Choose (default quit):if /i %omfgprompt%==c goto gs_backupif /i %omfgprompt%==q goto horrible_endif /i %omfgprompt%==r goto configuregoto cb_ask2 :cbdbokcall :colors 17title L2JDP installer - Community Board Server database setup - WARNING!!!echo.:askcommunityif %fresh_setup%==0 (set communityprompt=sset msg=default skip) else (set communityprompt=xset msg=no default for fresh install)echo COMMUNITYSERVER DATABASE install type:echo.echo (f)ull: WARNING! I'll destroy ALL of your existing communityecho    data (i really mean it: mail, forum, memo.. ALL)echo.echo (u)pgrade: I'll do my best to preserve all of your communityecho    data.echo.echo (s)kip: I'll take you to the gameserver databaseecho    installation and upgrade options.echo.echo (r)econfigure: You'll be able to redefine MySQL path,echo    user and database information and start over withecho    those fresh values.echo.echo (q)uitecho.set /p communityprompt= Choose (%msg%) : if /i %communityprompt%==f goto communityinstallif /i %communityprompt%==u goto upgradecbinstallif /i %communityprompt%==s goto gs_backupif /i %communityprompt%==r goto configureif /i %communityprompt%==q goto endgoto askcommunity :communityinstallset stage=6call :colors 17set cmdline=title L2JDP installer - Community Board Server database setup - Full installecho 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 omfggoto upgradecbinstall :upgradecbinstallset stage=6set cmdline=if %full% == 1 (title L2JDP installer - Community Board Server database setup - Installing...echo Installing new communityserver content.) else (title L2JDP installer - Community Board Server database setup - Upgrading...echo Upgrading communityserver content.)if %logging% == 0 set output=NULset dest=cbfor %%i in (clan_introductions.sqlcomments.sqlforums.sqlregistered_gameservers.sqlposts.sqltopics.sql) do call :dump %%i echo done...echo.goto gs_backup :gs_backupclscall :colors 17set cmdline=if %full% == 1 goto fullinstallset stage=7title L2JDP installer - Game server database setupclsecho.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 gsdbokrem if %safe_mode% == 1 goto omfg:gs_err1call :colors 47title L2JDP installer - Game Server database setup - Backup failed!clsecho.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.:askgsdbset gsdbprompt=yecho ATTEMPT TO CREATE GAMESERVER DATABASE?echo.echo (y)esecho.echo (n)oecho.echo (r)econfigureecho.echo (q)uitecho.set /p gsdbprompt= Choose (default yes):if /i %gsdbprompt%==y goto gsdbcreateif /i %gsdbprompt%==n goto horrible_endif /i %gsdbprompt%==r goto configureif /i %gsdbprompt%==q goto endgoto askgsdb :gsdbcreatecall :colors 17set stage=8set cmdline=title L2JDP installer - Game Server database setup - DB Creationclsecho 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 fullinstallif %safe_mode% == 1 goto omfg:gs_err2call :colors 47title L2JDP installer - Game Server database setup - DB Creation failed!clsecho.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 thisecho script again later. But you can try to reconfigure it now.echo.:askgsdbcreateset omfgprompt=qecho (r)estart script with fresh configuration valuesecho.echo (q)uit nowecho.set /p omfgprompt=  Choose (default quit):if /i %omfgprompt%==r goto configureif /i %omfgprompt%==q goto horrible_endgoto askgsdbcreate :gsdbokcall :colors 17title L2JDP installer - Game Server database setup - WARNING!!!clsecho.:asktypeset installtype=uecho GAMESERVER DATABASE install:echo.echo (f)ull: WARNING! I'll destroy ALL of your existing characterecho    data (i really mean it: items, pets.. ALL)echo.echo (u)pgrade: I'll do my best to preserve all of your characterecho    data.echo.echo (s)kip: We'll get into the last set of questions (cummulativeecho    updates, custom stuff...)echo.echo (q)uitecho.set /p installtype= Choose (default upgrade):if /i %installtype%==f goto fullinstallif /i %installtype%==u goto upgradeinstallif /i %installtype%==s goto customif /i %installtype%==q goto endgoto asktype :fullinstallcall :colors 17set stage=9set cmdline=title L2JDP installer - Game Server database setup - Full installecho 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 omfgset full=1echo.echo Game Server tables were deleted.goto upgradeinstall :upgradeinstallset stage=9set cmdline=if %full% == 1 (title L2JDP installer - Game Server database setup - Installing...echo Installing new gameserver content.) else (title L2JDP installer - Game Server database setup - Upgrading...echo Upgrading gameserver content.)if %logging% == 0 set output=NULset dest=lsfor %%i in (accounts.sqlaccount_data.sqlgameservers.sql) do call :dump %%iset dest=gsfor %%i in (access_levels.sqladmin_command_access_rights.sqlairships.sqlarmor.sqlarmorsets.sqlauction.sqlauction_bid.sqlauction_watch.sqlauto_announcements.sqlauto_chat.sqlauto_chat_text.sqlcastle.sqlcastle_door.sqlcastle_doorupgrade.sqlcastle_functions.sqlcastle_manor_procure.sqlcastle_manor_production.sqlcastle_siege_guards.sqlchar_creation_items.sqlchar_templates.sqlcharacter_friends.sqlcharacter_hennas.sqlcharacter_instance_time.sqlcharacter_macroses.sqlcharacter_quest_global_data.sqlcharacter_offline_trade_items.sqlcharacter_offline_trade.sqlcharacter_quests.sqlcharacter_raid_points.sqlcharacter_recipebook.sqlcharacter_recipeshoplist.sqlcharacter_recommends.sqlcharacter_shortcuts.sqlcharacter_skills.sqlcharacter_skills_save.sqlcharacter_subclasses.sqlcharacter_tpbookmark.sqlcharacter_ui_actions.sqlcharacter_ui_categories.sqlcharacters.sqlclan_data.sqlclan_notices.sqlclan_privs.sqlclan_skills.sqlclan_subpledges.sqlclan_wars.sqlclanhall.sqlclanhall_functions.sqlclass_list.sqlcursed_weapons.sqldimensional_rift.sqldroplist.sqlenchant_skill_groups.sqletcitem.sqlfish.sqlfishing_skill_trees.sqlfort.sqlfort_doorupgrade.sqlfort_functions.sqlfort_siege_guards.sqlfort_spawnlist.sqlfort_staticobjects.sqlfortsiege_clans.sqlforums.sqlfour_sepulchers_spawnlist.sqlgames.sqlglobal_tasks.sqlgrandboss_data.sqlgrandboss_list.sqlhelper_buff_list.sqlhenna.sqlhenna_trees.sqlheroes.sqlheroes_diary.sqlitem_attributes.sqlitems.sqlitemsonground.sqllocations.sqllvlupgain.sqlmapregion.sqlmerchant_areas_list.sqlmerchant_buylists.sqlmerchant_lease.sqlmerchant_shopids.sqlmerchants.sqlmessages.sqlminions.sqlnpc.sqlnpc_buffer.sqlnpcAIData.sqlnpcskills.sqlolympiad_data.sqlolympiad_fights.sqlolympiad_nobles.sqlolympiad_nobles_eom.sqlpets.sqlpets_skills.sqlpets_stats.sqlpledge_skill_trees.sqlposts.sqlquest_global_data.sqlraidboss_spawnlist.sqlrandom_spawn.sqlrandom_spawn_loc.sqlseven_signs.sqlseven_signs_festival.sqlseven_signs_status.sqlsiege_clans.sqlskill_learn.sqlskill_residential.sqlskill_spellbooks.sqlskill_trees.sqlspawnlist.sqlspecial_skill_trees.sqlteleport.sqltopic.sqlterritories.sqlterritory_registrations.sqlterritory_spawnlist.sqltransform_skill_trees.sqlwalker_routes.sqlweapon.sqlzone_vertices.sql) do call :dump %%i echo done...echo.goto custom :dumpset cmdline=if /i %full% == 1 (set action=Installing) else (set action=Upgrading)echo %action% %1>>"%output%"echo %action% %~nx1if "%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 %1goto :eof :omfg2clscall :colors 47title L2JDP 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 %~nx1echo.echo What we should do now?echo.:askomfg2set ntpebcak=cecho (l)og it: I will create a log for this file, then continueecho    with the rest of the list in non-logging mode.echo.echo (c)ontinue: Let's pretend that nothing happened and continue withecho    the rest of the list.echo.echo (r)econfigure: Perhaps these errors were caused by a typo.echo    you can restart from scratch and redefine paths, databasesecho    and user info again.echo.echo (q)uit nowecho.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 :logginonclscall :colors 17title L2JDP installer - Game Server database setup - Logging options turned onset logging=1if %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 rotatedecho 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>NULset 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 17set logging=0set output=NULgoto :eof :customecho.set cstprompt=nset /p cstprompt=Install custom gameserver DB tables: (y) yes or (N) no or (q) quit? if /i %cstprompt%==y goto cstinstallif /i %cstprompt%==n goto newbie_helperif /i %cstprompt%==q goto endgoto newbie_helper:cstinstallecho Installing custom content.cd ..\sql\custom\echo @echo off> temp.batif exist errors.txt del errors.txtfor %%i in (*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> custom_errors.txt >> temp.batcall temp.bat> nuldel temp.batmove custom_errors.txt %workdir%title L2JDP installer - Game Server database setup - custom tables processing completeclsecho Database structure for custom additions finished, i'm leaving aecho '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.pausecd %workdir%title L2JDP installer - Game Server database setup - L2J Modsclsecho L2J provides a basic infraestructure for some non-retail featuresecho (aka L2J mods) to get enabled with a minimum of changes.echo.echo Some of these mods would require extra tables in order to workecho and those tables could be created now if you wanted to.echo.cd ..\sql\mods\REM L2J mods that needed extra tables to work properly, should be REM listed here. To do so copy & paste the following 4 lines andREM change them properly:REM MOD: Wedding.set modprompt=nset /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 L2JDP installer - Game Server database setup - L2J Mods setup completeclsecho Database structure for L2J mods finished.echo.echo Remember that in order to get these additions actually working echo you need to edit your configuration files. echo.pausecd %workdir%goto newbie_helper  :newbie_helpercall :colors 17set stage=10title L2JDP installer - Game/CB Server database setup - update SQL filesclsif %full% == 1 goto endecho.echo In the sql/updates and cb_sql/updates folders,echo we use to store cummulative changes needed byecho the database structures.echo.echo Usually these SQL files are created whenever some newecho 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.:asknbset nbprompt=aecho.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 mayecho    pose a risk on your data.echo.echo automagi(c) processing: I'll do the automagic processecho    only with the cb_sql/updates folder.echo.echo automa(g)ic processing: I'll do the automagic processecho    only with the sql/updates folder.echo.echo (s)kip: I'll do nothing, it's up to you to find outecho    which file does what, which one could be of use forecho    you, etc.echo.set /p nbprompt= Choose (default auto):if /i %nbprompt%==a goto nbinstallif /i %nbprompt%==c goto nbcbinstallif /i %nbprompt%==g goto nbinstallif /i %nbprompt%==s goto endgoto asknb:nbinstallcd ..\sql\updates\echo @echo off> temp.batif exist errors.txt del errors.txtfor %%i in (*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> errors.txt >> temp.batcall temp.bat> nuldel temp.batmove errors.txt %workdir%cd %workdir%if /i %nbprompt%==g goto nbfinished:nbcbinstallcd ..\cb_sql\updates\echo @echo off> temp.batif exist cberrors.txt del cberrors.txtfor %%i in (*.sql) do echo "%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< %%i 2^>^> cberrors.txt >> temp.batcall temp.bat> nuldel temp.batmove cberrors.txt %workdir%cd %workdir%:nbfinishedtitle L2JDP installer - Game Server database setup - updates processing completeclsecho 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.pausegoto end :binaryfindif EXIST "%mysqlBinPath%" (echo Found) else (echo Not Found)goto :eof :horrible_endcall :colors 47title L2JDP installer - Oops!clsecho This wasn't a clean run, but don't worry.echo You can get help and support:echo.echo 1-Read the L2J Datapack project wiki :echo       (http://www.l2jdp.com/trac/wiki)echo 2-Search for a similar problem in our forumsecho       (http://www.l2jdp.com/forum)echo.echo You can ask for support in our forums or irc channel:echo irc://irc.freenode.net channel: #l2j-datapackecho.echo I'll try to gather some versioning information that youecho may find useful when asking for support :echo.echo Datapack revision reported by 'SVN version':svnversion -n 2>NULecho.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 ourecho   binaries needs) from :echo   http://subversion.tigris.org/servlets/ProjectDocumentList?folderID=91echo.)set dpvf="..\config\l2jdp-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> NULif not %ERRORLEVEL% == 0 (echo   An error occured while trying to readecho   your %dpvf% file!echo   Make sure you keep it up to dateecho   and in the correct place.echo %ERRORLEVEL%))echo.rem del %config_file%pausegoto end :endcall :colors 17title L2JDP installer - Script execution finishedclsecho.echo L2JDP database_installer version 0.2.2echo (C) 2007-2010 L2J Datapack Teamecho database_installer comes with ABSOLUTELY NO WARRANTY;echo This is free software, and you are welcome to redistribute itecho under certain conditions; See the file gpl.txt for furtherecho details.echo.echo Thanks for using our software.echo visit http://www.l2jdp.com for more info aboutecho the Official L2J Datapack project.echo.pausecolor 

Code: Select all

Deleting all gameserver tables for new content...The system cannot find the file specified. Game Server tables were deleted.Installing new gameserver content.Installing accounts.sqlThe system cannot find the path specified.Installing account_data.sqlThe system cannot find the path specified.Installing gameservers.sqlThe system cannot find the path specified.Installing access_levels.sqlThe system cannot find the path specified.Installing admin_command_access_rights.sqlThe system cannot find the path specified.Installing airships.sqlThe system cannot find the path specified.Installing armor.sqlThe system cannot find the path specified.Installing armorsets.sqlThe system cannot find the path specified.Installing auction.sqlThe system cannot find the path specified.Installing auction_bid.sqlThe system cannot find the path specified.Installing auction_watch.sqlThe system cannot find the path specified.Installing auto_announcements.sqlThe system cannot find the path specified.Installing auto_chat.sqlThe system cannot find the path specified.Installing auto_chat_text.sqlThe system cannot find the path specified.Installing castle.sqlThe system cannot find the path specified.Installing castle_door.sqlThe system cannot find the path specified.Installing castle_doorupgrade.sqlThe system cannot find the path specified.Installing castle_functions.sqlThe system cannot find the path specified.Installing castle_manor_procure.sqlThe system cannot find the path specified.Installing castle_manor_production.sqlThe system cannot find the path specified.Installing castle_siege_guards.sqlThe system cannot find the path specified.Installing char_creation_items.sqlThe system cannot find the path specified.Installing char_templates.sqlThe system cannot find the path specified.Installing character_friends.sqlThe system cannot find the path specified.Installing character_hennas.sqlThe system cannot find the path specified.Installing character_instance_time.sqlThe system cannot find the path specified.Installing character_macroses.sqlThe system cannot find the path specified.Installing character_quest_global_data.sqlThe system cannot find the path specified.Installing character_offline_trade_items.sqlThe system cannot find the path specified.Installing character_offline_trade.sqlThe system cannot find the path specified.Installing character_quests.sqlThe system cannot find the path specified.Installing character_raid_points.sqlThe system cannot find the path specified.Installing character_recipebook.sqlThe system cannot find the path specified.Installing character_recipeshoplist.sqlThe system cannot find the path specified.Installing character_recommends.sqlThe system cannot find the path specified.Installing character_shortcuts.sqlThe system cannot find the path specified.Installing character_skills.sqlThe system cannot find the path specified.Installing character_skills_save.sqlThe system cannot find the path specified.Installing character_subclasses.sqlThe system cannot find the path specified.Installing character_tpbookmark.sqlThe system cannot find the path specified.Installing character_ui_actions.sqlThe system cannot find the path specified.Installing character_ui_categories.sqlThe system cannot find the path specified.Installing characters.sqlThe system cannot find the path specified.Installing clan_data.sqlThe system cannot find the path specified.Installing clan_notices.sqlThe system cannot find the path specified.Installing clan_privs.sqlThe system cannot find the path specified.Installing clan_skills.sqlThe system cannot find the path specified.Installing clan_subpledges.sqlThe system cannot find the path specified.Installing clan_wars.sqlThe system cannot find the path specified.Installing clanhall.sqlThe system cannot find the path specified.Installing clanhall_functions.sqlThe system cannot find the path specified.Installing class_list.sqlThe system cannot find the path specified.Installing cursed_weapons.sqlThe system cannot find the path specified.Installing dimensional_rift.sqlThe system cannot find the path specified.Installing droplist.sqlThe system cannot find the path specified.Installing enchant_skill_groups.sqlThe system cannot find the path specified.Installing etcitem.sqlThe system cannot find the path specified.Installing fish.sqlThe system cannot find the path specified.Installing fishing_skill_trees.sqlThe system cannot find the path specified.Installing fort.sqlThe system cannot find the path specified.Installing fort_doorupgrade.sqlThe system cannot find the path specified.Installing fort_functions.sqlThe system cannot find the path specified.Installing fort_siege_guards.sqlThe system cannot find the path specified.Installing fort_spawnlist.sqlThe system cannot find the path specified.Installing fort_staticobjects.sqlThe system cannot find the path specified.Installing fortsiege_clans.sqlThe system cannot find the path specified.Installing forums.sqlThe system cannot find the path specified.Installing four_sepulchers_spawnlist.sqlThe system cannot find the path specified.Installing games.sqlThe system cannot find the path specified.Installing global_tasks.sqlThe system cannot find the path specified.Installing grandboss_data.sqlThe system cannot find the path specified.Installing grandboss_list.sqlThe system cannot find the path specified.Installing helper_buff_list.sqlThe system cannot find the path specified.Installing henna.sqlThe system cannot find the path specified.Installing henna_trees.sqlThe system cannot find the path specified.Installing heroes.sqlThe system cannot find the path specified.Installing heroes_diary.sqlThe system cannot find the path specified.Installing item_attributes.sqlThe system cannot find the path specified.Installing items.sqlThe system cannot find the path specified.Installing itemsonground.sqlThe system cannot find the path specified.Installing locations.sqlThe system cannot find the path specified.Installing lvlupgain.sqlThe system cannot find the path specified.Installing mapregion.sqlThe system cannot find the path specified.Installing merchant_areas_list.sqlThe system cannot find the path specified.Installing merchant_buylists.sqlThe system cannot find the path specified.Installing merchant_lease.sqlThe system cannot find the path specified.Installing merchant_shopids.sqlThe system cannot find the path specified.Installing merchants.sqlThe system cannot find the path specified.Installing messages.sqlThe system cannot find the path specified.Installing minions.sqlThe system cannot find the path specified.Installing npc.sqlThe system cannot find the path specified.Installing npc_buffer.sqlThe system cannot find the path specified.Installing npcAIData.sqlThe system cannot find the path specified.Installing npcskills.sqlThe system cannot find the path specified.Installing olympiad_data.sqlThe system cannot find the path specified.Installing olympiad_fights.sqlThe system cannot find the path specified.Installing olympiad_nobles.sqlThe system cannot find the path specified.Installing olympiad_nobles_eom.sqlThe system cannot find the path specified.Installing pets.sqlThe system cannot find the path specified.Installing pets_skills.sqlThe system cannot find the path specified.Installing pets_stats.sqlThe system cannot find the path specified.Installing pledge_skill_trees.sqlThe system cannot find the path specified.Installing posts.sqlThe system cannot find the path specified.Installing quest_global_data.sqlThe system cannot find the path specified.Installing raidboss_spawnlist.sqlThe system cannot find the path specified.Installing random_spawn.sqlThe system cannot find the path specified.Installing random_spawn_loc.sqlThe system cannot find the path specified.Installing seven_signs.sqlThe system cannot find the path specified.Installing seven_signs_festival.sqlThe system cannot find the path specified.Installing seven_signs_status.sqlThe system cannot find the path specified.Installing siege_clans.sqlThe system cannot find the path specified.Installing skill_learn.sqlThe system cannot find the path specified.Installing skill_residential.sqlThe system cannot find the path specified.Installing skill_spellbooks.sqlThe system cannot find the path specified.Installing skill_trees.sqlThe system cannot find the path specified.Installing spawnlist.sqlThe system cannot find the path specified.Installing special_skill_trees.sqlThe system cannot find the path specified.Installing teleport.sqlThe system cannot find the path specified.Installing topic.sqlThe system cannot find the path specified.Installing territories.sqlThe system cannot find the path specified.Installing territory_registrations.sqlThe system cannot find the path specified.Installing territory_spawnlist.sqlThe system cannot find the path specified.Installing transform_skill_trees.sqlThe system cannot find the path specified.Installing walker_routes.sqlThe system cannot find the path specified.Installing weapon.sqlThe system cannot find the path specified.Installing zone_vertices.sqlThe system cannot find the path specified.done...  Install custom gameserver DB tables: (y) yes or (N) no or (q) quit?

Code: Select all

@echo off set config_version=2 set cmode=cset safe_mode=1 set mysqlPath=C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exeset mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.1\binset mysqldumpPath=C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump.exeset lsuser=rootset lspass=passset lsdb=l2jlsset lshost=localhost set cbuser=rootset cbpass=passset cbdb=l2jcbset cbhost=localhost set gsuser=rootset gspass=passset gsdb=l2jgsset gshost=localhostset logdir=.set backup=.

Code: Select all

Deleting all gameserver tables for new content... Game Server tables were deleted.Installing new gameserver content.Installing accounts.sqlThe system cannot find the path specified.Installing account_data.sqlThe system cannot find the path specified.Installing gameservers.sqlThe system cannot find the path specified.Installing access_levels.sqlThe system cannot find the path specified.Installing admin_command_access_rights.sqlThe system cannot find the path specified.Installing airships.sqlThe system cannot find the path specified.Installing armor.sqlThe system cannot find the path specified.Installing armorsets.sqlThe system cannot find the path specified.Installing auction.sqlThe system cannot find the path specified.Installing auction_bid.sqlThe system cannot find the path specified.Installing auction_watch.sqlThe system cannot find the path specified.Installing auto_announcements.sqlThe system cannot find the path specified.Installing auto_chat.sqlThe system cannot find the path specified.Installing auto_chat_text.sqlThe system cannot find the path specified.Installing castle.sqlThe system cannot find the path specified.Installing castle_door.sqlThe system cannot find the path specified.Installing castle_doorupgrade.sqlThe system cannot find the path specified.Installing castle_functions.sqlThe system cannot find the path specified.Installing castle_manor_procure.sqlThe system cannot find the path specified.Installing castle_manor_production.sqlThe system cannot find the path specified.Installing castle_siege_guards.sqlThe system cannot find the path specified.Installing char_creation_items.sqlThe system cannot find the path specified.Installing char_templates.sqlThe system cannot find the path specified.Installing character_friends.sqlThe system cannot find the path specified.Installing character_hennas.sqlThe system cannot find the path specified.Installing character_instance_time.sqlThe system cannot find the path specified.Installing character_macroses.sqlThe system cannot find the path specified.Installing character_quest_global_data.sqlThe system cannot find the path specified.Installing character_offline_trade_items.sqlThe system cannot find the path specified.Installing character_offline_trade.sqlThe system cannot find the path specified.Installing character_quests.sqlThe system cannot find the path specified.Installing character_raid_points.sqlThe system cannot find the path specified.Installing character_recipebook.sqlThe system cannot find the path specified.Installing character_recipeshoplist.sqlThe system cannot find the path specified.Installing character_recommends.sqlThe system cannot find the path specified.Installing character_shortcuts.sqlThe system cannot find the path specified.Installing character_skills.sqlThe system cannot find the path specified.Installing character_skills_save.sqlThe system cannot find the path specified.Installing character_subclasses.sqlThe system cannot find the path specified.Installing character_tpbookmark.sqlThe system cannot find the path specified.Installing character_ui_actions.sqlThe system cannot find the path specified.Installing character_ui_categories.sqlThe system cannot find the path specified.Installing characters.sqlThe system cannot find the path specified.Installing clan_data.sqlThe system cannot find the path specified.Installing clan_notices.sqlThe system cannot find the path specified.Installing clan_privs.sqlThe system cannot find the path specified.Installing clan_skills.sqlThe system cannot find the path specified.Installing clan_subpledges.sqlThe system cannot find the path specified.Installing clan_wars.sqlThe system cannot find the path specified.Installing clanhall.sqlThe system cannot find the path specified.Installing clanhall_functions.sqlThe system cannot find the path specified.Installing class_list.sqlThe system cannot find the path specified.Installing cursed_weapons.sqlThe system cannot find the path specified.Installing dimensional_rift.sqlThe system cannot find the path specified.Installing droplist.sqlThe system cannot find the path specified.Installing enchant_skill_groups.sqlThe system cannot find the path specified.Installing etcitem.sqlThe system cannot find the path specified.Installing fish.sqlThe system cannot find the path specified.Installing fishing_skill_trees.sqlThe system cannot find the path specified.Installing fort.sqlThe system cannot find the path specified.Installing fort_doorupgrade.sqlThe system cannot find the path specified.Installing fort_functions.sqlThe system cannot find the path specified.Installing fort_siege_guards.sqlThe system cannot find the path specified.Installing fort_spawnlist.sqlThe system cannot find the path specified.Installing fort_staticobjects.sqlThe system cannot find the path specified.Installing fortsiege_clans.sqlThe system cannot find the path specified.Installing forums.sqlThe system cannot find the path specified.Installing four_sepulchers_spawnlist.sqlThe system cannot find the path specified.Installing games.sqlThe system cannot find the path specified.Installing global_tasks.sqlThe system cannot find the path specified.Installing grandboss_data.sqlThe system cannot find the path specified.Installing grandboss_list.sqlThe system cannot find the path specified.Installing helper_buff_list.sqlThe system cannot find the path specified.Installing henna.sqlThe system cannot find the path specified.Installing henna_trees.sqlThe system cannot find the path specified.Installing heroes.sqlThe system cannot find the path specified.Installing heroes_diary.sqlThe system cannot find the path specified.Installing item_attributes.sqlThe system cannot find the path specified.Installing items.sqlThe system cannot find the path specified.Installing itemsonground.sqlThe system cannot find the path specified.Installing locations.sqlThe system cannot find the path specified.Installing lvlupgain.sqlThe system cannot find the path specified.Installing mapregion.sqlThe system cannot find the path specified.Installing merchant_areas_list.sqlThe system cannot find the path specified.Installing merchant_buylists.sqlThe system cannot find the path specified.Installing merchant_lease.sqlThe system cannot find the path specified.Installing merchant_shopids.sqlThe system cannot find the path specified.Installing merchants.sqlThe system cannot find the path specified.Installing messages.sqlThe system cannot find the path specified.Installing minions.sqlThe system cannot find the path specified.Installing npc.sqlThe system cannot find the path specified.Installing npc_buffer.sqlThe system cannot find the path specified.Installing npcAIData.sqlThe system cannot find the path specified.Installing npcskills.sqlThe system cannot find the path specified.Installing olympiad_data.sqlThe system cannot find the path specified.Installing olympiad_fights.sqlThe system cannot find the path specified.Installing olympiad_nobles.sqlThe system cannot find the path specified.Installing olympiad_nobles_eom.sqlThe system cannot find the path specified.Installing pets.sqlThe system cannot find the path specified.Installing pets_skills.sqlThe system cannot find the path specified.Installing pets_stats.sqlThe system cannot find the path specified.Installing pledge_skill_trees.sqlThe system cannot find the path specified.Installing posts.sqlThe system cannot find the path specified.Installing quest_global_data.sqlThe system cannot find the path specified.Installing raidboss_spawnlist.sqlThe system cannot find the path specified.Installing random_spawn.sqlThe system cannot find the path specified.Installing random_spawn_loc.sqlThe system cannot find the path specified.Installing seven_signs.sqlThe system cannot find the path specified.Installing seven_signs_festival.sqlThe system cannot find the path specified.Installing seven_signs_status.sqlThe system cannot find the path specified.Installing siege_clans.sqlThe system cannot find the path specified.Installing skill_learn.sqlThe system cannot find the path specified.Installing skill_residential.sqlThe system cannot find the path specified.Installing skill_spellbooks.sqlThe system cannot find the path specified.Installing skill_trees.sqlThe system cannot find the path specified.Installing spawnlist.sqlThe system cannot find the path specified.Installing special_skill_trees.sqlThe system cannot find the path specified.Installing teleport.sqlThe system cannot find the path specified.Installing topic.sqlThe system cannot find the path specified.Installing territories.sqlThe system cannot find the path specified.Installing territory_registrations.sqlThe system cannot find the path specified.Installing territory_spawnlist.sqlThe system cannot find the path specified.Installing transform_skill_trees.sqlThe system cannot find the path specified.Installing walker_routes.sqlThe system cannot find the path specified.Installing weapon.sqlThe system cannot find the path specified.Installing zone_vertices.sqlThe system cannot find the path specified.done...  Install custom gameserver DB tables: (y) yes or (N) no or (q) quit?