database_installer.sh

#!/bin/bash
############################################
## WARNING!  WARNING!  WARNING!  WARNING! ##
##                                        ##
## DON'T USE NOTEPAD TO CHANGE THIS FILE  ##
## INSTEAD USE SOME DECENT TEXT EDITOR.   ##
## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ##
## WINDOWS AND UNIX.                      ##
##                                        ##
## USING NOTEPAD TO SAVE THIS FILE WILL   ##
## LEAVE IT IN A BROKEN STATE!!!          ##
############################################
## Writen by DrLecter                     ##
## License: GNU GPL                       ##
## Based on Tiago Tagliaferri's script    ##
## E-mail: tiago_tagliaferri@msn.com      ##
## From "L2J-DataPack"                    ##
## Bug reports: http://l2jdp.com/trac     ##
############################################
trap finish 2

configure() {
echo "#############################################"
echo "# You entered script configuration area     #"
echo "# No change will be performed in your DB    #"
echo "# I will just ask you some questions about  #"
echo "# your hosts and DB.                        #"
echo "#############################################"
MYSQLDUMPPATH=`which mysqldump 2>/dev/null`
MYSQLPATH=`which mysql 2>/dev/null`
if [ $? -ne 0 ]; then
echo "We were unable to find MySQL binaries on your path"
while :
 do
  echo -ne "\nPlease enter MySQL binaries directory (no trailing slash): "
  read MYSQLBINPATH
    if [ -e "$MYSQLBINPATH" ] && [ -d "$MYSQLBINPATH" ] && [ -e "$MYSQLBINPATH/mysqldump" ] && [ -e "$MYSQLBINPATH/mysql" ]; then
       MYSQLDUMPPATH="$MYSQLBINPATH/mysqldump"
       MYSQLPATH="$MYSQLBINPATH/mysql"
       break
    else
       echo "The data you entered is invalid. Please verify and try again."
       exit 1
    fi
 done
fi
#LS
echo -ne "\nPlease enter MySQL Login Server hostname (default localhost): "
read LSDBHOST
if [ -z "$LSDBHOST" ]; then
  LSDBHOST="localhost"
fi
echo -ne "\nPlease enter MySQL Login Server database name (default l2jdb): "
read LSDB
if [ -z "$LSDB" ]; then
  LSDB="l2jdb"
fi
echo -ne "\nPlease enter MySQL Login Server user (default root): "
read LSUSER
if [ -z "$LSUSER" ]; then
  LSUSER="root"
fi
echo -ne "\nPlease enter MySQL Login Server $LSUSER's password (won't be displayed) :"
stty -echo
read LSPASS
stty echo
echo ""
if [ -z "$LSPASS" ]; then
  echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords"
elif [ "$LSUSER" == "$LSPASS" ]; then
  echo "You're not too brilliant choosing passwords huh?"
fi
#GS
echo -ne "\nPlease enter MySQL Game Server hostname (default $LSDBHOST): "
read GSDBHOST
if [ -z "$GSDBHOST" ]; then
  GSDBHOST="$LSDBHOST"
fi
echo -ne "\nPlease enter MySQL Game Server database name (default $LSDB): "
read GSDB
if [ -z "$GSDB" ]; then
  GSDB="$LSDB"
fi
echo -ne "\nPlease enter MySQL Game Server user (default $LSUSER): "
read GSUSER
if [ -z "$GSUSER" ]; then
  GSUSER="$LSUSER"
fi
echo -ne "\nPlease enter MySQL Game Server $GSUSER's password (won't be displayed): "
stty -echo
read GSPASS
stty echo
echo ""
if [ -z "$GSPASS" ]; then
  echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords"
elif [ "$GSUSER" == "$GSPASS" ]; then
  echo "You're not too brilliant choosing passwords huh?"
fi
save_config $1
}

save_config() {
if [ -n "$1" ]; then
CONF="$1"
else
CONF="database_installer.rc"
fi
echo ""
echo "With these data I can generate a configuration file which can be read"
echo "on future updates. WARNING: this file will contain clear text passwords!"
echo -ne "Shall I generate config file $CONF? (Y/n):"
read SAVE
if [ "$SAVE" == "y" -o "$SAVE" == "Y" -o "$SAVE" == "" ];then
cat <<EOF>$CONF
#Configuration settings for L2J-Datapack database installer script
MYSQLDUMPPATH=$MYSQLDUMPPATH
MYSQLPATH=$MYSQLPATH
LSDBHOST=$LSDBHOST
LSDB=$LSDB
LSUSER=$LSUSER
LSPASS=$LSPASS
GSDBHOST=$GSDBHOST
GSDB=$GSDB
GSUSER=$GSUSER
GSPASS=$GSPASS
EOF
chmod 600 $CONF
echo "Configuration saved as $CONF"
echo "Permissions changed to 600 (rw- --- ---)"
elif [ "$SAVE" != "n" -a "$SAVE" != "N" ]; then
  save_config
fi
}

