[help]

MYSQL PATH : C:\Program Files\MySQL\MySQL Server 6.0

@echo off
color 17
title Simple Installer
REM #========================================#
REM # You can change here your own DB params #
REM #========================================#
REM MYSQL BIN PATH
REM Default values:
set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.0\bin

REM Here is a List of Default installation paths of Mysql useful if you dunno
REM #=================#
REM # for diskw users #
REM #=================#
REM C:\server\diskw\usr\local\mysql\bin

REM #=======================================#
REM # for mysql server users on x64 systems #
REM #=======================================#
REM C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin

REM #=========================================#
REM # for mysql server users on Win XP system #
REM #=========================================#
REM C:\Program Files\MySQL\MySQL Server 5.0\bin
REM C:\Arquivos de Programas\MySQL\MySQL Server 5.0\bin

REM LOGINSERVER
set lsuser=root
set lspass=root
set lsdb=l2j
set lshost=127.0.0.1

REM GAMESERVER
set gsuser=root
set gspass=root
set gsdb=l2j
set gshost=127.0.0.1
REM =========================================
set mysqldumpPath="%mysqlBinPath%\mysqldump"  
set mysqlPath="%mysqlBinPath%\mysql"  
echo.
echo                ** [ L2EMU PROJECT INTERACTIVE DATABASE INSTALLER ] **
echo                         ** [ LOGINSERVER DATABASE ] **
echo.
echo.
echo.
echo.
echo LOADING...
echo.
%mysqldumpPath% --add-drop-table -h %lshost% -u %lsuser% --password=%lspass% %lsdb% > loginserver_backup.sql
echo PLEASE SELECT YOUR INSTALL TYPE :
echo.
echo OPTIONS:
echo.
echo          FULL INSTALL (F) FOR A COMPLETE LOGINSERVER INSTALL.
echo.          
echo          UPGRADE INSTALL (U) FOR A LOGINSERVER UPGRADE INSTALL.
echo.        
echo          SKIP (S) TO SKIP LOGINSERVER DATABASE INSTALL.          
echo.
echo          QUIT (Q) TO EXIT PROGRAM.
echo.
echo.
:asklogin
set loginprompt=x
set /p loginprompt=WHAT'S YOUR CHOICE ?
echo.
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 OPERATION IN PROGRESS...
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < login_install.sql
echo.
:loginupgrade
echo OPERATION IN PROGRESS...
%mysqlPath% -h %gshost% -u %lsuser% --password=%lspass% -D %lsdb% < ../sql/user_database/account_data.sql
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < ../sql/user_database/accounts.sql
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < ../sql/user_database/gameservers.sql
echo.
echo LOGINSERVER DATABASE INSTALL COMPLETED !
echo.
echo.
echo.
echo.
echo.
:gsbackup
echo                ** [ L2EMU PROJECT INTERACTIVE DATABASE INSTALLER ] **
echo                         ** [ GAMESERVER DATABASE ] **
echo.
echo.
echo LOADING...
%mysqldumpPath% --add-drop-table -h %gshost% -u %gsuser% --password=%gspass% %gsdb% > gameserver_backup.sql
echo.
echo.
echo PLEASE SELECT YOUR INSTALL TYPE :
echo.
echo OPTIONS:
echo.
echo          FULL INSTALL (F) FOR A COMPLETE GAMESERVER INSTALL.
echo.          
echo          UPGRADE INSTALL (U) FOR A GAMESERVER UPGRADE INSTALL.
echo.        
echo          SKIP (S) TO SKIP GAMESERVER DATABASE INSTALL.
echo.
echo          QUIT (Q) TO EXIT THIS PROGRAM.
echo.
echo.    
:asktype
set installtype=x
set /p installtype=WHAT'S YOUR CHOICE ?
echo.
echo.
if /i %installtype%==F goto fullinstall
if /i %installtype%==U goto upgradeinstall
if /i %installtype%==S goto additional_features_setup
if /i %installtype%==Q goto end
goto asktype

:fullinstall
echo OPERATION IN PROGRESS...
echo.
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < full_install.sql

