@echo off
color 4
REM ##############################################
REM ## Interactive script setup ##
REM ##############################################
REM Default values:
set mysqlBinPath="C:\ProgramFiles\MySQL\MySQL Server 5.1\bin"
REM LOGINSERVER
set lsuser=root
set lspass=****
set lsdb=l2jdb
set lshost=localhost
REM GAMESERVER
set gsuser=root
set gspass=****
set gsdb=l2jdb
set gshost=localhost
C:\Program Files\MySQL\MySQL Server 5.1\bin
логин и пароль правильные через Navicat for MySQL все коннектится бд тоже правильно написал и создал в Navicat
вот полный батник database_installer.bat
Свернуть ↑
@echo off color 4 REM ############################################## REM ## Interactive script setup ## REM ############################################## REM Default values: set mysqlBinPath="C:\ProgramFiles\MySQL\MySQL Server 5.1\bin" REM LOGINSERVER set lsuser=root set lspass=**** set lsdb=l2jdb set lshost=localhost REM GAMESERVER set gsuser=root set gspass=**** set gsdb=l2jdb set gshost=localhost set workdir="%cd%" :loadVars if not exist vars.txt goto createVars ren vars.txt *.bat call vars.bat ren vars.bat *.txt cls goto start :createVars echo Welcome to LIONNA Installer version 1.2 echo You are trying to install LIONNA datapack.Please configure it if its your first time echo. echo Your mysqlBinPath is? (default: %ProgramFiles%\MySQL\MySQL Server 5.1\bin) set /P mysqlBinPath=": " echo. echo LoginServer settings echo -------------------- set /P lsuser="User (default is 'root'): " set /P lspass="Pass (default is 'root'): " set /P lsdb="Database (default is 'l2auth'): " set /P lshost="Host (default is 'localhost'): " echo. echo GameServer settings echo ------------------- set /P gsuser="User (default is 'root'): " set /P gspass="Pass (default is 'root'): " set /P gsdb="Database (default is 'lin2world'): " set /P gshost="Host (default is 'localhost'): " echo. echo @set mysqlPath="%mysqlBinPath%\mysql"> vars.txt echo @set mysqlBinPath="%mysqlBinPath%">> vars.txt echo @set mysqldumpPath="%mysqlBinPath%\mysqldump">> vars.txt echo @set lsuser=%lsuser%>> vars.txt echo @set lspass=%lspass%>> vars.txt echo @set lsdb=%lsdb%>> vars.txt echo @set lshost=%lshost%>> vars.txt echo @set gsuser=%gsuser%>> vars.txt echo @set gspass=%gspass%>> vars.txt echo @set gsdb=%gsdb%>> vars.txt echo @set gshost=%gshost%>> vars.txt echo. echo Script setup complete, press any key to continue... pause> nul goto loadVars :start REM ############################################ echo. echo Making a backup of the original loginserver database. %mysqldumpPath% --add-drop-table -h %lshost% -u %lsuser% --password=%lspass% %lsdb% > loginserver_backup.sql echo. echo WARNING: Full install (f) will destroy data in your `accounts` and `gameserver` echo tables. echo. echo Choose upgrade (u) if you already have an `accounts` table but no `gameserver` echo table (ie. your server is a pre LS/GS split version.) echo. echo Choose skip (s) to skip loginserver DB installation and go to gameserver DB echo installation/upgrade. echo. :asklogin set loginprompt=x set /p loginprompt=LOGINSERVER DB install type: (f) full or (u) upgrade or {s} skip or (q) quit? if /i %loginprompt%==f goto logininstall if /i %loginprompt%==u goto loginupgrade if /i %loginprompt%==s goto gsbackup if /i %loginprompt%==q goto end goto asklogin :logininstall echo Deleting loginserver tables for new content. %mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < login_install.sql :loginupgrade echo Installing new loginserver content. %mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < sql/accounts.sql %mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < sql/gameservers.sql :gsbackup echo. echo Making a backup of the original gameserver database. %mysqldumpPath% --add-drop-table -h %gshost% -u %gsuser% --password=%gspass% %gsdb% > gameserver_backup.sql echo. echo. echo WARNING: A full install (f) will destroy all existing character data. :asktype set installtype=x set /p installtype=GAMESERVER DB install type: (f) full install or (u) upgrade or (s) skip or (q) quit? if /i %installtype%==f goto fullinstall if /i %installtype%==u goto upgradeinstall if /i %installtype%==s goto experimental if /i %installtype%==q goto end goto asktype :fullinstall echo Deleting all gameserver tables for new content. %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < full_install.sql :upgradeinstall echo Installing new LIONNA Datapack Content. echo The installer will install both official and custom content echo Version:Interlude %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/account_data.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/account_premium.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/armor.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/armorsets.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/autoanounce.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/auction.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/auction_bid.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/auction_watch.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/auto_chat.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/auto_chat_text.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/augmentations.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/boxaccess.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/boxes.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/buff_templates.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle_door.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle_doorupgrade.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle_manor_procure.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle_manor_production.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle_siege_guards.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/cch_guards.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/char_templates.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_blocklist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_colors.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_colors_title.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_friends.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_hennas.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_macroses.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_pccafe_points.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_quests.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_raid_points.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_recipebook.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_recommends.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_shortcuts.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_skills.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_skills_save.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_subclasses.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/characters.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_data.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_privs.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_subpledges.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_skills.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_wars.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_notices.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clanhall.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clanhall_functions.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clanhall_siege.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/class_list.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/couples.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/cursed_weapons.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_armor.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_armorsets.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_droplist.sql echo Please wait.... %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_etcitem.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/mods_buffer.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/mods_wedding.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_merchant_buylists.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_merchant_shopids.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_teleport.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_weapon.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/dimensional_rift.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/donate_hero_data.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/droplist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/enchant_skill_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/etcitem.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fish.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fishing_skill_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fort_staticobjects.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fort_functions.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fort_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fort_siege_guards.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fort_door.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fort_doorupgrade.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fort.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fortress_siege.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/fortsiege_clans.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/forums.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/games.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/grandboss_data.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/grandboss_list.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/global_tasks.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/gm_edit.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/helper_buff_list.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/henna.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/henna_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/heroes.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/items.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/itemsonground.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/locations.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/lvlupgain.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/l2top_votes.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/mapregion.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/merchant_areas_list.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/merchant_buylists.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/merchant_lease.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/merchant_shopids.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/merchants.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/minions.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/nospawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/npcskills.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/npc.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom_npc.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/pets.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/pets_objects.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/pets_stats.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/pkkills.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/pledge_skill_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/posts.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/quest_global_data.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/raid_events_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/raid_prizes.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/olympiad_nobles.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/raidboss_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/random_spawn.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/random_spawn_loc.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/record.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/seven_signs.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/seven_signs_festival.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/seven_signs_status.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/siege_clans.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/shop_skill_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/skill_learn.sql echo Almost finish %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/skill_spellbooks.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/skill_trees.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/teleport.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/topic.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/vanhalter_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/walker_routes.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/weapon.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/zone.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/zone_vertices.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/four_sepulchers_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/npc_buffer.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/lastimperialtomb_spawnlist.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/ctf.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/ctf_teams.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/dm.sql %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/forced_updates.sql echo Installation finish.Visit
www.lionna.net for more info echo. :end echo. echo Powered by LIONNA Developing Team echo 2010-2011 echo Script complete. pause
Свернуть ↑Развернуть ↓