load_config() {
if [ -n "$1" ]; then
CONF="$1"
else
CONF="database_installer.rc"
fi
if [ -e "$CONF" ] && [ -f "$CONF" ]; then
. $CONF
else
echo "Settings file not found: $CONF"
echo "You can specify an alternate settings filename:"
echo $0 config_filename
echo ""
echo "If file doesn't exist it can be created"
echo "If nothing is specified script will try to work with ./database_installer.rc"
echo ""
configure $CONF
fi
}

asklogin(){
echo "#############################################"
echo "# WARNING: This section of the script CAN   #"
echo "# destroy your characters and accounts      #"
echo "# information. Read questions carefully     #"
echo "# before you reply.                         #"
echo "#############################################"
echo ""
echo "Choose full (f) if you don't have and 'accounts' table or would"
echo "prefer to erase the existing accounts information."
echo "Choose skip (s) to skip loginserver DB installation and go to"
echo "gameserver DB installation/upgrade."
echo -ne "LOGINSERVER DB install type: (f) full, (s) skip or (q) quit? "
read LOGINPROMPT
case "$LOGINPROMPT" in
    "f"|"F") logininstall; loginupgrade; gsbackup; asktype;;
    "s"|"S") gsbackup; asktype;;
    "q"|"Q") finish;;
    *) asklogin;;
esac
}

logininstall(){
echo "Deleting loginserver tables for new content."
$MYL < login_install.sql &> /dev/null
#$MYSQLDUMPPATH --add-drop-table -h $LSDBHOST -u $LSUSER --password=$LSPASS $LSDB --no-data | grep ^DROP | $MYL
}

loginupgrade(){
echo "Installling new loginserver content."
$MYL < login_install.sql &> /dev/null
$MYL < ../sql/accounts.sql &> /dev/null
$MYL < ../sql/gameservers.sql &> /dev/null
}

gsbackup(){
while :
  do
   echo ""
   echo -ne "Do you want to make a backup copy of your GSDB? (y/n): "
   read LSB
   if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then
     echo "Making a backup of the original gameserver database."
     $MYSQLDUMPPATH --add-drop-table -h $GSDBHOST -u $GSUSER --password=$GSPASS $GSDB > gameserver_backup.sql
     if [ $? -ne 0 ];then
     echo ""
     echo "There was a problem accesing your GS database, either it wasnt created or authentication data is incorrect."
     exit 1
     fi
     break
   elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then
     break
   fi
  done
}

lsbackup(){
while :
  do
   echo ""
   echo -ne "Do you want to make a backup copy of your LSDB? (y/n): "
   read LSB
   if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then
     echo "Making a backup of the original loginserver database."
     $MYSQLDUMPPATH --add-drop-table -h $LSDBHOST -u $LSUSER --password=$LSPASS $LSDB > loginserver_backup.sql
     if [ $? -ne 0 ];then
        echo ""
        echo "There was a problem accesing your LS database, either it wasnt created or authentication data is incorrect."
        exit 1
     fi
     break
   elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then
     break
   fi
  done
}

asktype(){
echo ""
echo ""
echo "WARNING: A full install (f) will destroy all existing character data."
echo -ne "GAMESERVER DB install type: (f) full install, (u) upgrade, (s) skip or (q) quit? "
read INSTALLTYPE
case "$INSTALLTYPE" in
    "f"|"F") fullinstall; upgradeinstall I; custom;;
    "u"|"U") upgradeinstall U; custom;;
    "s"|"S") custom;;
    "q"|"Q") finish;;
    *) asktype;;
esac
}

fullinstall(){
echo "Deleting all gameserver tables for new content."
$MYG < full_install.sql &> /dev/null
}

