#!/bin/bash
user="user"
pass="pass"
wdb="waad99"
cdb="realmd99"
server="localhost"  
devpath="Tables" 


until [ $letter == x ]
do

clear
echo	       "####################################"
echo	       "#######       	     	       #######"
echo	       "######        W A A D         ######"
echo	       "#######     		       #######"
echo	       "####################################"
echo
echo		"Veuillez selectionner la lettre de l'option:"

echo		 "w = Installer WAAD Serveur"
echo		 "c = Prochainement installation base joueur"
echo
echo		 "b - Sauvegarde Characters/Acounts"
echo		 "r - Restore Characters/Accounts"
echo
echo		 "d - Voir la configuration de connection mysql"
echo		 "x - Sortir"

read -p "Enter option:  " letter

if [ ! $letter ]; then	
echo	
echo "Entrez option correcte... "	
read -p "Appuyez sur une touche pour reessayer..."
echo	
else
   if [ $letter == w ]; then
      echo "[Importing] Started..."
      for i in $( ls $devpath/*.sql -C -1 );
      do
         if [ $i != "/character_tables.sql" ]; then
           echo "[Importing]" $i
           mysql -h $server --user=$user --password=$pass $wdb < $i
        fi
      done
      echo "Importation Termine..."
   fi

   if [ $letter == c  ]; then
   	clear
   	echo		"! ! !   AVERTISSEMENT  ! ! !"
   	echo
        echo
   	echo		"Cela DELETERA tous les donnees Joueurs"
   	echo		"De la base de données!"
   	echo
   	echo		"Etes vous sur de vouloir:"
   	echo		"Installez base de donnees Joueur?"
   	echo
        echo		 "'oui' or 'non'"
   	read -p "Enter option: " resp
   	if [ $resp != "oui"  ]; then
		echo "Stop..."
		exit
   	else
		echo "[Importing] Start..."
		echo "[Importing] Importing Character/Account tables..."
		mysql -h $server --user=$user --password=$pass $cdb < $pubpath/character.sql
		echo "[Importing] Fini"
		echo					
	fi   		
   fi
   
   if [ $letter == b  ]; then
	echo "[Backing Up] Start..."
	echo "[Backing Up] Data Accounts et Characters..."
	mysqldump -h $server --user=$user --password=$pass $cdb accounts auctions characters charters corpses gm_tickets guilds guild_ranks instances ipbans mailbox playeritems playerpets playerpetspells playersummonspells questlog playercooldownitems playercooldownsecurity social tutorials > $pubpath/Backups/characters_backup.sql
	echo "[Backing Up] Fini"	
   fi

   if [ $letter == r  ]; then
   	clear
   	echo		"! ! !   AVERTISSEMENT     ! ! !"
	echo
   	echo
   	echo		"Cela DELETERA tous les donnees serveur"
   	echo		"De la base de données!"
   	echo
   	echo		"Etes vous sur de vouloir:"
   	echo		"Installez base de donnees serveur?"
   	echo
   	echo		"'oui' or 'non'"
   	read -p "Enter option: " resp
   	if [ $resp != "oui"  ]; then
   		echo "Stop.."
   	        exit
        else
   		echo "[Restoring] Start..."
   	        echo "[Restoring] Data Accounts et Characters..."
   	        mysql -h $server --user=$user --password=$pass $cdb < $pubpath/Backups/characters_backup.sql
   	        echo "[Restoring] Fini"
   	        echo
   	fi
   fi

   if [ $letter == d  ]; then 
   	clear 
   	echo 
   	echo	"User = $user"
   	echo	"Password = $pass" 
   	echo	"World DB = $wdb" 
   	echo	"Char DB = $cdb"
   	echo	"Server = $server" 
   	echo	"Development Directory Path = $devpath"
   	echo	"Releases Directory Path = $pubpath"
   fi

fi
if [ $letter != x ]; then
echo
read -p "Appuyez sur une touche pour continuer..."
echo
fi
echo "Merci d'utiliser la database W A A D!!"
done