#! /bin/bash

#GNU/Linux import Skript für SQL Dateien des GMDB Projekts

#username="loginname"
#userpass="loginpassword"
username=""
userpass=""

#database_udb="mangos"
#database_scriptdev2="scriptdev2"
#filepath="/home/<username>/source/mangos/gmdb/trunk/GMDB
database_udb=""
database_sd2=""
filepath=""

#server="MySQL Server IP"
#Port="MySQL Server Port"
server="127.0.0.1"

port="3306"

OPTIONS="Ausfuehren Ende"
select opt in $OPTIONS; do
    if [ "$opt" = "Ende" ]; then
        echo done
        exit
    elif [ "$opt" = "Ausfuehren" ]; then
        echo
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/areatrigger_tavern.sql
        echo areatriger_tavern.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/areatrigger_teleport.sql
        echo areatriger_teleport.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/command.sql
        echo command.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/creature_ai_texts.sql
        echo creature_ai_texts.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/db_script_string.sql
        echo db_script_string.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/game_tele.sql
        echo game_tele.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/locales_achievement_reward.sql
        echo locales_achievment_reward.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/locales_creature.sql
        echo locales_creature.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/locales_gameobject.sql
        echo locales_gameobject.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/locales_gossip_menu_option.sql
        echo locales_gossip_menu_option.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/locales_item.sql
        echo locales_item.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/locales_npc_text.sql
        echo locales_npc_text.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/locales_page_text.sql
        echo locales_page_text.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/locales_points_of_interest.sql
        echo locales_points_of_interest.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/locales_quest.sql
        echo locales_quest.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/mangos_string.sql
        echo mangos_string.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_udb < $filepath/transports.sql
        echo transports.sql
        mysql --host=$server --user=$username --password=$userpass --port=$port $database_sd2 < $filepath/ScriptDev2/script_texts.sql
        echo ScriptDev2/script_texts.sql
    echo
    echo ---
    echo Fertig. 2 drücken zum beenden.
    echo ---
    echo
    else
        clear
    echo Falsche Eingabe
    fi
done