upgradeinstall(){
if [ "$1" == "I" ]; then
echo "Installling new gameserver content."
else
echo "Upgrading gameserver content"
fi
echo "*** Sucesfull 1 percents. ***"
$MYG < ../sql/access_levels.sql &> /dev/null

echo "*** Sucesfull 2 percents. ***"
$MYG < ../sql/armor.sql &> /dev/null

echo "*** Sucesfull 3 percents. ***"
$MYG < ../sql/armorsets.sql &> /dev/null

echo "*** Sucesfull 4 percents. ***"
$MYG < ../sql/auction.sql &> /dev/null

echo "*** Sucesfull 5 percents. ***"
$MYG < ../sql/auction_bid.sql &> /dev/null

echo "*** Sucesfull 6 percents. ***"
$MYG < ../sql/auction_watch.sql &> /dev/null

echo "*** Sucesfull 7 percents. ***"
$MYG < ../sql/augmentations.sql &> /dev/null

echo "*** Sucesfull 8 percents. ***"
$MYG < ../sql/auto_announcements.sql &> /dev/null
$MYG < ../sql/auto_chat.sql &> /dev/null

echo "*** Sucesfull 9 percents. ***"
$MYG < ../sql/auto_chat_text.sql &> /dev/null

echo "*** Sucesfull 10 percents. ***"
$MYG < ../sql/boxaccess.sql &> /dev/null

echo "*** Sucesfull 11 percents. ***"
$MYG < ../sql/boxes.sql &> /dev/null
$MYG < ../sql/buff_templates.sql &> /dev/null

echo "*** Sucesfull 12 percents. ***"
$MYG < ../sql/castle.sql &> /dev/null

echo "*** Sucesfull 13 percents. ***"
$MYG < ../sql/castle_door.sql &> /dev/null

echo "*** Sucesfull 14 percents. ***"
$MYG < ../sql/castle_doorupgrade.sql &> /dev/null

echo "*** Sucesfull 15 percents. ***"
$MYG < ../sql/castle_siege_guards.sql &> /dev/null

echo "*** Sucesfull 16 percents. ***"
$MYG < ../sql/char_templates.sql &> /dev/null

echo "*** Sucesfull 17 percents. ***"
$MYG < ../sql/character_friends.sql &> /dev/null

echo "*** Sucesfull 18 percents. ***"
$MYG < ../sql/character_hennas.sql &> /dev/null

echo "*** Sucesfull 19 percents. ***"
$MYG < ../sql/character_macroses.sql &> /dev/null

echo "*** Sucesfull 20 percents. ***"
$MYG < ../sql/character_quests.sql &> /dev/null

echo "*** Sucesfull 21 percents. ***"
$MYG < ../sql/character_raid_points.sql &> /dev/null
$MYG < ../sql/character_recipebook.sql &> /dev/null

echo "*** Sucesfull 22 percents. ***"
$MYG < ../sql/character_recommends.sql &> /dev/null

echo "*** Sucesfull 23 percents. ***"
$MYG < ../sql/character_shortcuts.sql &> /dev/null

echo "*** Sucesfull 24 percents. ***"
$MYG < ../sql/character_skills.sql &> /dev/null

echo "*** Sucesfull 25 percents. ***"
$MYG < ../sql/character_skills_save.sql &> /dev/null

echo "*** Sucesfull 26 percents. ***"
$MYG < ../sql/character_subclasses.sql &> /dev/null

echo "*** Sucesfull 27 percents. ***"
$MYG < ../sql/characters.sql &> /dev/null

echo "*** Sucesfull 28 percents. ***"
$MYG < ../sql/clan_data.sql &> /dev/null

echo "*** Sucesfull 29 percents. ***"
$MYG < ../sql/clan_privs.sql &> /dev/null

echo "*** Sucesfull 30 percents. ***"
$MYG < ../sql/clan_skills.sql &> /dev/null

echo "*** Sucesfull 31 percents. ***"
$MYG < ../sql/clan_subpledges.sql &> /dev/null

echo "*** Sucesfull 32 percents. ***"
$MYG < ../sql/clan_wars.sql &> /dev/null
$MYG < ../sql/clan_notices.sql &> /dev/null

echo "*** Sucesfull 33 percents. ***"
$MYG < ../sql/clanhall.sql &> /dev/null

echo "*** Sucesfull 34 percents. ***"
$MYG < ../sql/clanhall_functions.sql &> /dev/null

echo "*** Sucesfull 35 percents. ***"
$MYG < ../sql/class_list.sql &> /dev/null

echo "*** Sucesfull 36 percents. ***"
$MYG < ../sql/cursed_weapons.sql &> /dev/null

echo "*** Sucesfull 37 percents. ***"
$MYG < ../sql/dimensional_rift.sql &> /dev/null

echo "*** Sucesfull 38 percents. ***"
$MYG < ../sql/droplist.sql &> /dev/null

echo "*** Sucesfull 39 percents. ***"
$MYG < ../sql/enchant_skill_trees.sql &> /dev/null
$MYG < ../sql/engrave.sql &> /dev/null

echo "*** Sucesfull 40 percents. ***"
$MYG < ../sql/etcitem.sql &> /dev/null

echo "*** Sucesfull 41 percents. ***"
$MYG < ../sql/fish.sql &> /dev/null

echo "*** Sucesfull 42 percents. ***"
$MYG < ../sql/fishing_skill_trees.sql &> /dev/null

echo "*** Sucesfull 43 percents. ***"
$MYG < ../sql/forums.sql &> /dev/null

echo "*** Sucesfull 44 percents. ***"
$MYG < ../sql/games.sql &> /dev/null

echo "*** Sucesfull 45 percents. ***"
$MYG < ../sql/global_tasks.sql &> /dev/null

echo "*** Sucesfull 46 percents. ***"
$MYG < ../sql/grandboss_data.sql &> /dev/null

echo "*** Sucesfull 47 percents. ***"
$MYG < ../sql/grandboss_list.sql &> /dev/null

echo "*** Sucesfull 48 percents. ***"
$MYG < ../sql/helper_buff_list.sql &> /dev/null

echo "*** Sucesfull 49 percents. ***"
$MYG < ../sql/henna_trees.sql &> /dev/null

echo "*** Sucesfull 50 percents. ***"
$MYG < ../sql/heroes.sql &> /dev/null

echo "*** Sucesfull 51 percents. ***"
$MYG < ../sql/items.sql &> /dev/null

echo "*** Sucesfull 52 percents. ***"
$MYG < ../sql/itemsonground.sql &> /dev/null

echo "*** Sucesfull 53 percents. ***"
$MYG < ../sql/locations.sql &> /dev/null

echo "*** Sucesfull 54 percents. ***"
$MYG < ../sql/lvlupgain.sql &> /dev/null

echo "*** Sucesfull 55 percents. ***"
$MYG < ../sql/merchant_areas_list.sql &> /dev/null

echo "*** Sucesfull 56 percents. ***"
$MYG < ../sql/merchant_buylists.sql &> /dev/null

echo "*** Sucesfull 57 percents. ***"
$MYG < ../sql/merchant_lease.sql &> /dev/null

echo "*** Sucesfull 58 percents. ***"
$MYG < ../sql/merchant_shopids.sql &> /dev/null

echo "*** Sucesfull 59 percents. ***"
$MYG < ../sql/merchants.sql &> /dev/null

echo "*** Sucesfull 60 percents. ***"
$MYG < ../sql/minions.sql &> /dev/null

echo "*** Sucesfull 61 percents. ***"
$MYG < ../sql/mods_wedding.sql &> /dev/null
$MYG < ../sql/mods_buffer.sql &> /dev/null
$MYG < ../sql/character_offline_trade.sql &> /dev/null

echo "*** Sucesfull 62 percents. ***"
$MYG < ../sql/npc.sql &> /dev/null

echo "*** Sucesfull 63 percents. ***"
$MYG < ../sql/npcskills.sql &> /dev/null

echo "*** Sucesfull 64 percents. ***"
$MYG < ../sql/olympiad_nobles.sql &> /dev/null

echo "*** Sucesfull 65 percents. ***"
$MYG < ../sql/pets.sql &> /dev/null

echo "*** Sucesfull 66 percents. ***"
$MYG < ../sql/pets_stats.sql &> /dev/null

echo "*** Sucesfull 67 percents. ***"
$MYG < ../sql/pledge_skill_trees.sql &> /dev/null

echo "*** Sucesfull 68 percents. ***"
$MYG < ../sql/posts.sql &> /dev/null

echo "*** Sucesfull 69 percents. ***"
$MYG < ../sql/raidboss_spawnlist.sql &> /dev/null

echo "*** Sucesfull 70 percents. ***"
$MYG < ../sql/random_spawn.sql &> /dev/null

echo "*** Sucesfull 71 percents. ***"
$MYG < ../sql/random_spawn_loc.sql &> /dev/null

echo "*** Sucesfull 72 percents. ***"
$MYG < ../sql/seven_signs.sql &> /dev/null

echo "*** Sucesfull 73 percents. ***"
$MYG < ../sql/seven_signs_festival.sql &> /dev/null

echo "*** Sucesfull 74 percents. ***"
$MYG < ../sql/seven_signs_status.sql &> /dev/null

echo "*** Sucesfull 75 percents. ***"
$MYG < ../sql/siege_clans.sql &> /dev/null

echo "*** Sucesfull 76 percents. ***"
$MYG < ../sql/skill_learn.sql &> /dev/null

echo "*** Sucesfull 77 percents. ***"
$MYG < ../sql/skill_spellbooks.sql &> /dev/null

echo "*** Sucesfull 78 percents. ***"
$MYG < ../sql/skill_trees.sql &> /dev/null

echo "*** Sucesfull 79 percents. ***"
$MYG < ../sql/spawnlist.sql &> /dev/null

echo "*** Sucesfull 80 percents. ***"
$MYG < ../sql/teleport.sql &> /dev/null

echo "*** Sucesfull 81 percents. ***"
$MYG < ../sql/topic.sql &> /dev/null

echo "*** Sucesfull 83 percents. ***"
$MYG < ../sql/weapon.sql &> /dev/null

echo "*** Sucesfull 84 percents. ***"
$MYG < ../sql/zone_vertices.sql &> /dev/null

echo "*** Sucesfull 85 percents. ***"
$MYG < ../sql/quest_global_data.sql &> /dev/null

echo "*** Sucesfull 87 percents. ***"
$MYG < ../sql/castle_manor_procure.sql &> /dev/null

echo "*** Sucesfull 88 percents. ***"
$MYG < ../sql/castle_manor_production.sql &> /dev/null

echo "*** Sucesfull 89 percents. ***"
$MYG < ../sql/custom_weapon.sql &> /dev/null
$MYG < ../sql/custom_npc.sql &> /dev/null
$MYG < ../sql/custom_teleport.sql &> /dev/null
$MYG < ../sql/custom_armor.sql &> /dev/null
$MYG < ../sql/custom_armorsets.sql &> /dev/null
$MYG < ../sql/custom_contestable_clanhalls.sql &> /dev/null
$MYG < ../sql/custom_merchant_shopids.sql &> /dev/null
$MYG < ../sql/custom_droplist.sql &> /dev/null
$MYG < ../sql/custom_merchant_buylists.sql &> /dev/null
$MYG < ../sql/custom_etcitem.sql &> /dev/null
$MYG < ../sql/custom_notspawned.sql &> /dev/null

echo "*** Sucesfull 90 percents. ***"
$MYG < ../sql/rebirth_manager.sql &> /dev/null

echo "*** Sucesfull 91 percents. ***"
$MYG < ../sql/remove_unneeded_spawns.sql &> /dev/null

echo "*** Sucesfull 92 percents. ***"
$MYG < ../sql/admin_command_access_rights.sql &> /dev/null

echo "*** Sucesfull 93 percents. ***"
$MYG < ../sql/pkkills.sql &> /dev/null

echo "*** Sucesfull 94 percents. ***"
$MYG < ../sql/characters_custom_data.sql &> /dev/null

echo "*** Sucesfull 95 percents. ***"
$MYG < ../sql/tvt.sql &> /dev/null
$MYG < ../sql/tvt_teams.sql &> /dev/null

echo "*** Sucesfull 97 percents. ***"
$MYG < ../sql/character_recipebook.sql &> /dev/null
$MYG < ../sql/fort_door.sql &> /dev/null
$MYG < ../sql/fort_doorupgrade.sql &> /dev/null
$MYG < ../sql/fort_siege_guards.sql &> /dev/null
$MYG < ../sql/fort.sql &> /dev/null
$MYG < ../sql/fortsiege_clans.sql &> /dev/null

echo "*** Sucesfull 99 percents. ***"
$MYG < ../sql/four_sepulchers_spawnlist.sql &> /dev/null
$MYG < ../sql/custom_spawnlist.sql &> /dev/null
$MYG < ../sql/vanhalter_spawnlist.sql &> /dev/null
$MYG < ../sql/clanhall_siege.sql &> /dev/null
$MYG < ../sql/paystream.sql &> /dev/null
$MYG < ../sql/l2votes.sql &> /dev/null
$MYG < ../sql/smsonline.sql &> /dev/null
$MYG < ../sql/npc_to_pc_polymorph.sql &> /dev/null
$MYG < ../sql/vip.sql &> /dev/null
$MYG < ../sql/ctf.sql &> /dev/null
$MYG < ../sql/ctf_teams.sql &> /dev/null
$MYG < ../sql/dm.sql &> /dev/null

echo "*** Sucesfull 100 percents. ***"
newbie_helper
}