:upgradeinstall
echo OPERATION IN PROGRESS...
echo.
echo INSTALLING SERVER DATABASE
echo.
echo.
echo ARMOR                                       PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/armor.sql
echo ARMOR SETS                                  PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/armorsets.sql
echo AUTO CHAT                                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/auto_chat.sql
echo AUTO CHAT TEXT                              PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/auto_chat_text.sql
echo BUFF TEMPLATES                              PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/buff_templates.sql
echo CASTLE DOOR                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/castle_door.sql
echo CASTLE SIEGE GUARDS                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/castle_siege_guards.sql
echo CHARACTER ITEM CREATION                     PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/char_creation_items.sql
echo CHARACTER TEMPLATES                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/char_templates.sql
echo CLASS LIST                                  PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/class_list.sql
echo DROPLIST                                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/droplist.sql
echo ENCHANT SKILL TREES                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/enchant_skill_trees.sql
echo ETC ITEM                                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/etcitem.sql
echo FISH                                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fish.sql
echo FISHING SKILL TREE                          PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fishing_skill_trees.sql
echo FORTRESS DOORS                              PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fort_door.sql
echo FORTRESS SIEGE GUARDS                       PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fort_siege_guards.sql
echo FORTRESS SPAWN LIST                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fort_spawnlist.sql
echo FOUR SEPULCHERS SPAWNLIST                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/four_sepulchers_spawnlist.sql
echo GRAND BOSS SPAWNLIST                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/grandboss_spawnlist.sql
echo HENNA                                       PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/henna.sql
echo HENNA TREES                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/henna_trees.sql
echo LAST IMPERIAL TOMB SPAWNLIST                PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/lastimperialtomb_spawnlist.sql
echo LVL UP GAIN                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/lvlupgain.sql
echo MERCHANT BUYLISTS                           PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/merchant_buylists.sql
echo MERCHANT SHOP IDS                           PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/merchant_shopids.sql
echo MERCHANT                                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/merchants.sql
echo MINIONS                                     PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/minions.sql
echo NPC                                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/npc.sql
echo NPCS SKILLS                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/npcskills.sql
echo PET SKILLS                                  PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/pets_skills.sql
echo PET STATS                                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/pets_stats.sql
echo PLEDGE SKILL TREES                          PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/pledge_skill_trees.sql
echo RAID BOSS SPAWNLIST                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/raidboss_spawnlist.sql
echo RANDOM SPAWN                                PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/random_spawn.sql
echo RANDOM SPAWN LOC                            PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/random_spawn_loc.sql
echo SKILL LEARN                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/skill_learn.sql
echo SKILL SPEELBOOKS                            PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/skill_spellbooks.sql
echo SKILL TREE                                  PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/skill_trees.sql
echo SPAWNLIST                                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/spawnlist.sql
echo TELEPORT                                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/teleport.sql
echo TRANSFORMATION SKILL TREES                  PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/transform_skill_trees.sql
echo VAN HALTER SPAWNLIST                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/vanhalter_spawnlist.sql
echo WALKER ROUTES                               PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/walker_routes.sql
echo WEAPON                                      PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/weapon.sql
echo.
echo.
echo INSTALLING USER DATABASE
echo.
echo.
echo ACCESS LEVELS                               PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/access_levels.sql
echo ADMIN COMMAND ACCESS RIGHTS                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/admin_command_access_rights.sql
echo AUCTION                                     PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/auction.sql
echo AUCTION BID                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/auction_bid.sql
echo AUCTION WATCH                               PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/auction_watch.sql
echo AUTO ANNOUNCEMENTS                          PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/auto_announcements.sql
echo CASTLE                                      PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle.sql
echo CASTLE DOOR UPGRADE                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle_doorupgrade.sql
echo CASTLE FUNCTIONS                            PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle_functions.sql
echo CASTLE MANOR PROCURE                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle_manor_procure.sql
echo CASTLE MANOR PRODUCTION                     PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle_manor_production.sql
echo CHARACTER FRIENDS                           PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_friends.sql
echo CHARACTER HENNA                             PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_hennas.sql
echo CHARACTER MACRO                             PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_macroses.sql
echo CHARACTER QUEST                             PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_quests.sql
echo CHARACTER QUEST ITEMS                       PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_quests_item.sql
echo CHARACTER RAID POINTS                       PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_raid_points.sql
echo CHARACTER RECIPEBOOK                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_recipebook.sql
echo CHARACTER RECOMMENDS                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_recommends.sql
echo CHARACTER SHORTCUT                          PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_shortcuts.sql
echo CHARACTER SKILL                             PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_skills.sql
echo CHARACTER SKILL SAVE                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_skills_save.sql
echo CHARACTER STATS                             PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_stats.sql
echo CHARACTER SUBCLASS                          PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_subclasses.sql
echo CHARACTER                                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/characters.sql
echo CLAN DATA                                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_data.sql
echo CLAN NOTICE                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_notice.sql
echo CLAN HALL                                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clanhall.sql
echo CLAN PRIVILEGIES BY RANK                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_privs.sql
echo CLAN SKILLS                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_skills.sql
echo CLAN SUB PRIVILEGIES                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_subpledges.sql
echo CLAN WAR                                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_wars.sql
echo CLAN HALL FUNCTIONS                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clanhall_functions.sql
echo COUPLES                                     PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/couples.sql
echo CURSED WEAPONS                              PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/cursed_weapons.sql
echo FORTRESS                                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/fort.sql
echo FORTRESS DOORS UPGRADE                      PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/fort_doorupgrade.sql
echo FORTRESS FUNCTIONS                          PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/fort_functions.sql
echo FORTRESS SIEGE CLANS                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/fortsiege_clans.sql
echo FORUMS                                      PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/forums.sql
echo GAMES                                       PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/games.sql
echo GLOBAL TASKS                                PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/global_tasks.sql
echo GM AUDIT                                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/gm_audit.sql
echo GRAND BOSS INTERVAL LIST                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/grandboss_intervallist.sql
echo HEROES                                      PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/heroes.sql
echo ITEM ATTRIBUTES                             PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/item_attributes.sql
echo ITEMS                                       PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/items.sql
echo ITEMS ON GROUND                             PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/items_on_ground.sql
echo OBJECT RESTRICTIONS                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/obj_restrictions.sql
echo OLYMPIAD NOBLES                             PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/olympiad_nobles.sql
echo PETITION                                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/petitions.sql
echo PET                                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/pets.sql
echo POST                                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/posts.sql
echo QUEST GLOBAL DATA                           PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/quest_global_data.sql
echo RECORD                                      PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/record.sql
echo SEVEN SIGNS                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/seven_signs.sql
echo SEVEN SIGNS FESTIVAL                        PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/seven_signs_festival.sql
echo SEVEN SIGNS STATUS                          PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/seven_signs_status.sql
echo SIEGE CLANS                                 PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/siege_clans.sql
echo TOPIC                                       PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/topic.sql
echo.
echo.
echo INSTALLING MODS DATABASE...
echo.
echo CTF                                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/ctf.sql
echo CTF TEAMS                                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/ctf_teams.sql
echo DEATH MATCH EVENT                           PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/dm.sql
echo JAIL SPAWNLIST                              PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/jail_spawnlist.sql
echo TVT                                         PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/tvt.sql
echo TVT TEAMS                                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/tvt_teams.sql
echo VIP EVENT                                   PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/vipinfo.sql
echo.
echo.
echo INSTALLING CUSTOM DATABASE...
echo.
echo CHARACTERS CUSTOM DATA                      PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/characters_custom_data.sql
echo CUSTOM ARMOR                                PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_armor.sql
echo CUSTOM ARMOR SETS                           PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_armorsets.sql
echo CUSTOM DROP LIST                            PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_droplist.sql
echo CUSTOM ETCITEM                              PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_etcitem.sql
echo CUSTOM MERCHANT BUYLISTS                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_merchant_buylists.sql
echo CUSTOM MERCHANT SHOP IDS                    PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_merchant_shopids.sql
echo CUSTOM NPC                                  PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_npc.sql
echo CUSTOM NPC SKILLS                           PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_npcskills.sql
echo CUSTOM SPAWNLIST                            PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_spawnlist.sql
echo CUSTOM TELEPORTS                            PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_teleports.sql
echo CUSTOM WEAPON                               PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_weapon.sql
echo NPC BUFFER                                  PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/npc_buffer.sql
echo.
echo.
echo GAMESERVER TABLES INSTALL COMPLETED !
echo.
echo.
echo                     ** GAMESERVER DATABASE UPDATER **
echo.
echo.
echo.
echo THIS PROGRAM WILL RUN ALL DATABASE UPDATES NEEDED FOR YOUR GAMESERVER.
echo.
echo.
echo IMPORTANT: USE THIS TOOL ONLY IF YOU UPGRADE FROM AN OLDER VERSION,
echo            IF YOU JUST MADE A FRESH INSTALL THEN YOU DON'T NEED TO RUN THIS UPDATER.
echo.
echo.
echo WARNING:   WHILE YOU ARE RUNNING THE UPDATER, YOU MAY GET ERRORS.
echo            THIS IS CAUSED DUE TO OLDER UPDATE FILES, JUST IGNORE THEM.
echo            MOST OF THEM SHOULD BE DUPLICATE ERRROR ON LINE 1.
echo.
echo.
echo SELECT:  YES (Y) TO RUN AND INSTALL ALL DB UPDATES FOR GS.
echo.          
echo          QUIT (Q) TO CLOSE THIS PROGRAM.  
echo.  
:askupdate
set updateprompt=x
set /p installtype=UPDATE your database: (y) yes or (n) no?
if /i %installtype%==y goto updatedb
if /i %installtype%==n goto end
goto askupdate

