#!/bin/bash

MyUSER="root"     # USERNAME
MyPASS="G48sOf8HgGn7s3"   # PASSWORD
MyHOST="localhost"        # Hostname

MYSQL="mysql"
MYSQLDUMP="mysqldump"
CHOWN="chown"
CHMOD="chmod"
GZIP="gzip"
SECONDI=2

DEST="/backup"
MBD="$DEST/mysql"
HOST="$(hostname)"
NOW="$(date +"%Y-%m-%d")"
FILE=""
DBS=""
Bungee="bungee"
Servers=("minigames" "creativa" "enchantwars" "fazioni" "vanilla" "skyblock" "survival" "vanillapuro")
IGGY="test"
[ ! -d $MBD ] && mkdir -p $MBD || :
$CHOWN 0.0 -R $DEST
$CHMOD 0600 $DEST
for serv in "${Servers[@]}"
do
 su -l mc -c "/usr/games/minecraft/mineos_console.js -s $serv stop"
 sleep $SECONDI
done
su -l mc -c "/usr/games/minecraft/mineos_console.js -s $Bungee kill"
# Get all database lisot first
DBS="$($MYSQL -u $MyUSER -h $MyHOST --password=$MyPASS -Bse 'show databases')"
for db in $DBS
do
    skipdb=-1
    if [ "$IGGY" != "" ];
    then
    for i in $IGGY
    do
        [ "$db" == "$i" ] && skipdb=1 || :
    done
    fi
    if [ "$skipdb" == "-1" ] ; then
    FILE="$MBD/$db.$NOW.gz"
        $MYSQLDUMP -u $MyUSER -h $MyHOST --password=$MyPASS $db | $GZIP -9 > $FILE
    fi
done
su -l mc -c "/usr/games/minecraft/mineos_console.js -s $Bungee start"
sleep $SECONDI
for serv in "${Servers[@]}"
do
 su -l mc -c "/usr/games/minecraft/mineos_console.js -s $serv start"
 sleep $SECONDI
done