custom(){
echo ""
echo ""
echo -ne "Install custom gameserver DB tables: (i) custom Items, (n) custom NPCs, (s) custom NPCs Spawns, (f) full customs, (q) Quit"
read ASKCS
case "$ASKCS" in
    "i"|"I") citemsinstall;;
    "n"|"N") cnpcsinstall;;
    "s"|"S") cspawnsinstall;;
    "f"|"F") cstinstall;;
    "q"|"Q") finish;;
    *) custom;;
esac
finish
}

citemsinstall(){
echo "Put in database custom Items..."
$MYG < ../sql/customs/added_custom_etcitem.sql &> /dev/null
$MYG < ../sql/customs/DynastyArmor_SQL_OK.sql &> /dev/null
$MYG < ../sql/customs/Epic_MaskAndShield_SQL_OK.sql &> /dev/null
$MYG < ../sql/customs/Gold_Bar_Item_OK.sql &> /dev/null
$MYG < ../sql/customs/Mordor_Weapons_SQL_OK.sql &> /dev/null
$MYG < ../sql/customs/Wings_SQL_OK.sql &> /dev/null
echo "custom Items loaded with no-error. Greet!!!"
custom
}

cnpcsinstall(){
echo "Put in database custom NPCs..."
$MYG < ../sql/customs/added_custom_merchant_buylist.sql &> /dev/null
$MYG < ../sql/customs/added_custom_npc.sql &> /dev/null
$MYG < ../sql/customs/added_custom_teleport.sql &> /dev/null
echo "custom NPCs loaded with no-error. Greet!!!"
custom
}