:updatedb
echo UPDATING DATABASE...
echo.
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_17_05_2007.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_18_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_19_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_20_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_21_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_22_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_23_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_24_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_25_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_26_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_27_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_28_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_29_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_30_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_31_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_01_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_02_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_03_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_04_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_05_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_06_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_07_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_08_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_09_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_10_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_11_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_12_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_13_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_14_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_18_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_21_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_26_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_17_08_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_05_09_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_17_09_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_29_09_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_01_10_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_06_10_2008.sql
REM ALWAYS ON LAST FILE SQL ENGINE RAID BOSS
:end
echo UPDATE COMPLETED !
echo.
echo IF YOU GOT DUPLICATE ERRORS ON LINE 1 IT MEANS YOUR DB IS ALREADY UPDATED.
echo JUST IGNORE THESE ERRORS.
:end
echo.
echo INTERACTIVE DATABASE INSTALLER COMPLETED !
echo.
echo.
echo CONTACTS : http://www.l2emu.net/
echo.
echo.
echo POWERED BY L2EMU PROJECT DEVELOPMENT TEAM.
echo COPYRIGHT 2005-2008 - ALL RIGHTS RESERVED.
echo.
echo Patch by RAYAN.
echo.
pause

REM LOGINSERVER
set lsuser=root
set lspass=root
set lsdb=l2j
set lshost=127.0.0.1

REM GAMESERVER
set gsuser=root
set gspass=root
set gsdb=l2j
set gshost=127.0.0.1