=FFFF=00000

[/ex][/ex][ex][ex]

@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