cspawnsinstall(){
echo "Put in database custom NPCs spawns..."
$MYG < ../sql/customs/added_custom_spawnlist.sql &> /dev/null
echo "custom NPCs spawns loaded with no-error. Greet!!!"
custom
}

cstinstall(){
while :
  do
   echo ""
   echo -ne "If you're not that skilled applying changes within 'custom' folder, i can try to do it for you (y). If you wish to do it on your own, choose (n). Should i parse updates files? (Y/n)"
   read NOB
   if [ "$NOB" == "Y" -o "$NOB" == "y" -o "$NOB" == "" ]; then
     echo ""
     echo "There we go, it may take some time..."
     echo "custom parser results. Last run: "`date` >database_installer.log
     for file in $(ls ../sql/customs/*sql);do
        echo $file|cut -d/ -f4 >> database_installer.log
        $MYG < $file 2>> database_installer.log
    if [ $? -eq 0 ];then
        echo "no errors">> database_installer.log
    fi
    done
     echo ""
     echo "Log available at $(pwd)/database_installer.log"
     echo ""
     break
   elif [ "$NOB" == "n" -o "$NOB" == "N" ]; then
     break
   fi
  done
  finish
}

finish(){
echo ""
echo "Script execution finished."
exit 0
}

newbie_helper(){
while :
  do
   echo ""
   echo -ne "If you're not that skilled applying changes within 'updates' folder, i can try to do it for you (y). If you wish to do it on your own, choose (n). Should i parse updates files? (Y/n)"
   read NOB
   if [ "$NOB" == "Y" -o "$NOB" == "y" -o "$NOB" == "" ]; then
     echo ""
     echo "There we go, it may take some time..."
     echo "updates parser results. Last run: "`date` >database_installer.log
     for file in $(ls ../sql/updates/*sql);do
        echo $file|cut -d/ -f4 >> database_installer.log
        $MYG < $file 2>> database_installer.log
    if [ $? -eq 0 ];then
        echo "no errors">> database_installer.log
    fi
    done
     echo ""
     echo "Log available at $(pwd)/database_installer.log"
     echo ""
     break
   elif [ "$NOB" == "n" -o "$NOB" == "N" ]; then
     break
   fi
  done
}

clear
load_config $1
MYL="$MYSQLPATH -h $LSDBHOST -u $LSUSER --password=$LSPASS -D $LSDB"
MYG="$MYSQLPATH -h $GSDBHOST -u $GSUSER --password=$GSPASS -D $GSDB"
lsbackup
asklogin