Created
February 18, 2010 10:49
-
-
Save SkirnirMaNGOS/307569 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#! /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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment