#!/bin/bash

CURRENT_USER=${SUDO_USER:-$CURRENT_USER}
REALM_IP=$(hostname -I | awk '{print $1}')

# CONFIG
MANGOS_ETC="/home/"$CURRENT_USER"/vmangos/etc"
MANGOS_DATA="/home/"$CURRENT_USER"/vmangos/data"
MANGOS_LOGS="/home/"$CURRENT_USER"/vmangos/logs"

MYSQL_ROOT_PASS="greg"
MANGOS_DB_PASS="mangos"

REALM_NAME="wow-garage"

# DEPENDENCIES
echo "[INFO] Configuration & dependencies installation ..."

sudo systemctl stop apt-daily.timer
sudo systemctl disable apt-daily.timer

sudo apt update && sudo apt install p7zip-full git wget g++ cmake openssl libssl-dev build-essential checkinstall zlib1g-dev mariadb-server mariadb-client libmariadb-dev libmariadb-dev-compat libreadline-dev -y

sudo apt install -qq libace-dev -y
export ACE_ROOT=/usr/include/ace

sudo apt install -y libtbb-dev -y
export TBB_ROOT_DIR=/usr/include/tbb

# CLONING PROJECT
echo "[INFO] Cloning project ..."

sudo mkdir -p /home/$CURRENT_USER/vmangos
sudo chown -R $CURRENT_USER:$CURRENT_USER /home/$CURRENT_USER
cd /home/$CURRENT_USER/vmangos
git clone -b development https://github.com/vmangos/core && git clone https://github.com/brotalnia/database vmangos/db

mkdir -p /home/$CURRENT_USER/build
cd /home/$CURRENT_USER/build
sudo cmake /home/$CURRENT_USER/vmangos/core -DDEBUG=0 -DSUPPORTED_CLIENT_BUILD=5875 -DUSE_EXTRACTORS=0 -DCMAKE_INSTALL_PREFIX=$HOME/vmangos

# BUILDING PROJECT
echo "[INFO] building $CURRENT_USER ..."

sudo make -j $(nproc) install

# GETTING DATAS
echo "[INFO] Getting datas ..."

cd /home/$CURRENT_USER/vmangos
wget https://www.mediafire.com/file_premium/j6cyqjeif3dvrv2/data.7z
7z x data.7z
rm -r data.7z

# MISE EN PLACE DES FICHIERS
echo "[INFO] Mise en place des fichiers ..."

mkdir /home/$CURRENT_USER/vmangos/etc

sudo chown -R $CURRENT_USER:$CURRENT_USER /home/$CURRENT_USER/vmangos

sudo cp /root/vmangos/etc/realmd.conf.dist /home/$CURRENT_USER/vmangos/etc/mangosd.conf
sudo cp /root/vmangos/etc/mangosd.conf.dist /home/$CURRENT_USER/vmangos/etc/realmd.conf

sudo chown -R $CURRENT_USER:$CURRENT_USER /home/$CURRENT_USER/vmangos

mkdir -p /home/$CURRENT_USER/vmangos/logs/{mangosd,realmd,honor}

# CONFIG AGAIN
echo "[INFO] Configuration de mangosd.conf ..."

sed -i \
    -e "s|^DataDir.*|DataDir = \"$MANGOS_DATA\"|" \
    -e "s|^LogsDir.*|LogsDir = \"$MANGOS_LOGS/mangosd\"|" \
    -e "s|^HonorDir.*|HonorDir = \"$MANGOS_LOGS/honor\"|" \
    "$MANGOS_ETC/mangosd.conf"

echo "[INFO] Configuration de realmd.conf ..."
sed -i \
    -e "s|^LogsDir.*|LogsDir = \"$MANGOS_LOGS/realmd\"|" \
    "$MANGOS_ETC/realmd.conf"

# MYSQL SECURE INSTALLATION
echo "[INFO] Sécurisation de MySQL ..."

sudo mysql <<EOF
DELETE FROM mysql.user WHERE User='';
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost');
DROP DATABASE IF EXISTS test;
DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';
FLUSH PRIVILEGES;
EOF

sudo mysql --user=root --password="${MYSQL_ROOT_PASS}" <<EOF
DROP USER IF EXISTS 'mangos'@'localhost';

CREATE USER 'mangos'@'localhost' IDENTIFIED BY '${MANGOS_DB_PASS}'
WITH MAX_QUERIES_PER_HOUR 0
     MAX_CONNECTIONS_PER_HOUR 0
     MAX_UPDATES_PER_HOUR 0;

GRANT ALL PRIVILEGES ON *.* TO 'mangos'@'localhost' WITH GRANT OPTION;

CREATE DATABASE IF NOT EXISTS \`realmd\`
    DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE DATABASE IF NOT EXISTS \`mangos\`
    DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE DATABASE IF NOT EXISTS \`characters\`
    DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE DATABASE IF NOT EXISTS \`logs\`
    DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

GRANT ALL PRIVILEGES ON \`realmd\`.* TO 'mangos'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON \`mangos\`.* TO 'mangos'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON \`characters\`.* TO 'mangos'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON \`logs\`.* TO 'mangos'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;
EOF

# not sure of usefullness
sudo mysql -u root -p"${MYSQL_ROOT_PASS}" -e "SHOW GRANTS FOR 'mangos'@'localhost';"
# end of 'not sure of usefullness'

sudo mysql -u root -p"${MYSQL_ROOT_PASS}" <<EOF
DROP USER IF EXISTS 'mangos'@'localhost';
CREATE USER 'mangos'@'localhost' IDENTIFIED BY 'mangos';
GRANT ALL PRIVILEGES ON *.* TO 'mangos'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EOF

# FINAL CONFIGS
cd /home/$CURRENT_USER/vmangos/vmangos/db/

wget https://github.com/brotalnia/database/blob/master/world_full_14_june_2021.7z?raw=true

7z x world_full_14_june_2021.7z
sudo mysql -u mangos -pmangos --database=mangos < world_full_14_june_2021.sql
rm -r world_full_14_june_2021.sql

cd /home/$CURRENT_USER/vmangos/core/sql/

mysql -u mangos -pmangos --database=characters < characters.sql
mysql -u mangos -pmangos --database=logs < logs.sql
mysql -u mangos -pmangos --database=realmd < logon.sql

sudo mysql -u root -p"${MYSQL_ROOT_PASS}" <<EOF

USE mangos;

ALTER TABLE locales_item
MODIFY COLUMN name_loc1 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc2 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc3 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc4 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc5 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc6 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc7 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc8 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci';

ALTER TABLE locales_creature
MODIFY COLUMN name_loc1 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc2 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc3 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc4 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc5 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc6 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc7 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc8 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci';

ALTER TABLE locales_gameobject
MODIFY COLUMN name_loc1 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc2 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc3 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc4 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc5 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc6 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc7 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci',
MODIFY COLUMN name_loc8 VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8_general_ci';

USE realmd;

DELETE FROM realmlist WHERE id=1;
INSERT INTO realmlist (id, name, address, localAddress, localSubnetMask, icon, timezone, realmbuilds)
VALUES (1, $REALM_NAME, $REALM_IP, '127.0.0.1', '255.255.255.0', 1, 2, '5875 6005 6141');

EOF

# MIGRATIONS
cd /home/$CURRENT_USER/vmangos/core/sql/migrations

./merge.sh

mysql -u mangos -pmangos --database=mangos < world_db_updates.sql
mysql -u mangos -pmangos --database=logs < logs_db_updates.sql
mysql -u mangos -pmangos --database=characters < characters_db_updates.sql
mysql -u mangos -pmangos --database=realmd < logon_db_updates.sql