Скрытый текст@echo off TITLE Database Installer set user=root set pass=33333 set DBname=lineage set DBHost=localhost --port=3306 REM ######################################## :home :home cls echo.Database Installer echo. echo.(1) Login echo.(2) Game echo. echo.(3) Custom patches echo. echo.(0) Exit echo. set button=x set /p button=cmd: if /i %button%==1 goto login if /i %button%==2 goto game if /i %button%==3 goto patches if /i %button%==0 goto exit goto home REM ######################################## :login :login cls echo.Database Installer: login echo. echo.(1) Install. echo.(2) Back. echo. echo.(0) Exit. echo. set button=x set /p button=cmd: if /i %button%==1 goto login_exe if /i %button%==2 goto home if /i %button%==0 goto exit goto login REM ######################################## :game :game cls echo.Database Installer: game echo. echo.(1) Install. echo.(2) Back. echo. echo.(0) Exit. echo. set button=x set /p button=cmd: if /i %button%==1 goto game_exe if /i %button%==2 goto home if /i %button%==0 goto exit goto game REM ######################################## :patches :patches cls echo.Database Installer: patches echo. echo.(1) PvP Drop // Only adena, life stones, clan eggs and epic jewerly. echo.(2) Noblesse Skill // Give Blessing of Noblesse to all characters. echo.(3) Return Skill // Give Return to all characters. echo.(4) 0 Adena // Sell any item to NPC with 0 adena. echo.(9) Back. echo. echo.(0) Exit. echo. set button=x set /p button=cmd: if /i %button%==1 goto pvp_drop if /i %button%==2 goto noble_skill if /i %button%==3 goto return_skill if /i %button%==4 goto null_prices if /i %button%==9 goto home if /i %button%==0 goto exit goto patches REM ######################################## :pvp_drop :pvp_drop echo. echo.Database Installer: patches: install echo. echo Loading... pvp_drop.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < patches/pvp_drop.sql echo...completed. echo. echo.pvp_drop installed! echo. pause goto home REM ######################################## :noble_skill :noble_skill echo. echo.Database Installer: patches: install echo. echo Loading... noble_skill.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < patches/noble_skill.sql echo...completed. echo. echo.noble_skill installed! echo. pause goto home REM ######################################## :return_skill :return_skill echo. echo.Database Installer: patches: install echo. echo Loading... return_skill.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < patches/return_skill.sql echo...completed. echo. echo.return_skill installed! echo. pause goto home REM ######################################## :null_prices :null_prices echo. echo.Database Installer: patches: install echo. echo Loading... null_prices.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < patches/null_prices.sql echo...completed. echo. echo.null_prices installed! echo. pause goto home REM ######################################## :login_exe :login_exe echo. echo.Database Installer: login: install echo. echo Loading... accounts.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < login/accounts.sql echo Loading... gameservers.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < login/gameservers.sql echo...completed. echo. echo.login installed! echo. pause goto home REM ######################################## :game_exe :game_exe echo. echo.Database Installer: game: install echo. echo General tables... echo Loading... armor.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/armor.sql echo Loading... armorsets.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/armorsets.sql echo Loading... auction.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auction.sql echo Loading... auction_bid.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auction_bid.sql echo Loading... auction_watch.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auction_watch.sql echo Loading... auto_chat.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auto_chat.sql echo Loading... auto_chat_text.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auto_chat_text.sql echo Loading... boxaccess.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/boxaccess.sql echo Loading... boxes.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/boxes.sql echo Loading... buff_templates.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/buff_templates.sql echo Loading... castle.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle.sql echo Loading... castle_door.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_door.sql echo Loading... castle_doorupgrade.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_doorupgrade.sql echo Loading... castle_manor_procure.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_manor_procure.sql echo Loading... castle_manor_production.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_manor_production.sql echo Loading... castle_siege_guards.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_siege_guards.sql echo Loading... char_templates.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/char_templates.sql echo Loading... character_friends.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_friends.sql echo Loading... character_hennas.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_hennas.sql echo Loading... character_macroses.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_macroses.sql echo Loading... character_quests.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_quests.sql echo Loading... character_raid_points.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_raid_points.sql echo Loading... character_recipebook.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_recipebook.sql echo Loading... character_recommends.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_recommends.sql echo Loading... character_settings.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_settings.sql echo Loading... character_shortcuts.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_shortcuts.sql echo Loading... character_skills.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_skills.sql echo Loading... character_skills_save.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_skills_save.sql echo Loading... character_subclasses.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_subclasses.sql echo Loading... characters.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/characters.sql echo Loading... clan_data.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_data.sql echo Loading... clan_privs.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_privs.sql echo Loading... clan_skills.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_skills.sql echo Loading... clan_subpledges.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_subpledges.sql echo Loading... clan_wars.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_wars.sql echo Loading... clanhall.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clanhall.sql echo Loading... clanhall_functions.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clanhall_functions.sql echo Loading... class_list.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/class_list.sql echo Loading... connection_test_table.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/connection_test_table.sql echo Loading... cursed_weapons.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/cursed_weapons.sql echo Loading... dimensional_rift.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/dimensional_rift.sql echo Loading... droplist.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/droplist.sql echo Loading... enchant_skill_trees.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/enchant_skill_trees.sql echo Loading... etcitem.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/etcitem.sql echo Loading... fish.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/fish.sql echo Loading... fishing_skill_trees.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/fishing_skill_trees.sql echo Loading... forums.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/forums.sql echo Loading... four_sepulchers_spawnlist.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/four_sepulchers_spawnlist.sql echo Loading... games.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/games.sql echo Loading... global_tasks.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/global_tasks.sql echo Loading... grandboss_data.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/grandboss_data.sql echo Loading... grandboss_list.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/grandboss_list.sql echo Loading... helper_buff_list.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/helper_buff_list.sql echo Loading... henna.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/henna.sql echo Loading... henna_trees.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/henna_trees.sql echo Loading... heroes.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/heroes.sql echo Loading... imp_tomb_spawnlist.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/imp_tomb_spawnlist.sql echo Loading... items.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/items.sql echo Loading... itemsonground.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/itemsonground.sql echo Loading... locations.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/locations.sql echo Loading... lvlupgain.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/lvlupgain.sql echo Loading... mapregion.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/mapregion.sql echo Loading... merchant_areas_list.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchant_areas_list.sql echo Loading... merchant_buylists.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchant_buylists.sql echo Loading... merchant_lease.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchant_lease.sql echo Loading... merchant_shopids.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchant_shopids.sql echo Loading... merchants.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchants.sql echo Loading... minions.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/minions.sql echo Loading... mods_wedding.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/mods_wedding.sql echo Loading... npc.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/npc.sql echo Loading... npcskills.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/npcskills.sql echo Loading... olympiad_diaries.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/olympiad_diaries.sql echo Loading... olympiad_nobles.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/olympiad_nobles.sql echo Loading... party_match.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/party_match.sql echo Loading... pets.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/pets.sql echo Loading... pets_stats.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/pets_stats.sql echo Loading... pledge_skill_trees.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/pledge_skill_trees.sql echo Loading... posts.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/posts.sql echo Loading... quest_global_data.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/quest_global_data.sql echo Loading... raidboss_points.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/raidboss_points.sql echo Loading... raidboss_spawnlist.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/raidboss_spawnlist.sql echo Loading... raidboss_status.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/raidboss_status.sql echo Loading... random_spawn.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/random_spawn.sql echo Loading... random_spawn_loc.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/random_spawn_loc.sql echo Loading... server_variables.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/server_variables.sql echo Loading... seven_signs.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/seven_signs.sql echo Loading... seven_signs_festival.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/seven_signs_festival.sql echo Loading... seven_signs_status.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/seven_signs_status.sql echo Loading... siege_clans.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/siege_clans.sql echo Loading... skill_learn.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/skill_learn.sql echo Loading... skill_spellbooks.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/skill_spellbooks.sql echo Loading... skill_trees.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/skill_trees.sql echo Loading... spawnlist.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/spawnlist.sql echo Loading... teleport.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/teleport.sql echo Loading... topic.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/topic.sql echo Loading... walker_routes.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/walker_routes.sql echo Loading... weapon.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/weapon.sql echo Loading... zone_vertices.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/zone_vertices.sql echo...completed. echo Custom tables... echo Loading... z_donate_skills.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_donate_skills.sql echo Loading... z_bbs_auction.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_bbs_auction.sql echo Loading... z_bbs_mail.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_bbs_mail.sql echo Loading... z_buff_profile.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_buff_profile.sql echo Loading... z_char_keys.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_char_keys.sql echo Loading... z_fc_players.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_fc_players.sql echo Loading... z_maxonline.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_maxonline.sql echo Loading... z_moderator.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_moderator.sql echo Loading... z_moderator_log.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_moderator_log.sql echo Loading... z_post_adrbook.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_adrbook.sql echo Loading... z_post_in.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_in.sql echo Loading... z_post_out.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_out.sql echo Loading... z_post_pos.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_pos.sql echo Loading... z_post_stat.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_stat.sql echo Loading... z_safety_trade.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_safety_trade.sql echo Loading... z_stock_accounts.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_stock_accounts.sql echo Loading... z_stock_items.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_stock_items.sql echo Loading... z_stock_logs.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_stock_logs.sql echo Loading... z_vote_names.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_vote_names.sql echo Loading... z_vote_logs.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_vote_logs.sql echo Loading... zz_donate_log.sql mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/zz_donate_log.sql echo...completed. echo. echo.game installed! pause goto home REM ######################################## :exit :exit
да конечно все создал
